SUMMARY

• 11+ years IT experience expert on all aspects of Essbase application life cycle including but not limited to scope analysis, Design Creating Essbase ASO/BSO Cubes, Conversion of Block storage to Aggregate storage, Making Outline changes, building Load rules, building Calculation Scripts, report Scripts, ESSCMD/MAXL Scripts, Performance Tuning, Optimization and ad - hoc reports
• Experience in design, analysis, development, migrations, installations, administration and implementation of BI solutions usingHyperionFinancial Management (HFM), Financial Data Quality management (FDQM),HyperionEssbase 11.x/9.x,HyperionPlanning 11.x/9.x, Essbase Administration Services,HyperionFinancial Reporting, Data Relationship Management (DRM), MaxL, Smart View, Excel Add-In, Essbase Studio and Oracle Data Integrator (ODI) on Windows and Unix environment.
• Experience with full Enterprise Software Project Lifecycle from initiation through requirements, analysis, design, development, testing, deployment and administration (support and maintenance).
• Expertise in upgrade and migratingHyperionSystem 9x to 11x
• Expertise in writing Calc Scripts, Maxl Scripts, Report Scripts and Load rules.
• Extensively involved in maintenance, automation, backups, Performance tuning and Optimization of cubes across Block Storage (BSO) and Essbase kernels.
• Managing security, permissions, users and groups using Shared Services and controlling access to database cells through managing filters.
• Experience in SSL creation/renewal forHyperion.
• Creating innovative solutions to automate processes.
• DRM Experience in creating the Properties, Nodes, filters in different versions. Member and Hierarchy ordering in DRM, setting up different properties to members in export process etc.
• Workspace was used as a centralized system to register the application, creating data forms, Workflow, smartlist, Task lists, launching Business rules and Accessing Reports.
• Developed data forms usingHyperionplanning web client for the users to input Forecast, Budget, and Accounting changes.
• Export and import security using batch command.
• Used Oracle Data Integrator (ODI) to load data values, accounts, entities, and custom dimensions from flat file/Database into Essbase / Planning cubes.
• DevelopedHyperionFinancial Reports for the Monthly Financial Review Team.
• Having domain experience in Media and Entertainment, Confidential and Healthcare.
• Monitoring and supportHyperionEssbase Business Intelligence applications and batch load processes to ensure the highest level of system availability.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• Created user training manuals, documentation and provided training to the end users onHyperiontools.
• Excellent interpersonal, presentation and communication skills with the ability to work in a team and a stand-alone environment.
• Acted as a liaison between offshore and on-shore team.

TECHNICAL SKILLS

• Hyperion System
• Hyperion Planning
• Hyperion Essbase
• Hyperion Data Relationship Management
• Hyperion Financial Management
• Essbase Administration Services (EAS)
• Shared Services
• HyperionFinancial Reporting … Oracle Database 11g
• Windows Server 2008 R2
• Unix
• Smart View
• ODI
• DRM
• FDQM
• Essbase Studio.

PROFESSIONAL EXPERIENCE

Confidential, Dallas TX

Senior Lead Hyperion Developer/Admin

Responsibilities:

