SUMMARY

• Oracle Hyperion expert with over 8+ years of IT experience including 6+ years in administration, design, analysis, development, migrations, installations and implementation of BI solutions using Hyperion Essbase 11.x/9.x, Hyperion Planning, Hyperion Financial Reporting, Hyperion DRM 11x, EPMA, ESSCMD, MaxL, Smart View, Essbase Excel Add - In on Windows and UNIX environments
• Experience with full Enterprise Software Project Lifecycle from initiation through requirements, analysis, design, development, testing, deployment and administration (support and maintenance).
• Proven ability to identify, track and resolve issues related to the project throughout its lifecycle
• Highly skilled in designing, developing and administering Hyperion Essbase Cubes and Planning Applications
• Expert in user/group provisioning, providing access roles/permissions to applications in Shared Services.
• Hands on experience in designing and developing numerous cubes and Multi-dimensional databases both ASO and BSO in Essbase with excellent balance of dense and sparse dimensions allocation strategy
• Created and maintained Meta outlines and used hybrid analysis to drill down to relational sources using Essbase Integration Services (EIS) to develop and support Essbase Outlines.
• Experience in performing regular data validation and maintenance to ensure accuracy of end user tools.
• Expertise in building Dimension build rules, Data load rules and writing custom Essbase calculation scripts, automating Essbase cubes using MaxL and ESSCMD
• Skilled in performing automation and Optimization of cubes and calc scripts, upgrading, testing and migration of cubes in different environments
• Proficient in using LCM Utility to migrate Hyperion applications
• Knowledgeable of financial and business concepts, chart of accounts/balance sheet/P&L/cash flow
• Prepared monthly and quarterly reports for all cost variances between Actual, Budget and Forecast scenarios using Financial Reporting Studio. Also experienced in developing dashboards using Hyperion Web Analysis Studio.
• Created templates and ad-hoc reports using Excel Add-in, Smart view for budget and forecast analysis
• Experience working with Relational Database sources (RDBMS) including SQL Server, Oracle DB, Teradata.
• Functional knowledge of financial statements, budgeting, forecasting and planning processes that facilitate creation of powerful Hyperion solutions including Workforce estimation and capital expense (CAPEX) planning.
• Proficient in Star and Snowflake schema modeling techniques to design data warehouse & data marts, ETL techniques and processes.
• Created user training manuals, documentation and provided training to the end users on Hyperion tools
• Excellent interpersonal, presentation and communication skills with the ability to work in a team and a stand-alone environment

TECHNICAL SKILLS

OLAP Tools: Hyperion Essbase 11.x/9.x/7.x/6.x,DRM 11x, Hyperion Planning, Financial Reporting Studio, Web Analysis, FDM, Smart View for Office, Excel Add-InDatabases Oracle 11i/10g/9i/8i, MS SQL Server, MS Access, DB2

Languages: ESSCMD, MaxL, MDX, SQL, PL/SQL

Modeling Tools: Star & Snowflake Schema, Dimension and Fact tables, Logical and Physical modeling

Operating Systems: Windows NT/2000 /XP/UNIX/ server 2003/server 2008

PROFESSIONAL EXPERIENCE

Confidential

Sr. Hyperion DRM/Essbase/Planning Consultant

Responsibilities:

