- Featured in:
-
More VBA Developer Resumes
Use these VBA Developer samples as a guideline or visit our extensive library of customizable professional resume templates.
Select
Customize
Download
Find out what is the best resume for you in our Ultimate Resume Format Guide.
Additional Computer Software Resume Samples
VBA Developer Resume Samples
No results found
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
- 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.
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
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).
Computer Software Cover Letter Examples
Rate This Article
[VBA Developer]
Last edited by: Gabriela Barcenas, CPRW, Content Writer II -
Gabriela Barcenas
CPRW, Content Writer IIGabriela is a Certified Professional Resume Writer (CPRW) and career adviser. With 10 years of digital media experience and five years of resume writing expertise, her publication history includes fashion, education, travel, social justice, equitable design and career advice.
