What We Do
Who We Are
Industries
Technologies
AWS
Azure
Boomi
Confluent
MuleSoft
Snowflake
Software AG
Events
Insights
INSIGHTS
Blog Posts
Industry News and Updates
Case Studies
Recent Projects
Offerings
Project Accelerators
White Papers & eBooks
Insights and Education
Contact
Contact Us

Data Lake Simplifies Integrations for Global Pharma Client

AWS
Cloud & Serverless
Workday
Customer Scenario

Human resource management (HR) is one of the few internal functions that touches every part of a business. That means a wealth of data is available to HR. It also means hundreds of connection points if you are a Fortune 100 company. Our client needed to integrate their Workday HCM implementation with internal and external systems to support the management and talent acquisition activities for 30,000 employees and more than 10,000 contractors across the globe. To accomplish this challenge, the client needed to address three specific integration scenarios: supporting existing integrations, simplify and accelerate partner integration, and reduce the number of custom integrations to the Workday platform.

Solution Approach

The good news was that partners and internal systems used a common set of data. The bad news was that each required custom data formatting, differing frequency needs, and different protocols. By creating a data lake on the AWS platform, we were able to process and store data to enable standardized integration development. By employing a variety of appropriate solutions on AWS - including SNS, Kinesis, Glue, Athena, DynamoDB, and Transfer for sFTP - we were able to take in raw data into an S3 bucket and begin processing it. The data factory created for the project started with raw data and cleansed, enhanced, and tagged the data to streamline information access.

Results

Before the implementation of the data lake, the client struggled with cost-effectively supporting internal and external integrations. This caused a heightened need for IT resources when updates were needed, or new partners needed to be onboarded. After the data lake implementation, the client was able to support integrations with more than 20 internal systems, including portals and authentication requirements, and more than 150 external partners with specialized timing and format needs. HR was also able to generate unprecedented intelligence and analytics on employee performance, risks, andtrends for its global team. As an added benefit, the standardized data access has accelerated the team’s ability to provide ad hoc requests for regulatory and compliance needs.

Big Compass
subscribe

Sign up to stay on top of the latest news.

We've added you to the list!
Something went wrong. Please try again.
recent Case Studies
From Mule 3 to Mule 4: A Government Agency's Journey Towards Secure Integrations to Ensure Safe Water and Flood Control
Leader in Children’s Play Kits Integrates NetSuite, Shopify, and Boomi to Modernize and Support International Operations
MuleSoft Migration Streamlines and Simplifies ERP Business Processes for Manufacturing Client
View All
No items found.

BUILDING CONNECTIONS IN A DISCONNECTED WORLD

Company
What We DoWho We AreEventsCareersContact us
technologies
AWS
Azure
Boomi
Confluent
MuleSoft
Snowflake
Software AG
insights
Blog Posts
Case Studies
Offerings
White Papers & eBooks
subscribe
Welcome to the Big Compass family!
Oops! Something went wrong while submitting the form. Please try again.
© 2020 Big Compass
  |  
Privacy Policy
  |  
Terms of Service