THOMAS FUNKE

** ****** **.

O’Fallon, MO *****

636-***-****

PROFESSIONAL SUMMARY

Over 25 years of programming, analysis, and testing.

20+ years of program design, system architecture, and implementation.

Worked on several different payroll projects, from collecting user requirements in order to rewrite the process, to simple program maintenance so that the current payroll process could last until the replacement system was ready for use.

Responsible for a portfolio system that kept track of the company's entire customer base and all of those customers' holdings.

Responsible for the financial batch process which required 24/7 availability.

Gather requirements from system/user interviews, code, test, debug, and document conversion programs for a new payroll system to upgrade the computer that the payroll process was running on.

Gather requirements from system/user interviews, code, test, debug, and document conversion programs to upgrade the database.

Analyze programs and provide time requirements along with all documentation needed to change existing programs for general maintenance, as required.

Assist with 24 hour support for resolving production issues, as required.

Using DB2 most files were accessed using cursors to fetch rows so that the entire file was not read when only a small percentage of the rows were needed. Many rows are also read directly when there is a need to update a specific row. (ie. Rows where we have enough information to only retrieve 1 record for update).

Fully participate in all projects and sub-projects, as assigned.

Read and create technical specs for all projects as required for my participation within the project group.

Participate in all unit testing, integration testing, regression testing, and user acceptance testing.

Resolve and correct all defects in programming code as well as code developed by others.

Create all documentation required to promote changed code through conversion environments, system test environments to get the code into production.

TECHNICAL SKILLS

Hardware: IBM Mainframe, ES9000, DEC/VAX

Operating Systems: MVS ESA, DOS/VSE, Z/os

Programming Languages: COBOL, COBOL II, JCL, MVS, SQL DB2, MANTIS, MARK4, IDEAL, Assembler

Database / Data Management: CICS, DB2, IDMS, VSAM, TOTAL, DB/COMM, SUPRA, MQ-Series

Tools and Utilities: SHOW, DISPLAY, EXHIBIT, SYNCSORT, TSO/SPF, Batch XPEDITER, On-line XPEDITER, CA/SORT, File-Aid, Easytrieve, MS Word, MS Excel, Zeke, Autosys, Changeman, CA7

Applications: Retail, Financial, Payroll, Manufacturing, Inventory Control, Accounting, Insurance

Methodology: SDM, Champion, SDLC

PROFESSIONAL EXPERIENCE

L&T Infotech Limited 03/13 – 01/14

Contractor – AMIG

Working primarily on their daily EDI processing and any maintenance or new development that is needed to keep their EDI processes running. Working on setting up a new server for the EDI process as our current server is going to be retired. Work on other trouble tickets as assigned.

Prospect Infosys 10/12 – 12/12

Contractor – RKV Technologies

Working on a project that will identify persons who have received state benefit overpayments based upon fraudulent statements. This information will then be passed along to the federal government into their TOPS program. If any of the persons that we identify receive a federal tax refund, some or all of that refund will be sent to the state depending upon the TOPS program rules. Any overpayments that qualify for this program will generate a letter to the person asking for repayment. Sixty days after the letter is sent we will verify if that person still qualifies for the program and then enter the person into the federal TOPS program. I have worked on creating the programs that will validate that the person identified still qualifies for the program, the program to create the federal file of add and change records, and the program to process any collections that the federal government collects on our behalf.

Better Minds Consulting 11/10 – 09/12

Consultant – AMIG

Mortgage Insurance

Responsible for the programming of small projects that have been stacking up. These projects are mostly estimated to be 1 – 2 weeks in length but there are over 150 of them. First project was to create steps to split out certain records from an input file, look for duplicate records, combine the duplicates into 1 record depending upon certain criteria, put the file back together and then continue the job like normal. Second project was a conversion from an hard coding step within jobs that send out emails with reports that were created in the jobs to a more internal type of system with an input screen where the users are able to make update to email lists, email messages that are sent, and some other information that with the old system required JCL changes.

