SUMMARY

• 10+ years of professional IT experience in Oracle Hyperion Enterprise Performance Management Architecture EPMA Products such as Hyperion Financial Management, Essbase Administration Services, Hyperion Financial Data Quality Management FDM/FDMEE, Hyperion Planning, Hyperion Financial Reports, Hyperion Smart View, Hyperion Shared Services Console, Hyperion Calculation Manager.
• Experience in end to end implementation including the design, development, implementation, testing and maintenance of Hyperion financial applications which includes requirements gathering and analysis, preparing BRD (Business Requirement Documents), design document and develop Hyperion application objects in design phase, Creating end user training documentation for UAT (User Acceptance Testing) and training users.
• Good understanding of financial accounting concepts (balance sheet, Income and Cash Flow statement, handling multi - currency translations, roll forwards, closing consolidation process, reconciliation of trial balance in HFM application, minority interest and Good will eliminations, CTA and FCTR calculations, consolidation methods, journal entries, intercompany unit transactions, cash flow statements, working with opening Balances, Constant Dollar calculation financial close process) to develop in HFM application and internal and external reporting processes.
• Experienced in creating HFM rules such as calculation, multi-currency translation, consolidation, ICP, input/no input, dynamic rules and business rules to calculate minority interest, good will, Cumulative Translation Adjustment, Foreign currency translation and creating member lists.
• Designed complex security model for HFM and Essbase applications by creating and managing Active directory users and groups at various application levels using Shared Services Consol.
• Strong knowledge in migration process from one environment to other by using extended analytics, LCM and copy application utilities and data reconciliation in between the different environment applications.
• Expertise in creating Financial Data Quality Management (FDM/FDMEE) application by building locations, import formats, periods, control tables, integration scripts, validation rules and implementing import scripts to load the data from different data sources like Essbase, PeopleSoft, Flat Files to HFM. And in automation of data loads using FDM/FDMEE batch loader and Task Scheduler.
• Design and enhance of Hyperion financial reports using Financial Reporting Studio in creation of monthly, quarterly and yearly reports of balance sheet and income statement and cash flow statement, currency translation, ICP elimination, journal reports, minority interest report, goodwill elimination report, statutory and MIS reports.
• Good Knowledge on task automation, application backups, performance tuning, troubleshooting, debugging and optimization of Hyperion Financial Management application.
• Conduct workshops for UAT (user training), prepare software documentation (user guides) and technical report writing.
• Excellent interpersonal, presentation and communication skills with the ability to work in a team and a stand-alone environment.

TECHNICAL SKILLS

Hyperion: Hyperion Financial Management 9.3.1, 11.1.1.2, 11.1.1.3, 11.1.2.1 & 11.1.2.3, 11.1.2.4.200 , Hyperion Planning, Hyperion Financial Data Quality Management (FDM/FDMEE), EPMA, Oracle Hyperion Data Relationship Management (DRM),Hyperion Financial Reporting, Hyperion Shared Services, Essbase Administration services, SAP 740 version 7400

Databases: ESSBASE 11X/9X, Oracle 10g/9i, SQL, SQL Server 2005, Data Warehouse

Reporting Tool: Hyperion Financial Reporting, Essbase Add-in, Smart View, BOA Analysis

Programming Language: VB Script, Python scripting, Core Java, SQL, PL/SQL

Office Tools: MS Office 2000, MS Word, MS-Excel, MS Access 2000

PROFESSIONAL EXPERIENCE

Hyperion Administrator

Confidential

Responsibilities:

• Responsible for preparing the HFM and FDM applications for the month-end close process - Opening scenario (s)- Actual, Forecast (MIDMth), and plan in process management, updating task flows for data backups, automate consolidations, loading exchange rates & beginning balances for Actual and other forecast scenario (s) and send out communication to all Hyperion users about the system availability.
• Provides administrative support throughout the close-to-report under a tight close and reporting schedules for around 750 active users in the system all around the world on their monthly data uploads for “Actual” and Midmonth(“planning/forecasting”) data uploads in order to meet the user needs.
• During typical (U+5) month end close, Monitoring “Process Monitor report” in FDM and informing divisional heads about the data upload status of over 356 Reporting Units and troubleshoot/ resolve in case of any mapping related issues in FDM.
• Monitoring the loading, promotion, and consolidation of data in HFM: Lock both HFM and FDM applications within the time frame once the ME is closed. Running consolidations, translations in HFM and data reconciliation at each business unit level using 10KQ BS, PL & CF Comparison Smart View reports.
• Responsible for handling metadata change requests (adding new entities, account, custom dimension members, rules logic, creating New FDM locations and Mappings, set up security for new locations) under system maintenance, by obtaining divisional heads approval on metadata change requests. Documenting soft copies of change request (emails and approvals) for the SOX controls. Migrating application changes across environments (dev, test, prod) using LCM.
• Maintaining user security in Hyperion shared services console, provision/ de-provision users by following strict divisional approvals in order to grant/revoke access from system. Documenting all required emails related to security requests in PDF soft copies for the auditing purposes (SOX controls).
• Creating new security groups and assigning roles as required to by the business during monthly system maintenance changes. Performing monthly security reviews in between Active Directory, HFM, FDM, applications and with Financial Systems common mailbox contacts in order to maintain active users in all the systems and providing monthly documentation to the higher management.
• Performing 90-Day in-activity task to filter in-active users from shared services: HFM and FDM groups in order to remove inactive user’s access from the system.
• Creating data grids & forms in HFM, updating existing reports/ building new reports in Hyperion financial reporting studio if needed.
• Trouble shoot and Resolving smart view related user issues.
• Extracting and loading Actuals data to other down steam systems once month end close is completed.
• Responsible for performing daily admin activities such as data & task audits and tracking daily security changes and maintain/ document all changes for the SOX auditing purposes. And monitor the HFM server’s health check to avoid Systems down times.
• Acts as liaison between Secure-24 (IT infrastructure Team) and with Hyperion users in case of any server failures/application unavailability.
• Hyperion EPM Troubleshooting, Tuning, Disaster Recovery testing, Patch testing, Backups and Restore and documenting all test results and send it to Secure-24 with the necessary approvals for the patching Prod. Communicating with Secure-24 infrastructure team in case of any test failures.
• Maintains active Hyperion users contact list in Financial Systems Shared mailbox in order to send system updates / communications.
• Handled SAP securities by assisting users on user quires which relates to either access/ BOA reports and documenting frequently asked questions and posted it on Confidential Financial systems website.
• Performing other system related tasks as assigned my divisional heads and by direct reporting manager (Consolidations Director)

HFM Developer

Confidential

Responsibilities:

• Responsible for maintaining the corporate financial systems including Hyperion Financial Management (HFM) and Hyperion Financial Data Quality Management (FDM) applications.
• Working closely with a Project Manager and with the business on list of assigned tasks.
• Assist business with monthly close issues within a scope (HFM, FDM, FR and SmartView)
• Design, troubleshoot and migrate HFM reports as per business requirements.
• Maintains HFM metadata changes, FDM mappings for both new and updated accounts and data uploads in to HFM.
• Provisioning/Deprovisioning securities in shared Services.
• Migrating application changes and databases across multiple environments.

Hyperion Systems Administrator

Confidential

Responsibilities:

• As an admin, scheduling data loads from EBs to HFM application through FDMEE during the month end, troubleshot and resolving in case of any data loads issues.
• Involving month-end close activities and work with the business to ensure a timely close process.
• Maintaining and updating metadata (to process monthly metadata requests), rules and reports in HFM application on a monthly basis as needed by the business.
• Creating new locations and Updating mapping tables in FDMEE based the new requirement.
• Maintaining system security based on requirement to provide access to users
• Creating data forms, building new reports and maintaining existing reports and sending to end users as per the requirement.
• Maintaining Smart View connections to reconcile any data related issues after loading data and Journals and assisting users on any smart view connection issues.
• Maintained monthly backups of task and data audits of the application to increase the applications performance.
• Taking backups of applications using LCM and maintaining applications across development and Production servers.