SUMMARY

• Over 7 years of IT experience and a proven track record working as a Hyperion Consultant, extensive hands on technical experience in many aspects of Data Warehouse and OLAP software systems design and implementation.
• HyperionHFM/Reports/FDM/FDMEE Consultant with emphasis onHyperionapplication Development, Implementation, Reporting, Administration, and Migration of various applications in client/server environment usingHyperionfinancial management,HyperionFinancial data quality management, HyperionFinancial data quality management Enterprise edition andHyperionFinancial Reporting Studio.
• I have been involved in ground up implementations ofHyperionProducts.
• 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.
• Extensive experience in the development, design, analysis and implementation of various applications usingEssbaseinteractive reporting 11.x/9.x, OBIEE,EssbaseAdministration Services,Hyperionstrategic finance,HyperionData integration management (DIM),HyperionWorkforce Planning,EssbaseIntegration Services, HAL,Hyperionweb Analyzer,Hyperionfinancial Reports,EssbaseStudio andEssbaseSpreadsheet Add - In,HyperionVisual Explorer.
• Skilled in Automation, Optimization, and Performance Tuning ofEssbaseapplication data/metadata processing, upgrading, testing and migrating of cubes in different environment.
• DevelopedHFMapplications in classic and EPMA mode which is sourced from various financial data sources used for client consolidation and reporting needs
• Experience in Accounting: Balance Sheet, P&L, Fixed Assets, Budgets, Closing, Reconciliations, Journal Entries, Payroll, Banking, Trial Balance, Financial Analysis, Financial Audits, ERP Implementation.
• Strong experience inHyperionFinancial management application, metadata preparation, security classes, Member lists, data grids, Web Data forms, journals posting, ICP Eliminations, reports and automation ofHFMtasks using task flows from workspace
• Experience in Client Installs/Issues with Excel add-in, Smart View, HFM.
• Experience in building, loading, testing and validating the application model according to the design specifications, installing and verifying the application and building basic integration components. Translate strategic business needs into business rules, practical consolidations and reporting solutions.
• Experience with a background in financial consolidations, budgeting, reporting, month-end closing and forecasting; utilizing Hyperion Planning, Reporting and Financial Management/Hyperion Enterprise.
• Technical experience on report writing, loading metadata, designing calculation models, documenting architectural designs, validation and creating SmartView Reports etc.
• Understanding of financial planning, budgeting, and reporting processes and its correlation to supporting various reporting systems.
• Equipped with strong financial knowledge in budgeting, cost allocation, reporting and forecasting.
• Experience in supporting Hyperion data conversion, integration and interfacing activities, including user support to load and reconcile data.
• Experience in creating, updating maps, import format and locations etc. in FDM.
• Experienced in Consolidation at the entity, business unit, multiple currency and department level with the ability to generate reports at these levels.
• Expertise in administrative tasks ofEssbase: Managing applications and databases, Essbasearchitecture, data and dimension loading, Calc Scripts, Business Rules, MaxL, MDX Querying, Report Scripting, User security and Performance tuning.
• Expertise in gathering and analyzing the requirements of users and translating them into specifics cube definitions and design.
• Migrated and supported UAT and Production environments
• Trained and supported End users in UAT.
• Involved in creation of FDM/FDMEE data load process for loading data into HFM
• Designed backup and recovery process forHyperionFinancial Management and FDQM applications.
• Strong Knowledge in migration process of applications from one environment to other using shared services and other back end techniques.
• Strong knowledge in writing test cases to validate the applications developed and performed Unit Testing.

TECHNICAL SKILLS

OLAP Tools: Hyperion System 11.x, Hyperion Financial Management 11.x, FDQM, FDMEE 11.x, Hyperion Planning 11.x, BI+(Financial reporting, Interactive reporting), Hyperion Essbase 11.x/9.3.x, Hyperion Planning 11.x/9.3.x, Hyperion Shared Services, Hyperion DRM, Hyperion System 11.x, Analytic Administration Services, Hyperion Enterprise, Hyperion Essbase Administration Services console (EAS), Hyperion Shared services,Hyperion Workspace

Reporting Tools: Hyperion Interactive Reporting (IR), Financial Reporting (FR), Web Analysis (Analyzer), Excel Add-in and Smart View.

Database: Oracle 12c/11g/10g, MS Access, MS SQL Server.

Programming Languages: XML, SQL, PL/SQL

Operating Systems: Windows, Linux and Unix.

PROFESSIONAL EXPERIENCE

Hyperion Consultant

Confidential - Deerfield IL

RESPONSIBILITIES:

• Involved in all phases of database design and implementation, including project planning, requirements gathering, data extraction, database building, customer education, and production support.
• Performed complete analysis on their existing model of consolidation process and documented the process.
• Developed end user security list and user security rights. Walked theHyperioncore team thru design sessions and strategy as to where bestHFMfits within otherHyperionproducts
• Responsible for running BI monthly and annual reports.
• Helped on Administer, maintain, and support corporate financialHyperionsystems.
• Strong knowledge of working on FDM and FDMEE.
• DevelopedEssbase(ASO and BSO) applications required for the day to day analysis and used for accounting teams for closing process
• Responsible for handling, closing and creating access requests raised on due basis using BMC Remedy Ticket Handler.
• Generating reports for every Month End Turnover Tasks and Closing Activities.
• Creating Groups and Assigning Users for Shared Services, JDE to HFM submission Website and submission folder for text files.
• Regular follow up on patching activities and Co-ordination with IBM team in patching servers/Monthly Maintenance.
• During patching, shutdown and restart Hyperion services on the server for DEV, TEST and PROD environments.
• Designed logic groups, locations, import format, validations, data load rules and mappings in FDM
• Set up locations, category mapping, periodic mapping and import formats for FDM.
• Assisted inHFM/FDM annual SOX and PWC audits by providing required evidence of documents, data and reports to internal/external auditors.
• Created some automation scripts for handling the ON and OFF of the HFM task manager and maintained the same with windows servers.
• On time completion of all assigned tasks and desirables meeting the business expectations and timelines.
• Responsible for FDM Maintenance and Update of FDM Mappings
• Re-submission of Batches upon requirements or submission failure.
• Resolving errors and issues of Smart View, Hyperion Web for users.
• Maintenance of all the users record in MS Access Database.
• Running of Monthly HR Termination Reports.
• Tuned and troubleshootHyperionEssbaseapplications (BSO and ASO) as part of optimization process.
• Maintain security by creating, managing, and assigning provisions to the users in the shared services
• Maintenance of BI-Annual review reports for Audit purpose.
• Responsible for running FDM batch reports and resolving the errors in case of any failures during submission.
• Provide mentoring and training to clients incase of any issues.
• Tactically develop Hyperion Financial Management (HFM) environments, including outlines, FDM mappings, rules, reports, input forms and security.
• Write and maintain clear, concise functional and technical specifications on HFM applications and business system processes.
• Loading data, calculate and consolidate data, reconcile errors, script creation & execution and monitoring status reporting.
• Resolved issues withHFMnot being able to create applications due to configuration issues, by troubleshooting Shared Services, Works pace, andHFM.
• Developed load rules for loading data files and for dimension build and implemented data-access security and user management. Created application profiles and metadata forHFMapplications
• Data loading, reconciliation, migrating data from one application to another, and data warehousing concepts is a required skillset.
• Deep functional knowledge and experience with, HFM, FDQM, FDMEE, Essbase, Hyperion Planning, Financial Reporting including functional design, administration and maintenance.
• Ability to architect, design and build all aspects of a Hyperion systems including loading data and metadata, creating data forms and business rules.
• Participated in meetings with financial users and IT Department if any issues arise regarding Hyperion.
• Managed and maintained monthly/actual financial report, documented and interpreted key drivers and variances and compared to the overall financial plan (QTD, YTD, monthly) and reported to senior Management.
• Created users, groups, filters and assigned different kinds of Security access to users in Hyperion financial management
• Applications using Hyperion Shared Services and gave security acess to users in Hyperion Planning applications through Active directory .
• Responsible for running month end reports and security access for Lease pak and lease price applications through Citrix Xenapp.
• Performed financial analysis for customers and senior managers as requested.

ENVIRONMENT: Hyperion Financial Management 11.1.x, Hyperion Essbase 11.1.x, Hyperion Planning 11.1.x, Hyperion Workspace v.11.1.2.3 Financial Reports, Hyperion Integration Services, Hyperion Administration Services), Hyperion Web Analysis, HFM, FDMEE, Excel Add-In, Smart View, Windows Server/7, Oracle, MS Access.

Hyperion Administrator

Confidential - Bannockburn IL

RESPONSIBILITIES:

