Jay Patel

Data Analytics

[email protected] +91 9664922783

Resume

Hello, I am

Jay Patel.

2

SQL
Projects

2

PowerBI
Projects

1

Excel
Project

1

Python
Project

About Me

Data-Driven analysts over 2 years efficiently transformed billions of database rows into actionable insights for C-level executives saving 40% cost using AWS Glue, AWS Redshift and AWS QuickSight with optimised queries and data management. Part of Adani Solar’s CEO team, working on 2024 financial budget preparation, saved ₹20 Cr+ by identifying planning failures & reducing non-moving inventory by 13%, Achieve 8x Faster decision for upper management with use of Power BI, SQL, Python, Excel & SAP.

Key Skills

AWS Redshift

AWS Quicksight

My Projects

Business 360 Dashboard Project

Domain/Function: Business

Hospitality Revenue insight Dashboard

Domain/Function: Hospitality Management

Market Analytics Year on Year

Domain/Function: Market Analysis

Supply Chain Accuracy Tracking Reports

Domain/Function: Supply Chain Management

Retail Performance Analysis

Domain/Function: Retail Analytics

Transforming P&L Data into Strategic Financial Insights

Domain/Function: Finance

My Experience

MyOperator – Data Analyst, COO’s Office Jun 2025 – Present

Data Analyst Noida, Uttar Pradesh

Transformed 4+ billion operational data rows from production databases into actionable business insights using AWS Glue and Redshift, directly empowering C-level executives with daily visual analytics and decision dashboards. (AWS Analytics)
Drove a 20% reduction in customer churn by leveraging Zoho Analytics to monitor account owner performance and optimize customer support strategies, resulting in higher retention and significant gaps closed in team operations. (Zoho Analytics)
Engineered, cost-saving AWS Cloud data pipeline, reducing data storage cost by 40% and freeing up 50% of storage over legacy solutions, while accelerating data refresh rates and improving data accessibility for the COO and CEO. (AWS Analytics)

Adani Solar – Analyst, Supply Chain Management (PPC) Jun 2024 – Jan 2025

Assistant Manager Mundra, Gujarat

Price Intelligence & Forecasting: Enabled smarter material buying by visualising raw material price forecasts in Power BI, increasing forecast accuracy by 22%. (Skills: Forecasting, Price Intelligence, Data Analytics, Power BI, Data Visualisation)
Real-Time material Insights & Product Grading: Reduced downtime by 9% and saved ₹1Cr+ by building a Power BI dashboard to visualize SAP material data and track hourly product grading. (Skills: SAP, Power BI, Data Analysis, Material Management)

Adani Solar – Business Analyst, CEO’s Office Jul 2023 – May 2024

GET| Senior Engineer| Assistant Manager Ahmedabad, Gujarat

Price Intelligence & Forecasting: Enabled smarter material buying by visualising raw material price forecasts in Power BI, increasing forecast accuracy by 22%. (Skills: Forecasting, Price Intelligence, Data Analytics, Power BI, Data Visualisation)
Real-Time material Insights & Product Grading: Reduced downtime by 9% and saved ₹1Cr+ by building a Power BI dashboard to visualize SAP material data and track hourly product grading. (Skills: SAP, Power BI, Data Analysis, Material Management)

Ford India – Inventory Analyst May 2022 – Jul 2022

Internship Sanand, Gujarat

Recovered ₹45 lakhs by identifying 1% non-moving inventory(of ₹45Cr) using ABC Analysis (Skills: Excel, Data Analysis)

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

The Joy of Computing using Python - NPTEL,IIT Madras

Team of the Month - Adani Solar

Ford India - Inventory Analyst

Data and AI Innovation

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/jay-patel-bba86a352/

Call Me

+91 9664922783

PowerBI Project

Business 360 Dashboard Project

Domain/Function: Business

Developed an interactive Power BI dashboard integrating data from Excel and SQL. Cleaned, transformed data with Power Query, used DAX for KPIs, and provided insights into revenue, sales, expenses, and more.

Other Tools

excel

sql

Financial dashboard showing net sales, gross margin, net profit trends, GM%, profit%, COGS, and segment-wise net profit insights.

Global sales overview with region-wise net sales on a map, trends by category, and customer performance with key metrics like GM%.

Project Details

Developed an interactive business dashboard using Power BI seamlessly integrating data from multiple sources including Excel and SQL databases. Cleaned, transformed, and modeled large datasets through Power Query, while utilizing DAX to create KPIs and financial metrics. The dashboard provided critical insights into revenue growth, sales forecasts, market share, operational expenses, and customer acquisition costs, enabling data-driven decision-making. Enhanced data visualization and performance tracking, delivering a comprehensive tool for optimizing business operations and financial performance.

Project video

Live Interactive Dashboard

PowerBI Project

Hospitality Revenue insight Dashboard

Domain/Function: Hospitality Management

