Excel VBA Developer Resume
Excel-VBA developers have thorough knowledge of Microsoft Excel and mostly work in business environment. Since Excel is widely used for complex calculation and financial solutions, the developers needs to be familiar with mathematical formulas and syntax used in finance. Based on the clients' and employers' requirement, they must be able to integrate VBA (Visual Basic for Applications) template and macros in Excel. They should be experienced in automating financial and mathematical tasks in Excel by building or creating macros.
Excel VBA Developer Resume Example
John K. Stratton
1940 Chenoweth Drive
Huntland, TN 37345
Phone: 931-469-2041
Email: jkstratton@example.com
Career Objective:
To work as an Excel VBA Developer with “Trident Financial,” and provide best business solutions to clients by developing customized macros and managing back-end functions to store and preserve worksheets data.
Summary of Skills:
- Excellent knowledge and experience of VBA and business finance
- Comprehensive knowledge of MS Excel in a business environment
- Excellent understanding of object-oriented programming language
- Strong knowledge of commodities and equity derivatives
- Remarkable analytical, problem-solving, and troubleshooting skills
- Competent in project management, SQL and other database applications
Work Experience:
Excel-VBA Developer
Global Developers and Associate, Huntland, TN
October 2014 - Present
- Accessing and developing customized solutions for clients
- Interacting and demonstrating financial solutions to clients
- Performing testing, maintenance, debugging, and documentation for every process
- Designed and wrote the automation code for database queries and resolution
- Creating link-based module to enable automatic updates for excel workbooks
- Designing client-specific modules for automatic reconciliation and tracking database modifications
- Designing a self-training manual for clients and their employees
- Assisting in development and maintenance of database migration module
- Providing on-site and off-site troubleshoot assistance
Excel VBA Developer
CUBIX Technologies, Huntland, TN
February 2013 - September 2014
- Developed and installed VBA programs for business solutions at clients' site
- Tested and debugged applications, written user manual, and FAQ's
- Finished all the projects on or before time and within allocated budget
- Developed a utility module for data conversion and exporting to Excel workbooks and VBA programs simultaneously
- Provided support and maintenance including data encryption and security on a weekly basis and generating reports for VAR, CRP, CDM and QAP
- Involved in remodeling of user defined functions and tabs for different instructions
- Created macros for calculation of AR/AP, equity, interest, OS settlement and foreign exchange
- Created automated mail trigger for reporting any unusual modification to critical files as well as deals above a specified limit
Education:
- Bachelor's Degree in Information Technology
ABC University, Huntland, TN
2012
Reference:
On request.
