Richard E. Thornton

Analytics Professional

thornton.richard@gmail.com

(201) 787-8066

                                                                                                                                                             

Overview

• Seasoned Marketing Analyst with experience in Brokerage, Insurance, Credit Cards, and Pharmaceuticals.
• Extensive UNIX,Linux,Windows,IBM mainframe experience. 
• Over fifteen years utilizing SAS.

 

 

Database:                    DB2, Oracle, Teradata.

 

Languages:                 COBOL, JCL, UNIX Scripts, SAS, FORTRAN, Pascal, C, R,

                                        EasyTrieve, Syncsort.

 

Other Software:         MS (Excel, Word, PowerPoint), Business Objects.

 

Hardware:              IBM 3090, IBM Compatibles, UNIX/Linux platforms.

 

SAS Modules:             SAS (BASE, Macro, ACCESS, SQL, STAT

                                       (LOGISTIC,LIFETEST,PHREG,MIXED,GLM),

                                       GRAPH, Enterprise Guide 4.x, JMP.

                              

 

SAS Platforms:           Any PC, IBM Compatible Mainframes, HP-UX., Solaris, IBM-AIX

 

Operating Systems:    MVS/ESA,Z/OS, All MS Versions (XP,Vista,7), UNIX, Linux

 

 

 

 

Manager Patient Outcomes , Medco Health Research

9/07-Present

 

·     UNIX environment with Oracle/Teradata and SAS version 9.3

• SAS Enterprise Guide 4.x.
• Subject matter expert in Medicare Part D/RDS
• Adherence Calculations.
• ROI Analysis.
• Data Mining.
• Decision Tree Analytics
• Led meetings and developed detailed slide presentations.
• PHREG/Logistic used for computing Days to Coverage Gap.
• Developed highly respected quarterly report for A1C Home Test Program.

 

 

 

 

 

 

SAS BI / Data Modeler, Contracts  Pfizer Inc

12/06-9/07

 

·     HP-UX environment with Oracle and SAS version 9.13

• SAS Enterprise Guide 4.x
• Created a Meta-data Server/Repository Environment for data modeling projects.
• Main project was analyzing "spillover" from Medicaid onto Third-Party Plans.
• Lift Calculations.
• ROI Analysis.
• Data Mining.
• Decision Tree Analysis.
• Data models with Oracle using Visio.
• SAS BI tools such as Data Management Console and SAS EG 4.x.
• Led meetings and developed detailed slide presentations.
• Clustering and principal components procedures in SAS to segment physicians.
• Physician Deciling.
• Worked heavily with all aspects of SAS including regressions, time-series regressions, panel analysis.

 

 

SAS Developer CV Primary Market Research, Sanofi-Aventis

09/05-12/06

 

• Oracle used to access both call data and samples data (Dendrite System).
• Institutional data studied such as calls to hospitals accounts.
• Created reports which tied Lovenox, Heparin, and Plavix DDD data with Procedures data;
• Clever use of SAS with Excel via DDE; Also used VBA coding with Excel.
• Worked with primary market research people designing tests and reporting on results.

 

 

SAS Developer, Guardian Life Insurance

04/05-09/05

 

• IBM AIX environment with Oracle and SAS version 9.1.
• Worked primarily to develop a series of production quality SAS programs executing on the Unix platform which read data from both flat files and Oracle tables, producing a driver file with two main keys - Agency Code, and Producer Code; this driver file is then split by all agency codes and all producer codes, creating Excel spreadsheets from SAS via XML. The process is elegant; by outputting each file as XML, Excel opens a completely formatted report without using any special translation tools within SAS such as ODS, Proc Export, DDE; No VBA on the Excel side is used, yet each report is fully formatted.
• >2400 emails per job.
• Saved return codes and produced completed audit reports which were automatically emailed.
• Modular program design, so any program can be quickly modified to produce any desired report for any particular email job. The concept of using SAS for writing raw XML has many possibilities such as production intranet reporting repositories. There is an automatic cost savings as well, since existing SAS tools are leveraged without needing other special reporting packages.

 

SAS Developer, Merck & Co., INC.

10/04-04/05

 

• Ad hoc requests, coupled with IT processing of IMS data, both monthly and weekly; several ongoing monthly and weekly projects for senior management.
• All work done with SAS 8.2, on PC using WIN XP and Z/OS IBM Mainframe.
• Heavy use of Oracle SQL with SAS.
• Heavy use of macros to auto-generate JCL and remote submit batch jobs to the internal reader.

 

 

SAS Developer, Pfizer, INC.

02/04-10/04

 

• Business Side project; occasional ad hoc requests, primarily self-motivated

             Analysis work in order to present pertinent information to senior management. 

• Regular interaction with senior level team members.
• Management & Analysis of major call planning system.
• Part of a team of individuals tasked with managing this system.
• All work done with SAS 8.2, on PC Using WIN 2000.
• Data stored in Oracle tables.
• Heavy use of Oracle SQL with SAS.
• Deliverables in Excel.
• VBA was employed for formatting.
• Close contact with other vendors aligned with project.
• Personally developed at least 120 SAS programs for this project.
• Several programs developed for easy re-use; quasi-production quality.
• Data Mining.

 

ZS Associates, Princeton, NJ.

10/03-02/04

 

• LTC care project detailing high value physicians with associated institutions.
• All work done with Solaris UNIX SAS 8.x.
• Production quality output using Crystal Reports.
• Tight deadlines with pharmaceutical client interaction.
• Data Mining.

 

 

SAS Developer, Schering-Plough Kenilworth

02/03-10/03

 

• Pharmaceutical Marketing Data Analyst/SAS Developer.
• PC & Mainframe SAS coding for a small marketing science team.
• Promotional-mix models for client marketing groups.
• Analyzed duplicate prescriber identifiers and their impact.
• Call plan Analysis.
• Presented the results of this analysis with various graphs and PowerPoint Slides.
• Utilized Enterprise Miner for Segmentation analysis.
• Used NDC data for marketing reports by product, market, geography, share calculations, call and sample data used for call plan analyses.
• PowerPoint slide development presentations for senior management as needed for all projects.
• Utilized Oracle tables to extract data for use in SAS analysis.
• Segmentation Analysis Using PC & Mainframe SAS.
• Simulations such as Monte-Carlo Methods were developed with PC SAS.
• Ad hoc Reports, with deliverables in Excel (Proc Export, DDE, VBA Macros employed).
• VBA macro development for large client requests of 300+ reports.
• All work done using PC SAS 8.2.
• Used NDC Data and IMS Data.

 

 

 

 

 

 

SAS Developer, Bristol-Myers Squibb

06/01-02/03

 

• Pharmaceutical Marketing Data Analyst/SAS Developer.
• Created basic SAS datasets used in a variety of ad hoc requests in our working group.
• Managed three to four ad hoc report requests on a weekly basis.
• All requests formatted with Excel using advanced Windows features such as DDE.
• Data was on several platforms: MVS, Win NT, and UNIX.
• Helped install, troubleshoot, and maintain a parallel Enterprise Guide installation.            
• Utilized Oracle Database residing on a UNIX server and accessed it through a middleware product called Intelligent Warehouse.
• Used Business Objects to access this data, or pass-thru SQL with SAS, using ODBC and SAS/Access.
• Used SAS/Access for DB/2 on MVS or MS Access on Win NT for data retrievals, depending on the platform.
• Extensive MACRO development for individual report requests.
• Developed toolset for the use of the programming department.

 

 

Database Marketing Analyst, Merck-Medco

02/01-06/01

 

• Designed and implemented randomized lists with scoring and suppression for internal customer marketing campaigns.
• Campaigns were designed to drive customers to Medco website.
• Post campaign results (web metrics) - visits and orders.
• Raw data pulled from Terdata.
• Lift Calculations.
• ROI Analysis.

 

Database Marketing Analyst, Paine Webber

06/00-02/01

 

• Campaign Analysis designed to drive customers to new investment products.
• Post campaign results.
• Raw data pulled from IBM mainframe flat files.
• Lift Calculations.
• ROI Analysis.
• Data Mining.

 

SAS Developer, Bristol-Myers Squibb

02/99-06/00

 

Data Modeler, Dun & Bradstreet

11/98-02/99

 

Development of Ad hoc & Production Reports, Visiting  Nurse Services

04/98-11/98

 

Credit Card Marketing and Mailing List Processing, Fair Isaac, INC

09/97-04/98

 

Actuarial Systems SAS Developer, Empire Blue Cross

01/96-09/97

 

 

Education

• The University of Tennessee (Knoxville); M.S. coursework in Applied Mathematics.
• The University of Tennessee (Chattanooga); M.S. coursework in Chemical Engineering.
• The University of Tennessee; B.A. in Mathematics.
• Calculus, Statistics, Numerical Methods Society of Actuaries Exams.