• Actively involved in project development life-cycle from analysis of Functional Specifications Document (requirements gathering), application design, development, parallel testing, rollout into production environment, implementation and end-user training.
• Configure and Create Hyperion DRM and ESSSBASE application components (Hierarchies, Properties, Node types, Validations, scripts etc.)
• Implemented robust data-access security and user management.
• Optimized data loads and calculation scripts and maintained existing ESSBASE cubes. Optimized the applications to reduce runtime.
• Developed a transparent partition withASO / BSOcubes to leverage advantages of both technologies.Developed rule files for loading data and for dimension build.
• Retrieved reports using Excel Add-in and generated batch reports using Hyperion reports.
• Created Rule files in EAS for dimension building and data loading.
• Loaded the data automatically using MaxL and batch script.
• Involved in Testing of Data consistency from Cube to Cube.
• Developed numerous member formulas, Calc scripts and optimized calculations scripts.
• Validation and cleansing techniques of data to be imported in DRM and ESSBASE.
• Monitor GL data load process into Essbase and evaluate data Integrity on a daily bases.
• Performed DRM Import/Export processes to various applications for ESSBASE applications.
• Total experience with in building automator scripts to upload different hierarchies in DRM and ESSBASE.
• Defining properties into the system. Also worked with blender.
• Developed Business rules and assigned it to data forms to run on save.
• Performed Validation and cleansing techniques of data to be imported in DRM.
• Experience with System Administration setup and activities.
• Prepared design document for Interfacing DRM with transactional and analytics system through inbound and outbound web services API.
• Understanding of source data files and configures Meta data and master data in DRM.
• Defining batch scripts to automate the imports and export processes.
• Extensively used EPMA to maintain metadata for various planning applications.
• Validate calculated data with the help of Excel add in.
• Developed ad-hoc reports in smart view.
• Developed Maxl scripts write back Process to Automate the Whole Hyperion Essbase tasks.
• Developed reports for the regulatory purpose in Essbase Excel Add in and Standard Reports in Hyperion Financial Reporting.
• Build Node types and data validations in DRM to support data integrity.
• Involved in identifying what should be the master data and how it can be handled using DRM
• Experience with Oracle Data Integrator.
• Substantial ETL architecture design experience within data warehousing environments governed by applying appropriate methodologies and ETL standards.
• Ability to design ETL technical/functional specifications.
• Discussed with users to in corporate new dimension requirements into the existing cubes.
• Prepare key deliverables such as requirement documents, design documents, development inventory, test documentation, training materials and administration/procedural guides and also involved in UAT testing.
• Migrated DRM metadata object using the DRM migration utility

Environment: Essbase 11.1.2.2, Hyperion DRM 11.1.2.2, Excel Add In, MS- Excel, MS Access, Hyperion Financial reporting 11.1.2.1,EPMA, Smart View, Microsoft SQL Server, Windows Server 2003/2008, Excel Add-in, MS Excel 2010.

Confidential, Pittsburgh, PA

Sr. Hyperion Essbase/Planning/DRM Consultant

Responsibilities:

• Actively involved in project development life-cycle from analysis of Functional Specifications Document (requirements gathering), application design, development, parallel testing, rollout into production environment, implementation and end-user training.
• Developed two Applications in Hyperion planning 11.1.2.1 to capture Finance and Payroll data.
• Was responsible for gathering requirements and conducting meetings with business users to find out dimension hierarchy, members and its properties.
• Create Planning application through EPMA.
• Maintain the dimensions through dimension library in EPMA.
• Created Workforce Planning App (Payroll) manually and also created business rules to calculate payroll data.
• Extended the functionality of the planning system to include Workforce estimation planning
• Loaded data into Essbase cube through FDM.
• Extensively worked on updating import format, locations, mapping in FDM application.
• Created various Calculation scripts to Copy, Delete, Calc data and also used @XREF function to bring data from different database to calculate.
• Created various web forms like payroll form, balance sheet forms, Income statement forms, Cost center forms for users to enter respective data.
• Responsible to create and manage various task lists which guide users through the planning process by listing tasks, instructions, and due dates.
• Responsible to create Planning Unit Hierarchy (Workflow) by gathering requirements from business users and assign users to their respected cost center.
• Also assigned different users to different roles like Owner, Reviewer to plan their respective cost center.
• Extensively worked with Hyperion Shared Services to give access and provision to users and groups.
• Configured various LDAP active directories with Hyperion Shared Services.
• Created different groups and gave them proper access to planning dimension, web forms, task lists, workflow to access users their respective intersection.
• Extensively work on Lifecycle Management to migrate security, planning application and its components from DEV to PROD environment.
• Created backup scripts for planning application data and metadata and automated backup scripts which run on daily basis.
• Created ASO cube in Essbase Administration Services for reporting purpose and imported data from planning cube.
• Improved the Performance (Optimized the Planning, Essbase system) by applying different optimization techniques and working on configuration file including Cache design techniques.
• Extensively worked on Hyperion Financial Reports to create detailed and summary Income statement and balance sheet reports from planning and Essbase App.
• Created Books of reports and scheduled those books by creating Batch files by using Hyperion Workspace.
• Gave training to users about Web form, Task list, Planning Security, Work flow and its functionalities.
• Also provided training for ASO, Smart view, and use of planning functionalities in Smart view.
• Responsible for validating reporting templates for Balance Sheet and Income Statement matching previously used reports gathered from Solomon, Great Plains using Hyperion Financial Reports.
• Provided technical support for existing cubes, problem identification, resolution and documentation.
• Development of import and exports profiles for various Application Interface Designs (AID) with queries to filter different hierarchy levels and specific property requirement
• Development of defined and derived properties, various property categories and validation
• Migration for metadata using migration utility for development, test, production instance for multiple project
• Deployment in production environment of several release for different stage of project
• System Testing of new DRM patch for DRM version 11.1.2.1
• Unit testing for entire workflow for performance tuning purpose
• Creation and updating configuration and batch scripts for windows server for import, blend and exports
• Testing entire workflow including Oracle Database, unix environment and windows server using SQL Developer, Putty, Win-Scp
• Tracking development progress and document changes for each project
• Supporting business analyst with requirement analysis and documents as well as workflow testing process

