SUMMARY

• Result - Oriented HCM functional consultant with over 11 Years of experience in Implementation, Upgrade, Support of Enterprise Resource Planning Applications. Experienced in Providing Solutions in PeopleSoft HCM Design, Development, Implementation, Customizations, Upgrading, Reporting and Production support Projects.
• SME Expert on PeopleSoft 9.2Core HR, NA Payroll, NA Payroll integrations, Time and Labor, Absence Management, Time and Labor, Base Benefits, Benefits Administration, Security, Self Service andDash- boarding.
• Implementedand Supported PeopleSoft HCM 9.2/9.1 for various clients. Expert in Configuring Setup tables related to Core HR, Position Management, Compensation, NA Payroll, Commitment Accounting and Budgets, Time & Labor, Benefits, Benefits Administration, Absence Management, Talent Acquisition Management/ Candidate Gateway, Performance Management, and Security.
• Expert in RequirementsGathering, Analysis, Prototyping and documenting current and new Business Processes in Implementation, Upgrade, Integrations, Business Intelligence and Data warehouse projects.
• Experienced in Fit/Gap Analysis, Keep Drop Analysis, Optimization, System/ Integration/Parallel/Performance Testing, Problem Analysis/Resolution & User Training as part of Upgrade and Support Projects
• Expert in Analysis and Review of Business, Functional Design and Technical Requirements Specification documents.
• Experience in designing exhaustivetest plans, test scripts, test casesfor multiple phases oftesting - Functional Unit testing, System integration testing (SIT), Regression testing, Coordinated User Acceptance Testing (UAT).
• Expert in planning and managing Annual Benefits enrollment and ACA Administration as part of Base Benefits, Benefits Administration, vendor administration and integrations.
• Involved in setup of Payroll, Time and Labor, Benefits and Benefits Administration related tables.
• Expert in configuring and validation of Employee Self Service (ESS), Manager Self Services (MSS), eRecruitment, ePerformance, MY Time, My Pay, workflow.
• Expert in converting data from legacy system and designing inbound and outbound integrations.
• Expertise in designing validations using Application Engine programs, PeopleCode, Component Interfaces (CI), Excel to CI, Workflow, Application Packages, Application Messages, Web Services, On-line Customizations using the Application Designer and working with the Integration Broker.
• Experience in Batch Jobs Scheduling & Monitoring using Process Scheduler and other scheduling technologies.
• 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, Global Payroll, Position Management, Benefits, Ben Admin, T&L, Absence Management, TBH, TAM/CG, Compensation, Performance Management, eProfile, ePay, ESS and MSS.

People Tools: App. Designer, App. Engine, App. Messaging, Activities, Business processes, 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, Houston TX

Lead PeopleSoft HCM Functional/Admin Consultant

Responsibilities:

