Accomplished data & database architect, data modeler and database developer with extensive experience with agile development of data warehouses, data marts, and operational data stores informed by both Kimball and Inmon methodologies. Experienced designing and implementing large databases while leveraging database tools for design, metadata, ETL, and code control to rapidly deploy fully functional systems. Assembles and leads teams by organizing workload and mentoring junior developers as required.
Able to view situations from any or all of the following perspectives; Business, Architectural, Macroscopic, Microscopic. Possesses excellent analytical and communication skills with an ability to organize information for, and relate to, all levels of management and systems personnel.
Team member on over 15 data marts/data warehouses as Tech Lead, Architect/Designer, Data Modeler and or ETL developer. Several were for global corporations incorporating data from multiple ERP systems in multiple languages and character sets. Recent multi-terabyte experience.
Former Naval Officer and Navy Nuclear Power Operator

Education
Bachelors of Science, Electrical Engineering and Computer Science

Practice areas
Roles
Data Warehouse Architect
Data Architect
ETL Architect
Team Leader
Data Modeler
Project Manager
Data Profiler
PL/SQL Developer
Tools and Methods
ER/Studio
Powerdesigner
Erwin
Oracle versions 6 to 11.2g RAC
MS SQL Server 2005
2008 Sybase 12.5
DataStage/Informatica
Oracle Warehouse Builder
UNIX/korn shell
Toad
MS Project TFS
Subversion
PVCS

Experience

Confidential, Tampa, FL
Senior Data Warehouse Consultant July 2010 - August 2012
Assumed responsibility for a mission critical Operational Data Store (ODS) for the Water Information Management System (WMIS). Reverse engineered source code for all database objects and programs and placed them under source code control in MS Team Foundation Server. Implemented scripted database deployment/build process for the ODS. Implemented branching and merging for the ODS code. Rewrote the ETL process to include enhanced process and error logging while optimizing performance and reliability. Implemented an incremental update strategy using code generated Oracle MERGE commands. Documented the process and organization of data and code for follow on developers.
Redesigned the ODS, new design when implemented will reduce the number of objects and lines of code by approximately 85%. New design will give near real time updates in the ODS.
Engaged by management to design and implement a "New Project Template" as a framework around which we standardized the organization of software development deliverables such that it supported good configuration management practices and supported scripted database deployments. Template allowed various subject matter experts to add to template so each new project thereafter incorporated the added functionality or knowledge.
Reverse engineered database source code for the WMIS system and organized it in source code control.
Designed Star Schema for all water measurements.
Designed and implemented a data mart for WMIS system usage versus trouble reports metrics.
Supported production database deployments and operations.
Reverse engineered and organized data models for various projects using Embarcadero's ER Studio Data Architect.
As DBA and System admin for build environment, developed and documented process and code to quickly and easily create a new Oracle or MS SQL Server database environment.
Absolutely shredded every database performance issue given in Oracle RAC environment.
Reduced an ETL refresh process that was running for 6-10 hours and frequently causing production outages to a reliable less than one hour process the first week on site.
Reduced to millisecond response time an update trigger that had been punishing district users for 5 years with a 3-5 minute wait every time they tried to edit a PARTY record. Did it in less than 8 hours of billable time.
Tuned two materialized views taking 2-4 hours of runtime each refresh to 5 minutes in less than 8 hours of billable time.
Support and mentor other developers in good programming practices and procedures

Confidential, Memphis, TN
Data Architect/Data Modeler August 2009 - June 2010
Designer and Oracle Lead for the Integrated Reporting and Interfaces Datamart (IRIS)
Lead a team of 4 developers and created an Oracle 10g Datamart sourced from multiple source systems including a VLDB(3TB+)
Design and implement Star Schema
Responsible for performance tuning of ETL programs getting data from VLDB.
Tune the loading of the star schema including parallel query, bit map indexes, bit map join indexes, explain plans and access paths
Responsible for partitioning of Datamart tables
Participate in partitioning of VLDB source system
Design, write and deploy a global process logging application
Participate in an insurance web services server design and implementation for the Aon iVOS web service client. The web service client is based on the ACORD standard and uses XML, WSDL and xml schemas
Design an iVOS ODS schema to support multiple iVOS instances in one ODS
Data profile the iVOS and viaOne data using Datirus data profiling software
Reverse Engineer and document data models for key viaOne and iVOS tables
Participate in requirements gathering and reviews, wrote design documentation and participated in design and code reviews
Project estimation and project plan generation
Generate and maintain data models using heavy SAX basic automation ER/Studio 8.5
Code generate over 180 PL/SQL stored packages which interface to dot net.
Code generate ETL MS SQL data to Oracle using BCP and Oracle SQLLDR direct access mode.
Write a c# program to analyze 388 jasper xml report specs using a SQL parser
Generate and maintain DDL with associated change management and version control
Support Sedgwick to mature their software configuration management processes and procedures. Trained developers in the use of Subversion.
Design and implement a reliable, repeatable build and deploy process with Subversion, SQL Plus and shell scripts
Support and mentor other developers in good programming practices and procedures
Oracle 10G/11G PL/SQL development interfacing to .NET

Confidential, New Britain, CT
Data Warehouse Architect/Technical Lead February 2008 - April 2009
Tech Lead/Data Architect for global AR BI Datamart (SAP, Navision, JD Edward and ACG)
Generate and maintain data models for 5 new projects
Implement Metadata capture, storage and deployment through Business Objects
Responsible for all data model(Powerdesigner) and DDL changes for Stanley Data Warehouse
Generate and maintained DDL with associated change management
Implement source code control and change management (Subversion, MantisBT)
Create and implement release/build management system
Implement Subversion, Mantis and DokuWiki servers with VMWARE Jumpbox virtual appliances
Upgrade Powerdesigner and repository (10.2 -> 12.5)

Confidential, New York City, NY
Senior Data Warehouse Consultant April 2005 - August 2006
Re-architect PeopleSoft Global Data Warehouse ETL process
Design and build an ELT process for PeopleSoft Global Data Warehouse, prototype was estimated to be 100 times faster than production system
Reverse engineer physical and logical data models for PeopleSoft Global Data Warehouse
Troubleshoot, document and resolve performance bottlenecks
Participate on design reviews for projects interfacing with Global Data Warehouse
Research and implement adjacency list to nested set conversion which resulted in 2,400% performance improvement over PeopleSoft implementation
Systems Architect/Lead Developer August 2003 - March 2005
Re-architect RITS system (Personnel ODS) ETL-ELT Process, implement new design
Work with SMEs to understand current and future business requirements
Perform detailed source system analysis including analysis of data quality issues
Create "as is" data models and design future state requirements document with data models
Design, code, test and document ELT process for high performance and extensibility
Design and document process to rapidly resolve existing data quality problems
Oracle Database Architect/Developer August 2002 - August 2003
Architect Oracle portion of data delivery system for Global Compensation System interfacing to PeopleSoft HR system
Design and implement metadata/metrics capture system used on all data delivery, reports and out bound feeds
Design and develop over 100 stored procedures
Create and maintain system data models
Mentor team of 15 developers on best practices, performance tuning and debugging