Andrew Mcclure Email & Phone Number

Greater London, England, United Kingdom

This was a varied role withing the risk and analytics team combing the following tasks:Review the team’s core SQL Server databases for configuration and performance issues, documenting and making the appropriate fixes to improve reliability and scalability. Catalogue and document data assets in Microsoft Purview, from various sources including Microsoft Fabric, ADF and SQL Server on Azure VM. Design and implement the team’s first Microsoft Fabric workspace. This involved researching all available functionality, to understand any limitations and to define the most appropriate design focusing on reliability, ease of use, scalability and running costs. The data sets added to Fabric came from a variety of sources including blob storage and SQL Server on Azure VM. The data processing methods trialled included ADF pipelines, Fabric pipelines and Fabric notebooks using python and Spark SQL. The various methods of adding Fabric items into source control were also trialled along with the use of Fabric’s deployment pipelines.

London, England, United Kingdom

Lead data engineer of a team responsible for designing and developing a data solution to prepare and publish data for a new Tableau reporting suite. The Tableau reporting suite was to be fully automated from the point of data loading all the way through to publication and was replacing the existing manual excel management/ stakeholder reports.Liaising with senior stakeholder and financial mangers to gather requirements for all reports and understand the complex business logic used to build the required report metrics.The report data was prepared using static and financial (FP&A) data from Horizon, OneStream, and Anaplan systems. The data was ingested using scalable data pipelines with complex transformation logic and data quality checks, then loaded into the data warehouse using a start schema optimised for analytics and publication.I was responsible for setting up and managing DevOps for source control, continuous integration, and the deployment process.The report data was prepared using static and financial data from Horizon, OneStream, and Anaplan systems.I was responsible for setting up and managing DevOps for source control, continuous integration, and the deployment process.

London

Lead data engineer of a team responsible for designing and developing a data hub to provide two business functions. The first to streamline the migration of property asset data from multiple sources into the Yardi Voyager asset management system. The second to create integration data pipelines for processing nightly ETL extracts from Yardi for a data warehouse.This involved designing and developing an ETL Transformation tool to convert static and financial data from source systems (Bluebox, Yardi, Sun, Tramps) to target systems (Yardi) in the form of ETLs. This tool validated the extracted data to provide data quality reports for source systems, provided missing mappings reports, and then performed over 200 data quality checks on the transformed data. It also provided full End to End testing of financial data once imported into the target system to ensure the migration was complete and accurate with audit documentation.The project was managed using agile methodology in Jira, with source control and release management using DevOps and GitHub.

Working within a team responsible for upgrading SQL Server 2005 databases to SQL Server 2014, I am responsible for converting approximately 60 DTS packages to SSIS packages. The initial conversion process used DTS xChange software to convert the DTS packages to SQL Server 2005 SSIS packages, and then upgraded to SQL Server 2014 packages using Visual Studio and SQL Server Data Tools (SSDT). The packages were then re-worked to take advantage of new SSIS functionality to simplify processing and improve error handling. Configuration files were used to simplify deployment to different environments. I am also responsible for defining and documenting the testing and migration process, this has included tracing and updating all the execution methods for the original DTS packages (scripts, stored procedures and SQL agent jobs).

