Development Technical Support

SUMMARY Mr. McCool specializes in analyzing, designing, and developing

Business Intelligence solutions across the nation. The skills and

technologies he has acquired make him a very capable candidate for key

roles in, Business Intelligence, Data Warehousing, and OLAP. He

currently possesses "Confidential" US Government Clearance.

PROFESSIONAL EXPERIENCE

Independent Designed and Developed BQY Dashboards and Reports for the USDA. Lead

Contractor Developer on the successful conversion and re-hosting of 1300+ BQYs

Keller, TX from Informix to Oracle using Oracle EPM 11x Utilized and developed

6/2011 - Impact Manger Scripts to interrogate and modify EPM Workspace objects

present as part of this effort.

Sr. BI Additional duties included, but not limited to; Migrating BQYs to

Consultant OBIEE's BI Publisher, Developing and Maintaining Informatica Mapping

and Workflows, and Business Analysis.

Microstrateg Assigned to the MicroStrategy Technical Support Department as the lead

y Support Engineer assisting National and Global customers in the

Keller, TX configuration of the Health Center System application, completing over

10/2010 - 100 configurations. Represented the MicroStrategy Technical Support

6/2011 Department at MicroStrategy

Sr. BI World 2011, in support of the Health Center System application. In

Consultant addition, designed and developed Dashboards for a large GPO Healthcare

organization utilizing MSTR 9.01.

Independent System 9 BQY Developer and Administrator for a Global Electronics

Contractor Semiconductor corporation, supporting Hyperion System 9 running on Red

Keller, TX Hat LINUX. Additional duties included, but not limited to:

2/2008 - Tuning and Troubleshooting of System 9 services.

10/2010 Monitoring System 9 Services and Users' IR Jobs, providing 24/7

Sr. BI support to International Clients.

Consultant Remotely assist International users in the development and

troubleshooting of their BQY's and IR Jobs.

Responsible for the mentoring of the internal Technical Support Staff

on System 9 concepts as well as BQY Development.

Developed Financial Dashboards and Reports for a Big 6 consulting

firms' Global Accounting and Finance Operations utilizing Excel, VB,

SSIS and SQL Server 2008. Responsible for the analysis, design, and

development of reports meeting executive needs.

Lead report developer for Hyperion System 9.2 Interactive Reporting

for a privately held Health Insurance provider. Projects include;

Consumer Complaints, Claim Analytics, Out of Compliance, and Time of

Service. Accountability includes reporting/analytical deliverables, as

well as providing guidance to the Data Architects regarding Data

Modeling and structures that can be easily consumed by End Users. Also

providing "As Needed" Reporting/Dashboards against the Clarity Project

Tracking System. Additional duties include; Creating BQY Templates

(Dashboards and supporting JavaScript methods) that can be consumed by

other developers. (This has lead to a 30% reduction in development

time), Mentoring the Development Team in BQY Coding and Architecture

"Best Practices", Assisting the System 9 Administrator in JOB and BQY

error resolution, as well as Requirements Liaison between the Data

Architects, ETL Developers and the End Users

OSI Assisted 1Answer Solutions VP of Engineering with R&D of internal and

Consulting external technologies. Technologies included, Eclipse - BIRT and

(formally Pentaho. IN addition, developed object wrapper classes for the BQY DOM

1Answer to help facilitate "RAPID" BQY development and maintenance.

Solutions)

Keller, TX Remotely assisted 1Answer Solutions field consultants with BQY design

7/2006 - and development, SQL, and Business Analysis.

2/2008

Sr. Supported the migration of a Brio 6.6 system to Hyperion 9.2 for one

Principal. of the largest Cruise Line companies in the world.

Business

Intelligence Mentored multiple developers in a classroom environment using Hyperion

Consultant 8.x regarding the Development and Best Practices of BQY development

for one of America's largest Home Builders.

Resolved System 9 installation issues for one of the largest

international Real Estate Banks in the world. Also performed training

in BQY/JavaScript development.

Lead report development team in the design and development of Hyperion

System 9 BQYs for a privately held Health Insurance provider. This

effort was centered on the conversion of existing "Consumer Complaint"

reports away from MicroStrategy 8x to Hyperion System 9. Duties also

included assisting the Data Architect with Data Mart dimensional

modeling.

Developed "Answers" and Dashboards utilizing OBIEE 10x for an

Environmental company based in Edmonton Canada.

Developed Dashboards utilizing Hyperion System 9.3.1 for the

Immigration and Customs Enforcement (ICE) division of Homeland

Security.

1Answer Designed, Developed, and Managed the creation of a "Report Wizard"

Solutions Dashboard utilizing HPSu 8x, Oracle 9x, and MS Windows 2003 Server

Irving, TX for one of the most prominent Banking and Financial Institution

7/2004 providers of a packaged Financial Data Warehouse. The Report Wizard

-3/2006 guides new Hyperion as well as Data Warehouse users through the basics

Sr. of developing a BQY Document that includes Query selection, Limit

Principal. selection, Report construction and finally the creation of Charts and

Business Pivots. The final step of the Report Wizard exports all the technical

