Sandeep Manjunatha

• Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
• Designed compliance frameworks for multi-site data warehousing efforts to verify conformity with state and federal data security guidelines.
• Generated detailed studies on potential third-party data handling solutions, verifying compliance with internal needs and stakeholder requirements.
• Built databases and table structures for web applications.

Bangalore, India * November 2020 - December 2022

• Lead a team of 20 data engineers, data analysts and Developers, Work with Stakeholders and Business Analysts to Finalize the requirement, Data Channels and technology.
• Work closely with the Enterprise Architect team on all the infrastructure decisions, App services, Resource groups and Security.
• Analyze the data on different platforms and come up with Data elements to fit the model on Azure.
• Replaced BizTalk application using Azure Data Factory by triggering Stored Procedures and Generating Ad-hoc based Reports when users place a file of their own requirement.
• Ingested Data from multiple applications and different source systems using Azure data factory into Datalake (Both batch and Realtime).
• Prepared the data into Facts and Dimensions built on Databricks delta lake and pushed into Synapse.
• Built ADB notebooks using Pyspark to push the data into CosmosDB for different domains like Policy, Insured, Claims. Reinsurance, Accounts etc.
• APIs are built on top of CosmosDB to Expose domain Data, managed using APIGEE and authenticated using OKTA.

Data Migration - Migrating data from multiple legacy systems into Azure

• Azure ADF is used to extract data from Different sources into ADLS
• CDC is performed in DataBricks to capture the Delta records and apply all the business logic and transformations.
• Data is then consumed by an analysis service for data modeling.
• Pushed the data into Synapse using Databrick Notebooks.
• Power BI is used to generate reports and dashboards

CLM-ODS: nCino is an application built on SALESFORCE CRM which replaced CLAS (Loan booking application) at MnT Bank.

• Data is extracted from flat files, Cobol files and SQL Server into Oracle using Informatica.
• All the active Loans are processed into Staging by applying the active filters and capturing delta records.
• Data from Staging is then loaded into the INBOUND layer by applying the business logic to transform the data that is required by nCino and pushed to nCino on a daily basis.
• Data is pulled back to OUTBOUND layer to have near real SYNC between nCino and Downstream

FADS (Financial Analytical Data Store)- is the data warehouse used across T-Mobile, Business rules are applied to the data which is then checked for validity and cleansed before the reports are created

• Developed Mappings, workflows and Sessions to load data from TS Stage1 (Transient Stage) to Stage2 (Semi-persistent Stage) and from Stage2 to target tables (Core Table).
• Implemented SCD Type 1 Insert only, SCD Type 1 Insert else Update, SCD Type2 mappings with date logic based on client requirement
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables and disable/Enable indexes at run time.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Running the Jobs through the control-M Scheduler and Unix Shell scripting to handle File operations.