Ashish Awagan

Data Analyst

Pune 0+ yrs exp 86 · Excellent

About

Detail-oriented Data Analyst with hands-on experience in SQL, Python, MS Excel, and Power BI, including a 6-month internship analyzing 50,000+ record datasets. Skilled in data cleaning, exploratory data analysis (EDA), dashboard development, data visualization, and business reporting. Proven ability to transform raw data into actionable business insights through statistical analysis and stakeholder-ready reporting. Seeking an entry-level Data Analyst / SQL Analyst role to apply strong analytical thinking and data-driven decision-making skills.

Skills & Expertise (22)

SQL Intermediate

5.8/10

0.5

Years Exp

Python Intermediate

5.8/10

0.5

Years Exp

Pandas Intermediate

5.8/10

0.5

Years Exp

NumPy Intermediate

5.8/10

0.5

Years Exp

Matplotlib Intermediate

5.8/10

0.5

Years Exp

Data Cleaning Intermediate

5.8/10

0.5

Years Exp

Data Transformation Intermediate

5.8/10

0.5

Years Exp

Exploratory data analysis Intermediate

5.8/10

0.5

Years Exp

Jupyter Notebook Intermediate

5.8/10

0.5

Years Exp

Team Collaboration Intermediate

5.0/10

0.5

Years Exp

Analytical Thinking Intermediate

5.0/10

0.5

Years Exp

Problem Solving Intermediate

5.0/10

0.5

Years Exp

stakeholder communication Intermediate

5.0/10

0.5

Years Exp

VS Code Intermediate

5.0/10

0.5

Years Exp

MS Excel Intermediate

5.0/10

0.5

Years Exp

Business Reporting Beginner

4.5/10

0.5

Years Exp

MySQL WorkBench Beginner

4.5/10

0.5

Years Exp

Dashboard Development Beginner

4.5/10

0.5

Years Exp

Data Storytelling Beginner

4.5/10

0.5

Years Exp

Business Intelligence Beginner

4.5/10

0.5

Years Exp

Statistical Analysis Beginner

4.5/10

0.5

Years Exp

Power BI Beginner

4.5/10

0.5

Years Exp

Work Experience

Data Science Intern

Novartis Tech System

Oct 2025 - Mar 2026

Analyzed datasets containing 50,000+ records using Python and SQL, generating business insights that supported data-driven decision-making. Performed data cleaning, transformation, and preprocessing on large datasets, improving data quality and consistency for downstream analysis. Conducted Exploratory Data Analysis (EDA) using Pandas, NumPy, and Matplotlib to identify business trends, patterns, and anomalies. Wrote SQL queries (joins, subqueries, aggregations) and collaborated with a cross-functional team to deliver data solutions within project timelines.