SUMMARY:

• Over 12 Years of experience in IT with 8 years of experience in Hyperion Suite of products and 4 years of experience in Testing
• Over 4 years of team management experience for day to day activities as well as long term resource allocation, cube development, testing, etc.
• Experienced in all stages of Software Development Life Cycle (SDLC) with comprehensive knowledge of business and requirements analysis, business Process modeling, Project planning and creation of user cases.
• Experienced in a range of Hyperion products including Oracle PBCS, Smart push, EPM Automate, Oracle/Hyperion System 11x, Essbase Analytics (BSO and ASO), Hyperion System 11x Planning, Hyperion Financial Reporting Web Studio, Web Analysis, Smart View, ODI, Maxl, MDX, Report Scripts, EIS.
• Strong experience as a Hyperion Essbase and Planning Administrator with Security Setup and Management: User Management, User roles, Shared Services setup, assigning server and application access, database calculation, filtering, assignment of application access types.
• Strong Understanding of dense and sparse strategy dimension allocation, calculation scripts, developed, reviewed, and optimized report queries.
• Analyzed user requirements and involved in the process of finalizing dimensions for Cubes.
• Extensively involved in designing and modifying the outlines for Essbase and Planning Cubes.
• Extensive experience in Calculation scripts, Dimension build rules, Data load rules and report scripts.
• Involved in writing custom Essbase calculations scripts, automated the Essbase Cubes using MaxL, Esscmds and Batch Scripts.
• Skilled in Automation, Optimization and Performance Tuning of Essbase application data/metadata processing, upgrading, testing and migrating of cubes in different environment.
• Experience in HFM applications - metadata preparation, security classes, Member lists, data grids, Web Data forms, journals posting, ICP Eliminations, reports and automation of HFM tasks using task flows from workspace.
• Experience in interacting with business users at various levels and converting the requirements into technical specifications
• Excellent technical communication skill, analytical and strong inter-personal skills and good documentation skills. Team player capable of working independently, motivated and quick learner.
• Performed optimization of the applications for the faster data load, better calculation time and for faster retrieval of the reports using the Dense/Sparse settings, Cache settings, making changes in Outline formulas.
• Optimized outline for calc performance and faster retrieval using optimization techniques such as hour glass structure etc.

PROFESSIONAL EXPERIENCE:

Confidential, MD

Associate

Responsibilities:

• Participated in workshops with business stakeholders to understand future state processes and the functionality needed to enable it.
• Documented initial business requirements collected via the workshops and creation of BRD.
• Created PBCS application and enabled the prebuilt Out Of The Box (OOTB) features and functionality for the Financials, Workforce and Projects business processes.
• Designed and loaded standard and custom dimensions, Addition of NRC specific chart of accounts into the standard dimensions through Simplified user interface.
• Created custom budget forms and integrated them into dashboards along with user specific infolets
• Leveraged the prebuilt Rules for Workforce including the Process Loaded data, Calculate Compensation, Synchronize Defaults and Definition.
• Created custom forecast process and calculations for 3+9, 6+6 and 9+3 forecasts cycles incorporating actuals and budget data.
• Developed Data management import formats, location, period mappings, data load rules and data mappings for integrating and importing data from legacy systems into PBCS and drill through functionality.
• Configured Security using Identity Management and My Services leveraging predefined roles, user & group creation and granting roles.
• LCM from Test to Prod instances and Snapshot Backups using Migration utility.
• Build automation of metadata and data load process using Oracle Data Integrator and EPM Automate utility
• Created of Valid Intersections to restrict unwanted data intersections and have only the required data views.
• Testing and validation of all the build and documentation, including unit and integration testing.
• Conducted UAT for periodic review of the build
• Performed performance tuning and optimization of the application for data load, aggregation and calculations.
• Design and develop the ELT process (Data Extraction, Loading and Transformation) from source to PBCS using Oracle Data Integrator
• Developed packages, scenarios using interfaces and variables
• Created load plans to run the scenarios in a hierarchy of sequential and parallel steps
• Maintained the on-prem Hyperion Classic planning applications day to day activities, user requests, pefromances tuning, etc.
• Maintained the ODI load process for both existing and new Planning applications (on-prem and PBCS)
• Maintained the OBIEE reports and also the load process via ODI. Troubleshoot user related BI tickets
• Ensured that the user tickets are prioritized and resolved in a timely manner
• Ensure that the Change Management tickets have clear documentation with well defined processes

