EXPERIENCE SUMMARY:

• 15 Years of Oracle Applications experience - specializes in the development of Oracle software solutions utilizing expertise in requirements definition, business analysis, design, systems integration, and implementation
• Completed Oracle Cloud Financial
• Hands-on involvement in business requirement, GAP analysis, process mapping, solution design, configuration, setups, work arounds, interfaces, user
• Developed functional (MD50, CV40) and technical (MD70, CV60) specifications as well as test plans(UTP) and test scenarios using AIM methodology
• Good Experience in implementing Supply Chain Business Process flows
• Strong experience in customizing applications using OAF, JTF, Java, JSP, ADF and JSF
• Over 14 years of experience in Implementation and RICEFW Customization/Development of Oracle Applications 11.5.7/11.5.9/11.5.10 and Release 12 modules such as OM, OTM (Oracle Trade Management), PO, INV, WIP, BOM, AP, AR, FA, GL, iExpenses and iProcurement modules
• Strong technical experience in Sales Modules Quoting, Trade Management, Channel Revenue Management (OCRM), Advance Pricing and iStore
• Successfully implemented iExpense P-Card integration process in Oracle R12
• Successfully upgraded 11i OPM modules (Inventory, Development, Execution, Costing and Quality) into R12
• Good experience customizing and personalizing approvals using Oracle Approval Management (AME)
• Experience with SOAP and REST web service development and deployment using Integrated SOA gateway
• Experience with fusion middle ware tool DELL BOMMI to EBS integration
• Experience in developing of EDI outbound and inbound programs using Oracle EDI Gateway
• Good knowledge of the TCA (Trading Community Architecture) model architecture in 11i & R12
• Has very good experience in customizing existing OAF Screens, forms and reports as per business needs using OAF Substitutions, custom PLL's, Forms Personalization's respectively
• Experience in the preparation of Functional Design, Technical Design documents and System Test scripts for Extensions, Data Conversion/Migrations, Inbound / Outbound interfaces, Reports, Forms and Customizations
• Expertise in SQL, PL/SQL, Packages, Functions, Procedures, Triggers, Views and Indexes
• Experience in various development tools like SQL Developer, SQL*Loader, Oracle Developer 10g, Forms & Reports 6i/10g
• Proficient in Oracle Application Express 4.0, 42, Java Script, HTML, XML, CSS, SQL and Oracle 11g/12C
• Experience in developing UNIX Shell scripts for loading data into staging tables
• Experience in Tuning SQL statements to improve execution performance using TKPROF, SQL Trace
• Experience in developing reports from Oracle Report Builder, Discoverer Tool and BI Publisher(XML)
• Experience in development, customization of Views, folders for Discoverer Reports 10g/9i/4i and well versed in Discoverer Administrator, Discoverer Desktop, Discoverer Plus and Discoverer Viewer
• Experience working within an agile development process (Scrum, XP, Kanban, etc.)
• Experience with Source version control tools like VSS, PVCS, SVN, Quest Stat and Kintana
• Excellent communication skills, adapt in client interaction and understanding business applications
• Pro-actively identify areas of opportunity and work to finding solutions that meet the business needs of the customer
• Absolutely capable of working in a fast paced, dynamic, team-oriented environment with 24x7 support

TECHNICAL SKILLS:

Oracle Apps11i/R12: Oracle Payables, Oracle Receivables, Inventory, Order Management, Purchase Order, Oracle Projects, Oracle Pricing Manger, Bill of Materials, Work in Process, iProcurement, iExpenses, HCM/HRMS, Forecasting and OPM Modules (Inventory, Product, Execution and Quality)

Foundation Modules: Oracle Alerts, System Admin, Application Developer.

Oracle Tools: Oracle Developer, Workflow2.5/2.6, SQL*Loader, Form Builder 6i/10g, Oracle Enterprise Manager, JDeveloper 10g.

Databases: Oracle 7/8/8i/9i/10g/11g, MS Access

Reporting Tools: Report Builder, Discoverer and XML Publisher

Languages: C, C++, PL/SQL and Java

Operating Systems: UNIX (SUN Solaris, SUN OS, HP9000), Windows NT/2000/XP

IDEs and Tools: JBoss, Apache Tomcat, IBM Web sphere, IIS, Eclipse, Net beans

Exposure To: XML, Java Script

Application Tools: Microsoft Visio/Projects/Power pointer/Access/Word/Excel

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Platforms: Oracle E-Business Suite R12

