We provide IT Staff Augmentation Services!

Lead Hyperion System Administrator Resume

Pittsburgh, PA

SUMMARY:

  • 9+ years of IT experience and 7 years of experience maintain/Administration of Hyperion products.
  • Superior Knowledge of Maintaining the Hyperion Suite (Planning, Capex, workforce, Strategic finance, EAS, EIS, Essbase Studio, Financial reporting, Interactive reporting, SQR, Dash Board, HFM, FDM, DRM, Financial Close Management, Disclosure Management, Performance Score card, Smart Space) Of System 11(11.1.1.3 and 11.1.2) under Windows 2003/2008/NT4.0 and Unix environment.
  • Superior Knowledge of Maintaining the Hyperion Suite (Planning, Capex, Workforce, Strategic finance, EAS, EIS, Financial reporting, Interactive reporting, SQR, Dash Board, HFM, FDM, DRM) Of System 9 under Windows 2003/2008/NT4.0 and Unix environment.
  • Worked with Client Installs/Issues With Excel add-in, Smart view, HFM, FR, IR, Workbench (FDM) and ODI.
  • Knowledge of Hyperion System 11 (Oracle EPMA System 11). Which is know as Fusion version
  • Extensive experience on the installation, document installation and configuration of Hyperion products Suite on both Windows and UNIX environments.
  • Extensive knowledge of upgrade between different versions of Hyperion Suite.
  • Extensive Knowledge with deployment using Web logic, Tomcat, IIS and Oracle application server.
  • Experience with SSO
  • Knowledge of Install/Maintain/Administration of OBIEE
  • Knowledge of Apache web server.
  • Extensive knowledge of LCM (Life Cycle management).
  • Migrated the artifacts from One environment to other using LSM.
  • Expertise in Installation and Maintained Oracle data integrator (ODI).
  • Validated the logical and physical architecture in ODI topology and context models.
  • Responsible for viewing and managing production integration jobs using ODI Operator.
  • Monitor ETL ODI Jobs and provided On-Call support in Trouble shooting and debugging.
  • Worked with ODI Graphical Modules (Designer, Topology Manager, Operator, Security Manager)
  • Used ODI Security Manager for adding users and maintaining and restricting their privileges depending on the role of a team member.
  • Knowledge of ODI Development.
  • Coordinated monthly accounting close process managed administration of the Hyperion system (Essbase, Planning, HFM) infrastructure to ensure a stable, optimized financial planning and reporting environment.
  • Managing applications, databases, backups and restore; managing user security in shared services.
  • Strong working knowledge of Hyperion System 9 Suite, System 11(11.1.1.3 and 11.1.2).
  • Proficient in batch scripting, UNIX Shell scripting, C++ programming, Excel VBA coding, PL/SQL scripting, software installation, system upgrade and server maintenance, application and data back-ups and security.
  • Decisive with strong leadership qualities and flexible in work schedules.
  • Responsible for Migration of application from One Environment to other.
  • Responsible for looking into the performance issues, Disc space.
  • Responsible for applying the needed Patches.
  • Knowledge of implementing the Perl script to take the Backup.
  • Expertise in Setting up of Cluster system for Fail Over and maintaining the Active/Passive structure.
  • Knowledge of Change management for the System/Infrastructure Changes.
  • Maintained the SLA (Service Level Agreement).
  • Involved in Life cycle of Hyperion product implementation.

TECHNICAL SUMMARY:

OLAP Tools: Hyperion System 11.x/9.3.1 BI+(Financial reporting, Interactive reporting And SQR), Hyperion System 11.x/9.3.1 Analytic Administration Services, Hyperion Planning 11.x/9.3.1.x, Hyperion System 9 Application Link (HAL), Essbase 11.x/9.3.1.x/7.x/ 6.5/6.2/5.0, Hyperion Enterprise, Hyperion Essbase Administration Services console (EAS), EIS 11.x/9.3.1.x, Performance Score Card, Essbase studio 11.x, FDM 11.x/9.3.1.x, HFM 11.x/9.3.1.x, DRM 11.x/9.3.1, Hyperion Data Integration Management (DIM). Dimension Modeling: Star-Schema Modeling, Erwin Snowflake Modeling, Fact and Dimensions Tables. Databases: Oracle 10g/9i/8i, DB2 UDB, MS SQL Server 2005 and MS Access. ETL Tools: DataStage7X, Informatica 7.1, ODI Languages: SQL, PL/SQL, Perl. Operating Systems: MS-DOS, UNIX AIX and Windows NT 4.0/XP/2000/2003/2008. GUIs: Visual Basic 6.0/5.0, VB.NET and TOAD. Reporting Tools: Hyperion Analyzer 11.x/7.x/6.x/5.x, Hyperion Financial Reports 11.x/9.x/7.x/2.x, Smart View, Essbase Excel Add-in

