OBJECTIVE:

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

PROFESSIONAL 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 Confidential & Confidential 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.2.34 to 11.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 tunin g of Hyperion Planning and HFM applications.

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