VBA Developer

Reporting to : - Manager - Automation

Main Objectives of this position : -

• To design, develop, and implement intelligent automation solutions using VBA and Blue Prism, enhancing operational efficiency and accuracy across business processes. This role aims to leverage strong programming skills to deliver scalable, maintainable, and high-quality automation systems that support continuous improvement within the organization.

Function and duties : -

Main Tasks : -

• Analyze business processes to identify automation opportunities.
• Design and develop Automation solutions using Blue Prism and VBA
• Participate in the full software development life cycle, including requirements gathering, design, development, testing, and implementationReview artifacts that are subject to quality checks e.g.PDDs, SDDs, Robot code etc.
• Advise on and, if needed, review other documentation: complexity scoring and value assessment, UAT test strategy, Go-Live Document, Operations Handbook, Process Handover Document
• Advise internal team on the overall Macro / RPA best practices,
• Participating in solution design against business requirements.
• Analyse business requirements for developing functional and non-functional system requirements.
• Performing Proof of Concepts for feasibility analysis for the proposed automated solution.
• Working with the Business Process Teams during the UAT and roll-out
• Ability to provide quick resolution for issues after go-live
• Develop upgrades for existing applications
• Taking accountability of automation projects
• Drive efficiencies through completed projects

Qualification and technical job requirements : -

• BE/B-tech, Bachelor's degree in CS, IT etc.
• Knowledge of Software Development Life Cycle (SDLC)
• Excellent working knowledge in Microsoft office tools specifically Outlook, Excel Macro, MS Access, and other general office applications.
• Excellent communication skills.
• Stakeholder Management skills.
• Create reports and dashboards for analysis.

Technical Skills : -

• VBA Development: Proficiency in Visual Basic for Applications (VBA) programming language to create macros, automate tasks, and develop custom solutions within Microsoft Office applications (Excel, Word, Access, etc.).
• Blue Prism Automation: In-depth knowledge of the Blue Prism platform, its components, and methodologies to design, develop, and deploy robotic process automation (RPA) solutions.
• Process Automation: Strong understanding of business processes and the ability to analyze, optimize, and automate them using VBA and Blue Prism, identifying areas for improvement and efficiency gains.
• Programming Languages: good to have programming skills, not limited to VBA, but also including knowledge of other languages like C#, Python, or Java, depending on the requirements of the automation projects.
• Testing and Debugging: Proficiency in testing and debugging VBA macros and Blue Prism processes to ensure quality and reliability of the automation solutions.
• Process Documentation: Skill in documenting VBA scripts and Blue Prism processes comprehensively, including process flowcharts, logic, and configurations.

Behavioral Skills : -

• Problem-Solving: Excellent problem-solving skills to identify automation opportunities, troubleshoot issues, and implement effective solutions in both VBA and Blue Prism environments.
• Communication: Strong communication skills to collaborate with business stakeholders, gather requirements, and effectively convey technical concepts to non-technical team members.
• Continuous Learning: Being proactive in keeping up-to-date with the latest developments in VBA, Blue Prism, and the broader RPA industry to incorporate best practices and emerging technologies into automation projects.

Job Requirements:

• Strong technical skills in VBA with the ability to understand business requirements and automate processes effectively
• Excellent communication skills for stakeholder management
• Proven stability and consistency in past work experience