Professional Experience
Walitechs Solutions Private Limited
Oct 2023 – Present
SENIOR DATA ANALYST · GURUGRAM
- Microsoft Fabric & Cloud BI: Architected enterprise Lakehouse, OneLake & Warehouse solutions integrated with Power BI for real-time analytics across Sales, Finance, HR and Supply Chain.
- Power BI Dashboards: Built 10+ enterprise dashboards (Star & Snowflake Schema, DAX, RLS, drill-through) for 50+ stakeholders; reduced reporting time by ~50%.
- Snowflake Engineering: Designed JSON pipelines via FLATTEN & LATERAL joins; Streams (CDC) and Replication for resilience.
- ERP Migration: Managed Microsoft Dynamics AX data extraction; led full migration to Dynamics 365 Business Central with zero data loss.
- Python Analytics: Processed 500K+ row datasets with Pandas & NumPy — improved data accuracy by 30% through automated quality checks.
- ETL Automation: Automated 15+ weekly/monthly MIS reports via Python & Power Query — saving 10+ man-hours per week.
- AI Productivity: Leveraged Claude AI, ChatGPT & Gemini for DAX, SQL scripting, report & mail automation — cutting dev time ~40%.
- SQL Optimisation: Reduced query execution time by 35% across SQL Server, PostgreSQL and Snowflake using indexing, CTEs, Window Functions, Stored Procedures & EXPLAIN PLAN.
IndiaMART InterMESH Ltd.
Jul 2022 – Jul 2023
BUSINESS DELIVERY EXECUTIVE
- Managed business delivery pipelines using data-driven methodologies ensuring operational SLA compliance.
- Generated operational MIS dashboards and performance reports; supported C-level stakeholders through analytics-driven insights.
Key Analytics Projects
01
Microsoft Fabric Data Architecture
Scalable Lakehouse & Warehouse on Microsoft Fabric with OneLake as unified storage layer for real-time cross-domain analytics.
↑ Unified data layer · Real-time
Lakehouse code → BC → Fabric AX views →02
Sales & Product Intelligence Dashboard
Multi-level drilldown (Country→State→City→Store) with YoY/MoM/YTD Time Intelligence for 30+ users across 5 regions.
↓ 50% reporting time
Rebuilt on synthetic data: Power BI report →03
Snowflake Data Engineering
JSON pipelines with FLATTEN & LATERAL joins. Streams for CDC, Replication for resilience, AI-assisted query optimisation.
↓ 35% query time (SQL Server, PostgreSQL & Snowflake)
Rebuilt on synthetic data: CDC pipeline →04
AI Report Automation & NL-to-SQL
Automated report generation via Claude AI for scheduled emails. NL-to-SQL system for non-technical stakeholders.
↓ 50% manual effort
▶ Live demo NL-to-SQL code → Report automation code →05
Financial & Inventory Performance Hub
P&L (Revenue, GP, EBITDA) with variance analysis. Real-time On-Hand, In-Transit & Aging stock across 5 BUs.
↓ 40% discrepancy time
Rebuilt on synthetic data: inventory & OTIF lakehouse →06
HR Analytics Dashboard
Headcount, attrition & recruitment velocity with RLS for 5 role levels across 500+ employees. Identified 20% cost saving.
20% cost saving identified
HR page: design prototype →07
Customer Churn Analysis
Cohort & funnel analysis identified top 3 churn drivers. Automated cleaning pipeline cut preprocessing by 60%.
↓ 60% preprocessing time
Rebuilt on synthetic data: churn model →08
Retail & Category Performance
Pareto 80/20 analysis for top-5 categories. Market Basket Analysis & store-level dashboards for regional benchmarking.
↑ 45% benchmarking efficiency
Rebuilt on synthetic data: Pareto ABC code →