• 8 years experience in complex statistical modeling using SAS, SPSS, Excel and Access • SAS Certified Base Programmer for SAS9 • Strong numerical and analytical skills • Good understanding of statistical techniques and analytical site forecasting methods • Solve business problems, gather data, transform databases, perform research analysis against data warehouse, interpret data and publish/generate reports • Proven organizational, time management and multi-tasking skills and ability to work independently while being a good team player who enjoys delivering high quality work
SAS Programmer/Analyst, Optionslam.com, Toronto (2006 -- present)
• Designed statistical summary tables, graphs, and stock listings • Created datasets and generating reports using PROC Tabulate, PROC Report, SAS arrays, PROC SQL and MACROS • Developed SAS MACROS for data cleaning and Reporting and to support routing processing • Responsible for data mining and multivariable statistical analysis for leading online trading website (Base SAS/STAT) • Create Statistical reports based on historical price movements vs. current options straddle cost (SAS, Excel) • Analyze volatility changes before and after earnings (SAS) • Create data model to trace daily price changes and create report to optimize trade picking algorithm • Evaluate SAS tool and develop scripts to demonstrate the statistical results • Develop trading rules and models for risk management
Research Assistant, TNY Consulting Inc., Toronto (2005)
• Created & maintained data entry application with SAS • Created SAS data sets, cleaned data, extracted data and merged data sets using Base SAS, SAS/SQL & SAS/Macro • Read data from Excel and flat files into SAS and transferred data between databases • Run routine program using to create data listing, tables for researchers • Conducted statistical analysis using SAS • Produced CSV, RTF and HTML files using SAS/ODS • Provided programming support to data analysts • Queried data using SAS/SQL
Sr. Statistician, Statistical Center, Ministry of Railways, China (1986 -- 2004)
• Applied sampling investigation method and used correlation and time series analysis to evaluate the transportation demand and forecast passenger and freight traffic volumes for planning department (SPSS) • Provided consultation expertise on national transportation scheduling strategy (5000 railway stations) • Tracked the funding allocation, project status, and procurement activities for Chinese national railway (10 billion CDN Annual Budget) • Managed statistical bulletins and composed statistical yearbooks for Ministry of Railway • Processed and analyzed mass quantities data electronically on daily basis (SAS/SQL) while ensuring data quality and integrity • Imported and exported data sets between DB2, Excel, Access and SAS • Conducted and generated daily, monthly and yearly statistical reports based on the routine analysis on the following items of entire National Railway network (SAS, BO): ? Passenger and Freight Traffic Volumes, ? Operation of rolling stocks ? 2.4 million employee contracts, wages, salaries, and benefits ? Fixed assets investment ? Transportation revenues and expenditures
EDUCATION & TRAINING
SAS Certified Base Programmer for SAS9 (2008) SAS Institute of Canada, Toronto, ON
Accounting, Maple Leaf College, Toronto, Canada (2006)
Master of Statistics, Beijing JiaoTong University, China Relevant Courses: • Statistical Inference I & II • Multivariate Data Analysis and Applied Statistical Linear Model • Database Management
Bachelor of Economic, Beijing JiaoTong University, China Relevant Courses: • Probability & Mathematical Statistics • Principles of Statistics • Cobol programming and Data processing (dBase)
Certifications
SAS Certified Base Programmer for SAS9
CONTACT DETAILS
You must be logged in and have a current resume access subscription. Login or Register »