SUMMARY

• Over 10 years of experience in Hyperion Applications using Planning, Essbase, FDM, HFM, ODI, Esscmds, Maxl scripts, and Financial Reporting and also have strong Hands on experience in Data warehousing (Informatica) with major focus on design and development and full implementations.
• Strong understanding of dense and sparse settings, performed dynamic calculations, developed, reviewed, and loaded data from various database to cubes.
• Prepared the SDS, TSD documents from the functional specification document.
• Experience creating Experience creating reports through Hyperion Reports and/or Analyzer or equivalent Hyperion application (if within System 9 BI+), OLAP cubes using Hyperion Essbase, both ASO and BSO.
• Strong database development and business intelligence modeling capabilities; Essbase Calculation Script & Configuration Settings.
• Experienced Hyperion System 9 modules (Hyperion System 9 BI+ Analytic Services, Hyperion System 9 Planning, Interactive Reporting, Financial Reporting, Production Reporting and Dashboards)
• Involved in writing custom Essbase calculations scripts, automated the Essbase Cubes using ESSCMD, MAXL and Batch Scripts.
• Good knowledge and experience in using Oracle 10g/9i/8i, Terradata v2R6/V2R4.
• Expert in creating reports using Essbase Excel Add - In, Hyperion reports, Report Scripts & adhoc reports using Hyperion Analyzer.
• Proficient in Batch Scripting, SQL Scripting, Software Installation, System Upgrade and Server Maintenance, Application and Data back-ups and Security, RDBMS Design and Development.
• In depth knowledge of End to End testing of software, SDLC, SEI - CMM standards excellent understanding of Software Development Life Cycle and Test Methodologies from project design to post-deployment documentation.
• Expertise in designing and developing Test plans, Test Cases, Test Scripts, Test Scenarios, Test Reports for both manual and automated tests.
• Knowledge of Essbase Integration Services and Partitioning.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.

TECHNICAL SKILLS

Operating Systems: Windows 2003/NT/XP/Vista, Mac OS and UNIX.

Tools: Hyperion Essbase 11.1.1.2/9. x/7.x/6.x, Hyperion Planning 11.1.1.2/9. 3, Hyperion Analyzer 7.x/6.x, Hyperion Reports 7.x, Hyperion Integration Services, ESSCMD, MAXL, Hyperion Financial Management, UNIX Shell Script .AUTOSYS,TOMCAT,OAS,WEBLOGIC.

OLAP Tools: Hyperion Essbase 11.1.1.2/9. 3/7.1.5/6.x, EAS 7.1.5, EIS, Hyperion System 9 BI+

RDBMS: Oracle 7/8/8i/9i/10gi, IBM DB2,TerradataV2R6.0/V2R4.0,SQLServer 2005/2000, MSAccess.

Languages: C, C++, COBOL, JCL, SQL

PROFESSIONAL EXPERIENCE

Confidential, Columbus OH

Responsibilities:

• Involved in installations and configurations of Hyperion 11.1.2.2. version in distributed environments both windows and linux.
• Worked on Patching strategies for the Hyperion Products like Planning, Essbase, Essbase Studio, FR,IR.
• Worked for the install and configuration ODI and Hypoerion strategic Finance for the existing environments.
• Involved with IE 11 upgrade by implementing Hyperion 11.1.2.2.500 Patching across all the environments
• Provided the right syntax sql’s for creating the schema;s required for configuration oif Infrastucture.
• Involved in integrating OBIEE with Hyperion Worksapce and Shared services and succefully completed the same.
• Performing multiple installations and configurations for different LOB’s, debugging and find out the root cause during Hyperion EPMA Setup
• Installing and Configuring OBIEE 11g on Red hat Linux for POC
• Installed configured ARM,FCM and SOA on windows environments for both 11.1.2.2 and 11.1.2.3.
• Making changes to improve the performance at Infrastructure Level.
• Worked on Financial Reporting Batch Scheduler issue, which is failing since 2 years and make a fix for it.
• Worked on Financial reporting PDF preview issue, where reports failed to open in PDF mode and successfully fixed the same.
• Successfully made the OHS big Ip url’s work using the diversions of ports and was working on a big ip url.
• Addition of new components for existing architecture like HFM FDM ARM FCM.
• Worked on Weblogic security Patching’s extensively released by Oracle on a quarterly basis.

Environment: Oracle Hyperion EPMA 11.1.2.2 Hyperion Financial Management,, ODI 11g, OBIEE 11g, Oracle 11g, RHEL 5.4 Servers and Windows 2008 Servers,Account Reconciliation Management, Financial close management, SOA, weblogic, linux, windows.

