VB/VBA Developer

• 2+ years of software development in VBA (Visual Basic Application) Visual Basic (VB) and Microsoft Excel/ Macros.
• Skills: Degree/ Diploma Holders with 2-3 Years Experience in VB/VBA Development.

VBA Development:

• Design, develop, and maintain VBA macros and scripts to automate tasks and processes within Excel.
  Create custom functions and procedures to enhance Excel functionality.

Excel Automation:

• Build automation solutions to streamline data processing, analysis, and reporting tasks.
  Implement Excel-based workflows to improve efficiency and reduce manual efforts.

Data Manipulation and Analysis:

• Manipulate and analyze data within Excel using VBA for tasks such as cleansing, transformation, and validation.
  Develop tools for data import/export and integration with external systems.

User Interface (UI) Design:

• Design user-friendly interfaces within Excel for data input, manipulation, and reporting.
  Ensure a positive user experience through effective UI design.

Integration with External Systems:

• Integrate Excel applications with external databases, APIs, and other data sources.
  Develop solutions for data synchronization and real-time updates.

Error Handling and Debugging:

• Implement robust error handling mechanisms in VBA code.
  Debug and troubleshoot issues to ensure the reliability of Excel applications.

Documentation:

• Create comprehensive documentation for VBA code, including comments and usage guidelines.
  Document Excel applications, workflows, and data structures.

Collaboration:

• Collaborate with business users and stakeholders to understand requirements and gather feedback.
  Work closely with other developers and IT teams to integrate Excel solutions with broader systems.