Tim Cooke

Tim Cooke Email and Phone Number

Senior Database Specialist at Muddy Boots Software @ Muddy Boots Software
bristol, bristol, united kingdom
Tim Cooke's Location
Bristol, England, United Kingdom, United Kingdom
Tim Cooke's Contact Details

Tim Cooke personal email

n/a
About Tim Cooke

Database architect with Online Transaction Processing (OLTP) and Business Intelligence (BI) implementation experience. Skills: Requirements and process analysis, conceptual and detailed design, relational, conceptual, logical, physical and dimensional modelling of both OLTP (3rd Normal Form) and BI (Star Schema, Kimball Model) databases.In depth knowledge of MS SQL Server architecture with proven experience in database administration (DBA). Skills: Managing OLTP, and BI environments including Installation, Configuration, Maintenance, Patching and Upgrades. Migration, Backup, Recovery, Database Monitoring, Disaster Recovery and data-desensitisation for GDPR. Security management, Logins and Server Roles, Database Users and Database Roles, Certificates and End Points.Highly experienced with Extract Transform & Load (ETL). Skills: Scheduling, deployment and data loading using both Bulk Import and SQL Server Integration Services (SSIS). Wide ranging SSIS Task and Component knowledge and thorough understanding of SSIS flow design. SSISDB and Integration Services Catalogues deployment, management and automation. Service Broker specialist designing asynchronous messaging services. Skills: Message Types, Contracts, Queues and Services, Inter-Sever setup and design, End Points, Certificates, Routes and Service Bindings. Monitoring and Troubleshooting. Designed an Inter-Server setup automation tool including Certificate exchange. Architect of a real-time data warehouse solution using Service Broker.Performance Specialist advising, educating and implementing solutions for performance gain. Skills: SQL Server System Tables and DM Views, Tuning Advisor, Application Insights, Indexing, Profiler and Performance Monitoring. Extensive experience of re-working SQL Code for performance gain.Educator. Have written and presented on numerous subjects including, Reading Query Plans (5 presentations), Temporary Tables, Flexible Filtering and SQL & Entity Framework.

Tim Cooke's Current Company Details
Muddy Boots Software

Muddy Boots Software

View
Senior Database Specialist at Muddy Boots Software
bristol, bristol, united kingdom
Website:
muddyboots.com
Employees:
126
Tim Cooke Work Experience Details
  • Muddy Boots Software
    Senior Database Specialist
    Muddy Boots Software Nov 2017 - Present
    Bristol, United Kingdom
    Eighteen months ago the business recognised there was a lack of SQL Server knowledge, lack of database architecture advice and quickly worsening database performance right across the business so I was promoted into the role of Senior SQL Server Database Specialist with a remit of Education, Architecture and Performance. Over this time I successfully implemented SQL monitoring, highlighting for the teams what databases and code needed attention. I delivered a number of online presentations about Query Plans and Tuning and was the point of contact for the whole business for advice. Over this time I considerably improved application and reporting performance never failing to achieve better than 80% gains in all operations I touched. I Designed and implemented innovative architectures including moving complex business logic away from the SPs where it was slow, repetitive and unwieldy to a middle structure driven by triggers and a two phase agrochemical import architecture allowing both the receipt and consumption of data to be consistent, efficient, robust and repeatable.
  • Muddy Boots Software
    Business Intelligence Product Development Manager
    Muddy Boots Software Nov 2015 - Oct 2017
    Continuing to perform as Business Intelligence Team Leader I became Line Manager for the team members, engaged with the senior management team on business strategy and attended the technical forum. I advised the company on technology to adopt to fulfil its dashboard and reporting requirements. During this time I successfully completed a move away from SSRS and began a similar move away from Logi towards HTML5 in-house developments, this allowed a much more focused relationship between our products and their reporting requirements.
  • Muddy Boots Software
    Senior Database Developer And Business Intelligence Team Leader
    Muddy Boots Software Aug 2013 - Oct 2015
    Bristol, United Kingdom
    Successfully lead a team of four Business Intelligence developers, using Agile methodologies, to deliver a number of successful projects ranging from dashboards and reporting to data warehousing and multi-database consolidation.Delivered new reporting and dashboard functionality for a major client helping them drive sustainability in their supply chains.Created a truly innovative real-time data warehouse with efficient hierarchical data structures to enable application developers to deliver interactive supply chain maps both as a logical tree-view and as pins on a map. The real-time data warehouse was achieved using Service Broker to deliver, process and store changes as they occurred in the application. Changes are delivered asynchronously and the application released immediately thus preventing waits and locks in the database and maximising the users’ productivitySuccessfully delivered a low cost, low effort solution to locating map points for supply chain nodes merely by the addresses supplied. This was achieved by using SSIS to poll the Google GeoLocation API returning best location for an address worldwide. Met the challenge of delivering the consolidation of 121 databases into a single Combined Instance with effective separation logic using SSIS to handle the migration. As a long-time advocate of agile methods I performed the role of Scrum Master for the BI team guiding them through the cycle of refinement, sprint, scrum and retrospective to effectively deliver development work to time and budget.
  • Merkle | Dbg
    Sql Server Developer
    Merkle | Dbg Aug 2008 - Jul 2013
    Responsible for designing, developing and implementing data and reporting solutions for a variety of clients. Over my time at DBG I studied Kimball methodologies and become a significant influence on policy within the department, I am a recognised innovator able to push through improvements in implementation methods. I use my experience to design and develop databases and data-warehouses, getting to grips with ETL, SCD, data matching, reporting, auditing and performance. I brought into the department experience of SSIS, data-matching and email-marketing allowing me to take a lead on SSIS techniques, develop SSIS packages to handle email-marketing data and enhance methods for auditing, error handling and SCD. Proactive at all times I looked for ways in which development time, accuracy, accountability, testing, deployment and performance can be improved. I extended the database automation tools to deliver Insert, Update and Inferred Member stored procedures in addition to the existing Create Table scripts.I helped develop a bespoke SSIS component to handle matching of feed data to dimensions giving me a deeper understanding of how SSIS works, as well as consolidating my experience of data matching. I have developed accurate financial SSRS reports for a well-known car manufacturer and a restaurant chain and towards the end of my time at DBG wrote an interface to FastStats PeopleStage to capture marketing campaign activity.
  • Design Revelation
    Website Designer And Developer
    Design Revelation Aug 2003 - Apr 2009
    Weston Super Mare
    In August 2003 I began a new venture as the owner of Design Revelation, a Website design and development business. Since then I have been involved in developing many small to medium database driven websites.In February 2005 I decided to take up a contract with UBHT in Bristol to provide better security for my family. I continued to support existing clients up until April 2009.
  • Gds International
    Business Systems Developer
    Gds International Dec 2006 - Jul 2008
    Bristol, United Kingdom
    While with GDS I put in place several major systems, identifying systems requirements and either purchasing or developing suitable solutions. I built a coherent database from over 40 spreadsheets of varying quality (about 600,000 records) and supplied tools for the management of the data. My first task was to spec, purchase and install a SQL 2005 database server capable of meeting the need and with room to grow. Next I wrote extensive SSIS packages to handle the transformation of the spreadsheets and cleaning of the data. I then developed .NET front-end tools for data management and reporting tools using SSRS. After researching, purchasing and installing an email-marketing solution that could integrate with the new database, I wrote a series of stored procedures and queries to handle the large volume of updates to the data resultant from email campaigns. I then developed a secure .NET Sales Order Management system and an Excel based Event Management tool.
  • United Bristol Healthcare Trust
    Senior Database Developer
    United Bristol Healthcare Trust Feb 2004 - Dec 2006
    Bristol, United Kingdom
    Working in the UBHT senior HR team I was responsible for developing a series of highly complex tools to perform financial calculations interfacing with existing public sector Finance, HR and Payroll database systems. The tools were rolled out to selected users and have performed excellently. I continued to support the calculation tools until the conclusion of the project. In addition I developed several other Access 2003 Databases and Cognos Impromptu reports with very complex structures successfully delivering workforce and financial information to senior managers and directors. As part of the HR team I was able to demonstrate excellent communication skills. I was a good team player able to liase and operate effectively at any level within the organisation.
  • Azlan Training
    Technical Resources Manager
    Azlan Training Sep 2000 - Apr 2003
    Wokingham, United Kingdom
    I was responsible for leading a small Systems Support team providing fast effective technical troubleshooting and advice to the trainers. In support of this role I developed a live UK wide SQL server database optimised for very slow WAN connections. I developed and maintained Access and SQL databases providing information to technical teams and trainers. I was also responsible for designing and implementing a new network infrastructure for the training centres and developing strategies for logistical hardware management and deployment. I developed support processes and database tools for the training course schedulers and the sales force and streamlined classroom support and equipment provision. Towards the end of my career at Azlan I worked with the European training operations team on a project to centralise high cost hardware helping to define equipment policy/strategy throughout the UK.
  • Azlan Training
    Senior Systems Engineer
    Azlan Training Aug 1997 - Sep 2000
    Wokingham, United Kingdom
    I was responsible for coordinating the smooth running of the Wokingham training centre’s equipment. I developed a large distributed Access 2000 and SQL Server database to record, track and audit high value equipment throughout the UK and Europe. I investigated technical problems as they arose, identifying and implementing solutions as required. I also developed new solutions for the fast deployment of highly complex and technical classroom builds.
  • L.A Rumbold
    Technical Author, Compiler And Illustrator
    L.A Rumbold Jul 1989 - Sep 1997
    Camberley, United Kingdom
    As Technical Author and Compiler I was responsible for writing aircraft component maintenance manuals and service bulletins. As a Technical Illustrator I was producing ink line illustrations and presentation colour airbrush artwork. I studied Access database development and created a database using Access 2.0 and VBA to manage the revision status, publication, distribution and complex relationships of the department’s documents and records. I wrote macros to automate the conversion of old Lotus Manuscript documents to AmiPro, supported the department’s small computer network and provided staff training.
  • Airship Industries
    Technical Illustrator
    Airship Industries Oct 1988 - Jul 1989
    Bedford, United Kingdom
    Technical Illustrator responsible for producing artwork for airship maintenance manuals, parts lists and service bulletins.
  • Oerlicon Logistics
    Technical Illustrator (Fircroft Contract)
    Oerlicon Logistics Oct 1988 - Jul 1989
    Lincoln, United Kingdom
    Technical Illustrator working in a team improving the existing parts list illustrations.
  • Cheltenham Technical Publications
    Technical Illustrator
    Cheltenham Technical Publications Jul 1987 - Mar 1988
    London, United Kingdom
    Technical Illustrator producing ink line illustrations to MOD specifications
  • Rank Xerox
    Technical Illustrator
    Rank Xerox Aug 1985 - Jul 1987
    Welwyn Garden City
    Technical Illustrator producing visual aids and illustrations for photocopier operation and maintenance manuals.
  • Start Ltd
    Graphic Designer And Layout Artist
    Start Ltd Jun 1984 - Aug 1985
    London, United Kingdom
    Magazine designer, layout artist and graphic designer.

