We provide IT Staff Augmentation Services!

Peoplesoft Payroll Business Consultant Resume

2.00/5 (Submit Your Rating)

Deerfield, IL

SUMMARY

  • Around 7+ years of experience in Implementation, Customization, upgradation and maintenance of various PeopleSoft HRMS/ HCM modules such as Core HR, Benefits, Ben - Admin, Absence Management, NA Payroll, Time Labor and Self-Service ESS, MSS, Talent Acquisition.
  • Knowledge and hands on experience in configuring Peoplesoft HCM including Core HR, Benefits, Absence Management, Payroll, Time and Labor, Security, Recruiting, Compensation and Talent modules with proven project delivery through full life-cycle from requirements through deployment / support.
  • Experienced in Business Modeling using MS Visio and Axure, done Requirements Gathering through direct user interviews and workshops. Design, development, and maintenance of MS SQL and MySQL databases for company initiatives.
  • Experienced in all phases of ERP lifecycle - Upgrade, Conversion, migration, Interface, Production/Post production support and troubleshooting of Peoplesoft applications release 9.2,9.1,9.0.
  • Proficiently involved in the implementation of Peoplesoft HCMS 9.1 including core HR, Base Benefits, Benefit administration, Time & Labor, Compensation, North America Payroll, eModules, Absence Management, Talent Acquisition Management, Recruiting Solutions Suite and eLearning modules.
  • Extensive experience in People-Code 8.3, SQR, Application Engine, Application Package, Web Services, Service Operation, Process Scheduler, Workflow, AWE, PS Query, Data Mover, Component Interface, Integration Broker, XML Publisher, Crystal Reports, n-Vision.
  • Developed various Fast Formulas for specific custom requirements in Global HR, Benefits, Compensation, Talent Management Modules and HCM Extracts.
  • Skilled in micro managing build /delivery of key functionality within PeopleSoft Core HR including PeopleSoft HCM - SAP Finance integration, profile management, Staffing, ESS and MSS.
  • Experience in resolving the tickets and/or MECs related to HR/Self Services, Compensation and Security Administration and NA Payroll and managed development of outbound interface to send employee compensation data to external systems.
  • Extensive experience on support and enhancement of people soft HRMS - Time & Labor, North America Payroll, Core HRMS, Manager Self Service, Employee Self-service, Compensation and Profile Management.
  • Extensively used PS Query to develop various queries based on User requirements.
  • Experienced closely with the Compensation team to map the Salary Plans, Grades and Steps for Union and Non-Union Employees, and uploading Employee compensation information using Excel to CI in PeopleSoft .
  • Utilized OBIEE Reports & Dashboards on Core HCM processes (Employee/Workforce details, Hires/Headcount/ Terminations, compensation/Diversity/benefit, Turnover reports & VIP dashboards).
  • Proficient in working with People Tools, Application Designer, People Code, SQR, Component Interface, PS Query, XML/BI Publisher, Data Mover, Integration Broker, Application Package.
  • Extensively involved in HR, NA Payroll, Benefits, Time and Labor, e-Recruit (Candidate Gateway and Talent Acquisition Management), Compensation, Training, Employee Self-Service and Manager.
  • Used application Engine, Excel to CI, Integration Broker, Component Interface, Process Scheduler, Fluid Pages, PS Query, Process Monitor, Data Mover and File Layout.
  • Performed prototype demonstrations for all Talent Management related modules to the Sr. HR Directors as a part of requirements gathering workshops.
  • Experienced in working on PeopleSoft reporting tools like XML PUB (BI Publisher), PS Query and Workflow technology for notification Frameworks.
  • Experienced in Integration Broker services such as Nodes, Messages, Services, Operations, Routings and Queues for automatic updates between PeopleSoft to PeopleSoft applications and Third-Party applications.

PROFESSIONAL EXPERIENCE

Confidential, DEERFIELD, IL

Peoplesoft Payroll Business Consultant

