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.
• Training and helping User’s on HFM, FDM and FR Tools.

TECHNICAL SKILLS

Tools: & 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

PROFESSIONAL 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 training 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 training materials and provide formal/informal training
• 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:

• 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:

• 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.
• Responsiblefor 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.