Senior Sas Programmer Resume
PennsylvaniA
Objectives Computer Programming and systems analysis
Education
B.S. in Mathematical Computer Science,
Experience
Administrative Assistant, Operations Control
Generated reports using LOTUS 1,2,3.
Entered data into a mini database used for warehouse
inventory.
Performed VSAM extracts for operations control using SAS on TSO.
AMP/TYCO Electronics, Harrisburg, Pennsylvania May, 1986 to January, 1996
Systems Analyst
Developed on line data entry systems using REXX in conjunction
with SASSCL and/or RAMIS.
Developed on line report generation systems using
REXX/RAMIS/RAMEXECS/SBX.
Developed/maintained batch generated performance
reporting files/reports using VMBATCH/RAMIS.
Produced performance graphs using TELEGRAF.
Used REXX/SAS/RAMIS to maintain sales statistical
files and master driving files.
Automated monthly password changes and execution submits
using REXX/SBX, this eliminated operational duties for several coworkers.
Automated hard copy report distribution via REXX/RAMIS/Programmable
XEROX printers. This eliminated bursting duties for several coworkers.
Automated report footnote/REVISED title changes using an Assembler
function called from RAMIS.
Was instrumental in developing a Point of Sale processing system. This system
would determine errors, notify user of the type of error, the record in question
and also convert the CMS file to a properly formatted (zoned signing) MVS
compatible tape. Lastly it would automatically rename tapes to keep them
from being processed multiple times.
During 1994/1995/1996 I was directly responsible for the generation of
200400 ad hoc reports/data files monthly. I gave direction to 1015 analysts for 4 hours a week to ensure that these requests were handled. I was also responsible for training new hires, summer students and coops.
Confidential,Pennsylvania, May 1996 to January 2010
Senior SAS Programmer
First few years:
used SASTSO against VSAM files to perform loan sales and generate special
one time reports.
Next several years:
used SASTSO running embedded SQL against the new DB2 servicing system
to perform loan sales, adhoc reports and data transmissions to support special needs of our external customers.
Last several years (in addition to duties mentioned above):
mentored nearly a dozen individuals on how to properly code SQL inquiry DMLs. This involved utilizing correlated subqueries and multi level stepped joins.
also was the sole provider of borrower benefit reporting. This involved some
of the most complicated tables yet created for the DB2 servicing system.
Most recently I was the sole individual in the department responsible for developing
the coding necessary to support the Ensuring Continued Access to Student Loans Act
created by the Federal Government to provide liquidity when the credit markets froze.
this involved a funding request transmission that has been run hundreds of times.
it also involved a monthly reconciliation transmission for which I was the only
individual responsible for at PHEAA. At one point said reconciliation had to be
performed for 13 different external customers. I was recently able to automate most of it reducing the monthly cycle window from 7 to 3 days.