BLUESMITH INFORMATION SYSTEMS LTD

Cloud Data Mart, Big Data and Allied Services

We are experts in designing, building and populating Data Marts and Data Warehouses using a Kimball or Inmon approach. Using our Agile Data Warehouse methodology we’ll analyse existing datasources, and build new reporting systems which provide Business Intelligence and insight from your existing databases, documents, files and other data sources.

Features

• Consultancy and support through design, build, test, cutover and go-live
• High performance data load and partitioning for 24x7 incremental updates
• Both private and public cloud infrastructures are supported
• Deep expertise in Databricks, dbt, Azure Data Factory and PowerBI
• Vast experience of building datamarts, data warehouses, and disparate data-sources
• Expertise in other platforms e.g. Ingres, Oracle and NoSQL databases
• Custom dashboard and custom ETL experts
• Data migration and data cleanse consultancy on structured Big Data
• Data mining, data engineering, data mart, data warehouse consultancy support
• Access to our extensive Business Intelligence and Big Data expertise

Benefits

• Improved OLTP performance and improved security
• Rapid return-on-investment through improved business insights
• Capitalise on cloud platforms' massive data storage and analysis capabilities
• Methodology brings rapid ROI and early business benefits
• Enables exploitation of Amazon Web Services and Google Cloud Platform
• Enables exploitation of the Microsoft Azure platform
• Rapidly turns existing data into accessible information
• Enable Business Intelligence reporting, fraud detection and profiling
• Intuitive visualisation of your data
• DevOps approach

£475.00 to £925.00 a unit a day

• Education pricing available

Service documents

• Pricing document

  PDF

• Skills Framework for the Information Age rate card

  PDF

• Service definition document

  PDF

• Terms and conditions

  PDF

Request an accessible format

If you use assistive technology (such as a screen reader) and need versions of these documents in a more accessible format, email the supplier at projects@bluesmithis.com. Tell them what format you need. It will help if you say what assistive technology you use.

Framework

G-Cloud 14

Service ID

212661103606970

Contact

Rich Smith
01138313131
projects@bluesmithis.com

Planning

• Planning service: Yes
• How the planning service works: Planning is undertaken by the dedicated Project Manager who is assigned to the project. They work in close consultation with the client and their key technical staff to develop the key elements of the plan. ; ; Initial consideration is given to the type of project being undertaken: Lift and Shift, Consumption of existing PaaS and SaaS services or Re-architecting for the Cloud. Based on these approaches, key outcomes and success criteria are identified against which the projects can be measured.; ; Most of the projects we undertake are run utilising agile development principles, typically over a series of two weekly sprints. During the initial Sprint 0, a backlog of tasks is generated in close consultation with the Product Owner. These tasks are then sized using a basic ‘T’ shirt sizing approach – small, medium and large and estimated timings applied to give an overall estimate of the project duration. ; ; Each sprint is preceded by a planning session in which tasks from the remaining backlog are identified as appropriate for inclusion in the next sprint. A MoSCoW approach to prioritising tasks is taken to identify which tasks are to be included. Progress / burn rate is monitored closely by the project manager.
• Planning service works with specific services: Yes
• Hosting or software services the planning service works with:
  • Azure
  • AWS

Training

• Training service provided: Yes
• How the training service works: Although we don’t view ourselves as a training company, being good at training our own staff is fundamental to the way we operate. People are our only assets, so we have taken a great deal of time to develop our training approach to yield the best possible results. ; ; Within our organisations we have two tried and tested training pathways. The first for Software Engineers and the second for Data Engineers. Each pathway is made up of a series of assisted self-learning modules that guide an individual from the basics to fundamentals of their chosen engineering discipline. Their training is supported by a dedicated mentor and training manager who supports them throughout the course. ; ; We don’t market these training modules independently but many of our clients have taken advantage of these training courses. Client’s staff have attended our offices to undertake selected training modules in support of the projects on which we are working with them.
• Training is tied to specific services: Yes
• Services the training service works with:
  • Azure
  • AWS

Setup and migration

• Setup or migration service available: Yes
• How the setup or migration service works: Setup and Migration work also take place alongside the planning activities in Sprint 0. In this sprint we aim to establish the key technical and governance elements required to undertake the project.; ; Technical Setup includes tasks such as: Setup of user ids, spin up of environments, establishing and proving connections between systems and via firewalls, agreement and development of the deployment approaches, setup of testing frameworks etc.; ; Governance Setup includes agreeing timings of Huddles, Sprint Planning Sessions, Retrospectives, Status Reporting and Project Review Meetings etc.; ; A key element of most projects during this stage is to establish the overall approach to security and information management. Consequently, we aim to engage with the client’s Information and Data Security teams at the earliest possibility to ensure all decisions are aligned with the client’s required practices.; ; Migration projects also require specific considerations around the timing and approach to migration. Here decisions need to be made around whether the approach will be staged or ‘big bang’, the length of parallel running - if this is possible, as well as the validation approach to ensure the migration has been successful.
• Setup or migration service is for specific cloud services: Yes
• List of supported services:
  • Azure
  • AWS

Quality assurance and performance testing

• Quality assurance and performance testing service: Yes
• How the quality assurance and performance testing works: Ensuring high quality is at the heart of everything we do. To achieve this, we have a comprehensive set of standards for nearly everything, and everyone in the company is trained to operate to those standards.; ; Quality Assurance is achieved though comprehensive peer review processes aligned to an approach to utilise automated testing wherever practical. We make significant use of tools with built-in test frameworks to ensure regression testing becomes a continuous process and we look to build reusable pipelines that not only speed up development times but minimise the volume of code that needs testing. ; ; Performance Testing is major discipline in its own right. Projects would typically establish a set of Non-functional requirements for performance at the beginning of the project. At key points in the deployment of the project, testing would take place to see how well the system performed against those requirements. Tests undertaken usually involve Load, Stress, Spike, Soak and Volume, with mitigations then being devised for any tests that did not come up to scratch.; ; It is usually also necessary within the context of Performance Testing to undertake additional tests that measure the endurance of the system i.e. tests covering: Recovery, Failure and Resilience.

Security testing

• Security services: No

Ongoing support

• Ongoing support service: Yes
• Types of service supported:
  • Buyer hosting or software
  • Hosting or software provided by a third-party organisation
• How the support service works: Ongoing support is usually provided as part of initial warranty service just after go-live often while we are still engaged in on-going development phases or as a separated negotiated call off support service after we have completed an assignment. ; ; Support levels up to 24 by 7 can be agreed per order in line with customer needs, with initial response times as low as one hour, during support availability periods. Full incident escalation processes are available. Support is available via the following channels – online, service desk, on-site, phone and email.; ; In many cases this support includes incremental enhancement to include new features, and integration with new and replacement systems. Support is delivered primarily remotely from our Leeds location supplemented by a part-time on-site presence at any UK customer premises as dictated by the agreed service level.

Service scope

• Service constraints: None

User support

• Email or online ticketing support: Email or online ticketing
• Support response times: Support levels up to 24 by 7 can be agreed per order in line with customer needs, with initial response times as low as one hour, during support availability periods. Full incident escalation processes are available. Support is available via the following channels – online, service desk, on-site, phone and email.
• User can manage status and priority of support tickets: No
• Phone support: Yes
• Phone support availability: 9 to 5 (UK time), 7 days a week
• Web chat support: No
• Support levels: Support levels up to 24 by 7 can be agreed per order in line with customer needs, with initial response times as low as one hour, during support availability periods. Full incident escalation processes are available. Support is available via the following channels – online, service desk, on-site, phone and email.

Resellers

• Supplier type: Not a reseller

Staff security

• Staff security clearance: Conforms to BS7858:2019
• Government security clearance: Up to Developed Vetting (DV)

Standards and certifications

• ISO/IEC 27001 certification: No
• ISO 28000:2007 certification: No
• CSA STAR certification: No
• PCI certification: No
• Cyber essentials: Yes
• Cyber essentials plus: Yes
• Other security certifications: No

Social Value

• Social Value:

  Social Value

  • Fighting climate change
  • Equal opportunity
  • Wellbeing

  Fighting climate change

  Bluesmith has a published Carbon Reduction plan and is committed to achieving Net Zero emissions by 2040.

  Equal opportunity

  Bluesmith Information Systems Limited (Bluesmith) is committed to encouraging equality, diversity and inclusion among its employees, and eliminating unlawful discrimination. Bluesmith is an equal opportunity employer and is committed to maintaining equal opportunities for all its employees regardless of sex, race, age, colour, creed, national origin or sexual orientation. All employees of Bluesmith are expected to act in accordance with it's Equality, Diversity nd Inclusion policy.

  Wellbeing

  Bluesmith has a dedicated mental health facilitator and trained mental health responders and a place to share resources and discuss wellbeing issues on a dedicated channel.

Pricing

• Price: £475.00 to £925.00 a unit a day
• Discount for educational organisations: Yes

Service documents

• Pricing document

  PDF

• Skills Framework for the Information Age rate card

  PDF

• Service definition document

  PDF

• Terms and conditions

  PDF

Request an accessible format

If you use assistive technology (such as a screen reader) and need versions of these documents in a more accessible format, email the supplier at projects@bluesmithis.com. Tell them what format you need. It will help if you say what assistive technology you use.