Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Miguel R. | Elance
 
176985602337900
Last Sign-in: Mar 12, 2012

Miguel R.

Database Developer / Analyst
   United States
Frisco

Overview

Database developer with more than 23 years of IT experience. Experience includes OLTP/OLAP reporting technologies, data warehousing development, analysis, coding/testing, applications development (SDLC), software reverse engineering, and maintenance of business systems in LINUX, UNIX, and WINDOWS platforms. I have developed an exceptional aptitude towards translating user requirements via UML case diagrams into logical processes, test scenarios, risk mitigation procedures, and deployment strategies. I work closely with developers,...

Read More »

Skills (4)

Tested
MS SQL Server 2000 Test
My Score
avg
Passed
Data Warehousing Test
My Score
avg
Passed

Service Description

I am a Senior Application Programmer/Analyst with extensive experience in data modeling (3rd Normal and Fact/Dimensional), tuning (database and application), and reporting to/from Fox Pro (version 5.0 thru 9.0), Clipper (Summer '87, 5.x, and Visual-Objects), Oracle (8i, 9i, and 10g), and & MS SQL Server Database Management Systems (version 2000 thru 2008).

I've created customized Fox Pro and Clipper applications for various clients since 1990. For example, I've delivered and still remotely maintain an ERP (e.g., invoicing, GL Accounting, A/P, etc.) application written entirely in Clipper (Summer '87) for a retail client named Water-Rite Products, which is located in California.

According to that client, the functionality contained in those
customized applications exceeds most provided by off-the-shelve products offered by Quicken, Sage Mas 500, MicroSoft Dynamics, etc. Due to the comprehensive gathering of his requirements, development of sound logical & technical specifications, and adherence to high-quality coding standards %u2013 Water-Rite products became a happy Clipper/FoxPro client for life....

Another example involves BlockBuster where I was tasked with tuning PL/SQL (Stored Procedural) code contained within Oracle database triggers and application modules of database applications (e.g., iFinancials, iProcurement, etc.) containing financial information. I wrote T/SQL and Procedural modules which: a) loaded 3rd Normal Form OLTP data from a...

Read More »

Education

University of Texas, Dallas
Dual MBA -- Finance and MIS (Management of Information Systems)
2001 - 2003
California State University, Sacramento
Bachelor of Science in Business Administration
1996 - 2000
Overview  |  Job History  |  Resume/C.V.

Keywords

Cognos
Oracle
SQL
Analysis
Design
My Snapshot
All Categories
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
Church-ERP
Type
Individual
Member Since
July 2009
Elance URL
Verifications
0
Miguel R. | Elance

Miguel R.