SUMMARY:

• PeopleSoft HCM Functional Consultant with 10+ Years of experience in implementation, upgrade, support of HCM, integrations, and third party systems.
• Implemented and Supported PeopleSoft HCM 9.2/9.1. Expert in Configuring Setup tables related to Core HR, Position Management, Compensation, NA Payroll, Benefits, Benefits Administration, Absence Management, Performance Management and Security.
• Expert in Requirements Gathering, Analysis, Prototyping and documenting current and new Business Processes in Implementation, Upgrade, Integrations and Business process.
• Strong skills in technical project management, planning, and effectively meeting deadlines.
• Strong implementation/upgrade skills and high level of business process knowledge of PeopleSoft 9.2/9.1, 9.0.
• Expert in Analysis and Review of Business, Functional Design and Technical Requirements Specification documents.
• Possess excellent skills in Fit/Gap analysis, test cases, user requirement analysis, prototyping, data modeling, project management, proposal writing and documentation of functional and technical specifications. Good communication and presentation skills.
• Excellent functional knowledge and project experience in the areas of PeopleSoft HCM Core HR, Base Benefits, Benefits Administration, Position Management, ePerformance, Profile Management, NA Payroll and functional understanding of all HCM modules.
• Involved in the setup of Core HR, Benefits and Benefits Administration related tables.
• Expert in converting data from legacy system and designing inbound and outbound integrations.
• PeopleSoft HCM security expert with in - depth knowledge of profiles, roles, permissions and portal structure/registry, definition security, password controls, query security and tree management.
• Expert in designing and developing reports in SQR, Crystal Reports, BI Publisher and PS Query.
• Expert in creating PL/SQL scripts used for databases and integrations.
• Expertise in writing ad-hoc queries using PS Query and Query Manager.
• Excellent in verbal, written communication skills and good team player.

TECHNICAL SKILLS:

PeopleSoft HCM:: Core HR, Payroll NA, Position Management, Benefits, Ben Admin, T&L, Absence Management, Compensation, Performance Management, eProfile, ePay, ESS and MSS.

People Tools:: App. Designer, App. Engine, App. Messaging, Activities, Business processes, PUM,Component Interfaces, Business Interlinks, PeopleCode, Upgrade Assistant, Tree Manager, Query Manger and Workflow.

PS Admin Tools:: Process Scheduler, Data Mover, Security, Application Server, Tree Manager.

Reporting & OLAP:: SQR 3.x/4.x/6.0, PS Query, Query Manager, Query Tree.

Database/Servers:: Oracle 9i/10g, 11gR2, MS Access, DB2, MS SQL Server.

Operating System:: UNIX, Windows 98/NT/2000

PROFESSIONAL EXPERIENCE:

Confidential, Kansas City MO.

PeopleSoft 9.2 Functional Consultant

Responsibilities:

• Analyzed the existing functionality of PeopleSoft in the areas where enhancements were identified.
• Worked with business/functional users for gathering requirements on the enhancements and the problem areas with the old system are identified.
• Analyzed the various customizations with their business requirements and replaced them with new functionalities from PeopleSoft 9.2
• Participated in the fit Gap meetings to analyze the end users about the new functionality that can be used as the Enhancements for Benefits Admin, Core HRincluding compensation and Pension.
• Prepared the fit Gap document with customizations that are active with the present system.
• Taking up all the trackers to discuss in Design Control Board and getting the approval.
• Coordinating with technical team members for development / customizations.
• Implement change requests as per change management policies and procedures.
• Created the Manager Dashboard with the specific requirements from the manager level and users.
• Updating weekly status report and sharing it with the clients and maintaining the timelines.
• Worked on setting up Cobra Administration; enrolling the participants in both batch process and getting manually enrolled.
• Validated various custom benefit rules used by the Benefit Admin process. Created new event and eligibility rules.
• Act as a Liaison between business user and technical support for updates to system customizations .
• Designed exhaustive test plans, test scripts, test cases for multiple phases of testing - system integration testing, regression testing, Coordinated User Acceptance Testing (UAT).
• Built queries using PS Query, exceptional understanding of PL/SQL, expertise in working with complex SQLs to extract and report data.
• Provide production support for PeopleSoft applications.
• Providing resolution on various L2 tickets raised by Users.

