Summary
Overview
Work History
Education
Skills
Websites
Certification
Achievements And Extracurricular Activities
Timeline
Generic
ADITI DWIVEDI

ADITI DWIVEDI

Business Analyst
Bangalore

Summary

Proactive Business Analyst adept in SQL, Excel, Power BI, and Tableau, delivering impactful insights and driving business success through synergistic team efforts.

Overview

2
2
years of professional experience
1
1
Certification

Work History

Business Analyst

Analitica Insights Pvt Ltd
Bangalore
04.2024 - Current
  • Automated 60–70% of recurring performance reporting (sales, transactions, check size, regional, category, demographic, marketing, and competitor benchmarks) using SQL, Excel, Tableau, and Power BI, increasing reporting efficiency and enabling deeper analysis.
  • Freed bandwidth for 30–40% deep-dive analysis on growth drivers and draggers, with insights directly presented to the client’s leadership.
  • Delivered a menu design strategy impact analysis (two format types), enabling the client to prioritize the stronger design, discontinue the less effective one, and inform strategic decisions by the leadership team.
  • Conducted a granular dayparts and regional performance study, integrating trend, market, and promo data to isolate the drivers of a 10% sales decline, with results adopted by the client’s leadership.

Intern

10.2023 - 03.2024
  • Developed competitor pricing intelligence reports that guided item-level price increases, enabling the client to optimize pricing without significantly impacting footfall, or sales.
  • Built a VBA-enabled Excel tool with hierarchical access controls, ensuring secure, role-based sharing, and reducing reporting turnaround time by 90%.
  • Utilized SQL, Excel, Power BI, and PowerPoint to prepare and analyze datasets, uncovering actionable business insights for client reporting and decision-making.

Education

B.Tech. - Computer Science and Engineering

Lovely Professional University
Phagwara, India
07.2024

Skills

  • Data prep, modeling, automation, web scraping: Excel, SQL, and Python programming
  • Presentation: PowerPoint
  • Data visualization tools: Tableau, Power BI
  • Microsoft Azure cloud services

Certification

  • Cloud Bootcamp, 2023, GFG
  • SQL Masterclass: SQL for Data Analytics, 2022, Udemy
  • Google Data Analyst, 2021, Coursera
  • Python and R with Data Visualization, 2020

Achievements And Extracurricular Activities

  • 5-star rating in SQL, HackerRank
  • Special recommendation, UNFCCC, Delegate of Norway, MHMUN

Timeline

Business Analyst

Analitica Insights Pvt Ltd
04.2024 - Current

Intern

10.2023 - 03.2024

B.Tech. - Computer Science and Engineering

Lovely Professional University
ADITI DWIVEDIBusiness Analyst