Jithin Raj B

Data Analyst in Sourcing and Inventory Management at Walkaroo International Pvt. Ltd.

[email protected] +91 8089648779

Resume

Hello, I am

Jithin Raj B.

5

PowerBI
Projects

About Me

Data Analyst passionate about transforming complex data into actionable insights that support business decisions and operational excellence. An alumnus of the College of Engineering Trivandrum and the National Institute of Technology Calicut, with a strong foundation in data analytics and problem-solving.

Currently working as a Data Analyst in Sourcing and Inventory Management at Walkaroo, focusing on analyzing sourcing, procurement, and inventory data to enhance efficiency and strategic planning.

Previously served as a Business Analyst at TinyZo Online, dealing with extensive e-commerce domain data and developing integrated dashboards for data-driven insights across multiple online platforms.

Proficient in Power BI, Excel, Power Query, SQL, PostgreSQL, and Python, with expertise in data visualization, data storytelling, and reporting.

Key Skills

Python

MS Word

SQL

MATLAB

Power BI

Power Point

Advanced Excel

Web Scrapping

My Projects

Amazon Advertisement Campaign Analysis

Domain/Function: Online Retail

Power BI Dashboard for Multi-Platform E-Commerce Sales Analysis

Domain/Function: Online Retail

Election Analysis

Business Insight 360

IPL Insights

My Experience

Walkaroo International Pvt. Ltd. Oct 2025 - Present

Coimbatore, Tamil Nadu, India (on-site)

Data Analyst in Sourcing and Inventory Management

TinyZo Online Pvt. Ltd. Jul 2024 – Oct 2025

Manjeri, Kerala, India (on-site)

• Automated monthly reporting process using advanced Excel techniques, including Power Query, reducing time and effort by 75%.

• Designed and implemented a SQL database connected through an on-premise gateway with Power BI services for

streamlined sales analysis.

• Integrated sales data from multiple e-commerce platforms (Amazon, Flipkart, Jiomart, Meesho, Tata 1 mg and Firstcry) into a unified dashboard, enabling faster insights and better decision-making.

• Over 4 years of sales data, exceeding 1 million rows, were analysed from various platforms, with data integrated across 20+ tables through efficient data modelling.

Freelance Subject-Matter Expert Jul 2021 – May 2024

TutorBin, Gurugram, India (Remote)

• Addressed 400+ global student queries in math, statistics, civil engineering, hydrology, programming, numerical, and analytical methods, achieving an expert rating exceeding 4.8 out of 5.

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/jithinrajb

Call Me

+91 8089648779

GitHub

https://github.com/Jithin-Raj-DataAnalyst

PowerBI Project

Amazon Advertisement Campaign Analysis

Domain/Function: Online Retail

An interactive Power BI dashboard to analyze Amazon Sponsored Product advertisement campaigns, offering actionable insights for optimizing advertising strategies.

It evaluates the performance of Amazon Sponsored Product ad campaigns, focusing on metrics like impressions, clicks, spend, sales, ROAS, and ACOS.

Slicers selected: Targeting and ROAS

Project Details

Power BI Interactive Dashboard for Analyzing Amazon Ad Campaign Performance

Reports Used: Data was downloaded from the Amazon Ads Console, including the Search Term, Targeting, Advertised Product, Campaign, Budget, and Placement Reports. These reports, spanning various periods, were extracted, transformed, consolidated, and loaded (ETL) using Power Query Editor in Power BI.

Key Metrics:
- Impressions: The number of times ads were displayed to users, indicating the reach of the campaigns.
- Clicks: The number of user interactions with the ads, reflecting engagement levels.
- Spend: The total amount invested in running the ad campaigns.
- Sales: The revenue generated from the campaigns, showcasing the effect
- ACOS (Advertising Cost of Sales): Measures the percentage of ad spend on sales. A lower ACOS indicates a more efficient campaign.
- ROAS (Return on Ad Spend): Evaluates the revenue generated for every spent on ads. Higher ROAS signifies better performance.

Live Interactive Dashboard

PowerBI Project

Power BI Dashboard for Multi-Platform E-Commerce Sales Analysis

Domain/Function: Online Retail

A comprehensive Power BI solution designed to consolidate sales data from multiple platforms, including Amazon, Flipkart, Meesho, Tata 1mg, JioMart, and FirstCry. The dashboard provides a unified view of performance metrics across over 25 brands and a diverse portfolio of unique products.

The Overall Performance page of the Power BI dashboard offers a consolidated snapshot of sales performance metrics across r e-commerce platforms.

The Overview page provides a detailed summary of sales performance across Amazon, Flipkart, and Meesho for each brand.

Project Details

A robust data visualization tool developed using Power BI, designed to streamline and consolidate sales analysis across major e-commerce platforms: Amazon, Flipkart, and Meesho. This dashboard provides a comprehensive overview of sales performance, operational costs, and profitability for different brands, each offering multiple unique products.
Features:
1. Platform-Specific Summaries:
Provides detailed metrics for each platform, including net quantity, net sales, gross settlement, ad costs, and net settlement
Breaks down performance across platforms.
2. Sales Trends Over Time:
Visualizes net payout and sales performance over fiscal years, months, and quarters.
Highlights revenue fluctuations and platform-specific contributions.

Live Interactive Dashboard

PowerBI Project

Election Analysis

This project contains an analysis of the Indian General Elections using Power BI. The study aims to explore various aspects of the elections, including voter demographics, voting trends, and election results.

View Project
Engagement

View Project
on GitHUB

The vote distribution of a political party in an election does not necessarily determine the number of seats won. A party could receive a significant

The BJP secured more than the majority margin of 272 seats in the 2014 and 2019 elections. In contrast, the trailing party, Congress, failed to

Project Details

Election Analysis:
A comprehensive study of the Indian General Elections using Power BI and Python.

This project dives deep into various aspects of the elections, such as voter demographics, voting trends, and results. The interactive Power BI dashboard offers insightful visualizations to explore the data deeply.
Key Insights:
Vote Distribution vs. Seats Won: A political party's vote share doesn't always translate into a proportionate number of seats.
Party Performance: The BJP's dominance in 2014 and 2019, and the resurgence of the Congress in 2024.

📊 Data Sources:
- Election Commission of India
- Wikipedia
- Other media sites

Tools Used:
- Python: Web scraping.
- Power BI: Data processing, creating interactive visualizations and dashboards.

Live Interactive Dashboard

PowerBI Project

Business Insight 360

Atliq is a hardware manufacturing company and it sells goods to different customers such as Croma, Best Buy, Staples, Flipkart and so on. These customers sell those goods to end consumers through online (E-commerce) as well as offline stores (Brick and Mortar). While their business grows substantial

View Project
on GitHUB

This executive view contains the overall summary of the performance of the Atliq hardware across the globe.

The Marketing view dashboard has the dynamics to visualise the marketing performance of the Atliq hardware products.

Project Details

The project highlights the profit and loss statement of the Atliq hardware across the globe.

Live Interactive Dashboard

PowerBI Project

IPL Insights

The sports blog company "Sports Basics" decided to release a special edition magazine on behalf of IPL 2024. To appease the audience, this magazine aims to generate interesting insights and facts from the last 3 seasons of IPL data.

View Project
on GitHUB

This dashboard is specifically used to analyse the performance of each player.

The top players as well as the teams are selected according to the statistics of the 3 seasons.

Project Details

Dashboard Link: https://app.powerbi.com/groups/me/reports/54306c8a-b3e7-4c46-8d92-84d640dee1a6/ReportSection4adb8e78e74a039522ae?experience=power-bi