Confidential

Principal Technical Analyst

Responsibilities:

• Building new Infrastructure setup of Hyperion EPMA 11.1.2.1.11.1.2.2 and 11.1.2.3 on distributed environment for existing and new architectures...
• Installing of Hyperion EPMA 11.1.2.0 and 11.1.2.1 products on Red hat Linux, IBM AIX, Oracle Enterprise Linux and Windows 2008 Servers and configuring with Oracle Web Logic 11g application server
• Performing multiple installations and configurations for different LOB’s, debugging and find out the root cause during Hyperion EPMA Setup
• Installing and Configuring OBIEE 11g on Red hat Linux for POC
• Installed configured ARM,FCM and SOA on windows environments for both 11.1.2.2 and 11.1.2.3.
• Applied patches security patches, and 11.1.2.3.500 series patches in the distributed environments for all the Hyperion Suite.
• Created the sample schedules for FCM.
• Created SOA service as windows and updated the registries as per the standards, which makes SOA run without any issues.
• Created the Web logic as a windows service to run uninterruptedly.
• Support existing multiple Hyperion Environments 11.1.1.3 and System 9.
• Configuring new MSAD active directory for existing and new Users in the Organization.
• Creating a new Groups through Shared Service and assigned privileges for Hyperion Products
• Worked on building the clustering environments for Essbase, Planning and HFM.
• Hands on experience working on Disaster recovery of the total Hyperion Modules.
• Migrating Multiple Planning Applications, Artifacts and Security from SIT/UAT to PROD by using LCM Utility
• Migrating Stand Alone Essbase Applications and Objects from SIT/UAT to PROD by using Migration Wizard and on Server side
• Implementing backup scripts for LDAP, Essbase Lvl0, All data and Essbase Applications by writing MAXL, Batch and Shell Scripting
• Implementing daily backup for Planning Applications by using LCM script
• Automating back up and Start/stop Hyperion Services on daily and weekly basis.
• Making changes to improve the performance at Infrastructure Level.

Environment: Oracle Hyperion EPMA 11.1.2.0 & 11.1.2.1,11.1.2.2,11.1.2.3 Hyperion Financial Management, Hyperion System 9.3.1/11.x, ODI 11g, OBIEE 11g, Oracle 11g, RHEL 5.4 Servers and Windows 2008 Servers,Autosys, Account Reconciliation Management, Financial close management, SOA, weblogic, linux, windows.

Confidential, New JERSEY

Hyperion EPM Tech Lead

Responsibilities:

• Building new Infrastructure setup of Hyperion EPMA 11.1.2.0 and 11.1.2.1 on distributed environment for existing BMS projects.
• Installing of Hyperion EPMA 11.1.2.0 and 11.1.2.1 products on Red hat Linux, IBM AIX and Windows 2008 Servers and configuring with Oracle Web Logic 11g application server
• Performing multiple installations and configurations for different LOB’s, debugging and find out the root cause during Hyperion EPMA Setup
• Installing and Configuring OBIEE 11g on Red hat Linux for POC
• Support existing multiple Hyperion Environments 11.1.1.3 and System 9.
• Configuring new MSAD active directory for existing and new Users in the Organization.
• Creating a new Groups through Shared Service and assigned privileges for Hyperion Products
• Assigning Filter and Calc access through Shared Service to all groups
• Worked on building the clustering environments for Essbase, Planning and HFM.
• Hands on experience working on Disaster recovery of the total Hyperion Modules.
• Migrating Multiple Planning Applications, Artifacts and Security from SIT/UAT to PROD by using LCM Utility
• Migrating Stand Alone Essbase Applications and Objects from SIT/UAT to PROD by using Migration Wizard and on Server side
• Implementing backup scripts for LDAP, Essbase Lvl0, All data and Essbase Applications by writing MAXL, Batch and Shell Scripting
• Implementing daily backup for Planning Applications by using LCM script
• Automating back up and Start/stop Hyperion Services on daily and weekly basis.
• Making changes to improve the performance at Infrastructure Level.
• Coordinate with Project Managers, Business teams to analyze new Business Requirements
• Making changes to Calc Scripts, MAXL and Business Rules
• Responsible for Planning metadata loading by ODI 11g
• Making manual changes to Essbase functions and planning functions.
• Installed and configured Smart view 11.1.2 and Essbase excel-Add-in 11.1.2 on client machine for data validating and loading input data through web forms
• Troubleshoot issues and documentation Web logic 11g and HTTP Servers of Hyperion EPMA 11.x

