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