SUMMARY

• A result driven senior professional with 20+ years of IT experience in WorkDay and PeopleSoft ERP.
• Experience in various modules like Core HR, Benefits, Payroll, Absence Management, Time tracking, Compensation, Talent, Performance Management, Staffing along with Authentication, User Security and Integration.
• Served as a Workday Report Writer and created custom integrations with third party applications using Enterprise Interface Builder (EIB) and Workday Cloud Connect.
• Hands on experience in inbound / outbound integrations Using Core Connector, working with EIB, Report Writer, Creating Workday Calculated Fields and Custom Reports.
• Expertise in analysis of client's HR/Payroll business needs through client working sessions and day to day support of Workday HCM, Security, Compensation and Reporting issues.
• Worked with different staffing models, defining Hiring restrictions to Job Management, Position Management and Headcount Management, experience in creating Job Profiles, Job Families and Job Family Groups.
• Developed integration using SOAP/REST web services WSDL, XML, XSLT on the Workday cloud platform such as Payroll integration.
• Created Several Custom Reports on Ad - Hoc and Schedule Basis for Users and Support Team in Benefits, Time Tracking, Absence Management and Payroll including Prism Analytics by converting legacy Tableau reports on external data.
• Strong working knowledge in software development methodologies like Agile, Waterfall across the span of various projects.
• Coordinated and supervised the daily activities of the Workday HR System and act as primary point of contact to monitor and troubleshoot production issues
• Experienced in configuring Compensation framework, providing support and guidance to a geographically distributed workforce and/or HR Business Community to meet client requirements.
• Thorough knowledge of HR processes such as employee record maintenance, Payroll, Benefits, Security, Pay Planning, Performance Management/Talent Management, Time Tracking / On-boarding.
• Developed testing strategies and verification scenarios along with project Scope and requirement documents, diagnose functional issues, report bugs, and take ownership of issue resolution.
• Highly experienced in PeopleSoft PUM upgrades, Bolt-On application development and integration of business software both on-premise and cloud services.
• Hands on expertise with PeopleSoft development tools like Application Designer, Integration Broker, Component Interface, People Code, Process Scheduler, Workflow, AWE, Reporting Tools like SQR, PS/Query and BI Publisher.
• Extensive experience in Configurations, Fluid Pages development and conversion, Tiles, Tile Wizard, Life Cycle Tools like Data Migration Work Bench, Page and Field Configurator.
• Expertise in Managing PTF, AWE set up and configuration, Related Content Service management and design and development of Forms.
• Expertise in Third Party Scheduling tools, ETL tools and Unix scripting.
• Extensive experience in SQL and performance tuning to optimize database queries with a strong knowledge in Oracle PL/SQL.
• Expert in data migration from PeopleSoft to Cloud applications, data cleanup and transformation.
• Expertise in job data management, guided services, onboarding activity guide, position management and hire/rehire/termination of employees and temp workers.
• Strong knowledge in Payroll processing, tax update, on cycle/off cycle runs and monthly/quarterly/yearly Payroll reporting.
• Comprehensive knowledge of Benefit Eligibility rules, Event rules, Benefit Plans, Benefit Rates, Calculation rules, Coverage formula and Benefit Program, job data management, guided services, position management and hire/ rehire/ termination of employees.
• Excellent documentation, presentation and communication skill

TECHNICAL SKILLS

ERP: WorkDay HR, Compensation, Recruiting, Benefits, Payroll, Time Tracking, Security, Reporting, Talent, Performance Mgmt., PeopleSoft HCM, Campus Solution, FSCM, EPM

Tools: and Utilities: SOAP, WSDL, XML, XSLT, XPATH, DT, Calculated fields, Custom reports, Cloud Connects, Core Connectors, EIBs. Application Designer, PS/Query, Approval Workflow Engine (AWE), Process Scheduler, Application Engine, SQR, Bi-Publisher, File Layout, Data Mover, Tree Manager, Component Interface, Excel To CI Application Packages, Integration Broker, Form Builder, Data Migration Work Bench, Related Content Service, Page & Field Configurator, Prism Analytics

Languages: People Code, SQL, PL/SQL, Java, Visual Basic

Operating Systems: Linux, UNIX, Windows, Mainframe

Databases: DB2, Oracle, SQL Server

ETL Tool: Informatica

Change Management: STAT, PHIRE, JIRA

Scripting language: VB Script, Java Script, HTML, Unix Shell Script, JCL

Utilities: Toad, SQL*Plus, WS FTP, Putty, Ultra Edit, CA7, Maestro, Edit Plus, Note Pad++, Win-SQL, SQLTools, SQL Navigator, XML Quire, Beyond Compare, Ultra Edit Compare

PROFESSIONAL EXPERIENCE

