SUMMARY

• Over 8+ years of IT experience in advanced analytical software applications, Requirements Gathering, Design, Development, Testing, Administration and implementation of OLAP and Client / Server projects using industry accepted methodologies and proceduresExperience in development of Hyperion Planning applications with data forms, Web Forms, Task list, Business rules, menus, plans, and application migration as well as application management and troubleshooting.
• Expertise in buildingFinancial Budgeting and Forecasting OLAP applications with Hyperion planning.
• Designing and implementing Security for Hyperion products.
• Understanding of Essbase security features and ability to create user and group profiles and assign proper privileges.
• Provided security for various levels of users using Hyperion Shared Services.
• Experience in performing migration between different environments and in upgrade between different versions including Life Cycle Management utility in version 11.
• Configuration of OBIEE and EPM with full end to end SSL with External LDAP in SSL.
• Experience on the installation, configuration, sever settings and client installation of Oracle Business Intelligence Enterprise Edition(OBIEE 10x/11x) on UNIX environment.
• Administration of nightly and weekly backups of Hyperion and OBIEE services through manual/automated updates.
• Installation of RCU for 11x.
• Responsible for upgrade and configuration of OBIEE environment from 11.1.1.7.1 to 11.1.9.0 for agencies.
• Implementation of Mapviewer in OBIEE 11x.
• Implementation of Usage tracking in OBIEE 11x.
• Implementation of BI Publisher Usage tracking in OBIEE 11x
• Quarterly patching for OBIEE (PSU)
• Set up single sign on (SSO) with OBIEE 11x with Workspace.
• Creating RPD and Dashboards.
• EPM Workspace Integration with OBIEE
• Import the Essbase Cube Data from Essbase Administration services console (EAS) to OBIEE and generate the dashboards.
• Configuration of OBIEE and EPM with full end to end SSL with External LDAP in SSL with Weblogic 11G/9G
• Quarterly patching for WebLogic 11g (PSU)
• Set up single sign on (SSO) with WebLogic 11x for OBIEE/Hyperion
• Deploying War files in WebLogic 11g.
• Configuring WebLogic 9G/10G/11g domain and server to adapt with OBIEE, EPM products and custom applications.
• Configuring WebLogic 11g domain with Different LDAPS sources for OBIEE/EPM.
• Daily, weekly and quarterly Deployment.
• Daily, weekly and quarterly maintainace of WebLogic services with OBiEE/EPM/Custom Apps.

TECHNICAL SKILLS

OLAP Development Tools: Hyperion version 11.x Product Suite, Hyperion Planning System 11.1.x.x, 9.3.1/9.3.0, Hyperion Shared Services 9.3, Enterprise Performance Management 11.1.2, 9.3.1/7.X/6.X, Essbase Integration Services 7.X/6.X (EIS), Hyperion System 9 Smart View, Essbase Excel Add In, ESSCMD, MaxL, MDX, Hyperion Report 9.3,7.2/7.0, Hyperion Financial Reporting Studio 9.3, 11.2.3, OBIEE 11x.

Middle ware: Apache, Tomcat,, WebLogic 10x, 11x, Oracle Fusion Enterprise Management 11x

Business Intelligence Tools: Hyperion Analyzer, Hyperion Performance Suite, Hyperion Intelligence,OBIEE 11x.

Reporting Tools: Hyperion Financial Reporting Studio 9x/11x, Hyperion Reports, Web Analysis, Hyperion Analyzer 7.x/6.x/5.x, Hyperion Intelligence, Brio 11x, Hyperion Spreadsheet Add - in, Hyperion Smartview 11x, OBIEE 10x/11x.

Programming Languages: Java, J2EE, C, C++, SQL

Operating Systems: Windows 95/98/2000/NT/XP, Red hat Linux, Unix, Oracle OS.

Databases: Oracle Database 10g/11g, Informix, DB2 databases, MYSQL, ODBC Drivers Setup.

PROFESSIONAL EXPERIENCE

Confidential, Arlington, VA

Hyperion/OBIEE/WebLogic Administrator

Responsibilities:

