SUMMARY:

• 16 years of total work experience with 11 years of expertise in Business Intelligence as in IT consulting, Solution Design, administration and Integrations primarily into OLAP with focus on Hyperion Suite of Technologies (Essbase, Planning and Financial Reporting).
• Hyperion System 9.x / Oracle EPM 11.x - Design and Development of EPM Applications using Hyperion Essbase, Planning, FDM and ODI.
• Expertise in Hyperion Infrastructure Setup - Installation and Configuration of Hyperion environment for components: Essbase, Planning, Reporting, FDM, FDMEE, ODI, DRM etc.
• Strong Experience in upgrading Hyperion Suite of applications from 7.x and 9.x to 11.x.
• Expertise in Hyperion upgrades in Heterogeneous platforms and proven expertise in upgrades with different approaches.
• Done upgrades in Direct Upgrade Approaches.
• Expertise in Design Assessment, Code Review & Optimization, Performance Assessment and Performance Tuning.
• Fluent in using Hyperion Essbase Application Manager modules; Outline Editor, Report Editor, Calc Script Editor, and Data Prep Editor.
• Hands on experience on developing Hyperion Financial Reports.
• Maintained database optimization while performing Data Loading, Business Rules, Calculation Scripts, and Report Scripts.
• Proficient in dynamically building Dimension members, Attributes using rule files and loading Fact data in an ESSBASE Applications by means of several build methods such as generation, level and parent-child s
• Extensive experience on server settings, backups, client installations of Hyperion products such as Essbase, Essbase Integration Services, Analyzer and Hyperion Reports on Windows environment and Linux.
• Security Management through restricting user accounts with Roles and Privileges.
• Possess a good knowledge of relational databases design and implementation, PL/SQL skills, RDBMS development knowledge and understanding of relational data marts.
• Well versed with SDLC and followed it extensively in projects.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• Excellent communication skills, team player with excellent analytical skills & problem solving aptitude.
• Possess ability and willingness for learning new applications as needed.

SKILL:

OLAP Application: Hyperion System 11.x, Hyperion Essbase/Planning 11.x/9.x,Financial reporting, ARM, Excel Add-In, Essbase Integration Services 9.x, ESSCMD, MAXL, Essbase Administration Services

Hyperion Tools: Hyperion Shared Services, Calc Manager

Web Analysis, Excel Add: Ins, Financial Reporting, Smart View

MS: Office

Operating System: Linux, Windows XP, Windows Server 2003, Windows Vista/7

ETL Tools: Oracle Data Integrator 11g

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, Texas

Hyperion EssbaseTechnical Specialist

Responsibilities:

• Recommendations of Infrastructure Configuration for IPF.
• Installation and Configurations of Hyperion Modules and PSU.
• Solution design for Forecast Planning.
• Logic Design using SQL to extract data from CPF MART (IBM Netezza data warehouse) to load to Essbase ASO Cubes for Bank Applications (Credit Card, Deposits and Consumer Loan Cubes).
• Performing Monthly Loads.
• Monitoring automated Jobs through Control-M and fixing code or PROCESS in case of failure.
• SmartView VBA Code Conversion.
• Production Deployments using LCM.
• Developing ASO Member formulas.
• Creating scripts using ESSCMD and MAXL
• Creating Rule file for Metadata Updates.
• Supporting ETL, ODI and Hyperion for Workforce and Market forecast Cycle.
• Updating and creating new Control M jobs as per Business Requirement.
• Requirement gathering from Business, preparing Tech design docs.
• Preparing and Presenting Proof of Concepts to Client.
• Good understanding of Agile Methodology.
• User on SmartView, Hyperion Planning and Reporting tools.
• Developing test cases and executing them for all changes implemnented as a part of QA
• Performing Root cause analysis for the issues raised during forecast cycle and documenting them.

Confidential, Billerica, MA

Principal Hyperion Consultant

Responsibilities:

• Developed planning forms to facilitate use of systems
• Created a basic outline structure to be used by all subsidiaries regardless of the differences in their chart of accounts
• Coordinated security and role-based provisioning across multiple product suites.
• Assisted in updates of Hyperion budgeting forms and reports to reflect new company structure
• Built standardized Excel Essbase templates for detailed monthly reporting
• Developed a package for new Hyperion users and led multiple sessions from beginning to expert levels
• Ensure monthly close process runs smoothly in Hyperion Planning & FDM, DRM, ODI and Essbase applications
• Create ODI project to map from source (EBS) to Hyperion Planning.
• Installation and configuration of all Hyperion Modules on Exalytics Linux Boxes for Staging and Production Environment (Foundation Services, Essbase, Planning, HFM, Calc manager, FDMEE, ARM,TAX MANAGEMENT )
• Following up with Server team to get all perquisites to be implemented before starting the Installation.
• Performing Post Configuration tasks like JVM Updates, Patching, and WebLogic Changes.
• Smoke Testing of all the Hyperion Products.
• Applying Required Patches on the servers for Hyperion modules for bug fixes, Functionality updates and Version Upgrades
• Preparation of detailed documentation on EPM suite installation on Oracle Exalytics boxes.
• Working with DBA and infrastructure teams on space and memory updates.
• Migration of Financial Essbase cubes from Existing Production to newly built Exalytics Production Environment.
• Creating Maxl Scripts, Shell Scripts to implement the backup Process for existing applications and Data. (Automation of application backup using LCM).
• Preparation of detailed documentation on the backup process implemented Oracle Exalytics boxes.
• Deploying Planning, Essbase, HFM, FDMEE, ARM, Workforce and CAPEX applications.
• Performing the smoke test on Deployed Applications and providing Test cases to users for UAT.
• Moving SQL Scripts/ Shell Scripts/Maxl Scripts and make necessary edits to scripts to make all scripts ready for Target Environment.
• Monitoring the current Production environment servers for performance and stability
• Setting UP DR environment.
• Maintain Essbase, Managing database settings, optimizations, attributes, Essbase Cache settings, optimizing calculations and reports.

Environment: Hyperion Essbase, Planning, Foundation Services, HFM,FDMEE, FCM,TAX, Calcmanager, Smart View 11.1.2.4, Oracle 10 g, Oracle Data Integrator 11g, SQL Developer, Linux.

Confidential

Lead Hyperion Essbase Consultant

Responsibilities:

• Involved in Business requirement gathering and Preparing Technical design Doc.
• Recommending Server configuration for Dev, QA and Prod Environment.
• Resource Planning, Preparation and Presenting Proof of Concepts to Clients.
• Application Creation in Hyperion Planning
• Loading Metadata into the planning application.
• Developed web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data.
• Created Calculation scripts & Variables as per the requirement.
• Developed Business rules and attached to the input forms to calculate data on save Option.
• Developed Essbase cubes for Sales, Production, Planning and Budgeting.
• Developed Essbase member formulas for position count accounts based on position flag and CalcScripts using advanced CalcScripts functions.
• Developed Load Rules for loading dimensions and data into Essbase cube.
• Optimization of Cube performance.
• Developed Business Rules for Update Budget, Forecast, Copy Scenarios, Monthly Salary Calculations, Bonus Accruals and so on for Salary Planning Applications.
• Work with the team to ensure that the project deliverables are met Share knowledge and provide support to the fellow team members to resolve the issues faced.
• Encouraging open dialogue in/ amongst the teams appropriately.
• Referring to past experience to suggest an approach.
• Identifying root cause of the problem and provides solutions.
• Monitoring and triggering failed jobs of DOMESTIC Nightly batch process.
• Created the ODI interfaces needed to extract the Accounts and members from the existing application and map them to the new value in the new application
• Assist end-users with developing complex reports using Essbase to meet analytical requirements and effective forecasting.
• Writing and executing test scenarios for Business Rules Execution.

Project Hyperion Administration Support

Confidential, Atlanta, GA

Responsibilities:

• Maintain Hyperion Production, QA and Development Environments.
• Monitor nightly batch Job Processes and schedule manually based on requirement or failures.
• Monitor the application backup Process.
• Maintain log files and archiving logs as per process.
• Monitoring of disk space, CPU Utilization and Memory.
• Trouble shoot error logs during data and Metadata Load.
• Coordinate with IT and Server Teams.
• Work closely with implementation and application team to understand the changes.
• Preform Environment Refresh.
• Starting and Stopping Services.
• Documenting changes to Infrastructure and Configuration Settings.
• Coordinate with Oracle to resolve any Hyperion Related Challenges.
• Email Scheduled outage communication to Business Users.
• Monitor remedy queue for New Tickets and act upon those Tickets.

Environment: Hyperion Essbase/Planning 11.1.2.2, Excel Add-In, Smart View 11.1.2.2, Oracle 10 g, Linux, Oracle Data Integrator 11g, SQL Developer, Linux, Oracle Data Integrator.

Confidential

Responsibilities:

• Installation and Configuration of Hyperion11.1.2.3 Products.
• Creating PSPB Planning application.
• Customization of the Default artifacts and creating new Artifacts according to Client Requirement to maintain HRMS Data.
• ODI Integration to load metadata (Employee, Account, Position and Salary grades Dimensions) to planning application from HRMS.
• Creating FDQM Application.
• Setting up ADAPTER Settings and Mapping definitions in FDQM to load data.

