Mark Blakey Email & Phone Number

Providing Sql Server Consultancy Services to various clients including:• RBI• Calastone• OCS• Kinetic InsuranceWork entailed multiple Sql Server Consolidation projects, Performance tuning, Business Intelligence, Data Migration, System Scalability , Disaster Recovery, Sql Server Upgrades and on site training.

Responsible for consolidation of distributed Sql Server environment onto Sql Server 2008 • Architecture of end to end Business Intelligence solution using SSIS, SSAS, SSRS and SharePoint, implementing scale out architecture on all service tiers.• Implementation of Kerberos Security configuration across Sql Server & BI stack• Design and implementation of robust Disaster Recovery (DR) and High Availability (HA) configuration across nationwide WAN.• Documentation and Training of Permanent Sql Server Staff• SharePoint development and administration• Performance tuning and stabilisation of overloaded finance and operational systems• Implementation of bespoke monitoring solution within Sql Server environment.• Sql Server Installation, Configuration and Maintenance• Development of logistics reporting data warehouse, data feeds, OLAP cubes and reports using SSIS, SSAS and SSRS.• Development of reports in SSRS to represent core Business KPI’s• Integration of SAP HR system into Active Directory• Performance tuning of overloaded finance systems

Database Administration of multiple high availability databases predominantly in a web based environment.•Configuration and maintenance of Magazine Jobs Advertising platform across multiple publications •Implementation of first generation of Peer to Peer replication in a high revenue website environment.• Troubleshooting replication (Merge, Transaction and Peer to Peer) and DTS\SSIS production issues • System Performance tuning• Database migrations and upgrades from Sql 2000 to Sql 2005. Consolidation on 64 bit Unisys platform• Implementation of network monitoring solution using SSIS• Deployment of Software releases• Implementation of SSIS and Sql 2005 best practices

Responsibile for the administration and development of MI systems. Ownership of Master Data Management System (MDMS) and overall data strategy within Virgin Holidays and Virgin Incoming Services (VIS).• Database Administration of 25 Sql Servers running Virgin Holidays applications• Support and development of Sql Server replication (Merge and Transaction)• Support and development of all SSIS ETL packages used for nightly refresh of data warehouse• Introduction of robust backup and recovery framework for all Sql server databases• Creation of clear step by step Disaster Recovery plan for recovery of Business Critical Applications• Performance tuning of long running reports\batch processes• Database migrations and upgrades (6.5 to 2000, 2000 to 2005)• Rationalisation of security policy to all Sql Server databases for simplified management (AD groups)

Design and development of Insurance Risk\Policy Database for QBE Insurance Group. • Data modelling and systems design.• Development of Stored procedures and triggers for database Auditing system• Development of ETL processes to import data from ICC XML market data feeds into Sql 2000 database.Responsible for the design, development and support of databases used by Thales-ISF’ Credit Risk products within Deutsche Bank and Euroclear.• 2nd and 3rd Level support of Oracle (7.3.4\8.1.7) production database environment at Deutsche Bank.• Backup and recovery of over 50 production and development databases (Oracle and Sql Server)• Database Consultancy for various Thales-ISF clients (Deutsche Bank, Dresdner DKIB, Euroclear)

Design, implementation and support of technical infrastructure used for online payment system.

Graduate Trainee responsible for maintaining MIS database.Development of KPI's and Business DashboardsSystems Administrations