Professional Experience

Confidential

Senior Engineer

• Designed and wrote an EDI application to validate and maintain SAP HR from a Ceridian HR file.
• As an acquisition team member I constructed an ABAP EDI program to load Carreker 206M MS Project data into CATS monthly for the subsidiary billing thus providing visibility to the business for managers, reducing processing cycles/time for the elimination of errors.
• I wrote a multi step ABAP EDI program to load acquisitions into PD and PA objects from a spreadsheet eliminating the need for LSMW. Supplemented with BDC programs.
• Constructed a PL/SQL acquisition solution to load Corillian data into SAP HR.
• Wrote a web-dynpro program, with 2 editable ALV grids used to update a parent/child relationship for configuration z-tables.
• ABAP support.

Confidential

Oracle Technical Lead/SAP HR ABAP Engineer

• Team contributor for SAP upgrade from 4.6c to ECC 6.0 using SPAU. Resolved upgrade issues for legacy ABAP code.
• Developed an ABAP payroll audit program for ADP Connection, which enabled payroll to quickly sync PCPW to SAP eliminating discrepancies.
• Designed and implemented a tracking application within the SAP database for HR and FI. Triggers recorded SAP changes and an ABAP program culled through the data either interactively, query mode or it could be scheduled as a batch job emailing results as an attached spreadsheet.
• Wrote an ABAP program to keep recurring payroll deductions in PA0014 in sync with PA0170 for all plan types addressing ESS mid-year plan changes, as a result of qualifying events.
• Wrote an ACH ABAP interface program for Bank of America.
• Designed, created, and implemented a SAP ABAP messaging system which delivers messages to recipients by message class and severity. Running every 5 minutes 24x7 for semi-real time delivery. Provides ability for IT to review and resend messages.
• Wrote a VB program with ODBC connections to Oracle and SQL Server, which updated EBI from SAP changes and gave control of physical access to all buildings to HR/SAP, utilizing CHOM.
• Devised and implemented a process for CMD scripts to be moved from DEV to TEST and to Production environments utilizing an environment file for dynamic look up of passwords.
• Lead developer/designer on a custom Oracle PL/SQL application used to update Active Directory, Remedy, EBI, RACF, and many other downstream corporate utilities from SAP. SAP changes evaluated and qualified based on stored definitions.
• Implemented the use of WS FTP for PGP encryption in SAP batch jobs to fully automate CMD jobs to interface 3rd party files to and from SAP HR/FI.
• Created an ABAP transaction to reset, generate, and email new SAP passwords by EMP ID.
• Wrote several ABAP extract/load programs for benefit interfaces. Fidelity, UHC, Suntrust, Wausau, Aetna, SHPS, etc. A spreadsheet for each interface file was created and automatically emailed to the process owner for complete transparency to resolve issues without IT.
• In emergencies, I applied direct database changes to SAP tables via SQL and/or PL/SQL. Performed partial client copies from production to development using dynamic SQL.
• Rewrote all PL/SQL objects for a highly visible custom CRM application utilizing shell scripts, stored procedures, and Visual Basic, making it maintenance free.

Confidential

Oracle Application DBA/Engineer

• Development and support for six production instances/web based applications, including test and development environments for each respectively. Set up batch jobs for hot and cold backups, archiving, and the DB monitoring. Enhanced oracle configuration. Client installs.
• Performed DB recoveries, performance tuning, and SQL tuning. 1st level Oracle DB support.
• Developed an automated billing process using shell scripts to schedule and initiate stored procedures to produce billing spreadsheets customized to meet each customer's requirements.
• Solved application critical issues and provided Oracle consultation to developers.
• PL/SQL development for a terabyte-sized AR application, ADP billing. Lead periodical code reviews for SQL tuning throughout the development lifecycle.
• Designed and developed stored procedure driver processes that would handle exceptions and perform error logging with automatic restart capabilities. Critical for long running conversion jobs.
• Wrote shell scripts to rebuild the entire database from ERD generated DDL for a release. The UNIX script ran DDL to drop and recreate the entire schema and compiled all objects back into the database exports taken just before the objects were dropped. The automated process tremendously reduced the effort and time expended on releases.

Confidential

Lead Analyst

• Application lead to create and integrate an EDI from legacy mainframe to Demand Solutions, a client server app. for Material Management. Provided technical specification to the DEV team.
• Support of functions/applications from order entry, inventory logistics, and materials management for a 1.2 billion dollar company.
• Merged the Voice and Copy products divisions, involving analysis, modification and/or rewriting and coordinating of 100 COBOL programs.
• Lead developer to replace Product and Location mainframe applications with a client server version using Realia COBOL with embedded Oracle SQL, PL/SQL, SQL, DOS scripts. Application DBA, writing SQL/DDL/DOS scripts for deployment.
• Responsible for IT coordination of semi-annual physical inventory 140 million in conjunction with accounting, materials management, distribution, and order entry.
• Designed, engineered, and implemented a self-managing multi-platform batch system which synchronized data and schedules between the client/server and mainframe enviroments.

Confidential

Programmer/Analyst

• Production support and maintenance of the Billing Verification System. a 24x7 real time application for PIN verification and approval of third party and collect phone calls for Bell Operating Companies BOC . Coordinated the daily loading of BOC database updates.
• Developed audit software to produce discrepancy reports for the reduction of fraud and errors for each BOC. Wrote programs to balance daily and monthly billings for Pacific Bell, US West, Bell South, etc. and enhanced code to reduce maintenance effort and cost.

Confidential

Programmer

• COBOL program development for the US Navy's civilian payroll system NAVCPS and maintenance of the financial management system NIFMS . Member of technical support staff, troubleshooting of production runs at six sites.