HELLO!
I'm
Vikas Ratan

Engineer , Digital Marketer

Data Analytics Intern
file_type_excel2

6

Excel Projects

8

Power BI Projects

10

SQL Projects

15

Python Projects

About Me

With over 5 years of comprehensive experience in the field of data science & analytics, accompanied by a bachelor’s degree in engineering. Proficient in data analysis, statistical analysis, hypothesis testing, customer behaviour analysis, & machine learning. Demonstrated success in leading impactful projects and providing effective mentorship.

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

30+ Projects completed

Name: Vikas K Ratan

Job Role: Digital Marketer

Experience: 3 Years 3 Months

Address: Delhi, India

Skills

MS Excel
0 %
Power BI
0 %
SQL
0 %
Python
0 %

Experience

2021-Present

Digital Marketing Executive

Traveda Tour

Merkle, a leading CXM and media company with over 10K+ professionals globally. It’s a part of Dentsu International.

  • Analysed ad campaigns, clickstream, and customer surveys data, identified an increasing demand and launched a strategic product line.
  • Developed time series forecasting models to predict sales and optimize marketing budgets, got model performance of 92%.
  • Designed and executed A/B tests, performed rigorous statistical analysis. Led to 20% MoM increase in the conversion rate.

2018-2021

Digital Marketing Executive

Webologix Global Pvt. Ltd

Merkle, a leading CXM and media company with over 10K+ professionals globally. It’s a part of Dentsu International.

  • Analysed ad campaigns, clickstream, and customer surveys data, identified an increasing demand and launched a strategic product line.
  • Developed time series forecasting models to predict sales and optimize marketing budgets, got model performance of 92%.
  • Designed and executed A/B tests, performed rigorous statistical analysis. Led to 20% MoM increase in the conversion rate.

Education

2011-2015

Bachelor of Engineering

(VISVESVARAYA TECHNOLOGICAL UNIVERSITY)

Grade: First class distinction.

2009-2011

Higher Secondary School

(Sec. DPS Shahid Bhagat Singh Clny)

Grade: First class distinction.

PORTFOLIOS

LATEST PROJECTS

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

Sales and Finance Analytics

Crafted actionable insights through comprehensive sales and financial analytics in the FMCG sector. Empowered businesses with

See My Work

      

Sales and Finance Analytics

Crafted actionable insights through comprehensive sales and financial analytics in the FMCG sector. Empowered businesses with

See My Work

 

Sales and Finance Analytics

Crafted actionable insights through comprehensive sales and financial analytics in the FMCG sector. Empowered businesses with

See My Work

 

Sales and Finance Analytics

Crafted actionable insights through comprehensive sales and financial analytics in the FMCG sector. Empowered businesses with

See My Work

      

Sales and Finance Analytics

Crafted actionable insights through comprehensive sales and financial analytics in the FMCG sector. Empowered businesses with

See My Work

  

Sales and Finance Analytics

Crafted actionable insights through comprehensive sales and financial analytics in the FMCG sector. Empowered businesses with

See My Work

    

More projects on Github

I love to solve business problems & uncover hidden data stories

Contact Me

Below are the details to reach out to me!

Email

vikasratan9740@ gmail.com

Github

Projects

Contact No.

8709987683

Resume

Download CV

Sales and Finance Analytics
Excel Project

Crafted actionable insights through comprehensive sales and financial analytics in the FMCG sector. Empowered businesses with data-driven strategies for growth and expansion. Acquired proficiency in ETL, Power Query, Power Pivot, DAX, and user-centric report design.

Project Details

I made a sales report using Excel that helps businesses figure out good discounts for customers, talk better with them, and find new places to grow. The report gives advice on how to make sales better, make customers happier, and earn more money.

I learned to:

1. Use special tables in Excel
2. Work with data in a smart way
3. Do some basic math for data
4. Make things look pretty with colors
5. Make reports nice to look at
6. Know important sales numbers

This project is all about giving businesses the tools they need to watch, understand, and improve how they sell things. By looking at sales info, companies can find chances to do better, grow, and stay ahead in the changing market.