Environment: Hyperion DRM 11.1.2.1, Hyperion Planning 11.1.2.1, Hyperion Essbase 11.1.2.1, Essbase Administration Services (EAS), Shared Services, EPMA, Hyperion Financial data quality management 11.1.2.1, Hyperion Financial reporting 11.1.2.1, Smart View, Microsoft SQL Server, Windows Server 2003/2008, Excel Add-in, MS Excel 2010.

Confidential, NJ

Sr. Hyperion Essbase/Planning Developer

Responsibilities:

• Participated in defining requirements from the end user, functional specifications, design documentations and test strategies.
• Designed and developed Planning application facilitating Budgeting and forecasting.
• Involved in creating the load utility files for the dimension member loading and the data loading into the application.
• Created web forms for the user inputs which were tuned by creating the attribute and substitution variables.
• Designed, developed and implemented the planning and reporting system for the financial department.
• Created classic planning applications using Workspace.
• Created and managed numerous Business Rules and Member formulas for application.
• Worked on Supporting FDM application for Data loading Planning application.
• Rewrote Import Scripts to work with Custom Delimiters.
• Updated FDM mapping to Map a Single column in two dimensions.
• Created New Locations, and import format to load the data in planning application.
• Designed currency conversion Rule to facilitate reporting in more than one currency.
• Provided training to end users in using the MS Excel spreadsheet add-in and Web forms to enter data.
• Involved in user access provisioning and the security filter on the system. Assigned accesses and privileges to various end users in different planning applications using Shared Services.
• Responsible for developing Financial & Management Reports using Hyperion Financial Reporting Studio and Hyperion Smart-View.
• Design Operating and CIP Budget Book using Hyperion Financial Reporting Studio.
• Build the financial reports for various end-users based on Program, Department and Project.
• Used different functionality of FR as Conditional Suppression, Conditional Formatting.
• Validate metadata and data using Hyperion Smart-View.
• Responsible to keep the structure of the Report folders in sync in different environments for the report migration purpose.
• Developed reports in Excel using Smartview function: HsGetValue.
• Created Reports with Multiple Database Connections.
• Used the Conditional Suppression functionality to suppress the rows/columns to display dynamically based on Prompts, User POV & grid POV.
• Developed Books from the Financial Reports and documented all financial reports.
• Involved in the Automation of the Reports to run in PDF, HTML formats.
• Publish and Test all the reports in Hyperion Workspace.
• Responsible for solving the reports issues related to tool with the help of Hyperion tech support
• Created Dashboards getting data from Oracle & Essbase cubes in Interactive Reports.
• Data Validation by comparing the data from data warehouse and cubes using IR Studio.
• Created Reports, Pivots & charts in Interactive Report Studio.
• Assign the security permissions and provisions to the Reports in Hyperion Workspace.
• Maintain security by creating, managing, and assigning provisions to the users in the shared services.
• Act as a Liaison between the tech team and the business users to promote the financial reports from the development to production environment.

