Oracle Certified Professional PL/SQL Developer with four credentials and 20+ years' experience building database applications, including:
Read More »
- Advanced Oracle SQL & PL/SQL
- Complete life-cycle data warehouse development
- E-R & dimensional modeling
- ETL & metadata application development
- SQL and system performance tuning
- Data integration
I have developed many database applications over my 20 years as a developer. My advanced expertise is in Oracle PL/SQL and SQL, versions 8.0 through 11.2. I have also developed applications in SQL Server, Sybase, PostgreSQL and Informix. I adhere to best practices and deliver programs that are optimized for fast execution and robust exception handling.
I am also an expert data modeler and can conduct the necessary modeling or develop from an existing data model. I prefer ERwin and have experience with ERwin 4.x through 9.01, but also have extensive experience with E/R Studio, PowerDesigner, Oracle SQL Developer Data Modeler, and open source modelers such as SQL Architect.
An accurate data model is absolutely essential to a properly-functioning application. If best practices are not followed, the client will pay for it for years to come. I leave nothing to chance, but track down the user or SME (subject matter expert) who has the knowledge that needs to be reflected in the data model. I won't accept a project without assurance that the SMEs will be available for both formal data modeling sessions and quick email questions.
I document all of my code as I go, for the sake of the client, future developers, and for myself when I have to modify it later on. An example of this is, on December 31st, 1999, I received a call from a frantic former client regarding a program I wrote for them in 1995. They were still using it daily, but needed to have it updated for Y2K. I had...
Read More »
Sr Data Warehouse Modeler
2011 - Present
ERwin, Dimensional modeling, Oracle SQL