SUMMARY:

• Over 13+ years experience in Oracle EBS Implementation, Upgradation and Maintenance in Oracle Applications e - Business Suites modules.
• Excellent understanding of business process flow in Order to Cash(OTC), Procure to Pay (P2P), Report to Record(RTR) and Sub-Ledger Accounting (SLA).
• Experience in Business Requirements gathering, GAP Analysis, Test Plan Preparation, Unit Testing, System Integration testing, UAT, Go-Live preparation and Production Support.
• Professional expertise in Designing, Implementation, Customization and Testing in Oracle Financials module which include Account Payables (AP), Purchasing (PO), General Ledger (GL), Account Receivables (AR),Fixed Assets (FA), Cash Management (CE), E Business Tax (E b-Tax), Projects, Order Management,(OM),System Administration (Sys Admin).
• Skilled in Configuring the application based on solution design, performed gap analysis and designed workaround solutions. Excellent knowledge on Functional Analysis and Implementation, Techno/Functional analysis on Interfaces/Legacy conversions and Reports.
• Experience in using Oracle’s Application Implementation Methodology (AIM): Business Functional Requirement analysis, Understanding AS-IS process, TO-BE process, Gap analysis, Solution designing and building RICE components, System configuration, Conducted CRP’s, Co-ordinate UAT and extensively worked on Preparing documentation (BR 100, BR 150, BR 30, MD 50, BP 80, RD 20,CV 40 &TE 40) and Testing.
• Experience in preparing Data Conversion and Data Mapping Documents (CV040), (CV030) developing various Data Conversions and interface to Oracle Applications Using Oracle Interface Import and custom data validation programs.
• Experience in creating APIs, working with Oracle API’s like TCA, Packages, Functions, Triggers and other database objects using SQL and PL/SQL and front end tools like Oracle Forms 9i/6i, Reports 9i/6i.
• Involved in Data Conversions/Migration and designed function specific document of data (Suppliers, Customers, Assets, GL Balances, Open AP and AR with Revenue Recognition and open receipts) from Legacy System to Oracle.
• Excellent communication skills and leadership qualities with analytical problem solving skills and thorough knowledge on Microsoft technologies like (Office, Visio and Visual Studio).

TECHNICAL SKILLS:

ERP: Oracle Applications (R12,11.5.10, 11.5.9, 11.5.8, 11.5.7, 11.0.3,10.7),(Order Management, Purchasing, Inventory, General Ledger, Account Payables, Account Receivables, Fixed Assets, Cash Management,, Advanced Pricing, Advanced Supply Chain Planning (ASCP),BOM, WIP, AOL, Alerts,Sys. Admin, Workflow, AME(Oracle Approval Mgmt.), iProcurement, iStore, iExpenses, Service Contracts, Install Base, iReceivables, iSetup, iRecruitement, EDI Gateway)

Languages & Tools: SQL, PL/SQL, C, Unix Shell scripts, SQL*Loader, Toad, Developer 4.5/5/6.x (Forms and Reports), TOAD, PL/SQL Developer, Workflow Builder, Oracle JDeveloper, Oracle Interconnect, API Wizard Tool, XML, Webservices, Oracle XML Publisher, OA Framework, IBM Rational Clear Case and Clear Quest.

Databases: Oracle 11g/10g/9i/ 8i/7.x

Operating Systems: Exadata, SCO-Unix, HP-UNIX, Linux, Windows 97/NT/XP/95, MS-Dos

Case Tools: Microsoft Word, Microsoft Excel, Microsoft Power Point, Microsoft Projects, Visio 5.0, Microsoft Visual Source Safe, PVCS, Kintana, SVN, STAT

PROFESSIONAL EXPERIENCE:

Confidential,Charlotte,NC

Sr. Techno-functional Consultant

• Understanding and gathering the requirement and prepared design document for Hercules Tire and Rubber Operating unit.
• Designed and worked on complex Intercompany pricing logics to handle for intercompany flows i.e., Cross OU Procurement, Cross OU DC Direct Shipment, Cross OU ISO and Cross OU Drop Shipment using standard intercompany solution.
• Designed and worked on the custom AR AutoInvoice Preprocessor for AR Invoice.
• Designed and worked on AR Invoice customization.
• Designed and worked on Concur travel expense coming Amex and P-card to load into AP through payable invoices interface.
• Designed and worked on Advanced Shipping & Billing Notice workbench as part of Global procurement solutions, thereby enabling Prepayment to suppliers and AP invoice matching.
• Designed and worked on AR Invoices and AP Invoices conversion.
• Designed and worked on going Item customization and synchronization of item attributes from master to validation and to child organizations as per business requirement.
• Worked on Inventory valuation and inventory to General Ledger reconciliation reports customization for DC.
• Designed and worked on inventory tracking report Type 21 reconcile with Type10 for bonded warehouse and report to Customs.
• Worked on SLA customization for Revenue accounts.
• Worked on production tickets based on priority and provided regular updates to clients until resolution

