Ira
Schonberger
280 River Road
Piscataway, NJ 08854
sas_dynamo@yahoo.com
Phone:732-356-4864
URL: https://www.angelfire.com/ny2/schony
12- year SAS programmer, Statistics, SQL, UNIX, MVS, Win NT/2000; Pharmaceutical, Health, Applications Development Experience
EXPERIENCE 9/2002 – 12/2002 Merck & Co., Inc. (www.merck.com) Rahway,
NJ
SAS Programmer/Analyst (contractor) Performed conversion of Clinical
Adverse Event Reporting System from Actuate/VB/Oracle/Unix to SAS/Oracle/Unix client-server
system on Windows 2000. Heavy use of
Oracle SQL extensions, SAS/ODS and SAS report writing in data null steps.
6/2001 - 6/2002 Pharmacia & Upjohn (www.pharmacia.com) Peapack,
NJ
SAS Programmer/Analyst (Contractor) Programmer and Co-Statistician in
Statistical Services and Exploratory Data Analysis team working with
pharmaceutical clinical trials and health outcomes data with SAS 8 on HP Unix,
Oracle, and Windows. Heavy use of SAS/STAT, SAS/ODS, SAS/GRAPH, Proc SQL, Excel
Pivot Tables (for data cubes/OLAP). Clinical/Statistical aspects of
pharmaceuticals industry. Generated p-values for treatment effects in many
statistical models. Focused on anti-inflammatory and overactive bladder
therapeutic areas.
5/2001 - 6/2001 Microeconomic Consulting &
Research Assoc., Inc. (www.micradc.com) also
6/2000-9/2000 Washington, DC
SAS programmer/Econometrician (contractor) Supported economists working as
expert witnesses on damages, antitrust and anti-competitive behavior lawsuits.
Designed and coded regression models to study effects of market share growth on
brand and industry sales. Used SAS, SAS/STAT, SAS/GRAPH, SAS Version 8 Enhanced
Editor on Windows 2000. Extensive data
manipulation.
1/2001 - 4/2001 Cendant
Corporation/RCI, Inc.(www.rci.com)
Parsippany,
NJ
SAS Programmer-Database Marketing (contractor) Fast-paced business analysis and
data analysis in SAS on Unix, and with SAS/CONNECT to Oracle and DB2, as part
of Database Marketing Team.
Designed and programmed Unix/SAS Deposit Solicitation System using local and
remote connections to Oracle and DB2.
9/1997 - 5/2000 Rutgers
University/Oregon
State University New Brunswick, NJ/Corvallis, OR
GTA Instructor Taught courses in econometrics using base SAS and SAS-IML
matrix language on the Windows and Unix platforms. Also taught courses in
economics. Topics
taught include econometric estimation, inference and hypothesis-testing using
SAS-IML matrix language, matrix operations, deviation from means, probability
functions, OLS, t-test, lag operator, F-test of general linear hypotheses, test
for structural change, augmented regression, dummy variables,
multicollinearity, restricted OLS, base SAS procedures: Proc Reg, Proc Autoreg,
Proc Syslin (SUR, 2SLS, 3SLS, LIML, FIML), White and Glesjer tests, Weighted
least squares, White's error covariance matrix, Durbin-Watson test, Breusch-Godfrey
test, estimating autoregressive parameter, Panel data models, SUR models,
cross-equation restrictions, SEM, Hausman test, Logit and Probit models.
1/1997 - 7/1997 Keane,
Inc. (www.keane.com) New York, NY
Senior Consultant Performed primary stages of Year 2000 compliance project
at Goldman Sachs, Inc. Used SAS, MVS JCL, JCL procs, and ViaSoft software to
accomplish system component reconciliation project.
3/1991 - 12/1996 Health Management Systems, Inc. (www.hmsy.com) New York, NY
Senior Programmer/Analyst 1994-1996: Led team of
programmer/analysts developing and maintaining health care related application
systems in SAS, COBOL, DB2, MVS JCL, JCL Procs, Unix, Oracle, Windows NT, et.
al. Had principal responsibility for Unix/SAS/Oracle-based Medical Claims
Accounts Receivable System.
Associate Project Manager 1991-1993: Worked on (and later led) business
analyst teams performing data analysis in SAS (on MVS and Windows NT
platforms), constructing application systems architecture and writing
programming specifications.
9/1989 - 3/1991 S & R
Consultants, Inc. New York, NY
Group Health Claims Associate Performed health insurance claims
processing, participated in plan administration, and designed and wrote
applications in TurboPascal to automate manual processes.
EDUCATION 5/2000 Rutgers University New Brunswick, NJ
Ph.D. Program in Economics Completed all the coursework for
the M.A. degree in Economics, but have not completed the thesis requirement.
Specialized in the field of econometrics. GPA: 3.7
7/1999 Oregon
State University Corvallis, OR
Ph.D. Program in Economics After two successful years (GPA
3.8) transferred to Rutgers University. Specialized in the field of
econometrics. Awarded D. Barton DeLoach Distinguished Graduate Fellowship in
Economics.
1/1991 Hunter
College of CUNY New York, NY
Bachelor's Degree Completed double-major in Mathematics and Economics, Minor
in Statistics, graduated Summa cum
Laude (GPA 3.9).
AFFILIATIONS
1/1993 - 12/1993 American
MENSA, Ltd. Member
SKILLS |
Skill
Name |
Experience |
Skill
Level |
|
SAS, SAS Macros, SAS/SQL |
12 years |
Expert |
|
|
SAS/STAT |
7 years |
Expert |
|
|
SAS/GRAPH |
5 years |
Expert |
|
|
SAS/ODS |
3 years |
Expert |
|
|
UNIX |
7 years |
Expert |
|
|
SQL |
7 years |
Expert |
|
|
Oracle,SQL+,PL/SQL |
6 years |
Expert |
|
|
Windows NT/2000 |
6 years |
Expert |
|
|
MVS,JCL,ISPF,COBOL |
7 years |
Expert |
|
|
JCL Procs,Syncsort,Endevor |
7 years |
Expert |
|
|
DB2 |
7 years |
Expert |
|
|
MicroFocus COBOL with RCM |
7 years |
Expert |
|
|
Excel (with Pivot Tables, Data Cubes) |
12 years |
Expert |
|
|
HTML/ASP |
3 years |
Intermediate |
ADDITIONALNational
Mathematics Honorary Society (1990), Comparative Lit. Honors Seminar (1989)
INFORMATION