Hire VBA Developers & Contractors in Thames valley | LynxPro
Find VBA Developers in Thames valley
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.
I am a highly motivated and hard-working VBA Developer who enjoys solving problems applying creativity and imagination to everything I do. I have achieved a high academic standard throughout my university and college courses with a significant amount of time spent in designing and developing software applications. Experience at work helped me to develop strong analytical and problems solving skills along with a high attention to detail which will be imperative in a development environment.
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