Ronak Patel

Hi, I'm Ronak Patel

Data Analyst | Product & Business Analytics | SQL • Power BI • Python • Tableau | Driving Growth through Data

Explore Projects Get In Touch

About Me

Ronak Patel

I’m Ronak Patel, a Data Analyst with 3+ years of hands-on analytics experience and 8+ years in finance and operations, helping organizations make smarter decisions through data across finance, IT services, Social commerce and business operations domains.

Proficient in SQL, Python (Pandas, NumPy), Power BI, Tableau, and Excel, I design interactive dashboards, build scalable ETL pipelines, and perform A/B testing and data analysis to uncover insights, track KPIs, and drive informed business decisions.

Backed by a PGDM in Finance, 8+ years in finance and operations, and 3+ years in data analytics, I combine business expertise with analytics to generate actionable insights that enhance performance, streamline operations, and drive strategic decisions.

I specialize in transforming complex datasets into actionable business insights by leveraging SQL, data modeling, and dashboard development to analyze trends, optimize workflows, and deliver clear, impactful visualizations for data-driven decision-making.

I’m actively seeking opportunities to collaborate with data-driven teams where I can leverage my analytics, dashboarding, and business insights expertise to deliver measurable impact and drive informed decision-making.

11+ Years Experience
PGDM Finance
30+ Projects

Featured Projects

Explore my data analysis projects showcasing expertise in Python, Power BI, SQL, and machine learning

IBM HR Analytics

Power BI Python Excel EDA
  • Analyzed attrition trends across departments and age groups
  • Created interactive dashboards with drill-down filters
  • Performed overtime-income correlation analysis using Python
View on GitHub

Uber Supply-Demand Gap

Python EDA Matplotlib Seaborn
  • Explored Uber ride request data to identify peak-hour gaps
  • Segmented data by city and time to detect cancellations
  • Recommended solutions to improve ride availability
View on GitHub

Superstore Sales Dashboard

Power BI DAX SQL Excel
  • Built advanced dashboard analyzing returns and profits
  • Used DAX for return rate KPIs and dynamic visuals
  • Implemented RLS for manager-specific views
View on GitHub

House Price Prediction (ML + Flask)

Python Flask scikit-learn Jupyter
  • Built regression model to predict house prices
  • Deployed using Flask with a user-friendly interface
  • Used numeric & categorical features for high accuracy
View on GitHub

Telco Customer Churn (Python)

Python EDA Classification Seaborn
  • Explored customer data to identify churn factors
  • Built predictive model using Python classification techniques
  • Visualized churn risk segments and retention insights
View on GitHub

Restaurant Sales Analysis

Python Seaborn Excel EDA
  • Analyzed sales trends across products and locations
  • Visualized peak ordering times and top categories
  • Suggested revenue improvement strategies
View on GitHub

Dubai Real Estate Dashboard

Power BI Excel Dashboard
  • Visualized Dubai housing prices and trends in Power BI
  • Enabled filtering by location, year, property type
  • Supported decision-making for real estate investment
View on GitHub

Portfolio Website

HTML CSS GitHub Pages
  • Built personal portfolio to showcase data projects
  • Hosted on GitHub Pages with clean navigation
  • Includes resume, contact and GitHub links
View on GitHub

AI Resume Analyzer

Python HTML Flask
  • AI feature to match resume with job descriptions
  • Built with Python logic and Flask backend
  • Helps job seekers optimize resumes with keyword insights
View on GitHub

AI Student Management System

Python Flask SQLite
  • Built AI-based CRUD student system for tracking performance
  • Used Python with SQLite backend and Flask for routing
  • Targeted for academic monitoring and feedback
View on GitHub

Higher Education SQL Project

SQL MySQL Education
  • Analyzed course enrollments and student outcomes
  • Wrote complex queries to find insights in education data
  • Structured datasets to support academic decisions
View on GitHub

Boston Housing Price Prediction

Python EDA scikit-learn
  • Developed regression model to predict housing prices
  • Used pandas and sklearn for preprocessing and training
  • Visualized price distribution and performance metrics
View on GitHub

Telco Churn – Power BI

Power BI Excel EDA
  • Analyzed churn behavior segmented by plans and tenure
  • Used Power BI filters and drill-through visualizations
  • Provided actionable KPIs to reduce churn
View on GitHub

Mental Health Survey EDA

Python EDA Seaborn
  • Analyzed survey on mental health and workplace stigma
  • Visualized key relationships across demographics
  • Recommended awareness programs for treatment support
View on GitHub

Retail Sales Response Analysis

Python Excel EDA
  • Explored regional sales data for promo effectiveness
  • Segmented response by product category & region
  • Offered actionable strategies to boost sales
View on GitHub

Online Retail II – E-Commerce

Python EDA Seaborn
  • Cleaned & analyzed large e-commerce transaction data
  • Segmented customers by order recency & frequency
  • Prepared data for cohort and RFM analysis
View on GitHub

Higher Education – Power BI

Power BI Excel EDA
  • Visualized course enrollment & performance by region
  • Used slicers & filters for institution/course insights
  • Built dashboards for education analyst decisions
View on GitHub

Superstore Sales Trend

