SkillsSkills
At Eclipsys
Eclipsys is a developer of database products for the healthcare industry. Most of its clients are hospitals with 200
The heart of the EDW product is the relational mapper/loader. I maintain and enhance this program. It is written in C. It uses the Oracle Call Interface and the ODBC API. Most of the work is done on Unix but a lot of the work is being moved to NT (Visual C++). I was responsible for proposing and then moving the code to NT. This work also requires knowledge of SQL including the differences between Oracle, Sybase and SQL Server. One of my direct reports has taken up most of the porting work for Sybase and SQL Server. I am responsible for getting the code into our code control system (CCC/Harvest) and for maintaining the "make" files so that the product can be built by our configuration department.
I am also the sole programmer for the PowerBuilder application which is used to create and maintain the meta data for the data warehouse. I was involved in porting the application to PB version 4, then version 5 and new version 6.5. This application runs on 32-bit Windows. This application also requires SQL knowledge. I have added quite a lot of features to this application.
I wrote some C code that was used as a command-line parser. I also wrote some C++ code that did a post installation cleanup for one of our programs. Both of these programs were developed using Visual C++.
I researched query tools and then chose Brio to be our vehicle for developing reports. I was the sole developer on the first phase of this product and continue to lead this effort. I have two direct reports who are also developing reports. Before they are released I will make sure that they work in a consistent manner.
I am a member of a team that is working on consolidating the efforts of the current company and a recent acquisition. Previously I was on a committee looking into the Business Process Reengineering as it applied to our configuration department. I was also on the Tools committee until it was disbanded. Keeping up to the date on the latest tools continues to be an interest of mine.
I have given two talks to our User's Group. I have been on 3 site visits to our customers.
Previously we had an Oracle DBA working on site but it is difficult for a development shop to keep a DBA (in the strictest sense of "administrator") busy. So when the Oracle DBA left, I became the de facto DBA along with my other duties. This also included being the SQL Server DBA when we started working on that database engine. In that case, I developed the hardware configuration requirements, installed all of the software and performed the other tasks usually left to the DBA.