We provide IT Staff Augmentation Services!

Workday Integration/ Reporting Consultant Resume

5.00/5 (Submit Your Rating)

Professional Summary:

  • Over 8 years of IT experience in the Analysis, Design, Development, Implementation and Testing in different modules of the ERP systems including over3 years of Workday implementation and production support.
  • Experience in all phases of Workday like Requirements Gathering, Analysis, Design, Development and Testing.
  • Experienced in providing Workday Support (Human Capital Management, Absence Management, Compensation, Performance & Goal Management, Merit, Succession Planning)
  • Experienced in Workday Financials and worked on GL, AP, AR, Fixed Assets, Banking & Procurement modules.
  • Worked on Balance sheet and trial balance reports.
  • Involved in Data Migration/Data Conversions to Workday.
  • Extensive Experience in Workday Reporting. Worked on Workday Standard Reports and Custom Reports.
  • Experienced in Building integration using EIB, DT, Core Connectors, Workday Studio, Cloud Connectors and Payroll Connectors.
  • Strong knowledge on Workday Functional concepts like Supervisory Organizations, Staffing Models, Jobs and Position, Business Processes, Security, Benefits and Compensation
  • Experienced in production support and providing solution for high priority issues.
  • Worked on various HCM/HR modules like Core HR, Payroll, Benefits, Compensations, Time Tracking, Absence Management, and Recruiting.
  • Helped building and maintaining several integrations for vendors such as Cigna, Hartford, MetLife including integration for Servicenow.
  • Experienced and good understanding of XML language XSLT styling, WD - SOAP Web Service, and WD- REST Web Service and experienced in using tools such as Soap, XML Exchanger.
  • Proficient with Workday Compensation including Eligibility Rule setup, Grades & Grade Profiles, Salary & Allowance Plans, Merit plans bonuses and grouping them into Compensation Packages.
  • Experienced with middleware tools such as Mulesoft and Dell Boomi
  • Proficient in writing documents such as business requirements document (BRD), user requirement specification (URS) document and Test documents
  • Extensively worked with Inbound and Outbound Application Engine Programs using File layout and testing.
  • Created Workday Custom reports on both HCM and financial modules. Developed Simple, Advanced, Matrix, Trending and Composite report types using complex Calculated fields.
  • Extensive Functional knowledge in HCM/HR modules.
  • Hands on experience in building inbound / outbound integrations using core connector, Workday Studio, EIB, & XSLT.
  • Worked on Workday Connectors/ Packaged integrations. Developed integrations with Benefit Connectors (CCB), CCW, Payroll Connectors (PICOF and PECI), and Time and absence connectors.
  • Expertise in Application Designer, People Code, SQR, Process Scheduler, XML Publisher PS-Query, Workflow, and Application Engine.
  • Proficient in Module Development, Upgrade, Interfacing, Conversion, Data Migration using People Code and People Tools.
  • Knowledgeable in the creation of complex database reports using SQR, PS/Query and XML Publisher.
  • Strong working knowledge of RDBMS such as Oracle, SQL Server and MySQL.
  • Worked on industry products like PeopleSoft (HCM, ELM, and TAM), Oracle, HP Quality Centre and HP Application Life-cycle Management.

Professional Experience

Client: Confidential,MD

Title: Workday Integration/ Reporting Consultant

Description and Responsibilities:

  • Involved in full life cycle including requirement gathering, analysis, design, development, testing, Implementation, and maintenance.
  • Closely worked with business users to understand and analyze new requirements and offering insight valuable workarounds for the existing production and new functionality insights of the existing application.
  • Designed and Developed Inbound/Outbound Integrations using EIB, Core Connectors and Studio integrations in HR and Finance Modules.
  • Extensively worked on Workday data conversion and data validations.
  • Worked on Reports to create custom reports using Workday Report Writer to meet the business needs of HR, Finance and Payroll application report consumer groups.
  • Created various Benefit, Payroll, HCM and Finance integrations using Workday Connectors like CCW, PICOF, PECI, ADP Connectors, Banking connectors, Finance connectors and CCBs.
  • Configured Workday security roles and groups to the required level of confidentially and segregation of duties.
  • Performed Integrations/reports testing from scripting test cases to execution for all phases of testing (System Integration Testing, End to End Testing, Parallel, UAT).
  • Used instance object transporter to migrate reports, calculate fields from environment to environment.
  • Worked collaboratively across HR, Finance, and IS teams to gain maximum efficiency from the various modules used by HR and Payroll.
  • Applied XSLT transformations to XML Data. Worked extensively on web service integration (SOAP, WSDL, and XML).
  • Used sequence generators, generating templates and validating inbound integration system results.
  • Created and used Calculated Fields in Reporting, Business Processes, Integrations and other areas within Workday.
  • Created complex studio integration which is an inbound and outbound integration which loads new Withholding Orders in to workday and sends back a notification to ADP.
  • Configured Security domains and Security groups that secure access to integration templates and integration systems web service operations, report data sources, report fields, and custom reports are secured to various security domains.
  • Configured Workday security roles and groups to the required level of confidentially and segregation of duties.

