We provide IT Staff Augmentation Services!

Hyperion Developer /admin Resume

Kansas City, MO

SUMMARY:

  • Around 10 Years of Total experience in which 9 years of diversified experience in Business Intelligence application Hyperion Financial Management, Financial Data quality Management (FDQM), Financial Reporting, Hyperion Planning and Hyperion Essbase
  • Experienced in both HFM Web client and Desktop client
  • Implemented in Hyperion Financial Management 9.3.1 and experienced in migrating from Hyperion 9.3.1 to 11.1.1.3 and 11.1.2.0 to 11.1.2.1.
  • Experience in administration, building securities and Roles in HFM, and creating filters and assigning access to users in Essbase.
  • Provide Month End Support to users.
  • Experienced implementing 2 complete implementations in Hyperion.
  • Experienced in HFM Application Library, Dimension library, Shared Services, Calculation manager and Import and Export Tasks.
  • Well experienced in Planning Application implementations from end to end include designing the metadata, building, and loading data. Worked with Business unit, Process unit, Review process. Rules.
  • Experienced in Capex and Workforce Planning modules
  • Extensive Knowledge of ESSCMD, MaxL scripts, Member Formulas and Essbase Analytic services.
  • Strong experience on Essbase Cube analysis, design and development, Essbase database administration and performed Up gradations, Maintenance, Database backups, Performance tuning, optimization of BSO/ASO Cubes, Dense/Sparse settings, partitioning etc.
  • Knowledge of Shared Services to maintain Essbase security (Groups, Filters, users, etc.).
  • Extensive experience in creating reports using Financial Reports, Essbase Excel Add - In, and Smart view. Performed SmartView knowledge transfer to Client analysts.
  • Expertise in database development skills using Oracle PL/SQL to write stored procedures, stored functions, packages, and triggers.
  • Expertise in learning new technologies and business terminology quickly. Worked on multi- platform architecture using GUI and specialized in developing financial and production applications. and helping User’s on HFM, FDM and FR Tools.

TECHNICAL SKILLS:

Technologies: Hyperion Financial Management, Hyperion Financial Data Quality Management, Hyperion Planning, Hyperion Essbase, Hyperion Financial Reports, Smart view

Languages: SQL,PL/SQL, SQL Loader

RDBMS: SQL Server7.0/6.5, Oracle 10g/9i/8i/8.0, MS Access 2000/2003/2007

Operating Systems: Windows 20008, XP

JOB EXPERIENCE

Confidential, Kansas City, MO

Hyperion Developer /Admin

Responsibilities:

  • Created a new Application in HFM development environment then migrated it to it to QA then Production using HFM copy application.
  • Managing all Hyperion systems (HFM, FDMEE, Planning, Smart View) during the Month ends.
  • Involved in updating mappings and scheduling loads in FDMEE into HFM and Planning.
  • Created a new scenario in HFM and loaded data and done reconciliation.
  • Created new Rules and modified existing files as per the User requirements.
  • Worked extensively on Hyperion shared Services and Created numerous users, groups and provided them different privileges.
  • Worked extensively on LCM to migrate Planning Applications from one environment to another or taking the backup of Hyperion Application.
  • Responsible for monthly maintenance work, including metadata, mapping changes, opening periods, data loads and consolidation.
  • Actively involved in the maintenance and support of multiple planning applications.
  • Expertise in developing data rules to load data from source system/file to Hyperion system in FDMEE.
  • Supporting end users on Hyperion related issues.
  • Maintenance of user security and troubleshooting user access issues as they arise.
  • Monitoring the current Production environment servers for performance and stability.
  • Monitor application performance; identification and communication of resolution of issues
  • Restarting the Hyperion services on weekly backup times.
  • Trouble shooting the daily issues, Creating Oracle SR’s.

Environment: HFM 11.1.2.X, FDMEE, DRM 11.1.2.X, Smart View, DRM, Windows 2008 R2, Sql server

Confidential, Los Angeles, CA

Hyperion Developer /Admin

Responsibilities:

  • Support corporate, field and remote users with Hyperion applications and Smart View
  • Ensure monthly close process runs smoothly in Hyperion HFM, FDM, FR and Smart View applications.
  • Coordinate issue resolution with internal and external technical support providers
  • Load data to HFM as needed during monthly close process
  • Monitor application performance; identification and communication of resolution of issues
  • Maintenance of user security and troubleshooting user access issues as they arise.
  • Creating and updating the existing Rule files to match HFM structure.
  • Stopping and Starting the Hyperion services on weekly backup times.
  • Trouble shooting the daily issues, Creating Oracle SR’s and applying Patches.
  • Applying patches to HFM and Foundation servers.
  • Creating new locations in FDM as per the request.
  • Designed Reports as per user requirement using Hyperion Reports.
  • Experienced in creating workbooks in Financial Reports
  • Schedule Batches for FR reports in workspace.
  • Worked with IT team about backup procedure.

