Summary
Overview
Work History
Education
Skills
Projects
Timeline
Generic
Ronik Jayakumar

Ronik Jayakumar

Data Consultant
Pyrmont

Summary

Strategic Data & Sales Analytics Consultant with 3+ years of experience in leveraging AI/ML-powered insights, Salesforce automation, and predictive analytics to improve sales processes and pipeline visibility. Proven ability to lead cross-functional initiatives, develop scalable dashboards (Power BI, SSRS), and enable data-driven decisions across financial and operational domains. Adept at stakeholder engagement, process transformation, and end-to-end data governance in high-impact enterprise environments.

Overview

6
6
years of professional experience

Work History

Salesforce Analyst and Administrator

PM-Partners Group
03.2023 - Current
  • Delivered AI-powered funnel segmentation analysis to improve conversion forecasting and sales planning.
  • Automated lead-to-cash reporting by integrating Salesforce and Power Automate, increasing pipeline transparency by 30%.
  • Rebuilt sales performance dashboards using Power BI, improving sales leader visibility across regions.
  • Collaborated with Sales & Finance stakeholders to identify and implement predictive analytics use cases.
  • Implemented RLS and governed access to sensitive sales insights across business units.
  • Conducted end-to-end change impact assessments to drive user adoption of new analytics tools.

Power Bi Consultant

Ventia
03.2025 - 05.2025
  • Partnered with Project Management, Ops & IS&T teams to develop AI/ML-informed dashboards for financial KPIs and project health.
  • Integrated ServiceNow, Jira, and Salesforce data into central Power BI models to support predictive reporting.
  • Enabled leadership decision-making by translating complex data into intuitive dashboards.
  • Conducted stakeholder workshops to assess reporting needs and implement sales pipeline enhancements.
  • Spearheaded alignment with enterprise data strategy through dashboard migration and model tuning.

Data Analyst

Repos Energy India Pvt Ltd
10.2020 - 10.2022
  • Rebuilt and optimised Power BI and SSRS reports across financial and operational domains, ensuring full data reconciliation.
  • Developed 12+ dashboards, accelerating reporting processes by 25%.
  • Automated lead-to-cash reporting via Salesforce and Power Automate, boosting pipeline visibility by 30%.
  • Implemented RLS in Power BI for access control across sensitive datasets.
  • Performed funnel and segmentation analysis to optimise digital sales conversion.

Intern

Volvo India Private Limited
04.2019 - 05.2019
  • Gained knowledge in the workings of a manufacturing unit.
  • Worked in finding new automation points for the manufacturing and assembly unit.
  • Experienced and was a part of the operating processes for converting and refining raw materials into products.
  • Communicated with engineering team and Managers to discuss methods to improve process and performance.
  • Studied the type of manufacturing processes used by Volvo.

Education

Masters Degree - Data Science And Innovation

University of Technology Sydney
Sydney, NSW
04.2001 -

Bachelor in Technology - Mechanical Engineering

Christ University
Bangalore, India
04.2001 -

Skills

Power Bi

Projects

Big Data ELT Pipeline – Airbnb & Census (Airflow, DBT, GCP, Postgres)
University of Technology Sydney – Sept 2024 to Nov 2024

  • Designed and automated an ELT pipeline processing 1.2 million Airbnb and Census records monthly using Apache Airflow, dbt Cloud, and PostgreSQL, enabling scalable and reliable data integration in GCP Cloud SQL.
  • Developed a star schema and data mart to support detailed analysis of Sydney’s property availability, host activity, and neighbourhood affordability trends for over 1 million listings.
  • Delivered advanced SQL insights on revenue drivers and demographic shifts, directly supporting strategic planning for real estate and urban development stakeholders.


Big Data Processing Using Databricks
University of Technology Sydney – June 2024 to August 2024

  • Processed and cleaned 730M+ NYC taxi trip records (2015–2022) using Apache Spark on Databricks, integrating yellow and green cab data into a unified ~300 GB dataset.
  • Delivered complex SparkSQL analyses on trip patterns, fares, tips, and rider behaviour, generating high-value aggregated reports.
  • Built and benchmarked Spark ML regression models to predict trip fares, improving RMSE by 15%, and automated a cost-efficient ETL pipeline from Azure Blob Storage to Parquet in DBFS for scalable analytics


Deep Learning Image Classification | Japanese MNIST Dataset (70,000 images)
University of Technology Sydney – March 2024 to May 2024

  • Built and evaluated 3 neural network models to classify 70,000+ handwritten Japanese characters across 10 categories, improving accuracy from 87% to 88.3%.
  • Led data preparation and standardisation of a ~140MB image dataset to ensure high-quality inputs for model training.
  • Experimented with advanced TensorFlow techniques, including adaptive learning rates and dropout, recommending CNNs for production deployment.

Timeline

Power Bi Consultant

Ventia
03.2025 - 05.2025

Salesforce Analyst and Administrator

PM-Partners Group
03.2023 - Current

Data Analyst

Repos Energy India Pvt Ltd
10.2020 - 10.2022

Intern

Volvo India Private Limited
04.2019 - 05.2019

Masters Degree - Data Science And Innovation

University of Technology Sydney
04.2001 -

Bachelor in Technology - Mechanical Engineering

Christ University
04.2001 -
Ronik JayakumarData Consultant