Intelligence details to a Formatted Excel Spreadsheet for auditing purposes.

Consultant

Developed the reporting system utilizing custom SQL and Dashboards for

the Warranty division of the same car manufacturer listed below for

their Data Warehouse. Project utilized Solaris OS, HPSu 8.2, and

Oracle 9.x.

Supported the ground floor development of a Data Mart for one the

largest, premium Japanese Car Manufactures in the world. Supported the

discovery of data sources, supported the creation of the Data

Structures, as well as the reports. Reports included initial Dashboard

Development and Design. Utilized Hyperion Performance Suite 8x, Oracle

9i, and Essbase 6.5.

Instructor, on behalf of Hyperion Corp. to one of the original Ma Bell

companies R&D center for the use and advanced JavaScript development

of Hyperion Intelligence Client, using Hyperion Performance Suite 8x.

Independent Supported, developed, and migrated Brio BQY's for the Enterprise Data

Contractor Warehouse, using Brio Enterprise 6x and Oracle 9i, of a Pioneering

Irving, TX Consulting Group that is the leading provider of research and analysis

1/2002 - on the global IT industry.

7/2004

Worked with Senior Business Analyst's as well as Business Intelligence

Analysts in the conversion and consolidation of existing Brio queries

from legacy Data Warehouse over to a new Enterprise Data Warehouse.

Also provided Data quality analysis during conversion and provided

Business Analysts with the findings.

Provided on-site support to the internal, enterprise systems

development team of a Big 6 IT consulting company of their Enterprise

Data Warehouse, using Windows 2000 servers, SQL Server 2000, and

BrioOne 7x. Utilized various Brio and MS Windows technologies in the

development and delivery of Capital Reporting Corporate Scorecards,

distributed worldwide. Technologies included, JavaScript, SQL, JOOLE,

OLE, VBScript, Jscript, HTML, Windows Scripting Host (WSH) and Windows

Management Instrumentation (WMI). Provided guidance and training to

client's development staff in the areas of JavaScript application

design and development. Also providing performance and tuning

guidance on MS SQL Server and SQL queries.

Brio Installed Brio Enterprise for a large International Flow Control land

Technology Valves company. This instance of Brio was driven by NxTrend software.

Irving, TX Also, developed EIS dashboards utilizing JavaScript and SQL for

2/2001-11/20 Executives of the division.

01

Business Developed Brio Enterprise EIS dashboards utilizing JavaScript and SQL

Intelligence to support the enterprise reporting needs of a large, Western region

Consultant telecommunications company.

Provided onsite Brio Enterprise support to a large Central region

Telecommunications company, in the areas of, EIS development,

JavaScript and SQL.

Installed and supported BrioOne (Enterprise and Portal) software for

one of the largest International Aircraft manufactures. Also developed

EIS dashboards utilizing JavaScript and SQL.

Provided remote technical support to Brio's Technical Support

Division, resolving advanced JavaScript and Brio Enterprise technical

issues.

Verbind, Inc Lexington, MA 1999 - 2001

Senior CRM Consultant

Oracle Corporation Irving, TX 1998 - 1999

Principal Business Intelligence Consultant

Various Companies Dallas, TX 1987 - 1998

C/C++ Software Engineer

CAPABILITIES

Technolog Software, Tools & Languages

y

JavaScript, VBA, Jscript, VBScript, ADO, OLE, JOOLE, Regular Expressions,

Windows Scripting Host (WSH), Windows Management Instrumentation (WMI), C,

and C++.

Business Intelligence

Oracle EPM 11x.

Brio/Hyperion: System 9x, 8x, 6x, BrioOne.

Oracle BI Publisher

MicroStrategy 9x (Certified MCE)

ETL

Informatica Power Center 9x

Operating Systems

UNIX: Solaris, HPUX, AIX; LINUX, Windows

Databases

Oracle RDBMS 9x, 10x, 11x

MS SQL Server 2005, 2008

Other

Knowledge of Microsoft SSRS and SSIS

HONORS

Speaking Hyperion World Conference - 2007

Selected as a Speaker in a "Tips and Tricks from the Masters" two part

presentation as one of the seven panelist. Personal Topic pertains to

"Object Aware Methods".

Hyperion World Conference - 2006

Selected as a Speaker in a "Tips and Tricks from the Masters" presentation

as one of the five panelist. Personal Topic pertained to "Prototyping - A

Functional Evolution".

Hyperion World Conference - 2005

Selected by Hyperion to be a primary speaker to present on the topic of

utilizing ActiveX and Windows Scripting Technologies as part of an

Hyperion Interactive Reporting solution.

EDUCATION

Education 11/1987 - Oklahoma City University

Bachelor of Science - Magna Cum Laude

Major: Computer Science Minor: Finance

08/1983 - Oklahoma State University

Associates of Arts - w/ Honors

Major: Programming

Technical

Training 2013 - Informatica University - PowerCenter 9x Developer

2012 - Oracle University - OBIEE's BI Publisher 11x

2010 - MicroStrategy University - MicroStrategy 9x

(Certified MCE)

Contact this candidate