Dorababu Seera

Oracle Financial Functional Consultant

Email: acs0wc@r.postjobfree.com

Contact # +1-720-***-****

SUMMARY

Over 8.2 years of industry experience

Working with TATA Consultancy Services as IT Analyst for Oracle Financial modules

Worked with Mahindra Satyam as a Senior Functional Consultant for Financial modules

Worked with Sierra Atlantic Software Services as an Oracle Financial Functional Consultant

Worked with Orasphere Technologies as an Oracle Financial Functional Consultant

Extensive Oracle Financials experience in Design, Development and Implementations, System upgrades, Integrations, Process Re-engineering, Requirements gathering, Fit and Gap analysis, System setups, Interfaces, Extensions, Training & Support.

Successfully implemented five (5) complete end-to-end life cycle projects in Oracle Financials & SCM – GL, AP, AR, CM, FA, AGIS,PO, iExpences and iProcurment.

Excellent experience as an Oracle Apps Implementation specialist with Sub-Ledger Accounting(SLA), MOAC, Payments and TCA

Excellent support experience as a Grid Engineer for Metalink Support on GL and AP, Period closing and Reconciliation process with GL to other Sub ledgers.

Subject Matter Expert in processes like Procure-to-Pay, Order-to-Cash, General Ledger and Fixed Assets

Worked on Upgrade Project from 12.0.6 to 12.1.3.

Worked and contributed in Data conversion, data Interfaces, reporting requirements

Prepared implementation Documents by using Oracle AIM methodology (RD20, BP80, BR100, MD50 and TE40), good understanding in various Oracle related products like SQL, PL/SQL, UNIX, Report Builder, form Builder, XML Reports, Discoverer and various Oracle tools(Web ADI and Data Loader).

Expertise in Oracle E-Business suite (11i & R12), Oracle Technologies PL/SQL, SQL*Loader, TOAD, SQL Plus

Functional knowledge and implementation experience in industries like Telecom, Finance, Manufacturing and Distribution industries

SKILLS

Oracle E-Business Suite 11i& R12: General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Cash Management (CM), Fixed Assets (FA), Purchasing (PO), Order Management (OM), Advanced Global Intercompany System (AGIS), Sub-ledger Accounting (SLA), Multi Org access control (MOAC) and Trading Community Architecture (TCA).

Technical Skills : TOAD, SQL, Data loader, ADI and HP Quality Center

Management/Leadership Skills: Finance Functional Lead, Onsite Lead and Sr. Business Analyst

PROJECT EXPERIENCE

The Western Union Company, USA. (Onsite) Oct-2014 – Till Date

Financial Functional Consultant – R12 Upgrade & AMS Support

Western Union enables companies of all sizes to send and receive cross-border payments and manage foreign exchange. With deep expertise in moving funds around the globe, access to over 130 currencies, and a global financial network spanning more than 200 countries and territories, we help companies spend less time managing international financial transactions and more time growing their businesses.

Environnent: Oracle Apps. R 12.1.3

Modules: GL, AP, CE, FA, iExpences

Role: Sr. Business System Analyst

Worked on development of new FSG reports and customized various standard FSG reports

Involved in upgrade project from 12.0.6 to 12.1.3

Creating functional requirements as an input to application design

Identify, diagnose and document current existing system issues

Prepared Impact analysis document for the upgrade of the financial modules from 12.0.06 to R12.1.3

Reviewed the Business Requirements Documents with the business and development teams and analyzed the functionality of the Oracle applications so as to finalize the solution

Defined payment terms, Accounting Rules, Accounting Periods, and Invoice Sources

Responsible for preparing upgrade plan for GL, AP, AR, and I-Expenses with all customizations and form personalization

Facilitating end-user training and developing the various users training manuals and conducted the UAT sessions

Involved on Month end activities for all the financial Modules

Worked on Reconciliation process to close the accounts as per month end process

Created Job aids as per users request

Raised SR’s with Oracle Support to resolve the issues which were part of Oracle Bug and provided necessary information as required

Reviewed the current reconciliation process in Cash Management and designed business process and system has been configured and tested to meet the Business requirements

Integrated Cash Management with Payables, Receivable modules for reconciliation. Auto import and reconciliation of bank statement Bank file integration/mapping

Setup the approval hierarchy for the expense reports and created signing limits for iExpense users in Payables

Developed functional documents for technical customizations

Involved in documentation of Frequent Mistakes and Error made by end-user in application based on issue log register (KEDB)

Extensively used Toad and SQL Developer to view the tables to troubleshoot production issues

Resolved the issues related to payment processing, payment authorization, and suppliers

Run Diagnostic scripts and coordinated with oracle tech support through OWC session

The Western Union Company, USA. (Onsite) Aug-2013 – Sep-2014

Financial Functional Consultant – R12 AMS Support

Western Union enables companies of all sizes to send and receive cross-border payments and manage foreign exchange. With deep expertise in moving funds around the globe, access to over 130 currencies, and a global financial network spanning more than 200 countries and territories, we help companies spend less time managing international financial transactions and more time growing their businesses.

Environnent: Oracle Apps. R 12.0.6