• Working as a Lead HCM Functional/Admin consultant as part of implementation & support projects.
• Collaborated with HRMS project stakeholders to identify recommendations for process improvements, overcome
• Business and functional constraints, and resolve difficult operational issues.
• Performed Impact and Fit - Gap analysis of the modification, enhancements and customizations of Core HR, Time & Labor, Benefits modules.
• Successfully leading a team in implementing multiple projects &enhancements related to NA Payroll, configuring Canadian tax pages of earnings and deduction codes, Benefits modules on tight deadline.
• Leading and participation in projects related to production support and Database Migrations as Lead PeopleSoft Administrator.
• Worked on creating ad-hoc reports using PS Query & ServiceNow for application maintenance issue monitoring.
• Working experience with Dell STAT application lifecycle management tools.
• Advanced experience working with STAT in creating migration packages and configuration to be migrated across instances.
• Working on Troubleshooting & Performance tuning of SQL Queries, Table Reorganization, running statistics, Indexing, handling PS Jobs and Sessions.
• Involved in performing windows patching activity, performing activities related to maintain SOX audit controls.
• Performing PeopleSoft Admin activities such as upgrade, patching, supporting production and non-production environments, Web App server setup and monitoring etc.
• Working along with a team on new HCM Workday project that transforms the HCM landscape of this billion-dollar organization for the coming decades.
• Working on PeopleSoft to Workday data conversion and migration to Production.
• Working extensively in PeopleSoft security including User Administration, Development Tools, Integration Tools.
• Configured Take elements and calculation rules for Vacation, Sick, Paid Time Off, Extended Leaves, Bereavement, Jury Duty, Office Closed etc.
• Created and setupcustom Template base time rulesin Time and Labor for some time groups.
• Created custom Workgroups, Schedules,template-built Rules and Rules Programs.
• Designed test plans and approach to validate complex Time and Labor, Absence Management business rules.
• Configured absence accrual and leave request processing functionality, including a rules engine to compute the most complex accrual, consumption, payout and carryover logic.
• Setups of Extended Leave Templates and configuration of extended leave calculation rules for client's FMLA, Maternity, Worker's Compensation and Infant Care leave types.
• Configured request approval functionality, including multilevel approvals and alternate approvers using Employee Self Service, Manager Self Service.
• Configured Take elements and calculation rules for Vacation, Sick, Paid Time Off, Extended Leaves, Bereavement, Jury Duty, Office Closed etc.
• Created and setupcustom Template base time rulesin Time and Labor for some time groups.
• Created custom Workgroups, Schedules,template-built Rules and Rules Programs.
• Designed test plans and approach to validate complex Time and Labor, Absence Management business rules.
• Configured absence accrual and leave request processing functionality, including a rules engine to compute the most complex accrual, consumption, payout and carryover logic.
• Setups of Extended Leave Templates and configuration of extended leave calculation rules for client's FMLA, Maternity, Worker's Compensation and Infant Care leave types.
• Monitoring team activities and system performance reports.

Environment: PeopleSoft HCM v9.1(Core HR, Base Benefits, eBenefits, North America Payroll, Time & Labor, Absence Management), Peopletools 8.5X, Application Engine, Component Interface, Service Now, Data Mover, PS/Query, Peoplecode, XML Publisher Oracle, STAT, ServiceNow.

Confidential, Dallas, TX

PeopleSoft HCM 9.2 Upgrade Lead & Support Analyst

Responsibilities:

• Worked as a HCM Functional Leadanalystas part of 9.2 Upgrade project.
• Involved in requirements gathering from end users for required customizations.
• PerformedImpact and Fit - Gap analysis of the modification, enhancements and customizations of Core HR,Base Benefits modules.
• Worked closely with end users, HRIS, FMIS, DBAs, and otherstakeholders during discovery, design, construction, transition, and implementation of applications and application components
• Effectively appliedShared Services software development life cyclemethodology and enforces project standards. Reviewed and applied quality assurance procedures with customers and applications development staff.
• Created and setup custom Template base time rules in Time and Labor for some time groups.
• Worked onSetting up Tiles, Work Centers, Dashboards and Fluid Page configurations as part of HCM 9.2 Upgrade.
• Worked on PeopleSoft Security involving User Profiles, Roles, Permissions, Core Row Level Securityand Tree Manager.
• Worked on eCompensation implementation and integration with PeopleSoft applications.
• Set Upfoundation tables for HR such as department tables, Job Code, Job Profile, Job Family, Locationand Establishment.
• Setup Eligibility Rules and worked with custom Eligibility Configuration fields.
• Providing production support on daily basis for issues in domestic andinternational environments.
• Performed Unit/SIT testing (PeopleSoft Test Frame work)andassistedin UAT.
• Monitoring Test Problem Reports (TPR’s) with functional and technical teamon weekly basis to trouble-shoot system issues in HR module or other HRMS modules such as Payroll& Benefits that integrate with the HR modules.
• Developed Test Scripts and Test Cases for Core HR and Benefits as part of 9.2 Upgrade testing.
• Working Knowledge of PeopleSoft Update Manager(PUM).
• Created process documentation for end users and provided complete training of the functionality to the end user.

Environment: PeopleSoft HCM v9.2(Core HR, Base Benefits, eBenefits, North America Payroll),Peopletools 8.5X, Application Engine, Component Interface, Service Now, Data Mover,PS/Query, Peoplecode, Integration Broker, XML Publisher Oracle

Confidential, St. Louis, MO

PeopleSoft HCM Functional Analyst

Responsibilities:

