Data Warehouse

Frank Nee Phone: 805-***-****

**** ***** ***, ******, ** 75034 *****.***@*****.***

SUMMARY

Senior Enterprise Data Warehouse Architect with extensive experience of leading implementations of

Large Scale, Multi Terabyte Data Warehouses on multiple BI platforms across multiple Industries.

EXPERIENCE:

MORGAN STANLEY/SAXON IRVING, TX

05/2011–present

SENIOR ENTERPRISE DATA WAREHOUSE ARCHITECT

Key Responsibilities and Accomplishments

Responsible for leading the overall design and construction of Saxon’s Enterprise Data Warehouse,

•

guiding the ETL and SSRS report developments teams working in sync to successfully deliver the

complete solution on SQL Server 2008/2012 platform.

Extended Kimball and Inmon Methodologies for Real World Data Warehouse Designs, proposed

•

Architectures of Data Warehouse (Staging, ODS, Data Marts and OLAP Cubes) that best serve Saxon’s

needs based upon these Principles.

Implemented a Master Data Management Strategy that played a pivotal role in Saxon’s successful

•

data integration of various Mortgage processing partners.

Led the effort of constructing Logical and Physical Models of Staging, ODS and Data Marts with

•

Embarcadero ER/Studio, as well as OLAP Cubes with Microsoft SSAS.

Mentoring Architects and Developers proper techniques of Designing, Optimizing and Tuning

•

Dimensional Systems, ensuring the traditional Legacy OLTP techniques are not forced onto Dimensional

System Design and Implementations.

Coordinating requirement capturing from various business areas and the development of technical

•

specifications, walking through source/target mapping, Informatica data loading/transformation logics with

developers to ensure the business rules are implemented correctly.

FANNIE MAE DALLAS, TX

07/2010–04/2011

CONSULTANT /LEAD DATA WAREHOUSE ARCHITECT

Key Responsibilities and Accomplishments

Architected the ODS, Data Mart foundation for Fannie Mae’s STAR program, which grades

•

Mortgage Servicers’ performances, and it famously forced Bank of America give up the service rights of

400,000 Mortgages when it failed the STAR grade.

Developed methods to successfully consolidate/conform data from 60+ top Servicers into the STAR

•

ODS/Data Marts on Oracle 11g, allowing STAR to effectively and consistently grade the Servicers.

Coordinated the development of STAR report with Business Objects, provided technical and

•

architecture guidance to developers whenever necessary.

BANK OF AMERICA PLANO, TX

07/2008–06/2010

SENIOR ENTERPRISE DATA WAREHOUSE ARCHITECT

Key Responsibilities and Accomplishments

Responsible for architecting and enhancing BAC’s Mortgage Servicing Data Warehouse, guiding

•

and coordinating the DBAs, ETL and report developers during the complete SDLC of BAC’s Data

Warehouse implementation.

Initiated a THREE-Stage Data Warehouse architecture (Operational Data Store, Data Marts and

•

OLAP Cubes) that enabled Microsoft SQL Server (instead of other more expensive platforms) host BAC’s

Multi-Terabyte Mortgage Servicing Data Warehouses.

Improvised partition strategies for very large dimension/fact tables and Cubes to enable SQL Server

•

2008 platform effectively host BAC’s Multi-Terabyte Mortgage Servicing Data Warehouses that

outperformed the previous AIX/Oracle 10g platform.

Built Relational and Dimensional Data Models for the key components of the ODS and Data Marts,

•

mentored other architects techniques of designing high performance large Data Warehouses.

Implemented Multi Terabyte Mortgage and Insurance OLAP Cubes from ground up with Analysis

•

Services (SSAS), led the performance turning efforts to ensure the performance bench marks were met.

Joined an effort of reengineering a Countrywide Mortgage Performance Data Mart in Oracle 10g

•

and migrating it to Bank of America’s Teradata Data Warehouse.

COUNTRYWIDE FINANCIAL SIMI VALLEY, CA

09/2004–06/2008

SENIOR ENTERPRISE DATA ARCHITECT

Key Responsibilities and Accomplishments

Responsible for architecting and enhancing CFC’s Enterprise Data Warehouse, leading and

•

coordinating the technical teams in the full life cycle of DW implementation.

Designed and built the logical and physical data models of key Mortgage and Insurance data marts

•

and operational data stores with Embarcadero on Oracle 10g.

Wrote key Mortgage and Insurance report specifications for Business Objects, designed and

•

developed corresponding Business Objects XI Universes.

Designed highly flexible, efficient multi dimensional data models for the Business Objects XI

•

reporting, which needs to satisfy BAC’s demanding Mortgage and Insurance reporting requirements.

Coordinate the effort of performance tuning of the Mortgage and Insurance Data Warehouse and

•

manage the rapid size growth of Oracle 10g Data Warehouse.

Designed and developed Business Objects XI Universes for key Mortgage and Insurance Business