Tim Cooke Skills

Sql Data Warehousing Microsoft Sql Server Sql Server Integration Services Agile Methodologies Software Development Business Intelligence Scrum Business Analysis Database Design Disaster Recovery Database Administration Databases Xml Transact Sql Online Transaction Processing General Data Protection Regulation Database Security

Tim Cooke Education Details

  • Ravensbourne Colege Bromley
    Ravensbourne Colege Bromley
    Technical & Airbrush Illustration
  • St Joseph'S College Beulah Hill
    St Joseph'S College Beulah Hill

Frequently Asked Questions about Tim Cooke

What company does Tim Cooke work for?

Tim Cooke works for Muddy Boots Software

What is Tim Cooke's role at the current company?

Tim Cooke's current role is Senior Database Specialist at Muddy Boots Software.

What is Tim Cooke's email address?

Tim Cooke's email address is ti****@****ion.com

What schools did Tim Cooke attend?

Tim Cooke attended Ravensbourne Colege Bromley, St Joseph's College Beulah Hill.

What skills is Tim Cooke known for?

Tim Cooke has skills like Sql, Data Warehousing, Microsoft Sql Server, Sql Server Integration Services, Agile Methodologies, Software Development, Business Intelligence, Scrum, Business Analysis, Database Design, Disaster Recovery, Database Administration.

Who are Tim Cooke's colleagues?

Tim Cooke's colleagues are Stephen Ng'ang'a, Matt Davies, Amanda Williams, Meirion Evans, Faith Kamenchu, David Lawrence-Brown, Netta K..

Not the Tim Cooke you were looking for?

  • Tim Cooke

    Greater Reading Area
    3
    cooke99.eclipse.co.uk, kcom.com, orange.com
  • Tim Cooke

    I Ghostwrite Books For Time-Starved Ceos And Professionals | In 20 Hours We Can Create A Book To Raise Your Profile, Drive Business, And Change Your Readers' Lives | Oxford-Educated Author With Over 350 Books In Print
    London Area, United Kingdom
  • Tim Cooke

    Museum Director
    Stratford-Upon-Avon
  • Tim Cooke

    Chairman And Investor In Multiple Tech Companies.
    London
    3
    devonhurst.com, btinternet.com, it-catalyst.com

    1 +44 196XXXXXXXX

  • Tim Cooke

    London Area, United Kingdom

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.