Name: Abhinandan Kumar

Job Role: Data Analyst

Experience: 3 Years +

Address: Gurugram, Haryana

Skills

Excel 90%
SQL 85%
Power BI 80%
Google Analytics 90%
PYTHON 65%

About

About Me

Passionate MIS/Data Analyst with expertise in Excel, SQL, and Power BI. Skilled in deriving actionable insights from complex datasets and automating processes with Python. Committed to driving data-driven decisions and optimizing business strategies. Open to collaborations and new opportunities in the data realm.

  • Profile: Data Analyst
  • Domain: Retail, Market Research & Digital Marketing
  • Education: Bachelor of Computer Application
  • Language: English, Hindi
  • BI Tools: Microsoft Power BI, SSMS & Tableau
  • Other Skills: Google Analytics, Web Master & SEO
  • Interest: Traveling & Learning

0 +   Projects completed

LinkedIn

Resume

Resume

Data Analyst with 3+ years of experience driving business strategies through data-driven insights. Proven expertise in MS Excel, statistical analysis, SQL and Data Visualization.

Experience


Jan'24-Present

Sr. MIS Executive

Vivo Mobile India

Vivo Mobile India provides the best smartphones and services in India since 2014.

  • Data Collection: Proficient in extracting and managing data from website databases using SQL queries, ensuring a reliable foundation for analysis.
  • Daily Tentative Reports: Successfully implemented a system for providing daily tentative reports on the productivity of VBA promoters, tracking their performance against monthly targets in the sale of Vivo mobile phones.
  • Cost Analysis: Executed comprehensive cost analysis reports, offering insights into financial efficiency and areas for improvement.
  • Forecasting: Utilized historical data to prepare forecasting reports, aiding in anticipating trends and making proactive business decisions.
  • Monthly Dashboard: Developed and maintained a monthly dashboard using Power BI, offering a holistic view of the sales team's performance, including target achievement, growth, and comparisons with previous months.

April'23-Dec'23

Digital Marketing Analyst

IMARC Group

The IMARC Group is a leading advisor on management strategy and market research worldwide.

  • Applied Excel for data cleaning, analysis, and reporting, presenting findings to stakeholders in an accessible manner.
  • Managed a team of marketers and oversaw the day-to-day operations of the marketing department
  • Utilized data analytics tools to track and measure the performance of digital marketing campaigns, optimizing strategies based on insights.
  • Drove traffic to the company's website and generated leads.
  • Managed a team of marketers and oversaw the day-to-day operations of the marketing department.
  • Stayed up-to-date with the latest trends and best practices in digital marketing.



Education


2017-2020

Bachelor of Computer Application

Arka Jain University

Grade: First class distinction.

2015-2017

Higher Secondary School

Holy Cross School

Grade: First class distinction.

Projects

Projects

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

Road Accident Dashboard Using MS Excel

Analyzed Road Accident Dashboard for year 2021 and 2022 using MS Excel so that they can have insight on the below requirements.

Data Analysis using Python Project for Beginners

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

Power BI Sales dashboard Project for Beginners

Designed a power bi dashboard for Madhav Store to track and analyze the online sales data acorss India.


Sales Forecast- Time Series Forecasting

Used multiple machine learning models to forecast sales (retail store) and performed time series analysis.

Customer Segmentation using clustering model

Developed a ML model to give various recommendations of financial products & services on target customer groups.

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

Gurugram, Haryana

Contact Number

6201455106

Download Resume

resumelink



Have a Question? Click Here