Senior VBA Developer with .Net and SQL Skills

Senior-KDNI

Roles & responsibilities

•Developing robust, modular code utilizing procedures and functions. •Advanced application of Excel formulas, including dynamic arrays and LAMBDA functions. •Integration with external data sources such as SharePoint lists and SQL databases. •Experience working with Power Query •Expertise in the Excel Object Model •Comprehensive knowledge of key objects: Application, Workbooks, Worksheets, Range, and others. •Skilled use of ActiveX and Form controls. •Event handling at both workbook and worksheet levels. •Practical experience designing and developing VBA solutions interacting with COM objects. Error Handling and Debugging •Mastery of various error handling methodologies. •Performance and Memory Optimization •In-depth understanding of effective memory management. 

Strong ability to evaluate and optimize existing VBA logic for performance improvements.

•End-to-end Software development leveraging Azure Dev Ops •Sound understanding of Agile principles and development life cycle activities. •Business and Analytical Skills / Ability to understand the Tax domain (This is not a must, but the candidate should be able to understand complex logic) 

Ability to understand complex business logic and building data models that reflect business rules. 

Roles & responsibilities

•Developing robust, modular code utilizing procedures and functions. •Advanced application of Excel formulas, including dynamic arrays and LAMBDA functions. •Integration with external data sources such as SharePoint lists and SQL databases. •Experience working with Power Query •Expertise in the Excel Object Model •Comprehensive knowledge of key objects: Application, Workbooks, Worksheets, Range, and others. •Skilled use of ActiveX and Form controls. •Event handling at both workbook and worksheet levels. •Practical experience designing and developing VBA solutions interacting with COM objects. Error Handling and Debugging •Mastery of various error handling methodologies. •Performance and Memory Optimization •In-depth understanding of effective memory management. 

Strong ability to evaluate and optimize existing VBA logic for performance improvements.

•End-to-end Software development leveraging Azure Dev Ops •Sound understanding of Agile principles and development life cycle activities. •Business and Analytical Skills / Ability to understand the Tax domain (This is not a must, but the candidate should be able to understand complex logic) 

Ability to understand complex business logic and building data models that reflect business rules. 

Educational qualifications

•B.Tech or Equivalent

Work experience

•5 – 8 YOE

Mandatory  technical & functional skills

•.Net, SQL and Excel VBA

Preferred technical &
functional skills

•Experience with using APIs and JSON. •Experience with scripting programming languages such as Python or PowerShell, etc. 

Experience Level

Senior Level