Database, Data Warehousing (ETL, OLAP, BI) & Data Architect

Database, Data Warehousing (ETL, OLAP, BI) & Data Architect

Kurt Schmidt

eMail: (anti-spam guarded) dbsyseng.PostJobFree*please.remove.anti.spam.guard.between.asterisks.only*@xemaps.com

Mailing address: please see PostJobFree.com

Phone: please see PostJobFree.com

QUALIFICATIONS

* Database systems architect, designer and engineer with over 14 years of database development and engineering experience.

* Oracle - PL/SQL, SQL*Plus, SQL experience.

* Microsoft SQL Server - T-SQL, SQL experience.

* DTS (SSIS) 2000 experience, SSIS 2008 training.

* SQL Server SSIS, SSAS, SSRS experience.

* ETL expertise in designing and implementing logical and physical database structures, processes and systems, including VLS data warehouses and high efficiency ETL/METaL.

* Extensive experience as a Data Modeler, Data Architect, Database Engineer and Manager at large, medium and smaller corporations supporting numerous projects tracking multiple data points across multiple projects in a variety of industries.

* Experience in JAD session, user requirements and data warehousing

* Published peer reviewed research in database uses, presented at international conferences by invitation.

* Strong analytical skills with the ability to communicate well in both writing and verbally.

* Bachelor of Science Degrees in Computer Science and Biology.

SELECTED ACCOMPLISHMENTS

* Designed and documented database systems using IDEF1X, ERwin, JAD and SDLC.

* Engineered high performance database systems, including high frequency incrementally refreshed (ETL and METaL) data warehouses and datamarts.

* Created data models, including logical and physical schemas, for data warehousing (DW) database systems with multiple ETL sources with >250 source tables.

* Served as a liaison to vendors, researched alternate technical solutions and communicated them in briefings for academic researchers, management, business staff and developers.

* Lead and mentored development staff in finding creative, long-term solutions.

* Employee Excellence Award for work on core corporate database systems.

* Received Domestic and International patent for architecture of a distributed, adaptable cardiology information system using commercial DBMS (American Home Products).

COMPETENCIES

* SQL Server (2005 - 4.x), Oracle (10g - 9i)

* T-SQL , SQL, PL/SQL, SQL*Plus, Windows Shell Script

* TOAD, CVS, PVCS, MS VSS, ERwin (4.x, 3.x), Rational Rose

* Unix, Ultrix, Linux, Win XP Pro, NT (4.x, 3.x), Solaris

EMPLOYMENT HISTORY

SR. PROJECT CONSULTING DATABASE ENGINEER

Wincito Solutions LLC

Bellevue, WA

03/2008 - 10/2008

* Analyzed existing multiple applications and existing business practices and needs for estimation and capture of actual profits of customer's Internet advertising business.

* Designed a unified ETL process and database system to incrementally refresh warehoused data as well as store business rules and collateral information.

* Designed and implemented database structures and scripts (over two thousand code lines) enforcing complex business rules based on data entries in the database.

* Mentored development and QA/QC staff in database systems development.

* Environment: SQL Server 2005, Windows XP, Windows Server 2005.

SR. DATABASE ENGINEER AND DEVELOPER

T-Mobile USA

Bellevue, WA

02/2005 - 04/2007

* Utilized OOA and OOD to design Oracle modules and applications for management of customer mobile phones data services usage and design of data warehouse ETL.

* Implemented OO designs translating the OO logicals into relational implementation.

* Produced review, acceptance and maintenance documentation for the modules.

* Created scripts and frameworks and implemented insertion of these modules into a live nationwide phone network system.

* Mentored development and QA/QC staff in database systems and their development.

* Championed team-wide versioned code storage methodology and practices.

* Environment: Oracle 10g and 9i, UNIX, Windows XP, ERwin, TOAD, CVS.

SR. DATABASE SYSTEMS ARCHITECT AND DEVELOPER,

Microsoft and other contracts

Bellevue and Redmond, WA

03/2001 - 02/2005

* Designed architecture and using full SLCD implemented a flexible, metadata driven METaL process for multiple high demand three-tier datamarts, improving performance by 95% (from 36+ hours to less than 2 and a half hours).

* Maintained a multi-tier data warehouse (data size: >700 GB).

* Captured, analyzed and validated system requirements and functional specifications, designed and implemented technical specifications and validated code for databases.

* Analyzed performance bottlenecks and performed successful Performance Tuning and Optimization of OLTP and Data Warehousing database systems, including ETL processes.

* Environment: IDEF1X, SQL Server, ERwin 4.x, Source Depot, E.piphany Analytics, IDEF1X, Erwin 4.x, Analysis Services (OLAP), MDX, OOA, OOD, JAD.

DATABASE ENGINEER

Onyx Software (SolutionsIQ)

Bellevue, WA

09/1999 - 10/2000

* Analyzed and validated system and database requirements, software processes, algorithms and legacy code for changes, inclusion or replacement with new code.

* Utilizing OOA and OOD designed database components integrating SQL Server processing with multi-tiered Web based applications and redistributing system layers for greater efficiency.

* Translated OO designs into detailed relational and physical database designs.

* Implemented SQL queries and stored procedures and validated code against designs.

* Optimized existing stored procedures, system processing and indexes.

* Developed support software and SQL Server utilities for automated code analysis.

* Environment: IDEF1X, SQL Server 2000 & 7.0, ERwin, VBA, VSS, Windows Script Shell, OOA, OOD.

SR. SQL DATABASE DEVELOPER

Nth Dimension

Bothell, WA

Attachmate (temp. staff)

Bellevue, WA

Microsoft Corporation

Redmond, WA

07/1998 - 09/1999

* Analyzed performance tuned and optimized queries, databases and servers.

* Captured user requirements from users, reverse engineered and documented database systems

* Analyzed data management and database needs and created long range plans for database requirements of a rapidly growing e-commerce dot-com company.

* Validated requirements and verified code of a stochastic financial system.

* Created architecture for database backend solutions for high demand e-commerce, created and revised ER diagrams and other database documentation.

* Reviewed, edited and coded about 3300 lines of SQL stored procedures.

* Environment: IDEF1X, SQL Server 6.5, 7.0 and 2000, Erwin 2.x, VSS, JAD

SR. DATABASE ENGINEER

Intermation, Inc.

Bellevue and Redmond, WA

05/1995 - 06/1998

* Captured warehouse management business processes and requirements using JAD sessions, analyzed results using OOA, and using OOD created designs of a new database system.

* Developed a report server for automated creation of template driven scheduled and ad-hoc heterogeneously sourced database reports, saving approximately 200 hrs/week

* Developed mentoring sessions on databases and related software engineering methodologies.

* Environment: IDEF1X, SQL 6.x and 4.x, Erwin 2.x, VB, VBA, Crystal Reports, Rational Rose

Further career history available on request

EDUCATION

* B.S. in Computer Science, Florida State University

* B.S. in Biology, University of West Florida

* Oracle9i: Advanced PL/SQL (hands-on), Oracle University.

* Microsoft Certificate course, Performance Tuning and Optimization of Microsoft SQL Server.

* Microsoft system skills update course, Performance Tuning and Optimization of Microsoft SQL Server 2005.

* SQL Server 2008 Business Intelligence - OLAP certificate course (Bellevue College)

Contact this candidate