SUMMARY

• Experience in design, analysis, development and implementation of various applications in client/server environment using Hyperion Essbase/ Planning 11.1.2.4, 11.1.2.3, 11.1.2.2, 11.1.1.3, 9.3.1, 7.x
• Involved in multiple full cycle implementation of Planning and Essbase applications.
• Expertise in Oracle PBCS and EPBCS
• Extensive Experience in working with various Hyperion products such as Hyperion Planning, Essbase, Financial Reporting, Shared Services, Essbase Studio, HFM and FDMEE.
• Expertise in creating data flow models from source systems to EPM and from EPM to various reporting systems.
• Worked with ERP Systems like Oracle E - Business Suite, Peoplesoft and JD Edwards
• Expertise in the upgrade, patching,installation and configuration of EPM product suite.
• Expertise in backup and restore strategies and developing Disaster Recovery systems.
• Expertise in buildingFinancial Budgeting and Forecasting OLAP applications with Hyperion planning including Fin Stat, workforce and Capex.
• Expertise in development of custom business rules, calculation scripts, rule files and reports.
• Expertise in creation and maintenance of numerous Essbase applications leveraging both BSO and ASO technologies.
• Expertise in automating the Essbase cube operations using MaxL, ESSCMD.
• In depth Knowledge of Oracle Data Integrator (ODI)
• Expertise in batch scheduling the MaxL scripts using CONTROL-M software.
• Proficiency in both Star Schema and Snow-Flake Schema data modeling techniques.
• Hands-on expertise creating reports usingEssbaseExcel Add-In and SmartView Add-In.
• Proficient in batch scripting,UNIX Shell scripting, Excel VBA coding,PL/SQL scripting, software installation, application and data back-ups, security
• Hands on experience in integration OBIEE with EPM products.
• Supported over 400 users across the globe.
• Excellent client relation skills and the drive to complete tasks effectively and efficiently where customer services and technical skills are demanded as well as the ability to communicate effectively with all levels of management and the client community.
• Good Team player possessing excellent communicational skills, motivated and ability to quickly adapt and work under minimal supervision.

PROFESSIONAL EXPERIENCE

PBCS/EPM Developer/ Administrator

Confidential, McLean, VA

Responsibilities:

• Migration of on premise EPM 11.1.2.x planning applications to PBCS
• Implemented new planning applications using PBCS by working closely with FP&A users.
• Developed multiple custom business rules for Workforce, Capital and Expense planning.
• Developed multiple custom business rules and calculation scripts for seeding budget, allocations and forecasting.
• Automated the batch files in PBCS using EPM automate.
• Implemented currency conversion.
• Used FDMEE to load data into PBCS applications.
• Implemented the security model and smart push functionality in PBCS planning application.
• Presented functional users with EPBCS sandbox planning demo application using EPBCS workforce and capex modules.
• Configured and integrated PeopleSoft with EPM systems in FDMEE as a prime ETL tool for loading data.
• Defined drill thru reports for users in FDMEE to PS system.
• Created Versions and Hierarchies for DRM applications.
• Created DRM properties and property types as per the requirement.
• Created DRM Property functions for derived properties.
• Created DRM Automatons for imports and exports.
• Integrated DRM with EPMA for metadata load into EPM systems.
• Used ODI and developed packages to massage and load data and metadata from source systems to EPMA and automated the scenarios.
• Transformed FDM to FDMEE mappings
• Setup EPM Automate process to automate file drop FDMEE loads
• Conducted CRPs and UATs, prepared test scripts, training documents for FDMEE integration
• Supported HFM applications by maintaining Metadata and data.
• Developed and maintained Webforms and Grids in HFM.
• Designed and built new business rules using calc manager.
• Used Excel add-in and Smart View for adhoc reporting and data validation.
• Maintenance and creation of security groups and users for the planning.
• Migration of Essbase and planning applications across the servers using LCM.
• Training the users to use workspace, excel add-in, SmartView and running the FR reports.
• Designed and implemented new ASO application and drill through capability using Essbase Studio.
• Supported multiple active users across the globe for the planning cycles.
• Supported monthly close and data validations.
• Supported Backups, Disaster Recovery systems, Security, patching and maintenance of EPM product suite.
• Automated the employee dim process in workforce planning through DRM and EBS gems System.
• Implemented the account and cost center hierarchy in DRM for Center repository tool for Company
• Wrote different property in DRM to support HFM, Planning Essbase and other relation system.
• Automated the change data capture process in DRM with help export DRM function and Action script.
• Implement security in DRM and used blender and import script DRM to support company merger process and Re- org process.
• Maintained different version in DRM for Month end process worked with DRM workflow to improve account creation approval process
• Creation of “CR” for environment migrations, publishing of both “old” and “new” hierarchies from MDM tool, creation of BBY SDLC documentation, creation of a disaster recovery plan, creation of new system codes for MDM tool (Archer) and training/Knowledge transition for both Corp Systems and Support resources

