VBA Developer

• The VBA Developer will be responsible for developing, maintaining, and optimizing MS Office-based automation tools using VBA, VSTO, and .
• The role involves building and enhancing Office Add-ins, templates, and macros to support global tax and legal service delivery teams, ensuring consistency, quality, and efficiency across business processes.

Experience:

• Experience developing tools using MS Office VBA and VSTO (Visual Studio Tools for Office).
• Experience in building and maintaining Office Add-ins, templates, and automation solutions.
• Experience writing complex VBA macros and developing user forms, modules, and class modules.
• Experience integrating MS Office applications such as Outlook, Word, Excel, and PowerPoint using macros.
• Experience in application development using and WinForms.
• Experience with tool development lifecycle, testing, and deployment processes.

Responsibilities:

• Develop, deploy, and maintain VSTO Add-ins for MS Office applications using VBA, , and VSTO.
• Create VSTO templates, workbooks, and documents for Excel and Word to extend functionality.
• Maintain and upgrade existing tools, add-ins, and templates.
• Develop complex VBA macros to support business functionality.
• Build user forms, modules, and class modules for automation solutions.
• Integrate different MS Office applications using macros and automation techniques.
• Test, deploy, and deliver high-quality tools and solutions.
• Support tool development, maintenance, and optimization activities.
• Ensure adherence to development guidelines, standards, and compliance requirements.
• Maintain documentation to support governance and tool lifecycle processes.
• Follow SDLC processes and ensure quality in all deliverables.

Should Have:

• Strong understanding of SDLC, quality, and testing processes.
• Strong problem-solving and analytical skills.
• Ability to standardize and innovate automation solutions.
• Strong attention to detail and adherence to coding standards.
• Ability to work in a global delivery environment.

Skills:

• Microsoft Office Suite (Excel, Word, Outlook, PowerPoint).
• VBA programming and complex macro development.
• and .NET framework fundamentals.
• VSTO (Visual Studio Tools for Office).
• WinForms application development.
• Object-Oriented Programming (OOPs).
• Data structures and algorithms.
• Python (preferred).
• Power Apps (preferred).
• SharePoint concepts (preferred).

Qualification And Education:

• MCA, Engineering, or B.Sc. in Computer Science or related field.