Summary
Overview
Work History
Education
Skills
Websites
Certification
Personal Information
Timeline
Generic

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
Somil Sethi