Data Project

Professional Summary

Skills

Work History

MANORANJITHAN VEERAPPAPILLAI

**** ******** ****, *** ****, Plano, TX 75024 847-***-**** ********@*****.*** Accomplished Hyperion Consultant with 12 years of diverse IT experience including Financial Systems Implementation and Administration, Business Analysis, Technical Consultation and Service Delivery with the ability to solve challenging business problems using my cross-functional background in finance and information systems. Proactive team worker with excellent communication skills and integrity. Highly adaptable in fast-paced and complex work environment.

Tools & Technologies

Financial Consolidation : Oracle Hyperion

v.11.1.2.4 (HFM,HTP)

Integration : Oracle Hyperion v.11.1.2.4

(FDMEE,ODI)

Metadata Management : Oracle Hyperion

v.11.1.2.4 (EPMA,DRM)

OLAP : Hyperion Essbase 6.4

Financial Planning : Oracle Hyperion

Planning 3.5

Scripting Languages: HFM Rules, Visual Basic,

Batch Scripts, ESSCMD, Jython, PL/SQL

Reporting : Oracle Hyperion v.11.1.2.4

(SmartView, Financial Reporting)

Operating Systems: Windows 7, XP

Databases: Oracle, SQL

Industry Knowledge

Consulting

Project Lead

Business Analysis

Service Delivery

Requirement Gathering

Software Development Life Cycle

Domain: Health Care, Retail,

Manufacturing,Financial Services

Interpersonal Skills

Team Management

Customer Engagement

Lead Consultant 02/2018 to Current

Infosys Limited

Project : HFM Business Rules Optimization

Industry : Financial Services

Role : HFM Consultant

Liaise with IT teams to understand requirement and propose rules optimization techniques. Re write HFM business rules adopting coding standards and industry best practices to improve performances

Re design the rule file to partition rules for historic periods and go forward periods.Cleanup the calculations that are discontinued for go forward periods Re organize rule file to logical groups

Create Sub routines for calculations that repeat.This reduce the code length, Maintenance and improve readability

Automate Cash flow calculations using HFM Web form and Cell text functions Limit the page dimension scope for calculations to improve Consolidation performance Devised testing strategy and performed unit testing. Project : IFRS Reporting

Industry : Financial Services

Role : HFM Consultant

Implemented IFRS (International Financial Reporting Standards) Reporting solution in an existing HFM application

Liaise with BI, Accounting and Finance teams to define business requirements and contribute to business requirements document (BRD)

Partnered with Accounting teams to design and implement Chart of Account for IFRS Reporting

Addressed IFRS Reporting solution using a Custom Reporting dimension that categorizes the data between USGAAP and IFRS

Developed HFM Rules to support IFRS Reporting - Retained Earnings and Out of Balance Calcs for IFRS Reporting Members, IFRS Negative balance Re class, Populate IFRS Supplemental Accounts for OCI /Capital Surplus from Balance Sheet Roll forwards Provided various data Integration Solutions to load IFRS balances to HFM : OSX to HFM data Integration, HFM Journals

Technical Consultation to POST HFM Journals for IFRS Opening Balances and Closing balances Developed Hyperion Financial Reports to support IFRS Reporting Contribute to Project Plan with Project tasks, Efforts and Resource estimations Write and execute Unit test cases for HFM development Assist with System Integration and User Acceptance testing Devised deployment plan for Production Migration

Support technical aspects to Oracle HFM in developing Rules and troubleshooting Financial Close issues

Manager 11/2016 to 02/2018

Cognizant Technology Solutions

Project : HFM Product Restructure & Historic Data Restatement Industry : Manufacturing

Role : Consultant - HFM & FDMEE

Designed and Implemented solution to restructure Product Hierarchy and re state historical data to accommodate business changes

Restated the Actual data that summarizes data from the individual product members into a single product member in order not to disturb historical reporting of the business for any period prior to the cut over of the project

Technical Solution for data restatement using HFM Journals so that the data can be easily tracked for SOX audit purpose

Technical solution to Post Restatement Journals via Oracle FDMEE Prepare and execute data reconciliation strategy

Write and execute Unit test cases for HFM development Assist with System Integration and User Acceptance testing Devised deployment plan for Production Migration

Project : Application Maintenance & Support (L3)

Industry : Manufacturing

Role : Financial Systems Lead - HFM & FDMEE

Provide Support, Maintenance and the Continuing development of Consolidation application

(HFM) including but not limited to, consolidation of 30+ legal entities, multi-currency translations

, consolidating elimination and adjusting entries

Support the extract of data to HFM from SAP using FDMEE, including mapping, loading and reconciliation of data for actual and Budget/forecasts data loads to/from Hyperion planning application

Liaison between Consolidation and FP&A teams to ensure efficient controls and data movement

Support technical aspects to Oracle HFM including maintaining rules and modifications as requested by users; maintain translation, cash flow and consolidation/elimination rules in accordance with US GAAP; all HFM migration processes from environments (DEV to QA to PROD) to ensure completed correctly and data is validated before use Work on Master data maintenance using DRM & Security functionality in HFM Develop standard reports using FR studio and, where necessary, prepare ad hoc reports using smart view

