We provide IT Staff Augmentation Services!

Senior Hyperion Resume

CT

SUMMARY OF QUALIFICATIONS

  • Over 8 + years of IT experience with over 7 + years of experience as a Hyperion consultant, Extensive hands on technical experience in many aspects of Data Warehouse and OLAP software systems Administration, design and implementation.
  • Extensive experience in the development, design, analysis and Implementation of various applications using Hyperion System 11 and system 9 ,Hyperion Essbase 7.X/6.X, Essbase Integration Services, Hyperion Analyzer, Hyperion Financial Reporting Studio, Hyperion Planning,Workforce Planning, Essbase, Smart view and Spreadsheet Add-In on Windows 2000/NT
  • Responsible for security groups and access for the users in Financial Reports and Hyperion System 9 and system11 Planning.
  • Experience in design, analysis, development and implementation of various applications in Client/Server OLAPenvironment using, Hyperion System 11 and 9(BI), Hyperion Essbase, Hyperion Analyzer, Hyperion Reports, Hyperion Planning, Analytical integration Services.
  • Strong database development and business intelligence modeling capabilities; Essbase calculation script knowledge, creating rule files, Process automation and data loading, dimension building.
  • Strong knowledge of Financial Domain applications and Functional analysis for Planning, Budgeting and forecast applications.
  • Proficient in the Star and Snowflake Schema data modeling technique used to design for data warehouse and data mart.
  • Extensive experience on the installation,configuration, server settings, backups, client and server installations of Hyperion products such as Essbase, Essbase Integration Services, Essbase Analyzer and Hyperion Reports.
  • Experience with the entire Microsoft Office Professional .

OLAP Development Tool

Hyperion System 11 and system 9.3,Hyperion Essbase 7.0/6.x, , MS Excel spreadsheet add-in

ETL Tools

Oracle Warehouse Builder, ODI

Business Intelligence Tools

Hyperion Planning system11 and 9.3.x, Hyperion Analyzer 7.x/6.x, Financial Reports, H.A.L, Hyperion Enterprise Services.

Operating Systems:

MS-DOS, UNIX, WINDOWS 98/2000/NT 4.0/XP

Databases

Oracle 11i/10i/9i, MS SQL Server 2000.

Hardware Platform

Linux, SUN Solaris, Windows 2003/2008/NT Servers

Languages

PL/SQL,C/C++, SQL, HTML, XML, ASP.

Web Design & other tools

HTML, MS FrontPage, Dream Weaver, Macromedia Flash, MS Office2003.

Dimensional Modeling

Star-Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables, Physical and logical data modeling.

Process/Modeling Tools

System Development Life Cycle, MS Visio, Rational Rose, ERWin4.0.

Project Management

MS Project 2000/2003

Reporting Tool:

Hyperion Financial reporting studio, Hyperion work space.

PROFESSIONAL EXPERIENCE

Client: Confidential, CT August2011-June 2012
Senior Hyperion Developer
Project Summary:
GE is a diversified global infrastructure and Finance Company serving customers in more than 100 countries and employs approximately 300,000 people worldwide. The project involved new implementation of Hyperion 11.1.2.1 at Enterprise level and migrating data from existing Business Object application to Hyperion Planning. . I was responsible for the design and development of several
Web forms and Reports used for corporate budgeting and forecasting.

Role & Responsibilities:

  • Actively interacted with Functional user for functional requirements gathering, design and implementation of Hyperion Planning.
  • Worked on Data Mapping for creating of Webforms and Reports.
  • Created Meta data on Hyperion planning for Actual and Budget Data.
  • Developed Web Forms, Composite Web Forms, Menu, Task Lists, and User Variables based on the Functional and Technical Requirements requested by the business.
  • Created users and user groups in the Planning applications and assigned security to web forms.
  • Performed the performance tuning by using the Dense/Sparse settings and developed the required alternate rollups for reports.
  • Created Business Rules using calculation manager to assign them to Planning Web forms and also to launch them on demand.
  • Developed over 50 reports for different group of users using Hyperion Financial Reporting studio.
  • Worked on architecture of Hyperion Workspace and shared services related to groups and security.
  • Responsible for implementation, migration and technical-support for Hyperion planning Web forms and Hyperion web reports.
  • Migrated Hyperion applications, cubes, repositories, or artifacts across different Environment via Hyperion LCM tool.
  • Created Batch reports and automated the batch with bursting feature for wide distribution.
  • Installed Hyperion Planning software and designed a design document on Hyperion Planning for the end users, how to work with forms, and how to manage the workflow.
  • Conducted Parallel testing, UAT.
  • Provided training to end users in using the MS Excel SmartView to load data and the basic concepts of multidimensional databases.
  • Worked in support team to resolve many production issues.