CERTIFICATION: Certification In Essbase 7.x Certification in Hyperion Financial Management9.3 Administrator Certification in Hyperion BI+ 9.3 Administrator Certification in Hyperion Planning 9.3 Administrator

EXPERIENCE:

Confidential 03/08 - Till Date

Lead Hyperion System Administrator My role in Fannie Mae is to lead the Hyperion support (Which is Know as FAPT HYPERION SUPPORT). I'm purely responsible for supporting the Production Environment.

  • Upgraded Hyperion 7.x to 9.3.1
  • Acted as architecture in designing the Environment.
  • Analyzed Issues in 9.3.1 and applied needed Patch sets.
  • Upgraded Hyperion from 9.3.1 to 11.1.1.3
  • Analyzed Issues in 11.1.1.3 and applied needed Patch sets.
  • Installed 11.1.2
  • Upgraded Hyperion from 9.3.1 to 9.3.3
  • Installation/Configuration of Smart Space.
  • Install/Maintain/Administer OBIEE.
  • Involved in Project design.
  • Knowledge of Improving Performance Tuning for all the Hyperion Products.
  • Worked Closely with Hyperion support Development team in fixing the Issues.
  • Supporting the End users on Client install issues. Tracking the issues with Incident management tickets.
  • Creation and Maintain of Planning, Essbase, HFM and FDM application.
  • Responsible for Migrations.
  • Performance tuning and Optimization of the Applications for the fast data loads, better calculation times of the cubes and fast retrieval of the reports using the Dense/Sparse settings, Cache settings.
  • Infrastructure Support - Server Maintenance like File system Space Management, moving Backups to staging server, Exports and OS as well as Hyperion Patches.
  • Functioning as a single point of contact for the clients/BPO's on all production related support and maintenance issues.
  • 24/7 on call support.
  • Maintenance of user security and troubleshooting user access issues as they arise.
  • Backup and Recovery of Hyperion applications. Scheduling daily backups.
  • Monitoring the current Production environment servers for performance and stability.
  • Maintenance and Support for Essbase, HFM and FDM, Planning Applications and Other Hyperion Products.
  • Participated in the application testing, while monitoring the system performance, thereby reporting any anomalies in the application.
  • Defined and documented the steps to migrate applications in the Hyperion Planning, Essbase, HFM and FDM between Prod, QA, and Dev environments.
  • Worked with Hyperion Support on a number of issue resolutions.
  • Involved in design and development of HAL to ODI conversion.
  • Customized the Knowledge Modules as per the Requirement.
  • Scheduling the ODI jobs using ODI scheduler.
  • Has very goo Experience with TRAM (Security issues finding).
  • Knowledge of SOX compliance.
  • Helping the users with Testing and Loading the data using ODI.
  • Maintained the resources for Support.
  • Developed Scripts for routine administration tasks like backup, purging app/server logs.
  • Performance tuning and Optimization of the Applications for the fast data loads, better calculation times of the cubes and fast retrieval of the reports using the Dense/Sparse settings, Cache settings, Outline formulas.
  • Backup and Recovery of Hyperion applications. Scheduling daily backups.
  • Experience on Disaster recovery and contingency.
  • Experience with Change/Incident/Problem Management.
  • Worked with ODI Graphical Modules (Designer, Topology Manager, Operator, Security Manager)
  • Defined data stores, interfaces and packages in ODI Designer.
  • Involved in maintaining and creating new data servers, connections for different data sources through the Topology manager. Created data servers for sources that included Flat files and SQL Server sources.
  • Validated the logical and physical architecture in ODI topology and context models.
  • Responsible for viewing and managing production integration jobs using ODI Operator.
  • Monitor ETL ODI Jobs and provided On-Call support in Trouble shooting and debugging.
  • Created Complex ODI Interfaces which involved slowly Changing Dimensions (SCD) to implement Business Logic and capturing changed records in the source systems
  • Implemented Best Practices using ODI
  • Responsible for viewing and managing production integration jobs using ODI Operator.

