PROFESSIONAL SUMMARY:

• Over 10 Years of strong experience in design, analysis, development and implementation of various applications using Hyperion Essbase, Hyperion Planning, Hyperion Financial Management, Financial Data Quality Management, Essbase Integration Services, Hyperion Analyzer (Web Analysis Reports), MAXL, MDX Query, ESSCMD, Smart view and Essbase Spreadsheet Services under Windows environment.
• Proficiency in implementing Public Sector Planning and Budgeting
• Skilled at installing and configuring all Hyperion products in Windows environments.
• Strong experience in development, production support and administration oriented tasks of Hyperion products.
• Skilled at Hyperion Workforce Planning, Public Sector Planning and Budgeting, and Hyperion Capital Asset Planning.
• Thorough knowledge of dynamic dimension build and data loading.
• Proficiency in Essbase database and Calc Script optimization.
• Expertise in automation process by developing MAXL Scripts and batch Scripts
• Comprehensive skill in creating Ad - Hoc reports using EXCEL ADD-IN.
• Hands on Experience in test case preparation for Hyperion environment.
• Successfully oversaw upgrade of other Oracle EPM/Hyperion products from 9.3.1 to 11.1.1.3
• Detailed knowledge of Hyperion Pre-System 9, System 9 and System 11.
• Expertise in KT, preparing technical documents, training users.

TECHNICAL SKILLS:

MDDB Database: Hyperion Essbase 6.5 and 7.1 and Hyperion Essbase 9.2, 9.3.1 and 11.x.

EPM Tools: Hyperion Planning, Hyperion Public Sector Planning and Budgeting, Hyperion Capital Asset & Workforce Planning, Hyperion Financial Management, Financial Data Quality Management.

Reporting Tools: Interactive Reporting, Financial Reporting, Web analysis Reporting, Smart view and Spread Sheet Add in.

Hyperion Scripts: Calc Scripts, Report Scripts, MAXL, MDX and ESSCMD

Operating Systems: Windows XP, Windows 2003, AIX and LINUX

Databases: Oracle 9i, Oracle 10g, Oracle 11g, SQL Server 2005, DB2

GUI Tools: TOAD, VMWARE and MS-VISIO

PROFESSIONAL EXPERIENCE

Confidential, Raleigh, NC

Hyperion Lead

Responsibilities:

• Gathered requirements for the application build.
• Integrated Oracle Fusion with Hyperion PBCS for Data updates.
• Created new forms and templates for entering data.
• Migrated applications from one instance to another (Test to Prod).
• Build 3 cubes (GL cube, Contracts cube & work force cube).

Environment: Hyperion PBCS.

Confidential, Fort Worth, TX

Hyperion PSPB SME

Responsibilities:

• Helped in loading data in the application and resolving issues related to inconsistency of data.
• Created new forms and templates for entering data.
• Migrated applications from one instance to another (Test to Prod).
• Trained users in Smart view and Hyperion.
• Resolved the issue with Map Reporting application.
• Trained the admin to maintain the system.
• Wrote the user guide, training documentation and the functional specifications document.
• Develop, Build and Deploy PSPB (Employee and Position based Budgeting) application for new campus.
• Did production support for all the 7 applications in production.

Environment: Hyperion 11.1.2.2 PSPB, Essbase, Financial Reporting and smartview.

Confidential, San Diego, CA

PSPB Hyperion Planning

Responsibilities:

• Provided PSPB expertise in building the application and optimizing the build process to meet time lines.
• Migrated applications from one instance to another (Test to Prod).
• Build custom Financial Reports using FR.
• Assign dimension level and web form level security and implemented workflow.
• Develop, Build and Deploy PSPB (Employee and Position based Budgeting) application.

Environment: Hyperion 11.1.2.3 PSPB, Essbase, Financial Reporting.

Confidential California

PSPB Hyperion Planning

Responsibilities:

• Provided PSPB expertise in Requirements Gathering, Fit-Gap Analysis, Application Design, Metadata design and configuration, HCP dimension and data element design.
• Develop, Build and Deploy PSPB (employee and position based budgeting) application along with Capex, GL and detail cubes.
• Optimized the HCP cube as the volume of data was large.
• Developed Smart View & FR reports and wrote calculation scripts to extract data into relation database for the BIP team for creating the Budget book.
• Created multiple data push mappings to push data between cubes in the application.

