Go Green One tree
One life
Trees
Loading...
Client-Business-Goal

Client’s Business Goals

The client was keen to migrate all their systems onto a single unified enterprise application with latest technologies, for better management and maintenance. The chosen unified solution was Workday – best-in-class application for finance, HR and more.

Key Challenges

There were a few challenges that were sorted:

Workday API's complex & large XML responses

Client needing reusable & dynamic code to reduce development efforts

Shutting down multiple applications and migrating to Workday using Big Bang approach without impacting business & users

Workday integrations

New technology (PySpark & Workday's inbuilt XXLT code base)

Our Approach

Looking at the challenges faced by the client, SPEC INDIA defined four teams.

Data migration team for carrying out data migration activities – pulling data from Power BI reports, converting them into workday-acceptable formats, and sending data to the workday.

Data integration team taking care of all Workday-to-Workday integrations & third-party to Workday integrations. All these integrations to be built in Workday Studio and keep running at defined intervals.

ETL team takes care of pulling data from Workday, transforming & processing data, and sending processed data to a data warehouse for reporting purposes. Most of the ETL development is done in Azure Databricks and scheduled in Azure Data Factory.

Reporting team to generate Power BI reports for Biz Ops and other stakeholders.

Our Solution

The project was to replace third-party applications (from different vendors & for different purposes) with one enterprise application (Workday).  The client was using different SaaS-based applications for HR, Finance, Project & CRM modules which were a bit costly and required more support efforts and cost.

We got legacy data from Power BI models for data migration activities, migrated to Databricks for faster processing of data, Python & PySpark technologies for data extraction and processing, Workday Studio for integrations, and Power BI for reporting. We approached Azure as a cloud platform.

Key Inclusions

Data migration from legacy applications to Workday

Explore Workday's public web API to send & receive Workday data

Migrate legacy applications code (from U-SQL) to Databricks (PySpark)

Write Workday integrations to sync data within systems

Retrieve & process Workday data (HR, Project & Finance data) in Azure Databricks through PySpark technology

Create Power BI reports from processed Workday data for BizOps people

Workday - Human Resource
Worker Personal & Contact Information
Worker Compensation Data
Worker Job Information
Worker Leaves & Time off
Worker Costing Allocations
Worker Utilization & Availability

Workday - Project
Project Details
Project Hierarchy
Project Plan & Tasks
Resource Forecast
Resource Plan
Customer Contracts
Project Revenues Lines & Schedules
Project Role Assignments

Workday - Finance
Journals & Journal Entries
Journal Budgets
Currency Conversion Rates
Expense Items
Supplier Invoices
Account Sets
Journal Sources

CS-CTA-1

Are There Multiple Systems You Wish to Integrate into One?

Our well-thought-of integration solutions and methodologies are perfect to suit your requirements and ensure no data loss or mismanagement of information. We value your data and ensure a unified portal that can take care of all systems from a centralized location.

Contact Us

Technologies & Tools

Python-Logo
Python
PySpark-logo
PySpark
Databricks-logo
Databrick
Azure-Logo
Azure
PowerShell-logo
PowerShell
Azure-Data-Factory
Data Factory
Workday Studio-logo
Workday Studio
PyCharm-logo
PyCharm
Databricks CL-logo
Databricks CLI

Our Process

Research-icon
  Research/Analysis

Our detailed and accurate research, analysis, and refinement leads to a comprehensive study that describes the requirements, functions, and roles in a transparent manner.

Design_icon
  Design

We have a team of creative design experts who are apt at producing sleek designs of the system components with modernized layouts.

Code_icon
  Coding

Our programmers are well versed with latest programming languages, tools, and techniques to effectively interpret the analysis and design into code.

Testing
  Testing

Quality is at the helm of our projects. We leave no stone unturned in ensuring superior excellence and assurance in all our solutions and services.

Launch_icon
   Launch

We have well-defined, robust, and secure launch criteria that offer us a successful implementation clubbed with detailed testing, customer acceptance, and satisfaction.

Business Benefits

Reduced application cost

Reduced support efforts and cost

One application for all data

Latest technologies & platform

Less maintenance & support

Improved user experience

Smooth and effective business process execution

Robust reporting features

Let’s get in touch!