
Congruent designed a solution using Google BigQuery and Python as the primary
technology stack.
The client’s people data set from Google BigQuery was downloaded into hash tables. The segment files from partners were downloaded from the FTP folder, unzipped. The data from the two sources was used to arrive at propensity scores for each household member. Members with propensity scores above a set threshold were identified and pushed to the audience builder file in csv format. The csv files were finally uploaded to GBQ using the chunking approach.
Some highlights of the solution design are:
As a global pharmaceutical leader, the imperative is to ensure patient safety through meticulous adverse event reporting — a regulatory requirement to monitor products’ safety post-market. Historically, manual processes hampered the client’s ability to rapidly and accurately report adverse events, leading to inefficiencies and data inaccuracies.
vSaaS Global partnered with the client team to integrate Smartsheet and AI technologies to transform their reporting system, yielding:
Other Smartsheet success stories:
In a strategic move to elevate project delivery efficiency, a large IT PMO organization partnered with vSaaS. Faced with sluggish project timelines and inflated costs, the challenge was to harness technology for streamlined operations. vSaaS implemented Smartsheet, integrating it with JIRA and ServiceNow via API connectors. This fusion not only synchronized project management tasks but also enhanced real-time data exchange, achieving unparalleled workflow efficiency.
Key Outcomes:
Other Smartsheet success stories:
Global PetroChem struggled with a cumbersome new product introduction (NPI) process, with extensive paperwork, siloed communication, and disjointed teams leading to delays and stifled innovation. Partnering with vSaaS, they implemented a digital Smartsheet platform for centralization, automated workflows, collaborative dashboards, and API integration, accompanied by robust change management.
Key Outcomes:
Innovation Unleashed: Focus shifted from bureaucracy to product development innovation.
Other Smartsheet success stories: