Peter R. Haggard

214-***-****

Senior Business Intelligence Developer

PROFESSIONAL HISTORY

Director of Software Development

ROSEMONT REALTY October 2012 -

Present

. [pic] Rosemont Realty is a fully integrated market leader in commercial

property acquisition and asset management.

Functional Aspects

. Produced all business requirements and specifications for the creation of

a financial data-warehouse taking advantage of my fifteen years of

MicroStrategy experience using best practice design requirements and

architecting them into Rosemont's suite of applications.

. Developed Aging Receivables and Project Management Dashboards for Asset

Managers utilizing MicroStrategy Interactive Dashboards, Visualization

techniques.

. Implemented MicroStrategy 9 components: Architect, Desktop, Schema

Objects, MicroStrategy Administrator, OLAP Services, BI Developer Kit,

Intelligence Server, Object Manager, Report Services, Mobile and Web

after designing and creating Rosemont's Financial data-warehouse (RRDW).

. Utilized Advanced SQL skills to develop and maintain financial data load

scripts to populate RRDW data-warehouse and balance sheet tie-out scripts

for financial investor reporting.

. Developed RRDW MicroStrategy 9 grid and web document financial reports

for accounting to deliver to Rosemont Investors.

BI-REPORT & DASHBOARD DEVELOPER

DEPARTMENT OF HIGHER EDUCATION / CONTRACTOR September 2011 - October 2012

. [pic] The Department of Higher Education is a state agency that provides

independent research, guidance and recommendations on higher education

issues that impact the educational status of New Mexicans.

Functional Aspects

. Designing HEDW/P-20W data model and data-warehouse schema for NMHED

. Developing extract scripts using SQL to populate the HEDW data-warehouse.

. Architecting a HEDW MicroStrategy application using MicroStrategy

Architect, then designing, developing, and testing reports.

. Developing HEDW MicroStrategy grid and graph desktop and web reports for

the NMHED to analyze the enrollment data by institution and semester.

. Performing post-technical implementation review, fully analyzing each

phase of the project life cycle

BI-REPORT & DASHBOARD DEVELOPER

EMCORE / CONTRACTOR October 2010 - September

2011

. [pic] Emcore designs, manufactures and markets a broad portfolio of

compound semiconductor-based products for the broadband, fiber optic,

satellite and solar power markets.

Functional Aspects

. Business Objects 11 R2, Crystal Reports 11 R2/Administrator -Design,

Develop, and Administer BO and Crystal Reports Servers. Created standard

reports for clients using SQL views, SQL stored procedures, ODBC,

Scripts. Object Security and permissions. Data Warehouse.

. SQL(Cubes) Developer -Design, Develop, and Administer SQL(Cubes). Load

Cubes into IBM TM1 BI tool. Develop BI reports and dashboards.

. SQL Server 2000/2005/2008 -Migration (2000-2008) Table Maintenance,

constraints, keys, joins, creating views, CTE's, table variables, derived

tables, sub queries, stored procedures, system stored procedures and

views, scripts, normalization, Triggers, indexes.

. Systems Analyst -Acquire user requirements. Define System requirements.

Documentation (diagrams and flowcharts of processes). Recommend system

upgrades. Recommend new system software and hardware.

BI-REPORT & DASHBOARD DEVELOPER

SERCO / CONTRACTOR February 2010 -October

2010

. [pic] A leading provider of Defense and Health Care IT solutions. IHS

(Indian Health Services) provides Health Care IT solutions to Native

Americans.

Functional Aspects

. Created data-warehouse knowledge base for Indian Health Services (IHS)

Electronic Health Record (EHR) Certification project

. Designed EHR data model and built the warehouse schema.

. Architected a MicroStrategy EHR application using MicroStrategy

Architect, then designed, developed, and tested reports and dashboards.

. Developed EHR MicroStrategy grid and graph desktop, web reports and

dashboards for the IHS to analyze discharge and facility data.

BI-REPORT & DASHBOARD DEVELOPER

iOLAP / CONTRACTOR November 2009 - February

2010

. [pic] A leading provider of Business Intelligence solutions, iOLAP offers

enterprise data warehousing and web-deployed reporting and analysis.

Functional Aspects

. Developed Call Center data-warehouse BI reports for AT&T's national call

center

. Developed and implemented Call Center data-warehouse BI attributes and

metrics while at AT&T and collaborated on the design of the data model

and data-warehouse schema.

BI-REPORT & DASHBOARD DEVELOPER

