Aryan Tiwari

Aspiring Data Analyst | Electronics and Communication Engineer

LinkedIn | GitHub

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 Experience

Procurement ANALYST INTERN

BMW GROUP INDIA

Mar 2024 - Jun 2024

Gurugram, Haryana, IN

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

  • 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.

DATA ANALYST INTERN

ATAL INCUBATION CENTRE

Nov 2021 - Nov 2022

Greater Noida, Uttar Pradesh, IN

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

  • 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

ELECTRONICS AND COMMUNICATION ENGINEERING

SHIV NADAR UNIVERSITY

Aug 2020 - Jun 2024

Greater Noida, Uttar Pradesh, IN

Courses

  • Introduction to Data Science Using Python & R
  • Advanced-Data Structures
  • Relational Database Management System

Certificates

Data Analysis with Python

freeCodeCamp

Career Essentials in Data Analysis

Microsoft & LinkedIn

Scientific Computing with Python

freeCodeCamp

Python, Pandas, NumPy

Kaggle

Data Cleaning, Machine Learning

Kaggle

Projects

NEWSLETTER CUSTOMER ANALYSIS REPORT

Mar 2024 - Mar 2024

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

Nov 2023 - Nov 2023

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.

Awards

Python Gold Badge

HackerRank

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

Pandas Badge

LeetCode

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

PowerBI Badge

Microsoft Learn

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

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