SUMMARY:

Expert in Financial Information Technology, Financial Management systems re - engineering, complete development life-cycle implementations, developing and clarifying organizational requirements, translating requirements into data and process designs. Coordinating Hyperion-related activities across the companies, and serving as primary liaison with stockholders from an IT and Finance standpoint. OLAP technical and project lead proficiency including: current state analysis, architect a solution, system upgrades, migrations, business assessments, and documents validations, parameterized, standardized, and ad-hoc financial reporting, implementation of redesigned reporting and planning processes, change management and training of client staff for a successful deployment of the new process and systems. Subject matter experts with Oracle/Hyperion toolset; Essbase and Planning, including, creation of cubes, building load scripts, building calculation scripts and making outline changes, and members formula calculation and performance tuning, definition key analytic services and business metrics and best practices.

AREAS OF EXPERTISE:

• Strong Hyperion Essbase Systems Architecture / Developer (Advanced skills level),
• Experience with Multiple Full Cycle Implementation of Version 11.1.2.3 / patches, user-training, end-user support.
• 12 Years Hyperion Essbase, Hyperion EPMA Planning, 20 Years of Financial Reporting and Detail Financial Analysis.
• BSO, ASO, calculations scripts, MDX, business rules and web forms.
• Administrating production and development environments, database maintenance, database backups, and performance optimization.
• EPMA, Essbase Studio, Smart view, Shared Service and Workspace.
• Develop business focused technical solutions for our end-users by work with the user community, which included detail business requirements, documentation and functional specifications.
• Excellent communication, presentation and interpersonal skills and end-users training.
• Working with all level of management both on the IT and Accounting, to understand and manage, departmentally and divisionally needs, which will align within the companies final objective.

PROFESSIONAL EXPERIENCE:

Senior Oracle Hyperion Essbase Developer

Confidential, Tampa FL

Responsibilities:

• Responsible for all Essbase development activity involving the Lawson to SAP conversation.
• Focused goal was to mirror the Lawson Essbase to using the new SAP Essbase System as the core source system, using Version 11.1.1.3 and 11.1.2.3
• This included reviewing the Lawson Essbase Application and working through those detail of the application, design and process, coming up with a detail process to mirror all process, with the new sources system which included; building new SQL queries using Hana studio for the building of the new dimensions and data loads
• Built, mirrored and updated, Rules files, Calc Scripts, Maxl Scripts, Attribute Dimension, UDA’s Flip’s and validates all financial templates
• Review and updated CFG system.
• Work through the detail of the upgrade from 11.1.1.3 to 11.1.2.3
• Sizing server
• Validating the process to using Essbase studio in the testing environment
• Mirrored the Production Environment with the Testing environment wrote detail Technical documentation, prepared and designed training documentation.

Senior Oracle Hyperion Essbase and Planning Support Consultant

Confidential

Responsibilities:

• Responsible for multiple activities within the Financial Analysis & Reporting Systems group.
• Responsible for the overnight validation of the Essbase, Planning and HPCM Application in the Production Environment
• Responsible for the updates of the Migration and Security changes within the DEV and QA environment.
• Input the changes with the system, and validating those detail changes before validating the updates to the Production Environment
• Responsible for the validation of the Development vs.QA Environments, Including All Planning and Essbase Objects Including, Outlines, Calc Scripts, Business Rules, Web Forms, Maxl Script, Report Scripts and Windows Batch Scripts.
• Responsible for the manual ADS files updates, and the validation of the Metadata change into the EPMA Planning application
• Responsible for the manual ADS files update and validation of the Metadata change into the EPMA Planning application
• Work with the system DBA to build a mirrored Instance of the Development Environment for TCS for testing
• Copying, Deploying and re-building Application for Planning, Essbase and HPCM in EPMA Environment.
• Update and validate Share library information, Updating and validation Application Library and Dimension Library, Data syncing and deploying update to application.
• Upgrading and re-designing the Bluebook project
• Responsible for all aspects of optimizations the Essbase Cubes
• Adjusting dense and sparse member
• Restructuring the data load and calculation scripts
• Results included load time from 47 minute for single month of actual data to 11 minutes for 24 month of actual and budget data
• Built a BSO to ASO cube for a user write-back ability
• Provided a transparent partition. validating data within the cube
• Wrote detail design documentation for the cubes being transferred from 9.3.1 to 11.1.2.1 system upgrade
• Prepared and designed training documentation
• Provided super-user and end-user Essbase Smart-view training
• Createda comprehensive detail user guide for Essbase smart version 11.1.2.1.
• Wrote system scripts for stress testing on new system.
• Lead on a team to mirror the write-back Essbase process for allocations, and then build a planning application for the business user to input allocations using web forms

