SUMMARY

• 8 years of rich experience in IT including 6 years of experience in design, analysis, development and implementation of various Hyperion applications using Hyperion DRM, Hyperion Essbase, Essbase Administration Services, MaxL, Essbase Excel Add - in, on Windows.
• Specialized in DRM design, development, automation and integration with hands on tool experience in integration with Hyperion products.
• Extensive Experience on Hyperion Data relationship Management (DRM) and created imports, exports, blender and Automator profiles, node types, batch client
• Experience in all stages of Software Development Life Cycle (SDLC) with comprehensive knowledge of business and requirements analysis, Business Process Modeling, Project planning and Creation of use cases as well as user stories
• Experience in gathering client requirements, business needs and project objectives via feedback sessions and client meetings
• Involved in installing DRM system on a windows based environment.
• Accessed with business and made them realize the importance of DRM.
• Gathered requirements for creating brand new Hierarchies in DRM.
• Created version and Hierarchies in DRM.
• Loaded the data by Automator and also by creating import profile in DRM.
• Created and defined and derived attributes for supporting hierarchies in DRM.
• Created export profiles and validations in DRM.
• Created the automation system for exporting the metadata from DRM.
• Trained the users on DRM.
• Extensive experience in designing and developing OLAP cubes from a conceptual level
• Applying quantitative methods to analyze synthesize and interpret information from multiple data sources.
• Capable of managing organization’s data, assess and fulfill its reporting needs and develop powerful solutions that have true impact on the performance of a company
• Managing security, permissions, users and groups, controlling access to database cells through managing filters, filters: creating, copying and assigning filters
• Scheduling loading of metadata/data, and writing scripts to perform loads and calculations for Aggregate Storage(ASO) and Block Storage(BSO) database models
• Extensive involvement in maintenance, automation, backups, Performance tuning and Optimization of Essbase cubes, calc scripts and applications to facilitate effective business decision making
• Support user training, documentation and rollout of new projects
• Versatile team player with Excellent inter-personal and presentation skills

TECHNICAL SKILLS

OLAP and BI Tools: Hyperion Essbase 11.x/9.x, Hyperion DRM 11.1.1.3/11.1.2.1 , Essbase Adminstartion Services (EAS),Hyperion Shared Service, Smart View for Office, MS Excel Add-In

Reporting Tools: Hyperion Financial Reporting (FR), Hyperion SmartView

Office Tools: MS Office Suite 2007/2003/2000

Languages: MaxL, MDX, SQL, PL/SQL

Databases: Oracle 11i/10g/9i/8i, MS SQL Server, MS Access, DB2

Operating Systems: Windows NT/2000 /XP/Server 2003

PROFESSIONAL EXPERIENCE

Confidential, Suwanee, GA

Sr. Hyperion Data Relationship Management Developer

Environment: Hyperion 11.1.2.3, Oracle 12c, Peoplesoft, Windows XP, Windows 7

Responsibilities:

• Entered for implementing the new DRM system.
• Collecting the requirements and configured the system that would suite the need of the client.
• Did vigorous functional testing on the DRM.
• Designed dummy hierarchies, making the managers to know the significance of DRM.
• Documented all the functional and technical requirements.
• Created the hierarchies by using importing and action script.
• Created Derived, Lookup and defined Property definitions.
• Created the blender profile.
• Created node types.
• Created property queries and node quires.
• Assigned node types to the hierarchies.
• Created Exports and out of the box reports in ASCII form. Involved in team work with downstream Essbase members to import metadata into DRM.
• Designed validation and assigned them to appropriate versions and hierarchies to hold the integrity of data
• Scheduled jobs through client by using the new working feature in DRM 11.1.2.3.

Confidential, Edina, MN

Sr. Hyperion Data Relationship Management Developer

Environment: Hyperion 11.1.2.1, SQL, Windows XP, Windows 7

Responsibilities:

• Implemented the new DRM system.
• Configured the system that would suite the need of the client.
• Did vigorous functional and functional testing on the DRM.
• Involved in sessions with the PMO's in making them to understand the importance of DRM.
• Involved in gathering the requirements.
• Documented all the functional and technical requirements.
• Created the hierarchies and showed to the PMO's as part of the DRM importance sessions with the client.
• Created Derived and defined Property definitions.
• Created the import profile, blender profile.
• Loaded the import profile that would create 2 hierarchies with each version at a time.
• Created node types.
• Created property queries.
• Created the node glyphs for identifying the each GL.
• Assigned node types to the hierarchies.
• Created Exports and out of the box reports.
• Did work on batch client.
• Involved in identifying what should be the master data and how it can be handled using DRM
• Created configuration files and .cmd files for loads in and out of DRM automatically.
• Scheduled jobs through client.

Confidential, Shoreview, MN

Sr. Hyperion DRM Consultant

Environment: Hyperion Data Relationship Management (DRM) 11.1.1.3, SQL Windows XP

Responsibilities:

