SUMMARY:

• Hyperion Certified Consultant with 9+ years of experience with emphasis on Hyperion application Development, Implementation, Reporting, Administration, and Migration of various applications in client/server environment using Hyperion financial management(HFM), Hyperion Financial data quality management(FDQM), Hyperion Financial data quality management Enterprise edition(FDMEE), Hyperion Planning, Essbase, DRM (Data Relationship Management), Oracle Data Integrator (ODI), OBIEE and Hyperion Financial Reporting Studio under windows and Unix Environments.
• I have been involved in ground up implementations of Hyperion Products. I have worked in the Financial Service Industries, Banking, Automotive, Retail, and Manufacturing Industries.
• Strong experience in full implementation cycles of Hyperion Financial Management products for global corporations and small scale corporations.
• Worked on requirement gathering, requirement analysis, BRD (Business Requirement Documents), FRD (Functional requirement document), Development and Design, UAT (User acceptance Testing), End user training and production of applications.
• Developed HFM applications in classic and EPMA mode which is sourced from various financial data sources used for client consolidation and reporting needs
• Possessing strong technical and developmental skill set on Hyperion Planning/Essbase, FDMEE and HFM
• Designed and developed Aggregate and Block storage databases with excellent balance of Dense and Sparse dimensions, developing various OLAP models.
• Experience in Essbase Cube Analysis, Design and Maintenance, and Essbase Database Administration.
• Experience in writing custom Essbase calculation scripts, Rules script, Report script, automating the Essbase cubes using MaxL, MDX and Batch scripts.
• Possess broad understanding of database calculations such as formulas on dimension members, order of calculations in terms of dense and sparse dimensions, dynamic calculations and developing calculation scripts.
• Experience in Accounting: Balance Sheet, P&L, A/P, A/R, G/L, Fixed Assets, Budgets, Closing, Reconciliations, Journal Entries, Payroll, Banking, Trial Balance, Financial Analysis, Financial Audits, ERP Implementation.
• Strong experience in Hyperion Financial management application, metadata preparation, security classes, Member lists, data grids, Web Data forms, journals posting, ICP Eliminations, reports and automation of HFM tasks using task flows from workspace.
• Extensive experience in EPMA Suite application creation using application and dimension libraries and shared dimensions with Data Synchronization for planning and HFM applications. Application conversion from classic applications to EPMA and importing Business rules into CALCULATION manager.
• Designed metadata, build dimensions from existing Enterprise hierarchy for Historical data, integrate SAP entity, account and custom dimensions
• Strong knowledge in understanding and developing business rules in HFM
• Strong knowledge and experience on development of cash flow statement and automation of cash Flow Statement through business rules as per the client requirement.
• Designed complex security model for HFM, Planning, and Essbase applications as per client requirements.
• Migrated EPMA applications from one environment to other using LCM process and copy application utilities
• Automated the process of data feeds and dimension building of HFM applications using various automation tools
• Very familiar with SDLC process of HFM application process like consolidation process, ICP, Journals, Chart of accounts, financial statements.
• Designed the ETL process of HFM applications using FDM/FDMEE as the ETL tool.
• Designed backup and recovery process for Hyperion Financial Management and FDQM applications.
• Integrated Oracle EBS to the HFM/Planning/Essbase applications using FDM as the ETL tool.
• Strong knowledge and Experience in Developing Business reports, Management with the help of Hyperion Reporting Studio using HFM, Planning, Essbase as data source.
• Having Good knowledge on FCCS and PBCS Cloud Applications.
• Excellent command over the DRM Applications, Versions, Hierarchies, Nodes, Properties, Imports and Exports, Validation Rules, Security and DRG Process.
• Extensive knowledge on the Oracle EBS Modules like AP, AR, HRMS and integrated them to the Hyperion applications.
• Strong knowledge in financial reports, charts, pivots, dashboards, books, batches, snapshot reports using financial reporting studio.
• Strong Knowledge in migration process of applications from one environment to other using shared services and other back end techniques.
• Excellent communication skills and capable of working with IT and FPNA Team
• Strong knowledge in creating documentation related to functional as well as technical requirements and preparation of knowledge Transfer documentation as per the client requirements.

