Summary
Overview
Work History
Education
Accomplishments
Languages
Interests
Training
Timeline
Generic

William H. Turner, II

South Orange,NJ

Summary

I am a Senior SAS Programmer\Developer with Project Leadership Skill sets. I have years of experience in New Jersey's Big Pharmaceutical, Public utility, Commercial Insurance, and the Health Management Industry as well as Financial, Marketing and Retail. I am actively working with SAS software and other tools in data gathering, creating Human interfaces UI, reporting, Data Analytics, and Data Analysis. I have also built job streams in support of forecasting while Managing Development Teams and Operational support Team members to maintain the integrity of the data delivery system and the timely 24x7 successful completions of valuable information for Business consumption. My primary focus has been to provide a bridge between Business Endeavors with Information Technology solutions. My goal is to continue to translate business initiatives into cost efficient Technology solutions in a multi-dimensional platform\software environment and create efficiencies in practice which include modular development approaches for easy Operational Support. In addition to this approach, improve the Quality of data and data ETL processes as well as data compliance and data integrity by providing end-to-end “clean” Processes. Specialties: My strengths are in communications, Planning and Problem solving. Visionary in identifying the issues, developing a visual plan and resolving issues in the most cost efficient manner primarily using SAS and other Tools. Also providing a Modular Development approach using Macros, automated notifications, and checkpoints to improve successful data delivery. Managing Operation support of 24x7 operations Team to insure data integrity, on time delivery of accurate results.

Pursuing full-time role that presents professional challenges and leverages interpersonal skills, effective time management, and problem-solving expertise.

Collaborative leader partners with coworkers to promote engaged, empowering work culture. Documented strengths in building and maintaining relationships with diverse range of stakeholders in dynamic, fast-paced settings.

Overview

45
45
years of professional experience

Work History

Director Analytics Administration

Payer Sciences
01.2023 - Current
  • Functioning as a SAS Developer created SAS ETL support code Solutions for related projects for production processes and ADHOC reporting of Market level monthly and Trend usage reports. Most reporting was in support of sales forces and Pharmaceutical Management organizations.
  • Supported existing Production SAS programs doing impact analysis to determine possible conflict in new reporting requirements
  • Also Involved with Special Projects related to Infrastructure and internal operations while providing procedural guidance, Backup plans and recovery plans and documentation for My development Projects.

SAS Architect & Project Manager

Avis Budget Group (TCS)
05.2012 - 04.2021
  • Functioning as Project Manager and Senior SAS developer in an Operations Research group Managed a Team of 5 Programmers in an operational setting Provided Management over sight , Data, Application Development and SAS programming on Unix and Mainframe platforms for Business stakeholders. The Technology Environment Approach used distributed methodology to process Forecast Models over multiple machines separately and interactively. The major Application called “YEILD” Management is a decision making process used to predict, vary, and control product availability. Various analytical tools, decision models, market strategies and mathematical techniques have been developed to support yield. Under our charter we provided comprehensive decision support to system applications and managed over 150 U.S., Canadian and Caribbean locations on a 24x7 basis.

Senior SAS Consultant

American Express
09.2009 - 05.2012
  • Created ETL and data point metrics for Market Analysis Projects. Develop Association, Best Customer analyses, Partnership/Peer Analysis
  • . Customer Spend profiles etc for Business Insights Group within Marketing Organization. ETL data as part of a Marketing Analysis Plan and develop data Metrics. QA data inputs using SAS PROCS such as proc Freq and others to look at data trends. The data was stored on a Unix Platform and is accessible through a Citrix Server through SAS Enterprise Guide Application. Data base files of detail in hundreds of millions to billions of rows are extracted most efficiently. Most output reports are exported to Excel and Power point presentations. Essentially we look to create opportunities for Businesses to assist each other by partnering up with businesses in other industries as one strategy. We also provide Merchants a detailed look at customer behavior and customer loyalty to competitive Brands. The financial packages and the analysis we provide to clients help to understand their Market share metrics as well as their share of wallet. We also provide the supportive demographics which give insight to a more detailed perspective as to who your customers are. Primary Technical toolkit: SAS, SAS Macros, MS Excel, Access, and Power point, Applications: SAS EG4, Manipulating Delimited text files of all types.

Senior SAS Programmer Analyst- Consultant

