Rohit Rajagopal Email & Phone Number

Sydney, Nsw, Au

Auckland, New Zealand

Government Agency: Provided data-driven recommendations and insights to inform business decisions - Used Scikit-learn and DAX to analyse the NZ housing market and conduct demand forecasting for various scenarios - Designed and ran an A/B test and evaluated a regression model in R to improve product adoption- Automated Power BI reporting and streamlined SQL procedures to identify bottlenecks across internal processes Media Broadcaster: Enhanced financial reporting and data processing through advanced analytics and automation - Designed an in-depth Power BI dashboard to replace manual reporting, saving up to two business days weekly - Built pipelines in Databricks (PySpark and SQL) and Synapse to speed up processing of tables with 500m+ rows - Applied CI/CD practices and automated testing suites within Azure DevOps to release updates to production Multinational Bank: Acted as the key relationship point for 6 remediation projects, ranging from home loans to overdrafts- Delivered expert remediation and consulting services, resulting in over $1.5m of refunds dating back to 2015 - Utilised PROC SQL, Oracle SQL, and SAS to develop macros and compensation models for affected customers - Translated complex business logic into code and generate trigger reports to immediately identify future issues Multinational Dairy Manufacturer: Conducted data management and data modelling to improve efficiency - Simplified Power BI data models and optimised SQL queries in SSMS to accelerate report visual load times - Performed market share analysis and visualised regions of interest to identify opportunities for diversification

Auckland, New Zealand

As part of the Digital Products & Services team, I was involved in a variety of tasks:- Delivery of Power BI dashboards to generate high-quality data insights for internal and external use- Automating business processes and handling client data using Dataverse/PowerApps- Python software development to monitor and optimise energy consumption in large buildings (BTune by Beca)- QA testing and managing Azure DevOps release pipelines for application deployments to production (CAPEXinsights & FACILITYTwin)

Auckland, New Zealand

Graded coursework and examinations for the Engineering Science and Statistics departments.

Auckland, New Zealand

Published articles on a fortnightly basis which addressed a range of financial and economic perspectives.

Auckland, New Zealand

Created object detection and text recognition models to identify industrial assets in standard and spherical images. This involved researching effective algorithms, data wrangling, augmentation, and rigorous model testing.

Auckland, New Zealand

Worked on an industrial optimisation project to reduce the power consumption at a large refrigeration site. Conducted extensive data cleaning, feature engineering, visualisations, and literature reviews to identify important variables.

Auckland, New Zealand

Tutored high school students in AS and A Level Chemistry.

Bachelor Of Engineering, Engineering Science With First Class Honours

Activities and Societies: Management Consulting Club, Auckland University Ultimate Club, University of Auckland Investment Club, SavY NZ

A* Average Across Cambridge A Levels

Activities and Societies: 1st XI Cricket Team, Social Football, Society of St. Vincent de Paul, Special Character group, Academic.