Experience

Rexel Canada

• Canada
• Wholesale
• 100 - 200 Employee

• Product Data Specialist

  • Jun 2023 - Present



Deloitte

• Business Consulting and Services
• 700 & Above Employee

• Data Analyst Intern

  • May 2021 - Apr 2022

  • Validated anti-money laundering models for Scotiabank. • Assessed methodology in R and Python scripts provided by the client; independently completed the validation of 8 models. • Extracted transactional data, including cash transactions, wire transactions, and monetary instruments transactions from Oracle database; extracted 4,000,000-20,000,000 entries of transactional data using SQL queries. • Performed data quality assessment and data lineage using Jupyter Notebook; checked the integrity of the data; sampled alerts with the proposed threshold using R, Python, or SAS; spotted potential errors and misfires. • Validated models for the loyalty marketing industry; used SQL Server Management Studio to analyze client SQL scripts; calculated redemption rates and breakage rates; validated client’s results. • Valuated derivatives such as interest rate swaps and foreign exchange forward for the Canadian financial industry; valuated commodity swaps for the Canadian energy industry. • Extracted fix-float rate, foreign exchange rate, historical price, and future contract price of commodities independently using Bloomberg Terminal. Show less



Sunlands Technology Group

• China
• E-Learning Providers
• 1 - 100 Employee

• Quality Assurance Intern

  • Jul 2019 - Aug 2019

  • Monitored sales and customer service through an integrated call recording system (100 records/day). • Filed reports about aggressive sales tactics; helped to improve customer experience. • Filtered through about 50000 entries of customer information exported using SQL. • Created pivot tables from the data mentioned above; analyzed the performance of 6 company sub-divisions based on pivot tables in Microsoft Excel. • Detected a flaw in the awarding system of the company that the employees could potentially exploit; gave a presentation within a group of 5 people, including the superior; led the discussion and drew a conclusion on what could be done about the issue. Show less