Dolby Vivisol LtdIMT Systems Engineer
May. 2013 - Mar. 2016GatwickI lead a small team who were mainly dedicated to Database administration and Report generation.
• Was Lead Developer in a Data Migration project from a Legacy ERP System to SAP/Bespoke ERP.
• Database Maintenance tasks including, but not limited to, automated Database backup and restoration, Index Optimisation, Data Integrity Checks, Replication across datacentres.
• Developed ETL from multiple Data sources using SQL Server Integration Services and MS BIDS into Reporting server with requirements for redundancy and failover automation. • Generated reports for Internal and External (NHS) Customers in SQL Server Reporting Services, deployed and administered through Web interface and version controlled using Team foundation server.
• Developed Ad-Hoc tools in ASP.net interfacing between the operations teams and the Production Database.
• Created Stored Procedures to generate Datasets and manipulate data within ERP database were ERP Software could not accommodate Operations requirements.