SUMMARY:

• 7 years of experience in all phases of software development life cycle including Design, Development & Testing in different modules of the ERP - PeopleSoft HRMS.
• Involved in Upgrade of PeopleSoft HCM from version 9.1 to 9.2 and performed impact of changes with the technical teams.
• Extensively involved in customization of HRMS modules including Human resources, North America Payroll, Workforce Admin, Person Model, Base Benefits, Time and Labor, Talent Acquisition Manager/Recruiting, ePerformance, Compensate Employees and Self Services.
• Extensively involved in customization of HRMS modules including North America Payroll, Core HR, Workforce Admin, Person Model, Base Benefits, Benefits Administration, Time and Labor, Talent Acquisition Manager/Recruiting, Candidate Gateway, Compensate Employees and Self Service (MSS, ESS, Applicant, eBenefit, ePay, ePerformance), Recruiting solutions , Profile Management, Enterprise Performance Management etc.
• Experience in PeopleSoft production support, enhancements, and upgrades to existing and new PeopleSoft HCM and PeopleSoft CRM Customer Support.
• Strong PeopleSoft Functional and hands-on experience in PeopleSoft (PS) HCM 9.2,9.1 9.0, 8.8 - Human resources, Workforce Administration, PS Reports, PS Query, PS Security, PS Workflow, Employee Self Service, (ESS), Manager Self Service (MSS), Payroll, e-Recruit, e-Pay, e-Performance.
• Expertise in PeopleSoft Implementation, Upgrades, Interfacing/Reporting, Data Conversion and Troubleshooting.
• Experience in Campus Solutions \Student Admin Modules-Student Records, Campus Community, Admissions, Academic advisement, Student Financials, Financial Aid.
• Predominantly focused on design and customization of PeopleSoft HCM Modules (Core Human resources, Workforce Administration, Benefits, Recruiting, E-Performance, E-Compensation).
• Expertise in designing, configuring and implementing of PeopleSoft HCM modules.
• Experience in performing various roles as HCM Functional Consultant, Benefits Business Analyst involving in multiple PeopleSoft HCM Implementation, Upgrade, and Production Support & Maintenance projects.
• Maintained, administered and supported PeopleSoft Campus Solutions 9.0, 9.1, 9.2.
• Experience across Core Human resources, Employee and Manager Self Service, Global Payroll, North American Payroll, e-Performance, Payroll Interface modules.
• Had the experience in PeopleSoft HRMS which includes Human Resources, N/A Payroll, and Payroll Interface, TL, Compensation, Benefits, Benefit Administration, Profile Manager, TAM, CGW and ELM modules.
• Expertise in both Technical/Functional areas includes Analysis, Design, Document, Development, etc.
• Upgrade experience of PeopleSoft HRMS application from 9.1 to 9.2.
• Experience in business-related project milestones such as in Requirements Gathering, Data Modeling (logical and physical design of databases), Business Gap Analysis, Unit/Integration Testing, Data Migration, User Training, and System Maintenance.
• Involved in Fit-Gap analysis for PeopleSoft 9.1 to 9.2 Upgrade for Human resources, Benefits, Ben-Admin, Payroll, Security, ESS, MSS, eBenefit, ELM and Pension Management.
• Expertise in all phases of the System Development Life Cycle including Requirements Definition, Data Conversion and System Implementation.
• Performing user requirement studies, design, analysis, development of technical specifications, custom reports, custom applications, programming, implementations, integration, documentation, and testing, training and post-production support.
• Extensive skills in Application Design, Custom Reports Development, building interfaces and working with PeopleSoft People Tools.
• Supported data cleansing activities - SQL Backend support by creating and running scripts in SQL/PS Query.
• Experience in all aspects of business analysis function including business process mapping, requirements gathering, functional design and testing.
• Worked with business analyst and data architect for data mapping between the PeopleSoft ERP and the central main data warehouse.
• Excellent working knowledge in People Tools (Application Designer, PeopleCode, Data Mover, Application Engine, Process Scheduler, Component Interface, SQR, Crystal Reports, XML Publisher, and PS Query).
• Strong SQL skills, ability to write and execute advance SQL on Oracle and MySQL server database.

PROFESSIONAL EXPERIENCE:

Sr. PeopleSoft Campus Solutions Consultant

Confidential, IL

