We provide IT Staff Augmentation Services!

Sr.hyperion Consultant Resume

Foster City, CA

SUMMARY:

  • Around 8 years of professional experience in IT of which more than 6+ years of expertise in the area of Data Warehouse and OLAP software systems design and implementation specifically in the implementation and maintenance of Oracle EPM’s applications (HFM, FDQM, Essbase and Planning).
  • Expertise in a range of Hyperion products including Essbase, Hyperion Financial Management, Hyperion Planning, Smart View and Spreadsheet Add - In
  • Proficient in Hyperion Financial Management (HFM) V9.3/11.1 Application Creation (Classic & EPMA),Hyperion financial management Data Grids, DRM, Data Forms, Security Class, Metadata Maintenance, Task List, Member Lists, Data Loads, inter-company eliminations, Plug Accounts, Journal Adjustments &running Consolidations, Calculation Manager/ Rules Editor for managing Rules.
  • Strong Financial knowledge: US GAAP, Accounting Close activities, Financial Statements analysis.
  • Proficient in loading, reconciling, consolidating key Financial Data with Hyperion using Financial Data Quality Manager (FDQM) and HFM consolidation, validation and execution
  • Skilled in data modeling technique using Snowflake and Star Schema for designing data warehouse and data mart.
  • Strong Database Administration skills with Oracle 8i, 9i, 10g, 11g. MS SQL Server.
  • Experience in managing FDM applications used to load data into HFM,strong understanding of key aspects of FDM application namely Application Integration with HFM,Control Tables, Location setups, Workflow, import scripts, built import formats using format build, managed batched processing (single load processing) loading data from 400 locations for CISCO global entities, scheduling batch scripts using task manager, FDM reports.
  • Strong expertise in Batch Scripting, Calc Scripting, software installation, system upgrade, server maintenance, data back-ups and security.
  • Skilled in Architecture design and maintenance of numerous applications of Essbase Cubes using Block storage (BSO) and Aggregate storage (ASO) Essbase Kernels.
  • Experience in implementing full lifecycle projects starting from requirement analysis, design, development, unit testing, system testing, integration testing, user acceptance testing etc.
  • Extensive experience in creating, maintaining, and supporting all application objects including outlines, formulas, calculation scripts, rules files for dimension builds and data loads, caches, and security profile through Analytical Administration Services (AAS) and MaxL scripts. Also involved in automation of these procedures using Batch Scripts.
  • Extensively used Oracle's Hyperion® Workspace, to provide the user interface for viewing and interacting reports using Hyperion Financial Reporting Studio & Hyperion Web Analysis and enabling users to create queries against relational and multidimensional data sources.
  • Skilled in optimization and performance tuning of Essbase application data/metadata processing, upgrading, testing and migration of cubes in different environment.
  • Created several kinds of Database Backups like Physical, Logical and through Life Cycle Management.
  • Expertise in Creation and Maintenance of Hyperion Planning applications, Business Rules, Web forms, Security Groups and Users etc.
  • Proficient in software documentation, technical report writing, decisive with strong leadership qualities, flexible in work schedules.
  • Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment. Strong communication, organizational and interpersonal competencies along with detail-oriented and problem solving skills.

TECHNICAL SKILLS:

Operating Systems: Windows XP, Window 2000, 2003 MS-Dos, OS/400, UNIX, Linux (RHEL6/5)

Domains Oriented: Telecom services, Banking, Financial, Health Care

ERP: SAP, People soft, Oracle Financials

ETL Tools: Informatica 8.1/7.1, Data Stage 8.x/7.x, Oracle Data Integrator 10g/11g, Oracle FDQM 11.1.x

Middleware: Web Logic, IBM’s Web Sphere, Java Web Server

Others: MS Project, MS Office, MS Excel, VB Scripting

BI Tools: Hyperion financial management 4.x/9.x/11.1.1.x/11.1.2.x,Hyperion planning 11.x/9.x/4.x/3.x, Essbase 11.x/9.x/7.x/6.x,Oracle Business Intelligence suite, Financial Reporting, Hyperion interactive reporting (BRIO) 11.x/9.x/8.x/6.x, Hyperion strategic finance (HSF) Hyperion financial management 4.x/9.x,Smart View, DRM, Essbase Administration services, Hyperion workspace, Hyperion shared services, Hyperion Reports 9.x/7.x/2.x, Excel Add- in, Essbase Studio, Hyperion Visual Explorer.

Databases/ERP: Oracle 9i/10g, DB2 8.0, MS SQL Server 2000/2005, Teradata V2R6,IBM AS/400

PROFESSIONAL EXPERIENCE:

Confidential, Foster City, CA

Sr.Hyperion Consultant