Oracle EPM Developer

Confidential, Vienna, VA

Responsibilities:

• The role was to act as shared resource between two departments. Duties in one department were to create a new P&L Reporting application which will be the replacement for the current legacy application built in-house with Essbase and in the other department to support existing Hyperion applications.
• Actively involved in requirement gathering sessions with FP&A team.
• Designed and developed an Aggregate Storage Database (ASO) cube from scratch that maintained company’s PL data. Performed the data load from data warehouse using various Rules files
• Debugging rules for the existing HFM application on Calc Manager.
• Data Tie-outs -Comparison utilities and templates using Smart View reports.
• Providing Support on issues related to HFM.
• Created and validated new HFM application with provided requirements. Have extensive experience in app creation and validations.
• Automated data load using MaxL and Shell Scripting. Data was loaded incrementally using Load Buffers and full load was done whenever necessary.
• Created ODI procedures to produce the action script file for DRM.
• Configured DRM with PS and EPM.
• Performed upgrade, Patching and migration of whole DRM application and also different artifacts of the applications.
• As a Hyperion Administrator involved in Installation and Configuration/Upgrade of Hyperion system 11.1.2.2 including the products such as Planning, Essbase and reporting tools.
• Performed migrations between the Production, QA and Dev environments using the Life Cycle Management utility integrated in the shared services console provided in 11.1.2.2 version.
• Integrate DRM and EPMA for Metadata changes
• Installation of Oracle DRM in multiple environments, worked with other teams for environment setup/issues, configured Oracle DRM tool in 4 environments (Dev, Test, Prod Like, Prod) Creation of security profiles within MDM tool, Analysis on location data attributes, analysis on hierarchy maintenance workflow processes and data conversion/load of Location hierarchy
• Developed batch scripts to automate the process of taking backups of the planning application, Essbase database, shared services and reports on a nightly basis using the Life cycle management command line utility.
• Maintain metadata in DRM and create CDC process for metadata change for month end process
• Created property types and property definitions in DRM.
• Created and automated nightly hierarchies build and property changed using DRM action scripts.
• Worked with DRM exports to generate ADS files to load in to EPMA.
• Create Shared and local dimension based on the application requirement
• Created web forms in planning with drill through capability to the source system using Oracle FDMEE.
• Performed daily Hyperion uploads with FDM to HFM during period closing cycle
• Developed FDMEE load automation using Open Batch and Open Batch multi period loads
• Prepared End to End FDMEE Process documents for Client including FDMEE data load admins guide, FDMEE migration documents, ODI Admin guide and FDMEE training documents

Hyperion Developer/Administrator

Confidential, Arlington, VA

Responsibilities:

• Developed Load Rules, for data load in to Essbase OLAP server using Essbase Application Manager.
• Involved in creation of Calc scripts, Rules for Hyperion Essbase Database and Application.
• Involved in development of rules files - for performing operations on records, fields, data, dimension building.
• Applied Intelligent Calculation - for calc scripts, partial calculations, calculating data blocks, turned OFF Intelligent Calculation where it was not necessary and affected performance.
• Optimized and tuned Database outline to increase retrieval and calculation timing of Hyperion Essbase BSO cube.
• Created Database backup for Hyperion OLAP Server.
• Performed tuning and debugging as well as enhancements.
• Applied Hyperion Financial Reporting to design specific financial reports to serve management requirements. Also used automated the report bursting.
• Develop building Dimensions, Attributes, Shared Member using Rule Files in an outline by means of several build methods such as Generation, Level and Parent-Child references
• Validated all the databases for data using standard Excel retrievals and Essbase reports.
• Acted as the technical lead for Hyperion Essbase related issues including providing technical support for users and supervisors.
• Optimization of BSO cubes: Custom setting type of compression, data cache, calculator cache settings, and allocation of dense/spare configuration relating to hourglass model to have optimum database block size.
• Involved and interacted regularly with the finance, IT, business users and other application administrators.

