YASH JAIN
Pune
Summary
Computer Science graduate with strong academic background and expertise in developing data-driven solutions. Proficient in Python, SQL, and AWS Cloud services, with a proven ability to analyze requirements and solve technical challenges. Experience as a Data Analyst Intern, identifying discrepancies and optimizing data sets for analysis. Delivered actionable reports based on thorough examination of data trends, contributing to team objectives.
Overview
1
1
Certification
Work History
Data Analyst Intern
U&D Square Solutions Pvt. Ltd.
Pune
07.2024 - 12.2024
- Performed exploratory data analysis (EDA) to identify trends, inconsistencies, and key insights supporting weekly and monthly business reports.
- Executed SQL queries to extract and analyze data from relational databases, enhancing clarity of reporting and analysis.
- Created interactive dashboards and visual reports using Tableau and Excel to track KPIs, facilitating informed management decision-making.
- Cleaned, validated, and structured large datasets using Excel (Pivot Tables, VLOOKUP/XLOOKUP) and SQL, improving data accuracy and reporting readiness.
- Utilized Python (Pandas, NumPy) for data cleaning, preprocessing, and basic analysis on structured datasets.
- Documented data workflows, validation checks, and reporting processes, ensuring consistency and minimizing recurring data errors.
Education
Bachelor of Science - Computer Science & Engineering
Gyan Ganga Institute of Technology And Sciences
Jabalpur, Madhya PradeshSkills
- Data analysis and visualization
- SQL and MySQL
- Python (Pandas)
- R programming
- Microsoft Excel (Pivot tables, VLOOKUP)
- DBMS concepts
- Report generation
- Data visualization
- Process optimization
- Problem solving
- Communication skills
- C
Certification
Google Data Analytics Professional Certificate
Programming Essentials in C, C++, and Python
Programming Essentials in C, C++, and Python
Projects
Sales & Customer Performance Analysis Dashboard
Excel, SQL, Python (Pandas), Tableau
• Analyzed a structured sales dataset to identify revenue trends, customer behavior patterns, and product performance across regions and time periods.
• Cleaned and transformed raw data using Excel and Python (Pandas) by handling missing values, duplicates, and inconsistent formats.
• Created interactive Tableau dashboards to visualize sales growth, top-performing products, and monthly performance trends for business insights.
• Presented actionable insights and recommendations based on data findings, aligning analysis with business decision-making objectives.
Accomplishments
Gold Medalist in Taekwondo (Inter-School Level, 2017), demonstrating high
levels of discipline, competitive focus, and commitment.
levels of discipline, competitive focus, and commitment.
Affiliations
Event Manager & Host (GGITS): Organized and managed college events, developing strong public speaking, coordination, and logistical planning skills.
Timeline
Data Analyst Intern
U&D Square Solutions Pvt. Ltd.
07.2024 - 12.2024
Bachelor of Science - Computer Science & Engineering
Gyan Ganga Institute of Technology And Sciences