VBA Developer Resume Samples

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.

 

VBA Developer Resume example

VBA Developer Resume

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 :

    1. Designed custom VBA applications to assist and streamline current operations.
    2. Worked with multiple departments to find more efficient processes and procedures.
    3. Designed Excel spreadsheets to compile and compare large sets of data.
    4. Designed and implemented new tools and systems to improve department specific processes.
    5. Fulfilled a lead role within my team and established structure and standards by which to operate by.
    6. 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.
    7. Established structure and standards for myself and my team to operate by.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
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 :

    1. Developed cash flow reporting tool for the HR Executive Compensation Department to assist with Troubled Asset Relief Program (TARP) reporting requirements.
    2. Tools generated highly confidential cash flow 
    3. Developed improved reporting processes for Basel III Regulations.
    4. Met with analysts and managers to gather the requirements pertaining to their request.
    5. Played an active role in the quarterly closing process.
    6. Created entity lists, account lists, loading/consolidating data and maintaining security groups.
    7. Included providing user support, if needed, for Hyperion retrieve reports.
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
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 :

    1. Developed an Excel VBA program called Charges Attachment Generator.
    2. Provided functionality to create any of several financial charges tables (without templates) and to populate the tables.
    3. Generated sophisticated Excel formulas that calculated labor rates and total cost.
    4. Used forms to query for initial data to control table generation and used Excel validation to maintain accuracy.
    5. Modified its own code on-the-fly to provide event handling for the tables.
    6. Generated a dynamic, printable report summarising data from all of the tables.
    7. Centralised control data in a single spreadsheet allowing AmEx employees to set it before distribution to vendors.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
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 :

    1. Designed Dashboard in Access and excel.
    2. Designed an optimal one-to-many relationship layout of tables in Access.
    3. Created tables, Link tables, Views, Forms and Reports in Access from scratch.
    4. Developed macros to upload, export data automatically & periodically.
    5. Developed user friendly screens for capturing data.
    6. Created relationship between tables and queries in MS Access.
    7. Developed macros to fetch data from different data sources.
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
Master's In Commerce

VBA Developer Resume

Objective : A detail orientated individual seeking a position in database report development utilizing MS SQL Server Management Studio and MS Access/Excel VBA programming environment. To become a contributing team member of an IT department generating adhoc office report/systems and growing technically with current data reporting tools.

Skills : VBA, SQL, Access, Excel, T-Sql.

Description :

    1. Created and maintained advanced ETL processes for easy data flow to various systems.
    2. Monitored automated SSIS (ETL) and other system processes for success and failures.
    3. Assisted with logical and physical data modeling to support business initiatives.
    4. Utilised SQL to wrangle and report on large volumes of data.
    5. Collaborated with end users to identify needs and opportunities for improved data management and delivery.
    6. Developed, automated and ran user-friendly dashboards and reports using tools like Excel, VBA, Power BI and Tableau.
    7. Created and enhanced Microsoft Tabular (and PowerPivot) models to aid reporting requirements.
                        Years of Experience
                        Experience
                        2-5 Years
                        Experience Level
                        Level
                        Executive
                        Education
                        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 :

                          1. Designed Dashboard in Access and excel.
                          2. Designed an optimal one-to-many relationship layout of tables in Access.
                          3. Created tables, Link tables, Views, Forms and Reports in Access from scratch.
                          4. Developed macros to upload, export data automatically & periodically.
                          5. Developed user friendly screens for capturing data.
                          6. Created relationship between tables and queries in MS Access.
                          7. Developed macros to fetch data from different data sources.
                        Years of Experience
                        Experience
                        10+ Years
                        Experience Level
                        Level
                        Senior
                        Education
                        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.

                        Skills : Developing, Modelling, Security Management.

                        Description :

                          1. Worked for a Healthcare provider assisted the Informatics Department of the IT group with custom VBA written Excel Reports.
                          2. Had to create individual reports based on each time group, add & format new sheets in the workbook and plot new graphs from the dataset.
                          3. Developed VB application to export data from SQL Server to Access.
                          4. Created tables, Views, Forms and Reports in Access.
                          5. Implemented conditional formatting in access reports.
                          6. Automated the refreshment of the pivot tables of the reports in a specified directory (the number of report workbooks.
                          7. Instituted moderate security protocols and generated HTML help files.
                        Years of Experience
                        Experience
                        2-5 Years
                        Experience Level
                        Level
                        Executive
                        Education
                        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 :

                          1. Used this system as the topic of my undergraduate honors thesis and my senior capstone project.
                          2. Transformed that data into Excel worksheets.
                          3. Loaded the Excel data into MS Access database Tables.
                          4. Created MS Access Forms, Query and Reports to display this data in meaningful ways to Deloitte and the CDC.
                          5. Basically managed the project myself.
                          6. Created two MS Access database; one for DPIP Awardee data and one for EHDI Awardee data.
                          7. Supported and enhanced a complex reporting ecosystem in Excel.
                        Years of Experience
                        Experience
                        5-7 Years
                        Experience Level
                        Level
                        Executive
                        Education
                        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.

                        Skills : MS-Excel, MS-Access, MS-PowerPoint, MS-Word, MS-Visual.

                        Description :

                          1. Worked in Investment Delivery, which is responsible for producing a large number of reports to the business.
                          2. Worked directly with users and stakeholders to gather requirements and work independently to deliver with limited direct supervision.
                          3. Designed, implemented and delivered solutions independently, with limited direct supervision, including requirements gathering, design, coding and testing.
                          4. Experienced integrating with other Microsoft tools (Outlook, Word, PowerPoint) is a plus.
                          5. Interested in other reporting tools and experience with SharePoint integration or PowerApps are a plus.
                          6. Trained team members in new coding techniques from a foundational understanding to practical application.
                          7. Troubleshoot VBA code and stored procedures.
                            Years of Experience
                            Experience
                            2-5 Years
                            Experience Level
                            Level
                            Executive
                            Education
                            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 :

                              1. Monitored the reuse of media titles and episodes which warrant the payment of a residual to the talent involved in the production.
                              2. 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.
                              3. Managed a small team of two senior financial systems analysts to provide on going user training, application enhancements, and IT systems support.
                              4. Experienced working with front-office investment systems is helpful but not required.
                              5. Reviewed gathered requirement.
                              6. Analysed and designed applications efficiently to ensure that customers needs are met respecting due dates.
                              7. Modified or created new user interfaces in MS Access, creating and modifying stored procedures.
                                      Years of Experience
                                      Experience
                                      7-10 Years
                                      Experience Level
                                      Level
                                      Management
                                      Education
                                      Education
                                      Business Administration