Hello!

I'm Ayush Rana



Engineering Student

Instagram My works

Name: Ayush Rana

Role: Engineering Student

Experience: 2 months

Address: Delhi, India

Skills

SQL 80%
PYTHON 75%
Data Visualization 70%
Statistical Analysis 80%
Data Structures and algorithms 60%

About

About Me

Hello guys , I'm Ayush Rana i am pursuing my B.Tech in electronics and communication engineering from NSIT. I completed my internships in DRDO as research trainee, MAC'N'TOS technologies as Data Analyst and Business Analyst in Internselite Edutech pvt.ltd

  • Profile: Data Science, Business Analyst & Analytics
  • Domain: Retail, Ecommerce, & Digital Marketing
  • Education: Bachelor of Engineering
  • Language: English, Hindi
  • BI Tools: Microsoft Power BI, & Tableau
  • Other Skills: Cloud, PySpark, Excel, Git, Google Analytics & SEO
  • Interest: Traveling, Gyming, Travel , Farming

0 +   Projects completed

LinkedIn

Resume

Resume

Currently , a fresher applying for Data Analyst, business analyst role with 0-1 years of experience . Proven expertise in data science, statistical analysis, machine learning algorithms and project management.

Experience


June'24-July'24

Research trainee

DRDO

DRDO ( Defense Research and Development Organisation)

  • Revamped the graphene production rate by 15% through optimization of synthesis parameters.
  • Optimized graphene mechanical strength, contributing to a 10% increase in durability.

May'24-June'24

Business Analyst

Internselite Edutech Pvt.Ltd

Internselite

  • Managed clients high-volume accounts receivable with a 95% collection rate, 20% reduction in outstanding.
  • Accomplished successful payment discussions by reviewing data through Excel, resolved disputes efficiently, and optimized invoicing which reduced overdue claims receivable accounts by 35% and 15% increase in on-time payments.

May'2023

Data Analyst

Mac'N'TOS

Mac'N'Tos a graphic designing and printing company highly advnaced printing machines for the purpose of complex printing.

  • Performed in-depth market research and analysis to create online pages. Resulted in ~100% website growth and 30% increase in conversion rate YoY.
  • Delivered multiple training and mentorship sessions on analytical tools like SQL, MS Excel, Power BI, Tableau and Python.
  • Performed migration and enhancements for merchandising dashboard, involved data integration and its feature improvement.



Education


2021-2025

Bachelor of Technology

Netaji Subhas University of Technology( NSIT / DIT )

Grade: 7.38 CGPA

2020-2021

Higher Secondary School

BVM Public School

Grade: 95.00%

Download CV

Projects

Projects

Below are the sample Data Analytics projects on SQL, Python, Tableau & Advanced Excel.

Clothing Superstore Sales Analysis

Developed a interactive dashboard to give analysed trends of sales, products & based on annual.

Data Analysis using Python Project

Performed exploratory data analysis on diwali sales data using Python to improve the customer experience.

Tableau Dashboard for EV Sales Analysis

Designed a Tableau dashboard for Electric vehicle to track and analyze the sales data acorss world.


0 Achievements
0 Projects
0 Age
0 Certifications

More projects on Github

I love to solve business problems & uncover hidden data stories


GitHub

Contact

Contact Me

Below are the details to reach out to me!

Address

Najafgarh,Delhi,India

Contact Number

+91-9013200773

Email Address

conctact@ayushrana3101@gmail.com

Download Resume

resumelink



Have a Question? Click Here


  • Find me on