Environment: Hyperion 11.1.2.3 PSPB, Essbase, Financial Reporting.

Confidential, Omaha, NE

Hyperion Architect

Responsibilities:

• Provided PSPB expertise with Requirements Gathering, Fit-Gap Analysis, Application Design, Metadata design and configuration, HCP dimension and data element design.
• Developed, build and Deploy PSPB (Employee based Budgeting) application.
• Trained users in HCP and how to validate the existing position information.
• Supported UAT and post production for a 2 weeks after GO Live.

Environment: Hyperion 11.1.2.3 PSPB, Essbase, Financial Reporting.

Confidential, Greenville, NC

Hyperion Architect

Responsibilities:

• Provided PSPB expertise with Requirements Gathering, Fit-Gap Analysis, Application Design, Metadata design and configuration, HCP dimension and data element design, and Capex custom application design and development
• Develop, Build and Deploy PSPB (employee and position based) application along with Capproj, GL and detail cubes.
• Developed FR reports and FDM interfaces.

Environment: Hyperion 11.1.2.2 PSPB, Essbase, FDM and financial reporting.

Confidential, Torrance, CA

Hyperion Architect

Responsibilities:

• Provided assessment of Hyperion architecture and identified risk areas which needed further testing and management. Suggested mitigation plans and implemented necessary changes for successful release of new version.
• Coordinated and led business meetings for needs assessment and design review.
• Worked with the business to understand their daily usage of the system and based off that created a testing universe for the project.
• Worked extensively on Disaster Recovery Plan, simulating a disaster and ensuring entire recovery.
• Managed all phases of the testing lifecycle including - Smoke Testing, Shakeout Testing, NAR Testing, DR Testing, UAT Testing, Regression Testing, Production Sync Testing, Security Testing etc.
• Analyzed the differences between the systems in the user interface and helped with Training and documenting them
• Coordinated with current Application Management team to understand the enhancements and fixes they were engaging in and made assessments on when to bring in those changes into the new environment through the lifecycle of the upgrade.
• Created a stage by stage go live release plan to ensure Go Live date does not impact business deliverables and financial reporting timelines.

Environment: Hyperion 11.1.2.2 Planning, Essbase, Interactive reporting and financial reporting.

Confidential, Glenville, FL

Hyperion Planning Developer

Responsibilities:

• Responsible for gathering the requirements by having a series of discussions with the budget office.
• Responsible for delivering the requirements document based on the discussions with the users.
• Involved in the technical design discussions and came up with an optimal design for the application .
• Consolidated the dimensions and came up with a cube structure that would support the business process.
• Came up with the data flow of how data would move from one application/system to the other.
• Built the GL & HCP cubes, which included writing Business rules using Calc Manager, writing calculation scripts and web forms.
• Customized the Out of the box business rules to meet the business process.
• Used LCM to migrate the application from one Application/ Instance to the other.
• Mapped the planning cubes using “Map Reporting Application” to push data from one cube to the other.
• Documented all the steps that are involved in the budget process and also designed the technical document.

Environment: Hyperion Public Sector Planning & Budgeting 11.1.2.1, Financial Reporting Studio.

Confidential, Chicago, IL

Sr. Hyperion Developer

Responsibilities:

• Lead the team of Hyperion developers under the direction of the architect.
• Lead the technical design discussions in the requirements gathering meetings.
• Suggested best practices for an optimal build of the application.
• Analyzed data from the two source system and came up with the Dimensions for the application.
• Built the GL & HCP cubes, which included writing Business rules using Calc Manager, writing calculation scripts, report scripts and web forms.
• Worked extensively with LCM to migrate the application from one instance to the other.
• Reviewed 11.1.2.2 for the client server installation.
• Assisted the client in developing their understanding on Hyperion.
• Built an ASO cube with 10 years of data for reporting purposes.
• Built reports using FR for balance sheets reports and BTA reports for the budget department.
• Mapped the planning BSO’s with the ASO Application using “Map Reporting Application” to push data from one cube to the other.
• Provided support for the application through testing & production phase.
• Trained the user along with the trainers in the training sessions.

