Minghao Li (B. Statistics & Mathematics)

Tel: 647-***-**** Email: ac86gb@r.postjobfree.com

BACKGROUND SUMMARY

Received Bachelor of Statistics & Mathematics degree from McMaster University in 2019 with strong analytical capabilities and excellent quantitative/statistical analysis skills.

A certified SAS programmer with 10 months of customer data analyses and business analytics experiences in financial banking industry.

In-depth knowledge and understanding of financial banking, Customer Relationship Management

(CRM) and database marketing. Proficient in customer segmentation and profiling, customer loyalty and value analyses, campaign analyses and developing competitive strategies.

Advanced expertise and skills in applying industry-leading analytic tools (SAS/SQL/R programming, BI Query, Oracle BI, SAS Visual Analytics, Tableau, Excel etc.) to explore, query, manipulate, analyze and visualize big data.

Adept at creating dynamic Excel/RTF/PDF/HTML reports and insightful dashboards using SAS/Base, SAS/Graph, SAS/MACRO, SAS/SQL and ODS techniques.

A detail-oriented and self-motivated person with strong analytical and problem-solving abilities, able to perform multiple tasks and meet tight timelines in a fast-paced environment.

A good team player and a quick learner with excellent communication, teamwork and interpersonal skills.

TECHNICAL SKILLS

Databases: Oracle, DB2, and SQL Server.

Operating System: Windows, Unix, Linux.

Application packages: MS Word/Excel/Access/PowerPoint, Publisher, SharePoint. Tableau. Oracle BI. SAS Tools: SAS9.3 Programming (SAS/Base, SAS/SQL, SAS/Macro, SAS/STAT, SAS/Graph, SAS/Access, SAS/ODS), SAS Enterprise Guide, SAS Studio. Data Exploration and Manipulation

Data extraction, validation, cleansing, aggregation, manipulation and analysis (sort, dedupe, subset, append, merge, join, roll-up, drill-down, etc.) by applying SAS Data step, SQL, Macro and Array approaches.

Statistical Analysis

Student’s t-Test, ANOVA, Chi-Square Test, regression analysis, time series etc. Data Reporting and Presentation

Create strategic and insightful dashboards and dynamic Excel/PDF/HTML/RTF reports using SAS programming, SAS visual analytics, Tableau, Excel tools. Adept at using Excel to generate interactive Pivot Tables and Pivot Charts.

RELEVANT WORK EXPERIENCE

Data Analyst (Intern) 2017--- 2019

Bank of China, Guangzhou, Guangdong Province, China

Ran SAS/SQL programs to generate monthly, quarterly and annual customer metrics and business intelligence reports; reviewed and validated reports by comparing to existing customer metrics.

Accessed Oracle and SQL Server relational databases to extract customer data and business data through SAS and SQL programming.

Conducted data cleansing, validation, manipulation and analysis (sort/dedup, subset/append, merge/join, roll-up/aggregate etc.) via Data Step, SQL, Array and Macro techniques.

Leveraged and analyzed customer and sales data to report and study on the sales trends, product penetrations and performances, customer distributions and purchase patterns.

Performed customer segmentation, profiling and correlation analyses based on various criteria to investigate the demographic and behavioral characteristics of financial customers and identify high value customers.

Created analytic reports with insightful tabulations, plots, charts and interactive Pivot Tables and Charts using SAS/SQL programming, Oracle BI, Tableau and Excel tools to identify marketing opportunities, grow customer insights and business intelligence.

Maintained accurate and comprehensive documentations of project materials, such as project specifications and requests, Email communications, SAS/SQL code, analytic reports (Excel, PowerPoint, PDF etc).

EDUCATION AND TRAINING

Bachelor of Science – Statistics and Mathematics 2019 McMaster University, Hamilton, Ontario, Canada

Main Courses: Financial Markets Derivatives, Mathematical Finance, Actuarial Mathematics, Applied Regression Analysis with SAS, Mathematical Statistic, Statistic Method Application, Marketing, Accounting, and Intermediate Macroeconomics/Microeconomics.

SAS Certification for Advanced Programmer for SAS® 9 2018 SAS Certification for Base Programmer for SAS® 9 2018 Tableau Essentials Training 2017

Bank of China, Guangzhou, China

Oracle Business Intelligence (OBIEE) Training: Create Analyses and Dashboards 2017 Bank of China, Guangzhou, China

Advanced Excel and Access Workshop 2016

McMaster University, Hamilton, Ontario, Canada

REFERENCES AVAILABLE UPON REQUEST

Contact this candidate