VBA Developer
About The Position
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.
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.
Nice To Haves
- 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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
Number of Employees
5,001-10,000 employees
