OBJECTIVE

• To utilize my software development skills in any organization dat will provide continuous opportunities for growth and advancement.

SUMMARY

• Over nine years of experience in Data Ware House, analysis, architecture, development, implementation, reporting, and migration of various applications in client/server environment using Hyperion Essbase, Hyperion Planning(Workforce, Capex) Hyperion Financial Management, Shared Services, Essbase Integration Services, Hyperion Interactive reporting, DRM, Essbase Spread Sheet Add - in, Hyperion Intelligence(Web Client) under Windows and UNIX environments.
• Proficiency in Oracle Hyperion Data Relationship Management (DRM) solutions.
• Expertise in using DRM for managing users, properties, verifications and validations, managing system categories, node types, migrating DRM metadata, working wif formulas and transaction requests.
• Experienced Hyperion System 11.1/9.3 modules (Hyperion System 11.1/9 BI+ Analytic Services, Hyperion System 11.1/9 Planning, Interactive Reporting, Financial Reporting, Production Reporting and Dashboards).
• Strong Multidimensional Database design skills, development and business intelligence modeling capabilities.
• Experienced in interacting wif business users Confidential various levels and converting their requirements into technical specifications.
• Experience working wif intercompany eliminations wif consolidations in Hyperion and oracle and wif foreign subsidiaries.
• Performed Dense/Sparse settings, Optimization of Data load and Optimization of Calculation scripts and Business Rules.
• Expert level noledge and understanding of ESSCMD and MAXL scripts used for automation and partitioning.
• Experienced in working wif Aggregate Storage Outline (ASO) and Block Storage Outline (BSO).

TECHNICAL SKILLS

OLAP TOOLS: Hyperion System 11.1/9 BI+ Analytic Services 11.1/9.3, Hyperion Financial Management 11.1/9x, Hyperion Essbase 11.1./9.3, Hyperion Planning System( WorkForce and Capex) 11.1/9.3/9.2 , Hyperion Planning 11.1/9.3,Hyperion DRM 9.3/11.1.2, Hyperion Workspace 11.1/9.3

REPORTING TOOLS: Hyperion Financial Reporting release 11.1/9.3, Sales Reporting, Hyperion Interactive Reporting release11.1/ 9.3, Hyperion Production Reporting release 11.1/9.3, DRM, Hyperion SmartView 11.1/9.3, Budgeting, Forecasting, Planning

DATABASES: Oracle 12.1 & 11.5.10, 10g/9.x.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Oracle Hyperion Consultant

Responsibilities:

• Involved in extracting dimensions from Current essbase and Planning applications.
• Created the properties, categories, exports for all the metadata in DRM.
• Loaded the metadata extracted from essbase and planning dimensions in to DRM.
• Automated the load of the new profit centers, cost centers from SAP in to DRM.
• Created tables using SQL and loaded the metadata in to tables.
• Created ODI interfaces for loading the metadata from DRM in to Essbase.
• Created ODI packages for each planning application.
• Loaded the data in to Essbase and Planning applications using FDMEE and did the data tieouts.

Environment: DRM, ODI, SAP, Essbase and Planning.

Confidential, Houston, TX

Oracle Hyperion Architect

Responsibilities:

• Gatheird the requirements from business and did set up system dat matches the requirements
• Gatheird the functional requirements of the projects and created BRD's for diff projects
• Created hierarchies in DRM.
• Created properties and property categories dat match the naming conventions of target systems.
• Mapped the correct in and out nodes to the correct parent nodes wif different mapping combinations.
• Created validations in DRM
• Created exports and import profile
• Created blend profiles and ad hoc queries both user and standard too in DRM.
• Applied DRM patches on all the environments too.
• Created .BAT and .CFG files for the batch processing.
• Scheduled the jobs in windows and other enterprise job schedulers for automation.
• Involved in building API’S for workflow using Java script.
• Customized the Java packages in the API’S for data integration across environments.
• Designed the upgrade flow from 11.1.1.2 to 11.1.2.2.307
• Involved in configuration of Data Relationship Governance (DRG).
• Trained users across Data Relationship governance (DRG) and its uses.
• Monitored the governance activities and supported the entire governance system.
• Worked on SVNR (Version control tool).

Environment: Oracle Hyperion DRM, DRG, SQL.

Confidential, Atlanta, GA

Oracle Hyperion Architect

Responsibilities:

• Configured the DRM system.
• Gatheird the requirements for integration of DRM wif each down stream system.
• Created properties dat support the feed in to DRM and in to target application.
• Created exports in DRM dat will help to push data.
• Created batches dat will kick load in to DRM and out of DRM automatically.
• Created batch and real time validations for restricting the users to make unwanted changes.
• Created test plans for users.
• Trained users for making data governance activities in DRM.
• Documented all the technical details for the projects.
• Created .BAT and .CFG files for the batch processing.
• Scheduled the jobs in windows and other enterprise job schedulers for automation.
• Used local third party version controlling tools to maintain code.

Environment: Oracle Hyperion DRM, Hyperion Planning, People soft, ESB, HFM

Confidential, Raleigh, NC

Oracle Hyperion DRM Consultant

Responsibilities:

• Gatheird the business requirements for integrating wif SAP.
• Took the old BB&T system, centers, created new roll point for each center.
• Integrated the Hyperion DRM wif Planning.
• Created planning properties in DRM.
• Integrated DRM wif SAP-BW and SAP-ECC.
• Created target header for SAP-BW and SAP-ECC in DRM.
• Created table in DRM for each business line.
• Automated the change data capture in DRM through a VB script.
• Created .BAT and .CFG files for the batch processing.
• Scheduled the jobs in windows and other enterprise job schedulers for automation.
• Automated the data in and out of DRM through windows scripting.
• Created user training documents and trained users.
• Mentored the offshore team lead them for a successful integration.

Environment: Oracle Hyperion DRM 11.1.1, SAP-BW, SAP-ECC, Hyperion Planning.

Confidential, Houston, TX

Oracle Hyperion Architect

Responsibilities:

• Involved in the configuration of the new Hyperion DRM system.
• Gave different business streams demo of DRM and its technical abilities.
• Gatheird the requirements from business and did set up system dat matches the requirements
• Gatheird the functional requirements of the projects and created BRD's for diff projects
• Created hierarchies in DRM.
• Created properties and property categories dat match the naming conventions of target systems.
• Mapped the correct in and out nodes to the correct parent nodes wif different mapping combinations.
• Created validations in DRM
• Created exports and import profile
• Created blend profiles and ad hoc queries both user and standard too in DRM.
• Created unit and system test cases
• Created migration documents
• Created batches to schedule the exports
• Verified the data migrations across environments.
• Applied DRM patches on all the environments too.
• Created .BAT and .CFG files for the batch processing.
• Scheduled the jobs in windows and other enterprise job schedulers for automation.
• Involved in building API’S for workflow using Java script.
• Customized the Java packages in the API’S for data integration across environments.
• Designed the upgrade flow from 11.1.1.2 to 11.1.2.2.307
• Trained users across Data Relationship governance and its uses.

Environment: Oracle Hyperion DRM, DRG, SQL.

Confidential, Decatur, IL

Oracle Hyperion DRM Consultant

Responsibilities:

• Implemented the new DRM system.
• Configured the system dat would suite the need of the client.
• Did vigorous functional and functional testing on the DRM.
• Involved in sessions wif 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 wif the client.
• Created Derived and defined Property definitions.
• Created the import profile, blender profile.
• 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.
• Loaded the imported data in to the FDM tables.
• Created the generation exports.
• Combined the exports to create book and load in to destination systems.
• Exported the data in to the EPMA.
• Integrated the DRM wif HFM through EPMA.
• Created the .ads file and loaded in to HFM through EPMA.
• Did create windows batch file for scheduling.
• Created configuration files and .cmd files for loads in and out of DRM automatically.
• Mapped the exports to the schemas.
• Used SVN and Rosetta version control tools.

Environment: Hyperion DRM 11.1.2.103 , HFM.

Confidential, Cincinnati OH

Oracle Hyperion Consultant

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.
• Gatheird 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 dat club multiple properties from Feed systems.
• Created Sort by property for the Sorting order to be in control.
• Created control system dat 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 wif Property categories for populating property categories.
• Integrated the DRM wif Essbase and planning.
• Created calculation scripts and member formulas for Essbase consolidatons as per requirements.
• Worked on security of Essbase and planning.
• Created exports for each integration.
• Created import and blend profiles.
• Created validations to support the hierarchy and restricting the users.
• Created Out of the box reports.
• Created the batch jobs to flow data in to integrations.
• Automated the data flow.
• Created the VB and windows script for API's.

Environment: DRM 11.1.2.1, Essbase, Planning, SQL and OFSAA.

Confidential, Sunnyvale CA

Oracle Hyperion DRM Developer

Responsibilities:

• Created templates for creating import profiles in DRM for data loading.
• Gatheird the requirements from the business.
• Creating the DRAFT and BRD’S by having sessions wif 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 wif 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 dat 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 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 batch files to create exports, incremental too.
• Created .CMD and .CFG files for the batch files to call.
• Created .BAT and .CFG files for the batch processing.
• Scheduled the jobs in windows and other enterprise job schedulers for automation.
• 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 wif incremental loads.
• Created cross functional team user manuals for users to understand the DRM and its functional aspects.
• Involved in upgrade project of DRM from 9.3. .1.2
• Took the backup of all the DRM hierarchies using utility XML for upgrade project.
• Installed the 11.1.2 and migrated the 9.3.2 code to 11.1.2.
• Did all the check to verify the data migration across patches.

Environment: DRM 9.3.2/11.1.2 , Oracle.

Confidential, Washington DC

Hyperion Consultant

RESPONSIBILITIES:

• Created applications and migrated from previous environment too.
• Created calculations scripts, batch scripts using MDX and ESSCMD.
• Involved in the automation process for data load, tuning, backups and adhoc reports too.
• Created ASO and BSO cubes.
• Created ASO from BSO.
• Involved in installation of Hyperion on a new environment and applied all patches.
• Created the user training documentation.
• Trained end users.
• Tested the system and fixed all the defects picked by users.
• Modified the system as per defects.
• Worked Extensively on HP quality center.
• Developed batch scripts for automating the dynamic dim builds and data loads.
• Analyzed user requirements and involved in the process of finalizing dimensions for cubes.
• Optimized dense and sparse database settings for improving retrieval times.

Environment: Hyperion System 9.3.2, HP Quality center.

Confidential, Alpharetta, GA

Hyperion Consultant

RESPONSIBILITIES:

• Involved in installing DRM system on a windows based environment.
• Accessed wif business and made them realize the importance of DRM.
• Created a demo Hierarchy and compromised the business and super users over usage of DRM.
• Gatheird requirements for creating brand new Hierarchies in DRM.
• Involved in gathering requirements for user grouping and for building and redesigning exports in DRM.
• Created version and Hierarchies in DRM.
• Loaded the data by Automator and also by creating import profile in DRM.
• Created properties and categories in DRM.
• Built the logic for the hierarchies in DRM.
• Configure the applications so the users could see all the metadata Confidential loci in DRM.
• Created both Read only hierarchies wif no export profiles and also hierarchies wif export profiles in DRM.
• Done incremental loads in DRM.
• Worked on security in DRM.
• Scheduled tasks in DRM using windows scheduler.
• Created logic for incremental loads in DRM.
• Created a release document for deploying the hierarchy in DRM production environment.
• Assisted in developing other hierarchies 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 wifout any IT support.
• 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.
• Created properties to export the incremental changes in DRM based on period intervals.
• Created applications and migrated from previous environment too.
• Created calculations scripts, batch scripts using MDX and ESSCMD.
• Involved in the automation process for data load, tuning, backups and adhoc reports too.
• Created ASO and BSO cubes.
• Created ASO from BSO.
• Created, designed and validated business rules in planning, Essbase, HFM through EPMA.
• Implemented Planning(Workforce, Capex) over Essbase to leverage the Cube design activities .
• Created reports using financial reporting and involved in decision making for future fiscal years by forecasting and budgeting.
• Was responsible for performance tuning of Hyperion Planning and HFM applications.

Environment: Hyperion System 11.1.3/9 BI+Analytic Services 11/9.2.0.2, DRM.

Confidential

Essbase Developer/Analyst

RESPONSIBILITIES:

• Designed, developed, and implemented Expense Planning and Reporting System for the Financial Department Confidential Target Corporation using Essbase for better decision-making by Top Management.
• Involved in the requirements and design documents wif business users.
• Build and maintained two new Essbase cubes, one for toshiba’s international markets and the other one for its domestic markets.
• Involved in dynamic dimension building and modifying outlines.
• Implemented Planning over Essbase to leverage the Cube design activities.
• Developed batch scripts for automating the dynamic dim builds and data loads.
• Analyzed user requirements and involved in the process of finalizing dimensions for cubes.
• Optimized dense and sparse database settings for improving retrieval times.
• Migrated Block Storage (BSO) databases to Aggregate Storage (ASO) using migration wizard.
• Used Essbase administrative activities such as creating filters, assigning users and groups to the filters and maintaining Essbase Servers.
• Involved in defining requirements, functional specifications, designing documentations and testing strategies.

Environment: Hyperion Essbase 6.5/7x, Essbase Administration Services 6.2, Hyperion Analyzer 6.2, Hyperion Reports 7.2, Hyperion Brio, Essbase Integration Services 6.2.