David M. Email & Phone Number

Madison, Wi, Us

Madison, Wi, Us

1210 W. Dayton St

Provided technical support for the Peoplesoft Finance and Supply Change systems.Modified delivered PeopleCode in the Project Costing module to eliminate sending blank messages through the Integration Broker to external systems.Wrote technical specifications for loading journal line and header transactions via a direct database link. Created a custom journal load program to process these transactions into the journal temp tables and execute the delivered journal edit process. Met with functional managers to determine change request priorities and timelines.Technical Lead on the Peoplesoft Finance/Supply Chain upgrade from release 8.8 to 9.1.Reported IT updates to the core project teamMet weekly with the Oracle vendor support to review customer service casesAssigned and monitored developer work loadsModified PeopleCode for reapplication of customizations as necessary

Worked with Business Analysts to define new technical processes and create program change specificationsPerformed maintenance to CICS programs for Internal Corporate and Government directed change requests.Converted production VSAM files in order to meet government requirement deadlines.Monitored monthly and quarterly system change implementations

Provided technical support for a Banking Institution on their Credit Card processing system. As part of a Unique ID project that eliminated the passing of a customer's credit card number to external vendors: • Modified existing COBOL program to populate the new Unique ID and Master Account DB2 tables when credit card applications are processed and booked onto the system• Wrote DB2 load procedures• Oversaw the implementation of conversion programs and monitored conversion jobs to ensure results were accurateFor a Rewards/Redemptions system change from one external vendor to a new vendor:• Coded COBOL/DB2 programs that created daily Customer and Transaction rewards files for processing by the external vendor• Worked as a liaison between the File Transfer Server Team, the external Vendor, and the IT Development team• Oversaw the testing of file transmissions and retrievals• Developed the Conversion schedule and the Implementation plan documents Wrote technical documentation including Test Case documents, Test Result documents, Process Flow diagrams, and Batch Processing documentation

Provided technical support for the Procurement & Disbursement area using PeopleSoft Financials and the Electronic Settlement business area using the in-house WebEFT application.For the Electronic Settlement area:Improved the efficiency and performance of COBOL and Visual Basic programs by restructuring code, fine tuning SQL statements, and adding or removing DB2 table indexes.Created custom reports with Crystal Reports for client/server applications written in Visual Basic 6.0.Restructured batch jobs and tuned SQL statements to reduce a monthly DB2 archive process from 6 hours to 2.5 hours.Led the development of a Security Administration system for the WebEFT system. Met with business users to aid them in developing business specification documentsWrote page and class module design documentsCoded ASP pages and Visual Basic COM+ objectsDesigned DB2 table modelsFor the Procurement & Disbursement area:Modified PeopleCode for corporate specific edits.Created panels for entering responsibility unit and location combination edits that were stored on database tables.Wrote SQR programs to pull data from the database tables for batch printing of payment/voucher checksCreated on-demand Voucher processing reports using Crystal Reports

Provided technical support for Financial, Accounting, and Warehouse Management Clients.Coordinated a general ledger upgrade with outside vendors.

Provided technical support for Financial and Accounting Clients.Designed a nightly batch process to edit vouchers outside of the Application Engine and print checks using PeopleSoft v5.1 Financials.Installed several upgrades for the Walker general ledger.Coached client employees on COBOL, JCL, SQL, Changeman, FileAid, and DB2 utilities.

Worked on maintenance requests, wrote report programs, and created flat file to DB2 table matching programs.