Looking for a job

Ronak Lodha

@ronaklodha

Message

Data Analyst specialising in Data Analysis, Python, SQL and Machine Learning

India

Message

Data Analyst with 3+ years of experience delivering data-driven insights across analytics, business intelligence, and retail/logistics functions. Skilled in building and automating dashboards and reports that help business teams track KPIs and act faster — including automation frameworks that improved spend control and a dashboard rebuild that lifted performance by ~70%. Proficient in SQL, Python, Advanced Excel, and visualization tools (Tableau, Power BI, Looker Studio), with hands-on experience analyzing large datasets to surface trends, risks, and opportunities. Proven track record of translating analysis into stakeholder-ready recommendations, including a performance system that drove a 25% increase in user engagement.

Experience

Work history, roles, and key accomplishments

Current

Data Analyst

Current

Quilytics

Dec 2024 - Present (1 year 6 months)

Data Analyst
Performed Marketing Mix Modeling (MMM) for multiple clients & built automation frameworks for budget pacing, enabling real-time spend control.
Built end to end data pipelines ensuring reliability and data quality.

xWF – Google | Logistic Analyst (Client Project)
Engineered SQL/BigQuery dashboards for large-scale datasets, improving performance ~70%, and built new metrics like (OTR)

Sr. Business Intelligence Analyst

Viral Fission

Oct 2023 - Nov 2024 (1 year 1 month)

•Developed and implemented a user points system based on performance metrics, driving user engagement and retention.
•Utilized SQL for data querying and analysis, restructuring dashboards for enhanced visualization.
•Collaborated with cross-functional teams for requirement gathering and analysis, ensuring alignment with business objectives.
•Explored Google Analytics and integrated insights.

Python SQL MongoDB Google Analytics Natural Language Processing Tableau

Business Intelligence Analyst

Viral Fission

Jul 2022 - Oct 2023 (1 year 3 months)

•Led the implementation of a new points system to evaluate team performance, enhancing productivity and efficiency.
•Created dashboards for data visualization, identifying trends and insights to support decision making processes.
•Utilized NLP techniques to analyze open-text survey responses, providing valuable insights for business strategy.

Data Visualization Advanced Excel Jupyter Python Statistics

Data Science Intern

Forsk Technologies

May 2022 - Jul 2022 (2 months)

Participated in a comprehensive Data Science training and internship program, gaining hands-on experience in data analysis and machine learning techniques.

Data Science