Namaste!

I'm Sanya Rastogi



A Data Analyst

Know Me My works

Name: Sanya Rastogi

Job Role: Data Analyst

Experience: 4 Months

Address: Ghaziabad, India

Skills

SQL 80%
PYTHON 65%
POWER BI 70%
ADVANCED EXCEL 70%

About

About Me

Recent MCA graduate skilled in utilizing tools such as SQL, Python, Advanced Excel, and Power BI. Proficient in data collection, meticulous data cleaning, insightful data analysis, and data visualization.

  • Profile: Data Science & Analytics
  • Education: Master of Computer Applications
  • Language: English, Hindi
  • Other Skills: Artifical Intelligence, Machine Learning, Gen AI
  • Interest: Reading, Volunteering, Gardening

0 +   Projects completed

LinkedIn

Resume

Resume

As a recent MCA graduate passionate about data analysis, I'm ready to leverage my skills in SQL, Python, and Power BI to drive success in a dynamic environment. With a strong foundation in data visualization and database management, I aim to contribute immediately in a data analyst role, enhancing business insights and decision-making processes."

Resume

Experience


Sept 2023-Dec 2023

Data Analyst Intern

KultureHire
  • Analyzed the collected Gen Z data and extracted valuable insights through Joins and Aggregate Function in SQL.
  • Utilized Google forms to gather information about the career goals and learning preferences of Generation Z.
  • Created dashboards in Excel utilizing Pivot Charts and used Slicers to filter the sales data in domains like sales, customer relations, and finance.
  • Designed interactive and dynamic dashboards, reports, and user interfaces using Excel and Power BI features for enhanced data visualization.



Education


2021-2023

Master of Computer Applications

Specialization in AI/ ML
KIET Group of Institutions
2017-2020

Bachelor of Science

Specialization in Mathematics
University of Allahabad

Download CV

Projects

Projects

Below are the sample Data Analytics projects on SQL, Python, Power BI & Excel

Strategic Marketing for Personal Loans using SQL

Analyzed bank personal bank data using advanced SQL queires and python to boost campaign success, trim costs, and strengthen customer retention, leading to increased revenue growth.

Hotel Booking Data Analysis using Python

Performed exploratory data analysis on hotel booking data using Python to minimize cancellation rates and enhance revenue generation efficiency.

HR Analytics Dashboard using Power BI

Designed a Power BI dashboard for HR Analytics, pinpointing factors behind organizational attrition and offering actionable retention insights.


Fashion Store Data Analysis using Excel

Created the 2023 annual sales report for a Fashion Store using Excel to help the store understand its customers and drive increased sales in 2024.

Iris Flower Classification using Machine Learning

Utilized K-Nearest Neighbour and Support Vector Machine models to predict the flower types based on their distinct features.

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

Noida, Uttar Pradesh, India

Contact Number

+91 xxxxx xxxxx

Email Address

rastogi.sanya28@gmail.com

Download Resume

resumelink



  • Find me on