Peng Wan

Toronto, ON 416-***-**** aczxex@r.postjobfree.com

QUALIFICATIONS PROFILE

Results-driven Junior Analyst, with expertise honed through education and professional experience. Eager to optimise systems, improve work processes, and augment business efficiency for a forward-thinking company.

Business Analysis: Proficient knowledge of financial statements, products, economic models, statistics, and accounting. Demonstrable success delivering sales report/credit ratings analyses. Design business improvement initiatives using quality analytics to influence strategic direction, enhance sales forecasting, identify trends, improve customer service, and drive business goals.

Data Collection and Reporting: Excel in retrieving and extracting data from various sources. Expert in data validation, manipulation, formatting, and analysis using cutting-edge tools (SAS, SQL, VBA and Excel). Detail-driven, produce top-quality reports and models to communicate outcomes clearly to a range of audiences.

Database Programming: Record of success designing data programmes using complex technical functions and procedures with SAS, SQL, and Macro. Leverage technology to achieve data automation, increase work efficiency, and improve accuracy. Solid understanding of database structure, fault finding, and resolution.

Key Strengths: Highly analytical and self-motivated with well-honed problem solving skills. Adept at managing independent workload and collaborating with teams to improve knowledge/working practices. Organised and customer focused, able to prioritise and complete multiple complex tasks within strict deadlines, meeting and exceeding targets. Committed to continuous learning and professional growth.

Core IT Skills: VBA, SAS Programming, SQL (MS and SAS), Macro Functions, Database Functions (ETL), Advanced MS Excel, MS Access, MS Word, MS Outlook, MS PowerPoint, Relational Database Methodology, Argic.

EDUCATIONAL BACKGROUND

Master of Arts in Economics • York University, Toronto, ON • 2016

Bachelor of Arts in Economics (Honours) • York University, Toronto, ON • 2015

Certifications:

Canadian Securities Course (CSC) Certificate – Canadian Securities Institute (2016) • SAS Certified Base Programmer for SAS 9 (2016) • SAS Certified Advanced Programmer for SAS (In progress)

EXPERIENCE HIGHLIGHTS

SavvyPro Education, Toronto, ON

SAS Programmer Trainee, Oct 2016 – Dec 2016

Applied economics knowledge and extended professional development in fast-paced, diverse environment.

Extracted, combined, merged, and reconciled data from multiple sources using SAS formats and functions (PROC IMPORT, DATA INFILE, IMPORT WIZARD, INPUT, MERGE, PUT/INPUT etc.).

Delivered projects using most SAS Data and Procedure techniques.

Improved work process efficiencies by using SAS Macro to conditionally process high-volume data.

Debugged SAS programme through comprehensive key word searching.

Analysed credit risk ratings from multiple agencies and created a visualized data graph to present information, using PROC SGPLOT and ODS.

York University, Toronto, ON, Sept 2015 – May 2016

Teaching Assistant, Sept 2015 – May 2016

Delivered classroom and practical session support to students across multiple courses, including Mathematics, Macroeconomics, and Managerial Economics.

Hosted weekly office hour and offered additional appointments for students, to assist learning process.

Honed excellent communication, diplomacy, and influencing skills when dealing with student and classroom questions/grade queries.

Coordinated students, professors, co-workers, and staff from other departments to organize cross-functional activities and resolve student issues.

Invigilated student exams and delivered agile problem-solving in response to exam issues/incidents.

Assisted professors with assessment of student assignments and exams. Utilised Excel to analyse and report on student grades.

York University, Toronto, ON, 2012– 2016

Student (Master of Arts and Bachelor of Arts in Economics)

Acquired and applied knowledge on a range of subjects, techniques, and processes (including econometrics, statistics, industrial organisation, corporate finance, economics, and accounting). Selected key projects include:

Econometrics Analysis (North American Free Trade Agreement’s Influence on Canada and US)

Analysed large-volume data (3600 observations/36 variables) using double difference statistic method.

Extracted data from multiple data file types (txt, sas7bdat, and csv) and database servers through ETL tools, SQL scripts, SAS Proc Import, SAS Infile, SAS Libname, and SAS/SQL.

Organised data and removed, formatted and renamed variables using Proc Sort, Data step Merge, and SAS SQL. Identified correlations between multiple data sources to identify discrepancies.

Designed indexes for key variables using Proc/SQL and Proc Datasets to streamline processing time and reduce computer memory use.

Applied statistics and econometrics principles to test and verify data outcomes.

Exported result using SAS output (ODS) and produced/presented report on economic impact.

Solow Growth Model Analysis (Empirical Data from 158 Countries)

Facilitated group discussion to explore different analytical and data presentation methods.

Extracted, prepared and manipulated large economic data sets. Conducted data exploration, cleansing, validation, transformation, and merging using SQL scripts and Excel.

Automated data preparation using Macro and VBA to significantly reduce time/workload.

Prepared data using Excel V-lookup, H-lookup, Match, Index, Pivot Table and array formulas.

Produced a comprehensive regression model and report evaluating real GDP growth on all countries.

Credit Rating Transition Matrix Report

Built Macro to automatically sort data sets, enabling automation with different variables and removing need for repeated coding, and improving accuracy.

Converted ratings using PROC Format. Constructed artificial data frame using DO Loop in SAS. Formatted rating transition matrix via Proc Freq and Output.

Presented observations in a clear and understandable format using Proc Transpose.

Sales Data Analysis (Large Organisation with 10,000+ Records)

Conducted data preparation, cleansing, and complex analysis using Access, Excel, and Power Pivot.

Designed detailed report identifying key business problems and improvement strategies based on key indicators (shipping costs, logistics methods, locations, taxes, and industry types).

Contact this candidate