Data Analyst

Kolmeo

1. • Performed data management of product data on a day-to-day basis using T-SQL in Microsoft SQL Server Management Studio.
2. • Resolved payments support issues regarding financials using investigative analysis with Microsoft SQL Server Management Studio.
3. • Efficiently managed and curated 130 – 150 data support requests and BI report requests to on a weekly basis in Kolmeo.
4. • Worked on SQL Server Reporting Services and Power BI to develop and publish data visualizations as per client requirements.
5. • Utilized Microsoft Azure Cloud Services for data sourcing for SQL Server Reporting Services.
6. • Identified issues and communicate effective solutions to non-technical stakeholders, i.e., Customer Service & Customer Success teams.
7. • Experienced in agile Scrum methodology and tools.

Lead Data Analyst Intern

Mill Software

1. • Headed analyst team working with Mill software and Yarra Energy Foundation.
2. • Employed Data Science using Python & its statistical libraries to achieve client requirements.
3. • Extracted raw data on energy consumption sourced from parts of Victoria and cleaned to improve data significance using Pandas.
4. • Performed data mapping and data wrangling as part of preparation of data modelling with NumPy.
5. • Transformed the data for feature selection to select significant features for modelling.
6. • Implemented various predictive modelling techniques for time series analysis and compared results for prediction efficiency using Scikit-Learn.
7. • Developed insights on energy consumption based on model results.
8. • Constructed interactive data visualizations for correlations and feature significance with Plotly and Matplotlib.
9. • Generated forecast 24-hour energy consumption in parts of Victoria with 79% accuracy, to aid selection of optimal capacity for solar battery storages.
10. • Awarded with High Distinction by RMIT University for producing significant results and effective stakeholder management.

Royal Melbourne Institute of Technology

Analytics