SUMMARY:

• Over 9+ years of experience in IT industry with applied knowledge of planning, analysis, design implementation, testing, and administration in a client - server environment with proficiency in developing business applications using Relational and Multi-dimensional Databases.
• Oracle Hyperion Essbase and Hyperion Financial Management Certified consultant having good experience in developing, managing, and maintaining Multi-dimensional databases in an OLAP server environment for Hyperion Essbase, Hyperion Planning, Hyperion Financial Management, Hyperion Financial Data Management, Hyperion Strategic Finance, Data Relationship Management as well as data retrieval and reporting using MS Excel Add-in, Hyperion Financial Reports, Smartview and Web Analysis.
• Experience in handling Multi Client support model, supporting multiple Hyperion components starting from System 9.x to 11.1.2.3. Working is a Leverage Model and currently supporting various US Clients with their Infrastructure (installations, configurations and performance tuning) & Application Support along with Disaster Recovery.
• Involved in Implementation of Oracle Hyperion Essase, planning, Essbase administration services on Oracle Exalytics servers in version 11.1.2.3.
• Involved in planning and implementation of Oracle Hyperion versions 11.1.1.3, 11.1.2.2 and 11,1,2,3 for HFM, FDM, DRM, Essbase, Planning, HSF, FR, Smart view, DRM and DRM web-service Manger.
• Involved in Upgrading Hyperion applications from 9.3.1 to 11.1.1.3, 11.1.2.1 to 11.1.2.2 and 11.1.1.3 to 11.1.2.3
• Expertise in end-to-end implementation, migration, production support, installation and configuration, development and support of various projects; including designing, development, coding, and implementation of software applications.
• Experience in Migration of artifacts between various environments using LCM and various migration utilities. (Application/security migrations)
• Good knowledge in designing, implementation and building Hyperion environments.
• Skilled in applying Hyperion patches in various Hyperion environments and versions. Experience in handling Hpatch and Opatch on Hyperion servers/clients.
• Involved in applying Hyperion 500 Patch in 11.1.2.3 version
• Experienced in creating/managing/maintaining security for wide range of Hyperion products through Hyperion Shared Services and also have good exposure in managing and configuring MSAD.
• Skilled in implementing of BI workspace Load balancing, Essbase/HFM Clustering and Single sign on.
• Good experience in creating calculations such as implementing formulas on dimension members, dynamic calculations, developing calculation scripts, ESSCMD and HFM application calculations.
• Skilled in Server and application scheduling using automation process like FR batch scheduling and batch scripting and shell scripting.
• Skilled in automation, optimization and performance tuning of Essbase/Planning/Financial Reports/Hyperion Financial Management/Hyperion Financial Data Management/Hyperion Strategic Finance applications data metadata processing, upgrading, testing and migrating cubes in different Hyperion applications.
• Expertise in Hyperion Essbase, Essbase Administration Services, Hyperion Planning, Financial Reporting Studio, Hyperion Reports, ESSCMD, MaxL, MDX, Excel Add - in, Smart view and Hyperion Financial Management.
• Having good knowledge and work experience in application development and support related activities of Hyperion Essbase, Planning, Financial Reporting, Hyperion Financial Management and Financial Data quality Management products.
• Experience with database backups and recovering applications across environments.
• Worked considerably in Business Analysis, Software Development and Project Management with reputed organizations in the domain of Banking, Finance, Telecom, Retail and Media & Entertainment Services.
• Good knowledge and experience of different phases of software development life cycle (SDLC) including analysis, design, development, testing and maintenance.
• Strong communication skills and experience in customer interaction in Requirement gathering.
• Experience in knowledge transfer, preparing technical documentation, the clients.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work / project environment. Excellent communication skills with proficient expression, transmission and interpretation of knowledge and ideas.
• Self-starter with the ability to complete work with minimal supervision.

TECHNICAL SKILLS:

OLAP Tools: HYPERION Modules: Hyperion Version 7.x/9.x/11.x product suite. Foundation Services, Hyperion Essbase, Hyperion Planning, Hyperion Financial Reporting, Hyperion Financial Management, Hyperion Financial Data Management, Hyperion Strategic Finance, Data Relationship Management, Excel Add-in and Smartview, ESSCMD, MaxL, MDX.