Environment: Hyperion Planning 11.1.2.1, Hyperion Essbase 11.1.2.1, Hyperion DRM 11.1.2.1, Essbase Administration Services (EAS), Shared Services, Hyperion Financial reporting 11.1.2.1, FDM 11.1.2.1, PeopleSoft Financials 9.1, Hyperion Interactive reporting 11.1.2.1 Oracle Database 11g, Linux-RHEL5, MS Excel 2010.

Confidential, Simi Valley, CA

Sr. Hyperion Essbase/Planning Consultant

Responsibilities:

• Actively participating in defining requirements, functional specifications, design documentations and test strategies.
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass Model.
• Involved in creating Rule files for dimension building and data load process and created scripts in MAXL for automating these processes.
• Created Data integration process to load data from file systems into Hyperion Planning using Oracle Data Integrator (ODI).
• Designed data integration using Oracle Data Integrator (ODI) by setting up sources and targets using ODI Topology Manager, creating Designer models, developing integration interfaces and additional components
• Utilized ODI to load data from Oracle GL and Legacy systems into planning. Responsible for setting up all dimensions, members and measures.
• Used Operator GUI to schedule and automate data load processes through ODI
• Developed Data Loads and numerous Calc Scripts and optimized them.
• Designed, developed and implemented the planning and reporting system for the financial department.
• Created planning applications using EPMA and Planning studio.
• Created Shell scripts and Batch scripts for automation of data load, metadata load and running security files.
• Used FTP for putting files on Unix Server.
• Created and managed numerous Web Forms and created Business Rules for multiple applications.
• Combined Tables, Queries, Pivot, and Chart etc. into dash board and wrote scripts to drill down in dash board for interactive reporting.
• Involved in the Automation of the Reports to run in PDF, HTML formats.
• Publish and Test all the reports in Hyperion Workspace.
• Created Key Performance Indicators report using Interactive Reporting.
• Assign the security permissions and provisions to the Reports in Hyperion Workspace.
• Maintain security by creating, managing, and assigning provisions to the users in the shared services.
• Redesigned currency conversion scripts to facilitate reporting in more than one currency.
• Assigned accesses and privileges to various end users in different planning applications using Shared Services.
• Maintaining and updating Essbase and planning applications as per user and business requirements.
• Extensively working on Database optimization and performance tuning of Essbase cubes for fast retrieval and calculation performance.
• Providing training to end users in MS Excel spreadsheet add-in and Web forms to enter data.

Environment: Hyperion Planning 11.1.1.3, Hyperion Essbase 11.1.1.3, Hyperion Interactive reporting 11.1.1.3, Hyperion Financial reporting 11.1.1.3, EPMA, Essbase Administration Services (EAS),Shared Services, Oracle Data Integrator (ODI), Oracle EBS R12, Oracle Database 10g, Windows Server 2003, Linux, Windows XP, MS Excel 2003

Confidential, Dallas, TX

Hyperion Essbase & Planning Consultant

Responsibilities:

• Involved in user requirements, Identifying Dimensions and identifying data sources.
• Worked with Aggregate Storage Outline (ASO) and Block Storage Outline (BSO) to store different types of multidimensional data.
• Optimizing Aggregate Storage Option and Block Storage Option outline
• Giving source specification required for flat file format.
• Writing Rule file for Dimension building & Data Loading.
• Written simple as well as Complicated Calc scripts.
• Written Report scripts for Report generation.
• Created reports using Hyperion Financial Reports & Hyperion Web Analysis Studio.
• Creating reports using Hyperion Smart view.
• Designed and developed web forms as per the business requirements using Hyperion Planning.
• Developed numerous simple to complex Business Rules and attached them to the web forms.
• Extracted data manually from different sources to combine different sources into one business report.
• Developed calc scripts to derive complex calculations such as cash cost per user, YTD commitment, variance, capital expenditure forecast and budgeted cash flow statements.
• Developed web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data.
• Performed performance tuning and database 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.
• Created Key Performance Indicators report using Interactive Reporting.
• Used various conditional numeric functions to add computed columns in query, result, pivot and report sections in Interactive reporting and did Problem solving and Query Tuning while report generation.
• Designed and developed various types of reports (Pivot, Tabular, and Chart reports) to be used by different user groups using Hyperion Interactive reporting.
• Handled performance tuning, weekly back-ups and monthly consolidations of data and automated monthly/quarterly/annual report generation.
• Developed weekly, monthly forecast, budget and quarterly year to date (YTD) reports.
• Uploading data to and data from Hyperion Planning.
• Developed web forms using Hyperion Planning for the users to input data.
• Developed Business rules and attached to the input forms to calculate data on save option.
• Designed Task lists for the Planning applications.
• Involved in complete life cycle of cube from specification requirement to production move of the cube.
• Tuning and Performance of Data Loads and Calculation Scripts.
• Created Hyperion Security by creating Users, Groups and Filters for Analytic Services and Hyperion Reports.

Environment: Hyperion Planning 11.1.1.3, Hyperion Essbase 11.1.1.3, Hyperion Interactive reporting 11.1.1.3, EPMA, Essbase Administration Services (EAS),Shared Services, Oracle Database 10g, Windows Server 2003,Windows XP, MS Excel 2003

Confidential, Reston, VA

Hyperion Essbase & Planning Consultant

Responsibilities:

• Supported development, administered and maintained Planning/ Essbase cubes(BSO)
• Created MaxL scripts to automate Backup/Restore, Batch loading and Batch Calculations
• Automated daily jobs for cube building, data loads, calculations and exporting data to take regular backups
• Developed and maintained Batch files scheduled jobs to upload data from financial systems to Essbase cube
• Uploaded monthly numbers and assisted markets with systems issues
• Created users and groups in Shared Services and assigned privileges to them.
• Assisted in the reconciliation and validation between the Corporate and market integration processes
• Created Dimension build rules and Data load rules to load data into Essbase cubes
• Optimized outline structure, data load times and calculations through appropriate dense and sparse settings of dimensions, storage allocations and by dynamic calculations
• Developed Calc scripts to perform aggregations and fine tuned them to bring down calculation times
• Defined and setup the application security in Hyperion Essbase.
• Prepared budget and forecast statements, P/L statements for Sales data using Financial Reporting Studio
• Migrated existing financial reports, Web Analysis dashboards from Dev to Prod
• Closely worked with business users across the globe to troubleshoot and resolve issues as and when they surfaced.

Environment: Planning 9.3, Essbase 9.3, MaxL, ESSCMD, Smart View, Oracle, and Windows.

Confidential

Database Developer

Responsibilities:

• Designed and developed Graphical User Interface using Forms.
• Developed the PL/SQL stored procedures for implementing the business logic.
• Developed the on-line context-sensitive user help.
• Development of reports (stores ledger, invoice preparation) using Reports 2.5
• Analyzed user requirements and involved in the process of finalizing dimensions for cubes.
• Developed test plans for invoice, order entries, billing, shipping, and Stock maintenance.
• Configured Oracle Clients on Win NT Workstations.
• Constructed Oracle Database Triggers and Indexes.
• Responsible for Code Reviews and PL/SQL Code Tuning
• User Management Duties involved: Create, Modify and Delete user accounts.

Environment: SQL Server 6.5/2000, Oracle 8i, Oracle Developer, MS Access.