Confidential, Dallas, TX

Hyperion Developer/ On site lead

Responsibilities:

• Planned day to day activities of the Hyperion team as the on-site Team Lead for a team of four working in India and Mexico (24 hours support).
• Planned and assigned work for the development and test schedule of all enhancements
• Worked as the on-point lead to respond to any queries or concerns of the client.
• Administer the ASO and BSO cubes which are used for reporting and making the changes as needed
• Gathered requirements from the business users Finance team and coordinate with the team to design/ enhance the application based on the business needs
• Executed and edited nightly batch jobs as required on UNIX Platform
• Gathered the requirements and determined the time line and effort required in designing the applications.
• Participated in business requirements for new enhancement & systems development activities.
• Work with Admin to migrate the Essbase applications for both BSO and ASO including artifacts from the existing production server and maintain metadata and managing data transfers between applications
• Ensure all development activity is compliant with change control procedures and is rigorously tested
• Maintenance of the existing developed code/Scripts in the Hyperion environment.
• Responsible for the management of the development review process for all Hyperion development.
• Ensure support and development service that meets or exceeds existing SLA’s
• Ensure that the SLA’s for Service requests and incidents/ defects are met
• Performance Tuning and optimization, Configuration settings, Dense/Sparse Outline configuration, scripting, Batch scripting.
• Worked on performance tuning and optimization of BSO cubes as well as on cube enhancements process.
• Provide a technical support and development service for each of these applications. This will involve gaining a detailed understanding of the application structures, the business processes they support and the requirements of a diverse user base
• Performed Constant updates to the config files ensuring that the performance is good
• Assess new Business needs/ initiatives and translate them into detailed business requirements specifications.
• Created and modified the Calc. Scripts and Report Scripts based on the Finance team’s request.
• Works with internal customers to consistently improve and refine processes and procedures
• Support for issues based on dimension Build Rules, Data Load Rules, Calc Scripts, MDX scripts, MaxL Scripts and Config Files.
• Experience ensuring change procedures comply with SOX controls

Confidential, Mechanicsville, VA

Hyperion Administrator/Developer

Responsibilities:

• Gathered requirements from the business users FP&A team and coordinated with the consultants to design the application based on the business needs
• After gathering the requirements determined the time line and effort required in designing the applications.
• Upgraded the Essbase/Planning (Enterprise Performance Management) applications from Version 9.3.1.4 to 11.1.2.1
• Responsible for creating new planning (Enterprise Performance Management) applications on version 11.1.2.1 for the Budget/Forecasting purpose.
• Participated/created UAT test scripts during the project implementation
• Used FDM for mapping and data load into an essbase/planning cube
• Work with IT/Infrastructure/ Data warehouse teams to determine best plan of action for each implementation.
• Creation of Standard Operational Procedures, Admin Manuals and Best Practices documents for application administration and maintenance and functional end user support
• Hyperion Essbase and Planning cubes optimization and best practices implementations in existing applications and calculations (Calc Scripts & Calc Manager).
• Reconcile data and assure data integrity.
• Support monthly/quarterly/annual processes for Actuals, Budget and Forecast.
• Data reconciliations, backups and maintenance of data integrity in all Hyperion applications
• Used outline load utility to update the metadata in the planning application
• Used LCM to migrate the Metadata from Environment to another environment
• Created data forms based on FP&A request and also created Business Rules based on the requirement
• Created calc scripts and executed them based on data loaded into the application
• Participated in business requirements for new enhancement & systems development activities
• Assigning security to Groups and Users, modifying the Essbase Filters based on the Essbase & Planning application business requirements.
• Modified the allocation of the Business Rules, changed the calculation scripts based on the business needs.
• Educated the users with the Smart View
• Worked on performance tuning and optimization of BSO cubes as well as on cube enhancements process.
• Worked with the internal customers to consistently improve and refine processes.
• Assess new Business needs/ initiatives and translate them into detailed business requirements specifications.
• Created and modified the Calc. Scripts and Report Scripts

