McLaren HealthCare
Property Management System

 

 


 

About:  


I was brought into McLaren HealthCare in a similar fashion as Cedars-Sinai, only I was committed to creating a prototype only during a 2 week period. The application they chose was the Property Management System. I was a little surprised it wasn't directly related to healthcare, but it was important to them none the less.

There were a lot of similarities to the project I did with Cedars-Sinai since it was a small database (MS Access) that they wanted to convert to Oracle and make it web enabled. I was also encouraged to use the Oracle development tools, so I ended up writing about the half of the PL/SQL code by hand and using Designer to generate the other half as well. Also, instead of storing X-Rays as BLOBs in the database, they wanted to store images of the properties, as well as floor plans.

Highlights:


- Designed the new database
- Created routines to scrub and migrate the data
- Web enabled the application using the Oracle Web Application Server and PL/SQL Web Extensions
- Created half of the application writing PL/SQL by hand
- Created half of the application using Oracle Designer 2000
- Integrated various reports using the Oracle Reports server
- Stored images and floor plans of the properties as in-line BLOBs