Rebecca Bai Email & Phone Number

Canada

Toronto, Ontario, Canada

Toronto, Ontario, Canada

- Leveraged Alteryx macros, SQL and advanced Excel functions to efficiently clean, consolidate and analyze over 15 million transactions of client point of sales data and developed criteria for outlier and variance analysis; prepared dashboards and reports to present key insights and trends to stakeholders along with enabling a data-driven process to identify retail locations for audit compliance testing - Built an automation script with Python Selenium and Pandas to reduce time spent on client data preparation and analysis from a few hours to under 20 minutes- Worked closely with team members to understand business needs and collect feedback, in order to deploy and present a data repository solution using Power Apps for improving user experience in navigating business data for an internal team of 15+ employees- Helped expand team capabilities in the areas of data governance and data visualization, through researching and compiling best practices, preparing Powerpoints for internal and client needs, creating visualizations with Python and Tableau for unstructured business data, and documenting the processes and technologies used to facilitate knowledge transfer

Toronto, Ontario, Canada

-Supported various initiatives and projects, including analyzing and creating costing rates, performing cost analysis and reconciliation, and developing assumptions for financial models -Developed a comprehensive financial view of costs for all business lines through reconciling and integrating financial data from IBM TM1 database into Tableau with Excel and SQL queries, to provide greater transparency of cost drivers across organization-Leveraged financial data through developing dynamic Tableau views and visualizations to analyze data trends and perform ad hoc calculations -Completed Automation Designer Level 1 training course and developed automation in Blue Prism to reduce time spent on a business process by 70%

Toronto, Ontario, Canada

-Used macros in MS Excel to update and prepare quarterly exhibits of reserve data for analysis and accurate reporting of the performance of 20+ subsidiaries -Reviewed and analyzed fair value reserve data with pivot tables and advanced excel functions to compare KPIs and helped identify areas of concern and resolve it with manager, allowing for successful reconciliation of financial data -Analyzed historical premium triangle and vector data in ResQ using chain-ladder method and BF method to estimate IBNR reserve amounts, to ensure efficient operation of subsidiaries-Worked independently and collaboratively with manager and actuarial team to prepare an informational presentation highlighting the benefits and methods of implementing ESG as a business strategy

Toronto, Canada Area

-Handled calls and provided customer service regarding lost pets and insurance claims through phone and Live Chat -Scanned and compiled time-sensitive customer insurance documents, categorized and uploaded to the company database-Worked independently and collaboratively with managers, co-workers, and other business units to conduct a time study by tracking data in MS Excel, and reducing inefficiencies

Bachelor'S Degree, Financial Mathematics

11-12

Activities and Societies: Design club co-founder, OT Robotics Team