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, which involved up to five people over 3 days, reducing the time to 1.5 hours. Converted 1300+ Hyperion EPM 11x reports from Informix to Oracle. Developed Impact Manager Scripts (JavaScript) to interrogate and modify Hyperion EPM 11 reports.Collaborative deliverables included; Strategy and planning, Roadmap development, deployment, and UAT. Collaborated with the Data Architect and USDA Branch SME’s, delivering a Business Program Enterprise Data Dictionary. Developed and maintained Informatica Mappings and Workflows for the Data Warehouse, Business Program dimension

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 documentation, as well as, document business process changes within the Global reporting organization. Analyzed and provided solutions for complex business problems.

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. Provided query performance guidance to the Data Architects, resulting in a 50% reduction in query processing times. Collaborated with the Data Architects, DBA’s and ETL Staff in the planning, development and deployment.

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 meetings and development in the migration of MicroStrategy 8x Consumer Complaint dashboards and reports to Hyperion System 9 for Health Markets. Provided guidance to the Data Architect in Data Mart dimensional modeling, resulting in more efficient report development and query times.Developed Dashboards and reports, utilizing Hyperion System 9 reporting, for Homeland Security. Collaborated with the Data Architect and ETL Developer in providing a more consumable and efficient reporting data model, resulting in a 50% reduction in reporting query and report development times. Additional Clients included: Toyota, Lexus, At&T, Hyperion, Carnival Cruise Lines, FiServ, Lennar Homes, Pioneer Resources, and Health Markets.

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 conversion and provided Business Analysts with the findings.Additional Clients included: Fidelity Investments and Liberty Mutual.

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. Installed and supported Brio One (Enterprise and Portal) software for Boeing. 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.

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 Decision Support, OLAP, and ETL product integration. Assisted the Engineering and Product divisions in the research, evaluation, and integration of potential DSS, OLAP, and ETL solutions into LifeTime. Other responsibilities include the research and acquisition of Data Mining Software Tools.

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 SUN Solaris, for the packaging division of one of the largest and oldest Beer Breweries in the US. These modules, written in SPL transported data between the front-end, developed with Express Objects and Oracle Relational and Express databases.Business and ETL analyst of a 6-member team responsible for delivering the first phase of a PL/SQL developer of a Demand Queue Data Warehouse for a Texas based, internationally known, semiconductor manufacturer. Interfaced with client staff at various levels and capacities. Worked directly with the Data Architect to ensure compliance of data relationships and business rules.Assistant Oracle “Boot Camp” Instructor for the Oracle Financial Analyzer class. Assisted students with instructional materials and lab assignments. Installed and configured NT 4.0 Server