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, India07.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
Similar Profiles
ADRIANA CONFALONIERIADRIANA CONFALONIERI
Responsable de Calidad at ANALYTICAL TECHNOLOGIES- CENTRO DE ALTA TECNOLOGIA ANALITICAResponsable de Calidad at ANALYTICAL TECHNOLOGIES- CENTRO DE ALTA TECNOLOGIA ANALITICA
POOJA SHARMAPOOJA SHARMA
Team Lead- Content at Global Market Insights Pvt. Ltd.Team Lead- Content at Global Market Insights Pvt. Ltd.
JAYAPRAKASH JJAYAPRAKASH J
Senior Test Engineer at Blackbuck Insights Pvt Ltd (BBI)Senior Test Engineer at Blackbuck Insights Pvt Ltd (BBI)
Simran SSimran S
Travel Consultant at BCD TravelTravel Consultant at BCD Travel
Kannan LKannan L
Service Owner - Identity Global Products at AXA Global Business ServicesService Owner - Identity Global Products at AXA Global Business Services