Environment: Hyperion Essbase 7.x/9.3.1/11.1.1.3/11.1.2, Planning 9.3.1/11.1.1.3/11.1.2, Hyperion Reporting & Analysis 9.3.1/11.1.1.3/11.1.2 (FR, WA, IR, Workspace), Hyperion Shared Services 9.3.1/11.1.1.3/11.1.2, HFM 9.3.1/11.1.1.3/11.1.2, FDM 9.3.1/11.1.1.3/11.1.2, Weblogic 9.1/9.2/11g, Oracle 9i/10g/11g, Oracle Application Server 10g, Windows 2000/2003/2008 server, Windows 2003 server IIS, EIS 9.3.1/11.1.1.3/11.1.2,Essbase Studio 11.1.1.3/11.1.2, Performance Score Card, HAL, ODI 10.1.3.5/10.1.3.5.6/11g,Toad 9.0, Putty, Smart view 9.3.1/11.1.1.3/11.1.2, Excel Add-In 9.3.1/11.1.1.3/11.1.2 ,Smart Space 9.3.1/11.1.1.3,DRM 9.3.1/11.1.1.3/11.1.2,Clarity 6.x, Strategic Finance 9.3.1/11.1.1.3/11.1.2,IIS 6 and IIS 7.

Confidential. Nov 06 to 02/08 Pittsburgh, PA Hyperion DBA

Senior Hyperion Admin

Confidential implemented Hyperion BPM suite of applications globally for their BU and Corporate Planning & Forecasting needs. This is the one of the biggest Hyperion implementations using almost all the Hyperion BPM suite products viz. Hyperion Planning, Hyperion Essbase, Financial Reports, Web Analysis, FDM, EIS, and HFM. The actual data from OLTP systems was collected, cleansed, transformed into Data warehouse build using Oracle Apps. Hyperion Planning applications were developed at BU level for department level Planning and one at Global level which consists of all the BU data at certain high level. Again once Planning or forecasting is complete in BU applications, they push forecast data into GDW at certain high level. This is loaded into Global Planning application for corporation planning and reporting needs.

Technical Support and Administration of Existing applications:

  • Creation and maintenance of Essbase cubes.
  • Creation and Maintain of Planning, HFM and FDM application.
  • Responsible for Migrations.
  • Performance tuning and Optimization of the Applications for the fast data loads, better calculation times of the cubes and fast retrieval of the reports using the Dense/Sparse settings, Cache settings, Outline formulas..
  • Developed a custom program to report on user/group access information and disabled users in Hyperion Shared Services.
  • Managing hierarchy changes as part of COA (Chart of Accounts) process as well as updating calc scripts, business rules, web forms and reports according to changes.
  • Infrastructure Support - Server Maintenance like File system Space Management, moving Backups to staging server, Exports and OS Patches.
  • Developed Maxl/Shell scripts with combination of Perl for routine administration tasks like backup, scheduling calcs on server, purging app/server logs, data export/imports.
  • Functioning as a single point of contact for the clients/BPO's on all production related support and maintenance issues.
  • Maintenance of user security and troubleshooting user access issues as they arise.
  • Backup and Recovery of Hyperion applications. Scheduling daily backups.
  • Converted more than 4 BSO cubes into ASO and regular support for ASO applications like hierarchy changes and data loads.
  • Monitoring the current Production environment servers for performance and stability.
  • Maintenance and Support for Essbase, HFM and FDM Applications.
  • Participated in the application testing, while monitoring the system performance, thereby reporting any anomalies in the application.
  • Performed UNIT testing and USER ACCEPTANCE TESTING (UAT) the final step before Rolling out of the Application.
  • Defined and documented the steps to migrate applications in the Hyperion Planning, Essbase, HFM and FDM between Prod, QA, and Dev environments.
  • Worked with Hyperion Support on a number of issue resolutions.
  • Documented all the application and user issues and the corresponding resolutions in order to facilitate easy knowledge transfer.
  • Installation, configuration and Administering of TempDR and DR environments.
  • Handling infrastructure related tickets.
  • Keeping all the environments in sync.
  • Applying the latest Hyperion Products related patches (If necessary).
  • Planning administration for particular planning cycle
  • Production migration and support
  • Training end users
  • Installing Required Clients (Excel, SV, HFM, FR etc).
  • Troubleshooting the Client install issues (Excel, SV)

