Aryan Tiwari

Aspiring Data Analyst | Electronics and Communication Engineer
Gurugram, IN.

About

Highly motivated Electronics and Communication Engineering student with practical experience in data analysis, committed to leveraging quantitative skills to drive data-driven decision-making. Proven ability to apply Python, SQL, and Power BI to streamline data processes, generate actionable insights, and contribute to significant improvements in areas such as customer churn reduction and inventory management. Eager to apply analytical expertise in a challenging data-focused role within the technology or consulting sector.

Work

BMW GROUP INDIA
|

Procurement ANALYST INTERN

Gurugram, Haryana, India

Summary

Optimized procurement processes through rigorous data quality initiatives, robust database management, and insightful data visualization to enhance operational efficiency and decision-making.

Highlights

Implemented Python-based data validation checks, significantly improving data accuracy and integrity for critical procurement processes.

Applied MySQL database concepts to enhance data organization and optimize query performance, substantially improving data accessibility and retrieval efficiency.

Developed and deployed dynamic Power BI and Excel dashboards, showcasing procurement data across departments and vendors to enable proactive tracking of expiring contracts and necessary actions.

ATAL INCUBATION CENTRE
|

DATA ANALYST INTERN

Greater Noida, Uttar Pradesh, India

Summary

Provided critical data-driven insights to the startup ecosystem through comprehensive financial and performance analysis, streamlining data processes, and developing key metric visualizations.

Highlights

Analyzed startup performance and financial data using Python, SQL, and Excel, contributing to data-driven insights that informed strategic team decisions.

Streamlined data transformation processes, reducing data preparation time and improving report accuracy for critical business intelligence.

Designed and implemented Power BI dashboards to visualize key metrics, including ROI potential and market opportunities, directly supporting organizational decision-making processes.

Generated comprehensive reports on startup performance and market opportunities, increasing visibility for promising ventures among potential investors.

Education

SHIV NADAR UNIVERSITY
Greater Noida, Uttar Pradesh, India

Bachelor of Technology

ELECTRONICS AND COMMUNICATION ENGINEERING

Courses

Introduction to Data Science Using Python & R

Advanced-Data Structures

Relational Database Management System

Awards

Python Gold Badge

Awarded By

HackerRank

Achieved gold badge recognition for advanced Python programming skills on HackerRank.

Pandas Badge

Awarded By

LeetCode

Earned LeetCode badge for proficiency in data manipulation and analysis using the Pandas library.

PowerBI Badge

Awarded By

Microsoft Learn

Recognized by Microsoft Learn for expertise in Power BI data visualization and business intelligence.

Certificates

Data Analysis with Python

Issued By

freeCodeCamp

Career Essentials in Data Analysis

Issued By

Microsoft & LinkedIn

Scientific Computing with Python

Issued By

freeCodeCamp

Python, Pandas, NumPy

Issued By

Kaggle

Data Cleaning, Machine Learning

Issued By

Kaggle

Skills

Data Analysis & Visualization

Python, SQL, R, Excel, Power BI, DAX, Power Query, Looker, NumPy, Pandas, Matplotlib, Data Cleaning, Machine Learning, Time Series Analysis, Customer Segmentation.

Programming & Development

VBA, HTML/CSS, JavaScript.

Database Management

MySQL, PostgreSQL.

Version Control

Git, GitHub.

Cloud Platforms

Google Cloud Platform.

Projects

NEWSLETTER CUSTOMER ANALYSIS REPORT

Summary

Developed a comprehensive customer behavior analysis system, integrating robust data quality procedures, predictive modeling, and dynamic dashboards to effectively reduce churn and provide actionable insights for strategic decision-making.

E-COMMERCE ANALYTICS

Summary

Conducted in-depth e-commerce data analysis, encompassing data integration, customer segmentation, and time series forecasting, to optimize marketing strategies and enhance inventory management efficiency.