US Government Mainframe Conversion
Acted as Lead Consultant for an ongoing DOE Conversion effort. Designed and wrote flexible conversion software for converting mainframe data to PC Databases. Reviewed and finalized data element migration between existing mainframe data and new Oracle database. Interfaced with various contractors. Conducted search for additional staff.
Categories: Projects Tags: Conversion, Government, metadata, Oracle, Paradox
Patient Accounting
Assisted a Buffalo, NY based hospital in the enhancement of several reports dealing with patient census and hospital billing. Provided consulting services to help standardize reports and create uniform coding criteria in preparation for conversion to an entirely new hardware and software platform.
Categories: Projects Tags: COBOL, Conversion, data mapping, DATABASE, DB2, ETL, GCOS, Honeywell, IBM, IDS, meta, metadata, Patient Accounting, Patient Census, Reports
Hospital Database Conversion
Designed and developed a series of ETL programs and accompanying JCL to convert historical and current patient records from existing Honeywell IDS database system to IBM Hospital Management System using IDMS.
The entire project took nearly a year. My role involved leading the Data Mapping efforts between all tables/fields related to Patient Census and Patient Accounting. In addition, I created or redesigned about 20 reports on the IBM side to corresponding to existing report formats on the Honeywell side.
Categories: Projects Tags: CICS, COBOL, Conversion, data mapping, DATABASE, DB2, ETL, GCOS, Honeywell, Hospital, IDMS, IDS, JCL, JCOS, metadata, MVS, Patient Accounting, Patient Census
Airport Status Map
FedEx Package Tracking
Find A Zip Code
UPS Package Tracking
US Postal Package Tracking