William Bauer Email & Phone Number

Perform re-segmentation of Omni master files to allow for additional room for clients migrating from old Omni 5.2 to Omni 7.4.Write up analysis required for the conversion of all user exit scripts (ex: WDRL/XFER/LOAN MAX,s,VLDT,WDRLSUSP/FORF) going from Omni 5.2 to Omni 7.4.Code all changes on user exit scripts making them Omni 7.4 compatible along with removing old functionality now covered by Omni 7.4.Test all code to ensure it is functioning properly via T381, T384, T404, T444, T813, T815 transactions giving any support to QA testing as needed.

Perform analysis to clients for T907 data warehousing, VSAM re-org process (BR/BRAR, VTRAN and UCOM). Consolidate current extract processes involving COBOL/Omni Script.Provide Omni SME go-live support to correct production defects in various implementations.Support Omni Pay 4.1 to Next Gen upgrades for multiple clients. Responsibilities included verifying existing 4.1 - Next Gen output through rigorous testing procedures along with identifying Next Gen core code defects.Mainframe to LINUX/UNIX conversions – provide analysis/coding to convert MVS JCL/COBOL to shell scripts/Microfocus COBOL for multiple clients.Handle conversion of client specific Omni core jobs (unified, vtutil etc.) on the mainframe to unix shell scripts.Wrote TDD/Coded process to convert external client specific RMD process to Omni Core T844 transactions along with additional custom code to satisfy previous distribution history by way of T444/160 activity along with 12/31 and 4/1 eligibility & reporting.Support mainframe DB2 vs IBM DB2 Connect (LUW) performance testing.

Modify Omni Core module PREXFP to suit TIAA’s requirements of the T219 dividend and T039 IA transactions.Code Omni extracts to sync data with outside vendors utilizing DB2, Omni Scripts/COBOL.Provide Omni SME support to multiple projects for FIS’ inactive investments functionality.Design and code process to promote Omni Scripts to alternate production file set via REXX, ISPF panels and MVS JCL.

Modify various Omni Scripts, COBOL and Natural programs for PIN expansion.Design/Code new jobs in batch and determine where to schedule in the nightly cycle including contribution sweeps for the ITD (Income Test Drive) and CISS feed file.Assist QA on how to test code for various releases including job setup.Act as OmniPlus SME assisting different groups on contribution, distribution and transfer processing.Write technical design documents outlining changes required for COBOL, Natural and Omni Script modules on various projects.

Clone/Modify Omni Script otextr20 to meet specific client needs for files sent to Omni Trade.Modify existing check writing COBOL program to create CSV format payment files from the RS06* records for new business.Design/Code a COBOL program to create the Individual Directed Account cashiering file in CSV format derived from the sequential history file for new business.Create COBOL programs to process input price files from new/existing clients to edit, format and load prices to Omni.Setup all necessary transactions and data to run end to end testing on all above code.

Design and Develop Cobol modules for all types of confirms (Contributions, Transfers, Distributions, Refunds etc.) to read the sequential history file and format the output in XML and send to MQ.Convert batch remittance jobs (enrollments/contributions) from legacy to Omni.Analysis, code and testing for Omni fund/source expansion.Define control cards for various VSAM file processing (IDCAMS).Create/Execute all transaction types in Omni Station for Unit and Integration testing.Design and Develop all types of Omni Scripts (Base Event, Standalone, Called by VBA & ASP/HTML) for various projects and business needs.Upgrade/Maintain all Omni VBA for correct transaction creation per business/processing requirements.

Testing of multiple types of Omni Scripts in Omni Plus and Omni Plan.Performed code changes on existing Omni Scripts to meet specific business needs.Supported testing of Financial Engines/Managed Accounts program back end.Created Omni Scripts to meet specific business requirements.Testing of both Inbound/Outbound Payroll.Able to create data/ run all associated transactions to test all assigned tasks.

Performed production support for Omni Plus/Omni Plan daily unified mainframe batch jobs and resolved problems to meet specific time constraints (SLA’s).Debugged SunGard’s Omni Plus/Omni Plan core Cobol modules to correct problems that appeared on the updated Master Files (VSAM).Performed system regression testing to validate changes made to SunGard core Cobol modules.Modified code to meet system, user and regulatory requirements.Lead production ancillary notices to plan participants.

Responsible for the creation and maintenance of data used in integration and system testing.Analysis of converted data and integration of converted data into the system test environment.Coded and tested reports and interface procedures between Omni Plus and AMS’ Federal Financial System using COBOL II, JCL, XPEDITER.Responsible for the documentation of deliverables, technical specifications and test plans, as well as, the scheduling and allocation of tasks to meet production requirements.Supported system and integration testing by executing, documenting and verifying batch procedures used to process interfaces and transactions accepted through custom coded front end applications, including Web and VRU.Created a client interface facility using Visual Basic 6 as the front end for Omni Plus, a major component of the procedure used to establish daily prices. Provided editing and verification capabilities, and used the internet transfer control to send/receive data to/from a server.

Expansion of SunGard’s Omni Plan Pension (401k and 457) and Annuity Recordkeeping system to accommodate additional sources (modification of existing COBOL II code).Design and implementation of procedures to establish multiple vesting schedules for plan participant’s including methodology for reporting eligibility of clients using COBOL II.Testing and debugging of newly install procedures (XPEDITER and Microfocus).Responsible for system regression testing.Research and documentation of requirements for system enhancements.Created Excel spreadsheets to track and report project status.

Webmaster

Diploma, Computer Programming

Nominated for the Honor’s Program

License, Airframe & Powerplant License