Sign in

Manager Data Analyst

May 31, 2017

Contact this candidate

Andrew Wei

Telephone: +***-********* E-mail:

Work Experience and Transferrable Skills

Apr. 2015 - Present

Data Analyst, AML Risk Office, Internal Control, Western Union

Co. Dublin, Ireland

• Using programing skills (SQL, R, Matlab, Tebleau) to designed the consumer score card model independently base on big transactional data as a periodic dashboard review to monitoring consumer activities to mitigate AML risks for more than 30 EU countries.

• Collaborate with Oversight Activity Manager and the Risk Assessment team located across EU to evaluate the effectiveness of the AML controls based on (not limited to) the local regulations and design follow up actions when needed.

• Finding consumer communities in very large dataset/consumer networks and analysis the behavior of each consumer community in R. Practice statistics methodology to identify abnormal pattern and mitigate the potential risk by detect the red flags with minimal supervision.

• Excellent numeracy skills of analyze and interpret data from a wide spectrum of sources, both quantitative and qualitative and use suitable data mining/manipulation techniques to validate the performance of IT controls and processes to advise AML Compliance stakeholders.

• Knowledge of global anti-money laundering regulations, especially for EU regions and money-transfer and business payments regulatory environment and design and execute big data analysis at country or cross-country level. Able to detect the control blemishes such as refund and cross border transactions and quantify the risk based on big data analysis.

• Ability to interact effectively, orally & in writing, with all levels of management as a business and data analyst with track record of delivering analytical reports and summaries, including writing complex queries and maintain data analytics sources, tools for compliance and audit purpose.

• Flexible to change priority to meet deadlines and balance the works which had been planned and prepare for the ad-hoc outside of the team.

• Provide support to the team and on-boarding of new hires, particularly from a data analytic technical and AML compliance training perspective.

Jun. 2014 – Apr. 2015

Data Analyst Financial Intelligence Unit, Western Union

Co. Dublin, Ireland

• Maintain records of identified AML risks/threats within countries of the European region and provide support and recommendations to the management.

• Use suitable data mining and manipulation techniques to validate the performance of AML controls and processes.

• Advise AML Compliance stakeholders on system based/information technology control best practices within their processes to reduce AML risks.

• Review and investigate referrals of suspected fraudulent and suspicious trends and patterns utilizing data analytics skills.

• Monitoring data with the capability of identifying unusual patterns and trends proactively, documenting and sharing the findings to others within the business.

• Building statistics models with data analysis soft wares alone to identify areas/countries that require increased control measures to protect the consumers.

• Document and maintain records of identified risks/threats within countries of the European region and provide support and recommendations to the management.

• Participate in special projects by conducting specific and technical review/investigation activities.

Feb. – Jun. 2012

Henan Province, China


Personal Business Trainee of Industrial and Commercial Bank of China

• Collected data to produce monthly financial reports to engage with multiple mangers.

• Developed quarterly and annual sales forecasts by building models, analysis data that support financial transactions used by more senior staff.

Oct. 2010 - Apr. 2011:

Trader of Xiamen Zhongjin Trading Company

Fujian Province, China Intern

• Informing all relevant parties of the most relevant trades for the day.

• Gathering information, carrying out detailed analysis and valuation model with multiple soft wares to predicting markets movement for instant decisions.

• Proving in-depth market reports and identifying issues affecting clients, developing client relationships and presenting ideas to clients.

• Obtaining market prices from market-making traders and executing the trade.

May – Sept. 2011:

Assistant to the manager in Kelta (China) company.

Guangdong Province, China

Summer Intern

• Proposed identified and developed new opportunities through the internet and gathered useful information to send to managers.

• Designed different digital magazines for B2B and B2C customers to develop a high level of understanding of Kelta’s products and services.

May – Sept. 2010:

Assistant to the finance department manager in the Shuanghui Group.

Henan Province, China

Summer Intern

• Undertook financial calculations to assist the management decision-making. Developed an in-depth understanding of the company.

• Answered questions directly from internal stakeholders or external agencies, such as customers or suppliers.


2013 – 2014:

MSc of Quantitative Finance at Michael Smurfit Graduate Business School UCD.

Results: 2:1 Honors.

Main Modules: Fixed Income Securities, Numerical Methods, Portfolio & Risk Management, Derivative Securities, Financial Econometrics.

• Used Matlab & Excel to perform a regression analysis to examine the determinants of gold price.

• Tested the of the size effect of FUSTE 100 using excel and Matlab.

• Constructed level and slope hedge for fixed income securities using Excel.

2012 – 2013:

Xiamen University Wang Yanan Institute for Studies in Economics (WISE).

Main Modules: Financial Statement Analysis, Probability, Stochastic Process, Time Series Analysis, Financial Economic.

• Estimated and back tested the residual of the GARCH model using R.

• Sketched efficient frontier to find the best portfolio of NASDAQ with Excel.

2009 – 2013:

Xiamen University TKK College. Results: 86% average, equivalent to 1:1 Honors.

Bachelor of International Business and Trade.

Main Modules: Currency Banking, Financial Management, International Business and Negotiation, Securities Investment.

• Research on Transnational Electronic Information Corporations’ Location Choice in China and Its Determinants Based on GVC. (2012) Published in International Conference on Information Management.

• Research on the Inflation Pushed by Foreign Currency and Its Corresponding Control Measures Including Comments on the Hypothesis of Imported Inflation. (2010)


-Strong knowledge of SQL, R, Tebleau, ACL, Matlab, SAS, Stata, Bloomberg, Excel-VBA, Python, Hadoop, EView, Microsoft Office, Excel - PivotTable, Word, PowerPoint, Prezi

-Fluent in Chinese and English: working in the European head quarter of an international company for about 3-year.

Contact this candidate