PROFESSIONAL SUMMARY:

• Total around 9+ 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 subroutines 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.
• Knowledge on DRM and DRG work flows.
• 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.
• Formidable 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, Oracle Planning and Budgeting Cloud Service (PBCS) and Enterprise PBCS (EPBCS)

ELT/ETL: Oracle Data Integrator (ODI)

Operating Systems: Windows, Unix

Scripting Languages: MAXL, MDX, Batch, Shell Scripting

Languages: SQL

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Senior Oracle EPM /Hyperion Consultant

Responsibilities:

• Created Design Document and worked towards reviews and getting approvals.
• Involved in creating Oracle Cloud PBCS and EPBCS(Financials) applications in accordance with exisitng 11.1.2.4 applications.
• Created Dash boards in PBCS usings forms, FR Reports etc.
• POC for Valid Intersection in PBCS forms.
• Prepared new feature documents for PBCS for FP&A users for their ease of PBCS use.
• Have knowledge on the metadata management and data integration with PBCS.
• Automated tasks (metadata updates, data loads, import/export) using EPMAutomote.
• Created Calc manager rules in both PBCS and On-Premise Planning.
• Involved in Hyperion Planning development activites such as Webform, Calculation Manager Rules etc.
• Worked closely with FPA users for successful UAT for essbase applicaions.
• Developed and modified calculation scripts, business rules in Hyperion Essbase, Planning apps 11.1.2.4.
• Created complex webforms with Validation rules and adhoc grids.
• Involved in DRM application development for metadata build and automation.
• Using Extended Analytics, created an interface to load data from HFM to Essbase application.
• Assisting with Post Production support, until new enhancements/ development actives are finalized.

Environment: Hyperion Essbase 11.1.2.4, Planning 11.1.2.4, Data relationship Management (DRM), HFR, Oracle PBCS and EPBCS. SmartView 11.x, HSS, ODI

Confidential, Norwalk, CT

Senior Oracle Hyperion Consultant

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.

Environment: Hyperion Essbase 11.1.2.1, Planning 11.1.2.1, Hyperion Financial Reports, SmartView 11.x, HSS, ODI

Confidential, Fairfield, CT

Oracle EPM 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

Environment: Hyperion Essbase 11.1.2.4, Planning 11.1.2.4, Hyperion Financial Management (HFM) 11.1.2.4, FDMEE, Hyperion Financial Reports. SmartView 11.X, Hyperion Shared Services

Confidential, Plano, TX

Hyperion Consultant

Responsibilities:

• Worked with Business users to gather functional requirements.
• Dimension Setup for EPMA HFM and Planning Applications - Metadata build 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.
• Created HFM Webforms, Grids.
• Involved in EPMA Planning and Essbase application creation, metadata build, data load and Calculation Manager rules.
• Development of complex Financial Reports with various reporting solutions.

Environment: Oracle EPM suite, Hyperion Essbase 11.1.2.3, Planning 11.1.2.3, Hyperion Financial Management (HFM) 11.1.2.3, FDMEE, SmartView 11.x, HSS.

Confidential

Oracle EPM Hyperion Consultant

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.

Environment: Hyperion Essbase 11.1.2.1, Planning 11.1.2.1, Hyperion Financial Reports

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

Environment: Hyperion Essbase 11.1.1.3, Planning 11.1.1.3, Hyperion Financial Reports, HSS, Workspace, Smartview 11.1.1.3, ODI

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.

Environment: Hyperion Essbase 11.1.2, Planning 11.1.2, SmartView 11.x, ODI, HSS, Workspace

Confidential

Hyperion Administrator

Responsibilities:

• Worked with Business users on enhancements.
• Successful testing of enhancements and involved in deployment in Production post testing.
• Involved in discussions regarding Q’close and Plan Session activities.
• Created & maintained calc scripts and Business rules as per requirement.
• Worked with HAL for Planning Metadata updates.
• Monitored all the scheduled jobs, till successful completion.
• Created web forms in Planning as per the requirement.
• Set-up of new Plan Sessions every year.
• Data validation with GL daily.
• Resolved reconciliation issues, whenever required.

Environment: Hyperion Essbase 9.3.1, Planning 9.3.1, SmartView, HAL, Spread Sheet Add-In, HSS

Confidential

Developer

Responsibilities:

• Creating calc script for calculations on data in the cubes.
• Created and modified Dynamic Dimensions and optimal Data Loading.
• Executed Calculation Scripts and maintained Essbase optimization tuning.
• Administered user groups and privileges in Essbase.
• Developed and maintained automation for all data flowing into and out of the Hyperion Essbase cube architecture using ESSCMD.
• Performed troubleshooting, diagnoses, and solve all Hyperion Essbase related issues.
• Automated the processes using MAXL.
• Scheduling the jobs using windows batch scheduler.
• Developed the static reports using excel - add in.

Environment: Hyperion System 9, Hyperion Financial Reporting, Oracle 9i

Confidential

Developer

Responsibilities:

• Outline creation based on the requirement study.
• Created Load rules for data to move from Warehouse to Essbase cubes.
• Calc. Scripts creation for calculations on the data in the cubes
• Worked with Essbase-MaxL (multidimensional Access) Language to automate the tasks.
• Unit testing of the test-data.
• Preparation of Reports as per user requirement.

Environment: Hyperion - Essbase