OBJECTIVE

• To obtain marketing / clinical SAS programmer or data analyst position that utilizes my skills in SAS development, data analysis, modeling and database management and enables me to make a positive contribution to the organization.

SUMMARY

• Over 5 years of extensive experience in SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/IML, SAS/CONNECT, SAS/SCL and SAS/AF.
• Extensive experience in SAS programming, data analysis, and database design, development and implementation.
• Experience with categorizing, extracting, modifying, merging, and analyzing clinical data for finding and generating classification, as well as generate TABLE, LISTING, GRAPH, REPORT and Data Cleaning.
• Experience with SAS/AF and SAS Component Language (SCL) on developing user interfaces.
• Hands on experience in interacting with data from various file formats like Excel, ASCII, CSV, Access, RTF, HTML, XML and PDF using Proc Import/Proc Export, SAS Enterprise guide, SAS/ACCESS and SAS/ODS.
• Good Experience in using SAS/STAT Procedures such as PROC FREQ, PROC MEANS, PROC UNIVARIATE, PROC SUMMARY, PROC REG, PROC GLM, PROC ANOVA etc.
• Experience with Data Validation, designing Edit check programs and parallel development of tables & listings for project level programs.
• Solid working experience in Data Manipulations using SAS procedures such as Array, Do Loop, PROC SQL, MERGE, PROC SORT, PROC TRANSPOSE, etc.
• Familiar with statistical methods that apply to Phase I - IV clinical trials.
• Familiar with pharmaceutical industrial standards like CDISC (ODM, Define.XML, etc)
• Solid background knowledge and hands-on experience in Statistical Analysis and Predictive Modeling, especially Linear/Logistic Regression, Experiment Design, Cluster Analysis, etc.

TECHNICAL SKILLS

SAS Tools: SAS9, SAS/GRAPH, SAS/STAT, SAS/SQL, SAS/CONNECT, SAS/ACCESS, SAS MACROS, SAS ODS

Data base Packages: SQL2005/2008, MS Access 2007, Oracle

Programming Language: VB, C/C++, R, SPSS, MATLAB, HTML, JAVA, Perl

Operating Systems: Windows XP / Vista /Windows7/ Unix/Linux

Office tools: MS Office 97/2000/2003/2007/2010

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

SAS Programmer

Responsibilities:

• Forecasted new released DVDs and movie serials point of sale in USA and Canada market.
• Gathered historical sale information from Teradata database. Created report, table and graph using SAS and MS excel.
• Performed ad hoc analysis.
• Maintained, updated and developed SAS macros.
• Developed new market plan with senior statisticians.

Confidential, Minneapolis, MN

SAS Developer

Responsibilities:

• Developed new SAS procedures assisting with uncovering automation opportunities for daily, weekly, monthly updates.
• Integrated data from multiple sources (SQL servers, SAS table, Excel and Teradata).
• Deployed Extraction, Transformation and Loading (ETL) with SAS DI and SSRS.
• Business Intelligence developed with SAS BI and MicroStrategy.
• Created new SAS macros and SAS based applications and did ad - hoc analysis.
• Applied complex Proc SQL joins and hash joins.
• Maintained SAS routine task for employees performance evaluation plan.
• Developed new function to optimize and troubleshoot for SAS tasks.
• Worked with remote server in Unix environment to submit SAS command to operate and reformat data.
• Analyzed data with SAS and created predict model then updated old parameters for business usage, generated analysis report and graph, applied the result on SharePoint server.

Confidential, Cincinnati, OH

Statistician/SAS Programmer

Responsibilities:

• Supported statistics department on multiple projects on research and development including product development and consumer research in a fast peace environment.
• Worked closely with project teams and reported directly to principal scientists and senior statistician by extracting data from various data sources, interpreting business problems and introducing/developing statistical methods to solve the problems.
• Developed new business tools for customer satisfaction evaluation on daily consume production with SAS base and SAS BI.
• Developed predictive model based on custom questionnaire
• Designed experiments using Latin square and other complex methods and generated mixed model using SAS.
• Created ad hoc reports and ensured data is accurate and made business sense.
• Created web based report combine with SAS and SQL server and made interactive interface exchange information between customers and database.
• Used dynamic data exchange (DDE) technology to connect and control data from different resource.

Confidential, Princeton, NJ

Statistical Programmer

Responsibilities:

• Wrote programs to generate statistical tables and listings according to templates of SAP, assisted in the development of data analysis plans through collaboration with senior statistician and consultant, reviewed protocol, SAP, and CRFs for the primary goal, statistical method, and trial specialty.
• Generated datasets, helped set specifications of analysis datasets and pooled datasets.
• Wrote code using SAS/Base and SAS/Macros to extract clean and validated data from Excel file, Access Database, and Microsoft SQL server.
• Provided SAS programming and validation support for senior statistician. Generated tables, figures, and listings for final report by using PROC TABULATE, PROC REPORT and PROC GPLOT; developed ODS output RTF, PDF or HTLM file for documents.
• Mapped raw data to CDISC domains and produced SDTM output.
• Involved in Phase II and III clinical trials by providing required tables and listings.
• Responsible for manipulating, transferring and managing data in SAS.
• Helped with ad - hoc analysis and wrote report to summarize finished or ongoing studies.
• Performed validation for program and datasets through independently coding.
• Compared and checked the output for accuracy or compared datasets by using PROC COMPARE.
• Validated the integrity of all the programs and improved all the programs.

Confidential

Statistical Programmer/ Analyst

Responsibilities:

• Performed SAS programming and provided statistical analysis under independent and cooperate environment.
• Imported data from different sources such as Excel and txt raw data.
• Checked data integrity, cleaned data and performed data transmission occasionally .
• Manipulated data sets into forms for statistical analysis by sorting, adding variables, rename and/or labeling variables, formatting, merging, combining, and transpose.
• Performed statistical analysis using SAS/BASE and SAS/STAT including provide sample size estimation provided basic descriptive statistics using Proc Means, Proc Freq, and Proc Univariate, conducted analysis like Regression, Correlation, and Analysis of Variance using Proc Reg, Proc Corr, Proc Glm.
• Applied statistical modeling techniques with SAS software to model and analyze customer data for direct marketing purpose.