• Proven ability to organize and work on multiple projects in Campus Solutions with high quality deliverables and task completion ahead of the timeliness allocated.
• Support technical development of the PeopleSoft HCM application using PeopleTools, PeopleCode, Web Services, Integration Broker, Application Designer, Application Messaging, Application Engine, complex SQR, etc.
• Completed PeopleSoft upgrades, fixes, and tax upgrades for HRMS.
• Worked closely with Business User at client site for PS HCM modules - Base Benefits, Core HR and payroll interface.
• Developed Custom tables and pages to setup the benefit plans and coverage codes.
• Involved in writing technical design documents based on functional specifications and developed customization in PeopleSoft 9.2 Environment.
• Designed and developed Core HR and Time and Labor WorkCentre. Involved in online changes to the delivered pages, components, menus and translate values.
• Worked with key project management team and business people to formulate and communicate the business vision for the project and mapping out the initial requirements in Campus Solutions and Human resources.
• Involved in Development, Enhancement, Upgrade and Maintenance of HR, Base Benefits, Benefits Administration, Payroll, and Time & Labor.
• Created new and customized Fields, Records, Pages, and Components for the client specific functionality.
• Worked as a hands-on function lead of analysts to support the PeopleSoft HCM/ELM 9.2 Upgrade effort.
• Involved in major customizations in Base Benefits and Payroll for NA modules that involved PeopleCode development, Application Engine processes and Cobol programs.
• Responsible for creation of Interface, reports, technical specs, functional specs, Test cases document of PeopleSoft HR application which includes Core HR, Payroll, Benefit and Time and labor requirements.
• Verified active job appointments and percentages in PeopleSoft HR Management System (HRMS) as well as student financial account Wrote Test scripts related to test all the scenarios related to benefits.
• Created Application Engine programs which encrypt employee job data information.
• Generated SQR reports to create Employee Data file which is sent to Finance system along with Payroll Data.
• Developed SQR programs based on the requirement and debugged issues related to several payroll processes which included Load Time and Labor, Pay Calculation, Pay Confirmation.
• Designed new BI Publisher reports using an add-on on MS Word document to create rtf documents and load then into the PeopleSoft system. charges in PeopleSoft Campus Solutions.
• Configured the PeopleSoft Payroll system which included Earnings codes, Earnings Programs, pay groups, Pay Calendars, Pay Run Ids.
• Wrote the custom application engine to pull employees benefits data to send to vendors.
• Helped in the conversion of crystal reports to BI Publisher/XML Publisher.
• Designed and developed the XML publisher reports in Time and Labor.
• Designed/Developed/Configured the synchronous and asynchronous messaging between HCM, Financials and ELM using the Integration Broker.
• Worked on several enhancements/fixes in the Campus Solutions.
• Created Technical Design Document from Functional Design Documents in Core HR, Benefits, Payroll and Time and Labor.
• Worked on several fixes and customizations as needed in Campus solutions Student Records.
• Conducted fit/gap analysis when working for both versions, communicated with users, gathered feedbacks and requirements on HR, Payroll & Benefits Administration modules, acted as business development liaison between customers and technical development team, identified and clarified business requirements & project risks, translated the requirements into highly detailed functional system specifications, recommended solutions, UAT Testing, conducted query and reporting.
• Created new pages, permission lists, roles and registered them in PeopleSoft portal.
• Developed several Synchronous and asynchronous integrations between PeopleSoft and 3rd party systems.
• Responsible for the configuration, testing and roll out of the benefit administration open enrollment functionality during the implementation of PeopleSoft version 9.2.
• Deployment of Unitime and integration between Campus Solutions and Unitime (Scheduling System) to expose class and faculty information and retrieve the schedule.
• Wrote the functional specs for all the upgrade changes related to the benefits and benefits administration and Payroll modules as the part of the upgrade 9.2.
• Worked on support and enhancements in Human resources and Campus Solutions modules.
• Worked on several Technical troubleshooting issues with fellow developers and functional analysts.
• Developed, customized and implemented custom processes for lock box transfer, vendor data, daily and monthly forms, along with integrations to and from Campus and HCM.
• Involved with PeopleCode, SQR'S, PSQuery, Crystal Reports and Xml Publisher.

PeopleSoft HRMS Consultant

Confidential, Seminole, FL

