SUMMARY:

I am a senior IT software engineer with considerable experience using DB2, Oracle and Teradata. For most of my career I have been involved with very large datasets (datamart or data warehouse).I have participated in very large program development projects using the SDLC methodology, as well as writing hundreds of ad - hoc report programs using SAS. I have used all major flavors of Unix and am conversant in the command languages of the three major OS types. In the past few years I have been heavily involved in creating customer lists for risk management and product promotions.

TECHNICAL EXPERTISE:

Languages: SAS (Base, Macro, STAT, SQL, GRAPH, Tabulate, ODS), Shell scripting, SQL, and some PL/SQL, Visual Basic, HTML, PL/I, COBOL, JavaScript, XML, JCL, HLASM

Operating Systems: Windows(8.1, Vista) Unix (HP, AIX, Solaris, SUSE), IBM (z/OS, MVS/XA)

Database: Teradata, DB2, Oracle, MS Access, SQL Server, Sybase

Tools: Access, MS Excel, PowerPoint, MS Word, MS Visio, Xpediter

Outputs: Flat Files,Excel spreadsheets,SAS datasets, SAS Dashboards, DB tables

SAS: Versions 9.13, 9.2, 9.3 with BASE SAS, SAS/STAT, SAS MACRO, SAS SQL, SAS/FSP, SAS/ASSIST, SAS/ACCESS, SAS/CONNECT, SAS/GRAPH, SAS DB2UTIL, SAS intrNet, SAS Perl, SAS Enterprise Guide, SAS AMO et. al

PROFESSIONAL EXPERIENCE:

Confidential, Cary, NC

Responsibilities:

• I wrote SAS programs in support of their credit risk progam.
• I used SAS 9.4, SAS Visual Analytics, SAS Data Integration Studio and dealt with extremely large databases located in memory using SAS LASR technology.

Confidential, Clearwater, FL

Sr SAS Programmer

Responsibilities:

• I wrote SAS programs that imported data from Excel spreadsheets and created reports on Emergency Room abuse (too many uses), hospital visits, dental visits, costs of medications by client, zipcode, zone and store number.
• And other reports as requested. Involved a large amount of data cleansing.

Software: SAS 9.3, Windows XP

Confidential, Oldsmar, FL

Sr SAS Programmer

Responsibilities:

• I wrote SAS code that extracted performance data over a one and a half year period creating a history file that was then compared against ongoing test data. From this data reports and charts were generated.

Software: SAS 9.2 SAS 9.3 SAS EG 5.8 Hardware: IBM MVS, Unix, Windows 7

Confidential, Indianapolis, IN

Sr SAS Programmer

Responsibilities:

• I wrote “Black Box” software to duplicate the output of proposed production software. I also assisted in writing the test accompanying test documentation.

Software used: Base SAS 9.2, Proc SQL.

Confidential, Dayton, OH

Sr SAS Programmer

Responsibilities:

• I modified production software data layouts to read the new Confidential claims system data received from OJFS.
• Created a care provider history program that tracked each provider’s availability and their capabilities over time.

Software used: Base SAS 9.2, Proc SQL reading MS SQL Server DBs.

Confidential, Columbus, OH

SAS Risk Programmer

Responsibilities:

• I wrote SAS programs in support a major migration claims payment system.

Software used: Base SAS 9.2, SAS ODS, MS Excel

Confidential, Columbus, Ohio

SAS Risk Programmer

Responsibilities:

• I was responsible for writing stored process code using PROC SQL, that, when executed, invokes Excel and creates spreadsheets and charts as directed by the end user.
• These spreadsheets show the variance between the Probability of Default (PD) and the actual default rates of the client customers (home and auto loans as well as credit cards).

Software used: Base SAS 9.2, SAS Stat 9.2, SAS Add In for Microsoft Office, MS Excel, MS VBA, IBM DB2, Business Objects.

Confidential, Columbus, OH

Sr SAS Programmer/Analyst

Responsibilities:

• Utilizing SAS, PROC SQL, Teradata and Teradata CRM tools, I worked on projects focused on managing and coding email, mail and telemarketing sales campaign lists for specific target audiences.
• I also provided numerous reports detailing selection / non-selection criteria and results.
• Additionally, I documented the execution flows of three CRM projects.
• This included the entire data flow in and out of Nationwide.

Environment: SAS 9.13 (PC,Solaris 64)

Confidential, Houston, TX

Sr SAS Programmer/Analyst

Responsibilities:

• Utilizing SAS PROC SQL and Oracle PL/SQL, I wrote SAS programs to generate reports of customer payment profiles.
• Produced SAS programs on an ad-hoc basis.
• Was required to convert PL/QL code to SAS PROC SQL to validate new production database tables.

Environment: SAS 9.13 (PC, HP), SAP and Oracle

Confidential, McLean, VA

Sr SAS Programmer/Analyst

Responsibilities:

• Updated the Confidential mortgage mass mailing model which used a Teradata DB systemto improve its execution and efficiency.
• This program used 26 PROC SQL statements using SAS pass through facility to read tables consisting of up to 43 million rows of 2200 columns.
• After modifications were made the execution time was reduced from 11 hours to 2 hours.
• Modified and executed monthly production SAS programs which used credit bureau information.
• Created a program to read, verify, validate and report input variables to the production models.
• This data was used to create SAS Dashboards of a rolling 12 month view of variable changeability.
• Created SAS datamarts from the Teradata DB which were used to reporting and data analysis.

Environment: SAS 9.13 (PC, Solaris 64, zOS), Teradata and Oracle

Confidential, Springboro, OH

Sr SAS Programmer/Analyst

Responsibilities:

• Modified SAS code to use their new data repository.
• Gathered data across several Unix web servers using Unix scp command to create SAS Share datamarts.
• Used a combination of SAS Base language, SAS Perl, Java scripts and HTML to create WebSphere JAVA garbage collection statistical reports.
• Used SAS to create interactive web reports using the SAS datamart data collected.
• This was accomplished using SAS Internet, SAS ODS and HTML.

Environment: SAS 9.13 (PC,Solaris 64) and WebSphere on AIX