• Worked as a HCM Functional analyst gathering requirements from End users for required customizations.
• Set up foundation tables for HR such as Set ID tables, new Company, business unit table, Pay Group table, location table, department tables.
• Security Setup for new company, migration and test script development and execution.
• Setup Eligibility Rules and worked with custom Eligibility Configuration fields
• Involved in customization of fields in reference to user requirements.
• Performed Unit testing andassistedin UAT. Documenting the issues in JIRA and assigning to development team.
• Involved in custom Person Of Interest(POI) functionality project, designed test scripts and executed the script.
• Designing custom forms as per user- requirements to meet their talent acquisition needs.
• Created process documentation for end users and provided complete training of the functionality to the end user.
• Provided production support on daily basisfor Core HR & Payroll modules and scheduling migrations on weekly basis.
• Analyzed user and system requirements together with specification documents and develop cases for test plan.
• Monitoring closely with functional and technical people to trouble-shoot systems issues in Benefits modules or other HRMS modules such as Payroll, which integrate with the benefits modules.
• Conducted database testing by executing PS queries for Database verification to ensure that the server was being updated as expected after user activity on the front end of the application
• Developed Test Scripts and Test Cases for Core HR and Benefits.
• Examined Documentation on different environment tofurther assist in testing and attaining appropriate results.

Environment: PeopleSoft HCM v9.2(Core HR, Base Benefits, eBenefits, North America Payroll), Peopletools 8.5X, Application Engine, Component Interface, JIRA, Data Mover, PS/Query, Peoplecode, Integration Broker, XML Publisher Oracle

Confidential, Lisle, IL

PeopleSoft Benefits Open Enrollment Lead

Responsibilities:

• Worked as a HCM Benefits Lead Consultant for 2017 Open Enrollment and Roth 401(k) implementation in PeopleSoft HCM9.2.
• Participated in business requirements analysis, Review BRD’s, Created Functional Designs for Benefits administration, eBenefits, NA Payroll as part of implementation2017 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 Roth 401(k) implementation.
• Configuration, executing Open enrolment process, customizing enrolment form and confirmation statement.
• Created new event and eligibility rules for Vacation Buy Plan.
• Defining Hyperlink setup table and URL’s as part of Open Enrollment Benefits Configuration.
• Configured Text and Message Catalog.
• Act as a Liaison between business user and technical support for updates to system customizations .
• Worked with developerson 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.
• Setting eBenefits, 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 throughSQL 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, Peoplecode, Integration Broker, XML Publisher SharePoint, PHire, Oracle

Confidential, San Leandro, CA

PeopleSoft HCM9.2 Functional Consultant

Responsibilities:

• Worked as a HCM Functional consultant in the Upgrade ofPeopleSoft HCM 9.2.
• Designed exhaustive test plans, test scripts, test cases for multiple phases ofsystem integration testing (SIT). 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.
• Advised and assisted payroll users with the execution of payroll processes such as creation of Pay Sheets, Pre-Calc, Pay Calc, Pay Confirm, Direct Deposit, Paycheck creation and with the GL Interface.
• Resolved time sensitive issues with mission critical programs using traces.
• Identified data issues with balances in earnings, deductions and taxes in the Payroll for North America module.
• Created custom Workgroups, Schedules,template-built Rules and Rules Programs.
• Configured rules for Overtime, Additional Straight time, Holiday for FT and PT, Comp time and Meals.
• Created custom exceptions for hours over or below scheduled hours, meal break, and overtime in Time and Labor.
• Created and setup custom Template base time rules in Time and Labor for some time groups.
• Configured absence accrual and leave request processing functionality, including a rules engine to compute the most complex accrual, consumption, payout and carryover logic.
• Setups of Extended Leave Templates and configuration of extended leave calculation rules for client's FMLA, Maternity, Worker's Compensation and Infant Care leave types.
• Configured request approval functionality, including multilevel approvals and alternate approvers using Employee Self Service, Manager Self Service and Approval Workflow Engine.
• Designed test plans and approach to validate complex Time and Labor, Absence Management business rules.
• Conducted system functionality testing, document and work to resolve Time & Labor functional gaps identified during Time & Labor Fit - Gap sessions.
• Integration of Absence Management to Time and Labor to enable the processing of time information and to generate payable time data that is subsequently loaded into Payroll for North America and third party payroll interface.

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