Environment: HFM 11.1.2.2, FDM, Smart View,HTP,Hyperion Financial Reporting 11.1.2.1 Windows 2008, Sql server

Confidential, San Jose, CA

Hyperion Developer /Admin

Responsibilities:

  • Ensure monthly close process runs smoothly in Hyperion HFM, FDM, FR and Smart View applications.
  • Coordinate issue resolution with internal and external technical support providers
  • Support, corporate, field and remote users with Hyperion applications and Smart View
  • Build, maintain and run financial reports in Hyperion Financial Reporting Studio
  • Load data to HFM as needed during monthly close process
  • Work with end users to develop and enhance the application process in a manner that will result in a stable productive environment
  • Monitor application performance; identification and communication of resolution of issues
  • Participate in the analysis of the efficiency and effectiveness of current departmental processes and procedures and ultimately help to implement identified improvements
  • Special projects and process improvements as determined necessary by management.
  • Support end users’ needs by providing assistance with report creation/implementation, user and functionality guidance as needed
  • Supporting the End users on Client install issues. Tracking the issues with Incident management tickets.
  • Maintenance of user security and troubleshooting user access issues as they arise.
  • Updating the existing Rule files to match HFM structure.
  • Created Member lists in Hyperion Financial Management.
  • Creating and Scheduling the Extended Analytics data loads based on the requirement.
  • Stopping and Starting the Hyperion services on weekly backup times.
  • Trouble shooting the daily issues, Creating Oracle SR’s and applying Patches.
  • Load required data into Hyperion with appropriate checks and controls
  • Create and maintain system documentation and internal controls
  • Develop materials and provide formal/informal
  • Perform Hyperion administration duties related to the operations of Hyperion
  • Attend the regular review calls and provide an update to client.

Environment: HFM 11.1.2.1/11.1.2.0 , FDM, Smart View,Hyperion Financial Reporting 11.1.2.1/11.1.2.0 , Windows 2008, Microsoft Access, Oracle 10g.

Confidential, Burbank, CA

Sr Hyperion Developer /Admin

Responsibilities:

  • Worked as a admin for new Hyperion 11.1.2.1 for HFM, FDM and FR.
  • Worked as a Team lead for on - shore team.
  • Created Groups and assigned roles to the group.
  • Changing users security access based on the requirement.
  • Adding new Meta data into HFM and adding new Accounts, Entities, Custom1 to Custom4 maps to FDM and mapping them to Targets.
  • Updating the existing Rule files to match HFM structure.
  • Loaded the actual data into 11.1.2.1 using FDM.
  • Created new maps and migrating the FDM from 9.2 to 11.1.1.3.
  • Interact regularly and communicate effectively with users, business owners, upper management, vendors, and outside consultants during project scoping, requirements gathering, solutions design, implementation, project management, UAT, and production support
  • Supporting to users for Month ending Process.
  • Analyze present reporting environment.
  • Convert Smartview/excel reports into Hyperion financial reports.
  • Create Reports, books and schedule Batches in workspace.
  • Study the Essbase cube design and suggest improvements for reporting purposes.
  • Create B/S, Income statement, TB, Flash and other reports in FR.
  • Loading Sales, Revenue, and Head Count Data to Essbase cubes and creating current Forecast/Budget members
  • Migrated applications from Hyperion 11.1.2.0 to Hyperion 11.1.2.1
  • Essbase outline changes for optimization.
  • Created web forms and Business Rules for Planning application.
  • Migrated application from DEV to Production using LCM (Life cycle management)
  • Managed system upgrades and client installations based on users’ requirements.
  • Installed, setup, and configured Hyperion 11.1.2.1 (Foundation, Essbase, Planning, ODI, ERPi, EPMA) in newly built distributed four-servers environments

Environment: HFM 11.1.2.1/11.1.2.0 , FDM, Essbase 11.1.2.1/11.1.2.0 , ASO,BSO, Excel Smart view Add-In, Hyperion Planning 11.1.2.1/11.1.2.0 , Smartview, Financial Reporting 11.1.2.1/11.1.2.0 , Oracle 10g.

Confidential, Mountain View, CA

HFM Consultant / Admin