Analyzed KPIs (revenue, occupancy, guest satisfaction) to optimize sales strategies. Explored revenue across cities, hotel types, and platforms, enhancing efficiency. Developed interactive Power BI dashboards.

Other Tools

Excel

Dashboard highlights KPIs for occupancy, revenue, and ratings, offering insights to improve performance and guest satisfaction across cities.

AtliQ Hospitality dashboard highlights key metrics by city occupancy, revenue, and ratings, identifying performance gaps and areas for improvement.

Project Details

This project revolves around using key metrics like revenue, occupancy, and guest satisfaction to provide insights that can help improve sales strategies. It includes a deep dive into revenue breakdowns across different cities, hotel types, and booking platforms to find opportunities for growth. Additionally, booking patterns, cancellations, and guest behavior are analyzed to improve operational efficiency and boost revenue. Interactive Power BI dashboards are created to visualize the data, with DAX used for modeling and analysis. Ultimately, the goal is to provide data-driven insights that help the team make informed decisions, streamline operations, and optimize financial performance.

Live Interactive Dashboard

SQL Project

Market Analytics Year on Year

Domain/Function: Market Analysis

This project focuses on advanced SQL techniques for finance analytics, covering user-defined functions, stored procedures, and generating detailed sales reports.

MySQL Workbench executing the "get_market_badge" procedure with inputs for market and fiscal year to return a badge(Gold,Silver).

Stored procedure "get_monthly_gross_sales_for_customer" is able to executing the customer code "70002018" to retrieve monthly sales data.

Project Details

it includes a series of modules that cover essential topics such as backlog grooming meetings for gross sales reports, user-defined SQL functions, and practical exercises to reinforce learning. Key components include generating monthly product transaction reports, calculating total sales amounts, and creating yearly sales reports. The project also delves into stored procedures, demonstrating their use in generating monthly gross sales reports and market badges, along with discussing the benefits of using stored procedures for efficiency and maintainability. This comprehensive approach equips users with the skills to leverage SQL for effective finance analytics and reporting, enhancing decision-making capabilities in financial contexts.

SQL Project

Supply Chain Accuracy Tracking Reports

Domain/Function: Supply Chain Management

Developed forecast accuracy reports and improved query performance with composite indexes and temporary tables, processing nearly two million rows for faster data retrieval.

Query: Selecting data from a specific table with a filter. Triggers: Events that automatically execute actions when specific data changes occur.

SQL query analyzes forecast accuracy using a CTE (Common Table Expression). Results shows customer code, name, market, sales, forecast, error metrix.

Project Details

• Developed forecast accuracy reports to track supply chain predictions versus actual outcomes, aiding in better decisionmaking.
• Enhanced query performance by utilizing composite indexes and temporary tables, resulting in faster data retrieval and
optimized system performance

Python Project

Retail Performance Analysis

Domain/Function: Retail Analytics

Developed a predictive model for retail sales analysis, incorporating exploratory data analysis (EDA) and achieving a 7.64% Mean Absolute Error, showcasing effective forecasting accuracy.

Other Tools

Excel

Jupyter Notebook

Weekly_Sales has a strong positive correlation with lagged variables and a negative correlation with Store. Holiday_Flag and Temperature show slight n

Retail sales analysis using predictive modeling and EDA, achieving a 7.64% Mean Absolute Error for accurate forecasting.

Project Details

Developed a predictive model for retail sales analysis, leveraging exploratory data analysis (EDA) to uncover trends and insights. The model achieved a Mean Absolute Error of 7.64%, demonstrating effective forecasting accuracy. By analyzing historical sales data alongside external factors such as temperature, fuel prices, and economic indicators, the project provided actionable insights for inventory management and sales strategies. This comprehensive approach not only enhanced understanding of sales patterns but also facilitated informed decision-making to optimize business performance in a competitive retail landscape.

Excel Project

Transforming P&L Data into Strategic Financial Insights

Domain/Function: Finance

Analyzed Profit & Loss (P&L) statements across multiple timeframes, enhancing financial reporting with Excel’s advanced features for improved insights and performance tracking.

Other Tools

Power Query

P&L data reveals regional profitability, identifies top products, and shows year-over-year trends in revenue and expenses for strategic insights.

The "Top 10 Products Sales" dashboard highlights sales trends for key products in 2020-2021, revealing significant growth for AQ Home Allin1 (6000%) a

Project Details

like the human way
ChatGPT said:
In this project, I analyzed Profit & Loss (P&L) statements across different time periods—years, months, and quarters—to improve financial reporting. I integrated financial data into a structured data model, making it easier to generate detailed reports that support strategic decision-making. Using advanced Excel features, I refined P&L reports for year-over-year and month-over-month comparisons, allowing stakeholders to spot trends and key performance metrics more efficiently. This project focused on delivering accurate insights into revenue and expenses, offering a clearer view of the company’s financial health. The end result was a series of dynamic reports that made it simpler for management to assess financial performance and make well-informed business decisions.