SUMMARY

• Over 6 years of IT experience and a proven success record in working with Oracle and Hyperion.
• Experience in installations, upgrades, and configuration procedures in client/server environments.
• Strong Experience in application designing and development using Hyperion Essbase 11.1.2.1/11.1.1.3/9.3.1 /7. x/6.x, HFM 11.1.2.1, Hyperion Reports, Hyperion planning applications 11.1.2.1/11.1.1.3/9.3.1 , and Hyperion Analyzer.
• Experienced in upgrade of Financial Data Management (FDM) from 9.3.3 to 11.1.2.1 and Oracle Data Integrator (ODI) from 10 to 11.1.1.5, Hyperion Financial Management (HFM) from 9.3.1 to 11.1.2.1, Essbase and planning installation and upgradation from 9.3.3 to 11.1.2.1.
• Have been working on OBIEE
• Managed and administered the use of numerous Essbase applications and cubes (both block storage and aggregate storage), forms, reports, and books.
• Essbase cube design and partitioning, and optimization of report queries in Microsoft Excel.
• Migrated and supported UAT and Production environments
• Trained and supported End users in UAT.
• Extensive experience in creating, maintaining, and supporting all application objects including outlines, calculation scripts, rules files for dimension builds and data loads, transparent partitions, and security objects through both Essbase Administration Services (EAS) and MaxL scripts; Also involved in automation of these procedures using batch scripts
• Assisted end - users with developing complex reports to meet requirements; Also developed ad-hoc analysis reports as needed
• Demonstrated ability to work as part of a team to analyze complex business requirements and translate them into business intelligence solutions
• Excellent technical, oral, communicational and analytical skills. Admirable interpersonal abilities and an efficient team player.

TECHNICAL SKILLS

