Harsh Verma
Data Analyst || BI Developer || Automation & ML Specialist
About
Data Analyst and AI Automation Engineer with 2+ years of experience across B2B/B2C supply chain environments including Flipkart and The RR Group. Skilled in building ETL/ELT pipelines using REST APIs and OAuth 2.0, developing Power BI and Microsoft Fabric semantic models (DAX, Star Schema, RLS), and optimizing large-scale SQL datasets. Experienced in AI-powered automation using LLMs (ChatGPT, Claude), RAG pipelines, and NLP-based models, along with CI/CD workflows via GitHub Actions (YAML, cron) and AWS RDS. Delivered MIS efficiency to gain and overall operational improvement. Built Python automation solutions using Selenium and XGBoost for supply chain analytics. Strong consulting mindset with stakeholder management experience. Published researcher (ICTSM 2025) and certified by Deloitte, Accenture, and Microsoft.
Skills & Expertise (56)
Work Experience
Lead Data Analyst
The RR Group
Apr 2026 - Present
Architected real-time data extraction pipeline integrating Zoho CRM & Zoho Books REST APIs (OAuth 2.0)—programmatically pulling sales orders, invoices, credit notes, and fulfilment records; engineered Zoho Analytics Bulk Export API pipelines with async job polling, OAuth token auto-refresh, and structured load into AWS RDS MySQL across 10,000+ order records. Built fully automated CI/CD pipelines using GitHub Actions YAML workflows with scheduled cron jobs, Ubuntu cloud runners, pip dependency management, and GitHub Secrets for secure credential injection (DB, Google API keys, Gmail SMTP) — Jana Order Automation running daily independent of local machine, with Gmail SMTP failure alerts. Deployed Claude & ChatGPT API-powered AI agents for automated vendor dispute resolution and remittance matching (Xpressbees, Delhivery, OM Logistics, Rapidship, Watsoo); engineered RAG pipeline foundations with vendor SLA documents as retrievable context; implemented prompt chaining, structured output parsing, and Lang Chain-compatible agent orchestration patterns. Conducted EDA on 1,00,000+ order records identifying data quality issues (missing AWBs, status inconsistencies); implemented NLP-driven MySQL stored procedure customer segmentation analyzing purchasing behavior and surfacing churn insights — 20% operational efficiency improvement; built Python data reconciliation scripts (pandas, pymysql) processing multi-source order-item datasets with case insensitive fuzzy key matching. Built enterprise BI dashboards for Flipkart, Swiggy, and Meesho — 30% MIS efficiency gain; designed semantic data models (star schema, one-to-many, RLS via USERPRINCIPALNAME() DAX); advanced DAX measures (SUMX/SUMMARIZE Revenue deduplication, Collection Rate, Avg TAT, Overdue counts); Power Query (M) — financial-year month sorting, INR stripping, aging columns; published to Power BI Service with per-client filtered URL delivery for 100+ Client locations. Engineered complex Zoho Analytics SQL joins (Purchase Orders × Items × Receive × Vendors) — qty ordered/received/pending, DATEDIFF aging, CASE delivery status; Google Apps Script pipelines with IMPORTRANGE, FILTER, CONCATENATE composite keys (Mapping Unique Key); AWS EC2/RDS MySQL infrastructure with Security Group management and Python connector (pymysql) deployment.
Data Analyst
Flipkart
Aug 2025 - Mar 2026
Managed end-to-end Power BI reporting — SQL extraction from 1M+ row shipment datasets, Power Query (star schema, DAX) and dashboard deployment for operations, finance, and leadership teams; optimized SQL queries for Wishmaster-level delivery data enabling root-cause investigation and operational planning. Write a Python automation system (Selenium) for shipment TID tracking — automated status-check workflows eliminating manual processing; built EDA pipelines on supply chain datasets for trend analysis, loss metric identification, and vendor SLA adherence monitoring. Developed Looker Studio dashboards integrated with Google Sheets for automated operational reporting — tracking supply chain KPIs (loss metrics, delivery performance, RTO adherence, vendor efficiency, regional scorecards) consumed daily by planning and audit teams; reduced data latency for field operations teams.
Associate Data Analyst Intern
Lazer Lab
Apr 2024 - May 2025
Developed Power BI dashboards for audit and compliance reporting using SQL-based datasets aligned with ITGC and SOX frameworks and performed data cleaning, transformation, and validation using SQL Workbench and Power Query to ensure high-quality reporting inputs. Authored SOPs for data access and reporting workflows, ensuring governance consistency and smooth handover across teams. Created KPI reports and summary dashboards for internal stakeholders, improving visibility into control testing overall results.
Education
Bachelor of Technology, Computer Science and Engineering - Abdul Kalam Technical University (AKTU)
2021 - 2025 · Afghanistan
Certifications
Infrared Based Vein Detection: Comprehensive Review
International Conference on ICTSM · 2025
Data Analytics Job Simulation
Deloitte · 2025
Career Essentials in Business Analysis
Microsoft and LinkedIn · 2025
Data Analytics and Visualization Job Simulation
Accenture and Forage · 2025
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Visa Status
Need Sponsorship
Relocation
Depends on Offer
Skills (56)
Click a skill to find developers with the same skill