Sr. Hyperion Consultant

Confidential, Richmond, VA

Responsibilities:

• Installed and configured EPM System 11 including Essbase, Planning, Foundation Services, Financial Reporting, Analytical Provider Service, Web Analysis and ODI.
• Upgraded and Migrated 2 Planning applications from version 9.3 to system11.
• Involved in coordination with the business to get the requirements, month-end and year end close activities and ensure all objectives met successfully.
• Worked on conversion of Hyperion applications from Classic to EPMA application.
• Worked on various business rules, calculation scripts and rule files.
• Involved in design and development tasks within the context of an ongoing application development for Essbase, Planning, HFM and Reporting tools.
• Support application development and monthly maintenance processes.
• Involved in month-end data processing and data integration troubleshooting,
• Diagnosing, and resolving all problems reported to the IT Analytical Systems
• Load ADS files from DRM to EPMA Shared library and deploy planning applications in EPMA application library.
• Developed and created Web forms for users to input the data into ESSBASE cube through Hyperion Planning.
• Developed standard and ad-hoc grids, forms, rules for consolidation and reports in HFM.
• Used Classic administration and EPMA environment to create planning cubes with dimension library, application library.
• Extensively worked in Build dimensions by loading metadata into planning applications by using outline load utility.
• Involved in the automation of nightly backups, extraction of data and loading data.
• Creating and maintained hierarchies in DRM versions and exported to Text files and Databases for downstream applications.
• Designed logic groups, locations, import format, validations, data load rules and mappings in FDMEE
• Integrated ERP Systems in order to extract and load the data in to the target Essbase and HFM using FDMEE.
• Set up locations, category mapping, periodic mapping and import formats for FDMEE.

Sr. Hyperion Consultant

Confidential, Rutherford, NJ

Responsibilities:

• Interacted with users to gather business requirements, define, design, develop, test and deploy Hyperion Planning and Essbase Applications.
• Working with financial system super users, infrastructure team, other IT system administrators for daily data loads and verification process.
• Involved in full cycle of two Hyperion planning implementation.
• Responsible for Development and maintaining all technical aspects of Essbase, Planning, Reporting and FDMEE which includes constructing Metadata, changes, maintenance of application structures.
• Designed and developed standalone Essbase cube for corporate reporting framework using Block storage (BSO).
• Created Business Rules to move data between Scenarios and versions, data between Workforce Planning and Financial Statement, Revenue and Finance statement, department expense allocations and consolidations.
• Used MaxL in an interactive and batch mode to load data files and automate Essbase operations.
• Proficiency in functional and technical development for Hyperion Planning application involving budgeting, strategic planning, forecasting and workforce planning.
• Expertise in providing security for Planning &Essbase applications and ability to create user and group profiles for assigning proper privileges using both User provisioning, Native security and Shared services modes.
• Expertise in Planning Business rules and Planning Data forms/Task List
• Developed and maintained rules files, Calc scripts, MaxL scripts and reports.
• Developed reports for users to view the data in the planning applications using Hyperion Financial Reports.
• Worked on development activities like setting up source Systems, registering Target EPM Applications, Extracting General Ledger Data, Selecting Source Accounting Entities (Name of ledgers or business units), working with Import formats, Defining Locations, Defining Metadata Rules, Defining Period Mappings, Defining Category Mappings, Viewing Process Details.
• As a part of production support, look after Hyperion applications; make sure the system is up and running, available for all users.
• Prepared reports as per client requirement using Hyperion Reports and scheduled using Hyperion Reports batch scheduler.