SUMMARY:

• Over 8 + years’ experience in Oracle - Hyperion applications and custom software solution design and development, application integration, migration and consulting management.
• Diverse experience in OLAP design, analysis, architecture, development, implementation, reporting, administration, and migration of various applications in client/server environment using Hyperion Essbase, Hyperion Planning, Essbase Integration Services, Hyperion Workspace, Hyperion Reports, Hyperion web Analysis, Hyperion Essbase Spread Sheet Add-in/Smart-view, Oracle Data Integrator, Hyperion Financial Management, Financial Data Quality management under Windows and Unix environments.
• Proven track record of successful implementation of all project lifecycle stages from requirements gathering implementation and enhancements.
• Developed HFM applications in classic and EPMA mode which is sourced from various financial data sources used for client consolidation needs.
• Experience in Accounting: Balance Sheet, P&L, A/P, A/R, G/L, Fixed Assets, Budgets, Closing, Reconciliations, Journal Entries, Payroll, Banking, Trial Balance, Financial Analysis, Financial Audits, ERP Implementation.
• Strong skill set in Installation, Configuration, Troubleshooting and application demo presentation of Hyperion 9 & 11 on Windows and Linux operating systems.
• Strong experience in Financial management applications, metadata preparation, security classes, Member lists, data grids, Web Data forms, journals posting, ICP Eliminations, reports and automation of HFM tasks using task flows from workspace.
• Strong Skill set in Developing ASO and BSO cubes using Hyperion Essbase that contained financial data that was retrieved using FR reports
• Installed and configured complete Hyperion EPM suite from server requirement gathering to server deployment.
• Used various application and web servers in versions 9 and 11. Used Apache Tomcat application Server and web server in version 9 and used web logic application server and Oracle HTTP server in version 11
• Strong experience and skill set in migrating Essbase application from System 7 to System 11.
• Experience in working with Aggregate Storage Outline (ASO) and Block Storage Outline (BSO).
• Designed custom substitution variable Excel template using Visual Basic scripts. Those templates are used for updating the variables.
• Designed Essbase applications for day to day end user reporting and planning applications as per client requirements for budgeting and forecasting.
• Created complex and simple reports from relational/ Multi-dimensional databases using OBIEE
• Created OLAP Models and Meta Outlines using Essbase Integration Services (EIS) for dimension building and data loading.
• Extensive knowledge of writing business rules for planning applications and Calc Scripts for Essbase applications to fulfill end user custom calculation requirements.
• Designed web analysis, Hyperion financial reports, and Smart view & Excel templates as per end user reporting requirements.
• Integrated desperate data sources into Hyperion planning and Essbase applications using Oracle Data Integrator.
• Integrated ERP Systems (People Soft, Oracle EBS, SAP) to Hyperion applications and vice versa.
• Used Oracle Data Integrator Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse databases as well as Hyperion applications.
• Extensively used VBA scripting to design excel templates for Hyperion Essbase retrieval and calculation.
• Expert level knowledge and understanding of ESSCMD and MAXL scripts used for automations
• Excellent communication and interpersonal skills and outstanding team player with an aptitude to learn.

TECHNICAL SKILLS:

BI Tools: Hyperion planning 11.x/9.x/4.x/3.x, Essbase 11.x/9.x/7.x/6.x, Oracle Business Intelligence suite, Hyperion Financial Reporting, Hyperion interactive reporting (BRIO) 11.x/9.x/8.x/6.x, Brio Insight, Brio Server 11.x/9.x/6.x,Brio Explorer, Hyperion strategic finance(HSF) Hyperion financial management 4.x/9.x,Smart View, Essbase Administration services, Hyperion Data integration management (DIM), Hyperion workspace, Hyperion shared services, Hyperion web Analyzer 9.x,7.x/6.x/5.x, Hyperion Reports 9.x/7.x/2.x, Excel Add- in, Essbase Studio, Hyperion Visual Explorer.

Databases/ERP: Oracle 9i/10g, DB2 8.0, MS SQL Server 2000/2005, Teradata V2R6,IBM AS/400

