VBA Developer Resume Sample
Work Experience
- Advanced Excel VBA experience required
- Familiarity with O365 tools, esp. Sharepoint Online and Power BI
- Proficiency in MS Excel and VBA
- Very good knowledge of MS Access and SQL
- Maintain end user relationship as well as relationship with other development teams across Rates Technology
- Perfect Microsoft Access 2010 as well as Excel 2010 skills
- Experience in VBA (or VB.NET)
- Knowledge in specific data base/reporting work experience or any other involvement in commercial type of reporting
- Support and development of data processing systems using Excel and Access
- Client support with queries relating to
- Provide subject matter expertise in MS Excel, VBA tools
- Develop dashboards in Excel using Pivot Tables, Power Pivot. Automation of tasks using macros and Excel packages
- Create and update automated scripts for graphs, charts, and data tables on a weekly, monthly and quarterly basis
- Participate in requirements gathering sessions to understand, capture and validate new requirements for development/modifications/enhancements
- Collect and connect data across the databases and information sources. Interact with business area management, ITO specialists, and corporate business analysts to ensure operational delivery support services
- Interact with the Data Warehousing team and provide business requirements for database development of reports in Business Objects, or other tools, as needed
- Development on differentiated tasks by translating the software design into code in accordance to the partners’ quality requirements
- Excel VBA Macros
- MS Access VBA Macros
- Assists in analyzing, designing, creating, and implementing database and spreadsheet applications in all environments
- Supports, maintains, optimizes, and monitors database and spreadsheet applications in all environments
- Provides assistance in designing, testing, and implementing specific database and spreadsheet structural changes
- Helps in investigating and resolving database and spreadsheet application problems
Education
Professional Skills
- Strong skills in Visual Basic for Applications (VBA), with experience developing automated reporting from multiple data sources
- Verbal and written communication skills, listening skills
- Excellent interpersonal skills with the ability to communicate, maintain positive relationships and work effectively as part of a team
- Strong, demonstrable VBA/VBScript skills Solid understanding of the Microsoft .NET languages VB.NET, C , C or C++, SQL Server and NET WinForms
- Proven VBA Development experience with a strong technical understanding of MS office Applications
- Strong Communication (both written & verbal), analytical and problem solving skills
- Possess strong verbal and written communication skills and the ability to multi-task and work on tight deadlines
How to write VBA Developer Resume
VBA Developer role is responsible for excel, reporting, vba, programming, languages, microsoft, .net, access, analytical, insurance.
To write great resume for vba developer job, your resume must include:
- Your contact information
- Work experience
- Education
- Skill listing
Contact Information For VBA Developer Resume
The section contact information is important in your vba developer resume. The recruiter has to be able to contact you ASAP if they like to offer you the job. This is why you need to provide your:
- First and last name
- Telephone number
Work Experience in Your VBA Developer Resume
The section work experience is an essential part of your vba developer resume. It’s the one thing the recruiter really cares about and pays the most attention to.
This section, however, is not just a list of your previous vba developer responsibilities. It's meant to present you as a wholesome candidate by showcasing your relevant accomplishments and should be tailored specifically to the particular vba developer position you're applying to.
The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative VBA Developer resume experience can include:
- Solid Experience in writing Access SQL and T-SQL Statements
- VBA programming skills in Excel and Access
- UI - Demonstrated ability creating rich interfaces. Good judgment in UX/UI design
- Advanced trouble-shooting skills
- Strong experience of automation / optimizing PROD performance via MS Excel
- Well-developed analytical skills, with the ability to define document and resolve problems utilizing a variety of analytical tools
Education on a VBA Developer Resume
Make sure to make education a priority on your vba developer resume. If you’ve been working for a few years and have a few solid positions to show, put your education after your vba developer experience. For example, if you have a Ph.D in Neuroscience and a Master's in the same sphere, just list your Ph.D. Besides the doctorate, Master’s degrees go next, followed by Bachelor’s and finally, Associate’s degree.
Additional details to include:
- School you graduated from
- Major/ minor
- Year of graduation
- Location of school
These are the four additional pieces of information you should mention when listing your education on your resume.
Professional Skills in VBA Developer Resume
When listing skills on your vba developer resume, remember always to be honest about your level of ability. Include the Skills section after experience.
Present the most important skills in your resume, there's a list of typical vba developer skills:
- Good communication skills to work effectively with other functional teams
- Excel enthusiast with proven Excel advanced skills & macros
- Experience: Four years of prior work experience (in addition to education requirement)
- Excellent organizational, facilitation and interpersonal skills
- Incorporate visualizations into reporting to pinpoint insights effectively and enable actions to be taken efficiently
- Good knowledge and experience of SQL, preferably in Oracle, including stored procedures, functions and triggers. (would be beneficial but not mandatory)
List of Typical Experience For a VBA Developer Resume
Experience For Senior VBA Developer Resume
- Experience translating enterprise desired reporting requirements
- Using your broader capabilities to contribute to the design and governance of the Insurance Finance operating model for data
- Outstanding problem solving ability and tenacity to drive resolution
- Understanding of TCP/IP networking environments
- Deputising for the Lead Developer as relevant
- Working with firm's systems to enhance/develop tools to streamline work processes and integrate operations
- Working knowledge of relational databases such as Oracle and SQL Server. Knowledge of database design
- Understanding of financials industry and its IT solutions
Experience For MS Access / VBA Developer Resume
- Understanding of SQL. Ability to write performant SQL. Ability to diagnose queries, and work with DBAs
- Understanding of financial & sales framework
- Understanding of general finance systems or applications
- Being assigned development tasks on .NET or Mulesoft
- Competent at facilitating, creating materials and presenting level appropriate material in a small group meeting
- The role also involves analyzing and designing technical solutions to problems and advising on the appropriate use of tactical technology
- Working with data and creating operational processes regarding ETL
- Knowledgeable in designing and architecting solutions using Blue Prism
Experience For VBA Developer for Access & Excel Resume
- Execute various manual test cases against requirements, including but not limited to functional, regression, stress and load testing
- Design and build tools and reporting using VBA, MS Access, MS Excel
- Understands infrastructure elements including performance and tuning considerations
- Maintenance of VBA within existing Actuarial Pricing models
- Display understanding of programming techniques and apply knowledge as appropriate
- Perform independently using business applications, databases, data viewing/extraction tools and reports
- Working in SQL, including Access SQL or SQL Server
- Research, recommend and institute operational automation protocols to improve business processes for data flow, analysis, and reporting
Experience For Excel / VBA Developer Resume
- Establish procedures for assessing data sources for data quality issues
- Assist in testing efforts for supported applications and analytic tools
- Expert understanding of ETL processes
- Gain a quick understanding of key business processes and technical issues
- Proactively developing and maintain customer relationships, to meet current and future business needs
Experience For MS Access / VBA Developer With German Resume
- Plan and execute acceptance testing and criteria specification
- Design, develop, enhance and deliver integrated solutions using Microsoft technologies and SQL Server
- Knowledge of other programming/technical languages useful (MATLAB etc)
- Insight into database design and modelling
- Present and win backing for new ideas
- Basic understanding of key economic concepts
Experience For GFI Ad-vba Developer Resume
- Consult with Merchandising, DSMs, Store Support and others to create new tools to support store support initiatives
- Familiarity with backup or monitoring tools
- Adjust and adapt to an ever-changing environment
- Self-motivated and multi-tasking individual who works well in a team environment
- Integration of Actuarial Pricing models to a new database for parameter data
- Client-Server Programming: Visual Basic, VB.NET, ASP.NET, VBA
Experience For VBA Developer Resume
- Building .NET applications in C or VB.NET
- Team player fostering a collaborative and cooperative approach to project delivery
- Preferably at least 2 years in a role that involves reporting activities
- Perform controls to minimize the risk of unauthorized and rogue trading
- Verify the firm’s trading related Profit & Loss (P&L) and ensure it is complete, accurate and explainable
- Verify the bank’s trading related balance sheet is accurate in the firms General Ledger (GL) accounts
- Participates in specification meetings with project team members to determine scope and limitations of projects
Experience For Senior VBA Developer Resume
- Maintains database schemas and data documentation
- The main functions of the role are technical development and support for tactical Access databases and Excel spreadsheets
- Design, develop and implement, via effective collaboration with business stakeholders, new forecasting tools in VBA, SAS, or equivalent analytical programming language
- Interacting with QA and Business Analysts on User Stories and Bugs
- Reporting status to Product Manager and team
- Adhering to our SDLC
- Establish procedures for loading new datasets into data warehouses including ETL, business logic verification, and data governance
Experience For MS Access / VBA Developer Resume
- Design and develop data extraction, staging, and loading processes for data warehouses
- Lead efforts to enhance and maintain existing analytics tools used for data analysis, forecasting, and report generation
- Analyze requirements to ensure technical design of analytic solutions meet customer needs
- Perform code reviews to ensure proper design and functionality of technical solutions
- Mentor and transfer EXCEL / VBA / MS Access / SAS technical knowledge and processes to other Bank team and department personnel
Experience For VBA Developer for Access & Excel Resume
- Working experience in large Corporate environments with ERP, CRM, Install & Service Field Ops, Cloud based platforms (BaaN, Oracle Fusion/Oracle EBS, ServiceMax, SalesForce.com highly desired)
- Continuous Improvement - Serve as a change agent by continuously searching and proposing more efficient ways of doing day-to-day activities/processes
- Design, develop, maintain, and deliver highly scalable and reliable Microsoft Word 2013 applications that interface with web technologies including HTML5, CSS3, JavaScript, REST API
- Experience developing Microsoft Word 2013 applications using VBA
- Experience in HTML5, CSS3, JavaScript
- Experience in at least one of the following configuration management tools: PVCS, Subversion and build automation tools such as Ant, Maven, BuildForge or similar
- Database Administration - Develop range of spreadsheet modelling applications and database/web-mining tools utilizing SQL and VBA for applications. Includes manipulation and development of automated spreadsheets and database applications through VBA programming
- Stakeholder Management - Effectively gather stakeholder requirements, through workshops and focus group discussions, and incorporate in the output/product. Ensure that requirements are also aligned with the organization's directions. Create user manuals based on output/product and conduct training, if necessary
List of Typical Skills For a VBA Developer Resume
Skills For Senior VBA Developer Resume
- Strong skills in MS Access, and MS Excel
- Strong task and time management skills
- Responsibility for delivering management information and data solutions for change using a variety of technical and analytical skills
- Well-developed planning and organization skills
- Superior documentation and organizational skills
Skills For MS Access / VBA Developer Resume
- VB6 Skills (about 3-5 years)
- Demonstrates ability to prioritize work within timelines
- Demonstrated ability to prioritize own work within project timelines
- Experience with writing, editing, and pass-through querying
- Experience of developing tools using VBA in MS Excel and/or MS Access
- Experience gathering requirements for executive level reporting
- Experience with business process mapping, process improvement and re-engineering
Skills For VBA Developer for Access & Excel Resume
- Experience developing interactive data driven applications using Excel VBA and SQL Server in a multi-user environment
- Experience working with Visual Basic, SAS, or related programming language
- Good working knowledge on investments and finance, supporting business applications and procedures
- Experience supporting requirements gathering, analysis, and documentation
- Experience in creasing/using micros in Microsoft Excel or Access
- Experience working in a project-centered environment
- Experience in negotiating issues to resolution
Skills For Excel / VBA Developer Resume
- Strong work ethic with focus on continuous improvement and enhancing the team environment
- Experience performing complex data analysis and data aggregation
- Any experience working with retail markets and data is highly desirable
- Innovative thinker with good problem solving abilities and attention to detail
- Self-motivated with ability to work independently, prioritizing tasks to meet deadlines
- Experience with ad-hoc reporting, dashboards and metrics development
- Demonstrated proficiency in analyzing data to derive business insights and support business process improvement initiatives
- Uses rigorous logic and methods to solve difficult problems providing effective, efficient solutions
Skills For MS Access / VBA Developer With German Resume
- Multitask and adhere to project schedules and prioritization. Adapt to rapidly changing deadlines and tasks
- Experience in MS Office Applications using VBA
- Experience using Pivot Tables, and Pivot Charts
- Building charts in Excel with a strong VBA bias
- Experience using PowerPivot
Skills For GFI Ad-vba Developer Resume
- Experience in Perl, Python, Windows Batch Scripting
- Experience with automation of business processes using Windows APIs and COM objects, test script development, and SDLC best practices
- Relatable experience using VBA and Access
- Demonstrates strength at evaluating feasibility or practicality of ideas and options, assesses risks and trade-offs; makes informed and timely decisions
- Demonstrated strength at evaluating feasibility or practicality of ideas and options, assesses risks and trade-offs; makes informed and timely decisions
- Experience in Banking and Finance
- Experience with Windows 7/10 operating system
Skills For VBA Developer Resume
- Solid MS Access and MS SQL Server
- Demonstrate a customer-service centered service delivery approach
- Knowledge/Experience with .NET Windows Application Development
- Knowledge/Experience with SharePoint Development
- Knowledge/Experience with WSI Xceptor Qualifications
Skills For Senior VBA Developer Resume
- Desirable Industry experience in Fund Administration in a business analyst role
- Experience with C#.NET, Python, ETL systems (e.g. SSIS) or BI tools (would be beneficial but not mandatory)
- Work well independently and within a team. Strong team player with willingness to collaborate
- Experience with the challenges of Custom software applications
- Full life-cycle tactical system development experience
- BVA and Excel experience
- C# or other .NET technologies experience
- Experience in Rapid Application Development and Agile methodology
- Proven success and ability to implement end-to-end change
Skills For MS Access / VBA Developer Resume
- Experience with Microsoft Access and VBA application development
- Proven ability to communicate with diverse group of users by phone
- Analyze and implement, via effective collaboration with application support personnel, business requirements in relation to systems capabilities
- Experience in at least one of the following integrated development environments: Eclipse, IBM RAD, or JDeveloper
- Advanced Excel VBA experience is required
- Effective verbal and written communication for both technical and non-technical stakeholders / audience
- Developer technology experience with VBA, ACCESS, and SQL required
- Experience in system design, development, and support
- Development experience with Microsoft VB.Net, Windows Forms, VBA, and Microsoft Access Form Design
Skills For VBA Developer for Access & Excel Resume
- Experience with databases (Microsoft SQL Server)
- Experience in business process analysis and SDLCs
- Experience in production deployment process and release management
- Excellent verbal, written, and interpersonal communication
- Develop an automated excel to operate with Macros to perform RA methodology with weightings
- Deploy and assist with Business Unit Regulatory applicability designation and validation process either through ECRAA process or manual excel
- Experience with VBA/VB, SQL Server and .net for ECRAA
- Ensuring compliance with all relevant Group and team procedures, guidelines and reporting requirements (including regulatory and statutory requirements)
- Contributing to the planning, control and monitoring of a range of services and initiatives
List of Typical Responsibilities For a VBA Developer Resume
Responsibilities For Senior VBA Developer Resume
- Project Management - Follow short iterative and incremental development cycles to produce prototypes allowing faster product delivery, early testing of prototype and continuous integration. Create test plans to ensure requirements are captured and executed correctly. Document product timeline and transition plan
- Building unit tests
- The delivery of project and business change to our finance systems, ensuring high quality output
- Plan, conduct, and direct analysis of business initiatives
- Provide consultation to users and sponsers
- Provide daily system and governance support
Responsibilities For MS Access / VBA Developer Resume
- Design, develop, test, and implement technology applications/systems
- Support development, maintenance, and enhancements of Microsoft Access, Excel and SQL
- Support team on special projects
- Provide project status updates
- Develop, write, and implement code for updates to compliance risk assessment templates in Enterprise Compliance Risk Assessment Application (ECRAA)
Responsibilities For VBA Developer for Access & Excel Resume
- Deploy compliance risk assessments in accordance with annual schedule within ECRAA system and ensure they run correctly
- Write new code compliance risk assessment templates and source documents within the ECRAA system
- Manage compliance risk assessment database and risk assessment data transfers to Open Pages GRC System
- Provide Microsoft (MS) Access Database, MS Excel, MS SQL Server, and Visual Basic for Applications (VBA) Technical Support and Maintenance
- Respond to technical questions, diagnose and troubleshoot software problems, and perform enhancements for applications
- Analyze business requirements, evaluate current tools/processes, provide input to design of technology solutions and problem solve both technical/non-technical issues
- Build/Enhance Excel VBA prototypes and small scale applications as well as VBA scripts to automate Access/Excel spreadsheet processes
- Work with team to produce technical documentation, test scripts and test cases from requirements, and user stories
Responsibilities For Excel / VBA Developer Resume
- Ensure compliance with System policies and standards as well as internal control processes
- Identify and implement operational improvements to enhance department performance, manage risk, and benchmark to industry best practices
- Expert in MS Excel, Access, and VBA/Macro in Microsoft Office 2013/2016
- Proficient in SQL Server (2008-2016) and its suite of tools (Management Studio)
- Project: the classic phases of a project (V model) knowledge
Responsibilities For MS Access / VBA Developer With German Resume
- Analyze and formalize needs
- Responsiveness, availability, ability to move quickly from one topic to another
- Up-to-date with latest advances and trends in applications development
- Able to meet deadlines and communicate regularly with supervisor on project status
- Apply knowledge of retail environment to design and approach for new applications development
- Interact with non-technical people in plain language
- Proficient in other Microsoft applications – MS Word, PowerPoint, & SharePoint would be helpful
- English - business fluent
Responsibilities For GFI Ad-vba Developer Resume
- Knowledge of SharePoint is also positively valuated (desirable)
- Generates new and unique ideas, approaches and solutions to problems and opportunities. Openly questions traditional assumptions
- Takes first steps to act on ideas and opportunities with minimal direction
- Strives to seek out ways to improve team dynamics
- Take responsibility for the secure storage of all our data and archives
- Previous history of business analysis
- Interest in data delivery/presentation/visualisation
Responsibilities For VBA Developer Resume
- Advanced form/query/report design in MS Access/MS Excel
- Knowledge of SharePoint 2010+
- Write VBA and SQL in Access
- Verify the prices used to value the firm’s trades and positions and ensure accurate to the market
- Perform disclosures reporting to regulators (e.g. ensuring that positions held on our books are transparent as to the reliability of their fair value and support other regulatory items such as Dodd Frank and Basel 3)
- Align to the bank’s strategic investment, capital, restructuring and efficiency initiatives (LEP, SRP and more)
- Consult and problem solve on various business issues with cross functional groups (RVPs, DSMs, Store Support, FP&A, IT etc.)
Responsibilities For Senior VBA Developer Resume
- Knowledge of database analysis, design, and maintenance
- Microsoft Access database development
- Expert in VBA, Access, Excel and SQL Server & SSIS
- Possess ability to work independently with minimal supervision
- Translate business requirements into meaningful and actionable reports
- Financial background, esp. in Interest Rates Derivatives
- Reuters RMDS/Eikon or other market data platforms
Responsibilities For MS Access / VBA Developer Resume
- Windows 7, MS Office 2007/2010
- Financial background, preferably Interest Rates Derivatives / Fixed Income / Credit Derivatives
- Build relationships with peers and customers
- Object Orientated development
- Microsoft Excel development
- Expert Excel/VBA knowledge
- Create complex queries
- Support ad-hoc RFIs
- Microsoft SQL S014