Manoranjithan Veerappapillai

• Participate in requirements workshops , lead design and Implementation of Onestream Solutions.
• Member of Onestream COE to review and sign off on all Technical aspects of application lifecycle: design, build, test, performance optimization, upgrade, and production rollout.
• Assist Project Delivery teams with techincal build and Operations support team with troubleshooting technical issues and implementing business as usual tasks.
• Develop re usable components , establish best practices and setup COE design review guidelines.
• Contribute to Project estimations and resource hiring.

Project : Driver based Planning

Client - Self Storage Facility

Accomplishments:

• Implemented Driver based Revenue Planning solution by transitioning from existing Projections and Budget Excel based Models.
• Built various complex calculations using linear regression functions,Data Buffers , 2 pass consolidations,Global variables,SQL functions within OS.
• Implemented Solution to Budget for Same Stores and Non Same Stores which vary by Period.
• Implemented efficient Integration solutions to Ingest high volumes of data like New Customer Vacates Factors , Seasonality Factors across 1500 entities to drive Store Budget.
• Leveraged Table Data Manager to store and calculate drivers that doesn't fit to OS dimensionality ex: Elasticity and Discounts
• Automated the end to end Budget Process using OS Data Management Jobs and Business Rules.The Budget Process involve 2 iterations of Budget for 3 Years.

Project - Driver Based Planning

Client - Bulk food Retailer

Accomplishments:

• Implemented Driver based Planning Solution to Budget and Forecast P&L.
• Implemented Weekly and Monthly Budgets with Period 13 within the same application.
• Built Complex Calculations to Budget Freight Cost by Linehauls , Store Rental Cost with Step up and Step down Rent Rates,Retail Sales incorporating Closures,Renovations and Relocations by Period, Retail Sales Budget Reclass by Owned Vs Franchise Store by Period
• Implemented solution to apply Finance team and CFO Overrides on the Calculated Budget.
• Implemented an Automated Seeding Forecast process to Seed Actual on Closed Periods and Prior Forecast/Budget for Forecast Periods using DM Jobs and Business Rules.
• Built DM Jobs and Business Rules to push Weekly Budget to Monthly Budget Scenarios.

Project - Driver based Planning

Client - Oil Gas

Accomplishments:

• Implemented driver based planning to calculate Budget for Revenue , Royalties and Transportation Cost for Oil Gas Productions.
• Developed Business rules to allocate the Budget at detailed Cost center using the Price,Royalty and Transportation drivers seeded at Summary Cost Center.
• Imported Opex Budget at Summary Cost Center and developed business rules to allocate it to detailed Cost Center using the Oil/Gas Production and Well Count at detailed Cost Center.
• Developed efficient business rules using data buffers to calculate and allocate the Budget to detailed Cost Center using the Imported Budget or seeded drivers at Summary Cost Center.
• Developed Inter Application Data Outbound Integrations to push the Budget to Parent Company Application using DM Jobs and Business rules.

Project - Driver Based Planning

Client - Shared Services Company

Accomplishments:

• Implemented Driver based Planning for BalanceSheet by converting their existing BalanceSheet Excel Model in to OS Solution.
• Enabled users to Budget/Forecast P&L at Detailed Account and BalanceSheet at Summary Account level.
• Implemented varying logic by group of BS Accounts to Budget and Forecast using Trailing X Period Averages of Actual and / or Prior Period Forecast and Seeded Drivers.
• Implemented Seeding Forecast on the Actual Periods for both P&L and BS Accounts.

Project - Driver Based Planning

Client - Vehicle Protective Film & Coating Manufacturer

Accomplishments:

• Implemented Driver based Planning with Mid Year Budget and Rolling Forecast.
• Actuals are reported by Legal Entity while Budget & Forecast is performed by Cost Center (Entity) and its Local Currency.This is achieved by implementing a separate Cube for Planning with CostCenter as Entity.
• Written Business Rules to Seed USD Actuals from Consolidations Cube to Planning Cube by Cost Center and converting to its Cost Center Currency.
• Product Revenue and COGS are Budgeted by Customer in a Separate Cube due to the high volume of Customer Data.
• Implemented complex and efficient business rules using Data Buffers to distribute Yearly Total Revenue Budget across Budget Periods and then allocate it to each Revenue GL based on Actuals.
• Written Business Rules with 2 Pass consolidations to Forecast SG&A based on the Forecasted Revenue of Total CostCenter.