Environment: Hyperion Essbase 9.3.1.x, Planning 9.3.1.x, Hyperion Reporting & Analysis 9.3.1.x (FR, WA, Workspace), Hyperion Shared Services 9.3.1.x, HFM, FDM, Web logic 9.1, Oracle 9i/10g, Oracle Application Server 10g, Windows 2000 server, Windows 2003 server IIS, EIS 9x/9.3.1 & HAL, Toad 9.0, Putty, Smart view, Excel Add-In 9.3.1.x

Confidential,June 05 to Oct 06 Indianapolis, IN Hyperion Technical Administrator

Confidential is a cell phone manufacturer located in Indianapolis implemented Hyperion System 9.3.1 suite of products for various applications. The environment includes 3 Planning applications, 3 native Essbase applications, 1 HFM application and, 2 FDM applications, 1 strategic finance applications. There are around 1000 users across the globe. Responsibilities:

  • Installation and configuration of Hyperion Products.
  • Applying Hyperion security patches.
  • Technical troubleshooting and maintenance.
  • Upgrade of Hyperion Essbase, planning, HFM and BI+ Financial reports, Web Analysis reports.
  • Testing of the tools after the upgrade.
  • Trouble shooting the migration and technical issues, escalation to Hyperion.
  • Patch installation for Bugs
  • Preparation of startup and other maintenance scripts.
  • Documenting the processes and installation steps.
  • Designing and development of the planning application model and outline.
  • Meta data management in custom dimensional repository.
  • Setting up security in planning and assigning access to Forms, Rules and Reports.
  • Migration of planning applications from Test to Production.
  • Design and development of financial reports on this Planning application.
  • Testing, documentation and user training.

Environment: Microsoft 2003 Windows Server, Hyperion System 9.3.X,7.X EIS, DIM, BEA Weblogic 8.1/9.1, Strategic Finance, HFM, FDM

Confidential, Minneapolis, MN Aug 04 to May 05 Hyperion Technical Consultant Confidential is one of the Largest health insurance provider in US.This project is to implement new Hyperion Planning application and provide support for existing Planning and Reporting applications. Responsibilities:

  • Closely worked with the functional and the business analyst team during the pre-implementation phase of the applications.
  • Developed Planning dimensions and Essbase outline
  • Developed Planning Workflow and task flows.
  • Developed Essbase calc scripts and partitions.
  • Develop Essbase reporting cube on top of planning cube.
  • Defined and setup the application security in Hyperion Planning, Hyperion Essbase, HFM and Essbase Integration Services.
  • Developed Cron-scripts in Solaris and windows for the building of the application.
  • Setup automated scripts for weekly backup of the application.
  • Participated in the application testing, while monitoring the system performance, thereby reporting any anomalies in the application.
  • Performed UNIT testing and USER ACCEPTANCE TESTING (UAT) the final step before Rolling out of the Application.
  • Defined and documented the steps to migrating applications in the Hyperion Planning, Essbase as well as the HFM environments in Prod, QA, and Dev.
  • Migration of Planning Applications from Test to Production.
  • Closely worked with business users across the globe to troubleshoot and resolve issues as and when they surfaced.

Environment: Hyperion Planning 7.x, Hyperion Essbase 7.x, EAS 7.x, Hyperion Reports 7.x, Essbase Add-in, Smart View, HFM Add-in, HFM 4.x, Oracle 9i/10g, Solaris, Windows 2000 Advanced Server, Windows 2003, Veritas Cluster Manager, IBM Websphere, Eclipse, and Apache Tomcat.

Confidential, Jan 04 to Jun 04 Columbus, OH Hyperion Administrator

