Dataware house developer , data analyst

12/2013 – offen

▪ Requirement gathering and providing estimation to project manager.
▪ Solution design for ETL and Reporting, Cross training to team members and work allocation.
▪ Creation of worksheets, Dashboards and publishing the workbooks to server.
▪ Tableau dashboard backtracking, data analysis, issue fixing and communicating to end users.
▪ Working as Operational deputy manager for BMW applications.
▪ Working closely with clients to gain the business knowledge and to know about business process and requirements.
▪ Conducting standup meetings and team meetings and quarterly team reviews.
▪ Worked on Informatica migration projects and Oracle migration projects. Tested the informatica applications after migration from end to end.
▪ Informatica object analysis for issues and providing solution for issues.
▪ Create and maintain adequate documentation of project ETL design, technical artifacts and ETL
environment and prepared ER Diagrams.
▪ Created mappings and mapplets using different transformations, Workflows using different tasks.
▪ Created plsql procedures and complex queries and worked on Reports backtracking and analysis.
▪ Creating issues in Jira and updating the documentation in confluence.
▪ Creating and executing the testcases in HP-ALM and XRay Preparing the test result documentation.
▪ Modifying the Unix scripts and scheduling the workflows.

Datawarehouse / DWH