Novartis
10.2008 - 03.2009
  • In a major pharmaceutical company within the Sales Information Technology group. My primary responsibilities included developing and creating specifications and programming for competitive Sales contests to drive Sales revenues. DDD Sales data, Vials and Script writing are measured for all Sales Forces and selected for the analysis. Data from Text files, SAS files, Excel files on Both Unix and Oracle were collected scrubbed, interrogated, audited prior to creating and moving this data to a common format and Data source. Used Proc sort, export/import, means, weight, freq, transpose and other procedures and techniques was used in a UNIX environment. SAS connect was also used to process data in the most efficient and effective way possible. The data was then loaded into an Excel workbook and developed further sometimes using Visual Basic to enhance the reports for field management. These contest are measure over a period of time so a full process was created using SAS MACROS to create further efficiency and expedience. These contests involve creating Baseline data and then capturing actual weekly and monthly data to compare, track and develop trends. Based on Growth percentages Directors, managers and field ops could gain based on a winning percentage of 100% or better. Also in this position I was involved in creating data for express use in Oracle databases.

Senior SAS Programmer Analyst - Consultant

Health Management Systems
03.2008 - 10.2008
  • Worked to resolve Data issues and or miss charges for the Federal Government Medicaid program to recoup payout that should have been paid by the Patients personal insurance company. Provided Programming Expertise as required maintenance on Production systems using SAS to create accurate corrections and innovations. Created files for Management which would reflect the current accurate billing information. Moved programs into production to create regular and routine billing data for customers. Worked on independent projects with Project managers to create customer information. Resolved data environment issues with large data extracts of 100 million plus rows of data. Created production reports using SAS. Created Macros to process dynamically multiple year files to produce results. This was a large data shop where time and computer resource usage was an optimal part of planning any data development project.

MIS - Systems Analyst

Crum & Forster Insurance Company
01.2004 - 02.2008
  • As a member of the Actuarial Department’s (MIS Group), while interacting directly with Actuarial, Financial, Claims, Underwriting, Marketing, IT Support, and Senior Management to provide data, reports, and general system expertise.
  • Created insurance claims triangle reporting which reports claims as they develop over a period of time. It is quite typical that claims get registered in a particular year and the payments are paid out over several years. Assisted with the Financial close each month using programmatic checks and balancing of the accounts final bookings of accounts. In addition maintained Data & Systems for financial, Regulatory, Special analyses & ADHOC reporting. Software tools used Microsoft Access, Excel, SAS, SQL, Oracle, TM1, and Visual Basic. These tools are used in a Multi-platform environment, both PC and MVS.

Senior SAS Programmer Analyst - Consultant

Merck Pharmaceuticals
01.2003 - 01.2004
  • Served on a major Company Migration project as a SAS Auditor. This project was a migration project where the Human Resources Department had been, for some time, converting business logic, applications, and data from DB2 and other MVS data stores on MVS to Oracle for use by PeopleSoft. My role on the team was to create audit methodology that could compare data between The PC and MVS. Client Server SAS was selected as the Software of choice in consort with SAS on MVS to connect the platforms. Programs were developed using the Libnam statement & SAS Views to extract & report error statistics. Automated Turnaround documents were also created for use as re-input to source. Microsoft Access and Excel were also used to provide output analysis data. Also programmed reports for Management to use to find business logic problems, manual and automated keying problems.

Senior SAS Programmer Consulting Position (IT-Marketing)

Novartis Pharmaceuticals
04.2003 - 10.2003
  • Data Warehouse project - 50 million dollar project involving the development of a new system to incorporate marketing and Physician data. The new system will process data to field sales force in a timelier manner. Performed data validity checks and evaluations on existing data. Created Test and Development environments On Unix for integration testing. Used SAS client and SAS on the UNIX box to do data comparison analysis. Also created production jobs using Shell scripts on UNIX to call SAS programs. Created SAS programs to read data from delimited flat files and Oracle databases. Used FTP on UNIX to move programs and data from One UNIX Box to the other. Used various SAS procedures such as proc compare, Proc summary .and SAS macros to create data analysis reports, files and demoralized records.

Senior SAS Programmer Consulting

Schering Plough
08.2002 - 03.2003
  • Provided expertise on the Pharmacokinetics / Biostatistics project, which involves the development of analytical programs to process clinical data to provide Biostatistician analysis Tables and listings and reload analysis output to the PK Oracle database. This project utilizes a Java front-end and a SAS backend. The SAS back-end provides users with an interactive analysis of various types of crossover and parallel studies. My responsibilities here are to deal with the SAS portion of the project. Additionally my responsibilities are to create documentation provided for the SDS (System Documentation Specification) and Unit test plan as well as the entire SAS coding process. Also received 21 CFR Part 11 compliancy training to integrate the FDA regulation into the creation and usage of the application. The following Technology was used, Proc Mixed, Proc means, Proc report, SAS macros, SAS Base, ODS (Output delivery system), SAS/IT (Integration technology), SAS Access to access the data which is stored in the PK Oracle database. Both the application and the database interact with each other on Windows 2000 Servers.

