Pratik Sahoo

• Design, Build and Review Integration patterns and solutions for KPMG internal business applications on Azure Enterprise Data platform.
• Design automations build and release pipelines for CICD using Azure Devops and GIT for Data services like ADF, Databricks, Synapse on Azure platform.
• Make sure Data in EDP is compliant and secure by implementing Azure key vault, re-design IAM and access groups, create compliance policies, Job alerts and notifications for easy tracking and Ops Support.
• Design and Build solutions around Enterprise data strategy for Data Quality, Data Catalog and Data Governance across KPMG Internal Business areas.
• Skills: Microsoft Azure- Data Factory, Databricks, IAM, Security, Devops, ADLS, SQL Server, Key Vault, Synapse, Purview, Informatica- Data Quality, Data Catalog, Axon

• Led backend Database module of Digital supply chain for Dell corporation and helped client migrate away from manual Excel to automated Engineering and reporting technology.
• Leading the Architecture revamp from existing SSAS Data model to Spark & MemSQL DB
• Create Spark jobs to read data from Dell Data Lake (GreenPlum), perform transformation & aggregation and load data into MemSQL DB
• Skills: Microsoft SQL Server, SSAS, Spark, Power BI, MemSQL

• Design and Implement an end to end Customer Master Solution to meet the business objectives of commonly consumed data across the enterprise and maintain the MDM hub/repository to process data from multiple Health care providers
• Initial Infrastructure setup and configuring of MDS and DQS on client VM
• Involved in finalizing the Design of MDM Hub.
• Skills: Microsoft SQL Server, SSIS, MDS, DQS

• Analyzing existing DTS transformation (currently written in SPs) and implementing using SSIS 2012 Transformations.
• Creating Models, Entity, Hierarchy and Attributes related to Master data for MDM.
• Designing SSIS packages related to MDM (Loading data into MDM tables) and Creating Subscription Views to consume data from MDM.
• Creating Matching Policies for Data De-duplication.