This is a Hyperion Planning implementation project for Cardinal Health Corporate planning, Forecasting & Budgeting needs. Developed Planning models (Sales, payroll, Capex and Main) by replacing the existing Spread sheet models. Actual data from EDW, JDEdwards and Peoplesoft has been transformed using Informatica and fed to these Planning applications through HAL. After input and calculations are completed the data in other applications will be consolidated to main application that will be used for balance sheet calculations and Budget Reporting. I have been involved in full life cycle of the project starting from requirements gathering.

Responsibilities:

  • Migrated existing applications from Hyperion Essbase 6.5.4 to Hyperion System 9 Environment
  • Integrated the Hyperion System 9 environment with the Microsoft Active Directory application of VSD and designed the security of Essbase applications in the new environment.
  • Testing, documentation and user training.
  • Installation of Hyperion software on Windows servers.
  • Development of Planning Web forms and dimensions.
  • Development of few Business rules and Calc Scripts.
  • Development of interfaces using DIM tool.
  • Setting up security in Planning and assigning access to Forms, Rules and Reports.
  • Migration of Planning applications from Test to Production.
  • Design and development of financial reports o this Planning application.

Environment: Hyperion System 9, Hyperion Essbase 9.2.3, Analytic Administration Services 9.2.3, Hyperion Financial reporting 9.2.3, Essbase excel Add-in 9.0, Hyperion Smart view 9.2, MDM, Clarity 6, Oracle 9i/10g, HP UNIX, Windows 2003 Advanced server, IBM Web sphere, Ascential Data stage 7.x, Hyperion Interactive Reporting

Confidential,Feb 03 to Dec 03 Houston,TX Hyperion Administrator/Developer

This is a Hyperion implementation project for Energy Financial Services (EFS) a business unit of GE Commercial Finance for Planning, Consolidation & Reporting needs. Developed two planning models (BU Plan & Consol) and one Essbase model (Closing) for aggregation and Reporting. BU plan contains descriptor level accounts and is for business planning and forecasting during different planning cycles. Closing model has been designed mainly for data aggregation and Reporting of actuals at detail level. GL data feed comes from Closing to Plan Model. At the end of each Plan cycle plan data will be fed to Closing model. Consol model is mainly for Consolidation of BU plan and Actual data for variance analysis and data submission to corporate model. I have involved in BU Plan and Closing models.

Responsibilities:

  • Involved in all phases of the development during the implementation.
  • Involved in analysis and design of Web forms and Reports
  • Developed various number of Web forms depending on plan cycles and several FP&A/OTC reports for Variance Analysis
  • Development of Business rules for Taxes, New volume and Expenses.
  • Involved in design of Hal routines to load metadata using planning adapter.
  • Developed several Maxl scripts for automation of the processes.
  • Setting up security in Planning and assigning access to Forms, Rules and Reports.
  • Involved in developing drill down and dashboard Reports using Analyzer.
  • Experience in Testing, documentation and user training.
  • Backup and Recovery.

Environment: Hyperion Essbase 6.5, Windows 2000, Oracle 9i, SQL, PL/SQL, Reports, Essbase, TOAD

Hyperion Consultant Built three-cubes (finance cube, management cube and inter-company cube) using People Soft process and Essbase integration services tool for outbound reporting. Details available upon request Environment: Hyperion Essbase V6.5.1 / 6.5.4, Hyperion Reporting V2.5 / 2.6, Oracle 9.i, Hyperion Analyzer 6.0, Windows NT, Essbase integration services, Web logic server, Excel Add-in

Confidential Admin Details available upon request Environment: Hyperion Essbase V6.2/6.5.1, Hyperion Reporting V/1.7/2.0/2.1, Oracle, Hyperion Analyzer, Windows NT, Hyperion Planning 3.0, HAL, Unix, Web logic server, Excel Add-in

Confidential Admin Details available upon request Environment: Hyperion Essbase 5.x/6.5.X/6.1, Essbase Integration Services 6.5, Oracle8i, Windows 2000/ SUN Solaris 7

Confidential Software Developer Details available upon request Environment: Visual Basic, Crystal Reports 6.0, Oracle 7.3, Windows 98/NT

Confidential Oracle Developer Details available upon request Environment: Developer 2000, PL/SQL, SQL, Oracle 7.3, Windows NT

Hire Now