Hello!

I'm Varun Rana



A Sales Analyst

Tableau GitHub

Name: Varun Rana

Job Role: Sales Analyst

Experience: 1 Year

Address: Jamnagar, India

Skills

Python 80%
Selenium 80%
Power BI 80%
Tableau 80%
Microsoft Excel 80%
SQL 80%

About

About Me

Results-driven Automation Testing professional with hands-on experience in Python and Selenium, skilled in designing, executing, and optimizing test cases to ensure software quality. Strong understanding of test automation frameworks and debugging. Additionally, possess working knowledge of Power BI, Excel, and SQL for basic data analysis and reporting support

  • Profile: Sales Analysis
  • Domain: Analysis & Automation Testing
  • Education: Masters of Science in Information & Technology
  • Language: English, Hindi, Gujarati
  • BI Tools: Microsoft Power BI & Tableau
  • Other Skills: Cisco Packet Tracer, SQL,& SEO
  • Interest: Traveling, Gaming, Treking

0 +   Projects completed

LinkedIn

Resume

Resume

With more than 1+ year expereience from providing backlinks as an SEO analyst to driving business strategies through data-driven insights. I have proven my expertise in analysis using google analytics, SQL, Tableau and project management.

Experience


PitchWorx

SEO Analyst

2022-2023, Gurgoan

PitchWorx founded in 2012 is one of the first Presentation Design Companies in India, it has designed 100,000+ slides designed for over 500 clients around the world in 10 years.

  • Performed in-depth research and analysis for keywords to rank the website in the Search Engine.
  • Delivered multiple Backlinks with high DA and PA and maintaining data in Excel sheet.
  • Performed Google Analytics and providing accurate data to the company. As well as keeping the record up to date.
  • Making Plagiarism-free content.

Ceat Shoppe

Sales Analyst

2025-Present

Providing neat and clean Data using Excel and Power BI in Ceat Shoppe

  • Managed daily Sales operations, ensuring accurate sales of tyres, accessories, and consumables using Excel-based tracking systems.
  • Utilized Microsoft Excel (Advanced Functions) for maintaining purchase records, billing, and real-time updates, including VLOOKUP, PivotTables, and conditional formatting.
  • Monitored most sold tyres when it comes to category



Education


2015-2018

Bachelors of Computer Application (BCA)

Saurashtra University

Grade: First class distinction.

2018-2020

Masters of Science in Information & Technology

CHARUSAT UNIVERSITY

Grade: 5.16 CGPA.

Download CV

Projects

Projects

Below are the sample Projects of Automation Testing using python as well as Data Analytics projects on Tableau and Power BI.

Automation Testing of SWag Labs

Developed an end-to-end web automation testing framework with Selenium and Python implementing POM architecture, explicit waits, assertions, and reusable page classes for SauceDemo testing.

Login Automation on Orange HRM

This project is a Selenium automation framework built using Python and the Page Object Model (POM) design pattern. It automates the login functionality of the OrangeHRM demo website and verifies whether the login is successful

British Airways Data Analysis using Tableau

Analyzed Travellers data using advanced methods of visualization to identify gaps and increase the business growth.

Data Analysis of Car Sales using Microsoft Power BI

Performed exploratory data analysis on Car sales and it resale value using Microsoft Power BI.

Data Analysis of Bike Accessories Sales using Tableau

Performed exploratory data analysis on Bike Accessories Store to know the customer experience around the globe.

Data Analysis of Disney+ using Power BI

Presenting the captivating Disney+ Dashboard—a dynamic hub featuring global IMDb ratings, an interactive map, genre breakdowns, trending titles, and a unique exploration of Metascore ratings both by genre and viewer ratings. Dive into the magic

Poojara Mobile Sales Dashboard Power BI

Experience the power of a dynamic mobile sales dashboard, where you can effortlessly track ratings, compare sell prices to original prices, and unveil exclusive discounts. Customize your view with intuitive filters by brand, memory, and storage to uncover the perfect device for you.


More projects on Github

I love to solve business problems & uncover hidden data stories


GitHub

Certificates

Certificates

Achivements from reputed firms.

Tata Group's Data Visualisation: Empowering Business with Effective Insights

Data Analytics Bootcamp by Alexander Freberg

PWC: Power BI Job Simulation

CCNA Network Fundamental Certificate

Edapt Ethical Hacking Certificate

Edapt Cyber Security Certificate


Contact

Contact Me

Below are the details to reach out to me!

Address

Jamnagar, Gujarat, India

Contact Number

+91 9924218084

Email Address

varunrana449@gmail.com

Download Resume

resumelink




  • Find me on