DWH/ETL/BI Tech Lead

2/2019 – offen

- Responsible for working closely with various stakeholders groups to build business requirements and functional design documents.
- Supporting and writing the SIT and UAT (along with QA) test scripts and coordinating the end-to-end system testing, mapping the business processes, designing the databases, building training and knowledge management documentation.
- Conducted business requirements elicitation, created detailed functional requirements, worked on the RFP questions and selection.
- Managed the daily scrum meetings, defined the user scripts, and managed the product backlog using the agile methodology.
- Worked with the in-house ETL tool to implement and test all the Business requirements.
- Facilitated the communication between various functional teams and the vendor to determine the application problems, remediation approaches, and the implementation path.

Microsoft SQL-Server (MS SQL), Oracle Database, UC4

1/2013 – 1/2017

Project Lead, Deutsche Bank, Frankfurt, Germany:

- Presently working as an BI and ETL Project/Tech Lead with around 10+ years of total work experience and over 8+ years in BI and ETL (Integration/Data transformation) and Oracle technologies.
- Main area of experience has been Requirement Gathering, Analysis, Design, Development, Debugging, Deployments and Testing Support for Datawarehouse, Integration and Migration projects.

, Business Intelligence (BI), Datawarehouse / DWH, Informatica, Migration

2/2008 – 10/2010

RMPS MIS System - Module lead:

-Participated in development of new POCs for different clients with their subset of live data.
- Responsible for all activities related to the development, implementation, administration and support of different ETL processes for large scale data warehouses using Informatica Power Center.
- Had experience to automise the LDAP directory to add/delete/update users with high frequency (specially to access some reports/portals)
- involved in data modeling using Sybase Power Designer, Star Schema modeling and snowflake modeling, Fact and Dimensions tables, physical and logical modeling.
- Involved in UNIX Shell scripting

Business Intelligence (BI), Datawarehouse / DWH, Informatica, Oracle Business Intelligence Enterprise Edition Plus (OBIEE+)