TECHNICAL SKILLS:

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

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 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, 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, California, CA

Senior Hyperion Consultant

Responsibilities:

• Worked from End to End implementation from requirement gathering to production deployment as part of this application development.
• Design, develop, and implement enterprise-wide budgeting, forecasting, and financial reporting cubes.
• Created and maintained ASO/BSO cubes as per user requirements and performed optimization by using appropriate dense/sparse configuration, outline structure strategies such as dynamic calculations, attribute dimensions, partitioning etc. and optimization of calc scripts and tuning of calc cache.
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an Extended hour glass fashion.
• Strong knowledge and Experience in Maintaining metadata, FDMEE maps and managing data transfers between applications including HFM.
• Configured and developed FDMEE application with Data loading Approaches EBS Direct Integration, Open Interface Adapter, and Universal Data Adapter. Tracked the metrics for each approach and assisted the client to choose the best approach.
• Developed Email Notification script by using Jython Scripting to send an automatic Email which states the status of FDMEE data loading tasks such as Import, Validate, Export and Check processes.
• Configured FDMEE batch files include multiple data load rules that load data into target systems with replace and merge mode.
• Involved in defining requirements, functional specifications, designing documentations and testing for creating budgeting and forecasting tool.
• Responsible for system maintenance, support & monitoring, capacity planning, resource management, evaluating & implementing best approaches, performance tuning as well as security maintenance.
• Developed business reports with the help of Smart View and Hyperion Financial Reporting studio.
• Helped automate process to limit user access and provision user/group security to sensitive corporate financial data with Shared Services.
• Developed new Planning Application Matrix from scratch as per business requirement.
• Hyperion planning is 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.
• 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.
• 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 (Migration wizard for Essbase) 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.x 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 DRM Activities such as hierarchies managing, Automation of metadata, Action script execution and validation rules building.

Environment: Hyperion System 11.1.2.2/11.1.2.4 , Hyperion Essbase 11.1.2.2/11.1.2.4 , Hyperion Financial Reports 11.1.2.2/11.1.2.4 , EAS 11.1.2.2/11.1.2.4 , Hyperion Planning 11.1.2.2/11.1.2.4 , DRM, Oracle 11g, Oracle SQL Loader, Windows 2012 Advanced Server, Linux.

Confidential, AZ Tucson, AZ

Sr. Hyperion Implementation Consultant

Responsibilities:

• Designed and developed HFM Classic Application with web forms, Grids, Member Lists, Task Flows and HFM Rules includes Calculation, Translation, Elimination, and Consolidation Rules.
• Extensively involved in business requirement gatherings and Functional design specifications to Technical design documents.
• Gather the Business requirements from the client and developed the rules for Calculation, Translation, Allocation, Intercompany, Consolidation to customize the default process.
• Performed complete analysis on their existing model of consolidation process and documented the process.
• Being a Subject Matter Expert Led the organization thru a valid business case for the need of Statement of Cash Flows within the existing Hyperion Financial Management (HFM) application. Developed and documented business requirements.
• Worked on Cash flow Automation used for consolidation purpose and to fulfill reporting needs.
• Rules has been developed to calculate and transform data for the Statement of Cash Flow, Translation of flow accounts, other calculation and capturing the foreign exchange rate differences in beginning balance.
• Prepared Technical documentation on what changes were made to the HFM application and how they were made, including meta data changes and rules.
• Designed and developed the FDMEE application, Configured system Settings, Applications Settings. Created import formats, locations, Data load rules, Security, Jython scripting.
• Designed and developed Open Interface adapter approach to automate the data loads from the Source system customized tables to FDMEE Tables.
• Developed Email Notification script by using Jython Scripting to send an automatic Email which states the status of FDMEE data loading tasks such as Import, Validate, Export and Check processes.
• Configured FDMEE batch files include multiple data load rules that load data into target systems with replace and merge mode.
• Translated end user requirements into application design specifications.
• Designed logic groups, locations, import format, validations, data load rules and mappings in FDMEE.
• Set up locations, category mapping, periodic mapping and import formats for FDM.
• Configured users and access rights in FDM.
• Build reports using Financial reporting studio for different end-users, including Financial Users, Sales Managers, Actuaries, and Cost-Center Administrators.
• Implemented Essbase and Planning Modules for financial budgeting, sales forecasting and marketing analysis to produce ad-hoc reports.
• Involved in the Development of BSO and ASO cubes - one for Industrial Sales, one for Production Planning and Budgeting, one for Market Research and one for Customer Analysis.
• Extensively worked on Calc Scripts, Report Scripts, MaxL and MDX Scripting as per the business requirements.
• Developed MaxL scripts to automate the repetitive tasks such as Data Loading, Backus, Security filters creation and update.
• Configure Hyperion DRM Application and Components (Versions, Hierarchies, Nodes, Properties, Validations, Import, Export processes, Security and automation).
• Extensively worked on DRG process and DRM Security Model includes Users Creation, Assigning Roles, Property Access, Object Access and Access Groups
• Developed action scripts to update the DRM Meta data.

