Oracle Hyperion Consultant Resume
Houston, TX
OBJECTIVE
- To utilize my software development skills in any organization that 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 with 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 with business users Confidential various levels and converting their requirements into technical specifications.
- Experience working with intercompany eliminations with consolidations in Hyperion and oracle and with foreign subsidiaries.
- Performed Dense/Sparse settings, Optimization of Data load and Optimization of Calculation scripts and Business Rules.
- Expert level knowledge and understanding of ESSCMD and MAXL scripts used for automation and partitioning.
- Experienced in working with 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:
- Gathered the requirements from business and did set up system that matches the requirements
- Gathered the functional requirements of the projects and created BRD's for diff projects
- Created hierarchies in DRM.
- Created properties and property categories that match the naming conventions of target systems.
- Mapped the correct in and out nodes to the correct parent nodes with 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.
- Gathered the requirements for integration of DRM with each down stream system.
- Created properties that support the feed in to DRM and in to target application.
- Created exports in DRM that will help to push data.
- Created batches that 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:
- Gathered the business requirements for integrating with SAP.
- Took the old BB&T system, centers, created new roll point for each center.
- Integrated the Hyperion DRM with Planning.
- Created planning properties in DRM.
- Integrated DRM with 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.
- Gathered the requirements from business and did set up system that matches the requirements
- Gathered the functional requirements of the projects and created BRD's for diff projects
- Created hierarchies in DRM.
- Created properties and property categories that match the naming conventions of target systems.
- Mapped the correct in and out nodes to the correct parent nodes with 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 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.
- 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 with 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.
- 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.
- Integrated the DRM with 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.
- 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 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 with 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 with business and made them realize the importance of DRM.
- Created a demo Hierarchy and compromised the business and super users over usage of DRM.
- Gathered 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 with no export profiles and also hierarchies with 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 without 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 with 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.