• Responsible for installation, configuration and server setting for EPM 11.1.2.2 to 11.1.2.4 and OBIEEE 11.1.7.0 to 11.1.9.0 for two Clients in 7 environments.
• Administration of nightly and weekly backups of Hyperion and OBIEE services through manual/automated updates.
• Quarterly patching for OBIEE (PSU)
• Set up single sign on (SSO) with OBIEE 11x with Workspace.
• Creating RPD and Dashboards.
• Responsible for upgrade and configuration of OBIEE environment from 11.1.7.0 to 11.1.9.0
• Initial up-grade of EPM 11.1.2.2 to 11.1.2.4 including reconfiguration and presetting of server settings.
• Implementation of Mapviewer in OBIEE 11x.
• Implementation of Usage tracking in OBIEE 11x.
• Implementation of BI Publisher Usage tracking in OBIEE 11x
• Quarterly patching for OBIEE (PSU)
• Quarterly patching for WebLogic 11g (PSU)
• Deploying War files in WebLogic 11g.
• Configuring WebLogic 11g domain with Different LDAPS sources for OBIEE/EPM.
• Created users, groups, filters and assigned different kinds of Security access to users in Hyperion Planning using Shared Services.
• Configuration of OBIEE and EPM with full end to end SSL with External LDAP in SSL.
• Maintenance of server batch scripts including Start/stop of servers for weekly maintenance purposes. Create and delete scripts for WebLogic Services in OBIEE 11g
• Migration of user security and reports through LCM in Shared Services.
• Setting up Email server in Oracle OS with Hyperion/OBIEE.
• Creating RPD and Dashboard in OBIEE 11g.

Confidential, Kansas City, KS

Hyperion/WebLogic/OBIEE Administrator.

Responsibilities:

• Responsible for installation, configuration and server setting for EPM 11.1.1.3 to 11.1.1.4 then 11.1.2.3 and OBIEEE 11.1.6.2 to 11.1.6.9 then 11.1.7.0 for two agencies.
• Administration of nightly and weekly backups of Hyperion and OBIEE services through manual/automated updates.
• Responsible for upgrade and configuration of OBIEE environment from 11.1.1.6.0 to 11.1.6.9 for agencies, Eventually upgraded to 11.1.7.0
• Initial up-grade of FPM 11.1.1.3 to 11.1.1.4 including reconfiguration and presetting of server settings. Eventually upgraded to 11.1.2.3.
• Compiling and Installation of Apache HTTP Server 2.2 with E Authorization for server and directory configuration files.
• Installation of Essbase and other EPM tools onto the same Weblogic 11g domain as OBIEE facilitating shared security provisioning between Essbase and OBIEE though application roles and policies
• Assisted with the development of Hyperion Planning for P&L and Workforce Planning.
• Created users, groups, filters and assigned different kinds of Security access to users in Hyperion Planning using Shared Services.
• Created and executed calculation scripts for automation of shipments, actual and forecasting data.
• Configuration of OBIEE and EPM with full end to end SSL with External LDAP in SSL.
• Maintenance of server batch scripts including Start/stop of servers for weekly maintenance purposes. Create and delete scripts for Weblogic Services in OBIEE 11g (11.1.1.6)
• Migration of user security and reports through LCM in Shared Services.
• Setting up Email server in Oracle OS with Hyperion/OBIEE.
• Creating RPD and Dashboard in OBIEE 11g.
• Import the Essbase Cube Data from Essbase Administration services console (EAS) to OBIEE and generate the dashboards.

Confidential

Hyperion Consultant/Planning Administrator

Responsibilities:

• Interacted with users to gather business requirements, define, design, develop, test and deploy Hyperion Planning Applications.
• Installation and Configuration of the Development server consisting of Enterprise Performance Management 11.1.2.1, Hyperion Planning, Hyperion Shared Services, Hyperion Application Link, Financial Reports, Web Analysis and Workspace.
• Successfully upgraded the environment from version 9 to version 11.1.2.1
• Worked on Enterprise Performance Management 11.1.2.1planning to support complex financial applications for budgeting and Forecasting.
• Created web forms in Hyperion planning for users to input forecast, budget, actual, accounting changes and other variance explanations data.
• Used JAVA APIs to run Interactive Reporting jobs. Also used Java APIs to access shared services from external applications.
• Created the data forms, Web Forms, Task list, as per client request.
• Developed HBR (Hyperion Business Rules) with Run-Time Prompts.
• Create Data Source Configuration through Hyperion Configuration Utility 11 in Hypeiron System 11.1.2.1 Foundation. Created and registered Planning applications in Hyperion System 11 Workspace.
• Assisted with the development of Hyperion Planning for P&L and Workforce Planning.
• Created users, groups, filters and assigned different kinds of Security access to users in Hyperion Planning using Shared Services.
• Created and executed calculation scripts for automation of shipments, actual and forecasting data.
• Designing new WAS 7.0 implementations.
• Standardizing existing WAS 7.0/6.1 environments, setting up deployment and release best practices.
• Designing and implementing Security for WebSphere environments using LDAP and ESM.
• Implement Hyperion Products on WebSphere application server.
• Installed EARs, WARs and configured application specific JVM settings, Web container parameters using the Admin Console and used was admin scripts to invoke Jacl and Jython scripts in WAS 6.x/7.0.
• Created and scheduled batch jobs for complete automation processes for application refresh and backup.
• Developed batch scripts to automate the process of taking backups of the planning application, essbase database, shared services and reports on a nightly basis using the Life cycle management command line utility.
• Performed migrations between the Production, QA and Dev environments using the Life Cycle Management utility integrated in the shared services console provided in 11.1.x.x version.
• Developed batch scripts using for building dimensions dynamically and load data into cubes and scheduled to run on a periodic basis.
• Documented the recovery process in the event of disaster recovery.
• Provided production support and dealt with the user issues.
• Provided security for various levels of users using Hyperion Shared Services.

Environment Enterprise Performance Management 11.1.2.1, Hyperion planning 11.1.x, EAS Administration services, Hyperion Financial reports, HyperionPlanning desktop, Smart View, Oracle 10g, MS Excel spreadsheet Add-in, Windows 2000, Hyperion DRM 9.3

Confidential, Bohemia, NY

Hyperion consultant/admin

Responsibilities:

• Interacted with users to gather business requirements, define, design, develop, test and deploy Hyperion Planning Applications.
• As a Hyperion Administrator involved in Installation and Configuration of Hyperion products such as Planning, Essbase,reporting tools, and Shared Services reporting ODI.
• Worked on Enterprise Performance Management 11planning to support complex financial applications for budgeting and Forecasting.
• Installed and configured IBM WebSphere Application Server 6.0/6.1/7.0 (ND) on AIX operating platforms for development and production environments
• Configuring WAS and setting up environment for new applications.
• Created JVM’s for Hyperion EAS and Aps on Websphere and assigned the respective ports to these Jvm’s on Websphere.
• Created web forms in Hyperion planning for users to input forecast, budget, actual, accounting changes and other variance explanations data. Developed Calc Scripts, Rule files and Report Scripts for data loads and dimension builds.
• Developed HBR (Hyperion Business Rules) with Run-Time Prompts.
• Involved in Automation of Essbase cubes using MaxL, Esscmd, MDX, Batch and Shell scripts.
• Involved in designing reports and snapshots using Hyperion Reports/Financial Reporting.
• Used JAVA APIs to run Interactive Reporting jobs.
• Experienced in implementing and managing server clustering and maintenance of connections pools and EJBs
• IBM HTTP server and plug-in installation and configuration.
• Created Financial Budgeting and Forecasting OLAP applications with Hyperion planning.
• Used Hyperion Planning 11.1.1.3 to create EAS applications / security filters, modify existing and develop new database outlines, business rules, setting up dimensions, users / user groups and security rights.
• Expertise in developing data forms, Web Forms, Task list, Business rules.
• Worked on Enterprise Performance Management 11.1.1.3 BI+ to create various ASO and BSO applications for budgeting planning and forecasting for higher management of decision support system.
• Modified existing outlines for addition, deletion and movement of members both through manually and used dimension build methods.
• Developed batch scripts using for building dimensions dynamically and load data into cubes and scheduled to run on a periodic basis.
• Created HAL routines to load data from Outline Utility to load date to Planning and dimension building.
• Involved in estimating and tuning the Essbase database performance.
• Hands on experience in backup and recovery of database.
• Provided security for various levels of users using Hyperion Shared Services.

Environment: Enterprise Performance Management 9.3.0.1 / 11.1.1.3, Hyperion planning 9.3.0.1 / 11.1.1.3, EIS Integration services, Hyperion Reports 7.3, Hyperion Web analyzer, Hyperion Application Link 7.2,Hyperion Planning desktop, Oracle 9i,SQL, PL/SQL,MS Excel spreadsheet Add-in, Windows 2000.