SUMMARY:

• Over 8 years of IT experience in development and support of Hyperion products across various domains.
• Extensive experience in development and implementation of Planning and Essbase Applications on UNIX and Windows Environment.
• Proficient in analyzing and translating business requirements to technical requirements and design Financial reports.
• Experience in working through all phases of Software Development Life Cycle (SLDC) including the design, development, implementation, and maintenance of financial applications.
• Extensive experience in installing Hyperion components on UNIX and Windows operating systems.
• Designed and developed numerous Essbase applications (Block Storage and Aggregate Storage) with excellent balance of dense and sparse dimensions, developing various OLAP Models & Metadata Outline.
• Experience in creating load rules, writing Calculation Scripts, Maxl commands and MDX queries.
• Knowledge and experience in automation of daily activities using MaxL, Esscmds and Batch Scripts.
• Optimization of report queries in Microsoft Excel, creating ad - hoc reports for decision makers using Smart View and other applications.
• Strong experience as a Hyperion Essbase 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.
• Experience with Hyperion EPMA and Planning in loading metadata and data, creating web forms and assigning users/groups security filters.
• Performance Tuning with the environments QA/PROD/DEV and testing of Hyperion Applications. Experience in migrating/deploying Planning/Essbase Applications from one environment to another.
• Expertise in QA methodology, writing Test Plans, Test Cases and creation of test data for Performance, Load and UAT testing.
• Proficiency in Database Administration (DBA) such as enhancing security, database tuning, backup and recovery on different servers, platforms and operating systems.
• Experience in database and retrieval performance optimization, tuning, performance analysis, and creation of debugging procedures through development of dynamic test cases.
• Involved in generating monthly/quarterly financial reports (Balance sheet Statement, Cash flow Statement) using Hyperion Intelligence, Hyperion Analyzer, Hyperion Reports and Hyperion Essbase Spreadsheet Add-in.
• Highly experienced in resolving analytical issues based on priorities, enormous under pressure work capabilities, an excellent trouble shooter.
• Worked on IBM Websphere and Weblogic application servers.
• Strong problem-solving, communication, interpersonal,, and presentation skills. Prepared numerous presentations to help end-users understand the workflow.
• Experience in providing s on Hyperion Essbase, Planning and Financial Reporting.
• Team player with excellent Analytical and Communication skills.

TECHNICAL SKILLS:

OLAP Tools: Hyperion System 11.1.1.3 (Essbase, EPMA/Planning and Financial Reporting), Hyperion System 11.1.2.1,Hyperion System 9.3, Hyperion Essbase 7.0/ 6.5, Hyperion Planning 3.5.1, SmartView, Web Analysis

RDBMS and Office Suites: Ms Office, SQL, Oracle 10g.

Emulation: Putty, Telnet and Windows Terminal Server.

Web Design: HTML, CSS, PHP and JAVA SCRIPT, Perl Script

Operating Systems: MS-Dos, Windows9x/2000/2003/XP/, UNIX, Clarity, Rational Clear Case

PROFESSIONAL EXPERIENCE:

Confidential

Hyperion Analyst and Developer

Responsibilities:

• Involved in defining and gathering the requirements and functional specifications.
• Worked on Detailed Design document for Technical Specifications.
• Interacted with other Business Analysts and other developers throughout the project life cycle to ensure a quality system delivery to the customers.
• Analyzed the requirements and proposed Planning/Essbase solutions.
• Created Planning applications and built outline using Outline Load Utility.
• Developed web-forms that have ability to interface with SmartView and input instructions/messages in the web-forms. Developed Composite webforms to accommodate data input and show calculated data in two different forms.
• Created and update Business Rules as per the requirements and functional specifications. Created Business rules to perform validations on the web form.
• Designed Load rules to load data into Essbase.
• Written complex Calculation Scripts and member formulas to calculate data and produce desired results.
• Performed Data Validations by creating reports in excel spreadsheets and smartview and validating them against raw data.
• Designed Maxl and Batch scripts to automate process of Extracting the data from source systems, loading it into Essbase cubes and calculating data.
• Performed Business functionality testing of all core functions of the application.
• Maintained project documents and updated changes to timeline and scope as necessary.
• Maintained access rights and resolved access related issues.
• Performed migration of Planning applications using LCM Migration Utility from one environment to another.
• Provisioned users with respective roles in the shared services. Created user groups and assigned users to respective groups. Assigned security to web forms and Dimensions

