SUMMARY:

• 5+ years of experience as PeopleSoft Techno - functional consultant on PeopleSoft HCM systems.
• Proficient with implementation, upgradation/enhancement, integration and production support.
• Specialization in: Core HR, Payroll, benefits, compensation, absence management, time and labour, Versions 8.8-9.2, Tools PS Query, Application designer, application engine, application packaging, component interface, IB, Web Services, vision, SQR, PeopleSoft Studio design, application messaging, workflow, data mover, PUM and process tuning.

WORK EXPERIENCE:

PeopleSoft HCM Consultant

Confidential, New York, NY

Responsibilities:

• Involved in the implementation of PeopleSoft 9.2 throughout the project.
• Configuration of the Absence Management Module based on the Labor laws and the requirement of the client.
• Configured the earnings, deductions for NA Payroll as per business requirements. Ran the test payrolls for validation of earnings and deductions in the employee pay checks and direct deposit advices.
• Created Time and Labor security for various groups of employees based on HR Department tree, Dynamic groups and Access types (Security by Permission list).
• Support for Bi-weekly Payroll Processes, Holiday Payrolls and Time& Labor processes which included Time Administration, Batch Approval and AWE.
• Educated client team on PeopleSoft's Core HR, Benefits, Payroll, and Pension Administration foundation tables. Reviewed the configuration and documented the setup of all modules.
• Developed complex custom Time and Labor rules to calculate Late In, Excess Meal & short break, where the associates work in cross over shift and consists multiple login and logout on same day.
• Set up Time Reporting Codes, Time Reporting Programs, Workgroups, Holiday Schedules, Compensatory plans and Value lists.
• Work with Payroll Business Unit users in troubleshooting and resolving production issues with uploading inbound and outbound Kronos interface files.
• Analyzed and documented technical design specifications to carry forward numerous custom objects and customizations to delivered AP Pages, PeopleCode, Records, Fields, Application Engine programs, database triggers.
• Developed several Ad-hoc reports using PS Query for department salaries, salary plans, and deduction, participants in Benefit Programs, salary change Report, salary Mass Updates and provided support for HR and benefits interfaces.
• Involved in developing and customizing the reports using the tools PS Query SQR, and nvision reports.
• Wrote many Inbound/Outbound interface Application Engine Processes to get data between PeopleSoft system and third-party systems. Wrote SQL queries and used SQLEXEC in PeopleCode. Performed query tuning and created Index.
• Involved in the reviewing, writing & execution of Test cases pertaining to Time and Labor, Core HR and Payroll.
• Designed Functional Specification Documents for Time and Labor module; teamed with developers to produce technical documentation.
• Developed and utilized tools to gather and implement BU-specific configuration and templates to support diverse local business processes.

PeopleSoft Consultant

Confidential, University Park, PA

Responsibilities:

• Effectively conducted workshops and with client team.
• Monitor daily data flow between HRMS, Absence Management and Time & Labor applications.
• Generated a process to create interface between Benefits and Time and Labor which compares employee's leaves recorded in Time and Labor against the allowed leaves; this process is used as an alternative to the existing Payroll feature, which calculates the Leave Accruals.
• Worked on PeopleSoft HCM upgrade from 9.0 to 9.1. Updated and created several PeopleCode Objects, App packages to fit business needs. Worked on SES search frame work building indexes. Created several XML publisher reports.
• Developed payroll adjustment report, to identify differences in payable time for all the time edits done on previous pay period after the payroll process.
• Identified additional functionalities, features and enhancements added due to PS Maintenance Packs and Bundles throughout in PS 9.1 HCM including TAM/CG module.
• Devised numerous standard and ad-hoc reports for users to access and run via PS Query and/or from menu navigation.
• Involved in creation and maintenance of Roles and Permission list for all PeopleSoft account users in the HR.
• Worked in defining the PeopleSoft security roles, permission lists and user profiles as per the requirement for all the modules.
• Created data mover scripts for exporting and importing important tables, like the security tables and the configuration tables. Did manual configurations after the bundle application.
• Worked with business and functional user to understand the requirements and created the technical design documents.
• Gathered the requirements from vendor and developed complex SQL's depending upon the Scenarios they provided in functional documents.
• Worked closely with Business owners/users to accomplish the User acceptance testing by coordinating with the development environment team to resolve the issues.
• Responsible for development of all RICE items (conversion, enhancements, interfaces, reports) which includes preparing technical design, doing build, coordinating the development, unit testing, peer review and migration.

Sr. PeopleSoft Business Analyst

Confidential, Sterling, VA

Responsibilities:

• Designed and developed FMLA outbound interface from Time and Labor to Benefits, for the FMLA reported hours. Created the mapping between Reported time table in T&L and the Benefits FMLA Leave History table. Developed the validations for Entitlements.
• Set up Calculation Elements, Eligibility rules, Accumulators, Schedules, Absences, Absence approvals and Delegations in Absence Management.
• Helping clean up Benefit Programs, Plans, Options, Rate Codes and Deduction Codes to improve the accuracy of payroll calculations.
• Configured Peoplesoft Template based Time and Labor rules using Period Threshold, Holiday, Accumulator, Shift Premium templates.
• Trained and mentored new employees/consultants in skills necessary for project implementation and completion.
• Handled bundles to resolve issues & upgrade the application. Triaged various testing, production and performance issues.
• Developed test cases/scenarios for end to end test coverage and created test scripts for execution of functional tests.
• Reviewed functional specs with business sponsors for approval and coordinated in testing all the requirements.
• Worked on building PS queries and security for users on ad-hoc reports.
• Helped the user build the work flow matrix which identifies the groups or person receiving notification during approval process. Designed security as per the requirement, created Permission Lists, Roles, User Profiles, and maintained them.
• Created & tuned complex SQL Queries record joins, filtering criteria & Effective Dated Active status rows.
• Involved in developing and customizing the reports using the tools PS Query SQR, and XML Publisher reports.
• Supported developments by clearly articulating the customer's business needs while continually verifying that the implementation approach and resulting technical developments that meets the current/future state requirements.

HCM Business Analyst

Confidential, St. Charles, MO

Responsibilities:

• Validate HRMS data after system upgrades for quality control as part of an interdisciplinary group (HR, Payroll, ITS) to include testing system changes, report writing and analyzing data flows for process improvement opportunities.
• Collaborated with Payroll, Benefits, IT and other HR Departments to complete complex processes, including transfers over multiple HR platforms and off-cycle checks.
• Process on-boarding new hire paperwork to include coding of retirement, health, dental and vision benefits and support new employee orientation.
• Generated implementation plan including resource requirements, assignment breakdown, and task lists.
• Developed System testing, Integration test Scripts with different test scenarios for Testing.
• Analyzed nature of defects and provided root cause analysis to the client team.
• Responsible for in UAT testing and helping the end user with the new system.
• Gathered and documented business (BRD) and reviewed contract documents
• Participated in JAD sessions for developing and revising prototype design and screen mockups responding to feedback from end users.
• Learned about different tools used in companies to fulfill business requirements such as, Microsoft Project, SQL database queries, traceability matrix, Visio.
• Participated in each phase of the agile software development life cycle.
• Increased Proficiency in MS Visio for drawing process workflow charts, use case diagrams, sequence and activity diagrams using Unified Modelling Language.