Kenneth Zhou, Cfa Email & Phone Number

Edmonton, Alberta, Canada

Edmonton, Canada Area

Edmonton, Canada Area

Liquidity reporting and analyticso Test and build liquidity models in R and Python to efficiently perform analytics (such as scenario and sensitivity analysis), aggregate and visualize results in Power BI to assist senior management with risk monitoring processo Research about investment liquidity management in the current industry and develop alternative analytics to improve the models and better interpret AIMCo’s liquidity position across asset classes and strategieso Prepare monthly liquidity reports and presentations for the liquidity committee members, and provide senior management with an understanding of AIMCo’s current liquidity positionLiquidity Power BI Dashboardo Redesigned to visualize four liquidity reports in Power BI, which presents AIMCo’s current liquidity coverage ratios and liquid assets positions with stressed and scenario tests o Developed “What-if” sensitivity analysis functions on the Power BI dashboards for readers to dynamically view the liquidity metrics under user-defined inputs and market stressed scenariosCash Forecasting and Management Systemo Invented a cash management algorithm to turn all decision making and manual works into a robotic process, where it calculates the most optimal cash movement option on all accounts based on their current credit and debit rate, to create additional value for AIMCo and our clientso Built sensitivity models on all holdings in the prime brokerage accounts to calculate the optimal level of cash necessary to maintain the margin requirement as well as to earn the highest rateo Implemented Seasonal Auto-regressive Integrated Moving Average (SARIMA) model in R to forecast pension clients’ cash inflows and outflows based on their historical patterns; the forecast are visualized in Power BI with their 95% confidence interval bands

Edmonton, Canada Area

Responsibilities:• Collect, analyze and synthesize data into clear, concise and professional reporting that meets the relevant standards and style requirements (e.g. reports on progress toward performance measures).• Lead preparation and updating of the data required for department, branch and ministry reporting to ensure accurate and relevant information is presented in a meaningful format.• Respond to specialized requests for data from internal and external stakeholders Achievements:• Capital Projects Announcement Road-map reporting platform development• 2016/17 year-end capital project accrual process management

Edmonton, Alberta, Canada

Responsibilities:• Manage payment process for all capital investment projects, manage accounts payable data and process invoices submitted by vendors in compliance with all regulatory procedures including researching the insurance and workers’ compensation status of the vendors’ entities• coordinate and complete distribution of various reports to internal and external stakeholders as requiredAchievements:• Led and managed the Capital Grant projects under the Lodge Renewal Initiative Program and the Health and Safety Upgrades Program• Systematic data validation for the new implemented business platform - Microsoft Dynamics CRM• Assisted in the capital budget planning process for the 2016/17 Capital Preservation and Improvement projects