Client Resources Inc.

Consultant – Woodmen Insurance 3/10 – 7/10

Gener/OL to Cobol conversion

Responsible for finishing the conversion from the 4th GL Gener/OL programming language to Cobol. This process was started by a company that told Woodmen that they could take the Gener/OL code and generate a running Cobol program. As with any code generator the conversion could only convert the code and not the logic for how the Gener/OL programs process the information. Gener/OL has a lot of processing that happens behind the scenes and did not convert. There were several Gener/ol commands that did not convert to a valid Cobol command. I had to figure out what the Gener/OL program was attempting to do and then make the Cobol program do the same things. We also were supposed to make this conversion as seamless as possible so that the users will not notice any changes to their screens and how they process their work. These programs are 100% CICS transactions accessing both DB2 and VSAM files.

Edward Jones

Associate 8/07 – 6/08

Income Distribution Systems

Worked on problem tickets for the IDS/SCP team and carried the team pager. This team was about 50/50 for CICS on-line and batch programs along with 60/40 for using the IDMS database compared to the DB2 database.

Create and implement test plans for all changes assigned to me.

Lead a team in the architecture, design and programming of the Income Reinvestment project. Created a system that would allow the users to see products that were about to generate some sort of payment. (Dividend, Interest, Capital, or Principle). This allowed the branch to see all of their customers that were currently set up to reinvest these payments and those customers that were not set up to reinvest the payments. The customers that were not reinvesting could then be contacted to set up reinvestment options. Create the test plan for the project along with helping the user create their user test plan. Keep track of all tests that fail to be sure that they are corrected and re-tested before the user test plan is implemented. This project was Java on-line with Cobol batch to support the on-line system and 80/20 DB2 database and VSAM files.

Regression test all changes where applicable.

Class Action Project

Lead a team that created checks for former customers who were participating in the Class Action Lawsuit. This project was 25/75 CICS on-line to Batch and about 20/20/40 for IDMS database/VSAM files/DB2

Sent the Class Action check files to ADP which had to conform to ADP standards and requirements.

Created ad-hoc programs for Class Action.

Responsible for check return processing for the Class Action project.

Responsible for all test plans to be sure that the checks were correct before they were sent out for printing.

Fair Fund Project

Lead the team that analyzed participants in the fund who were from California as California had opted out of the settlement.

Reported total payments to California residents and to non-California residents.

DAL Data Access Layer conversions

Apex Consulting

Consultant - Edward Jones 1/06 – 8/07

Problem Reduction Team

Worked on problem tickets for various teams. These were both on-line CICS and batch programs and depending on the program either IDMS or DB2.

Peak Performance

Analyzed long running processes

Presented options for speeding up the process

Made changes to the process in order to shorten the running time of the process.

FAIR Fund Project

Created wires for IR's for their account that received payments from the FAIR Fund settlement.

Created and sent the FAIR Fund check files to ADP which had to conform to ADP standards and requirements.

Created file for OFAC testing.

DAL Data Access Layer conversions. This was converting all of the on-line CICS and batch programs so that the program did not know if it was calling the IDMS database or the DB2 database. The object of this project was to allow Edward Jones to slowly move the database from IDMS to DB2. The main problem with this project was that any DB2 database that was created was going to have to image the IDMS database and was not going to access the full power of DB2.

Create and implement test plans for all changes assigned to me.

Washington University

Programmer Analyst II 12/03 – 1/06

Support of the AP & FIS Systems. This system was still using the Total database but any new development was being done with DB2. The on-line system that the university used was Mantis.

Verify all jobs successfully scheduled through Zeke and Autosys.

Verify that each job ran successfully each day, making corrections to those that fail.

Make any required program modifications resulting from business rule changes, hardware/software upgrades, or day-to-day operations are changed.

Created a process that encodes and sends a file to the bank.

