A VBA Developer is responsible for developing and implementing Excel VBA applications. Common roles and responsibilities relating to the role are listed on the VBA Developer Resume as – building VB prototypes and small scale applications, developing and maintaining MS Office applications, handling both frontend and backend development procedures, developing and implementing new systems, ensuring the configuration is properly handled, using development best practices, and appropriate patterns to develop required software solutions, creating SQL Server views, stored procedures, and queries, and maintaining technical documentation including user manuals.
To be considered for this role, one must have advanced Excel skills and possess knowledge of reference and lookup, array formulas, and custom functions. As this work is highly technical, it is imperative for candidates working in this role to embrace experience in programming and be skillful in applicable programming languages. Exceptional knowledge of designing a tactical application, using standard best practices and procedures are also needed. Most of these developers have a degree in computer science.
Summary : To obtain employment with a well-established company that can provide me the opportunity to utilize my skills to grow with the organization. Abilities I am very adaptable to almost any business environment and quick to learn new systems, processes, and procedures.
Skills : VBA, Ms Access, Ms Excel, Sharepoint, HTML 5, CSS, Javascript, C#.
Description :
Designed custom VBA applications to assist and streamline current operations.
Worked with multiple departments to find more efficient processes and procedures.
Designed Excel spreadsheets to compile and compare large sets of data.
Designed and implemented new tools and systems to improve department specific processes.
Fulfilled a lead role within my team and established structure and standards by which to operate by.
Involved in the recruitment and training process of team members who started with little to no experience and were operational within a couple months and independent within six months.
Established structure and standards for myself and my team to operate by.
Experience
7-10 Years
Level
Management
Education
High School Diploma
VBA Developer Resume
Summary : Over 30+ years bridging people and technology, since just before the release of Lotus 123. Delivering complex data in simple, digestible presentation. Constructing procedures and systems that automate data flow, manipulation and integrity. Teaching people to use, understand and be comfortable with the technology available to them.
Skills : SQL (8 years), SSRS (8 years), AIF.
Description :
Developed cash flow reporting tool for the HR Executive Compensation Department to assist with Troubled Asset Relief Program (TARP) reporting requirements.
Tools generated highly confidential cash flow
Developed improved reporting processes for Basel III Regulations.
Met with analysts and managers to gather the requirements pertaining to their request.
Played an active role in the quarterly closing process.
Created entity lists, account lists, loading/consolidating data and maintaining security groups.
Included providing user support, if needed, for Hyperion retrieve reports.
Experience
10+ Years
Level
Senior
Education
Bachelor's In Accounting
VBA Developer Resume
Headline : Six years in development for university research, finance, and healthcare. I also used VBA in support of non-VBA positions. With personal projects, I have developed in VBA during the past 17 years. C++ Developer: Four years in development for home media research, education, and marketing cross-tabulation.
Skills : MS Excel, MS Access, Developing Skills.
Description :
Developed an Excel VBA program called Charges Attachment Generator.
Provided functionality to create any of several financial charges tables (without templates) and to populate the tables.
Generated sophisticated Excel formulas that calculated labor rates and total cost.
Used forms to query for initial data to control table generation and used Excel validation to maintain accuracy.
Modified its own code on-the-fly to provide event handling for the tables.
Generated a dynamic, printable report summarising data from all of the tables.
Centralised control data in a single spreadsheet allowing AmEx employees to set it before distribution to vendors.
Experience
5-7 Years
Level
Executive
Education
Bachelor Of Science
VBA Developer Resume
Summary : Over 17 years of experience in Application design, analysis, testing and production support. Designed SQL Server / Access database for storage and retrieval of real-time sensor data. Strong finance & accounting knowledge and experience. Extensive experienced working with large Corporations in Agile and Waterfall environments.
Skills : Planning, Data Analyst, Waterfall Environment.
Description :
Designed Dashboard in Access and excel.
Designed an optimal one-to-many relationship layout of tables in Access.
Created tables, Link tables, Views, Forms and Reports in Access from scratch.
Developed macros to upload, export data automatically & periodically.
Developed user friendly screens for capturing data.
Created relationship between tables and queries in MS Access.
Developed macros to fetch data from different data sources.
Experience
10+ Years
Level
Senior
Education
Master's In Commerce
VBA Developer Resume
Objective : VBA Developer is Providing additional support with NATOP (Naval Training and Operating Procedures Standardization Program) and NATIP (Navy Technical Information Program) product developers on folders for need date changes to chapters quarterly. Assist NATOP/NATIP product developers connecting them to the subject matter experts to ensure folder’s deadlines.
Skills : VBA, SQL, Access, Excel, T-Sql.
Description :
Created and maintained advanced ETL processes for easy data flow to various systems.
Monitored automated SSIS (ETL) and other system processes for success and failures.
Assisted with logical and physical data modeling to support business initiatives.
Utilised SQL to wrangle and report on large volumes of data.
Collaborated with end users to identify needs and opportunities for improved data management and delivery.
Developed, automated and ran user-friendly dashboards and reports using tools like Excel, VBA, Power BI and Tableau.
Created and enhanced Microsoft Tabular (and PowerPivot) models to aid reporting requirements.
Experience
2-5 Years
Level
Executive
Education
MS
VBA Developer Resume
Summary : Over 17 years of experience in Application design, analysis, testing and production support. Designed SQL Server / Access database for storage and retrieval of real-time sensor data. Strong finance & accounting knowledge and experience. Extensive experience working with large Corporations in Agile and Waterfall environments.
Skills : Planning, Data Analyst, Waterfall Environment.
Description :
Designed Dashboard in Access and excel.
Designed an optimal one-to-many relationship layout of tables in Access.
Created tables, Link tables, Views, Forms and Reports in Access from scratch.
Developed macros to upload, export data automatically & periodically.
Developed user friendly screens for capturing data.
Created relationship between tables and queries in MS Access.
Developed macros to fetch data from different data sources.
Experience
10+ Years
Level
Senior
Education
Master's In Commerce
VBA Developer Resume
Objective : VBA Developer is Working across departments, Masco Business Units, and with other external customers to deliver value from Masco Support Services’ investment in database and other systems, Delivering end-to-end reporting solutions including requirements gathering, data sourcing, data cleansing, data normalization and reporting.
Worked for a Healthcare provider assisted the Informatics Department of the IT group with custom VBA written Excel Reports.
Had to create individual reports based on each time group, add & format new sheets in the workbook and plot new graphs from the dataset.
Developed VB application to export data from SQL Server to Access.
Created tables, Views, Forms and Reports in Access.
Implemented conditional formatting in access reports.
Automated the refreshment of the pivot tables of the reports in a specified directory (the number of report workbooks.
Instituted moderate security protocols and generated HTML help files.
Experience
2-5 Years
Level
Executive
Education
MS
VBA Developer Resume
Headline : A challenging VBA Developer position with a progressive organization that provides opportunities to utilize my extensive experience in VBA, MS Access, Excel, PowerPoint, SQL Server 2008 and C#, Plan and conduct testing on all e-RP system user account interface, utility tool, and user activity tool updates and modifications to ensure system integrity
Skills : MS Access, VBA, Sql Server, Developing.
Description :
Used this system as the topic of my undergraduate honors thesis and my senior capstone project.
Transformed that data into Excel worksheets.
Loaded the Excel data into MS Access database Tables.
Created MS Access Forms, Query and Reports to display this data in meaningful ways to Deloitte and the CDC.
Basically managed the project myself.
Created two MS Access database; one for DPIP Awardee data and one for EHDI Awardee data.
Supported and enhanced a complex reporting ecosystem in Excel.
Experience
5-7 Years
Level
Executive
Education
MS
VBA Developer Resume
Objective : Highly qualified VBA Developer with experience in the industry. Enjoy creative problem solving and getting exposure on multiple projects, and I would excel in the collaborative environment on which your company prides itself.
Worked in Investment Delivery, which is responsible for producing a large number of reports to the business.
Worked directly with users and stakeholders to gather requirements and work independently to deliver with limited direct supervision.
Designed, implemented and delivered solutions independently, with limited direct supervision, including requirements gathering, design, coding and testing.
Experienced integrating with other Microsoft tools (Outlook, Word, PowerPoint) is a plus.
Interested in other reporting tools and experience with SharePoint integration or PowerApps are a plus.
Trained team members in new coding techniques from a foundational understanding to practical application.
Troubleshoot VBA code and stored procedures.
Experience
2-5 Years
Level
Executive
Education
MA
VBA Developer Resume
Summary : Insightful, results-driven VBA Developer Professional with over 10 years experience working with SQL Server, Access, Excel, and Visual Basic for Applications (VBA). Notable success in process improvement and hands-on experience leading all stages of system development efforts, including requirements definition, design, architecture, testing, and project-based efforts while managing, motivating, and guiding teams.
Skills : SQL, Microsoft Office, Tableau, VBA.
Description :
Monitored the reuse of media titles and episodes which warrant the payment of a residual to the talent involved in the production.
Worked closely with management mapping the department process work flow, creating a data dictionary, and getting approval for every phase of the project to its completion.
Managed a small team of two senior financial systems analysts to provide on going user training, application enhancements, and IT systems support.
Experienced working with front-office investment systems is helpful but not required.
Reviewed gathered requirement.
Analysed and designed applications efficiently to ensure that customers needs are met respecting due dates.
Modified or created new user interfaces in MS Access, creating and modifying stored procedures.
Creating an account is free and takes five seconds.
You'll get access to the PDF version of this resume template.
Choose an option.
Sign up with Google
Sign up with Facebook
Sign up with Linkedin
This helps us make sure you're human and prevents spammers from abusing our services.
By continuing, you agree to our Privacy Policy and Terms.
Unlock the Power of Over 10,000 Resume Samples.
Take your job search to the next level with our extensive collection of 10,000+ resume samples. Find inspiration for your own resume and gain a competitive edge in your job search.
Get Hired Faster with Resume Assistant.
Make your resume shine with our Resume Assistant. You'll receive a real-time score as you edit, helping you to optimize your skills, experience, and achievements for the role you want.
Get Noticed with Resume Templates that Beat the ATS.
Get past the resume screeners with ease using our optimized templates. Our professional designs are tailored to beat the ATS and help you land your dream job.