We provide IT Staff Augmentation Services!

Resume

Hyperion Application Lead Jersey City, NJ

OBJECTIVE:

My main objective while performing any Job is to provide the best in class solutions and performance to the clients and in turn help them in achieving the results for which they hired me.

EXPERIENCE:

  • 7 years of experience in the field of Information Technology, this includes pioneering work in business Analysis, Project Management, requirements, development, testing, implementing and support of Hyperion Suite Applications and Client/Server projects using industry accepted methodologies and procedures. experience in Analysis, Development, Implementing and Testing using Oracle Hyperion suite of products Such as Hyperion Essbase, PBCS & EPBCS, Planning, FDMEE, Hyperion Financial reporting, and Smart View.
  • 7+ years of productive experience in Analysis, Development, Implementing and Testing using Oracle Hyperion suite of products Such as Hyperion Essbase, PBCS & EPBCS, Planning, FDMEE, Hyperion Financial reporting, and Smart View.
  • Installed and Configured various version of Oracle EPM in distributed environment.
  • Experienced in Administration of EPM products such as Hyperion Planning, Essbase, and FDMEE.
  • Worked extensively on Essbase Block storage cubes and ASO cubes. Familiar with many performance improvements techniques like Partitioning, cache optimization, indexing, paging, outline optimization, Member formula and calculation script optimization. Broadcasting to publish, print and e - mail the pre-built Excel based financial reports
  • Worked on Creating Hyperion planning Application both on-prem and PBCS (Classic & EPMA), Hyperion Data Forms, Security Class, Metadata Maintenance, Task List, Member Lists, Data Loads, running Consolidations, & Calculation Manager.
  • Experience in creation of Web forms in Hyperion planning for users to create, modify the plan details and creation of Menus and Smart Lists in Planning application.
  • Extensive experience in building Financial Budgeting & Forecasting, Contribution Margin, Sales, profit margin, variance calculations, exchange rate calculation application with Hyperion Planning (Forms, Security, Metadata Maintenance, Business Rules) and Reports.
  • Excellent functional and technical expertise in maintenance and support activities.
  • Worked extensively on Hyperion Shared services Roles/Groups Authorizations including custom groups to make user authorization and control easy to maintain and extensible. Also implemented Row Level security for business units to protect crucial financial information based on individual profit centers.
  • Experience in working through all phases of Software Development Life Cycle (SLDC) including the design, development, implementation, and maintenance of financial applications.
  • Developed and enhanced complex Hyperion reports using Financial Reporting Studio and Smart view.
  • Developed support, enhance budgeting and reporting templates and ad-hoc reports using Smart view for office.
  • Configured FDMEE for Actual Data loads for Essbase and HFM applications.
  • Extensive knowledge in Oracle, SQL Server.
  • Worked on conversion of business requirements into Hyperion based models as per the department’s goals and objectives.
  • Worked closely with Finance teams such as regional controllers, Financial Planning and budgeting teams.
  • Strong communication, organizational and interpersonal competencies, adapt to change and a quick in learning new versions and applications.

SKILL:

Hyperion Essbase, Hyperion Planning, PBCS, Financial Data Quality Management (FDM/FDMEE), Essbase Administration Services, Hyperion Shared Services.

WORK SUMMARY:

Confidential, Jersey City, NJ

Environment: Hyperion Essbase 11.1.1.3 & 11.1.2.4, Hyperion Essbase studioPBCS, AIX, Smart View.

Hyperion Application lead

Responsibilities:

  • Design, Develop, Gather and Analyze functional requirements and Technical Design Documents.
  • Migrated Essbase from 11.1.1.3 to 11.1.2.4 version.
  • Installed and configured Essbase servers.
  • Migrated all data, outlines and other artifacts from old AIX servers to new Servers, also modified scripts and Set env.
  • Created Security structure in the new environment.
  • Migrated EIS to Essbase studio.
  • Created Essbase cubes and PBCS cubes.
  • Worked on Administering the Essbase cubes in the production environment.
  • Optimized the performance of the Essbase applications by performing multiple tuning techniques.
  • Optimized performance, Block Size, Block density, cache settings, indexing, paging and compression settings.
  • Performed tuning on Calc Scripts & Business rules and automated daily tasks.
  • Outline Optimization - Modified Hour Glass Model (AKA Dress form or Hourglass on a Stick).
  • Created Data forms, Task lists, & Smart lists for PBCS applications.
  • Created partitions on Essbase cubes.
  • Worked closely with business users and made sure that all their requirements are met.
  • Lead offshore team and made sure that tasks are completed in the provided time frame.
  • Ran multiple tests and resolved issues that showed up while testing.
  • Coordinated with Oracle to come across few bugs we faced after upgrade
  • Automated daily tasks. As a part of automation, created and scheduled tasks in Control-M.
  • Administered user security using share services.
  • Documented complete process with screen shots for Business Signoff.
  • Trained Business admins and end users on new options available in latest version

Confidential, NJ

Environment: Hyperion Essbase, Hyperion Planning, PBCS, FDMEE

Sr. Hyperion Consultant

