Vikaas J

Data Aspirant

[email protected] +91 9019850099

Resume

Hello, I am

Vikaas J.

1

Excel
Project

1

PowerBI
Project

1

SQL
Project

1

Python
Project

About Me

Welcome to my portfolio! I’m an aspiring Data Analyst with a talent for extracting insights from data using tools like Excel, Power BI and Python. Currently, I work as a Senior Catalog Operations Specialist at Amazon, where I’ve spent 4.5 years mastering process management, developing standard operating procedures, leading operational programs, and analyzing data to drive improvements through root cause analysis.

Throughout my journey, I’ve discovered my passion for data analysis and its ability to influence decision-making. I’ve completed several business projects that highlight my analytical skills and dedication to process enhancement—projects you can explore in my portfolio below.

I’m excited about leveraging data to create meaningful impact and am eager to connect with opportunities where I can apply my expertise and enthusiasm for data-driven solutions. Let’s work together to turn insights into action!

Key Skills

Excel

Power BI

Operations Management

SQL

Python

stakeholder engagement

Project Management

SOP Development

My Projects

Sales Analytics (FMCG)

Domain/Function: Sales

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: Finance, Sales, Marketing and Supply Chain

Finance and Supply chain Analytics

Domain/Function: Finance and Supply chain.

Data Analysis in Hospitality Domain

Domain/Function: Hospitality Domain

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Python: Beginner to Advanced For Data Professionals

Data Analytics Essentials

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Mail Me

[email protected]

https://www.linkedin.com/in/vikaas-j-1679bb164/

Call Me

+91 9019850099

GitHub

https://github.com/Vikaasj

Excel Project

Sales Analytics (FMCG)

Domain/Function: Sales

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

View Project
Engagement

View Project
on GitHUB

Customer Performance Report: Provides net sales performance of each customer across years

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

In this project, I developed a sales report using Excel pivot tables to help businesses identify effective customer discounts, facilitate negotiations, and uncover potential expansion opportunities in promising markets. The generated reports deliver actionable insights and recommendations that enable businesses to optimize their sales strategies, improve customer satisfaction, and maximize revenue.

Here’s what I learned:

Pivot Tables
Power Query
Basic DAX
Conditional Formatting
Report Design
Sales Metrics

Overall, this project aims to equip businesses with the tools and insights needed to monitor, assess, and enhance their sales activities. By leveraging sales data analysis, companies can discover new opportunities, drive growth, and maintain a competitive edge in an ever-changing market.

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: Finance, Sales, Marketing and Supply Chain

AtliQ Hardwares is a rapidly growing consumer electronics company that struggles to compete effectively due to its reliance on Excel for reporting. My objective is to implement an advanced analytics solution using Power BI, enabling the company to gain valuable insights and make informed decisions.

View Project
Engagement

View Project
on GitHUB

User-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

Project Description:

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Live Interactive Dashboard

SQL Project

Finance and Supply chain Analytics

Domain/Function: Finance and Supply chain.

AtliQ Hardwares is a rapidly growing consumer electronics company that struggles to compete effectively due to its reliance on Excel for reporting. My objective is to implement an advanced analytics solution using SQL, enabling the company to gain valuable insights and make informed decisions.

View Project
Engagement

Performed joins between the tables and fetched records as per requirement. Created few temporary tables, CTE's , Stored Procedures and functions.

Compared the forecast accuracy by Fiscal years 2020 and 2021.

Project Details

🔹 Advanced SQL Techniques: Mastered subqueries, CTEs, views, and temporary tables for efficient data handling.
🔹 ETL & Data Warehousing: Gained expertise in ETL processes, data warehouses, and OLAP vs. OLTP systems.
🔹 SQL Optimization: Learned to create user-defined functions and stored procedures for better code reusability and performance.
🔹 Window Functions: Explored OVER, ROW_NUMBER, RANK, and DENSE_RANK for advanced analytics.
🔹 Data Engineering Essentials: Studied indexes, triggers, events, and user account management.
🔹 Hands-on with Large Datasets: Worked with real-world data (>1M records) in an industry-style project.

Python Project

Data Analysis in Hospitality Domain

Domain/Function: Hospitality Domain

Atliq Grands, a hotel chain, was facing growing competition, leading to a decline in revenue and market share. The goal of this project was to analyze booking trends, revenue patterns, and customer behavior to provide data-driven insights for strategic decision-making and business growth.

View Project
Engagement

View Project
on

This are some snaps of the Jupyter Notebook

Project Details

Atliq Grands faced growing competition, leading to a decline in revenue and market share. This project aimed to analyze booking trends, revenue patterns, and customer behavior to provide data-driven insights for strategic decision-making. Key tasks included data cleaning to ensure accuracy, data transformation by introducing occupancy percentage for better comparisons, and exploratory data analysis. Key findings revealed occupancy trends, peak booking periods, seasonal revenue variations, and platform-wise performance. These insights helped optimize pricing, enhance customer retention, and refine marketing strategies. By leveraging Python (NumPy, Pandas, Matplotlib, Seaborn), this project enabled Atliq Grands to make informed decisions, boosting profitability and sustaining a competitive edge in the hospitality industry.