Databases: Oracle 9i/8i/10g/11g, SQL Server.

Reporting Tools: Hyperion Financial Reporting Studio, Hyperion Reports, Hyperion

Spreadsheet Add: in, Hyperion System 9 Smart view.

Application Server: IIS, WebLogic, Tomcat WebSphere

MS Applications: MS Office 97/2003/2007/ 2010

Application Scripting: MaxL Scripting, Hyperion Business Rules, Windows batch scripting, shell scripting, VB Scripting.

Operating Systems: Windows 2000/ 2003/2008, Unix, Linux Solaris and Oracle Exalytics.

Programming Languages: C, C++, Java, XML, SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Senior Hyperion Technology Specialist

Responsibilities:

• Involved in an end to end installations, configurations, Application migrations and upgrades using Hyperion Shared Services, Essbase, Planning, FR, Web Analysis, HSF, DRM, HFM, and FDM. (Versions 9.3.1 to 11.1.1.3 and 11.1.1.3 to 11.1.2.3)
• Involved in application Implementation in terms of building applications, providing/managing security, storage and system management, for Hyperion Essbase, Planning and HFM.
• Setting up Hyperion environments which include installation of Hyperion components and upgrading the Hyperion environment.
• Migration of Hyperion applications from one environment to other across different product versions 9.x /11.x.
• Involved in Stabilizing environments by implementing performance tuning techniques and applying necessary patches
• Writing scripts for automating the regular task in windows and Linux servers.
• Supporting Hyperion Essbase, Planning, HFR, Smart View, HFM, FDM, DRM, HSF application.
• Actively participated in Monthly/Quarterly/Yearly Consolidation Process.
• Responsible for day-to-day tasks like process management, running consolidations and validating the data after consolidations.
• Updating Rules as per client requirement
• Providing technical support to end users who have problem in the areas of Hyperion Workspace, Planning, HFM, FDM, Essbase, Hyperion Smart view for office
• Implemented Incident, Problem and Change management processes as per SLA agreement and as per the contract.
• Created Knowledge base for Installation & configuration and Activity Run Book documentation.
• Involved in design, planning and testing of Disaster Recovery.
• Applied Hyperion patches on all the Hyperion servers as needed across different versions.
• Server maintenance activities including HFM cluster configuration, Essbase clustering and Load Balancing on BI servers to improve the performance of Workspace.
• Troubleshoot all client, server issues across all Hyperion products and all user issues.
• Installation and configuration of Hyperion Suites specifically HFM and FDQM on Windows. Worked on HFM Version 11.1.1.3, 11.1.2.3.
• Managing HFM applications such as Creating Application profiles, Creating Applications, Working with System Messages, Managing System Users, Managing servers and applications, Monitoring Running tasks and Changing Registry settings.
• Loading and Extracting HFM Metadata, Memberlists, Journals, Dataforms and Rulefiles
• Managing Task audit and Data audit reports, extracting security review reports as per client requirement
• Server maintenance activities including HFM cluster configuration.
• Purge HFM logs periodically to improve the performance of HFM applications and managing HFM Timeout settings.
• Perform HFM application copies across and within the environment (Prod, Stage and Dev) using HFM Application copy utility.
• Monitoring HFM application Database tables DATA AUDIT, TASK AUDIT, ERRORLOG tables and Hsvevent viewer logs as a proactive measure and truncate them below the oracle suggested threshold values to achieve better performance.
• Create and run taskflows, troubleshoot taskflow/EA related issues and perform EA extraction.
• Experience on Smart view integration with HFM and designing reports in Financial Reporting
• Troubleshoot issues on Smartview, HFM Client as well as FR studio on server and client machines.
• HFM Version up-gradation from 9.3.1 to 11.1.1.3 and applying HFM client/server patches.
• Managing HFM application security, security classes, maintaining regular backups of security across applications and restored them as needed.
• Experienced in performing HFM Backup and Recovery
• Migration of objects between environments using Life Cycle Management (LCM) and also used Hyperion application utilities of Shared Services, planning and HFM as needed.
• Manage or assist with DBA's of all system RDBMS backups and system backups including the necessary MAXL scripting for Essbase backups.
• Manage monthly Windows and Linux patching on all Hyperion servers as to maintain the server up to date with OS patch levels.
• Manage the technical documentation of Application/Infrastructure Run Book, all fixes, versioning, issues related to suite and Create RCA documents when required.
• SLA Management - Root cause analysis and defining standard operating procedure to improve resolution time/response time.
• Travelled to Houston TX, to take part in Business meetings, Project transition and Version upgrade projects.

