Headline

Data Analyst | SQL Server, Power BI & Python | Turned SAP/Tally/Oracle Chaos into 14 Dashboards Used by 120+ People Daily

About

I'm a Data Analyst at Genpact, embedded directly inside Sales, Finance, and Supply Chain teams — not sitting in a back-office BI function, but working as a genuine partner to the business. I own the full data stack, end to end: → SQL Server pipelines that bring SAP, Tally, and a legacy Oracle system into one warehouse → 14 Power BI dashboards used daily by 120+ people, with row-level security so every regional manager sees only their own data → Python automation (Pandas, SQLAlchemy) that catches around 340 data errors a month before they ever reach a report The result I'm proudest of: cutting month-end reporting from 4 days down to under 6 hours, by pulling three disconnected ERP systems into a single source of truth. Beyond the technical side, I care about the human part of this work — running weekly stakeholder demos, mentoring junior analysts, and making sure the people using my dashboards actually trust the numbers in front of them. Open to Data Analyst / BI Analyst opportunities. Always happy to connect.

Location

Greater Indore Area

AI stack

antigravity

codex

cursor

Work experience

Data Analyst at GENPACT, Aug 2022 - Oct 2024 · 2 yrs 3 mos, Bengaluru, Karnataka, India, Embedded in the Analytics & BI team, partnering directly with Sales, Supply Chain, and Finance on data infrastructure, automated reporting, and analysis that feeds real operational decisions. - Consolidated data from SAP, Tally, and a legacy Oracle database into a single SQL Server warehouse — cut month-end reporting from 4 days to under 6 hours (94% reduction) - Own and maintain 14 Power BI dashboards used daily by ~120 people, covering sell-through, stock aging, regional revenue, and promo performance - Built all data models from scratch in Power Query using star schema, replacing fragile flat-file Excel extracts - Implemented Row-Level Security so each regional manager sees only their own territory's data - Authored 40+ DAX measures (YTD/MTD revenue, rolling averages, forecast vs. actuals) so managers can self-serve answers - Replaced 18 manual monthly Excel reports with automated paginated Power BI reports — saving 20+ hours per reporting cycle - Built Python data quality scripts (Pandas, SQLAlchemy) catching ~340 errors/month before they reach any report - Resolved ~2,200 unmapped SKUs during an Oracle migration using a fuzzy-matching reconciliation script - Mentored 2 junior analysts on SQL and Power BI; wrote onboarding documentation that cut ramp-up time by ~3 weeks

Intern at GENPACT, Jan 2022 - Jun 2022 · 6 mos, Remote, Worked alongside senior analysts to support data operations, reporting, and analysis workflows — building a strong foundation in real-world data handling and business intelligence practices. 𝗞𝗲𝘆 𝗖𝗼𝗻𝘁𝗿𝗶𝗯𝘂𝘁𝗶𝗼𝗻𝘀: ▶ Data Analysis & Validation — Analyzed and validated large-scale datasets using Excel and SQL, ensuring data accuracy and integrity across business operations. ▶ Data Cleaning & Transformation — Identified and eliminated duplicate and inconsistent records using Excel filters and SQL queries, improving overall data quality for reporting. ▶ Reporting & Dashboarding — Designed and maintained weekly Excel reports tracking key operational metrics, enabling the team to monitor performance and take timely action. ▶ Documentation & Process Support — Maintained structured documentation of data sources, workflows, and analysis steps — improving team efficiency and knowledge transfer.

Education

Master of Computer Applications - MCA, Computer Applications / Data Analytics Grade: ( 7+ CGPA), National institute of technology kurukshetra

Bachelor in science, APJ Abdul Kalam University