Mukesh Pandey — Product Manager

Seasoned and results-oriented Data Architect with over 14 years of experience in the IT industry, including 5+ years in Data Architecture and 8+ years in Data Modeling. Proven expertise across diverse domains such as US Healthcare (Claims & Provider), Clinical Trials, Pharmaceutical, and Learning & Development Analytics. Skilled in designing and delivering scalable, secure, and high-performance data solutions using Microsoft Azure (ADF, Databricks, ADLS), SQL Server, and modern ETL/ELT frameworks. Adept in data governance, metadata management, and data integration strategies, ensuring compliance with industry regulations, including HIPAA and GDPR. Experienced in leading cross-functional teams, optimizing data workflows, and driving continuous improvements. Strong command over collaboration and DevOps tools such as Jira, GitHub, and Azure DevOps, with a focus on delivering business value through data-driven insights and innovation. Core Competencies: • Data Architecture & Design: Enterprise Data Warehouse (EDW), Data Marts, Data Lakes, Lakehouse, OLAP/OLTP Systems, Data Integration Strategies. • Cloud Platforms: Azure Databricks, Azure Data Factory (ADF), Azure Data Lake Storage (ADLS), Microsoft Fabric. • Data Modeling & Architecture: Conceptual, Logical & Physical Data Models, Star & Snowflake Schema, Relational & Dimensional Modeling, Normalization & Denormalization. • Data Modeling Tools: Erwin Data Modeler, Microsoft Visio, DBDiagram.io • ETL/ELT: Design and implementation of scalable ETL/ELT pipelines using Azure Data Factory, Informatica IDMC, and SSIS. • Data Documentation & Governance: Data Dictionary, Data Lineage, Metadata Management, Security & Access Control Matrix, Compliance Documentation (GDPR, HIPAA). • ETL & Data Integration Documentation: Source-to-Target Mapping, Data Transformation Specifications, Data Pipeline Design, Query Optimization Strategy. • Advanced SQL & Performance Tuning: Complex SQL Queries, Automation, Stored Procedures, Query Optimization. • RDBMS Expertise: MS SQL Server, MySQL, Oracle, PostgreSQL. • Business Intelligence: Integration with BI tools (Power BI, MicroStrategy, Denodo) for reporting and dashboard creation. • Data Governance & Security: Implementation of data security, privacy policies, and compliance with HIPAA and GDPR regulations. • Project Management Tools: Jira, GitHub, Azure DevOps, ServiceNow. • Domain Knowledge: US Healthcare, Clinical Trials (Life Sciences), Pharmaceutical, Learning & Development analytics. • Leadership & Collaboration: Team Leadership, Code & PR Reviews, Approving Change Requests

Stackforce AI infers this person is a Data Architect specializing in Healthcare and Pharmaceutical analytics with strong cloud and data governance expertise.

Location: Hyderabad, Telangana, India

Experience: 14 yrs 3 mos