• Deep functional knowledge and experience with Hyperion Planning, HFM, Essbase, Financial Reporting, FDMEE, including functional design, administration and maintenance.
• Support toHyperion Financial Management (HFM), Financial Data Quality Management (FDM), Hyperion Financial Reporting (HFR) and Hyperion Profitability and Cost Management (HPCM) applications.
• Involved in all phases of database design and implementation, including project planning, requirements gathering, data extraction, database building, customer education, and production support.
• Responsible for running FDM batch reports and resolving the errors in case of any failures during submission.
• Created Member Lists, Data Grids, Data forms and Security file, Process flow usingHFM.
• Responsible for running BI monthly and annual reports.
• Responsible for handling, closing and creating access requests raised on due basis using BMC Remedy Ticket Handler.
• Generating reports for every Month End Turnover Tasks and Closing Activities.
• Creating Groups and Assigning Users for Shared Services.
• Created some automation scripts for handling the ON and OFF of the HFM task manager and maintained the same with windows servers.
• Creating Groups and assigning users in Shared Services
• Responsible to turn on/off some Automation and timers in FDM Task Manager and Windows Task Scheduler on server.
• Responsible for FDM Maintenance and Update of FDM Mappings
• Re-submission of Batches upon requirements.
• Resolving errors and issues of Smart View, Hyperion Web for users.
• Maintenance of all the users record in MS Access Database.
• Running of Monthly HR Termination Reports.
• Maintenance of BI-Annual review reports.
• Responsible for maintaining and updating HFM mappings on needy basis.
• Provide mentoring and training to clients.
• On time completion of all assigned tasks and desirables meeting the business expectations and timelines.
• Provided documentation related to administration of theHFMapplications developed and enhanced existing documentation related toHFMapplications.
• Ability to architect, design and build all aspects of a Hyperion systems including loading data and metadata, creating data forms and business rules.
• Managed and maintained monthly/actual financial report, documented and interpreted key drivers and variances and compared to the overall financial plan (QTD, YTD, monthly) and reported to senior Management.
• Created users, groups, filters and assigned different kinds of Security access to users in Hyperion Planning Applications using Hyperion Shared Services.
• Responsible for running monthly HR termination reports.
• Performed financial analysis for customers and senior managers as requested.

ENVIRONMENT: Hyperion Financial Management 11.1.x, Hyperion Workspace v.11.1.2.2 Financial Reports, Hyperion Integration Services, Hyperion Administration Services, Hyperion Web Analysis, HFM, FDMEE, Excel Add-In, Smart View, Windows Server/7, Oracle, MS Access.

Confidential, Atlanta, GA

RESPONSIBILITIES:

• Implemented end to end solution ofHFMused for consolidation purpose and to fulfil 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 toHyperion Financial Management (HFM), Financial Data Quality Management (FDM) and Hyperion Financial Reporting (HFR)
• Involving in Month, Quarter and Annual Preclose activities
• Trained users so they could review and validate data inHFM.
• Scheduling tasks for consolidation, Process Management starting, Data loading, Copying and extracting using the EPM.
• Exported data out formHFMapplications and loaded the same to Essbase applications used for all standard reporting needs.
• 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.
• Involved in data transformation fromHyperionPlanning toHyperionFinancial 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.
• Created and Loaded Metadata forHFMconsolidation 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 theHFMEPMA applications.
• Configured the source and target adapters inHFMfrom FDM and created the machine profiles.
• Used FDM in building Workflows, Mappings, Locations, Import Formats, Control tables to load Monthly data inHFMApplication.
• Worked on end to end development of automation of cash flow statement starting from gathering requirements to go live.
• Designed ETL required forHFMapplications using FDQM/FDMEE (Financial Data Quality Management) to integrate flat file and relational data source toHyperionfinancial management applications.
• Worked on adapters, mappings, locations, imports, exports, reports using financial data management.
• 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 usingHFM.
• 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.
• Prepared templates for achieving quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers
• Created complex security of theHyperionapplications usingHyperionshared services andHFM security.
• Created reports based on the business user requirement usingHyperionFinancial Reporting and Smart View (Eg: Cash Flow, Funds Flow, Depreciation, Amortization
• Provided documentation related to administration of theHFMapplications developed and enhanced existing documentation related toHFMapplications.

ENVIRONMENT: HyperionFinancial Management 11.1.2,HyperionFDQM 11.1.2,HyperionFinancial Reporting (HFR) 11.1.2,HyperionShared 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.

Hyperion Administrator

Confidential

RESPONSIBILITIES:

• Developed and designed cubes usingEssbaseIntegration Services.
• Translated end user requirements into application design specifications.
• Assured optimal match between cube design and report specifications.
• Involved in deploying of cubes from testing to production, restoring database from backup after database corrupt or server crash and creating test environments.
• Optimized outline structure, loading and calculations through appropriate dense and sparse settings of dimensions, storage allocations and by dynamic calculations and debugging.
• ImplementedEssbasein connection with financial budgeting, sales forecasting and marketing analysis to produce ad-hoc reports.
• Optimized cache settings, established user security, managed applications migration, established substitution variables and settings for dynamic time series, asynchronous processing, and editing/validating scripts.
• Managed system upgrades and client installations based on user requirements.
• Developed Batch files using Maxl and Rule files to upload data from financial database toEssbasecube.
• Services for activities such as filter creation, creation of users and creation of groups.
• Created and scheduled Batch Jobs for complete automation processes for application refresh and backup.
• Designed and created a security plan to manage security at the user and group layer, the global access layer and the server level.
• Implemented various Optimization techniques to improve the performance of the cube.
• Responsible for Performance Monitoring, Security, Backup and Recovery of the cube.w
• Worked closely with management and end-user to develop and enhance the application processes that will result in a stable productive environment.
• Involved in documentation on allHyperionPlanning processes for all business groups and technical documentation on business rules and calc scripts.

ENVIRONMENT: MS SQL Server 2005, SQL Server Reporting Services 2005, SSIS, Front Office 8.3 / 10.2 /10.3, Windows XP/ NT / 2000, MS Office 2003

Hyperion Consultant

Confidential

RESPONSIBILITIES:

• Involved in design and development of Account, Entity, ICP and other dimensions inHFMand FDM.
• Designed standard and custom dimensions using EPMA utilities for EPMA applications and used FDM for classic applications.
• Exported data out formHFMapplications and loaded the same to Essbase applications used for all standard reporting needs.
• Performed detailed documentation of tasks, processes and optimization requirements based on run times during data load and application build, within the project.
• Perform complex security setup for all theHyperionapplications using Shared Services and application proprietary utilities.
• Implemented Essbase in connection to produce ad-hoc reports.
• Translated end-user requirements into application design specifications.
• Implemented project in two phases one phase is initial implementation ofHFMapplication and second phase is the enhancements
• Worked on migration ofHFMapplications from 9.x to 11.x and involved in installation/configuration and migration process for old to new environments.
• Created, configured and maintainedHFM(Classic and EPMA) and FDM Applications.
• Created complex and simple Member Lists for usage in data forms, journals and other data load activities.
• Integrated FDM Applications withHFMApplications by creating mappings between FDM andHFM Applications for loading data and metadata.
• Created Import Groups, Import Scripts and Integration Scripts for importing data to the Locations in FDM.
• Worked on reconciliation and loading on operational financial data and extensive use of FDM and HFM
• Performed various maintenance activities like updating metadata, loading data, creating member lists and enhancing application rules.
• Extensively used Smart View for all ad hoc and standard reporting needs.
• Applied security levels to users for Application Objects and Locations within FDM.
• Performed detailed documentation of tasks, processes and optimization requirements based on run times during data load and application build, within the project.
• Perform complex security setup for all theHyperionapplications using Shared Services and application proprietary utilities.
• Created end user training guides and trained users on the applications developed.

ENVIRONMENT: HyperionFinancial Management 11.1.1.3,HyperionEssbase 11.1.1.2,HyperionPlanning,HyperionWorkspace, HyperionFinancial Reporting, Excel Spreadsheet Add-In, VB Script, Smart View, Window Server 2003 and UNIX Servers, Oracle SQL Developer 2.1, Oracle 10.2.

Essbase Analyst/Essbase Developer

Confidential

RESPONSIBILITIES:

• Implemented Essbase in connection to produce ad-hoc reports.
• Translated end-user requirements into application design specifications.
• Assured optimal match between cube design and report specifications.
• Develop new Essbase cubes and database objects or update existing ones to meet new business requirements.
• Optimized outline structure, loading and calculations through appropriate dense and sparse settings of dimensions, storage allocations and by dynamic calculations and debugging.
• Optimized cache settings, established user security, managed applications migration, established substitution variables and settings for dynamic time series, asynchronous processing, and editing/validating scripts.
• Developed and designed cubes using Essbase Integration Services.
• Managed system upgrades and client installations based on users requirements.
• Developed Batch files using MaxL, and Rules files to upload data from financial systems Database to Essbase cube.
• Handled performance tuning, weekly back-ups and monthly consolidations of data and automated monthly/quarterly/annual report generation.
• Developed Analyzer OLAP views and sophisticated what-if scenarios for the end users.
• Documented and issued procedures pertaining to Essbase applications.
• Provided business analysts with advice and options on opportunities to leverage the tool and increase usage.

ENVIRONMENT: Hyperion Essbase 9, EAS 9, EIS, Excel Spreadsheet Add-In, Windows 2003.