ENTERPRISE DATA WAREHOUSE ARCHITECT AND EDW/BI DEVELOPMENT SUPERVISOR
Seasoned enterprise data warehouse architect with over 14 years' experience in system design and development.
EDW/BI Development supervisor with 6 years' technical lead & managerial experience in enterprise data warehouse and
business intelligence system design and development using agile(Scrum/Planning Poker) methodology.
Dimensional model design Erwin/Visio
Logical/Physical model design Informatica PowerCenter/Data Quality/Data Explorer
ETL architecture and design OBIEE Repository(RPD) design
Inmon and Kimball Architecture Hyperion Interactive Reporting
Agile methodology SQL Server and Oracle
December 2012 to Current
Stewart Title Guaranty CompanyHouston, TXEnterprise Data Warehouse Architect and EDW/BI Development Supervisor
Established EDW as enterprise data integration hub and source of single truth for Direct Operations - accounting relies on EDW for report on opening, closing, and revenue; investor relationship relies on EDW for quarterly earnings release Reduced available time for key reports that Agency Operation executives rely on from weeks to just one day by designing and implementing underwriter data mart Designed change data capture framework to support near real-time reporting of data from over 800 source databases.
Reduced 70% of effort on working day related dashboard and report development by designing abstract working calendar dimension to meet business reporting requirements by working day Reduced staffing cost through smart staffing for busy/slow season by integrating staffing working time information from HR into data warehouse Software development supervisor overseeing on-going maintenance and enhancement to Stewart data warehouse.
Manage a team of ETL developers and BI developers Member of Stewart Enterprise Architecture team responsible for data architecture and data integration Enhanced/redesigned dimensional model and created mapping specs for order analysis data mart to support migration of reports/dashboards from Hyperion Interactive Reporting to OBIEE Created initial draft of OBIEE repository(RPD) design and involved in on-going enhancement/maintenance of the RPD Implemented process for quarterly and annual data warehouse design and operation review to proactively fix/enhance design and plan for growth.
November 2009 to November 2012
Stewart Title Guaranty CompanyHouston, TXETL Architect/Team Lead
Technical lead for data modeling, ETL design and development Lead on requirement gathering and analysis for underwriter data mart Designed dimensional model for underwriter data mart Designed dimensional model for customer analysis mart Developed customer cleansing and matching data quality plans Improved performance of several ETL mappings dealing with large data sets by 70% through manual query push down Designed ETL operation and data quality monitoring framework.
May 2008 to October 2009
Stewart Professional SolutionsHouston, TXETL Architect/Developer
Lead on dimensional model design and ETL design/development.
Created Stewart ETL development standard Created first release of Stewart Enterprise Data Warehouse business continuance plan and operation monitoring procedures Enhanced order analysis mart to support reporting of lock-down view and current view.
November 2006 to April 2008
Stewart Transaction SolutionsHouston, TXSenior Programmer/Analyst
Participated in ETL/BI tool selection and dimensional model design in creating the first data warehouse for Stewart Designed high-level workflows Developed mappings, sessions, and workflows for type 2 change data capture and Essbase export ETL.
Assisted in development of data warehouse architecture policies and processes Created deployment document template for Hyperion Interactive Reporting reports/dashboards and Informatica PowerCenter ETL objects.
April 2005 to October 2006
Landata Inc. of CaliforniaGlendale, CAApplications Developer
Developed two-way electronic policy generating, delivery, and reporting system between Stewart and.
Countrywide, earned lead technology contact designation for Stewart and Countrywide application integration.
Designed and developed a series of accounting and management reports for Stewart Title of California using.