VBA Developer

Job Description

JOB DESCRIPTION-Analyse Excel Report(s) with VB code to reverse engineer andunderstand logic including:-Determine all data sources and inputs used.-Review field mapping logic, transformation rules and data overrides.Understand final ouiputs (e.g record selection critera, template formats).-create technical specification documents outining existing functionality-Reviews business requirements and functional specifications for changesadditions to existing reporting tool (adding data sources, modifying fieldmappings, creating new outputs).-Preparing Technical Specification documents detaling required codechanges to meet business requirements.-Documenting ind executing Unt Testing of any Visual Basic codechanges.-Support User Acceptance testing and Regression testing cycles of reporting tool.-Support deployment / migration activities for release of codechanges to production-Communication with business users to clarify requirements forexisting VB code and/or debug issues-Ability to prioritize work and meet deadlines.-Effective analytical and problem-solving skills.-Effective communication skills both verbally and in writing with

-Analyse Excel Report(s) with VB code to reverse engineer andsuperiors and colleagues.understand logic including:-Present progress for review during regular status meetings.Determine all data sources and inputs usedEssentialReview field mapping logic, transformation rules and data overrides o 3rd level qualification in computer science or equivalentUnderstand final outputs (e.g. record selection criteria, template formats). o 5+ years' experience as VB/VBA developer in Excel includingCreate technical specification documents outlining existing functionality working with arrays, module classes, dils and with functions &-Reviews business requirements and functional specifications for changes proceduresadditions to existing reporting tool (adding data sources, modifying field o Experience working in an SDLC/Agile project environmentmappings, creating new outputs),-Experience preparing technical specification documents of-Preparing Technical Specification documents detailing required code system functionalitychanges to meet business requirements.Desirable-Documenting and executing Unit Testing of any Visual Basic code o Experience working in a Financial Institutionchanges-Treasury Product Knowledge• Support User Acceptance testing and Regression testing cycles of o Regulatory Reportingreporting tool-Oracle SQL