Nigel L.

Presently assigned as a Visual Basic for Applications [VBA] Support Analyst and Developer in a Microsoft Office End-User Computing [EUC] Middle and Back Office technology programme within a leading global financial group. Recent engagement as a Microsoft Office End-User Computing migration and remediation specialist for a technology transformation desktop refresh programme (repackaging and transferring applications from Microsoft Windows 7/Office 2010 to Windows 10/Office 365) for a leading global specialty commercial insurer and reinsurer, providing User Acceptance Testing support for Visual Basic for Applications [VBA]/Microsoft SQL Server-based systems. Previous engagements within City-based Financial Institutions. Insurance Service providers, Energy Trading organisations, and Professional Services organisations. Specialities: * Rapid Application Development and support of Microsoft Office applications (primarily Microsoft Access and Microsoft Excel) * Design and provision of robust, resilient, and secure data modelling resources for management information reporting systems * Automation of data analysis/validation/consolidation, and migration/extraction/transformation for finance and insurance clients * Leadership of development teams, support technicians, and testing resources, and mentorship/guidance to team members * Effective task prioritisation with clear, concise, and consistent communication to stakeholders, clients, colleagues, and peers * Issue identification taking responsibility to resolution, attention to detail, and commitment throughout the entire project lifecycle * Preparation/execution of test procedures, scenarios, cases and scripts, with reporting/tracking and coordination of test cycles * Preparation of business training, functional requirements, quality assurance, system design, and user documentation Microsoft Office Suite (1.0 to 4.x, 95-2016, 2019/Office 365) 1990 to present Microsoft Access (1.0 to 2019, Access Basic, VBA) 1992 to present Microsoft Excel (3.0 to 2019, Excel Basic, VBA) 1990 to present Visual Basic for Applications [VBA] (1.0 to 7.1) 1993 to present Visual Basic for Windows [VB] (1.0 to 6.0 Enterprise) 1991 to 2003 Structured Query Language [SQL] (ANSI SQL-86 to SQL Server 2017) 1992 to present Transact-SQL [T-SQL] (Stored Procedures) 1999 to present