Environment: Hyperion (Oracle EPM): Foundation Services, Hyperion Essbase, Hyperion Planning, Hyperion Financial Reporting, Hyperion Financial Management, Hyperion Financial Data Management, Hyperion Strategic Finance, Data Relationship Management, Excel Add-in, Smartview, Windows 2008R2, Unix, Oracle Exalytics, Oracle 10g/11g and Windows 7 Enterprise.

Confidential

Hyperion Administrator

Responsibilities:

• Multi Client support model, supporting multiple Hyperion components starting from System 9 to 11.1.2.3 this is a Leverage Model and currently supporting multiple US Clients with their Infrastructure & Application Support along with Disaster Recovery.
• Involved in planning and Implementation of Oracle Hyperion version 11.1.2.1/2 for HFM, FDM, DRM, Essbase, Planning, FR, DRM API and DRM web-service Manger.
• Involved in Upgrading HFM App Server from 32 to 64 Bit on version 11.1.1.3
• Involved in Upgrading Hyperion 11.1.2.1 to 11.1.2.2
• Involved in design, planning and testing of Disaster Recovery.
• Migration of Hyperion applications from one environment to other across different product versions 9.x /11.x.
• Manage User Directories, Native Directory and users/groups provisioning.
• Involved in design, planning and testing of Disaster Recovery.
• Refreshed/Migrated the security across different environments as per Business needs.
• Prepared test cases. Involved in the System Testing and Unit/Smoke Testing.
• Involved in the UAT of HFM and Planning applications.
• Trained users in Reports, Smartview and UAT Planning and HFM applications.

Environment: Hyperion (Oracle EPM): Foundation Services, Hyperion Essbase, Hyperion Planning, Hyperion Financial Reporting, Hyperion Financial Management, Hyperion Financial Data Management, Hyperion Strategic Finance, Data Relationship Management, Excel Add-in and Smartview, Windows 2003/2008R2, Unix, Oracle 10g/11g and Windows 7 Enterprise.

Confidential

Hyperion Senior Consultant

Responsibilities:

• Designing Interface (inbound and Outbound) to pull Actual data from Apps and export budget data back to Apps.
• Involved in Designing, Building and optimizing the outline and assigning member properties.
• Created Groups and User to provide authentication.
• Created UDA’s, filters, calculation scripts for cube.
• Created planning applications and data forms to allow the end users to enter data as per the budgeting process.
• Created financial reports and scheduled them as per the business needs.
• Made cosmetic changes to the reports as per the Business needs.
• Testing the Production environment thoroughly prior to the applications being created and making them completely functional.
• Performing the Hyperion Admin role in taking charge of maintain servers and make the available all the time except the off hours.
• Maintaining Backups on all the Prod servers and will restore the database if needed as per the Business Request.
• Involved in optimization of ESSBASE Server Settings for best performance.
• Scheduled and automated using ESSCMD.
• Monitoring of the production environment and proactively raising incident tickets for resolution.
• Provided estimates for estimate requests and implemented the changes in time as per the ITSM Process.
• Interact with the business users of the system to better understand the problem ticket
• Maintaining the Weekly Status report and sharing the same with the Onsite team.
• Prepared end to end documentation related to the project which involves preparing Business requirement documents, Functional specification docs, design documents, Test scripts, and created application Run book.
• Reviewing Time report and deliverables of my team members.
• Responsible for 24/7 on call Production support.

Environment: Hyperion System 9, Essbase, Hyperion Planning, Hyperion Financial Reporting, Hyperion Application Link, Excel Add-inns, Smartview, Oracle 9i/10g and Microsoft Windows XP.

Confidential