Environment: Hyperion Essbase 11.1.2.2.1 , Hyperion Planning 11.1.2.2.3 , Hyperion Smartview 11.1.2.2.1

Confidential

EPMA/Planning Developer

Responsibilities:

• Created import profiles to import updated dimension structure monthly and deployed the application to Planning.
• Managed metadata using Dimension Library for updating the properties.
• Created and update Business Rules as per the requirements and functional specifications. Created Business rules to perform validations on the web form.
• Worked on different Planning Web forms that have ability to interface with SmartView and accept input instructions/messages from the users.
• Created Smart Lists that are used to create custom drop-down lists that users access from data form cells.
• Created Task Lists to assist users perform their EAC submission process step-by-Step. Tasks can display instructions, due dates, completed dates and provide email alerts at defined intervals as deadlines are approaching or missed.
• Created and managed Workflow through which planning units are promoted to next level and approved by Managers. It is the basic unit for preparing, annotating, reviewing, and approving plan data.
• Design Load rules to load data into Essbase Cubes.
• Written MDX formulas and Calculation Scripts for aggregations and data copy between different versions.
• Designed Maxl and Batch scripts to automate process of Extracting the data from source systems, loading it into essbase cubes and calculating data.
• Created reports in Financial Reporting Studio and scheduled the batches.
• Performed migration of EPMA Planning applications using LCM Migration Utility from one environment to another.
• Provisioned users with respective roles in the shared services. Created user groups and assigned users to respective groups. Assigned security to web forms, Tasklists and Planning units.
• Resolved technical issues and helped users with EAC Submission process. Conducted s to help users understand the system.
• Performed Period Close Activities and Data Validations by creating reports in excel spreadsheets and smartview and validating them against raw data.

Environment: Hyperion Essbase 11.1.1.3, EPMA 11.1.1.4, Hyperion Planning 11.1.1.4, Financial reporting 11.1.1.3.

Confidential, Mount Olive, NJ

Team lead

Responsibilities:

• Leading role in the development and support of Confidential Hyperion Applications which maintains data and Metadata related to varied Confidential Products.
• Involved in defining and gathering the requirements and functional specifications.
• Interacted with other Business Analysts and other developers throughout the project life cycle to ensure a quality system delivery to the customers.
• Coordinate meetings and communicate issues between Business users and Technical development team from offshore.
• Analyze the requirements and propose Essbase solutions.
• Extract metadata from source systems using Perl scripts and Java Scripts.
• Design Load rules to load data into BSO Cubes and ASO Cubes.
• Written Calculation Scripts and MDX formulas for currency conversion and other functions and modified them as and when requirements change
• Performed Period Close Activities and Data Validations by creating reports in excel spreadsheets and smartview and validating them against raw data.
• Resolved technical issues and provided root cause.
• Enhanced the stability of the system by proposing solutions to various iterative issues.
• Designed Maxl and Batch scripts to automate process of Extracting the data from source systems, loading it into essbase cubes and calculating data.
• Performed enhancements to the existing system with the integration of new data from Wrigleys.
• Partitioned Essbase cubes using transparent partitions created and managed the partitions, and processed cube’s administrator and end user security.
• Restructured and redesigned previous Essbase cubes. Maintenance of previous Essbase Cubes.
• Optimized and tuned Database outline to increase retrieval speed of Hyperion Essbase BSO cube.
• Created Planning data sources, deployed Planning applications through EPMA.
• Performed migration of EPMA Planning applications using LCM Migration Utility from Dev to Prod.
• Performed dimension loads to EPMA Shared Library via EPMA Batch Utility.
• Developed web-forms that have ability to interface with SmartView and input instructions/messages in the web-forms.
• Created Workflows for processing the budget data in Planning units.
• Performed Business functionality testing of all core functions of the application.
• Maintain project documents and update changes to timeline and scope as necessary.
• Maintained access rights and resolved access related issues.