• Responsible for Production Support of HCM application which include modules Human resources, Payroll, Benefits, Ben Admin, and Self Service application.
• Comprehensive experience in setting up security in Campus Solutions and Portal environments.
• Implement HR-Core, Absence, Payroll, Time and Labor, Benefit and Payroll.
• Integration, System, Regression and Parallel Testing Payroll, Benefits, and Human resources sub-modules.
• Verified the Payroll process and validated the data in backend tables.
• Responsible for the assessment of complex Time and Labor contract rules for various unions. Prepared quality review templates and lead knowledge sessions to team members.
• Actively involved in creating the Software Test Strategy, Software Test Plan and Test Cases for PeopleSoft Human resources, Benefits, Payroll and Custom Applications.
• Facilitated the student financial legacy system assessment and fit/gap analysis in anticipation of implementing PeopleSoft 9.0 Campus Solutions.
• Involved in the Fit gap analysis for Recruiting, Human resources, Benefits and benefits administration and Payroll modules and documented the gaps in the system.
• Analyze, design, code, and unit test application solutions from requirements using defined processes and procedures.
• Involved actively in testing the Conversion Process to load Core Human Resources Tables, Benefits Deduction.
• Involved in Development, Enhancement, Upgrade and Maintenance of HR, Base Benefits, Benefits Administration, Payroll, and Time and Labor.
• Planned the training for end users on Human resources, Benefits and Benefits administration and Payroll modules.
• Involved in Campus Solutions Modules Financial Aid, Student Administration, Campus Self Service and Student Financials.
• Designed application engine process to update the eligibility configuration fields based on the business unit and job codes that makes employees eligible for different benefits.
• Supported open enrollment for the client on PeopleSoft HRMS, Base benefits 9.1 module.
• Involved in Design, Development, Testing, and Enhancement of PeopleSoft HRMS for Human resources, Payroll and Base Benefits modules.
• Delivered new components/records/views/pages as requested in support of HCM and CampusSolutions modules.
• Participate in fit/gap analysis, detailed design, testing and other aspects of implementation of the PeopleSoft HRMS application at various client sites.
• Assist in the development of test scripts to ensure the PeopleSoft application functions as expected by the client.
• Developed number of interface reports using SQR to read the data from file and load it into PeopleSoft tables and send data from PeopleSoft to other external applications.
• Perform all PeopleSoft Time and Labor, Benefits and North American Payroll configuration to meet new business requirements. Performs functional testing.
• Worked on fit gap analysis for HRMS version 9.1 which included Time and Labor, Payroll, Human resources and Recruitment.
• Involved in UAT Support, Integration and System Testing & Deployment and assisted technical team responsible for performing the Oracle E-Business Suite environment performance tuning exercises.
• Involved in setting up PeopleSoft tables and data cleansing activities - SQL Backend support.
• Worked on Report Conversion process from SQR/Crystal to XML publisher in PeopleSoft 9.1 environment. Worked on the Business Objects Data Insight to analyze and monitor the claims reports.
• Creation of MS SQL Server transfer articulation data warehouse with MS Excel dashboard.

PeopleSoft HRMS Consultant

Confidential, Bentonville, AR

