G Madhan Mohan

Project Name: TCS – Monogram Health Care.

Role: Senior Data Engineer.

Project Description:

The Monogram Health Data Ecosystem Modernization Project - MVP1 Platform is intended to modernize the existing Monogram Health platform by re-architecting it to provide end-to-end integration from data ingestion to data transformation, to data analytics, and full re-platforming.

Roles and responsibilities:

• Collaborate with cross-functional teams to gather, analyze, and document business requirements for data integration projects.
• Strong proficiency in Microsoft Azure cloud platform services (Azure Data Factory, Azure Data Bricks, Azure SQL Database, Azure Data Lake Storage, and Azure Synapse Analytics).
• Expertise in T-SQL, Dynamic SQL, Spark SQL, and the ability to write complex stored procedures.
• Write complex stored procedures to support data transformation, and implement business validation logic.
• Experience in writing notebooks in Azure Synapse/Databricks using Spark SQL or PySpark to process and analyze large volumes of data.
• Develop and maintain robust data pipelines using Azure Data Factory, ensuring seamless data flow between systems.
• Design and implement migration strategies with the Azure suite: Azure SQL Database, Azure Data Factory (ADF) V2, Azure Key Vault, Azure Blob Storage, and Delta Lake tables.
• Created end-to-end data pipelines using ADF services to load data from on-prem to Azure SQL Server for data orchestration.
• Implementation of Azure Cloud Components: Azure Data Factory, Azure Blob Storage, Azure SQL DB.
• Implemented the email feature using Azure Logic Apps to get pipeline notifications.
• Design and develop complex, large-scale data structures and pipelines to organize, collect, standardize, and visualize data to generate insights and address monitoring and support needs.
• Ensuring data pipelines are observable, scalable, reliable, and secure, while improving data quality and integrity.
• Providing technical design and coding assistance to the team to accomplish the project deliverables as planned.
• Proven experience working with public healthcare datasets, and leveraging them to inform business strategy.
• Perform query performance optimization, including indexing strategies, and tuning for large datasets.
• Collaborated with other teams to understand their requirements and deliver solutions accordingly.

Project Name: DATA-FMB-AMS Support.

Role: Data Engineer Developer.

Project Description:

• Vitara is headquartered in the United States, with three global centers in Pittsburgh, Pennsylvania; Shanghai, China; and Hyderabad, India. They operate approximately 40 manufacturing facilities, which produce complex dosage forms, injectables, oral solid doses, and active pharmaceutical ingredients. And they maintain industry-leading pipelines.

Roles and responsibilities:

• Develop, document, and revise system design procedures, test procedures, and quality standards.
• Support Incident, Change, and Problem Management processes within the team.
• Troubleshoot performance issues and outages diligently, and handle escalations.
• Supporting the P2 tickets and working with other teams to close the incidents on time.
• Take charge of troubleshooting calls, and manage expectations and application recovery.
• Supporting business-critical integrations and high-frequency jobs. Resolving ongoing issues and bug fixes.
• Viatris is headquartered in the United States, with three global centers in Pittsburgh, Pennsylvania; Shanghai, China; and Hyderabad, India. They operate approximately 40 manufacturing facilities, which produce complex dosage forms, injectables, oral solid doses, and active pharmaceutical ingredients. And they maintain industry-leading pipelines.