Environment: Hyperion Financial Management (HFM) 11.1.2.4, Financial data quality management Enterprise Edition (FDMEE) 11.1.2.4, Financial reporting studio 11.1.2.4, Essbase 11.1.2.4, Planning 11.1.2.4, DRM, ODI

Confidential, Charlotte, NC

Hyperion Senior Consultant

Responsibilities:

• Implemented end to end solution of HFM used for consolidation purpose and to fulfill reporting needs.
• Performed complete analysis on their existing model of consolidation process and documented the process.
• Developed end user security matrix and user security rights. Walked the Hyperion core team thru design sessions and strategy as to where best HFM fits within other Hyperion products.
• Strong knowledge of working on FDM components like ODI, ERP Integrator, FDM.
• Translated end user requirements into application design specifications.
• Designed logic groups, locations, import format, validations, data load rules and mappings in FDM
• Working on Integration of ERP Systems (People Soft, Oracle EBS,) in order to extract and load the data in to the target HFM applications using FDM.
• Set up locations, category mapping, periodic mapping and import formats for FDM.
• Configured users and access rights in FDM.
• Managed the Essbase environment with 2 ASO and 3 BSO cubes which are actively used for analysis, budgeting and forecasting.
• Managed and maintained the daily automated feeds to the Essbase cubes.
• Developed filters to restrict uses from accessing restricted dimensions and assigned substitution variables using MaxL Scripts/EAS.
• Worked on optimization of BSO and ASO cubes in areas of Data loading, Data Retrieving, Calculation Scripts, Caches, Restructuring.
• Created MaxL script to automate the cube build process
• Automated data load rules for both single period and Multi-Period text files.
• Build reports using Financial reporting studio for different end-users, including Financial Users, Sales Managers, Actuaries, and Cost-Center Administrators.
• Involved in creation of FDM data load process for loading data into Planning and Essbase applications from various data sources.
• Performed knowledge transfer to the financial users regarding how to use data forms for the budgeting and workflow process.
• Maintain security by creating, managing, and assigning provisions to the users in the shared services. Created Users, Groups, Filters and assigned different levels of Security Access to users.
• Developed load rules for loading data files and for dimension build and implemented data-access security and user management. Created application profiles and metadata for HFM applications.
• Transformed the classic HFM application to the EPMA application.
• Created import profile to load the metadata from the flat file in to the target HFM application.
• Created data grids and data forms using Hyperion Financial Management & helped them move to the development environment. Developed Member Lists and Task Lists based on the business requirements.
• Developed Data Audit and Task Audit Reports for the auditors and managed Task Flows.
• Created Task Flows for the automation of consolidation, extended analytics for loading and extracting data to a file and database, loading and extracting journals.
• Involved in assigning security for applications using Hyperion Shared Services. Also created user and group profiles and assign proper privileges using filters.
• Created journals for Regular, Auto-reversing types which include Balanced, Unbalanced and Balanced By Entity. Created journal templates Standard and Recurring types for both Balanced and Unbalanced types. Created journal reports.
• Developed several Hyperion business rules for complex Calculations, Allocations, Translations, Transactions, Consolidation, Input and No Input.
• Implemented Extended Analytics for exporting metadata and data from the HFM applications into a flat file and database. Data is extracted in the form of a star schema with the fact table and several dimensions. Created templates for the extended analytics.
• Developed Books using HFR Automated E-mail delivery of financial reports using Batch Scheduler.
• Developed static and dynamic reports in HFR.