•

Objects Reports.

Led the Implementation of the Business Objects Security Bridge integration with PeopleSoft EPM,

•

which allows PeopleSoft Security setting seamless applied to Business Objects automatically.

Designed a metadata driven Impact Analysis system, which allows users perform valuable impact

•

analysis of the Countrywide PeopleSoft EPM System.

Provided technical resolutions to many challenging obstacles during the implementation of

•

Countrywide’s PeopleSoft Enterprise Performance Management System, which is one of the earliest

successfully large scale PeopleSoft EPM implementations.

TEXAS CHILDREN’S HOSPITAL HOUSTON, TX

CONSULTANT/LEAD DATA WAREHOUSE LEAD 01/1999–08/2004

Key Responsibilities and Accomplishments

Lead the effort of implementing the Business Intelligence strategies for Texas Children’s Hospital,

•

architecting the Data Warehouses, ETL processes and report solutions for the Hospital’s PeopleSoft HR and

Financials Systems.

Evaluated various Business Intelligence tools/solutions from top vendors and recommend the BI

•

tools/solutions best suited for the Hospital and its ERP systems to the upper management.

Architected an innovative, complete ERP BI/Reporting Solution that provided functionalities that

•

even PeopleSoft were not able to provide until years later with PeopleSoft EPM.

Developed the ETL technical and data mappings specifications for the Informatica development

•

team, help them address any design issues whenever necessary.

Architected the OLAP reporting strategy, developed the specification for the Essbase cubes for the

•

Essbase development team.

UNION CARBIDE CORP HOUSTON, TX

CONSULTANT/DEVELOPMNT LEAD 12/1997–12/1998

Key Responsibilities and Accomplishments

Led the implementation two of Union Carbide’s crucial projects, Asset Repository and

•

Responsible Care Tracking Projects. The projects were developed in PowerBuilder on Oracle 7.2;

Data Modes were built with CA Erwin.

Responsible for assembling the development team, guiding the team in all phases of the

•

project cycle, teaching Union Carbide developers the correct design and development techniques

and providing guidance whenever necessary.

Designed the application Data Models and the main components of the user interface,

•

supervised the development, QA effort and ensuring the projects completed on time and on budget.

CHEVRON CORP HOUSTON, TX

CONSULTANT 06/1997–12/1997

Key Responsibilities and Accomplishments

Designed and developed key components of Chevron’s Asset Management Project, which allows

•

Chevron to analyze the performances of its key Assets. The Project was developed with Erwin,

PowerBuilder on Oracle.

UNITED HEALTHCARE TAMPA, FL

APPLICATION DEVELOPER 05/1996–06/1997

Key Responsibilities and Accomplishments

Made major contributions in designing and developing one of UHC’s key EMP projects,

•

“HealthCare Provider”, which allows UHC to measure, analyze performances of its HealthCare

Providers. The project was developed in PowerBuilder on MS SQL Server.

Designed the Conceptual and Physical Data Models, as well as the major components of the

•

user interface for the “HealthCare Provider” project. The Data Models were built with Sybase S-

Designer.

Designed ETL jobs to populate the Data Warehouse from various data sources, implemented

•

processes to automate and schedule these ETL jobs to ensure they run in correct order and the date

warehouse refreshed correctly.

OKRA MARKETING/HARLAND FINANCIAL TAMPA, FL

APPLICATION DEVELOPER 01/1993–05/1996

Key Responsibilities and Accomplishments

Designed and enhanced key components of Okras’ Custom Analytical Database Engine,

•

which made Okra’s Analytical System, the Pinnacle the most efficient and scalable in its class.

Designed and developed the Data Import and Data Export functions, which allowed the

•

Pinnacle System perform Analytical Processing of client data and sending results back to clients.

TECHNICAL PROFICIENCIES:

Hardware Platforms: IBM AIX, HP UNIX, OS/2, Windows 9x/NT/2000/2003/2008/XP

Databases: Oracle 7/9i/10g/11g, Teradata, Sybase, Microsoft SQL Server

DW Design Methodologies: Kimball, Inmon and Industry Main Streams

Data Modeling Tools: Embarcadero, ERwin, PowerDesigner

BI Reporting Tools: Business Objects, Crystal Report, Hyperion/Brio, SSRS, QlikView

OLAP Platforms: Hyperion/Essbase, Microsoft SSAS

ETL Tools: DataStage, Microsoft SSIS, Informatica, Data Mover

Metadata/Master Data Tools: IBM InfoSphere

Data Profiling Tools: Informatica Analyst

Data Quality Tools: IDQ (Informatica Data Quality)

ERP Applications: PeopleSoft HR, Financial, EPM, CRM

Programming Languages: C, Visual Basic, PowerBuilder, Hyperion SQR, PeopleCode, SQL, MDX

EDUCATION: M.S. Applied Computing Science: University of New Orleans

Contact this candidate