SUMMARY

• Over 8+ years of rich IT experience in Hyperion Planning, Hyperion Essbase, Financial Modeling/Analysis, Budgeting, and Client Management.
• Experienced in leading teams of varied types/sizes and possess excellent analytical, problem solving, communication and interpersonal skills.
• Experience in working as a Functional Analyst in Implementations, Upgrade and Post Production Support of Oracle EBS in various industries like Banking, Retail, Healthcare, and Transportation.
• Extensive experience in Hyperion Financial Management (HFM), FDMEE, Hyperion Essbase, Hyperion Planning, Hyperion Financial Reporting Studio, Smart view for Office, MaxL and MDX in Windows environment.
• Hands on experience in Oracle Enterprise Management Architect (EPMA) technology.
• Experience in creating Meta Data using EPMA (Data synchronization, ADS files), in Essbase, in Planning (Outline Loader and ODI), and in Essbase (EIS, Text/rules files).
• Extensively involved in maintenance, automation, backups, Performance tuning and Optimization of cubes.
• Skilled in optimization and performance tuning of Essbase application data/metadata processing, upgrading, testing and migrating of cubes in different environments.
• Involved in writing custom Essbase calculations scripts, automated the Essbase Cubes using MAXL, ESSCMDS and Batch Scripts.
• Involved in creating data forms, workflow process and task lists for Hyperion Planning applications.
• Experience in writing financial reports from OLAP servers using Hyperion Financial Reporting Studio (HFR).
• Involved in upgrade between releases and migration from one environment to another using Life Cycle Management (LCM) utility.
• Involved in migration of HFM applications between environments using HFM utility.
• Highly proficient in loading, reconciling, consolidating key Financial Data with Hyperion using FDMEE and HFM consolidation, validation and execution.
• Designing and modifying dimensions, creating data forms and data grids in HFM applications.
• Highly proficient in financial modeling/analysis and budgeting.
• Experience in maintenance of metadata for Hyperion HFM including extracting, loading and updating the metadata structure.
• Involved in back up process and synchronization of Production and QA environments.
• Experience in working with Essbase Excel Add - In and Smart View.
• Involved in applying patches for Hyperion EPM System.
• A comprehensive understanding of multi-dimensional databases, OLAP servers and its concepts.
• Experience in support of Essbase and Planning applications.
• Areas of expertise in Hyperion Data Relationship Management (DRM)
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.

TECHNICAL SKILLS

Oracle EPM tools: Hyperion Essbase 11.x, Hyperion Planning 11.x, Hyperion HFM 11.x, Hyperion FDQM 11.x, Hyperion Shared Services 11.x, Hyperion System 11.x Smart View

Operating Systems: Windows 2003/2008 Server, MS Windows XP, MS Windows NT 4.0, MS Windows 98, MS Windows 7

Programming/Languages/Frameworks/Tools: C, UNIX shell scripting, HTML, MS Office 2003/2007/2010

Databases: DB2, SQL, MS SQL Server

Reporting Tools: Hyperion Financial Reporting 11.x, FDQM Reporting, Smart View

PROFESSIONAL EXPERIENCE

Confidential, Las Vegas, NV

HFM Consultant

Responsibilities:

• Hyperion Classic Planning was replaced by EPM to build the Planning and Financial management applications for Sales, Revenue & Expenses and Corporate from the scratch to meet the Business functional requirements.
• Performance tuning and 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.
• Developed a custom program to report on user/group access information and disabled users in Hyperion Shared Services.
• Backup and Recovery of Hyperion applications. Scheduling daily backups.
• Responsible for creating and modifying an application for Sales including all its member formulas, calculation scripts and business rules required for the same.
• Worked with ADS Files for Loading Dimensions and Members, Placing the Aliases into the shared library which in turn is usable for different applications.
• Responsible for data validation from the source to target and vice versa before loading through Financial Data Quality Management Enterprise Edition.
• Used Financial Data Quality Management Enterprise Edition (FDMEE) to load data values, accounts, entities, and custom dimensions from data source such as GL into applications.
• Experience working on Application Partitioning for increased performance of the cubes.
• Used Workspace as a centralized system to register the application, creating the Web data forms, Workflow, Task lists, launching Business rules and Accessing Reports.
• Created many simple and composite forms data such as input forms, what-if forms, Sales Variance Form, Budget Input Form and Forecast Form required for budgeting and forecasting.
• Designed Reports including Product Variance Analysis reports, Monthly reports, Capital Expenditure reports, Corporate Reports and Departmental P&L Reports using Hyperion Financial reports (HFR).
• Created ad-hoc analysis using Excel smart view for data verification and data validation. Worked on Hsget and Hsset Functions in smart view for data submission and data retrieval.
• Worked on Excel Add-In to give the end user a report/analysis template from which they make selections to make the desired reports.
• Used V-Lookup in excel for dimension mapping, data Validations that exists I different applications.
• Supported the financial users and end users in setting up access for training during the different phases of the project.
• Supported in database optimization and performance tuning of Essbase cubes using Load runner for fast retrieval and calculation performance.

Environment: Hyperion Planning v.11.1/v.9.3.1/4, Hyperion Financial management(HFM), EPMA, Hyperion Administrative Services, Workspace, Shared Services, Oracle Data Integrator (ODI), Hyperion Financial Reports, Smart view, Essbase Spread sheet add-in, Oracle 10g, Windows server.

Confidential, Philadelphia, PA

Planning and Allocation Support

Responsibilities:

• Created Planning applications and Essbase applications for Budgeting based on position and Employee.
• Created the Web forms to get the budget data entered into the database by giving the access levels to the business users.
• Working closely with Infrastructure and DBA team to configure the system and troubleshoot performance issues related to Hyperion applications.
• Working with Hyperion Planning users and DBAs to diagnose and solve application errors.
• Production support issues resolved for the server issues, security issues, Data issues and the Performance optimization issues.
• Involvement in administration tasks such as Data Loading, Batch Jobs, Backup and Recovery.
• Security provisioning based on the business user level, and create the planners and interactive user’s groups.
• Integration with Oracle EBS system to pull the data like GL, sub Ledger, Discounts, Depreciation data. And to the HRMS.
• Installed the Hyperion version 11.1.2.1 on a distributed environment and upgraded to the new release of 11.1.2.3.
• Worked on Shared services User/Group maintenance.
• LCM migration process is used to Migrate the Elements/objects.
• Used the EPMA to maintain the library of Application, dimension library, Calculation manager, Rules & Rule sets.
• Also, used DRM/MDM to maintain the libraries of Applications/Dimensions modification history and deploy.
• Created the Meta data in Planning (Outline loader, ODI), EPMA (Data synchronization, ADS file import).
• Data loading process is developed, to retrieve data form EBS (Oracle applications) and to load into EPMA, Planning, Essbase data bases directly.
• Architected framework for automation of cubes using Batch scripts/shell scripts and MAXL for refresh of development with production data.
• Developed MAXL scripts to build and load data into ESSBASE database using Rule files.
• Handled weekly back-ups and monthly consolidations of data and automated monthly/quarterly/annual report generation
• Created the Workforce and Non-Workforce application for all Expenses and Revenues including the Project allocated expenses.
• Documenting functional and technical specs and different methods of cube loading processes.
• Implemented the Dense/sparse dimensional architecture with Attribute dimensions, Smart lists based on the requirement and easy to use and update in future.

Environment: Hyperion Essbase 11.1.2.1&3, Hyperion Planning 11.1.2.1&3, Shared Services, EPMA 11.1.2, LCM, DRM, MDM, Oracle 11gR2 &12c, Unix, Toad, Smart view.

Confidential, Erie, PA

GET Hyperion Support

Responsibilities:

