Summary
Work History
Education
Skills
Certification
Languages
Project
Timeline
background-images
AMBIKA CHAUHAN

AMBIKA CHAUHAN

Shimla

Summary

Analytical and detail-oriented professional skilled in Excel (Basic to Advanced), SQL Server, and Power BI. Completed multiple certifications in business analytics, data visualization, and problem-solving. Experienced in designing dashboards, automating reports, and supporting data-driven decision-making. Passionate about turning data into actionable insights to support business growth.

Work History

Data Visualization: Empowering Business with Insights

Tata Consultancy Services
11.2025 - Current
  • Created executive-ready data visualizations to support leadership decision-making.
  • Forage Simulation

Data Analytics Intern

Deloitte Australia
11.2025 - Current
  • Built Tableau dashboards and used Excel to classify data for business conclusions.
  • Forage Simulation

Data Analytics Intern

Quantium
11.2025 - Current
  • Analyzed transaction datasets to deliver customer insights and commercial recommendations.
  • Forage Simulation

Data Analyst Intern

Oasis Infobyte
10.2025 - Current
  • Applied Python (NumPy, Pandas) for EDA and built visualizations to identify sales trends.
  • Virtual Internship

Finance, Controlling & Analysis Intern

Reliance Jio Infocomm Ltd.
06.2019 - 07.2019
  • Automated Excel workflows and supported financial reporting, improving dashboard accuracy for management.

Education

Bachelor of Commerce (Hons) -

Shoolini University of Biotechnology and Management Sciences
Solan, H.P.
01.2020

Skills

  • Microsoft SQL Server
  • Power BI
  • Tableau
  • Advanced Excel
  • Python
  • NumPy
  • Pandas
  • Matplotlib
  • Seaborn
  • Exploratory Data Analysis (EDA)
  • KPI Reporting
  • Dashboard Design
  • Data Modeling
  • DAX
  • Advanced DAX
  • Financial Planning & Analysis (FP&A)
  • Statistics
  • Forecasting
  • Business Strategy
  • Workflow Mapping
  • Business Analyst Practices
  • Requirements gathering
  • Stakeholder communication
  • Documentation
  • Data Storytelling
  • Visualization
  • Problem-Solving
  • Decision-Making
  • Data Analysis with ChatGPT
  • Microsoft Copilot

Certification

  • Advanced Excel
  • Microsoft SQL Server
  • Microsoft Power BI (Foundations & Advanced DAX)
  • Python for Data Science (NumPy, Pandas)
  • Tableau
  • Data Analysis with ChatGPT
  • Business Analyst
  • FP&A
  • Statistics
  • Business Strategy
  • Creative Problem Solving & Decision Making

Languages

English
Hindi

Project

https://github.com/ambikachauhan0501-eng/Retail_Sales_Performance 

Retail Sales Performance Dashboard (SQL + Power BI) 

Cleaned and modeled retail dataset into star schema for accurate KPI tracking

https://github.com/ambikachauhan0501-eng/OIB-SIP__EDA_on_Retail_Sales_Data 

EDA on Retail Sales Data (Python, Pandas, Power BI) 

Performed end‑to‑end data cleaning, statistical analysis, and visualization on retail sales dataset

https://github.com/ambikachauhan0501-eng/OIB-SIP_cleaning_data 

Data Cleaning (Python, Pandas) 

Cleaned messy datasets by handling missing values, duplicates, and outliers

https://github.com/ambikachauhan0501-eng/TATA_FORAGE_INTERNSHIP_Retail_Sales_Insights 

Built interactive dashboards in Tableau  showing revenue trends, top countries/customers, and product demand

Timeline

Data Visualization: Empowering Business with Insights

Tata Consultancy Services
11.2025 - Current

Data Analytics Intern

Deloitte Australia
11.2025 - Current

Data Analytics Intern

Quantium
11.2025 - Current

Data Analyst Intern

Oasis Infobyte
10.2025 - Current

Finance, Controlling & Analysis Intern

Reliance Jio Infocomm Ltd.
06.2019 - 07.2019

Bachelor of Commerce (Hons) -

Shoolini University of Biotechnology and Management Sciences
AMBIKA CHAUHAN