AugmntX

AugmntX is the world’s largest network of pre-vetted talent.

Contact Info

305, IRIS Corporate Centre,
Hiranandani Meadows, 400610.
hello@augmntx.com
+919820045154

Follow Us

Home / Developers / AXF29228
profile image
Mehakarkar O AXF29228 Active
Technical consultant in Pune
Seasoned technical lead with 12 years experience delivering data driven, AI based, and automation first solutions across pharma, BFSI, and manufacturing. Expert at architecting scalable data pipelines, intelligent machine learning models, and automated workflows that boost efficiency, governance, and ROI. Adept at leading global teams to integrate complex systems ensuring seamless end to end solutions that turn innovative concepts into enterprise grade reality.
Industries : Pharmaceutical
Share
Hire Mehakarkar O
Download PDF
Availability
Full-time
Total experience
12 years
Technical skills
Python
10 Years
SQL Server
10 Years
Azure Data Bricks
7 Years
Data Warehousing
7 Years
Power Automate
6 Years
PowerBI
4 Years
Java
3 Years
JavaScript
3 Years
SSAS, SAP S/4HANA, ICH, ATTP, SAP BTP (APIs), Azure Data Factory (ADF), Azure Databricks, Apache Spark, PySpark, Azure Data Lake Storage (ADLS), Parquet, Azure Machine Learning, Synapse Analytics, Power BI, Azure Monitor, Azure Key Vault
Projects
AI Performance Analytics
January-2025 to June-2025
Description
Architected and delivered a custom analytics platform for a pharma client post-demerger, providing end-to-end visibility across AI and RPA operations. Designed an enterprise SQL Server (100+ tables, 50+ SPs), built SSAS models and SSIS ETL with monthly-partitioned cubes and automated refreshes, led data migration and role-based dashboards achieving 80% reduction in monitoring time and simplified bot governance.
Roles and Responsibilities
Architected end-to-end analytics platform to deliver AI & RPA performance visibility. Designed enterprise SQL Server schema (100+ tables) and authored 50+ stored procedures and 20+ functions for KPI tracking and bot config. Led SSAS model design and SSIS ETL development with monthly-partitioned cubes and automated SQL Agent refresh jobs. Coordinated data migration from parent systems and ensured clean separation for business continuity. Developed role-based Power BI dashboards and enforced RLS for executive and domain access. Implemented centralized logging, monitoring, and alerting to reduce monitoring time by ~80%. Drove governance, documentation, and handover to operations for maintainability and scale.
Technologies: Sql Server, SSAS, Power Automate
Industry: Pharmaceutical
CM Alerts Classification
April-2024 to December-2024
Description
ed design and delivery of a scalable predictive risk classification platform to detect counterfeit, expiry, and invalid-order risks across the supply chain. Integrated SAP S/4HANA, ICH and ATTP sources with Azure pipelines (ADF, Databricks, ADLS), Azure ML scoring, and SAP BTP API actions. Built OLAP and real-time insights (Synapse, Power BI) with end-to-end observability and security, driving ~$3M annual savings and measurable reductions in recalls and manual triage.
Roles and Responsibilities
Owned data engineering architecture and end-to-end solution design for the SCM alerts platform. Designed and implemented ADF ingestion pipelines to process 10M+ alerts/day and orchestrated Databricks (PySpark) enrichment. Defined data lake schema and partitioned Parquet strategy in ADLS for scalable storage and query performance. Developed Azure ML scoring workflows and productionized models; integrated inference results into SAP via BTP APIs to trigger automated actions. Built Synapse-based OLAP/real-time layers and Power BI dashboards with role-based access for operational and executive insights. Implemented observability, monitoring, and security controls (Azure Monitor, Key Vault, logging/telemetry). Tuned pipeline performance, managed costs, and enforced data governance and compliance for post-demerger separation. Coordinated cross-functional stakeholders, led deployments, and validated business impact (20% fewer recalls, 30% fewer invalid orders, 50% reduction in manual triage).
Technologies: SAP S/4HANA, ICH, ATTP, SAP BTP (APIs), Azure Data Factory (ADF), Azure Databricks, Apache Spark, PySpark, Python, Azure Data Lake Storage (ADLS), Parquet, Azure Machine Learning, Synapse Analytics, Power BI, Azure Monitor, Azure Key Vault
Industry: Pharmaceutical
Work history
Technical consultant • August-2013 to August-2025
Description: Architect end-to-end analytics & automation platforms (SQL Server, SSIS/SSAS, Synapse, Power BI). Design high-throughput ingestion & ML pipelines (ADF, Databricks, Azure ML) handling 10M+ events/day.Build observability, telemetry, and self-healing automation (Azure Monitor, Grafana/Kibana). Lead cross-functional teams, manage data migrations, governance, and security. Deliver centralized logging, configuration, and dashboards to drive operational efficiency and multimillion-dollar savings.
Soft skills
Team leadership
Problem-solving
Critical thinking
Certifications
Azure data engineer certification by Microsoft
2023
Education
Bachelors degree in Computer Science
Swami Ramanand Teerth Marathwada University
2009 to 2013
Language
English - Advanced