Cloud Security Improvement and Optimization on GCP with Application Support Service

By February 6, 2022July 25th, 2022Case Study
Home » Case Study » Cloud Security Improvement and Optimization on GCP with Application Support Service

The Objective:

To improve the foundation and security aspects of the existing Google Cloud environment and provide application support services to the existing data services platform (GCP), Cronacle, Tableau and Thoughtspot applications to provide improved business continuity.

Beam Suntory

Challenges: Improving Cloud Security & Leveraging Cloud Technology

An American multinational company wanted to improve cloud security and perform audit risk of their Google Cloud Platform. They wanted to analyze their current environment and document GCP services and data access patterns. They also required assistance regarding a “cloud first” future state architecture and strategy. 

The Solution: Cloud Optimization, Future Cloud-First Plan

Datametica provided services and a solution to this client by analyzing their current Google Cloud architecture and provided recommendations on best practices on cloud platform security. Additionally, Datametica also provided additional application support for future cloud strategy & roadmap. The details are as follows:

  • Analyzed and documented the current architecture, data storage and access patterns, ETL pipelines, and data source integration
  • Performed gap analysis to identify shortcomings and gave recommendations on future state cloud architecture, ETL pipelines, data model, tools & services and optimization
  • Implemented Cloud Security best practices & processes to address Security and Audit concerns
  • Integration of on-premise Active Directory with GCP IAM services for enabling single sign-on and authorization ID management
  • Analysis of data feeds from vendors and how it should be processed it into a data lake through multiple layers to build reports in Tableau and ThoughtSpot
  • Set up of SAP BW shipment and depletion data extracted into data lake to enable easy access through Tableau
  • Restatement of data on the basis of calendar period or geographic location
  • Reprocessed data due to vendor source system data not matching with Corporate data
  • As per business user request, identified data issues and performed the necessary code changes along with testing and post business confirmation deploy to PROD. Also user provisioning on the basis of request raised
  • Support for data loads during periodic activities like patching, maintenance / outages, upgrades and also taking care of certificate renewals
  • Data validations and Tableau dashboard checks performed on regular intervals to keep data intact which help business users to get correct information all the time
  • Year end cut over activities and all the communication with vendor, and source systems

“Datametica impressed us with their expertise in the Google Cloud Platform. Their team was quick to understand our requirements, cloud infrastructure and business challenges to help us in our cloud-first approach. We appreciate their contribution to our cloud architecture and future Google Cloud Strategy.”

Director, Enterprise Architecture, Beam Suntory

Benefits: Better Cloud Security and IT Performance

  • Improvement in Cloud Security
  • Increase in application availability
  • Decrease in mean-time-to-resolution
  • Incident reduction through problem management
  • Reduction in planned and unplanned downtime
  • Client Dev team can focus on new development tasks

GCP Products We Used

The following GCP products helped Datametica in establishing a solid foundation for our customer:

GCP products

Recommended for you

pelican
Case Study
Pelican Contributed 90% Cost Savings in Data Validation
Learn how Google Cloud helps Retailers leverage their data
Webinar
Learn how Google Cloud helps Retailers leverage their data
Netezza to GCP
Case Study
Netezza to Google Cloud Platform (GCP) Migration

subscribe to our case study

let your data move seamlessly to cloud