Senior Oracle Hyperion Essbase Consultant

Confidential

Responsibilities:

• Responsible for all installations, Architecture, development, administration and end-user training of users for Hyperion Essbase 11.1.2.1. For the organization.
• Completely Responsible for all aspect of the Full Cycle Installation of the Hyperion Essbase Solution for OLAP Financial Reporting, to Mirror the existing JD Edwards Reporting process.
• Setup the Test, QA and Production Environment and validating the detail OBIEE SQL formats.
• Upgraded Essbase Server, Smart view and APS to 11.1.2.1.103
• Built financial reporting templates, and automated the daily hierarchy build and data load process.
• Worked on the team to Build, Design and produce test BI reports using OBIEE.

Senior Oracle Hyperion Essbase Consultant

Confidential, Miami, FL

Responsibilities:

• Responsible for all installation and development involving Hyperion Essbase 11.1.2. and above for the Testing and UAT environment, and had to mirror the product environment on all level with all parallel product.
• Interfaced with end-user on all intercompany support of Hyperion Products, Essbase and Financial Reporting Studio.
• Worked on Restructing the 3 Block storage cubes into a one(1) ASO Cube, included changing the automated loads, script and other detail processes for the new version of the Reporting cube.
• Managed and Develop the detail project plan, and on a weekly basis update Management of the progress of the project.

Senior Oracle Essbase Consultant

Confidential, Birmingham, AL

Responsibilities:

• Responsible for all development activity involving Hyperion Essbase 11.1.2 Company wide.
• Meet with the senior management stakeholders, business users and warehouse team, to converting business requirement into business applications for analysis and business reporting.
• Used Essbase Studio to build BSO and ASO Cubes application, Smartview for financial templating for business users.
• Developed DBA and end-user trainings sessions, to better manage and understand the company’s new policy on standardize reporting.
• Responsible for the 5 years of detail reconciliation and analysis of the source data from the warehouse to OBIEE, then to Hyperion Essbase, Designed prepared and distributed monthly operational and management results.
• Analyzed monthly financial results Revenue and P&L by Company, By Division, By Market and other Business segments.
• Managed the financial analysis and of the OBBIE Financial reporting structure, and validating the line by line financial ties to Hyperion Essbase.

Senior Oracle Hyperion Essbase Consultant

Confidential, Houston, TX

Responsibilities:

• Duties included providing technical and business support of Oracle Hyperion Essbase 7.1.6 and SAP Business Objects Data Integrator XI R2 operations, extracting financial and HR data from an SAP R/3 6.0 system to build financial and HR Oracle 10g data marts and build the financial multidimensional cubes in an OLAP database on a Sun Solaris server in UNIX environment.
• Review and building detail management, operational, funding and analysis reports using Crystal reports.
• Worked gathering business requirements and developing a business plan for financial applications for updating applications.
• Troubleshoot failed jobs to identify the source of the problem, modify Data Integrator jobs and UNIX scripts to resolve issues, and troubleshooting using Oracle SQL.
• Run processes to archive previous fiscal year data.
• Review process with BCM staff to grant end user access and permissions.
• Designing, Building, and maintaining multiple financial partitions cubes.

Oracle Planning Consultant

Confidential, Charlotte, NC

Responsibilities:

• Responsible for Hyperion Planning CWRENT Application Administration, Updated the UAT CWRENT Application. Validated The HAL, MaxL and Calculation Scripts, and wrote detail system documentations for all process involved.
• Maintain Hyperion Planning hierarchies and Essbase outlines.
• Developed business rules in Analytic Administration Services.
• Load hierarchies using Hyperion Application Link (HAL).
• Establish and maintain data validation checks and balances.
• Responsible for the month end closing and all validations from the bank source system to the planning application.

Sr Oracle Essbase Architecture/Development Consultant

Confidential, Manchester, NH

Responsibilities:

• Responsible for design architecture and implementation of Hyperion Essbase, which successfully addressed outstanding company strategic financial analysis, and budgeting reporting needs.
• Successfully completed a complete lifecycle implementation of Hyperion Essbase.
• Reviewed of companies needs, business level: data content, reporting needs, success measures, data sources, business logic requirements, business processes involved expectations, and assumptions.
• Project charter with stockholders, project goals, current state summary, key gaps, etc.
• Worked with directors for designing and building financial template for business unit owners, for actual and budget variance and detail analysis.
• Validated all Revenue and P&L Detail Data for 25 Grants within the organization.

Senior Oracle Hyperion Essbase Consultant

