PROFESSIONAL SUMMARY:

• 10 Years of IT experience on Oracle Applications (E - Business Suite) 11i, R12i and PL SQL as a technical consultant.
• Multiple project experience involving Implementation, Upgrade, Customizations, Conversions, Re-implementation, Support, Solutions, Multi-Currency and Multi-language development.
• Strong EBS/ERP customizations experience using Oracle 12c/11g/10g/9i, Reports 10g/9i/6i, PL/SQL, BI Publisher and Workflow
• Familiar in working with Order to Cash (O2C) and Procure to Pay (P2P) cycle on Multi-Org environment.
• One-upgrade Project experience from 11.0.3 to 12.1.3 for Confidential .
• Experience in developing Reports, Interfaces, Conversions and Extensions (R.I.C.E.) components with Oracle Applications.
• Extensively worked on XML Publisher reports with different templates.
• One-support Project experience of 12.1.3 for Confidential RMS system.
• Good Functional Knowledge of Financials and Supply Chain modules.
• Hands on experience preparing AIM methodology documents like MD50, MD70, CV40, CV60, TE20, TE40, and MD120.

TECHNICAL SKILLS

RDBMS: Oracle 12c/11g/10g/9i/8i

Languages: PL/SQL, UNIX Shell Programming, XML

Tools/IDEs: WinSCP, Toad, JIRA, Citrix ICA Client, TortoiseSVN

Oracle Applications Modules: General Ledger, Oracle Receivables, Oracle Payables, Order Management, Oracle Purchasing, Oracle Inventory, System Administrator, Application Object Library, Flex fields, Oracle Alerts.

Oracle Tools / Components: Oracle Developer Reports 10g/ 9i / 6i, Oracle Discoverer, Jdeveloper (10g,11g), Oracle Workflow, OBIEE, XML Publisher, SQL *Plus, SQL Developer, SQL *Loader, OA Framework (OAF).

PROFESSIONAL EXPERIENCE:

Confidential (San Francisco, CA)

Lead Developer - Oracle Ebiz R12

Responsibilities:

• Involved in functional Requirements Analysis, Technical Designs, Development and Testing.
• Implemented AP invoices interface for third party system Simple Legal.
• Customized AP Invoice Approval Notification by adding currency code at Subject and Line levels.
• For manual E-Commerce Sales Orders developed custom Web ADI.
• Developed Confidential FA Mass Additions Report.
• Customized AP Invoice Approval Notification by adding multiple attachments to the notification.
• Personalized OM responsibility to show only specific list of customers.
• Customized FA MASSADD PREP CUSTOM PKG to generate category, location and DFF values.
• Created Web ADI to load customers of different regions
• Developed eCom Order Cancel Program
• Customized the AP reports to generate the output in Excel format.
• Responsible for migration of objects to higher instances using iSetup Module.
• Prepared ADHOC scripts to Activate and Inactive the suppliers in Production.
• Set up the EFT format for Australia and tested the payments process.
• Developed custom periodic and event alerts.

Environment: Oracle Applications 12.1.3, (GL, AR, AP, PO, OM, iSetup), Oracle DB 11g, Oracle Workflow, OA Framework (OAF), PL/SQL, SQL Developer, WinSCP, Putty, JIRA.

Confidential (Melville, NY)

Lead Developer - Oracle Ebiz R12

Responsibilities:

• Lead technical status calls and provide status updates to managers on deliverables.
• Responsible for design and development of custom reports
• LEV Priority One Report By Bm Plan-Item No Reports
• LEV Canada Daily Sales Summary Report
• LEV Completed Order Detail By Market Warehouse
• LEV Month End Inventory Report
• LEV Customer Service Level Report
• LEV Cost Inventory Adjustment Report
• LEV Aging Summary Report
• LEV CAN New Order Activity Report
• LEV Over Credit Line Report
• LEV Aging Detail Report By Backorder
• LEV Aging Detail Report for ALLOCATED Orders
• LEV Aging Detail Report By Dt Requested
• LEV Aging Detail Report By Dt Entered
• Developed custom interfaces to import AP invoices and PO into Oracle Applications.
• Involved in various test cycle of the project, defect fix and resolution of the Interfaces.
• Worked on resolving performance issues with custom reports.
• Customization of PO Approval Workflow.

Environment: Oracle Applications 12.2.4 (GL, AP, PO, AR, INV), Oracle DB 12c, PL/SQL WinSCP, Putty

Confidential (Memphis, TN)

Oracle ERP Technical Lead

Responsibilities:

• Handling Techno Functional issues as technical lead by taking scope of the work from users and management
• Allocation of work to Team and monitoring their activities and suggesting appropriate solutions
• Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs).
• Conduct code and quality reviews developed by another development staff.
• Customizations and enhancements of reports and interfaces between legacy system and Oracle Applications.
• Development of Health Report for Invoices, Payments, Auto debits and Credit Card refunds.
• Supported Month-end and Year-end closing procedures.

Environment: Oracle Applications 12.1 . 3, ( AR, GL,IEX ), Orac le DB 11g, PL/SQL, Toad, WinSCP, Putty .

Confidential (Bellevue, WA)

Sr. Oracle ERP Consultant

Responsibilities:

• Customer conversion using TCA API’s, open invoices and payments conversion from legacy systems to AR using auto invoice and lockbox processing.
• Implemented Bank and Branches conversion program.
• Development of Customer Invoices Conversion program.
• PL/SQL Packages, Shell scripts and SQL Loader Control files for various conversions projects.
• Developed Customer Invoices Interface program which will read the XML messages from WS02 Transaction Bridge and created the transactions.
• Developed custom reports using Oracle BI Publisher Technology.
• Developed Custom Program to Import Price Lists and Price List Lines.
• Designed and developed custom program to validate and import customers using TCA API’s.

