Ronak Patel

Hi, I'm Ronak Patel

Data Analyst | Ex-Finance Operations Lead | Turning Data into Business Insights

Explore Projects Get In Touch

About Me

Ronak Patel

I’m Ronak Patel, a Data Analyst with 8+ years of finance experience and strong hands-on analytics expertise across transportation, retail, healthcare, and real estate domains.

Skilled in SQL, Python (Pandas, NumPy), Power BI, Tableau, and Excel, I have experience building interactive dashboards, developing ETL pipelines, conducting A/B testing, performing data modeling, predictive analytics, and KPI reporting to support data-driven decisions.

With a PGDM in Finance and over 9 years of industry experience, I bring a business-first mindset to analytics—focusing on insights that improve performance, efficiency, and strategic decision-making.

I specialize in transforming complex datasets into actionable business insights by analyzing trends, optimizing data pipelines, and delivering clear, impactful visualizations.

I’m currently seeking opportunities to collaborate with forward-thinking teams and create meaningful impact through data-driven solutions.

9+ 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

9+ years of experience in finance operations and data analytics

Associate Data Analyst

LehLah Styling Pvt Ltd – Mumbai

Sept 2025 – Present

Designed and deployed Tableau dashboards using SQL-based datasets to improve business visibility across product, marketing, and operations teams.
Automated Excel and Google Sheets reporting using Power Query, advanced formulas, and SQL outputs, reducing report turnaround time by 25%.
Conducted cohort analysis, A/B testing, funnel analysis, and customer behavior analysis to support growth and retention strategies.
Defined and tracked key KPIs including CTR, CVR, engagement rate, retention, and creator activity.
Performed data validation, reconciliation, and quality checks across multiple data sources to ensure reporting accuracy.
Optimized Tableau dashboard performance by improving SQL query efficiency and extract refresh strategies.
Utilized SQL, Tableau, Excel, Google Sheets, Python (Pandas), Power BI, and web scraping tools for analytics and automation.

Data Analytics Intern

Labmentix – Remote

Jun 2025 – Dec 2025

Delivered 15+ data analytics projects across transport, real estate, healthcare, and retail domains.
Performed data cleaning, validation, and exploratory data analysis (EDA) to ensure high-quality insights.
Built interactive dashboards using Power BI, Tableau, Python, and SQL to support performance analysis.
Automated dataset preparation using Python-based ETL scripts, improving processing efficiency by 40%.
Designed KPI reports and visualizations to track business performance and trends.
Published weekly deliverables on GitHub to enhance transparency and collaboration.

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.

Feb 2016 – 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 · 2025

IBM SkillsBuild Data Analytics

IBM · 2025

Career Essentials in Data Analysis

Microsoft & LinkedIn · 2025

Data Fundamentals with Capstone

IBM · 2025

Data Science

Infosys · 2025

Data Science & Analytics

HP Life · 2025

Power BI Visualization

Coding Ninjas · 2025

Tableau Visualization

Coding Ninjas · 2025

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