Environment: PeopleSoft HCM v9.2 Core HR, Benefits, Benefits Admin (Component Interface, Data Mover, AWE, PS/Query, PeopleCode, Integration Broker, XML Publisher SharePoint, PHire, Oracle.

Confidential, Lisle, IL

PeopleSoft 9.2 Functional Consultant

Responsibilities:

• Involved in getting business requirements from business process owners and sessions with business process owners to demonstrate application capabilities related to Benefits Administration.
• Involved in eligibility checking and respond to Human Resource events that might affect benefits enrollment, based on your eligibility and event rules.
• Worked on multiple, simultaneous plan years, according to enrollment rules that are define.
• Worked on benefit costs and coverage amounts independent of PeopleSoft Payroll for North America.
• Defined and processed a variety of flexible credits, both general and plan-based.
• Implemented foundation for implementing self-service enrollment using PeopleSoft eBenefits.
• Implemented integrations between HR, Payroll Interface and Payroll North America.
• Involved in flexible spending account (FSA) information for employees.
• Worked on health-care and dependent-care FSA claims.
• Understood the business needs and analyzed Functional Requirement through Functional design document.
• Analyzed the existing functionality of PeopleSoft in the areas where enhancements were identified.
• Worked with business/functional users for gathering requirements on the enhancements identified.
• Participated in business requirements analysis, Reviewed BRD’s, Created Functional Designs for Benefits administration, eBenefits, NA Payroll as part of implementation of 2017 Open Enrollment and Roth 401(K).
• Involved in Fit/Gap Analysis, Optimization, System/ Integration/Parallel/Performance Testing, Problem Analysis/Resolution & User Training as part of Upgrade.
• Gathered requirements for Open Enrollment and implementation.
• Validated various custom benefit rules used by the Benefit Admin process. Created new event and eligibility rules.
• Act as a Liaison between business user and technical support for updates to system customizations.
• Worked with developers on requirements clarification and ensure technical specifications satisfy the project needs.
• Configuration, executing Open enrolment process, customizing enrolment form and confirmation statement.
• Configuration of Vacation Buy plan as part of Open Enrollment implementation.
• Defined FSA (Flexible Spending Account) pertaining to issues in deductions.
• Setting benefits, Providing Merchant Integration, enrolling employees in benefit Plans include Health, Insurance, Savings, FSA, dependents/ Beneficiaries and life events like marriage, personal information, and Tax information.
• Created ad-hoc query reports and audits through SQL and PeopleSoft’s Query Manager.
• Developed Test Scripts and Test Cases for Open Enrollment, Benefits, Payroll, protocols for evaluation of system performance and facilitated user acceptance testing.
• Documentation of new customizations and implementation process that acts a quick guide to support team in case of issues.
• Maintaining existing Functional Designs, and Providing post-implementation support.

Environment: PeopleSoft HCM v9.2(Base Benefits, eBenefits, Core HR, North America Payroll & Time & Labor),Peopletools 8.5X, Application Engine, Component Interface, Data Mover, AWE, PS/Query, People Code, Integration Broker, XML Publisher SharePoint, PHire, Oracle

Confidential, Dallas, TX.

PeopleSoft HCM 9.2 Functional Analyst.

Responsibilities:

• Working as a HCM Functional consultant in the PeopleSoft HCM 9.2.
• Involved in analyzing the customizations in the Production HCM 9.2system and Integrations with vendors.
• Defined functional specifications and technicalrequirements.
• Profile configuration; which profile content types can be included in job openings and job applications.
• DesignedFunctional Specification documents to guide the technical team to build reports, interfaces, conversion programs, enhancements.
• Built queries using PS Query, exceptional understanding of PL/SQL, expertise in working with complex SQLs to extract and report data.
• Extensively worked on User Profile Security, Row level security, Create/Modify/delete Roles, Update Permission list assignment etc.
• Extensively act as an HR Analyst to resolve all PeopleSoft Portal, performance, ESS, MSS, Security related issues, Position Management.
• Modified fields, pages and menus by using people code as per user requirements.
• Created business process documentation and write configuration and system data documentation.
• Tested various programs to validate the data coming in flat files from different health care providers and to load that data into HR and Benefit tables using Component Interfaces.
• Tested the customizations involved in eBenefits Self Service applications
• Involved in testing various Inbound and Outbound Interfaces for transmitting employee Data to Benefits vendors and for receiving Data to process them and insert into various PeopleSoft Table.
• Documented status reports, coordinated meetings with business users to get clarity on business requirements, to close open items.
• Conducted Knowledge Transfer sessions, training sessions to help team members develop HR concepts.

Environment: PeopleSoft HCM 9.2/8.3XApplication Engine, Component Interface, Data Mover, AWE, PS/Query, PeopleCode, Integration Broker& XML Publisher (Core HR, Benefits and NA Payroll ).

Confidential, Pittsburgh, PA

PeopleSoft HCM Functional Consultant 9.1

Responsibilities:

• Worked with the Business team to understand the As-Is processes and in gathering and analyzing the requirements.
• Analyzing and Identifying qualified applicants and or candidates based on core profile data and enable employee self-service search match to allow employees to identify appropriate internal opportunities.
• Capturing prioritized business requirements from business process owners.
• Worked on Department tables and Job code tables also on Employee Data.
• Worked on base benefits such as adding and updating beneficiaries to the employees and Enroll in Benefits.
• Employee Record setup (All type of transactions like New hire, Rehire, Transfer, Termination, Data changes, Leave of Absence, Return From Leave and Applicant Tracking.
• Processed Salaried to Salaried / Salaried to hourly / hourly to hourly / hourly to salaried in Compensation module
• Contributed in Batch Process to generate the reports associate confirmation process, welcome Letters, Hire/Rehire, Arrears, Incentives, Head Count Report Termination reports.
• Handled TPC Database (Transaction Processing Centre) which is used by HR-Onshore to raise their requests and completing the requests raised by HR-Onshore in TPC database with in the time frame.
• Deployment of resources, including allocation and distribution of work within the team. Oversee the work of the team, allocating and scheduling to ensure work is completed to time and standard.
• In-depth knowledge of Workforce Administration
• Processed fit-gap analysis based on the business requirements gathered
• Worked on requirements are translated and developed correctly into technical solutions.
• Performed the cost/benefit analysis for the Gaps identified in the Fit-Gap analysis document.
• Configured the Talent Management and ePerformance modules.
• Given production support for the current ePerformance process, Benefits administration, and NA Payroll modules.
• Developed the templates: Requirement gathering template; Test plan and Test script templates; Fit-Gap template
• Involved in monitoring the application security by modifying and configuring new (as required) Permission lists,
• Tracked defects and retesting following resolution.
• Prepared test completion report
• Adopted Agile methodology in the project.
• Developed and executed the Test plan, test scripts and prepared test data for SIT and UAT.

Environment: PeopleSoft HCM v9.1(Core HR, Benefits, North America Payroll),Peopletools 8.X, Application Engine, Component Interface, Data Mover, PS/Query, PeopleCode, XML Publisher, PHire, Oracle.

Confidential

PeopleSoft HCM 9.1 Integration Analyst

Responsibilities:

• Worked as an Integration Analyst between HCM application and other Applications of RWS. The Role includes Plan, Gather requirements; Design, Develop, test, implement and support interfaces.
• Involved in requirements gathering with various users for understanding the functionality and finalizing the necessary objects for interface design.
• Formulated the plan and created the design, build and testing plans for integration for HCM.
• Involved in design and development of integration framework for all HCM interfaces.
• Designed the Functional designs for online customizations. HLD and DD for interface designs.
• Analyzed PeopleSoft delivered functionality of Global payroll for updating operational people via inbound file from time keeping system Virtual roster.
• Analyzed PeopleSoft delivered functionality of Absence Management and elements for understanding the entitlements and balances calculation for Operational people.
• Designed and developed application engine program for storing the data in staging table and updating positive input tables with global payroll rules.
• Designed and developed program for extracting leave entitlements for operational people and send them to Virtual Roster by an outbound interface file.
• Designed and developed program for calculating the leave balances with the leave takes and entitlement changes. Developed PS queries for users for validating the inbound data from various subsystems.
• Developed SIT, UAT and Functional test scripts for all the interfaces from HCM.
• Developed a document to be used by support team for production support.

Environment: PeopleSoft HCM 9.1, Global payroll, Absence Management, ESS, MSS, Application Engine, Application Packages, People code, SQR, Integration Broker, Component Interfaces, People tools 8.x, Oracle 10g, DB2.

Confidential

PeopleSoft Functional Consultant

Responsibilities:

• Worked as a HCM Functional consultant in the Upgrade of PeopleSoft HRMS 9.0.
• Developed functional design documents for new enhancements, worked closely with technical Lead to ensure better data solution for both Online and Batch programs.
• Analyze and resolve production & user support issues.
• Business Process re-designing and analysis.
• Configure & Setup HR system.
• Performed functional testing and System Integration Testing for Payroll Processing.
• Involved in resolving issues related to setup or employee related while performing System Integration Testing.
• Provided troubleshooting during payroll parallel testing and implementation.
• Act as the liaison for various types of projects between the business end-users and the technical team.
• Coordinate with the team on a daily basis to highlight completions/ issues/ risks.

Environment: PeopleSoft HRMS 9.0, Test Director 8.0/7.6/7.4,UNIX, MS SQL Server, Window 2000.

Confidential

PeopleSoft HCM Support Functional Consultant

Responsibilities:

• Worked as a HCM Functional consultant in the HRMS 9.0
• Analyzed functional design documents for new enhancements, worked closely with technical Lead to ensure a better data solution both Online and Batch programs.
• Analyzed and resolved production & user support issues.
• Business Process re-designing and analysis.
• Configured & Setup HR system.
• Performed functional testing and System Integration Testing for Payroll Processing.
• Involved in resolving issues related to setup or employee related while performing System Integration Testing.
• Provided troubleshooting during payroll parallel testing and implementation.
• Acted as the liaison for various types of projects between the business end-users and the technical team.
• Coordinated with the team on a daily basis to highlight completions/ issues/ risks.