Continually tuning a process that feeds information into a tax reporting system that is used to produce 1099 forms.

Create and implement test plans for all changes assigned to me.

Continually review the work flow through Zeke and Autosys are performing at optimum efficiency

Ferguson Consulting

Consultant - Washington University 2/01 – 5/03

Developed program specifications and test plans from both written and verbal instructions about enhancements or system problems.

Coded new feature and changes that would enhance the efficiency of programs.

Maintained the Payroll-Personnel System.

Lead the payroll and health benefit development changes and enhancements for the university. These changes range from changing providers to changing the rate tables.

Lead the program changes to support W2 reporting for employees and government.

Create and implement test plans for all changes assigned to me.

Ferguson Consulting

Consultant - Federal Mogal 10/98 – 2/01

Maintained the Financial Sales Administration system.

Designed and created programs to extract customers and products from the current mainframe system to a client server Margin Management System.

Designed and created interface for label programs to packaged software for Order Entry System.

Scheduled all new programs through Zeke.

Utilized FTP to send extracted sales files from all Federal Mogul operations to one central location.

Rewrote both on-line and batch programs to access a DB2 database rather than IDMS databases.

Converted several reports from FOCUS to COBOL. Converted a FOCUS program to CICS and added several enhancements.

Created parallel test plans and system documentation for new programs. Developed system manual for Label Processing System to be used for training IT users and staff.

Provided on-call support for daily, weekly, monthly and yearly financial systems.

Ferguson Consulting

Consultant - Anheuser-Busch Companies, Inc 12/97 – 9/98

Developed the Year 2000 (Y2K) coding changes for an automated payment system that pays out over $6 million annually. Required cooperation and frequent communication with large team.

Created test plans and implemented testing for programs with Y2K changes. Coordination of testing results made this testing difficult.

Comsys, Inc

Consultant - Edward Jones 9/93 – 12/97

Analyzed, estimated, designed, programmed and implemented enhancements for Marketing Systems. Worked on Portfolio System that required careful, systematic testing to protect multiple interfaces.

Followed formal System Development methodology in all tasks.

Designed system to move Account Payable checks from the 1403 impact printer to Laser printer.

Responsible for Portfolio System on a 24 x 7 basis that required support for problem analysis after being paged. Developed design for Portfolio System from requirements gathered at on and off site meetings with marketing users.

Create and implement test plans for all changes assigned to me.

Champion International Corporation

Programmer / Analyst 11/89 – 2/93

Designed, coded, tested and implemented a new Payroll System to replace a SERIES/1 Payroll System.

Trained and provided support for system. Required to be available for problem resolution on a 24-hour basis.

Developed systems which included time cards and time sheets for both the SERIES/1 and new payroll systems.

Andrew Jergens Company

Programmer 3/88 – 11/89

Designed and created new programs and systems as required.

Created and implemented test plans for all changes and systems that were assigned to me.

Rewrote existing programs and systems to increase speed and efficiency with updates and enhancements.

Designed a Soap & Lotion Tracking System for advertising to track payment for each advertising firm. Developed training material to be used by users. Training was difficult because of need to understand company s complicated business rules.

Enhanced an Assembler program written in 1966 with direct deposit capabilities. Designed the on-line system to capture the bank numbers with the capability of having 2 places for each employee to deposit money. This design was for a new business concept and required unusual and difficult reiterations of the design and approvals were long and tedious.

Developed design for VSAM and IDEAL files. This design was complicated by the use of Assembler to extract the data.

Responsible for resolution of system problems and routine backup and recovery procedures on a 24x7 basis.

Cincinnati Technical College

Programmer Analyst / System Analyst 8/86 – 3/88

Rewrote existing programs and systems with updates, enhancements and general maintenance.

Responsible for the Admissions System of the college and the reporting system.

EDUCATION:

Cincinnati Technical College 9/80 – 5/82

Associates of Applied Sciences Degree

Contact this candidate