Matthew J. Belo

Senior Database Engineer/Architect

***** ** ***** *****

Covington, Washington 98042-8700

253-***-****

Email: abltla@r.postjobfree.com

Summary of Qualifications

Over thirty years of Database and Software Development experience utilizing

various database platforms including Oracle and Microsoft SQL Server.

Fifteen years in project leadership roles with the last ten years focusing

on database engineering and analytics. Expertise includes database

development/design, data warehousing, data modeling and database

administration. Analytical problem solver with a logical approach and the

ability to see the big picture in developing solutions.

Database Skills

Oracle RAC 11g, 10g, 9i, 8i, 7

Microsoft SQL Server 2008, 2005, 2000, 7.0

. Database object development (stored procedure, trigger, materialized

views, etc) in T-SQL and PL/SQL

. Database planning, documentation, design and creation (OLTP, OLAP and

Data Mart)

. ETL design and development (using DTS, SSIS and Oracle Data

Integrator)

. Report development (both scheduled and ad-hoc) for business

intelligence utilizing complex queries (primarily using SSRS).

. Development and production application upgrades

. Data modeling, mapping and migration

. Database security and administration

. Replication configuration and maintenance (Transactional and Merge)

. Performance monitoring and tuning

. Research and resolution of Client/Server interface issues

. Legacy application data mining

. Administration planning (hardware, backup, archive, disaster recovery)

Other Skills

. Project & Team Leadership

. Middle-Tier System Design

. Data Analysis & Problem Solving

. Process Development

. Software and Database Design, with emphasis on internal business

tools.

. Data Warehousing

. Data Modeling

. Familiarity with a number of database products, software languages,

hardware configurations and applications.

Education

. Bachelor of Science - Computer Science (Magna Cum Laude)

University of Southern California - May 1983

Work Experience

Blue Nile Seattle, WA April 2009 - August 2010

Sr. Data Warehouse Analyst (Contract-to-Hire through The Triad Group)

. Design, Development and Optimization of Database Component in Oracle.

. Model existing architecture and assist establishment of enterprise

standards and processes.

. Analyze raw data and create Business Intelligence systems in the

warehouse for culling trends and projections.

. Work with business owners to create requirements for database and

reporting needs.

. Complete the database design/implementation and ETL processing for

requirements.

. Develop reports using SQL Server Reporting Services 2005.

. Provide both database development and administration assistance

Harland Financial Solutions Bothell, WA September 2007 - January 2009

Database Architect

. Design, Development and Optimization of Database Components in

Microsoft SQL Server 2005 & 2000

. Build architecture and implement archive and reporting databases and

processes (DTS, SSIS) to populate

. Develop roadmaps for evolution of products to SQL Server 2008

. Develop reports using Actuate and Crystal Reports and created roadmap

for migration to SSRS

. Provide both database development and administration assistance to

customers through support calls

. Design common database for the various application products to share

. Maintain and enhance C#/.Net utilities that are database-centric

. Produce and Maintain Data Models and other database artifacts for the

various products

Microsoft Corporation Issaquah, WA September 2006 - September 2007

Database Engineer (Contract through Excell Data Corporation)

. Redesign and Implement Partner Management Center (PMC) in Microsoft

SQL Server 2005

. Provide best practice analysis and performance optimization of product

. Design, develop and implement numerous database components (stored

procedures, view, schema collections, etc.)

. Create data replication functions in SSIS

. Create Service Broker components to enhance throughput of system

. Create, Update and Maintain database document artifacts (HLD, DLD and

LLD)

. Use VSTS DB Pro and code reviews to facilitate the development process

. Successfully implemented change-over of PMC system on schedule with

minimal issues.

Recreational Equipment, Inc. Kent, WA February 1999 - September 2006

Senior Database Engineer

. Administrate and maintain on a 24/7 basis numerous databases: 36

instances of Oracle RAC 10g, 140 instances of SQL Server 2000 and four

instances of IBM UDB 8.

. Immediately resolve database issues for online store to maintain

availability for $3M/day enterprise

. Design and develop database components to support application

development teams (PL/SQL, T-SQL and SQL PL)

. Design and implement database and ETL processing for online data

warehouse (Oracle), retail store data warehouse (SQL Server) and

corporate data warehouse (UDB).

. Design, document and implement data marts to support business

analytics team requirements

. Develop and maintain data models using ER/Studio for all database

implementations

. Develop process for transitioning development components (both

database and application) through Test/QA/Production lifecycle to

improve success of go-live.

Senior Software Engineer

. Develop software components for the Online Store using Java and Perl

for IBM WebSphere

. Develop processes to keep store inventories on the storefront in

synchronization with AS/400

. Develop data security and encryption classes for product.

. Develop low-level database interface components to optimally

communicate with Oracle database

Prior Employment

Metapath Software International Bellevue, WA March 1998 -

February 1999

BEST Consulting Kirkland, WA August 1995 - November 1998

Innovative System Applications Bellevue, WA February 1993 - August

1995

Boeing Computer Services Bellevue, WA June 1988 - September 1992

ESCA Corporation Bellevue, WA March 1987 - June 1988

Hughes Aircraft Company Fullerton, CA February 1982 - March 1987

City of Los Angeles Los Angeles, CA June 1980 - February 1982

University of Southern California Los Angeles, CA June 1980 -

February 1982

Contact this candidate