After 38 years in Information Technology in private and public sector. 15 years with last NYS agency

DBA in the Data Administration, Technical Services Unit. Supports the Enterprise Information Management, Business Intelligence and Data Warehouse ETL groups. Participates in NYWIC development project using Informatica Power Designer 10.1.1. Administration, support, and troubleshooting for multiple Oracle databases: creation of schemas, database links, tablespaces, tables, indexes (B-tree, "function-based", and bitmap), packages, procedures, functions, triggers, sequences, system and object-level grants. Applies DA standards to data security and enforces HIPAA PHI access standards.

DBA in the Data Administration, Technical Services Unit. Supports the Enterprise Information Management, Business Intelligence and Data Warehouse ETL group. Administration, support, and troubleshooting for multiple Oracle databases: creation of schemas, database links, tablespaces, tables, indexes (B-tree, "function-based", and bitmap), packages, procedures, functions, triggers, sequences, system and object-level grants.Applies DA standards to data security and enforces HIPAA PHI access standards.

Designed and created all ETL processes to copy various IDMS COBOL legacy systems to Oracle Data Warehouse Data Marts utilizing IDMS (ADS/O), COBOL, PL/SQL, UNIX Korn Shell Scripting, Informatica Power Center 7.1.3 , Oracle 9i, Embarcadero ERStudio Data Architect 8.0, TOAD, MS VISIO 2007 and Crystal Reports 10.Extracted data for: Human Resources Management (CHRM) and Inpatient/Outpatient Medicaid Billing (UBS/COBS), Occupational Injury (OIRS), FINTRANS, Medication Grant Program (MGP), Payroll and other IDMS COBOL legacy systems, to flat files using IDMS COBOL and IBM JCL. Transformed data using COBOL, FTP, and Unix Korn shell scripts. Loaded flat files to Oracle Data Warehouse Data Marts using Informatica and TOAD running under Oracle 9i SQL. Extracted data from eMedNY Data Warehouse using PL/SQL, Transformed Claim/Service/Payment data using SAS, and Loaded to Oracle SNP Data Mart using Informatica. Created Data Model for CHRM, MGP, Medicaid Billing, OIRS and Special Needs People (SNP) utilizing Embarcadero ERStudio Data Architect 8.0. Documented Work Flow of ETL data loads for OMH Payroll, CHRM, COBS/UBS, SNP, OIRS, MGP and Medi-Span (Drug Code file from vendor) using MS VISIO 2007.

Requirements development via analysis of legacy applications written in COBOL. Developed, tested, and executed database migration routines using COBOL, IBM JCL, PL/SQL, Unix korn Shell scripts and Informatica PowerCenter 7.1.3.

Performed maintained and enhanced to the Management and Administrative Reporting Subsystem (M.A.R.S.). Modified programs and control tables to properly fund and report claims received for the Family Health Plus and Child Health Plus programs. Utilized COBOL, ROSCOE and EasyTrieve Plus.

Assigned to Fleet Bank's Securitization / Summit Conversion Project. Developed reports to support the Securitization Payments and Draws feature of Automated Loan Collection Systems (ALCS). Utilized COBOL, VCM, and EasyTrieve Plus.

Created batch and online interface programs to support the effort to transfer Commercial Loan processing for International Loans to an outside vendor. Generated production JCL for Key Bank conversion and for all converted banking institutions.

Worked on the State Comptroller - Employee Retirement System.Performed maintenance and enhancements to E.R.S. Developed a DB2 (SQL) and VSAM system with the agency.

Implemented Year 2000 solution for FoxPro release 2.6 Application. Converted FoxPro 2.6 (Workers Advocate Application) to Visual FoxPro. Developed customer acceptance testing plans and documented same to support implementation project. Created and utilized Microsoft Excel spreadsheets for ad hoc reporting purposes pertinent to the Worker's Advocacy System

