Simon Wang

• Design and build streamlined reports, and dashboards by using Power BI and Power Query to provide insight into the WorkforceMix project performance and a valued contribution to inform decision-making for stakeholders and the senior leadership team.
• Develop and tailor a variety of reports and methods of presenting data to support the WorkforceMix project presentations, briefings, and proposals, and actively contribute to program presentations, forums, and workshops with the skill teams.
• Build relationships with various corporate and business functions to establish efficient processes for information/data exchange across the WorkforceMix project and to ensure alignment with corporate systems such as financial, workforce, enrolment reporting, and other business-related systems.

• Build Contractor Central Dashboard by using Power BI to replace weekly and monthly reports, visualized data for presentation to Senior Leadership Team.
• Design Security Guard Expenditure Dashboard by using Power BI to dynamically present actual and budget trends, and automatically update the report and present it to the facility management leadership team.
• Generate monthly actual business performance reports and present to the Chiefs and Directors, explain financial performance, and provide recommendations.
• Perform complex analysis related to the TAFE NSW budget including forecast modeling, undertaking the detailed design of agreed control processes, and tracking dashboards that will provide process quality around systems, methodologies, and techniques and are able to detect early warning alerts of missing operations or processes.
• Develop financial modeling to allocate organization targets to business units across TAFE NSW, including controls and reconciliations, audit trail, and reporting.

• Analyses business processes and build logic for business stakeholders to calculate budget and forecast, reconciliation, and management to enable a successful transition to Budgeting and Forecasting Tools Development.
• Develop and maintain strong and effective relationships with stakeholders to ensure a successful and sustainable implementation.
• Create documentation including business analysis, business requirements, gap analysis, design specification, and training documents to support the integration project.
• Building single-truth data warehouse for finance, payroll, and enrolment, developing data modeling, and using Power BI to virtualize reporting and support business performance report automation.
• Prepare and maintain project documentation for reporting, monitoring, and evaluation purposes to ensure accessibility of quality information and contribute to the achievement of project outcomes.

• Manage and improve daily data delivery to ensure high quality, effective and timely responses and advice to stakeholders in all aspects of reporting, analysis and interpretation of data.

• Interact with internal stakeholders with nationwide managers and record the information to reduce the error rate.

• Collect cybersecurity log from Arcsight to examine the violation access and cross-check with AD data and HR data in different applications.

• Undertake high-level data analysis, and prepare high-level correspondence, briefs, submissions and reports to enable informed decisions

• Manage the implementation of data projects, including business analysis and requirements specifications, testing and delivery, stakeholder engagement and the application of data governance practices and data quality standards

• Investigate, evaluate and implement process improvements, and new data sources and software for data delivery, working within and improving the accuracy of cybersecurity data log and maintaining data quality for audit works.

• Manipulate, clean and process data using Excel, SQL, and perform daily clearing and settlement duties in accordance with the company’s guidelines, procedures and instructions.
• Collecting and analyzed data; preparing and systematized relevant reports and statements, such as the trading day clearing and settlement report.
• Responsible for the daily calculation of the position size for trust fund products; prepared the information on funds’ earnings for public release.
• Receiving high recognition and praise from superiors for high client/agent satisfaction level and 100% error-free performance record.

• Responsible for collecting, organizing, and archiving finance data concerning medical representatives across the country.
• Operating the internal information management system to collect, categorize and report.
• Analyzed key aspects of the business to evaluate factors driving results and summarized them into presentations.
• Drafted reports on company financial metrics to assess successes and account for deficiencies.
• Interfacing with internal and external stakeholders to collect feedback, respond to inquiries, and problems resolving.
  

• Undertook media data analysis to evaluate the effectiveness of leading automakers’ marketing efforts.
• Made significant contributions to all aspects of several projects: filtering and organizing data, verifying data authenticity and quality, analyzing data with Excel, drafting reports, preparing presentations.
• Ensured the project's progress and smoothness through active follow-ups and communication with colleagues and clients.
• Developed a strong work ethic; honed skills in data analysis and logic reasoning.

• Developed in Visual Basic for Applications and Bloomberg

• Based on Principal Component Analysis Model

• Developed in SAS and MATLAB

• Based on Wavelet Neural Network Model

• Developed in SAS

• Based on Neural Network Model

• Developed in SAS and SPSS

• Based on Principal Component Analysis Model

• Developed in SAS and SPSS

• Based on Multi-Linear Regression Model and Factor Analysis Model

• Developed in SAS and Eviews

• Based on Structure Effect and Technology Effect