Nimish Chhabra
Summary
Senior Business Analyst with 2+ years of experience in data analytics, SQL and Power BI. Expert in dashboard development, KPI reporting, data modeling and stakeholder management. Strong experience in building scalable BI solutions, optimizing SQL queries and translating business requirements into actionable insights.
Overview
2
2
years of professional experience
Work History
SENIOR BUSINESS ANALYST
EXL
12.2023 - Current
- Utilized SQL techniques including CTEs, database views, window functions and aggregate queries to centralize performance metrics, eliminate duplicated logic and surface monthly revenue growth trends directly in dashboards, reducing query development time by ~30% and manual Excel work by 50%.
- Developed 12 interactive Power BI dashboards tracking over 50 KPIs, decreasing report generation time by 40%, which enhanced decision-making and project alignment across business units within three months.
- Performed data modeling and ETL using Power Query and SQL joins, optimizing DAX measures and report performance for enterprise-scale datasets.
- Led end-to-end video production including storyboarding, screen recording and editing to create 10+ e-learning and promotional videos aligned with brand standards and scripted 5 multimedia learning modules that transformed complex content into bite-sized narratives, achieving a 90% learner satisfaction score from 800+ employees.
- Designed and launched 8 bespoke instructional courses in collaboration with 10+ SMEs to define 200+ learning objectives, increasing learner engagement by 28% and reducing onboarding time by 20%.
- Fostered client and stakeholder partnerships through weekly status briefings for gathering requirements, aligning project milestones with business goals.
Business Analyst Internship
American Express
06.2022 - 07.2022
- Led analytics for OptBlue partners, analyzing transaction and merchant data to inform acquisition and charge-volume strategies for 50+ partners.
- Developed channel-focused marketing strategies, prioritizing high-profit segments and driving growth potential.
- Utilized SQL to query and aggregate large datasets, then distilled insights into executive PowerPoint decks that accelerated data-driven decision-making by senior leadership.
- Built interactive Excel and Tableau dashboards, leveraging pivot tables, VLOOKUP and calculated fields to streamline reporting workflows cutting manual effort by 40% and reducing errors.
Sales and Marketing Internship
The Contrast
04.2020 - 06.2020
- Managed a region focusing on property dispute cases, converting over 10 leads and made over 40 sales calls, prospecting for new business and supporting representatives.
- Recognized by sales management for my ability to up-sell, resulting in approximately 200k rupees in additional revenue.
Education
MBA(BE) - Business Economics
Delhi University
Delhi07.2023
Skills
- SQL
- Power BI
- Dashboard design
- Video production
- Instructional design
- Data visualization
- Microsoft Excel and PowerPoint
- Stakeholder management
- Probability and statistics
- Data modeling
- Business requirements gathering
- Problem solving
Projects
Prediction of Corporate Culture using Natural Language Processing, University of Ottawa, Extracted the Q&A section only from the conference data to avoid the 'cheap talk' inside presentation section and applied word2vec model to obtain word vectors of seed words for each value like integrity, innovation, etc., Created a dictionary from the data based on the similarity with the obtained word vectors of seed words and computed naive, tf-idf, wf-idf scores of each firm for each corporate value & linked it to the financial performance.
Awards
Secured 98.54 Percentile in CAT 2020
Timeline
SENIOR BUSINESS ANALYST
EXL
12.2023 - Current
Business Analyst Internship
American Express
06.2022 - 07.2022
Sales and Marketing Internship
The Contrast
04.2020 - 06.2020
MBA(BE) - Business Economics
Delhi University