PROFESSIONAL SUMMARY:

• 8 plus years of IT experience on large global projects in health care, services, banking, retail and process industries
• 4 years of experience with Hyperion technologies DRM, Essbase, Planning, Financial Reports, SmartView, ODI with latest versions 11.1.2.1,11.1.1.3,9.3.1
• 4 years of hands on experience in Hyperion DRM design, development and integration with Oracle EBS on source side and Hyperion Suite of products on target side
• Strong Experience in implementation of Hyperion Planning & Essbase ASO solutions for finance and analytical operations
• Strong experience in integration and ETL tools ODI for integrations between Hyperion products and relational data sources for moving data and metadata
• Strong experience in automation using Maxl and other scripting languages
• Strong experience in development of reports using Financial Reporting Studio
• Experience in new Hyperion Life Cycle Management(LCM) tool to migrate code and security from one environment to another environment
• Experience in Hyperion Application administration, production support, installation and configuration activities
• Experience in all phases of System Development Life Cycle (SDLC) from investigation of initial requirements through analysis, design, programming, testing documentation and implementation.
• Experience in relational databases Oracle and Microsoft SQL Server database modeling, SQL, PL/SQL DB Tables, Stored Procedures, and Functions etc.
• Excellent communication and interpersonal skills with large global teams

TECHNICAL SKILLS:

Hyperion Tools: Hyperion DRM, Hyperion Planning, Essbase, FinancialReporting Studio, ODI, LCM, EPMA, SmartView

ETL Tools: ODI

Databases: Oracle 11g, SQL Server 2000/2005.

Software Packages: MS - Office 2000/03/07

Other tools: Toad

Programming Languages: MaxL, SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, NC

Hyperion DRM consultant

Responsibilities:

• Gathered functional requirement and based on that Developed of hierarchies, attributes and properties to feed target analytical systems
• Creation of validations and verifications as per the Business needs for validation of data through DRM.
• Development of mappings through DRM.
• Managing and auditing the master data using DRM.
• Development of hierarchies using Action Script, import and blend methods in DRM
• Development of mappings in DRM to map the data between source systems to target systems
• Automation of the hierarchy build and update through DRM Batch Client and Batch files
• Development of automation process
• Development of validations and reports in DRM
• Development of exports
• 24x7 support for syndication schedule to generate and transmit all files to BI, ECC and RDR

Environment: Oracle DRM 11.1.2.2, Windows 2008 servers

Confidential, Bethesda, MD

Hyperion DRM Consultant

Responsibilities:

• Development of hierarchies, attributes and properties to feed target analytical systems
• Creation of validations and verifications as per the Business needs for validation of data through DRM.
• Development of mappings through DRM.
• Managing and auditing the master data using DRM.
• Development of hierarchies using Action Script, import and blend methods in DRM
• Development of integrations between DRM and Peoplesoft GL
• Development of integrations between DRM and Essbase
• Development of mappings in DRM to map the data between source systems to target systems
• Automation of the hierarchy build and update through DRM Batch Client and Batch files
• Development of automation process using Maxl, DOS and shell scripting
• Development of validations and reports in DRM
• Development of exports and audit reports
• Preparation of metadata using macros from excel files and other sources to load into DRM

Environment: Oracle EPM 11.1.2.1 Suite Planning, Essbase, DRM, Peoplesoft GL, Windows 2008 Servers

Confidential, Pittsburgh, PA

Hyperion DRM Consultant

Responsibilities:

• Requirements gathering for the implementation of Hyperion DRM
• Design Document preparation for DRM solution
• Development of hierarchies, attributes and properties to feed target analytical systems
• Creation of validations and verifications as per the Business needs for validation of data through DRM.
• Development of mappings through DRM.
• Installation and configuration DRM on server and client machines
• Managing and auditing the master data using DRM.
• Development of hierarchies using Automator, import and blend methods in DRM
• Development of integrations between DRM and Hyperion Planning and Essbase using ODI
• Development of mappings in DRM to map the data between source systems to target systems
• Automation of the hierarchy build and update through DRM Batch Client (MDM Connect)
• Workflow and Security setup on hierarchies at different levels to allow the approval process
• Was responsible for managing and auditing the master data using DRM.
• Development of Planning and Essbase components and troubleshooting of meta data builds
• Development of Business Rules and calc scripts for various functions
• Administration and enhancements to existing Hyperion Planning and Essbase applications
• Development of automation process using Maxl, DOS and shell scripting
• Development of reports using Financial Reports, Web Analysis, OBIEE
• Development of integration of reports into corporate web portals

Environment: Oracle EPM 11.1.2.1 Suite Planning, Essbase, DRM, ODI, Financial Reports, EPMA, LCM, Windows 2003 Servers

Confidential, Dublin, OH

Hyperion DRM Consultant

Responsibilities:

• Design of metadata, hierarchies, attributes and properties to build HFM and hyperion Planning applications in DRM
• Development of hierarchies for all HFM and Planning dimensions
• Development of properties and attributes in DRM
• Development of DRM Automator, blenders and other components to build the hierarchies
• Development of DRM reports/exports to generate flat files for loading into HFM
• Development of DRM reports/exports to generate flat files for loading Planning using ODI
• Administering the security and other maintenance operations
• Automation of the process using MDM Connect.
• Maintenance and support of the Hyperion Planning applications
• Created Aggregate Storage (ASO) application from the Block Storage (BSO) applications for executive level reporting
• Created financial reports using Prompts, User POV, Grid POV, Conditional Suppression and Conditional Formatting
• Developed Reports to compare against different months & years, entities and scenarios using SmartView
• Provided user Documentation, Training and Production support as part of the Implementation
• 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
• Configured ODI agent and leveraged Knowledge Modules to define workflow and task automation

Environment: Hyperion Essbase 11.1.1.3, Hyperion Planning 11.1.1.3, EPMA 11.1.1.3,Oracle Data Integrator (ODI) 10.1.3.4, Hyperion Shared Services 11.1.1.3,Workspace, Hyperion SmartView, Hyperion Financial Reports 11.1.1.3, MS SQL Server 2005, Windows XP

Confidential, New York, NY

Hyperion Developer/Administrator

Responsibilities:

• Development of hierarchies, attributes and properties to feed target analytical systems
• Development of mappings through DRM.
• Maintaining and administering security permissions for users and groups.
• Defining and creating batch scripts for automation in import and export using DRM.
• Worked in coordination with the OBIEE team for the Integration of DRM and OBIEE.
• Installation and configuration of SOA for deploying the DRM request client application.
• Responsible for setting up the properties, properties categories, system preferences and queries in DRM.
• Developed Rules file for Dimension Building and performed Metadata and Data loading
• Developed business rules and 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
• Created financial reports using Prompts, User POV, Grid POV, Conditional Suppression and Conditional Formatting
• Developed Reports to compare against different months & years, entities and scenarios using SmartView
• 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
• Designed Task lists and workflow process for all the Planning applications
• Created Hyperion Security by creating Users, Groups and Filters for Analytic Services and Hyperion Reports in Shared Services
• Created Data Integration interfaces, procedures and projects for loading SQL and File System data into Planning and Essbase using ODI
• Use of Operator GUI within ODI in-order to debug data loading issues and also schedule procedures
• Integrate Shared Services Security with ODI Security for centralized management of security
• Created documentation for the users and provided required training for data entry and reports

Environment: Hyperion Planning 9.3.1, Hyperion DRM(MDM), EPMA, Essbase Administration Services (EAS), Oracle Data Integrator (ODI) 10.1.3.4, Hyperion Shared Services, Hyperion Web Analysis, Hyperion SmartView, Oracle Database 10g, Windows Server 2003, MS Excel 2003

Confidential, Stamford, CT

Hyperion Administrator

Responsibilities:

• Created Budgeting and Forecasting applications using Hyperion Planning for the Finance department
• Identified planning metadata requirements and loaded metadata
• Developed Load Rules to automatically validate the data and feed into Essbase
• Extensively involved in creating web forms and business rules
• Designed reporting and input templates and developed numerous Financial Reports like Profit & Loss Reports, Income statement Reports, Expense Reports & Revenue Reports using Hyperion Financial Reporting
• Created financial reports using Prompts, User POV, Grid POV, Conditional Suppression and Conditional Formatting
• Developed Reports to compare against different months & years, entities and scenarios using SmartView
• Interacted with end users on a regular basis to capture business requirements
• Supported existing cubes, problem identification, resolution and documentation
• Provided user training on data entry and report generation steps

Environment: Hyperion System 9, Hyperion Planning 9.2.0.2, Hyperion Financial Reporting 9.2, Hyperion Shared Services 9.2, Hyperion Smart View, Workspace, Windows NT, Oracle 10g

Confidential, Atlanta, GA

Hyperion Developer/Administrator

Responsibilities:

• Designed, developed and supported financial and management cubes and reports
• Develop Rules file and perform Monthly loading of metadata and data
• Developed and implemented Dimensions and member Attributes
• Involved in budgeting application using Hyperion Planning
• Used Hyperion planning to create Planning Applications with Business rules and data forms
• Uploading metadata to Hyperion planning and data to Essbase
• Developed web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data
• Created financial reports using Prompts, User POV, Grid POV, Conditional Suppression and Conditional Formatting
• Developed Reports to compare against different months & years, entities and scenarios using SmartView

Environment: Hyperion Essbase 7.0.1, Hyperion Reports 7.0.1, Hyperion Planning 3.5.1, ESSCMD, Windows NT 4.0/2000