Sterling B2bi Consultant Resume
SUMMARY:
- 22 + years of experience in all aspects of EDI.
- 20 + years of extensive SAP EDI and SAP IDOC mapping experience.
- Roles have included analysis, design, EDI software implementation, pre & post - production support, testing, training and project management.
- Outstanding communication skills coupled with vast Sterling Products, EDI & SAP background makes a strong asset to any team.
- SAP SD configuration for pricing, tax condition, output types determination, Tax determination
SKILLS:
22 + yrs EDI with Sterling Integrator SI 5.2.6.2, 5x, Gentran Integration Suite (GIS version 2.x, 3.x, and 4.x), Sterling GIS on i-Series 4.3, Gentran:Server NT/UNIX( 3.x, 4.x & 5.x,6.x), Gentran Director Pro 5.x, Inovis TLE NT/UNIX/AS400 SAP with X12 & IDOC mappingAltova Map Force
LIGHTWELL B2B FRAMEWORK:
X12 Version: 200 series through 900 series - 204, 210, 214, 810, 812, 820, 821, 823, 824, 830, 832, 835, 840, 843, 846, 850, 852, 855, 856, 860, 865, 867, 870, 875, 880, 940, 943, 944, 945, 990 & 997
EDIFACT/TRADCOM: DELFOR, DELJIT, DESADV, INVOIC, INVRPT. ORDCHG, ORDERS, ORDRSP, PAYEXY, PAYMUL, PRICAT, REMADV, SLSRPT, SPCORD
SPEC2000: S1BOOKED, S1QUOTES, S1REJECT, S1NVOICE, S1SHIPPD, S1ORDEXC
XML: XML to EDI, EDI to IDoc, XML to XML, XML to EDIFACT, SPEC2000 to XML & IDoc to XML SPEC2000
EXPERIENCE:
Confidential
Sterling b2bi Consultant
Responsibilities:
- Project development and system architect
- Working with Gentran Server for UNIX and Migrating to SI
- Provided EDI expert for the Business, CSR and Customer
- Worked with the business user to implement new customers
- Confidential Sterling performance tuning and system monitoring
- Confidential Sterling Mapping Support (810, 813, 820, 830, 864, 824, 850, 860, 850, 855, 852, 856, 820, FLAT FILE & XML) using Oracle.
- Working with Oracle App to EDI and EDI to Oracle
- Daily support & Monitoring of SI Errors
- Migrating for SI 5.2.2 to b2bi 5.2.6 for 180 trading partners
- Migrating Lightwell frame 2.2 to 2.6.5
- Implementing MFT
- Implementing mail-boxing for partner
Confidential
SAP EDI Tech Lead Consultant
Responsibilities:
- Sterling GIS & SI trading partner setup, mapping, BPML
- Mentor team on Sterling SI
- Migrating from GIS 4.3 to SI 5.2.2 & 5.2.4
- Migrate from Oracle 10g to 11G on GIS & SI Database
- Mapping SPEC2000 transaction in Sterling SI 5.2
- Migrating from ERP Lawson to SAP ECC 6
- FTP, SFTP & XLST
- SAP Partner Profile setup
- EDPAR (Voe4) trading partner cross reference bill-to & ship to.
- SAP Partner (we20) profile setup
- IDOC trouble shooting and reprocessing using t-codes (voe4,vt03n, voe2, vf02, vl03n and more)
- Creating Mapping Requirement Specification (MRS) for IDOC mapping to and from SAP
- Apart of the blue printing team for EDI to SAP migrating
- Mentor and training EDI team on SAP, IDOC’s and Mapping for SAP
- Setup Confidential Sterling mailbox and file gateway.
- Using mailboxes for internal business group to send file to Confidential Sterling SI
- Using Confidential for moving routing files through the company
Confidential
Gentran Consultant
Responsibilities:
- Mapping for XML, 214, 940, 945, 856, 943, 944, 846, 315, 204, 210, 997 & 990
- Trading Partner profile setup
Confidential
SI / SAP Consultant
Responsibilities:
- Migrating from GIS 4.3 to SI 5.1 to SI 5.2.2
- Trading partner configuration
- Mapping to support SAP IDOC formats for ORDERS, SHPMENT, INVOIC, DELVRY, PEXR2002, PROACT, XML
- SAP to X12 SAP to XML, XML to SAP & X12 to SAP, GAP analysis for 810, 820, 830, 850, 852, 855,855, 856, EDIFACT
- BPML development
- SAP Partner Profile setup
- EDPAR (Voe4) trading partner cross reference bill-to & ship to.
- SAP Partner (we20) profile setup
- IDOC trouble shooting and reprocessing using t-codes (voe4,vt03n, voe2, vf02, vl03n and more)
Confidential
Gentran/SAP Consultant
Responsibilities:
- Trading partner configuration
- SAP Partner (we20) profile setup for outbound 856 ASN
- Mapping to support SAP IDOC formats for DELFOR, DELVRY, INVOIC
- SAP to 830, 852 X12 GAP for Outbound 856
- Training employee on Gentran
- Develop migration plan for migrating to Gentran Server or SI
- Documented current system state and future to-be system
Confidential
SAP/Gentran/ Sterling Consultant
Responsibilities:
- EDI & SAP Implementation to ECC 6
- Overview of SAP and EDI setups
- Overview of EDI mapping and Trading Partner setup
- Creation and testing maps for 850, 810 & 855 to SAP IDOC ORDERS, ORDRSP & INVOIC
Confidential
SAP/Gentran i-series Consultant
Responsibilities:
- Overview of the SAP and EDI setups
- Overview of the EDI mapping and Trading Partner setup
- Creation and testing maps for 850, 810 & 855 to SAP IDOC ORDERS, ORDRSP & INVOIC
- Modified existing SOAP connection to Amazon.com
Confidential
GIS Tech Lead Consultant
Responsibilities:
- Sterling GIS trading partner setup, mapping, BPML
- Team lead for Sterling WFoD & SCV project
- Setting up onbroading for new supplier for Sterling WebForms
- Install & Testing Sterling Control Center software
- Gentran Server conversion to GIS 4.3
- PGP setup
- FTP, SFTP & XLST
- Configured McAfee E-Business Server 8.5.x
- Migrating 35 flat file, PGP encryption, PGP decryption, reports & email processes to GIS from Gentran Server.
- X12 Mapping for 850, 855, 830, 810
- Setup routing table for quicker deployment of BP’s
- Setup ODBC maps for Document Tracking system
- Setup SFTP with Confidential
- Testing mailbox functionality for future use.
Confidential
Sterling Integrator Consultant
Responsibilities:
- Sterling SI trading partner setup, mapping, BPML
- Sterling WFoD & SCV project to onbroading new supplier for Sterling Web Forms
Confidential
SAP/Gentran Consultant
Responsibilities:
- Overview of SAP and EDI setups
- Overview of EDI mapping and Trading Partner setup
- SAP trading partner setup with WE20
- SAP port configuration with WE21
- EDPAR (Voe4) trading partner cross reference bill-to & shipto.
- We used the edpar to populate E1EDKA1/LIFNR is customer does not send SAP E1EDKA1/PARTN needed
- Setup & maintain EDPAR table
- SAP RFC setup for ALE with SM59 for TCP/IP & HTTP
- SD configuration for Customer Group, Division, Assigning Pricing procedure, defining shipping points & shipping conditions, maintain for company code, configure check for duplicate PO
- Configure and maintain Tax determination, setup & maintain output types
- Testing Sale order creation, Billing & Invoice, and shipping.
- Inbound & Outbound SAP IDOC testing for Sales Orders, Delivery, Order Response & Invoices.
- Schedule SAP programs “RBDAPP01” for “Inbound Processing of IDOCs Ready for Transfer” processing and added variants.
- SAP SD Production for Sales Order management and Invoicing.
- EDI to IDOC processing and IDOC to EDI processing for ORDERS, INVOIC & ORDERSP
- Working with Material management and availability.
Confidential
Gentran Consultant
Responsibilities:
- Provided training for 5 employee on Gentran Server for windows
- Upgrade to latest version on Gentran Windows with Oracle 10g database & Oracle application for back-end system.
- Imported trading partner profile, setup process control, mailboxes, Archive, CommScr, Maps, Forms and unattended
- Provided over of new version and functional
- Automated some manual processes
- Setup best practice for maintenance and everyday support
Confidential
GIS Consultant
Responsibilities:
- Migrating Gentran Server version 5.3 to GIS
- Trading partner configuration
- FTP & AS2 configuration
- Mapping for 180, 852, 820, 812 & 838
- Trading partner testing and processing to backend system Genesis
- Developed Bpml for all inbound, outbound, internal, & external processes.
- Develop change management document for go-live meeting weekly.
- Worked production support
- Developed custom email notification using XSLT
- Developed processes to handle notification for multi division of the company
- GIS Documentation and Mentor/training
Confidential
GIS Consultant
Responsibilities:
- GIS fast track setup ( initial inbound and outbound maps & BPML)
- Trading partner configuration
- BPML Development for inbound and outbound data flow using LWJDBC
- Developed 850 inbound, 855 outbound, DocExtract & Typing Service maps
- Setup customer JDBC properties file for external database connectivity
- Perform system maintenance
- GIS training & mentoring for US, Austria and Ireland employee
Confidential
GIS/SAP Consultant
Responsibilities:
- Trading partner configuration
- Developed BPML and mapping for connecting to XI Server
- Installed SAP JCo and configured SAP Adapter
- SAP trading partner setup with WE20
- SAP port configuration with WE21
- EDPAR (Voe4) trading partner cross reference bill-to & ship to. We used the edpar to populate E1EDKA1/LIFNR is customer does not send SAP E1EDKA1/PARTN needed
- Setup & maintain EDPAR table
- SAP RFC setup for ALE with SM59 for TCP/IP & HTTP
- SD configuration for Customer Group, Division, Assigning Pricing procedure, defining shipping points & shipping conditions, maintain for company code, configure check for duplicate PO
- Configure and maintain Tax determination, setup & maintain output types
- Testing Sale order creation, Billing & Invoice, and shipping.
- Inbound & Outbound SAP IDOC testing for Sales Orders, Delivery, Order Response & Invoices.
- Developed BPML with Lightweight JDBC adapter to validate Warranty Invoices and update MSQL database.
- Developed BPML with Lightweight JDBC adapter to validate Warranty Orders & Order Response and update MSQL database.
- Migrating trading partner from BizTalk to Windows GIS version 4.3
- Implementing 5 - 10 new trading Partner wit 850, 855, 810, 997 & 856
- Developed EDI to IDOC MRS and IDOC to EDI MRS
- Developed implementation guide to be used with all new & existing customers
- Created system design and infrastructure to migrate from Windows GIS 4.2 to UNIX HP GIS version 4.3
- Upgraded to Windows GIS version 4.3
- GIS performance tuning
- Configure server & client adapter for FTP, SFTP, HTTP communication
- Configured mailbox service, develop BPML to add file to mailbox, extract file from a mailbox.
- Develop BPML for LDAP adapter and configuration to extract external email address for warranty portal to send email for ORDRSP and Invoice acknowledgment.
- Managed trading partner relationship and setup for all new projects
- Project management and budget for four new projects with weekly status to manager & director.
Confidential
GIS/SAP Consultant
Responsibilities:
- Developed migration project plan to migrate from Gentran Mainframe to UNIX GIS version 4.1
- Trading partner configuration
- Mapping to support SAP IDOC formats for ORDERS, SHPMENT, INVOCI, DELVRY, PEXR2002
- SAP to X12 & X12 to SAP GAP analysis for 210, 810, 850 & 856
- Mapping to support X12 formats for 850/856/830/816/810/820/830/210/824 & ODBC Mapping
- BPML development
- XML and EDI flat file mapping
- IDOC interface with SAP and IDOC mapping
- Inbound & Outbound SAP IDOC testing for Sales Orders, Delivery, Order Response & Invoices.
- SAP Adapter configure, ALE Configure, AS2 connectivity, SMTP, Mime & Lightweight JDBC adapter
- SAP FI configuration for 810/820
- SAP EDI RFC port configuration
- SAP Output Determation for 856/810/855/850 to generate idoc’s
- SAP Partner Profile setup
- EDPAR (Voe4) trading partner cross reference bill-to & ship to. We used the edpar to populate E1EDKA1/LIFNR is customer does not send SAP E1EDKA1/PARTN needed
- Setup & maintain EDPAR table
- IDOC trouble shooting and reprocessing
- SD configuration for Customer Group, Division, Assigning Pricing procedure, defining shipping points & shipping conditions, maintain for company code, configure check for duplicate PO
- Configure and maintain Tax determination, setup & maintain output types
- Testing Sale order creation, Billing & Invoice, and shipping.
- IDOC testing for ORDERS, INVOIC, SHPMT05, PROACT01, and several customs Idoc’s.
- SAP configuration in the functional areas of SD (Order to Cash), MM and FI. SAP Configuration included the creation and updating of Scheduling Agreements, Orders, Materials, IDOCs, Partners, Partner Profiles, conversion) and all other EDI related tables.
- SAP configuration in the functional areas of SD (Order to Cash), and MM. SAP Configuration included the creation and updating of Orders, Materials, IDOCs, Partners, Partner Profiles, and all other EDI related tables
- SAP configuration in the functional areas of SD (Order to Cash), MM and FI. SAP Configuration included the creation and updating of Scheduling Agreements, Orders, Materials, IDOCs, Partners, Partner Profiles, conversion) and all other EDI related tables.
- Customer credit card billing processes, SAP IDOCs to support EDI 810/820 interfaces with LaSalle.
- Testing: Prepared and performed unit/system testing on all EDI transactions for both inbound and outbound translations. Outbound testing involved generation of correct translation through Gentran map, and the review and comparison of the generated EDI stream with the original IDoc. Likewise, testing of inbound EDI stream involved verification of correct Gentran map translation to IDoc and posting into the SAP R/3 system.
Confidential
GIS Consultant
Responsibilities:
- GIS Windows install and configuration
- Trading partner configuration
- Mapping to support X12 formats for 850/997/810/855/812/816 Mapping
- BPML development
- XML and EDI flat file mapping
- Oracle Apps data definition development for GIS AI Mapper
- Configuring Oracle E-Business Adapter.
- Configure server & client adapter for FTP communication
- Managed 2 off-site consultant with migration for Inovis to GIS
Confidential
GIS/SAP Consultant
Responsibilities:
- Developed project plan for migrating from Trinary EDI software to Windows GIS version 4.1
- Trading partner configuration
- Mapping to support SAP IDOC formats for ORDERS, SHPMENT, INVOCI, DELVRY, PEXR2002
- Mapping to support X12 formats for 850/856/830/816/810/820/830/210/824 & ODBC Mapping
- BPML development
- XML and EDI flat file mapping
- SAP Adapter configure, ALE Configure, AS2 connectivity, SMTP, Mime & Lightweight JDBC adapter
- SAP FI configuration for 810/820
- SAP EDI RFC port configuration
- SD configuration for Customer Group, Division, Assigning Pricing procedure, defining shipping points & shipping conditions, maintain for company code, configure check for duplicate PO
- Configure and maintain Tax determination, setup & maintain output types
- Testing Sale order creation, Billing & Invoice, and shipping.
- Customized EDI enveloping and de-enveloping processes for error handling
- Designed detailed error collection and formatting XSLT for notification.
- GIS Training for Client
- GIS documentation, system design and infrastructure
- Project leader for team of 5
- IDOC interface with SAP and IDOC mapping
- SAP configuration in the functional areas of SD (Order to Cash), MM and FI. SAP Configuration included the creation and updating of Scheduling Agreements, Orders, Materials, IDOCs, Partners, Partner Profiles, conversion) and all other EDI related tables.
- Testing: Prepared and performed unit/system testing on all EDI transactions for both inbound and outbound translations. Outbound testing involved generation of correct translation through Gentran map, and the review and comparison of the generated EDI stream with the original IDoc. Likewise, testing of inbound EDI stream involved verification of correct Gentran map translation to IDoc and posting into the SAP R/3 system.
Confidential
Sterling GIS/SAP Consultant
Responsibilities:
- Mapping specification for SAP IDOC formats ORDERS, SHPMENT, INVOCI, DELVRY03, DELVRY01, PROACT01, PEXR2002
- Mapping specification for X12 formats for 850/856/830/816/810/820/830/210/824
- SAP to X12 & X12 to SAP GAP analysis
- IDOC interface with SAP and IDOC mapping SAP configuration in the functional areas of SD (Order to Cash), MM and FI. SAP Configuration included the creation and updating of Scheduling Agreements, Orders, Materials, IDOCs, Partners, Partner Profiles, conversion) and all other EDI related tables.
- SD configuration for Customer Group, Division, Assigning Pricing procedure, defining shipping points & shipping conditions, maintain for company code, configure check for duplicate PO
- Configure and maintain Tax determination, setup & maintain output types
- Testing Sale order creation, Billing & Invoice, and shipping.
- Wrote FTP script for Window Batch processing
Confidential
GIS/SAP Consultant
Responsibilities:
- Trading partner configuration
- Mapping to support SAP 856, 810, 850, 855, 860 IDOC formats
- BPML development
- XML and EDI flat file mapping
- Project leader for 6 consultant
- GAP analysis for new customer using 214, 980, 204, 940, 944, 945 & 957
- IDOC interface with SAP and IDOC mapping
Confidential
Sterling GIS/SAP Consultant
Responsibilities:
- Migrating EDI from St. Paul software to Sterling Integration Suite GIS version 4.1
- Trading partner configuration
- Mapping to support SAP IDOC formats for 850/856/810/820/830/210/824
- SAP FI port configuration for 810/210/820
- SAP Adapter configure, ALE Configure, AS2 connectivity, SMTP, Mime & Lightweight JDBC adapter
- Migrating VAN from async to FTP.
- Configure server & client adapter for FTP, SFTP, HTTP communication
- Documentation and Training.
- BPML development
- Configured mailbox service, develop BPML to add file to mailbox, extract file from a mailbox.
- Installed and configured PGP software
- Customized EDI enveloping and de-enveloping processes for error handling
- Designed detailed error collection and formatting XSLT for notification.
- IDOC interface with SAP and IDOC mapping
- SAP configuration in the functional areas of SD (Order to Cash), MM and FI. SAP Configuration included the creation and updating of Scheduling Agreements, Orders, Materials, IDOCs, Partners, Partner Profiles, conversion) and all other EDI related tables.
- SD configuration for Customer Group, Division, Assigning Pricing procedure, defining shipping points & shipping conditions, maintain for company code, configure check for duplicate PO
- Configure and maintain Tax determination, setup & maintain output types
- Testing Sale order creation, Billing & Invoice, and shipping.
- Customer credit card billing processes, SAP IDOCs to support EDI 810/820 interfaces with Comerica & Northern Trust Bank
- Testing: Prepared and performed unit/system testing on all EDI transactions for both inbound and outbound translations. Outbound testing involved generation of correct translation through Gentran map, and the review and comparison of the generated EDI stream with the original IDoc. Likewise, testing of inbound EDI stream involved verification of correct Gentran map translation to IDoc and posting into the SAP R/3 system.
- Project for team of 3