As the senior developer/ dba, I was responsible for the full life cycle of a project to develop a complex telecommunication’s billing and reporting system, which would be entirely hosted in the Microsoft Azure environment with self-service reports / Dashboard via a portal. This role involved producing detailed design specifications, security audits, business continuity plans and disaster recovery plans. An important objective of the project was to keep on going costs to a minimum and this meant testing many different database configurations and techniques within Azure to find the best balance between cost and performance.I managed a small team of developers who were responsible for developing and implementing the final design, initial unit testing and finally user acceptance testing with the client. I finally set up the support infrastructure and developed the required processes to ensure all SLA, RTO and RPO requirements would be met.Key skills in this role: • Database – Microsoft Azure SQL Database V12, Microsoft SQL Server 2016• Azure Products – Azure SQL Database, Virtual Machines, Data Factory, VPN Gateway, File Storage, BLOB Storage• Advanced T-SQL development/ testing (Stored procedures, Functions and views)• Physical Design from business requirements.• Unit and integration testing using scripts.• Virtual servers.• Source control and release management with Team Foundation Server.• Automation with PowerShell scripting.• Development and maintenance of applications (C#).

Milton Keynes, United Kingdom

Working with a small team to continue the development and testing of a new mortgage calculator programme which was required to replicate the functionality of a third-party application currently in use. This was then used to identify discrepancies and calculate any remediation payments, if required. My role involved loading multiple files daily from different data sources using SSIS packages through an ETL pipeline. Complex calculations within stored procedures\ functions were required to handle all potential scenarios within an individual mortgage account. I liaised directly with technical consultants at the third-party supplier as well as subject matter experts within the bank to understand the current and correct handling of different mortgage account activities, and documenting the business and technical requirements of these. I developed an automated batch suite to process the required number of accounts to calculate account discrepancies which could then be displayed using SSRS reports. I also developed SSRS MI reports to calculate summary KPI information for weekly senior stakeholder meetings to allow monitoring of overall project budgets.Key skills in this role: • Database - Microsoft SQL Server 2014/ 2008 R2• Advanced T-SQL development/ testing (Stored procedures, Functions and views)• Unit and integration testing using scripts.• Implementation using release management scripts.• ETL (SSIS).• Reporting (SSRS).

Maidenhead

As the senior developer/ dba, I was responsible for the full life cycle of a project to develop a complex telecommunication’s billing and reporting system, which would be entirely hosted in the Microsoft Azure environment with self-service reports / Dashboard via a portal. This role involved producing detailed design specifications, security audits, business continuity plans and disaster recovery plans. An important objective of the project was to keep on going costs to a minimum and this meant testing many different database configurations and techniques within Azure to find the best balance between cost and performance.I managed a small team of developers who were responsible for developing and implementing the final design, initial unit testing and finally user acceptance testing with the client. I finally set up the support infrastructure and developed the required processes to ensure all SLA, RTO and RPO requirements would be met.Key skills in this role: • Database – Microsoft Azure SQL Database V12, Microsoft SQL Server 2016• Azure Products – Azure SQL Database, Virtual Machines, Data Factory, VPN Gateway, File Storage, BLOB Storage• Advanced T-SQL development/ testing (Stored procedures, Functions and views)• Physical Design from business requirements.• Unit and integration testing using scripts.• Virtual servers.• Source control and release management with Team Foundation Server.• Automation with PowerShell scripting.• Development and maintenance of applications (C#).

Milton Keynes, United Kingdom

I was responsible for replacing existing manual Excel PPI calculation spreadsheets, with an automated batch process that involved extracting the required data from various Oracle databases and calculating the PPI refunds using complex algorithms in SQL Server stored procedures. The itemised refunds were then stored in a SQL Server database and presented using SSRS reports. I was responsible for the complete design and implementation of the project; including liaising with all involved stakeholders to gather the business requirements and then translating the solution into a technical specification document. Once developed, I managed all unit / acceptance testing and final release to users.Key skills in this role: • Database - Microsoft SQL Server 2008 R2• Advanced T-SQL development/ testing (Stored procedures, Functions and views)• Unit and integration testing using scripts.• Implementation using release management scripts.• ETL (SSIS).• Reporting (SSRS).

Newbury

I was solely responsible for the design and implementation of the new MVNO (mobile virtual network operator) wholesale bundle billing system for Vodafone, whilst also performing the DBA role for their existing SQL server databases. This billing system was required to process millions of CDR records from disparate systems on a daily basis. The process involved data validation, transformation, exception reporting, auditing, complex algorithms for billing individual mobiles, and archiving data to the data warehouse for reporting and revenue assurance. I was responsible for upgrading the existing databases from SQL Server 2008R2 to SQL Server 2014, this required particular attention to cater for the CLR moving from version 2 to version 4. I also implemented source control for all the SQL Server databases using Team Foundation Server.Key skills in this role: • Databases - Microsoft SQL Server 2014/ 2008 R2• Advanced T-SQL development/ testing (Stored procedures, Functions and views)• CLR development/ testing (Stored procedures, Functions)• ETL (SSIS)• Reporting (SSRS & Excel)• Query performance tuning• Unit and integration testing using scripts • Implementation using release management scripts.• Source control with Team Foundation Server• Database security

I was a SQL developer at Cincom Systems LTD (via XPert 360 Ltd) involved with the design, development and implementation of a large global corporate web application for Konecranes. This application was used to configure complex crane systems, and managed the whole workflow process from initial configuration, technical drawing, offer documents, contract documents and integration with SAP to start the manufacturing process.The technologies involved were WPF, WCF services and SQL Server2008R2 database, and the system was developed using agile methodology. Key skills in this role: • Database - Microsoft SQL Server 2008 R2• Advanced T-SQL development/ testing (Stored procedures, Functions and views)• CLR development/ testing (Stored procedures, Functions)• XML processing using Xquery and CLR.• Physical Design from business requirements.• SCRUM Team development• Unit and integration testing using scripts.• Implementation using release management scripts.• Source control with Team Foundation Server.• Development and maintenance of WCF services (C#).

Farnborough

I was a member of the DBA team responsible for monitoring and managing in excess of one hundred SQL Server instances. These instances were running varied versions of SQL Server (2000, 2005 and 2008R2) and the critical instance were using Clustering, database mirroring and log shipping.I was the DBA within a team responsible for the migration of their corporate SAP implementation on an Oracle database to SQL server. I worked closely with the server, network and storage team along with a Microsoft consultant to design the complete configuration of database and application servers following Microsoft best practice and guidance. This was a corporate critical application and required the implementation of a clustered environment for high availability and database mirroring to a separate datacentre for disaster recovery requirements.Key skills in this role: • Databases - Microsoft SQL Server 2000, 2005, 2008 R2• Installing and configuring SQL Server instances• Log shipping and Database mirroring• Reporting (SSRS)• ETL (SSIS)• Virtualised servers• Source control with Team Foundation Server.• Monitoring using System Center Operations Manager (SCOM)

Newbury

Reporting directly to the company’s IT director I had sole responsibility for the entire SQL Server database estate within this data analytics company in the mobile telecommunications sector. My role included the design of large enterprise SQL Server databases, design and implementation of back-up and disaster recovery plans and 24/7 production support ensuring SLA requirements were met or exceeded. This main system processed millions of records from disparate systems on a daily basis. This process involved data validation, transformation, exception reporting, auditing, and archiving data to the data warehouse. I was also responsible for documenting company procedures and managing project budgets and deadlines.Key skills in this role: • Installation and configuration SQL server 2000 /2005/2008 databases• 24/7 on call support• Backup/Recovery• Database security• Query performance tuning• Advanced T-SQL development/ testing (Stored procedures, Functions and views)• Log shipping• Database mirroring• Reporting (SSRS & Excel)• ETL (SSIS)• SAN configuration and supportOther skills: • ASP.NET website development• Windows Server configuration• Active Directory • MS Exchange 2003 support

A solution provider for many blue chip organisations, particularly the retail fuel industry. I joined this company as a Cobol/Mainframe programmer and later cross-trained to become a SQL server developer. Ultimately working as the team leader of an efficient roll-out and development team, working on a Global Web Application (CRUSO) for Exxon Mobil. I joined this project in its prototype stage and was continually involved as it evolved to become a high-availability critical application. I was responsible for making the necessary databases and web changes to expand the system and bring further sites/interfaces into the application. I liaised directly with our customers in order to produce design specifications to meet their business requirements and provide them with budget and timescale estimations. My team developed the code and carried out unit & integration testing, implementation and support. I was also responsible for managing the budget for this project and for overseeing the work-load of each team member.

Mechanical Engineering

Education record

Education record