Hire VBA Developers & Contractors in London | LynxPro
Find VBA Developers in London
We use a highly curated database to find the candidate with the skills most suited to your business’s needs. Browse the talent below, find the perfect fit and our qualified customer service agents will take care of the rest.
Developer Skills: MS Excel up to 2010 (25 years), VBA development (20 years), MS Access 2010 (10 years), Access SQL (5 years), ADO (5 years) / DAO, Classes, XML, Sybase/SQL server T-SQL (3 years), MS SQL Server Management Studio 2012/2008 (2 years), Outlook VBA (1 year), WORD VBA (1 year).
BUSINESS ANALYSIS SKILLS (5 years): Requirements gathering, functional and technical Specifications – process maps, process gaps, analyse data sources, document VBA code–function points, data and calculation flowcharts. Data modelling. Technical Design. Tools: Visio and Word.
TESTING SKILLS: Unit testing, system testing, parallel testing and User Acceptance Testing (UAT). Tools: Quality Centre/ALM.
SECTORS: Banking (10+ years), Insurance (3.5 years), Asset Management (1.5 years), Other (11.5 years)
Database design, data-extraction, -integration, -manipulation, -analysis, -reporting & -visualization. VBA development in Access, Excel, Outlook & Word. ADOdb to SQL server back-end. Predictive analytics – regression, classification, clustering, & PCA. Highly skilled in SQL server, PowerPivot, R, Regular Expressions, DAX. Mac
VB.Net/C# application developer, Microsoft MCSA certified SQL Server developer and a CIMA qualified accountant. Over 10 years experience as a process improvement Analyst/Programmer in Microsoft technologies whilst working closely with business users (particularly within Finance).
Power BI: ETL in Power Query; Writing in M Language; Getting data from Excel, SQL Databases; Data Modelling in Power Pivot; Relationships; Report Building; Advanced Visualisations; Time Intelligence; Drill-Downs; Drill Throughs; Slicers; Filters; Bookmarks; Dashboards, Q&A, Quick Insights, Sharing Dashboards & Reports, Row Level Security, Workspaces; Creating Hierarchies; Writing DAX Functions, Measures & Calculated Tables; Using Row & Filter Context. Data Modelling: Kimball & Inmon Methodology; Normalisation to Third Normal Form (3NF); Minimising data redundancy; Designing Dimensional Models with Conformed Dimensions. Star, Snowflake and Waterfall Data Models. SQL Experience in writing SELECT Queries in SQL Server 2012/2016, ACCESS 2016 & Power Query. Good Knowledge writing SQL queries containing FROM, WHERE, GROUP BY, HAVING and ORDER BY Clauses, Using Joins, Aggregate Functions, Mathematical Operators, Sub Queries, Union Clauses, Common Table Expressions (CTEs), using CREATE, INSERT, SELECT INTO, UPDATE and DELETE, using variables, conditional logic (IF Statements), and Loops. Excel/Excel VBA: Excel Developer; Excel VBA Expert; Excel Dashboard Design; Process Automation; Excel Templates
MS Excel, VBA and SQL. Experience has tended to concentrate upon IT and databases, with exposure to Common End-user Software / Core Office. Overall offers 16 years work experience, 9 of which for leading banks.
• A proven track record of strong analytics and stakeholder’s management skills. • Strong written and verbal communication skills; coupled with strategic influencing and negotiating skills. • Knowledge of data analytics tools, such as SQL, VBA & Excel integrated with excellent business acumen. • Creative and lateral thinker with keen attention to detail. • Well organised and able to prioritise workload in line with tight deadlines and work effectively under pressure. • Evidence of building internal networks to influence change. more