Technical Environments/Areas:

Workday Studio, Workday BIRT, Workday EIB, Core Connectors, Document Transformation, Calculated Fields, Workday Report writer, XML, XSLT.

Client: Confidential , Summit, NJ

Title: Workday Integration/ Reporting Consultant

Description and Responsibilities:

  • Involved in full life cycle including requirement gathering, analysis, design and development.
  • Responsible for leading the technical and functional activities related to the company’s HR system (Workday) implementation designed and developed custom integrations and reports.
  • Designed and Developed Inbound/Outbound Integrations using EIB, Core Connectors and Studio integrations in Finance Modules.
  • Lead the offshore team and work on day - day production issues and work with business and vendors to resolve issues with data and posting of files.
  • Worked on benefits open enrollments and created reports and build integration as per the client requirements.
  • Built the outbound integrations as per the vendor requirements.
  • Created reports and integration from scratch for WorldAware and other vendors to provide the using full file and change file that needs to be scheduled daily, weekly and monthly run.
  • Created a complex inbound integration between SAP Field glass and Workday to hire employees.
  • Built the integration to share the employee data between workday and Servicenow.
  • Experience in building both inbound and outbound integrations using EIB, Workday Studio and other Workday delivered templates.
  • Provided support for new and existing integrations including SAP integrations.
  • Worked on middleware tool Dell Boomi.
  • Worked on creating reports for ACA IRS requirement and vendor’s requirement.
  • Worked on conveyed employee’s data request for client and built the advanced report along with EIB and DT to produce the data for the requested employees from date f hire till the date of termination.
  • Worked on HCM Integrations and Supported on Recruitment Integrations.
  • Worked on Workday Payroll integrations.
  • Worked closely with vendors such as Cigna, MetLife, Hartford, Express Scripts, Merrill Lynch etc. while building new integrations, open enrollments and providing support for existing benefits integrations.

Client: Confidential Health Insurance

Title: Workday Integration Consultant

Madison, Wisconsin

Responsibilities:

  • Involved in implementation of Workday FSCM and worked on GL, AP, AR, Fixed Assets, Banking & Procurement modules.
  • Involved in implementation of Workday HCM for various HR modules such as Time Tracking,Benefits, Absence Management, Payroll and Compensation.
  • Developed couple of integrations to perform period end closing.
  • Worked on various banking integration for Bank of America, Barclays and Wells Fargo.
  • Worked on various payments this likes cash, Wire, Sepa, and CHAPS and also inbound bank statements BA12 Template.
  • Worked on Balance sheets and trial balance reports.
  • Analyzed Business and Integration requirements.
  • Hands on experience in inbound/ outbound integrations Using Core Connector, managingbusiness processes, working with EIB, Report Writer, Creating Workday Calculated Fields and Custom Reports.
  • Designed and built both inbound and outbound integrations in various segmentsof Workday system using EIB, Workday Studio, Core Connectors and Cloud Connectors.
  • Developed Various Custom Reports (Simple, Advanced, Composite and Matrix) in HCM andFinancial areas.
  • Created new integration to pull the new hires information using Core Connector Worker andDocument Transformation which uses connector integrations XML Output as its data sourceinput.
  • Data configuration in Workday using Core Connectors.
  • Worked on the Calculated fields used in the Core Connector Integrations and resolved theissues occurred.
  • Involved in writing Test Plans, Test Scenarios and Test Cases.
  • Worked on middleware tool Mulesoft.
  • Tested different types of Benefits integrations during Workday implementations includingCloud Connect for Benefits (CCB), Enterprise Interface Builder (EIB).
  • Created complex custom reports with multi-layered calculated fields and used these as basisfor Enterprise Interface Builder (EIB) and Document Transformations.

Client: North Confidential Health Systems

Title: Workday Integration Consultant

