Data Warehouse Management
Resume:
PROFESSIONAL SUMMARY
Carrington Mortgage Holdings, Santa Ana, California (www.carringtonms.com) Dec 2009 - Current
Mortgage Servicing, Mortgage Lending, Escrow, Real Estate, Property Management.
DIRECTOR , BUSINESS INTELLIGENCE
Joined Carrington as the Director of Business Intelligence and successfully built a fortified BI team of 9+ to assist with development and deployment of Carrington’s Enterprise Data Warehouse consisting of Subject Area Marts that presently serve various business areas including APRE, Atlantic Pacific Real Estate, CRS, Compensation and Recovery Services, CMS, Carrington Mortgage Services, APE, Atlantic Pacific Escrow, and CML, Carrington Mortgage Lending and others where the new Enterprise Data Warehouse has enabled the development and deployment of various web-based executive dashboards as well as hundreds drillable operational and analytical web-based reports.
Key Results
Built a highly efficient, highly talented Business Intelligence team of rock-star professionals at the outset by recruiting from my ever growing network.
Perform day-to-day management of various sized projects as well as management, mentorship and further development of a highly technical and analytical Business Intelligence team.
Set Carrington’s data management and historical data retention strategy and implemented policies and processes to archive essential historical data needed for an Enterprise Data Warehouse.
Streamlined, restructured and optimized existing legacy SQL Server reporting databases as well as legacy Microsoft SSRS reports to meet business’s operational and analytical needs while full transition to the new Enterprise Data Warehouse is achieved.
Averaging successful deployment of one Subject Area Mart per quarter each including one or more web-based executive/operational dashboards as well as myriad of fully drillable web-based operational and analytical reports. Great care is taken to ensure each Mart is designed within the confines of dimensional modeling methodology, each a subset of the Enterprise Data Warehouse set within the constructs of a Data Mart Bus Architecture preventing information silos and maximizing shared conformed and global dimensions.
REDC, Irvine, California (www.Auction.com) Apr 2009 - Dec 2009
Industry Leader in residential and commercial real estate auctions throughout US and UK.
DATA ARCHITECT, INFORMATION TECHNOLOGY
Joined REDC as the Data Warehouse Architect and within incredibly tight time constraints successfully design and deployed REDC’s Enterprise Data Warehouse from inception to completion including a Data Mart Bus Architecture, archival processes and end-to-end ETL to stage, cleanse, and standardized disparate source data elements enabling integration into conformed global dimensions shared by various subject area Marts.
Key Results
Built a small, highly efficient and talented team of Database and Business Intelligence professionals within my first three weeks in REDC.
Analyzed REDC’s existing Data Management and Business Intelligence strategy and made recommendations.
Set data retention strategy and deployed processes to retain and archive historical data.
Worked with the CIO to setup development and production environments as well as allocating needed disk storage space for the new Data Warehouse.
Assessed and redesigned most critical areas of the source databases and worked with the application development team to make the necessary changes in order to improve quality of incoming data at the outset.
Restructured most critical areas of the source databases and at the application level wrote scripts to redirect and cleanse existing/historical data.
Designed and implemented extensive cleansing and standardization strategies and processes to improve data quality and conform like data elements from multiple disparate sources into centralized global dimensions
Overhauled the Real-estate ODS formerly designed to store and facilitate REDC’s real-estate division and application restructuring most critical areas of the database and rewriting fifty plus stored procedures
Designed and deployed several Subject Area Marts each within the constructs of a Data Mart Bus Architecture where they shared conformed dimensions including Pre/Post Auction Residential, Pre/Post Auction Commercial, Pre/Post Auction Notes, Online Auctions, Real-estate Sales, and Closings.
Worked with the Reports Development team to migrate/reproduce myriad legacy reports as well as writing new SSRS reports against REDC’s new Enterprise Data Warehouse.
Fireside Bank, Long Beach, California (www.firesidebank.com) Nov 2007 - Mar 2009
$1B auto finance bank that, originates and services auto loans.
DIRECTOR, BUSINESS INTELLIGENCE
Joined Fireside Bank as the Director and Chief EDW Architect and successfully designed and deployed Fireside’s new and first internally hosted Enterprise Data Warehouse including establishing six plus source systems data feeds, staging and archival environments and ETL processes, and five data marts. Established Fireside’s new Business Intelligence Department, built, coached and managed a team of 10 plus highly talented Data Warehouse professionals, set Fireside’s data management, data retention and information delivery strategy and policies. Planned, acquired, and deployed Fireside’s internal business intelligence infrastructure. Managed SOX and FDIC compliance activities including writing policies and procedures, technical and non technical documentation, data integrity checks automation, reviews, testing and remediation.
Key Results
Partnered with company’s President/CEO and various senior management staff and established Fireside’s new Business Intelligence Department.
Recruited technical talents and fully staffed the new department by mid Q2 2008.
Analyzed and documented Fireside’s existing data management, retention and information delivery strategy and policies, identified gaps and made recommendations.
Worked with department heads, Business Analysts, and various senior staff and documented analytical and operational reporting needs and requirements.
Planned, budgeted, acquired and deployed Fireside’s Data Warehouse and Business Intelligence infrastructure including hardware and software consisting of Storage Area Network, clustered and stand alone servers configurations for storage, FTP, back-end processing, and reporting by Q1 2008.
Negotiated contracts and set up feeds from six plus externally hosted source systems by Q1 2008.
Designed and deployed ODS and end-to-end ETL to load, stage and archive Fireside’s source system’s data.
Designed and deployed Fireside’s new internally hosted Enterprise Data Warehouse and delivered first three Data Marts including Loan Origination, Loan Servicing and Global on-time and within-budget (Q3 2008).
Implemented various credit and behavioral scorecards (designed Risk Management) into EDW and established external feeds to host systems.
Implemented various OLAP Cubes for analytical reporting including Trans Probability, Static Pool, and Loss Projections.
Established Operational and Reporting infrastructure and migrated/reproduced legacy reports and developed new reports including the Originations dashboard by Q1 2009.
Designed two additional Data Marts including Collections and General Ledger by Q1 2009.
IMPAC COMPANIES, INC., Irvine, California (www.impaccompanies.com) Sep 2005 - Nov 2007
$26B mortgage real estate investment trust (REIT) that acquires, originates, sells, and securitizes various mortgages.
SR. DATA WAREHOUSE ARCHITECT, BUSINESS INTELLIGENCE
Joined Impac Companies as the Sr. Data Warehouse Architect and successfully designed and deployed a new Data Warehouse consisting of five subject area marts. Reviewed and redesigned ETL of existing legacy data warehouse to drastically reduce load time enabling parallel load of legacy and the new data warehouse. Set up internal and external data feeds and historical data retention for immediate as well as future data mart projects. Assisted in organization and documentation of ETL processes to achieve SOX compliance for Corporate Information Systems including ETL, Data Warehouse and Operational Reporting by end-of-year 2005.
Key Results
Lead the design and development of the new Data Warehouse delivering three new federated Data Marts including Loan Origination, Loan Servicing and Warehouse Lending; on-time and within-budget achieving 165% ROI (based upon independent assessment by Nucleus Research http://www.nucleusresearch.com)
Established external data feed from Country Wide Financial, automated cleansing, load and distribution.
Established external data feed from Loanperformance.com followed by design and development of the Loan Performance Data Mart including ETL process to load over 25 gigabytes of national mortgage data monthly.
Partnered with the Enterprise Risk Management to provide predictive analytical capabilities by designing and developing static pool aggregates from the terabyte plus Loan Performance Data Mart.
Partnered with Default Department as well the Enterprise Risk Management and designed/developed the Internal Delinquency/Performance Data Mart to enable immediate operational reporting on delinquencies as well as providing predictive and Static Pool analytics from historical time series data.
Designed Business Objects Universes for the Loan Performance and the Internal Delinquency/Performance Data Marts that included myriad of customized and complex queries and measures.
TRIAD FINANCIAL, INC., Huntington Beach, California (www.triadfinancial.com) Aug 2001 - Sep 2005
$5B Subsidiary of Ford Motor Credit specializing in below-prime consumer lending and auto finance.
DATA WAREHOUSE ARCHITECT, INFORMATION MANAGEMENT & DELIVERY
Joined Triad Financial in 2001 as the Data Warehouse Architect and successfully created the Enterprise Data Warehouse consisting of three subject area marts including Loan Origination, Loan Servicing and Transaction used for operational reporting, predictive analytics and mission critical operations. Designed and developed incremental data extracts from multiple sources and established historical data retention and data archival strategy and processes. Designed and deployed a shared Staging Database for data cleansing and integration of multiple data sources. Successfully integrated three disparate loan origination systems into one cohesive subject area mart, the Loan Origination Data Mart. Designed and developed, and deployed the Transaction Data Mart used for mission critical operations such as financial booking as well as operational and historical reporting. Successfully completed documentation to ensure SOX compliance of the Transaction Data Mart. Designed Business Objects Universes for all subject area marts deployed. Implemented series of OLAP cubes to drastically enhance query performance of all subject area marts.
Key Results
Initially worked in Risk Department to provide end to end BI solution for Triad Financial and achieved successful delivery of an Enterprise Data Warehouse after two failed attempts by prior IT management.
Successfully documented and deployed the Enterprise Data Warehouse into production.
Transitioned to IT and continued to lead the effort of maintenance and future releases of the Enterprise Data Warehouse.
Defined, designed, and delivered highly scalable data mart bus architecture.
Wrote highly complex extract routines and accomplished fast incremental extracts of OLTP data sources with limited time stamps.
Wrote highly complex SQL code when ETL tools were not adequate to implement and automate complex business rules using under par data.
Worked closely with DBA to design and implement highest performance physical data structures.
Achieved SOX compliance by working closely with the Internal Audit and continuous documentation of code, ETL and business processes.
Partnered with business and successfully gathered and clarified requirements.
Ensured open channels of communication with business for continuous support of the user community.
Delivered BI interfaces to the user by creating universes and other BI tools to connect to various data marts and OLAP cubes.
AVEO INC., San Jose, California Dec 2000 - Apr 2001
Fastest growing online help network – free software that scans, warns and fixes personal computers
DATABASE ANALYST, INFORMATION TECHNOLOGY
Responsible for the tactical design of BI and reporting solution including partnering with IT manager and DBA to provide logical and physical data models for the Data Warehouse. Responsible for designing BI tool universe/interface to provide reporting capabilities to the management, marketing and seals staff.
Key Results
Successful design and implementation of a Data Warehouse using classic star schema model.
Delivered BI solution in a short period of time after a previous failed attempt by a consulting firm.
Successful implementation of Data Warehouse of terabytes of internet traffic, page views, and click-through data.
Achieved rapid deployment of Brio interface enabling self-service reporting capabilities to various departments.
Delivered a high performance reporting solution with fast query response by providing aggregate fact tables.
INTERMOUNTAIN HEALTH CARE, Salt Lake City, Utah (www.ihc.com) 1998 - 2000
Over 2600 employees’ health care provider in Utah, Idaho with 21 hospitals, clinics, and health plans.
DATA/PROGRAMMER ANALYST, INFORMATION TECHNOLOGY
Lead the integration of over 100 medical facilities’ customer data into the Master Customer Database including; detailed analysis of legacy systems data; writing complex text matching algorithms, SQL code and Perl scripts to de-dup, cleanse and consolidate customer records from disparate source systems.
Key Results
Wrote Automatch algorithms to facilitate fuzzy logic in order to match customer/patient records from disparate legacy system’s data.
Created complex SQL and Perl scripts to facilitate the customer record integration effort.
Automated and optimized processing of millions of customer records including de-duping, cleansing, and consolidation.
Partnered with various medical facilities; hospitals and clinics to coordinate integration of their facility’s customer data.
ADDITIONAL PROFESSIONAL BACKGROUND AND CONSULTING EXPERIENCE
Loanperformance.com
Acxiom Corporation
Cambridge Consulting
Selqtech Consulting
RoadLoans.com
TECHNOLOGY EXPERIENCE
Database Platforms: SQL Server 2000, 2005; Oracle 9i, 10g.
Database Design Tools: Erwin 4, ERStudio 6.6.1, DBArtisan 8.0.1, Rational Rose
Database Development Tools: PLSQL Developer, Toad, SQLplus, Query Analyzer
ETL Software: Informatica powercenter 7, Business Objects Data Integrator 11.x, DTS, SSIS
Business Intelligence Software: Business Objects 6.5, Brio, MS Reporting Services, MS Analysis Services
Programming Languages: Transact SQL, PLSQL, Perl, C++, Java
Hardware: Windows, IBM P-Series, HP-UX, Sun
O/S: Windows NT, XP, HP-UX, AIX, Linux, Solaris
PROFESSIONAL MEMBERSHIPS AND AFFILIATIONS
The Data Warehouse Institute (TDWI) - Member (2003 – Present)
EDUCATION
The Data Warehouse Institute (TDWI) – San Diego, California
Data Warehouse Technical Program (2007)
Santa Clara University – Santa Clara, California
Data Warehousing Coursework (2001)
University of Phoenix– Salt Lake City – Utah
MS, Information Systems (1995 - 1998)
Weber State University – Ogden, Utah
BA, Communications (1981 - 1985)
SALARY HISTORY AND PROFESSIONAL REFERENCES
(Available Upon Request)
Contact this candidate