Other Accomplishments

• Implemented 4 standard USGAAP Consolidations & Reporting Solutions.
• Implemented 2 Semi Automated USGAAP Cashflow Solution and Reporting using Dashboards.
• Implemented several Database and API based Direct Connect and Drillback Integrations.
• Implemented Dashboard and Reporting capabilities to execute Seeding Forecast and Budgeting Processes.

Project : USGAAP & Local GAAP Reporting Improvements

Accomplishments:

• Re designed HFM applications & Data Integrations for USGAAP & Local GAAP Reporting to meet Amazon's scale.
• Re designed Metadata by cleaning up un wanted custom members to reduce the data volume fed from GL to HFM applications.
• Implemented global calculations for ALL GEOs in the Local GAAP applications
• Re designed Data Integration for Local GAAP application to consolidate 80 different Integrations by each GEO to One single integration that feeds from Secondary Ledgers to ALL GEOs in HFM.

Project : AWS Buy/Sell - Currency Translation

Accomplishments:

• Designed Technical Solution and Implemented Currency Translation in Local GAAP HFM application using Bloomberg Rates and National Bank Rates for specific GEOs.
• Hands on HFM application development to setup Metadata , Re class rules , Beginning / Current Year Retained Earning ,CTA and Currency Overrides on translated currency.
• Built Data Integrations using ODI/FDMEE to feed Bloomberg and National Bank Rates from GL to HFM

Operational Support Include :

• Technical Support for Financial Close using Oracle EPM Suite of tools HFM, Essbase, FDMEE/ODI and HFR.
• Worked on HFM Application and Integration Enhancements and Bug Fixes.
• Intake Operational changes for HFM/Integrations from business users and perform impact analysis , estimate level of effort and create work back plan.
• Participate in root cause analysis and work with Infrastructure and DB teams to troubleshoot Application / Integration performance issues.
• Contribute to application testing with Hyperion upgrades and patches.

Project : Contemporary Finance Information Program
Accomplishments:

• Represent IT as Oracle Hyperion SME for Projects and Operations across following FInance domains : External Reporting (HFM) , Management Reporting (Essbase) , Planning & Forecasting (Hyperion Planning)
• Provide technical guidance to Operations team to solve application issues

Project : Financial Information Transformation - Tableau Reporting

Accomplishments:

• Implemented Integration using FDMEE/ODI to feed HFM data to Enterprise Data warehouse for Financial Reporting using Tableau
• Leverage existing ODI Packages to execute FDMEE DLRs to Extract data and transform it to a Hyperion Staging table for the consumption of ODS
• Create Data and Metadata Views as per the Reporting requirement in order for the Target systems to pull the data
• Develop Batch scripts to Schedule the ODI packages for data Outbound

Project : Oracle HFM Business Rules Optimization
Accomplishments:

• Re write HFM business rules adopting coding standards and industry best practices to improve performances
• Proposed Automated Solution for Cash flow calculations using HFM Web form and Cell text functions

Project : IFRS Reporting

Accomplishments:

• Implemented IFRS (International Financial Reporting Standards) solution in an existing USGAAP HFM application
• Partnered with Accounting teams to design and implement Chart of Account for IFRS Reporting
• Designed IFRS Reporting solution using a Custom Reporting dimension that categorizes data between USGAAP and IFRS
• Developed HFM Rules to support IFRS Reporting - Retained Earnings and Out of Balance Calculations for IFRS Reporting Members, IFRS Negative balance Re class, Populate IFRS Supplemental Accounts for OCI /Capital Surplus from Balance Sheet Roll forwards.

Project : Oracle HFM Product Restructure & Data Restatement

Accomplishments:

• Designed and Implemented solution to restructure Product Hierarchy and re state historical data to accommodate business changes
• Technical Solution to post data restatement using HFM Journals so that the data can be easily tracked for SOX audit purpose

Project : Application Maintenance & Support (L3)

Accomplishments:

• Provide Support & Maintenance for Financial Close using HFM/FDMEE applications.
• Liaison between Consolidation and FP&A teams to intake new requirements and assist with system issues.

Project : Application Maintenance & Support (L3)

Accomplishments:

• 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
• Partner with Infrastructure and Oracle teams 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
• Lead an EPM Patch Upgrade Project which included upgrade of HFM, EPMA, FDMEE and HTP applications