Somil Sethi
Gurgaon
Summary
Accomplished MDM Developer with over 8 years of experience leading Reltio MDM implementations for pharmaceutical and life sciences clients, including Pfizer, Takeda, and Eli Lilly. Expert in configuring match/merge rules, survivorship logic, data governance, and reference data management (RDM), with advanced proficiency in Java, Informatica IICS, and REST APIs. Certified in Reltio Cloud (Beginner and Advanced), with a proven track record of automating operational processes, resolving incidents within SLAs, and enhancing data quality for 400,000+ profiles. Adept at collaborating with cross-functional teams to ensure operational reliability and compliance in healthcare data management.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Senior Consultant (MDM Developer)
Deloitte Consulting USI
Gurugram
08.2020 - Current
- Led migration from IQVIA-managed Reltio MDM to Pfizer-managed Reltio MDM, ensuring high-quality customer master data for global markets.
- Configured Reltio MDM entities, relationships, match/merge rules, and survivorship strategies, security framework for access control, created custom scripts achieving 80% effort reduction in Reltio processes.
- Monitored platform health, triaged incidents (e.g., job failures, sync delays), and resolved issues within SLAs, ensuring operational reliability.
- Integrated Reltio with external systems using REST APIs, optimizing data synchronization.
- Automated data validation processes, improving efficiency by 50%.
- Established data governance procedures and collaborated with data stewards to maintain data integrity for 20 million+ customer profiles.
- Supported platform upgrades, reference data updates, and access control configurations, maintaining detailed SOPs and knowledge articles.
- Mentored junior developers and delivered company-wide Reltio MDM training.
- Received 5 Applause Awards and 2 Outstanding Awards for high performance and taking on additional responsibilities.
MDM Developer
Fresh Gravity
Pune
04.2020 - 08.2020
- Enhanced Reltio MDM to rank Healthcare Professionals (HCPs) and Healthcare Organizations (HCOs) based on specific metrics for customer-centric initiatives.
- Designed algorithms for ranking HCPs and HCOs, evaluating metrics using Scala notebooks in Reltio Data Science.
- Developed custom Java utilities for exporting resolved relation entities from Reltio, supporting data quality initiatives.
- Configured match rules and survivorship logic to ensure accurate HCP/HCO master data.
MDM Developer
Lumen Data Solutions
Bengaluru
09.2019 - 03.2020
- Onboarded Veeva as a new source and retired CRM in Reltio MDM, optimizing system processes for pharmaceutical data management.
- Configured L3 settings, including entity types, relationships, match rules, survivorship strategies, and UI configurations in Reltio Console.
- Developed Java utilities for data extraction (Master, XREF, relations) and bulk merge/unmerge processes, enhancing performance.
- Automated data exports using Revo tool and performed bulk data deletion for CRM retirement.
- Managed user accounts, data modeling, and environment management, ensuring SLA compliance.
- Collaborated with data stewards to support reference data management and stewardship workflows.
- Documented operational processes and ticket handling procedures for team reference.
MDM Developer
Tata Consultancy Services
Noida
07.2016 - 09.2019
- Executed two-phase project to extract, transform, and load product data into Reltio MDM and Oracle tables for downstream consumption.
- Gathered business requirements and developed design documents for Reltio MDM implementations.
- Configured Reltio data models, including entities, attributes, and match rules, using JSON-based configurations.
- Developed Informatica IICS transformations (Aggregator, Joiner, Router) and ICRT components for API-based data extraction.
- Authored Unix shell scripts to automate load stats collection, improving operational efficiency.
- Scheduled jobs using CA Workload Automation and collaborated with cross-functional teams to support data governance.
- Received Star Team Award, Best Team Award, Learning Achievement Award, and 3 On the Spot Awards for APIMS project performance.
Education
B.Tech - Computer Science and Engineering
Manav Rachna International University
PG Diploma - Information Security
Indira Gandhi National Open University
Skills
- Reltio MDM
- Match/Merge Rules
- Survivorship Logic
- Data Governance
- Reference Data Management
- REST APIs
- Informatica IICS
- ICRT
- Java
- Unix Shell Scripting
- Scala
- Snowflake
- AWS
- SQL
- JIRA
- Bitbucket
- Reltio Console
- SQL Developer
- Toad
- CA Workload Automation
- Agile Development
- Pharmaceutical
- Data Quality
- Incident Management
- SLA Compliance
Certification
- Reltio Cloud Certification (Beginner and Advanced)
- LOMA 280 - Principles of Insurance
Personal Information
Title: Senior MDM Developer
Timeline
Senior Consultant (MDM Developer)
Deloitte Consulting USI
08.2020 - Current
MDM Developer
Fresh Gravity
04.2020 - 08.2020
MDM Developer
Lumen Data Solutions
09.2019 - 03.2020
MDM Developer
Tata Consultancy Services
07.2016 - 09.2019
B.Tech - Computer Science and Engineering
Manav Rachna International University
PG Diploma - Information Security
Indira Gandhi National Open University
Similar Profiles
Ishan MukewarIshan Mukewar
Senior Consultant at Deloitte Consulting USISenior Consultant at Deloitte Consulting USI
Garima Tyagi DubeyGarima Tyagi Dubey
Senior Consultant, Human Capital – Organization Transformation at Deloitte Consulting USI Ltd.Senior Consultant, Human Capital – Organization Transformation at Deloitte Consulting USI Ltd.
Avadhoot AthalyeAvadhoot Athalye
Consultant at Deloitte Consulting USI Pvt. Ltd.Consultant at Deloitte Consulting USI Pvt. Ltd.
Kuljit SinghKuljit Singh
Head (Director), Business Transformation & Risk Control at AIS Info SourceHead (Director), Business Transformation & Risk Control at AIS Info Source
Girish MisraGirish Misra
Director – Operations at FareportalDirector – Operations at Fareportal