Gerard Gibney Email & Phone Number

Los Angeles, Ca, Us

Costa Mesa, Ca, Us

►Responsible for the delivery of all phases of PBCS, NSPB (NetSuite Planning and Budgeting), Hyperion Essbase and Planning Application development lifecycle, from requirements gathering, technical design, application development, testing, implementation, training and support.►Delivered Business Requirements document to client for sign off. Gathered business requirements through meetings, workshops and analysis of existing systems.►Delivered Application Design Document to client for sign off. Application design was conducted through a series of design sessions of the development team using the Business Requirements document as the guiding document.►Led and developed technical solution and delivered unit tested application to client.►Organized and Led UAT (User Acceptance Testing) of application. Resolved any defects discovered in testing and obtained final sign off on UAT scripts from testers. ►Responsible for delivery of final solution to client.►Provided post go live support and training if required by client.►Technologies and Skills - PBCS - NSPB (NetSuite Planning and Budgeting) - Oracle Hyperion Essbase - Oracle Hyperion Planning - Hyperion Financial Reporting - Hyperion Smartview - Essbase Studio - EPMA - FDM and FDMEE - ODI - MDX - ePBCS - FCCS - OAC - ESSCS

Los Angeles, Ca, Us

Provided technical architecture and functional advice. Delivered two major projects:ODI EPM System Automation:► This multi-phased project involved converting and enhancing existing automation batch script/MaxL to utilizing ODI as the process orchestration tool.► The major benefits of using ODI is enhanced functionality (such as data validation and email notification) and less maintenance.Transfer Pricing and FX Impact Project:► The TP Component of the solution allows for the correct calculation of transfer profit between controlled legal entities within an enterprise.► The FX Impact Component of the solution calculates the net gain (or loss) due to currency fluctuations within the business.► Managed the full life cycle of the solution (Requirements Gathering, Design, Development, Testing and Parallel Go Live)The solution was delivered utilizing the following technologies:Oracle DBSQL ServerODIHyperion PlanningHyperion Essbase (BSO & ASO)Hyperion Financial Reports

Delano, Ca, Us

This budget and forecasting solution for Paramount Citrus was a multi-phase implementation of Hyperion Planning. Their business environment is very dynamic due to large acquisitions and fundamental changes in how they run their business. The solution needed to be as flexible as possible to accommodate these changes and minimize the cost of the changes and additions.Each phase delivered the following:► Conducted requirements gathering and delivered a business requirements documents► Performed design sessions and delivered a design document► Development delivered: Phase 1 developed base applications for Income Statement, Capex, Workforce and Crop Cost Phase 2 enhanced all base applications for additional businesses Phase 3 support all applications for first budget. Automate Balance Sheet and Cashflow. ► Develop 5 Year Plan solution. ► Delivered signed off UAT scripts from testers and resolution of all issues identified during testing.► Delivered system admin guide► Trained system administrators on use and maintenance of system

Sherman Oaks, Ca, Us

The reporting solution for Prospect Mortgage was delivered using Data Marts, Hyperion Essbase Studio, Hyperion Essbase, SmartView and Financial Reporting.Prospect Mortgage has a dynamic reporting environment with existing reports changing frequently and the additional reporting requirements for SEC compliance. In order to deliver the solution in a rapid and cost efficient manner, an agile development approach was used with weekly releases of new reports and functionality.Reports were delivered under the following categories:► Internal Income Statement► Internal Balance Sheet► Internal Cashflow► SEC Income Statement► SEC Balance Sheet► SEC Cashflow► Product/Operational Reporting

Irving, Texas, Us

► Delivered business requirement document ► Delivered a detailed application design document.► The final solution that was developed and delivered composed of 5 planning databases, 6 Essbase BSO databases and 6 Essbase ASO databases. ► The Data Flow process that was developed flowed from the Planning to BSO to ASO databases using a combination of Essbase Export calculation scripts and Essbase replicate partitions.► The loading of Actuals data and employee data from SAP was developed using Essbase SQL Load Rules► Developed Essbase calcation scripts and calculation rules for complex calculations.► Developed MaxL scripts in combination with ODI to automate data loads on a daily, weekly and monthly basis.► Data remapping procedures were developed using a combination of ODI and Server SQL tables.► Metadata manual and automated update procedures were built using ODI from the SQL Server tables► Over 30+ reports were developed using Hyperion Financial Reporting suite and additional 30+ reports were developed using SmartView.► Delivered signed off UAT scripts from testers and resolution of all issues identified during testing.► Trained system administrators on use and maintenance of system► Provided 3rd level support for applications post go-live.► The development methodology was a combination of Agile development combined with the traditional Waterfall approach. ► The final solution enable 200+ users spread geographically throughout the world to perform monthly forecasting and annual planning.► This solution was the Winner of the 2012 Oracle EPM Titan award.

Newport Beach, Ca, Us

Solution Architect for all applications developed. Ensured that all deliverables at each stage of the development lifecycle are met. This includes leading requirements gathering, design, development, testing, go live and support. The solutions were focused on the areas of life insurance modeling, budgeting and forecasting, actuals, source of earnings and divisional expenses reporting. Provided advisory services for the upcoming data warehouse initiative and developed a number of Essbase Studio pilots to help the data warehouse team understand the potential of the technology.

San Jose, Ca, Us

Developed complete budgeting/forecasting solution that included Revenue, Capital Expenditure, Operational Expenses and Workforce Planning, along with cost center and profit center allocations. Primary responsibilities included implementation of Workforce Planning and Capex modules as well as co-development of global allocation model supporting shared service chargeback and product profitability.

Santa Monica, California, Us

Developed product planning application implementation for Activision. Developed a forecasting model that leverages a series of business rules, forms, and defined security roles required to define the business process: calculated and allocated product development, royalty, and all other variable costs across the life cycle of Product lines. Calculated revenue based on user input assumptions and amortized costs, using business rules to match revenue and related costs. Provided cash flow analysis and accrual based financial reports to aid in the planning of key product releases for Activision. Integrated business process into the reporting application utilizing custom Forms, defined security roles, and process management.

Molesworth Street , Dublin 2, Ie

Lead Developer during the Prototyping, Develpoment, Testing and Implementation phases. Responsible for the following:► Developing Applications per the Technical Specifications delivered in the previous phase.► Developed application utilizing Hyperion System 9 BI Suite. This included using AIS to build the Essbase Applications via a Teradata Data Mart. The Essbase applications include both BSO and ASO storage options due to the complex business requirements.► Developed nightly automation routines using a combination of Essbase proprietary automation languages Ess Command and MaxL and UNIX scripts. ► Working with the Data Warehousing team and the ETL team to ensure that the Data Mart meet all of our requirements and troubleshooting issues. The data warehousing technology used is Teradata and the ETL tool Ab Initio.► Reporting for the applications is done using the following tools: Hyperion Financial Reporting Hyperion Interactive Reporting (Brio) Hyperion Essbase Excel Add-In► During Testing responsible for prioritizing issues and bugs found in the applications. Working closely with the testers to ensure all issues are resolved.

Aliso Viejo, Ca, Us

QLogic Inc.: Hyperion Planning Data Remapping Solution

Toyota City, Aichi Prefecture, Jp

Mclean, Va, Us

Freddie Mac: Developed Hyperion Essbase ASO Solution

Atlanta, Georgia, Us

Turner Broadcasting: HFM implementation using HFM 4.0.1 Turner Broadcasting: Hyperion Planning implementation using Hyperion Planning 3.5.1

London, England, Gb

BP/Arco: Multiple Essbase Applications

Postgraduate Diploma, Internet Systems Development

Bachelor'S Degree, Finance