Wendy Wang Email & Phone Number

Calgary, Alberta, Canada

• Prepared daily reports for traders, executives, and board members using Excel and SAS; conducted attribution analysis on profit and loss areas, translating insights into clear and actionable information to facilitate data-driven decision making.• Collaborated cross-functionally with various technical and business teams to develop a Power BI data visualization dashboard, providing treasury critical information on required Letter of Credit amounts, enhancing operational efficiency.• Created new data tables essential for dashboard development by performing extract, transform, and load (ETL) processes using SQL and Python.• Developed and maintained key data processes and models to monitor changes in prices, forecasts, and various metrics (Mark to Market, Value at Risk, hedging strategy, etc.)• Worked closely with traders to ensure accurate hedging of amounts, contributing to the effective management of financial risks and optimization of investment strategies.• Validated auction and price forecast data; confirmed trades with relevant counterparties and ensured accurate data entry in a timely manner with meticulous attention to detail.

Surrey, British Columbia, Canada

• Identified and resolved data storage and retrieval inefficiencies by researching and implementing a data lake that integrates existing databases, significantly boosting operational efficiency.• Migrated crucial data analysis processes from SPSS into R, resulting in annual savings of over $15,000 in licensing fees and improving the flexibility of analysis workflows.• Engineered a robust data cleansing, wrangling, modelling, and analysis pipeline for data insights utilized in published research papers.• Conducted data mining to find key trends, patterns, and correlations, generating actionable insights to drive strategic product improvements.

Vancouver, British Columbia, Canada

• Validated and imported data into various databases. Visualized data in PI System through dashboard development.• Conducted comprehensive economic analysis utilizing data and financial information to assess project viability and presented findings and recommendations to management.