Samreen Taj

Samreen Taj

Power BI Analyst
India

نبذة عني

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…

الخبرة

IT Analyst

Tcsl
Aug 2023 - حتى الآن · 2 سنوات 10 أشهر

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 - حتى الآن · 5 سنوات 4 أشهر

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 - حتى الآن · 5 سنوات 4 أشهر

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 سنوات 5 أشهر

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 أشهر

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 سنوات 5 أشهر

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 أشهر

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.

المهارات

تحليل الأعمال تطوير DataStage ETL أوراكل ساب يونكس (نظام تشغيل) أجايل جيت (GIT) أنظمة SAP ERP محاولة الجمع ساب مالية والتحكم ساب سكسس فاكتورز ساب إدارة سلسلة التوريد دورة حياة التطوير البرمجي خبرة تقنية المعلومات إدارة المواد في SAP 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
الإبلاغ عن هذا الملف الشخصي؟