Summary:

• Accomplished 25 years experience in application development, system installation and end user support mainframe, midrange and PC platforms .
• Experience with Migration projects from Legacy systems to DB2/Adabas to Oracle.
• Analysis, design, development and unit testing of COBOL, CICS, DB2 in a mainframe environment
• Converted Cobol programs into PL/SQL
• Areas of experience include application analysis and programming pertaining to Financials, HR, ERP, MRPII, Customer Order Entry, Inventory Accounting, Bill of Materials, Shop Floor Controls, Tracking, Claims Processing Systems.
• System Refurbishment practice includes traditional re-engineering tools techniques, such as code restructuring, code splitting, and data name rationalization.
• BURROUGHS 2028/6064, UNIVAC 90/30, UNISYS 1100/2200, PDP 11/70
• Worked on Operating Systems and Services such as IBM OS/MVS, DOS/VSE, OS 390, 30XX, 370, 43XX, S/34, S/36
• Development experience with PowerCenter Informatica 8.6.1 Extracted from Flat files, Excel and SQL Server into Oracle 10g/11g.
• Industries include Financials, Automotive, General Sales, Life Insurance, Entertainment, Manufacturing and Higher Education.
• Enjoyed the challenges and rewards of working on various development projects and I have had the opportunity to be invited to return to former clients due to my skills, dedication and hard work.

Training attended:

• Cognos 8.4 Framework Manager, Report Studio, Query Studio, Analysis Studio
• Informatica and Constellar Hub
• Others: ASP, UNIX, VB6 Intro. and Advanced , Java, Javascript, Crystal Reports 8.0/8.5/9.0/XI,
• VBA for Microsoft Access programming, T-Sql, SQL Server, PHP 5/MySql, Unix and Shell Scripting.
• ORACLE: Data Modeling and Analysis, Design and Development, Data Warehousing, Oracle8 DBA, Forms / Reports 6i, Advanced Oracle Programming, Discoverer 4i, 10g, IMS/DB/DC

Technical proficiency:

Database Systems and Tools:

• Oracle RDBMS V7/8/8i/9i/10g/11g, DB2, ADABAS, Native SQL, Cincom/SUPRA, mySQL,
• T-SQL,IMS/DL1,VSAM, ACCESS, SQL Server 2000/2005, Toad, SQL Loader, SQL Plus

Programming Tools and Applications:

• PL/SQL, SQL Loader, TOAD, Oracle Discoverer 3i,4i,10g, 11g, Forms/Reports 6i/6.0/5.0/4.5/3.0,
• Crystal Reports 8.0/8.5/9.0/XI Cognos 8.6, CICS, Constellar, Hub,AppWorxs, TSO, ISPF, SPUFI
• JCL, Procs, Panvalet, FileAid, Roscoe, XPEDITER, Intertset, Librarian, Microsoft Office, Visio,
• Developer 2000, Unix, SQR, Crystal Reports v.3.1 XI, OLAP, LDAP, QMF, ABAP/4, VB,
• Adabas, Natural, COBOL, COBOL2, JCL, MF COBOL, AcuCobol, Easytrieve, DYL280 and Basic4.

Operating Systems and Services:

• Windows NT/2000/98/95/XP, HP Unix, Sun Solaris, IIS, Tomcat, Unix
• IBM OS/MVS, DOS/VSE, OS 390, 30XX, 370, 43XX, S/34, S/36
• BURROUGHS 2028/6064, UNIVAC 90/30, UNISYS 1100, PDP 11/70.

ETL's

• Informatica and Constellar.

Employment History:

Confidential

Analyst/Programmer contract

• Mainframe environment
• and JCL
• Analysis, design, development and unit testing of COBOL, CICS, DB2, VSAM, TSO/ISPF, Spufi,
• Support of Customer System
• Create/Maintain JCL
• Development experience with PowerCenter Informatica 8.6.1 Extracted from Flat files, Excel and SQL Server into Oracle 10g/11g.
• Create/Modify Adabas/Natural Programs
• Created user guides, developed reports, and tested databases.
• Created/Modified/Enhance existing Crystal Reports using Oracle 10G, SQL Server 2005/2008 and Excel .

Confidential

Oracle/Crystal Reports Developer contract

• Created Oracle PL/SQL to replace Cobol running under DB2/VSAM.
• Converted Legacy reports and Oracle Discoverer into Crystal Reports XI using Oracle.

• Development of procedures, triggers, views and packages.
• Developed customized Discoverer Reports from Oracle 11i Apps Modules: Purchasing PO , General Ledger GL , Fixed Assets FA , Accounts Payable AP , Accounts Receivable AR , Human Resources HRMS Financial, Payroll .
• Development of procedures, triggers, views and packages.

Confidential

Analyst/Programmer contract

• Created functional documentations for interfaces of Financial GL, A/P legacy systems Cobol/DB2/DLI and Access DB subsystem into Oracle 10g.

Confidential

Senior Programmer Analyst contract

• Create/Modify Natural Programs Cobol/CICS/VSAM/DB2/ADABAS . Support of the Company Vehicle System Natural/Adabas/Cobol/CICS/DB2/QMF .

Confidential

Senior Programmer Analyst contract

• Designed and developed custom reports Statistics using Crystal Reports Professional 8.5/9.0 and SQL Server 2000 using T-SQL and Stored Procedures .

Confidential

Senior Programmer Analyst contract

• Developed PL/SQL packages, Stored Procedures functions, triggers, and views for interfaces between legacy system and an Oracle MRP system using scripts to extract IMS data using MQSeries transactions and passing it to Oracle.
• Developed and documented detailed specifications for application program interfaces APIs .

Confidential

Senior Programmer Analyst contract

• Developed multiple interfaces for large Entertainment Industry client.
• Interfaces dealt with Inventory data between a hybrid Oracle order fulfillment system Oracle AR and System ESS Order Entry and legacy systems using IMS.
• Map legacy data fields to interface file fields.
• Interfaces developed with ETL tool, re: Constellar Hub
• Creation of packages, stored procedures, triggers and views.
• Used Explain Plan and Tkprof utilities were used for tuning the Queries

Confidential

Senior Programmer Analyst contract

• Developed Oracle Procedures, Functions and Triggers. Created PL/SQL packages to interface between databases.
• Created user guides, developed Forms/Reports, and tested databases.

Confidential

Senior Programmer Analyst contract

• Developed an Inventory systems using Bar Codes Access/VBA
• Created interfaces between Legacy systems Cobol/CICS/VSAM/DB2/ADABAS to HR systems PeopleSoft and into the Student/Technical/Training System. Support of the Company Vehicle System Natural/Adabas/Cobol/CICS/DB2/QMF .

Confidential

Senior Programmer Analyst contract

• Development of rule based and non-rule based API's for a client/server based ERP system running on a UNIX platform.
• Re-engineered COBOL apps to extract business rules and deploy into object oriented solutions stored procedures .

Environment:

• UNIX, HP/DEC/Sun servers, Windows95, ClearCase, DDTS, COBOLII, Oracle, SQL PLUS, PL/SQL, MF Cobol.

Confidential

Senior Programmer Analyst contract

• Support of Customer Training System, for a worldwide corporate account. Converted an Easytrieve/DB2 system to Cobol2/DB2.
• Created user guides, developed reports, and tested databases. Extracted Business Rules from Cobol programs for documentation.