SUMMARY

• Certified Oracle Professional with 10+ years of experience as an Oracle Financials Functional Consultant with experience in versions of R12 and 11i.
• Strong in General Ledger, Account Receivable, Account Payables, Cash Management within R12.
• 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.
• Experience working with multiple stake holders distributed world - wide for Requirement gathering and functional designs.
• Worked on multiple Implementations, Testing and Support projects, including full life cycle implementations in Oracle R12 (R12.1.3) and 11i (11.5.9, 11.5.10).
• Hands on experience in supporting Oracle Applications Fixed Assets, Ebtax, iExpense.
• Proficient in Procure to Pay (P2P) and Order to Cash (O2C) tracks.
• 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 Global Consolidation Process, Multi-Currency, Revaluation and Translation. Well versed with the integration and architecture of Multi-Org (MOAC), Sub-ledger accounting (SLA) and use of Web ADI.
• Expertise in the entire Oracle implementation cycle i.e. Baseline & Requirements analysis, solution design, system configuration & set-ups, data migration, pilot testing, trouble shooting, implementation, roll out, user training and post implementation support.
• 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.
• Excellent Analytical, Troubleshooting, Organization, and Presentation Skills. Experience working in a Dynamic, Cross-Functional Team, with excellent interpersonal communication and cross functional leadership skills.

TECHNICAL SKILLS

Oracle Applications: Oracle 11i & R12 - GL, AP, AR, CE.

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

Confidential, Overland Park, KS

Senior 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 BR30, 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, Ebtax and Iexpense.
• 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, Iexpense, Ebtax.

Confidential, Overland Park, KS

Senior 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 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.

Confidential, Overland Park, KS

Senior 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.
• Configured Cash Pools and Cash Positioning report for RBS accounts operating in United Kingdom.
• 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, Dallas TX

Lead Oracle Financials Functional Consultant

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.
• 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, Mass allocation as per requirement.
• Defined and maintained payment terms, supplier, supplier sites, and banks and other related setups as per requirement for payables.
• Defined and maintained Customers, customer profile classes, payment terms, distribution sets, Auto Cash Rule Sets, receivable activities as per requirement for receivables.
• Establishing quality processes and ensuring processes are followed as per defined standards and guidelines.
• Prioritized outstanding defects and system problems, ensuring accuracy and deadlines were met.
• Responsible for Monthly/Quarterly and Yearly closures for AP, AR & GL.
• Responsible for reconciliation of month-end/Quarter end reports.
• 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.

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

Confidential

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, CM, Advance Collection)

Confidential, Shelton, CT

Oracle Finance Functional Consultant

Responsibilities:

• Support as a Subject Matter Expert 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)

Confidential, Shelton CT

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.

Confidential

Oracle EBS Techno Functional Consultant

Responsibilities:

• Involved in the set-Up and implementation of Oracle Payables and Cash Management
• Involved in the set-up of Cash Management in non-production and production environments
• Developed the bank statement interface, which loaded all bank statement transactions into Cash Management module
• Developed the interface for Accounts Receivable module for automatic receipts
• Involved in the GL design and set up for multiple operating units

Environment: Oracle Application, AP, AR, GL, CE, Pl/Sql, RICE.