Key Implementations on Cloud technologies (as Solution Architect) Modernization of Data estate (Azure Synapse + Polybase) Technically coach the team members and provide real time solutions to complex problems Implemented Data ingestion, preparation, integration and operationalization techniques, optimally addressing the data requirements Design Golden Layer data model Design Data virtualization using Polybase for Power BI reporting Integrate real time data with Stream Analytics using Event Hub.Datalake and Modern Datawarehouse (Informatica IICS + Snowflake) Partner with business and enterprise architecture team to understand requirements and design/develop end to end solution Migrate existing on-premise Data Platform to the cloud, Snowflake with Data Residency on Azure Handling team of size 15 Store structured and semi-structured dataDatalake Migration from on-prem to Cloud (Azure Data Factory) Partner closely with global teams to implement the design Perform Gap Analysis – identifying the Data objects to be added in Cloud leasing application Design of Data Migration process of Master Data, Reference data and Transactional data Key Implementations on Classical DW Technologies Design and Develop Master Data Management MDM & RDM (Informatica MDM + Informatica RDM + Informatica Powercenter) Worked as MDM & RDM Architect – designing the data model for Party data domain , associating Account and Reference data Management. Experience in creating Data Model, Data validation, Match and Merge rules, Survivorship criteria Perform Data Analysis in setting up Match & Merge rules, Cleansing functions capturing the ‘dataEnterprise Data Warehouse implementation Datalake and Modern Datawarehouse (Informatica PC + Oracle + Powerexchange) As Delivery Manager, involved in end-to-end implementation of data warehouse Handling team of size 18 Architecting the DW data model using IIW ACCORD model

Major Accomplishments as Delivery Executive:• As Service Delivery Manager managed multiple projects.• Responsible for Program and Project Planning, Pre Sales Activities, Estimation, Resource Management, Client Interaction, Requirement Gathering, Relationship Building , Invoicing etc• Involved in Business Development Activities and growth of DW/BI Practice• Direct Client interaction with regard to functional / technical specifications, Project plan and project status with an objective of timely delivery and mitigating any forthcoming risks• Project Performance Management and Reporting, Risk Assessment and Risk PlanKey Projects1. Master Data Management for Party & Security reference data – As part of Enterprise Data Management program, EDM program was initiated to improve the timeliness, quality, accessibility, and security of data across the organisation. Cornerstone of EDM program was introduction of Securities Master & Reference Data Management & establish Master Data Hub and hierarchies. Master data domains considered are Security Master, Corporate Actions, Party – Advisor & Client with Legal Entity Identifier and Account. Data will be de-duplicated and mastered (golden copy) and stored in Master Data Management Hub. Tools: Informatica MDM2. Data masking & DVO – The project constitutes design & development of Data Masking solution for multiple Applications using Informatica as ETL tool & Masking tool , with an objective to Eliminate the risk of sensitive production data available to non-production environment across all applications within the Organization and Implement data masking tool to mask the sensitive data , maintaining the data integrity Tools: Informatica TDM & Powercenter

Key Responsibilities• Responsible for 30 % growth of DW/BI practice • Increased Team Strength by 40% in 4 months• Setup innovation centre, CoE and multi-domain teams for DW/BI• Responsible to grow the practice with responsibilities of Revenue, profitable growth, new customers and new initiatives • Planning Certification and cross training of associates• Building a strong team of experienced data warehouse professionals. • Delivery Lead responsible for successful project implementations utilizing a global delivery model • Working at various levels in organization level committees like redefining vision, mission and goals; retention• Responsible for developing capabilities on the Data warehousing and Business Intelligence practice areasKey Projects• Implement EDW solution for Non-life insurance organization.

Major Accomplishments:• Owned and delivered a successful DW solution to a leading bank in Switzerland for their Enterprise Data Warehouse initiative• Owned and Delivered Business Intelligence Road MapKey Projects1. EDW Implementation – Responsible for the delivery of Payroll and HR enterprise data warehouse with major responsibilities as• Planning the implementation of major Data Warehouse• Scope Breakdown by breaking down the deliverables into work packages• Task and Duration Estimating: create tasks and their sequence• Risk Assessment and Risk Plan• Technical presentation to client proposing different technical architecture to cater specific Business Requirements• Handling of various personal issues of team members and hence allocating work in order to keep the schedule in line. 2. BI Roadmap – Responsible for providing Business Intelligence Road map with major activities as as• Requirement Gathering by interacting with the GM’s and Users (as part of Top down Approach).• Understanding the existing reports and reporting environment(Bottom Up approach)• Document the Requirements focusing business areas as BRD.• Proposing BI Roadmap meeting requirements.

Key Responsibilities:• Responding to RFI’s/RFP’s for prospective clients • Preparing presentations for prospective business in BI/DW• Building a strong team of experienced data warehouse professionals. • Delivery Lead responsible for successful project implementations utilizing a global delivery model • Responsible for developing capabilities on the Data warehousing and Business Intelligence practice areasKey Projects1. Data Migration – Managed team of 16 people with Responsible for the delivery, Work Allocation and monitoring of the project involved in following activities• Creating Transformation rules for ETL from DWH to Data Mart.• Developing mapping specifications.• Involved in the project implementation comprising Initial Load and Daily Load.2. DW Implementation – Managed team of 6 people with Responsible for the delivery, Work Allocation and monitoring of the project involved in following activities• Creating a Road map for the implementation of EDW.• Requirement Gathering by interacting with the VP’s, GM’s and the Knowledge workers • Project Implementation ,User Training