Confidential, Boca Raton, FL

Responsibilities:

• Engaged in a company-wide effort to implement a new budgeting, forecasting, and reporting application using Hyperion System 9 Essbase, Planning and HFM.
• Orchestrated and successfully completed the transition of critical reports converting all HFM financial versions 9 reports to Hyperion Essbase and Hyperion Reports Version 9.3.1.
• Optimized the reporting template structure, and validate all Detail P&L and Revenue for business units included Gross margin Details analysis
• Worked senior management on reporting to consolidate the Choicepoint merger to the Confidential Financials.
• Recommended opportunities for improvement in the report in Essbase and Planning.

Senior Oracle Essbase Architecture Consultant

Confidential, Hartford, Ct

Responsibilities:

• Worked on various Essbase processes and was responsible for requirement gathering and documentation, design, building, and developing architecture for the Essbase application, which translated clients needs in complex dimension build, dataload, calc script, and MaxL Scripts processes, for International and US Business Tax requirements based on the US tax Code 267(A)(3).
• Achieved all companies Accounting Reporting objectives by re-engineering more than 40 monthly, quarterly, and ad-hoc reports from a mainframe GLEMIS environment into Essbase System 9 using the Informatica, and preparing the financial reports using the Essbase Add-in and Smart View for office, web analysis using Lawson Data. Translated client reporting need into gathered reporting requirements from stockholders, reviewed existing reports, and documented all existing and new reports using MS Excel before Essbase report writing begins.
• Participated in biweekly meetings to review progress of the project and address issues.
• Replicated approximately 40 to 45 monthly, quarterly, yearly and ad hoc mainframe GLEMIS reports into Lawson Essbase reports.
• Verification of data between the new Essbase reports and the existing GLEMIS reports
• Documented all reporting retrievals.
• Created all training materials and delivered training to:
• Financial users on how to properly execute the new Essbase reports.
• Associates in the use of Essbase. Created a formalized and centralized storage location for all new Essbase reports and templates.
• Created a numbering system schema's to provide positive identification for each Essbase report and template to facilitate Sarbanes-Oxley financial audit

Essbase and Planning Consultant

Confidential, Newton, MA

Responsibilities:

• Formed and managed a six member team that reviewed, upgraded, and implemented the budget and forecasted the process using Hyperion Planning Version 3.5 from Pillar.
• Strategically managed the business processes, reengineered Hyperion cubes, updated written documentation, and all system changes in the migration and the upgrading for the implementation.
• Performed as Hyperion Enterprise Version 5.0 administrator backup. Used Informatica to convert the source data for Data Mata staging, PeopleSoft to verify the budget and actual financial results.
• Responsible for the technical, administration, and functional, day to day operation, which included; overseeing, maintenance and re-engineering of the companies Business Cubes-database/applications/test environments and live business cube, validated daily uploads, adjustments to hiarchery structure, calculation scripts, optimization.
• Managed and acted as the liaison for the business customer requests and functional transfer of system, and business knowledge to achieve user’s objective goal per organizational financial operational needs.
• Performed as a Design architecture manager and functional financial team leads for the Hyperion Planning Implementation.
• Planned and worked through the budget process.
• Defined Dimensions and member; Setup Periods Scenarios, Version, Entity and Account Dimensions; User-Define Attributes and member formulas, Import custom dimensions using HAL, Loading and Calculating the Database, Set-up Security and Rights, Design and Customizing data Web Forms, adjusting Business Rules and creating Task lists
• Built Template for Revenue, Expense, Capx, and Headcounts.
• Defined Dimensions and member; Setup Periods Scenarios, Version, Entity and Account Dimensions; User-Define Attributes and member formulas, Import custom dimensions using HAL, Loading and Calculating the Database, Set-up Security and Rights, Design and Customizing data Web Forms, adjusting Business Rules and creating Task lists
• Built Template for Revenue, Expense, Capx, and Headcounts.
• Created and modified Essbase outlines, built calculation scripts, and designed load rules.
• Responsible for the updating, debugging and creating of the rules for loading the data into the cube; this includes adjusting any error, such as invalid data and member fields into the outline and assuring the integrity of the data.
• Reviewed the calculation scripts, monitored and improved performance, by optimizing the dataloads.
• Approved the user set-up and security of the database.
• Developed and updated various financial models, analytical, and reports using Hyperion Enterprise.
• Worked with end users to produce the financial analyst reports.
• Assisted in the budgeting and forecasting processes; including training and assisting corporate and field level managers with their respective budget models. Performed as a functional financial team leads for the Hyperion Planning Implementation.