Data System
Resume:
Zongming Pan
Plymouth Meeting, PA 19462
E-mail: **********@*****.*** Tel.: 267-***-****
QUALIFICATIONS SUMMARY
• High level of proficiency with SAS programming.
• Extensive experience in construction and manipulation and data analysis of large-scale and
complex datasets.
• Knowledge of clinical trials process.
• Strong analytical and problem solving skills.
• High ability to learn and apply new technologies quickly.
• Highly self-motivated, extremely detail-oriented, and highly productive with minimum
supervision.
• Excellent team player with good communication and interpersonal skills.
COMPUTER SKILLS
• SAS, SQL, Java, C, UNIX, Relational Database System, SigmaPlot, MS Excel, MS Word,
MS PowerPoint.
PROFESSIONAL EXPERIENCE
SAS Programmer, American Institute for Research 2008 – present
• Use SAS procedures, such as PROC Sort, Freq, Means, Corr, Sql, Summary, Transpose,
Tabulate, Report, and Print, to generate aggregate data sets and reports of large scale and
complex datasets.
• Extensively use SAS Macro Facility to create codes for reusable programs, and perform
program documentation on all programs, files and variables for accurate historical record.
• Be responsible for data cleaning, cross-checking the records to secure data quality.
• Transform data in various formats (Excel, CSV, ASCII) into SAS datasets, and vise-versa.
• Merge data from different sources into a single integrated dataset.
• Help statisticians to define programming specs and, on the basis, write multiple statistical
programs for data analysis.
Sr. Research Investigator, University of Pennsylvania 2004 -- 2008
• Screened new potential anti-epilepsy drugs that act on ion channels. Checked data quality
(outliers and missing data), conducted data analysis with SAS, used ANOVA, Fisher Exact
and Student T-test to check whether the effects of the drugs on cells/animals are significant
between groups.
• Helped developing a custom 50K vascular disease SNP array which aims to
comprehensively assess the genetic diversity within pathways (approximately 2150 genes)
1
underpinning primary and secondary vascular disease processes such as blood pressure,
insulin resistance.
• Conducted genomic data mining to study the evolution of a pivotal binding motif of ion
channels and its importance in determining brain function.
Postdoctoral Researcher, Stony Brook University 2001 -- 2003
• Performed genomics data mining, regression and correlation analysis on real-time PCR
data with SAS to study the expression and regulation of rennin-angiotensin system
members in heart.
• Worked as a consultant to clean a large data and convert it into a SAS data set for further
statistical analysis.
• Finished several projects on parsing programs by using ML, a functional programming
language, and XSB, a Logic Programming and Deductive Database system for Unix and
Windows.
• Profiled and analyzed the running of Jmol, a molecule viewer/editor, to improve the
performance.
Research Assistant, Stony Brook University 1999 -- 2001
• Involved in converting raw data from Phase I Clinical trial to SAS data set and in doing
statistical analysis.
• Performed statistical analysis to investigate gene expression profile using SAS.
• Designed and implemented an object-relational database system to support the operation of
a student registration system on campus. Implemented transaction procedures, measured
the transaction performance using TPPT (Transaction Processing Performance Tool) and
analyzed the performance measurement results.
• Carried out several projects on network programming with TCP/UDP, IP protocol and
remote procedures. C was used in Unix environment.
• Designed and implemented several modules with Java using the OSP/2 system, a simulated
environment for operating system design. CVS (Concurrent Version Control System) was
used.
EDUCATION
M.S. Computer Science (Minor in Biostatistics) Stony Brook University 2002
Ph.D. Neurobiology Stony Brook University 2001
B.S. Biology Ocean University of China,
China
VISA STATUS
• USA Citizen
2
Contact this candidate