Environment: Oracle Applications 12.1.3 (AR, AP, PO), Oracle DB 11g, PL/SQL, Toad, WinSCP, Putty, TortoiseSVN, JIRA

Confidential (Bellevue, WA)

Sr. Oracle ERP Consultant

Responsibilities:

• Involved in functional document (FD) walk through and discussion with client regarding requirements.
• Created of custom program to process bank acknowledgement xml files.
• Designed and developed Global Error handling and Monitoring Framework for interface monitoring, which is used across the project.
• Worked on Various AOL related activities.
• Development of Conversion for Channel Sub ledger entries for future checkouts.
• Worked on resolving performance issues with custom programs.
• Responsible for code review, unit testing and offshore delivery.
• Design and development of custom reports
• Development of TCA customer report.
• Development of Matching holds by buyer report.
• Development of User Management Audit Report.
• Design and development of custom interfaces.
• Order Interface: Inbound interface used to get order creation, update information from PS to oracle Ebiz.
• GL Interface: Inbound Interface required to create Journal Entries in Oracle EBS, those are coming from PS system.
• AR Adjustment Interface: Inbound interface from PS to oracle Ebiz to send AR Adjustments (i.e.: credit, debit memos)
• AP invoices Interface: Inbound interface from PS to oracle Ebiz for reconciliation
• Development of AR Invoice Bursting program.

Environment: Oracle Applications 12.1.3 (AR, AP, PO), Oracle DB 11g, PL/SQL, Toad, WinSCP, Putty, TortoiseSVN, JIRA

Confidential

Sr. Oracle ERP Consultant

Responsibilities:

• Ad-hoc data extraction scripts for reporting.
• Development of Suppliers Conversion from YODA system.
• Created API for processing High Volume Distribution Orders.
• Personalization of Sales Order and Invoices forms for Billing Profiles.
• Implemented Payables Invoice Interface for Confidential charges.
• Created deployment scripts/patches and verify correctness of RICEW/CEMLI migrations.
• Development of Credit Card Invoice Hold Release Program.
• Development of Clippership Interface for domestic and International shipments.
• Development of YODA Interfaces. Inbound Interface for Payables Invoices and Outbound Interface of Payment information.
• Development of DI Central Invoice Interface Program.
• Development of Sales Order Email Confirmation Report.

Environment: Oracle Applications 12.1.3 (AP, AR, OM, PO), Oracle DB 10g, PL/SQL, SQL Developer, Putty, WinSCP.

Confidential

Sr. Oracle ERP Consultant

Responsibilities:

• Analyzing and retrofitting of interfaces integrated with IBS to Global Template (G12).
• Prepared Technical Designed Documents (TDD) and Unit Test Plan Documents (UTP).
• Development of Interface Tool kit, a common utility for Interfaces and Conversions.
• Development of Invoice on Hold Report.

Environment: Oracle Applications 12.1.2 (OM, PO, AR, AP, GL), Oracle 10g, PL/SQL, Shell Script, Putty, WinSCP, JIRA.

Confidential

Sr. Oracle ERP Consultant

Responsibilities:

• Overseeing development quality, validating and testing customizations.
• Development of various conversions.
• Retrofit RICEW / CEMLI’s from 11.0.3 to 12.1.3 data model.
• Facilitate system integration and user acceptance testing of RICEW/CEMLIs.
• Retrofitting of custom Packages, Procedures and Functions.
• Retrofitting of custom Forms.
• Retrofitting various form customization using form personalization.

Environment: Oracle Applications 12.1.2 (OM, PO, AR, AP, INV), Oracle Applications 11.0.3, Oracle DB 9i, Developer 6i, PL/SQL, SQL Developer, Putty

Confidential

Oracle ERP Consultant

Responsibilities:

• Development of a Report for RC LOB and GEO relationship.
• Checking the Manage Now Application to know about the raised IMRs (Info Man Record)
• Analyzing the issues raised from the user and providing them the solution. This includes issues in the Inbounds, Outbounds, D2k and Discoverer reports.
• Development of an Interface for Correction Program.
• Doing code changes and testing it in the Development environment. This includes working on Interfaces, D2K reports and Discoverer reports.
• Development of a Report for Rule 7.
• Analyzing the production issues and planning future enhancements in the project.

Environment: Oracle Applications 11.5.10 (GL), Discoverer, Oracle DB 9i, PL/SQL, SQL Developer, Putty, WinSCP.

Confidential

Oracle ERP Consultant

Responsibilities:

• Designing of Interfaces to automate the uploading process of different business feeds into Oracle PO, AP and GL with a view to minimizing the need for manual intervention and improving resilience.
• Migration of the historic data from the existing system to the newly implemented Oracle PO, AP and GL.
• Development and customization of reports in Oracle Purchasing.
• Prepared MD070, MD120 Technical Design Documents for critical objects using the AIM Methodology.

Environment: Oracle Applications 11.5.10 (INV, PO, AP, GL), Oracle DB 9i, PL/SQL, SQL Developer, Putty.

Confidential

Oracle ERP Consultant

Responsibilities:

• Development of Interface for RGL.
• Development of a Report for Delegated Journal Entry.
• Development of a Report for Group Owner List.
• Development of a Discoverer Report for General Ledger by Account.

Environment: Oracle Applications 11.5.10 (GL), Discoverer, Oracle DB 9i, PL/SQL, SQL Developer, Putty, WinSCP.