Divya Koshatwar
Pune,India
Summary
Results-driven Senior Data Engineer with 7+ years of experience in US Pharma commercial data solutions. Strong expertise in Data Warehousing, MDM, and large-scale ETL/ELT pipelines across SQL Server, Snowflake, and Databricks. Experienced in Reltio–MuleSoft integrations, cloud migrations. Adept at building scalable, ACID-compliant architecture and leading cross-functional engineering teams.
Overview
2027
2027
years of professional experience
1
1
Certification
Work history
Senior Data Engineer
Circulants Solutions
Pune, Maharashtra
11 2023 - 2026.05
- Built cloud-native MDM platform using Reltio, MuleSoft, and Snowflake, including API-driven ingestion, match-merge processing, and delta-based reporting on cleansed, deduplicated data.
- Established data quality frameworks, enhancing consistency and reliability of master data. Contributed to implementing the CI/CD pipeline.
- Migrated 25+ procedures to Databricks, building scalable Py-Spark/Delta Lake ETL pipelines with ACID compliance and reusable architecture.
- Implemented robust logging and mentored team, improving observability and reducing failures by ~60%.
- Developed Target Segmentation models identifying high-value customers by integrating IQVIA, Komodo Claims, and Clarivate datasets, improving data completeness and insight accuracy.
- Architected master patient data integration framework consolidating multi-source GCT (Gene Cell Therapy) datasets into single source of truth—from diagnosis through therapy administration—including patient food and lodging eligibility data.
- Designed ETL workflows to onboard multi-country datasets into standardized reporting layer, enabling impact analysis on downstream objects and promoting reusable data models.
- Led end-to-end REMS system migration across Azure network environments, coordinating IT, compliance, and business teams to achieve zero-downtime cutover.
- Ensured full regulatory compliance throughout transition, including risk assessments and IQ/OQ validation testing for audit readiness.
- Provided technical leadership and mentored junior engineers, establishing migration best practices adopted across subsequent system transitions.
Application Software Developer
Circulants Solutions
New Jersey, USA
11 2021 - 10 2023
- AWS Instance Migration from Client Account to Circulant’s Company Account
- Migrated commercial data warehouse to new AWS account in under one month, consolidating servers and achieving significant infrastructure cost savings.
- Optimized migration to generate revenue of $8K per month for organization.
- Sunshine Act Compliance Reporting (Porzio → CMS)
- Migrated General Spend reporting from Porzio to CMS format, eliminating licensing costs and saving ~$100K.
- Developed SQL procedures, tables, and views for CMS-compliant spend reporting, resolving Concur data discrepancies through thorough analysis.
- Commercial Data Processing (Veeva, ValueCentric, DHC, SHA, Medpro, Concur)
- Achieved 98% on-time execution of daily commercial data processes by implementing robust Data Quality Management (DQM) framework.
- Managed day-to-day operations, resolving real-time pipeline issues and maintaining clear documentation for audit and knowledge transfer.
- Delivered ad hoc reports, quarterly Incentive Compensation files, Board presentations, and geo-spatial territory maps.
- Analyzed billing anomalies and optimized processes, reducing AWS costs by ~$1K/month.
- Transitioned from Value Centric to direct EDI ingestion and built DEA-validated ETL pipelines to ensure compliant, high-quality customer data.
- Executed SQL code migration from Snowflake, ensuring compatibility and performance.
- Executed root cause analysis and established quality check processes.
Senior Software Engineer
Circulants Solutions
Jaipur, Rajasthan
2018.12 - 2021.10
- Executed MDM platform implementation for vendors Veeva and Medpro, enhancing data integration capabilities.
- Developed 20+ SSIS packages for multi-vendor MDM ingestion, ensuring validation of key modules like Golden Record and match-merge processes.
- Validated Power BI reports and supported data profiling for match/merge rules, data quality, and hierarchy design.
- Developed a comprehensive framework to identify data anomalies and unexpected variance in the data warehouse; defined 100+ data quality checks used in daily operations and project development.
- Built supporting tables, procedures, views, Power BI reports, and automated email alerts for proactive issue tracking and resolution.
- Independently designed and delivered all SSIS packages, tables, procedures, and views for 10 DHC file layouts within one month, enabling hospital-physician affiliation data in the commercial system.
- Commercial Daily Data Processing & Productivity Reporting
- Led team in daily process execution, resolving errors and deploying 15+ database objects to support enhancement releases.
- Built a Productivity Summary Report combining Calls, Sales, and key metrics across multiple rep roster alignments in both Excel and Power BI.
QA Consultant
Kantar-Abacus Market Analytics
Mumbai, Maharashtra
2018.06 - 2018.11
- Ensured accuracy of advertising market surveys; strengthened collaborative cross-functional teamwork practices.
Technical Support Engineer
In-Solutions Global Private Limited
Mumbai, Maharashtra
2017.11 - 2018.05
- Monitored Visa/Master card servers; developed PL/SQL and Oracle DML queries to efficiently resolve client database issues.
Education
GED - Information Technology
Universal College of Engineering
Mumbai2017-06
Skills
- ETL Pipeline Design
- Cloud Data Engineering
- Data Warehousing
- Master Data Management
- SQL Development
- Python, Py-Spark
- Snowflake
- Databricks
- Power BI Reporting
- SSIS development
Certification
- Microsoft Certified: Power BI Data Analyst Associate, 2023
- Microsoft MVP (Avi Singh): LearnPowerBI, 2022
- SQLBI Certified: Introducing DAX Video Course, 2022
- Udemy: Microsoft Power BI for Business Intelligence, 2022
- LinkedIn Learning: Advanced SQL for Data Scientists, 2021
- Udemy: Salesforce Certified Platform Developer I, 2021
- NPTEL: Programming in C++, 2016
Timeline
Senior Software Engineer
Circulants Solutions
2018.12 - 2021.10
QA Consultant
Kantar-Abacus Market Analytics
2018.06 - 2018.11
Technical Support Engineer
In-Solutions Global Private Limited
2017.11 - 2018.05
Senior Data Engineer
Circulants Solutions
11 2023 - 2026.05
Application Software Developer
Circulants Solutions
11 2021 - 10 2023
GED - Information Technology
Universal College of Engineering