Modules: GL, AP, CE and iExpences

Supported the Installed product of Oracle financials R12

Handled the financial modules like GL, AP,CE and I-expenses

Handling the tickets, resolving the issues on day to day basis on priority.

Undertaking all steps necessary to satisfactorily closure of the tickets raised by clients.

Prepared CR Documents for any changes that needs to be deployed in Production Instance

Interacting with client Project manager on a weekly basis and submitting status report

Handling situations for run time problems and suggesting the work around.

Participated in Cab Meetings to address the changes request and seek approvals.

Worked on month end closing activities during the support

Involved in documentation of Frequent Mistakes and Error made by end-user in application based on issue log register (KEDB)

New Mangalore-port, India Sep-2012 – Aug-2013

Financial Functional Consultant – Implementation and Post Production Support (Release 12)

New Mangalore Port Trust operates the deep-water, all-weather port at Panambur, Mangalore in Karnataka state. The port serves hinterland of Karnataka state and to some extent state of Kerala. The major commodities exported through the port are iron ore concentrates & pellets, iron ore fines, manganese, granite stones, coffee, cashew and containerized cargo. The major imports of the port are crude and petroleum products, LPG, wood pulp, timber logs, finished fertilizers, liquid ammonia, phosphoric acid, other liquid chemicals, containerized cargo, etc.

Environnent: Oracle Apps. R 12

Modules: GL, AP, AR and FA.

Analysis of the business requirements and create a Development design documents

Involved in Mapping the Design Requirements to the Functional Setups related to the specific EBS modules

Configuring all Functional setups related to the financials modules in EBS R12

Proposing new and possible enhancements considering the existing application and business Requirement

Proposing the appropriate technology (solution) to cater to the Business requirements

Configured the MOAC, Ledger Setup, and Legal Entities

Performing System Integration Testing for developed components and provide support for Customer Acceptance Testing

Involved in preparing the Test cases and Test Evidences in Quality Control

Getting compliance approvals for developed Components migration

Conducted CRPs, Training Sessions to super users, and UAT sessions

Interacting with Business Users/Super users through calls to getting the Business requirement and resolve issues/ Clarifications based on priority

Motorola Solutions Inc. USA. Jan-2012 – Aug-2012

Financial Functional Consultant – MSI- Finance Transformation (AMS Support)

Finance Transformation program is a Motorola Global-Initiative to replace the existing iFOCUS 11.5.10 oracle ERP, sector ERP finance functionality with Oracle Applications R12. The project is to handle the development and implementation of Oracle ERP R12 in Motorola Solution Application. The benefit of migrating to ERP R12 is that one set of processes, procedures and interfaces for all users, Motorola wide; which will reduce the amount of interfaces needed to various systems as well as the effort required support and maintain them. This project involves complete analysis, design, development and implementation of R12 ERP application.

Environnent: Oracle Apps. R 12.

Modules: GL, AP, AR, CE, FA and Order management.

Analyzing the Business Requirements and System Specifications to understand the application

Coordinated with Onsite team for the status and the updates from client

Maintain project related documents in TCS tool IPMS and Logging defects in IPMS and doing root cause analysis whenever necessary

Resolving issues raised by customers

Providing weekly and monthly status to the client on the application development

Preparation of test scenarios and test cases

Testing execution and status reporting

Defect Prevention and Reviews to ensure the overall quality of the Project Title

Functional assistance to team members

Qatar University (QU), Doha, Qatar (Onsite) Jun-2011 – Dec-2011

Functional Consultant – R12 Implementation

Qatar University is the national institution of higher education in Qatar. It provides high-quality undergraduate and graduate programs that prepare competent graduates, destined to shape the future of Qatar.

This is End to End R12 (12.1.3) Implementation Project.

Working on the project deliverables by using AIM methodology

Involved in GL,AP, AR and IExpense Modules

Understand the current business practices of the client as part of As Is Study.

Prepared BRD and Flow Charts Based On client requirement.

Designed the solution to meet the business requirements as part of To Be Flows.

Prepared BR100 and Test scripts for All financials modules

Conducting workshops for CRP1 and CRP2 and prepared issue tracker.

Designed data templates for financials modules & security matrix for user responsibilities.

Prepared documents for UAT and Test strategies

Prepared Key User training documents and User Manuals (SOP).

Designed MD.050 solutions documents for finance custom components.

Developed functional documents for technical customizations

Business communications for the system updates and meeting the deadlines for the implementation

ABsciex

Jan-2010 – May-2011

Functional Consultant – R12 Implementation

AB ABSCIEX is a global leader in the development of best-in-class technologies that help answer complex scientific challenges and improve our world. AB SCIEX creates scientific instrumentation, software and services for the life science, clinical research and industrial markets, empowering customers with technologies that are used in drug discovery and manufacturing, food and environmental safety, and clinical research.

Interacted with business and analyzed existing business practices, Prepared and maintained business requirement gathering documents BR 100, functional extension and design document MD 50 and identified GAPS

Carried out operational analysis (AS-IS), solution design (TO-BE), Building Stage along with configuration of Oracle Financials GL (General Ledger) and AP (Accounts Payable)

