SUMMARY

• Oracle Hyperion Technical Consultant with 9 years of experience in Hyperion suite of products including Hyperion Essbase, Hyperion Planning, Planning and Budgeting Cloud Service(PBCS), FDMEE, Jython Scripting, ODI, FR Report and Oracle SQL, PL/SQL
• Experience in Project Module Lead, Development, Support and Enhancements projects creating Aggregate storage applications, Block storage applications
• Worked in ODI 11g (Oracle Data Integrator) and strong knowledge in Oracle PLSQL
• Knowledge in FDMEE 11.1.2.4. version Jython scripting
• Experience in conversion of existing VB Scripting to Jython code
• Strong knowledge in automating the process using the maxl, batches and PowerShell scripting
• Working experience in Web Analysis studio, Financial reporting
• Tuning of WebLogic and ODI settings for FDMEE performance
• Worked closely with management, applications development staff and users
• Knowledge in IBM Cognos Disclosure Management (CDM), configured with Hyperion Essbase and HFM applications
• Worked on IBM Cognos Command Center to automate the Essbase data loads, Planning meta data build and scheduling the jobs
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in the work environment
• Interpersonal skills with excellent analytical, problem solving and easily cop up with the changing business needs
• Exploring new features and techniques in PBCS, EPBCS and able to grasp new concepts quickly and efficiently
• Currently working as Hyperion Consultant in LTI and earlier organization was TCS

TECHNICAL SKILLS

Programming Languages: Oracle Hyperion Planning and Budgeting Cloud Services (PBCS), Hyperion Essbase 11.X, Hyperion Planning 11.X, Oracle Data Integrator(ODI), FDMEE Jython Scripting, MaxL, Calc scripts, Hyperion shared services, Web Analysis Studio, Financial Reporting studio, Smart view and Excel add - in

Operating System / ERP Version: Windows XP, Windows 2003 Server, Windows 2008 Server

Tools: / DB / Packages / Framework / ERP Components: IBM Cognos Command Center, HP Quality Center, SQL Developer, Toad, Oracle SQL and PLSQL, Oracle 11g and PowerShell scripting

Hardware Platforms: Intel Series

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Senior Hyperion Consultant

Technology & Tools: Hyperion Essbase, Planning, Oracle Data Integrator, HFM, Hyperion Shared Services 11.1.2.3.500 , Hyperion Smart View, Financial Reporting 11.1.3.500 and MS SQL

Responsibilities:

• Assisting the Team if any complexity is found during the application maintenance process
• Requirement gathering and analysis for changes in system. Using Remedy track all the changes and client approvals for new request
• Interaction with business team to understand the present and proposed solution to analyze the gaps in requirements
• Project estimation and planning.
• Development of various technical standards and ensuring the implementation of the same
• Monitoring the implemented & in-progress projects to ensure adherence to the guidelines defined by the client & LTIL
• Participation in planning of the development project to be undertaken.
• Interaction with Onsite team to validate and clarify requirements for design/development work at offshore.
• Application support for month end, quarter end and year end closing cycles
• Opening Budget and Estimate cycles as per the schedules calendar
• Monitor daily CCC jobs for and handling job failures
• Working on enhancements for as per the business change requirements
• Handling data related issues and working with client to close the incident
• Enhancing the performance of Rendering and Routing Engines
• Code Development activities.
• Modification & Enhancement to code.
• Conduction of Code Review activities.
• Ensuring that the quality of the delivered product is meeting the Microsoft quality and security standards
• Project progress tracking
• Reporting project status to PM and client
• Conducting training to Business users on new Hyperion system
• Reviewing the Technical reference document and Performing unit and integration testing.

Confidential

Senior Hyperion Consultant

Technology & Tools: Essbase, Planning, Financial Data Management Enterprise Edition (FDMEE) 11.1.2.3.500 , HFM Hyperion Shared Services 11.1.2.3.500 , Hyperion Smart View, Financial Reporting 11.1.3.500 and Oracle 11g

Responsibilities:

• Implemented new FDMEE project as data load to Essbase ASO application and HFM application
• Customization of FDMEE application as per client requirement with Jython Coding
• Worked on FDMEE data load performance tuning
• Developed a tool to monitor all Hyperion server’s drivers space monitoring report and automated
• Resolved FDMEE critical data load issues and migration of artifacts issues
• Worked on workspace slowness critical issues in Production environment
• Performed migration of Essbase, Planning, Calculation manager, HFM application and FR Reports across all environments
• Worked on all production applications day to day issues and solution provided to some of the critical applications migration issues
• Written new PowerShell scripting code to generate alerts on DEV, UAT and Productions servers drive space went below the minimum size
• Written PowerShell scripting code generate email alert when DEV, UAT and Productions services are down
• Worked with business users daily for access issues and Essbase security build
• Created Import Format, Location, Period Mapping, Category Mapping for new Essbase ASO application
• Created Data Load Mappings for HFM Application, Import and Exported all Dimensions Mapping
• Implemented Hyperion applications migration strategy across all the environments
• Migrated all Hyperion products from 11.1.2.3.500 to upgraded Hyperion servers 11.1.2.4
• Prepared detailed technical reference document

Confidential

Senior Hyperion Consultant

Technology & Tools:Financial Data Management Enterprise Edition (FDMEE) 11.1.2.4, HFM Hyperion Shared Services 11.1.2.4, Hyperion Smart View, Financial Reporting 11.1.2.4 and Oracle 11g

Responsibilities:

