VBA Developer at NTT DATA
Portage, Michigan, United States -
Full Time


Start Date

Immediate

Expiry Date

24 Apr, 26

Salary

0.0

Posted On

24 Jan, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

No

Skills

VBA, Excel, SAP, Expandable, Ariba, Data Management, SQL, Database, FileSystemObject, XML, CSV, cXML, EDI, APIs, Power Automate, Batch Management, Serial Number Tracking

Industry

IT Services and IT Consulting

Description
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. 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
Develop a VBA-based tool for automating ASN file processing and create scripts for multi-system integration. Build logic for data validation and optimize the current manual process into an automated workflow.
Loading...