Vba Developer Resume Samples

HIGH QUALITY

The best examples from thousands of real-world resumes

EXPERT APPROVED

Handpicked by resume experts based on rigorous standards

DIVERSE EXAMPLES

Tailored for various backgrounds and experience levels

Vba Developers create business solutions for a variety of companies using the programming language called Virtual Basic for Applications. Typical duties highlighted on a Vba Developer resume sample are discussing requirements with clients, maintaining computer systems, ensuring customer support, improving information systems, developing applications, and handling quality assurance tasks. Based on our collection of example resumes in the field, essential qualifications are analytical thinking, technical skills, teamwork, problem-solving orientation, computer proficiency, and attention to details. Most Vba Developers hold a Bachelor’s Degree in information technology or computer science.

1

Business Intelligence Analyst; Access/vba Developer

Developed a site-wide Metrics tracking and reporting system for the NASA White Sands facility, using MS Access & VBA. Project encompassed 8 departments with over 100 reports and growing. Utilized solid design and best technology to quickly create solutions that met immediate needs, yet are flexible enough to grow with business.

  • Planned, developed, implemented and administered for the acquisition, storage and retrieval of data for a variety of databases that support the programmatic and administrative functions of this system.
  • Collaborated with department managers to determine functionality requirements, resolve data quality issues, and improve the quality of the source data. Analyzed and defined data requirements, specifications and procedures; planned for and anticipated changes in data capacity requirements, and evaluated new technologies and architectures.
  • Worked with the Health & Safety department manager on the design and implementation of a database driven web portal for monthly check-up reporting, using VB.net and ASP.net.
  • Extracted data from Maximo and Remedy for storage and reporting into custom SQL data warehouse. Built VBA UDF's (user defined functions) for conversion of Julian dates (ddd/hhh:mm:ss) for use across applications.
Candidate Info
5
years in
workforce
1
month
at this job
2

Project Manager / Vba Developer

Helped conceptualize and set up account suites to accurately capture trade flow, cash moves and accounting entries. Maintained department-wide P&L/Settlement systems, updating them to correctly handle new workflow.

  • Worked with the P&L team in a senior capacity, delegating responsibilities and providing training and guidance.
  • Served as external accounting firm's point of contact on year-end processing and annual audits.
  • Rebuilt and improved programs used for monitoring daily margin and equity balances, cash positions, and run-rate calculations, saving the company 5 hours of processing time per week.
  • Facilitated the corporate crisis plan after Hurricane Sandy by establishing a temporary office in New Jersey, then directing operations on a short-term basis from London. This enabled the company to regain full trading capacity (> 1M transactions per day) within 1 week.
Candidate Info
11
years in
workforce
2
years
at this job
BS
Finance
MBA
Business Administration
3

Business Intelligence Analyst; Access/vba Developer

  • Developed a site-wide Metrics tracking and reporting system for the NASA White Sands facility, using MS Access & VBA. Project encompassed 8 departments with over 100 reports and growing. Utilized solid design and best technology to quickly create solutions that met immediate needs, yet are flexible enough to grow with business.
  • Planned, developed, implemented and administered for the acquisition, storage and retrieval of data for a variety of databases that support the programmatic and administrative functions of this system.
  • Collaborated with department managers to determine functionality requirements, resolve data quality issues, and improve the quality of the source data. Analyzed and defined data requirements, specifications and procedures; planned for and anticipated changes in data capacity requirements, and evaluated new technologies and architectures.
  • Worked with the Health & Safety department manager on the design and implementation of a database driven web portal for monthly check-up reporting, using VB.net and ASP.net.
  • Extracted data from Maximo and Remedy for storage and reporting into custom SQL data warehouse. Built VBA UDF's (user defined functions) for conversion of Julian dates (ddd/hhh:mm:ss) for use across applications.
Candidate Info
5
years in
workforce
1
month
at this job
4

Excel / VBA Developer - Automation / Trading Tools Developer

