PROFESSIONAL SUMMARY:

• Around 9+ years of experience in Hyperion Financial Management (HFM), Financial Data Quality Management (FDQM).
• Strong experience in Business Analysis, Project Management, Financial Planning & Analysis with focus on domains like Investment Banking, and financial services sector and Health Care
• Excellent Interpersonal, Client interfacing, Communication, Negotiation and Presentation skills.
• Highly adoptable to new environments & changes with willingness to accept new challenges.
• Expertise in full project life cycle development for implementation and integration. A proactive planner with expertise in handling Projects, Business Analysis, Business Development, Internal Audit and Leading the growth of profitability by increasing team revenues, expanding services and products to existing clients.
• Expert Knowledge on Hyperion Financial Management (HFM), Hyperion Enterprise, Financial Data Quality Management (FDQM) V9.3/11.1 Application Creation (Classic & EPMA) Hyperion financial management Data Grids, Data Forms, Security Class, Metadata Maintenance, Task List, Member Lists, Data Loads, inter - company eliminations, Plug Accounts, Journal Adjustments & running Consolidations, Calculation Manager/ Rules Editor for managing.
• Expertise in Hyperion Financial Report 11.1 and Excel Add-In on Windows.
• Hands on experience in performing Financial Reporting, Statement Analysis, Trend Analysis, Variance Analysis.
• Business process improvement, financial management, Hyperion Implementation Support for Essbase and risk management, Hyperion reports, Hyperion smart view.
• Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing, and migration from development to production.
• Experience in using SQL, PL/SQL, functions and procedures.
• Highly organized with proven ability to prioritize, manage multiple tasks, and meet deadlines with deliverables.
• Good team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.

TECHNICAL SKILLS:

OLAP Tools: Hyperion Financial Management 11.x/9.x, Financial data quality management 9.x/11.x, Financial data quality management Enterprise Edition, Smart View, Workspace

Programming Languages: SQL, PL/SQL, VB

RDBMS: Oracle 11g/10g/9,MS Access

GUI &Reporting Tools: Hyperion Financial Reporting 11.x, Hyperion Interactive Reports, Web Analysis, Dashboard, Smart View, Essbase Excel Add-in

IDE: EAS, FDM Workbench, HFM Client, HFM Rules Editor, FR Studio

Domains: Financial, Telecom, Banking, Healthcare

Operating Systems: Windows NT/2000/XP/2007

Industry Standards: SOX, IFRS, BASEL II

PROFESSIONAL SUMMARY:

Confidential, Milpitas, CA

Hyperion HFM FDM Consultant

Responsibilities:

