Manager Data Warehouse

Tony Bingham

Email: *********@********.***

Address: **** ********** **

City: Rowlett

State: TX

Zip: 75089

Country: USA

Phone: 972-***-****

Skill Level: Management

Salary Range: 150

Primary Skills/Experience:

See Resume

Educational Background:

See Resume

Job History / Details:

Data Warehouse Director

Goal oriented IT professional with diversified experience in operations, business support, finance, and Business Intelligence. Ability to multi-task in a fast paced environment. Excellent technical skills and extensive project management experience. PMP Certified. Effective communicator and problem solver.

Experience

Essilor USA - Dallas, TX

Leading manufacturer and wholesale distributor of optical lenses in the United States with annual revenue of $2 billion

Director of BI, October 2010 to Present

Responsible for all aspects of the Data Warehouse including Planning, Design, Development, and Implementation.

Data Warehouse Strategy and Direction - Directly responsible for developing strategic vision and presenting to C level executives to acquire funding for strategic initiatives. Created multiple presentations to executives to underscore the need to modernize and redesign the Data Warehouse as well as master data management of customer and product information. Funding for the EIM (Enterprise Information Management) program was approved and I am currently leading the technical implementation for all phases. Responsible for oversight of Conceptual, Logical, and Physical Data models for Customer Domain, Data Warehouse, and Product Domain. Leader for initiatives such as Data Virtualization and Big Data Analytics.

Project Management - Directly responsible for all Data Warehouse project implementations. Requirements gathering, project estimation, ongoing tracking, status reporting, etc. based on standard PMI methodology. Responsible for managing all Data Warehouse initiatives including working closely with business to determine requirements and obtain funding. Implemented A/R and GL modules for OBIEE 7.9.4 as well as upgrade to 7.9.6 in an Oracle on Demand environment. Responsible for all Planning including Chartering, Schedules, and management plans (communication, risk planning and mitigation, staffing plans etc.) Responsible for all Initiation activities including business case inclusive of business benefits, ROI, and TCO estimates. Monthly Executive Steering Committee updates.

Vendor Selection - Full life cycle including selection criteria, evaluations, selection and contract negotiations with system integrators and Tool vendors such as ETL, MDM, and Data Cleansing. Responsible for ongoing relationship management and tracking to milestones.

BI Manager, March 2007 to Oct 2010

Responsible for ongoing support and maintenance of Essilor`s Enterprise Data Warehouse and Business Intelligence reporting solutions.

* Responsible for all program management of Business Intelligence projects

* Kimball dimensional model star schema with dozens of source systems including Oracle EBS and customer applications. All legacy applications utilizing Genio/Open Text ETL. OBIEE with Informatica ETL.

* MQ Series Messaging for file movement from Legacy applications.

* HP Quality Center QA applications for load, performance, and regression testing

* PVCS for Oracle and Genio application version control

* Visual Source Safe for version control of all Microsoft code.

* .Net

* Business Objects environment including Crystal Reports, Webi and Deski reports

* Essbase and MSAS cubes with Cognos Executive Viewer

* OBIEE

* 9 TB`s Oracle 10G database across development, test, and Production utilizing monthly partitioning and aggregation for performance.

* Nightly back-ups and monthly refresh of test.

Software Spectrum - Plano, TX

Global Software Reseller with annual revenue of $3.1 billion

Data Warehouse Manager, February 2006 to March 2007

Lead BI Developer with 4 direct reports responsible for SQL Data Warehouse maintenance and ongoing development.

* Duties included leading projects, creating RFP`s, creating SOW`s, managing near shore and off-shore resources, performance reviews, tool selection, project closure.

* Day to day oversight of data loads from source systems to global data warehouse as well as ongoing development of infrastructure to support reporting. All ETL work including maintaining legacy DTS packages and conversion to SAP Data Integrator. Creation of star schema data marts to facilitate faster more integrated reporting from multiple source systems.

* Management of Business Objects Enterprise environment. Including Data Integrator servers for ETL work, Business Objects Enterprise Premium release 2 servers, test and development environments, and Crystal Reports XI user support.

* Creating views, stored procedures, star schema`s, business views, universes, summary tables, and OLAP cubes to support reporting.

Manager of Data Services January 2005 to January 2006

Led team of 22 people responsible for all aspects of data including part, customer, and vendor set-up as well as pricing and reporting

* In addition to all other duties stated previously as manager of pricing and reporting, I managed a team of 13 people responsible for setting up and maintaining 200k software parts, 2 individuals responsible for approving and maintaining over 30k active accounts, and 2 people responsible for setting up and maintaining 12k vendors.

* Worked to automate the loading of over 70 vendor price files. This allowed Spectrum to nearly double the number of managed vendors.

* Decreased turn-around times of for pricing and availability requests

* Developed process to include customers from partners in customer reporting

* Responsible for creating star schema data mart to support equivalent sales reporting from transactions process outside internal systems. Created RFP and worked with on-shore consulting firm to architect, design and implement.

Manager of Pricing and Reporting April 1999 to December 2005

Led team of 5 individuals responsible for providing reports and price files to vendors, customers, and sales management

* Received Star Performer award during Spectrum`s acquisition by Level3 and merger with Corporate Software for work completed to merge systems, data and accounts for two, $1 billion dollar companies.

* Performed in-depth comparative /ROI analysis used to assist executives in strategic planning and business improvement initiatives.

* Led process improvement team to identify broken and inefficient processes.

* Led development of customer reporting on the web which reduced non-web requests by 30%

* Key Member of Project NorthStar, which was responsible for developing the standards and goals by which Spectrum`s electronic commerce offering would be evaluated.

* Created and maintained dozens of B2B catalog solutions for Ariba, Trade Ranger, PeopleSoft etc. as well as customers home grown solutions.

* Led several initiatives to cleanse data and add B2B content such as long descriptions, box shots, tech notes etc.

Finance Manager May 1996 to March 1999

* Responsible for creation of all templates and monthly schedule of summary invoicing using InfoMaker

* Creation of monthly financial package for Credit Department.

* Created aging reports so credit reps could create ad-hoc statements for customers

* Worked extensively to convert financial system to Smart Stream in 1999.

* Responsible for training program for all credit reps on the new system

Education

University of Texas Dallas - Richardson, TX

BBA, Economics and Finance 1989

Crystal Reports Certification

PMP Certification

Advanced Computer Skills

* Crystal Reports 8.5, 9.0, XI

* Business Objects Enterprise XI R3

* Business Objects Data Integrator

* MS SQL Server 2000/2005

* MS Reporting Services

* MS SQL Server Analysis Services

* Toad

* Trillium

* Erwin Data Modeler

* Microsoft Office

* Microsoft Project Professional

* SharePoint

* Informatica

* SQL Analyzer

* OBIEE 7.9.4/7.9.6.1

Contact this candidate