SUMMARY

• 8 years of professional Technical consultant experience in EPM Suite or products including various phases of system design, analysis, development and supporting of various applications in Client/Server OLAP environment using Hyperion Essbase, HFM, Hyperion Planning, DRM, FDMEE, Hyperion Reporting
• Good understanding of dense and sparse strategy dimension allocation. Experience working with stakeholders and experience in client facing roles
• Proficiency as Essbase Administrator in maintaining Essbase, managing database settings, optimizations, thorough understanding of ASO and BSO cube architecture, Essbase Cache settings, optimizing calculations, attributes, storage security, optimizing reports.
• Security Management through restricting user accounts with roles and privileges.
• Expertise in administrative tasks of Essbase: managing applications and databases, Essbase architecture, data and dimension loading, Calc Scripts, MaxL, Report Scripting, Performance tuning.
• Perfectly handled Monthly, Quarterly and Yearly Processes and Weekly Maintenance activities. Intervened in production support issues as necessary.
• Substantial experience in creating, maintaining, and supporting all application objects including outlines, calculation scripts, rules files for dimension building and data loading, creation and security objects through Essbase Administrative Services (EAS), MaxL.
• Commendable knowledge and experience in ESSBASE cube designing, automation using batch scripts, creating ad - hoc reports for decision makers using Smart View and other applications.
• Expertise in Dynamic dimension builds methods, MaxL Scripts, Dimension and Data Load Rules.
• Having extensive experience in creating Data Load Rule files, Calc Scripts, MaxL Scripts, Batch Scripts, Reports and Excel Add-in.
• Excellent communication skills and better understanding of business requirements and software development cycle in the Hyperion EssBase environment
• Experienced in knowledge transfer, preparing the required documentation, training the clients.
• Worked with FP&A team to translate complex requirements Data flow diagrams, Requirements specifications, Use case scenarios, Acceptance testing
• Worked closely with FP&A team to develop, design and test robust Hyperion solutions

TECHNICAL SKILLS

Performance Management Tools: Oracle Hyperion Planning/Workforce Planning 3.1/9.3.3/11.1.2.3/11.1.2.4

Business Intelligence Tools: Oracle Essbase 9.3.1/9.3.3/11.1.2.1/11.1.2.3/11.1.2.4

Reporting Tools: Hyperion Financial Reporting, Smart View, Excel Addins, Tableau

Data Management Tools: Data Relationship Management (DRM), Financial Data Quality Management (FDQM)

PROFESSIONAL EXPERIENCE

Confidential, Utah

PBCS Product Support

Responsibilities:

• As a Confidential major role involves identifying the scope of projects, future enhancements documenting business requirements converting them to user stories and acting as a bridge or coordinate between functional team/business leaders and help the Informational technology team to understand the requirement and follow up with the to get the requirements done
• Plan for testing the developed logic /evaluate the design
• Drive feature assessment & requirements gathering & Work as Functional expert for a business process and use cases
• Test Member formulae and Business rules to check the flow of data
• Provided training to end users in Smart view, Basic Hyperion Practices.
• Maintain DRM with all the metadata data changes prior to Midmonth.
• Maintain Hierarchies in Hyperion, document changes
• Provide updates to the IT team on all the hierarchy/cost center moves will happen for the team to update the necessary web forms with the new members for users to plan at and update UDAs.
• Data movement validation verification from one region to other region one Management entity to other management entity
• Structure validations and Data validation for the planning cycles, Actual and History data load for the Midmonth
• Testing support for upgraded, patches, enhancements for process improvements.
• Validate the Balance sheet roll forward process/data for the FP&A Balance sheet team
• Design/Develop enhancement’s functionality, test provide signoff for the enhancement’s
• Support FP&A Planning cycles (determine opening closing, cycles), support maintain month end process
• Define Requirements to enhance the existing process
• Participated in Implementing Partition Design
• Designed integration of different source COA into one DRM application
• Designed Balance sheet roll forward process for new COA and new Hierarchies built and planning cycle design
• Assist users with PBCS issues
• Working knowledge on EPM Automate
• Working knowledge on dash boards, smart push
• Work with customers to identify /trouble shoot issues and figure out root cause of the problem
• Communicate notes on bugs fixes to customers

Environment: Hyperion Essbase 11.1.2.4, Hyperion Planning 11.1.2.4, Hyperion Workspace 11.1.2.4, Data Relationship management 11.1.2.4, Data relationship governance 11.1.2.4, PBCS 16.07 to 17.06

Confidential, Palo Alto, CA

Hyperion Essbase Planning Developer & Support

Responsibilities:

• Designed and developed new Essbase & Planning cubes for corporate business Hands on development and configuration of Hyperion Planning and Essbase applications.
• Automated data load’s using maxl, batch process. Developed and maintained Rule File, Calc Scripts, MaxL Scripts and Reports.
• Assist with data conversion and interfacing activities, including user support to load and reconcile data
• Creating report scripts to extract the data from ASO cubes as per requirement.
• Creating web forms based on user requirements in Hyperion Planning.
• Restructured the Database by adding new members, optimized the Database by configuring Sparse and Dense Dimensions
• Designed and implemented batch scripts for loading the data from text files to Essbase cubes through rules files.
• Managing Data relationship governance workflow, members in Data relationship management
• Write user stories, convert them into test cases and execute test cases
• Upgrade and analysis/testing of source system from Oracle EBS to SAP Chart of accounts
• Involved in gathering data and supervising data load, created batch files to automate the data load process as well as dimension build process using MAXL Scripts.
• Maintained security for the users and groups using Shared services.
• Professionally responded to demands and deadlines in a positive manner.
• Developed batch files to automate cube refresh, LCM export using planning utilities.
• Part of the team to take care of pre - project activities of Proposal preparation, interacting with clients, Questionnaire preparation, Requirement gathering etc.
• Coordinate activities to support clients through full life cycle Hyperion Planning and/or Oracle Essbase implementations including contributing to design effort through development, training, documentation and go-live deployment.
• Assisted end-users through direct communication and documentation.
• Document preparation with respect to client requirements, Solution given etc.
• Liaised with Oracle support for issues and bugs reported in the Product.
• Documented Hyperion system processes and responsible for complete system documentation and training materials.

Environment: Hyperion Essbase 11.1.2.3, Hyperion Planning 11.1.2.3, Hyperion Workspace 11.1.2.3, Data Relationship management 11.1.2.3, Data relationship governance 11.1.2.3

Confidential, Atlanta, GA

Hyperion Essbase and Planning consultant

Responsibilities:

• Created Hyperion Planning, Essbase application based on the requirements of Business users.
• Maintenance of existing Hyperion Planning applications for Forecasting and Budgeting.
• Optimization of couple Essbase databases by utilizing dynamic calcs and optimal outline structure.
• Responsible for automating all jobs and processes in Essbase and Planning. 
• Analyzing business requirement, collecting relevant information which in turn will result in the implementation of the requirement in the best possible manner.
• Created the web entry data forms, web data grids and Journal Templates and testing.
• Creating the member lists as per requirement.
• Created the Automation Tasks for Data Loading, Calculation and Consolidation.
• Experienced in creating Smart view templates for loading and retrieving data.
• Daily support activities like extraction, loading and resolution of Service Request related to application and user issues.
• Involved in planning and Essbase support activities to provide better quality of support.
• Managing Outages and communication with Business owners regarding Application availability.
• Accepting and resolving the dockets raised by the client\user as per the SLA.
• Co-Ordinate with reporting team at Onsite and Offshore Team for further requirements on Enhancements.
• Support business, end user questions related to functionality of the application or technical queries.
• Review Web Forms Hyperion Report changes.

Environment: Hyperion Planning 11.1.2.2, Essbase Administration Services 11.1.2.2, Shared Services 11.1.2.2, Hyperion Smart View for Office 11.1.2.2, Hyperion Data Relationship management 11.1.2.2, ODI 11.1.1.3, Financial Reporting, Web Analysis, Essbase Studio 11.1.1, MAXL

Confidential

Planning/Essbase Developer

Responsibilities:

• Interacted with users to gather requirements, understand business needs and ensured applications met the required changes.
• Designed and developed new Essbase cubes for corporate reporting framework using Aggregate storage (ASO) and Block Storage (BSO) cube.
• Automated periodic data loads and calc scripts using MaxL and Batch Scripts.
• Developed load rules for loading data, metadata and dimension build. Implemented robust data-access security and user management
• Involved in high performance tuning and optimization. Created and maintained Block Storage Application.
• Worked extensively on modifying and building the outline and assigning member properties.
• Developed and maintained Rule File, Calc Scripts, MaxL Scripts and Reports.
• Maintained numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion.
• Designed and implemented batch scripts for loading the data from text files to Essbase cubes through rules files.
• Created users and groups through Shared services and assigned access privileges to appropriate users.
• Tuning of cubes - sparse/dense configuration, block density and compression, outline structure strategies, batch update streamlining, load optimization (load rules and transformation) and calc script optimization.
• Involved in preparing security design document and reviewed other documents.
• Synchronized Essbase security with Shared services.

Environment: Hyperion Planning 11.1.1, Oracle Essbase Administration Services 11.1., Hyperion Shared Services 11.1.1, Oracle Hyperion Financial Reporting 11.1.1, Essbase Excel Add-In, WINDOWS.