Mike Li
Email: ****.**.****@*****.***, Phone: 647-***-****
*** ******* **. ****. *******. ON. M4Y 1T5
CAREER OBJECTIVE: To seek a challenge position in financial industry.
QUALIFICATIONS
More than 3 year Professional experience in financial industry
More than 5 years experience in marketing data analysis, statistical model development, and risk
management
More than 5 years experience using T-SQL, SAS Base, SAS Enterprise Guide and SAS
Enterprise Miner to check and prepare data, to do marketing & competitive analysis report
Highly advanced skills in Excel (pivot table, charts, lookups, advanced functions and marco),
Access, Word, PowerPoint and Outlook to provide regular analysis and business report
Proven ability to transform data into meaningful information and value-added analysis
Creative thinking and analytical skills to review processes, build process flows, and identify
opportunities for improvement
Thoroughness and accuracy when collecting, analyzing, interpreting and documenting large
volume and fairly complex information in an organized and comprehensive manner, often under
tight deadlines
Strong customer service skills with an eye for details and problem solving abilities
Detailed-oriented, self-motivated, resourceful and supportive team player with outgoing nice
personality
WORK EXPERIENCE
Data Analyst, Bank of Rizhao Shandong
May 2012- June 2013
Participated in conducting credit risk report;
Extract and manipulate raw data to enable analysis, tracking and portfolio monitoring including
write-off rate, automated decisions, approval rate and override rate;
Organize several manually generated forms into database to be used for tracking report
Marketing Data Analyst, Meiraku Group (JP), Co.,Ltd Beijing
Nov 2011- Apr 2012
Extract and manipulate raw data by SAS Base to enable analysis, strategy development,
tracking and portfolio monitoring cross-functional groups to accomplish objectives resolve
complex marketing issues
Analyzed financial reports from various departments: marketing, sales, communication,
purchase and production
Analyzing business data and identifying opportunities to improve operational efficiencies
Evaluated the monetary impact on business of various business proposals
Controls cost and minimizes risks while simultaneously driving desired results for bottom-line
profitability
Customer Service Representative, Future Wireless Communication (Fido), Toronto
Nov 2010 – Oct 2011
Customer Liaison& Service: Contract Negotiations/ Account Development
Sales Growth: Consultative Sales /Needs Assessment
Retail method of accounting
Sales Training & Team Works
Research Assistant, University of Guelph
SEP 2008 - DEC 2010
Developed the conceptual & empirical framework and built model to assess the impact of the
possible reduction in provincial slaughter capacity on Ontario hog growers
Used SAS base to made data chart presentations, coded variables from original data,
conducted statistical analysis, provided summaries of analysis.
Conducted the statistical graph by using SAS & MatLab
Provided marketing strategy development for Ontario Pork
EDUCATION
Master of Science--Agricultural Food Resource Economics 2010
University of Guelph, Canada
Financial Analysis, Contingency Planning,
Marketing & Competitive Analysis
Stochastic Processes, Fixed Income Investment,
Ontario Pork Project & Risk and Stochastics Project
Graduated Research Contribution for Ontario Pork Project (SAS Simulation Model)
This research used SAS to provide a model of the North American live hog trade to assess the impact
of the potential reduction in Ontario slaughter capacity (transportation costs study included) on the
financial welfare of Ontario hog growers.
Bachelor of Arts (Hons) in Economics (4.0 GPA) 2008
York University, Canada
Foundation Economics, Mathematics and Statistics
Accounting & Mathematics
Economics & Statistics
Business Finance & Marketing
Advanced Trainging -- SAS Base & Advance Training Course
Kennedy College of Technology, Canada
Manipulating and converting data by using SAS functions
Process data using DO LOOPS and SAS arrays
Generating Reports and Handling Errors
Professional Designation CFA (In Process)
Interest Soccer, Basketball and Swimming