Coordinated CRP’s and was involved in Test Scripts preparation (TE 40), for GL & AP

Business communications for the system updates and meeting the deadlines for the implementation

Configured, Accounting setup manager, COA Structure, Segments, Values Sets, Flex fields, Account qualifiers and Segment Qualifiers, Cross Validation Rules, Security Rules, Calendar and Currencies

Expertly defined, configured and implemented Rollup Groups, Aliases, Dynamic Insertion, Accounting Calendar, Summary Accounts, Intercompany accounts, and consolidation ledgers

Setting up Standard, Statistical & Recurring Journals, Suspense Account and Mass Allocation formulas.

Training Super users & power users before start of CRP2

Reviewed the current reconciliation process in Cash Management and designed business process and system has been configured and tested to meet the Business requirements

Oracle Corporation, Hyderabad, India Oct-2008 – Dec-2009

Grid Engineer – Oracle Support Project

Global Customer Support (GCS) provides 24x7 supports to our Customers throughout the world. GCS has Support Centers around the globe to provide this coverage whenever it is required 365 days a year. Consider this group of professionals as an extension of customer's internal project team providing hundreds of individuals with in-depth product skills.

Oracle dedicated Development team and Support organization makes each customer more Successful managing and maintaining their Oracle software.

Environnent: Oracle Apps. 11i & R12

Modules: Accounts Payable and General Ledger

Provided Functional and Technical support on AP module in P2P cycle and also on PO, GL, CE and FA related issues which are integrated with AP module

Handling SR’s raised by the customers globally in the Metalink which involved problem analysis and understanding the functional flow for the same

Initiate the OWC sessions for critical issues for better analysis and quick resolution

Replicating the functional issues in internal support instance to analyze the issue

Raising the new bugs and follow up with DEV team to get the patch and providing the regular updates to the customers on the status of the bug

Assisting the Dev team in resolving the bug

Expertise in analyzing of APList and log files for the reported issues through Metalink.

Thorough Research of the Problem and Back end Tables, Provide suitable Data Fixes or workarounds to the customers across the globe.

Testing the data fix in the Support instance

Documentation of the issues (SRs) with the Oracle Diagnostic Methodology (ODM) process

End to End understanding of AP Product and Providing Perfect Data Fixes, Resolutions to the Customers

African Petroleum PLC, Lagos, Nigeria Jan-2008 – Sep-2008

Oracle Financial Functional Consultant – Implementation Project (Onsite)

African Petroleum Plc is a major player in the marketing and sales of refined petroleum products in Nigeria. With over 500 AP branded retail outlets classed into Service and Filing Stations, located strategically across the country to meet our customer's needs.

Environnent: Oracle Apps R12.0.6

Modules: GL, AP, AR, CE and FA

Interacted with business and analyzed existing business practices, Prepared and maintained business requirement gathering documents RD 20, BR 100,BR 110, functional extension and design document MD 50 and identified GAPS

Carried out operational analysis (AS-IS), solution design (TO-BE), Building Stage along with configuration of Oracle Financials GL (General Ledger) and AP (Accounts Payable)

Coordinated CRP’s and was involved in Test Scripts preparation (TE 40), for GL,AP,AR and CM

Coordinating with client on daily basis for project Deliverables

Participate in Weekly Status Review Meetings with IT Team

Performed developed and documented systems analysis, validation testing, and development of training documentation, training of internal staff of enhanced business system functionality

Created test documents, performed unit, End to End and User Acceptance Tests for AP

Nahco PLC, Lagos, Nigeria Aug-2007– Jan-2008

Oracle Financial Functional Consultant – Implementation Project

Nigerian Aviation Handling Company Plc. is a Nigerian diversified enterprise with interests in aviation cargo, aircraft handling, passenger facilitation, crew transportation and aviation training.

The company currently serves more than 35 airlines at seven airports across Nigeria, with plans to expand operations to other African countries. It handles about 70% of domestic and foreign airlines operating in Nigeria.

Environnent: Oracle Apps R12.0.6

Modules: GL, AP, AR, CE and FA

Prepared and reviewing of documents and doing the Setup in Development instance.

Worked on Setup Document (BR-100) and was responsible for Setup all financial modules under strict Revision Control based upon the various discussions, teleconferences.

Involved in testing all the processes in Test Instance and Development Instance

Prepared test scripts for financial modules

Prepared the training manuals for End Users

Defining the responsibilities and assigning the security attributes to different

Responsibilities

Assisting Technical consultants in customizing interfaces between AP and AR for Specific requirements of the Client

Training imparted to Technical consultants in functional part for the purpose of

Customization

Accounts Executive in Pratul Automobiles Pvt Ltd, Jun-2005 – Dec-2006

Roles and Responsibilities:

Preparation of Bank Reconciliation Statements on monthly basis

Checking of Debit and Credit Vouchers

Checking of Collections statements from various Branches

Handling of day-to-day Accounting transactions

Validation of Stock

Handling of monthly payrolls

Education and Training

Masters in Finance from Anna University, India

Completed Fusion Accounting Hub (FAH) Training from Oracle India

Contact this candidate