SUMMARY

• Around 7 years as a Hyperion Consultant, extensive hands on technical experience in many aspects of Data Warehouse and OLAP software systems design and implementation.
• Experience in the Implementation, development, design, analysis of various applications using Essbase 11.x/9.x, planning 11.x/9.x, HFM, ODI, Hyperion Workforce Planning, Hyperion Capital Expense Planning, Essbase Integration Services, Hyperion financial Reports, Essbase Studio and Essbase Spreadsheet Add - In, & Smart view.
• Worked on installation and configuration of Hyperion EPM 11.1.2.4 versions on windows/Unix environments.
• Extensive experience in all critical phases of Software Development Life Cycle (SDLC) like research, analysis, design, modeling, development, testing, deployment, and support.
• Organized & maintained financial records & applied GAAP to company's accounting practices.
• Good understanding of RDBMS, data warehousing, data reporting and experienced in writing queries using SQL.
• Experienced in dimensional modeling using Star Schema and Snow-Flake Schema.
• Monitored and validated that all aspects of capital projects and spending were in compliance with Capital Policy, SOX and GAAP.
• Extensive experience in design, development, performance tuning and optimization of Essbase databases. Well versed in Essbase architecture, Calculation Scripts, Business Rules, Aggregate Storage Option (ASO), Block Storage Option (BSO), MDX Member calculations, ESSCMD, MaxL for batch scripting, and shell scripting.
• Worked extensively on Hyperion Financial Reporting Studio, created & edited Financial Reports.
• Understanding of Essbase & Planning security features and ability to create user and group profiles, and assign the proper privileges.
• Experienced in knowledge transfer, preparing the required documentation, training the clients.
• Proficient in writing Stored Procedures and Triggers using SQL and PL/SQL on Oracle/SQL Server databases.
• Strong communication, organizational and interpersonal competencies along with detail oriented and problem solving skills in the technology arena.
• Excellent rapport with management in all the projects and worked in close collaboration with team members to ensure enhancement of quality
• Quick learner with respect to new technologies, best practices and techniques.
• Strong knowledge in creating documentation and end user training on Hyperion Essbase/Planning applications developed.
• Extensive knowledge on the Oracle EBS Modules like AP, AR, HRMS and integrated them to the Hyperion applications.
• Solid understanding of Multidimensional and Relational database architecture; Extensive knowledge of Planning, budgeting, and forecasting procedures.
• Strong knowledge in financial reports, charts, pivots, dashboards, books, batches, snapshot reports using financial reporting studio.
• Strong Knowledge in migration process of applications from one environment to other using shared services and other back end techniques.
• Automated daily database backup and Essbase file back up using MAXL and window task scheduler.
• Monitoring the jobs and troubleshoot on any event of job failure.
• Maintaining Hyperion servers and monitoring disk space and consumption in servers.
• Developed Use Cases for the main modules and describe the requirements to the developers.
• Worked closely with the development team to communicate client requirements
• Worked closely with the Project Manager in handling the scope creep and analyzing its effects
• Provided key input in working with users in defining project and system requirements.
• Communicate any final adjustments required based on user feedback.
• Strong knowledge in writing test cases to validate the applications developed and performed Unit Testing, Black box/White box testing and performed regression for the applications developed.
• Excellent communication skills and capable of working with IT and FPNA Team
• Strong knowledge in creating documentation related to functional as well as technical requirements and preparation of knowledge Transfer documentation as per the client requirements.
• Experienced in Oracle Data Integrator (ODI) and Financial Data Quality Management (FDQM) to load both metadata and data and extracting data using outline data extractor.
• Excellent analytical, programming, written and verbal communication skills.
• Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.

PROFESSIONAL EXPERIENCE

Confidential, Blue Ash, OH

Sr. Hyperion Consultant

Responsibilities:

