VBA Programmer Resume

Visual Basic for Applications (VBA) Programmers provide support in the development of business applications or solutions and database systems by designing, testing, and debugging efficient VBA codes. They program and control different functions in MS applications such as Excel, Access or Word as well as develop training materials and technical guides for end-users and technical team. These programming experts have a bachelor's and master's degree in computer science, information technology or related fields. If you are looking for a job in this field, you will need a comprehensive resume to highlight your exceptional programming skills and experience and make you stand out from the competition. It must showcase your expertise in VBA programming, developing, and implementing MS Office based custom applications, Excel and Access coding, SQL database and user interface designs, code debugging and optimization, unit and integration testing, application code and design reviews, requirement gathering and analysis, end-user support, software documentation and SQL reporting, maintaining and modifying information systems. To increase your chances of getting an interview call, also include strong communication, analytical, time-management, leadership, team-working, multi-tasking, problem-solving and decision-making skills.

VBA Programmer Resume Example

---

Jeanie H. Williams
1723 North Avenue
Chicago, IL 60005
Phone No: 312-547-6743
Email: jeaniewilliams@anymail.com

Career Summary:

Highly-dedicated, enthusiastic, and professional VBA Programmer with more than 6 years of experience in analyzing user or business requirements as well as developing, testing, debugging, and modifying VBA programs. Expertise in developing business applications, user interfaces, and SQL databases as well as creating, controlling, and implementing various functionalities in MS Office products. Possess excellent communication, analytical, troubleshooting, project management, and team-working skills.

Summary of Skills:

• Thorough knowledge of VBA programming, Excel, and Access coding, SDLC, SQL queries and databases, user interface designs, OOPS concepts and ODBC connection, requirement analysis, system development and enhancements, Excel based macros and user forms, software testing and debugging, application troubleshooting, and modification techniques, code optimization and software documentation, project-management
• Working knowledge of Visual Basic 6, VBA, SQL Server and My SQL, Access and Oracle databases, MS Office Suite applications, Visual Studio IDE, HTML, XML, CSS and Crystal Reports
• Excellent analytical skills with the ability to develop technical specifications and write efficient and reliable VBA code
• Exceptional problem-solving skills with the ability to complete projects within specified deadlines
• Strong report-writing and documentation skills with the ability to develop effective user manuals and developers' guides
• Excellent multi-tasking and organizational skills with the ability to cope in a fast-paced and challenging work environment
• Solid leadership and mentoring skills as well as the ability to work well independently and in a cross-functional team
• Effective communication and presentation skills with the ability to maintain effective relations with clients, management and technical staff

Work Experience:

VBA Programmer
Intertask Technologies, Chicago, IL
February 2018 – Present

• Providing support to the development and technical project teams in the analysis of user or business requirements as well as in the designing and development of Microsoft based business applications and database and establishing back-end connectivity using VBA and SQL programming
• Designing, testing, debugging and executing reliable and efficient VBA code for developing business solutions or assigned application projects as well as controlling functionalities in Excel, Access, Word and Power-point as per established programming standards
• Writing and maintaining developers' design documents or guides and functional specifications as required as well as creating and modifying systems in Excel using VBA as per business or client needs
• Working collaboratively with developers, analysts, and QA personnel in creating and executing user acceptance, unit and integration testing plans and scripts as well as troubleshooting, maintaining, and enhancing macros, excel spreadsheets, access databases and related MS applications
• Leading and providing guidance to technical or project team on application integration and implementation queries as well as performing code and design reviews for junior programmers or developers as required
• Collaborating with project lead and senior management personnel to develop cost and time estimates for application or software projects as well as providing technical support and training manuals related to application usage and maintenance for end-users

VBA Programmer
Broad-ridge Tech Group, Chicago, IL
April 2016 - January 2018

• Worked collaboratively with the technical team in building prototypes and developing, enhancing and maintaining MS Office based custom applications as well as providing support in both back-end and front-end development procedures using VBA and SQL programming
• Analyzed and translated user or business requirements into technical specifications that included logic diagrams, flowcharts, algorithms, and program logics
• Suggested and implemented necessary architecture and code enhancements as per business needs or design specifications as well as prepared and maintained functional and technical requirements documentation, user manuals and technical guides as required
• Performed testing, debugging or troubleshooting functions for VBA programs and related applications as well as managed change requests from end-users or clients and ensured release of new functionalities in existing programs as required
• Created and maintained user-defined functions, user-friendly interfaces, and database designs in Excel, Word and Access applications as required as well as participated in code reviews to ensure compliance with best programming practices and established standards
• Actively responded to clients' requests and provided regular status updates regarding application projects as well as utilized Excel and other MS Office application functions for database development and integration

Junior VBA Programmer
Next-Gen Technologies, Chicago, IL
December 2013 - March 2016

• Assisted senior programmers in designing and executing VBA and SQL programs to control and implement functionalities for various MS products such as created user forms and updated Excel spreadsheets, external data queries or program modules in access databases
• Assisted in developing Access databases, user interfaces, and Excel forms as required as well as performed unit testing, debugging, optimization and documentation functions for new and existing VBA code as per established programming standards and user requirements
• Created macros, link-based modules, and various procedures for Excel updates, data conversion, import and export processes as well as worked with subject matter experts in designing technical guides for developers and training manuals or FAQ's for end-users as required
• Collaborated with clients to identify their needs or requirements and develop design specifications as well as assisted senior programmers, developers and QA personnel in analyzing and troubleshooting coding and related application issues as required
• Assisted in developing and enhancing various database systems, software or programming components as well as ensured high level accuracy, quality and security of spreadsheets or SQL reports developed

Education:

• Master's Degree in Computer Science
  De Paul University, Chicago, IL, USA
  2013
  

• Bachelor's Degree in Computer Science
  Roosevelt University, Chicago, IL, USA
  2011

Reference:

On request.