Hung Sun(Philip),Chan Home Phone:1-514-***-****

**** ***** ***** #* *****: hsp_cha @hotmail.com

Montreal,Quebec,Canada,H4N 3G9

Career Objective:

A challenging position of the Junior Data Scientist with Statistical environment using SAS / SPSS.

Summary of Qualifications :

About 8 years of professional experiences of SAS Programming in Clinical, Market and financial industry

Experiences in Statistical model theory(such as General linear, Regression, Bayesian, Factor analysis, Repeated Measure, ANOVAs etc)

Experiences in SAS BI components- SAS Enterprise Guide

Experience in back-end database such as Oracle, MS -Access, SQL-Sever

Extensive experience in SAS/Base, SAS/STAT, SAS/MACROS, SAS/SQL,SAS/Connect, SAS/ODS, SAS/ACCESS,SAS/GRAPH,SAS/QC,SAS/ENTERPRISE GUIDE, SAS/ETL, SAS/STAT.

Extensive experiences in SAS/REPORT generating procedure like PROC SUMMARY,PROC FREQ, PROC MEANS,PROC REPORT,PROC TABUALATE, PROC UNIVARIATE,PROC FORMAT, PROC TRANSPOSE etc..

Good experience using SAS/GRAPH procedures, exclusively PROC GPLOT,PROC GHART

Experiences in SAS/ETL(Extraction, Transformation and Loading ) with Access connectivity.

Generated Reports, Summaries, Graphs and Tabulates as per company standards

Interacted with senior statistician or programmer to provide SAS programming in analyzing the data, generating reports, tables and graph

worked on phase II,III clinical trials performed clinical data analysis and generated SAS dataset in accordance with the SOP and guidelines.

Generated output files in RTF, HTML and PDF using SAS/ODS

Performed data extraction from database and flat files. Conversion of SAS Datasets to various file types(including Excel, MS-Access and flat files)

Hands on experiences in data management like Merging, concatenating, interleaving SAS datasets using merge and set statements in data step and using PROC SQL.

Good knowledge of Drug Development processing including all Clinical trial phases I-IV

Excellent in analytical, problem solving skills and work independently as well as in the team.

Technical Skills

SAS Tools: SAS V9,9.13,9.2, SAS/SQL,SAS/STAT,SAS/BASE,SAS/GRAPH,SAS/REPORTS,SAS/ODS,

SAS/ACCESS, SAS/MACRO, SAS/OR,SAS/EG etc

SAS Procedures: Report, Print, Printto,Freq, Means,Summary, Univariate, Sql, Sort, Transpose, dataset, Import, Export, Format, GLM, ANOVA, Mixed, Gplot, Gchart, Sgplot,Reg, etc

Statistical Tools: SPSS, R, Statistica, JMP,SAS, Stata, Minitab,

Database : SQL,MS-Access, SQL sever

Programming Languages: SQL,PL/SQL,C,C++,Python, matplotlib, R, S plus, SPSS, Maple

Offices Tools: MS-OFFICE( MS-Access, Excel, Word, PowerPoint)

WORK HISTORY:

SAS Upgrade( Self Study), Montreal, Quebec, Canada December 2015-Present

Responsible:

Upgrade new version SAS from 9.0 to 9.4

Study proc CDSIC procedure to create or modify to STDM or Adam dataset

Develop new macro procedure or function for the analyst .

Combined and Modified SAS dataset for statistical analysis using SAS data step and procedures including PROC SQL

Environments: Windows, SAS( Base, Stat, ODS, Graph, SQL, Enterprise Guide), Microsoft office, Python XML

Programmer Group (Contract, oversea) May2013 -Nov 2015

Freelance SAS / Statistical Programmer

Responsible :

The data sources and information provided from the pharmaceutical, research or financial client

General Data Management for the ETL procedure to manipulate data,

Build up pharmacokinetics/ Financial model, organize report, table and chart

Generated SAS Program for Statistical analyst / model for the analysis and provide TGL

Apply the regularity methodology or knowledge on the client project or procedure

Generating graphic for reporting purposes using SAS/Graph

Environments: Windows, SAS(Base, Graph, SQL, Stat and Macro), Microsoft Office(Excel, MS Access)

Programmer Group, Montreal, Quebec, Canada Jan 2009-Oct2012

SAS Programmer

Responsibilities:

Data file ( numerical or character) from the clinical/ pharmaceutical research client

Depend on the phase( I,II or III) technique to complete the research or project

Generated SAS Programs for pre-processing data, data analysis and for generating report.

Imported and Exported data files to and from SAS using Procedure like import and export from Excel,various delimited text bases data files such as txt and csv file

Write the SAS Program and ETL procedure to manipulate data for analyses.

Using statistical quality control theory or analyst to processing the data and analysis