Confidential,Charlotte,NC

Sr. Techno-functional Consultant

• Understanding and gathering the requirement from business users and prepared requirement document and identified Gaps for customization for North America and Panama Latin America
• Configured AR and Advance collections modules.
• Prepared design and worked on AR Invoice Pre-processer customization as per business process.
• Worked on warranty claims customization that are coming from external systems from Tavant
• Worked on Customization of AR Invoice print customization as per business needs
• Involved in UAT testing and supported the user issues during UAT.
• Worked on the customization of dunning letters for collections.
• Worked on AR and AP Invoice conversion from legacy system.
• Worked on SLA customization.
• Worked on the customization Invoice printer on the government printer having pre-printed format as legal requirement for Panama country
• Worked on Production ticket issues based on priority and provided regular updates to clients until resolution

Confidential,WI

Sr. Techno-functional Consultant

• Understanding and gathering the requirement from business users and prepared Business requirement document and identified Gaps for customization.
• Configured Primary Ledger, secondary ledger and defined accounting setup options, Operating Units, locations, Organizations, shipping networks, for the implementation of QAD Project
• Worked on design of the AR Invoice and AR receipts conversion.
• Worked on Concur travel expense raised by employees to interface to payables through payable invoices interface.
• Worked on Customer, AR Open Invoices and AR receipts Conversion
• Customized AR Invoice Pre-processer as per business process.
• Designed and worked on sourcing rules conversions.
• Co-ordinate with Offshore development team for development of objects and clarifies the queries.

Modules: Oracle Applications R12.1.3 - Oracle PO, INV, OM, AP, GL, FA, AR, CM, SLA, Pricing,WIP, BOM, ASCP, Demantra

Confidential, Keene,NH

Sr. Techno-functional Consultant

• Understanding and gathering the requirement from business users and prepared Business requirement document and identified Gaps for customization.
• Identified business requirements and mapped them to the Oracle Application functionality.
• Worked on the AP Invoice conversion and direct debit payment.
• Designed and worked on Purchase Orders, Blanket Purchase Orders, Customers using TCA API’s, Suppliers and Customer Banks conversions.
• Worked on the design and developed extensive business logic for Consolidation Billing for the AR Invoices pre-processor interface
• Designed and worked on COGS Customization by reversing COGS journals and creating corresponding new journals entries based on Purchase Order receipt deals data (which are impacted with inventory layer cost) and applying on to Sales Orders issue transactions as per business rules.
• Worked on Open Account Payables Invoice conversion.
• Designed and worked on requisition import interface.
• Worked on design and developed inbound interfaces like AR Invoices and GL interface
• Worked on the outbound programs like Sales extract data to Hyperion, customer extension attribute to legacy system.
• Designed and worked on new OA Framework Screens for the AR Customer extension attributes. Screens has search and update customer attributes functionality and also provided mass update of all extension attributes through excel upload.
• Designed and developed conversions of Purchase Orders and Blanket Purchase Orders.
• Worked on the XML Publisher reports to customization reports as per business requirements in AR, OM, FA (Fixed Asset Register, Fixed Asset Termination Report), AP and GL.
• Automated debit memo creation in AP for the Invoices.
• Designed and developed AP invoice interface.
• Worked on customization of AP checking printing.
• Worked on Sales Order Import from various sources and customers in different formats using Order Process API’s after applying the customer specific business rules.
• Worked on Production ticket issues based on priority and provided regular updates to clients until resolution

Modules: Oracle Applications R12.1.3 - Oracle PO, INV, OM, AP, GL, FA, AR, CM, SLA, Pricing, and MDM

Confidential, NJ

Sr. Techno-functional Consultant

• Designed and developed automatic printing of Electronic License Access Number (ELAN) certificate with barcode and serial number for the all items in PO.
• Worked on customized of Pick Slip report with bar code printing and LPN shipment confirmation.
• Worked on customization of mobile supply chain PO receipt screen.
• Worked on enhancement on reports in discoverer and XML publisher in AR, AP and OM modules.
• Configured shipping networks and inventory organizations.
• Designed and developed new JSP pages for the Carriers like Fedex to confirm the installation of the Canon Machine at customer location for Sale order delivery confirmation.
• Design and developed custom Pick Slip report
• Designed and customized AR Invoice pre-processing to in corporate new custom logic for bundling and Grouping of AR Invoice lines.
• Developed Discoverer reports as per business requirement
• Worked on the XML Publisher reports to customization reports as per business requirements in AR, OM,PO and INV
• Worked on Production ticket issues based on priority and provided regular updates to clients until resolution.

