Hyperion Consultant Resume
Richmond, VA
SUMMARY
- Over 7 years of IT experience as a Hyperion Techno Functional Consultant/Developer. Experience in gathering requirements, developing and implementing Oracle Enterprise Performance Management using Oracle Hyperion Essbase/Planning, Hyperion Financial Management, Data Integration Management, Financial Data Management (FDM, FDMEE), Hyperion Financial Reporting, Interactive Reporting
- Experience implementing various Hyperion modules such as Hyperion Essbase, Planning, HFM, Interactive Reporting, Financial Reporting and migration of Hyperion Planning, Hyperion Essbase, Hyperion Financial Management application between various environment using LCM
- Extensive experience in Planning, analysis, design, implementation, testing, quality assurance and administration in a client - server environment with expertise in developing business applications in Relational (RDBMS) and Multi-Dimensional (MDBMS) Databases.
- Experienced in maintaining the Multi-Dimensional Databases using OLAP server for Hyperion Essbase … Hyperion Planning, HFM, FDM, DRM, ODI, Hyperion Financial Reports, MaxL, Essbase Spreadsheet, SmartView, Hyperion Suite
- Experience in creating hierarchies in Oracle Data Relation Management (DRM) and integrating ODI mappings with Oracle Data Relationship Management (DRM) web services to support meta-data management approach to maintain hierarchies among various Hyperion application including Essbase/Planning and Hyperion Financial Management
- Experiences on Essbase Cube Optimization, performance tuning of Essbase cube, Daily data backups, data/metadata processing, Data validation, testing and migration across different environments.
- Experienced in installation and configuration of Hyperion EPM 11.1.2 version on windows/Unix environments.
- Extensively worked on disparate data sources such as RDBMS, (Teradata, Oracle, sql server) SAP, flat file (.csv, .txt)
- Extensive experience developing member formulas on dimension members, order of calculations in terms of dense and sparse dimensions in BSO, and solve order in ASO.
- Expertise in creating automator for GlobalOne and Webform request for various applications
- Extensive Knowledge of PL/SQL, SQL query to retrieve, manipulate, and control data by creating efficient queries, functions, procedures, packages, and triggers.
- Extensive experience in maintaining metadata and data loads in Hyperion Essbase/Planning and HFM applications
- Extensive experience in administering Hyperion applications and application servers and security
- Extensive experience on the installation and configuration of Hyperion products Suite on both Windows and UNIX environments
- Skilled in Automation, Optimization and Performance Tuning of Essbase application data/metadata processing, upgrading, testing, managing database settings, manage Essbase Cache settings, optimizations and migrating of cubes in different environment
- Experienced in troubleshooting system issues and working with Oracle Support to solve the issues if needed
- Strong experience in interacting effectively with business stakeholders and technical teams at all levels of the organization
- Experienced working on offshore/ onsite model
- Versatile team player with excellent analytical, presentation, written and verbal communication skills and interpersonal skills with an aptitude to learn new technologies
- Solid time management and multitasking skills, which help in conducting project meetings, reviews, walkthroughs, and customer interviews and user trainings as required.
TECHNICAL SKILLS
Operating Systems: Windows XP, Window 2000, MS-Dos, OS/400, UNIX,MVS
Languages& Software: EJB 1x, 2.0, Java script, C, COBOL 400, RPG 400, CL 400, SQL, J2EE, Applets, Servlets, HTML
Domains: Oriented Retail, Manufacture, Healthcare, Banking, Financial
ERP: SAP, People soft, Oracle Financials
ETL Tools: Informatica, Data Stage, ODI
Middleware: Web Logic, IBM's Web Sphere, Java Web Server, ODI
Others: MS Project, Visio, MS Office, MS Excel
BI Tools: Hyperion planning … Essbase … Oracle Business Intelligence suite 10/11g Financial Reporting, Hyperion interactive reporting (BRIO) … Brio Insight, Brio Server 11.x/9.x/6.x,Brio Explorer, Hyperion SQR production reporting 11.x/9.x, Hyperion strategic finance(HSF) Hyperion financial management 4.x/9.x,Smart View, Essbase Administration services, Hyperion Data Relation management (DRM), Hyperion workspace, Hyperion shared services, Hyperion web Analyzer 9.x,7.x/6.x/5.x, Hyperion Reports 9.x/7.x/2.x, Excel Add- in, Essbase Studio, Hyperion Visual Explorer.
Tools: Hyperion Planning, Hyperion Essbase, Hyperion Workspace, Hyperion DRM, Smart View, Excel Add in, Toad
PROFESSIONAL EXPERIENCE
Confidential, Richmond, VA
Hyperion Consultant
Responsibilities:
- Involved in gathering requirements, developing and supporting Hyperion ESSBASE (ASO/BSO) and Hyperion planning application.
- Involved in development of two BSO cubes for corporate planning and forecasting, Developed ESSBASE outlines as per business requirements.
- Involved in development of ASO cube for analysis and reporting of data.
- Involved in design and development of complex ESSBASE applications with excellent balance of Dense and Sparse dimensions (hourglass model).
- Involved in creating batch files using MAXL and rules files for metadata, data loads and launching calculation scripts (BSO cubes).
- Involved in creating views to load data by using SQL developer.
- Involved in developing applications using Hyperion Planning and developed web forms for various planning scenarios.
- Involved in assigning security access to Users, Groups, dimension members and web forms through Hyperion Planning.
- Involved in creating security user groups, providing access to the users by using shared services.
- Involved in maintaining security access in Shared Services.
- Involved in creating reports by using Web Analysis.
- Designed smart view templates for supporting users. Involved in creating static and dynamic reports using Hyperion Financial reporting (HFR).
- Involved in developing cash flow, balance sheet and other financial statement reports using HFR.
- Involved in ESSBASE outline maintenance and data validation.
- Involved in providing Hyperion technical support and resolved issues related to data and security.
- Involved in optimization of data loads and calculation scripts based on specification s of systems to reduce runtime.
- Automated the scheduled process on each Business days for the data flow between BSO and ASO cubes in Control-m
- Assisted application development team in defining and documenting configuration management processes and procedures for maintaining various Hyperion applications including Essbase/Planning, HFM
- Experienced in managing HFM metadata structure from existing hierarchies and writing rules to replicate account movements
- Lead the team in automating the metadata job, data load jobs, defining the dependency and worked closely with Control- M team to schedule the jobs
- Worked closely with DRM team, EDW team, Informatica team, and Control-M team to understand behind the scene process for smooth execution of metadata and data flowing from various sources during month end cycle.
- Developed and maintained Hyperion PBCS security
- Worked closely with EPM team, business team to Implement planning application and providing support to users post implementation
- Worked closely with business users during UAT and help BA during the user training session.
Environment: Hyperion Planning and Budgeting Cloud Services (PBCS) 17.01.27 and 17.02.75, Hyperion Essbase 11.1.2, Hyperion FDMEE 17.01.27 and 17.02.75, Hyperion Data Relationship Management, Hyperion Financial Management 11.1.2, Oracle Hyperion workspace 11.1.2, Hyperion smart view 11.1.2.5.6 , BMC Control-M, Informatica, Jira, Teradata, Oracle 10g, Unix, Windows
Confidential, Sunnyvale, CA
Hyperion Consultant
Responsibilities:
- Responsible for in design and developing Hyperion planning 11.1.1.3 and Essabase.
- Involved in Outline creation and data modeling.
- Involved in Building ASO reporting cubes Store, Dynamic and Multi hierarchy techniques.
- Designed and developed the web based data forms to facilitate the data entry with in Hyperion planning.
- Involved in Assigning secured access to Essbase, Planning, Reporting and Analysis in shared services.
- Responsible for Metadata changes and updates in Outline and Planning.
- Involved in creating metadata file to load the metadata as dimensions.
- Involved in creating Hyperion planning application to handle multiple currencies.
- Involved in Design and develop web based data forms to facilitate the data entry with in Hyperion planning.
- Involved in developing Business rules, currency conversion scripts and assign them to data forms bases on the requirement.
- Involved in controlling data forms access by creating users and groups in both native and external directories through shared services.
- Involved in develop and schedule reports using batch scheduler.
- Involved in exporting data based on UDA groups and Attribute dimension members.
- Involved in developing dashboards with multiple frames using Interactive reporting (IR) on relation database and publish them in Hyperion Planning.
- Involved in developing automation process using MaxL script.
- Responsible for Monitoring error email, Batch jobs scheduling, enabling and running them in the production support environment.
- Involved in Optimization and Performance Tuning of Outline/Data Loads/Calc Scripts
- Worked on developing and maintaining Hyperion system, server and applications using various monitoring process including Accelatis
- Standardized automation process using MAXL, BATCH, FDM and DOS scripts
- Worked on developing and updating new and existing security groups and provisioning roles as per the business needs
- Created and maintained new and existing automation scripts (.bat) for loading data
- Worked closely with business user in creation of business reports requirements using HFR, SmartView and microstrategy
- Worked closely with users in creation of excel SmartView model for reporting
- Performed as a single point of contact on all production related support and maintenance issues
- 24/7 on call support
- Responsible for maintenance of user security and troubleshooting user access issues as they occur
- Responsible for Backup and Recovery of Hyperion applications. Scheduling daily backups
- Maintenance and Support for Essbase, HFM and FDM, Planning Applications and Other Hyperion Products.
- Documented the necessary steps occurred to migrate applications in the Hyperion Planning, Essbase, HFM and FDM, DRM between Prod, QA, and Dev environments.
- Worked closely with oracle support to troubleshoot technical issues and to resolve service request
- Created Test scripts, Test plan and Test criteria for unit testing and user acceptance testing
- Developed training manual post application implementation.
Environment: Hyperion planning 11.1.2., Essbase 11.1.2, Hyperion Financial Management 11.1.2, Hyperion Financial Data Management 11.1.2, Data Relation Management, Oracle Hyperion workspace 11.1.2, Hyperion smart view, MS Excel Add-in, Informatica, Unix, Windows, Micro strategy, Accelatis, Jira, Netezza, KIDS, PACE, Oracle 10g, Smart Report
Confidential, Miami, FL
Hyperion DRM Consultant
Responsibilities:
- Conducts meetings with Business to under the requirements and how that needs to be implemented in the system
- Involved in adding formula for members across Accounts and DeptID dimension
- Run UNIX search tool for the deletion member to check whether they are used in any Calculation or Report scripts
- Automator preparation for Add/Move/Delete request for various BSO, ASO and Planning cubes
- Involved in preparing the system for QA hierarchy cubes for hierarchy refresh by restoring the PROD otl and data files
- Involved in generating audit reports and difference reports for Accounts and DeptID dimensions for different process
- Run export books for ASO cubes that will push the hierarchy into tables from which cubes will be updated with hierarchy via EIS
- Run export books for BSO cubes that will generate text files (DIM and MESS) for each dimension which will be used to build the cube
- Refresh Planning cubes by generating dimension exports and refresh the cube through workspace
- Validate each request against the cubes to check whether the hierarchy build went through the process correctly
- Co-ordinate with business for data and hierarchy validation and get sign-off for each cube
- Migration of automators from QA and PROD and generate export files from QA and PROD to compare for any differences
- Build PROD hierarchy and validate the dimensions’ structure along with member and alias against QA
- Verify all the security filters in cubes to check for any errors due to the deletion of members that can be used in the filters
Environment: Hyperion DRM, Hyperion Planning 11.1.1.3, Hyperion Essbase 11.1.1.3, EAS 11.1.1.3, EIS, Hyperion Workspace, Excel Add-In, Oracle9i and Smart View.
Confidential
Hyperion Essbase Developer
Responsibilities:
- Obtained a detailed knowledge of the business process being followed in the project environment
- Extracted the business requirements from the end users keeping in mind their need for the application and prepared business requirement document as per the requirements.
- Involved in the day-to-day implementation of the Rational Unified Process (RUP) methodology of application development with its various workflows, artifacts and activities
- Involved in backing up the Essbase application on daily basis and restored the Essbase application whenever required.
- Developed Load rules for Dimension build and Rules File for loading the data from Oracle GL into Hyperion Cube.
- Developed Calc Scripts for aggregating the data based on the business requirements.
- Involved in optimization and tuning of the Essbase application to bring down the calc time.
- Automated the monthly loading process using Maxl Scripts.
- Resolved many technical and functional issues and ensured the smooth process flow during monthly and quarterly close.
- Developed reports required for the business needs using Hyperion Reports and Hyperion Analyzer (ad-hoc).
- As a part of team, involved in the installation and configuration of Hyperion Essbase (7.X) on VMware environment to test the application.
- Used Web sphere application server for installing and configuring the Planning Web applications.
- Developed Business rules to facilitate the users to aggregate data based on user inputs.
- Developed Web forms using Hyperion Planning for various planning scenarios.
- Involved in validating the web forms for the OTC users on the consolidation cube.
- Created users, user groups in the Planning application for accessing the various application elements.
Environment: Hyperion ESSBASE 6.5.4/7.1.5/9 , Hyperion Planning 3.5.1, Hyperion Application Link (HAL), Hyperion Reports 7.0, Hyperion Analyzer 7.0, People Soft, Hyperion Essbase Spreadsheet Add-In, PL/SQL and Oracle 8i, Web Sphere 5.0, Windows 2003, Unix (Solaris), Korn Shell Scripting, IBM AIX 5.2.