SAS Programmer Analyst - Consultant

Sony Corporation Consulting
10.2001 - 04.2002
  • Worked as a Project leader on a major migration project. This assignment requires an in-depth knowledge of SAS and a reasonably good working knowledge of SQL and the data delivery aspects of ORACLE. This assignment requires the migration of a financial application Known as the "ISSA Financial Allocation Application" from MVS/OS to UNIX/ORACLE. The MVS application is written in SAS. This project is a 2 Phase migration currently in Phase I. Once this project is complete, a new and improved version of the previous MVS application will emerge with improvements to the validation and data verification processes as well as an improvement to the overall operation since the validation data exists on UNIX

Senior Applications Programmer /Analyst - Consulting

NOVARTIS - PHARMACEUTICAL Co
03.2001 - 09.2001
  • Working on a major Migration project. This position requires an in depth knowledge of SAS and the SAS tools which allow SAS to be a portable software. The DEV-IT team of which I am a part is tasked with developing tools and moving all Clinical programs, Clinical data and Clinical applications from the OpenVMS environment on the VAX to the UNIX platform... This process is achieved by creating macros in SAS to analyze the differences in the programming code such as calls to the operating system as well as to files and convert the code to compliant code as interpreted on UNIX. SAS transport files are also created to prepare the SAS files to be moved via FTP. CPORT and CIMPORT procs are also used to pack and unpack the data so that it may be on the new platform. Once the Clinical trials programs were unpacked Phase II & III level programs were executed on the Unix Platform to resolve any issues that may have resulted during the migration. This project is directed as a global company project. All management is located in Basel Switzerland, where I travel periodically for project management meetings and Auditing training for the FDA regulated process..

Senior Applications Programmer - Consulting

MERCK -PHARMACEUTICAL CO.
01.1994 - 01.2000
  • - Provided services as a Project Leader. Developed methodology-using SAS programming experience in a Human Resources department, to create programs using the "SAS Data Warehouse" concept to store denormalized HR data. Extracts were created to write data for current, point-in-time, Time span, and action driven historical data. Created a process to extract data stored in PeopleSoft and Oracle data warehouse tables on UNIX and NT platforms and write or interface with MVS mainframe. Interfaced with computer operations as an S&P (Standards and Procedures) liaison while developing production programs in SAS and SAS/SQL and the associated documentation for Production Job scheduling. Developed all JCL (job control language) for the production process. Developed Front-end applications using SAS/AF, SAS/FSP, SAS/SCL, SAS MACROS and SAS SHARE to provide user multi-update capabilities SAS Warehouse/Database applications. Some of these applications interfaced with production jobs which while running on a scheduled basis performed other functions such as SMTP mailings. Other products such as FTP (file transfer) and SOFTSWITCH were also used in conjunction with these products. Provided Internal training to programmers for SAS and JCL using training room and projection hardware. Also provided ADHOC programming support to management for confidential and non-confidential reporting of various levels of difficulty. Developed the in house technology to extract data from a foreign platform using Peer to Peer Communications. Acted as Team lead for Y2K projects for all reporting systems used by HRIS which were successfully converted without incident.

SAS Programmer Analyst – Consultant

AT&T
01.1991 - 01.1994
  • The Market Analysis & Forecasting organization, provided "ADHOC" programming and Data analysis support of various Business cases. The information provided assisted Marketing Management officials in developing repricing strategies for various Advanced Features and communication networks. Much of the analysis offered looked at utilization trends for clients of both small and large business constituencies. To support this end standard monthly reports were developed using "BASE SAS and various SAS procs. Harvard Graphics and Lotus (windows version) were also used. Also working with billing companies to receive data to bolster the analyses more volume of data to use when analyzing Usage for all features.

Analyst III – Financial Systems – Employee

GENERAL PUBLIC UTILITIES (GPU - Nuclear)
01.1985 - 01.1991
  • Financial Systems - Responsible for the coordination of the Corporate Budget System, upgrades and modifications. Responsible also for Corporate Financial Reporting/Creation of Financial Reports. Expert knowledge and ADHOC programmer support to field management and Vice Presidents using COBOL & SAS, SAS/AF, and SAS/FSP applications. Designed/Implemented a Financial Query Information System (FQIS) to provide clients with online/batch access to tailored reports as well as creating and providing manuals and training to over 500 users. The FQIS System alleviated high cost processing realizing a reoccurring cost saving of 100K per annum. (Reducing overall processing cost 80%).

