Samreen Taj

Samreen Taj

Power BI Analyst
India

About Me

Experienced developer with background of 8+ years in business intelligence and data analysis across various industries. Excel at creating tools/solutions and leading efforts to improve data analysis and organizational ca…

Experience

IT Analyst

Tcsl
Aug 2023 - Present · 2 years 10 months

Role-Datastage developer
Responsibility-
Designing jobs based on the requirements.
Preparing high level documentation.
Monitoring jobs untill moves to production.
Supporting production tickets.
Designing jobs using transformations and different stages
Mapping based on business rule
Applying logics on to satisfy the conditions.

TECHNOLOGY ANALYST

CATERPILLAR INC
Mar 2021 - Present · 5 years 4 months

Hands-on experience in data analytics tools like Excel, DAX, SQL Server, etc.
Involved in creating new stored procedures and optimizing existing queries and stored procedures.
Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
Explore data in a variety of ways and across multiple visualizations using Power BI.
Have sound knowledge of database management systems, data modeling, data warehousing, data visualization, business intelligence, OLAP (Online Analytical Processing), etc.
Knowledge of various software development life cycle models and documentation.
Used Power BI Gateways to keep the dashboards and reports up to date.

TECHNOLOGY ANALYST

CATERPILLAR INC, US
Mar 2021 - Present · 5 years 4 months

Hands-on experience in data analytics tools like Excel, DAX, SQL Server, etc.
Involved in creating new stored procedures and optimizing existing queries and stored procedures.
Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
Explore data in a Variety of ways and across multiple visualizations using Power B
Have sound knowledge of database management systems, data modeling, data warehousing, data visualization, business intelligence, OLAP(Online Analytical Processing), etc
Knowledge of various software development life cycle models and documentation.
Used Power BI Gateways to keep the dashboards and reports up to date.

DATA STAGE DEVELOPER

Lloyd’s banking group
Jan 2015 - Jun 2017 · 2 years 5 months

Extensively used DataStage Client components: DataStage Designer, DataStage Manager and DataStage Director.
Got the source data in the form of Oracle tables, Sequential files and Excel sheets.
Developed processes to extract the source data and load it into the data warehouse after cleansing, transforms and integrating.
Imported metadata from repository, created new job categories, routines and data elements.
Transformations were used in DataStage to load data to Oracle and updated using PL/SQL.
Created Job Sequencer to execute a set of jobs.

Power BI DEVELOPER

Lloyd’s banking group
Mar 2014 - Dec 2014 · 9 months

Used the DataStage Designer to debug processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database and also the process of loading data into Data-mart.
As a data analyst responsible for solving high priority incidents and identifying the errors and resolving the errors and making job to run again.
Used the IBM WebSphere DataStage designer to develop jobs for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
Got the source data in the form of Oracle tables, Sequential files, mainframe files.
Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
Used the Tidal job Scheduler to schedule the DataStage jobs to run the daily jobs and weekly jobs.
Validated the current production data, existing data and the programming logic involved.

DATA STAGE DEVELOPER

Lloyd’s banking group, UK
Jan 2015 - Jun 2017 · 2 years 5 months

Extensively used DataStage Client components: DataStage Designer, DataStage Manager and DataStage Director.
Got the source data in the form of Oracle tables, Sequential files and Excel sheets.
Developed processes to extract the source data and load it into the data warehouse after cleansing, transforms and integrating.
Imported metadata from repository, created new job categories, routines and data elements
Transformations were used in DataStage to load data to Oracle and updated using PL/SQL.
Created Job Sequencer to execute a set of jobs.

Power BI DEVELOPER

Lloyd’s banking group, UK
Mar 2014 - Dec 2014 · 9 months

Used the DataStage Designer to debug processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database and also the process of loading data into Data-mart.
As a data analyst responsible for solving high priority incidents and identifying the errors and resolving the errors and making job to run again.
Used the IBM WebSphere DataStage designer to develop jobs for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
Got the source data in the form of Oracle tables, Sequential files, mainframe files.
Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
Used the Tidal job Scheduler to schedule the DataStage jobs to run the daily jobs and weekly jobs.
Validated the current production data, existing data and the programming logic involved.

Skills

Business Analysis DataStage ETL Development Oracle SAP UNIX Agile GIT Version Control (GIT) SAP ERP Systems Collection Attempt SAP Finance & Controlling SAP SuccessFactors SAP Supply Chain Management SDLC IT Experience SAP Materials Management Microsoft Power BI Excel DAX SQL Server Power BI Power Pivot Power View Power Map database management systems data modeling data warehousing data visualization business intelligence OLAP(Online Analytical Processing) software development life cycle models documentation Power BI Gateways DataStage Client components DataStage Designer DataStage Manager DataStage Director Oracle tables Sequential files Excel sheets data warehouse cleansing transforms integrating metadata job categories routines data elements transformations PL/SQL Job Sequencer IBM WebSphere DataStage designer mainframe files Exception Handling Tidal job Scheduler DataStage jobs Stored Procedures Database Management Systems Data Modeling Data Warehousing Data Visualization Business Intelligence OLAP Software Development Life Cycle Sequential Files IBM WebSphere DataStage Tidal Job Scheduler
Report this Profile?