John Messer Email and Phone Number

- Manage department budget of over 2M USD - Manage a delivery team of 18 full time resources - Manage contract resources as required by capital projects- Responsible for usability of DA/DW systems with over 160TB of data- Responsible for all ERCOT Internal "Managed" data products and reports- Responsible for delivery of over 200 “Market” data products produced by ERCOT- Responsible for Business Intelligence and Data Management implementation at ERCOT

- Designed COGNOS departmental data security architecture- Designed infrastructure to leverage a 65TB Operational Data Store - Personally focused Nodal delivery of System Operations data products- Designed Data Access Methodology for ERCOT Data Assets via COGNOS - Designed Standard EIS product development lifecycle and control structure- Responsible for the architecture of Enterprise Business Intelligence platform - Designed 2 distinct Temporally Conformed Data Warehouses (Market /Corp)- Designed COGNOS User Role Licensing Methodology for Audit and Compliance- Designed auditing procedure for COGNOS Users to minimize annual licensing costs - Founding Member of the Austin Business Intelligence Leadership Forum (ABIL Forum)- Architected Load/Gen Resource Status Analytical Data Mart for Compliance Reporting- Lead Enterprise Data Warehouse (EDW) sub-project for the Texas Nodal Implementation - Conceptualized Solution, Component, and Product distinction for corporate communications

Worked with GE Blackbelts and Project Managers in the GE Security Division to provide design changes and enhance the GE Security Data Warehouse for fulfillment metrics and reporting. Non-Technical responsibilities included managing 2 development teams; one in Houston, Texas, and the other in Beijing, China for a 24 hour development cycle.

Served as a Sr. Business Intelligence Consultant to many medium to large companies, including:- Shell (Energy) - Enron (Energy)- ERCOT (Energy)- Amadeus (Travel)- EPA (Government)- Trizetto (Healthcare)- Cooper Industries (Manufacturing)- Cable Wireless Panama (Telecom)- Blue Cross Blue Shield of Michigan (Healthcare)

-Provided data entry services for linking product details and MSDS sheets at the SKU level to the 3M website- Redesigned the distributor rebate sytems for the Electrical Products Division (ELPD)