SUMMARY:

• Over 22 year’s Oracle EBS techno - functional consulting experience in Oracle Application implementations and enhancements.
• Handful experience in several life cycle OracleApplications implementations and upgrades.
• Techno/Functional experience in Oracle EBS APPS configuration, setups, unit and integration testing of Oracle Order Management, Advanced Pricing, Shipping Account receivables, Cash Management, Purchasing, Inventory, Account Payables, Oracle e-Commerce Gateway, XML Gateway and OPM modules and customizations on Cycle Count, and Standard Costing solutions, assessed gap analysis and provided solutions based on client requirement.
• Excellent business and interpersonal skills, Aggressive Team Player with positive attitude, and Goal Oriented.
• Excellent technical and functional skills in Oracle Applications 10.6/10.7/11.0.3/11 i/R12 Oracle Applications 10.6/10.7SC/11.0.3/11i/R12 (Order Management, Advance Pricing, Shipping/WMS, AR, Trade Management, OPM, Oracle e-Commerce gateway/ EDI Gateway, OPM, AP, Cash Management, PO, GL, INV, BOM, ENG/Flow Mfg., WIP, XML Gateway, Oracle Alerts, System Admin and AOL).
• Very good knowledge on B2B and Oracle Procure to Pay (PTP), Order to cash (OTC) and Supply Chain Management (SCM) process.
• Ability to understand the business requirements, Business Process Modeling, GAP Analysis, Solution Design, Conference Room Pilot, System Integration Testing, Project Planning and Management, Application Setup / Configuration, User Acceptance Testing, Super User and End User, Production Deployment and Cutover, Post Production Support and translate it into technical design and build the solution with little direct supervision.
• Experience in project planning, testing for upgrades, preparation of test plans, test scripts, test cases, the end users in testing.
• Excellent command over functional aspects including implementation, customizations as a consultant provided quality deliverables and excellent production support.
• Have accomplished various tasks as a solution architect, team lead, application designer and lead analyst and developer.
• Expert in Requirement Analysis, Gap Analysis, Proof of Concepts, Functional and Technical Designs.
• Worked on Data Extractions, Data Conversions, Oracle Open Interfaces /API’S in Oracle/Oracle Application Implementations and Upgrade Projects.
• Excellent knowledge on writing AIM methodology Data Conversion (CV), Business Requirement Mapping(BR), Business System Testing (TE), Production Migration (PM), Build and Module Design (MD) documents.
• Excellent knowledge in Oracle e-Commerce Gateway/XML Gateway (B2B) modules.
• Handful experience on EDI - MIG (Message Implementation Guide’s and MRS (Mapping requirement specification documents.
• Good Experience on Oracle tools including PL/SQL, Reports 2.5/6i, Forms 4.5, Discoverer 2000/3i/4i, BI Publisher and SQL*Loader.
• Excellent Experience in developing EDI interfaces between Oracle Applications and external systems.
• Excellent skills on Oracle EDI Gateway/Oracle e- Commerce Gateway and Oracle XML Gateway Modules.
• Worked on Gentran (GIS) for Mapping document templates, Trading Partners configuration and Process Control Managers setups.
• Experience on EDI mapping tools Mercator, Innovis, Gentran and Oracle XML Gateway Message Designer.
• Very Good experience on EDI/Industry standards (ANSI X12, EDIFACT, RosettaNet (PIP’s), TRADACOM, UCC Net, VICS, TCIF and UPC).
• Handful experience in data/object mapping EDI (X12, EDIFACT), Rosetta Net and TRADACOM standards.
• Very good experience on GXS Products like Active Orders (AO), Active Intelligent (AI-DQC) and compliance link (CL) applications.
• Good experience RosettaNet Object mappings.
• Good experience SOA Dynamic routing and composer Applications and BPEL.
• Written EDI MIG and MRS (mapping requirement specification) inbound/outbound documents.
• Excellent understanding of the way various Trading partners does their Business and have skills to map their Business with EDI standards.
• Experience in distribution and warehouse management for 3PL integrations.
• Experience with off-shore development models very good experience in system/integration/UAT testing QC Process.
• Ability to establish effective working relationships and contribute in a team environment.

TECHNICAL SKILLS:

ERP: Oracle Applications 10.6/10.7SC/11.0.3/11i/R12 (Order Management, Advance Pricing, Shipping/WMS, AR, Oracle Trade Management(OTM), OPM, Purchasing, Payables, Oracle e-Commerce gateway/ EDI Gateway, Cash Management, PO, GL, INV, BOM, ENG/ Flow Mfg., Release Management, XML Gateway, Oracle Alerts, System Admin, AOL and BI Publisher).

B2B Tools/Systems: Mercator, Harbinger, Innovis, GIS, TIBCO and SOA 12c Applications, AWS Cloud Applications, Microservices(JSON data collection),TIBCO.

Languages: C, C++, SQL, PL/SQL, HTML, XML and UNIX Shell scripting.

Oracle Tools: SQL * PLUS, SQL * Loader and SQL * Reports.

Development Tools: SQL Navigator, TOAD, Forms Builder, and Reports Builder

GUIs: Developer 2000 (Reports 2.5/6i, Forms 4.5) and Oracle

Discoverer:: 2000/3i/4i, XML Publisher.

Databases:: Oracle 7.x/8.x/8i/9i/10g/11g, MS-Access, and SQL Server and UTL FILE utilities.

Operating Systems: Windows '95/98/2000/NT, MS DOS, Linux, HP UNIX, AIX and Sun Solaris.

Version Control Tools: PVCS and Kintana, HP Quality Center and Remedy - Issue Tracking tools.

PROFESSIONAL EXPERIENCE:

Principal Systems Analyst B2B/EDI Solution Designer

Confidential . San Diego, CA

Responsibilities:

• Worked on customer B2B RosettaNet PIP’s Purchase Order Request/Confirmation 3A4R/3A4C, Purchase Order Change Request/Confirmation 3A8R/3A8C and Purchase Order Update 3A7 message Implementation functional designs.
• Worked on 3A4R/3A4C,3A8R/3A8C and 3A7 message mapping requirement specifications documents.
• Worked on AWS, Microservices, TIBCO Interface architecture designs.
• Worked with Order Management team for Order Creation, Order Update and Order acknowledge business validation designs/MD065 documents.
• Worked on EDI 856, RosettaNet(3A4,3A8,3A7) specification guides/workbooks.
• Responsible for the detailed requirements, gap analysis, design/development, testing, and implementation for Inbound ASN-856 Interface.
• Working on Technical Requirement analysis, proof of concepts, and technical Design for ASN-856.
• Worked on Object Mapping document for X12 EDI 856 and RosettaNet 3B2 PIP’s,
• Worked on managed file transfer mechanism design using Flat files using Dynamic Routing mechanism inbound WAFER receipt/Shipment and Probe completion business document for Trade Management Reporting.
• Worked on AIM MD065 Techno/Functional design document.

Environment: Oracle Applications (12.2.3) (Procurement, Oracle Order Management, Shipping, Receiving, SOA Composer, AWS Cloud, Microservice, JSON, TIBCO and HP Quality Center).

Oracle Apps Sr. Functional Analyst/EDI Lead Interfaces Designer

Confidential, Portland, OR

Responsibilities:

• Worked on Order Management configuration and setups to support Sales Orders and Blanket Agreement Sales Order releases.
• Worked on Open Sales Order Conversions.
• Worked on Sales Force and Oracle Pricing Design Functional designs.
• Worked on custom JSI piking and ship conform interface design and development.
• Worked on consolidated Sales Orders Import design/Program (Standards, Consumption and VMI).
• Worked IR/ISO supply chain process to support Vendor Management Inventory.
• Responsible for the detailed requirements, gap analysis, design/development, testing, and implementation for Oracle ERP application systems EDI interfaces.
• Working on Technical Requirement analysis, proof of concepts, and technical Designs.
• Working on EDI interfaces to process Order Management, Shipping and AR receivables EDI inbound/outbound documents from/to Oracle Applications.
• Worked on managed file transfer mechanism design using SOA FTP process for inbound and outbound business transactional documents.
• Provide end to end solution for EDI from analysis to post go-live support, Co-ordinate with all parties involved for working and achieving the project deadlines, Analysis, Design, Implement and Support the following EDI transactions
• Designed infrastructure process for EDI inbound and outbound transactions.
• Gathered requirements from trading partners (customers and suppliers) and designed as Edi transaction to fit into Oracle Applications.
• Worked AIM MD050, MD070, MD120 and BR100 Documents.
• Worked on Rosetta Net B2B Interfaces 3A4, 3A8, 3A8, 4A3, 5C1, 3A7, 5C1, 4B3, 7B1 Dual PIPs.
• Written Functional design MD050 and Technical design MD070 documents for Inbound 850/855/856/844 and Outbound 810/812/820/850/855/856/849.
• Written MRS documents (Object Mappings) for Inbound 850/855/856/844 and Outbound 810/812/820/850/855/856/849 transactions.
• Written Solution Design Documents and Developed Edi Inbound (Inbound 850/855/856/844 ) and Outbound ( 810/812/820/850/855/856/849 ) transactions.
• Developed Edi Inbound (Inbound 850/855/856/ /862/842 ) and Outbound ( 810/812/820/850/855/856/849 ) transactions.
• Worked on BI reports for EDI Orders, Forecast and Inventory reports.

Environment: Oracle Applications (12.2.3) (Order Management, Shipping, AR, Oracle e-Commerce gateway, Procurement /Purchasing, Receiving, Oracle Payables, Cash Management and Supply Chain modules integrator and SOA FTP adaptors).

Oracle Apps Sr. Functional Analyst/EDI Interfaces Designer

Confidential

Responsibilities:

• Worked on customers, pricelist and supplier master data conversions.
• Designed and developed custom Warehouse 3PL Outbound 940, 943, DESADV interfaces to support Grupo Bimbo global business logistics.
• Designed and developed custom Warehouse 3PL inbound 944, 945, DLCFL (TRADACOM) interfaces to support Grupo Bimbo global business model.
• Worked on end-to end inbound 850/875/ORDERS/ORDFL documents (mapping, Oracle extensions).
• Worked on end-to end outbound 855/856/810/880/ INVFL documents (mapping, Oracle extensions).
• Worked on end-to end outbound Remittance advise 820 transactions (mapping, Oracle bank interface extensions)
• Worked on Release management Oracle e-Commerce Gateway Inbound 830 and 862 Transactions.
• Worked on GAP analysis between standard Oracle e-Commerce functionality and trading partner data need in EDI inbound and outbound transactions.
• Participated in resolution of issues working with 3rd party EDI translator/vendor in EDI data mapping, data extracts customizations etc.
• Coordinated setups, testing with functional teams.
• Written MD050 functional design documents for the Interfaces-Inbound Orders, Warehouse shipping advice and stock transfer receipt.
• Written MD050 functional design documents for the Interfaces-Outbound Sales Order Acknowledgements, advise shipping Advise, Invoice, and Remittance advice.
• Provided leadership, direction and all hands on technical EDI business documents Configuration/development/customizations.
• Provided best practice and industry specific solutions and advise on and provided alternative (out of the box) solutions.
• Worked on 3PL warehouse management interfaces (Picking, shipping and receiving).

Environment: Oracle Applications (12.2.3) (Order Management, Shipping, Oracle e-Commerce gateway, AR, iProcurement /Purchasing, Receiving, Oracle Payables and Cash management HP Quality Center and IBM Open TEXT integrator).

Oracle ERP Sr. Functional Analyst//EDI Solutions Designer

Confidential, Seattle, WA

Responsibilities:

• Responsible for the detailed requirements, gap analysis, design/development, testing, and implementation for Oracle ERP application systems EDI interfaces.
• Providing Production support and troubleshooting Channel development/B2B solutions EDI Interfaces.
• Working on Technical Requirement analysis, proof of concepts, and technical Designs.
• Working on EDI interfaces to process Order Management, Shipping and AR receivables EDI inbound/outbound documents from/to Oracle Applications.
• Worked on functional solution Design documents for Order Management and Procurement Business Interfaces.
• Worked on 3PL Warehouse(NDC) Shipping Order/Confirm EDI ASN Labels functional design to support customers ASN/Shipping documents.
• Worked on ONT OEXOEORD form/function level personalization.
• Working on custom Oracle EDI interfaces Technical designs documents.
• Working on GXS Trading Grid online tracking for Active EDI business documents.
• Responsible for evaluating, customizing, developing, monitoring and supporting Oracle ERP Applications 11i/r12 production systems.
• Create, review and approve technical and system interface designs, physical data models, physical application and infrastructure architectures; technical specifications; develop prototype to validate technical design.
• Working on new EDI capabilities ongoing Project for client B2B Solutions EDI Interfaces extensions.
• Working on Oracle e-Commerce Gateway extensions using Oracle extensible architecture for EDI business Interfaces.
• Working on enhancements solution design and development for EDI Inbound and Outbound transactions.
• Working on setups/configurations in Oracle EBS systems for new business process and Interfaces.
• Validating Quality Center test cases/test scripts for Oracle Interfaces/Reports.
• Worked on end-to end Outbound 850,860,824 and Inbound 855,856,810 (Purchasing, receiving, account Payables) Supplier Integration EDI Interfaces.
• Worked on Solution Design Documents and Developed Edi Inbound, 875,820,824,864,997 and Outbound 855,856,810/880,812 transactions.
• Worked on EDI Inbound 830,862 transactions using Oracle e-Commerce Gateway module.
• Written Mapping EDI Inbound EDI X12 vs. Oracle (, 875,820,824,864,997)/Outbound Oracle V/s EDI X12 855,856,810/880 MRS documents provided to GXS for EDI maps build.
• Worked on GXS Trading Grid online tracking for day by day transactions reporting
• Validated (Quality Center) test cases/test scripts for PTP Interfaces/Reports (PO Print, Vertex PO hookup, PO Approval and PO Acknowledgement /notification)
• Written Supplier EDI specification guidelines documents for Purchase Order -850out/, Change Purchase Order 860out, Purchase Order Acknowledgement 855in and Advance Shipping Notice 856in transactions.
• Written Supplier EDI Mapping Requirement specifications(MRS) documents for Purchase Order -850out/Change Purchase Order 860out, Purchase Order Acknowledgement 855in and Advance Shipping Notice 856 in transactions
• Preparing technical/functional solution design, developing and unit testing the code
• Provide support to the end users, diagnosing and resolving problems, manage configuration changes patches and upgrades, and work with outsourced application management teams.

Environment: Oracle Applications (11.5.10) (Order Management, Advance Pricing, Shipping/WMS, AR, Oracle e-Commerce Gateway, XML Gateway, Purchasing, Receiving, Account Payables, GSIT, Linux, XML Gateway message Designer and GXS Trading Grid/Open Text.

Oracle Applications Sr. Consultant/EDI Developer

Confidential, New York, NY

Responsibilities:

• Provided Production support for Supply chain (PTP) EDI -855/856/810 Inbound transactions
• Modified Custom EDI Purchase Orders creation interface in Oracle purchasing for EDI suppliers
• Added EDI -850 Purchase Orders Outbound Header level/Item level attachment segments in Outbound EDI-850 POO transaction
• Modified custom EDI 856 ASNI transaction to populate correct Bill to and Ship to locations id’s in ROI Interface tables for receipt and delivery process
• Developed Additional EDI Alerts (Exceptions) for EDI-855 Purchase Orders Acknowledge inbound (POAI), EDI-856 ASN Inbound and EDI-810 Invoice Inbound transactions
• Developed EDI mapping documents for Payment Remittances Advice Outbound EDI 820 (REMADV)
• Developed EDI mapping documents for Price Catalog Inbound EDI 832 (CATI) Inbound

Environment: Oracle Applications (11.5.10) (, Purchasing, Receiving, Oracle e-Commerce gateway, Oracle Payables, (AP), Oracle Alerts, Linux and GIS)

Oracle APPS Techno/Functional Consultant/EDI Solution Designer

Confidential, NEW JERSY NJ

Responsibilities:

• Worked on Purchasing setups and configurations to support Standard and Blanket PO/Releases.
• Worked on Receiving Open Interface functional design to support lot attributes for ASN Shipments and receipt process.
• Worked on Gentran GIS, Mapping, Design, development and responsibilities include end to end project management individually managing communication between Celgene IT, Business Team, customer / supplier trading partners, sterling commerce.
• Provide end to end solution for EDI from analysis to post go-live support, Co-ordinate with all parties involved for working and achieving the project deadlines, Analysis, Design, Implement and Support the following EDI transactions
• Designed infrastructure process for EDI inbound and outbound transactions.
• Gathered requirements from trading partners (customer’s and suppliers) and designed as Edi transaction to fit into Oracle Applications.
• Written Functional design MD050 and Technical design MD070 documents for Inbound 850/855/856/844 and Outbound 810/812/820/850/855/856/849.
• Written MRS documents for Inbound 850/855/856/844 and Outbound 810/812/820/850/855/856/849 transactions.
• Written Solution Design Documents and Developed Edi Inbound (Inbound 850/855/856/844 ) and Outbound ( 810/812/820/850/855/856/849 ) transactions.
• Developed Edi Inbound (Inbound 850/855/856/844 ) and Outbound ( 810/812/820/850/855/856/849 ) transactions.
• Designed and developed trade management custom EDI 844(Claim creation) Inbound and 849(claim reconciliation) outbound transactions.
• Worked on FDA Risk Management process interfaces using SOA/BPEL.
• Worked on Trade Management Claim Import Interface and AR Auto lock box Interface.
• Written user test scripts for EDI transactions testing.
• Worked with Sterling Commerce direct connectivity.
• Responsible for Oracle e-Commerce Gateway configurations, Trading Partner setups, code conversions, process/column rules and extensible architecture development and testing
• Designed and developed EDI 810/INO, 850/POO, 856/DSNO and 820/PYO Transactions using Oracle e-Commerce gateway.

Environment: Oracle Applications (12.04) (Purchasing, Receiving, Oracle e-Commerce gateway, Order Management, Shipping, AR, Trade Management, Oracle Alerts, System Admin., AOL) Linux and Gentran Integration Server)

Oracle Applications OTC Consultant/EDI Lead Developer

Confidential, Concord, MA

Responsibilities:

• Gathering requirements from EDI legacy system and Designed as Edi transaction to fit into Oracle Applications.
• Designed the Mappings between Welch’s and their Trading Partners for both the Inbound and out bound EDI transactions.
• Written Solution Design Documents and Developed Edi Inbound (850/875/852/944/945 ) and Outbound (810/880/856/855/865/940/943 ) transactions.
• Written Mapping EDI Inbound EDI X12 vs. Oracle (850/875/852/944/945 )/Outbound Oracle Vs EDI X12 (810/880/856/855/865/940/943 ) documents and provided to SPS Commerce for EDI documents translations.
• Worked with SPS Commerce EDI documents communications.
• Designed web forms Layouts for EDI 812/816/820/824/864/867 Transactions.
• Responsible for Oracle e-Commerce Gateway configurations, Trading Partner setups, code conversions, process/column rules and extensible architecture development and testing
• Used Extensible Architecture in INO-810/880 and DSNO-856 (SSCC Shipping Pallet Labels) Transactions.
• Written Test scripts to test EDI Inbound and Outbound translations.
• Provided Production support for daily business EDI transmissions
• Designed and developed 3PL EDI 940,945,943 and 944 custom layouts/Interfaces in Oracle EBS.
• Worked on OPM Items (API) and Discrete Item Update (Item Import).
• Worked on OPM API’s-Receipe, Routings and Lot Conversions.
• Worked on Trade deduction s/claim settlement Import (4sight -source system to Oracle Trade management).
• Worked on Trade Accruals import (4sight -source system to Oracle EBS)
• Worked on customer deduction extract/ load Interface (Oracle Trade management source system to 4Sight system)
• Worked on Sales Orders/Invoices Conversions
• Worked on Shipping API’s for Pick and ship confirm (EDI 945 Transaction) Process.
• Worked Receiving open interface (ROI)-EDI 944 Transaction.
• Worked on EDI Orders (850/875/852) Custom Inbound - Order Import Process.
• Developed package for TAX and FREIGHT lines for 810 Inbound Transaction.
• Written Ftp Programs and Automation Inbound/Outbound programs for EDI files processing.
• Designed and developed Customer related Inbound 850, Outbound 810 Transactions.
• Written Exception programs for EDI Inbound Transactions using Oracle Alerts and Send mail from UNIX.
• Worked on EDI-820 (Auto Lockbox) and EDI-824 Application Advice Inbound Transactions.
• Written Mapping Documents (EDI X12 vs. Oracle) for Inbound and Outbound (Oracle Vs EDI X12) transactions.

Environment: Oracle Applications (11.5.10) 11i (Oracle e-Commerce gateway, Order Management, Trade Management, GL, OPM, Receiving, AR, Oracle Alerts, System Admin., AOL) Linux, Trusted Link, Web methods and SPS Commerce and 4Sight)

Oracle Applications Consultant

Confidential, Denver, CO

Responsibilities:

• Setup trading partners in Oracle e-Commerce Gateway.
• Defined Code conversion in Oracle e-Commerce Gateway.
• Used Extensible Architecture in INO-810 for Serial Numbers, Cusomer Item commodity codes.
• Written Program for Customer Ship to site’s update for 850 Purchase Order Inbound Transaction.
• Developed package for TAX and FREIGHT lines for 810 Inbound Transaction.
• Designed and developed Customer related Inbound 850, Outbound 810 Transactions.
• Designed and Developed Supplier related Outbound 850, Outbound 860 and Inbound 810 Transactions.
• Written Exception programs for EDI Inbound Transactions using Oracle Alerts and Send mail from UNIX.
• Worked on EDI-820 (Auto Lockbox) and EDI-824 Application Advice Inbound Transactions.
• Developed maps using Gentran Server - Applications Integrator (AI) for EDI Inbound 850, 810, 820, and 824 transactions.
• Developed maps using Gentran Server - Applications Integrator (AI) for EDI Outbound 850,860 and 810 transactions.
• Gathered EDI guidelines from Trading Partners and based on requirement and Developed EDI maps.
• Setup Trading Partners using Gentran trading Partners Administration.
• Configured Source, Process and Delivery Agents using Gentran Process Control Manager (PCM).
• Written Mapping Documents (EDI X12 vs. Oracle) for Inbound and Outbound transactions
• Written Automation programs for EDI files processing.

Environment: Oracle Applications (11.5.9) 11i (e-Commerce gateway, Order Management, Purchasing, AR, AP Cash Management, Oracle Alerts, System Admin., AOL) HP-UNIX and Gentran Server UNIX 6.02.

Oracle Applications Sr. Technical Consultant

Confidential, Detroit, MI

Responsibilities:

• Developed 20 Week Production Operating Plan Report: This Report for 20 Week Plant Capacity, Schedule demand and Safety Stock Information.
• Developed Daily Production Operating Plan Report: This Report for Daily Plant Capacity, Schedule demand and Safety Stock Information.
• Working on Routing API (Bom Rtg Pub).

Environment: Oracle Applications (11.5.8) 11i (Oracle Flow Manufacturing, MRP, BOM and WIP) HP-UX and Oracle Reports 6i.

Oracle Applications Sr. Techno/Functional Consultant

Confidential, Milwaukee, WI

Responsibilities:

• Configuration Oracle e-Commerce gateway Module, Setup the Trading Partners and Develop Oracle e-Commerce Gateway/non e-Commerce gateway inbound and outbound Transactions.
• Written Oracle Mapping documents for Purchase Order inbound (ORDRS/850), Grocery Purchase Order inbound (ORDERS/875), Purchase Order Change inbound (ORDCHG/860), Invoice Outbound (INO/810) and Grocery Invoice Outbound (INO/880) Transactions.
• Designed, developed and tested Purchase Order inbound (ORDRS/850), Grocery Purchase Order inbound (ORDRS/875), Purchase Order Change inbound (ORDCHG/860), Invoice Outbound (INO/810) and Grocery Invoice Outbound (INO/880) Transactions.
• Written Pl/Sql Packages for non-Oracle e-Commerce gateway transactions Edi/824 Application Advice, 864 Error Text messages and Edi/858 Shipment Information (Bill of Lading) Transactions.
• Used Innovis for Inbound and Outbound maps development.
• Worked on BAI2 Format Bank Statement Reconciliation Transaction (Cash Management).
• Written automation programs (Shell Programs) for inbound file process management.
• Written Oracle e-Mail Notifications using Oracle Alerts for Exception Management in Oracle e-Commerce gateway Inbound Transactions.
• Worked on Customization Oracle e-Commerce Gateway Outbound Transaction using DFF’s and Extensible Architecture.

Environment: Oracle Applications (11.5.9) 11i (EDI Gateway/e-Commerce gatewayOrder Management, Shipping, Purchasing, OPM Inventory, AR, Cash Management, Oracle Alerts, System Admin., AOL) and Linux

Oracle Applications Techno/Functional Consultant

Confidential, Detroit, MI

Responsibilities:

• Responsible Production support for Process Purchase Orders Outbound (Process PO), Change Purchase Orders Outbound (Change PO), Self Build Invoice Outbound (SBI), Remittance Advice Outbound (REMADV), Error Acknowledgement Outbound (APERAK), and Advance Shipment Notice Inbound (ASN) XML documents
• Developed large PO creation program for Large Outbound XML documents generation
• Worked on Receiving Open interface for Advance Shipment Notice Inbound errors
• Modified DTD’s and Maps for data mapping using Oracle XML Gateway Message Designer
• Developed FMC XML Gateway ASN Inbound Error Report, Oracle Work flow monitor report using Reports 6i
• Worked on Building Workbooks in Discoverer 3i edited the existing workbooks, defining calculations and formatting worksheets
• Involved setting up hub and trading partners in Oracle XML gateway module
• Worked on performance, development and testing Large Outbound XML documents generation process
• Prepared MD.070 Application Extensions Technical Design and mapping documents.
• Used PVCS and Kintana utilities for Production Migrations.
• Modified FTP program to avoid special characters from UTF8 to ISO 8859 1 translation.

Technical Environment: Oracle Applications 11i (Oracle XML Gateway, Purchasing, Receiving, Account Payable, Oracle Workflow) Oracle Message Designer 2.6, Discoverer 3i, HP-UNIX, PVCS and Kintana Utility.

Oracle Applications Technical Consultant

Confidential, Houston, TX

Responsibilities:

• My Role was Configure Oracle e-Commerce Gateway, define data requirements, Setup Trading Partners, preparing edi inbound data files and Development and testing EDI inbound and outbound Order Management (Customers) Transactions using Oracle e-Commerce gateway Module
• Designed, developed and tested Purchase Order inbound (POI-850 Order Import) transaction
• Designed, developed and tested Invoice Outbound (INO-810 Oracle Account Receivables) and Outbound Ship Notice/Manifest (DSNO-856 Shipping Execution) transactions
• Written Purchase Orders Inbound Intermediate Program (Order Processing API)
• Developed Trading Partners Setup Program This Program Setup the Trading partners group, Header, details information based on Customer master
• Worked on Customer Master conversion to populate EDI Location Codes Customers Site level
• Used Extensible Architecture in EDI-810 AR Invoice Outbound transaction for MAN Segment (Order Management, Shipping and Receivables)
• Defined Value sets and Descriptive flex fields Global location, PO Type, PO Facility Number and PO Department for Wal-Mart Trading Partner in Purchase Orders Inbound (POI-850)
• Developed Periodic Alerts EDI-850 Order Import Interface Errors Alert, EDI Sales Orders Alert for Exception Management.
• Developed maps using Gentran Server - Applications Integrator (AI) for EDI Inbound 850 transaction.
• Developed maps using Gentran Server - Applications Integrator (AI) for EDI Outbound 810 and 856 transactions.
• Written Shell Programs to Automate inbound and outbound file management
• Responsible for gathering requirements, configuration/setup, and testing/
• Developed EDI Trading Partners Invoices Report using Oracle Report 6i
• Developed and tested Oracle Order Management, Oracle Shipping execution, Oracle Receivables reports using Discoverer 4i
• Worked on test plans, test scripts and enhancement requests and documentation using AIMS methodology
• Written technical, implementation and mapping documents

Environment: Oracle Applications (11.5.8) 11i (EDI Gateway/e-Commerce gatewayOrder Management, Shipping, AR, Oracle Alerts, System Admin. And AOL) Oracle 9i, Reports 6i, Discoverer 4i and Sun Solaris.

Oracle Applications Technical Consultant

Confidential, Shawnee, OK

Responsibilities:

• Designed, developed and tested Purchase Order Outbound (POO-850) and Purchase Order Change Outbound (POCO-860) transactions
• Designed, developed and tested Purchase Order inbound (POI-850 Order Import) and Invoice Inbound (INI-810 Payables open interface) transactions
• Converted Vendors, Vendor Sites and Vendor Contacts
• Developed Periodic Alerts EDI-850 Order Import Interface Errors Alert, EDI Sales Orders Alert for Exception Management for Purchase Orders Inbound (POI-850)
• Developed Periodic Alerts EDI-810 AP Invoice Errors Alert, for Exception Management for Invoice Inbound (INI-810)
• Responsible for gathering requirements, configuration/setup, and testing/
• Written Shell Programs to Automate inbound and outbound data files
• Responsible to provide data file formats for gentran data file mapping
• Written technical, implementation and mapping documents

Environment: Oracle Applications (11.5.7) 11i (EDI Gateway/e-Commerce gateway, Oracle Alerts, PO, Order Management, AP, System Admin. and AOL), Reports 6i, Oracle 9i and Sun Solaris

Oracle Applications Technical Consultant

Confidential, Santa Clara, CA

Responsibilities:

• Developed and tested Purchase Orders Inbound (POI-850 Order Import), Purchase Order Change inbound (POCI-860 Order Import), Ship Notice/Manifest Inbound (ASNI-856 Receiving Open Interface) and Invoice Inbound (INI-810 Payables open interface) transactions
• Developed and tested Invoice Outbound (INO-810 Oracle Account Receivables), Purchase Order Outbound (POO-850 Oracle Purchasing) Purchase Order Change Outbound (POCO-860 Oracle Purchasing), Purchase Order Acknowledgments Outbound (POAO-855 Oracle Order Management and Purchase Order Change Acknowledgments Outbound (POCAO-865 Oracle Order Management) transactions
• Worked on Order Import, Payables Open Interface and Receiving Open Interface
• Used Extensible Architecture in AR Invoice Outbound transaction for Serial Numbers, Remit to Notes and PO Line Number
• Responsible for gathering requirements, configuration/setup, and testing/
• Developed Periodic Alerts for Exception Management in inbound Transactions
• Customized Print Selected Invoices Report, Printed Purchase Order Report, Printed Change Purchase Orders Report using Oracle Report 6i
• Written technical, implementation and mapping documents for e-Commerce gateway transactions

Environment: Oracle Applications 11i (EDI Gateway/e-Commerce gateway, XML Gateway Oracle Alerts, Order Management, AP, AR and PO) Oracle 8.x, Reports 6i, Sun Solaris and SQL*Reports

Oracle Applications Technical Consultant

Confidential, Orlando, FL

Responsibilities:

• Developed Replenishment Open Interface (Oracle Inventory) for retail sales information
• Imported historical Customer information from the existing AR system into Oracle
• Receivable Applications (Customer Interface) for collection needs and better customer
• Management by keeping track of customer contacts and calls details for future s
• Using PL/SQL and SQL*Loader
• Developed Bulk ups table populate report (New report) this report populate the Customer, Item, Order and Shipping information into custom table for the Ship Confirm Open Interface
• Modified Bill of Material structure report to include manufacturer name, manufacturer part number to print all the designators in a line to number of pages it will run if they are lot of designators and adjust the layout as required by the user
• Worked on Ship confirm Open Interface
• Advance Shipping Notice OutboundASNO-856. This Transaction Integrated with OE/AR/INV/BOM Modules
• Invoice Outbound INO-810. This Transaction integrated with AR Module
• Worked production support for 852, 856 Transactions
• Developed Oracle Applications reports using Oracle Reports 2.5

Environment: Oracle Applications (Manufacturing, Financials and EDI Gateway/e-Commerce gateway,) 10.7/11i (INV, BOM, GL, AR, AP, OE/OM, and AOL) Oracle 7.3/8.x, Reports 2.5/6i, Discoverer 3.0 and HP-UNIX

Oracle Applications Technical Consultant

Confidential, Linthicum hills, MD

Responsibilities:

• I am responsible for doing study of existing reports writing the document regarding the customization part by it with the standard reports. Discussing, testing and the users during this period I was upgraded /developed more then 20 reports meeting customer Requirements using Oracle 6i Reports
• Completed the conversion of the Bills of Material and Inventory modules of Oracle Manufacturing and Accounts Receivable of the Oracle Financials Multi-Org
• Worked on Data Extraction using utl file utility package for Shipping labels
• Designed and developed a program TCIF Product package labels (Inner Box Labels) to extract shipping data for CIENA Shipping Labels, interface the program with loftware that generates the bar-coded labels.
• Designed and developed a program TCIF Shipping/Receiving Transaction labels (Outer Box Labels) to extract shipping data for CIENA Shipping Labels, interface the program with loftware that generates the bar-coded labels
• Worked on Oracle Order Import process to perform volume testing this program insert records in to the Oracle Order interface tables like OE HEADERS IFACE ALL, OE LINES IFACE ALL
• Developed APEXTRACT Program for 1099. This program uploads vendor, invoice, and amount information form AP and GL Modules

Environment: Oracle Applications (Manufacturing, Financials) 11.0.3/11i (INV, BOM, OE/Shipping and AP) Oracle 7.3/8.x, Reports 2.5/6i and Sun Solaris

Oracle Applications Technical Consultant

Confidential, Sanjose, CA

Responsibilities:

• Responsible for Design and Development of various reports in OE, MRP Modules, and Event Alerts.

Environment: Oracle Applications (Manufacturing) 11.0.3 (OE/Shipping, INV, BOM, MRP, and Oracle Alerts) Oracle 7.3, Reports 2.5 and Sun Solaris

Oracle Applications Technical Consultant

Confidential, Santa Clara, CA

Responsibilities:

• EDI 850 (Purchase Order release) development was gateway to the Project. Sales Orders were inserted into Requisitions Interface Table and Requisitions were created. Purchase Orders were created with the Auto Create option by using these Requisitions. Final Output File is generated with Sales Order, Purchase Order, Customer, and Header/Line Notes Information. The whole process is automated by scheduling concurrent programs and Alerts
• Developed Advance Shipping Notice. Inbound - EDI 856(Receiving Open Interface)
• Creation of Purchase Order and generation of EDI File and sending to Japan.
• Outbound - EDI 850 Interface Program was written in PL/SQL.
• Alerts were created.
• SQL Scripts were written to create Custom Tables
• Worked Production Support for ASN (856) and POO (850) transactions and Documentation
• Responsible to write Functional and Technical design documents
• Customization and development of Reports in Order Entry, Inventory, Bill of Material Modules
• Developed Order Entry, Inventory reports using Oracle Discoverer 2000

Environment: Oracle Applications (Manufacturing, Financials) 10.7 / 11.0.3 (OE, PO, AR and INV) Oracle 7.3, Reports 2.5, Oracle Discoverer 2000, SQL*Loader, Mercator 5.0 and HP UNIX.

Oracle Applications Technical Consultant

Confidential, LA, CA

Responsibilities:

• Developed EDI In/850, out/855 and out DSNO maps using Mercator mapping tool
• Responsible for design and development of Reports 2.5 in OE, PO, INV and WIP.
• Interacted with users for designing reports as per client's business requirement.
• Designed and developed reports like order action buy report, lot transaction register report, min-max report, aged booking report, write time report, back order detail report, open purchase order report, PAR quality report etc.
• Implemented coding standards for better performance and effective usage of Hardware Resources, like using single query data model rather than multi query data model and using PL/SQL instead of User Exits, etc.
• Preparation of functional and design documents

Environment: Oracle Applications (Manufacturing) 10.7 (OE, INV, WIP and PO)

Oracle Applications Technical Consultant

Confidential, Chicago IL

Responsibilities:

• Developed Conversions, Open Interfaces, Customization of reports and forms OE, PO and INV modules.
• Used SQL* Loader for Conversions and Interfaces.
• Registered, customized and new reports in AOL.
• Involved in development of interface programs for transferring data from external system into Oracle Order Entry using order import Interface.
• Developed interfaces using temporary tables, SQL* Loader, packages for file I/O and PL/SQL stored procedures
• Implemented Oracle Coding standards in developing reports and customizing existing forms

Environment: Oracle Applications (Manufacturing) 10.7 (OE, PO and INV) Oracle 7.3Reports 2.5, Oracle Forms 4.5, SQL*Loader and HP UNIX

Oracle Applications Technical Consultant

Confidential

Responsibilities:

• As a consultant involved in designing and developing interfaces, customization of user requests and implementation change requests. During this process interacted with end users and implemented their requirements into the Application Systems, per their needs
• Involved in Open Interfaces for BOM, WIP, MRP, OE, and INV modules
• Migrated data from legacy systems into Oracle applications
• Registered customized reports and forms in AOL

Environment: Oracle Manufacturing 10.6/10.7 SC (PO, OE, INV, BOM, WIP, MRP, and AOL and Sysadmn). Developer 2000, Forms 4.5, Reports 2.5 and SQL*Loader

Confidential

Programmer Analyst

Responsibilities:

• Project was developed using Oracle 7.3, forms 4.5 and SQL*Plus reports to account for various automobile components between receipts, inspection and stores
• Forms were developed for entering material in inventory
• Reports were developed for inspecting the components and parts, for acceptance/rejection screens stores data regarding the goods

Environment: Oracle 7.3, Forms 4.5 and Reports 2.5, Windows 95 and SQL*Loader