Sai Kiran Darapureddy
Rochester,NY
Summary
- Over 9+ years of IT experience specializing as a Workday Integration Developer, with expertise in Reporting, Integrations, and HRMS modules.
- Expertise in Workday Studio, EIB, Core Connectors, PECI (Payroll Effective Change Interface), BIRT, Report Writer, Complex Custom Reports, Calculated Fields. and Document Transformation.
- Skilled in SOAP, REST web-services, APIs, XML, XSLT, EDI, PGP encryption, Workday Studio and Mulesoft Anypoint Platform.
- Expertise in developing inbound and outbound integrations between Workday and external systems like ServiceNow, SAP, AlertMedia, Salesforce and Identity Management Systems.
- Hands-on experience with API-based integrations (REST/SOAP) for seamless interoperability with other systems.
- Designed and implemented complex integrations in Anypoint Studio, focusing on Dataweave, API-led connectivity, and service orchestration across diverse systems.
- Successfully designed and deployed 15+ enterprise integrations achieving seamless connectivity across systems and improving data processing efficiency by 80%.
- Proven ability to troubleshoot and resolve integration errors and performance issues.
- Strong collaborator, with experience working across cross-functional teams to deliver Workday integrations and Mulesoft solutions.
- Excellent troubleshooting and production support skills, ensuring seamless integration delivery and operational excellence.
- Ability to work independently and in Agile team environments.
Overview
10
10
years of professional experience
Work History
Sr. Integration Developer
Constellation Brands Inc.
Rochester, NY
11.2017 - Current
- Primarily focused on building and supporting complex Workday integrations (Studio, EIB, Core Connectors, PECI/PICOF), with additional experience developing APIs and integrations using Mulesoft.
- Collaborated with HR, Payroll, Benefits, and external vendors to gather requirements, troubleshoot integration issues, and ensure seamless data flow across Workday and third-party systems.
- Developed and maintained integrations using Workday Studio, EIB, Core Connectors, and Workday Web Services (SOAP, REST) to support payroll, benefits, and HCM processes.
- Built Open Enrollment integrations for benefit vendors (e.g., Kaiser, Delta Dental, AON, UHC and VSP Vision).
- Developed complex custom reports as input for EIB, & core connectors integrations using calculated fields, attributes, integration maps, field override, delivery & retrieval services.
- Designed and implemented Core Connector and Document Transformation (DT) to convert XML output into various formats, such as CSV, Fixed Width, Flat files and Pipe-delimited.
- Designed and deployed Core Connector and Workday Studio integrations for employee data feeds, organizational updates, and job/position changes.
- Integrated Workday HCM with downstream systems (e.g., Active Directory, SiVale, SpaceIQ, Fusion, Kronos) to maintain accurate and real-time worker records.
- Supported Workday releases (March/September), and Tenant Refresh cycles by testing integrations and making necessary updates for compatibility.
- Utilized Reports-as-a-Service (RaaS) for integration with third-party vendors and automated SFTP file transfers.
- Built BIRT layouts for offer letters, severance letters, and check printing, aligning output with client branding and compliance needs.
- Developed and supported PECI (Payroll Effective Change Interface) to transmit employee changes (hires, terminations, compensation updates, LOA, etc.) to external payroll vendors like Meta4, ensuring accurate payroll inputs.
- Used Workday's Integration System User (ISU) accounts and roles to maintain secure integration access and audit compliance.
- Developed API-led connectivity solutions (System, Process, Experience APIs) using Mulesoft to integrate Workday, ServiceNow, SAP, and other enterprise systems.
- Developed scalable Mulesoft API integrations to retrieve employee profiles via Workday's Get_Worker web service, improving data retrieval efficiency by 30% and enabling real-time synchronization across enterprise systems.
- Developed Dataweave mappings for API transformations and implemented basic system APIs to expose Workday data securely.
- Managed day-to-day support for Workday Reports and both Workday & Mulesoft Integrations, ensuring seamless operations.
- Provided post-production support, troubleshooting issues with EIBs, Cloud Connectors, and Workday Studio integrations.
Workday Integration Developer
Walmart
Bentonville, AR
06.2017 - 10.2017
- Involved in requirement gathering, design, development, and successful delivery of integration solutions across multiple projects.
- Developed workday outbound and inbound integrations using EIB (Enterprise Interface Builder), Core Connector with DT for changes only file and Workday Studio.
- Experience with Workday Web Services (WSDL, SOAP, REST and WS standards), APIs and technical experience with XML and XLST.
- Configuring studio integration using workday delivered web services.
- Involved in handling data transmissions between workday to/from external third parties.
- Troubleshoot Workday configuration and reporting issues to identify and fix root causes.
- Worked on several calculated fields like Extract Single Instances, Extract Multi Instances, Lookup Related Values, Evaluate expression, True or False Conditions, Arithmetic Calculation, Formatting date fields etc.
- Experience in creating new integrations and supporting existing integrations.
Mulesoft Developer
Farmers Insurance Group
Woodland Hills, CA
01.2017 - 05.2017
- Designed and implemented Mulesoft API integrations using Anypoint Studio and Dataweave.
- Developed RESTful APIs and SOAP-based services to integrate Salesforce and internal systems.
- Creating Flows, Sub Flows, Exception strategy, and DataWeave transformation in Mule configuration.
- Debugged and optimized Mule flows, improving performance and reliability.
- Designed and developed APIs to Implement Experience, process and system layers.
- Worked with Anypoint API Platform on designing the RAML for implementing REST API's.
- Integrated SOAP web services in Mulesoft by importing WSDL files and performing data transformations with Dataweave to meet application requirements.
- Extensively used Mule Debugger to troubleshoot Mule flows and developed MUnit test cases utilizing features such as mocking, verify call, and assert conditions with various data sets.
- Experienced in handling exceptions and implementing error handling strategies.
Associate Software Engineer
Infotech Solutions
Bangalore, India
12.2014 - 11.2015
- Created/Modified database objects like packages, procedures, functions, and triggers and handled errors using Exceptions.
- Designed and developed ETL to pull data from sources such as flat files and load it to the destination database using multiple transformations.
- Implemented data flow tasks, control flow logic, and error handling in SSIS for scheduled data loading and transformation.
- Maintained and developed complex SQL queries, stored procedures, views, and functions in MS SQL server.
Education
Master's - Computer Science
University of Central Missouri
Bachelor's - Engineering
Jawaharlal Nehru Technological University
Skills
- Workday
- EIB
- Studio
- Core Connectors
- BIRT Reports
- Custom Reports
- Calculated Fields
- Cloud Connect
- XSLT
- Mulesoft Anypoint Studio
- SOAP
- REST
- Web Services
- WSDL
- XML
- PGP
- SFTP
- Oxygen
- GitHub
- Postman
- SQL
- PL/SQL
- MS SQL Server
- Mule API Gateway
- RAML
- Dataweave
- Agile Methodology
- Production Support
- Debugging
- Issue Resolution
- Incident Management
Timeline
Sr. Integration Developer
Constellation Brands Inc.
11.2017 - Current
Workday Integration Developer
Walmart
06.2017 - 10.2017
Mulesoft Developer
Farmers Insurance Group
01.2017 - 05.2017
Associate Software Engineer
Infotech Solutions
12.2014 - 11.2015
Master's - Computer Science
University of Central Missouri
Bachelor's - Engineering
Jawaharlal Nehru Technological University
Similar Profiles
JOSEPH AMADORJOSEPH AMADOR
Draft Development Director at Constellation Brands Inc.Draft Development Director at Constellation Brands Inc.
Lisa Michele KesterLisa Michele Kester
Senior Manager, Inventory at Constellation Brands Inc.Senior Manager, Inventory at Constellation Brands Inc.
Jason RiversJason Rivers
Facilities Maintenance Mechanic at Woodbridge Winery (Constellation Brands)Facilities Maintenance Mechanic at Woodbridge Winery (Constellation Brands)
DENNIS GERALDDENNIS GERALD
DEV LEAD – SOFTWARE ENGINEER at Excellus BCBS, IncDEV LEAD – SOFTWARE ENGINEER at Excellus BCBS, Inc
Tyrone WilliamsTyrone Williams
Director of Facilities Maintenance at Wesley GardensDirector of Facilities Maintenance at Wesley Gardens