• Work closely with the Finance department to ensure timely Hyperion Applications support during the close and non-close periods.
• Single point of contact for the Business System Analysts and End users for gathering all requirements for Implementation of Oracle EBS (AR, AP, I-Procurement and I-Receivables).
• Integration with Oracle EBS ERP system to pull the data from Oracle GL- sub Ledger, discounts, depreciation data and the details on major and minor projects from Oracle FA along with employee information from Oracle HR tables for building the end-to-end budgeting applications.
• Manage ad-hoc user requests and assist in the coordination of team activities on Hyperion projects.
• Provide ongoing operation support for Hyperion systems & HFM.
• Extract and load miscellaneous data in HFM and Essbase.
• Setup journals, task lists, member lists and web forms as per the functional requirements for the HFM application along with the consolidation and approval processes for monthly closing of fiscal periods.
• Maintain HFM Business Rules, Scripts, Variables, Input Grids, Data Forms, Reports and Journals.
• Support Hyperion FDMEE to support business users during the monthly close process and updating FDMEE load templates as needed.
• Maintain load scripts and mapping tables for legacy ERP loads in FDMEE.
• Developed the interfaces usingODI to achieve the Metadata and Data to meet the requirements.
• Assist in designing, developing, and deploying Hyperion DRM applications.
• Build multi-dimensional models by using Essbase Studio
• Perform all Essbase Studio tasks, including deploys cubes and executing drill-through reports
• Created Web based Data form to allow the end users to enter Actual data as per the Month wise period close process.
• Maintaining documentation for installation and troubleshooting procedures of the application.
• Installation of HFM Fusion edition 11, implementation of HFM 11.1.2, also responsible for upgrade and patching works for HFM application.
• Work closely with End-User community and any internal support groups to troubleshoot and solve technical issues adhering to pre-defined SLAs.
• Discussing with reporting management to schedule UAT user role, testing scenario for each identified user and develop user guide that include UAT activities.
• Be responsible to do testing in UAT before release of any changes in production environment.
• Involved in upgrade between releases and migration from one environment to another using Life Cycle Management (LCM) utility.
• Scheduling the Batches for running the reports using Hyperion Financial Reporting.
• Responsible for creating Multiple Templates of Smart View and Excel Addin for every day analysis of the user.
• Meta data is developed in Hyperion Planning for the actual or Budget data and loading the data through HAL, ODI.
• Support/maintenance of scheduled and ad-hoc jobs
• Performance monitoring and tuning
• Provide primary support to the users in solving day-today issues.
• Involved in maintaining and creating new data servers, connections for different data sources through the Topology manager. Created data servers for sources that included Flat files and SQL Server sources.
• Responsible for Migration of application from One Environment to other.
• Developing new reports in Hyperion Financial Reporting and Smart View, and making changes to the existing Report views when requested.
• Created and Managed Filters on Essbase cubes to restrict the access to the data for various intersections based on user privilege.
• Developed numerous Financial Reports like Profit & Loss Reports, Income statement Reports, Expense Reports & Revenue Reports using Hyperion Reports Tool.

Environment: Oracle EBS 11i, Hyperion Essbase 11.1.2.4, Shared Services 11.1.2.4, ASO & BSO, ODI, DRM, Essbase Studio, Smart View for office, Spread sheet add-in, Interactive reporting, Financial Reporting, Oracle 10g

Confidential, Rochester, NY

Sr. Hyperion Essbase & Planning Support

Responsibilities:

• Involved in end-to-end SDLC process for implementation of Hyperion Planning HFM, FDM and DRM in connection to Corporate and Divisional banners at The Confidential Companies.
• Collaborated with Infrastructure, Data Architecture and Solution Architecture, Solution Engineering and Delivery teams to propose the overall conceptual design and development
• Integration with Oracle EBS ERP system to pull the data from Oracle GL- sub Ledger, discounts, depreciation data and the details on major and minor projects from Oracle FA along with employee information from Oracle HR tables for building the end-to-end budgeting applications
• Created application profiles and built the chart of accounts for the HFM application
• Developed business rules using Calc Manager and invoked sub routines and functions along with used defined variables
• Setup journals, task lists, member lists and web forms as per the functional requirements for the HFM application along with the consolidation and approval processes for monthly closing of fiscal periods
• Setup currency translations for the consolidation and close process for the global divisions of The Lidestri Companies.
• Created FDM processes using FDM Task Workbench to load PeopleSoft data into Oracle EPM (Hyperion Planning and Hyperion Financial Management) on a periodic basis.
• Meta data is developed in Hyperion Planning for the actual or Budget data and loading the data through HAL, ODI.
• Designed and developed complex Business Rules to implement Business Logic Calculations for Hyperion Financial Management (HFM) and Hyperion Planning Applications.
• Created task flows to extract HFM data and extracted automated consolidation journals to record consolidation details for the Value dimension
• Setup intercompany reporting for the HFM application along with financial close reports by divisions and consolidated reports by LiDestri Corporate
• Involved in systeminstallation,configurationand softwareupgradesof Hyperion Essbase, planning.
• Designed the Essbase cubes for Block Storage Option (BSO) Sales and Expense Planning Applications for the Corporate and the divisional chains
• Created various rule files for dimension building and data loading of the cube by using several build methods such as generation, level and parent-child references
• Translated business models and diagrams into operational multidimensional outlines to build Essbase cubes and associated different dimensions with their respective members and assigned their properties, formula scripts; programmed automated jobs for running application processing tasks using MaxL scripts and Calculation Scripts
• Be responsible to do testing in UAT before release of any changes in production environment.
• Worked on a drilled down Security Matrix and Roles & Responsibilities Matrix for IT and business users at the company and built user roles in Hyperion Shared Services
• Built the hierarchies for dimension members in Hyperion Planning and HFM applications in DRM
• Developed DRM export scripts for generating the. ads files for EPMA deployment and synchronization
• Also, worked on developing an approval process using action scripts for accepting property changes to DRM from source systems Oracle General Ledger and Site Hub and blending the changes with the final approved versions in the DRM application
• Supported in Data Backups, Script Automations, Database optimization and performance testing for fast retrieval and calculation performance.
• Automated and scheduled reports using Hyperion Financial Reporting Studio for budgeting and forecasting purposes.

Environment: Oracle EBS, Hyperion Essbase 11.1.2.3, Hyperion DRM, Shared Services 11.1.2.3, ASO & BSO, Essbase Studio, Smart View For office, ODI, Spread sheet add-in, Interactive reporting, Financial Reporting, Oracle 10g.

Confidential, San Antonio, TX

Hyperion Developer

Responsibilities:

• Implemented Hyperion planning 11.1.2.1, Essbase 11.1.2.1 and upgraded to new versions.
• Created the Planning applications with the plan types for Revenue & Expenses along with Capital Expenditure planning.
• Created the Multi-currency applications with knowledge of functionality and to allow the currency input to enter in reporting currency entity in most of the applications including Headcount (Workforce) planning application.
• Integration with Oracle EBS ERP system to pull the data from Oracle GL- sub Ledger, discounts, depreciation data and the details on major and minor projects from Oracle FA along with employee information from Oracle HR tables for building the end-to-end budgeting applications
• Developed scripts for long range planning by setting up a cascading process based on a proportional spread across future years NY to NY10 based on the TY plan
• In 11.1.2 version, created HSF application for goal seeking process for single periods and time series
• Defined various functional formulas against account members
• Worked on Debt scheduler, WACC calculator and depreciation scheduler for managing cash flow in debt investments and rate of ROI calculations
• Initially involved in Hyperion upgrade from 9.3.1 to 11.1.1.3 and then to 11.1.2 for Hyperion Planning, Essbase, Shared services, EPMA and reporting tools.
• Started working on 11.1.1.1 version for Planning, EPMA, Essbase and upgraded to patch 3, 5, 6 and finally moved to 11.1.1.3.
• Developed Web Forms for the users to input forecast, budget, actual (overrides) accounting changes and other variance explanations data.
• Wrote Essbase formulas, Calculation scripts, MDX formulas as per the requirements and created substitution variables for the ease of maintenance of application.
• Wrote MaxL scripts to load databases, adding users, alter substitution variables and executed the scripts in both interactive modes and maintenance for daily backup.
• Involved in to maintenance activities like verifying the new dimensional members which are coming in actual data load daily or monthly, restoration procedure, security maintenance.
• Set up users and groups per the department and maintained security to users and groups from Hyperion shared services and assigned security to web forms.
• Developed some key reports like direct cost P&L summery, Income statement, Net Margin, Balance sheet and Headcount reports by using financial reporting studio.
• Trained business analysts on retrieving data from Essbase cubes by using Excel spreadsheet add-in and smart view.