ETL Tools: Informatica 8.1/7.1, Data Stage 8.x/7.x

ERP: SAP, People soft, Oracle Financials

Middleware: Web Logic, IBM’s Web Sphere, Java Web Server

PROFESSIONAL EXPERIENCE:

Confidential, Warren, NJ

Sr. Hyperion Essbase & Planning Developer

Responsibilities:

• Worked from End to End implementation from requirement gathering to production deployment as part of this application development.
• Design, develop, and implement enterprise-wide budgeting, forecasting, and financial reporting cubes.
• Implemented entire SDLC of Hyperion planning and Essbase applications
• Create Oracle / Hyperion Planning and Essbase solutions - specializing in Workforce Planning and also have extensive experience building Revenue, Capital, Income Statement, Balance Sheet, and Cash Flow applications.
• 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
• Responsible for the day-to-day maintenance of Hyperion ESSBASE and Planning as well as all Hyperion activities related to monthly management reporting, forecasting, and the annual budget process.
• Involved in defining requirements, functional specifications, design documentation and test strategy.
• Involved with customers and data analysts in design of data flow, integration and transformation of data into data marts.
• Designed application as per end user requirements and fulfilled all the customizations as required.
• I was involved in data transformation from Hyperion Planning to Hyperion Financial Management.
• Developed and deployed EPMA and classic HFM applications used for consolidation purposes.
• Implemented Workforce and capex planning modules to budget and forecast on HR and capex related data.
• Integrated FDM Applications with HFM Applications by creating mappings between FDM and HFM Applications for loading data and metadata.
• Designed OBIEE dashboards to report the Essbase and Planning applications data.
• Created EPMA and classic applications for the planning development purposes.
• Created complex and simple reports using Excel Smart view, Hyperion Reporting
• Created reports from relational/multi-dimensional databases using OBIEE for various reporting purposes.
• Installed ODI as a Service in DEV, UAT and PRODUCTION environments.
• Designed ETL using ODI to integrate various source system data to Hyperion applications
• Designed ETL process from ERP system to Hyperion application which includes dimension build and data loads.
• Developed Batch Scripts to load data into cubes and schedule to run on a periodic basis.
• Created shell scripts to start and stop Hyperion related services.
• Created shell scripts to automate the ETL process related to Hyperion applications i.e for data loading and dimension building.
• Created shell scripts for backup and recovery of Essbase applications and server file system.
• Experience inEssbase application design and development, focusing on ASO and BSO combination.
• Designed detailed level of security for Hyperion applications using shared services.
• Experience with complex IT and Finance environments with multi-tiered reporting systems.
• Used extensively maxl scripts to automate dimension building and data loading process of ASO and BSO applications
• Developed numerous financial Reports like Income Statement, cash flow and balance sheet.
• Strong experience in migration of Hyperion application components from one environment to other.

Environment: Hyperion system 11.1.2.1, Hyperion Essbase 11.1.2.1,Hyperion Financial Management 11.1.2, Hyperion FDQM 11.1.2,Hyperion Financial Reporting (HFR) 11.1.2, Hyperion Planning, Oracle 11g Hyperion Shared Services, VB Script, Smart View, Window Server 2003/2008 R1, Oracle SQL Developer 2.1.1.64, Oracle 10.204, XML Files, SQL, PL/SQL

Confidential, Middletown, NJ

Sr. Hyperion Consultant

Responsibilities:

