Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Michael M. | Elance
 
176985602337900
Last Sign-in: Apr 9, 2013

Michael M.

Expert Data Modeler & Oracle PL/SQL Developer
   United States
  |   Layton, UT
  |  3:33 pm Local Time

Verified Freelancer

Michael M.'s identity has been verified.  Learn More

Overview

Minimum Hourly Rate $75

Oracle Certified Professional PL/SQL Developer with four credentials and 20+ years' experience building database applications, including:

- 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
- Mentoring

Read More »

Portfolio

Skills (8)

Tested
Data Modeling
Oracle 11g PL/SQL
Data Warehousing
ERwin
Oracle Administration
Oracle 11g
E/R Studio
Healthcare IT

Service Description

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 »

Employment

Hewlett-Packard Corp
Sr Data Warehouse Modeler
2011 - Present
ERwin, Dimensional modeling, Oracle SQL

Education

State University of New York College at Buffalo
Bachelor Degree, Biology
-

Keywords

PL/SQL
SQL
PLSQL
data model
dimensional
Oracle
data warehouse
star-schema
ERwin
TOAD
metadata
DBA
OCP
OLTP
OLAP
My Snapshot
IT & Programming
1
Elance Level
Level represents activity and experience on Elance. Freelancers start at Level 1 and achieve higher levels through their work. A higher "Level" indicates greater earnings, ratings and other achievements on Elance. Learn More »
  • 12 months
  • Lifetime
Jobs
0
0
0
Total
Milestones
Hours
Reviews
Recommend
Clients
Total
Repeat
Earnings
Total
Per Client
Identity
Username
ocpdeveloper
Type
Individual
Member Since
August 2012
Elance URL
Verifications
0
Groups
Michael M. | Elance

Michael M.