Job Search Status
Open to workDesired start date: Open to discussion
Open To Work
Verified
This profile is verified using an email address.
Harshit Gulati
Westmead,Australia
Work Preference
Summary
Data analyst with over 5 years of experience in the Australian and New Zealand public sectors, providing analytical solutions to diverse stakeholders. Proficient in SQL, Python, R, Power BI, and Databricks, with a track record of developing advanced dashboards and complex data models to enhance executive decision-making. Expertise in machine learning, including model evaluation and performance monitoring, as well as creating analytical applications using R Shiny. Strong collaborator with senior stakeholders, focused on documenting processes to ensure transparency and promote continuous improvement.
Overview
1
1
Certification
5
5
years of professional experience
Work History
Data analyst
NSW Ombudsman
Sydney, Australia
05.2023 - Current
- Led the production of data for the 2024-25 Annual Report by designing and implementing an automated workflow in Databricks using multiple Python notebooks developed to generate data for each report section.
- Developed the Investigations and Recommendation dashboards for use across the office while liaising with multiple stakeholders across the office.
- Developed a KPI dashboard for the executive team to monitor organisational performance against key objectives in real time. This involved liaising with executive stakeholders, designing a complex Power BI data model, and writing advanced DAX measures to enable dynamic visualisation of KPIs across different office branches.
- Managed critical data requests for the NSW Parliament and cross-sector agencies, architecting complex SQL workflows (CTEs, Joins, Temp Tables) to transform fragmented data into high-integrity, decision-ready reports for senior stakeholders.
- Key contributor to the Trimester Operations Report, developing complex SQL queries to calculate and analyse office KPIs across multiple branches.
- Maintain the Data Analytics team request log and improved efficiency by automating the addition of new requests using Power Automate.
- Managed the DAU satisfaction survey process for internal stakeholders and improved efficiency by automating survey distribution using Power Automate.
- Responsible for maintaining existing dashboards and improving their functionality.
- Documented key processes for various tasks in Confluence to support knowledge sharing and team continuity.
Data insights analyst
Immigration NZ
Wellington, New Zealand
09.2022 - 05.2023
- Performed effective data wrangling on very messy Offshore Risk Monitoring Review (RMR) data to prepare it for analysis.
- Performed Regression analysis using logistic regression to identify and rank key factors leading to risk identification in offshore visa applications.
- Developed an interactive Power BI Dashboard for the Risk and Verification managers worldwide to derive useful insights from the data.
- Participated in the writing up of the report for the internal customer summarising the key findings from the analysis of the RMR project.
- Worked on the Accreditation Employer Risk Monitoring Review (AERMR) project aimed at mitigating risks of exploitation of migrant workers by NZ employers.
- Designed an appropriate dashboard using Power BI for the OTI managers to report on visa application volume and processing times to improve performance and productivity at Immigration NZ for processing of visa applications.
Statistical and data analyst
Statistics NZ
Christchurch, New Zealand
11.2020 - 08.2022
- Conducted an improvement study of the Stats NZ migration machine learning model used to generate provisional migration estimates. Developed an R Shiny application to monitor the performance of the XGBoost model and identified multiple enhancements that were successfully deployed.
- Contributed to a high-priority review of the HSU methodology used by the Ministry of Health to support improved COVID-19 vaccination coverage across New Zealand, as part of the wider NZ Government pandemic response. Conducted comparative analysis between ERP (base 2018) projections and Ministry of Health HSU estimates using data visualisation in R, identified key trends and potential drivers behind observed differences, and collaborated with the publishing team to prepare the report and visual outputs for release on the Stats NZ website.
- Conducted a study of the trend methodology used for New Zealand's International Travel and Migration (ITM) series to assess the appropriate timing for resuming trend publication in the post-COVID environment.
- Active member of the Stats NZ Time Series Network, regularly presenting on trend analysis for the International Travel and Migration (ITM) series and the application of ARIMA modelling and forecasting to support responses to complex customer queries.
- Produced population projections for the Gisborne District and Waiheke Local Board area, liaising with district council stakeholders as required.
- Authored internal documentation detailing the methodology used at Stats NZ for producing SA2 population projections, including analysis of potential improvements to the process.
Data Science Intern
Orion Health
Auckland, New Zealand
11.2019 - 02.2020
- Project title was 'Smart search: clinically relevant auto-complete'.
- Performed research into different auto-complete and semantic search algorithms.
- Implemented the chosen algorithms on unstructured medical databases using Python.
- Developed an auto-complete input field using R Shiny which deployed the chosen algorithms using a Flask API.
Education
Master of Applied Data Science - Applied Data Science
University of Canterbury
Christchurch06-2020
Master of Science - Astronomy
University of Canterbury
Christchurch03-2019
Bachelor of Science - Physics and Maths (double major)
University of Canterbury
Christchurch12-2015
Skills
- Power BI
- SQL Server
- Python
- DAX
- Databricks
- R
- MS Excel
- Pyspark
- Machine Learning
- Confluence
- Statistics
- Data wrangling
- R shiny
- Deep learning
- Flask
- Tableau
- MATLAB
- Time series analysis
- Power Automate
Certification
- Databricks Academy Accreditation - Databricks Fundamentals, 03/01/25
- Databricks Academy Accreditation - Gen AI Fundamentals, 04/01/25
- Databricks Certified Generative AI Engineer Associate, 11/01/25
Awards
- Frank and Doris Bateson Graduate Memorial Scholarship, 03/01/18 - 03/01/19, Scholarship awarded to students conducting research in the field of Astronomy/Astrophysics. Only one scholarship is awarded each year to a postgraduate student.
- UC Summer Research scholarship, 11/01/15 - 02/01/16, Conducted research into Delta Scuti and Gamma Doradus variable stars as part of a paid Astronomy summer research project.
- Member of Golden Key High Achieving International Honour Society, 02/01/14 - Present, Only students securing marks within the top 15% of the University are invited to join the society.
References
References available upon request
Extracurricular Activities
KNOX TE KURA BADMINTON CLUB, Christchurch, 01/01/16 - 06/01/19, Member of the club committee and helped in organizing games on the playing nights. Physsoc, 02/01/14 - 03/01/19, Physics club at the University. Took part in events and helped in event organization. Earthquake relief worker, Christchurch City Council, 02/01/11 - 03/01/11, Volunteered at Burnside High School after the Christchurch Earthquake to help accommodate affected people.
Languages
- Hindi
- English
- Hindi
Timeline
Data analyst
NSW Ombudsman
05.2023 - Current
Data insights analyst
Immigration NZ
09.2022 - 05.2023
Statistical and data analyst
Statistics NZ
11.2020 - 08.2022
Data Science Intern
Orion Health
11.2019 - 02.2020
Master of Applied Data Science - Applied Data Science
University of Canterbury
Master of Science - Astronomy
University of Canterbury
Bachelor of Science - Physics and Maths (double major)
University of Canterbury