Modules: Purchasing, TCA, SLA, AP, AR and GL

Oracle EBS F&A Development Lead

Responsibilities:

• Identification of Gap & put collaborative effort with the Technical team to address the same through Technical Specification
• Working on enhancement request for AR Lockbox/EDI interface to load Misc and standard AR cash receipts
• Working on Business Associate (BA) custom application enhancement requests to modify Supplier and Customer sites (Remit To and Bill To)
• Working on Business Associate(BA) integration enhancement requests for QUORUM (JIB Owner)
• Working on building interface for Delegate of Authority (DOA) from Workday to EBS to Oildex, Unifier and Concur
• Building integration programs between DELL BOOMI to EBS for all file processing interfaces
• Enhancing Supplier hub and MDM integration processes
• Build the Inbound/Outbound Integration between Coupa and Oracle EBS (PO to SO, AR Invoice to AP Invoice and Product Catalog)

Confidential, Dallas, TX

Platforms: Oracle E-Business Suite R12

Modules: Purchasing, OM, SLA, MRP, Inventory, AP, WMS and AR,

Oracle EBS Lead Analyst

Responsibilities:

• Identification of Gap & put collaborative effort with the Technical team to address the same through Technical Specification (MD50 and MD70)
• Conducting Pre Project Review & Post Project Review
• Customized Inventory Min/Max and Cycle count reports in Oracle R12
• Developed a Forecast interface program to load legacy forecast data into Oracle MRP
• Developed an Interface program to load Items, org assignments, Item cross s and price list creation and assignments (Advanced Pricing)
• Developed EDI interface programs to load AP invoices (EDI 810) into Oracle R12
• Customized Requisition import process for MRP requisitions that are imported through MRP workbench. Users want to make price/qty adjustments before it converted into PO. Actual MRP requisitions will automatically imported as an approved status so the standard functionality will not allow making any changes to requisitions
• Supporting Oracle Mobile supplychain GUI tool to perform WMS transactions
• Developed SOAP Web service (PL/SQL API) to grab a data file from Cyber source system (Credit card payments) to Oracle Interface folder and loaded them into AR cash receipts in Oracle
• Developed SOAP Web service that will load sales orders from .net application

Confidential, TX

Platforms: Oracle E-Business Suite R12

Modules: Purchasing, AP, AR, OM, Oracle Subledger Accounting (SLA), and Inventory

Oracle Techno-Functional Consultant

Responsibilities:

• Worked for the Category & Mapping data migration to meet the go alive deadline
• Assisted Business for Business Acceptance Testing and obtain Sign off
• Understanding the current Business process and preparation of As-Is documentation.
• Setup Configuration - BR100 Preparation & Mapping of Business Process
• Conducting UAT - End to End Integration testing
• Providing day to day support
• Worked on new enhancement requests and extending existing functionalities
• Functional Business Support, and resolving day-to-day critical issues

Confidential, Dallas, TX

Platforms: Oracle E-Business Suite R12

Oracle EBS Consultant

Responsibilities:

• Identification of Gap & put collaborative effort with the Technical team to address the same through Technical Specification
• Developed a Bank statement interface program to load SWFT940 in Cash Management Module
• Built various diagnostic reports namely GL Diagnostics that identifies and reports net difference between SLA and GL
• Designed and developed an automated process that sends AP Payment file to Bank of America through Paymode-X channel (EDI eText)
• Customized Separate Remittance Advise and Positive Pay programs in Account Payables
• Customized Customer facing documents like AR Invoice, AR Customer statements, return to Vendor, Packing Slip and Print Purchase order for Italy and Australia
• Automated Customer facing documents archived into FTP server using Shell script, XML Bursting and NLS package
• Designed and Developed a custom solution for VAT reports in PO and AP for Italy localization
• Developed PL/SQL scripts to load data from external system to Fixed Assets FA MASS ADDITIONS interface tables.
• Developed a custom interface program to capture all inventory movements of an item will be transferred over to fixed assets (Any material movement transactions will have transferred to Fixed Asset module)
• Developed a custom program to retire R-ADD’s items that are calculating depreciation in Fixed asset module

Confidential, Seattle, WA

Platforms: Oracle E-Business Suite R12

Modules: Purchasing, AP, AR, SLA, iExpense, Fixed Assets and HR modules

Oracle Consultant

Responsibilities:

• Developed BI XML report to show complete list of iExpense Proxy Delegate information
• Converted an existing Discoverer report into BI XML Report. This report generates Excel output that shows Projects, PO’s and Federal grant information based on the user input parameters
• Developed BI XML Report for P-Card and Travel Card Use Tax Report in iExpense
• Developed BI Report for P-Card and Travel Card Status Report in iExpense
• Developed BI Report for Employeewise P-Card Detail Trans. Reconciliation Report in iExpense
• Developed BI XML Report to show complete lists of responsibilities, menus and functions that are been assigned to the user group. This report will be used by security Audit team.

Confidential, Irving, TX

Platforms: Oracle Applications R12

Modules: Inventory, PO, OM, AR, Cash Management, OPM and HR modules

Oracle EBS Senior Developer

Responsibilities:

• Developed Order Summary program to show a report finished item and row items consummation
• Developed an interface for employee outbound to Kronos system in Oracle HR
• Developed an interface for payroll outbound to ADP in Oracle HR
• Developed an interface for ADP expenses inbound to Oracle GL
• Developed a bank statement interface program in Cash Management
• Developed AME approval rules based on invoice amount for the following transaction type Payables Invoice
• Approval using Oracle Approval Management (AME) and configured action types and actions and set up the profile option to work for Payables only and also the required setup through Payables Options form
• Developed custom process to load Pricelist, modifiers and qualifiers using Pricing API’s QP Price List PUB (QP)

Confidential, Irving, TX

Platforms: Oracle Applications R12

Modules: Inventory, Purchasing, Order Management, CRM, OPM and HR modules

Oracle ERP Lead Developer

Responsibilities:

• Developed custom pick lease and custom pick confirm form (Order Management)
• Developed extension program to split order line (Order Management)
• Developed extension program to add backorder line to ready to release line (Order Management)
• Developed lot split program to split lot for lot individual items
• Developed program to assign item to child inventory org and restricting sub inventories
• Developed a custom program to calculate OPM lot costing based on metal content percentage
• Developed a custom program to add freight charges from PO to Landed cost management module (Advanced Pricing). Used advance pricing standard hook and added a custom logic to it.
• Customized OPM Simulator Oracle standard form to show customer specification min, max and target values of metal contents.
• Customized Select available inventory form to show Quality results for each lot
• Customized OPM manufacturing make to Order program to reserve more qty and increase batch qty
• Enhanced APEX custom forms and reports that are using by Plant supervisors

Confidential, NY

Platforms: Oracle Applications R12

Modules: BOM, WIP, Account Payables and Cash Management,

R12 Integration Lead

Responsibilities:

• Developed an interface program to sync supplier, sites and contacts, bank, and bank accounts information from Microsoft Dynamics to Oracle R12
• Developed an interface program to sync supplier invoice inf from Microsoft Dynamics to Oracle R12
• Developed an outbound interface to sync supplier invoice payment information (Check and ACH) from Oracle R12 to Microsoft Dynamics
• Developed forms to perform mass update of WIP Attributes (Supply type, Locator and Sub Inventory) in BOM for Kanban Items that are maintained at organization level in Common BOM
• Developed an Interface program to load item master data from MQ messages.
• Customized OAF iSupplier Portal Home Page by adding summary stack layout region (Display Hold, process and Reject invoices count)
• Customized Supplier OAF page to populate custom supplier number using JDeveloper

Confidential, Irving, TX

Platforms: Oracle E-Business Suite 11i and R12

Modules: Inventory, Purchasing, CRM, OM, WIP, BOM, GL, AP, PA, AR

Oracle EBS SCM Consultant

Responsibilities:

• Developed Hedging Application using Oracle Forms 6i
• Developed Hedging rollover application using Oracle Forms 6i
• Developed AP extension program to capturing Freight cost for Drop ship orders
• Developed Project conversion in PA module
• Developed conversion programs for Items and Service Contracts using Oracle PL/SQL and APIs
• Developed Hedging variance report using Discoverer
• Developed Hedging Rollover data report using Discoverer
• Developed hedging Sales order summary report using Discoverer
• Modified Custom BOM Details report to add Approved Supplier Information
• Developed BOM-WORKORDER Variance report for exceptions messages
• Supported APEX applications and conducted performance tuning for PLSQL
• Contributed with database designs and assisted in increasing response time for APEX reports
• Created custom API’s for REST web service calls (Sales order, PO and Invoices, etc…). The data will be supplied from Oracle ERP to SAP through REST web service calls (SOA).
• Developed APEX custom application for claiming product damages and service tickets
• Developed a custom credit management interface that grants customer credit line limit for processing sales order confirmation (Order Management)