Peoplesoft Consultant Resume
Johnston, IA
SUMMARY
- Over Ten years of IT experience in software design, development and implementation of various commercial applications in Workday, PeopleSoft, Oracle and Visual Basic.
- Extensively worked on Workday data conversion & Workday integrations.
- Experienced in implementing Custom Integration, Packaged Integration and Studio Integration.
- Experienced in Data Migration through iLoad and spreadsheets.
- Provided Project Management Support, Team Building, Cloud Systems Architecture, Mentoring, Systems Analysis.
- Experience in Financial modules likeAccounts Payable, Accounts Receivable, General Ledger, Revenue Management,Asset Management, and Financial Aid
- Developed detail Test strategy, plans and scripts to test specific HCM Compensation business process in HCM
- Developed/Tested User Defined Workday EIB's to enable processing of large - volume transactions
- Expertise in Workday and PeopleSoft HR, North American Payroll, Benefits Administration and Base Benefits.
- Expertise in Workday Security Policies for Payroll, Benefits and Financials Administrator
- Experience in Training the End Users on Job Requisition System, Benefits and Payroll
- Experienced in configuring EIB, building Custom Report, Calculated Fields, and configuring studio integrations using workday delivered web services.
- Defines Test Strategy and Test Approach. Manages the overall test project plan, time tracking, defect management, issue resolution, and risk management.
- Extensively involved in trouble shooting and fixing problems at development, system testing and post-production stages for various HRMS modules
- Expertise in SQL, Eclipse, XML, XSLT, and Web Services technologies.
TECHNICAL SKILLS
WORKDAY SKILLS: Workday HCM, HCM Integrations, Configurable Security, EIB's, Report Writer, iLoad’s, core connector’s and Studio Integrations, NA Payroll, Compensation, Time Tracking, Absence Management, Benefits, General Ledger, Procurement, AM, AP, AR
PEOPLESOFT TECHNICAL: PeopleTools, Application Designer, Data Mover, Workflow, People code, Application Engine, SQR, Crystal Reports, PS Query
DATEBASES: Oracle, SQL server
Tools: Oracle Enterprise Manager, Export/Import, SQL* Loader, TOAD, PVCS.
PROFESSIONAL EXPERIENCE
Confidential, Rochester, NY
Sr Workday Consultant
Environment: Workday 26/25, Workday Studio, XML, Web Services, XSLT 2.0, Report Writer, Oxygen
Responsibilities:
- Provide Knowledge to Custom G/L Integration from Workdayusing Journal Lines data source to send payroll result to Peoplesoft Financial system
- Developed and provided support on Workday Recruiting Inbound and outbound Integrations for ICIMS.
- Provided my knowledge on solving issues with the ICIMS Integrations especially for Job Requisitions, New Hires And Employees Information.
- Worked on third party Payroll Integrations like Safeguard for the Europe, Latin America and other Asian Countries.
- Configured PICIF &PICOF’s to integrate with payroll vendors. create functional specification documentation for various fixes and new enhancements across AR and AP modules.
- Developed and provided my knowledge on solving issues with EIB inbound and outbound integrations.
- Worked on several modules onworkdayreporting includes HCM, Payroll, Benefits Reporting
- Development of Advanced, Matrix, Composite Customreports
- Good Experience inReportDesigning Tool (BIRT) in designing custom layouts to thereport definitions
- Provided Comp my experience on web services for several vendor files.
- Create various integrations and used XSLT code to transform XML data to various files formats and to safely deliver files using SFTP server.
- Thorough understanding in using different APIs for connecting to third party systems
- Involved in Business Process configurations like Staffing, Core Compensation, and Payroll Interfaces etc.
- Configured Cloud connectors for Benefits Integrations for Metlife, Voya, Aon Hewitt Dental and send the files over to vendor.
- Provided support on studio Integrations for Credit Card Authorizations for the Data which includesCurrency, Amount,Merchant Account ID, Merchant Customer Profile, and Merchant Processing ID.
- Developedfinancialreport using Journal lines data source inWorkday
- Created XSLT scripts for Integrations to transform XML data.
- Created various job profiles along with the job profile security group
- Created Custom Security Groups and Custom security Roles., User based Security Groups
- Assigning security domains to the Security Groups
- Created security groups with given references to provide access required for the various Business processes in the system.
- Build own web services by defining customreportsas web service enabled and providing integration solutions
- Created Unlimited Number of plans and budgets forFinancial, award proposal, position, and project budgets with budget checking before transaction approval Provided Mentorship and Design documents for Reports and Integrations.
- Worked extensively using excel spread sheet for workday conversion and matrix report.
- Worked on Domain security policy change control and security policy change control.
- Handling support related tickets using IBM ticketing system to provide reliable and prompt support to provide resolution within time limit as per priority
- Provided support on setting up the entire framework of Time tracking including- Creating Time Entry Codes, Groups, Time Entry Templates and the Business Process for Entering Time, Setting up Period schedules, Worker eligibility rules.
Confidential, Charlotte, NC
Sr Workday Consultant
Environment: Workday 26/25, Workday Studio, XML, Web Services, XSLT 2.0, Report Writer, Oxygen
Responsibilities:
- Worked on Financials modules likeGeneral Ledger, Accounts Receivable,Fixed Assets, Procurement Suppliers Invoices, and Accounts Payable.
- Responsible for gathering and documenting requirements, designing, tracking, reporting and analyzing key organizational and operational reports.
- Provided support to variousfinancial modules focusing on AR, GL and AP modules coordinating with onsite back office personnel technical resources.
- Work closely with Billing, General Ledger and Project Costing team.
- FinancialsEBS implementations, responsible for all development work includingintegration, reporting, data migration, testing and rollout.
- Built Integrations in Workday Financials data module which includes data relative toAccounts, Accounting, Business Plans, Financial Reporting, and Tax.
- Created CustomG/LIntegration fromWorkdayusing Journal Lines data source to send the Post payroll result to Lawson Financial system.
- Design and buildintegrationsand worked closely with Testing and production team to solve the issue withIntegrations.
- Assist business users during month end closing by reviewing and correcting journals and perform reconciliation with subsystems.
- Work closely with the offshore technical resources by reviewing the analysis performed, provide guidance to resolve production issues.
- Worked on Compensation eligibility rules creation, compensation plan, create compensation package etc.
- Developed integrations and functionalreportstoreportout massive data fromWorkday.
- Created customreportsto pull Benefits data into the Benefits Workbook for client
- Built industry standardreportslike ListReports, MatrixReports, Calculated Fields, Conditions and Eligibility Rules that apply to the parameters of thereport.
- Configured templates for Cloud Connect Benefits (CCB) and Cloud Connect Payroll (CCP).
- Worked on Core connectors andworkdaystudio.
- Good working knowledge on Inbound and Outbound EIBIntegrationconcepts and created the various EIBintegrations.
- Worked On data transfer from tenants to SFTP, FTP.
- Experience building and managing integrations with the Workday Integration Cloud Platform-Integration Platform-as-a-Service (iPaaS).
- Experienced in creating Advanced, Medium, complex Inbound/Outbound integrations using workday studio, Core/Cloud Connectors, using EIB's (Enterprise Interface Builder), Document Transformation process.
- Worked on the business process for bonus plan, merit plan, salary plan and hourly plan.
- Configured PICOFs to integrate with payroll vendors.
- Designed regression testing scenarios for the integrations during upgrades.
- Performed arithmetic calculation in Matrix report for counting, averaging, summing, ranging between maximum and minimum.
- Worked on Talent Management, Recruiting, Business reports etc.
- Developed SOAP web services, concur expense management using EIB and Workday Report Writer.
- Worked on testing the data and security issues with the data from the reporting prospective.
- Leveraged robustWorkdayWeb Service API framework to load payroll inputs intoWorkdayviaWorkdayStudio development.
- Involved in Unit Test onIntegrations, UAT Support and End User Training.
- Worked with Performance Management, Pre-hire, Onboarding, Manager Evaluation, Succession Planning reports.
Confidential, Denver, CO
Workday Technical Consultant
Environment: Workday 25Workday 22/23, Workday Studio, XML, Web Services, XSLT 1.0, Report Writer, Oxygen
Responsibilities:
- Involved in Development, Enhancement, Upgrade, Maintenance of HR, Benefits, and Payroll.
- Lead the Technical team supporting Integrations, Reporting, and Production Issues in Workday.
- Designed and built inbound and outbound studio integrations with RaaS reports.
- Developed several reports using Workday Report Writer like Salary Changes, Severance, Payroll Earnings, Medical Enrollments, LTD Participants, Med, Dent, Vision, Salary plan etc reports as part of Implementation.
- Worked on setting up scheduling ofreportsand understanding the required permissions forreport sharing.
- Worked on Compensation Merit Process including Performance Ratings and Compensation Matrix.
- Developedfinancialreport using Journal lines data source inWorkday
- Involved in Payroll Integrations ADP Tax Monthly, ADP Tax Quarterly using Workday Studio
- Developed Several EIB inbound and outbound integrations.
- Created several custom reports and exposed as web services for several vendor files.
- Developed integrations using web service SOAP, XML, XSLT on the Workday cloud platform such as Payroll integration.
- Configured Cloud connectors for Benefits Integrations for Vanguard, Cigna Dental, and Blue Cross IL Medical and send the files over to vendor.
- Involved in Business Process configurations like Staffing, Core Compensation, and Payroll Interfaces etc.
- Created XSLT scripts for Integrations to transform XML data.
- Created Custom Security Groups and Custom security Roles.
- Provided Mentorship and Design documents for Reports and Integrations.
- Worked extensively using excel spread sheet for workday conversion and matrix report.
- Created secure interface between workday and client system created PGP public key to enhance security of the tasks.
- Worked extensively on Business security policies Security for the user
- Recognizing technical resource to maintain security on user-based, role-based, job-based, domain and business processes level
Confidential, St.Paul, MN
Workday Integrations Developer
Environment: Workday 20/21, Workday Studio, XML, Web Services, XSLT 1.0, Report Writer, Oxygen
Responsibilities:
- Involved in Development, Enhancement, Upgrade, and Maintenance of HR, Benefits, and Payroll.
- Lead the Technical team supporting Integrations, Reporting, Production Issues in Workday.
- Designed and built inbound and outbound studio integrations with RAAS reports.
- Developed Payroll Integrations ADP PCPW for U.S., ADP Pay@Work for Canada using Workday Studio.
- Configured Cloud connectors for Benefits Integrations for Superior Vision, Delta Dental and COBRA Enrollment for ADP.
- Involved in Configure Compensation Plans, Bonus Plans etc. in Workday
- Developed Interface for Benefits provider Desjardin using Integration Template for Document Transformation.
- Involved in custom G/L Integration from Workday using Journal Lines data source to send the Post payroll result to Lawson Financial system.
- Build Active Directory Integration with Courion and Granted access to 2 Public Web-Services to update the Username and Primary work e-mail address in Workday.
- Developed several Payroll, Tax, Accounting reports like Payroll Pre-Complete G/L Journal entry Audit, FICA Tax and Expense Audit, Worker US Tax elections etc.
- Created XSLT scripts for Integrations to transform XML data.
- Created Several Custom Reports and calculated fields for Core HR, Payroll and Benefits.
- Created Custom Security Groups and Custom security Roles.
- Maintaining Application Security and conduct quarterly access control review
- Created several custom reports and exposed as web services for several vendor files.
- Provided Mentorship and Design documents for Reports and Integrations.
- Created pivot tables in excel spread sheet using workday reports.
- Creating advanced calculated fields.
- Thesereportshave been in all aspects ofWorkdayincluding core HCM, recruitment, compensation & advanced compensation, benefits, performance management, absence, and questionnaires
Confidential, Dallas, TX
Workday implementation and consultant
Environment: Workday 19/20, Workday Studio, XML, Web Services, XSLT 1.0, Report Writer, Oxygen
Responsibilities:
- Lead consultant for extracting data from PeopleSoft HRMS 8.9 and transforming 22,000 workers into Workday iload/EIB format
- Performed fit-gap analysis for HR setup, configurations and data mapping
- Utilized Workday testing methodology for system development and implementation, developed detail Test strategy, plans and scripts to test specific HCM business process in Workday HCM.
- Developed multi-dimensional reports and analytics with the ability to drill down to transaction-level details.
- Configured outbound Benefit Interfaces using workday cloud Connect for Benefits.
- Developed SOAP Web Services Concur Expense Management using EIB and Workday Report Writer.
- Created Custom report for Benefits and made it as RAAS and scheduled it using EIB.
- Determine the Data Source and use appropriate Business objects to deliver the requiredreportfor the end user.
- Converting Simplereportsto AdvancedReportsby using Calculated Fields, Sorting, FilteringReport Fields, providing Advanced Filtering Option, Creating Sub Filters and by using related Business Objects
- Created Inbound EIB to update Benefit Annual Rates using Web Service.
- Provided mentorship for creating Reports and Calculated fields.
- Configuring secure document deliveries to various vendors ftp servers.
- Scheduling Integration to generate output at particular intervals.
- Created several custom reports for Payroll, Benefits, and Core HR reports.
Confidential, Johnston, IA
PeopleSoft Consultant
Responsibilities:
- Fixed current Payroll issues for Faculty and Staff Employee payroll.
- Configured and customized the Rapid Entry Pay sheet to improve the current data entry Payroll data.
- Developed Payroll Audit queries and reports to conduct the following audit of Payroll System:
- Audit query to run prior to Pay sheet creation to clean up missing HR and Benefit information and provide compensation report for each department though out the campus.
- Audit report to show actual payroll payment and department budget for all incumbents before Pay confirms.
- Install tax updates 12-B, 12-C and 12-D.
- Developed test plans and Payroll checklist for Monthly and Semi-monthly pay run.
- Worked as Payroll SME for current production Payroll.
Confidential, Minneapolis, MN
PeopleSoft Consultant
Responsibilities:
- Defined fit/gap questionnaires and conducted fit/gap sessions in Core HR, Payroll Interface to ADP EV5, Profile Management and Employee/Manager Self-service.
- Defined customizations, upgrade direction, project timeline/resources/cost, and business process improvements to eliminate customizations and understand the new functionality of version 9.1.
- Delivered Upgrade Feasibility study document outlining the direction and recommendations for the upgrade project