• Gathered requirements from end users and developed the design of the essbase outline.
• Gained extensive knowledge on financials and reporting procedures of the organization.
• Designed and developed the ClassicHyperionplanning and EPMA applications according to the gathered requirements.
• Involved in database and security refreshes inHyperionPlanning and Essbase.
• Created rule files to load data into the essbase outline HPCM apps admin support, Security provisioning, supporting Month end close process.
• Involved in transitioning to Oracle Data Integrator as the load tool used to load data to essbase.
• Developed load packages, interfaces and scenarios within ODI to automate the load process.
• Designed security groups and assigned security to application, data forms and reports.
• Formulated and executed calculation scripts to calculate essbase data along with data entered by end users in data forms.
• Designed and created financial reports according to the requirements given by end users using HyperionFinancial Reporting Studio on a monthly and quarterly basis.
• Installed Smartview in the systems of the end users and trained them on retrieving data forms and reports into Smart view for their convenience.
• Produced and scheduled batch jobs for complete automation processes for application refresh and execution of calculation scripts.
• Migration of various components of the application including reports, calculation scripts, and outlines using Life Cycle Management Utility (LCM) among development, test and production environments.
• Extensively involved in training end users with essbase concepts, and usage of planning application, running reports and Smartview.
• Performed quarterly security reviews with management and audit by running the provisioning reports from shared services and updating them accordingly.
• Configured active and native directories in shared services.
• Successfully took part in the project of making the application SOX compliant according to the guidelines of the company.
• Identified various ways to migrate different components of the application between environments and assisted in technical writing of the procedures.
• Involved in establishing a change management process where every change made to the application is ticketed and is passes through the version control tool.
• Worked on Essbase studio.
• Involved in other administration tasks like assigning security, starting and stopping services, installing patches.

Environment: Oracle Essbase 11.1.2.4,HyperionPlanning 11.1.2.4, Dodeca,HyperionFinancial Reports 11.1.2.4, Essbase Admin Services (EAS), HPCM, Autosys, Essbase Scripting, MAXL, Smart view, Unix Shell scripts, Oracle 11i, SQL Server 2008, MS Excel Add-in, .Net, Unix.

Confidential, Cincinnati, OH

Hyperion Consultant

Responsibilities:

• Involved in defining requirements, functional specifications, designing documentations and testing strategies.
• Involved in creating Meta outlines using Metadata extracts from PeopleSoft files in Hyperion EPMA.
• Developed Data Load Rules, Calc Scripts & Report Scripts.
• Created ASO cube for historical data linked to forecast cubes by partition.
• Created new members into the Existing hierarchies with the desired member properties as per the client’s requirement, using the ADS files.
• Developed a Planning application from the created dimensions and successfully deployed it.
• Worked extensively on planning application for Planning, budgeting and Forecasting (PBF), Business Rules and web forms for planning users.
• Created web forms to enter, update, analyze, print, and report on data.
• Developed the Consistent Financial & Interactive Reports & moved them to Production.
• Developing numerous simple to complex Business Rules and attached them to the web forms.
• Worked on creating, maintaining, and supporting all application objects including outlines, calculation scripts, rules files for dimension building and data loading, creation and optimization of transparent partitions, and security objects through Essbase Administrative Services (EAS), MaxL, MDX queries, and ESSCMDs.
• Used Life Cycle Management (LCM) for migrations between different environments, Development to QA, QA to production.
• Worked on Excel spreadsheets using Excel-add in for data cleansing and validation.
• Prepared Quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers.
• Involved in Loading Sales, Revenue, and Head Count Data to cubes, creating current Actual/Forecast/Budget members.
• Involved in creating cubes, outline modifications, maintenance of batch scripts, scheduling runs, developing report scripts and load rules.
• Worked on Automation using batch scripts, optimization of report queries in Microsoft Excel, creating ad-hoc reports for decision makers using Smart View and other applications.
• Developed web forms using Hyperion Planning for the users to input data.
• Developed various financial reports on Excel spreadsheets add-In using Essbase Query Designer for analyzing the data at different levels and for data validations.
• Involved in mapping data from Hyperion Essbase to the relational source, and running ad-hoc queries for providing optimized reports.
• Responsible for month-end tie-out and provide related support to financial controllers.
• Supported users during User Acceptance Test (UAT) by troubleshooting and resolving outstanding issues/problems faced by users.
• Prepared Quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers.
• Created Web Analysis reports for the users for those reports where they wanted to use the Drill down Functionality effectively and some Ad-hoc reporting.
• Involved in filing Service Requests (SR) to the Oracle if there were any production issues.
• Detailed documentation for everyday-easy to use maintenance guide for DBAs and financial controllers.

Environment: HyperionPlanning System 11.1.1.3,HyperionEssbase 11.1.13, Financial Reporting 11.1.1.3, Smart View, Essbase Excel Add-in, Oracle 10g, Windows Server 2003, MaxL, Esscmd, Shared Services 11.1.1.3 Enterprise performance management (EPM).

Confidential, Cincinnati, OH

Hyperion Analyst

Responsibilities:

• Designed and developed web forms for the data input as per business requirements using HyperionPlanning.
• Coordinate the preparation and consolidation of monthly headcount reporting.
• Review, analyze and corroborate monthly expenses and payables
• Involved in migration of planning application from Development to QA to Production.
• Involved in database and security refreshes inHyperionPlanning.
• Used Business rules for allocation and budgeting inHyperionPlanning.
• Involved in Unit Testing to test the Web forms and their associated business rules functionality.
• Written MaxL Scripts to automate the process of dimension build and data load.
• Created Users & Groups inHyperionSystem 9 Shared Services and given appropriate access to the users for the cubes.
• Analyzed user requirements and involved in the process of finalizing dimensions for cubes.
• Created and maintained ASO/BSO cubes as per user requirements and performed optimization by using appropriate dense/sparse configuration, outline structure strategies such as dynamic calculations, attribute dimensions, partitioning etc. and optimization of Calc scripts and tuning of Calc cache.
• Involved in Development and performance-tuning withHyperionAnalytic Services (Essbase), multidimensional databases including Outline, Rule Files, Calc Scripts, Reports, database optimization.
• MaintainHyperionServers, create batch files and MaxL scripts to automate the data load process
• Implemented application security process, created users/groups, security profiles and application access to different groups using filters.
• Provide support and training for new and experienced Essbase users.
• Optimized the applications to reduce the calculation time and database size considerably.
• Extracted the reports using HFR and Smart View.
• Restored database by taking regular backup in case of database corrupt or server crash.
• Automated the daily general ledger load intoHyperion, and added extra error checking and automated notification processes, so the team is immediately aware of any data, server or process-related issues. The log files had to be manually checked on a daily basis prior to this change.
• Worked closely and pro-actively with project leadership to identify and resolve key risks with the Hyperionupgrade project.
• Provided technical leadership and mentoring, helping those on the team less familiar withHyperion System 9 to come up to speed.
• Intervened in production support issues as necessary to improve issue turnaround time as well as the customer's perception of the team's customer service.

Environment: Hyperion Planning and Essbase 9.3.1, Shared services, Oracle 10g, Financial Reporting, Hyperion Interactive Reporting MaxL, ESSCMD, Smart View for Office, MS Project, OracleDB, L, Unix, MS-Visio, MS-Project.

Confidential

Hyperion Essbase & Planning Developer

Responsibilities:

• Provided admin support for VSD Essbase apps on HP-Unix & Planning apps on Windows server,
• Support involved managing Six Planning apps (they are WOS, SGA, Strpyrl, 10kcheck, Mktg and SlsCOGS) and twenty VSD Essbase app (Backorder, Books, Colsize, Excess, Mps Chnl, InvMgm, Tchannel FscDmd and so on)
• Maintained transparent/replicated partitions, resolving data and roll-up issues.
• Admin tasks like starting and stopping Essbase server on Unix during production outage.
• Managing essbase processes, Monitoring Back-ups, review the log files both on windows and Unix platform. Restoration of Essbase & Planning applications from back-ups.
• Created and maintained Strpyrl Planning app that contains store expenses for approx. 323 stores, they are selling (excel Proc) dollars, Wage rate, processing dollars, project dollars & actual-OT etc.
• Maintained user security admin tasks involving existing users and groups, creating new users and groups, provisioning security to users (MSAD authentication), security filters, refresh security from Shared Services and then through planning web client.
• Monthly review meetings with customers discussing enhancements and on-going production issues.
• Worked closely with business users, extensively involved in gathering requirements and created application design specific document.
• Actively involved in production support of existing Essbase cubes and Planning applications, resolving data, job scheduling, and automation, Security & connection issues.
• Extensively worked on Hyperion Financial reporting studio and developed financial reports related to Inventory, Level 0 P&L Quarterly Brand report, level 4 P&L detail/YTD.
• Monthly, Quarterly & Year-end maintenance like roll forward substitution variables, Modifying exchange rates (i.e. end of the month (EOM) and average rate), Modifying data forms, Calc scripts and executing them for WOS & 10kcheck Planning apps.
• Worked on converting BSO application to ASO and optimized ASO Cubes.
• Modifying Excel VBA code, preparing documents & training end users.
• Actively involved in Essbase upgrade (from Essbase v9.2 to Enterprise Performance Management System 11.1) and testing Essbase (ASO & BSO outlines), Hyperion Financial reports, Web Analysis, VBA templates and Planning applications in development, UAT environments.
• Month end monitoring jobs thru Control-M scheduler. Updating the metadata planning outlines (i.e. Entity and Accounts dimension) of SGA, Strpyrl and Mktg apps thru HAL /ODI, loading G/L actual data into SGA and Mktg application and finally reconciling data between SAP level 4 Pnl against detailed applications.
• Monitoring HFM data loads and assisting business users on Consolidation, Metadata maintenance, security admin & data reconciliation issues.
• Actively involved in upgrading Essbase server from Version 9.2 to Version … on both Unix and windows platform; Migrated all applications from old to new environment.
• Provided infrastructure support like shutdown and start-up of all Hyperion services on Prod, QA and dev. environment, working with LTS DBA Oracle team creating new schemas, table refreshes, setting up control-M jobs and establish Firewall rules between windows servers.
• Extensively involved in designing and modifying the outlines for ESSBASE Cubes.
• Developed Calc Scripts, Rule files and Report Scripts for data loads and dimension builds.
• Analyzed all dimensions and members in the ESSBASE outline.
• Performed tuning by using the Dense/Sparse settings and developed the required alternate rollups for reports.
• Responsible for Performance Monitoring, Backup and Recovery of the cube.
• Implemented various troubleshooting procedures to recover databases.
• Supported users with excel add-in, Essbase databases and data issues.
• Involved in performing Administrative tasks like user authentication, creating new users for the Essbase cube using EAS options.
• Involved in tuning of dimensions, cache settings for better calculation and retrieval timings
• Prepared the change request documents for approval of the changes
• Performed tuning by using the Dense/Sparse settings and developed the required alternate rollups for reports
• Responsible for Performance Monitoring, Backup and Recovery of the cube
• Working with Oracle product support on open issues/ Bug fixes for Hyperion version … and Clarity product support.
• Actively involved in installing Essbase components, development of projects like Store payroll enhancements, ODI Interfaces, getting GL Balances functional area into SGA app and GSL app.
• Managed FDM user security, Mapping tables, control tables (Currencies, Periods & Categories).