Environment: Hyperion Financial Management (HFM) 11.1.2.2, Financial data quality management (FDQM) 11.1.2.2, Financial data quality management enterprise edition 11.1.2,3, Financial reporting studio 11.1.2.1, Essbase 11.1.2.3, Planning 11.1.2.2,Microsoft Windows Server 2008 R2.

Confidential, Palo Alto, CA

Sr. HFM/FDM/ESSBase Developer

Responsibilities:

• Implemented end to end solution of HFM used for consolidation purpose and to fulfill reporting needs.
• As part of analysis explored various ERP systems (GL, HR, Payables, receivables modules) as part of analysis and worked on multicurrency as well.
• Support to HFM, FDM, Essbase and HFR applications
• Involved in development of ASO and BSO cubes using Hyperion Essbase 11.1.2.x that contained financial data that was retrieved using FR reports and supported Excel Addin for MS Excel.
• Worked extensively on tuning and optimization of BSO and ASO cubes.
• Developed various Rule files for multi-dimensional databases
• Modifications to Dimensions, Calc scripts, Load rules and Data load strategy.
• Maintenance of developed Hyperion Planning and Essbase applications including development of new functionality and processes (metadata, sub-variables, business rule and Cal script development) within the application.
• Involved in developing of Calc Scripts for complex calculations, currency conversion and optimization.
• Involved in making the Essbase backups and restores of Essbase application.
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass manner.
• Performed Performance tuning by using the dense/spares settings and developed the required alternate rollups for reports.
• Developed transparent partitioning to optimize the calc time on the cube.
• Involving in Month, Quarter and Annual Pre-close activities
• Scheduling tasks for consolidation, Process Management starting, Data loading, Copying and extracting using the EPM Maestro.
• Providing task audit reports to business team for audit in daily using Audit extract utility
• Providing Data Audit reports and security reports such as Users, roles and groups list to business team for audit in monthly
• Managing Metadata, Making Changes like Adding and Removing Members as per Client Requirement.
• Designing New Data Forms, making modifications as per Client Requirement.
• Providing Technical or Functional Solutions and Resolving issues of users.
• Designing New Reports as per the requirement by using Hyperion Financial Reporting.
• I was involved in data transformation from Hyperion Planning to Hyperion Financial Management.
• Worked with SME/Finance Teams to gather the consolidation application requirements.
• Designed Business requirements documents based on the analysis of the current business model.
• Designed Technical design document as per the business requirements.
• Developed and deployed EPMA and classic HFM applications used for consolidation purposes.
• Created and Loaded Metadata for HFM consolidation Actuals and Budget using EPMA to generate variance reports.
• For EPMA applications used application library/dimension library/job console and used EPMA utilities to manage metadata related to the HFM EPMA applications.
• Created and Modified HFM rules to perform various functions (No Input, Consolidation, Calculation, Currency Translation etc.)
• Created complex security of the Hyperion applications using Hyperion shared services and HFM security.
• Integrated People Soft, Oracle ERP Applications using FDM to integrate data related to financial applications.
• Created Member Lists, Data Grids, Data forms and Security file, Process flow using HFM.
• Performed Set up of Journal Entries, Intercompany Transactions, Eliminations, Exchange rate conversion.
• Entered Foreign Exchange Rates grids and their entries for Balance Sheet and Income Statement.
• Assisted in HFM/FDM annual SOX audits by providing documents, data and reports to internal/external auditors.
• Configured the source and target adapters in HFM from FDM and created the machine profiles.
• Used FDM in building Workflows, Mappings, Locations, Import Formats, Control tables to load Monthly data in HFM Application.
• Worked on end to end development of automation of cash flow statement starting from gathering requirements to go live.
• Developed new business rules while working on various automation tasks in HFM also modified existing rules as per the business needs.
• Designed ETL required for HFM applications using FDQM (Financial Data Quality Management) to integrate flat file and relational data source to Hyperion financial management applications.
• Worked on adapters, mappings, locations, imports, exports, reports using financial data management.
• Prepared templates for achieving quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers
• Created reports based on the business user requirement using Hyperion Financial Reporting and Smart View ( Eg: Cash Flow, Funds Flow, Depreciation, Amortization)
• On time completion of all assigned tasks and desirables meeting the business expectations and timelines.
• Provided documentation related to administration of the HFM applications developed and enhanced existing documentation related to HFM applications.

