SUMMARY

• 8+ years experience in Oracle Financials modules (AR, AP, GL), Oracle Distribution Modules - Order Management and Purchasing, i-Procurement. Possess a thorough understanding of both the “Order to Cash” process as well as the “Procure to Report” process.
• He is conversant with Configuring Oracle Application modules as well as understands the underlying schema, which gives him a better insight into converting user requirements into functional and technical specifications.
• He has expert level experience in Building and deploying Financial Statement Generators (FSG) in General Ledger.
• He has been actively responsible for testing of the functionality of Oracle ERP Application.
• He is well conversant with documentation as per the AIM methodology.
• He has also been involved in scoping and mapping of business requirements of clients for Oracle Financials/Distribution solutions. He is actively involved Conference Room Pilots and User Acceptance Testing.
• His responsibilities also include building, testing & development as per Business Requirements.
• He also has extensive experience with working on developing Financial Statement Generator reports in General Ledger.
• Expert in AIM 3.0 methodologies.
• Good Leadership skills, excellent communication and interpersonal skills, ability to lead the team and as an individual team player.
• Expert in Functional designing of Data Conversion Mappings from Legacy Systems to Oracle Applications.
• Proposed & implemented various in house tools to improve the performance of the whole Project.
• Expert in Business Process Re-engineering of processes.
• Expert in doing GAP analysis.
• Proposed solid design solutions, coordinated activities to meet multiple project deadlines. Coordinated Business and technical user community in defining user requirements, writing gap analysis and mapping system requirements for development efforts.

PROFESSIONAL EXPERIENCE

Confidential, New Haven, CT

Responsibilities:

• As a Business Analyst Supported Procure to Pay Process
• Enhancements for OM, PO and INV module
• Worked on setting up of Revenue Recognition process in AR Module
• Worked in configuring the Approval Hierarchies in PO module
• Worked on the setup of i-Procurement module including the setting up of Catalogs, Categories and Uploading Items into i-Procurement, Punch-out’s both transparent and direct.
• Performed Requirement and Gap analysis.
• Worked on the setup of Purchasing Options, Financial Options and Document Types in PO Module.
• Worked on the configuration of the Intercompany transactions using the Internal Requisition Internal Sales Order (IRISO) process.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Configured PO, INV, i-Procurement, AP modules from scratch and simultaneously created BR100 documentation for the setups.
• Worked on the Localizations for Europe (Netherland, Spain, Italy), UK, Mexico, Latin America, Japan, China
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Completed Multi-Org configuration by creating a new Organization Structure for WVI (World Vision International) by creating new Business Group, Legal Entity, Set of Books and Operating Unit.
• Conducted Regression testing to examine the effects of a new Org on the previous Org.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Created FSG Financial Reports critical to company’s business process.
• Worked on creation of MRC Setup by defining primary Set of Books and Reporting Set of Books in Oracle GL.

Confidential, Mountain View, CA

Responsibilities:

• Worked in the configuration of PO, OM, i-Procurement, INV, AP modules.
• Performed Requirement and GAP analysis.
• Worked on the Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
• Preparing BR100, MD050, TE40, TE50, CRP execution and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Involved in the Setups of Revenue Recognition including the setups of Invoicing and Accounting rules, setting up deferred revenue rules, setting up the Daily Revenue Rule that are new in R12.
• Worked on the Setup of OM module - including defining of Transaction Types, Price Lists, Defaulting Rules and Processing Constraints.
• Worked on the setup of the Internal Requisition Internal Sales Order (IRISO) process.
• Worked on the Auto Lock box process in Oracle AR module.
• Worked on Auto Accounting in the AR module
• Worked on the Auto Invoice Process in AR Module.
• Worked in a team in understanding the integration of Advanced Pricing with OM process
• Worked on setting up the Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module. Also worked on setting up the Line and Header transaction flex field in AR for Auto Invoice to work.

Confidential, Stamford, CT

Responsibilities:

• Implementation of Oracle Financial Modules -Accounts Receivable, Oracle General Ledger, Purchasing, Accounts Payable, and Cash Management.
• AP- Defined invoicing information including payment terms, invoicing and accounting rules, territories and invoice sources
• Defined accounting options, methods of accounting, realized gain / loss account, unallocated revenue account, auto cash rule set
• AR - Defined receivable activities for misc. receipts, finance charges, bank charges, defining distribution sets
• Defined receipt class, specifying creation method, payment method, clearing method, defining collectors and aging buckets
• Created customer profile classes, attaching payment terms, collectors, matching receipts, statement cycle to profile classes
• Set up transaction types, invoices, guarantee, deposit, and credit memos, debit memos
• Defined several Financial Statement Generator reports (FSG) in GL.
• Assigned receivable account, revenue account, unbilled account, freight account, clearing account, and unearned account to transaction types
• Analyzed user requirements and functional specifications to create test plans, test cases and test procedures for testing.
• Performed Black Box testing based on the functional requirements and product specifications of the application

Confidential, Atlanta, GA

Responsibilities:

• Configured the I-procurement module with non-catalog feature.
• Configured the Organization Hierarchy.
• Set up of Inventory Organizations, Sub inventories, Shipping networks, Transaction Sources.
• Configured the tax setups in payables and receivables.
• Set ups for Purchasing Module by configuring Jobs, Positions, Hierarchies, Buyers, and Approval Management.
• Review the existing Business Processes / Activity Cycles and firming up the “To Be” business processes.
• Configuring the position based Requisition and PO hierarchies for approval management as per the Procurement Policies.
• Implemented the drop-shipment feature of Order management and purchasing.
• Performed the Month end close process involving the intercompany transfers and reconciliation process and maintaining the account code combinations.

Confidential,  Marlton, NJ

Oracle Financial Technical Consultant

Responsibilities:

• Examined the client’s current and future business processes.
• Defined the calendar and chart of accounts. Defined the Multiple Set of Books, Accounting Periods, Journal Sources, Journal Categories, Automatic Posting, Suspense Accounts, Round difference accounts and Summary Accounts.
• Created journals (standard and formula) for the interfaces.
• Defined Mass Allocation Formula.
• Used ADI (General Ledger Desktop Integrator) to integrate the GL module to the Excel spreadsheet.
• Defined value sets, key flex fields segments and roll-up groups with security and cross validation rules.
• Prepared documentation provided adequate knowledge transfer.
• Generated several FSG Reports.
• Worked on testing the applications end to end. Wrote test scripts, worked with business to execute test scripts.
• Developed financial statement generator reports in Oracle General Ledger, which includes profit and loss statement, balance sheet, revenue recognition reports.
• Developed and maintained functional specifications for custom reports
• Met with users to generate and review business test cases.