Gary Mccool Email & Phone Number

Converted legacy Oracle Forms and Hyperion EPM reports to Oracle BI Publisher RTF Templates. Led the business analysis and maintenance of the Essbase Cubes, Calc. Scripts, and Hyperion EPM reports. Facilitated business analysis requirements and report development in the automation of a manual process of producing reports for budgeting and forecasting.

Remotely installed and configured the Health Center System application, successfully completed over 100 configurations for National and International clients. Represented MicroStrategy at the 2011 World Conference, communicating and illustrating the benefits of the Health Center System application.

Hyperion System 9 Administrator, providing 24/7 support to international clients.Remotely assisted International users in the development and troubleshooting of their reports.

Led the report development team in support of, Accenture’s Global Accounting and Finance Operational executives, global reporting. Analyzed, designed and developed the Financial Dashboards and Reports, utilizing Excel, VBA, SSIS and SQL Server to integrate SAP (BW) data extracts. Facilitated business requirement sessions.to produce Business Requirement.

Led the report development team, for Health Markets, utilizing Hyperion System 9. Projects included: Consumer Complaints, Claim Analytics, Out of Compliance, and Time of Service reporting and analytics. Responsible for the requirements gathering and documentation via JAD sessions, dashboard and report development, deployment, UAT and security access..

Assisted the VP of Engineering, in the R&D of integrating external technologies with Hyperion Technologies utilizing; Eclipse – BIRT and Pentaho. Developed object wrapper classes for the Hyperion reporting DOM to facilitate “RAPID” development of Hyperion dashboards, resulting in 75% decrease in development time.Facilitated and led the requirements.

Supported, developed, and migrated Brio BQY's for the Enterprise Data Warehouse, using Brio Enterprise 6x and Oracle 9i, for the Garter Group. Collaborated with Senior Business Analysts in the conversion and consolidation of existing Brio reports from a legacy Data Warehouse to a new Enterprise Data Warehouse. Also provided Data quality analysis during.

Installed Brio Enterprise for Tyco's International Flow Control land Valves company. This instance of Brio was driven by NxTrend software. Also, developed EIS dashboards utilizing JavaScript and SQL for Executives of the division.Developed Brio Enterprise EIS dashboards utilizing JavaScript and SQL to support the enterprise reporting needs for Level3..

Solely responsible for the research, acquisition, and integration of all real-time and static client data into LifeTime, a state driven, eCRM application. Provided technical guidance to Business Technical Analysts in Data Integration and Data Cleansing utilizing MS SQL Server and Data Junction. Member of the core Product Planning team providing guidance in.

Installed, configured and implemented an Oracle Express, Financial Analyzer, and GL-Link system for the financial division of an industry leading, Snack Food manufacturer. Resolved all Express and OFA technical issues. Provided AIX system tuning documentation prior to turning system over to operational staff.Developed Express Server modules, operating on.