SUMMARY:

• Certified Oracle Professional with 10+ years of IT experience. 8+ years in an Oracle Financials Functional Consultant with experience in versions of R12 and 11i. As a functional lead, worked with business users and technical teams in successfully translating business requirements into functional specifications and deliverables.
• Key Business Analysis skills on requirements gathering, process flow mapping, functional specifications, design and coding, testing and impact analysis. Worked on multiple Implementations, Testing and Support projects, including full life cycle implementations in Oracle R12 (R12.1.3. R12.2.5) and 11i (11.5.9, 11.5.10).
• Strong functional experience in General Ledger, Account Receivable, Account Payables, Oracle Payments, Cash Management within R12. Hands on experience in supporting Oracle Applications Fixed Assets, Advance Collection, Purchasing, Ebtax.
• Extensive knowledge of SWIFT related processes including MT messages, ISO payment formats and Alliance Lite2 services. Experience on Data Conversion and Migrations life cycle. Worked in Onsite and Offshore model projects including coordinating and leading offshore team.
• Experience in complete software product development life cycle (SDLC): System Analysis, Design, Development, Testing and Deployment.
• Good understanding of the AIM implementation methodology: BR030, BR100, MD50, MD70 documents.
• Proficient in Data retrieval using SQL queries and supporting the necessary service requested logged with oracle. Ability to assist and guide technical team in Technical Design and Development of business requirements.

TECHNICAL SKILLS:

Oracle Applications: Oracle 11i & R12 - GL, AP, AR, CE, FA, PO, Advance Collection, Ebtax.

Documentation: AIM Methodology (Scope, Business Process, Business Requirement, Conversions, Mapping).

Database: Oracle 10g/11g, MS SQL SERVER.

Operating Systems: Windows (95, 98, XP, NT, Vista, 7),

Other Tools: MS Office 2003/2007/2010 , MS Visio 2007, Use of SQL Developer, Web ADI, Data loader, TOAD, FileZilla and XML publisher

PROFESSIONAL EXPERIENCE:

Oracle Functional Consultant 

Responsibilities:

• Core team member in design and implementing P2P track for R11i to R12 upgrade.
• Responsible for systems integration of 3rd party systems with Accounts Payables.
• Responsible for creating BR100 for Ebtax for new Non-US legal entities.
• Involved in payment integration testing with banks.

Environment: Oracle Application 12.2.5, Oracle Purchasing, Payables, Payments, Ebtax.

Functional Consultant

Responsibilities:

• Perform study of Treasury current and future process and develop criteria’s for vendor evaluation. Participate in discussions and demos with different Vendors to understand their process and capabilities.
• Perform comparative analysis and provide data to business to assist them with vendor selection. Create budgetary proposal along with project plan based on vendor selection.
• Liaison as functional consultant with Core Business Team, Project and Support Teams for project execution.

Environment: Oracle Application 12.1.3, Oracle Financials, GL, AP, CM, TMS.

Oracle Financials Functional Consultant

Responsibilities:

• Perform study on RPC (Recommended Patch Collections), analyze functional changes, perform gap analysis and impact on current business process.
• Prepare documents of BR030, BR100, and design Document MD 50 for changes identified. Hands on involvement in preparation of test scripts (TE40) for business areas in GL, AP, AR, FA, Purchasing, Ebtax. Test business process for Procure-to-Pay cycles and the customizations involved.
• Anchor UAT sessions with Business, identify issues and work with project team for resolution. Create training material, cut-over documents and facilitate end-user learning and adoption. Facilitate cutover to production

Environment: Oracle Application 12.1.3, Oracle Financials, GL, AP, AR, CM, FA, Purchasing, Iexpense, Ebtax.

Oracle Financials Functional Consultant

Responsibilities:

• Liaison with Core Business Team, Apps Specialists & Key Business Owners, Project and Support Teams. Participated in understanding the requirements and business processes from the requirement gathering team and business users of each region.
• Worked on Account Payables setups - Supplier and Supplier Site creation, Bank and Bank Account setups and Tax Codes setups using Ebtax for each country.
• Designed and implemented payment process using Payment process profiles, Requests Formats, XML Publisher Templates and templates to facilitate ACH and Wire payment formats for Canada, India, Vietnam, Philippines and Australia using ISO standards.
• Implemented and created process for XML Check Outsourcing payment formats for India using Oracle Payments. Configured and designed the Withholding Tax calculation process for India.
• Designed and configured the BACS payment format for United Kingdom using Oracle Payments. Build functional solutions using Cash Management for auto reconciliation of statements received using MT940 formats for HSBC, RBS, and BNP Paribas.
• Build custom solution around Bank of Tokyo statements to enable them to auto Reconcile. Configured Bank transactions codes, Sweep Transactions in Oracle for bank to bank transfers.
• Involved in SWIFT message configuration (method to use to transact between banks and companies), SWIFT rule customizations on SWIFT alliance lite2 and its integration with Oracle.
• Involved in the preparation of documents like BR030, MD050 and BR100, Training material and review of cut-over Documents as part of project deliverables.
• Prepared and executed test scripts (TE 40). Conducted UAT and SIT and liaison with Users for approvals. Facilitate end-user learning and adoption. Facilitate cutover to production. Post production support and maintenance of the Application and resolving user queries.

