Linkedin

james.schuler@swoonstaffing.com

Data Optimization

by

Project Details

  • Identified opportunities for leveraging data throughout the company
  • Mined, analyzed, cleaned up & combined disparate databases into one database
  • Developed & monitored custom data models, algorithms & predictive modeling
  • Developed processes & tools to monitor & analyze model performance & data accuracy

Business Outcomes

  • Leveraged data to drive critical business solutions
  • Optimized & improved product development, marketing techniques & business strategies
  • Improved customer experiences, revenue generation & advertising targeting

On-Prem to Web-Based Migration

by

Project Details

  • Migrate on-prem Med-Web application to browser-driven web-based application to decouple vendor from software & hardware dependencies
  • Design & develop a core functionality & front-end for screens related to benefits, member switch, claims, & member restrictions
  • Design & create various data converters & valuators in the web component layer for masking functionalities for HIPAA
  • Manage ongoing security support: create user accounts & set up user rights on web applications

Business Outcomes

  • The web-based application successfully decoupled users from maintaining local Med-Web software copies on their system; instead, users can connect to a centralized browser-driven application

Supply Chain Digital Transformation

by

Project Details

  • Identified specific pain points in the current supply chain, point of sale (POS) & inventory processes
  • Consolidated process for inventory optimization (from many disparate steps down to a clean, efficient process)
  • Organized, sequenced & synchronized Warehouse Management Systems (WMS)
  • Corrected gaps in ordering process & overhauled payment processing system
  • Turned all retail locations into shipping centers by creating real-time coordination of the POS & inventory systems

Business Outcomes

  • Reduced inventory holding costs while improving inventory stocking & turns, & creating quicker & less expensive customer shipping options
  • Personalize customers’ web experience & sent real-time text deals to attract them to nearby locations
  • 2021 revenue increased 19% to $9 billion

Cloud Migration

by

Project Details

  • Self-service environment allowing users to bring their own data for analytical & reporting purposes
  • Write back capability to increase data governance posture & visibility of data lineage
  • A new CDC model making use of Snowflake Stream & tasks for Type 2 Slowly Changing Dimensions (SCD) (mainly to capture & track deleted records)
  • Column-level (data masking) & row-level security
  • Reporting Tableau dashboards for monitoring compute cost, storage usage, long-running queries, RBAC structure & SSE object creation

Business Outcomes

  • New environment reduced IT resourcing, storage & compute costs
  • Increased data governance, security & visibility of data lineage
  • Data masking allows for the ease of new user bulk onboarding
  • Detailed reporting allows for cost reductions utilizing available usage from different Snowflake accounts

Transforming Business Operation through Cloud Migration for a Healthcare Technology Company

by

Client Overview

Our client is a leading healthtech service provider based in the United States – with a special focus on medication access. Their main goal is to connect patients with the right medication sources, so they host an extensive repository of patients’ and allied health professionals’ data.

They use electronic prior authorization (ePA) mechanisms to verify patient prescriptions and deliver them post-verification to facilitate this process. To ensure that their current platform is free to use, they partner with pharmaceutical companies, pharmacy benefit managers, and insurance companies to fund and enable these access programs.

Collaboration Goals

The main goal of our collaboration was to help our client transform their existing data infrastructure to create a more purpose-built data platform.

Here are a few objectives we had to fulfill:

  • Migrate their existing data infrastructure to Azure Cloud
  • Remove any redundancies in their current system and tighten up their infrastructure to enable smooth functioning
  • Optimize the costs of using Azure services while aligning with their business objectives
  • Improve the security and compliance standards of their infrastructure to ensure better protection of patient and provider data
  • Educate and train their in-house team on how to use the new tools and systems for better business productivity
  • Ensure that the business transformation project is done keeping future needs in mind

Why Swoon Consulting

Swoon Consulting has experience not only in the data analytics space but is also equipped with deep talent resources. We have a range of consultants adept at varying technologies—with deep domain expertise across the entire data stack. For this reason, they were confident in our abilities to help them migrate to the cloud. Moreover, Swoon Consulting has extensive experience handling successful cloud migration and digital transformation projects. We had demonstrated our capabilities previously when it came to owning technical strategy right from design through successful delivery—with respect to Azure Cloud migration.

How Swoon Consulting Helped

As our client was planning a large data migration project to support the growing needs of their company, they needed a partner to guide them through it. 

Our first step was to understand our client’s goals and how external support could help them achieve these goals. While their primary need was to create a purpose-built data platform, they also needed additional technical support and subject matter expertise to build it.  Our goal was to create a data platform that reduces their on-prem load, provides extended functionality, and is easy to maintain.

Knowing they had to migrate to the cloud, they had already tried and tested the lift and shift approach. But, it turned out to be an unsuccessful attempt, given the depth of their operations.

Drawing on this experience, we provided the client with a consulting approach and a team with expertise in handling complex Azure Cloud migration projects for a diverse set of clients.

Within two weeks, we finalized a project team and mapped out three project phases:

  • Taking historical data out of their on-prem footprint and migrating to the cloud
  • Building a data center for new sets of data
  • Analyzing what needs to be rebuilt

Project Outcomes

After examining our client’s unique business requirements, we devised a migration roadmap and recommendations list that would best support them. Bringing Swoon Consulting’s technical expertise into play, we were able to help them transform to Azure Cloud.

Moreover, we also helped them do the following:

  • Incorporate SQL, Postgres, Data Lakes, and Data Factory in their cloud infrastructure
  • Helped them design and build a new multi-cluster BI platform using Tableau
  • Helped them with their Kubernetes expansion
  • Performed a cost analysis for the Azure Cloud platform to optimize potential inefficient spending
  • Set up a new set of security standards for the infrastructure—critical to their operations as they store patient health information (PHI) and are required to be compliant
  • Created a set of recommendations for Cloud foundations and installed automation for future deployments
  • Trained their entire staff on best practices of cloud usage and troubleshooting as needed

Reimagine Your Data Today

If you’re looking to transform your business operations, please reach out to our team.

Reimagine your data

Contact Us
Swoon Consulting
© 2022 Swoon Consulting