Apply on Employer Site

NTT DATA · 11 hours ago

VBA Developer - SAP Ariba Expertise Required

United States

Full-time

Remote

Senior Level

$34.39/hr - $71.64/hr

7+ years exp

NTT DATA is a recognized leader in IT and business services, and they are seeking a VBA Developer to automate the extraction and insertion of batch and serial characteristics into ASN files before they are uploaded to SAP/Ariba. The role involves developing tools for data automation, ensuring data accuracy, and optimizing processes across multiple systems.

Application Performance ManagementCloud ManagementEnterprise SoftwareInformation Technology

No H1B

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

Qualification

VBASAPSAP AribaData ManagementSQL/DatabaseCXMLEDIPower Automate

Required

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