Samarth Rajpal

Data Steward with hands-on experience owning golden record integrity, resolving data conflicts and duplicates, and monitoring Data Quality KPIs (Accuracy, Completeness, Consistency, Timeliness) across enterprise and clinical data domains. Skilled in data matching and merging, root-cause analysis, and cross-system hierarchy mapping using TAMR, DQS, VTMF, and Snowflake. Experienced in building data profiling and validation frameworks, documenting data management plans, and partnering with cross-functional teams to enforce data governance standards and business rules.

Clinical Master Data Manager at Tata Consultancy Services (TCS) (2025-02 – Present)

• Own the integrity of the golden record for core clinical data domains, resolving data conflicts and duplicate records through validation rules, matching logic, and standardization frameworks.
• Manage data hierarchies, relationships, and cross-system mapping between EDC platforms and data warehouses, using TAMR, DQS, and VTMF to consolidate and reconcile source data.
• Establish and monitor Data Quality KPIs — Accuracy, Completeness, Consistency, and Timeliness — through automated and manual validation controls.
• Perform root-cause analysis on data discrepancies and lead remediation efforts, including discrepancy management and database lock activities.
• Design data profiling, validation, and cleansing processes using SQL, Snowflake, and BI tools to identify anomalies and improve downstream data reliability.
• Document data management plans, data transfer processes, and standardization rules; partner with biostatistics, clinical, and medical teams to align on data governance standards and business requirements.
• Ensure regulatory compliance and SOP adherence, supporting audit-readiness through consistent data lineage and process documentation.

Pharmaceutical Sales & Management Intern at Khandelwal Chemist (2023-03 – 2023-06)

• Maintained inventory and sales records using advanced Excel, supporting accurate order tracking and reporting.
• Supported daily pharmacy operations and built strong customer relationships through consistent, compliant service.

Bachelor of Pharmacy in Pharmacy – IPS Academy (2020 – 2024)