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, Oracle Payment, 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, Advance Collection
• 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.
• 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 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.
• 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:

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