Apply pareto analysis theory to set data analyst and chart

Generating graphic for reporting purposes using SAS/Graph

Environments: Windows, SAS Enterprise, SQL Server, Oracle, Microsoft Office(Excel, MS Access)

Programmers Group. Montreal, Quebec, Canada Dec2007-Jan 2009

SAS Developer

Responsibilities:

The data sources and information provided from the market research or financial client

Generated SAS Programs and created macros for programmer or statistician to deliverables like analysis datasets, tables and chart.

Build up the statistical/ mathematical( such as general linear, anova, categorical, multivariate, survival etc) model and analyst with SAS program to process the data

Imported data files to and from SAS using Procedure like import from MS-Access

Write or modify SAS Program to extract and manipulate data for analyses

Extensively used data step, proc tabulate, proc means, proc freq.

Investigated missing data and data inconsistency in SAS datasets. Developed edit-check program to clean invalid data from the database,

All the work completed to supervisor’s or Manager satisfaction and on time

Environments: Windows, Microsoft office (excel), SAS (Base, SQL, Access, Connect)

Legendre Lubawin Goldfarb Inc. Montreal, Quebec, Canada Feb -Nov 2007

Data Management/Administration Specialist

Responsibilities:

The programming and statistical data analyst of marketing & clinical research project

Data management(numerical or categorical) from the data file underneath by the supervisor

Inspection,clean-up & validate data file(excel)

Compiling and entering data excel table

All the work completed to supervisor’s or Manager satisfaction and on time

Environments: Windows, Microsoft office (excel), SAS (Base, SQL)

Pouvoir & Associes, Montreal, Quebec, Canada Mar 2005-Oct2006

SAS (Accounting) Technician /Programmer/Analyst

Responsibilities:

File/data management, tax (company, personnel & payroll) application of company client’s.

Develop and implement SAS and Excel program for simple statistical analyst, tabulations, report. Environments: Windows, MS Excel, MS Windows, Crystal Report, SAS (Base, Stat, SQL, Macro)

Legendre Lubawin Goldfarb Inc. Montreal,Quebec, Canada May-June-July 1995-2003

Statistical Analyst/Programmer

Responsibilities:

The project is general marketing research of people or family’s life expectations.

Integrated collect the numerical or categorical data from the survey questionnaire.

Using statistical software & statistical technique forecast the outcome.

Compiling and entering survey data to verify results, table and graphics.

Environment- Windows, Access, statxp, SPSS

Ebitendo Statistics, Montreal,Quebec,Canada Aug-Dec 2002

Database Program and Design

Responsibilities

General survey of HIV/AIDS (Kenya, Uganda and Tanzania) people the life expected & condition in relation to children.

reading and understanding the study annotated Case Report Forms, Study Definition documents, software tools and working with MS-Access

Design the database of data processing under senior statistician in the Africa research centers.

Developed edit-check program to clean invalid data from the database.

Using survey (local government, community & household) questionnaires diagram the survey database, analyzing the questionnaire, coding and debugging of survey (query, report & form) applications.

Environment- MS Access, Windows

Ebitendo Statistics, Montreal, Quebec, Canada May-July 2002

Clinical SAS Programmer/ Developer

Responsibilities:

The programming and statistical data analysis of medical (sleep maintenance insomnia) data for Clinical Trial.

Using Phase II methods weigh up the safety and effect treatment of the drug

With the Design of experiment technique(such as general linear model with repeated measure) to set up the model advantage analyst .

Associate the senior statistician/ programmer forecast model with SAS program to process the medical data.

Importing and exporting raw data files, manipulate and transform data, combine sas datasets create basic detail and summary reports using SAS procedures and handling errors by identify and correcting data, syntax and programming errors

Generated graphics for reporting using SAS/GRAPH

Created external files mainly RTF or PDF report using SAS Output Delivery System(ODS)

Environment- SAS( Graph, Base,Stat,QC,ODS, SQL), Windows, Power point

University of Concordia, Montreal, Quebec, Canada Jan -Dec 2002

Teaching Assistant

Responsibilities:

Tutor fundamental mathematics or statistics courses on university program.

With Mathematical Software( such as SAS, SPSS, Statistica or R) to work out the assignment.

Group or one-to-one help the student’s assignments to solve the problems or previous exams.

Instructor the group or students using statistical/ mathematical software solve the troubles.

Identified areas for improvement and developed learning strategies outside the classroom.

Environment- Windows, SAS, SPSS, R, Maple, Statistica

EDUCATION:

Bachelors in Pure and Applied Mathematics and minor in Physical Chemistry

University of Concordia, Montreal, Quebec, Canada, 2000

Diploma in Pure and Applied Science

Dawson College, Montreal, Quebec, Canada,1992

CITIZENSHIP:

Canadian Citizen

Contact this candidate