Performance Exception Reporting
An add-on enhancement developed for a major power company that helps management track deviations from standard operating parameters. This system collects information on-line and reports those points outside user set criteria. It was developed in response to EPA pollution requirements.
Automated Data Distribution
This is another enhancement developed for a major power producer to gather certain information and automatically distribute it to various programs for statistical analysis and subsequent graphing. These reports are given to top management and the EPA. This system, which I suggested, will save the company approximately five man weeks each year.
Data Acquisition System
A real-time data collection system developed for a local power company. This system allows users to select from several thousand possible points to track. The system will extract either current or historical values and allow them to be imported into a spreadsheet package for further analysis and graphing.
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





FedEx Package Tracking
Find A Zip Code
UPS Package Tracking
US Postal Package Tracking