Environment: Hyperion Public Sector Planning & Budgeting 11.1.2.1, ODI 11g, Financial Reporting Studio.

Confidential, Vermont

Hyperion DBA (On Demand Command Center)

Responsibilities:

• Supporting Oracle On-demand Customers running various versions of Database (Oracle 8i, 9i, 10g and 11g), Hyperion Version 9 and above.
• Provided all round DBA support to resolve DB, Application, Tech Stack outages on production, development, test and staging On-demand Customer environments.
• Daily responsibilities included trouble shooting and restoring any and all Severity 1 & 2 service requests(SR) pertaining to Hyperion products and EBSO.
• Worked at the command center and overcame challenges involved to resolve the outage within the SLA.
• Identified, analyzed and resolved a variety of technical problems related to Hyperion.
• Restored failed services; found workarounds to reduce business outage situations.
• Monitored SRs and was responsible for all SR updates and providing anyinformationto Oracle from Oracle Diagnostics Tool.
• Worked on Hyperion and Oracle Apps DBA at the command center.

Environment: Hyperion version 9 and above, Oracle EBS (E-Business Suite) - 11i & R12, Oracle 10g & 11g Database, Solaris.

Confidential, Arlington, VA

Work Force Planning Developer

Responsibilities:

• Collected requirements from the users and finalized the design.
• Developed HFM, FDQM and Hyperion Workforce Planning applications and data forms.
• Implemented FDM environment, including import formats, scripting, dimension mapping, and validation reports.
• Used ODI to load metadata into both Work force planning and Planning applications.
• Was responsible for managing the security of users in both Planning and Work Force Planning application as the applications were going live.
• Wrote the test scripts for the Workforce Planning data forms and was responsible for the application to clear the testing phase.
• Supported the trainers/users in the training sessions as a technical resource.
• Designed the configuration document which helped users understand the application.
• Worked with Oracle support team to resolve product issues regarding Hyperion Planning.

Environment: Hyperion System 11 Planning & Workforce Planning, Hyperion Financial Management, Financial Data Quality Management, Oracle Data Integrator (ODI), Hyperion System 11 Analytic Services(Essbase), Microsoft Excel 2007, MaxL and Smart View.

Confidential, Cincinnati, OH

Financial Report Developer

Responsibilities:

• Collected requirements from the users and finalized the design for the reports.
• Involved in preparing the Templates.
• Designed documents which would help users map members form Hyperion Enterprise to Essbase/HFM.
• Developed Reports using Financial Reporting against both Essbase and Planning data sources.
• Worked with Hyperion/Oracle support team to resolve product issues regarding Financial Reporting.
• Responsible for creating a document against Financial reports (Utility Report Library), which would help the user understand them better.
• Responsible for the year end maintenance and also to educate the client about the process as they were doing it for the first time.
• Assisted as an ad-hoc Planning Admin and was responsible for solving problems with access.
• Was in charge of all the deliveries on behalf of Wipro for the BI support team for the last three weeks.

Environment: Hyperion System 9 BI+ (Financial Reporting), Hyperion System 9 Planning, Hyperion System 9 Analytic Services (Essbase), Microsoft Excel 2007, Windows 2003, ESSCMD, MaxL, Essbase Excel Add-In and Smart View.

Confidential, Chicago, IL

Lead Hyperion Planning

Responsibilities:

• Collected requirements from the users.
• Involved in preparing the design document.
• Designed the Planning Process using the Hyperion Planning Workflow.
• Designed Task Lists for the Budgeting process by including web forms, Business rules for the end
• users
• Extensively used Macros functionality in to develop shorter and easy to maintain Business Rules.
• Designed Smart Lists for better ease of use.
• Worked with Hyperion/Oracle support team to resolve product issues.
• Developed Reports using Fin Reporting against both Essbase and Planning data sources.
• Modified Capital Assets Web Forms, Task Lists and Business Rules to suit the client’s
• requirements
• Created Task Lists for the Capital Asset Planning data type.
• Integrated the Capital Planning plan type to Financial Planning plan type

