Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Pat Allen | Elance
 
176985602337900
Last Sign-in: Sep 1, 2014

Pat Allen

Data Architect, DBA and BI specialist
   United States
  |   Greenwood, IN
  |  6:39 am Local Time

Verified Freelancer

Pat Allen's identity has been verified.  Learn More

Overview

Over 20 years of Database design, programming and administrative experience on Oracle, SQLServer, DB2, MySQL and PostgreSQL.

Read More »
Jun 11, 2014|Data Analysis|Private|Working
Mar 16, 2014|Database Development|Private|Completed
|
5.0
Feb 13, 2014|Data Analysis|Private|Working

View All »

Portfolio

Skills (15)

Tested
Business Intelligence
SSAS/SSIS/SSRS

Service Description

Database Management/Design: Oracle 9i, 10g, 11g, Oracle RAC, Oracle Business Intelligence EE, Oracle RMAN and Active Data Guard, SQLServer 2012, MySQL, PostgreSQL, IBM DB2, Star Schema Design (Kimball Dimensional Modeling), NoSQL- CouchDB

Operating Systems: Linux (RHEL, Debian, Fedora, SUSE), AIX, Solaris, HP-UX, z/OS, VMware, MS Windows and Windows Server, NAS systems from IBM and EMC
Systems Engineering: Systems Life Cycle , UML Modeling, ERwin, Visio, Wireframe, Storyboarding, Work Flow Design, Server Virtualization
Programming: C++, J2EE, Cold Fusion, VB, PHP, COBOL, shell scripting(Perl, KSH, CSH, SH)

Tools, ETL and Reporting: SQL*Plus, PL/SQL, Informatica, Pentaho Spoon, Pentaho Report designer, IBM MQ and TXSeries, JasperReports, Microsoft's (SSIS, SSAS, SSRS, PowerPivot, T-SQL)

Internet Technologies: HTML5, Javascript, AJAX, CSS , jQuery, IBM’s WebSphere and IBM’s WebSphere Portal, Liferay Portal, Apache HTTP, Apache Tomcat, MS Sharepoint

Enterprise Architecture: The Zachman Framework

Read More »

Education

Purdue University
Bachelor of Science
-
Overview  |  Job History  |  Portfolio  |  Resume/C.V.

Keywords

database
sql
BI
architect
LAMP
oracle
ETL
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
Private
Private
Total
Per Client
Identity
Username
patallen
Type
Individual
Member Since
February 2014
Elance URL
Verifications
0
Pat Allen | Elance

Pat Allen