Enhanced Trading productivity by designing and building Excel based trade booking tool for Global Domestic Equity Finance Desk to support automatic bookings of Equity, Repo, Bonds and TriParty trades. The tool interfaces with the SOAP WebService and provides data validation and error control services.

  • Optimized daily Trading PNL with a delivery of a position management tool to manage excess Equity inventory. It allows the trader to automatically return excess longs by automatically creating a basket of Equities with highest cost to the firm while keeping the book flat throughout the day.
  • Enhanced Trading Risk Management with a tool to perform credit checks on 2000+ daily trades across a spectrum of Equity and Fixed Income products. VBA code interfaced with XML/Rest technologies provided by internal Risk systems, which communicated daily risk and retrieved daily Risk limits.
  • Designed and authored Positional / PNL / Inventory pricing reports with MS Access Database Tools.
  • Built ad-hoc pricing tools and data retrieval services.
  • Programmed COM DLL with C# to expose .Net functionality to Excel users. Authored a Class Library which combined and exposed all firm Lending/Borrow Equity Webservices in a single DLL. This DLL is used across hundreds of in-house macros, the key benefit, it is self-updating of webservice parameters post webservice releases this saves time by not having to update VBA macros manually.
  • Simplified process for Trading requests for report of trade positions by adding LINQ services to DLL libraries to manipulate WebServices collections of trades.
  • Reduced time to delivery on programming projects by designing and programming an abstraction enhancement to the VBA system scripting dictionary to automate redundant programming tasks such as populating dictionaries / collections, checking for duplicates, member exist checker and implementing error control and quasi- strong type restrictions for newly instantiated objects.
  • Improved time to delivery on complex projects by writing a class generator for VBA to serialize Excel ranges to VBA objects and deserialize objects to Excel ranges. These classes are generated to have full set of setters/getters that can deserialize the instances of their object from their collections to an Excel range in a single line statement. This automation allowed me and other programmers to take on and complete projects with complex requirements and very large datasets. In addition, hours of redundant coding are saved and each iterative solution retains same readability as previous versions.
  • Remediated slow Excel Macro tools by converting them into Object Oriented Programs and removing slow loop code and replacing it with arrays to range allocations. Influenced other programmers to use similar methods to write faster Macros.
  • Enhanced internal employee knowledge base by proposing and organizing C# .Net training course at [company name] for 19 people.
Candidate Info
11
years in
workforce
4
years
at this job
BA
Economics
5

Excel/vba Developer

Developed macros to manage processing of state compliance reporting.

  • These macros facilitated the collection of data, the set of reports and redefining of data values to be chatted.
  • Developed DOS bat routine to rename PDF files to match column heading within compliance reports to facilitate data entry.
  • Used Excel to create script by editing columns of cells, creating a 200+ line script in less than 10 minutes.
  • Evaluated software for project to parse large data source.
  • Trained new office assistant on usage of repenting system.
Candidate Info
15
years in
workforce
3
months
at this job
BS
Computer Science
6

MS Access/excel VBA Developer

Built MS Access Database for Market Research.

  • Complete Access Database - Restructure - Troubleshoot -VBA - and SQL (Structured Query Language) Code - Build Custom Forms and Reports.
  • Relational Database table structure includes one-to-many, one-to-one, and many-to-many relationships with implementation of junction tables.
  • Database includes over 470 employees with various security levels.
  • Main structure features include: Project Entry, Time Charging, and Advanced Reporting (Custom Outputs using Access Database Reports as well as Object Orientated Application Outputs to Excel and PowerPoint for Charts and Presentations.)
  • VBA Modules include complex Functions to loop thru form controls, VBA code working in conjunction with SQL Statements to manipulate data.
  • Dynamic Advanced Filtering, which incorporated using UNION queries, for searching and reporting which include multiple field(s) (combo box, textbox, checkbox, listbox) as well as "wildcard" - partial entry field(s) - used to search description or Project name field(s).
Candidate Info
20
years in
workforce
10
months
at this job
AS
Industrial Technology

Your Resume, Made Easy.

You are looking for your dream job and need a resume? My Perfect Resume is your solution and takes the hassle out of resume writing. Create the perfect job-worthy resume effortlessly in just a few clicks!