Environment: Hyperion Planning 11.1.2.3, Shared Services11.1.2.3, Excel Smart View, Report Scripts, ODI.

Confidential, Blue Bell, PA

Hyperion Essbase Developer

Responsibilities:

• Involved in system installation,configuration and software upgrades of Hyperion Essbase, planning.
• Involved in developing design specifications of Essbase cube with Customers.
• Developed Aggregate Storage Cubes (A.S.O) cubes using Essbase.
• 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.
• Developed batch scripts using MaxL and ESSCMDs to load data from relational systems database to Essbase cube.
• Developed OLAP Models and outlines using Essbase Integration Services from star schema in relational databases.
• Involved in installation of Hyperion Planning on Windows environment.
• Create Data Source Configuration through Hyperion Configuration Utility 9.3 in Hyperion System 9 Foundation. Created and registered Planning applications in Hyperion System 9 Workspace.
• Created Dashboard Reports using Interactive Reporting.
• Developed and created Web forms for users to input the data into Essbase cube through Hyperion Planning.
• Worked extensively on Budget process and Budget Administrative tasks
• Involved in Structure changes and creating Alternate Roll up’s in Web Forms

Environment: Essbase 11.1.1.3, Excel Smart View, Hyperion Planning 11.1.3, Hyperion Shared Services, Report Scripts, ODI, HFR (Hyperion Financial Reporting).

Confidential

Hyperion Technical Analyst

Responsibilities:

• Worked on selection criteria for segregation of accounting flexfields/ combinations to generate P&L Line Analysis.
• Collaborated with the business users to define row sets, columns set and content set to filter general ledger data for reports for the regional and global operations across Asia Pacific region, North and South America
• Modified existing reports based on business requirements to alter report definitions
• Also, worked on a FSG Automation project to generate reports on a scheduled basis for GL month end, quarterly and year end consolidations
• Designed report templates on Hyperion Interactive Reporting Studio for serving the purpose of Reporting and Analytics for the various divisions at UCO
• Defined deliverable content, and ensured buy-in of proposed solutions from top management levels
• Modified current data forms to aid in variance analysis of statements line balances compared to prior years
• Created interactive reports for different market segments of the business using Hyperion Interactive Reporting Studio

Environment: Hyperion Planning, Hyperion Essbase System 9, Hyperion Financial Reports, Hyperion Planning System 9, ODI, Oracle 9i & Windows 2003.

Confidential

PL/SQL Developer

Responsibilities:

• Actively involved in interacting with front end users and gathered User Requirement and Online System Specification.
• Created number of database objects like tables, views, indexes, synonyms and materialized views using SQL Loader.
• Involved in creating procedures, functions, packages and triggers to facilitate functionality in different modules.
• Created data mapping files for the data coming from different web services.
• Developed ad-hoc Reports (SQL or PL/SQL scripts running in Unix System) to extract data from database and deliver to user in Excel format.
• Created audit tables and implemented complex business logic using triggers.
• Used cursors, for cursors and Ref Cursor (dynamic SQL) for fetching data and processing it.
• Avoided Mutating table errors by using different methods like pragma autonomous transaction, statement level trigger and multiple triggers.
• Worked onXMLalong with PL/SQL to develop and modify web forms.
• Used bulk processing for better performance and easy retrieval of data, being a part of performance tuning of the procedures and packages.
• Developed ETL sessions for initial full loading and incremental loading.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
• Developed ETL sessions for initial full loading and incremental loading.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Monitoring nightly ETL batch flow and resolving the issues and directing it to concerned person.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Worked on requirement analysis, coding and testing various modules in a software development life cycle.

Environment: Oracle Database 9i, Toad, SQL*Plus, SQL* Navigator, SQL*LOADER, UNIX, Forms Builder 6i, Reports Builder 6i.