Technical Lead 10/2006 to 10/2016

Wipro Technologies

Project : Oracle EPM Upgrade

Industry : Retail

Role : Consultant (HFM/FDMEE)

Lead an EPM Patch Upgrade Project which included upgrade of HFM, EPMA, FDMEE and HTP applications

Review and identify all the EPM conponents that require upgrade to maintain compatibility Review Know issues with the upgrade and perform business systems impact analysis Socialize system impact analysis with client and propose work around or alternate solutions Prepare Project Plan and provide status update to business and IT teams Apply the Patches in lower environment and perform functional testing Assist with System Integration and User Acceptance testing Devised deployment plan for Production Migration

Project : Application Maintenance & Support (L3)

Industry : Retail, Healthcare

Role : Financial Systems Lead (HFM/FDMEE)

Work closely with Consolidations and FPA teams to execute the Monthly financial consolidation process and coordinate data submissions from divisions Execute system changes for Metadata, business rules, web forms, reports, etc. based on requirements identified by business users. Ensure the specifications for these changes are properly documented and tested

Apply Hyperion Patch updates for various Hyperion components. Recycle Hyperion Services and apply application performance tuning

Partner with Infrastructure team in managing the Infrastructure and database Patch activities and troubleshoot system Performance issues

Partner with Oracle for any Patch updates, bug fixes and get updates on new product features. Identify business needs, perform impact analysis and determine system changes and upgrades

Understand and follow appropriate SDLC, S/Ox validation processes and application change management processes

Project : Application Maintenance & Support (L2/L3) Industry : Healthcare

Role : Consultant (Planning & Essbase)

Provide day to day technical support for Hyperion Planning and Essbase applications Create Hyperion Planning applications (Sales, Payroll and CapeX) for Yearly Budgeting and Planning process

Load Metadata and Data using HAL to Planning application in order to prepare for the Yearly Budgeting Process

Ensure overall system up time and timely availability of information and assist in troubleshooting hardware and infrastructure support issues as needed Maintain Hyperion application security

Analyze data issues and reconcile, as necessary

Maintain outline, metadata, and member formulas as business requirement changes Create Web Forms within Hyperion planning for business users to load the Budget data and train end users in using the web forms

Provide assistance to field users regarding issues or questions when loading or retrieving Education

Accomplishments

financial information

Master of Science: Software Engineering. 2010

Birla Institute of Science & Technology - Pilani,India Bachelor of Science: Physics

Bharathidasan University - Tiruchirappalli, India

Product Development

Designed solution and Implemented IFRS Reporting standard in an existing HFM application. Architect-ed solution and Implemented HFM data Restatement project to restructure Product Hierarchy and restate historical data.

Implemented End to End HFM Process Control functionality by assigning submissions of P&L data at Phase1, Balance Sheet data at Phase 2 and Balance Sheet Flows at Phase 3,which helped enhance data security and stream line submissions during critical Financial close. Worked on multiple Rules development related to Specific translations, Restatements, Equity re class, No Inputs, Currency Translations, Currency Overrides, and On demand rules. Designed and developed Financial Reports in compliance with IFRS Reporting standards. Business Systems Analysis

Liaison between Finance and Information Technology teams to participate and lead the development of Finance Consolidation systems to support business requirements Worked on various challenging and complex business requirements and converted them to technical design and solution.

Worked on various business impact analysis for Change requests that come from business and ensure smooth implementation of change with no impact to existing system & historic data. Research alternative technology solutions for existing business process and, where appropriate propose as service Improvement.

Process Improvement

Optimized HFM Business rules to improve consolidation performance and mimize maintenance.

Implemented End to End Automated Process for daily FULL backup of HFM repository and restore it to a staging database to maintain up to date back up of Production. Automated Essbase Consolidations from Sales, Payroll & Capex cubes to Main cube using ESSCMD and Batch Scripts which avoided manual consolidations and save time. Transformed multiple Smart view templates in to HFM Web forms and HFR reports for easy access and efficient use.

System Integration

Implemented various data integrations between SAP, HFM and other EPM applications using FDMEE/ODI components.

Designed and automated submissions of HFM Journal Adjustments via FDMEE which helped business users to avoid manual entries and expedite close process. Automated various FDMEE mappings using SQL script based mappings to avoid manual map updates. Cross reference target HFM members by directly pointing to EPM HFM Schema instead of hard coding target members

Developed FDMEE Script to validate Intercompany Accounts submitted without an Intercompany Partner and setup a Validation Intersection Report to identify them Automated Daily Spot Rate load to HFM using FDMEE batch System Upgrade

Lead and Implemented EPM Patch Upgrade Project which included upgrade of HFM, EPMA, FDMEE and HTP applications.

Project Management

Own Critical system issues, drive it though Closure with minimal system Outage and provide status updates to key stake holders till issue closure and Root cause Analysis. Prepare Statement of Work (SOW) and Contribute to Project Plan with Project tasks, effort and resource estimations

Host meetings with IT and Finance teams and lead Business Requirements and design discussions.

Manage issues and escalate effectively

Trained and supervised new staff on Finance applications. Understand and follow appropriate SDLC, S/Ox validation processes and application change management processes.

Contact this candidate