• Design, develop, and implement enterprise-wide budgeting, forecasting, and financial reporting cubes.
• Installed and configured entire Hyperion infrastructure for test and production instances
• Involved in Installation, configuration and validation of all 11.1.2.2 Hyperion components
• Involved with customers and data analysts in design of data flow, integration and transformation of data into data marts.
• Configured Hyperion system with multiple application and web servers to provide continuous availability of Hyperion services.
• Configured load balancer to manage the load on the Hyperion services.
• Developing ASO and BSO cubes using Hyperion Essbase that contained financial data that was retrieved using FR reports
• Involved in creating, redesigning, testing, documenting, reporting, protecting, supporting and administrating the full life cycle of multidimensional database using the Hyperion software family.
• Created applications on Hyperion as per the user requirements.
• Designed application as per end user requirements and fulfilled all the customizations as required.
• Developed Batch Scripts to load data into cubes and schedule to run on a periodic basis.
• Involved in performance tuning and optimizations for data/dimension loads, database restructuring (BSO/ASO), calculations, overall Essbase performance. Key techniques used were resetting databases, grouping sparse member combinations, using parallel calculations, managing caches, using two-pass calculations, changing buffer size, setting numeric precision, restructuring cubes for defragmentation.
• Created Hyperion planning web forms to enter, update, analyze, print, and report on data.
• Created transparent partition for the ASO cubes as target for BSO source cubes to enhance reporting.
• Created SQL scripts for sourcing data from Teradata, including creating tables, views, stored procedures, loading data into the tables.
• Created the Planning applications with the plan type for Revenue, expenses, capex and workforce modules.
• Involved in data tie-out for performing OLAP cubes using a simple variable substitution mechanism, to ensure that data is the same in both system.
• Strong experience in writing the VBA scripts in Excel to refresh excels templates.
• Implemented the Dense/Sparse dimensional architecture with Attribute dimensions, Smart lists based on the requirement and easy to use and update in future.
• Designed detailed level of security for Hyperion applications using shared services.
• Experience with complex IT and Finance environments with multi-tiered reporting systems.
• Worked on day to day production supports for Essbase and Planning applications.
• Strong experience in migration of Hyperion application components from one environment to other.
• Worked on day to day production tickets related to Hyperion applications. Supported products are Hyperion planning, Essbase, HFM, FDQM, Smart View and Excel Addin.

Environment: Hyperion Financial management 11.1.2.2,Hperion FDQM 11.1.2.2, Hyperion planning 11.1.2, Essbase 11.1.2, ASO, BSO cubes, Hyperion smart view, Hyperion Financial Reporting 11.1.2 Oracle 11g, Oracle data Integrator 11g, Oracle Applications, MS Excel Add-in.

Confidential, Philadelphia, PA

Sr. Hyperion Consultant

Responsibilities:

• Worked on various phases of project as part of implementation of Hyperion products.
• Design and support of Essbase/VPT/Risk applications and databases (ASO & BSO) - Portfolio, Forecast, Cerberus reporting and Planning cubes to capture the financial and quantity data for Value Planning to enhance reporting.
• Involved in performance tuning and optimizations for data/dimension loads, database restructuring (BSO/ASO), calculations, overall Essbase performance. Key techniques used were resetting databases, grouping sparse member combinations, using parallel calculations, managing caches, using two-pass calculations, changing buffer size, setting numeric precision, restructuring cubes for defragmentation.
• Worked on improving Web-based budgeting and planning system enhancing collaborative, event based operational planning processes for G&A planning and forecasting.
• Hyperion Planning was used in testing of the new calculation scripts and to define business rules to match the needs of the users.
• Created Hyperion planning web forms to enter, update, analyze, print, and report on data.
• Created transparent partition for the ASO cubes as target for BSO source cubes to enhance reporting.
• Created SQL scripts for sourcing data from Teradata, including creating tables, views, stored procedures, loading data into the tables.
• Created custom Excel data entry forms using macros and VB script to replace Hyperion Planning data entry forms to reduce the work load of the user thereby focusing on Planning, Budgeting and Forecasting.
• Rebuild/Redesign of existing and new Essbase models for new business reporting.
• Provided several key features in the Essbase DB, for the usability for financial controllers and directors, while maintaining the simplicity for maintenance. This involved flexibility to allow the business users to load data at any level into the Essbase DB based on the each business unit's procedures for Budget and Forecast numbers.
• Worked Extensively on Admin Services, Essbase, Planning, Performed monthly and quarterly data loads and verifications.
• Extensive Essbase DBA experience and activities such as filter creation, creation of users, creation of groups and related activities. Involved in analysis, development and enhancement of database outlines. Maintained application security and added/deleted users per management requests.
• Role of Essbase Administrator and key involvement in editing Calc Scripts, developing MaxL scripts for automation, MDX for advanced queries. Worked extensively on metadata and data loads, business rules, load rules, performance tuning, Batch Scripting, UDA.
• Also involved in installation Essbase 9.x and actively participated migrating Essbase application from System 7 to System 9.
• Created Hyperion business rules (HBR), calc script, and responsible for automating jobs and processes
• Developed the OLAP model and Meta-outlines, implemented star schema and used EIS to interface with the company’s existing oracle data warehouse.

