Overview

• Deliver and manage concurrent projects in cross-functional organizational structure for Pfizer.
• Gathered Business Requirements, interacted with the users, designers and developers, project manager and QA team to get a better understanding of the Business Processes
• Conducted JAD session with ETL developers and database architects.
• Responsible for Data Architecture, Database Design, Data Quality, Data Cleansing.
• Created Adhoc reports to users in Tableau by connecting various data sources.
• Analyzing and understanding root causes of change in metrics and defining KPI’s.
• Pulling data using SQL from various servers including DB2 and SQL Server.
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
• Worked on Data Modeling, involved in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.
• Developed Logical and Physical Data Model using Erwin, followed Star Schema to build the Data warehouse.
• Prepared mock up reports.
• Extracted data from various source systems like Teradata, mainframes and flat files as per the requirement delivered the artifacts within the time lines and excelled in the quality of deliverables.
• Responsible of designing the whole DWH system including ODS, DWH and data marts.
• Used Informatica tool for Data profiling.
• Developed data mapping documents between Legacy, Production, and User Interface Systems.
• Documented data content, data relationships and structure, and processes the data using Informatica Power Center.
• Designed testing Scenarios, Cases & Conditions involving User Acceptance testing, Regression, Integration and System testing
• Performed Gap Analysis.