Vba Developer

Role: VBA-MIS Developer

Location: Pune,Nagpur,Kolkata

Experience: 4-8 Years

Skillset:

MS Access

VBA

SQL

Macros

UI Developement

RDBMS concept, SQL script, stored procedure, functions, trigger, UDFs

Responsibilities:

• Develop, enhance, and maintain multi-user VBA applications in Excel, MS Access, and SQL Server.
• Develop custom user forms, scripts, libraries and functions for Microsoft Office applications.
• Use VBA to transform data from multiple sources while ensuring accuracy and consistency.
• Document VBA code and procedures to support knowledge sharing and future reference.
• Provide ongoing support and maintenance for existing solutions.
• Train end users on newly developed and existing applications.
• Ensure applications comply with company policies and standards.
• Understand and follow SDLC Software development life Cycle
• Proficient in SQL and RDBMS concepts
• Manage various databases in MS Access, MS SQL Server
• SQL Server– Create tables, Query, Joins, view, Trigger, UDFs, Stored procedures etc.
• Engage with clients, end users, and senior management to gather requirements and identify automation opportunities.
• Ability to present data and information through BI tools.
• Ability to work to tight deadlines
• Methodical and logical thinker with data analysis and problem resolution skills
• Excellent written and verbal communication skills. Able to communicate effectively at all levels and have the confidence to challenge when necessary.