Looking for a job

Ronak Patel

@ronakpatel

Data Analyst with 9+ years in finance. Skilled in SQL, Power BI, Tableau & Python, turning data into actionable business insights.

India

Message

What I'm looking for

I’m seeking a Data Analyst or BI role where I can use SQL, Power BI, Tableau, and Python to solve business problems. I want a data-driven team that values insights, ownership, and growth, with opportunities to work on end-to-end analytics and deliver measurable impact.

I am a Data Analyst with 9+ years of experience in the finance industry and hands-on expertise in data analytics. My career began in finance, where I developed strong business acumen, stakeholder communication skills, and a deep understanding of financial reporting, performance tracking, and operational efficiency. Over time, I transitioned into data analytics to combine my domain expertise with technical problem-solving.

I am proficient in SQL, Power BI, Tableau, Python, and Excel, and have completed 30+ analytics projects across domains including finance, sales, HR, operations, marketing, and eCommerce. I specialize in data cleaning, transformation, exploratory data analysis (EDA), KPI design, and building interactive dashboards that support strategic decision-making. I focus on translating complex datasets into clear, actionable insights that drive measurable business impact.

Recently, I have worked on projects involving airline performance analysis, Amazon sales reporting, HR analytics, logistics analysis, and business performance dashboards. My work typically includes writing optimized SQL queries, designing data models, automating reports, and presenting insights to stakeholders in a simple and impactful way.

I hold a PGDM in Finance and a B.Com degree, along with certifications from IBM, Microsoft, Infosys, and HP. I am passionate about continuous learning, leveraging AI tools in analytics workflows, and building scalable data solutions. My long-term goal is to become a globally recognized data specialist, build multiple income streams, and create meaningful impact through data-driven innovation.

Experience

Work history, roles, and key accomplishments

Associate Data Analyst

LehLah Styling Pvt Ltd

Sep 2025 - Apr 2026 (7 months)

• Built Tableau dashboards using SQL datasets to drive decisions across product, marketing, and operations.
• Automated Excel/Sheets reporting with Power Query and SQL, reducing turnaround time by 25%.
• Performed cohort, funnel, and customer analysis to improve growth and retention.
• Tracked KPIs (CTR, CVR, retention) and ensured data accuracy via validation and performance optimization.

Data Analytics Intern

Labmentix ESolution Pvt ltd

Jun 2025 - Dec 2025 (6 months)

• Delivered 15+ analytics projects across transport, real estate, healthcare, and retail.
• Performed data cleaning, validation, and EDA to generate reliable insights.
• Built interactive dashboards using Power BI, Tableau, SQL, and Python.
• Automated data preparation with Python ETL, improving efficiency by 40%.
• Designed KPI reports and published weekly updates.

Data Analytics Intern

Labmentix

Jun 2025 - Dec 2025 (6 months)

Delivered 15+ analytics projects across transport, real estate, healthcare, and retail, built interactive dashboards and automated ETL scripts to improve processing efficiency by 40%.

Power BI Tableau Python SQL ETL Data Cleaning EDA Dashboarding Git

Team Lead(Trading desk & KYC Operations)

MarketWolf Securities Private Limited.

Jun 2019 - Dec 2023 (4 years 6 months)

• 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%.

Team Leadership Team Management Identity Verification Document Management Documentation Documentation Management Trading Algorithmic Trading Monitoring And Alerting Data Management Customer Onboarding Operations

Team Lead – KYC Operations

MarketWolf Securities Pvt. Ltd.

Jun 2019 - Dec 2023 (4 years 6 months)

Managed KYC and compliance workflows for 35,000+ clients monthly with 100% accuracy and implemented automated reporting and dashboards that reduced workflow time by 40% and improved KPI accuracy by 30%.

Excel Macros Dashboarding Compliance Operations KPIs Data Reconciliation Stakeholder Management

Operations Executive

Angel Broking Limited

Sep 2017 - Jun 2019 (1 year 9 months)

• 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%.

Algorithmic Trading

Operations Executive

Angel Broking Ltd.

Sep 2017 - Jun 2019 (1 year 9 months)

Executed and reconciled 100+ daily trades with 100% accuracy, built MIS dashboards to track KPIs and improved team efficiency while reducing trade discrepancy resolution time by 20%.

KPI Tracking Operational Support Process Improvement

Trainee Dealer

ValeurHR E-Solution Pvt. Ltd

Feb 2016 - Jun 2017 (1 year 4 months)

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

Algorithmic Trading

Trainee Dealer (FX Trader)

ValeurHR E-Solution Pvt. Ltd.

Feb 2016 - Jun 2017 (1 year 4 months)

Trained in live FX trading, executed EUR/USD trades using technical analysis and price-action strategies, and completed live trading training in Singapore under senior dealers.

Risk Management Live Trading

Customer Service Associate

Reliable Business Solutions and Services Private Limited

May 2012 - Sep 2012 (4 months)

● Prepares for customer inquiries by studying products, services, and customer
service processes.
● Responds to customer inquiries by understanding inquiry; reviewing previous inquiries and
responses; gathering and researching information; assembling and forwarding information;
verifying customer's understanding of information and answer.
● Records customer inquiries by documenting inquiry and res

Call Center Operations