VBA Developer - SAP Ariba Expertise Required jobs in United States
info-icon
This job has closed.
company-logo

NTT DATA North America · 2 weeks ago

VBA Developer - SAP Ariba Expertise Required

NTT DATA North America is a leader in IT and business services, and they are seeking a VBA Developer to automate processes related to SAP and Expandable systems. The role involves developing tools for data automation, ensuring data accuracy, and optimizing workflows to enhance operational efficiency.

ConsultingDigital MarketingInformation ServicesInformation TechnologyIT Management
badNo H1Bnote

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 ManagementSQLProcess OptimizationError HandlingMulti-System IntegrationCXMLEDI

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

Preferred

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

Benefits

Medical
Dental
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
Additional voluntary or legally required benefits

Company

NTT DATA North America

company-logo
NTT DATA, Inc. is a trusted global innovator of business and technology services.