Confidential

WorkDay AMS Support Lead Consultant

Responsibilities:

• Experience in configuring various modules of the workday and develop various reports and integrations to meet the business requirements.
• Provided day to day support of workday HR, Benefits, Payroll, Compensation, Time Tracking modules and reporting issues.
• Support legacy system data conversion to WorkDay.
• Involved in HCM Configurations over multiple areas: Compensation, Benefits, Recruiting, Hire/Onboarding, Talent and Performance, Staffing, Time off and Leave.
• Workday Customer support Central point of contact, well versed with creating cases with workday for issues, sandbox refresh exemptions.
• Created new integrations to pull new hire information using core connector worker and delivered using document transformation, which uses core connector XML outputs as its data source input.
• Managed Security configurations for many functional areas and business processes.
• Developed various custom reports for staffing, recruiting, payroll and compensation purposes with complex calculated fields.
• Designed and developed various EIB integrations for data loads and to export the data from Workday to external systems along with data transformation using Calculated fields and/or XSLT.
• Implemented various delimiter based, fixed width, custom XSLT transformations with the use of several functions.
• Provide AMS support to HCM users day to day requests to create, modify, troubleshoot custom reports, integrations, business processes, updating security. Resolving functionality, data integrity related issues, educating users on navigation, functionality matters etc.
• Developed workday custom reports on HCM Data, compensation data, recruiting, absence data and utilized Report as a Service (RaaS) ability to use in integrations.
• Generated matrix reports to support compensation, benefits, HRBP's, payroll and other teams.
• Defining output of report to worklet options or chart options, sharing options, setting up transfer ownerships.
• Created several calculated fields to meet complex reporting requirements using functions like extract single Instances, multiple instance, lookup related value, evaluate expression, true or false Conditions, arithmetic calculation, convert currency, substring text, format date fields etc.
• Used EIB for integrating location of employees, Performance ratings, assigning organizations and updating payroll IDs.
• Created packaged integrations, also Connector (CCW/CCB/CCTPP: PECI) integrations to get/put information using XML, XSLT, XTT, ETV Document Transformation.
• Involved in creating the Technical Design Documents for the Integration's based on the Functional Design Documents.
• Managing Data conversions, HR and Compensation related Custom Reports, Security Management, Business Process configuration and configuring the application according to customer requirements and developing system Integration.
• Developed Inbound and outbound integrations using EIB, Web Services SOAP, WSDL, XML, and XSLT Document Transformation for several integrations from Workday to downstream internal and vendor systems and provided necessary security for related functional area to launch the EIB.
• Hands on experience in inbound/ outbound integrations Using Core Connector, working with EIB, Report Writer, Ad-Hoc Reports, Creating Workday Calculated Fields and Custom Reports.
• Creating the new business processes and notifications in deployment and sandbox tenants based on the designed business flow diagrams.
• Converted Tableau reports that are created using external data sets to Prism Analytics based reports.
• Support Prism Analytics reports on performance and award and foster best practices for UI and graphics team.
• Developed Advanced, Matrix and Composite reports on Prism published data set.
• Working with users to guide them on new features, releases of the workday.
• Prepare Weekly status meeting, Monthly business meeting and Quarterly board review meeting agenda from client side.
• Used sequence generators, generating templates and validating inbound integration system results.
• Worked on configuring Domain Security Policy and Business Process Security Policy.
• Developed test cases and test scenarios to perform UAT, SAT on the newly developed integrations.

Confidential

PeopleSoft / WorkDay Data Migration Lead

Responsibilities:

• Write programs and complex queries to extract data in specified format. Fix data issues as encountered.
• Develop SQR and Application engine programs to generate data output in specified format for WorkDay iLoad.
• Maintain issues log and error reports along with resolutions in error tracking system.
• Use transformations and data field mappings for data migration.
• Experience in configuring various modules of the workday and develop various reports and integrations to meet the business requirements.
• Providing solution to complex technical issues by fixing them in terms of Debugging, Root cause analysis and modifying the code when needed.
• Converted legacy application reports using Workday Report Writer.
• Support implementation team in resolving data issues for workday HCM load.
• Hands on experience in inbound/ outbound integrations Using Core Connector, working with EIB, Report Writer, Ad-Hoc Reports, Creating Workday Calculated Fields and Custom Reports.
• Participated in security review and prepared documentation for Role Based, User Based and Segment Based security.
• Used sequence generators, generating templates and validating inbound integration system results.
• Implemented various delimiter based, fixed width, custom XSLT transformations with the use of several functions.
• Involved in creating the Technical Design Documents for the Integration's based on the Functional Design Documents.
• Managing Data conversions, HR and Compensation related Custom Reports, Security Management, Business Process configuration and configuring the application according to customer requirements and developing system Integration.
• Responsible to educate Business Users on Workday reporting terminology to traditional RDBMS system.
• Trained and support Business Users on building custom reports as per daily need.