Hyperion Lead Administrator.

Responsibilities:

• Attended KT sessions at onsite (Warner Bros. Burbank, LA Headquarters).
• Created KT foundation documents and share information across entire team.
• Creating and Modifying Business Rules and Calculation Scripts.
• Creating and Modifying of data forms and reports.
• Created Process Documents, System Design Documents, Security Matrix and User Guides.
• Currently performing the Admin role and supporting Asia pacific, EMEA, USA.
• Clearing the Current Forecast scenario and also archiving the Current Forecast scenario into Forecast month specific scenario.
• Defined and developed Load rules, Functions, Report Scripts to perform cube build and data load.
• Created and executed calculation scripts.
• Design and creation of ASO / BSO cubes for OLAP in Hyperion Essbase.
• Developed ESSCMD scripts for Dimension Build and Data Load processes.
• Developed load rules for loading data files and for dimension build.
• Optimized Data Loads and Calc Scripts.
• Implemented robust data-access security and user management.
• Created various filters as per user requirements in EAS.
• Written Report script to extract the data from Essbase.
• Written Calculation script for manipulating data.
• Managing Backup on daily basis and restored applications when requested by Business.

Environment: Hyperion System 9, Essbase, Hyperion Planning, Hyperion Financial Reporting, Hyperion Application Link, Excel Add-inns. Oracle 9i/10g and Windows 2003.

Confidential, San Jose, CA

Hyperion Essbase and OBIEE Developer

Responsibilities:

• Have worked to build the Analytics repository (metadata) by building the three layers.
• Worked on implementing object and data level security.
• Have implemented drill downs using Dimension Hierarchies.
• Worked on Siebel Answers to build Analytics reports and Dashboards.
• Worked on various views in Analytics reports, namely, table view, pivot table view, narrative view, charts, etc.
• Worked on Deliver to generate the iBots.
• Establish regular contact with onsite team for requirement gathering and requirement enhancement.
• Experience in Client Co-ordination and team handling.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE 10.1.3.3.1 ), Hyperion Essbase 9.3, Informatica 8, Oracle 10g, Windows Server 2003

Confidential, Charlotte, NC

Hyperion Consultant.

Responsibilities:

• Designed, Developed and Implemented numerous Planning applications and Essbase application from transactional data (SAP Fixed Asset, GL, AP and AR) which is now the platform for all the financial reporting and analysis.
• Involved in Installation and Configuration of Hyperion Tools on different environments.
• Responsible for gathering requirements and developing a project plan.
• Involved in installation of Planning, EAS, Workspace, Shared Services, Hyperion Financial Reporting Studio and configuration of these products.
• Participated in outlining requirements and development of a project plan with business personnel.
• Responsible for creating users, groups and filters.
• Involved in making the Essbase backups and restores of Essbase application. Implementedrobust data-access security and user management.
• Performed Optimization using Hour glass design technique, during Data Loads and while calculating.
• Worked on Hyperion system 9 planning to support complex applications for budgeting that are flexible to adapt to changes in the business life cycle.
• Developed Hyperion Business Rules with Run - Time Prompts.
• Worked on various forms using Hyperion Planning.
• Performed Performance tuning by using the dense/spares settings and developed the required alternate rollups for reports.
• Designing Interface (inbound and Outbound) to pull Actual data from Apps and export budget data back to Apps.
• Involved in Designing, Building and optimizing the outline and assigning member properties.
• Designed and created cubes for OLAP in Hyperion Essbase using rules files.
• Involved in modifying calculation scripts as per the business requirements to solve production issues.
• Written reports scripts for exporting of subset of data to flat files.
• Performed various optimization techniques.
• Developed & Maintained Rules File, Calc Scripts and MaxL/ESSCMD Scripts.
• Created Users & Groups in Hyperion System 9 Shared Services and given appropriate access to the users for the cube.
• Involved in creation of Planning Application and Built the Dimensions dynamically through Hyperion Application Link.
• Created Forms in planning Application in a specific format to enter and save the Budget data.
• Managed the entire database from Planning Application.
• Generating various kinds of reports like Annual Balance Sheet Report, Monthly Balance Report, Daily Trial Balance Report, Annual Income Statement, and Monthly Income Statement.
• Involved in writing ESSCMD Scripts to automate the process of Dimension build and data load through running Batch scripts.
• Expertise in managing the Planning Application and Financial reports through Web Analysis.
• Developed various scripts like Date for the reports to run automatically in the specified time period like Monthly, Weekly, and Daily.

