We provide IT Staff Augmentation Services!

Senior Hyperion Consultant Resume

Santa Clara, CA

SUMMARY:

  • Around 12 years of comprehensive experience in IT. Experienced in Budgeting, Forecasting and Reporting with multidimensional database using Hyperion Essbase, Planning and Financial .
  • Experience in Installation and Configuration, Development of cubes, consolidation of data, creating outlines, updating meta data, Loading data and designing reports using Hyperion tools. knowledge of FDMEE & ODI (Oracle Data Integration) tool version 11.1.1 for integration with Essbase with Oracle Database in the backend.
  • Strong technical and functional expertise in Oracle Hyperion technologies including Essbase, HFM, Essbase, Planning, Workforce and Interactive Reporting.
  • Skillful in upgrades of Oracle Hyperion products, retrieval of data through Excel Add - Inn and Smart view.
  • Technical experience gained in administration of Hyperion performance suit by using shared services for user/group accesses/privileges and application organization.
  • Exceptional skills acquired using Workspace to design Web forms for data inputs, registering applications and retrieving data in real time.
  • Experience with SDLC methodology Agile and Waterfall model.
  • Detailed grasp of Hyperion administration and optimization and performance tuning techniques relating to data loading and calculation.

TECHNICAL SKILLS:

Programming Languages: EssCmd, MAXL, VB

Operating System: Microsoft Windows server, 7, Vista, XP and DOS.

Databases: Oracle, PeopleSoft, EBS, SQL Server 2000/2005

Tools: Oracle Hyperion Essbase, EAS, EPM, HFM, Planning, Shared Services, EIS, Workspace, PBCS, Microsoft Office, Adobe Photoshop, Microsoft Visual Studio, Citrix. IBM WebSphere, Oracle WebLogic.

PROFESSIONAL EXPERIENCE:

Confidential - Santa Clara, CA

Senior Hyperion Consultant

  • Led support team of upto 11 people that included onshore offshore model.
  • Power point presentation of Monthly reports and status update to clients.
  • Scheduled outages and downtown times - for routinge maintenance and patching activities.
  • Excellent with Change Management Process.
  • Did requirement gathering and prepared detailed Design document outlining Goals, Scope, Risks, Architectural & Database Structures and Database Design.
  • Good knowledge and understanding of ETL process involving informatica. Overlooked night processes of extraction of Metadata from sources - People Soft, Ingress and load into Hyperion.
  • Played key role in Performing Disaster Recovery annual testing.
  • Extensive work on Security.
  • Helped Design and Create Reports using FR Studio, Excel Add-in and Smartview.
  • Did extensive code review of the application
  • Extensively reviewed application to improve performance optimization.
  • Did Unit testing of the application.
  • Part of the UAT testing team.

Confidential - Tulsa, OK

Senior Consultant, Hyperion Lead

  • Project Manager for major enhancement projects of R12 and OWB.
  • Observed industry best practices by implementing ITIL processes. Responsible to make changes in PROD environment. Implement and follow Change Management Process.
  • Good knowledge of Service Now - the ticket and job tracking tool. Through Service Now logged User Incidents, Tasks, Service Requests, Enhancements.
  • Power point presentation of Monthly reports and status update to clients.
  • Scheduled outages and downtown times - for routinge maintenance and patching activities.
  • Migration of Hyperion EPMA applications from one environment to another via LCM.
  • Excellent with Change Management Process.
  • Did requirement gathering and prepared detailed Design document outlining Goals, Scope, Risks, Architectural & Database Structures and Database Design.
  • Good knowledge and understanding of ETL process involving FDW like informatica. Overlooked night processes of extraction of Metadata from sources - People Soft, Oracle G/L, and Power Plant and load into Hyperion.
  • Played key role in Performing Disaster Recovery annual testing.
  • Extensive work on Security.
  • Helped Design and Create Reports using FR Studio, Excel Add-in and Smartview.
  • Did extensive code review of the application
  • Extensively reviewed application to improve performance optimization.
  • Did Unit testing of the application.
  • Part of the UAT testing team.
  • Maintained by synchronizing test and prod environments.

Environment: Windows, UNIX, VMware, VBscript, MDX, Oracle DB, JD Edwards, Hyperion Planning, EssbaseHFM, Hyperion Financial Reporting, Smartview, Excel Add-in, EAS, Weblogic, Citrix, TOAD, SQL server database

Confidential

Senior Consultant, Developer & Lead

  • Led support team of more than 20 people that included onshore offshore model.
  • The project involves full life cycle implementation of Hyperion Planning and Budgeting.
  • Responsible to do Business Requirement Gathering documents in direct consultation with the client.
  • Worked with the ERP team to extract metadata and PS source system.
  • Create and deploy the Planning and Budgeting applications
  • Manage metadata by adding and importing dimensions and members.
  • Set up security for users, groups, and members
  • Create and customize forms, menus, and task lists
  • Planning capabilities, Smart View and Planning’s relationship with dimension requirements
  • Create and test forms, reports and ad hoc grids
  • Set up and test business rules, approval process and implementation task lists
  • Create User manuals and train the trainers.
  • Create a Test Plan & Test Cases
  • Prepare a Project Plan
  • Interacting with the Vendor
  • Execute the Test Plan involved in Integration and System Testing
  • Responsible to Unit test and UAT.
  • Involved in Execution of Workshops provided and tested the expected

Hire Now