KEVIN CAO
128 ANZAC AVENUE
Summary
Detail-focused Master of Information Technology student at the University of Auckland with a strong foundation in data analysis and database management using PowerBI, R, MicroStrategy BI, SQL, and Tableau. Effective communication skills with different stakeholders in developing comprehensive reports to achieve optimal results.
Overview
3
3
years of professional experience
5
5
years of post-secondary education
Work History
Power Insights Specialist
Transaction Settlement Department, Heilan Electric
12.2023 - Current
- Dealing with electric power Day-Ahead Trading (D+1) processes on a daily basis, analysing market trend (including electricity market load, Solar/Wind/Nuclear load, and real time load released by China National Grid) into deciding the buying/selling amount of electricity for the department using Excel vlookup/pivot tables.
- Updating weighted-average transmission charges for customer companies based on Day-Ahead Trading / Continuous Matching Trading (D+2/3) / Monthly trading(M+1) / Government-authorised electricity capacity(yearly basis), succeeded in insuring 0 errorsin relevant statements.
- Understanding and delivering government power policies changes to key members within the department, developed relevant conclusion documents for policies changes.
- Utilising R unsupervised learning algorithm (K-Means), succeeded in categorising the contracted customers (more than 400 companies) into 3 distinct types based on their own daily power usage curves, enabling more targeted analysis and strategy development for our department.
- Utilising R (leaflet package) and Power BI, created interactive map visualizations showcasing power plants in the Shandong province. Employed color-coding to distinguish various types of power plants, including wind power, nuclear, solar, photovoltaic, and thermal power.
- Communicating with companies with abnormal power consumption changes, determined why the power changes, also forecasting the amount of electricity to purchase in next days based on the changes, succeeded in achieving minimal loss on clearing statements.
Data Analyst Intern
University Of Auckland, Student Academic Services
07.2023 - 11.2023
- Using R (including Cooks distance) to exclude abnormal values from dataset given, ensured data as 100% clear and accurate.
- Create and update SQL Queries (Campus Solution Query Manager 9.0) using in both SSO test and actual environment, succeeded in retrieving student information based on term, course catalog, subject. Created MicroStrategy dossier visualisation tables reflecting the time trend of students enrolled in a particular course.
- Team developed a comprehensive 'Suite of Reports' using MicroStrategy BI (Similar to Power BI) with corrected dataset to enhance self-service access post-university's shift to centralised analytics, aiding senior leadership's strategic decisions, succeeded in improving academic understanding.
- Aligned with university goals, created 32 easy-to-use interactive dashboards (Bar charts, Map charts, Dynamic time charts) to Faculty of Science, break down by critical student functions: Applications, Enrolment, Retention, Compliance, Pass Rates, and Qualifications.
- Collaborated closely with Faculty of Science Academic Services and senior leaders, ensuring tailored dashboards met stakeholders' needs.
- Conducted group meetings fortnightly for feedback, refining dashboards iteratively based on usability and presentation, keep aligning with stakeholders' changing requirements.
- Using R to distinguish the discrepancies for student enrollment information (in Excel) between SMR (data visualisation system) and SSO (operational system) datasets break down by term, subject and course catalogue (over 523,000 records), finding out the differences for each of the data source and aggregated all causes in a final report. Succeeded in improving data consistency/integrity for different systems within the university.
Data Analyst Intern
Citycare Property
11.2021 - 12.2021
- Determined the 3 most important variables that are affecting availability of assets for maintenance using decision tree/Xgboost method using R.
- Processed raw data into data insights through well-organized reports, presentations, and graphics to summarise and explained research findings and their implications, ultimately reducing 13% operational cost.
Website Developer
INFOMGMT399, University Of Auckland
07.2021 - 11.2021
- Developed website (Healthcloud399) using WordPress for wearable devices to monitor user’s health data, succeeded in generating and analyzing users' heart rate and steps data.
- Collaborated closely with all stakeholders, including end users and teammates, succeeded in understanding project requirements and meet 96% of the functionalities from project scope.
- Visualized and categorize heart rate and steps data using Wordpress Plugins, including PowerBI data visualization dashboard Plugin, resulting in interactive data dashboard reflecting real-time health data for users.
- Inbuilt email alert function to warn clinicians if user exceeded warning heart rate (140bmp), with accuracy rate being 98%.
Education
Master of Science - Information Technology
The University of Auckland
01.2022 - 12.2023
Bachelor of Science - Statistics And Information Technology Management
The University of Auckland
01.2019 - 12.2021
Skills
SQL and Peoplesoft Campus Solutions 9.0 Query Manager:
- Proficient in using SQL and Peoplesoft Campus Solutions 9.0 Query Manager, including inner join, outer join, full join, and performing CRUD operations (create, read, update, delete).
R:
- Skilled in data cleaning, data wrangling and visualisation using R (tidyverse, ggplot2),
- Experienced in data modelling including: multivariate analysis, overfitting detection, t-tests, and chi-square tests.
- Proficiency in parameter selection including: bagging (Random forest), boosting (Xgboost), decision tree; regularization (lasso, Ridge).
- Able to solve goodness of fit and model selection problems
PowerBI, Microstrategy BI and Tableau:
- Handling relationships between tables, including one to one, one to many, many to many table relationships
- Proficient in ETL (Extract, Transform, Load) processes
Team Collaboration:
- Proficient in using SDLC, able to analyze and visualize user requirements (CRM)
- Good understanding of Agile development
- Proficient in using SWOT analysis and stakeholder analysis
Volunteer
Vlog Creator, Southwest University, 07/2020 - 12/2020
Came second in the University of Auckland China Learning Centre vlog
competition, and the vlog was exhibited on University of Auckland website
Class representative for STATS 330, University of Auckland, 02/2021-07/2021
Being an offshore class representative for online students outside New Zealand due to COVID. Generated students’ feedback weekly to help professor effectively improve the course.
Awards And Certificates
University of Auckland：
• 2022 UoA distinguished graduate award
• Certificate of Outstanding achievement in Compsci101
• Certificate of Outstanding achievement in Maths108
• ARIS certificate (Business Process Management)
• Class representative certificate in STATS330
• Advanced Google Analytics Certificate
Southwest University:
• Certificate of member of Advertising Club
• Come second in the University of Auckland China Learning Centre vlog competition
Nanjing University of Science and Technology:
• Certificate of Activist in Cultural and Sports Activities
Timeline
Power Insights Specialist
Transaction Settlement Department, Heilan Electric
12.2023 - Current
Data Analyst Intern
University Of Auckland, Student Academic Services
07.2023 - 11.2023
Master of Science - Information Technology
The University of Auckland
01.2022 - 12.2023
Data Analyst Intern
Citycare Property
11.2021 - 12.2021
Website Developer
INFOMGMT399, University Of Auckland
07.2021 - 11.2021
Bachelor of Science - Statistics And Information Technology Management
The University of Auckland
01.2019 - 12.2021
Similar Profiles
MANABU SAKUDAMANABU SAKUDA
Regional Sales Manager at Transaction Banking Solutions Department, Sumitomo Mitsui Banking Corporation Singapore BranchRegional Sales Manager at Transaction Banking Solutions Department, Sumitomo Mitsui Banking Corporation Singapore Branch
Adriana LaraAdriana Lara
Records/Property and Evidence Technician at White Settlement Police DepartmentRecords/Property and Evidence Technician at White Settlement Police Department
NOKUPHIWA ZWANENOKUPHIWA ZWANE
SCM Procurement/Buyer Intern at Gauteng Department of Human SettlementSCM Procurement/Buyer Intern at Gauteng Department of Human Settlement
Tiara UlukTiara Uluk
Junior Retail Assistant at Mareko Island CreationsJunior Retail Assistant at Mareko Island Creations
Nikola NagyovaNikola Nagyova
Storekeeper at Kratochvíl S.r.o. , Czech RepublicStorekeeper at Kratochvíl S.r.o. , Czech Republic