Data Analyst

Jingwei (James) Cao

***-*** ********* ***** ***********, ON L5B 4K2 416-***-**** *******.***@****.********.**

SA

As a dedicated and knowledgeable professional with strong qualifications and experience in SAS and SQL programming and database analytics, I seek to bring my skills and abilities to add value to your company.

Hands-on experience in analyst-related positions conducted on statistical and econometric models and reporting various KPIs/metrics and dashboards to support insights regarding company operations.

Proven track record of success in utilizing SAS, SQL, R, Excel and VBA to manipulate, filter, aggregate, and analyze complex datasets.

Strong background in business intelligence operation cycle flows including data mining, data interpretation, automated and ad hoc reports, data development, statistical tests and related post analysis.

Excellent ability to leverage insights from large data to propose strategies and recommendations.

Successfully delivers complex technical matters in a clear, concise manner within tight timelines while maintaining open communication with stakeholders and senior management.

Advanced computer performer with software knowledge covering Microsoft Word, PowerPoint and Excel (V/H Lookups, Pivot Table, Sum/if/s, Count/if/s, Graphing, VBA).

Education

Honours Bachelor of Science, Economics and Mathematics, University of Toronto Mississauga, 2015

SAS Certified Base Programmer for SAS9, Score: 100%, SAS Institute Inc.

SAS Certified Advanced Programmer SAS9, Score: 100%, SAS Institute Inc.

SAS Certified Statistical Business Analyst: Regression and Modeling, Score: 90%, SAS Institute Inc.

Professional Experience

INTERNATIONAL CREDIT EXPERT INC. North York, Ontario

Data Analyst, June 2016 – Present

Perform extract, Transform and load (ETL) process by implementing SQL script; transfer and clean the huge raw dataset into trend analysis formats.

Produce pre- and post- campaign analysis by identifying revenue opportunities and assisting marketing to form the campaign strategy.

Extensively utilize Excel (V Lookups, Sum/if/s, Count/if/s, Charts) to automate revenue & payment reports which presented individual and organizational level performance.

Enhance company inventory reporting procedures by designing Excel templates and building Macros using Visual Basic for Applications(VBA), helping directors to access inventory information accurately and efficiently.

Develop, update and publish the call center operation analytics and dashboards, such as the Agent Performance dashboard, Call Dialer Penetration dashboard.

Review KPIs and reporting metrics (call abandon rate, call count rate) daily to improve operational efficiency within the company.

Fluently participate in business meetings by preparing Internal Call Volume Log reports, meeting clients’ requirements and getting high praise from directors.

METRO COLLEGE OF TECHNOLOGY Toronto, Ontario

Data Analyst – SAS, December 2015 – June 2016

Retrieved and profiled samples from large dataset containing 32,264 cases of bank customers.

Utilized SAS SQL Macro to extract, transform, clean and merge source data from databases and write SQL scripts to manipulate data for data loads and extracts.

Performed exploratory data analysis, regression models and correction analysis to analyze potential marketing campaign aimed at encouraging customers to select bank’s products and services.

Employed hypothesis testing including ANOVA test to test for differences between credit score and other independent variables.

Compiled and presented statistical findings using graphs, summaries and tables, then use data to draw conclusions and recommend plans aimed at increasing revenue streams.

Advised the suitability of methodologies and suggest process improvements and enhancements.

STONE BRIDGE UNITED CANADA Mississauga, Ontario

Logistics Assistant Manager, July 2015 – June 2016

Ensured all orders are shipped within established shipping schedules and achieve 100% accuracy for all orders processed by monitoring daily reports.

Performed a wide range of accurate and efficient data processing including data entry, data auditing and credit data reports, and actively monitor all data for accuracy.

Maintained clients’ database and extract information needed from large amounts of data.

Continuously updated requests from clients using the company’s system to meet all clients’ need.

Effectively liaised with internal departments to contribute high quality operational feedbacks.

Generated monthly expense reports so as to provide recommendations to reduce costs.

LUMACARE North York, Ontario

Survey Analyst, November 2015 – February 2016

Designed employee satisfaction questionnaires and made recommendations for distribution formats through actively coordinating with HR manager.

Analyzed employee satisfaction survey data based on each survey’s questions so as to make relevant suggestions for enhancements based on responses.

Received recognition for providing high quality survey reports to HR Manager and the Senior Team.

Contact this candidate