VBA Developer – Job Description

Role Purpose

The Advanced VBA Developer drives enterprise automation transformation by building scalable Excel-based solutions integrated with core systems (SAP, APIs, SQL, Outlook, Share Point). This role delivers measurable cost optimization (FTE reduction), SLA improvement, and audit-compliant automation ecosystems.

Business Impact

• Deliver quantifiable FTE savings through automation

• Improve process turnaround time (30–60%) and accuracy (≥95%)

• Enable scalable, reusable automation frameworks

• Strengthen audit compliance and risk controls

• Reduce manual effort and operational dependency

Core Responsibilities

• Lead end-to-end automation lifecycle: requirement → design → build → deploy → support

• Own and enhance Process Design Documents (PDDs) ensuring complete coverage of:

o Business rules, exceptions, and decision logic

o Compliance and audit requirements

• Drive delivery within an Agile framework:

o Sprint planning, backlog grooming, and daily stand-ups

o Accurate estimation and on-time delivery of user stories





• Ensure proactive stakeholder communication:

o Provide regular status updates, risks, and mitigation plans

o Escalate blockers early and drive resolution

• Maintain strict timeline accountability:

o Deliver all automation within defined SLAs

o Ensure on-time closure with zero spillover

• Engineer high-performance VBA solutions with modular, reusable design

• Integrate Excel with enterprise systems:

o APIs (REST/SOAP), SAP, SQL databases

o Outlook workflows and Share Point ecosystems

• Embed:

o Audit trails, validations, exception handling o Secure and compliant automation controls

• Drive process re-engineering, not just automation

• Ensure production stability, RCA, and continuous improvement

Technical Excellence

• Advanced VBA (modular coding, classes, performance optimization)

• Excel advanced stack (Power Query, Power Pivot, data models)

• System integration (API, SAP GUI, SQL v

📌 Vba Macro Developer (Chennai)
🏢 Renowned Shipping MNC
📍 Chennai