SUMMARY:

• DATA PROCESSING AND INFORMATION SYSTEMS
• Over twenty years of experienced in analyzing, designing, testing, and developing programs for retail, manufacturing, government, education, insurance, and the banking industries.

TECHNICAL SKILLS:

Software:  COBOL/ II, SQL, PL/SQL, JCL, DCL, CICS, ETL’s, XML, CA Enterprise(4th GL), VSAM and RMS (FDL) file structures, QMF, Spufi, Windows, MQ Messager/ CICS DPL, Data Expert, File Aid, Abend Aid, Xpediter, Lotus Notes, Lotus 123, Excel, Word, Wordperfect, Viso, VAX Document, Datatrieve, and Canvas.Databases DB2, IMS, RDB, Oracle, Optibase, and WebSphere MQ series.

Hardware: Confidential (MVS/ISPF) Mainframe, Confidential 9000 VSE (OS/2), UNIX, Digital Workstations (3100), Digital VAX (6600, 8800, 780), Confidential PC’s, Packard Bell PC, and Macintosh Computers.

PROFESSIONAL EXPERIENCE:

Confidential, Louisville, KY

Application Analyst

Responsibilities:

• Responsible for support and enhancements for the backend settlement of credit cards.
• This includes the decommission of applications, a project to migrate Oracle from the mainframe to the AIX system, COBOL upgrade to version 11, several releases of the semi - annual release requirements, a large Risk Management Work project to identify suspicious clients.

Environment: Confidential Mainframe z/OS with TSO/ISPF, COBOL, VSAM, Oracle and JCL.

Confidential, East Lansing, MI

Application Developer

Responsibilities:

• Responsible for support and enhancements for the ESI Corporation located in Minneapolis, MN.
• It includes the support of problems and change tickets for POS and Eligibility applications, which involves problem determination and implementation of changes / enhancements to the applications.

Environment: Confidential Mainframe z/OS with TSO/ISPF, COBOL, DB2, CICS VSAM, and JCL.

Confidential, Milwaukee, WI

Consultant 

Responsibilities:

• Responsible for the Conversions and Mergers of all ACH client services provided by FIS.
• This process includes the execution of jobs and the preparation of JCL and / or programs to uniquely custom each clinic needs.

Environment: Confidential Mainframe z/OS with TSO/ISPF, COBOL, VSAM, and JCL.

Confidential, Dubuque, IA

Websphere Administrator

Responsibilities:

• Responsible for the Websphere support at Confidential . Support problems and change tickets for client server operations for work involving problem determination and implementation of changes to hardware, software, applications or network systems.
• Lead and mentor support teams to execute Middleware infrastructure environments and product upgrades.
• Create processes and document future issues. Lead and mentor support teams to execute Middleware infrastructure environments and complex product upgrades.
• Lead and mentor support teams in the correction of complex Middleware security non-compliance issues.

Confidential, Milwaukee, WI

Senior Consultant

Responsibilities:

• Responsible with the Detail Design of the EFC2 project for Kohl’s Department Stores.
• This entailed a solution for fixing the issue of hardcoding in the current mainframe legacy applications.
• With the addition of a second and subsequent EFC’s in the future, they need to ensure that the processing in place for the first EFC will be duplicated for the new EFC(s).
• These included hardcoding changes and the creation of tables to give the system a cross reference of where an item resides.

Environment: Confidential Mainframe TSO/ISPF, COBOL, DB2, VSAM, CICS, MQ Series, XML, and JCL.

Confidential, Milwaukee, WI

Senior Consultant

Responsibilities:

• Responsible for the maintenance and support for the following systems for MillerCoors LLC: Data Collection Reporting, Retail Sales Application (RSA)
• Distributor Realignments, Retail Sales, Trade Dimensions Monthly Processing, Human Resource, Pension, Payroll, Employee Information, Benefits, Time and Attendance, Fixed Assets, Inventory for Sales, and Pricing Analysis. Provide 24 hour support for the above systems, along with small project work.

Environment: Confidential Mainframe TSO/ISPF, ABS COBOL, DB2, VSAM, CICS, and JCL.

Confidential, Coralville, IA

Software Engineer III

Responsibilities:

• Vangent has a contract with the Department of Education to process applications and corrections for Free Application for Student Aid (FAFSA) data.
• The CPS system edits input data received through paper, electronically, Web, or system generated. After passing edits, the data is sent to five matching government agencies to validate the information. Upon the return of validated data, the CPS system will calculate the student’s expected family contribution (EFC).
• The EFC is used to determine the PELL grants and loan distribution amounts. CPS then sends the information back to the student electronically or through the paper product called a Student Aid Report (SAR). The student checks the SAR (electronically or paper) and decides if there are any corrections to be made.
• If the student decides that corrections are needed, they send the updated SAR (electronic or paper) back to the CPS, and the process starts again.
• In addition, the CPS processes SAR Reprint requests, and enables users to view MIS data using Online Analytical Processing (OLAP).
• In the fall, a separate process identifies Renewal Application eligible transactions on the CPS Database. The Renewal Application transaction is used to pre-populate student’s data on the web. The reason for this process is so the student doesn’t have to reenter all the information they initially entered from prior year.
• The Web products, FAFSA on the Web (FOTW), Renewal Applications on the Web (ROTW), and Corrections on the Web (COTW) are edited and calculated the same as above.
• CPS also interfaces with the Image Data Capture (IDC) and retrieves and stores images of all paper documents. Pre FAFSA applications submitted from the Web will be processed separately to calculate an EFC.
• A member of the CPS team, I was involved with the 08/09 school year enhancements, which included: twelve program modifications, thirty-five ETL modifications for OLAP which included several load module changes, twenty-one production JCL changes, and updates to the Runbooks/ On-call procedure documents.

Environment: COBOL on Confidential MVS TSO/ISPF system, ETL’s (OLAP), Windows XP, Word, Visio, Excel, DB2, QMF, Spufi, JCL, VSAM, WebSphere MQ messager/ CICS DPL Bridge, Panvalet, Xpediter, File Aid, and SDLC Work Ahead Waterfall methodology.

Confidential, Milwaukee, WI

Systems Designer/Developer

Responsibilities:

• Added two enhanced functionality, installed vendor software, and corrected several defects to the claims processing system for the Assurant Health Insurance Company. The first enhancement was to add new functionality to the Claims system that will notify the Claim processor of the existence of a special Pre-Authorization record that should be viewed for special negotiations on costs for the related medical claim.
• Install two versions of Autocoder without error and within the time constraints.
• Four projects were completed for the wealth management system for the Metavante Corporation. The first two projects included the drop down display and maintenance to the XML messaging system for the ‘Composite Account’ and the ‘Contact Alert’ systems. The third project was the creation of a download file used in Excel for any report created from the report writer system. The fourth project was the request to add federal withholding fees at the branch level for each bank.

Environment: Confidential Mainframe TSO/ISPF, COBOL, XML, VSAM, JCL, Xpediter and File Aid.

Confidential, Milwaukee, WI

Senior Systems Analyst

Responsibilities:

• Responsible for two major conversion projects and one major enhancement project, along with the daily maintenance for the two furniture divisions at Sak’s Incorporated. The purpose of the first conversion was to move the “Carsons, Pirie, Scott” division to the Sak’s common system utilizing SDLC methodology.
• The first conversion involved changes to all programs, JCL, Procs, Control cards, screens, and QMF objects to reflect the new naming convention of the Sak’s common systems. In addition to the naming conventions, all date routines were changed to keep the current ISO format usage.
• It involved the data conversions to unload the current mainframe data and then reload it via the DB2 download/upload utilities, along with the FTP process to move the data. Each member of the team received a “Chairman of the Board” award for this successful conversion.
• The second successful conversion was to move from the GERS Oracle software (UNIX) also to the common system.
• It involved unloading the current Oracle data and reloading it to the mainframe via the DB2 load utility. Writing several one-time programs to FTP the data from the UNIX computer and creating several other one-time programs for the user to enter any information not found in the GERS system, but used on the mainframe system.
• The last step was the creation of history reports using the GERS data and then moving it to the common reporting system.
• The major enhancement project was the creation of the reservation archive system. It involved the analysis of what information needed to be retained for the furniture system. All information that was over two years old was archived. Any delivery reservation information over two years old was removed from the system. If the user needed to do any maintenance to the reservation, the archive process allowed the user to move any archived reservation back to the current system.
• Approximately, 30% percent of the rows were removed from the current system and the nightly batch process time was reduced by 40% percent. In addition to the major projects, I needed to maintain a stable environment for the CPS main frame and GERS Unix system. Help identify impending problems such as those caused by increased volumes, file sizes, and operating environment changes before they occur.
• Develop and execute unit, system integration, user acceptance and production test plans. Ensure that program moves to production will not adversely affect the existing production environment. Tools used: Xpediter and File Aid.

Environment: Confidential Mainframe TSO/ISPF, COBOL, JCL, CICS, DB2, QMF, Spufi, VSAM, PL/SQL, Oracle, UNIX, Windows 95/XP, Novell Network, Extra emulator.