Responsibilities:

  • Worked with Subject matter experts (SME) and business analysts to gather the business requirements during development stages and prepared BRD and FRD
  • Involved in defining requirements, functional specifications, designing documentations and testing for creating budgeting and forecasting tool
  • Developed new Planning Application Matrix from scratch as per business requirement.
  • Extensive Dashboards were built providing easy access to the managers and executives to various reports usingHyperion Interactive Reporting Studio (Brio).
  • Involved in identifying what should be the master data and how it can be handled using DRM.
  • Used Web Analysis, Financial Reporting and Interactive reporting to prepare quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers.
  • Developed and Published Daily and weekly reports using Financial Reporting studio to the Senior IT Managers.
  • Published and scheduled handful of trending analysisdashboardsandreportsin Hyperion Workspace for the Strategic Finance team.
  • Developed customer user-friendly reports and graphs self-contained in financial models.
  • Designed Data Models were used to analyze many business issues and to integrate the strategic planning processes.
  • Created tables, charts, pivots, report, dashboards using Hyperion interactive reporting (BRIO).
  • Administered and knowledge on installation, configuration, and optimization of Hyperion Essbase, Planning, Financial Reporting, Interactive Reporting and Web Analysis.
  • Hyperion planning was used to create new web forms. The same was used to define business rules.
  • Created users and user groups in the Planning applications and assigned security to web forms.
  • Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion
  • Created business rules as per the business logic at workflow level and restricted user to input any wrong data, which minimized use of validation at DRM end and hence improving the tool performance.
  • Creating imports for one time build in DRM. Further, Creating Heir and version from the import file from stage Area.
  • Specific role as Essbase Administrator involved Shared Services security development for Essbase and Planning.
  • Setting up users and groups according to business department and assigning security to users and groups using Shared Services.
  • Developed Hyperion Business Rules with Run-time Prompts.
  • Was involved in Build Planning Model using EPMA.
  • Created simple and composite data forms using Hyperion Planning.
  • Created and executed calculation scripts related to budget, actual and forecasting data.
  • Implemented complex data-access security matrix for Essbase and Planning applications
  • Used LCM and other utilities to migrate applications from one environment to other
  • Automated the ETL activity of the Essbase and planning application using ODI and MaxL utilities.
  • Developed Excel Templates for user interface in Essbase database
  • Built several custom reports using Hyperion Financial Report 11.1.2.1 for corporate reporting processes (Monthly, Quarterly and annual) as well as for each business units.
  • Performed consolidation and reporting duties. Created and executed new financial reports and procedures using Interactive Reporting, Web Analysis & Hyperion Reporting Studio
  • Prepared templates for achieving quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers
  • Involved in Knowledge transfer and development transition to the other team members and to production team (onshore and offshore).
  • On time completion of all assigned tasks and desirables meeting the business expectations and timelines.

Environment: Hyperion system 11.1.2.1, Hyperion Essbase 11.1.2.1, Hyperion Financial Reports 11.1.2, Hyperion Interactive reporting 11.1.2.1, EAS 11.1.2, DRM, Hyperion Planning, Oracle 11g, Oracle SQL Loader, Windows 2000 Advanced Server, Linux.

Confidential, Princeton, NJ

Hyperion Planning/HFM Consultant

Responsibilities:

  • Created, configured, designed, and implemented new HFM and Planning applications in 9.3.1
  • Created, configured, designed applications in FDQM and ODI.
  • Loaded metadata into HFM application by creating load metadata file. And also created Application profile and assigned its frequencies and number of years.
  • Loaded data into HFM application by using ODI AND FDQM.
  • Registered HFM application with shared services and also assigned security class.
  • Managed metadata by defining Dimension and its attributes, Application settings, Account types, consolidation methods, currencies, Intercompany transactions.
  • Also Managed Member list, journals, Rules using Rules editor and Data forms.
  • Created data forms in HFM application using form builder for users to input the data. Also created data grids in HFM application for consolidating financial data. And used consolidation and forced consolidation method for consolidation method in HFM application.
  • Applied FDQM for imports, validations, exports, and checks on data with Hyperion Planning 9, HFM 9.3.1. Developed Planning data forms, involved in initiation of budgeting process, setup of Planning calendar, setup of currencies and exchange rates, customization of reports, and development of alias tables.
  • Creating business rules using validations and verification in MDM/DRM.
  • Applied Hyperion Financial Reporting to design specific financial reports to serve management requirements.
  • Developed security management (user management) on Hyperion Financial Data Quality Management (FDQM).
  • Done all Data Modeling using FDQM, like importing source data, validating source data, exporting data to target systems and consolidating target systems.
  • Combined Intercompany and Accounts dimensions on HFM to view intercompany transactions. Ran intercompany matching financial reports for the same.
  • Involved in creation of Calc scripts, Rules for Hyperion Essbase Database and Application
  • Performed Essbase calc script tuning and debugging as well as enhancements.

Environment: Oracle/Hyperion System 9.3.1, EAS 9.3.1, Excel Spreadsheet Add-In, DRM, Hyperion Planning 9.x, Web Analysis, Interactive Reporting, MaxL, Oracle 10g,, HFM, Workspace, Shared Services

Confidential, Atlanta, GA

Hyperion Consultant

