SUMMARY:

• Senior IT Software engineer with considerable experience using DB2, Oracle and Teradata.
• Most of my career have been involved with very large datasets (DataMart or Data warehouse).
• Extensively participated in very large program development projects using the SDLC methodology, as well as writing hundreds of ad - hoc report programs using SAS.
• Efficient with all major flavors of UNIX and am conversant in the command languages of the three major OS types.
• Heavily involved in creating customer lists for risk management and product promotions.

TECHNICAL SKILLS:

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, MXGOutputs: Flat Files, Excel spreadsheets, AS 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, OH

Sr SAS Programmer

Responsibilities:

• I currently work part time in the Confidential watering the plants, assisting customers and helping to load their vehicles

Confidential, OH

Sr SAS Programmer

Responsibilities:

• I worked part time in the Kroger gas station as a cashier. I got another job at Home Depot, but was unable to coordinate the hours between the two jobs, so I quit.

Confidential, NC

Sr SAS Programmer

Responsibilities:

• I was an FTE with Deutsche Bank where I wrote SAS programs in support of their credit risk program. Used SAS 9.4, SAS Visual Analytics, and SAS Data Integration Studio and dealt with extremely large databases located in memory using SAS LASR technology.

Confidential, Clearwater, FL

Sr SAS Programmer

Responsibilities:

• 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:

• 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, and Windows 7

Confidential, Indianapolis, IN

Sr SAS Programmer

Responsibilities:

• 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, OH

Sr SAS Programmer

Responsibilities:

• Modified production software data layouts to read the new MITS 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, OH

SAS Risk Programmer

Responsibilities:

• Wrote SAS programs in support a major migration to the new Medicaid Information Technology System (MITS) claims payment system. This was a joint project of the Department of Developmentally Disabled (DODD) and the Ohio Jobs and Family Services (OJFS) departments.

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

Confidential, Ohio

SAS Risk Programmer

• 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, 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, 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, VA

Sr SAS Programmer/Analyst

Responsibilities:

• Updated the Confidential mortgage mass mailing model which used a Teradata DB system to improve its execution time 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 for reporting and data analysis.

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

Confidential, 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

Confidential, Springboro, OH

Sr Software Engineer

Responsibilities:

• Maintained several PL/I document indexing programs. This involved modifying the primary code as well as subprograms (grammars) that provided the indexing criteria.
• Rewrote metrics program to utilize new PL/I SAX parser for XML documents. Wrote programs to modify datasets, using SAS macro language.
• Migrated a major indexing application to client server environment (SQL Serve, Perl, C++, TCP/IP sockets) and added ability to parse XML documents.
• Much of the XML modifications to these programs were in anticipation of the LexisNexis globalization effort, which will allow Latin I (most foreign languages) datasets to be processed. Participated in numerous code reviews.
• These projects all include using the SDLC architecture with high level, low level through release to production documentation using MS Word and Visio.

Environment: PL/I, SAS 8.x, OS 390

Confidential, OH

Sr Programmer Analyst

Responsibilities:

• Designed, coded and maintained an online accounting application using VS COBOL II, IMS/DC, and DB2.
• Batch programs were created and maintained using IBM PL/I, IBM VS COBOL II, SAS (BASE, TSO, Connect, DB2Util, Assist, et.al.) The online programs were created with CA-TELON, a program development tool.
• Performed Y2K maintenance when necessary.

Environment: COBOL, PL/I, SAS, DB2, ISPF, Telon, QuickJob, Xpediter, OS/390