SUMMARY:

• Over 22 year’s Oracle EBS techno - functional consulting experience in Oracle Application implementations and enhancements.
• Handful experience in several life cycle Oracle Applications 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 Confidential 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 Training, 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, training 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 ( Confidential ) 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.
• Worked on 3PL warehouse management interfaces (Picking, shipping and receiving).
• Worked on data extraction, data conversions, API’s and open interfaces in various Oracle Financials, Manufacturing modules using functions, procedures trigger and packages for validations Used SQL* Loader and UTL FILE Package for data conversions and interfaces
• Customized and developed new reports using Oracle reports 2.5/6i.
• Used Discoverer 2000/3i/4i to set-up ad-hoc queries and reports.
• Good experience on Oracle FORM Personalization.
• Developed Periodic and Event Alerts.
• Good Experience on development of EDI interfaces between Oracle Applications and external systems.
• Possesses functional understanding of Oracle manufacturing Applications.
• Registered the Procedures, Packages, Reports, and Shell Scripts as concurrent programs.
• Involved in functional analysis of the business process and implementing Order Management Account Receivables Purchasing and Cash Management modules.
• Worked as a functional developer responsible for gathering requirements, configuration/setup, and testing/training.
• Functional and Technical complete involvement of the Oracle e-Commerce Gateway setups Defining the trading Partners, code Conversions, configuration setups, mapping and automation for the e-Commerce gateway transactions.
• Used Extensible Architecture in Oracle e-Commerce gateway outbound transactions.
• Developed Oracle Alerts for Exception Management in Oracle e-Commerce gateway inbound transactions.
• Written test plans, test scripts and enhancement requests. Expert in documentation using AIM Methodology
• Solid understanding of design and coding standards for extensions to the Oracle Applications
• Handful experience in UNIX Shell scripting.
• Technical Expertise: SQL and PL/SQL for Oracle Database Components, Oracle BI Publisher, Workflow, Forms, Reports, Development, Customizations Personalization’s and Extensions. Application Development using APEX.SOA Integration Using BPEL, ESB Business Event and Subscriptions.XML and EDI Gateway Integrations.
• Worked on more than ten EDI (X12, EDIFACT), TRADACOM and custom format O2C, P2P engineering and transportation Interfaces.
• Worked on Rosetta Net Confidential Interfaces 3B2,4B2,3B12,3B13,3C3,3A4, 3A8, 4A3, 5C1, 3A7, 5C1, 4B3, 7B1 Dual PIPs.
• Good knowledge on AWS cloud, Microservice and JSON data storage and communication formats.

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).

Confidential 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

Confidential, San Diego, CA

Responsibilities:

• Worked on customer Confidential 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 Confidential 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/844 /830/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, Confidential interfaces to support Confidential global business logistics.
• Designed and developed custom Warehouse 3PL inbound 944, 945, DLCFL (TRADACOM) interfaces to support Confidential 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/ Confidential 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 Confidential 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 850 860,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 (850 860,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 Confidential 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)