Colin Kish Email & Phone Number

Yarm, Gb

York, England, United Kingdom

Leeds, United Kingdom

• EROS Project Deliverables: Support and Maintain Data Interface between Application and Data Warehouse/Tableau Visualisation Tool, implementing robust data models, ingest and transform complex data structures into the Data Visualisation Platform• Developed, delivered, supported, maintained and governed a robust data pipeline to transform source data into an XML format to be consumed by an API. Extraction of XML; transforming the data firstly into a relation format and subsequently into a de-normalised format as required for SSRS or Tableau Visualisation to industry best practices• Specified and built SSRS operational reports for various businesses areas based on end user requirements• Developed large data volumes and near real-time ETL (SSIS) data pipeline design for the complex Data Visualisation and Data Warehouse platforms

Leeds, West Yorkshire, United Kingdom

• Provided GDPR Data Compliance; communicating and engaging members from various parts of the business (developers, testers, managers, stakeholders), reporting progress, highlight risks and manage blockers• Supported the completion of a GDPR project, working as part of a team or be self-sufficient as required. Provide expert and proficient knowledge of working with T-SQL and SQL Server 2017 and understanding any advantages provided the project• Reduced DB footprint, implement a generic real-time configurable T-SQL data purge framework, consult with development teams as required

Middlesbrough

• Managed and governed the design and build of high volume, high complexity database solutions across a technology range• Full-stack database developer from architecting solutions, to designing, implementing, testing and refining• Primarily used SQL Server, MySQL but also Vertica and Netezza, responsible for designing (Kimball Method), building and maintaining complex single customer view data warehouses and ETL for high profile international clients• Led the delivery of complex ETL solutions, ingesting client data from various sources (Dynamics 365, Flat Files, etc…) data cleansing, data exports and complex marketing calculations, segment, and analysis (SSRS) in a dynamic client-led organisation with tight deadlines• Designed and built an automated Relation to JSON conversion solution ETL framework using dynamic complex MySQL via a flexible configuration. Allowing for the definition of multiple bespoke RESTful APIs and JSON payloads to be inserted into a document DB. Configured and used Postman for API Call testing• Build a generic Single Customer View (SCV) ETL framework utilising configuration parameters via a dynamic coded framework, Document, and present to stakeholders• Migrated SCV ETL Framework from SQL Server to MySQL, applying MySQL performance enhancement techniques. Ability to learn new systems quickly• Used skill set to manage different database technologies and adapt to the organisation as new technologies and frameworks are introduced. Migrating Clients to new platforms as required. Continually develop new skills and knowledge across technologies • Upskilled off-shore team; trained and mentored a large off-shore team of developers to assist in the development and support of the solutions• Led the Quality Control across the team, implementing coding standards and quality management policies for the other developers to follow

Sunderland, United Kingdom

As a sole SQL Server DBA responsible for all aspects of SQL Server activities including ensuring continual database availability, support and maintenance. Produce MI reporting using SSRS and Excel for Finance, Marketing and Operations Directors. Build and maintain SQL Server Integration Services (SSIS) packages.  Install, configure and provide reports from the Company’s CRM Email software.  Quality and Version Control (using SVN and Source Safe) all software released from the Development Team. Plan and coordinate rollouts to the Production Servers.  Install, Configure and maintain the Company’s internal WIKI and Bug Tracking Management Software utilising a MySQL Database. Build windows 2008 Server, configure as a Failover Cluster and install SQL Server 2008 as a clustered service. Install and configure a Dell EqualLogic SAN. Build and maintain a SQL Server Pre-Production Environment. Troubleshoot and tune any performance problems within T-SQL, Indexes and SQL Server Configuration, using Performance Monitor and SQL Profiler.

Skipton

Working as part of a team of DBAs to provide the accurate and guaranteed delivery of BI and MI reports from the data warehouse to internal and external clients to meet SLA’s.  Design and administer the Data Warehouse (snow flake design) into which data is replicated from the OLTP core system overnight.  Administer SSAS Cube to ensure deliver of BI reports to clients. Attended VB, ADO, and ASP .NET Microsoft accredited training courses. Plan and coordinate SQL Server databases throughout HML to ensure accurate, appropriate and effective use of data, including database definition, structure, documentation, its long-term requirements and operational guidelines. Follow company ITIL standards for incident management and change control. Administer Microsoft Cluster environment on which the data warehouse resides. Participate in Business Continuity Planning (BCP) exercises with external auditors to demonstrate SQL Server disaster recover procedures. Supervise less experienced members of the team and acting up as DBA Manager during their absence. Perform technical interviews for all potential new DBA’s.

Harrogate, United Kingdom

Working as an SQL Server DBA/Developer responsible for the development and administration of multiple SQL Server OLTP databases for the power generation industry.  Implement and version control the release of database upgrade scripts to client sites.  Provide SQL Server and T-SQL technical support for the Company’s Development Team, Support Engineers and the Product Board.  Visit client sites and recommend optimal SQL Server configuration.  Produced a database archiving system with a Visual Basic front end (utilising SQL-DMO and SQL-NS).

Middlesbrough

Working across the full Software Development Lifecycle - design, implementation and administration of an OLTP relational database, including specification of the data model based on the clients’ requirements, Acted as the SQL Server technical lead throughout.  Implementation of database design on SQL Server. Specification and implementation of T-SQL stored procedures to service client software.  Automated database population with client data using DTS. On-going database administration and maintenance duties.

Sunderland, United Kingdom

 Achieved Professional Membership of the Institute for Management and Supervision. Configuration of FIX DMACS SCADA software. Including integration with Visual Basic, Access and Oracle databases. Attended SQL and PL/SQL Oracle training course.

Ucpd - Developing Personalised Business Intelligence Solutions With Power Bi, Power Bi, Dax And M Language, Ucpd

1St Class Honours, Software Engineering

Activities and Societies: Football Team Won BT Prize for Best Final Year Software Engineering Student!!!