Resume
Hyperion Senior, DevelopeR
SUMMARY
- Total around 10 years of experience in Oracle EPM Suite applications.
- Strong knowledge in all phases of Software Development Life Cycle in BI domain.
- Experience in Implementation, Maintenance, Development, Enhancement, Migration, Support and performance tuning of Hyperion projects.
- Have strong Expertise and worked on Hyperion Essbase 9.x, 11.x, Oracle Hyperion Planning 9.x, 11.x, Oracle Master Data Management 9.x, Oracle Data Relationship Management 11.x.
- Worked extensively on reporting tools Smart View 9.x, 11.x, Oracle Hyperion Financial Reporting 9.x, 11.x and Essbase Excel Add - In.
- Have strong knowledge on designing and tuning Essbase BSO applications.
- Involved in automating the Essbase Cubes using MAXL, ESSCMD, MDX, Batch Scripts and Shell Scripts.
- Have extensive experience in Building and Optimizing Essbase ASO and writing MDX formulas, setting up Design Aggregations.
- Implemented and Maintained Security using Hyperion Shared Services.
- Worked on migration of Planning Hierarchies, Artifacts using Life Cycle Management (LCM).
- Created and maintained Planning applications through Classic and Enterprise Performance Management Architect (EPMA).
- Expertise in writing Business Logics using Essbase Calculation Scripts and Planning Calculation Manager Rules.
- Involved in creating and maintaining Versions, Hierarchies, Properties and exports in DRM tool.
- Familiar with Hyperion infrastructure maintenance activities.
- Exposure on FPA budgeting processes and have knowledge on Balance Sheet. Income Statement and Tax calculations.
- Involved in creating and maintaining Hyperion Financial Management (HFM) classic and EPMA applications.
- Worked with various type of rules in HFM like Consolidation, calculation, Translation, Allocations.
- Involved in configuring FDMEE with HFM applications and in creating mappings.
- Developed Dynamic reports to accommodate prompts as per user flexibility in HFR.
- Worked on Installation and Configuration of Oracle EPM 11 suite in Windows Environment.
- Experienced in creation of all development related documents (Design, Testing, Admin and Disaster Recovery).
- Involved in different testing phases like unit tests, System Integration Tests and User Acceptance Testing.
- Strong team player with excellent interpersonal and communication skills.
TECHNICAL SKILLS
OLAP and Hyperion Tools: Hyperion Essbase 7x, 9.x, 11x, Hyperion Planning 9x, 11.x, Hyperion Financial Reporting 9x, 11.x, Oracle Data Relationship Management (DRM), Hyperion Financial Management (HFM), Financial Data Quality Management Enterprise Edition(FDMEE), Workspace, Shared Services, EPMA, Smart view, Planning and Budgeting Cloud Service (PBCS) and Enterprise PBCS (EPBCS)ELT/ETL
Operating Systems: Windows, Unix
Scripting Languages: MAXL, MDX, Batch, Shell Scripting
Languages: SQL
PROFESSIONAL EXPERIENCE
Confidential
Hyperion Senior Developer
Responsibilities:
- Created Design Document and worked towards reviews and getting approvals.
- Involved in creating POC applications for Oracle Cloud PBCS and EPBCS modules in accordance with exisitng applications.
- Made necessary changes to Essbase Cubes as part of Cube Optimization.
- Involved in developing interfaces for data extraction and load into Essbase.
- Understood Business logics and created, modified, tested calculation scripts.
- Involved in Hyperion Planning development activites such as Webform, Calculation Manager Rules etc.
- Worked closely with FPA users for successful UAT.
- Created, modified Maxl scripts and batch jobs to automate the processes.
- Coordinated with Prodcution support team during the migration and Go-Live of the application.
- Assisting with Post Production support, until new enhancements/ develompent activies are finalized.
- Worked extensively on shared services for Security set up and User Management.
- Creating users and user groups in the planning application and assigned security to web forms.
- Developed and modified calculation scripts, business rules.
- Created complex webforms with Validation rules and adhoc grids.
- Involved in DRM application development for metadata.
- Initial setup of creating an application in FDMEE and integrating with HFM.
- Involved in FDMEE integatation for Data Load process setup.
- Using Extended Analytics, created an interface to load data from HFM to Essbase application.
Confidential
Hyperion Senior Developer
Responsibilities:
- Onsite Team Lead for CRE and EFS businesses.
- Meeting with Clients on a regular basis on Hyperion related enhancements, forecast related discussions.
- Designed Hyperion Planning Application Optimization.
- Hyperion related training to users, whenever necessary.
- Delegating tasks and closely working with off-shore teams.
- Working with alternate hierarchies in DRM per requirements and to push them into Hyperion.
- Creating, scheduling, Monitoring Automated Jobs.
- Supporting users during Month Close and financial closes issues
- Activities related to Forecasting and Budgeting per user instructions.
Confidential
Hyperion Consultant
Responsibilities:
- Successfully brought all the artifacts information together of Hyperion Applications including Hyperion Planning forms and HFR reports and their names by using LCM and Unix/Solaris environments, to determine the efforts to be put by the Development team in specific areas.
- Participated in gathering requirements.
- Worked on Requirement Traceability Matrix by financial tracks and documented requirements.
- Documented the Edit Checks and Validation Rules information in Planning Web forms.
- Documented existing data flows and calculations.
- Provide report of artifacts to be used /continued/removed in the new system from the existing system.
- Gathered existing Metadata being used in Calculation Scripts, Calculation Manager Rules and HFR reports.
- Worked on the new Metadata(aliases) by track, to be used per user inputs as part of requirement gathering.
- Was being part of creating new Metadata naming convention for FPA accounts.
- Part of developing HFM applications and Integrating with FDMEE mappings from Oracle EBS, to accommodate the source data across all segments of Confidential Company.
- Worked on Security setup and security classes for HFM applications.
- Created sample Financial Reports with formatting to show the HFR tools’ touch and feel in 11.1.2.4 version
Confidential
Hyperion Consultant
Responsibilities:
- Worked with Business users to gather functional requirements.
- Dimension Setup for EPMA HFM and Planning Applications - Metadata for Accounts, Entities and Custom Dimensions.
- FDMEE configuration for HFM applications
- Defined and managed Data Load Rules in FDMEE through Data Load workbench.
- Used Batch Processing by combining multiple load rules and scheduling the FDMEE load jobs.
- Configuration of HFM Application settings and Currencies.
- Security setup and security classes setup.
- Created HFM Webforms, Grids, and Solution advises.
- Involved in Creating HFM rules in Calculation Manager for Consolidation, calculating data and for translating currencies
- Development of complex Financial Reports with various reporting solutions.
Confidential
Hyperion Administrator
Responsibilities:
- Gathered requirements as part of enhancements.
- Delegated tasks to offshore team based on the requirements
- Creation and maintenance of complex web forms as per requirements.
- Used Validation Rules mechanism in Hyperion Planning web forms.
- Maintained and created Edit Checks related to 10-K, 10-Q reporting.
- Created and maintained Calculation Manager Rules and calculation scripts.
- Monitoring data loads, dimension builds, calculations, LCM migrations.
- Worked on Planning utilities like Outline load Util, Form Def Util Meu Def Util etc.
- Handled Hyperion Infrastructure related issues.
- Hyperion Services maintenance during regular outages, patches and DBA related outages.
- Timely interaction with Users in case of Hyperion related issues based on Priority and SLA.
- Created automation jobs to reduce Manual Intervention.
- Resolved data reconciliation issues.
- Quarter close readiness by performing activities like Application Backups, DRs, scheduling jobs.
Confidential
Hyperion Developer
Responsibilities:
- Involved in Gathering Business requirements.
- Designing and Building of the Planning cube.
- Worked on Interfaces in ODI for loading metadata into planning application.
- Created Automation Jobs to reduce Manual Intervention
- Validating the data with existing Retail Finance applications.
- Involved in designing the Security for the Applications.
- Resolved user issues in UAT phase
- Worked in Post Production Phase of the Project, post successful Go-Live
- Maintained web forms for user inputs on daily and weekly basis.
Confidential
Hyperion Developer
Responsibilities:
- Created Planning application as per user requirements.
- Created and executed metadata loads using ODI
- Creation and maintenance of data forms in Hyperion Planning
- Security Maintenance and updates using Shared Services.
- Maintenance and security filters on data forms in Hyperion Planning
Confidential
Hyperion Consultant
Responsibilities:
- Worked as Off-shore Team Lead and coordinated with the team for successful completion of Project.
- Involved in Gathering Business requirements.
- Designing and Building of the Planning cube. Finalizing the Planning Hierarchies.
- Worked on Interfaces in ODI for loading metadata into planning application.
- Validating the data with existing EFS applications.
- Created complex Web forms in Planning
- Involved in designing the Security for the Applications.
- Resolved user issues in UAT phase
- Worked in Post Production Phase of the Project, post successful Go-Live.
- Maintained Hierarchies through Oracle DRM.
