CAREER SUMMARY:

• Proven technology leader with multiple successful large - scale Business Intelligence implementations.
• Over fifteen years of business intelligence experience in a variety of roles including: development team manager, data architect, program manager and database developer.
• BI strategy and program management expertise.
• Industry background in finance, e-commerce, education, healthcare, education and distribution.
• Extensive development management experience utilizing both on-shore and off-shore resources
• End-To-End design experience for numerous large Business Intelligence and data integration projects.
• Expertise in data governance, metadata management, data quality and reference data management.
• Expert in Kimball’s & Inmon’s data warehousing methodologies.
• Strong data modeling background in both 3NF, data vault and dimensional paradigms.
• Extensive database development experience with Oracle including query optimization, PL/SQL, triggers, SQL/loader and materialized views.
• Expertise with Informatica and Oracle Data Integrator (ODI) ETL tools.
• Knowledge of other relational database products including: Teradata, SQL/Server, DB2 and Sybase.
• Knowledge of BI tools from Microsoft (SSAS, SSRS & PowerView), SAP and Oracle.
• Proficiency with ER/win and ER/Studio data modeling tools, UNIX shell scripting and the Microsoft Office Suite.

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

Data Architecture Consultant

• Engagement focused on extending the functionality of the client’s Teradata Claims & Membership data warehouse.
• Created data vault models to support data integration.
• Designed Business Objects semantic model.
• Build ETL processes with Informatica & native Teradata SQL.
• Automated data quality testing functions.

Confidential, Renton, WA

Data Architecture Consultant

• Engagement focused on optimization of integration processes for a Hyperion Profitability & Cost Management (HPCM) initiative.
• Documented Informatica & ODI ETL processes which linked Oracle DBs, Essbase cubes, and file based sources.
• Created ETL optimization roadmap.
• Modified and created new ODI and Informatica processes.
• Designed OBIEE sematic models support workgroup, departmental and enterprise level analytic requirements.

Confidential, Seattle, WA

Senior Principal Consultant

• Provided guidance on Business Intelligence strategy and architecture to various clients including Confidential University, Schnitzer Steel Industries and Confidential .
• Topics included Data Governance, Metadata, Data Modeling and ETL design.
• At Confidential, participated in the creation of a university wide BI program strategy focusing on the following areas: data governance, architectural guidelines, tool rationalization, program methodology and project roadmaps.
• Created logical and physical designs (data models, ETL plans and semantic models) for several projects within the BI Program.
• Built tools for data quality analysis, data profiling, error handing and process monitoring.

Confidential

Data Warehouse Architect

• For Schnitzer Steel Industries, build multiple OBIEE repositories to support end-user analytic requirements.
• Lead OBIA migration team.
• Responsible for migration of ETL infrastructure from Informatica to ODI.
• Created and modified multiple ODI routines to support the migration.
• At Confidential, performed complex data migration activities with PL/SQL. Also responsible maintenance and enhancements for Jibe’s internal Oracle BI systems built with OBIEE & ODI.

Confidential, Seattle, WA

Data Warehouse Architect

• Modeled single view of the business via analysis of multiple data source systems and stakeholder interviews.
• Creation of conceptual, logical and physical data models for the warehouse using ER/win.
• Build stored procedures to load staging area, integration platform and dimensional data marts.
• Wrote design & functional specification documents for above. Presented summary of design to stakeholders.

Confidential, San Antonio, TX

Senior Data Warehouse Consultant

• Created data integration plan for the rollout of new ERP & CPM packages.
• Performed analysis of existing data warehouse environment and recommended design changes to align with ERP & CPM projects.
• Prepared an analysis of BI, ETL & RDBMS tool marketplace and presented result to senior management.

Confidential, Redmond, WA

Senior Business Intelligence Consultant

• Revised dimensional data models and recommended aggregation strategy utilizing Oracle materialized views.
• Optimized backend DB performance to support rollout of e-commerce application. Set up database partitioning, created index-organized tables and optimized queries to enhance application performance.
• Created PL/SQL error handling, data cleansing and balancing procedures to assure data accuracy and completeness.
• Coded ETL jobs w/ Oracle Data Integrator.
• Updated design specification for all changes.

Confidential, Seattle, WA

Data Integration Manager

• Created complex PL/SQL procedures and Informatica mappings to extract data from Confidential customer - relationship data stores. Transformed the data for use in Confidential ’s centralized customer DB. Designed extensions to data models to support the conversion.
• Built customer analysis and credit reports for integrating data from Confidential and surviving Confidential systems (Oracle PL/SQL and VBA).
• Planned migration for surviving database servers from Confidential data centers to Confidential facilities.

Confidential

Senior Database Architect

• Designed and prototyped near real-time data staging solution for use with Oracle source systems.
• This system transferred data from materialized view logs to BI integration repositories.
• Implemented tools for data quality monitoring and collaborated with business teams on procedural changes to improve data quality.
• Member of enterprise team which prototyped data obfuscation technology for the Bank.

Confidential

Data Services Manager

• Set up an offshore development program to augment internal development teams. Worked w/ corporate teams to address access and security issues.
• Responsible for design and development of a 7 million dollar BI application. The application provided a common view of key Commercial data. It was comprised of a staging area, integration repository (3NF), multiple dimensional data marts, and SQL Reporting services cubes. Data was fed via both batch and real-time ETL processes.
• Implemented offshore monitoring and level 1 support for production databases. Streamlined and documented operational procedures.

Confidential

Data Architect

• Designed a dimensional data warehouse and the accompanying data movement infrastructure for the Enterprise Spend Management (ESM) project. The warehouse supported the A/P, Purchasing, and Strategic Sourcing organizations. The warehouse conformed and aggregated data from seven legacy systems in order to provide a unified view of spending for the Bank.
• Developed metadata repository to support various data warehousing projects. Created an extensible data model for the repository. Designed metadata harvesting interfaces for relational databases, Informatica, Business Objects and ER/Win. Supervised the creation of a Java based web client for metadata presentation.
• Provided input on architectural issues and functionality extensions to various legacy BI platforms.