Environment: Hyperion Financial Management 11.1.2, Hyperion FDQM 11.1.2,Hyperion Financial Reporting (HFR) 11.1.2, Hyperion Shared Services, VB Script, Smart View, Window Server 2003/2008 R1, Oracle SQL Developer 2.1.1.64, Oracle 10.204, XML Files, SQL, PL/SQL

Confidential, Troy, MI

Hyperion Senior Consultant/Admin

Responsibilities:

• Involved in developing design specifications of Essbase cube according business requirements.
• Developed Calc Scripts, Rule files and Report Scripts for data loads and dimension builds.
• Developed batch scripts using MaxL and ESSCMDs to load data from relational systems database to Essbase cube.
• Developed OLAP Models and Meta outlines using Essbase Integration Services from star schema in relational databases.
• Used Essbase Administration Services for activities such as filter creation, creation of users, creation of groups, and migration of cubes and maintenance of Essbase Servers.
• Involved in database and security refreshes in Hyperion Planning.
• Created and Loaded Metadata for HFM consolidation Actuals and Budget (for Variance) using EPMA.
• Configured the source and target adapters in HFM from FDM and created the machine profiles.
• Used FDM in building Workflows, Mappings, Locations, Import Formats, Control tables to load Monthly data in HFM Application.
• Automated Data loads from different departments into HFM using FDM Task Manager.
• Modified business rules to perform various functions (Consolidation, Calculation, Currency Translation etc.) according to the requirements.
• Created Meta data, Member Lists, Data Grids, Data forms and Security file.
• Worked with Finance Analysts to customize application for generating Financial Statements.
• Performed Set up of Journal Entries, Intercompany Transactions, Eliminations, Exchange rate conversion.
• Entered Foreign Exchange Rates grids and their entries for Balance Sheet and Income Statement Accounts.
• Assisted in HFM/FDM annual SOX audits by providing documents, data and reports to internal/external auditors.
• As part of maintenance took backup for metadata, business rules, journals and security files
• Created Users, Groups, Filters and assigned different levels of Security Access to users.
• Developed Cash management reports, Profit and Loss statements, income statements and balance sheets using Hyperion Financial reporting studio.
• Involved in the creation of dimensions and members in Essbase Outline
• Involved in the complete Software Development Life Cycle of the applications
• Designed and developed complex Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion.
• Optimized the Hyperion application to balance the calculation and retrieval performance.
• Performed dynamic calculations, loaded data from various database using Rules files, developed, reviewed, and optimized report queries in Microsoft Excel.
• Developed the Security Filters for Essbase applications
• Built ETL process to load data and build dimensions in Essbase applications in Nightly mode.
• Worked on day to day production supports for Essbase and ETL applications.
• Worked with SME and business analysts to gather and analyze requirements and built and POC for initial sign off.
• Expertise knowledge in Design and architecture of Essbase and Planning applications.
• Hyperion Planning is used to build the Planning and Budget application from the scratch to meet the business functional requirement and to map the data from the external sources application.
• Developed numerous simple to complex Business Rules for planning and calc scripts for Essbase applications as per end user requirements
• Created the Planning applications with the plan type for Revenue, expenses, capex and workforce modules.
• Involved in data tie-out for performing OLAP cubes using a simple variable substitution mechanism, to ensure that data is the same in both system.
• Implemented the Dense/Sparse dimensional architecture with Attribute dimensions, Smart lists based on the requirement and easy to use and update in future.

