Professional — Marc Cheng

REXEL CANADA ELECTRIC INC.

Product Information Management Team

Developed dataflow control process using AWS CLI.
Developed key functionalities for import and export operations in Informatica Product 360.
Oversaw the entire end-to-end (ERP - TIBCO - PIM - TIBCO - Hybris) testing process in the UAT environment.
Developed a Python application to update product keywords.
Utilized custom SQL queries in conjunction with IBM AS400 to maintain product information stored in IBM DB2.

RexelGPT Beta Testing Team

Participated in RexelGPT large language model project during the beta testing phase.
Provided feedbacks on functionality, helped improved stability.

Anti-Money Laundering Team — Financial Advisory

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.

Valuation Team — Financial Advisory

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.

The company is an online post-secondary education service offering accounting, finance, and management programs.

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.