Sr. Consultant

Confidential

Responsibilities:

• Set up data feed from PeopleSoft to Oracle Cloud Performance module using HDL Extract. Applied modification to the delivered Application engine as per business requirement.
• Created BI Outbound Report and output file in CSV format for Inbound Payroll integration for Award payments.
• Conversion of Classic Pages into Fluid pages.
• Issue fixes and Classic Plus support for custom modules.
• PUM upgrade support and retrofitting of customizations after upgrade.
• AWE Setups and configuration; develop custom AWE Application Class modules to handle approval workflows for role based approvals.
• Development of Workflow Setup data migration DMS scripts.
• Set up Generic Templates for notifications, email setups for role based email notification execution.
• Develop multi staged approval process with criteria based processing.
• Created Component Interface to load Rapid Entry Pay sheets for Payroll processing of Academic Assistance amounts and implement tax implication for non-taxable and taxable assistance as per IRS rules.
• Security set up for entire module including PS/Query security set up by Query Tree updates.
• Designed and developed new components, pages, records and fields for new bolt on module.
• Rewrite Leave entitlement interface for new vendor to handle change of vendor.
• Applied configuration changes to apply application features needed.
• Customization and retrofit 9.2 PUM 20 image.
• Configured Fluid Settings, Set up Global Search (SES) and Manage Company Directory after upgrade.

Confidential

PeopleSoft Consultant

Responsibilities:

• Prepared functional and technical design documents for custom changes.
• Maintained Third Party Interfaces and Troubleshoot issues reported.
• Modified SQR interface programs to add new benefit programs and plans.
• Reviewed file layout and modify SQR programs to fit in new layouts.
• Updated Benefit SQR programs as per business requirement.
• Testing of interface programs to ensure a match as per requirement specification.

Confidential

PeopleSoft Consultant

Responsibilities:

• Apply Configuration changes to apply application features needed.
• Customize and retrofit 9.2 version as per 9.0 customizations.
• Tested application after PUM patches applied.
• Troubleshoot security issues in HCM and CS environment after split to identify required access for various roles.
• Participated in Security redesign and created new Roles and Permission Lists and assign those to the users, including primary and process profile permission list access.
• Prepared functional and technical design documents for custom changes.
• Maintained Third Party Interfaces in Campus Solution and Troubleshoot issues reported.
• Modified PS/Queries and Create New Queries for changes in records due to Campus Solution HCM split and new requirements stated by business users.
• Created multiple SQR reports for Benefits, Payroll and HR reporting.
• Retrofit pages used to load Contract Information for Payroll processing.
• Developed report to identify Payroll deductions and company contribution based on plan selected for 403B in each Pay cycle.
• Created new PS job to process Contract Pay Calculation before Payroll Pay Calc process and modified delivered Pay Calc Run Control Page.
• Modified delivered Fluid pages as per business requirement. Created new page and component in Fluid to replicate Classic page features as per requirement.
• Converted PS/Query reports to BI Publisher reports.
• Tested Integration Broker syncs between HCM and CS and troubleshoot issues reported.
• Retrofit Payroll and Benefit SQR programs for new version.

Confidential

PeopleSoft Consultant

Responsibilities:

• Prepared requirement documents for custom Bolt-On application module in PeopleSoft HCM.
• Prepared Technical design specification for custom application.
• Understanding requirement and develop PeopleSoft objects including fields, records, pages, components and menu for new PeopleSoft custom module.
• Developed BI Publisher reports and custom notifications as features of new custom application.
• Developed Application Engine batch programs for application updates and notifications.

Confidential

PeopleSoft Consultant

Responsibilities:

• Prepared requirement documents for Data mapping for Conversion processes.
• Mapped Payroll data to defined format for extraction from PeopleSoft to load into flat file.
• Analysed existing PeopleSoft application and prepared functional and technical design for benefit plans.
• Prepared Technical design specification for batch processes for Data Conversion.
• Developed interface programs with third party applications for benefit pension administration plans.

Confidential

PeopleSoft Consultant

Responsibilities:

• Analysed existing PeopleSoft application and prepared functional and technical design for benefit plans.
• Prepare Technical Design Specification documents for online customization, interface and batch programs.
• Developed Components, Pages, Records, Fields, SQLs, Message Catalogue entries, Portal Registry Structures and Menus.
• Developed new class in Application Package and add methods as per technical design.
• Developed Self Service application extension for accessing new benefit plan from Self Service.
• Developed new Application Engine batch program for Coupon and Invoice printing for loan payments