Description and Responsibilities:

  • Developed Complex inbound/Outbound integrations using EIB, connectors and Studio(SOAP/REST Workday Web service calls)
  • Developed Various Custom Reports (Simple, Advanced, Composite and Matrix) usingcomplex calculated fields.
  • Maintained integration and Report scheduling and Business Processes.
  • Worked on post-implementation support and enhancements.
  • Responsible for Workday release enhancements and updates.
  • Created and Maintained integration and Reporting Documentation (Technical design Documents and FDDs).
  • Worked on Compensation eligibility rules creation, compensation plan, create compensation package etc.
  • Developed Complex Integrations using Workday Studio and Core connectors/DT.
  • Configured templates for Cloud Connect Benefits (CCB) and Cloud Connect Payroll (CCP).
  • Used XSLT transformations, SOAP/REST Web service calls, Encryption/Decryption Techniques and sequence generators in integration systems.
  • Converted Workday Standard reports to Custom reports and modified them according to business needs.
  • Coordinated with Vendors, Business owners, BAs, PMOs and other technical team’s to develop and maintain integrations and reports.
  • Experience in using the XML, XPATH, WSDL and XSD. Ability to write XSL transformations to transform the web service (SOAP) requests to meet their requirements.
  • Created advanced reports and used those reports as RAAS (report as a service) REST calls to extract data from workday to studio and use it as perthe integration requirements.
  • Worked as a core member of Workday Update team and providing feedback and documenting the process to help in future updates of the system.
  • Generated an App Engine processes for loading HCM Base tables with the detail obtained from flat files and using file layouts and component interfaces.
  • Developed advanced reports wherein I had to use different business objects and related business objects in developing awaiting steps in performance business processes.
  • Worked on setting up scheduling of reports and understanding the required permissions for report sharing.
  • Worked on setting up security on reports, performing specific authentications on reports.
  • Optimized use of existing reports by creating optional and required prompt values.
  • Worked on developing the reports for business partners for specific purposes.

Client: Confidential, Dover, DE

Project: 9.1 to 9.2 Upgrade

Title: Upgrade Specialist

Description and Responsibilities:

  • PHRST is the Human Capital Management (HCM) component of the Confidential Enterprise Resource Planning (ERP) system and FSF is First state financials.
  • PHRST system is an integrated software application consisting of four modules within Oracle (PeopleSoft): Human Resources, Benefits, Payroll and Time and Labor
  • Central payroll operations for all state agencies, school districts, charters schools, and higher education institutions
  • Apply routine PeopleSoft system updates
  • Analyze and provide functional and system support for Benefit and Salary Plans
  • Integrated workflow with First State Financials (FSF)
  • Worked on AP Related Enhancements and Work Order Customization in Requisition and Procurement
  • Working on Confidential PHRST and FSF upgrade from version 9.1 to version 9.2
  • Conversion of all custom Crystal reports to SQRs
  • Conversion of customized delivered crystal reports to BI Publisher
  • Working on adding the new Ethnic Categories to EEO4 Reports using PSN/vision which includes the EEO-4 Jobcode Count,EEO-4 Status Report by Jobcode, Terminations and Separations by Sex and Ethnic Group, EEO-4 Status Report, EEO-4 Status Report w/Seasonal and Temporary Employees.
  • Developed custom records, pages and Components to meet the Business Requirement.
  • Conversion of reading custom reports using BI Publisher
  • Working independently and maintaining the design documents for updated notes on changes made to the reports
  • Preparation of Technical Design document, Unit test case documents
  • Developed new Records, Online Pages, and Run Control Pages using PeopleTools for the specific needs of the company. Implemented PeopleCode for online validations and user interface.
  • Extensively involved in the analysis and retrofitting the existing People code, SQL’s, SQR’s, Application Engine’s and other PeopleSoft impacted objects.
  • UsedSTAT 5.8.0 for Migration

Client: Confidential, Atlanta, GA

Project: PeopleSoft 9.2 HCM &ELM Support

Title: Developer

Responsibilities:

  • Customizing existing PeopleSoft functionality as per user requirements.
  • Developing inbound, outbound interface to receive and send data from PeopleSoft HCM 9.2.
  • Worked on resolving issues with workflow approvals & AWE issues.
  • Developed custom pages for the maintaining GM agreements and storing GM specific Learning management fields.
  • Worked on crystal Reports, SQR, XML publisher. converted Crystal to Bi publisher and SQR
  • Developed custom application engine programs to inactivate the courses, learning paths etc.
  • Used PHIRE migration tool for migrating the projects across different PeopleSoft instances.
  • Created custom reports using BI publisher.
  • Preparation of Technical Design document, Unit test case documents.
  • UAT, cut over support and post production support.

Environment: PeopleSoft 9.2, People Tools 8.53, Oracle 10g, Windows, UNIX.

Client: Confidential of South Carolina, Columbia, SC

Project: Implementation and Customization of PeopleSoft HRMS 9.2.

Title: PeopleSoft Consultant

