Back to Developers
Ronak Patel

Ronak Patel

Data Analyst

Mumbai, India
85
Profile Score

About

Results-driven Data Analyst with 8+ years of finance experience and 6+ months of hands-on analytics work across transportation, retail, healthcare, and real estate domains. Proficient in SQL, Python (Pandas, NumPy), Power BI, Tableau, and Excel, with expertise in dashboarding, statistical analysis, ETL pipelines, A/B testing, data modeling, predictive analytics, and KPI reporting. Experienced in transforming complex datasets into actionable insights, automating data workflows, and driving data-informed decisions across cross-functional teams.

Skills & Expertise (38)

SQL Expert
9.0/10
8
Years Exp
Tableau Advanced
8.4/10
5
Years Exp
Excel Expert
8.2/10
8
Years Exp
Python Advanced
7.8/10
4
Years Exp
Power BI Advanced
7.5/10
3
Years Exp
Streamlit Adaptability Flask KPI Reporting Business Insights stakeholder communication Financial Analysis Problem Solving Analytical Thinking Business Communication Stakeholder Reporting Time management Priority Management Team Collaboration Critical thinking Decision Making A/B testing Google Sheets MySql Postgresql SQLite Oracle SQL Developer Statistical Analysis Predictive Modeling Forecasting VS Code Hypothesis Testing Data Cleaning Data Wrangling ETL Pipelines Data Quality Checks Jupyter Notebook Git/GitHub

Work Experience

Associate Data Analyst

LehLah Styling Pvt Ltd

Sep 2025 - Present

Designed and deployed Tableau dashboards using SQL-based datasets to improve business visibility and support data-driven decision-making 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, retention, and marketing optimization strategies. Defined, tracked, and monitored key business 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 and data reliability. 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, automation, and reporting.

Operations Executive – Equity/Commodity/Currency

Angel Broking Ltd.

Sep 2017 - Jun 2019

Executed and reconciled 100+ daily trades while ensuring 100% accuracy. Built Excel MIS dashboards to track KPIs, improving team efficiency and reporting flow. Supported 50+ sub-brokers and reduced trade discrepancy resolution time by 20%.

Data Analytics Intern

Labmentix

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 operational and customer 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, enhancing transparency, version control, and collaboration.

Team Lead – KYC Operations & Trading Desk

MarketWolf Securities Pvt. Ltd.

Jun 2019 - Dec 2023

Managed KYC and compliance workflows for 35K+ clients per month across NSE/CDSL/MCX 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%.

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

PGDM in Finance - ITM SIA Business School

2013 - 2015 · India

B.Com (Commerce) - Mumbai University

2009 - 2012 · India

Certifications

Google Data Analytics

Coursera · 2025

IBM SkillsBuild Data Analytics Certificate

IBM · 2025

Data Science

Infosys Springboard · 2025

Career Essentials in Data Analysis

Microsoft & LinkedIn · 2025

Data Science & Analytics

HP Life · 2025

Data Fundamentals with Capstone Project

IBM · 2025

Data Visualization with Power BI

Coding Ninjas · 2025

Data Visualization with Tableau

Coding Ninjas · 2025

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 5/5
Verified 5/5
Total Score 85/100

Profile Overview

Member sinceMar 2026

Skills (38)

SQL Tableau Excel Python Power BI Streamlit Adaptability Flask KPI Reporting Business Insights +28 more