Hi, I’m Divyanshu Vashisht 👋
Data-driven Business Analyst with a proven ability to turn complex data into actionable insights that accelerate go-to-market strategies and improve sales performance. Adept at building pricing models, sales reports, and executive dashboards that influence decision-making at the leadership level. Skilled in SQL, Python, and data visualization tools, with a strong track record of leading cross-functional teams, optimizing customer experience, and supporting high-impact product rollouts.
🎓 Education
- Masters in Business Analytics
University of Illinois Urbana-Champaign, USA
Graduated: May 2025 GPA: 3.61/4 - Bachelor of Technology in Production and Industrial Engineering
Vellore Institute of Technology, India
Graduated: June 2022
GPA: 3.33/10
🛠 Skills
- Technical: SQL, R, Python (Pandas, NumPy, NLTK), Data management & ETL, Statistical Predictive Modeling & Forecasting
- Tools: Azure Data Studio, JIRA, Trello, Tableau, MS Excel, MS PowerPoint, Power BI, Confluence, Salesforce (equivalent)
- Business Operations: Sales Cadence Support, KPI Dashboards, Reporting Automation, GTM Execution
- Certifications: AWS Cloud Practitioner, Six Sigma Green Belt, Google AI Essentials
- Cross-Functional: Project Tracking, Stakeholder Communication, Requirement Gathering, Backlog Management
💼 Work Experience
- Business Analyst Consultant | Wise Tries (Business Practicum)
Jan 2025 - May 2025
- Translated business requirements into backlog items and feature logic, supporting Agile planning across business teams.
- Authored product scope documents to support system configuration, platform integration, and requirements traceability.
- Built interactive dashboards to track operational KPIs for pilot rollouts, enabling leadership to monitor success metrics.
- Senior Business Analyst | Appointy IT Pvt. Ltd.
Aug 2022 - Jun 2024- Led full-cycle KPI reporting for 15+ enterprise accounts; built dashboards tracking pipeline metrics and onboarding SLAs.
- Conducted in-depth quantitative analysis using SQL and Excel to identify churn patterns, pricing friction, and introduced client retention models.
- Served as analytics lead on strategic process improvement efforts, integrating cross-functional data to identify $200K in annual retention risks.
- Mentored a 6-member analyst team on documentation standards, client communication, and stakeholder reporting.
- Business Analyst | Appointy IT Pvt. Ltd.
Aug 2021 - Jul 2022- Conducted profitability analysis using Excel and strategic pricing models, contributing to a $600K YoY revenue increase.
- Analyzed product usage of 2,000+ users through event-level A/B tests, driving 15% engagement by suggested UX changes.
- Interviewed 100+ users to map pain points and collaborated with the product team to inform roadmap decisions.
- Led automation of reporting pipelines across operations and finance, improving process efficiency by 25%.
- Tracked and reported program-level KPIs to senior leadership, aligning data visibility with quarterly performance goals.
🛠 Projects
-
Data Storytelling: Credit Card Fraud Detection Python, Tableau - Achieved 72% hit rate using a Python-based fraud detection model, incorporating claim amount and subscription period.
- Created interactive Tableau dashboards to visualize fraud patterns and enable data-driven decision-making
- Identified high-risk claims, potentially saving $20,000+ annually in insurance payouts.
-
Cryptocurrency Analysis for MEME coins Dune, SQL - Designed real-time analytics dashboards on Dune, tracking key metrics across 1 M+ blockchain transactions.
- Conducted data-driven investigations into optimal trading hours and price volatility across BONK, POPCAT, and PNUT.
- Optimized SQL queries for on-chain data extraction and visualization, reducing processing time by 15%.
-
Chicago Crime Hotspot Analysis SQL, R, Tableau - Analyzed 1 MM+ police records using SQL and R to detect crime-prone zones and seasonal spikes.
- Applied Random Forest classification and correlation analysis to improve the prediction of hotspot zones.
- Built a precision-focused patrolling model that simulated an 18% gain in resource efficiency, supporting law enforcement.
🌱 Achievements and Volunteer Work
- Recognized by senior leadership for “Data-Driven Impact” in 2023, awarded for building an interactive hiring dashboard that streamlined applicant filtering for 3,000+ candidates and accelerated interview shortlisting across the support team.
- ‘Culture & Value Champion’ at Appointy (1 of 13 recognized) for fostering positive workplace culture.
- Volunteered in organizing a cultural immersion trip to Lake of the Woods, through Global Leaders of Orange and Blue Engagement (GLOBE), helping international students explore U.S. traditions and connect with the Champaign community.
- Part of Kinder foundation to teach English grammar to elementary school kids in rural India.