Responsibilities:

  • I have been an active part of the full life cycle implementation that is end to end in terms of Implementation, Configuration and upgradation of Peoplesoft HCM modules from 9.1 to 9.2.
  • Worked with People tools 8.57.
  • Created the file extract templates for core HR configuration and transaction data conversion processes and on-going interfaces for legacy to PeopleSoft system.
  • Tested Enable Employee Self-service Enhancement where the user is unable to change his/her home address in Update Profile page and enable expense payments to be routed to alternate locations (addresses) other than the address sent from PayServ.
  • Resolved critical issues in timely manner during both day to day and month ends, such as PeopleSoft vendor check payments issues for sensitive vendor payments, Grants Management, Accounts Payable, Asset Management month end closures.
  • Proficient in writing Use Cases and competent understanding of Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, State Diagrams to support the development team and business groups using MS Visio .
  • Developed the PS Queries for Payroll and Configuring the Earn Codes for the Payroll, working on Vacation payout and On Cycle and OFF Cycle Payroll.
  • Involved in Fit-gap analysis, designed gap strategies, Design, data analysis, data mapping for conversion, data cleaning, preparing technical documentation, Table set up & interface design for PeopleSoft 9.2.
  • Customized payroll reports and voucher processes according to GAP definitions.
  • Worked on Global setup of the manager (MSS) and employee self-service (ESS) based on the job codes, salary plan admin and grade for various countries. These also include their payroll currently setup and pre- retirement or termination reimbursement criteria and Troubleshooting whenever issues arise..
  • Lead the Requirement gathering, Fit/Gap Analysis, and best practice evaluation/recommendation for the upgrade of Core HR, Benefits and benefits administration modules.
  • Understood the current issues with the system and the business processes, identified areas of improvements and provided recommendations and best practice evaluations.
  • Involved in the production & support and upgrade of the PeopleSoft HCM (HR, Benefits and Benefits Administration, Payroll and Time & Labor) modules based on organizational needs and requirements & Performed the Fit -Gap analysis and the Upgrade lab sessions to sort out the new functionalities to be added to the existing system.
  • Improved the Manage Hires process and populate employee's profile data with already captured applicant data in the Candidate Gateway and reduce customizations by introducing bundles and maintenance packs related to Recruiting Solutions and configuring additional workflow and notifications.
  • Implemented custom integrations from HCM to Recruiting solutions to get the employee HR reporting chain information and employee personal information.
  • Involved in setting up the integration between PeopleSoft HR and Kronos time keeping interface.
  • Investigated and jump started the use of integration technologies with time keeping systems integrated with PeopleSoft
  • Interacted with the Users and Functional analysts to come up with new requirements for the business unit and Change reporting period dates in EPay.
  • Prepared Functional Designs for Conversions, Reports and Customizations related to Time & Labor, Absence Management and Commitment Accounting modules.
  • Was single point of contact for all things related to Absence Management including Absence Configuration migrations using delivered packages and overall deployment.
  • Prepared processes to load Budgets for new Financial Year, other batch updates and mass load of budget records resulting in hundreds of man-hour savings on data entry.
  • Created business process models and identified business process improvements for the PeopleSoft 9.2 Core HR, Base Benefits, Benefits Administration, N.A. Payroll, Time and Labor, Talent Acquisition Manager (TAM), and Self Service modules.
  • Extensively used tools like Process Scheduler and Process Monitor for the execution of SQL and Crystal Reports.
  • Administer PeopleSoft Security, including ESS and MSS, by troubleshooting and maintaining Security Setup by creating Row level security, Roles and Permission Lists, and amending the security access based on approved requests
  • Retrofitted Custom Time and Labor Interface application engine program that loads data from the flat files sent by various different Time Keeping Systems into PeopleSoft Reported Time table.
  • Work with the end users to resolve issues with contract activation, initial grants billing and amount allocation for amount-based contract lines.
  • Provided Involved in various phases of this project such as analysis, design, development, Data Conversion Scripts using SQR & SQL Scripts, unit testing, devising string and integration testing, performance tuning of on-line and batch application.
  • Involved in Recruitment, Workforce Admin, Self Service (Employee and Manager), Compensation (Base and Variable), Core HR, Time and Labor, Benefits, Ben Admin, NA Payroll, Global Payroll, Absence Management and Time Collection Devices (TCD).
  • Worked as a functional guy to analyze and support the PeopleSoft HCM/ELM 9.2 Upgrade effort.
  • Performed extensive debugging and performance tuning of various processes. Well versed in utilizing tools and utilities provided by PeopleSoft (Debugger, tracing etc) for trouble shooting issues on People Code, Application Engine, SQR's & Online.
  • Worked closely with Installation, administration and upgrades of PeopleSoft environments on an Oracle/Solaris, PeopleSoft application architecture including the table structure, delivered objects, design standards, protocols and Involved in various PeopleSoft Applications Up gradation using Upgrade/ Change Assistant.
  • Configured Load balancing and high availability on Application server, Process scheduler and web Server and Involved in PeopleSoft Application upgrade.
  • Collaborated with QA team to create and implement test plan and test cases for User Acceptance Testing (UAT). Involved with the whole UAT to ensure the performance of the system and application.
  • Developed Unix shell scripts to schedule reset of Process Scheduler, and Application Server domains. Developed shell scripts on the Application Server to generate the average transaction time served by each Application Server Instance. Created simple scripts to monitor the tuxedo domain to check queue/server status.
  • Comprehensive experience in setting up security in HRMS, Financials, CRM, EPM, and Portal environments and created designs for AP, General Ledger, AR, AM, Billing, PC, PO, ePay and Expenses modules

