MS Access VBA Developer

at  Luxoft

PROJECT DESCRIPTION

Our client is a UK subsidiary of a global financial house working in multiple markets and asset classes.
We are currently for a VBA developer, who will work in the technology team within Operations for EMEA, which is responsible for around 60 MS Access applications with about 600,000 lines of VBA code. The role is for maintenance and enhancement of existing systems, and development of new systems to support business requirements.
The candidate will work closely with the heads of operations departments and SMEs, operating as a senior analyst and programmer to support system development and implementation. They will be responsible for the production of various project elements including but not limited to; Analysis, Business Requirements, Design Documents, Application Programs, Test Scripts and Test Plans. The end solutions should be consistent with the design and implementation of existing solutions, and reuse existing components where relevant.
Strong communication and interpersonal skills is a must, and the candidate must have a well organised and structured approach to managing small/medium projects and working with senior stakeholders.

SKILLS

Must have
5+ years of relevant experience in MS Access VBA Development or as mix of Excel and Access VBA being one of the tools (8+ years of experience)
Access VBA: Good understanding of the use of Class modules
Access SQL
Access Forms
Access Reports
Automation, from Access, of Excel, Word, Outlook
Use of other COM objects as required
Experience of ODBC connections to:
SQL Server
Oracle
IBM iSeries
Experience with end to end SDLC from designing to coding, testing, implementation and support
Nice to have
Banking experience, Regulatory initiatives

Undertake the design, coding, and testing of solutions using MS Access and SQL Server technologies.
Re-use and leverage functional components from existing MS Access systems if applicable.
Analyse user requirements and design technical solutions to business problems.
Document requirements, system designs/specifications and user guides as per department standards.
Applies agreed standards and tools, to achieve well-engineered outcomes.
Prepare test plans including test cases and coordinate UAT with users.
Works iteratively with stakeholders, to identify potential benefits and available options for consideration, and in defining acceptance tests.
Accepts responsibility for creation of test cases using own in-depth technical analysis of both functional and non-functional specifications (such as reliability, efficiency, usability, maintainability and portability).
Specifies requirements for environment, data, resources and tools. Interprets, executes and documents complex test scripts using agreed methods and standards.
Records and analyses actions and results, and maintains a defect register.
Access VBA Development