Mr. Qin (john) Zhang
** ****** **** **, ****** Plains, NJ 07950
Experienced SAS Programming Analyst with a history in data analytics and metrics reportage. From applied statistics to project management capable of performing a range of analyses using SAS as the primary tool. Familiarity with methodology of processing large datasets, e.g. 3,5000 vars and 25 million records. Experience in CDISC standard; knowledge of SDTM/ADaM data processing. Ready to implement and complete complex projects across all levels of an organization, with fast delivery of output and reports.
SAS programming (SAS Base, SAS/CONNECT, SAS/ACCESS, ENTERPRISE GUIDE, SAS/Perl and etc.)
SQL (SAS, Teradata, Oracle, DB2, PL/SQL and etc.)
MS Office (Excel, Access, Word and Powerpoint)
VBA in Excel, some knowledge in VBA in Access, Word and Powerpoint
VBS in Windows
PL/I, Syncsort, File-Aid, JCL on platform of MVS(ISPF/PDF,TSO/390)
Basics of R
Attentiveness to and persistence in SAS programming efficiency to minimize the use of resources
’2017.12-present: SAS Developer
Working at Johnson & Johnson (R&D) at Raritan, NJ through TCS inc.
Generating various SAS macros, Excel macros for clinical trial projects, marketing research projects and etc.; archiving CT data; aiding in implementing SAS LSAF (Life Science Analytics Framework)
’2016.10-2017.12: SAS Statistical Programmer
Worked for the Department of Clinical Data Programming at eResearch Technology in Philadelphia
Generating SDTM SAS datasets based on CDISC standards, following SDLC procedures; validating SDTM encoding programs to ensure the correctness and accuracy of data; performing major and/or minor modifications on existing studies and programs
’2005.02-‘2016.09: SAS Statistical Programmer
Novartis Pharmaceutical Inc. KMK Consulting, Inc.
Worked for the Department of Business Analysis/Payer/PBM Analytics; Oncology Dept, Novartis Pharmaceutical, Inc., New Jersey
Created and manipulated SAS datasets from IMS Xponent/Plantrak data, DDD data, FADS data, HUB patient data and flat files for marketing and sales analysis
Created over 30 adhoc/production reports monthly on average for various levels of administration, mainly sales reps and sales regional account managers
Involvement in targeting analysis (based on Forzen Target files), pull-through analysis, spill-over analysis, etc
Designed and implemented over 300 SAS and/or Excel macros of automation to facilitate dataset or report creation, utilizing the combination of SAS and VBA (Microsoft Excel, Access)
Dealt with clients who sought consultation on the expansion of sales, the performance of Managed Care accounts, providing results of business and statistical analysis, based on Xponent, Plantrak, pharmacy and CADI (rebate/claim) data, MII (Group Practice/Affiliation) data and Fingertip data for market access analysis
Prepared input data based on Teradata before manipulated by SAS procedures
Conducted training in SAS programming, especially SAS utility programs, and research to enhance programming techniques of SAS usage
Serving as a team lead to conduct work allocation, help maintain moral and disciplines
‘1996.04-’2005.01: SAS Programming Analyst, The Janus Group, NJ
Worked for AT&T Shannon Labs at Florham Park, New Jersey/ British Telecom, one of the clients of LCS Industries, Inc.
Created SAS datasets from existing datasets or flat files for Retention Analysis and other statistic analysis
Designed SAS procedures to facilitate Oracle/Teradata programming with program generator
Processed raw data from Oracle/Teradata base in both Unix and MVS mainframe
Designed large quantity of SAS macros to automate and facilitate SAS data processing, including setting up program generators, writing out flat files and etc.
Utilized the features of SQL Cartesian Product combined with certain statistical procedures to make data manipulation and analysis more efficient
’1995.08-’1996.04: SAS Programmer, Parexel International Co. (pharmaceutical consultation)
Created analysis data sets for Phase I and Phase IV of a double-blind, placebo-controlled fixed dose comparison of a drug called Seroquel to support bio-statistical analysis & reporting
Debugged and reviewed SAS output, interacted with clients on program specifications and modifications
M.A. in Economics, York University, Toronto, Canada (1984-86)
M.A. in European Economics, Nankai University. TianJin China (1982-84)
B.A. in International Economics, Nankai University. TianJin China (1978-82)
1) ’SQL Case Expression: An Alternative to IF/THEN Statement’ at NESUGI’97.
2) ‘A SAS Macro that Creates Numeric Decimal Formats’ at SUGI’98.
3) ‘SQL Host Variable: More about INTO Statements’ at NESUGI’98.
4) ‘Cartesian Product & Proc Fastclus’ at PharmaSUG’99.
5) ‘More About SAS File Transportation’ at SWSUG’99.
6) ‘Program Generator with DDE & FTP’ at NESUGI’99.