OLAP Tools: Hyperion Planning 11(v. 11.1.2.1/11.1.1/3 )/9(v.9.3.1/3), HFM 11(v.11.1.2.1), Hyperion Essbase 11(v. 11.1.2.1/11.1.1/3 )/9(v.9.3.1/3, Essbase Integration Services (EIS), Essbase Administration Services (EAS), Shared Services

Database Systems: Hyperion Essbase 11(v. 11.1.2.1/11.1.1/3 )/9(v.9.3.1/3)/7.x/6.x, SQL Server, Oracle 8i, 9i, 10g, MS Access

Reporting Tools: Excel Add-in, Smartview, Hyperion Web Analyzer, Hyperion Interactive Reporting (IR),Hyperion Financial Reporting (FR)

Scripting Languages: MAXL, ESSCMD, SQL, PL/SQL Scripting

Operating Systems: Windows server 2008/2003/ VISTA /XP/2000/98/95

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Hyperion Administrator

Responsibilities:

• Managed applications on 11.1.2.2
• Managed Essbase, Planning, FR, IR, HFM and FDM applications on 11.1.2.2
• Patch installation for Bugs
• Managed security groups in the shared services
• Configured user directory in Shared services
• Technical troubleshooting and maintenance.
• Coordinating with DBA’s to take backs up
• Installing Required Clients (Excel, Smart view, HFM, FR etc.).
• Maintenance of user security and troubleshooting user access issues.
• Responsible for application Migrations.
• Worked Closely with Hyperion support Development team in fixing the Issues
• Migration of HFM Applications from UAT to Production

Environment: Hyperion Planning system 11.1.2.2 Hyperion Essbase system 11.1.2.2 HFM 11.1.2.2, Hyperion Financial Reporting11.1.2.2, IR11.1.2.2, Workspace, Shared Services, FDM 11.1.2.2 ODI 11, Windows 2008R2, LINUX.

Confidential, Atlanta, GA

Hyperion Administrator

Responsibilities:

• Performed installation and configuration Hyperion11.1.2.1
• Performed Upgrade ofEssbase, Planning, FR, IR, HFM and FDM applications from 9.3.1 to 11.1.2.1
• Patch installation for Bugs
• Performed Installation and configuration ofODI 11.1.1.5
• Performed installed and configured ODI standalone agents.
• Managed security groups in the shared services
• Configureduser directory in Shared services
• Technical troubleshooting and maintenance.
• Trouble shooting Essbase issues
• Coordinating with DBA’s to take backs up
• Running Essbase calculation scripts
• Documenting the processes and installation steps.
• Installing required clients (Excel, Smart view, HFM, FR etc.).
• Maintenance of user security and troubleshooting user access issues.
• Responsible for application migrations.
• Worked closely with Hyperion support Development team in fixing the Issues
• Migration of planning applications from UAT to production.

Environment: Hyperion Planning system 11.1.2.1/9.3.1 , Hyperion Essbase system 11.1.2.1/9.3.1 , HFM 11.1.2.1/9.3.1 , Hyperion Financial Reporting 11.1.2.1/9.3.1 , IR 11.1.2.1/9.3.1 , Workspace, Shared Services, FDM 11.1.2.1/9.3.3 , ODI10/11, Windows 2008R2.

Confidential, Keene, NH

Hyperion Consultant

Responsibilities:

• Involved in requirements gathering, design, development, implementation, production testing, and implementation of Hyperion Planning Applications.
• Translated end user requirements into application design specifications.
• Worked on migration of Hyperion planning applications between the Environments.
• Developing and testing new Essbase applications based on business requirements.
• Perform monthly maintenance on cubes and weekly jobs.
• Support existing applications and perform tuning on Essbase cubes.
• Developed new financial reports and scheduled to run daily and weekly basis.
• Translated and tested some of Hyperion reports into OBIEE reports.
• Update and maintain webform security including business rules.
• Archive Essbase applications and run aggregations.
• Developed excel based regional sales reports for managers.
• Maintain and update load rule files and calc scripts as per new requirements.
• Create filters on applications and assign user groups.
• Worked on HFR reports automation and users security.
• Update and maintain webforms as per business needs.
• Provide quarterly Hyperion Planning users audit report for finance group.
• 24x7 support for Essbase and planning applications.
• Upgraded Hyperion Essbase from 9.3.1 to 11.1.2.2
• Upgraded Hyperion planning applications and FR studio from 9.3.1 to 11.1.2.2
• Created necessary import formats and mappings in ERPI to load data from oracle financials to Hyperion.
• Migrated Hyperion Essbase and Planning artifacts between test and production environments with LCM.
• Migrated Essbase standalone security to 11.1.2.2 shared services and updated user groups according to new rules.
• Install Essbase add-ins and Smart view on client machines and support users with login credentials.
• Train users to familiarize with new system applications.
• Created POV’s for Actuals and Budget data loads through Hyperion Smart View.
• Document everything including production support and system upgrade for further reference.

Environment: Hyperion Planning 11.1.2.2/9.3.1 , Hyperion Essbase 11.1.2.2/9.3.1 , Hyperion Financial Reports, Hyperion Web Analysis, Workspace, Shared Services, ESSCMD, UNIX, Calc manager, Smart View, MaxL, ODI, ERPi, OBIEE, SQL, Windows 2003 server.

Confidential, Dublin, CA

Hyperion Administrator

Responsibilities:

• Involved in requirements gathering, design, development, implementation, production testing, and implementation of Hyperion Planning project.
• Worked on installation, configuration and deployment of Hyperion Foundation services, Hyperion Planning, HFM, FDM
• Experience in Architecture design of Essbase Cubes using Block storage (BSO)
• Worked on Reporting with the help of Hyperion Financial Reporting tool.
• Worked on Hyperion BRIO.
• Performed data loads using FDM.
• Translated end user requirements into application design specifications.
• Worked on installation, configuration and deployment of Oracle Data Integrator.
• Created integration script in FDM to connect to and load data directly from PeopleSoft GL tables, instead of first exporting to a flat file and then loading.
• Logged records with zero balances into a special file for each period, to facilitate audits without hurting performance of FDM and Hyperion Planning data load by including those records.
• Exported applications and securities between environments with the help of Life Cycle Manager Tool (LCM).
• Managed securities and user groups in shared services.
• Designed and created data explorer, journal and intercompany partner matching reports.
• Resolved issues with Hyperion Planning not being able to create applications due to configuration issues, by troubleshooting Shared Services, Works pace, Hyperion Planning and other related DLLs and components.
• Set up SSO script to handle single sign on for FDM from Hyperion Planning, and for drill through from Hyperion Planning to FDM.
• Configured users and access rights in FDM.
• Installed and configured Hyperion Financial Data Management (FDM), including configuring IIS and Windows Server 2003 group policy.
• Set up locations, control tables and import formats, including import scripts for FDM.
• Configured users and access rights in FDM.
• Created maps to handle sign flips for some accounts.
• Created validation report listing major accounts like assets and net profit, and validation rule for checking whether accounts are balanced, in conjunction with validation entity groups to enable automatic consolidation in Hyperion Planning.
• Worked with outline extractor tool to extract dimension outlines for metadata validation.
• Analyzed financial results and prepared trend reports to support business managers make profitable decisions.
• Assist Financial Analysts to load and validate their budget, and prepare Actuals, forecasts, budget, ad-hoc reporting and management reporting by working with the departments’ managers.

Environment: Hyperion Planning system 11, Hyperion Essbase system 11, Workspace, Shared Services, FMD, ODI, Calc Script, ESSCMD, MaxL, SQL, Windows 2003.

Confidential

Essbase Analyst/Essbase Developer

Responsibilities:

• Translated end-user requirements into application design specifications.
• Assured optimal match between cube design and report specifications.
• Develop new Essbase cubes and database objects or update existing ones to meet new business requirements.
• Optimized outline structure, loading and calculations through appropriate dense and sparse settings of dimensions, storage allocations and by dynamic calculations and debugging.
• Optimized cache settings, established user security, managed applications migration, established substitution variables and settings for dynamic time series, asynchronous processing, and editing/validating scripts.
• Developed and designed cubes using Essbase Integration Services.
• Managed system upgrades and client installations based on users requirements.
• Developed Batch files using MaxL, and Rules files to upload data from financial systems Database to Essbase cube.
• Handled performance tuning, weekly back-ups and monthly consolidations of data and automated monthly/quarterly/annual report generation.
• Developed Analyzer OLAP views and sophisticated what-if scenarios for the end users.
• Documented and issued procedures pertaining to Essbase applications.
• Provided business analysts with advice and options on opportunities to leverage the tool and increase usage.

Environment: Hyperion Essbase 9, EAS 9, EIS, Excel Spreadsheet Add-In, Windows 2003.

Confidential

Oracle Developer

Responsibilities:

• Worked extensively on detailed system analysis, design and development of the system lifecycle.
• Designed logical and physical database architecture.
• Worked on Oracle and SQL Server databases.
• Worked on PL/SQL for writing Stored Procedures, Packages, Functions and Database Triggers.
• Developed PL/SQL scripts for back end validation/ updates.
• Developed Manual Test Scripts for unit testing.
• Performed Integration testing simulating a real time production environment.
• Developed reports using SQL* Plus.

Environment: Oracle 9i, Win2003, and PL/SQL.