Environment: Hyperion Essbase 11.1.1.3, Hyperion Planning 11, Financial reporting 11.1.1.3, UNIX, Toad, Perl and JavaScript Editors.

Confidential, Jersey City, NJ

Sr. Hyperion Consultant/Developer

Responsibilities:

• Developed batch scripts and rules files to upload dimensions and data from legacy systems to Essbase cubes, and developed rules for multi dimensional databases.
• Involved in developing webforms applications, Assigning Security, Workflow procedures and developed several Essbase, Planning applications which suit the business and for best performance.
• Analyzed, designed and optimized the load rules to improve the Dynamic database updates and to optimize the Essbase database cubes performing the calculation scripts in order to calculate the data present in the Essbase cubes, Smart view, Forecasting and to calculate Dynamic Time Series data.
• Developed MaxL scripts to automate daily backup and consolidations of monthly data.
• Created ESSCMD scripts to update outlines in batch, load data and execute calc scripts, during maintenance.
• Developed report in Pivots, Charts, Reports, Dashboards, Financial reports.
• Designing and developing Crystal Reports for different clients using Oracle as the backend
• Pulled out data from data repositories so that user can ease of access using Financial Reporting.
• Customize drill down options for reports that were created using Financial Reporting.
• Resolved technical issues and provided root cause.
• Developed Calc scripts and ran them to calculate complex values using Block Storage cubes. Involved in troubleshooting, Performance tuning and Performance monitoring.
• Retrieved data using Hyperion Essbase Excel Add-in for analysis of data.
• Involved in administrative activities such as installation and upgrade of software products including ESSBASE, setting up users, security groups and access filters to set the security policy and to ensure maximum security.

Environment: Hyperion Essbase 11.x/9.x, Hyperion Planning 9.x, Hyperion Financial reporting 11.x/9.x, Clarity, Oracle 9i, Unix.

Confidential

Team lead

Responsibilities:

• Involved in analyzing the requirements and preparing System Design Specification document.
• Making weekly Project updates to Dashboard and reporting status to Manager.
• Communicate Project developments, issues and risk to senior management.
• Development of the EMRS application in Hyperion Essbase Version 11.1.1
• Designing Scripts and Rule Files for dimension build and loading data in database.
• Modified the existing outlines to implement the new functionality based on the user requirements.
• Designing BLR Reports on HFR Studio as per the standards.
• User rules verification for salary calculations, adjustments, monthly/quarterly plan and actual scenarios.
• Defect Tracking and Reporting using Mercury Quality center.
• Prepared defect reports and test case execution report in Quality Center.
• Design Web Analysis reports on Web Analysis Studio.
• Perform Data Validation of the reports to ensure the formulae used are providing desired output.
• Perform Unit test of the portions developed by other team members.
• Review the reports developed by team members and provide comments.
• Build automated process to refresh the cube as per the tentative cube schedule.
• Involved in the Business Acceptance Testing (BAT) and user acceptance testing (UAT).
• Analyzed system requirements, developed & executed detailed Test plans, Test cases and test data, Test scripts for testing the Functionality and Integration of the different modules.
• Generating Requirements Traceability Matrix (RTM) and Defects summary for Management reporting.

Environment: Hyperion Essbase 11.1.2.1, Financial Reporting studio 11.1.2.1, Smartview, Hyperion Planning 9

Confidential

Team lead

Responsibilities:

• Testing the functionalities and behavior of the Planning and Essbase cubes in System 11 and record the results in Test case Document.
• Created Test Plan, that defines the test environment, phases of testing, entrance and exit criteria into different phases of testing and resources required.
• Performing the Hierarchy test of the cube and Data Validation in System 11.
• Preparing test cases for each module and input the actual results against expected results after performing test.
• Testing the Standard Format and functions of the report in FR Studio. Test all the functionalities of report and input the actual results against expected results in test cases.
• Identifying the defects of System 9 which has been fixed in new version and test those functionalities.
• Prepared defect reports and test case execution report in Quality Center.
• Prepare Traceability Matrix for Test Coverage using QC
• Identifying the new features of System 11 and testing their performance in all the existing Hyperion Essbase and Planning applications.
• Prepare and submit status reports for validation activities on weekly basis.
• Analyzed test results for performance tests, load tests and produced various graphs and documents.

Environment: Hyperion System 11.1.2.1

Confidential

Hyperion developer

Responsibilities:

• Created Reports as per construction rules & Standards and provided all functionalities as per the requirements.
• Created standard checklist for reports as per Confidential standards
• Ensuring defect minimization by following checklist.
• Perform Data Validation of the reports to ensure the formulae used are providing desired output.
• Examined and analyzed the requirements to develop test plans, cases and Test scripts for manual testing
• Developed Test Cases and Test Scripts in Test Plan Manager.
• Categorized bugs based on the severity and interfaced with developers to resolve them Conducted Manual Test for entire applications using manual scripts, which are designed specifically
• Planning and Estimating tests and Processes, scheduling the workflow and meeting the project milestones
• Involved in functional testing and performed screen Navigation Test to ensure that the links are established as per the documentation provided
• Created Unit test cases for reports to capture the test results.
• Defect Tracking and Reporting using Mercury Quality center.
• Prepared defect reports and test case execution report in Quality Center.
• Involved in the Business Acceptance Testing (BAT) and user acceptance testing (UAT).
• Involved in SIT phase and tested the reports basis the test standards prescribed in Unit Test Records.
• Analyzed system requirements, developed & executed detailed Test plans, Test cases and test data, Test scripts for testing the Functionality and Integration of the different modules.
• Involved in BAT phase, updated the corrections basis PCR
• Identify the root cause and solution of errors occurred during design phase.
• Maintained Defect Management for Confidential Wealth Project.

Environment: Hyperion Essbase 9.3, Hyperion Financial Reporting studio 9.3

Confidential

Hyperion developer

Responsibilities:

• Involved in analyzing the requirements and preparing System Design Specification document.
• Development of the TDCT Planning application in Hyperion Version 9.3 Enterprise Performance Management and provided below mentioned functionalities.
• >Support a monthly rolling forecast for the line of business and the segment which will load back into FDW in order to be finalized by Business Day (BD) 18 and available for TDCT MR on BD1. >Ability to input Forecast data on an allocated basis and as such no allocation engine is required within Hyperion.
• Created Planning data sources, deployed Planning applications through EPMA
• Performed migration of EPMA Planning applications using LCM Migration Utility from Dev to Prod.
• Performed dimension loads to EPMA Shared Library via EPMA Batch Utility
• Performed data loads using Essbase load rules
• Converted functional requirements to technical requirements to be used for the Hyperion Implementation
• Designed, developed numerous Financial Reports using Hyperion Financial Reporting Studio.
• Configured external directory to Hyperion Shared Services using LDAP authentication
• Externalized the security of the Hyperion Applications to Shared Services and provided Users/Groups access roles to the Hyperion Applications using Hyperion Shared Service.
• Developed 3 pairs of web-forms that have ability to interface with SmartView and input instructions/messages in the web-forms.
• Loading monthly data of actuals from FDW to Planning application.
• Archival of previous 13 months forecast in Essbase and write back data to FDW upon completion of Monthly forecasting cycle (BD 18).
• Developed reports as per the standards and providing all the required functionalities.
• Involved in Unit test of the application, web-forms and reports.

Environment: Hyperion Planning 9.3, Essbase 9.3, Financial Reporting studio 9.3, Smartview

Confidential

Hyperion developer

Responsibilities:

• Worked on Hierarchy/Dimension changes in MR cube as part of Metadata synchronization.
• Modified calculation scripts to run on the new dimensions and member names.
• Modified Substitution Variables as required for changes to dimension names.
• Analyzed, designed and optimized the load rules to improve the Dynamic database updates and to optimize the Essbase database cubes performing the calculation scripts in order to calculate the data present in the Essbase cubes, Smart view, Forecasting and to calculate Dynamic Time Series data.
• Developed MaxL scripts to automate daily backup and consolidations of monthly data.
• Created and maintained interfaces to move data into and out of Hyperion cubes.
• Administered and implemented the Migration, Back-up and Restore procedures of the entire Hyperion environment using MaxL scripts.
• Defined and maintained the security of users and groups for various Hyperion components using the native Open LDAP and User directories in User Management Console of Hyperion Shared Services.
• Created web forms as per the requirement
• Migrated existing reports to the new applications and made necessary changes to point them to new member names and hierarchies. Also created new reports as per the requirement.
• Used Drag and drop tables, pivots and charts onto the layouts to create the report’s subject matter.
• Performed ad-hoc analysis and reporting using Hyperion SmartView for Essbase and Planning.
• Created the existing Budget Book reports using Web Analysis.
• Involved in Unit test of reports and reviewed reports created by other team members.

Environment: Hyperion Planning 9.3, Essbase 9.3, Financial Reporting studio 9.3

Confidential, Connecticut

Hyperion developer

Responsibilities:

• Involved in building the Consolidation applications using Hyperion Planning.
• Involved in building HAL to update the hierarchy in planning.
• Built Essbase applications based on the requirements.
• Created load rules for loading metadata and data into cubes.
• Developed Calc scripts and ran them to calculate complex values using Block Storage cubes. Involved in troubleshooting, Performance tuning and Performance monitoring.
• Retrieved data using Hyperion Essbase Excel Add-in for analysis of data.
• Created web enabled reports using Hyperion Analyzer, maintained cubes and took regular backups of databases.
• Design and develop web based data entry forms within Hyperion Planning and task lists.
• Modified the webforms so that they match the Corporate standards.
• Created users and user groups in the Planning applications and assigned security to web forms.
• Involved in checking the status and progress of each planning unit so as to analyze variances in real-time, revise, promote, reject and approve plans.
• Involved in building data load rules, calc scripts and validation of data.
• Users input capability to the applications maintained by Filters for many applications.

Environment: Hyperion Essbase 6.5.4.2/ 7.1.5 , Planning 3.0/3.5.1, Reports 7.0.1.2, HAL7.0, Websphere 5.0, Weblogic, Oracle 8i, Oracle GL, Hyperroll 4.2, Windows 2003 server, Linux, Unix.

Confidential, Connecticut

Hyperion developer

Responsibilities:

• Played role of Subject Matter Expert who provides 24/7 support of Hyperion Applications across the Confidential domain.
• Involved in Hyperion Installations. Installed Essbase, Planning, Report and Analyzer on Windows and Unix.
• Performed Essbase upgrades from version 6.5.4 to 7.1.6 for all business.
• Involved in setting up users, disk space, servers and prerequisites for new Installations.
• Involved in design and implementation of the backup\Disaster Recovery process for Hyperion applications across the Confidential business.
• Played a key role in the performance testing of planning and closing applications before being deployed to production.
• Designed and documented the scripts for performance testing.
• Provided offshore production support. Resolved issues related to server, database corruption, refresh issues and issues during development stage.
• Provided RCCA’s (Root cause corrective action), PPA (Permanent Preventive Action) for major (priority 1) production issues.
• Involved in performing the disaster recovery tests for all businesses to make sure it meets the SLA.
• Involved in building of automated processes for Month, Quarter and Year close activities using AppWorx scheduler for all businesses.
• Involved in documenting all the RCCA’s, SOP’s and supported more than 30 applications in production.

Environment: Hyperion Essbase 6.5.4.2/7.1.5 , Planning 3.0/3.5.1, Reports 7.0.1.2, Analyzer 7.0, HAL7.0, Websphere 5.0, Weblogic, Oracle 8i, Oracle GL, Hyperroll 4.2, Windows 2003 server, Linux, Unix.