Principal Consultant Resume
DallaS
OBJECTIVE:
- Seeking a Hyperion Planning/Essbase Solution Architect/Consultant position where I can leverage my broad knowledge of Oracle Hyperion business intelligence, financial reporting, project management, and software development to lead /plan & support the analysis, architecture and development of Hyperion software solutions to answer business challenges.
PROFESSIONAL SUMMARY:
- Talented and accomplished IT professional having over 17 years of experience analyzing, designing, developing, implementing, tuning and supporting the Oracle Hyperion Suite of tools, including Hyperion Planning, Hyperion Essbase, FDM,HFM,DRM Hyperion Financial Reporting etc. .
- Expertise in Hyperion Planning cloud environment.
- Proven ability to direct and manage IT projects. Experienced in leading development and implementation of Hyperion Planning/Essbase systems. Expertise in complete project management, from conceptualization and requirements determination to design, development, final testing and implementation.
- Hands - on experience with various aspects of Hyperion project management: project planning, requirements gathering, scope management, change control, issue management, and risk mitigation
- Proficient in Hyperion Planning 9/11.x BI+, Hyperion Essbase 11.x,/9.x/7.x/6.x, Hyperion Reports, ESSCMD, MAXL, Essbase Smart View/Excel Add-In.
- Expertise in Partitioning, Calc Scripting, and dimension build, Data Load Rules, Tuning and Optimization.
- Expertise in creation and maintenance of Hyperion planning applications, business rules, web forms, security groups and users etc.
- Strong overall systems, business analysis, design skills and full life cycle implementation experience.
PROFESSIONAL EXPERIENCE:
Confidential
PRINCIPAL CONSULTANT
Responsibilities:
- Worked on requirement gathering for new Planning cube.
- Designed & developed new Planning application to handle budgeting process.
- Converted existing rigid HFM budgeting process to Hyperion Planning
- Reduce the currency calculation time in exiting HFM application from 1 day to 15 minutes in Hyperion Planning.
- Build Rollforward logic from HFM to Hyperion Planning.
- Developed quicker consolidation forecast result compared in Planning compared to HFM
Confidential
HYPERION MANAGER
Responsibilities:
- Involved in Sales cycle and RFP process on Essbase reporting side.
- Developed Functional & Technical Design Documents for Metadata/data interface between DRM/SAP and Hyperion Essbase ASO.
- Requirement analysis and gathering for their ASO reporting cube.
- Defining specifications for Federation between OBIEE Financial analytics and Essbase ASO.
- Leading the development effort for Essbase reporting cube with Confidential offshore Hyderabad.
Confidential -Dallas
HYPERION MANAGER
Responsibilities:
- Senior Hyperion Planning lead responsible for Requirement analysis and gathering for their Workforce/Capex cube.
- Implementation of Workforce/Capex in EPMA.
- Developed FDM load from flat file to Workforce.
- Created a budget and rolling forecast for Workforce & Capex.
- Involved during initial stage of Sale cycle process and POC for Confidential group.
Confidential
HYPERION MANAGER
Responsibilities:
- Lead the requirement analysis /gathering/Project Planning for their ASO cube that allows drill through capabilities for their GL data.
- Creating design document for ASO cube with Essbase studio as drill through from OBAW tables.
Confidential
HYPERION MANAGER
Responsibilities:
- Implemented Allocation logic for Income Statement cube.
Confidential
HYPERION MANAGER
Responsibilities:
- Implemented Business rule upgrade from 11.1.1.3 to 11.1.2.2
Confidential
HYPERION MANAGER
Responsibilities:
- Lead the requirement analysis and gathering for their Profitability reporting cube.
- Implementation of reporting solution in EPMA.
- Developed Automation to load from OFSAAA Tables.
Confidential
HYPERION MANAGER
Responsibilities:
- Senior Hyperion Planning Consultant responsible for requirements gathering, design, and development of reporting applications using Oracle Enterprise Performance Management System 11.1.2 in EPMA for a ASO reporting cube.
- Developed data integration for loading metadata for reporting ASO cube. EMPA flat files were used to load Meta data into EMPA Shared library/Application Library.
- Automated the data load for reporting from 9 different GL system using ODI.
- Developed interfaces in ODI to map various GL system accounts, Profit center, company code etc to Epicor 9 GL system.
Confidential, VIRGINIA
SENIOR CONSULTANT
Responsibilities:
- Optimized the several calc script to speed up the calc time from 62 min to 26 mins.
- Optimized Planning cubes design and optimized several reports for ANR.
Confidential
HYPERION SENIOR CONSULTANT
Responsibilities:
- Senior Hyperion Planning Consultant responsible for requirements gathering, design, and development of 4 applications for DAPLAN,CAPEX,WEEKLY,WORKFORCE using Oracle Enterprise Performance Management System 11.1.1.3 in EPMA.
- Designed and developed WEEKLY/WORKFORCE/ConP-ASO cube.
- Developed and automated data integration for loading metadata and data integration within various Planning cubes. EMPA flat files were used to load Meta data into EMPA Shared library.
- Developed customized web forms/Financial reports for all cubes.
- Subject matter expert for all queries related to Hyperion products.
- Provided external support for all Hyperion issues on as need basis.
- Mentoring and guiding Confidential business users on all Hyperion products.
- Provided technical leadership and mentoring, helping business users on the team less familiar with Hyperion System 9 to come up to speed to Oracle EPM 11.1.1.3 system
- Identify project risks, issues and avenues of mitigation on Hyperion Planning & Essbase.
- Worked closely with Oracle Product Assurance and Oracle developers to resolve bugs as they arose
Confidential
HYPERION SENIOR CONSULTANT
Responsibilities:
- Designed CorpPL cube on a different line of business i.e. Domestic / International /
- Developed customized web forms for all cubes.
- Assigned security for all business users as per requirement.
- Automated the entire process using ODI.
- Developed business rules for aggregation/data copy across different line of business.
- Provided Admin to ARC admins in Washington.
- Worked to design, build and implement a process to automate nightly processes relating to Essbase data loads and Hyperion nightly metadata updates
- Worked with Oracle On Demand team to set up DEV/Prod/TEST environment for Hyperion on Linux.
- Provided technical leadership and mentoring, helping those on the team less familiar with Hyperion System 9 to come up to speed.
ENVIRONMENT: Hyperion Essbase 11.1.1.3, Hyperion Planning 11.1.1.3, ODI, Hyperion Shared Services 11.1.3, Excel Hyperion Add-In.
Confidential
HYPERION SENIOR CONSULTANT
Responsibilities:
- Lead and designed Salary Application for Confidential using Classic Planning.
- Developed calculation for Benefits/Merit/SSN/Tax etc for all employees.
- Provided to end users in using the MS Excel spreadsheet add-in and the basic concepts of multidimensional databases.
- Developed customized web forms/business rules for all cubes.
- Implementation of robust data-access security and user management
- Automated the entire process using ODI.
ENVIRONMENT: Hyperion Essbase 9.3, Hyperion Planning 9.3, ODI, Hyperion Shared Services 11.1, Excel Hyperion Add-In.
Confidential, GA
HYPERION SENIOR CONSULTANT
Responsibilities:
- Designed Finance, Revenue and Capital expenditure (Capex) cube on a weekly basis.
- Automated the entire process using ODI.
- Developed calc scripts for depreciation and amortization for Capex cube including 52/53 weeks logic capability.
- Developed business logic and formulas for Balance sheet /Cash Flow in Finance cube.
ENVIRONMENT: Hyperion Essbase 9.3, Hyperion Planning 9.3, ODI, Hyperion Shared Services 9.3, Excel Hyperion Add-In.
Confidential, NC
HYPERION CONSULTANT
Responsibilities:
- Designed Finance, Workforce, balance sheet, Cash flow and Capital expenditure (Capex) cube as multicurrency application.
- Developed customized web forms for all cube along with the business rules.
- Developed calc scripts for depreciation and amortization for Capex cube on a monthly basis.
- Developed calc scripts for Workforce application including merit, benefits calculations etc.
ENVIRONMENT: Hyperion Essbase 9.3.1, Hyperion Planning 9.3.1, HAL 9, Hyperion Shared Services 9.3.1, Excel Add-In, SQL Server 2000, Windows, Hyperion Financial Reports 9.3.1, MS-Excel Spreadsheet Add-In.
Confidential, SC
HYPERION CONSULTANT
Responsibilities:
- Designed P&L, Workforce and Capital expenditure (Capex) cube.
- Automated the process of XREF which extracted the data from Capital expenditure and Workforce cube to P&L cube.
- Automated the entire process using HAL.
- Developed customized web forms for all cube along with the business rules.
- Developed various allocations calc scripts e.g. Admin, Property & Liability, Vehicle Insurance, Income tax etc.
- Converted the Hyperion Pillar application into Hyperion planning application.
- Developed calc scripts for depreciation and amortization for Capex cube
ENVIRONMENT: Hyperion Essbase 9.3.0, Hyperion Planning 9.3.0, HAL 9, Hyperion Shared Services 9.3.0, Excel Add-In, SQL Server 2000, Windows, Hyperion Financial Reports 9.3.0, MS-Excel Spreadsheet Add-In.
Confidential, WV
HYPERION CONSuLTANT
Responsibilities:
- Designed Income Statement and Balance sheet essbase cubes.
- Developed Hyperion business material.
- Developed and implemented project plan under tight deadline.
- Developed customized web forms for Income statement &Balance sheet with the business rules.
ENVIRONMENT: Hyperion Essbase 9x, Hyperion Planning 9.3.1, HAL 9, Hyperion Shared Services 9.3.1, Excel Add-In, SQL Server 2000, Windows, Hyperion Financial Reports 9.3.1, MS-Excel Spreadsheet Add-In
Confidential, Forth Worth, TX
ESSBASE CONSULTANT
Responsibilities:
- Developed enhancement for Hyperion Essbase application for corporate finance which included developing outline & data load rules, calculation scripts, and Maxl scripts for automated outline and data loading.
- Optimized outline, data load rules and calculation scripts, Manipulated data columns to suite dimension builds, tested data load rules, fixed errors from the error log files, resolved issues of data retrieve from excel.
ENVIRONMENT: Hyperion Administration 7.1, Essbase Analytics 9.0 (OLAP), Alphablox, JSP, Teradata, java script, CSS, Perl, UNIX, MKS, MDM 9.0
Confidential, San Jose, CA
Sr Consultant - Project / Technical leader
Responsibilities:
- Providing Support / Enhancement / Maintenance for Confidential ’s CA-Finance Application.
- Handling all security related issues for CA Finance in Essbase 6.1.5
- Controlling all security related (which are basically stored in Hyperion - OLAP database) issues for Ca-Finance Applications users of Confidential .