SUMMARY:

• Hyperion Certified Consultant (HCC), Oracle DB Certified Professional with 9 years of IT experience in Analysis, Design, Development, Implementation, Administration and maintenance of various applications in Client/Server environment using Business Intelligence (OLAP) and Oracle EPM Product suits(Hyperion Essbase, Hyperion Planning, Oracle Data Integrator, MDM/DRM, EIS,Hyperion Financial Management, FDQM, OBIEE) including all phases of Software Development Life Cycle (SDLC) with different role as a Lead Developer, Business Analyst, Techno - Functional Analyst.
• Strong application development experience using different Oracle EPM Products Hyperion Essbase, Hyperion Planning including Workforce and CapEx Planning,ODI,MDM/DRM, OBIEE- Answer,Dashboard,Publisher, EPM 11.1.x,Hyperion System 9 BI+ Interactive Reporting, Web Analysis, SQR-Production Reporting, Financial Reporting, Work Space, Clarity Performance Management, VBA MACROS, ESSCMD, MAXL SCRIPTS, Shell Script API programming, Report Script.
• Exposure on cash flow Statements, Balance Sheets, Income statement, Key Metrics, Operating and Admin Expenses, and basic knowledge on accounts, GAAP &IFRS.
• Solid experience on Hyperion development, infrastructure and administration activates on Hyperion suite (foundation services, FM application (HFM, HSF, and HDFM), Data management application, BI + reporting services, planning, DRM.
• In-depth knowledge and experience on Installation and configuration of Hyperion EPM Suite (system 9, 11.1.1.3, 11.1.2.2) on windows, UNIX and performance tuning expertise on several Hyperion components.
• Sound experience on migration, up-gradation projects of Hyperion suite (system 9, 11.1.1.3, 11.1.2.2). Independently worked upon migration activates (DEV to UAT, PROD) and upgrading projects (system 9, 11.1.1.3. .1.2.2.300 ) for fortune 500 customers.
• Possess excellent analytical, logical, communication skills, familiar with the SDLC methodology of system development.

TECHNICAL SKILLS:

Software: Hyperion BI+, Hyperion Essbase, Planning, Data Relationship Manager(DRM), Financial Reports (FR), Web Analyzer, Business Rules, Designer (Performance Suite - 8.3), Brio Intelligence 6.6.4, Interactive Reporting, Workspace, Shared Services, EPMA, Excel Add-In, Smart View, Test Director (Mercury Quality Center), SQL and exposure to Hyperion Financial Management (HFM), Financial Data Management (FDM), Oracle Data Integrator (ODI), Rational Clear Quest. Have worked in versions of Hyperion including 6x, 7x, 9.2, 9.3.1, 11.1.1.3 and 11.1.2x. Exposed to OBIEE (10g), Business Objects and Informatica as well.

Databases: Advanced knowledge of Relational Database Management System (RDBMS) databases, Oracle 10g

Operating Systems: Microsoft Windows NT/ 98/2008/2003/ XP and Linux/Unix

Domain: Telecom, Banking, Finance & Insurance, Travel and Hospitality, Media and Information Services, Manufacturing, Energy & Utilities and Data storage devices.

PROFESSIONAL EXPERIENCE:

Confidential, Bethlehem, PA

Hyperion Consultant/ Principal/Architect

Responsibilities:

• Working with Business user to understand current state processes and gathering business requirement
• Analysis and define future state processes based on business objectives.
• Responsible for documenting the system design and reviewing requirements documentation to ensure it is complete, deliverable, and consistent with business requirement and delivered system capabilities
• Understanding the Organization Chart of Account and Defining the Measures /Dimensions and Hierarchy under different Entity, Product, Customer, geography, Departments.
• Designed Essbase and planning applications for all day to day financial data analysis and for budgeting and forecasting purposes.
• Developed complex calculation scripts and formulas for the existing BSO cubes to implement the business logic.
• Worked on Workforce and Total Expense Planning Cubes, Modifying outlines, business rules, calculation scripts, backing up application, reloading data, optimizing as needed.
• Wrote complex and simple business rules and calculation script to meet all the custom calculation needs.
• Designed Outlines, report scripts, Global variables, Location aliases for Essbase application development.
• Designed Data forms, Business rules, menus, task lists, workflow process for planning application development.

Environment: Hyperion EPM 11.1.2.3.500, Hyperion Planning, Hyperion HFM,FDMEE,Hyperion Essbase, MaxL scripts, Hyperion Financial Reports, Oracle Database 11GR2

Confidential, Santa Clara, CA

Sr. Team Lead - Hyperion Consultant

Responsibilities:

• Designed and implemented key finance hierarchies in DRM: Cost Center, Legal Entity, Account, and Product hierarchies for Oracle GL, Fusion HUB, HFM, and Planning.
• As per business requirements for monthly maintenance, Involved in changing the Metadata and mapping with source (PSGL accounts) and target account (HP, HFM, FDM) in DRM and created new version for every month.
• Security Administration Design. Design Node Types, Node Access Groups, and Security for downstream users to allow for mapping reconciliation.
• Design for Mapping of metadata and dollars from Planning to FCS (GL) and OFSA (reporting) - Designed the Mapping solution for dollar uploads, eliminations, intercompany transactions, etc. to facilitate the upload of dollars for Budget from Planning back to OFSA and the General Ledger, FCS.
• Master Data Dictionary, incl. source, integration target, properties/metadata, list of values, business owner.
• Solution/Design Document - DRM build, including source data model for data sources to data targets.
• Involved in every business meeting and translated all business requirements into technical specs and then advised to team create dynamic hierarchies and derived properties.
• Extensively worked on validations, Action scripts, blenders, formulas, derived properties.
• Involved in requirement analysis and documentation leading to an effective Hyperion solution incorporating user needs of converting Excel based Budgeting and Forecasting Process to Hyperion Planning in-order to increase efficiency.
• Gathered user requirements and then transformed them into Dimensions, Attributes and Members for Budgeting, Forecasting and Planning implementations.
• Created business rules that replicate the functionality of complex formulas existing in excel.
• Developed Dynamic Web forms for various users with POVs and Pages and designed the overall workflow of the budgeting and forecasting process with kick-off, reviews and approval states.
• Maintained and supported Hyperion Planning applications also implemented application security process, created users/groups, security profiles and application access to different groups using filters.
• Assisted to team to create and managing the project schedules and plans for Cube build and calc script development, General Expense/Allocation model, Balance Sheet budgeting, P&L Budgeting, Workforce Planning and CapEx Planning.
• Building all Proof of Concept EPM and DRM environments for customers.
• Designing and implementing EPM and DRM environment on customer sites as per expectations.
• Liaising with customer technical departments on best use of resource, infrastructure etc.
• Participated Building POC for EPM up gradation and migrations for couple customers.
• Reviewed couple of customer’s existing infrastructure model and addressed the bottlenecks, performance issue and tuned the parameters at different Layers.
• Implemented SSO for DRM applications for one customer with minimum downtime.
• Suggested High Availability technologies to build in fault tolerance at the core system level.
• Setup Internal EPM server and integrated with ERP and DRM module and implemented SSO.
• Participated various EPM COE activates and training session.

Environment: Hyperion EPM 11.1.2.3,Hyperion Planning, Hyperion DRM,HFM,FDMEE,Hyperion essbase, MaxL scripts, Hyperion Financial Reports, Oracle Database 11GR2

Confidential, San Francisco, CA

Lead Hyperion Consultant

Responsibilities:

• As a technical lead, I am responsible for various aspects of application and infrastructure architecture set up: project planning, requirements gathering, scope management, change control, execution oversight, issue management, and risk mitigation for all on demand customers.
• Involved in every aspect of on demand life cycle management, including requirements gathering for workflows and change management and incident management.
• Directly responsible for outlining the technical architecture of the EPM system, including the Sandbox, Development, System Test, Production, Training and Disaster Recovery environments andUtilized High Availability technologies to build in fault tolerance at the core system level.
• Principal designer for the EPM systems Disaster Recovery Plan (“DRP”). The DRP is designed to minimize the time required to cut over to the DRP site while ensuring that data and productivity loss is minimal.
• Extensively involved and work with US, APAC customer for new Hyperion ENV setup as per on demand standards and Enforced database standards, best practices, methodologies, processes and procedures.
• Almost 20 new customer, we have set up new Hyperion ENV as per on demands standards and involved in every aspect of infrastructure set up for all customer including installation &configuration, migration activities for fortune 500 customers.
• Extensively worked on troubleshooting and performance tuning activates on EPM suite (Foundation services, FM application, data management application).
• Responsible for Change management and incident management for prod environment and extensively worked on backup and restoration activates, Managing Hyperion Services for up to time, managed outages.
• Responsible for developing the security plan which was used to set up company security for all EPM suite as per on demand standards and Enforced database standards, best practices, methodologies, processes and procedures.
• Responsible for making sure all work is completed on time and Ability to motivate and lead team members to reach organization goals and objectives.

Environment: Hyperion ver 11.1.2x HFM, FDQM, DRM, HSF,Workspace, Smart View, FRs, Shared Services, Planning, EPMA, Essbase, Excel-AddIn and Service Now.

Confidential

Senior Hyperion Consultant

Responsibilities:

• Worked with senior management and end users to define scope of the requirements for new systems and enhancements and issues.
• Maintained the system continuously to perform maximum efficiency.
• Proactively supported for BAU activates and implemented the same without failure.
• Extensively worked with business users for every month BAU release to run smooth and implemented the same as per business requirements like Metadata maintenance in DRM, FDM, and HFM.
• Designed and implemented key finance hierarchies in DRM: Cost Center, Legal Entity, Account, and Product HFM, Planning.
• As per business requirements for monthly maintenance, Involved in changing the Metadata and mapping with source (PSGL accounts) and target account (HP, HFM, FDM) in DRM and created new version for every month.
• Configure Data Entry Forms by using Web Applications and Creating Grids as per requirement.
• Managing POV in the explore data setting.
• Set up security, including users, groups, security classes, and access rights.
• As per the business requirements, modified existing rules, Re-created, implemented new rules to fulfill business requirements.
• Effectively implemented HFM best practices on existing application to improve performance and high availability for end user.
• Implemented performance tuning and oracle recommendations on different Hyperion applications like shares services, workspace, HFM application to give more band width to the end users.
• Extensively worked with different internal teams and External vendor (Oracle) on different issues like performance tuning and FDM &HFM application issues.
• Installed tested patches into the production environment and documented all associated patching procedures, including specific configurations required.
• Proactively monitored the performance of the production database and Application components.
• Worked with database team for backups are performed in keeping with agreed back-up and recovery requirements.
• As an admin, involved in migration, up gradation, patch installation, performance tuning on different Hyperion components.
• Involved in Disaster Recovery testing and coordinate with different internal teams (windows, UNIX, oracle, control-m, NAS, enterprise storage, Business team) for testing and for internal audit prospective whether system is up and running.
• Effectively working on HFM housekeeping tasks such as Extracting and deleting task& data audit of the various objects that make up the database and application healthy.

Environment: Hyperion ver 11.1.x Essbase, Planning, EPMA, Shared Services, Workspace, Smart View, Excel Add-In, HFM, FDQM, FRs in Unix & Windows box, MS-Office suite and Informatica.

Confidential

Senior - Hyperion Consultant

Responsibilities:

• Understand Business requirements and extensively worked on NEW system.
• Worked heavily with senior management end users to define scope requirements for new systems and enhancements.
• Involved in preparation of tech specs (Data mapping docs) based functional specs and assist same to the team.
• Work closely with data architecture, IT and infrastructure teams.
• As per client request implemented new FR’s on the system and installed EPM11.1.1 and configured with FDM.
• Metadata Reconciliation and Financial Master Data Management Hierarchy Techniques and Best Practices. Give the bank best practices for Hyperion Solution Hierarchy design and maintenance in DRM.
• Security Administration Design. Design Node Types, Node Access Groups, and Security for downstream users to allow for mapping reconciliation.
• Design for Mapping of metadata and dollars from Planning to FCS (GL) and OFSA (reporting) - Designed the Mapping solution for dollar uploads, eliminations, intercompany transactions, etc. to facilitate the upload of dollars for Budget from Planning back to OFSA and the General Ledger, FCS.
• Master Data Dictionary, incl. source, integration target, properties/metadata, list of values, business owner.
• Solution/Design Document - DRM build, including source data model for data sources to data targets.
• Doing Consolidations and Analysis through HFM Client and Web.
• Extracted data from source system (general Ledgers), validated /Transformed/cleansed data into FDM and mapped to the respective accounts into HFM application.
• Extensively worked rules in FDM to load data into HFM application.
• Creating Grids by using Explore Data modules and created Dynamic member list as per client request.
• As per client requested created &modified business rules.
• Validation of Grids after load and consolidation.
• Involved in changing the Metadata whenever needed.
• Configure Data Entry Forms by using Web Applications and Creating Grids as per requirement.
• Managing POV in the explore data setting.
• Set up security, including users, groups, security classes, and access rights.

Environment: Hyperion ver11.1.1.3,HFM,DRM, Planning, EPMA, Shared Services, Workspace, Smart View, Excel Add-In, OBIEE(10g)

Confidential, TX

Team Member - Hyperion Consultant

Responsibilities:

• Installation and Configuration of Essbase Analytical server, Administration Server and Administration Console, Essbase Excel Add-Ins and Hyperion Analyzer for development, tests and production environments.
• Involved in Development and performance-tuning with Hyperion Analytic Services (Essbase) multidimensional databases including Outline, Rule Files, Calc Scripts, Reports, database optimization
• Maintain Hyperion Servers; create batch files and Maxl scripts to automate the data load process, Dimension Building, calculations and backups.
• Creating Calculation scripts, MaxL script for process automation.
• Migration to new production server and supporting end user, planners for budgeting.
• Daily and weekly back up process as well as Data loading job monitoring.
• Reporting using Excel add-in, Hyperion Analyzer.
• Creating Repository for Hyperion Planning Application.
• Building Planning Application and building metadata using HAL.
• Loading planning data using planning desktop and smart view client.

Environment: Hyperion EssBase 7.1.2, Hyperion Planning, Tools: SPC Excel Addin, Excel Macros with VBA, Esscmd, Shell scripting, MaxL scripts, Hyperion Reports, Hyperion Analyzer O/s: windows

Confidential, Austin, Tx

Hyperion Consultant

Responsibilities:

• Extensively worked with business users for every month BAU release to run smooth and implemented the same as per business requirements like Metadata maintenance in Hyperion Applications.
• As per the business requirements, modified existing rules, Re-created implemented new rules to fulfill business requirements.
• Involved in importing data from different data sources including OLTP/OLAP database, excel and text file to Essbase cube. Merged and aggregated data from different data sources. Created and maintained Rule files, Report Scripts and Calc Scripts.
• Maintained and updated members, outline, and alias automatically using Batch files and MaxL.
• Worked on the performance tuning (Cube Optimization) of the Applications for the fast data loads, better calculation times of the cubes and fast retrieval of the reports using the Dense/Sparse settings, Cache settings, Outline formulas and Calc scripts.
• Developed Excel Templates for user interface in Essbase database.
• Used Essbase Administration activities such as filter creation, creation of users, and creation of groups and maintenance of Essbase Servers.
• Extensively implemented unit testing for everything release.
• Installed tested patches into the production environment and documented all associated patching procedures, including specific configurations required.
• Apply various Filters for efficient and accurate retrieval of required data. Viewer.
• Designed and developed various types of reports (Pivot, Tabular, and Chart and OLAP Query reports) to be used by various user groups using Hyperion Intelligence.
• Drill Down functionality applied for most of drill down functionality like Summary Level,
• Customer Level and Territory Level.
• Develop Custom Hyperion Query reports with complex user interface (Dashboards) utilizing multiple database environments to provide real time reporting capabilities.
• Created and managed BQY job schedule, created and managed time events using on-demand sever.

Environment: Hyperion System 9, Hyperion system BI +, Essbase integration services, Hyperion Planning, Hyperion BRIO, Hyperion Reports, MS Excel Add-In, Oracle, Windows2000 server

Confidential, Bothell, WA

Team Member - Hyperion Consultant

Responsibilities:

• Performed Data Analysis and testing on various new AT&T mob products to be launched in Market.
• Written test case scenarios, test cases and executed them in Toad
• Supporting existing reports and developing ad-hoc reports from different data sources using Hyperion Interactive Reporting
• Performing monthly maintenance - workflow, user provisioning, data load, aggregation etc
• Production support activities including maintenance of sub-vars, calc scripts, rules file and creating Adhoc reports.

Environment: Toad, SQL (Oracle 9), Siebel, Test Director (Mercury Quality - Centre), Interactive Reporting, Essbase, Planning and Web Analysis

Confidential, Miami, FL

Team Member - Hyperion Consultant

Responsibilities:

• Facilitating the up-gradation from Brio Intelligence 6.6.4 version to Hyperion (System 9).
• Written Unit test case scenarios, test cases and executed them
• Supporting existing reports and developing ad-hoc reports from different data sources using Hyperion Interactive Reporting
• Formulating reports from different data sources using Hyperion Interactive Reporting
• Devising the EIS dashboard screens, pivots and charts to help user understand data.
• Performing monthly maintenance - workflow, user provisioning, data load, aggregation etc
• Production support activities including maintenance of sub-vars, calc scripts, rules file etc
• Maintaining workflow, Handling data/dim load, user provisioning etc

Environment: Hyperion ver 9.3x, Brio Intelligence 6.6.4, Hyperion Interactive Reporting, Essbase, Planning, Web Analysis and Rational Clear Quest

Confidential

Team Member - Hyperion Consultant

Responsibilities:

• Accumulating details of all databases and analyzing them to find out if they all can talk to one common tool for reporting purpose.
• Centralizing different source’s data to produce consolidated report for CXOs
• Processed all sample databases information in one common pool and generated reports out of it to be viewed at CXO level via Interactive Report

Environment: Hyperion ver 9x Interactive Reporting (Reporting Studio)

Confidential

Team Member - Hyperion Developer

Responsibilities:

• Completed Hyperion transition from client and then further hand-over to team members.
• Requirement gathering from business and creation of multiple reports requested by business and scheduled their execution and circulation via automated batch process.
• Help users troubleshoot their issues related to .bqy file to be used by them for querying their data or related to ODBC connection to .oce files etc.
• Optimization of slow performance issues.

Environment: Hyperion Designer (Hyperion Performance Suite - 8.3)

Confidential

Hyperion Developer

Responsibilities:

• Regular production support and maintaining application hierarchies, properties and application in Planning and Essbase (BSO).
• Perform Admin tasks including monitoring data loading by HAL, data extraction, planning refresh, Workflow, managing budgeting process, Sub Var set up etc
• Creation of data forms, calc-scripts, user security matrix for new application implementation.
• Launching Business Rule, Calc Script for substitution variables and location aliases.
• Used Essbase administration activities such as filter creation, creation of users, and creation of groups and maintenance of Essbase Servers.
• Performed tuning of the BSO cubes by arranging the dimensions according to the hourglass model, usingSparse/Dense setting, and various other techniques.
• Execution of Test cases during Upgrade from Sys 7 to Sys 9 Hyperion
• Worked on maintenance of Partitioned cubes as well
• Preparation and maintenance of documents for Audit perspective

Environment: Hyperion ver 9x, BI+, Hyperion Essbase(ver7), Hyperion Planning(ver4), Hyperion Reports (Financial Reports), Hyperion Analyzer (Web Analysis), Hyperion Business Rules, Workspace and Shared Services.