Performed maintenance and enhancements to the T.I.D. (Taxpayer Indicative Data) system. Performed requirements gathering, application design, coding, testing and documentation. The system was an IDMS database of Non-financial taxpayer information. Participated in the effort to convert the T.I.D. system from IDMS ASD/O to CICS and DB2 (SQL). Interacted with the processing of New York State Unemployment Insurance Tax files and records.

Performed maintenance and enhancements to CPS; a Consolidated purchasing System. Worked on CPS which supported planning and record keeping procurement activities. Used IDMS and ADS/O, COBOL Batch-IDMS

Updated vendor (SSI) software for PEP+ (Paperless Entry Check Processing). Supported branch divesture project of the FLEET/Shawmut bank merger. Utilized COBOL, CICS, and Easytrieve Plus.

Performed maintenance and enhancements to registration software for American Management Association. Used IDMS and ADS/O

Performed retro fit of user modifications to vendor software (CAS Inventory System, release 2.2) at Hughes Training (CAE Link) manufacturer of training software and equipment for U.S. Government defense systems. Used IDMS and ADS/O

Performed user modifications to DDA software including check processing. Used IMS DB/DC, CICS and Easytrieve plus.

Assisted with the implementation of maintenance and enhancements to the HealthNet (HealthEase) system. HealthEase was comprehensive IBM mainframe software for the administration of a Health Maintenance Organization. Wrote the system in COBOL using IMS DL/I software running under CICS on an IBM 3090.Designed, maintained, coded and tested COBOL (IMS DB/DC) and EASYTRIEVE PLUS programs to support the HealthNet and HealthEase claims user area.

Assisted programmers responsible for the design, coding and testing of reports to supports the patient management system. Performed code reviews of COBOL-IDMS and EASYTRIEVE Plus report programs; creating status reports for the Project director; participating in the program effort.Provided technical support to programmers responsible for the program coding and unit testing of ADS/O dialogs. Designed, coded, tested and implemented the on-line report generation for POMS IDMS system using Easytrieve plus. Implemented the system in IDMS, ADS/O, COBOL and EASYTRIEVE Plus on an IBM 3090/200.

Worked as member of project team responsible for the analysis, design, coding and unit testing of the Off List pricing system. Developed the system in ADS/O using IDD, OLM, ADSG, ADSA, DML/O and EASYTRIEVE Plus.

Worked as member of project team responsible for the implementation of HOGAN DDA software. Converted affiliate banks from DOS to HOGAN DDA software coding and testing programs to interface with the HOGAN DDA software. Developed Vendor Check using HOGAN Check Processing system. Developed the system using HOGAN software that executed under CICS. Used COBOL, IDCAMS, LIBRAROAM. ICC711 extensively in testing.

Performed the installation and maintenance of MSA's inventory and purchasing software for a commercial bank. Modified the software to site specifications using IBM utilities and performing unit and system testing. Implemented the system in COBOL using PANVALET and IDCAM on an IBM 3083 under OS-370. Installed and maintained MSA Payroll software.Modified the software to site specifications using IBM utilities and developing report procedures using RAMIS II. Used UCC7 and UCC11 (CA7 and CA11) to system test all programs prior to Production turnover. Performed Unitech audit Control Reporting. Implemented the system in COBOL. Wrote interface and report programs in PL/I and RAMIS II for IBM 3083 under OS-370.Modified vendor's JCL to client standard for batch processing of investor and payroll systems.

Executed programming, unit testing, and maintenance of the Product and Purchasing Information System (PPIS). Designed system to perform Parts Inventory Control and Cost Analysis.Converted sequential files to HISAM and performed COBOL (IMS and non-IMS) program maintenance. Implemented the system in IMS-COBOL using MFS, BTS and PANVALET on an IBM 3081 under os-370. Modified all JCL within existing inventory system.

Completed programming, testing, and maintenance of the Cost Accounting System.Charged with designing, coding, and testing file maintenance and report programs. Developed the system using COBOL and command level CICS.Processed New York State Unemployment Insurance Tax files and records.