Oracle Finance Functional Consultant
Resume:
NITHYA RAJAMURUGAN
*** **** ******** ******, ***# 1106,
Chicago (IL) - 60610
E-mail: ******.***********@*****.***
Summary
< Almost 9 Years of overall experience in Oracle Applications that includes
R12 Implementation, Global Rollouts, Upgrades and Production Support
projects.
< Involved in 4 full cycle implementations that includes Requirements
Gathering, Fit Gap Analysis, Solution Design, Configuration,
Implementation, Customization, Enhancements, Testing and Support.
< Well experienced in major Business Cycles viz-a-viz Order to Cash and
Procure to Pay.
< Proficient in working cycle of Procure to Pay business flow dealing with
almost all Oracle Financial modules like General Ledger (GL), Sub Ledger
Accounting (SLA), Payables (AP), Payments (IBY), Internet Expenses (IEX),
Cash Management (CM) and Purchasing.
< Expertise on Order to Cash Business cycle includes working experience on
modules like Order Management, Receivables (AR), Advanced Collections
(IEX), SLA and GL.
< Working experience on Primary Ledger, Secondary Ledger and Multi
Reporting Currency ledger setups and processes.
< Good understanding on TCA and its implications on Customer and Suppliers
Master Data processing.
< Great exposure towards easy configuration tool - DATALOADER.
< Working Knowledge on Oracle iSetup Configuration Migration utility.
< Proficient in authoring documentation of AIM methodology such as BR100,
MD50, MD70, CV40, TE40 and others.
< Expertise on Unit Testing, End-To-End Testing, Flow Through Testing,
Regression Testing, System Testing, Performance Testing, CRP, System
Integration Testing and User Acceptance Testing.
< Technically proficient in RICEW (Reports, Interfaces, Conversions,
Extensions and Workflows) components.
< Expert understanding and Solution Proposal capability on various Oracle
Developer tools including Oracle Forms and Reports, Oracle Workflows, XML
Publisher Reports, Web ADI, UNIX, FNDLOAD utility, SQLLDR utility,
PL/SQL, RDBMS etc.
< Experience in Oracle tools like SQL *Loader, SQL Developer, TOAD, SQL
Plus etc
< IT experience includes various roles from Core team member, Solution
architect and Solution Consultant in Oracle R12 ERP implementation,
Support and Rollout to multiple top class clients in different sectors
across the globe.
TECHNICAL PROFICIENCIES
Certifications:
< Certified in Infosys Technical Certification of P200 Oracle Receivables
< Certified in Infosys Technical Certification of P200 Oracle Payables
< Certified in Infosys Technical Certification of P200 Oracle General
Ledger
< Certified in Infosys Domain Certification of FFX100 e-banking Functional
REWARDS AND RECOGNITIONS
< Received SPOT Award for the Excellent Work and as a key Team Player on
Dec 2011
< Received SPOT Award for the Outstanding Performance on the Techno-
Functional Consultant role on handling one source POC for Key Financials
modules and processes that includes complex bank interfaces for countries
viz-a-viz China, Japan and Canada on Dec 2012.
< Received Direct Noticeable appreciation from Client on the Engagement
Level Feedback for her knowledge excellence, problem solving skills and
capability on August 2012.
VALUE DELIVERED TO CLIENTS
< Proposed and implemented an excellent solution of Intercompany Accounting
for the client handling both Manufacturing and Distribution business,
thereby ensuring that the accounting gets accurately captured as in the
respective boundaries.
< In a very short time span, effectively implemented the solution of
European SEPA regulations on Payments processing.
< Efficiently did the requirement analysis and proposal to select the
Gateway or Processor model for the credit card payments processing
requirement of a US shared service client in water solutions.
< Understood the out of box requirement and delivered the solution of
Different Strategies for Different Operating Units with different Aging
Buckets in Advanced Collections Module.
< Had embraced both functional and technical side and is instrumental in
scoping, requirement gathering, end to end testing and implementation of
the niche module of IExpenses.
< Efficiently proposed the solution for Employee Advances handling and
accounting in IExpenses modules with Customers' delight.
< Implemented the financial part of solution on entire Order to Cash flow
involving complex solutions on EDI and Lockbox processing of Receipts.
< Designed and implemented customization of Cheque & EFT Payment templates
creation w.r.t required Canadian & Australian Bank Specifications.
< Instrumental in Delivery of the Payment Interface to Citi Bank for US and
Canada viz-a-viz., various payment methods of Check, ACH, Wire, Positive
pay.
< Understood clearly the existing Customer Master Data in Legacy systems of
a Financial Shared Services company and wisely proposed solution to
capture the Legacy Customer Number by matching to make it suit to the
Oracle TCA structure.
< Effectively designed a solution on the make and to be requirement of a
custom Cash Forecasting Report which is to be based out of Business
Units.
< Had strategically re-designed an existing solution on Copy Attachment
functionality in Order to Cash cycle with an effective solution that best
suited the client thereby reducing the manual effort and human errors.
< Had delivered an effective solution with clients delight for a complex
end-to-end automation functionality of Move Orders approval and
processing mechanism in Inventory module with high level customization on
Oracle standard Forms and Workflows to a Fortune 200 Hi-Tech Components
Distribution Company.
< Had been the sole architect in doing the Supplier conversion for US
rollout of European Environmental and Industrial equipment manufacturing
client.
< Worked on a Logistics Service Provider Inbound and Outbound interface
which builds shipping documents in order to cash cycle.
< Had been part of various life cycle stages of an implementation project
with experience in Scoping, Requirements Gathering, Fit Gap Analysis,
Solution Design, Package Configuration, Deployment and Production
Support.
PROFESSIONAL EXPERIENCE
Oracle Applications Experience
Hyatt Hotels Corporation - ERP Implementation, Chicago, IL
Mar 2013 - Till date
Project Description: Oracle EBS R12 Implementation
Environment: 12.1.3
Roles and Responsibilities
< Scoping Hyatt's Gift Card processing and management into Oracle EBS R12
thereby facilitating the client with extensions of Gift Card Data
processing screen and Manipulation.
< Processing the Gift Card transactions in EBS and there by accounting the
transactions in Payables and Receivables to record Expenses and Revenue.
< Scoping and Managing Hyatt's Corporate Billing processing in R12
< Taxing of corporate authorities and the customers' using EBS Tax in
integration with Vertex.
< Necessary configurations in general ledger for Hotels and Corporate
systems.
< Responsible for requirements gathering, client discussions,
documentation, Functional Specification design documents, End to End
Testing and Test Scripts preparations and sign off.
Cummins Inc - ERP Implementation, Columbus, IN
Dec 2013 - Feb 2014
Project Description: Implementation of Oracle Apps for a Global
Distribution Business for US, Belgium, Norway, Romania, South Africa and
various regions across the globe.
Environment: 12.1.2
Roles and Responsibilities
< Onsite Finance Functional Consultant in the DBU NextGen program for
Cummins and had been on whole source POC for the modules - Payables,
Receivables and Payments.
< Client implementing ERP for distribution business also handling
manufacturing as well, successfully put forth the Global Intercompany
solution.
< Performing Fit - Gap analysis and Solution Proposal
< Thorough System testing and evaluation for fitment of solution with least
or no customization on the solution proposal.
< Requirements gathering and fine tuning the requirements and documenting
the same in the Business Requirement Documents.
< Supporting accounting issues w.r.t Primary and Secondary Ledger sync ups.
< Configuring Oracle General Ledger for Multi Currency Reporting (MRC).
< Month End support of Payables and Receivables accounts reconciliation and
period closure activities.
< Configuring the system for the required system with the proposed solution
< Gathering the setup details in the configuration document and configuring
for SIT, UAT and PRODUCTION.
< The Modules mentioned above is very niche modules, these modules got
different set of offsite team, co-ordinate with these teams for efficient
delivery.
Xylem Inc - ERP Implementation, Seneca Falls, NY
Dec 2012 - Dec 2013
Project Description: Implementation of All Finance Modules in US, Canada,
Europe for a Global Financial Shared Service
Environment: 12.1.3
Roles and Responsibilities
< Was responsible for solution design of the process flow and custom
components, configuration of instances, testing, Unit Acceptance Testing,
Production Support & providing resolutions for the issues.
< Proficiently designed solution, implemented and end-to-end tested for 13
different Payment Format Templates for various Payment Methods to Citi
Bank US & Canada added on to build one Consolidated Payment File for all
the formats - all within a very short time span of 2 months.
< Effectively did the analysis on Processor and Gateway model for Credit
Card Payments implementation - projected the usage, risks, pros & cons
involved to the Client & aided in deciding the well-suited model.
< Implemented Oracle Seeded AME Approval Process mechanism for Employee
Expenses Invoices created in Payables w.r.t Job Position hierarchy in
their concern.
< Analyzed and designed the solution for Approval process of Credit
Management in Order Management that gets integrated with Oracle
Receivables by developing a Custom AME Approval Mechanism process there
by giving the flexibility to the Business Users to define/modify the
approval group of authority.
< Designed the solution and prepared Functional Specification documents
along with Unit Test and Flow Test documents for AP and AR invoices
conversion and interface.
< Resolve issues related to Invoice and Payments issues like cancel
Invoices and payments are not getting accounted, invoice approval
workflow is not triggered, Invoice is partially accounted, voided payment
and recreated payment on same day not getting accounted etc.
< Having the necessity of importing the closed invoices to EBS, built a
custom logic of importing the invoices as in Open status followed to
automatically associate it with Sales Orders, thereby closing the Sales
Orders and its associated Invoices as well.
< Built a custom Accounting logic for Expenses accounting by building Sub
ledger accounting method in Sub Ledger Accounting module in oracle
applications.
< Finely built the Auto Close logic for Sales Orders closure that aids in
effective processing of Sales Orders closing.
< Other key customizations designed include AR and AP Invoice Conversion,
AR and AP Invoice Inbound and Outbound Interfaces.
< Was also responsible for documenting the business requirements, preparing
the test scripts and test cases, and functional testing of underlined
components.
< Expertise on System Administration Activities as in setting up of Profile
Options, Request Groups, Responsibility definition etc.
< Expertise on AOL activities like Concurrent Program development, Value
Set, Key Flex field, Descriptive Flex field, Request Sets etc.
< Expertise on identification of descriptive flexfields and attributes
usage to capture additional data on most used sales order tables.
Vaisala Inc - Global Rollouts, Finland
Jun 2009 - Dec 2012
Project Description: Oracle R12 Global Implementation and Rollouts for a
Weather Forecasting Devices Manufacturing Company head quartered in Finland
implementing Oracle Apps on various branch sectors as in Germany, USA,
Australia, Canada, China, Japan and United Kingdom
Environment: 12.0.6
Roles and Responsibilities
Implementation in Finland:-
< Individual functional consultant for Payables module.
< Configuration of Payables module for Client requirement involving Invoice
approval process categorizing Supplier Invoices and Employee Expense
Invoices.
< Preparation of BRD, Configuration and Setup Documents, Functional
Specification documents.
< Execution of CRP, SIT and UAT and a successful Go Live.
< Was responsible for Conversion of Payables invoices from legacy systems
to Oracle R12 thereby preparing the CV40 and Conversion Verification
Checklist documents
< Effective implementation of Integration with Oracle Payments (IBY) module
< Sourcing information of Bank and Bank Accounts from Cash Management and
processing payments using the Payment Documents of respective Bank
Accounts in Oracle Payments.
< Resolving issues w.r.t invoice accounting and supplier credit memo
invoice accounting.
< Auto Reconciliation of payable invoices in Cash Management.
< Period closure of payables open periods there by resolving issues in
payables ensuring proper accountings.
< Solution Proposal to use Forms Personalization instead of custom code
development on the necessary areas thereby minimizing the effort required
on coding.
Rollout in Germany:-
< Embraced both functional & technical side & was instrumental in scoping,
requirement gathering, end to end testing & implementation of the niche
module of IExpenses
< Effectively proposed a solution for Employee Advances Refund scenario
which also ensures a perfect stand of accounting of the transactions to
the customers' delight.
< Understanding the necessity of project based accounting of employee
expenses, proposed a custom solution that aids in tracking the expenses
both in payables & in iExpenses based on project.
< Understood the out-of-box requirement and delivered the solution of
Different Strategies for Different Operating Units with different Aging
Buckets in Advanced Collections Module.
< Setup EBS Tax for United Kingdom.
< Key customizations headed on are Cheque and Electronic Payment templates
creation w.r.t bank specifications.
< Effective implementation of SEPA Payment regulation for EUR payments
there by handling both Domestic and International Suppliers in EMEA
region.
< Prepared the BR100 setup documents, Functional and Technical
specification documents, test scripts and test scenarios along with the
end-to-end testing of the entire functionality.
< Efficient Execution of CRP, SIT and UAT and a successful Go Live for the
modules - AP, IExpenses, Advanced Collections.
< End to End thorough Flow through testing of Procure to Pay Business
Cycle.
Rollout in US and Canada:-
< Single source consultant responsible for the Oracle Financial modules -
Payables, Receivables, IExpenses, and Cash Management.
< Strategically re-designed an existing solution on copy attachment
functionality in Order to Cash cycle with an effective solution that best
suited the client thereby reducing the manual intervention.
< Prepared the BR100 setup documents, Functional and Technical
specification documents, test scripts and test scenarios along with the
end-to-end testing of the entire functionality.
< Proforma Invoice Reporting for US and Canada Invoices.
< Successful implementation of Inbound & Outbound interface on a Logistics
Service Provider that builds shipping documents in O2C cycle.
< Successful solution design on Dynamic Cheque Payments Templates creation
for multiple currencies as in USD and CAD
< Support provided on EBS Tax configured by third party service providers.
< Resolution of issues w.r.t inclusive tax calculation on Invoices
< Auto Lockbox processing of Receivables Invoices using Oracle Seeded BAI2
format.
Rollout in Australia, China and Japan:-
< Challenges faced on Bank Statement Loaders in Cash Management to
reconcile the payments with the invoices and successfully resolved the
same. Received SPOT Award recognizing the solution proposed and designed
at Company level.
< Successfully implemented with Customers' delight for the complex multi-
lingual interface where in the received data is in Chinese and Japanese
characters where Oracle has no direct solution for the same.
< EBS Tax configured for Japan for Use Tax and Sales Tax calculations on
invoices.
< High level changes done on all Customer Facing Reports to reflect the
address format w.r.t the country and language as applicable.
< Was also responsible for preparation and maintenance of all business
required documents like, BR100, BR110, MD50, MD70 and TE40.
< Experience in usage of tools like SVN and SharePoint for Document Version
Maintenance and Tracking.
Arrow Inc - ERP Implementation, New York
Aug 2007 - Jun 2009
Project Description: Global Implementation of Oracle Apps for a Fortune 500
Hi-Tech Company
Environment: 12.1.1
Roles & Responsibilities
< Delivered an effective solution with clients delight for a complex end-to-
end automation functionality of Move Orders approval and processing
mechanism in Inventory module with high level customization on Oracle
standard Forms and Workflows.
< Prepared Detailed design documents in line with the requirements through
formal client discussion
< Extensively designed solution for an additional custom zoom form
development in order to capture additional details required during the
Lot Transact process.
< Prepared the Functional Specification document and an extensive test plan
document capturing the various factors affecting the item transfer
process and the custom form.
< Vast solution designed containing extensive Customization done on Oracle
Workflows for auto processing of approval process based on item
categories and hierarchy.
< Actively involved in the testing and test plan preparation of the
component
< Designed a solution to use Oracle WebADI to load and import data into
Oracle for item transactions there by reducing customization.
< Involved in User Acceptance test and responsible in getting the sign off
from the client.
< Studiously participated in multiple CRPs and SITs in testing the core and
flow through scenarios of Inventory Module.
Cisco - ERP Production Support, San Jose, CA
Jul 2006 - Jun 2007
Project Description: Global Implementation of Oracle Apps for a Fortune 500
Hi-Tech Company
Environment: 12.1.1
Roles & Responsibilities
< Supported Auto Lockbox functionality related issues faced in production.
< EDI has been implemented for payments reconciliation.
< Generation of Customer Facing Reports on periodical basis.
< Custom built Sales Accounting Form has been used to capture the amount of
sales made thereby yielding revenue and reconcile the same with the
budgets and encumbrance journals.
< Experienced in using Remedy tool to support the issues logged in
Production and there by updating the same on progress, email-ing the user
on updates and
< Actively involved in the testing and test plan preparation of the
component
< Involved in User Acceptance test and responsible in getting the sign off
from the client.
< Studiously participated in multiple CRPs and SITs in testing the core and
flow through scenarios of Inventory Module.
TWWI (I) Pvt Ltd - Chennai, Tamil Nadu, India
Jul 2005 - Jun 2006
Job Description: Training, Mentoring and People Management operated from
India providing tuition help for school children based at US through a
secure Online Portal and Content Development using system software's.
Roles & Responsibilities
< Undergone technical training on handling the projects and the training
sessions.
< Involved in preparation of Educational contents using system software
tools.
< At a little expert level, managed a team of 12 there by mentoring them
along with their accountings and clockings.
ACADEMIC BACKGROUND
< Master of Business Administration (MBA) from Alagappa University, Tamil
Nadu, India.
< Master of Information Technology (M.Sc IT) from Alagappa University,
Tamil Nadu, India.
< Bachelor's Degree in Mathematics from Bharathidasan University, Tamil
Nadu, India.
PERSONAL DETAILS
First Name : Nithya
Last Name : Rajamurugan
Date of Birth : 25th Jul 1985
Sex : Female
Passport Number : Z2191199
Expiry Date : 01-Dec-2020
H1B Valid till : 30-Sep-2015
Contact this candidate