Environment: Hyperion Essbase 9.3/ EPMS Fusion …, HFM 9.3, Hyperion Planning system 9.3, Weblogic server 8.1, Windows Server 2003 R2, Hyperion Essbase Spreadsheet add-in 9.3, Clarity server 6.1, Hyperion System 9 BI+ Financial reporting studio, FDM, Web analysis 9.2, AAS Console, Oracle 10.x, HP-Unix 11, Control-M & DataStage 8.1

Confidential

Hyperion Database Developer

Responsibilities:

• Performed Installation, configuration and upgrading of Oracle server software and related products, also involved in setting up the oracle and DB2 database environments for development teams usage.
• Performed the cleanup activities on several database servers regularly by deleting the unwanted schemas and old dumps to make the space available for upcoming releases.
• Involved in DBA activities like creating database objects / DB refresh/ new user creation / monitoring the DB performance.
• Automated the backup process using Shell scripts and worked on UNIX shell wrapper scripts.
• Developed Load rules for Dimension build and Rules File for loading the data from Oracle GL into Hyperion Cube.
• Developed Calc Scripts for aggregating the data based on the business requirements.
• Involved in optimization and tuning of the Essbase application to bring down the Calc time.
• Automated the monthly loading process using Maxl, Shell Scripts.
• Resolved many technical and functional issues and ensured the smooth process flow during monthly and quarterly close.
• Maintained the closing cube in parallel to Hyper Roll to ensure the data is being loaded and aggregated as per the business requirements.
• Prepared the script to bring down the high watermark level by moving the tables hence resulted in less schema storage in oracle.
• Involved in preparing the Oracle and DB2 deployment package scripts / testing for Major releases as well as for previous release rollups.
• Addressed the last minute changes and released the patch incremental files before the media delivery.
• Added archive - purge changes with respective to new DDLs added in 2013 and thoroughly tested to ensure 0 errors in both oracle and DB2.
• I have made significant performance improvements to the archive purge code for oracle and DB2 along with adding new enhancements and requirements.
• Looked into archive - purge issues raised by HRFT, CHAN, PECI and BALKAMP clients and delivered the fixes in an Assisted the QA team in truncating the old transactional data, thereby reduced the size of QA golden dB to 5gb.
• Analyzed the missing FK’s on transactional tables and column comments on tables and worked with BA’s to get them added to product deployment package.
• Worked on converting the Oracle dumps into DB2 using MDAT scripts.

Environment: Oracle 11gR2, DB2, 10i, Unix, AIX.