Data Warehouse

BENJAMIN SIMMONS

(********.*******@****.***)

Education: MBA in International Management – Univ. of Macau, China 1991

BBA with Education minor – Univ. of Texas, Austin 1972

Skill Set: Applications Development, Client/Server Modeling and IT Management

DEVELOPMENT: Data Warehousing: Informatica PowerCenter, Penaho PDI and Reporting, Cognos,

Crystal Reports and Business Objects

DBMS: DB2, SQLServer 2008, Teradata, DataAllegro, Oracle10g, Access

MODELING: ER Studio, ERWIN, 3D, DA Boot camp, Lombardi TeamWorks BPM,

Len Silverston’s Universal Data Models and Teradata’s FSLDM/MLDM

MANAGEMENT: SOA Sonic MQ and ESB. Requirements analysis, Project Lead & Staff Management.

Employment Highlights:

3/12 – 8/12 BUSINESS INTELLIGENCE PRODUCTS MANAGER – Consert, San Antonio, TexasDeveloped business and systems requirements for an enhanced, Kimbell-based data warehouse architecture along with marketability benefits, source data analysis and cost estimates.Defined BI product offerings serving the electric utilities smart metering market.Created relational and dimensional data models as well as ETL and report specifications to be utilizing in the development of Pentaho PDI ETL processes and Pentaho analytical reports.

5/11 – 2/12 CONSULTANT – Accenture, San Antonio Outsourcing Delivery Center

Lead a small team of 4 in assuming remote responsibility for a client data warehouse based on Oracle,

Open Source Pentaho ETL (Commercial version) and Cognos reporting.

01/09 – 4/11 DATA ARCHITECT – Southwest Business Corporation, San Antonio,TexasDefined architecture and build process for a new Inmon-based data warehouse focusing on insurance products and accounting systems. Profiled/documented data quality issues and assigned data stewards.Recommended and purchased ER/Studio and Len Silverston enterprise data models in support of a model-driven, Inmon style architecture. Simplified and adapted the standard enterprise models in the creation of 3NF logical and physical data models for finance, HR and sales data subject areas. Derived dimensional star schemas, a data aggregation strategy and associated source-to-target ETL specifications.

10/06 – 7/08 DATA ARCHITECT – Dell Inc., Round Rock TexasAssisted strategists in developing order attribution / marketing analysis of direct mail & email campaigns. Participated as DA representative on a data warehouse engagements & quick impacts sizing team. Provided data models and source mapping documents for several data warehouse projects such as Consumer Price Optimization, Spanish Queue, Affinity, SFDC, Subscription Center. Assisted with the initial implementation and change management of Dell’s 3NF enterprise data model based on Teradata’s Manufacturing Logical Data Model utilizing Informatica and Business Objects.

10/04 – 4/06 SENIOR CONSULTANT – BearingPoint, Austin TexasLead data architect for the implementation of an initial enterprise-wide financial data warehouse/Basel II datamart. Created the Data & ETL Architecture Reference document and guided RAD sessions between reporting, modeling, mapping and ETL teams. Web Systems Integration consultant for a web-based invoicing system sponsored by an international airline association. Provided enhancement implementation assistance, a strategic SWOT analysis (Strengths, Weaknesses, Opportunities and Threats) and preliminary SOA assessment. Siebel CRM data integration specialist and dimension management consultant supporting data warehouse consolidation. Created an inventory of merged source systems and associated reporting dimensions with emphasis on Siebel CRM as a new data source. Business process modeler supporting a TeamWorks-based prototype of a social welfare system for Iraq.

7/03 – 5/04 CONTRACT DATA MODELER / ANALYST – Capital One and CarMax, Glen Allen VirginiaCreated a financial performance management logical data model from data requirements analysis inputs using data structures from an existing enterprise data warehouse logical model, the Teradata financial services logical data model (FSLDM version 6), PeopleSoft GL/HR/EPM applications and other application models. Developed new and converted existing reports for CarMax Auto Finance utilizing ePortfolio web interface, Crystal Reports, DBArtisan, SQLServer stored procedures and Erwin. Source data analysis involved both relational and multidimensional/star schema data models in an evolving financial data warehouse environment.

2/02 – 5/03 DATA ARCHITECT – Southwest Airlines, Dallas Love FieldOracle datamart modeler and Ab Initio ETL graph developer supporting a Finance driven scorecard project containing departmental performance metrics for Maintenance, Ground Ops, Flight Ops and Inflight Reservations.Teradata data warehouse modeler for OLAP dimensional (star schema) passenger activity analysis and terabyte sized relational airline operational data store. Created prototype OLAP model supporting Cognos-based Revenue Management analytics.

4/01 – 10/01 DATA ARCHITECT – The Cobalt Group, Austin TexasRecommended and implemented database changes supporting auto dealership e-trading community using Rational Rose & Erwin modeling tools, TOAD, PLSQL and Oracle triggers/stored procedures for D/B Administration tasks. Data warehousing tools and enterprise reporting advisor. Assisted in the evaluation of ETL and enterprise reporting tools: Cognos/DecisionStream and MicroStrategy/Informatica as final vendor options.

2/00 – 3/01 PRINCIPAL CONSULTANT – Concero, Austin TexasPerformed requirements analysis, relational database modeling and ETL for website content management. Modeled e-commerce architectures using Erwin and provided database support for Vignette based content management solutions. Provided ETL functions for internal project using Vignette’s CAS product. Provided D/B and systems integration support for an energy trading application. Maintained Oracle Designer based model, created test data & data replication scripts using Oracle PLSQL, triggers and stored procedures. Built Oracle Discoverer prototype reports.

3/98 – 1/00 SENIOR SYSTEMS ANALYST – Texas Parks & Wildlife Dept., Austin TexasGuided teams in the development of agency-wide disaster recovery plan using SunGard’s CBR product. Data warehousing project coordinator, trainer and developer in the creation of Cognos catalogs and dimensional data cubes (using Transformer) and OLAP reports (using Impromptu and Powerplay). Data sourced from a terabyte Oracle Financials database.

Certification: Certified Business Intelligence Professional – CBIP Master Level 2010

References: Available on Request

Contact this candidate