PROFESSIONAL SUMMARY:

• Total around 12 years of professional experience with 4 years on Indian stock markets exposure and 8 years 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.
• 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), Workspace, Shared Services, EPMA, Smart view, Oracle Planning and Budgeting Cloud Service (PBCS)

ELT/ETL: Oracle Data Integrator (ODI 11x)

Operating Systems: Windows, Unix

Scripting Languages: MAXL, MDX, Batch, power shell and Shell Scripting

Languages: SQL

PROFESSIONAL EXPERIENCE:

Confidential, NYC

Senior Oracle EPM Hyperion Consultant

Responsibilities:

• Was part of requirement gathering meetings with Business.
• Was part of Design, Sizing, Scrum and retrospective meetings.
• Created brand new data source and classic Planning application.
• Manipulated the relational tables for dimensions per Business requirements.
• Worked with upstream systems like Revpro, Peoplesoft, CDR, Financial Force, Waterfall reports and Manual files to pull raw metadata and data.
• Applied transformations and created Interfaces in ODI to build dimensions and to load data into Planning application.
• Created forms and attached rules to the forms.
• Created Calculation Manager rules with Calc Manager Date functions to calculate Performance Obligation Revenues across years based different Business logics.
• Created Calculation Manager rules for Version-Off, FX Conversion and other Business requirements and Aggregations.
• Implemented end-end Security in both Planning and Reporting applications.
• Automated all the processes with ODI Scenarios, Maxl scripts, CalcMgrCmdLineLauncher.cmd Planning utility in Batches.
• Has setup Backup process to have latest backups for Essbase security file, artifacts and data until last 14 days.
• Facilitated users to run the batch scripts on ad-hoc basis through workspace.
• Created Interfaces in ODI to build dimensions and to load data into Reporting application from upstream systems and the Planning application.
• Worked on FX Conversion for prior year, current Year and Budget rates with MDX formulas.
• Worked on FX Modelling to check the impact of Forex revenues based on the FX rate changes.
• Created multiple workspace jobs to facilitate users to version-off (data copy) with in ASO application, Clearing user specific data, upload user files to ASO application with user variables.
• Created Unit Test results document, Low Level Design documents.
• Used LCM extensively for Essbase, Planning, Reporting and Analysis artifacts and Security migrations across environments.
• Assisted FP&A users with UAT and fixed UAT defects.

Environment: Hyperion Essbase 11.1.2.4, Planning 11.1.2.4, Oracle Data Integrator (ODI 11x), SQL, HSS, SmartView 11.x, Batch, Power shell scripting.

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 existing 11.1.2.4 applications.
• Created Dash boards in PBCS using 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 EPM Automate.
• Involved in Hyperion Planning development activities such as Webform, Calculation Manager Rules etc.
• Worked closely with FPA users for successful UAT for Essbase applications.
• 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.
• Helped with in DRM application development activities for metadata build.
• Using Extended Analytics, loaded data from HFM to Essbase application.
• Assisted with Post Production support.

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 - Lead

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.
• 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