Power BI DAX Excel
  • Tracked regional sales trends and profitability
  • Used DAX to calculate year-over-year growth
  • Created category-wise visual breakdowns
View on GitHub
View All Projects

Technical Skills

Proficient in modern data analysis tools and technologies

SQL

Advanced Queries

Power BI

Dashboard Design

Python

Data Analysis

Excel

Advanced Analytics

Tableau

Data Visualization

GitHub

Version Control

Git

Source Control

VS Code

Development

MySQL

Database Management

Jupyter

Notebook Analysis

PostgreSQL

Relational DB

Oracle SQL

Enterprise SQL

KPI Reporting

Business Metrics

Predictive Modeling

Forecasting

Data Cleaning

Preprocessing & Wrangling

Dashboard Design

Visual Analytics

Pandas

Data Manipulation

Matplotlib

Data Visualization

Seaborn

Statistical Charts

NumPy

Numerical Computation

EDA

Exploratory Analysis

A/B Testing

Experiment Analysis

Statistics

Data Interpretation

Storytelling

Insight Communication

ETL

Data Pipelines

Reporting

Stakeholder Insights

Professional Experience

11+ years of experience in finance operations and data analytics

Associate Data Analyst

LehLah Styling Pvt Ltd – Mumbai

Sept 2025 – Present

  • Developed and maintained 5 interactive dashboards using Tableau, improving KPI visibility and supporting data-driven decision-making.
  • Performed advanced data analysis using Excel (Pivot Tables, VLOOKUP, Power Query) to generate actionable insights from large datasets.
  • Conducted cohort analysis, A/B testing, funnel analysis, and customer behavior analysis, improving campaign performance and retention insights.
  • Extracted and transformed data using SQL queries, handling datasets with 500K+ records for reporting and dashboard integration.
  • Automated recurring reports using Excel and SQL, reducing manual effort and improving reporting efficiency by 25%.
  • Ensured data accuracy and integrity through validation, reconciliation, and quality checks across multiple data sources.
  • Collaborated with cross-functional teams to deliver data-driven insights and performance reports, enabling faster decision-making.

Data Analyst

Web Crypt Technology – Remote

Dec 2023 – Aug 2025

  • Collected, cleaned, and processed large datasets (500K+ records) using SQL, Excel, and Python (Pandas) to ensure data consistency and reliability.
  • Built and maintained 10+ Power BI dashboards, improving KPI tracking and reporting efficiency.
  • Wrote and optimized advanced SQL queries, improving data retrieval performance by 15–20%.
  • Performed data analysis and reporting using advanced Excel functions (Pivot Tables, VLOOKUP), supporting business operations and decision-making.
  • Improved reporting efficiency by 20% through dashboard automation and streamlined workflows.
  • Ensured data accuracy and integrity through validation, reconciliation, and quality checks across multiple data sources.

Data Analytics Intern

Web Crypt Technology – Remote

Jun 2023 – Dec 2023

  • Gained hands-on experience in end-to-end data analysis workflows, including data collection, cleaning, and transformation of 100K+ records.
  • Developed foundational skills in SQL, Power BI, and Excel for data extraction, analysis, and visualization.
  • Created 2+ interactive dashboards using Power BI to track KPIs and support business reporting.
  • Wrote SQL queries for data retrieval, aggregation, and basic data manipulation.
  • Assisted in delivering data-driven insights, improving reporting accuracy and workflow efficiency.

Team Lead – KYC Operations & Trading Desk

MarketWolf Securities Pvt. Ltd., Mumbai

Jun 2019 – Dec 2023

  • Managed KYC and compliance workflows for 35K+ clients per month with 100% accuracy.
  • Automated reporting using Excel macros, reducing workflow time by 40%.
  • Built dashboards to monitor risk, compliance, and operational KPIs, improving accuracy by 30%.

Operations Executive – Equity/Commodity/Currency

Angel Broking Ltd., Mumbai

Sep 2017 – Jun 2019

  • Executed and reconciled 100+ daily trades with 100% accuracy.
  • Built Excel MIS dashboards to track KPIs and improve reporting flow.
  • Supported 50+ sub-brokers and reduced trade discrepancy resolution time by 20%.

Trainee Dealer (FX Trader)

ValeurHR E-Solution Pvt. Ltd.

Aug 2015 – Jun 2017

  • Traded EUR/USD using technical analysis and price-action strategies.
  • Completed live trading training in Singapore under senior dealers.

Education

Post Graduate Diploma in Management (Finance)

ITM Business School

2015

Bachelor of Commerce (B.Com)

Mumbai University

2012

Certifications

Click on a certification to preview the certificate

Google Data Analytics

Coursera

IBM SkillsBuild Data Analytics

IBM

Career Essentials in Data Analysis

Microsoft & LinkedIn

Data Fundamentals with Capstone

IBM

Data Science

Infosys

Data Science & Analytics

HP Life

Power BI Visualization

Coding Ninjas

Tableau Visualization

Coding Ninjas

Basic to Advanced Microsoft Excel

Skill Nation

Let's Connect

Ready to collaborate on your next data project? Let's discuss how I can help transform your data into actionable insights.

Get In Touch

Email

ronakpatel171990@gmail.com

Location

Mumbai, Maharashtra, India

Available for

Remote & On-site Opportunities

Download Resume

Send Message