• Customization of FDMEE application as per client requirement with Jython Coding
• Understanding of validation in FDMEE using Jython code
• Understanding of mappings, Data load rules of existing applications
• Experience to troubleshoot and resolve Planning and FDMEE user questions and issues where possible and work with the business
• Experience in conversion of existing VB Scripting to Jython code
• Connected HFM as source in FDMEE and exported HFM data from FDMEE
• Worked with business users daily for HFM functionality testing during the data load through FDMEE
• Created Source and Target Application
• Created Import Format, Location, Period Mapping, Category Mapping
• Created Data Load Mappings for HFM Application, Import and Exported all Dimensions Mapping
• Implemented FDMEE location level security and grant access to the users
• Worked on Essbase and Planning application migration to different servers
• Trained users how to load data through FDMEE
• Prepared detailed technical reference document.

Confidential

Hyperion Consultant

Technology & Tools: Oracle Hyperion Planning and Budgeting Cloud Services (PBCS), Financial Data Management Enterprise Edition (FDMEE), Hyperion Shared Services, Hyperion Smart View, Financial Reporting and Oracle 11g

Responsibilities:

• Loaded Metadata using utility
• Involved in implementation of ASO application
• Created data forms by enabling smart push
• Performed application snapshot migration from Production to Development environment
• Worked on batch script to automate upload data files, run business rule and push the data to reporting cube and sent email notification at each stage and overall completion of job
• Scheduled jobs using EPM automate utility and PBCS Job Scheduler
• Worked on data related issues and pushing staging data to reporting cube issues
• Worked on FR Studio first time setup and login issues
• Worked on batch script automation to modify source format and upload to PBCS before data loads
• Performance testing and automating maintenance activities of PBCS application using EPM Automate.
• Provided training to Business users to work with Simplified interface in PBCS
• Prepared Technical reference document.
• Performed unit and integration testing.

Confidential

Hyperion Associate Consultant

Technology & Tools:Hyperion Essbase, Hyperion Planning, ODI, HFR, Smart View and Web Analysis Studio

Responsibilities:

• Analyze and review business processes
• Responsible for documentation and propose solutions for business areas and documentation of workflows and business analysis findings
• Designing test scripts for assessing suitability of the solution against requirements
• Worked on month end and regular business data load Data Loads dry run in Essbase and planning applications
• Installed ODI client in user’s machines and prepared detailed documentation for Installation and uninstallation of ODI Client
• Created automation of seven days’ backup of Essbase application backup batch script
• Worked on Planning metadata refresh using ODI
• Applied Hyperion 11.1.2.3.500 patch in Development and Staging Windows environment
• Worked on Planning data loading automation part using windows batch scripting, Maxl and VBScript
• Performed production Essbase applications backup and restored in Development and Staging application
• Enhancements in Essbase calculation scripts, meta data update in Hyperion Planning using ODI and Web analysis report and resolution of data discrepancies and other business process related issues
• Created essbase load rule files to load the extracted data from DRM to build essbase dimensions.

Confidential

Team Member

Technology & Tools:Hyperion Essbase & Hyperion Planning 11.1.2.3, ODI, HFR, Smart View 11.1.2.3 and Web Analysis Studio, HP Quality Center

Responsibilities:

• Followed agile methodology in this project
• Attended daily status call and updates regarding tech refresh project
• Analysis of existing functionality in new servers
• Conducted SIT in all the new server for Essbase, Planning, ODI, FR Report, Web Analysis Studio and Windows batch scripts
• Prepared new test cases for existing functionality and conducted system testing
• Recorded SIT test cases issues and updated in HP Quality Center
• Involved in Performance tuning & cache setting
• Metadata loading using ODI
• Involved new systems bug fixing
• Creating batches using Essbase and scheduling them accordingly
• Analyzed new systems and prepared system functional and technical documents

Confidential

Team Member

Technology & Tools:Hyperion Planning 11.X, Hyperion EAS 11.X, Hyperion Essbase 11. X, Business Rules, Hyperion Financial Report Studio 11.x, Windows 2008 server and SQL server/Oracle 10g, Hyperion Shared Services 11.x.

Responsibilities:

• Worked on monitoring daily and monthly data loads jobs in Essbase
• Developed and automated daily backup of Essbase application
• Taking care of day to day configuration, administration and Performance tuning of calculation scripts and daily jobs
• Involved in solving incidents reported by users in Remedy 7 and maintaining Hyperion Production, Development and QA servers.
• Security setup including creating filters, groups
• Creating batches using Essbase and scheduling them accordingly monitoring Essbase calculation scripts and performance tuning
• Prepared a detailed documentation for new changes
• Worked with Oracle support team for Hyperion production issues

Confidential

Team Member

Technology & Tools:Core Java, Struts, Oracle Warehouse Builder, Analytical Workspace Manager, Oracle SQL and PLSQL Oracle 10g, Windows Server 2003

Responsibilities:

• Analyzed the data from GL accounts from bank source system
• Loading the data from source systems to ALM system using OWB (Oracle Warehouse Builder) and data dimensions are maintained in Analytical Workspace Management System (AWM)
• Data analysis before processing the month end year end process
• Prepared customized financial reporting formats as per customer requirement
• Analysis of banking reports and tallying banking financial accounts
• Knowledge in JDeveloper, writing Java MVC program (Structs) and deployment of production applications in WebLogic server
• Strong knowledge on banking functionality and accounting
• Conducted end user trainings Prepared a detailed documentation for new changes
• Worked with Oracle support team for production issues