• Documented and monitored risks to project or key deliverables. Asses project requirements by gaining functional application knowledge and investigating functional areas of concern.
• Involved in Hyperion HFM & FDM Development Version 11.1.2.2.
• Loading and Scanning of Metadata, building alternate hierarchies and correcting the errors before extracting in to HFM applications.
• 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.
• Trained users so they could review and validate data in HFM.
• 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 Reports as per the requirement by using Hyperion Financial Reporting.
• Worked with SME/Finance Teams to gather the consolidation application requirements.
• Designed Business requirements documents based on the analysis of the current business model.
• 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.
• Worked with end-users and SME to establish best practice and problem solving.
• Developed static and dynamic reports in HFR.
• Implemented FDM for integrating and validating financial data and then exporting it into HFM (Hyperion Financial Management).
• For EPMA applications used application library/dimension library/job console and used EPMA utilities to manage metadata related to the HFM EPMA applications.
• 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.
• Helped Lumentum to build CAFR and 40 financial statements.
• Helped Lumentum to eliminate manual processes by automating reports, saving time during an accounting close.
• Worked on adapters, mappings, locations, imports, exports, reports using financial data management.
• Created and Modified HFM rules to perform various functions (No Input, Consolidation, Calculation, Currency Translation etc.)
• 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.
• Assisted in HFM/FDM annual SOX audits by providing documents, data and reports to internal/external auditors.
• Prepared templates for achieving quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers.
• Created complex security of the Hyperion applications using Hyperion shared services and HFM security.
• Created reports based on the business user requirement using Hyperion Financial Management and Smart View (Eg: Cash Flow, Funds Flow, Depreciation and 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 (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, MS Visio, MS Office, Oracle Server

Confidential, Chicago, IL

Hyperion HFM FDM Consultant/Hyperion Lead

Responsibilities:

• Responsible for Day to day support with the business and working closely with IT.
• Gather analysis, prioritize and document business requirements.
• Responsible for the Security setup for HFM and FDQM. Individually handled complete security groups and security classes for the entire 405 entities.
• Actively participated in the Confidential for the users and presented user- class to a group of twenty.
• Involved in Troubleshooting and helping users on HFM, FDM and HFR.
• Developed HFM Change Control Processes for IT and Finance system based controls, including implementation of system tools to support remediation strategies for the Financial Statement Close Processes.
• Maintained user security of all HFM application in all three (dev, QA, Prod) environments.
• Developed materials and manuals for new and advanced HFM users and conducted in class-room session with the users.
• Designed basic rules for Roll forward differences, Variance accounts, Cash flow reporting, Statistical calculations.
• Developed many kinds of reports like tabular report, chart report, cross-tab report using Web analysis studio.
• Developed various financial reports based on the requirements gathered from SME's using Hyperion Financial Management Studio.
• Prepared Profitability Reports, which would compare the actual data to forecast data.
• Created reconciliation spreadsheets to tie data between HFM applications using Excel Add In and Smart View.
• Prepared quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers.
• Reviewed Test Procedures, Test Cases, and maintained Test Scripts, analyzed bugs and interacted with team members in fixing errors.
• Involved in defining requirements, functional specifications, designing documentations and testing strategies.
• Handled performance tuning, weekly back-ups and monthly consolidations of data and automated monthly/quarterly/annual report generation.
• Documented and issued procedures pertaining to HFM application
• Applied security on different applications by creating Filters on its dimension members.
• Managed the task flows for Consolidations and Extended Analytics and set the trigger to run the intraday task flows for every 3 hours’ interval.
• Responsible for locking and unlocking the periods in FDQM.
• Responsible for running the process monitor report in FDQM.
• Coordinated user account setup/changes within HFM and FDQM.
• Involved in Loading Data through Flat files and responsible for Metadata refresh and metadata loads.
• Involved in setting up connection information and setting up the Point of View for Extended Analytics.

Environment: Hyperion Financial Management 9.x/11.1.1.3, Hyperion Essbase 9.3/11.1.1.3, Hyperion Workspace 9.3/11.1.1.3, ODI 10.1.3, Hyperion Financial Management 9.3/11.1.1.3, Excel Spreadsheet Add-In, Smart View, Oracle Server.

Confidential, Washington D.C

Hyperion Lead

Responsibilities:

• Involved in Hyperion HFM Development, Migration & Upgrade of four applications from Version 9.3.1 to Version 11.1.2.1.
• Involved in installation and configuration of HFM application version 11.1.2.1.
• Involved in migration of four FDM applications from Version 9.3.3 to 11.1.2.1.
• Involved in modifying and maintaining business rules for Essbase and HFM applications.
• Scanning of Metadata and correcting the errors before extracting in to HFM applications.
• Created applications, locations, import formats, mapping templates, control tables, Integration scripts and validation rules in FDM.
• Strong exposure to Essbase Report Writing.
• Coordinated with the Technical architect team in migration of ESSBASE and FDM.
• Checked the interaction of FDM with HFM post migration.
• Created Essbase Reports by leveraging current Business Object Reports.
• Coordinated user account setup/changes within ESSBASE & FDM.
• Performed data analysis using various tools like SAS, Essbase, SQL queries against various databases.
• Responsible for communicating to the business about the environment up and down time for maintenance.
• Worked with end-users and SME to establish best practice and problem solving.
• Initiated meetings with stake holders for weekly updates on risk and milestones.
• Performed requirements management for in-depth design and layout. Best practices played a large role in the conversions.
• Prepared work documentations on process flows and design methods

Environment: Hyperion System 11.1.2.1 (Fusion Edition) Financial Management, FDM System 9.3.3, FDM System 11.1.2.1, Hyperion System 9 /System 11 Financial Reporting (HFR), Smart View.

Confidential, White Plains, NY

Hyperion 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.
• As part of analysis explored various ERP systems (GL, HR, Payables, receivables modules) as part of analysis and worked on multicurrency as well.
• Trained users so they could review and validate data in HFM.
• 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.
• 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.
• 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.
• 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.
• Created and Modified HFM rules to perform various functions (No Input, Consolidation, Calculation, Currency Translation etc.)
• Troubleshooting and helping users on HFM, FDM and HFR.
• Responsible for independently handling support teams.
• Experience in Full life cycle management implementation: Requirements gathering, Design, Build and Test.

Environment: Hyperion Financial Management 9.x/11.1.1.3, Hyperion Enterprise, ODI 10.1.3, Excel Spreadsheet Add-In, VB Script, Smart View, Window Server 2003 and windows Servers, Oracle SQL Developer 2.1, Oracle 10.2

Confidential, Tampa, FL

Technical Specialist

Responsibilities:

• Involved in Budget Sensitivity, Expense, Ratio, Headcount and Scorecard Analysis.
• Prepared and analyzed business and financial model of the prospective alliance partner.
• Strong exposure to Hyperion Enterprise version.
• Documented and issued procedures pertaining to HFM application
• Applied security on different applications by creating Filters on its dimension members.
• Created Business Requirements Document (BRD) and Software Requirements Specifications (SRS) in Rational Requisite Pro to communicate the application requirements and business rules to the technical team.
• Directed and participated in optimization studies of the HFM functionality to improve use of the application for alternative solutions.
• Assisted in HFM/FDM annual SOX audits by providing documents, data and reports to internal/external auditors.
• Prepared templates for achieving quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers.
• Created complex security of the Hyperion applications using Hyperion shared services and HFM security.
• Created reports using Hyperion Financial Reporting, Spreadsheet Services.
• Framed MAXL scripts to automate the calculation scripts.
• Performance optimization by tuning the caches.
• Created reports based on the business user requirement using Hyperion Financial Management and Smart View (Eg: Cash Flow, Funds Flow, Depreciation and Amortization).
• On time completion of all assigned tasks and desirables meeting the business expectations and timelines.
• Determined the composition of menthol using the data obtained from distillation columns.
• Improved the aspects of peppermint.
• Developed the material preparation using Hyperion enterprise.
• Worked on Hyperion to retrieve the data and work on the same to report to the cost center directors.
• Responsible for building reports in Hyperion.

Environment: Hyperion Financial Management 9.x, Hyperion FDQM 11.1.2, Hyperion Shared Services, VB Script, Smart View, ODI, Web Analysis, Windows 2003/NT

Confidential

Hyperion Functional Consultant

Responsibilities:

• Participate in the sales calls document the client/ customer requirements and provide the knowledge transfer to the team on the requirements
• Work on the proposals and SOW’s
• Provide consultative advice regarding existing processes and provide solutions to help reduce on-going maintenance
• Customize/Support the planning Forecast and Budgeting application as per new business process.
• Work with cross-functional teams to deliver enterprise-wide solution such as translating functional documented requirements provided by the business into the technical development and integration relating to Hyperion DRM, Planning, HFM, Strategic Finance and Essbase systems
• Worked on the design and implementation of user initiated functionality and application changes acting as an subject matter expert on projects/applications as required
• Work with other teams for support and project delivery - DBAs, functional support teams, project teams, application owners, etc.
• Load Data to HFM/Planning using FDM/FDMEE process.
• Work with the vendor on resolution of technical issues in the Hyperion environments

Environment: Hyperion Financial Management 9.x, Hyperion Essbase 9.x, Hyperion DRM, MS Visio

Confidential

Hyperion Consultant

Responsibilities:

• Created the installation and Configuration document for Hyperion Products.
• Actively involved in gathering user requirements.
• Developed Financial Reporting Cube related to the Cost of processing checks, ATM Machines, Customer Loans and Credit cards.
• Involved in dimension building and data loading using OLAP Models and Meta outlines.
• Automated Essbase operations through ESSCMD and MaxL scripts in shell script programming to run monthly balance sheets and ledgers.
• Involved in performing DBA activities such as performance tuning the calculation scripts, along with taking periodical ESSBASE backups.
• Involved in development and modification of existing financial and marketing reports which include corporate consolidation reports, and financial and planning reports for management.
• Designed and Developed reports and dashboards using Hyperion Interactive Reporting and Web Analysis.
• Developed various conditional numeric functions to add computed columns in query, result, pivot and report sections in Interactive reporting.
• Knowledge on Accounts Receivable (AR), Accounts Payables (AP) and Human Resources (HR) modules.
• Worked in the end to end process of creating the Physical, Business and Presentation Layers.
• Modified existing Physical layer to add more tables and Business Layer to add more Dimensions in the Oracle BI Admin Tool.
• Created Calculated Measures and set appropriate Aggregation properties for the Dimension members.
• Created appropriate security privileges on subject areas and dashboards according to business requirements.
• Created & formatted Spreadsheet reports, Charts, Pin board displays using Hyperion Web Analysis Reports and published on workspace.
• Involved in creating new reports, modifying existing according to the User requirement, Problem solving and Query Tuning on Errors while report generation.
• Schedule jobs for existing reports and sending email notification, and also exported to html, Excel and PDF.

Environment: Hyperion Financial Management 9.x, Hyperion Essbase 9.x, Hyperion, Smart View, Oracle Application GL module, Web Analysis, Windows 2003/NT, Excel Add in.