Technology/Platform: Hyperion Essbase System 11.1.2.1, Hyperion Planning 11.1.2.1, Hyperion financial Reporting Studio 11.1.2.674, Hyperion Workspace 11.1.2.1, Smart view, Microsoft Excel 2010, , Window 2003 Server, Solaris.

Client: Confidential, NJ Feb 2009 - July2011
Hyperion Developer

Project Summary:

  • Integrate planning, Budgeting, Forecasting and performance measurement on enterprise-wide basis and improve accuracy of forecast.
  • Four main planning applications and 2 Essbase applications were developed to track forecast and budgets.
  • Developed various reports for different group of users using Hyperion Financial Reporting studio.
  • Responsible for implementation, migration and technical-support for maintaining Hyperion Essbase production and Development servers.
  • Working offshore and supporting CBS clients through WebEx, GoToAssist or other remote desktop tools.
  • With the leadership qualities and also as a versatile team player in the migration team
    worked with other analysts to understand requirements, specifications, testing strategies and also for planning the project time line for migration.

Role & Responsibilities:

  • Created Planning and Essbase applications in Hyperion System 9.3 and system11, Created scripts in MAXL for dimension building and data loading and automated them.
  • Security setup on planning application and reports.
  • Performed product wide migration of Hyperion Essbase Version 9.3 to 11.2.0 and also system 9.3.1 Implemented application security process, created users/groups, security profiles and
    application access to different groups using filters.
  • Followed Software Development Life cycle of developing new cubes and redesigning and restructuring the existing cubes.
  • Production Support for Hyperion Financial reporting, Planning applications, Actuals and Budget data processing, migration and security related operations.
  • Work with "Budget Team" to identify reporting requirements and translate requirements into developing the right solution for user analytical / reporting solutions.
  • Develop and implement disaster recovery strategy.
  • Develop business rules and calculation scripts to improve the functionality for budget analysis, currency conversion and consolidation.
  • Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion. Developed Aggregate Storage Cubes using Hyperion System 9.3.
  • Installed Hyperion Planning software and designed a design document on Hyperion Planning for the end users, how to work with forms, how to create business rule, and how to manage the workflow.
  • Used Hyperion Reporting studio to generate various kinds of Annual and Quarterly Financial reports.
  • Used Hyperion Scheduler to schedule various reports on day to day basis.
  • Developed Multiple Web forms for data input and Reports on demand.

Technology/Platform: Hyperion Essbase System 9, Hyperion Planning 9.3, Hyperion 9.3 BI+ (Financial reporting Studio, Workspace, Web Analysis) Financial Reports 9.3 , Essbase Integration Services 6.5.4, Microsoft Excel 2000, Oracle 10i, Windows 2003 Server, UNIX.

Client: Confidential, VA April 2007 - Dec 2008
Hyperion Essbase Consultant / Functional Analyst

Project Summary: The main goal of project was to integrate scattered data in spreadsheets and an Oracle database into Essbase Applications. The Secondary task was integration of all the servers with MDM so any modification in hierarchies can be made from MDM services. And further use it for reporting using the analyzer. As part of a team of 4 we worked together to develop several applications in Essbase. I was involved in the complete Software Development Life Cycle of both the applications which involved in the different phases of the SDLC: Development, Testing, and Production. I was solely responsible for the design and development of several cubes used for reporting related to strategy and business collection respectively. The strategy and business collection cubes were used to generate reports to aid decision making related to receivables management, business collections, and fraud management. I was also generating ad-hoc reports on my cubes as well as on others on a regular basis using Analyzer.
Role & Responsibilities:

  • Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass and stick fashion.
  • Developed application in Hyperion System 9.2
  • Installed Hyperion Planning software and Essbase integration services, for the end users, how to work with forms, how to create business rule, and how to manage the workflow.
  • Created scripts in MAXL for dimension building and data loading and automated those processes
  • Used Master data management software to configure, import, export, and integrate dimensional and master data across BI, data warehouse, financial & operational systems, providing for accurate, consistent and compliant enterprise reporting.
  • Involved in creating Rule files and batch files to automate the data load process.
  • Created wrapper scripts (.ksh) to automate all the variables and all the (.scr) scripts.
  • Developed Data Loads and numerous Calc Scripts and optimized them.
  • Designed and developed optimized Essbase applications.
  • Created OLAP Model and Meta Outline for Essbase OLAP Server using Essbase Integration Services. Loaded data using Essbase Integration Services (EIS).
  • Generated reports relating to strategy, fraud, collections and accounts receivables using Hyperion Analyzer 6.5.
  • Actively participated in defining requirements, functional specifications, designing documentations and testing strategies.
  • Provided training to end users in using the MS Excel spreadsheet add-in to load data and the basic concepts of multidimensional databases.
  • Implemented Data Access layer to Communicate with the Oracle Database.

