ARUSHI NIGAM

Data/Business Analyst

arushinigam58@gmail.com+91-9811927642LinkedIn

Data analyst skilled in Power BI, SQL, and Python translating multi-source data into executive dashboards and strategic insights. Demonstrated impact through sales revenue tracking dashboards, VBA-automated KPI systems, and FMCG market-share analysis adopted in leadership strategy reviews. Proficient in DAX, advanced Excel, cohort analysis, and cross-functional requirement gathering—combining technical rigor with business acumen to drive data-driven decisions across revenue and market-share domains.

Experience

Social Media Content Intern

Pixstory Interface Network & IT (P) Ltd.

Jun 2023 – Jun 2023

  • Applied audience analytics to improve post interaction rates vs. baseline; awarded Certificate of Excellence for best performance across the intern cohort.

Business Development Intern

Avant-Garde

Feb 2022 – Apr 2022

  • Researched 3+ client segments; produced competitive-analysis reports adopted in leadership strategy reviews — mirroring consulting client-deliverable format.
  • Built a 15+ prospect pipeline tracker in Excel for senior stakeholder reporting; demonstrated requirement gathering, data organisation, and cross-functional collaboration in a live business environment.

Projects

Motorola Mobile Sales Dashboard

Jan 2026 – Feb 2026

Analysed ₹308M revenue across 1,514+ transactions; surfaced top 3 underperforming cities (~22% revenue shortfall) — enabling direct leadership action via a single-refresh executive dashboard with dynamic DAX measures.Modelled brand and city-level trends for Q3 stocking and pricing decisions; eliminated multi-hour ad-hoc reporting pulls through automated dashboard refresh.

Sales Executive Performance Dashboard

Dec 2025 – Jan 2026

Built a 4-view automated workbook with VBA navigation tracking Target Hit % and KPI performance across 8 cities — saved ~3 hrs/week in manual MIS reporting; flagged 2 outlier cities with >15% deviation for corrective action.

FMCG Market Share Analysis — Consulting Case Study

Feb 2026 – Mar 2026

Modelled Q1–Q4 market share shifts across 5 FMCG categories using Python (Pandas) and Tableau visualisations; delivered a 5-slide executive deck with pricing repositioning and SKU rationalisation — structured to Big 4 client-deliverable standard.

Education

Aryabhatta College, Delhi University

B.Com

2021 – 2024

KBD Public School, Ghaziabad

CBSE Class XII

2019 – 2021

Skills

BI & Visualisation
Power BI (DAX, Data Modelling, Slicers)TableauMIS ReportingExecutive DashboardsKPI Frameworks
Data & SQL
SQL (Joins, Subqueries, Aggregations)Power QueryETL PipelinesCohort AnalysisRoot-Cause Analysis
Excel & Automation
Advanced Excel (XLOOKUP, INDEX-MATCH, Pivot Tables, Power Pivot)VBA MacrosData Cleaning
Python
PandasNumPydata wranglingexploratory data analysismarket share modelling
Business Skills
Revenue AnalysisMarket Share AnalysisRequirement GatheringAd-Hoc ReportingCross-Functional Collaboration

Certifications

  • Deloitte Data Analytics Job SimulationDec 2025
  • SQL for Data Science
  • SQL & Relational Databases 101
  • Power BI
  • Microsoft Excel (Advanced)

Awards & Honors

  • 1st Position — North Zone-1 Chess Championship2019

    competed across 6 districts; demonstrates strategic thinking, pattern recognition and composure under competitive pressure.

  • 1st Position — Intercollege Chess Competition· Aryabhatta College2023
  • Certificate of Excellence· Pixstory Internship Cohort2023
Built withresumetrics
ARUSHI NIGAM · Resume | Resumetrics