Headline

Data Analyst | Ex-Bain & Company | Power BI · SQL · Python · GenAI Automation | Reduced Reporting Effort by 75% | Open to Analytics & AI-Driven Roles

About

I spent 9 months at Bain & Company watching smart people waste hours on manual reports — and decided to fix that with code. As a Data Analyst on a high-stakes consulting engagement, I built automation tools that turned 5-person, 8-day workflows into 2-day processes. I developed a Python + Streamlit app that auto-generated full PowerPoint diagnostic decks for senior clients — what used to take a week now happens on demand. I integrated GenAI tools (ChatGPT, Claude) into live analytics workflows, cutting time-to-insight by 50%. My work sits at the intersection of data analytics and AI automation: — Power BI dashboards (DAX, Deneb, Power Query) adopted in weekly executive reviews — NLP + LLM pipelines processing 50K+ customer records with 95%+ labelling accuracy — Excel and SimilarWeb/SEMrush automation scaled across 32-person consulting teams — Competitive intelligence, geo-analysis, and digital benchmarking for Fortune-level clients I'm a Computer Science graduate (AI & ML) from VIT with a Google Cloud Digital Leader certification, and I care deeply about one thing: making data actually useful to the people making decisions. I'm currently open to roles in Data Analytics, Business Intelligence, AI-Driven Analytics, and Product/Data. If you're hiring or solving interesting data problems — let's talk. 📩 divya.agarwal9082@gmail.com

Location

Gurugram

AI stack

cursor

claudecode

Work experience

Analyst at Bain & Company, Sep 2025 - May 2026 · 9 mos, Gurugram, Built an Excel automation tool consolidating SimilarWeb and SEMrush data across 32 team members, compressing an 8-day, 5-person manual workflow to under 2 days — 75% reduction in effort Developed a Python + Streamlit application to auto-generate client-ready marketing diagnostic PowerPoint decks, eliminating repetitive manual slide-building and enabling on-demand report refresh for senior stakeholders Integrated GenAI tools (ChatGPT, Claude) into live marketing analysis workflows, cutting time-to-draft for diagnostic reports by 50% and accelerating executive narrative generation at consulting speed Resolved a Python visual rendering failure in Power BI by re-implementing the chart in Deneb (Vega-Lite), restoring full dashboard functionality with zero infrastructure changes Conducted UI/UX competitive analysis across web and mobile platforms using SimilarWeb, SEMrush, and Brandwatch, delivering structured strategic recommendations to client leadership Produced executive-ready deliverables in PowerPoint, ThinkCell, and Mekko Graphics under tight consulting timelines, translating analytical output into structured, insight-led narratives

Education

B.Tech, Computer Science, Vellore Institute of Technology

Bachelor of Technology, Computer Science, Vellore Institute of Technology

Public links

github: https://github.com/divy-1909