SUMMARY

• 7 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 installation and configuration of 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.
• 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: Oracle Hyperion Essbase 11.x/9.x, Oracle Hyperion Planning 11.x/9.x, Workspace

ETL Tools: Informatica

Reporting Tools: Hyperion Interactive Reporting, Financial Reporting studio, Excel Spread sheet add-in and Hyperion Smart view

Languages: MaxL, MDX, ESSCMD, SQL

Databases: Oracle 10g/9i

Dimensional Modeling: Star-schema Modeling, Snow-Flake Modeling, Fact and Dimension Tables, Physical and Logical data modeling.

Operating Systems: Windows, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Purchase NY

Hyperion Planning Developer

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, Richmond, VA

Hyperion Consultant

Responsibilities:

• Performed installation and configuration Hyperion 11.1.2.1
• Upgraded Essbase, Planning, FR, IR, HFM and FDM applications from 9.3.1 to 11.1.2.1
• Developed 4 environments Development, Test, Acceptance and Production. Installation and configuration of 11.1.2.1( shared services, Essbase, planning, reporting and analysis, HFM, FDM) in all the four environments
• Installation and configuration of ODI 11.1.1.5
• Installed and configured ODI standalone agents.
• Installed and configured disaster recovery environment.
• Patching the servers during the Hyperion upgrade for fixing few bugs in version 11.1.2.1
• Provided Production Support for all the applications after the Upgrade is completed.
• Application Include (Essbase, Planning, FR, IR, HFM, FDM, ODI)
• Security migration from 9.3.1 to 11.1.2.1(Development environment). Also Migrated the applications from Development to Test Environment (11.1.2.1) and to Acceptance Environment(11.1.2.1) and finally Production Environment (11.1.2.1)
• Migrated shared services security and groups from 11.1.2.1 using LCM
• Created groups in the shared services 11.1.2.1
• Gave provision to the groups and users in the shared services 11.1.2.1
• Configured LDAP user directory in Shared services 11.1.2.1( in all the four environments development, test, acceptance and production)
• Upgraded of planning application from 9.3.1 to 11.1.2.1(Development environment). Also Migrated the applications from Development to Test Environment (11.1.2.1) and to Acceptance Environment(11.1.2.1) and finally to Production Environment (11.1.2.1)
• As a part of planning application upgrade migrated business rules, calculation scripts, report scripts, Projects from 9.3.1 to 11.1.2.1
• Loaded data into the Essbase cube
• Migrated security related to business rules
• Migrated groups and users who are provisioned to the planning applications from 9.3.1 to 11.1.2.1
• Upgraded of Essbase from 9.3.1 to 11.1.2.1(Development environment). Also Migrated the applications from Development to Test Environment (11.1.2.1) and to Acceptance Environment(11.1.2.1) and finally to Production Environment (11.1.2.1)
• As a part of Essbase application migration migrated business rules, calculation scripts, report scripts, Projects from 9.3.1 to 11.1.2.1
• Loaded data to the Essbase cube
• Migrated groups and users who are provisioned to the Essbase applications from 9.3.1 to 11.1.2.1
• Upgraded of HFM from 9.3.1 to 11.1.2.1(Development environment). Also Migrated the applications from Development to Test Environment (11.1.2.1) and to Acceptance Environment(11.1.2.1) and finally to Production Environment (11.1.2.1)
• Upgraded of FDM form 9.3.3 to 11.1.2.1(Development environment). Also Migrated the applications from Development to Test Environment (11.1.2.1) and to Acceptance Environment(11.1.2.1) and finally to Production Environment (11.1.2.1)
• Upgraded IR and FR reports from 9.3.1 to 11.1.2.1
• As a part of IR migration created OCE connections.
• Migrated the security related to the both FR and IR groups
• Upgraded ODI 10 to 11 (Development environment). Also Migrated the applications from Development to Test Environment and to Acceptance Environment and finally to Production Environment
• Trouble shooting the errors occurred during installation, configuration, Upgrade and migration
• Supporting testers in UAT phase
• Provided production support for the upgraded applications from 9.3.1 to 11.1.2.1
• During the Production Support Performed Tasks as follows.
• Ran Autosysjobs taking backups and performing Essbase refresh.
• Performed Planning Database and security refresh.
• Provisioning Users in shared services according to the requests that come in for all the applications (Essbase, Planning, FR, IR, HFM and FDM.)
• Fixing issues that show up in production.
• Working with oracle support for resolutions.
• Migrating applications from one environment to another like form UAT to Production if any changes to the applications are made.
• Creating Native groups in shared services and provision the groups according to the requirements
• Worked on modifying existing VB scripts in FDM.
• Worked very efficiently with business users and technical team for fixing the issues.
• Supported development and testing activities for new releases of applications
• Performed migrations using LCM between environments.
• Migrated Essbase applications between environments.

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, Lyndhurst, NJ

Essbase Developer

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 Smartview 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, Stamford, CT

Hyperion Essbase Developer

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

Hyperion Developer

Responsibilities:

• Involved in developing design specifications of Essbase cube with Customers.
• Extensively involved in designing and modifying the outlines for Essbase Cubes.
• Developed Calc Scripts, Rule files and Report Scripts for data loads and dimension builds.
• Developed batch scripts using MaxL and ESSCMDs to load data from relational systems database to Essbase cube.
• Involved in Migration of Hyperion Reports and Analyzer Report groups from one environment to another environment.
• Used Essbase Administration Services for activities such as filter creation, creation of users, creation of groups, and migration of cubes and maintenance of Essbase Servers.
• Assisted with the integration of financial reporting along with streamlining of process/method improvement for data collection.
• Presented detailed analytical reports to higher administrative people using Hyperion Planning induced collaborative decision making.
• Developed Block Storage Cubes (B.S.O) cubes using Essbase 10.
• Optimized the applications to bring down the runtime and database size considerably.
• Involved in production support and maintenance of existing cubes.
• Worked as a team member in Hyperion Essbase & Planning Implementation.

Environment: Hyperion EssBase 10.x, Hyperion Planning, Hyperion Reports, Hyperion Analyzer 7, Excel-Add-in, MS Access, Oracle 10.1.2.3, Windows 2000/NT 4.0.

Confidential

Programmer/ Analyst

Responsibilities:

• Developed the billing transaction and integrated with the order processing system which includes order confirmation, deliveries, goods issued and billing.
• Involved in coding of stored procedures and Functions.
• Developed various reports to display the sales orders, deliveries pending bills from customers shipped orders and outstanding dues.
• Involved in writing source code using SQL, PL/SQL.

Environment: Oracle 10.1.2., Reports 10.1.2., PL/SQL and Win NT.