• Creating HFM application, Managing Data forms & Data grids, Setting up HFM integrations from DRM to HFM, Resolving HFM profile corrupt issues, HFM shared service register, resolving HFM DCOM issues..etc
• Security import/export using command process.
• SSL Certificate setup & renewal.
• Daily jobs monitoring and troubleshooting if any issues in jobs.
• Setup & monitoring Daily applications backups.
• Troubleshooting if Calc scripts, Business rules, HFM rules not running properly.
• Free up space inHyperionLinux servers.
• HFM, FDM, Essbase, Planning & DRM migrations from one environment to another environment Restore Essbase Database & Planning applications to usable state after corruption.
• Monitoring Defrag process in Nightly jobs and resolving Defrag issues.
• Set up/Scheduling jobs using Crontab in Linux servers.
• FDM Adapter & Script migration.
• Creating HFM application, Managing Data forms & Data grids, Setting up HFM integrations from DRM to HFM, Resolving HFM profile corrupt issues, HFM shared service register, resolving HFM DCOM issues..etc
• HFM reports migrations and troubleshooting financial report issues.
• Installation of theHyperionproduct, ConfiguringHyperionEssbase and Planning.
• Involved in installation/Configuration Essbase Studio, ODI 12c and DRM.
• Involved in Installation/configuration of FDQM and HFM.
• Developed Batch/shell Scripts to Stop/StartHyperionServices.
• Developed Monitor scripts to checkHyperionservices are up or down.
• Automating script, validating data, testing and support end - users on security related issues, troubleshooting their problems and maintaining applications.
• Performed migration tasks from one environment to another using LCM (Lifecycle Management) utility and Relational backup and restore.
• Optimized the applications to bring down the runtime and database size considerably.
• Involved in production support and maintenance of existing cubes.
• Knowledge of Improving Performance Tuning for all theHyperionProducts.
• Supporting the End users on Client install issues. Tracking the issues with Incident management tickets.
• Backup and Recovery ofHyperionapplications. Scheduling daily backups.
• Monitoring the current Production environment servers for performance and stability.
• Supporting & troubleshooting custom sites (Data Mart portal, Writeback, AllocationFP & HAL) issues.
• Troubleshooting Smartview issues.
• Troubleshooting DRM metadata job issues.
• Defined and documented the steps to migrate applications in theHyperionPlanning and Essbase Prod, QA, and Dev environments.
• Developed Scripts for routine administration tasks like backup, purging app/server logs.

Environment: HyperionSystem 11.x,HyperionPlanning 11.x,HyperionEssbase 11.x,HyperionData Relationship Management 11.x,HyperionFinancial Management 11.x, Essbase Administration Services (EAS), Shared Services,HyperionFinancial Reporting 11.x, Oracle Database 11g, Windows Server 2008 R2, Unix, Smart View, ODI, DRM, FDQM, Essbase Studio.

Confidential, Forth worth TX

Lead Hyperion Developer/Admin

Responsibilities:

• Developed Batch/shell Scripts to Stop/StartHyperionServices.
• Developed Monitor scripts to checkHyperionservices are up or down.
• Automating script, validating data, testing and support end - users on security related issues, troubleshooting their problems and maintaining applications.
• Created security for users in shared services. Activities such as filter creation, creation of users, creation of groups, and migration of security objects to 11.1.2.2.
• Performed migration tasks from one environment to another using LCM (Lifecycle Management) utility and Relational backup and restore.
• Worked on the upgrading/installation activity ofHyperionSystem EPM 9.3.1 to 11.1.2.2 in windows and UNIX environments. Duties include migrating HFM, FDM, Planning apps, artifacts, Essbase EPM application and their objects, security.
• Involved in Installation/configuration of FDQM and developed POC to load data into ESSBASE BSO cubes.
• Installation of theHyperionproduct, ConfiguringHyperionEssbase and Planning.
• Involved in installation/Configuration Essbase Studio, ODI and DRM.
• Participated in defining requirements from the end user, functional specifications, design documentations and test strategies.
• An Auto recon process has been developed to generate reconciliation report between Source and Target System.
• Involved in creating the load utility files for the dimension member loading and the data loading into the application.
• Created web forms for the user inputs which were tuned by creating the attribute and substitution variables.
• Developed Data Load, MaxL scripts and shell scripts to automate the same.
• Provided training to end users in using the Smart View and Web forms to enter data.
• Involved in user access provisioning and security filter on the system. Assigned accesses and privileges to various end users in different planning applications using Shared Services.
• Maintaining dimensional level security in Planning at group level and created the security matrix for more than 2000 users in shared services.
• Responsible for developing Financial and Management Reports usingHyperionFinancial Reporting Studio andHyperionSmart-View.
• Responsible to keep the structure of the Report folders in sync in different environments for the report migration purpose.
• Responsible for solving the reports issues related to tool with the help ofHyperiontech support.
• Assign the security permissions and provisions to the Reports inHyperionWorkspace.
• Maintain security by creating, managing, and assigning provisions to the users in the shared services.