NEW MEXICO - HEALTH POLICY COMMISSION May 2009 - November 2009

. [pic] The Health Policy Commission (HPC) is a state agency that provides

independent research, guidance and recommendations on health policy

issues that impact the health status of New Mexicans.

Functional Aspects

. Designed Hospital Inpatient Discharge Data (HIDD) data model and data-

warehouse schema.

. Designed and developed extract scripts using SQL to populate the HIDD

data-warehouse.

. Architected a HIDD MicroStrategy application using MicroStrategy

Architect, then designed, developed, and tested reports.

. Developed HIDD MicroStrategy grid and graph desktop and web reports for

the HPC to analyze the discharge data by diagnosis and procedures

incorporating 2009 ICD9 standard codes.

REPORT DEVELOPER / ANALYST

THORNBURG MORTGAGE April 2007 - June

2009

[pic] Thornburg Mortgage was a leading single-family residential mortgage

lender focused principally on prime and super-prime borrowers seeking jumbo

and super-jumbo adjustable-rate mortgages.

Functional Aspects

. Build and maintain complex SQL queries for Capital Markets financial

data analysis using SQL and Sybase T-SQL.

. Developed MicroStrategy Financial Application.

. Designed data model and built the warehouse schema.

. Designed and developed extract scripts using SQL to populate the

warehouse.

. Architected a MicroStrategy application using MicroStrategy Architect,

then designed, developed, and tested reports using MicroStrategy Agent.

. Created parameterized Crystal reports and customized existing reports for

presentations using Cross-Tab reports, sub-reports, Running Totals, and

Sorting

. Work with business stakeholders, application developers, and production

teams and across functional units to identify business needs and discuss

solution options.

BI-DEVELOPER - PRHCO May 2006 -

April 2007

[pic] Contract Database Developer providing reporting services for clients

in the Construction Industry.

Functional Aspects

. Designed data model and built the warehouse schema.

. Integrated the procurement application database with data Warehouse.

. Analyze data for the calculation of Availability, Allocation, Shipping

Performance, and Service Level

metrics as well as looks at historical performance for trends and

variances

. Installed, configured and employed the entire MicroStrategy Platform to

develop presentation-quality reports with a customized web interface.

BI-DEVELOPER - PULTE HOMES November 2003

- May 2006

[pic] Pulte Homes is one of the world's largest home building companies

building over 30,000 homes annually.

Functional Aspects

. Developed design and coded a design procurement application using LISP

and SQL for Operations that reduced material cost by $5000 per home

. Designed data model and built the warehouse schema.

. Designed and developed extract scripts using SQL to populate the

warehouse.

. Analyze data for the calculation of Availability, Allocation, Shipping

Performance, and Service Level

metrics as well as looks at historical performance for trends and

variances

BI DEVELOPER - PRHCO May 2001 - November 2003

[pic] Report Developer providing Business Intelligence reporting services

for clients.

Functional Aspects

. Designed and develop Business Intelligence projects and reports using

MicroStrategy and SQL

SENIOR REPORT DEVELOPER - MICROSTRATEGY

august 1999- May 2001

[pic] Microstrategy is a worldwide provider of intelligent eBusiness

software and related services.

Functional Aspects

. Implemented MicroStrategy in large scale operations - Finance, Telco's,

Retail, and Healthcare

. Responsible for managing and reporting the implementation of the client's

properties.

. Joined the Amex team to implement a four-tier business intelligence

solution for the travel services division of American Express. American

Express integrated MSTR Power User tools and MSTR Web to allow thin-

client reporting on an extremely large database exceeding one thousand

fields.

. Developed MicroStrategy and SQL reports for Amex to analyze the air

travel and hotel usage profiles of their corporate clients, with the

intention of using this information to better negotiate with their travel

vendors.

DATABASE DEVELOPER - KPMG PEAT MARWICK, LLP December 1998 - August

1999

[pic] Application Solutions division is an Oracle-based consulting firm

specializing in the development, customization and full implementation of

Oracle Suite products such as Oracle Financials, Oracle HR and other Oracle

products.

Functional Aspects

. Developed PL/SQL packages for Incident Tracking application for Project

Managers

. Implemented and maintained Oracle Web Server

. Developed reports via Oracle Reports/Forms

EDUCATIONAL HISTORY

UNIVERSITY OF TEXAS AT ARLINGTON - ARLINGTON, TX

1997

. Business / Management Information Systems (MIS)

SECURITY CLEARANCES

. Active Level 5 Security Clearance[pic][pic]

Contact this candidate