Hyperion Planning:

  • Installed and upgraded Hyperion Planning applications.
  • Created and mapped HAL jobs to load the hierarchies into different planning applications.
  • Worked as an administrator to give access and privileges to various end users in different planning applications, and synchronizing the passwords during the Essbase logon, or using external provider in Essbase.
  • Created and managed numerous Data entry forms and Created many Business Rules for several applications.
  • Worked with Hyperion Planning in developing web-based forms for the various budgeting purposes.
  • Created various Reports in Hyperion Reports.

Technology/Platform: Hyperion Essbase System 9, Hyperion Analyzer 7.0, Hyperion Planning 3.5.1, Hyperion Reports 7.1.2 , Essbase Integration Services 6.5.4, Microsoft Excel 2000, Oracle 9i, Windows 2000 Advance Server, UNIX.

Client: Confidential, India May 2006 - March 2007
Hyperion Essbase Developer

Confidential, India\'s largest pharmaceutical company, is an integrated, research based, international pharmaceutical company, producing a wide range of quality, affordable generic medicines, trusted by healthcare professionals and patients across geographies. Ranbaxy today has a presence in 23 of the top 25 pharmaceutical markets of the world

Project Summary: RANBAXY required to analyze Budget, collect quarterly forecasts and provide insight into operational aspects of the business. Worked on design and development of different cubes used for creating reports about various business strategies, decision-making and future planning.

Role & Responsibilities:

  • Designed and developed numerous Essbaseapplications in system 9.0.
  • Interacted with users to support analysis and provide definition and requirements for the Financial Management reporting and other Essbase supported processes.
  • Created many groups and users for different business segments and then assigned security and filters to define Essbase privileges on them.
  • Installed and set up the server with Hyperion Essbase, Hyperion Analyzer, HAL. Developed Aggregate Storage Cubes using Essbase system 9.
  • Set up the server settings, optimized different Essbase objects, and implemented partitioning among different production cubes to improve performance of all the Essbase applications.
  • Actively participated in defining requirements, functional specifications, designing documentations and testing strategies.
  • Provided training to end users in using the MS Excel spreadsheet add-in to load data and the basic concepts of multidimensional databases.
  • Developed automation scripts for application refresh and back ups using Hyperion Essbase Esscmds and MaxL.
  • Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion. Developed Aggregate Storage Cubes using Essbase 7.1.
  • Installed Hyperion Planning software and designed a design document on Hyperion Planning for the end users, how to work with forms, how to create business rule, and how to manage the workflow.
  • Interacted with end users and developed numerous Business Rules in Hyperion Planning.
  • Involved in gathering requirements and developing a project plan.
  • Involved in gathering data and supervising data load.
  • Involved in creating Rule files and batch files to automate the data load process.
  • Developed Data Loads and numerous Calc Scripts and optimized them.
  • Implemented robust data-access security and user management.
  • Developed Excel Templates for user interface in Essbase database
  • Created OLAP Model and Meta Outline for Essbase OLAP Server using Essbase Integration Services. Loaded data using Essbase Integration Services (EIS).
  • Generated reports relating to strategy, fraud, collections and accounts receivables using Hyperion Analyzer 6.5.

Client: Confidential, India Jan 2005 - March 2006
Oracle Developer
Role & Responsibilities:

  • Designed and developed Graphical User Interface using Forms.
  • Developed the PL/SQL stored procedures for implementing the business logic.
  • Developed the on-line context-sensitive user help.
  • Development of reports (stores ledger, invoice preparation) using reports 3.0
  • Developed test plans for invoice, order entries, billing, shipping, and Stock maintenance.
  • Conducting Functional testing, System testing and GUI testing.
  • Tested the functionality by creating dummy transactions.
  • Manually tested different reports generation.
  • Created Packages, Procedures and Functions.
  • Configure Oracle Clients on Win NT Workstations.
  • Creating Complex Stored Procedures, Functions and Packages.
  • Developing Oracle Schema Design and Table Structures.
  • Constructing Oracle Database Triggers and Indexes. Code Reviews, PL/SQL Code Tuning and Plan SQL.
  • User Management; Create, Modify and Delete user accounts.
  • Grant Roles and Privileges to Users.

Environment: Developer 2000, PL/SQL, SQL, Oracle 9, and Windows NT

*References available on request

Hire Now