Mitsui: Using BigQuery to underwrite critical decisions

About Mitsui

Located in Brazil for 50 years, Mitsui Sumitomo Seguros is a subsidiary of the MS&AD Insurance Group. With branches in more than more than 35 countries, MS&AD is the largest insurance company in Japan. Mitsui Sumitomo Seguros continually tailors their products and services to keep pace with market changes and better serve customer needs.

Industries: Financial Services & Insurance
Location: Brazil
Products: BigQuery

Tell us your challenge. We're here to help.

Contact us

About CI&T

Established in 1995, CI&T is a global digital solutions specialist whose customers include Coca-Cola, Google, Johnson & Johnson, and Motorola. CI&T's skilled teams are trusted problem solvers and experts at mastering new technologies. A Google Cloud Platform Partner of the Year, CI&T is headquartered in Campinas, Brazil with locations across Latin and North America, Europe and the Asia-Pacific region.

Google Cloud Platform results

  • Instantly accesses and analyzes several data sources through a user-friendly reporting interface to support key business decisions
  • Transforms the MSS corporate culture by facilitating data-driven decisions, spurring 40% yearly sales growth

        Background

        For the insurance industry, hard numbers have traditionally driven complex business decisions such as who to cover, what to cover, and at what price. With digital platforms providing immediate and unlimited access to these numbers, the pace of decision-making has accelerated. To stay competitive in this rapidly changing marketplace, Mitsui Sumitomo Seguros (MSS) recognized the need to leverage their available data to stabilize and scale existing operations, improve sales decisions, and better engage employees. Working with CI&T, an enterprise digital solutions specialist, Mitsui Sumitomo Seguros had already begun optimizing its legacy systems and investing in cloud-based analytical solutions.

        Challenge

        MSS managers required frequent and easy access to newly organized data (including performance metrics and market intelligence) to make timely decisions. MSS sales teams needed granular-level knowledge to create what-if scenarios, and analytical tools to diagnose problems and offer a range of policies on tight deadlines to their customers. All of these solutions had to be scalable and affordable, growing as Mitsui Sumitomo Seguros grew.

        Solution

        CI&T advocated using BigQuery for its lightning-fast data processing capability and Compute Engine to power the Mitsui Sumitomo Seguros insights application. The system was easy to install and quick to build. These two Google Cloud Platform products handled all security, scalability, and infrastructure issues, allowing CI&T to focus its resources on developing a user-friendly interface and reporting system for MSS employees. CI&T choose Tableau, a data visualization tool integrated with BigQuery. CI&T was now able to map Mitsui Sumitomo Seguros's business processes and create a system-wide and highly flexible dashboard. Information disseminated through the dashboard helps MSS employees identify the root causes of problems that arise, experiment with data sources to determine which are most valuable for decision-making, and quickly choose what tasks to prioritize.

        "Exploring operational data, monitoring business KPIs or following up on results," says Giuliano Borro, Mitsui Sumitomo Seguros's CIO, "no matter the goal, all the data is provided to the commercial department so they can create their own data view, supporting their core business sales decisions."

        Results

        Mitsui Sumitomo Seguros's senior leadership team praised CI&T's information platform for its simplicity and user-friendliness, with 90% of MSS managers employing the new system every day. New datasets now can be built in hours instead of months using more traditional dimensional cubes. They also can be loaded in seconds instead of hours and can respond accurately to queries with an unlimited amount of data available—unlike the previous norm of a two-year window. Critical business decisions have become completely data-driven, changing the culture of the company, reducing business response time, and sparking sales growth by 40% in a single year!

        mitsui-sales-growth-image

        Tell us your challenge. We're here to help.

        Contact us

        About Mitsui

        Located in Brazil for 50 years, Mitsui Sumitomo Seguros is a subsidiary of the MS&AD Insurance Group. With branches in more than more than 35 countries, MS&AD is the largest insurance company in Japan. Mitsui Sumitomo Seguros continually tailors their products and services to keep pace with market changes and better serve customer needs.

        Industries: Financial Services & Insurance
        Location: Brazil

        About CI&T

        Established in 1995, CI&T is a global digital solutions specialist whose customers include Coca-Cola, Google, Johnson & Johnson, and Motorola. CI&T's skilled teams are trusted problem solvers and experts at mastering new technologies. A Google Cloud Platform Partner of the Year, CI&T is headquartered in Campinas, Brazil with locations across Latin and North America, Europe and the Asia-Pacific region.