Confidential, Madison

Peoplesoft Payroll Business Consultant

Responsibilities:

  • I have been an active part of the full life cycle implementation that is end to end in terms of Implementation, Configuration and upgradation of Peoplesoft HCM modules from 9.0 to 9.1.
  • Worked on mapping the Time Reporting Codes to Earning Codes, Created Leave Plans and Benefit Plans Benefit Programs as well & Major project converting Data from Workday to Peoplesoft and worked closely with the business customers to create new customized BI dashboards.
  • Provided Gap and Business Analysis to identify modifications and business requirements, functional and technical programming for HRMS, Benefits Administration, Payroll, Employee Self-Service, Workflow, benefits modules which consisted of design documentation, table structure setup and modification of workflow process for daily event processing and Open Enrollment functionality.
  • Performed Configuration, Testing using PS Query for Core HR, Payroll, T&L, Benefits, and Payroll.
  • Designed complex custom payroll process for redistribution of payroll data on per day basis.
  • Worked on troubleshooting payroll processes as well commitment accounting processes.
  • Extensive experience on support and enhancement of Peoplesoft HRMS - Time & Labor, North America Payroll, Core HRMS, Manager Self Service, Employee Self-service, Compensation and Profile Management.
  • Customized HR and Payroll menus, Inquiry pages, altered records, SQL View texts, People Code functions like SQL Exec, Scroll Select & Implemented complex technical and system design specifications for benefits, benefits and Self-Service.
  • Designed Benefits Administration system to allow for flexible independent cost, geographical restraints, and complex eligibility requirements.
  • Involved in maintaining and production support of PeopleSoft HRMS (Core HR, Workforce Administration, Performance, Benefits, NA Payroll) & Analyzed Human Resources/ Time & Labor/ Payroll/Benefits/ Time Capture business processes; work with business owners to achieve consensus for business process changes and facilitate transition to best practices as supported by PeopleSoft HCM.
  • Configured the Pay check modeler, Online rule processing in PeopleSoft and Set Up and Configured WorkCentre and Dashboards in PeopleSoft & Set up Earnings codes, Earnings Programs, Pay Groups, Deduction Codes and Garnishments.
  • Responsible for implementing Position Data Pages in MSS by creating departmental budgets, Defined budget period calendars and source transactions & experienced PeopleSoft HRMS applications with Modules such as HR, Payroll, Benefits, Benefits Administration, Time and Labor, Absence Management, ESS and MSS.
  • Involved in developing various routines to transform the date to the Client database format by using SQRs and Application Engine programs & Assignments focused on Conversion, Configuration, Customization and testing Benefits, Benefit Administration, ELM and Talent acquisition applications processing.
  • Worked on Global setup of the manager ( MSS) and employee self-service (ESS) based on the job codes, salary plan admin and grade for various countries. These also include their payroll currently setup and pre- retirement or termination reimbursement criteria and Troubleshooting whenever issues arise..
  • Coordinated with Users and Testing Team in successfully implementing the business requirements and customization into PeopleSoft Application and developed relationships with prospective and current clients by consistently reaching out to them and educating them about Epay.
  • Extensive work experience in understanding of Time Reporting Codes, Workgroups, TRC Programs, Value Lists, Template Built Rules and Custom Time Labor Rules.
  • Created and Used Application Packages, Application engine programs, SQR Batch Programs, Menus, Components, Pages, Records, Fields and several complex SQL Definitions in order to achieve functionality.
  • Responsible for creating, configuring and maintaining objects to support requested Business user Functionality according to development standards.
  • Developed test scenarios/scripts, test plans, prepared user acceptance test cases (UAT), UAT issue log for tracking the defects in JIRA and collaborated with system users to conduct UAT.
  • Developed the new SQR process, Simplex compare process to load the exceptions into the custom tables we created for this project. An exception is created if there is a difference between the elapsed time from the simplex system and the payable time from people soft beyond the tolerance level set by the payroll team.

Confidential, Columbus, OH

Business Analyst

Responsibilities:

  • Interacted with stakeholders, Systems Architect, UI/Content Management Team, Developers, SME and diverse group of personnel and facilitated JAD sessions to understand the business process, gather Business Requirements and identify changes for the applications and implemented in Agile methodology.
  • Conducted GAP Analysis to understand the limitations of the existing system and contributed to the functional design of the future system, modeled the AS-IS and TO-BE business workflow.
  • Performed document analysis to derive business rules from the legacy system and validated them with stakeholders for consistency and completeness.
  • Prepared Business Requirement Document (BRD), Functional requirement Document (FRD), converted functional and non-functional requirements into user stories for Agile development framework.
  • Documented, maintained and obtained sign-off on all department-wide policy, procedures and process flow.
  • Constructed Requirements Traceability Matrix to determine the source of the requirement, ensure all requirements are met and locate affected system components when there is a requirement change. Maintained the traceability matrix until business requirements were signed off.
  • Highly proficient in creating Use cases, Workflow Diagrams, Sequence Diagrams, and Class Diagrams, etc.
  • Extensively used Rational Rose and MS Visio for UML.
  • Documented all As-Is processes using Visio process flow diagrams to be able to confirm these with SMEs.
  • Analyzed requirements wrote User Stories and managed Agile Lifecycle in JIRA from planning to sprint deployment. Tracked and communicated team velocity and sprint/release progress. Assisted in managing the Product Backlog and Sprint Backlog.
  • Facilitate daily Stand ups, grooming, Sprint Planning, Sprint Reviews, and Sprint Retrospectives and Tracked JIRA board updates and ensure data accuracy.
  • Component-Based Diagrams, creation of technical design (UI screen) using Microsoft Visio.
  • Instructed and modeled core agile principles of collaboration, prioritization, team accountability, and visibility.
  • Designed and developed Commitment Account rules. Created Workflows for Long-term retro in Commitment Accounting. Created new IB Interfaces.
  • Worked on Forms in ELM and have created a CI to load data from Form onto the People soft Component.
  • Worked extensively to understand Time Reporting Codes, Workgroups, TRC Programs, Value Lists, Template Built Rules and Custom Time & Labor Rules.
  • Worked on multiple data conversion programs using CI and Application engine to convert legacy training data from Pathlore, ABRA into PeopleSoft ELM.
  • Analyzed current PeopleSoft system to design and configure tables for HR, Benefits (Benefits Administration), ePerformance, eCompensation and Talent Management (Succession Planning).
  • Met customer needs by creating custom reports, editing existing reports, and scheduling reports with PeopleSoft reporting tool and calculation fields.
  • Worked on customizations and reports in Time and Labor, Absence Management, ELM and HR modules.
  • Troubleshot and diagnosed PeopleSoft, Transitions, and Taleo issues, delivering swift resolution.
  • Involved in development and maintenance of HR dashboards weekly, monthly, quarterly, annual reports, Headcount, Hires, Terminations, off cycles, Merits, Global Compensation & Turnover reports to outline and analyze some of the following: workforce trends, quarterly dashboards, monthly reporting with detailed analyses.
  • Analyzed, documented and advised commitment accounting, payroll regarding tax updates, and applied patches, and Tax updates; worked with Oracle support team to obtain delivered solutions to issues.
  • Modified Time & Labor reports as a part of upgrade and retrofitted several customizations analyzing the reports.
  • Responsible for payroll tax and garnishment accounting, auditing, and all reconciliations.
  • Extensively worked with the HCM Upgrade team and functional users to develop, support and resolve technical issues in Admin, Absence Management, Talent Management, Payroll, and Benefits.
  • Retrofitted custom Time & Labor rules, exceptions, developed new rules and rules migration.
  • Conducted Compare Report analysis for PeopleSoft Changes, Customer Modified changes and analyzed the objects to be upgraded.
  • Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process.
  • Developed many Inbound/Outbound interface Application Engine Processes to get data between PeopleSoft system and third-party systems.
  • Used File Layout Definition to get data from the legacy system to people soft tables.
  • Worked on customizations for self-services, core HR and Benefit HRMS modules.
  • Involved in Unit testing of people soft delivered and modified functionality & customized SQR programs using HR, Absence Management, Talent Management, Benefits and Payroll Modules.
  • Conducted meetings with the Users and the testing team and involved in discussing their problems and helped them out in finding the proper solutions for their requirements.

We'd love your feedback!