Experience

IDC Canada

• Canada
• Market Research
• 1 - 100 Employee

• Statistical Analyst / VBA Programmer

  • Oct 2010 - Present

  •Wrote scripts in SPSS and VBA to automatically clean raw survey data and generate various statistical reports •Developed and improved 6 business forecasting model by using VBA and Excel •Developed a Macro which can automatically fill formula into more than 12,000 cells based on different rule •Supported analysts to do statistical analysis based on various survey data by using cluster analysis, Decision Matrix, Factor analysis, Correspondence Analysis and Perceptual Map •Provided… Show more •Wrote scripts in SPSS and VBA to automatically clean raw survey data and generate various statistical reports •Developed and improved 6 business forecasting model by using VBA and Excel •Developed a Macro which can automatically fill formula into more than 12,000 cells based on different rule •Supported analysts to do statistical analysis based on various survey data by using cluster analysis, Decision Matrix, Factor analysis, Correspondence Analysis and Perceptual Map •Provided data cut service for analysts to meet their needs Show less



Crosssmart.com

• PHP Programmer(Part Time)

  • Jul 2010 - Dec 2010

  •Set up the website by using PHP, MySQL, HTML, DHTML, CSS, and JavaScript •Maintained the website for backing up the database, updating the information and modifying the contents



Sqlor.com

• China

• SAS Programmer (Freelancer)

  • Sep 2007 - Sep 2010

  Developed 5 commercial SAS applications: 1)SAS reporting system which generated daily statistical reports for each of 5000 stocks in USA and China stock market based on billion level data sets 2)SAS Stock screener to search stocks based on 80 financial criteria 3)27 financial indicators which expanded SAS built-in financial functions 4)A series of SAS Macros which enabled analysts to draw 28 stock charts 5)A SAS-based stock analysis system with a similar function as MetaStock… Show more Developed 5 commercial SAS applications: 1)SAS reporting system which generated daily statistical reports for each of 5000 stocks in USA and China stock market based on billion level data sets 2)SAS Stock screener to search stocks based on 80 financial criteria 3)27 financial indicators which expanded SAS built-in financial functions 4)A series of SAS Macros which enabled analysts to draw 28 stock charts 5)A SAS-based stock analysis system with a similar function as MetaStock (#1 stock analysis software) Show less



Concordia University

• Canada
• Higher Education
• 700 & Above Employee

• Research Assistant / Math Touring

  • Sep 2007 - May 2010

  • Proposed 1 and improved 2 forecasting models based on Grey Model, ARIMA Model and Wavelet Transform • Tutored students for all undergraduate level math and stat courses



HostingDoor.Net

• Web designer (Freelancer)

  • Jan 2004 - Jan 2010

  • Designed and developed more than 300 websites based on PHP and Mysql • Maintained around 110 customers’ websites in 3 Linux servers • Supported customers for various technical problems



Sinohydro Corporation Beijing Bureau 2.

• System Engineer/Computer Technician

  • Sep 1996 - Jul 2003

  • Responsible for the full development of company's infromation system • Provided programming support to data analysts • Fixed assets investment • Queried data using MS-SQL • Created Statistical reports based on historical data (Excel) • Created datasets and generated reports using MS-SQL. • Developed SQL Stored Procedures to support routing processing, such as data cleaning and reporting • Transferring and migrating datasets between Excel, Access, Foxpro, MS-SQL. •… Show more • Responsible for the full development of company's infromation system • Provided programming support to data analysts • Fixed assets investment • Queried data using MS-SQL • Created Statistical reports based on historical data (Excel) • Created datasets and generated reports using MS-SQL. • Developed SQL Stored Procedures to support routing processing, such as data cleaning and reporting • Transferring and migrating datasets between Excel, Access, Foxpro, MS-SQL. • Conducted and generated statistical reports based on the routine analysis Show less