SUMMARY:

• Hyperion Developer - Oracle EPBCS, OACS, EPRCS, Oracle Hyperion Essbase, Planning, HPCM, Hyperion Financial reports, Essbase Studio, Shared Services, Workspace, Smart View - Strong experience with the design, build, implementation, optimization, automation processing, administration & training of all products. Calculation, report scripts, partitions, load rules, web forms, business rules, Esscmd, MaxL. Unix & Windows environments. Versions 6 - 11.2. Over one-year experience with EPBCS development.
• Financial Analysis - Trend and KPI identification, efficiency analysis. Operational, statistical and fiscal reporting with variance explanation. Report design, packaging and presentation to management.
• Project Management - Technical and business experience in full life cycle projects. Interaction and presentation to all levels of management. Identifying key objectives, scope, risks, drivers, and fostering cooperation between departments to enable success.

TECHNICAL SKILLS:

Domain: Enterprise Business Intelligence and Data Warehousing

Scripting Languages: Perl and PowerShell scripting.

Operating System: Windows Server 2003 & 2008, Linux 6.0.1 and AIX

Tools: / DB / Reporting tool: Oracle EPBCS, OACS, EPRCS, Hyperion Essbase, Planning, HPCM, Essbase Studio, Oracle DB, Finance reporting, Web Analysis reporting

PROFESSIONAL EXPERIENCE:

Confidential

Lead Hyperion Developer

• Hyperion developer developed application in Oracle EPBCS, Oracle Analytical Cloud Services, Enterprise Performance Reporting services.
• Developed EPBCS application and leveraged out of box features and custom plan types based on business need.
• Automated metadata/data load process, security provisioning using Rest API methods in python scripts.
• Hyperion developer developed Essbase, Planning and HPCM application as new requirement for different business in on-premise 11.1.2.4.
• Acted as liaison between the Hyperion and Business groups to translate and developed as per business requirement.
• Responsible for building and managing demo environments in PBCS engagements.
• Responsible for the migration of Hyperion Essbase and Planning from version 11.1.1.3 to 11.1.2.2 and migrate from 11.1.2.2 to 11.1.2.4.
• Developed HPCM application from end to end for three different business segments.
• Responsible for long range planning for the Hyperion environment and its potential impact to help better leverage the available tool sets across the Marsh finance user community.
• Automated several jobs like data load, data extract, metadata refresh, backup using PowerShell and Perl scripts.
• Hyperion technical lead involved in managing, optimizing and troubleshooting day to day activities, end user support, primary focus on new design and optimization of the current environment.
• Responsible for managing the Hyperion Group, its day to day, month end and year end activities, creating and executing the environment’s long-term vision and aligning Hyperion with Marsh FPA road map that supported Budgeting, Planning and Forecasting at a Corporate and BU level.
• This includes developing technical solutions/guidance, troubleshooting issues, process management, detailing future vision and customer support including creating organizational reporting. Lead role in all new design or optimization of the Hyperion environment and projects that encompass several system environments.
• Additional lead roles include environment long range planning, future product testing, training, product upgrades.
• Worked across team to meet the requirement in Hyperion for new development.

Environment: Cloud Planning, Essbase, Financial reporting,11.1.2.x, Planning, Essbase, HPCM, Essbase studio, DRM, Workspace, WA & FR web reports.

Confidential

Lead Hyperion Developer & Administrator

• Primary role was to provide systems development, administration and end user support to the Finance and Marketing departments principally through Essbase databases.
• This encompassed developing/updating/tuning Essbase databases, automated batch scripting, database administration, security, ensuring data integrity.
• Position included project management, translating business user’s requirements into technical specifications.
• Also, conducted training sessions and created end user documents.
• Position focused on enhancing or optimizing existing databases, ad hoc interdepartmental projects and automating processes.
• Position also included the rotating 24-hour support of existing databases and servers.
• Numerous ad hoc projects include server optimization, Essbase server installation/version upgrade, batch automation scripts using Perl/MaxL and leading application design lifecycles or projects as assigned by management.
• Played the role of Incident Manager, responsible for tracking of Virtual tickets from the time it is created till ticket is resolved and closed.
• Involved in the creation of all Essbase components; outlines, calculation scripts, Esscmd scripts, data load rules, server & client installation, data & index cache and other optimization tasks.

Environment: 9.3,11.1.x, Planning, Essbase, WA & FR web reports, Oracle 10g, AIX and Windows 2003.

Confidential

Hyperion Support Administrator

• Essbase server installation/version upgrade from 9.x to 11.1.1.3.
• Migrated the cube from 7 and 9 version to V11. Migrated the users from pre-system 9 to 11.
• Responsible for preparing Security design document and reviewed other technical design documents.
• Application Maintenance activities like log archiving and Scheduled reboot of Windows servers.
• Migration of Development objects from development server to Production server.
• Involved in regular Client interaction/Calls to identify the issues, change requests, enhancements and provided best of technical solutions.
• Trained business analysts on retrieving data from Essbase cubes by using Excel spreadsheet add-in.
• Created custom reports, input templates for users.
• Tested applications to ensure the built application, data conversions and interfaces supported the business processes as designed.
• Transferred knowledge about the built application to end-users after implementation.
• Communicated effectively with client and Hyperion engagement manager.

Environment: 6.x,7.x,9.x,11.1.1.3, Planning, Essbase, WA & FR web reports, Oracle 10g, AIX and Windows 2003.

Confidential

Hyperion Support Administrator

• Managed to provide excellent support to customers in a quick turnaround time. Ensured meeting various SLA like ownership SLA, Resolution SLA etc.
• Involved in configuration of V9.3.1 Shared services, Hyperion Essbase, Hyperion Planning and BI+ environment.
• Worked/Supported with Hyperion applications and reports using Hyperion Essbase, Workspace, Shared Services, Interactive reporting, Financial reporting.
• Involved in regular Client interaction/Calls to identify the issues, change requests, enhancements and provided best of technical solutions.
• Troubleshooting and Writing MaxL/Esscmd scripts for the data load/dimension build process.
• Created Load Rules required for the dimension/data build process. Enhanced the rules files as per the change request.
• Played the role of Incident Manager, responsible for tracking of BMC tickets from the time it is created till ticket is resolved.
• Ensured preparation/verification of proper documentation of any new issues that is uploaded into Project Share Point for future reference.
• Good experience on troubleshooting critical production issues related to Essbase Agent crash & External Authentication using NTLM, MSAD & LDAP, Data load and Calc script performance issue.
• Loaded data on daily basis and Developed the new Business Rules.
• Enhanced the existing data forms and developed new data forms in planning.

Environment: 9.x, Planning, Essbase, WA & FR web reports, Oracle 10g, AIX and Windows 2003.