Responsibilities:

  • The project involved implementation, customization of PeopleSoft HCM (HR, Payroll, and Benefits).
  • Gathered requirements, designed, developed and tested application enhancements.
  • Played key role in development of Interfaces using SQR’s, Application Engine.
  • Developed custom reports using SQR and XML Publisher.
  • Created custom approval process using Application Workflow Engine (AWE) for terminations.
  • Designed and developed an SQR process to generate files, containing all checks issued and reversed, to be used for Account Reconciliation.
  • Developed an Application Engine program to generate a file (biweekly or annual) containing hours worked in Terminals to be used for staffing and budgeting purpose.
  • Developed an automated process to calculate and load adjusted salary used to determine life and disability benefits for commissioned employees using Application Engine and Component Interface.
  • Created a SQR process to load the file containing Short Term Disability monthly payments from Hartford. Developed custom objects to store short-term payments made to employees.
  • Resolved various issues with Time Admin runs.
  • Designed and developed a custom process to enrol employees in Time and Labour using Application Engine.
  • Developed a Reconciliation process to report variances between Reported time and Payable time using SQR.
  • Created Test scripts and executed various test cycles for System testing and parallel testing.
  • Developed custom reports needed per the client requirements using PS Query.
  • Worked in a Production Support role to resolve issues related to Payroll processing.
  • Provided quality documentation including Design Documents, and Test Scripts.

PeopleSoft Senior Specialist - PeopleSoft HCM

  • Requirements Analysis for new Change requests.
  • Development and Retrofitting.
  • Integration and System Testing Support.
  • UAT Support for Job change transaction
  • Deployment
  • Support bug fixes and issues reported in Job change transaction, Termination
  • Status reporting to Confidential & Confidential Communication Management.
  • Extensively involved in the analysis and retrofitting the existing People code, SQL’s, SQR’s, Application Engine’s and other PeopleSoft impacted objects.
  • Developed new Records, Online Pages, and Run Control Pages using PeopleTools for the specific needs of the company. Implemented PeopleCode for online validations and user interface.

Environment: People Soft HRMS 8.8/9.1, People Tools 8.45/8.51, Windows, Application Designer, People Code, SQR, SQL, PS/Query, Crystal Reports, Oracle 10, PL/SQL.

Confidential, Altamonte Springs, FL

Project: Development of PeopleSoft Financials, HRMS and Front Office.

Title: PeopleSoft Developer

Responsibilities:

Reporting & Customizations

  • Involved with functional team to gather technical and reporting specifications and information for customizations and designing reports.
  • Worked on various People Tools such as Application Designer, Application Engine, Maintain security, Object Security, Process Scheduler, Process Monitor, PS Query, nVision, and Tree Manager.
  • Modified and tested various SQR interfaces like General Ledger activity, Posted Journal summary and Journal entry details
  • Designed an nVision report, which shows Revenue by Worksite for Business Unit, Products, and Departments by period. The report lists about the details of the revenue for each account in details by period.
  • Designed an nVision report, which gives the monthly summary of total revenue by product for the given period.
  • Designed an nVision report, which gives the Revenue for Department/Location by time spans. This report mainly summarizes about the revenue of each and every staffing office around the US to monitor the marketing leader’s business.
  • Modification and development of new reports and queries using SQR, Seagate Crystal Report, nVision, Tree Manager, PeopleSoft Query for analysis, data integrity, reconciliation of the flow of data among modules of PeopleSoft
  • Designed a Crystal Report, which captures Lost Orders for each Business Unit, Product and department by period. The report lists about the details of the lost orders and their contacts
  • Designed a Crystal Report, which captures Open Orders for each Business Unit, Product and department by period. The report lists about the details of the lost orders and their contacts

Interfaces

  • Generated a report using SQR to display the error data in the file sent by the carriers by comparing with the system tables.
  • Developed new SQR Report, which gives the business unit breakdown of vendor information along with the total amount paid during the year.

Project Name: PeopleSoft 9.1 Upgrade

Client: Confidential, Troy, MI

Role: Technical Developer

Responsibilities:

  • Involved in all steps of admin, development and most of the parts of PS 9.1 Upgrade.
  • Generated Compare Reports between 8.8 Production and 8.8 Demo to identify customizations.
  • Involved in decision process of customizations and suggested users in keep/drop decisions.
  • Extensively involved in the analysis and retrofitting the existing People code, SQL’s, SQR’s, Application Engine’s and other PeopleSoft impacted objects.
  • Implemented single sign-on for various benefit vendors.
  • Retrofitted the Time & Labor rules.
  • Retrofitted the departmental security and permission lists using Tree Manager.
  • Created new roles and permission lists for user’s security and followed Corning methodology to migrate to production and maintained documents for audit.
  • Worked on integration between People soft and third party application Oracle Identity Manager (OIM) to retrieve User Profile data.
  • Tuned conversion SQL’s to decrease the execution time which helped to minimize the cutover time.
  • Involved in the production cut over plan and Go-Live activities.

We'd love your feedback!