Environment: Oracle EPM Planning 11.x, Capital Asset Planning (Capex), Oracle EPM Essbase 11.x, Oracle EPM Financial Reports, Oracle EPM Web Analysis, Smartview, Oracle 9i, UNIX.

Confidential, Mason, OH

Hyperion Developer

Responsibilities:

• Responsible for providing production support.
• Involved in Backups of all production cubes.
• Responsible for maintaining Hyperion Shared Services for different business segments and then assigned security filters to define Essbase privileges on them.
• Recovered applications from its back up.
• Installed and set up the server with Hyperion Essbase, Hyperion Financial Reporting, and Smart View.
• Set up the server settings, optimized different Essbase objects, and implemented partitioning among different production cubes to improve performance.
• Provided training to end users in using the MS Excel spreadsheet add-in to load data and the basic concepts of multidimensional databases.
• Developed automation scripts for application refresh and backups.
• Created and made changes to the existing MaxL Scripts and scheduled the batch script to automate the running of the new Calc Scripts.
• Created Expense, Plant Variance Reports using Hyperion Reports & Hyperion Web Analysis.

Environment: Hyperion System 9 BI+ (Financial Reporting, Web Analysis), Hyperion System 9 Planning, Hyperion System 9 Analytic Services (Essbase),Hyperion Application Link (HAL), Microsoft Excel 2003, MS SQL Server 2000, Windows 2003, ESSCMD, MaxL, Essbase Excel Add-In.

Confidential, Vernon Hills, IL

Essbase Developer

Responsibilities:

• Analyzed user requirements and actively involved in the process of finalizing views for the existing cubes.
• Involved in developing the star schema for the EIS OLAP model.
• Developed Meta-Outlines for ESSBASE BSO cubes.
• Created Data Load Rules for manipulating records and loading the Enterprise data Ware house using rules files.
• Developed drill-thru reports using EIS.
• Automated the entire cube build process using MAXL. The MAXL scripts build the dimensions, load data, calculate the database and to define partitions. MaxL scripts are also used to do scheduled extraction of data from Essbase cubes using Report scripts. The MAXL scripts are invoked through Batch files on a schedule.
• Analyzed and created the user views for internal and external users and maintained securities on those views using Hyperion Web Analysis (Analyzer).
• Trained the users in administration of Hyperion Analyzer.
• Provided 24/7 hrs support to all the Essbase application and resolved the tickets on Essbase cube issues
• Developed Executive information System's interface reports for end users using Hyperion Dashboard Studio.
• Developed the Daily Sale Reports using Interactive Reporting going against Sales system.

Environment: Hyperion System 9 Essbase, Hyperion System 9 BI+ (Web Analysis, Financial Reporting Dashboard Services and Interactive Reporting), Oracle, Essbase Integration Services (EIS), MS-Excel and Windows 2000

Confidential, Akron, OH

Planning & Essbase Developer

Responsibilities:

• Involved in gathering business requirements, defining, designing, developing, testing and deploying the application.
• Built Outline and security using Hyperion Planning
• Developed web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data.
• Ensured the GL data is loaded into Cube from Data mart using Data Load Rule.
• Extensively worked on financial reports using Hyperion Reports Tool
• Developed numerous Financial reports like Contribution margin, Cost of sales, Operating Profit, Budget and Variance reports by pulling the GL data from the cube using Hyperion Reports.
• Developed Business rules and attached to the input forms to calculate data on save Option
• Designed and developed load rules using the Prep Editor.
• Hands on experience in backup and recovery for Database.
• Involved in designing and developing the corporate financial charts (Look and Feel) and other ad-hoc management financial reports using the Hyperion Analyzer.
• Created Ad hoc financial Reports for the end users to slice n dice the data using Hyperion Analyzer.
• Involved in tuning the applications for better performance by modifying the server wise, application, and database wise settings.
• Involved in designing mechanisms for the server and application / database security, developing Filters

Environment: Hyperion Essbase 7.x, Hyperion Reports 7.x, Oracle 9.i, Hyperion Analyzer 6.0, Windows 2000, Hyperion Planning 4.0, Hyperion Application Link (HAL),Web logic server, Excel Add-in.