Responsibilities Include:

  • Updating and Loading(Deploying) metadata for Accounts, entities, Scenario and custom dimension in Dimension library.
  • Creating Journals Templates, and Data Grids as per the client requirement.
  • Managing POV in the explore data setting.
  • Creating and Loading Dynamic Member lists (Created member lists for FR(Alternative hierarchies).
  • Worked as a admin for new Hyperion 11.1.2 for HFM, FDM and FR.
  • Updating the existing Rule files to match HFM structure.
  • Extracting data using Extended Analytics to load the data into Essbase (backup plan, in case Lprod2 the server down).
  • Loaded the actual data using FDM tool for UAT testing.
  • Designing and setup Security for HFM, FDM, FR and Smart View.
  • Assigning user’s into appropriate groups and creating security class and giving access rights.
  • Developed Security Process for Confidential for Support (GUTS Ticketing Process).
  • Helping Users to knowledge on Hyperion System (HFM, FDM, FR and Smart View).
  • Trouble shooting the daily issues.
  • Designed Reports as per user requirement using Financial Reporting Studio.
  • Installed Financial Reporting Studio, HFM Desktop Client and Smart view on Client machines.
  • Scheduling the reports based on the user requirement.
  • Migrating (Import and Export) Financial reports from system Dev to UAT

Environment: HFM 11.1.2 (EPM), Calculation manager, Financial Data Management, FR 11.1.2, Smart View.

Confidential, Columbus, Ohio

Hyperion Consultant

Responsibilities Include:

  • Supporting to users for Month ending Process.
  • Worked as a Team lead for on - shore and off-shore team.
  • Worked as a admin for new Hyperion 11.1.1.3 for HFM, FDM and FR.
  • Adding new Meta data into HFM and adding new Accounts, Entities, Custom1 to Custom4 maps to FDM and mapping them to Targets.
  • Loaded the actual data into 11.1.1.3 using FDM for May, June, July and Aug months.
  • Created new maps and migrating the FDM from 9.2 to 11.1.1.3.
  • Trouble shooting the daily issues.
  • Created new reports as per the user requirement.
  • Migrated Financial reports from system 9.2 to 11.1.1.3 and validate some Brands to make sure the System 11 Hyperion Reports reconcile to the System 9 reports.

Environment: HFM 11.1.1.3 & 9.2, FDM 11.1.1.3 & 9.2, FR 11.1.1.3 & 9.2, smart View.

Confidential, Aliso Viejo, CA

Hyperion Consultant

Responsibilities:

  • Converting the metadata in HFM application to match Oracle R12 structure
  • Creating new Rule files and updating the existing Rule files to match Oracle R12 structure.
  • Modified the Hyperion Planning application Account dimension members.
  • Developed and modified the existing Web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual accounting changes and other variance explanations data.
  • Developed and modified the existing Workforce and CapexCalculation scripts, Business rules based on the new R12 application and created substitution variables for the ease of maintenance of application.
  • Converting the Hyperion reports to match the Oracle R12 structure.
  • Loading the data using Financial Data Quality Management.
  • Convert mappings from Primary Ledger in Oracle R12 using FDM
  • Developed and modified the existing reports like direct cost P&L summery, Income statement, Net Margin, Balance sheet and Headcount reports by using financial reporting studio.

Environment: HFM 11.1.1.3, Hyperion Planning 11.1.1.3, Hyperion Essbase, FDM, R, smart View, SQL, PL/SQL.

Confidential

Hyperion Consultant

Responsibilities:

  • Load the actual data on monthly basis.
  • Regularly update metadata with new Accounts, Entities and Custom Dimensions.
  • Responsible for day to day tasks like process management, running consolidations and validating the data after consolidations.
  • Creating Static and Dynamic Member lists and Rules.
  • Migrated from Hyperion 9.3.1 to 11.1.1.
  • Periodically changing metadata and rules updating as per client change request. First trying the same in Development environment and then migrating to production.
  • Creating Journals Templates, and Data Grids as per the client requirement. Processing Journals every month for requirement.
  • Designed and developed Planning Multi-Currency applications.
  • Developed the outlines using Dynamic dimension build method.
  • Created Rule files for Data Loading in to RDASH and FOCUS cubes.
  • Creating filters in Essbase cubes.
  • Developed Web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual accounting changes and other variance explanations data.
  • Created calculation scripts in workforce Planning.
  • Written Essbase formulas, Calculation scripts, MDX formulas as per the requirements and created substitution variables for the ease of maintenance of application.
  • Written MaxL scripts to load databases, adding users, alter substitution variables and executed the scripts in both interactive modes.
  • Responsible for creating and modifying the PL and SQL procedure, function according to the business requirement.
  • Used SQL LOADER to upload the information into the database tables.
  • Created database objects like stored procedures, function, packages, Cursor, Ref Cursor and Triggers.

Environment: HFM, Hyperion Planning 11.1.1, Hyperion system 11.1.1, FDM, FR, Sql Toad.

Hire Now