Ray Wei Email & Phone Number

Acton, ACT, AU

ACT

- Delivered SQL queries via MS SQL Server, analysis on strategic and performance indicators.- Automated data flow processes from various data sources, fully eliminating manual effort and enhancing efficiency and data reliability.- Managed Power BI Pro licenses, and developed dashboards and visualization within the ACT Health Directorate.

Dickson, ACT

Data Management and Reporting at ACT Environmental Protection Authority (EPA) - Oversaw comprehensive data management, including database maintenance, governance, and execution of ad hoc queries to support the entire EPA team. - Developed and implemented a geospatial data integration process from initial collection, transformation and cleaning up, to.

Canberra, Australian Capital Territory, Australia

- Delivered tutoring for statistics courses, including Introductory Mathematical Statistics (STAT2001) and Survival Models (STAT3032).- Marked students’ exam papers and assignments promptly.

Canberra, Australian Capital Territory, Australia

Data Management for School Infrastructure New South Wales Tendering project - Engaged in the whole data integration, including data identification, data extraction, transformation and cleaning, data aggregation, as well as monitoring and maintenance via Excel and R.- Used API through R (httr package) to automate more than 90% of the data integration.

Predictive Model Construction for Capturing Fraudulent and Money Laundering Transactions - Cleaned up data from primary and secondary sources, and solved the problem of imbalanced data using different subsampling methods including normalization, down sampling and rose subsampling. - Assisted Senior Data Analyst in building a random forest model using R to.

Canberra

Evaluation of Tenderer Responses - Quantified tenders in terms of their experience of similar size and scope; Accessed the methodology from tender candidates and evaluated stochastic modelling assumptions. - Produced a comprehensive report for ANU’s Financial Committee, offering an in-depth analysis of all tenderer responses. The report highlighted the.

Canberra, Australian Capital Territory, Australia

Stochastic modelling of economic variables and portfolio construction - Use time series with external regressors to model economic variables in R to predict the financial returns of the institution’s investment. - Built stochastic models of future investment earnings for different asset classes over the next 40 years; Used VBA macro to run Monte Carlo.

Remote

Tutoring university-level statistics courses, e.g. Survival Models(STAT3032) and Quantitative Research Methods(STAT1008).

Canberra, Australian Capital Territory, Australia

- Conducted market research on the semiconductor industry and investigated Australia’s possibility of achieving sovereign capacity on semiconductors. - Delivered research findings and recommendations in both report and presentation forms.

Bachelor Of Actuarial Studies And Bachelor Of Finance, Actuarial Studies, Quantitative Finance, Current Gpa Is 6.38/7

The International Baccalaureate (Ib) Diploma Programme, Ib-40/45 (Equivalent Atar-98.5/99.95)

Activities and Societies: Australian Math Olymaid, Australian Mathematics Competition, International Student Committee, Badminton First.