Principal Consultant
PwC (PricewaterhouseCoopers)
Total years of experience :9 years, 5 Months
• SBI Life - DW Architecture Review
o
Technology/Tool assessment of software used by the organization for information processing and delivery.
o
Benchmarking the processes against the industry standards.
o
Suggesting framework for helping SBI Life to be future ready. o Preparing and proposing the road map for future transition to better address the business and information demands and requirements.
• Axis Bank - Enterprise Data Warehouse Implementation o Architect for end to end implementation and delivery of Data Warehouse from strategy to support phase of the project. o Data quality and data profiling environment setup. o Risk data mart design and implementation covering data lineage, data modelling and ETL design. o Customer 360 solution design and implementation. o Setting up Informatica Power center and Power Exchange CDC environment. Provide maintenance till handover.
• Business Development o Preparing proposals involving solution design, cost and estimation, presentation to clients and implementation.
• Zurich NA - Data Mart Design and Development o Design of Data Marts for various business functions. o ETL design including Source to Target Mapping and low-level design documents. o Implementing Error Handling and Audit Balancing for data loading. o Developing Informatica mappings as per specifications o Build complex transformation logic as per requirements.
• British Petroleum - Decision Support System and Data Warehouses o Developing Informatica mappings as per specifications o Providing support maintenance to existing applications o Onsite Coordinator for the Data Warehousing applications.
• Genentech - Data Mart Design and Development o Testing the business logic implementation from the Source to Target mappings. o Testing the requirements based on the Functional and Business specifications. o Data testing of the application database to check the integrity and correctness of data based on the business design.