Ian Byles Email & Phone Number

Cardiff, Wales, United Kingdom

Wallingford, England, United Kingdom

Dev/DBA role. Supporting SQL server 2017, mirroring. Developing using Visual Studio 2019 + SSDT and Azure Devops source control (GIT), setup of build and release pipelines for continuous integration and deployment. Integration Services and Reporting Services for DBA SQL server reports.

Swindon

Dev/DBA role. Supporting SQL server 2005 to 2017Developing using visual studio (2017 & 2019)/SSDT and Azure Devops source control (TFS & GIT), setup of build and release pipelines for continuous integration and deployment.Replacement of Access with SQL server.Integration Services for ETL with cloud based Application using Restful API and json.Reporting.

Cirencester, Gloucestershire, United Kingdom

DBA role. Monitoring SQL server instances. Working on migration and update of SQL databases to new hosted data centre with SQL 2017. Advising on and developing SQL Availability Groups, SQL Security, SQL Project dacpac deployment using Visual Studio and Powershell. Migration from SVN(subversion) to GIT source control.

Kingston Upon Thames, United Kingdom

Avantia is an award winning and regulated financial services technology business. We have an audited track-record, and have an excellent reputation in the UK general insurance community. Avantia knows, invests in, and trades on its strength. Our business has built deep expertise and knowledge within the residential property insurance market in the UK. We.

• Clients include:
• Harwood Associates – Information & Communication Technology Consultancy. Various projects on their behalf, private sector.
• Jayelle Consulting – Data Management Consultancy. Various public sector projects on their behalf.
• Alexir Packaging Limited. Crawley.
• Business Link North Manchester.
• UK Trade & Investment - Business Export Advice and Support, London Chamber of Commerce. London City.

Republic of Ireland Debt Collections DBA & Developer, maintaining and developing Collections Delivery System database and offshore call team interfaces. Responsible for the daily data processing to produce call lists, SMS’s and letters for all accounts in arrears. Brought the original delivery time down from around 9 hours to 3 hours. This process.

All Part of Siebel 6 to 7 upgrade program. Conversion of all Access and Excel interfaces connected to Siebel Data using SQL Server 2000, vba, dao, ado.Conversion of Access based user reports to T-SQL in SQL Server 2005.Advise and setup of SQL Server Transactional Replication architecture.Analysis of Siebel 6 and 7 data structure.

• Development Of Pricing, Forecasting And Estimation Systems For Television Marketing and Price Control Department.
• Import Of SAP Sourced Data In Excel Format.
• Flexible Reporting System, All Output As Excel Spreadsheets.
• Environment - Access 2000/2003, SQL Server 2000

Development of “Skillshare” database used to match the skills of Business Advisors with the services requested by Companies. Results returned as a ranked percentage match.o Production of Management Information reports using Views, Stored Procedures & PL/SQL.o Environment - Access 2000 and Oracle 8 on Win NT/2000 & Citrix terminal Server

• Development of in house reporting system to produce ad-hoc user reports and monthly MI reports. (Access 97/2000, Oracle 7, SQL Server 6 & 7)
• Became integrated with small IT team of 3 and provided general cover. Duties included data backup management, SQL Server login maintenance. Oracle schema development, general helpline support.
• Developed Workstation build database system to track the software installed on each workstation and faults logged and fixed. (Access 2000)
• Developed data import and export tool for third party telesales use. (Access 2000, Oracle 7)
• Environment - Access 97/2000 on Win NT

• Joined QIK development team to aid development of call centre software interfacing with BA’s global database for quotes, bookings and space availability for cargo on all BA and partners flights and trucks around the.
• Developed system checker and installer application to check workstation compatibility and install latest version of Call Centre software. (Visual Basic 4)
• Created application to monitor and log Call Centre successful booking percentage and check correct procedures were followed. (Access 95/97, QIK)
• Taught and mentored new internal developers in programming techniques, database and GUI design. Increase in speed of development enabled IT to become more responsive to clients demands for change and enhancements.
• Environment – QIK, Access 95/97, VB 4 on Win 95/NT