Environment: Hyperion Essbase/Planning 11.1.2.2, Excel Add-In, Smart View 11.1.2.2, Oracle 10 g, Linux, Oracle Data Integrator 11g, SQL Developer, Financial data Quality Management .

Confidential

Responsibilities:

• Build Operations &Maintenance Planning Lignite, Gas, Support & Nuclear Web forms.
• Build Metadata Interfaces - Location, Department and Project
• Build Data Interfaces for Actual, Plan & Forecast
• Build Data Interfaces for Employee/Labor from Hyperion WFP

Confidential, NY

Responsibilities:

• Application Creation in Hyperion Planning
• Loading Metadata into the planning application.
• Developed web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data.
• Created Calculation scripts & Variables as per the requirement.
• Developed Business rules and attached to the input forms to calculate data on save Option.
• Created the ODI Interfaces and Project to map and load metadata to planning applications from EBS and HRMS.
• Involved in optimizing the views created to extract the metadata in parent child format.
• Involved in Complete automation of metadata, data loads and aggregations to planning applications using shell scripts.
• Created users and user groups in the Planning applications and assigned security to web forms.
• Maintenance and troubleshooting of the Server Issues (on different Environments).
• Preparation of Complete end-end ETL Document for Metadata and Data loads.

Environment: Hyperion Essbase/Planning 11.1.2.1, Excel Add-In, Smart View 11.1.2.1, Oracle 10 g, Linux, Oracle Data Integrator 11g, SQL Developer.

Confidential, CA

Responsibilities:

• Upgrade of 1 Essbase and 3 Planning Applications from V 9.3.1 to V 11.1.2.1.
• Extracting Planning Metadata Using Outline Extractor from V9 applications.
• Formatting the files as required by outline load utility to import metadata to V11 applications.
• Importing metadata using Outline Load utility.
• Web forms upgrade using Formdef Utility.
• Exporting and Importing of Business Rules from V9 to V11.
• Setting up of Locations and Access Privileges to Business Rules.
• Validation of all Artifacts migrated from V9 to V11, recommended code changes with respect to the validation reports and performance issues.
• Setting up of Shared Services Security.
• Planning and Essbase Object level security using Export Security and Import Security Utilities.
• Prepared Unit Test Document by performing Unit Testing on all Upgraded Applications.
• Migration of all Application from Development Environment to QA Environment using LCM.
• Issues resolving during the testing performed by the Support team of the Client.
• Preparation of Development Server Installation and Validation documents, Hyperion Planning and Essbase Migration plan document, Smart View document to users, LCM Migration document and Security Migration Document.

Environment: Hyperion Essbase/Planning 9.3.1 , Hyperion Essbase/Planning 11.1.2.1, Excel Add-In, Smart View 11.1.2.1, Oracle 10 g, Windows 2008 R2 .

Confidential, NY

Responsibilities:

• Setting up of UAT Environment for Hyperion Products Foundation Services, Essbase, Planning, EPMA, Financial reporting, FDM on distributed Servers (3 Servers).
• Migration of Planning and Essbase applications from Development Environment to UAT Using LCM.
• Exporting and Importing for FR reports from Dev Server to UAT.
• Loading level0 data and running aggregation scripts.
• Involved in Data Reconciliation.
• Shared Services and Object Level Security Setup.
• Documentation of Installation process and LCM Migration Process.

Environment: Hyperion Essbase/Planning 11.1.2.0, Excel Add-In, Smart View 11.1.2.0, Oracle 10 g, Windows 2008 R2 .

Confidential

Responsibilities:

• Involved in INSTALLATION and Configuration of HYPERION products on Linux Server.
• Understanding of Existing System.
• Taking the Lev0 data backup for all the applications.
• Taking the entire app directory backup excluding data files.
• Placing all the backups in the staging area.
• Creating applications and databases.
• Move the Outlines, Rulefiles and Calcscripts to the respective databases.
• Verifying and Restart the applications.
• Moving the Lev0 data from staging to the respective applications.
• Loading the Lev0 data application by application.
• Data Reconciliation with Old and New System.
• Shared services user setup.
• Writing and validating test cases.
• Provided and scheduled automated scripts on services stop and start, daily data backup and archiving database.
• Involved in Preparation of Design Document, Test plan document, UAT Manual, Installation document.

Environment: Hyperion Essbase11.1.1.3 , Hyperion Shared services, Excel Add-In, Linux.