Responsibilities:

  • Installation and configuration of whole suite of Oracle EPM products including Hyperion Shared Services, Hyperion Essbase, Hyperion Planning, Hyperion Workspace, Hyperion Smart View and other related tools - in all environments.
  • Provided support for Hyperion Essbase, Hyperion Planning, Hyperion Reports other Hyperion Suite.
  • Involved in research and resolving complex issues related to any Hyperion Suite.
  • Troubleshoot and resolve complex Hyperion System related Issues.
  • Setup Disaster Recovery environment for Hyperion customer of Oracle.
  • Providing all round DBA support to resolve DB, Application, Tech Stack outages on production, development, test and staging on demand Customer environments.
  • Closely worked with System Administrator to resolve server related issue.
  • Involved in Setting up application instances required to create all the different logical environments in the system development life cycle (DEV, TEST, UAT, and PROD) helped in assisting clients and provided remote assistance in implementation.
  • Imported security profiles from Hyperion planning to Hyperion Essbase.
  • Improved the Performance (Optimized the Planning, Essbase system) by changing the dimension order and working on configuration file including Cache design techniques.
  • Migrated reports from development to Preproduction and then to production.
  • Involved in Trouble shooting the Production issues in support to the Planning Applications and all databases (Production Support).
  • Involved in Automating data load process with MaxL scripts and scheduled to run Calc scripts after every data load.
  • Researched and reported the Defects and Enhancements to the Hyperion Development team and enforce standards and best practices.
  • Configured the Application server software to each individual application’s requirements Performance Tuning with the Application server software for optimization of use.
  • Performed recovery under various circumstances on production database.
  • Successfully resolved archive log and NFS lock related issues.
  • Troubleshooter connectivity issue from middle tiers to database tier.
  • Synced up standby database with primary.
  • Involved in the documentation of the related tasks in the project.

Environment: Hyperion Essbase 9.3.1, Hyperion Planning 9.3.1, Hyperion Financial Reporting 9.3.0.1, Web Analysis, Smart View, Workspace, Shared Services, EPM, UNIX, Linux.

Confidential, NY

Hyperion Essbase Developer

Responsibilities:

  • Involved with Business Users and Business Analysts to gather the requirement and Business logic.
  • Migrated Essbase server (9.3.1) into (11.1.1.3) version and over UNIX host.
  • Installed Hyperion System 11 in development environment and explored migration issues.
  • Involved in creating Rule files for multi-dimensional databases, optimized Data loads and Calc Scripts.
  • Implemented Hyperion Essbase and Planning v.11 in connection with financial budgeting, sales forecasting and marketing analysis to produce ad-hoc reports.
  • Created Users and Groups in Hyperion Shared Services v.11 and assigned privileges to them. Applied security on different applications by creating filters on its dimension members.
  • Created new batch scripts to automate the transfer of the data from data server to Essbase Server.
  • Optimized structure, loading and calculations through appropriate dense and sparse settings of dimensions, storage allocations and by dynamic calculations and debugging.
  • Handled performance tuning, weekly backups and monthly consolidations of data and automated monthly/quarterly/annual report generation.
  • Updated/ modified the existing Calc scripts, MaxL scripts, UDA’s, Load Rules and Attribute dimensions as per the requirements of the business analysts.
  • Utilized Hyperion system 11 Essbase Aggregate Storage Option (ASO) to create cubes.
  • Updated/Created the MAXL scripts to include new dimension builds, data feeds, load rules and alias tables etc.
  • Hyperion Planning v.11 was used in testing of the new calculation scripts and to define business rules to match the needs of the users.
  • Created data entry forms to enter forms, update, analyze, print and report on data.
  • Build dashboards using Interactive reporting for upper level management.
  • Updated the korn shell scripts for running the process of recreation and validation.

Environment: Hyperion System 9.3.1, Hyperion planning 9.3.1, shared services, Essbase Spreadsheet Add-In, windows 2000, Interactive reporting,Hyperion web Analysis.

Confidential, Hartford, CT

Hyperion Essbase developer

Responsibilities:

  • Involved in designing, modifying and building of cubes and assigning member properties.
  • Co-ordinate with ETL team to sort data in desired format and loaded the data into data mart.
  • Involved in designing the load rule files for loading data from Oracle tables (fact tables) using SQL Interface, Excel sheets and flat files
  • Involved in creating, modifying calc scripts as per the business requirements to solve production issues.
  • Involved in optimization of outline and calc scripts.
  • Resolved many issues relating to server, database calculations, partitions, currency databases and Reports.
  • Involved in designing security filters and assigning them to end-users.
  • Written ESSCMD scripts for automation of various database tasks.
  • Written MaxL scripts for building and dropping partitions.
  • Involved in deploying of cubes from testing to production, restoring database from backup after database corrupt or server crash and creating test environments.
  • Written report scripts for exporting of subset of data to flat files.
  • Designed and developed views for business presentation using Hyperion Analyzer.
  • Designed numerous reports using Hyperion Reports using Hyperion financial reporting tool and Excel.

Environment: s: Hyperion Essbase 7.X and Hyperion Analyzer, Essbase Administration Services, Essbase Integration Services, Hyperion financial report (HFR) Excel Add-In, Web Analysis, Windows server 2000.

Hire Now