One tree One life
USA
Python, PySpark, Databricks, Azure, PowerShell, Data Factory, Workday Studio, PyCharm, Databricks CLI
Design & Innovation
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.
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)
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.
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.
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
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.
Our detailed and accurate research, analysis, and refinement leads to a comprehensive study that describes the requirements, functions, and roles in a transparent manner.
We have a team of creative design experts who are apt at producing sleek designs of the system components with modernized layouts.
Our programmers are well versed with latest programming languages, tools, and techniques to effectively interpret the analysis and design into code.
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.
We have well-defined, robust, and secure launch criteria that offer us a successful implementation clubbed with detailed testing, customer acceptance, and satisfaction.
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
We are the right choice for integrating all systems into a centralized one. With the right tool, approach, and skillset, our experienced professionals are best at migrating your legacy code and data to modern platforms.
This website uses cookies to ensure you get the best experience on our website. Learn more