Lead Developer-Process Automations-Vba Macros

Purpose of Role

• Own and be accountable for smooth and effective delivery of tactical process transformation automation solutions as per book of work.
• Ensure the timely delivery and accuracy of planned automation solutions.
• Ensure the right capabilities & certifications are in place for smooth automation delivery.
• Adherence to processes and compliance requirements for all automation solutions.   

Top Accountabilities

• Hands on and excellent knowledge of macros built in Visual Basic for Application scripting language in excel.
• Built VBA based standalone application and excel macros with the ability to fluently read macro code and revere engineer macro code, wrt code debug, code maintenance and execution for around 4 years, with an objective of designing and delivering improved macro-based automations.
• Clear understanding of Python with hands-on experience in python solutions in desktop or cloud environment.
• Chip in as key member of Automation Centre of Excellence (COE) to design, deploy custom automation solutions in VBA macros, by interpreting excel macros and detailing to help in crafting executable python code.
• Individual contributor developing solutions in agreement with the enterprise architecture, using the approved technology stack (Python, VBA macros etc).
• Adhere to the existing policy guidelines with respect to software development, deployment, change management.
• Version control code through tools in Repos to promote maintenance and re-usage.
• Understanding of Agile Software development methodology is desirable.
• Experience of having successfully engaged, motivated, and influenced a variety of collaborators in multiple geographies and cultures is desirable.

Qualifications and Technical Experience Required

• Min 4 to 7 years of autonomous design development (VBA & Python developer) and deployment of custom software and solution in a Technology organization within shared service delivery environment, of which min 5 years for VBA developers, remaining 1 to 2 years should be in Python ( is possible)
• “Bachelor’s Degree,” in Engineering, Science, Statistic, Mathematics, Commerce or equivalent with minimum 75% marks in Graduation.
• Good Experience in building up a new automation solution with below stack is required.
• Language : Basis hands on with VBA, Excel Macros, Agile is Macro interpretation
• Python Libraries: Basis hands on with NumPy, Pandas, PyMongo, Open CV, Pillow etc.
• Framework: Basis hands on with Flask, REST APIs.
• Database (not mandatory but desirable): Basis hands on with PostgreSQL (SQL), Cosmos DB (No SQL).
• Cloud Architecture (not mandatory but desirable): Basis hands-on with Azure Fundamentals