• Involved in the configuration of the new Oracle DRM system.
• Did the functional/performance testing of the new DRM system.
• Gave the VP’s and senior personnel a demo of the DRM which includes its technical and functional aspects.
• Gathered the requirements for developing versions/Hierarchies.
• Developed brand New Hierarchy in DRM by using importing.
• Created derived and defined attributes which are required for the DRM system and for the hierarchy maintenance in DRM.
• Developed exports for the data validation and the maintenance of the metadata.
• Created Property queries.
• Created validations in DRM.
• Created defined properties that club multiple properties from Feed systems.
• Created Sort by property for the Sorting order to be in control.
• Created control system that controls the flow of the export data from the DRM.
• Categorized the exports based on each version by creating books.
• Created node types and associated them with Property categories for populating property categories.
• Created import and blend profiles.
• Created validations to support the hierarchy and restricting the users.
• Created Out of the box reports.

Confidential, Atlanta, GA

Oracle Hyperion DRM Consultant

Environment: Hyperion Data Relationship Management (DRM) 9.3.2/11.1.1.3 , Oracle 9i, SQL Server 2005, Windows Server 2003

Responsibilities:

• Created templates for creating import profiles in DRM for data loading.
• Gathered the requirements from the business.
• Creating the DRAFT and BRD’S by having sessions with business users.
• Setting up the platform for building a brand new Hierarchy.
• Gave the users a demo of the sample Hierarchy including most of the technical requirements.
• Created properties and categories.
• Created node types, validations for the hierarchy.
• Tested the Hierarchy and assisted the QA team in testing the Hierarchy as per requirements.
• Deployed the Hierarchies in different environments using DRM migration utility.
• Created release documents and also user training documents for DRM for Deploying in Production.
• Assisted in moving the DRM application Code to Production.
• Assisted the users in Production in case of issues.
• Worked on security in DRM.
• Scheduled tasks in DRM using windows scheduler.
• Created logic for incremental loads in DRM.
• Created validation and queries for validating the data and also for adhoc reporting in DRM.
• Tested the hierarchies.
• Added properties and updated them with node Types.
• Created Property Queries for Hierarchy exports.
• Involved in developing a brand new Read only hierarchy for the company and her interests throughout the globe in DRM.
• Created derived properties that meet the business requirements and tested them.
• Created properties to export the incremental changes based on period intervals.
• Created defined properties as per the data flow in to the DRM.
• Created Exports both standard and non-standard exports for Reporting and also for loading in to the tables.
• Created template and gave to the analyst for creating the import profile to load as per the requirements.
• Created a release document for deploying the hierarchy in DRM production environment.
• Assisted in deploying hierarchies across production which are ready for release.
• Created XML’s for migrating hierarchies or appropriate properties across environments.
• Created user login guide for users to navigate around the DRM without any IT support.
• Created batch files to create exports, incremental too.
• Created .CMD and .CFG files for the batch files to call.
• Created email alerting system for export generation.
• Created incremental leaf members alert system using automation in DRM.
• Created derived properties in DRM and linked them with incremental loads.
• Created cross functional team user manuals for users to understand the DRM and its functional aspects.
• Involved in creating the test cases for database upgrade.
• Tested the DRM think client and web client after the database upgrade.
• Involved in upgrade project of DRM from 9.3.2 to 11.1.1.3
• Took the backup of all the DRM hierarchies using utility XML for upgrade project.
• Installed the 11.1.1.3 and migrated the 9.3.2 code to 11.1.1.3
• Did all the check to verify the data migration across patches.
• Did the functional testing and performance testing on DRM after the installation.

Confidential, NJ

Hyperion Essbase Consultant

Environment: Hyperion Essbase 9x, Hyperion Financial Reporting 9.2, Hyperion Shared Services 9.2, Hyperion Smart View, Windows NT, Oracle 10g

Responsibilities:

• Designed the multidimensional database and business performance measurement tools to map the financial budgeting process of the company.
• Gathered complex requirements from the users and documented them into appropriate technical specification and business requirements templates.
• Migrating Essbase cubes into newer versions and newer operating systems.
• Involved in analysis, development and enhancement of database (MDDB) outlines.
• Responsible for creating users and groups and providing authorization to them.
• Provided Essbase technical supports to all business units, offered suggestions and proposed solutions to resolve issues.
• Developed OLAP Models and Meta outlines for the cube.
• Created Essbase cube for DFSs financial data related to the cost of processing checks and credit cards.
• Restructured and redesigned previous Essbase cubes.
• Involved in the performance tuning and optimization of data load calc scripts.
• Extensively used MaxL, ESSCMDS for creating batch files for automation.
• Worked in different modules like books, accounts in Hyperion Financial Reporting to generate reports.
• Prepared Profitability Reports, which detail Unit Cost, Price and Volume Trends and Expense Variances over prior periods.
• Prepared quarterly forecasts, annual budget, ad-hoc reporting and management reporting using Hyperion Reports.
• Involved in defining requirements, functional specifications, designing documentations and testing strategies.
• Created Transparent partition to use the functions of BSO cubes along with the existing ASO cube.
• Extensively worked with Shared services in provisioning access permissions to users for Hyperion Essbase & Financial Reporting.
• Performed tuning and optimization of the ASO cubes.
• Responsible for providing training to the end users.