Modules: Oracle Apps 11.5.10.2 - Oracle PO, INV, OM, AP, GL, FA, AR, CM, CRM, Pricing and Oracle Service Contracts.

Confidential,San Diego,CA

Sr. Techno-functional Consultant

• Involved in requirement analysis, preparation of functional design, technical design, test plans, development, and testing and user acceptance
• Designed and developed creation of PO requisition interfaced from different source systems.
• Designed and worked on Customer Conversion using TCA API from Legacy system to Oracle.
• Designed Fixed Asset interface .
• Extensively worked on Auto Invoice and Auto Lock Box process and troubleshooting the process on production environment.
• Involved in the development project for third party logistics (3PL) project for Vendor Managed Inventory(VMI) wherein the Inventory Transactions by Nokia and Samsung are interfaced and processed in Oracle Application
• Developed the purchasing and AP custom reports in XML Publisher
• Imported Invoices and credit transactions using Auto-Invoice
• Personalization is done on AP invoice screen.
• Worked on functional design document and of BOM and Onhand conversions.
• Designed and developed conversions of Purchase Orders and Blanket Purchase Orders.
• Worked on the Mass Additions in FA
• Designed and created alerts as per business requirements in AR.
• Developed Pick Slip Reports to help pickers to pick items from the warehouse. Worked the technical design, developing & tuning the report
• Involved in resolution of post-production issues as per SLA.

Modules: Oracle Apps 11.5.10.2 - Oracle Apps 11.5.10.2 - Oracle OM, PO, INV, AP, iExpense, GL, FA, AR, CM.

Confidential

Sr. Techno-functional Consultant

• Involved in requirement analysis, preparation of functional design, technical design, test plans, development, and testing and user acceptance
• Worked on Supplier Conversion from legacy system, AP open Invoices and AR Open Invoices.
• Worked on Fixed Assets conversion.
• Configured AR lockboxes.
• Involved in the Item Conversion from legacy systems.
• Prepared functional document for customization of forms and reports as per business requirement.
• Worked on Production ticket issues based on priority and provided regular updates to clients until resolution.

Modules: Oracle Apps 11.5.10.2 - Account Receivables, General Ledger, Account Payables, Account Receivables, General Ledger, Account Payables, Project Costing and Billing, Order Management, Inventory, Purchasing, Cash Management, Fixed Assets, Oracle Contracts, Oracle Lease Management

Confidential

Sr. Techno-functional Consultant

• This project involves upgrade of all sites in Europe from 11.0.3 to 11.5.9.
• Worked on conversion design documents for migrating 11.0.3 Apps data to 11.5.9 for Account Receivables Open transactions, Account Payables Open Transactions and Fixed assets.
• Involved in reconciliation of AR and AP Open items after migration between 11.0.3 and 11.5.9.
• Analyzed all 11.0.3 custom reports are tested and migrated to 11.5.9 as per 11.5.9 new features.
• Designed custom process to load and define the segment hierarchy’s in the data repository used reporting.
• Worked on Fixed Assets conversion and GL Balance conversion

Modules: Oracle Apps - Account Receivables, General Ledger, Account Payables, Purchasing, Cash Management, Fixed Assets, Project billing, Project Costing

Confidential

Project Tech Lead

• Worked as Project leader involved in onsite/offshore co-ordination, client meetings, requirement gathering, preparation of Technical Design, Data Design and Unit Test Plans for Interfaces and Conversions, allocation of work in the team, meeting the project schedules, delivery of all the required deliverables.
• Designed and developed Item interface program and various out bounds in OM, AR, Inventory and PO.
• Designed and developed complex reporting requirements for COGS, Receivables and Revenue has to be reported by Branch. To satisfy the reporting requirement designed solution to build interfaces, this reverses the default accounting and creates redistribution journals by Branch. Accounting are created by deriving values from different sources at the same time ensure new combinations to created which would not violate Cross Validation Rules. Automated process of creating journal by using standard Journal import and posting to GL balances
• Customized PO Print report as per requirement
• Designed and developed create and update item category assignments by populating the data into item interface tables and calling Item import program.
• Worked on AP Invoice interface data from TAVANT system.
• Worked on the functional document of AP Check printing
• Worked on the Bank reconciliation in Cash management that coming electronic statement from bank
• Designed and developed custom reports in PO,AR, AP and GL
• Co-ordinate with Client requirements for implementation phases.
• Involved in Unit testing and System integration testing
• Involved in production support and solved critical issues.

Modules: Oracle Apps 11.5.8 - Account Receivables, General Ledger, Account Payables, Order Management, Inventory, BOM, WIP, Purchasing, Cash Management, Fixed Assets