Environment: Hyperion System 9.3 BI+, Essbase, Essbase Administration services, Planning and Financial Reports, Hyperion Application Link, Oracle 10g, Windows XP.

Confidential

Essbase Developer

Responsibilities:

• Study the Business Requirement Documents and regularly interact with the Clients to understand their Reports better.
• Involved in the requirements gathering for designing and developing Essbase cubes using Hyperion System 9.
• Created Dimension build rules to create dimensions & Members in the outline. Created Data load rules to load the data into the cube.
• Build members and Childs, siblings, attributes and build the dense and sparse dimensions.
• Involved in writing MAXL Scripts to automate the process of Dimension build and data load.
• Retrieving the data in the Excel-add ins to check whether the data has been loaded correctly or not.
• Involved in modifying calculation scripts as per the business requirements to solve production issues. Written reports scripts for exporting of subset of data to flat files.
• Created Stand alone Essbase applications apart from maintaining Essbase databases
• Created and executed calculation scripts for automation of shipments, actual and forecasting data.
• Involved in installation and Migration of Essbase applications from one environment to other.
• Involved in the Optimization of Hyperion Application.
• Executed performance tuning and optimization of both the data retrieval and data loading scenarios.
• Provided 24/7 on call Production support for Hyperion Applications.

Environment: Hyperion Essbase, Hyperion Web Analysis, Workspace, Excel Add-inns, HFR, Oracle 10g, Windows Server 2003.

Confidential

Hyperion Essbase & Planning Developer.

Responsibilities:

• Involved in designing and creating multidimensional database cubes for financial and analytical business needs.
• Created Data Source Configuration through Hyperion Configuration Utility 9.3 in Hyperion System 9 Foundation.
• Created and registered planning applications in Hyperion System 9 Workspace.
• Created HAL jobs for Dimension build and data loads.
• Worked on creating, comparing and validating Application Views; configuring Application Settings; Deploying Applications and the Deployment Process, Setting Up Exchange Rates.
• Created users, groups, filters and assigned different kinds of Security access to users in Hyperion Planning.
• Involved in Creating Data Forms and Folders and Customizing Data Forms.
• Developed CALC scripts in Essbase; complex Business Rules in planning which involved Building Runtime Prompts and Adding Formulas to Business Rules.
• Worked on creating Sequences which involved Business Rules and Calc Scripts.
• Involved in installation and Migration of Essbase/Planning/Reporting tool set from one environment to other.
• Analyzed Planning Data with Financial Reporting, Created Workforce using Hyperion Planning 3.5.
• Extensively worked on cube optimizing for reducing the calculation time.
• Maintained ASO/BSO cubes in Essbase.
• Involved in designing reports and snapshots using Hyperion Reports/Financial Reporting, Worked on Workspace for administration like Setting Ps and security.
• Involved in periodic back up of metadata and data.
• Involved in all the phases of the project life cycle like Development, Testing (performed UAT) and Production.
• Interacted with the end users in production support, trouble shooting Essbase/planning applications.
• Involved in and documentation of Hyperion Essbase and Planning applications.
• Developed ESSCMD scripts for Dimension Build and Data Load processes.
• Developed load rules for loading data files and for dimension build.
• Optimized Data Loads and Calc Scripts.
• Implemented robust data-access security and user management.
• Created various filters as per user requirements in EAS.
• Automating of cube refresh through MaxL and UNIX scripts.
• Restructured as well as maintained existing Essbase cubes.
• Optimized the applications to bring down the runtime considerably.
• Developed MaxL scripts for generating scheduling daily backup batch process.

Environment: Hyperion Planning System 9.3.1/9.3.0, Hyperion Essbase 9.3.1, Hyperion Application Link (HAL), Hyperion Financial Reporting Studio, Hyperion Workspace, Smart View, Excel Add-in.