Environment: Oracle Hyperion EPMA 11.1.2.0 & 11.1.2.1, Hyperion Financial Management, Hyperion System 9.3.1/11.x, ODI 11g, OBIEE 11g, Oracle 11g, RHEL 5.4 Servers and Windows 2008 Servers,Autosys.

Confidential, Reston, VA

Hyperion TECH LEAD/ Administrator

Responsibilities:

• Conducted Weekly Meetings with SME’s to resolve issues, assessed any issues that would lead to potential risk to the project.
• Building up Environments SIT (Software integration testing), UAT (User acceptance testing) and Production.
• Installed Essbase on AIX 6.1 for all the environments and regularly monitored till production live.
• Deployed the planning applications, Business rules into production using LCM Utility.
• Involved in migration/up gradation activity of different applications perfectly from test to production as well System 11.1.1.2.
• Worked on LDAP authentication and access privileges in Shared services.
• Upgraded the Essbase from 9.3 to 11.1.1.2 for a different project within Freddie Mac.
• Involved in writing different shell scripts in UNIX for backups stuff and batch scripts.
• Involved with various production issues like registering with shared services and configuration files.
• Configured all the Hyperion components with proper schemas on the both windows and aix side.
• Worked on installation and documenting the process of Hyperion essbase and Reporting studio.
• Essbase BSO and ASO cubes - Outlines, dimensions, measures, members, metadata administration with ability to design databases and complex calculations
• Provided Database Optimization with Dimension Building, Data Loading, Indexing, Calculations, Cache Management and Partition Management.
• Created new batch jobs and scheduled these batch files for complete automation process for refresh, calculations and backups using MAXL and Shell Scripts.
• Responsible for creating users groups and configuring and publishing the documents and job scheduling.
• Worked extensively on day to day activity monitored the Job’s and we strictly achieve the SLA’s as part of production support.
• Worked on periodic maintenance releases of applications, including enhancements redesign the defects.
• Successfully created clear quest and clear case tickets for the enhancements and patches that were applied to the system.
• Worked extensively in writing up of Jils for the automation of Jobs using Autosys.
• Worked extensively in Test and deploy EAS Client and Excel Plug-in for Essbase.
• Developed and implemented extensive modifications to the delivered positive pay process.
• Involved in Optimization & Performance tuning of Outline/Data load/Calculations.
• Involved in enabling the SSL and SSO for both Hyperion and OBIEE.
• Building up of Oracle Financial Close Management Environment in House for reducing the cost.
• Worked on creating the common TAM junctions for OBIEE and common junctions for Hyperion.
• Developed & Scheduled batch scripts to automate dimension build, data load and backup.
• Worked on various forms using Hyperion Planning. Created and maintained Essbase databases using planning application.
• Involved in 24/7 production support ad achieved the SLA’s within the correct time.
• Involved in designing and implementing new application in Hyperion Essbase. Worked with existing cubes for budget allocation.
• Worked on Excel Add-in Tools to generate various reports to analyze the business.
• Knowledge on JAVA and J2EE methodologies like increasing of JAVA heap sizes.
• Developed the Automation scripts for cube refresh, import and export of data forms and dimensional access.
• Maintained Security using shared services in development environment.

Environment: Hyperion BI+ System 11.1.1.2, Essbase, Essbase Integration services, Hyperion Planning11.1.1.2, OFCM11.1.2, Essbase, Excel-Add-in, Essbase administration Server (EAS),ODI, Web-analysis, Smart view, VB, Oracle9i, Clear Case, Clear Quest, BMC REMEDY, Unix Shell script, Windows 2003 server, AUTOSYS, Financial reporting, OAS, TOMCAT, Web logic.

Confidential, Boston, MA

Hyperion Essbase/Planning LEAD Administrator

Responsibilities:

