Ronak Patel

Hi, I'm Ronak Patel

Ex-Finance Operations Lead | Data Analyst | Turning Numbers into Narratives

Explore Projects Get In Touch

About Me

Ronak Patel

Hello! I'm Ronak Patel, a results-driven Data Analyst with over 9 years of experience in the financial domain and a strong passion for uncovering actionable insights through data.

I hold a PGDM in Finance and have recently transitioned into analytics after realizing the powerful impact data can have on business strategy and decision-making. My skillset includes SQL, Power BI, Python, Excel, Tableau, and data storytelling techniques.

I thrive at the intersection of business and analytics—translating raw data into strategic dashboards, reports, and models that drive performance and growth. Whether it's optimizing dashboards, running statistical models, or simplifying data pipelines, I bring curiosity, precision, and a user-centric mindset to everything I do.

I'm currently seeking opportunities where I can solve real-world problems, collaborate with cross-functional teams, and help organizations become more data-driven.

9+ Years Experience

PGDM Finance

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

Professional Experience

9+ years of experience in finance operations and data analysis

Data Analytics Intern

Labmentix – Remote

Jun 2025 – Present

Contributing to real-world analytics projects across transportation, real estate, healthcare, and retail domains
Led 5+ projects using Excel, SQL, Power BI, Python, Tableau with weekly deliverables documented on GitHub
Delivered dashboards and actionable insights while collaborating remotely with a distributed analytics team

Team Lead – KYC Operations & Trading Desk

MarketWolf Securities Pvt. Ltd., Mumbai

Jun 2019 – Dec 2024

Managed daily client onboarding, KYC checks, and compliance across NSE/CDSL/MCX
Automated backend workflows and reports using Excel macros
Reduced verification cycle time by 30% via collaboration with tech and compliance teams

Operations Executive – Equity/Commodity/Currency

Angel Broking Ltd., Mumbai

Sep 2017 – Jun 2019

Processed high-volume trades using Odin; handled KYC & support for sub-brokers
Maintained daily MIS reports and upgraded client workflow processes
Resolved trade discrepancies ensuring 100% compliance

Trainee Dealer (FX Trader)

ValeurHR E-Solution Pvt. Ltd.

Feb 2016 – Jun 2017

Traded EUR/USD pair using Price Action and Technical Analysis
Worked on RiceBowl software connected to the live forex market
Completed 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

Continuous learning and professional development in data analytics

Google Data Analytics

Google

IBM SkillsBuild Data Analytics

IBM

Career Essentials in Data Analysis

Microsoft + LinkedIn

Data Fundamentals with Capstone Project

IBM

Data Science

Infosys Springboard

Basic to Advanced Microsoft Excel

Skill Nation

Data Science & Analytics

HP LIFE

Data Visualization with Tableau

Coding Ninjas

Intro to Data Analysis in Excel

Coursera

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