Environment: Hyperion Essbase 9.3.1, Hyperion planning 9.3.1, Essbase Integration services, Hyperion Interactive Reports, Hyperion Web analyzer, Hyperion Financial Reporting Studio 11, Hyperion Utilities, Maxl, MDX, EAS administrative services, MS SQL Server 2005, Smart View, HAL, MS excel Spreadsheet Add-In, Windows 2003.

Confidential

Hyperion Essbase & Planning

Responsibilities:

• Involved in the creation of dimensions and members in Essbase Outline
• Involved in the complete Software Development Life Cycle of the applications
• Designed and developed complex Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion.
• Optimized the Hyperion application to balance the calculation and retrieval performance.
• Developed the reports as for given client templates in Hyperion analyzer.
• Performed dynamic calculations, loaded data from various database using Rules files, developed, reviewed, and optimized report queries in Microsoft Excel.
• Created security for the cubes ( created users/Groups)
• Developed the Security Filters for Essbase applications
• Built ETL process to load data and build dimensions in Essbase applications in Nightly mode.
• Worked on day to day production supports for Essbase and ETL applications.
• Worked with SME and business analysts to gather and analyze requirements and built and POC for initial sign off.
• Hyperion Planning is used to build the Planning and Budget application from the scratch to meet the business functional requirement and to map the data from the external sources application.
• Developed numerous simple to complex Business Rules for planning and calc scripts for Essbase applications as per end user requirements
• Created the Planning applications with the plan type for Revenue, expenses, capex and workforce modules.
• Involved in data tie-out for performing OLAP cubes using a simple variable substitution mechanism, to ensure that data is the same in both system.
• Created HAL7.3 (Hyperion Application Link) jobs for dimension build and data loads.
• Project within budgeting, planning, forecasting, OLAP and reporting solution and manage security of Hyperion apps.
• Primary responsibility include but not limited to installing and configuring the Informatica (DAC) software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ETL.
• Provided hands on document which explains the functionality of each and every Cube and reports which helps end user to understand what they can do with Cubes and reports.
• Used VBA for the creation of a template system where the field actually inputs data into an excel workbook that then sends the numbers to Essbase and initiates a calc script via VBA automations resulting in consolidated financials.
• Used VBA as a very powerful spreadsheet toolkit for automating Essbase/Excel retrieval task.
• Optimizing Aggregate Storage Option and Block Storage Option outline.
• Improved the performance i.e., optimized the Planning, Essbase system by changing the dimension order and working on configuration file including cache design technique.
• Used Hyperion Financial Management (HFM) for financial analysis and reporting and also created and modified numerous reports in Financial Reporting studio.
• Documented development process and also production support process of handling various issues.

Environment: Hyperion Planning system 11 and 9.3/7.x, Hyperion Shared Services 9.3/7.x, Hyperion Workspace, Essbase 9.x/7.x, HAL 4.x, Hyperion Interactive Reporting Studio 9.3/7.x, Hyperion Financial Management(HFM), Essbase Excel Add-in 7.X, Oracle 11g/10g, Ms Excel 2003/2007,Windows/Linux. OLAP Data Warehousing using Hyperion Essbase 7.0, Hyperion Planning 7.0, Essbase Excel Add-In, MS-Excel, Oracle & Windows 2000/ SUN Solaris.