• Worked closely with QA team for regression, integration and UAT testing.
• Updated and modified progress and resources allocation in MS project for the team.
• Was responsible for coming up with task and resource allocation along with the project manager.
• Demonstrated various modules to the business during the project lifecycle, incorporated the feedback into the project plan.
• Involved in writing UNIX shell scripts for different purposes like backups and batch processing’s.
• Worked on both ASO and BSO in Essbase.
• Understands the business processes, how the application supports the business processes and applies this knowledge to best solve problems.
• Suggested process and product improvements for the application.
• Created test plans, scripts and facilitated user acceptance testing.
• Lead design and delivery of a critical Business Intelligence/Analytics application in support of new business processes providing a Brio EIS application for validating demand forecasts.
• Involved for generating KPI reports for different business and end-users.
• Developed Executive Dash Boards to accomplish launching various Reports.
• Responsible for analyzing business requirements and developing queries and reports using Brio ad hoc query tool to provide Web-enabled data analysis solutions.
• Involved in the activities like system testing, full User Acceptance Test (UAT).
• Worked on QIQ Merge for merging two separate Brio by files.
• Also responsible for related functions such as user creation, security profiles and authorizations.
• Supervised and managed Vendor, Asset, Item Projects, and AR conversion efforts.
• As a part of production support, specialized in resolving problems associated with procurement Approval workflow, requisitioning and sourcing PO’s.
• Modify the title, grade, rate, and other information for existing and future employees
• Add, edit, and delete to-be-hired (TBH) employees
• Easily manage head count by using selections from Smart Lists to plan for an employee’s departure or leave of absence
• Transfer employees from one cost center to another either directly or using a two step ‘transfer out/transfer in’ process
• Plan salaries and other compensation, including bonuses, fringe benefits, and other expenses for existing and to-be-hired employees
• Performed performance tuning for people soft application server and process scheduler.
• Created People Soft Queries reports to suit the user requirements and needs.
• Worked on Excel Add-in Tools to generate various reports to analyze the business
• Performed Involved making module enhancements - focused on order management which included automating end user email communications, sending out automated email updates, web-based surveys and registration forms for data collection etc.
• Supported the admin activity for the workforce revenue planning.
• Documented client organization's direction, structure, business processes and requirements
• Researched client organization's industry and competitive position
• Worked directly with the end user customer and several internal departments to make network provisioning flexible and simpler

Environment: Brio 6.6 / Hyperion 8.2.1, 8.3.2, Upgraded to Hyperion 9 bi, Hyperion planning, Hyperion Insight/Dynamic Viewer/Analyzer, IS, Smart view, Financial reporting, Web-analysis, Hyperion Performance Suite 8.2.1 / Brio On Demand Server, AS, Broadcast Server, Oracle 9.0, Worked on UNIX environment,VB.NET, JavaScript, Sql, Windows NT and XP.

Confidential

Hyperion Consultant

Responsibilities:

• Building up of Environments from the scratch in distributed environments.
• Installed configured Hyperion Essbase, Planning, Workspace, Smart view, and all the components successfully.
• As part of Quarterly password policy in the organization successfully configured all the products every time.
• Conducted weekly meetings on the performance and resolved performance issues successfully using various techniques.
• Successfully automated the daily Essbase backups on UNIX boxes using Autosys.
• Successfully migrated the various planning applications from lower environments to production both manually and using utilizes.
• Automated the Shared services securities backup regularly using the windows scheduler.
• Worked on XREF sequences to increase the performance of planning applications.
• Worked on migrating Hyperion applications from Tomcat to OAS.
• Identified and developed documentation for data processing system enhancements that improved the efficiency and effectiveness of the operating units
• Designed and implemented new reporting procedures using Microsoft access for our department, which assisted in increasing consistency
• Reduced production time by six hours on key monthly reports by gathering essential information more efficiently
• Installation of Essbase Administration Services, Essbase Integration Services, Hyperion Analyzer and Hyperion Application Link.
• Optimized and tuned existing Essbase applications to enhance application performance
• Restructured and redesigned previous Essbase cubes.
• Developed load rules for loading specific type of data files.
• Utilized MaxL, ESSCMDS to run calculation and report scripts and performance tuning of data load calc scripts.
• Developed detailed and summary reports using Cognos Impromptu and Report Studio.
• Created Metadata models using Cognos Framework Manager 1.1 and published published packages for reporting activity.
• Created a Template system where the field actually inputs data into an excel workbook that can send the numbers to Essbase and initiates a Calc script resulting in consolidated financials.
• Modified existing financial, marketing and other reports.
• Maintained hierarchies in Planning through HAL (Hyperion Application Link)

Environment: Hyperion Essbase, Hyperion Integration Services, Hyperion Administration Services, Hyperion Analyzer, Hyperion Planning, Workforce Planning, Excel Add-In, Visual Basic 6.0, MS Project, Oracle, Windows NT/2000

Confidential

Hyperion Consultant

Responsibilities:

• Developed project plans for implementations detailing schedule, tasks, milestones, and requirements.
• Created dimension building load rule and data load Rule for dynamic dimension building, attribute dimension building and data loading in Essbase.
• Performance tuning using dense/spares settings.
• Developed the required alternate rollups for reports.

Environment: Hyperion Essbase 7.1/6x, Essbase Integration Services 6.5.4, Microsoft Excel 2000, Oracle 9i, Windows NT 4.0, ESSCMD, Maxl, Excel Add-In.