PROFESSIONAL SUMMARY:

• 7+ years of experience in Hyperion applications using Hyperion Essbase, Essbase Administration Services, Hyperion Planning, Hyperion Financial Reporting, Smart View for Office, ESSCMD, MaxL and Essbase Excel Add - in.
• 7+ years of experience in Information Technology in designing, developing, architecture, administration and implementation of Enterprise Performance Management (EPM), Business Intelligence (BI), Data Warehouse (DW) Applications under different environments.
• Experience in installation, configuration, server settings, client and server installations of Hyperion products such as Hyperion Essbase, Essbase Administration Services, Essbase Integration Services, Shared Services, Hyperion Financial Management (HFM), Hyperion Planning and Hyperion Reporting Modules on Windows and Unix Environment.
• Experience working with Hyperion products like HFM, FDM, DRM, LCM, OBIEE ODI, FDMEE.
• Responsible for the installation and administration of the Hyperion Planning & Hyperion Essbase solutions.
• Responsible for troubleshooting any Hyperion Products.
• Setup and maintain user access for Hyperion Planning and Essbase. This includes creating and provisioning of user groups, filters and security profiles in alignment with the needs of the business.
• Responsible for month end close data processing, integration and troubleshooting.
• Provide end user support for Hyperion Essbase, Financial reporting and Smartview.
• Developed ESSBASE cubes using Block/Aggregate storage technologies (BSO/ASO).
• Proficient in dynamically building Dimensions, 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 references.
• Expertise in Calc scripts, MaxL, ESSCMD, Hyperion business rules, Dimension build rules, Partitioning, Data load rules and report scripts.
• Skilled in automation, optimization and performance tuning of Essbase application data metadata processing, upgrading, testing and migrating cubes in different Hyperion applications.
• Experience in performing Migration between different Environments and in Upgrade between different Versions.
• Expertise in Essbase security features and ability to create user and group profiles for assigning proper privileges using both Native security (LDAP/MSAD) and Shared services modes.
• Expertise in building Financial budgeting and Forecasting OLAP Applications with Hyperion Planning using forms, business rules, menus, plans, and application migration as well as application management and troubleshooting.
• Expertise in creating Hierarchical and Non Hierarchical SQL queries, tables, Stored Procedures, relational references and maintaining the referential and data integrity in SQL.
• Experienced in all phases of SDLC like analyzing the business requirements, developing the application using industry best practices, deploying into different environments (production, test and development).
• Proficient in software documentation, technical report writing, knowledge transfers, and possess strong leadership qualities along with communication and interpersonal skills. .
• Excellent analytical and logical skills with a good understanding at conceptual level.
• Ability to work individually or in team environment.
• Versatile team player with excellent leadership and inter-personal skills.

TECHNICAL SKILLS:

Multidimensional Database: Hyperion Essbase 11.x/9.x

EPM Tools: Hyperion Planning 11.x/9.x, Studio, EAS

Reporting Tools: Hyperion Financial Reporting 11.x/9.x, Web Analysis, Hyperion System 9 Smart View 11.x/9.x, OBIEE 11g, OTBI(Cloud)

Hyperion Scripts: Calc Scripts, Report Scripts, MaxL, MDX and ESSCMD, Javascripts

Programming Language: C, C++, Java, PL/SQL

Web Technologies: HTML, DHTML, XML, CSS, Java Script

Operating Systems: Windows, UNIX

Databases: Oracle 9i/10g/11g, SQL Server 2008,Teradata

GUI Tools: TOAD, SQL Developer, VMWARE, MS-VISIO

Scheduling tools: Linux Autosys, Control-m, Windows Scheduler

PROFESSIONAL EXPERIENCE:

Essbase Developer/Admin/Consultant

Confidential, St. Paul, MN

Responsibilities:

• Developed a new Essbase BSO General Ledger cube in Hyperion 11.1.1.3 according to the Chart of Accounts (COA) in Fusion Cloud.
• Created/Modified MAXL Script and Rule Files, Calc Script, Dimensions to load the data (budget and other data)
• Created Data export Calc and Report Scripts for the purpose of exporting specific set of data like budget from the cubes.
• Migrated objects between environments using manual or Life Cycle Management (LCM) functionality
• Automated the load process from data extracting to loading the data and scheduled the process automatically.
• Maintained three cubes (Ledger, Day Sales and Supply) to support day to day business activities.
• Maintained Hyperion Shared Services and performed Active Directory (MSAD) Configuration.
• Created new users and groups and created roles according to the departments.
• Performed all Essbase Admin roles daily, including tools required to maintain the production and test environments, analyze processes to monitor and control data integrity and archiving data daily.
• Participate in the Enterprise Chart of Accounts (COA) Change Control process.
• Continuously improve month end financial reporting and processes.
• Worked with business in install different reporting options like Essbase-Add In, Smartview and Financial Reporting Studio (FRS) to fulfill their needs.
• Helped Business in understanding and monitoring full business lifecycle for Planning, Forecast, and Reporting of Actuals and impacts across source and reporting systems
• Helped Business created reports using Essbase Add In and Smartview like Net Income, Net Sales, Profit& Loss Statement.
• Worked with OBIEE team to help them use Essbase as their data source.
• Excellent knowledge of OBIE 11g backend including Physical Layer, Business Mapping & Modeling Layer and Presentation Layer.
• Worked together with BI team to help providing end-to-end BI solution by dimensional modeling design, Logical/Physical models, building/configuring RPD, Answers, Delivers, creating Reports/ Dashboards, Cache management, and setting up Security using LDAP Authentication and Basic RPD Authentication
• Worked with ETL team (DataStage) in getting the right Tables/Columns to create the right Physical Layer for OBIEE.

Oracle Fusion Cloud ERP (Financials)

Responsiblities:

• Experience in end-to-end implementation of Oracle Fusin Financial on Cloud(11.1.X)
• Worked with Oracle Implementing Partner Daz Si to move from On-Prem Oracle Financials 11i to CLOUD.
• Worked with Historical Data pull up, validation and Load.
• Worked with UNIX team to set up FTP process (Inboud and Outboud Interfaces)
• Fulfilled the role of Oracle Fusion Cloud Role Admin working on Oracle Identity Manager to create new implementing users and provisioning them with right roles.
• Worked with different financial modules like General Ledger (GL), Accounts Payable(AP), Accounts Receivable(AR), Fixed Assets(FA) andCash Management(CM).
• Created OTBI Reports/Dashboards based on different Transactional subject areas likes Payables, Journals, Suppliers etc.
• Created Data models using SQL and custom reports to fulfill advanced need of the business.
• Efficient in entering/searching Journals, Payments, and Assets manually if needed.
• Involved in Unit testing, User Acceptance Testing, Volume Testing and System Testing
• Excellent in working with Financial Reporting Center (FRC).
• Worked with e-help/IS team to help install FRS, Smartview and ADFi Tool in different computers.
• Scheduled Programs, Jobs and Processes to run accordingly to the business requirement in Cloud.
• Created Service Request (SR) in Oracle Support whenever there was a major issue.
• Strong experience with Fusion Applications.
• Excellent verbal and written communication, active listening and interpersonal skills
• Detailed knowledge of BI Publisher tools, templates for creating personalized report outputs from Oracle Cloud ERP.
• Familiarity with ACH and Check Payment templates, Bank Statement formats, ability to modify seeded templates as per bank and client requirements.
• Familiarity with Oracle Planning and Budgeting Cloud Service (PBCS).

Environment: HyperionEssbase11.1.1.3, Hyperion Planning 11.1.1.3, Essbase Add-in, SmartView, Oracle Fusion Cloud 11.1.x, OBIEE 11g, Oracle 11g

Sr. Hyperion Consultant

Confidential, Salt Lake City, UT

Responsibilities:

• Performed end to end upgrade of Hyperion Suite from 11.1.2.3 to 11.1.2.4
• Monitored servers & EPM environments : up-time; performance; back-up; capacity planning and optimization.
• Helped direct user research, user modeling, user needs assessment, user modeling, design, testing, developer relations ) for the Hyperion Planning/Essbase projects.
• Worked with multiple teams across to support Planning, Essbase, HFM ,
• Deployed planning application for budgeting and forecasting .
• Designed BSO application and ASO application as per the reporting requirement of the company.
• Implemented Linux Autosys to schedule jobs for easy Error handling, debugging and production support using Java.
• Created Rules Files for the purpose of loading data from flat files to the dimensions in outline using several build/load methods such as generation, level and parent-child references.
• Designed Data forms/Web forms, Menus and Smart lists to allow users to key in the data for the drivers that business requires, also attached business rules with these data forms to calculate several accounts.
• Automated Task Lists to guide the planning users through a several sets of web forms, calculations, business rules, etc. required to complete the plan cycle.
• Designed a replicated partition to transfer a portion of data from one cube to another, which significantly increase the performance for the excel-retrievals.
• Schedule cube builds and manage them with Linux cron job and Windows Task Scheduler along with Scripts.
• Implemented various types of calculations such as Dynamic & Two-Pass, Member formulas, UDA’s, attributes and XREF functions for calculations.
• Created MaxL and batch scripts to automate process of updating cubes on a daily basis.
• Involved in the duties of Administrator in resolving issues using ticketing system and Responsible for updating the wiki site with new resolved issues for future reference.
• Performed regular Backups of the cube and archiving it and automated the process.
• Integrated essbase cubes with OBIEE to generate dashboard reporting.
• Hand on expierence with working with FDMEE and ODI to loading data and metadata from different sources to Hyperion Product.
• Worked together with HFM Team to help with installation for HFM which provides consilidation and reports.
• Maintained hierarchy and dimensions using DRM.
• Hand on experience working with LCM to migrate planning applications and cubes across product environment.
• Disaster Recovery testing, SOX Assurance, Financial Year Changes in Essbase applications.
• Develop Complex Gaming Reports with OBIEE tool using different features available in the OBIEE.
• Modeled and Developed OBIEE Real Time Reports by connecting to the Oracle EBS source data.
• Created Data export Calc and Report Scripts for the purpose of exporting specific set of data from the cubes.
• Collaborated with end-users and stakeholders to bring form and clarity to a multitude of data sources which enabled data to be displayed in a meaningful analytic way.
• Created customized Financial Reports using Hyperion Financial Reporting Studio according to the finance user's requirements. These reports included Budget vs. Actual, Budget vs. Forecast and Forecast vs. Actual reporting capabilities. Also, automated the entire process of pushing reports by sending them automatically on a particular business day.
• Assisted in HFM/FDM annual SOX audits by providing documents, data and reports to internal/external auditors.
• Supported existing P&L application (consisting of Balance Sheet, Consolidated and Workforce databases) to plan several employee related expenses like salaries, bonuses, vacation days, vacant and filled positions, report Net income, Net Sales, Profit and Loss etc.

Environment: Hyperion Essbase 11.1.2.4, Hyperion Planning 11.1.2.4, HFM, Smart View, CA - Clarity PPM, Oracle 11g, Java, IBM PIM

Sr. Hyperion Consultant

Confidential, Fairfax, VA

Responsibilities:

• Provided development and administration support for Hyperion Planning and Essbase.
• Participated in installation/upgrade of Hyperion from 11.1.2.1 to 11.1.2.3 EPM environment, configurations and migrations, applied upgrades and patches, and performed data and application back-up and restoration
• In-depth troubleshooting of Hyperion reporting layer to data sets
• Managed security in the Hyperion applications, including integration
• Provided application and Essbase support for Hyperion systems and applications
• Monitored and optimized system performance.
• Monitoring Autosys and data flow jobs.
• Involved in testing various SOX requirements.
• Designing, developing and maintaining Essbase applications (ASO/BSO)
• Deployed planning application for budgeting and forecasting.
• Reporting, Budgeting, and Group Membership Association Policies analysis.
• Developed a fully automated refresh process for all Essbase applications using MAXL and Batch.
• Working closely with the Finance Users for designing and developing Smart view dashboards and reports and ensuring timely monthly/quarterly closes.
• Extensive DBA experience creating users, groups, filters in EAS/Shared Services and assigning them appropriate roles.
• Handled about 600 Sybase database migrations from 11.9 to ASE 12.5 and Solaris OS 5.8 to Linux 2.6.
• Coordinating with Infrastructure and DBA teams in maintaining Budgeting & forecasting Hyperion Planning Application.
• Developed automated Excel Reports/Templates running against Essbase using VBA for Excel.
• Integrated essbase applications with OBIEE to generate dashboard reporting.
• Expeirence working with FDMEE and ODI to loading data and metadata from different sources to Hyperion Product.
• Maintained hierarchy and dimensions using DRM.
• Hand on experience working with LCM to migrate planning applications and cubes across product environment.
• Extensively involved in User Acceptance Testing and Quality Assurance testing with the business users.
• Developed Planning applications and created web forms and business rules.
• Involved in the duties of Administrator in resolving issues at times.
• Performed regular Backups of the cube and archiving it.

Environment: Environment: Oracle EPM 11.1.2.3, Hyperion Essbase, Hyperion Planning, Financial Reporting Studio, Hyperion Smart View, Java, Oracle 11g, PL/SQL

Hyperion Planning/Essbase Consultant

Confidential, Austin, TX

Responsibilities:

• Involved in design and development of two cubes, one for budgeting and planning and the other for customer analysis.
• Developed both ASO and BSO applications depending on the requirement of the application.
• Creating and modifying Hyperion Planning Web forms.
• As a part of team developed the Essbase outlines, member formulas, and data load rules for the Planning Application.
• Experience in loading metadata into planning application using outline load command lines utility.
• Used MaxL in an interactive and batch mode to load data files and automate Essbase operations.
• Developed and maintained rules files, calc scripts, MaxL scripts and reports.
• Developed the necessary calculation scripts to calculate complex values, such as acquisition cost, gross margin/inventory turnover, revenue/payroll hr, total head count, and return on assets, properties, plants, and equipments, cash cost per user and YTD commitment and variance.
• Developed complex MDX formulas in income statement, balance sheet, debt analysis, cash flow and investment income moving data across different dimension members.
• Designed and developed several ad-hoc reports using Hyperion Analyzer and Hyperion Reports.
• Involved in performance tuning to minimize data load and calculation time using the dense/sparse settings and developed the required alternate rollups for reports.
• Responsible for performance monitoring, backup and recovery of the cubes.
• Designed and created a security plan to manage security at the user and group layer, including global access layer and the server level.
• Involved in troubleshooting and production support.

Environment: Hyperion Essbase 11.1.2.1, Hyperion Web Analysis, Hyperion Financial studio, Java, Hyperion Planning, SQL, MS-Excel 2000 Spreadsheet Add-In, MS SQL Server, Web Logic

Hyperion Essbase Consultant

Confidential, Columbus, OH

Responsibilities:

• Designed and developed new Essbase cubes for corporate reporting framework using both Aggregate storage (ASO) and Block Storage (BSO) cube as per the requirement.
• Worked with Essbase and Teradata, which included metadata changes, revising data forms and creating Balance Sheet schedules. Loaded data through Essbase and created and resolved any mapping kick outs.
• Developed and customized Data Forms in Hyperion Essbase for users to input forecast, working data, and accounting changes, and other variance data.
• Developed load rules for loading data files and for dimension build and implemented data-access security and user management. Developed Calc Scripts to calculate various Metrics for the outline.
• Developed application to create reports for income statements, balance sheets, key metrics, operating and admin expenses, consolidation, corporate P&L, Functional P&L and Revenue for different markets.
• Loaded actual data into Hyperion Essbase to drive actuals, forecast and budget numbers.
• Performed Integration test, system test and validation of reports and report data.
• Created and edited Hyperion Essbase reports using Excel add-in.
• Worked closely with external auditors, business analyst and business Intelligence team.

Environment: Windows Server 2008,Java,Hyperion Essbase11.1.1.3 Administration Services, Excel Add-In, Web Analysis, Hyperion Financial Reporting / Hyperion Essbase /Teradata v13

Hyperion Essbase/Planning Consultant

Confidential, Irving, TX

Responsibilities:

• Designed and developed Essbase cubes for corporate reporting framework using both Aggregate storage (ASO) and Block Storage (BSO) cube as per the user requirement.
• Developed and customized Data Forms in Hyperion planning for users to input forecast, working data, accounting changes and other variance data.
• Participated in gathering business and functional requirements details during business meetings and translated them into program specification documents.
• Developed load rules for loading data files and for dimension build and implemented data-access security and user management.
• Created and maintained the user provisioning by configuring user active directories to Shared services and creating groups, assigning roles and adding users to the groups.
• Wrote calculation scripts and business rules to perform allocations based on different drivers.
• Involved in database and security refreshes in Hyperion Planning.
• Participated in optimization of the cube by analyzing and modifying various aspects such as dense/sparse configuration, modifying member storage properties etc.
• Developed reports using Hyperion Interactive Reports, Hyperion Financial Reports, Web Analysis, and modified existing reports to in corporate global operations.
• Participated in the planning and execution of integration test, system test, and user acceptance test activities, including developing and documenting test plans. Involved in documentation on all Hyperion Planning processes for all business groups and technical documentation on business rules and calc scripts.

Environment: Hyperion System 11, Hyperion System 9 BI+, Hyperion Essbase 9.x, Hyperion Planning, Excel, Smart View

Hyperion Consultant

Confidential, Pittsburgh, PA

Responsibilities:

• Built metadata using outline load utility and developed load rules to load data into the application.
• WroteSQL scripts for retrieving the data.
• 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.
• Developed Reports using Financial Reporting against both Essbase and Planning data sources.
• Designed templates using Hyperion Smart View for MS Office.
• Developed the security matrix and security model for Shared Services provisioning in consultation with the client.
• 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 and Smartview.
• Involved in documenting all phases of development, testing and deployment
• Created business rules in planning and administered all phases of testing of Hyperion reports
• Provided support during the production phase of the Planning applications and financial reports, and helped resolve all levels of issues associated with that effort.

Environment: Oracle Hyperion Essbase 9.x, Hyperion Planning 9.x, Hyperion WebAnalysis, Hyperion Financial Reporting, SmartView, Oracle 10g, Windows Server 2003