Responsibilities:

  • Worked on Multi-Dimensional Database (MDDB) application such as Hyperion Essbase that stored and maintained company's financial data and Hyperion planning applications that are used for company’s Planning and budgeting.
  • Interacted with users to gather business requirements, define, design, develop, test and deploy Hyperion Planning and Essbase Applications.
  • Responsible for Development and maintaining all technical aspects of Essbase, Planning both on prem and Cloud(PBCS), and Reporting. Including constructing Metadata, changes, maintenance of application structures.
  • Performed metadata building using outline load utility for different dimension and various applications.
  • Developed Dynamic data forms for various applications with POVs, menus, run time prompts and Pages.
  • Configured FDMEE for Actual Data loads for ASO and Planning application
  • Designed mappings and tested the FDMEE app with multiple data loads with Import, Validate, Export and Check rule on multiple servers.
  • Delivered complex Financial Report for external reporting purpose
  • Developed ASO Essbase Cubes as per Business Requirement
  • Administration of Hyperion Planning and Essbase Applications.
  • Involved in the performance tuning of the Essbase server.
  • For every month end metadata refresh, Replicating Prod apps to UAT or Test based on Users request.
  • Enhancing and improving Business rule performance.
  • Loading exchange rates to various applications on a monthly basis, quarterly basis as per cycle.
  • Automated the monthly loading process using MaxL, Shell Scripts.
  • Developed load rules, calc scripts, webforms, Business Rules.
  • Designed and implemented Security model for planning applications.
  • Worked on MDX queries to View Dimensions and to perform tasks on ASO cubes.
  • Performs system backups and recovery. And maintained all backup files for disaster recovery.
  • Developed and maintained rules files, calc scripts, MaxL scripts and reports.
  • Developed reports for users to view the data in the planning applications using Hyperion Financial Reports.
  • Worked on development activities like setting up source Systems, registering Target EPM Applications, Extracting General Ledger Data, Selecting Source Accounting Entities (Name of ledgers or business units), working with Import formats, Defining Locations, Defining Metadata Rules, Defining Period Mappings, Defining Category Mappings, Viewing Process Details.

Confidential, ST. LOUIS, MO

Environment: Hyperion Planning, Essbase, Financial Reports, SmartView SQL server, FDMEE.

Hyperion Consultant & SQL admin

Responsibilities:

  • Responsible for development and maintenance of Hyperion Essbase and Planning applications to help in the analysis of Client’s business performance and provide insights into various customer segments.
  • Developed Hyperion Planning applications to support yearly budgeting and Forecasting process
  • Developed MaxL scripts write back process to automate the whole Hyperion Essbase tasks.
  • Developed the Corporate financial reports using Financial Reporting Studio, Excel Add-In, SmartView.
  • Performed metadata building using outline load utility for different dimension and various applications.
  • Developed load rules, calc scripts, webforms, Business Rules.
  • Setup security for Essbase and Planning users using shared services.
  • Involved in performance tuning Planning Cubes and Essbase ASO Reporting Cubes.
  • Created User documents. Build excel files describing the data forms, how they work and business rules association with them and what rule is doing.
  • Responsible for migrate reports into latest version.
  • Worked on Creating FDMEE application and integration setup
  • Created Planning web forms to capture budget/forecast from Finance users
  • Configured FDMEE to pull data from Oracle GL.
  • Performed actual data loads using FDMEE.
  • Supported finance team for the smooth execution of the month end actual, forecast and budget data load processes using FDMEE.
  • Extensively trained business users on SmartView and HFR tools.
  • Designed back up plans for the SQL server.
  • Worked on provisioning access to the users in SQL server.
  • Initiated the Group based access in SQL and Hyperion Products.

Confidential, Hoboken, NJ

Environment: Hyperion Planning, Hyperion Essbase, Smart View Shared Services.

Hyperion Essbase/Planning Administrator

Responsibilities:

  • Participated in defining requirements from the end user, functional specifications, design documentations and test strategies.
  • Support procurement, installation, implementation, maintenance, and of upgraded financial systems, system changes, and system upgrades.
  • Developed Essbase and Planning applications.
  • Created new and maintained existing reports using Financial Reports, Smart View Templates/Reports (using HSGetValue) and Ad hoc Queries as required by the business users.
  • Developed several Web Forms for users to enter Forecast, Budget and other data.
  • Updated Planning applications metadata.
  • Administered BSO and ASO cubes and improved their performance through tuning, recognizing design issues, eliminated fragmentation, sizing caches, grouping sparse dimensions together.
  • Gathered requirements for Smart View and Financial Reports.
  • Performed admin activities related to Hyperion Planning and managed Shared services responsibilities.
  • Developed/Enhanced business rules, Data forms and Hyperion financial reports.
  • 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.

Confidential

Environment: Hyperion Essbase, excel add-in, workspace.

Essbase Developer

Responsibilities:

  • Involved in the configuration of Hyperion Essbase.
  • Developed Essbase Cubes as per Business Requirement.
  • Involved in the performance tuning of the Essbase server.
  • Automated the backup process using MaxL scripts.
  • Developed Load rules for Dimension build and Rules File for loading the data from Oracle Database into Hyperion Cube.
  • Optimized Essbase cubes with Oracle recommended techniques.
  • Interacted with the data staging team to get appropriate data into Essbase cubes.
  • Developed Calc Scripts for aggregating the data based on the business requirements.
  • Involved in creating the Security Filters and assigned to the users for restricting the data from being accessed.
  • Customized retrieval on Excel sheets through efficient use of Essbase Query Designer.

Hire Now