Employment History

SUMMARY

• IT Professional offering over 20 years of experience in programming, system design and analysis.
• Successfully extracted data from Natural/Adabas to a Java mainframe utilizing EntireX broker in government projects with State of New Jersey (OIT).
• Employing excellent communication and organizational skills, effectively coordinated with project team to completely convert existing mainframe system of Johnson & Johnson from Adabas/Natural to client server using Oracle 8i.
• Highly-proficient in programming in Natural, Adabas, PL/SQL and Cobol to maintain existing systems such as Financial systems, Pensions and Benefits system, State Health Benefits System, Accounts Payable system, and Infrastructure systems using MQ Series and Construct.
• Possesses an advantage of having profound knowledge and experience with SAG products which includes: Natural, Adabas, Construct, Predict, and EntireX Broker.

TECHNICAL SKILLS

Adabas, Natural, Construct, Entire X Broker, DB2, Predict, TSO, Cobol, Unix, Oracle, PL/SQL, SQL Loader, SAS, CA-Top Secret, PVCS (Merant), MQ Series, Ondemand, Shadow Direct, RapidSQL and DBArtisan

PROFESSIONAL EXPERIENCE

July 2011 – June 2012
Confidential, Trenton, NJ
Senior Systems Consultant

• Extracted data from Adabas to a Java mainframe using EntireX broker.
• Programmed in Natural to generate EntireX wrapper modules for online Java applications and to maintain existing Pensions and Benefits system.
• Maintained existing Retired Payroll system programming using COBOL.
• Programmed in Natural using Construct to maintain existing Accounts Payable system.
• Created and maintained JCL for execution of Natural and Cobol programs and procedures.
• Created and maintained JCL for backup and restore of production job streams.
• Created and maintained JCL for FTP procedures.

July 2010 – July 2011 
Confidential, Princeton, NJ 
Senior Principal Consultant (for Morgan Stanley)

• Programmed in Adabas/Natural 4.2 and COBOL to maintain existing Infrastructure systems used for production job submissions and control.
• Programmed in Natural accessing Sybase, DB2 infrastructure databases.
• Programmed in Natural for MQ Series processing.
• Provided user support in setting up production schedule runs using CA7 for mission critical systems run in multiple regions.
• Supported the handover of project implementations into the production environment.
• Created and maintained JCL for execution of Natural and Cobol programs and procedures.
• Created and maintained JCL for backup and restore of production job streams.
• Provided production system support (after hours and weekends).
• Created and maintained JCL for FTP procedures.

April 2009 – June 2010 
Confidential, Trenton, NJ 
Senior Systems Consultant

• Programmed in Natural to generate EntireX wrapper modules for online Java applications.
• Programmed in Natural and Cobol to maintain existing Pension and Benefits
• Programmed in Natural to develop new Health Insurance Claims system
• Programmed in Natural using Construct to maintain existing Accounts Payable system.
• Created and maintained JCL for execution of Natural and Cobol programs and procedures.
• Created and maintained JCL for backup and restore of production job streams.

September 2006 – March 2009 
Confidential. Princeton, NJ 
Senior Principal Consultant (for Morgan Stanley)

• Programmed in Natural and COBOL to maintain existing financial systems using MQ Series.
• Programmed in Natural accessing Sybase, DB2 and Adabas for Product pricing system
• Converted Perl scripts into Natural programs to run on Mainframe.
• Accomplished system documentation.
• Created and maintained JCL for execution of Natural and Cobol programs and procedures.
• Created and maintained JCL for backup and restore of production job streams
• Provided production system support (after hours and weekends).
• Created and maintained JCL for FTP procedures.

May 2005 – August 2006 
Confidential, Trenton, NJ 
Senior Systems Analyst

• Programmed in Natural to generate EntireX wrapper modules for online Java applications.
• Programmed in Natural and Cobol to maintain existing Pension and Benefits systems.
• Created and maintained JCL for FTP procedures
• Created and maintained JCL for execution of Natural programs and procedures also for backup and restore of Natural program libraries.

August 2003 – April 2005 
Confidential, Edison, NJ 
Senior Systems Analyst

• PL/SQL programming using Oracle 9i. Created data flow models using Visio.
• Created entity model diagrams using Erwin and prototype system using TenFold Technology.
• Designed logical and physical data base for Oracle 9i. Created RFP for State Contracts bid process.
• Loaded Oracle 9i tables with data from spread sheets.

November 1998 – July 2003 
Confidential, New Brunswick, NJ 
Senior Software Consultant

• Programmed in SAS to extract data from Adabas for auto-generated correspondences.
• Programmed in Natural using embedded SQL to access DB2 tables.
• Converted existing mainframe system from Adabas/Natural to client server using Oracle 8i. Administered Mainframe Security using CA-Top Secret.
• Created and maintained JCL for execution of Natural programs and procedures. Created and maintained JCL for backup and restore of Natural program libraries.
• Created and maintained JCL for Natural/DB2 plans used by Natural programs. Performed Natural/DB2 plan binding function using created JCL. Created Natural programs to extract data from Adabas into Excel spreadsheets for loading into Access data base.
• Loaded Oracle tables using Access tables with SQL Loader. PL/SQL programming using Oracle 8i. Created triggers and scripts for Oracle conversion.
• Project management of conversion process and data load. Conducted meetings on Data standardization with Users and the vendor. Created customization procedures and functions for the vendor.

January 1994 – October 1998 
Confidential, West Point, PA 
Senior Software Consultant

• Programmed with Natural using embedded SQL to access DB2 tables. Programmed with Natural for batch processes.
• Programmed with Cobol for batch processes using DB2.
• Performed Natural program maintenance between libraries using Predict.
• Performed file maintenance of Adabas data dictionary using Predict.
• Created and maintained local and global data areas used by Natural programs. Generated Data Dictionary modules used by Natural programs.
• Performed system testing of Adabas/Natural software upgrades. Re-cataloged Natural programs libraries to activate upgrade or changes.
• Created and maintained Adabas test environment for quality control using production data. Created and maintained JCL for execution of Natural programs.
• Created and maintained JCL for backup and restore of Natural program libraries. Created and maintained JCL for Natural/DB2 plans used by Natural programs.
• Provided temporary Adabas DBA function. Provided Natural programming support for client’s programmers.
• Conducted QA testing for system implementation.
• Designed and developed program and report specifications. Created user testing and implementation procedures. Created system, program documentation for operations department
• Created project plans, testing and implementation schedules. Project coordination from start to implementation.
• Attended Project planning and monitoring meetings.

EDUCATION

• Associates Degree of Commerce, Major in Information Systems and Accounting, Confidential University
• Diploma in EDP and Systems Analysis, Major in Systems Analysis and Design, Data Structures, Confidential College