Programmer Analyst Edi Software

THOMAS FUNKE

** ****** **. *’Fallon, MO ***** Cell: 636-***-**** E-mail: *******@*****.***

PROFESSIONAL SUMMARY

Over 30 years of programming,designing, analysis, and testing.

Developed a way to add Direct Deposit into a 20 year old Assembler Payroll System.

Built an EDI process on a Windows 2000 server and then worked on upgrading both the server to Windows 2008 and the EDI software to work with the new server OS.

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

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; Waterfall; Agile

PROFESSIONAL EXPERIENCE

Peraton 8/23 – Current

Contractor – DFAS

Worked on the Defense Finance Accounting System. We were one of the groups that worked on the programs that allowed the armed forces to pay their civilian personal. These were complex programs that just kept growing as changes were made. No programs were ever evaluated as needing to be re-written or broken into multiple programs based upon the size of the programs. Using Agile and Scrum Teams

GDH Consultants 12/22 – 8/23

Contractor – DFAS

Worked on the Defense Finance Accounting System. We were one of the groups that worked on the programs that allowed the armed forces to pay their civilian personal. These were complex programs that just kept growing as changes were made. No programs were ever evaluated as needing to be re-written or broken into multiple programs based upon the size of the programs. Using Agile and Scrum Teams.

United States Post Office 06/15 – 12/22

Rural Letter Carrier

Mainframe contracts were disappearing so I had to re-invent myself while I waited for my next contracting opportunity. I was responsible for delivering all mail and packages for my route on a daily basis.

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

Contractor – AMIG

Working primarily on their daily EDI processing and any maintenance or new development that was needed to keep their EDI processes running. Worked 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.

Better Minds Consulting - Consultant – AMIG 11/10 – 09/12

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 Team

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 - This was an IDMS to DB2 file conversion.

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 and presented options for speeding up the process

Made changes to those processes in order to shorten their running time.

FAIR Fund Project – An SEC Lawsuit filed against Jones for their handling of some Mutual Funds.

Created emails for Investment Representatives for their accounts that received payments from the FAIR Fund settlement.

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

Created file for OFAC testing – Checking to make sure that the payees were not on any Homeland Security check lists.

DAL - Data Access Layer conversions - This was an IDMS to DB2 conversion.

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 for maximum performance and 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.

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