Data Analyst Service Representative

Hui (Heidi) Wang

*************@*****.***

438-***-**** Montreal, QC, Canada

HIGHLIGHT OF QUALIFICATIONS

* **** ********** ** ********** CRM analysis and campaign analysis to assist marketing teams by applying segmentation, profiling, RFM and cohort analysis

4 years’ experience in Anti-Money Laundry (AML) and Know Your Customers (KYC) / performing Due Diligence on investors, including retrieving and maintaining data from SQL server

4 years’ experience in risk analysis for private equity industry

4 years’ experience in report and dashboard designing by using Power BI and Excel

Sound experience and in-depth knowledge of data modeling for marketing campaign analytics by utilizing SAS data step and procedures (Proc Freq, Proc Univariate, Proc Logistics and Proc Tabulate)

Proficient in Microsoft Office Word, Access, and Excel (pivot table, v-lookup, charts, conditional formatting)

SAS Base and Advanced Programming Certificates

Master’s degree

Strong oral and written presentation and communication skills and ability to work independently with multi-tasks and coordinate with different stakeholders on priority basis

Excellent English and intermediate French

WORK EXPERIENCE

Senior AML Analyst 2018-present

Maples Group, Montreal, QC

Prepare monthly/quarterly AML Compliance Officer (CO) reports to be presented to the board by using T-SQL, Excel, and Power BI

Integrate KYC data sources and analyze data sets of private equity investors to identify potential risks

Update alert data to ensure politically exposed persons (PEPs) or high-risk triggers are timely escalated to COs

Collect and review documentation to meet AML / KYC due diligence requirements based on Cayman Islands and U.S. AML regulations

Liaise with other team members, clients, investors, investment managers, and other third parties in various international jurisdictions

Project1: Generate AMLCO reports by using Access, Excel, and Power BI

Document with a risk-based approach (RBA) ongoing procedure, including corrective measures and follow-up actions

Verify the identities of investors and ultimate beneficial owners (UBOs) and ensure the database information up to date

Support COs in dealing with high-risk situations by performing thorough investigations with recommendations

Project2: Investigate UBOs and apply risk patterns by segmenting suspicious activities (e.g., comparing investment amounts and Source of Wealth), and by filtering investors’ jurisdictions

Data Analyst (Contract) 2021-present

Livebarn Inc., Montreal, QC

Perform ETL from various data sources and perform data cleansing, validation, and manipulation by applying SAS data step (libname statement, format, array, do loop, merge, proc append), Proc SQL and Macro

Perform eCommerce and CRM related analysis including segmentation, cohort analysis and RFM analysis to both subscription-based and non-subscription-based customers to enable marketing teams to optimize targeting strategies and improve retention

Develop monthly performance report using Tableau

Project1: Perform Cohort Analysis by segmenting subscribers into cohorts to understand their life cycle, observe how their behavior change over time, and improve the retention rate of the lowest performance cohort

Project2: Assist marketing team’s up-sale by utilizing RFM analysis to determine targeting customers who would subscribe different services by using SAS data step and Procedures

Project3: Generate weekly/monthly sales reports based on various subscribed products and customers’ locations by using report tools (SAS/Graph, Macro) to achieve flexible and automated reporting

Administrative Support Intern (Co-op) Jan/2017-Apr/2017

CGI Montreal, QC

Created and updated Project Contract Billing (PCB) invoices

Validated and analyzed forecast data prior to the pay cycle process by using Excel

Chinese Teacher and Program Coordinator 2014-2015 International Leadership of Texas High School, Garland Division, Texas, USA

Analyzed students’ performance and attendance rates by using Excel and Tableau

Child Support Officer 2013-2014

Attorney General of Texas, Dallas Office (Region 406) Dallas, Texas, USA

Assisted staff with court documents

Provided support to establish and enforce child support cases

Customer Service Representative 2011-2013

Willis Library at University of North Texas (UNT)

EDUCATION

Bachelor of Commerce 2018

Concordia University, Montreal, QC, Canada

Master’s Degree 2013

University of North Texas (UNT), Texas, United States

Bachelor’s Degree 2010

Beijing International Studies University (BISU), Beijing, China

Contact this candidate