Environment: Oracle Application 12.1.3, Oracle Financials, AP, CM, Ebtax, PL/SQL, Toad, FileZilla, Alliance Lite2.

Oracle Financials Functional Consultant

Responsibilities:

• Perform study on current business process, conduct discussions, review requirements and impact on upstream and downstream applications.
• Configure & customize system to integrate SWIFT with Oracle EBS as per business requirements. Design & implement SEPA credit transfer (Pain V3) in ACH/WIRE formats in Oracle Payments for RBS/HSBC banks operating in Canada, Europe and South Africa.
• Design & implement NACHA payment format in Oracle payments for Wells Fargo banks operating in United States. Defined the financial options and payable options for new firms that are a part of business requirement.
• Configured the Supplier & Supplier Sites, Bank and Bank Account setups and Tax Codes setups for each country. Designed custom solution for remittance email generation to suppliers during payment process. Setup internal bank accounts in Cash management for payments and reconciliation.
• Build functional solutions around statement processing and auto reconciliation for statements received through SWIFT for previous and intra-day statements (MT940, MT942 & BAI2 formats) for RBS, HSBC and Wells Fargo.
• Involved in AutoClient configuration, SWIFT message configuration (FileAct), SWIFT rule customizations on SWIFT alliance lite2. Modified SLA in cash management for bank transfers.
• Involved in the preparation of documents like BR030, MD050 and BR100, Training material and review of cut-over Documents as part of project deliverables. Prepared and executed test scripts (TE 40). Conducted UAT and SIT and liaison with Users
• Facilitate end-user learning and adoption. Facilitate cutover to production

Environment: Oracle Application 12.1.3, Oracle Financials, AP, CM, Ebtax, SLA, PL/SQL, Toad, FileZilla, Alliance Lite2.

Confidential

Functional Support Lead

Responsibilities:

• Responsible for all functional tasks relating to the maintenance and business user directed development including end-user support and training in R12 functionality, setup, navigation and identifying and documenting procedures to execute future customizations for the above processes.
• Worked on post-production support issues raised by various users. Preparing Setup Documents, Functional Specifications for Customizations, Test Scripts & Training material.
• Liaison with technical resources to resolve problems and ensure seamless transition from the Analysis phase to the Release phase.
• Support end-users in Finance, Accounting, and Administration for the maintenance of Oracle ERP. Involved in resolving functional issues related to financial modules like GL, Accounts Payables, Receivables, Fixed Assets, iExpense, Ebtax.
• Setup Organization Structure (MOAC), Users and Responsibilities, Security Profiles, Flex Fields, recurring journals template, recurring journals, cross validation rules as per requirement.
• Establishing quality processes and ensuring processes are followed as per defined standards and guidelines. Supported Monthly/Quarterly closures for AP, AR & GL.

Environment: Oracle Application 11.5 & R12.1.1, Oracle Financials, GL, AR, AP, CM, FA, AGIS, Purchasing, Ebtax, PL/SQL, Toad.

Oracle Finance Functional Consultant

Responsibilities:

• Business Requirement Gathering, as-Is process analysis, Gap analysis and Process Mapping. Customized Lockbox process in AR to reduce collection time. Enhanced and customized UWQ in AR advance collections.
• Modified receivable activities for miscellaneous receipts, bank charges, collectors, and aging buckets. Modified customer profile classes, attached payment terms, collectors, matched receipts, statement cycle to profile classes and transaction types.
• Preparing Setup Documents, Functional Specifications for Customizations, Test Scripts & Training material.

Environment: R12.1.1 (GL, AR, Advance Collection)

Oracle Finance Functional Consultant

Responsibilities:

• Support as a SME on current business process in Customers, Invoice, Collections, Claims, Journal, Conduct discussions and review requirements & impact on upstream and downstream applications (Boundaries Application).
• Exposure to Multi-org setups. Configured the setups of General ledger as per the business requirements namely new responsibilities, Value Sets, Journal Categories, flex field security rules, cross validation rules, currency etc.
• Defined customer profile classes, payment terms, and distribution sets, and Auto Cash Rule Sets. Defined setups for AR module like receivable activities for miscellaneous receipts, bank charges, collectors, aging buckets, receipts, lockbox, Quick Codes and Taxes.
• Created customer profile classes, attached payment terms, collectors, matched receipts, statement cycle to profile classes. Setup transaction types, invoices, credit memos, debit memos. Designed a custom processes for invoice creation and customer update flows from legacy system to oracle AR.
• Created data mapping and conversion programs for data flow from legacy system to Oracle. Participated in CRP and UAT. Prepared the MD 50 and worked with technical team for reports development. Prepared and executed test scripts (TE 40). Created user-manuals and trained the end users.

Environment: R12.1.1 (GL, AR)

Onsite Coordinator /Functional Consultant

Responsibilities:

• Interacting with Client (Internal or External), Converting the Client requirement into Technical design, end to end coordination of the requirements starting from requirement gathering to development and then to Integration Testing with OSC.
• Setups and testing of functional components. Provide Functional & Technical Support on Production Issues. Provide month-end support on all functional activities.

Environment: Oracle R11.5.10 (GL), Oracle Hyperion, Mainframe.

 Mainframe Developer

Responsibilities:

• Worked as a developer as part of PMO team in development.

Environment: Mainframe COBOL, CICS, JCL