Environment: Oracle Hyperion Financial Management 11.1.2.3, FDM, HFR, DRM, EssBase, ODI, Excel 2010, Oracle 11i, and Windows 2012.

Confidential

Senior Hyperion Analyst/Developer

Responsibilities:

• Competent to work at the highest technical level of all phases of applications systems analysis and programming activities.
• Involved in Providing solution approach for up gradation
• Upgrading from version 9 Classic to 11 EPMA environments continued with Smart view for the mapping, design, creation and testing of Confidential ’s global financial reports within the EPMA environment.
• Responsible for Migrating artifacts from one environment to another environment.
• Actively performed the preparation and reviewing of test cases and executing them and Defect Testing.
• Experience promoting Hyperion objects from Development/Quality Assurance environments into production using LCM.
• Provided support as needed to Confidential worldwide users for HFM, FDQM and HFR Applications.
• Developed multiple Smart View Templates and reports to load data into HFM application and to perform analysis of financial data.
• Involved in developing design specifications of Essbase cube according business requirements.
• Developed Calc Scripts, Rule files and Report Scripts for data loads and dimension builds.
• Developed batch scripts using MaxL and ESSCMDs to load data from relational systems database to Essbase cube.
• Used Essbase Administration Services for activities such as filter creation, creation of users, creation of groups, and migration of cubes and maintenance of Essbase Servers.
• Involved in database and security refreshes in Hyperion Planning.

Environment: Hyperion Financial management 11.1.1.3/9.3.1 , Financial Data Quality Management, Hyperion Financial Reporting, EssBase and Smart view

Confidential

Senior Hyperion Analyst/Developer

Responsibilities:

• Involved in Providing solution approach for up gradation
• Provided Application Support for Oracle Hyperion Products which include Hyperion Financial Management, Hyperion Financial Reporting, Hyperion Financial Data Quality Management and Smart view.
• Designed new web data entry forms, Web Grids, Developed both static and Dynamic Member Lists, Task lists.
• Involved in design and development and maintenance of HFM Rules for Calculation, Translation, Consolidation, and Allocation.
• Involved in Developing of Smart View Templates as per the requirement.
• Provided and communicated to end users business process reinforcement and training as needed.
• Providing 24/7 Production support to resolve issues from the user relating to security, errors, new enhancements, reporting.
• Enhanced various HFM business rules.
• Developed FDM application and configured with settings. Developed import formats, maps, validation rules, Scripts.

Environment: Hyperion Financial management 11.1.1.3/9.3.1 , Financial Data Quality Management, Hyperion Financial Reporting, EssBase and Smart view

Confidential

Hyperion Analyst & Developer

Responsibilities:

• Senior member of the HFM Administration team responsible for Implement, Develop, support, design and problem solving for technically complex projects.
• Work with user community to technically enhance their use of the financial consolidation and reporting system.
• Troubleshoot and fix the Hyperion system related issues on priority basis.
• Work with corporate and field Financial Reporting and Accounting staffs to implement process improvements related to HFM and close process.
• Migrated Hyperion application from one environment to another depending on requirement.
• Hands-on technical system design of the HFM, HSS, HFR and configuring the same.

Environment: Hyperion Financial management 7.x/9.3.1, Financial Data Quality Management, Hyperion Financial Reporting, EssBase and Smart view

Confidential

Hyperion Analyst

Responsibilities:

• Creation of Metadata and Changes to Metadata based on requirements and Dimension Settings.
• Strong knowledge on Data Load & Extraction activities and worked on Intercompany, Cash Flow & Financial Consolidation Modules
• Creation of Business Rules for Inter-company Transactions and Financial Consolidation and Deferred Tax Modules
• Created Web Entry Forms for Inter-company Transactions, Financial Consolidation and for Cash Flow Statements.
• Worked on Consolidation for Intercompany Transactions and Cash Flow Statements.
• Preparation of Module Design Documents for the Intercompany Transactions, Financial Statements, and Cash Flow Statements

Environment: Hyperion Financial management 6.x/9.3.1, Financial Data Quality Management, Hyperion Financial Reporting, EssBase and Smart view