Confidential, Chicago

Hyperion Developer/Administrator

Responsibilities:

• Involved in documenting the designs and gathering specifications from business users for the development of Actual, Forecast, Budget and Business Plan Cubes.
• Developed customized cubes according to the business requirements and maintain them for users.
• Created Data Grids, Data forms and Security file, Process Control using HFM.
• Performed Set up of Journal Entries, Intercompany Transactions, Eliminations, Exchange rate conversion.
• Maintenance of FDMEE - create/update the mappings, validate and export the data into HFM
• Automation of HFM tasks using task flows from workspace.
• Created Rules Files for Loading Data.
• Created Calc Scripts and Optimized Calculations.
• User Management: Creation, Modification and Deletion of Users.
• Created Load Rules, Report Scripts based on the business needs.
• The Actual data feed used to come from Business Objects and troubleshoot any issue related.
• Involved in writing Maxl Scripts, Calc Scripts, Load Rules and Report scripts.
• Maintained Users security through Filters depending up on the functional business requirements.
• Hands on experience in backup and recovery of Database.
• Created multidimensional cubes using EIS where OLAP Model was created and Meta Outline was designed according to the requirements
• Performed optimization of the applications for the faster data load, better calculation time and for faster retrieval of the reports using the Dense/Sparse settings, Cache settings, making changes in Outline formulas.
• Created Budget and Financial reports using Hyperion Reports and Financial Reporting Studio.
• Worked on performance tuning and optimization of BSO cubes as well as on cube enhancements process.
• Performed backups for the Essbase Applications & other administration activities
• Automated data load and subsequent aggregations using MaxL and windows batch files.
• Assess new Business needs/ initiatives and translate them into detailed business requirements specifications.
• Develop reports using Hyperion Financial Reporting Studio.
• Worked closely with IT and finance/accounting teams to resolve issues, upgrade, develop, test, and implement financial systems.

Confidential, Akron OH

Essbase Developer

Responsibilities:

• Involved in the full cycle of gathering requirements, defining, designing, developing, testing and deploying the system.
• Involved in preparing the Design document detailing the data acquisition, business processes, test plans and test cases for unit testing and system integration testing.
• Supported the third party vendor conducting test processes such as User Acceptance Testing (UAT), system validation testing and performance testing.
• Worked on performance tuning and optimization of BSO cubes as well as on cube enhancements process.
• Created users and groups and assigned them different level access and privileges.
• Redesigned and restructured the existing cubes using Hyperion Analytic Administrative Services.
• Extensively worked on cube enhancement process which involved discuss, design, and document and add new requirements to existing cube outlines.
• Optimized Essbase database using optimization techniques like hourglass structure, dense, sparse settings etc.,
• Automated data load and subsequent aggregations using MaxL and windows batch files.
• Created Hyperion reports using Hyperion Essbase Excel Spreadsheet Add-In.
• Developed complex calculation scripts and formulas for the existing BSO cubes to implement the business logic.
• Completed migration of planning application from one environment to other and developed “How to” Manuals.
• Designed and developed nightly cycles which automate data loads, Aggregation, and backup of planning applications.
• Developed Financial reports for the Executive Management Team.

Confidential . Indianapolis, IN

QA Analyst

Responsibilities:

• Developed QA strategy, wrote Use Cases, UAT Plans and UAT test cases from Business Requirements.
• Gathered business requirements, studied the application and collected the information from developers.
• Wrote and implemented effective test plans.
• Prioritized test scenarios for testing based on time schedules
• Prepared Status Report, Summary Test Report and Readiness Matrix.
• Reviewed test assignments, developed test plans and scripts, and conducted tests as assigned.
• Data-Driven Testing using QTP
• Utilized Quality Center to develop and execute test cases.
• Performed Verification Testing and Regression Testing of the application.
• Executed test scripts for newly developed functionality and reported problems.
• Wrote Customized functions using QTP
• Interacting with developers and QA team in fixing schedules for assignments
• Documented Defects found during test on the TestDirector and communicated recorded problems to the responsible QA or development personnel.
• Discussed Enhancement and Modification Request issues in various meetings.
• Involved in weekly inspection meetings, to verify the status of the testing effort and the project as a whole.