PROFESSIONAL SUMMARY:

• Worked as a Hyperion Consultant having 12 years of experience in IT with specialization in Oracle EPM 11.1.2.2 System and experience in implementing and upgrading systems as well as Supporting Oracle HFM and Planning applications. Eager to accept challenging assignments leveraging my knowledge and expertise towards organizational growth.

TECHNICAL SKILLS:

OLAP: Oracle EPM 11.1.2.2, EPMA, Essbase, HBR, EAS, EIS, EDS ESSCMD, MaxL, MDX, Workspace, Essbase Partitioning, Hyperion Essbase SQL Interface, Hyperion Essbase API, Shared Services, LCM

Financial Analysis tools: Hyperion Planning 11.1.2.2, Workforce planning, HBR, Web Forms, Hyperion Performance Scorecard, Hyperion Enterprise, HFM, FDQM, FDM Work Bench.

Reporting tools: Hyperion Web analysis, Hyperion Smart View, ExcelAddin, Financial Reporting & Analysis, HIR ETL/meta data tools: Informatica Power Center and ODI, Data Stage, Terra data ERP: SAP, PeopleSoft HRMS & Financials (v 8.8/ 7.5/7.0/6.0 ), EPM 9.0/8.8,SQL, Oracle Apps 11i, GL Languages: PeopleCode, SQL, PL/SQL, JCL, CGI/PERL, C, C++, Jdk1.4, Visual Basic Databases/Technologies: ASP.net, VB Script, JavaScript, Java, Web analytics, J2EE JSP, Servlets, HTML, DHTML, Oracle 11g R2, DB2,MS SQL Server, Analysis Services 2005, SSIS Application servers/OS: Web Logic 8.x, Oracle Apps Server, Operating systems: Windows 2008/2005, UNIX (AIX, Solaris, Linux)

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

Hyperion Consultant

Responsibilities:

• Worked as a Team lead in Confidential . Designed Technical solutions for data conversion project to replace the legacy Lease and Retail applications with Cassopae and worked with interfaces to integrate the data
• Implemented EPS Driver based Planning project In Baker Hughes in EPM 11.1.1.3. Did production support for EPS Planning application and supported for forecasting and planning cycle. Extracted Meta data and loaded in FDM work Bench to push data into EPS Planning application.. Supported business users and maintained security in shared services
• Worked as Team lead and completed EWU Project in Toyota financial services in time. EWU is an excess wear and tear protection plan for automobiles
• Did production support in Pepsi and supported HFM applications and Month end close process in EPM 11.1.2.1.Validated Balance sheet reports. Supported Business users and Maintained security. Supported Meta data changes and Backup of HFM application.

Confidential, Seattle, WA

Hyperion Admin

Responsibilities:

• Installed and configured EPM 11.1.1.1 in Linux 5 (32 bit). Created repository in Oracle 10.2.0.1. Installed weblogic server 8.x. Installed and configured SS, APS, EAS, Deployed Hyperion services on Weblogic service. Developed shell scripts to start and stop SS, EAS console. Developed shell scripts start and stop Hyperion workspace. Migrated Hyperion cubes and reports developed in Excel Spread sheet from EPM 9.3.2 to EPM 11.1.1.1. Did performance improvement and portioned in between cubes. Did trouble shooting to maintain Hyperion applications

Confidential, NJ

Hyperion Admin

Responsibilities:

• Installed and configured EPM 11.1.2 in Linux 5 (64 bit). Created repository in Oracle 11.2.0.1. Installed weblogic server 8.x. Installed and configured SS, APS, EAS, FR and workspace. Deployed Hyperion services on Weblogic service. Developed Shell scripts to start and stop SS, EAS and APS console. Developed shell scripts start and stop Hyperion workspace. Migrated Hyperion cubes and financial reports from EPM 11.1.1.3 to EPM 11.1.2. Did trouble shooting to Maintain Hyperion applications. Did system and Integration testing.

Confidential, Cleveland, OH

Hyperion Admin

Responsibilities:

• Mining sites and Corp planning applications are implemented in Hyperion Planning 9.3.1 and HFM. Meta data is maintained in FDM. The actual data exported from HFM sites to planning Sites Application for Iron Ore and Coal mines global operations. Imported Budget data into HFM application from planning sites Hibbing Plan and Northsore Plan.
• Developed mappings in FDM work bench adapter for 2 locations. Maintained Hyperion EAS, Planning, HFM, Reports Repository in SQL Server 2003. Developed process to copy the HFM applications and to take back up of planning applications. Did break fixes to Essbase cubes and Planning Web forms. Designed and developed Budget and forecast reports using Financial Reporting. Prepared Planning Security Matrix and implemented security model for Confidential .

Confidential, Trexlor Town, PA

Hyperion system Administrator

• Supported 5 Hyperion applications used by World Wide consolidation team (WCT) and Decision Sciences Management Structure (DSMS) consists of 500 Users. Supported Budget and forecasting cycles in 5 Years strategic planning and Fiscal year Budget preparations. Did accounts, Entity addition and rollover. Worked in off - shore model and did KT and prepared Hyperion System documentation. Did consolidation and data tie-out between SAP and Hyperion. Maintained the mapping of Accounts between SAP GL and Hyperion Chart of Accounts. Involved in finalizing Balance sheets, Income statements, Cash flow and SOX compliance.

Confidential, Chappaqua, NY

Hyperion Consultant

Responsibilities:

• Loaded application with metadata from production system - Entity, Account, formats and formulas
• Created new categories to load data
• Modified Formulas as needed
• Extracted Rates from prod and loaded in dev
• Extracted Data, converted data to load into dev
• Prepared Test Templates to validate the data.
• Consolidated Tot Confidential Corp organization and Reconciled data after converting data from Fiscal year to Calendar year

Confidential, Woodland Hills, CA

HFM Consultant

Responsibilities:

• Prepared Security matix and Maintained security model for CRA Group users in HFM and did provisioning in Shared services
• Maintained Security and supported the HFM users during month end close
• Extracted SAP load files and ran the DTS package to transform SAP Data
• Validated and Imported data into HFM from FDM
• Ran and review FDM validation reports and investigated differences including:
• Record count and key account balances same as SAP, Check Govt reclass for legal, division and segment, Ensure Income Statement, Balance Sheet and Cash Flow tie out for Legal, Division and Segment, DTL AP LT and BALANCE account should have zero balance
• Did Consolidation the top level of the Legal hierarchy (HNT TotPreClose) during data loads, after Journal loading and Reclass
• Supported monthly end close and ledger adjustment postings and maintenance of New accounts and Entity changes. Did division, legal and market segment mappings
• Did extracts to backup HFM application includes
• Metadata, Member lists, Data, Final load files in SAP and HFM format, Journals, Rules and Reports Security
• Worked on change requests to make changes to Balance sheet and IS and cash flow reports and maintained the security for HFM reports in Work Space.
• Maintained the Reports like Income Statements, Balance Sheets, Consolidated Package, SAP Trial Balance TieOut, and Cash Flows
• Trouble shoot restore and backup the HFM application in Test and prod and dev environments during failure. Start and stop procedures of HFM server, Clusters, Workspace, Shared services and FDM server.
• Maintained data forms and data grids
• Prepared SOX Compliance reports

Confidential, Miramar, FL

Hyperion DBA and Developer

Responsibilities:

• Designed and developed new aggregate storage and block storage cubes. Extensively involved in dynamic designing and modifying the outlines for Essbase cubes Developed load rules, calc scripts and report scripts. Developed automation scripts to populate outline and data into cubes.
• Performed client/server installations and setup configuration of Hyperion Essbase as well as other Hyperion products including Excel spreadsheet add-in and Reports.
• Designed and developed Corporate reports using Hyperion Financial Reports and Involved in development and modification of existing financial and marketing reports which include corporate consolidation reports, and financial and reports for management.
• Developed multiple grid-based reports to generate Current Date, current Month, current Year and LTM, Fiscal year, calendar year, Last year data in form of CSS, HTML and PDF Reports. Did Conditional formatting to high light headers and traffic lighting to input and derived accounts and totals and subtotals in Balance sheet and Income statement.
• Developed multiple POVto enable the users to input value Confidential page level. Used functions like @Descendants @children and @siblings to design the sections of reports in accounts dimension. Used Links to join multiple reports. Developed Excel workbooks using Smart view.
• Did user provisioning in Shared Services and implemented external authentication for SSO.
• Enabled filters in the financial reports to limit the users to view the certain sections of members in the dimension.