Analyst II - Budget and Cost Analysis - Employee

GENERAL PUBLIC UTILITIES (GPU - Nuclear)
01.1981 - 01.1985
  • Budget and Cost - Coordinated/Supervised a team of CRT operators in maintaining corporate databases, coordinated corporate forecasting and verifications associated with the corporate budgeting function. Maintain database integrity while initiating upgrades and data analysis for three site locations. Designed and developed edit/turnaround reports to verify and enhance data entry accuracy. Developed front-end programming logic, which created checks and balances as well as intelligent updating of database records. Liaison between accounting function, external user departments and Information Services while reporting directly to the Manager of Corporate Budgets. Created a Goals & Objectives tracking system which would tie organization responsibilities to the GPU Nuclear Corporate Goals & Objectives. The system provided management with a report card on project performance, work-in-progress. The Goals & Objectives tracking also tied into Booze-Allen Hamilton Consulting Firm, which was a subset of the overall plan to provide clean efficient and safe electric power to the public. This system as well as FQIS continues to exist and operate

Education

Bachelor of Arts - Business Management

Farleigh Dickinson University
Madison, NJ
10.1983

Associate of Science - Computer Programming/System Design

Brick Computer Science Institute
Brick Township
01.1980

Some College (No Degree) - Industrial Psychology, Criminal Justice

Middlesex County College
Edison, NJ

Accomplishments

  • Achieved success by Providing full service Programming with accuracy for deliverables as well as 24/7 Operational Application Support .
  • Used Microsoft Excel to develop inventory tracking of Projects timelines and Delivery Targets
  • Supervised team of 6 staff members.
  • Collaborated with team of 6 to provide initial strategy and approaches and delivery schedule for Clients requiring programmed solutions.
  • Provided accurate documentation to expedite Resolutions.

Languages

English
Native or Bilingual

Interests

  • Youth Development Programs
  • Team Sports
  • Historical Exploration
  • Reading
  • I participate in low-impact exercises to strengthen core muscles
  • Volunteering
  • I like looking at the stars and learning about constellations
  • I enjoy helping others and giving back to the community
  • Music
  • Personal Development and Self-Improvement

Training

  • Certificates Management & Supervision Workshops
  • Certificate: 2000 – Certificate -Clinical Trials Training (Seminar for SAS Programmers) Provided by Meta Solutions, CRO, Nassau Inn Princeton, New Jersey 2003
  • 21- CFR Part 11 Training provided by Intrasphere Technologies, NYC, Extended Auditor Training IN Basel Switzerland for Clinical Trail Application Migration Specific Spring of 2001

Timeline

Director Analytics Administration

Payer Sciences
01.2023 - Current

SAS Architect & Project Manager

Avis Budget Group (TCS)
05.2012 - 04.2021

Senior SAS Consultant

American Express
09.2009 - 05.2012

Senior SAS Programmer Analyst- Consultant

Novartis
10.2008 - 03.2009

Senior SAS Programmer Analyst - Consultant

Health Management Systems
03.2008 - 10.2008

MIS - Systems Analyst

Crum & Forster Insurance Company
01.2004 - 02.2008

Senior SAS Programmer Consulting Position (IT-Marketing)

Novartis Pharmaceuticals
04.2003 - 10.2003

Senior SAS Programmer Analyst - Consultant

Merck Pharmaceuticals
01.2003 - 01.2004

Senior SAS Programmer Consulting

Schering Plough
08.2002 - 03.2003

SAS Programmer Analyst - Consultant

Sony Corporation Consulting
10.2001 - 04.2002

Senior Applications Programmer /Analyst - Consulting

NOVARTIS - PHARMACEUTICAL Co
03.2001 - 09.2001

Senior Applications Programmer - Consulting

MERCK -PHARMACEUTICAL CO.
01.1994 - 01.2000

SAS Programmer Analyst – Consultant

AT&T
01.1991 - 01.1994

Analyst III – Financial Systems – Employee

GENERAL PUBLIC UTILITIES (GPU - Nuclear)
01.1985 - 01.1991

Analyst II - Budget and Cost Analysis - Employee

GENERAL PUBLIC UTILITIES (GPU - Nuclear)
01.1981 - 01.1985

Bachelor of Arts - Business Management

Farleigh Dickinson University

Associate of Science - Computer Programming/System Design

Brick Computer Science Institute

Some College (No Degree) - Industrial Psychology, Criminal Justice

Middlesex County College

Similar Profiles

CREATE PROFILE
William H. Turner, II