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.
• 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.
• 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.