• Executed the manual test scripts to check the functionality of PeopleSoft HRMS modules including Payroll for NA.
• Resolved multiple issues related PeopleSoft Payroll, including resolving critical issues encountered during payroll processing days.
• Documented the Business Requirements Mapping for HCM Global Payroll modules.
• Implementation of PeopleSoft Global Payroll with extension over 8.9 and its customization per the processes.
• Defined Commitment Accounting tables, PeopleSoft Time and Labor for use with commitment accounting.
• Performed Production Support, enhancements and customizations of PeopleSoft HRMS 8.9.
• Troubleshoot Human resources, Payroll and Benefits Administration setup and processing issues in live production database.
• Resolved several complex Production issues in Benefits Administration, Payroll, and Time and Labor.
• Responsible for the analysis, design, testing and implementation of the PeopleSoft Absence Management module to be used for International employees.
• Responsible for the conversion of all necessary pension and benefits data from various legacy applications into an existing PeopleSoft HCM database.
• Redesigned current business practice to conform to the internal processes inherent in PeopleSoft HRMS.
• Developed test scripts, test scenarios and test data for AP Project, eProcurement Project, and Time and Labor Project.
• Review current setup of delivered and customized components of Human resources, Position Management, Payroll and Benefits Administration.
• Conduct discovery sessions with client personnel to ascertain if initial requirements were fulfilled by the original implementation of PeopleSoft HCM.
• Involved in business process mapping for Time and Labor / Time keeping and Recruiting/On-boarding.
• Design and implement new components in PeopleSoft to store account code allocations for both internally and externally paid employees and contingent workers.
• Assist in problem resolution for Benefits Administration testing issues arising from the upgrade to 8.9.
• Involved in customized payroll pay line inserts and general ledger interface to use account code allocations stored on newly created PeopleSoft records.
• Involved in designing of System Appreciation Document (SAD) for HR, Payroll, Benefits, and Time and Labor Modules.
• Involved in writing Manual Test Cases and Test Scripts for new and enhanced version of PeopleSoft HRMS 8.9 (Human Resource, Benefits, and Payroll).
• Performance tuning exercises utilizing oracle partition strategies for data warehouse databases.
• Responsible for data masking of several databases - SQL Server and Oracle.
• Responsible for logging, troubleshooting and resolving the issues, which were encountered when performing SIT (System Integration Testing), UAT (User Acceptance Testing) and Regression Testing. • Responsible for production support of PeopleSoft Modules, responding to inquiries from end users, overseeing and auditing processes, creating and running ad hoc queries utilizing SQL Query Analyzer. • Manage the internal reporting requests for various PeopleSoft Applications by developing and writing queries. • Assisted the UAT testing team with the functionality and approach with the testing techniques to comply with the project timelines.

HRMS Consultant

Confidential, Newark, New Jersey

• Successfully completed Payroll Data Conversion from Legacy system to PeopleSoft System.
• Worked in HCM/HRMS modules like Core HR, ePerformance, Time and Labor, Absence Management and self-services.
• Involved in analysis, customization and implementation of Human resources/ Benefits/ Payroll modules using PeopleSoft 8.8 and Oracle 9i.
• Involved in the production & support and upgrade of the PeopleSoft HCM 8.8(HR, Benefits and Benefits Administration, Payroll, and Time and Labor) modules based on organizational needs and requirements.
• Identified all the Business Process, Desktop reports and evaluated the required Business processes reports in Core HR.
• Prioritize and resolve the production Payroll and Time and Labor issues at business level.
• Fixed technical and functional issues across PS HRMS (Workforce Administration, NA Payroll, Manager Self Service, Employee Self Service, Benefits, Benefits Administration modules).
• Conducted Fit-Gap Analysis and developed full documentation of issues discovered and proposed solutions regarding the upgrade of HRMS 7.5 to 8.8.
• Functional accountability for the conversion of legacy system data for HR, position management, payroll and benefits into an existing PeopleSoft database.
• Provide detailed mapping spreadsheets to ensure employee information is brought across from the legacy system and correctly deposited into appropriate PeopleSoft fields and records in Base Benefits.
• Supported all the modules like Workforce Administration, Recruiting, Benefits, MSS, ESS and Time and Labor.
• Initiate required PeopleSoft setup to facilitate the conversion process.
• Analyze customization requirements and provide functional specifications to address needs not meet by delivered PeopleSoft functionality.
• Analyze and correct any Human Resource issues identified during testing.
• Provide post go-live support for all Human Resources, Position Management, Payroll and Benefits staff.
• Advising other groups in organization on ETL development, data warehouse development, and ETL development best practices.
• Developed and ran several SQL queries for data setup and for validation of test plans.
• Logging, troubleshooting and resolving the issues, which were encountered when performing SIT (System Integration Testing), UAT (User Acceptance Testing) and Regression Testing.
• Proficient at writing Test Plans and Test Strategies and strong working experience in PeopleSoft Test Framework and HP Quality Center.
• Extensively worked on coordinating the meetings among the users for performing the User Acceptance Testing (UAT).
• Developed and support numerous data extractions from multiple disparate data sources (SQL Server, Oracle, Teradata, flat files) into main data warehouse.
• Provide technical support to implement regular bundles and patches received through PeopleSoft Customer Connection.
• Development of various automated processes to update certain PeopleSoft tables to reduce the amount of data entry work using application engine and SQR.
• Worked on Unit testing and PeopleSoft HCM modules like ESS, Time-sheets etc.
• Wrote functional requirements and non-functional requirements based upon the approved business requirements by following UML processes and standard procedures for developing use cases, use case diagrams, and other supporting documentation.