NTT DATA's Client is seeking to eliminate manual touchpoints in their 'Pull PO' workflow by automating the extraction and insertion of batch and serial characteristics into Expandable-generated ASN files before they are uploaded to SAP/Ariba.
Requirements
- 7 years' experience with VBA: Advanced proficiency in Excel VBA, including FileSystemObject (FSO) for handling downloaded ASN files and XML/CSV manipulation.
- 5 years experience working with SAP (GUI Scripting or BAPIs) and Expandable or similar manufacturing ERPs.
- 3 years experience working with SAP Ariba upload templates and ASN requirements for supply chain collaboration.
- 5 years experience with Data Management: Strong understanding of batch management and serial number tracking within a logistics or manufacturing environment.
- 5 years experience with SQL/Database: Ability to query backend databases to retrieve characteristic values that may not be present in the initial ASN export.
- Experience with SAP Ariba APIs or Power Automate for handling cloud-to-desktop file transfers.
- Knowledge of cXML or EDI formats often used in ASN transmissions.
Responsibilities
- ASN Data Automation: Develop a VBA-based tool to automatically intercept downloaded ASN files from Expandable and inject required serial/batch characteristics based on SAP-generated PO data.
- Multi-System Integration: Create scripts that interface with SAP, Expandable, and Ariba to ensure seamless data flow for serial-tracked items.
- Data Validation: Build logic to verify that batch numbers and serial characteristics in the ASN match the original SAP Purchase Order and Expandable Sales Order before final upload.
- Process Optimization: Transition the current 5-step manual process (Generating PO Expandable SO ASN Download Manual Update Ariba Load) into a streamlined, automated workflow.
- Error Handling: Implement robust error-trapping to flag discrepancies in batch characteristics or missing serial numbers during the file-update phase.
Other
- NO STEM OPT
- The position is REMOTE for 3 months
- Degree requirements not specified, but the company is an equal opportunity employer
- Company benefits may include medical, dental, and vision insurance, flexible spending or health savings account, life, and AD&D insurance, short-and long-term disability coverage, paid time off, employee assistance, participation in a 401k program with company match
- Must inform recruiter of any disability to receive assistance or accommodation
