Hello, I'm

Ojas
Chaurasia

Data Analyst — turning data into decisions

Get in Touch Download Resume
Ojas Chaurasia

About Me

Data-driven Data Analyst and Computer Science Graduate with experience at AppZen and KPMG. Skilled in Python (Pandas, NumPy, Seaborn, Matplotlib), SQL, Power BI, Tableau, and AWS. Proven ability to enhance efficiency, develop KPI dashboards, and deliver data-driven insights that improved business outcomes by 30%.

Skills

Programming & Databases

PythonSQL

Data Visualization & BI Tools

Power BITableauApache SupersetAmazon QuickSightExcelAWS Redshift

Core Competencies

Data CleaningData ModelingKPI AnalysisStatistical AnalysisData StorytellingBusiness IntelligenceETLCollaboration

Experience

Data Analysis & Research Intern

AppZen • Pune • Mar 2024 – Jan 2025

  • Examined 10,000+ Zendesk and JIRA support-ticket records to identify recurring issues, improving chatbot accuracy and reducing response time by 30%.
  • Developed 5+ live dashboards in Apache Superset visualizing KPIs across expense and AAP data for internal and client teams.
  • Migrated dashboard suite to Amazon QuickSight, optimizing load times by 40% and enhancing stakeholder accessibility.
  • Utilized Amazon Redshift SQL for advanced querying, enabling faster data retrieval and real-time analytics.

Data Analytics Consulting Intern

KPMG • Remote • Apr 2023 – Jun 2023

  • Cleaned and modeled 100K+ customer records using Excel and Python, uncovering key behavioral insights by demographics and purchase history.
  • Identified 3 high-value customer segments, driving a simulated 15% increase in engagement through retention strategy recommendations.
  • Launched user-friendly Power BI and Tableau dashboards that visualized complex purchasing trends; empowered 20+ stakeholders with actionable insights.

Projects

Walmart Sales Analysis

Conducted EDA on 45K+ sales records using Python to identify trends, holiday impacts, and pricing patterns, boosting forecast accuracy by 20%. Created KPI dashboards and visualizations in Power BI and Matplotlib to highlight regional sales trends, driving data-driven decisions and 15% strategy gains.

Yulu Bike Sharing Dashboard

Performed EDA on 30K+ ride records using Python to uncover trip, user, and demand patterns. Designed dashboards and KPIs to optimize bike distribution and peak-hour allocation, boosting forecast accuracy and operational efficiency by 15%+.

AeroFit Treadmill Customer Analysis

Executed EDA on 5K+ customer profiles using Python to uncover correlations between demographics and treadmill usage. Constructed data visualizations and KPIs that guided product positioning and boosted marketing precision by 22%.

Netflix Content Analysis

Established EDA on 8.8K+ Netflix titles to analyze trends in movies and TV shows by genre, rating, release year, and country. Provided actionable insights for content strategy optimization, highlighting content distribution and audience focus.

Education & Certifications

B.Tech – Computer Science

JECRC University, Jaipur (Rajasthan) | GPA 8.48 | Nov 2020 – Jul 2024


Class XII – CBSE

Indira National School, Pune | 73.4% | Apr 2019 – Apr 2020


Class X – CBSE

Indira National School, Pune | 80.4% | Apr 2017 – Apr 2018

Certifications

  • Scaler Skill Mastery – Python Libraries
  • Scaler Skill Mastery – EDA Fundamentals
  • Udemy 2021 Complete Python Certification
  • The Complete AI Guide: Learn ChatGPT, Generative AI & More

Contact Me

Let's turn your data into decisions.