Angela H. Hooper

**** * ******* ** ******, CO ***31 720-***-**** mobile abo2z1@r.postjobfree.com

Technical Skills Summary

Primary Development in: SQL, PL/SQL, TSQL

Database Administration: Oracle 8i-11g on Win/Linux/Unix, SQL Server

ETL & Data Modeling Tools: Cognos DataManager, Decision Stream, Cognos Framework Manager, Cognos Transformer.

Informatica, DataMirror, Oracle Warehouse Builder, SSIS

Reporting Tools: Cognos 8 & 10 BI, Impromptu, PowerPlay, Crystal Reports, Brio

Certifications:

IBM Certified Solution Expert Cognos BI 2011

IBM Cognos BI Professional, 2011

IBM Certified Designer Cognos 10 BI reports, 2011

IBM Certified Developer Cognos 10 BI Metadata Models, 2011

IBM Certified Developer Cognos 10 BI Data Warehouses, 2011

Training & Education

B.B.A., Management Information Systems, University of Notre Dame, 2002

Work Experience

Senior Business Intelligence Consultant Infolink Consulting September 2010 Present

Infolink Consulting specializes in providing solutions for information delivery and analysis that are as unique as the organizations

we serve. As a senior consultant, Angela provides a range of business intelligence services related to data integration, metadata

modeling, reporting and project planning. Her expertise includes Cognos 8 and 10 BI suite and BI Program Management.

Client work includes but not limited to:

Metropolitan State College of Denver, Technical training on Cognos 10 Metadata modeling and Query Studio.

University of Oregon, BI Program Management and technical lead on Campus wide reporting initiative with Cognos 10.

Wake Forest University, Data Modeler for Student and Admissions related areas using Cognos 8.4 Framework Manager.

Virginia Commonwealth University Health System, Data Manager ETL consulting, installation and training.

Manager of Business Intelligence Colorado Community College System November 2007 September 2010

Serving as both Manager and technical lead, Angela was responsible for developing BI best practices and delivery standards for

the Colorado Community College System (CCCS) .

Designed and implemented a Finance Transaction History Data mart sourcing the State of Colorado s COFRS financial

system and CCCS s ERP for the purpose of reconciliation reporting between the two chart of account structures.

Project Manager for implementation of SunGard Operational Data Store and Enterprise Data Warehouse. This solution

includes 66 new ODS reporting packages and 16 Cognos transformer cubes over four main business areas.

Facilitate user meetings, requirements gathering and project scope definitions while managing a team of four developers

and up to two contractors or consultants.

September 2005 November 2007

Oracle Database Administrator - Tyler Junior College

Responsibilities included support for Oracle and SQL Server database solutions and applications. Lead up to 5 team members on

application and web development projects as the technical lead.

Oracle administration included installing software, creating databases, performing upgrades and patches, managing the

database's storage structures, and schema objects, proactively monitoring the database's health and taking preventive or

corrective action as required, monitoring and tuning performance.

Performed upgrades, installs and patches as the Cognos8 BI administrator. Developed complex financials using Report

Studio and rolled out campus wide toolset and report training.

Extended the ODS and EDW Business Intelligence systems using Oracle Warehouse Builder for ETL processing and data

modeling with Cognos Framework Manager PL/SQL Stored Procedures.

Angela Hooper Resume - Page 1

March 2005 September 2005

Data and Reporting Senior Specialist - Merrill Lynch Capital

Part of a high performance team that provided analysis, reporting and data solutions to business partners and internal business

units. Day-to-day responsibilities included general maintenance and support of SQL Server data warehouse and data mart, ETL

issue investigation, and enhancements.

Primary developer for the Real Estate Capital Lending business u nits. Responsibilities included developing and tuning

ETL procedures using TSQL and DTS packages.

Complex report development using Cognos Report Net 1.1 and the Cognos SDK to burst reports to users and to integrate

a single sign on through the newly designed corporate intranet

March 2003 March 2005

Information Systems Analyst and Jr. Oracle DBA - Tempel Steel Company

Responsibilities included Oracle and SQL Server performance tuning and administration, enterprise wide operational and

analytical reporting, software and application life cycle development and testing.

Oracle administration included installing software, creating databases, performing upgrades and patches, managing the

database's storage structures, and schema objects. RMAN backups, catalog maintenance and creation, cloning and

recovery when necessary, proactively monitoring the database's health and taking preventive or corrective action as

required, monitoring and tuning performance

Lead developer and reporting project manager during ERP implementation in Toronto. Solution consisted of PL/SQL

stored procedures against highly normalized OLTP data structures with a Crystal Reports front end. Real time reporting

against Visual Manufacturing Lilly Software included financial statements, inventory balances, purchasing & ordering

reports, and production schedules

Cognos Impromptu report and catalog development for a time and leave data mart running on a SQL Server database

August 2002 February 2003

Enterprise Engineer - Headstrong Consulting

Entry level consultant providing support work under the Business Intelligence practice area. Assisted with business development

and RFPs. Project work included:

Worked with a team to provide analysis of a not -for-profit business model and design of a data warehouse system.

Identified the scope of the project and developed conceptual process and data models for the client. Managed the project

implementation plan, construct ed the physical data warehouse system, and developed the user interface.

Worked on a team that designed and implemented components for a Key Performance Indicators web site for a major

energy provider. Primary responsibilities included ASP .NET, and SQL Development on a MSSQL Server 2000

platform.

Developed a Balanced Scorecard System for a Regional Hospital. Created documentation and repo rting protocols for

KPI s. Evaluated Balanced Scorecard software packages such as PB Views, CoreVu, and others.

Primary QA tester for a Chemical Data Collection Application. Worked with client to develop test plans and

communicated issues with developers.

Professional Affiliations

TDWI Denver Chapter

CGHE - Rocky Mountain Region Cognos Users Group, Presenter and Facilitator 2009 - 2012

BUMS Banner Users of the Mountain States, Presenter 2008,2009

SETA SunGard Higher Education Technology Association, Presenter

Angela Hooper Resume - Page 2

Contact this candidate