MohmadAdil Shaikh

Skills

Data & BI tools

Excel (Advanced) Power BI DAX Power Query Data Modeling SQL PostgreSQL DuckDB Python (Pandas, NumPy) Jupyter Notebook Google Colab

Analytical methods

Design of Experiments (DOE) Statistical Analysis FMEA Root Cause Analysis Process Validation (IQ/OQ/PQ)

Domain knowledge

Medical Device Development Design Verification & Validation Mechanical/Physical Testing Regulatory Documentation (DHR)

Soft skills

Stakeholder Communication Problem Solving Attention to Detail Cross-Functional Collaboration

Projects

Retail Data Pipeline & Analytics Engine

Python · Pandas · DuckDB · SQL

Built an automated pipeline ingesting 9,994 retail transaction records via the Kaggle API, cleaning and standardizing schema with Pandas, then loading into a DuckDB fact-table model. Wrote 5 SQL queries using window functions, CTEs, and YoY pivoting to surface revenue, regional, and profitability trends.

Machines sub-category: +$3,635 YoY profit growth View on GitHub ↗

Customer Shopping Behaviour Analysis

Python · SQL · Power BI · PostgreSQL

Performed end-to-end retail analysis on 3,900 transactional records — Python (Pandas, NumPy) for data exploration and cleaning, PostgreSQL for structured querying. Wrote 10 business SQL queries covering revenue segmentation by gender, customer tier classification, and loyalty pattern analysis.

73% non-subscriber base identified View on GitHub ↗

Bank Customer Churn Dashboard

Power BI · DAX · Power Query

Analyzed churn patterns across 10,000 bank customers using Power Query for ETL and DAX measures (Churn Rate, Customer Lost) for KPI tracking. Found number of products held as the strongest churn predictor, with compounding risk in older age groups and specific geographies.

3+ products → 82–100% churn rate View on GitHub ↗

Lotus Hospital Analytics Dashboard

Power BI · Excel · Data Modeling

Cleaned and modeled 7,157 hospital patient records in Power Query, building DAX measures for KPI aggregation across billing, occupancy, and diagnosis dimensions. Built an interactive dashboard with slicers for Patient ID and date range.

₹190.43M total billing tracked View on GitHub ↗

Zepto SQL Data Analysis

PostgreSQL · SQL

Cleaned and analyzed 3,732 grocery product records in PostgreSQL — removed invalid entries and normalized currency fields (paise → rupees). Wrote 8 SQL queries to analyze revenue concentration, discount patterns, and inventory weight distribution.

Top categories: ₹337K+ revenue each View on GitHub ↗

Experience

Senior R&D Officer — Meril Endo-Surgery Pvt. Ltd. Apr 2025 – Present

Build Power BI dashboards combining test data, project timelines, and market benchmarking for cross-functional teams.
Use SQL to query and extract process data, and Python to automate routine data-cleaning tasks.
Lead development of surgical implant and delivery system devices from concept through commercialization.

R&D Officer — Meril Endo-Surgery Pvt. Ltd. Mar 2022 – Apr 2025

Built Excel/Power BI dashboards to track test results and project timelines for cross-functional visibility.
Independently designed and executed Design of Experiments (DOE) to evaluate process and material parameters.

R&D Officer — Meril Healthcare Pvt. Ltd. (Trauma Orthopedics) Dec 2019 – Feb 2022

Supported design, development, and testing of orthopedic trauma implants and instruments.

R&D Officer — Meril Life Sciences Pvt. Ltd. (Cardiovascular) Feb 2018 – Dec 2019

Supported R&D activities for cardiovascular device development, including prototyping and testing.