Environment: HFM, FDM,HyperionEssbase11.1.2.2,HyperionPlanning 11.1.2.2, Essbase Administration Services (EAS),HyperionFinancial Reporting, Shared Services, Oracle Database 11g, Windows Server 2008 R2, Unix.

Confidential, AUSTIN TX

Senior Hyperion Consultant

Responsibilities:

• Created Essbase Filters to restrict the user access.
• Working on Essbase hierarchy changes.
• Handling month end activities and running the Job's manually when requested by business.
• Application synch between Production to Development
• Working on Adhoc requests.
• User accounts used for logon to Dev and QA servers.
• Analyze databases and data files; Currency database, Exchange database, Histrate database and Main database. Data movement between Main and Exchange database, and between Main and Histrate database
• Working on the incidents, work orders and service requests and resolved the issues on time.
• Involved in preparing KCS (Knowledge Centered Support) for the issues.
• Monitored maintenance activities of application and services.
• Provisioning user's security through EAS Console, creating groups and users in Essbase application. And maintaining SOX documentation for the same
• Need to monitor Elimination Process, Outline failures, Import failures, batch reports
• Worked with a team to provideHyperionFinancial Management solutions and support
• Involving HFM support activities like opening period every month using 'Process Control' option.
• Opening Journal & IC periods for every month
• Creating Application profiles, User Defined Member lists, Modification in Metadata
• Modification / Updating of metadata as per the requirement
• Creation of Data Forms as per user requirement
• Designing the locations and mappings associated with each locations
• Load mappings and the data files
• Create Target users and assign them with various level of security access.
• Mapping Source accounts with Target accounts in their respective locations in FDM.
• Assist users in loading Journals, ICP and Trial Balance data.

Environment: HyperionEssbase 9.3.1, 11.1.2.1,HyperionPlanning 9.3.1, 11.1.2.2,HyperionShared Services 9.3.1, 11.1.2.2,HyperionFinancial Reporting 9.3.1, 11.1.2.2, Workspace, Oracle Database 11g, Windows Server 2008 R2, Unix, Smart View.

Confidential

Hyperion Consultant

Responsibilities:

• Creating E - mail alerts for Process Management.
• Creation of Web Data Entry Forms by using Web Application.
• Changing the Metadata whenever needed.
• Initial application setup such as creating an application profile.
• Designing Dimensions, Data Forms, Data Grids, Journal Templates, etc.
• Design and implement user-provisioning details using Security Classes for each application.
• Worked on Web to perform financial consolidation and analysis.
• Running Consolidations after data load.
• Worked in close co-ordination with the client during the implementation.
• Initial application setup such as creating an application profile. Making changes to the HFM metadata as per the clients requirements.
• Set up security, including users, groups, security classes, and access rights. Configure Data Entry Forms by using Web Applications and Creating Grids as per requirement.
• Worked on Database Management to copy data from one scenario to another.
• Creation of Journals and doing Process Management in HFM.
• Creating the FDM application and configuring application setting and integrating settings etc.
• Populating control tables and creating import formats, mapping tables.
• Designing the locations and mappings associated with each location.
• Managing process flow: import, validate, export and clear & consolidating target system.
• Validating the mapping and export mapped file to target systems.

Environment: HFM, FDM,HyperionPlanning 11.1.1.3,HyperionEssbase 11.1.1.3, Essbase Administration Services (EAS), Essbase Outline Extractor,HyperionFinancial Reporting Studios, Shared Services, Oracle Database 11g, Windows Server 2008.