Confidential, KC, MO

Hyperion Applications Administrator

Responsibilities:

• Build and Maintained Budget process for Annual Budget 09 in Hyperion Enterprise. Loaded GL data, consolidated globally and Generated Concession Analysis reports, Budget Reports, Daily Revenue & admissions, Payroll Analysis, GSV, Operating Analysis, VOE Variance Top 5 By region and Cash flow.
• Troubleshooting, product mapping and History data load during merger LCE and Cinema Theaters. Developed Process and VBA macros in MS SQL Server using Analysis Services 2005 SSIS packages to prepare Fiscal Year budget 09 allocations and data input templates.
• New Theaters & products addition and data warehouse extracts to load data into Hyperion for analysis and reporting purpose. Updated Accounts, sub accounts and formulas to meet the needs of Finance Department, Food & Beverage Department and Fraud prevention Department. Write scripts to add Dynamic Accounts and Methods Confidential Theatre and Market Level for currency conversion. Did Rollover.

Confidential, Chandler, AZ

Hyperion Systems Administrator

Responsibilities:

• Upgraded Essbase 6.5.1 to Hyperion System 9.3 BI+ and Migrated the WFS Application in Confidential group supporting the corporate financial operations. Installed Hyperion System 9.3.0.Migrated the application WFS. Ran MaxL, LoadRules, CalcSripts and report scripts, Optimized the cube build time setting config file parameters like INDEX CACHE, DATA CACHE and Aggregate storage.
• Did Provisioning to users for assigning Project Manager role (create projects, assign applications to project), Provision Manager role (assigns roles, access controls for each application).
• And Directory Manager role (manages native Shared Services directory).

Confidential, Tampa, FL

Hyperion Developer/ DBA/ SA

Responsibilities:

• Extensively involved in performing DBA activities like performance tuning and Wrote MAXL, Calc scripts, Load Rules, functions, stored procedures and did Partitioning. Used third party tools like Hyper Roll and improved performance.
• Supported operations and managed users effectively for FRS application in worldwide operations. Developed Shell scripts using Maxi and ESSCMDs and load rule files to upload data from Peoplesoft database Financeone to Essbase cubes Management, Finance, Intercompany and Results.
• Integrated the data mart and operational data store in EPM with Essbase EIS for global consolidation, inbound and outbound processing.
• Maintained tree data structures in PeopleSoft to integrate with cube builds in Hyperion. Extensively involved in designing and modifying the outlines, OLAP Model files and Meta outlines for Essbase Cubes. Developed OLAP Data models ROLAP AND MOLAP using Star schema.
• Did installation, configuration and integrated Essbase family products EAS, EIS, EDS in FRS using EPM and upgraded Hyperion system from 6.5.3 to7.1.6 and 7.1.6 to Hyperion System 9.0 BI +Deployed Management Predefined reports Into Production Using Hyperion Reports and integrated with FRS PeopleSoft portal. Did Essbase administration activities such as filter creation, creation of users, and creation of groups and maintenance of Essbase Analytical Services using EAS across multiple Platforms Windows, AIX and SUN Solaris. Enabled User’s input capability to the Hyperion applications and maintained filters for global operations.
• Developed Shell scripts to run the jobs hourly, daily and monthly to build the incremental and destructive cube builds. Developed Java classes to support third party vendor products like Hyperion, EPM (Peoplesoft). FRS was integrated with Hyperion family products to copy cubes and to build destructive and incremental cubes. Developed People Code and integrated EPM with EIS and EDS to build outlines and load the data for incremental and destructive cube builds.
• Implemented External Authentication/SSO using Security Bridge in FRS and integrated with PeopleSoft Row level security

Confidential, LongMart, CO

Hyperion Admin/DBA

Responsibilities:

• Developed SALSMKT Cubes loaded data from Peoplesoft database. Maintain backups and supported users in production. Imparted to financial analysts and planners.
• Involved in all aspects of Essbase development: report scripts, calc scripts, data load rules, dimension builds, design and optimization of Essbase models (a specialty), and partitioning databases. Also involved in clients on the Essbase OLAP server and Essbase Excel add-in.
• Worked extensively with Hyperion's Web Gateway, deploying complete reporting solutions for two clients. One of my most critical tasks is preparing documentation on Essbase databases and their surrounding systems. Used Essbase in UNIX and NT environments, and is comfortable with both platforms. Also proficient in using the Essbase API with Visual Basic and the Excel add-in.
• One Essbase engagement was working with the client's Director of Budgeting to determine functional requirements. The plan called for the extraction of necessary data from Peoplesoft, use of MS Access to massage the data, importing of the data into Essbase (updating models as necessary), allowing users to enter budget data to Essbase via MS Excel, and exporting data from Essbase to PeopleSoft. During this process, used N-vision queries to extract the necessary tree structures from PeopleSoft. Using this data, I was able to create parent-child format files to duplicate the structures in Essbase. Then developed a simple way for managers to enter budget data into Essbase via MS Excel. Confidential the end of each day, the data is calculated and allocations run. Then the export from Essbase is performed using a report script. The data is then imported into PeopleSoft.

Confidential, Concord, NH

Hyperion Consultant

Responsibilities:

• Developed MAAP application using Java that stored and maintained financial data for analysis.
• Build the finance cube using Load Rules files in Data Prep Editor Reviewed cube design with developers and with Core Competency.
• Involved in troubleshooting, performance tuning and performance monitoring. Wrote Korn shell scripts and running crown jobs. Configured and provided production support.
• Optimized Essbase Server Settings for best performance.
• Developed adhoc reports using Actuate reports
• Wrote Calc Scripts for complex calculations using Oracle RDBMS.

Confidential, Farmington, MI

Hyperion Consultant

Responsibilities:

• Developed and implemented financial Planning and forecasting application for Confidential using Essbase (6.5.1), Hyperion Planning (2.2), Hyperion Reports (2.0), Hyperion Analyzer (6.2), Hyperion Application Link (Business Integration Studio v6), Hyperion Financial Management (HFM2.2), Analyzed the current and future financial planning and reporting requirements.
• Developed source to target mapping (SAP to Hyperion), data integration from SAP to Hyperion uses HAL (Hyperion Tool). Designed and developed the Essbase Outline and Dimension settings.
• Developed Hyperion Planning/Forecasting Forms, Business Rules/Calc Scripts/Currency Conversions and planning/forecasting/HFM Reports.
• Developed Migration plans, data validations using Excel macros, backup/Recovery scripts, and support for maintenance of issue logs, problem tracking, and documentation.
• Specialized in all aspects of high performance tuning and optimization of databases - ESSBASE.CFG, sparse/dense configuration and outline structure strategies (dynamic calcs, attribute dimensions, partitioning). Developed multiple Essbase applications and databases (cubes) and managed User/groups and security administration. Designed fact tables using star schema and dynamically linked to SQL Server DB.

Confidential, Atlanta, GA

Senior Essbase developer/DBA

Responsibilities:

• Developed outline, load calc and report scripts. Designed and developed monthly, quarterly and yearly retail P&L cubes. Did database settings, partitions and Essbase Server settings to improve performance. Reviewed cube design with developers and Essbase core competency.
• Used scheduling for ESSCMD.
• Did troubleshooting, performance tuning and performance monitoring.
• Developed a multi dimensional database (MDDB) application using Essbase that stored and maintained company's financial and marketing data and loading and manipulation of data into database using Load Rules files (Data Prep Editor).
• Developed Calc Scripts and run Calc Scripts to calculate complex values.
• Wrote report scripts to develop income and expense statement analysis reports.

Confidential, Redmond, WA

Programmer Analyst

Responsibilities:

• Designed, developed and tested the PES project. Did 3G system and regression testing. Developed test automation scripts to test STAR Web apps using regression test tools.