M. Haresh Kumar
M. Haresh Kumar
Data Operations & AI Automation

M. Haresh Kumar

Senior Data Operations Lead & Power BI Developer

14+ years bridging the gap between business operations and data analytics. I design clean pipelines, Power BI dashboards, and automated Python workflows using SQL, Snowflake, and Power BI.

View Projects 📄 Official 2-Page Resume GitHub Profile 📚 My Book on Amazon
📚
Now Live on Amazon Kindle
The Comprehensive Power BI & Enterprise Business Intelligence Handbook
VertiPaq · DAX · Fabric Direct Lake · Star-Schema · PL-300
Buy on Amazon →
“I didn't start in a classroom. I started in the real world. Handling 200K–300K record workflows and leading 15+ member teams taught me to build data solutions that actually work.”
— M. Haresh Kumar
14+
Years Experience
300K
Records Managed Monthly
15+
Team Members Led
SQL | Power BI | Snowflake
Core Technical Stack
🛠️ Core Tools & Stack
The core tools I use to build dashboards, ETL pipelines, and AI automation workflows.
📊 Power BI / DAX 🗄️ SQL (CTEs / Window) ❄️ Snowflake DWH 🐍 Python & Automation 📈 Excel / VBA ⚙️ Outlook COM API

Target Role Alignment

Directly mapping 14+ years of data operations leadership & modern technical stack to hiring manager requisitions:

PRIMARY FIT
Data Operations Lead
200K–300K Data Intake, Quality Control, 15+ Team Leadership, Excel/VBA Automation
STRONG FIT
BI Developer
Power BI Dashboards, DAX Calculated Measures, Power Query ETL, Star Schema Modeling
STRONG FIT
Data Analyst
Complex SQL CTEs & Window Functions, Financial Analytics, Operational Metrics
STRONG FIT
AI Automation Engineer
Python (`pywin32`, `gspread`), Multi-Account Outlook COM API, Claude & Cortex AI
GOOD FIT
Analytics Engineer
Snowflake Medallion Architecture (Bronze/Silver/Gold), Streams/Tasks, PII Masking
TRANSITION FIT
Fabric Data Specialist
Medallion Architecture (Bronze/Silver/Gold), Power Query ETL (Dataflows M), SQL Transformations, Governance

Honest Technical Skills Assessment

Clear, defensible skill categorization reflecting real operational depth and ongoing technical growth:

🟢 Advanced Experience
  • • Excel (Pivot, Macros, Formulas)
  • • Operational Data Validation
  • • Quality Control & MIS Reporting
  • • Team Leadership (15+ Members)
  • • Process Automation
🔵 Intermediate Competency
  • • SQL (CTEs, Window Functions)
  • • Power BI (DAX, Modeling)
  • • Power Query Data Cleansing
  • • Star Schema Dimensionality
  • • REST & Sheets API Integration
🟡 Practical Learning
  • • Snowflake (Medallion, Streams)
  • • Python (`pandas`, `pywin32`)
  • • AI Automation & Workflows
  • • MS Fabric (Lakehouse / Dataflows)
⚪ Conceptual Understanding
  • • Azure Data Factory
  • • SSIS ETL Pipelines
  • • Informatica Data Integration

Featured Personal Technical Projects

Practical data engineering, analytics, and automation systems built to demonstrate technical capabilities:

💳 1. Snowflake Medallion Pipeline
❄️ Snowflake ⚡ Streams & Tasks 🔒 PII Masking

3-layer Medallion Data Architecture (Bronze/Silver/Gold) in Snowflake with Streams & Tasks ingestion, Dynamic PII Data Masking, and Power BI fraud reporting.

Raw Logs
JSON / CSV
➔
Bronze
Staging
➔
Silver
De-duped
➔
Gold
Star Schema
📂 GitHub Docs 📓 Jupyter Notebook
📧 2. Multi-Account Outlook Automation
🐍 Python (*Learning*) 📬 Outlook COM API 📊 Google Sheets API

Python automation using Outlook COM API (`pywin32`) and Google Sheets API to manage multi-account sender rotation (100/day cap), bounce logging, and CRM sync.

📂 Source Code 📓 Jupyter Notebook
📉 3. Revenue Leakage Calculator
🌐 Web App ⚡ JavaScript 📊 CRM Intake

Responsive web diagnostic calculator for business owners to quantify missed lead revenue opportunities with real-time web-to-sheet CRM intake.

🌐 Live Web App 📂 Source Code
🏥 4. ER Capacity BI Dashboard
📊 Power BI 🧮 DAX Measures 🏥 Healthcare

Interactive Power BI dashboard analyzing patient triage priority (1-5), admission wait times, and peak arrival windows for hospital shift planning.

📂 PBI Files

Commercial Experience Timeline

Core operational leadership experience acquired over 14+ years managing data workflows and team performance:

🏢 Operational Data Management & Intake

Managed day-to-day data intake, validation, and reporting workflows across operational teams (handling datasets ranging from 200K–300K records).

⚡ Process Automation & MIS Reporting

Built custom Excel, VBA, and script-based tools that significantly reduced repetitive manual effort for operations staff.

👥 Team Leadership & Quality Control

Led teams of 15+ members, standardizing reporting formats, enforcing data quality rules, and training personnel on reporting systems.

🤖 AI Assistance Statement

Modern AI Collaboration:
The portfolio reflects my own solution design, SQL logic, Power BI models, and implementation. AI tools such as Claude and Snowflake Cortex AI were used where appropriate to accelerate development, with all outputs reviewed, tested, and validated by me.

Let’s Connect

Open to Data Analyst, BI Developer, and Data Operations Lead opportunities.

📄 View & Download Executive Resume PDF 📂 Explore GitHub Master Repo