Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Andrew P. | Elance
 
176985602337900
Last Sign-in: May 18, 2015

Andrew P.

BI Data warehouse SQL Server architect developer
   United States
  |   Newburyport, MA

Overview

For the last twenty some years Iíve been focused on solving complex business problems using a combination of data and database technology to build out data warehouses, business intelligence platforms and specialized business process transaction systems. Occasionally, Iíve been requested to stabilize and optimize several internet video and radio content platforms or pull a database project back on budget. And of course, Iíve designed and built numerous traditional data warehouses, MDM solutions, data marts and a few transactional systems. All...

Read More »

Skills (10)

Tested

Service Description

Past Completed Major Projects:

For a mid-sized pet food manufacturing company - 2011-2013
- BI: designed and implemented unified data warehouse, conformed dimensions, the associated data marts and required ETL. Created supporting multi-dimensional (cube) reporting environments for marketing analysis, POS analysis, sales operations and financial analytics.
(SQL Server 2012, 2008, 2008R2, SSAS, MDX, SSIS, SSRS, Tableau, Qlikview)
- BI tool usage evaluation: Microstrategy, Tableau, devExpress, Qlikview, Hadoop, Cassandra.

For Thomson-Reuters - a global leader in business and financial information, 2010-2011
- BI: designed and implemented the customer and account mapping and assignment logic for the ĎTo Beí analytics platform for the business development organization. (SQL Server 2008, SSIS)

For a mid-sized global supply chain and recycling management company, 2009-2010
- Web based platform for BI and life-cycle management: designed and implemented database architecture, data modeling (Erwin) development and ETL (SQL Server 2005/2008, SSIS, SAP).

For Yahoo! (one of the internetís largest destinations for content and video), 2008-2009
- designed and built BI & reporting system, providing visibility into user video activity, Web Trends daily activity and server utilization activity. (SSIS, SSAS, MDX, SSRS, ERwin).
- Evaluated usage of Yahooís Hadoop infrastructure for video activity analysis
- optimized the video platform databases supporting a three-fold increase...

Read More »
Overview  |  Job History  |  Resume/C.V.

Keywords

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
anpeterson
Type
Individual
Member Since
August 2014
Elance URL
Verifications
0
Andrew P. | Elance

Andrew P.