Clinical Programmer, Statistical Analyst

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

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

Montreal, Quebec, Canada,H4N 3G9

Career Objective:

A challenging position of the Statistical Programmer with Statistical environment using SAS /SPSS

Summary of Qualifications:

About 8 years of professional experiences of SAS Programming in Clinical and Marketing 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

Developed code for Extraction, Transformation and Loading table.

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, SAS Enterprise Guide(V.4.3,5.1,5.2),

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:

Programmer Group, Montreal, Quebec, Canada Dec 2015-Oct 2020

SAS/ Statistica Programmer & Upgrade

Responsible:

install new version SAS software and then configure to the different data source or sever

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

Develop new macro procedure or function for the analyst .

General data management /validation procedure & statistical analyst with Statistica or SAS

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 ), Statistica, Microsoft office, Python, XML

Programmer Group (Contract, oversea) May2013 -Nov 2015

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

Suggestion or inventory detail technical or solution to the project or client

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.

Compile and testing programming to make sure not fault on the procedure or function.

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.

Suggest the finest statistical model procedure or program for data analysis/ management.

Data source or data file using program to verify the mistake

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

Sourced and analyzed data from a variety of source like SAS datasets, MS Access, MS Excel, CSV, flat files etc

Analyzes data using various statistical procedure like proc summary, proc means, proc freq, proc reg, proc glm and proc anova etc

Using SAS Output Delivery system(ODS), generated reports in specific output formats like RTF, PDF and HTML

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

Responsible for extracting the data, cleaning, manipulating, transferring and managing data in SAS

Experience in entering, analyzing and coordinating data, generating table, listing, graphs and report.

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

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.

Provided the feature document for the user or administration guide.

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