SUMMARY:

• 8+ Years of experience in Implementation, PeopleSoft HCM Design, Development, Implementation, Customizations, Upgrading, Reporting and Production support Projects using People Tools.
• Experience in the diverse phases of Software Development Life Cycle (SDLC) and methodologies such as Spiral, Agile - Scrum, Waterfall and Rational Unified Process (RUP).
• Experience in the full lifecycle software development process as gathering, identifying, overseeing fulfillment of explicit and implicit business requirements as Business Analyst.
• Strong PeopleSoft Functional and hands-on experience in PeopleSoft (PS) HCM - Core HR, Talent Management, Workforce Administration, PS Reports, PS Query, PS Security, PS Workflow, Employee Self Service, Manager Self Service, Payroll.
• Worked on PeopleSoft 9.2 Core HR, NA Payroll, Time and Labor, Absence Management, Base Benefits, PeopleSoft Financials, Security and Dash- boarding.
• Experience in customizing PeopleSoft HRMS/HCM (HR, eModules and Compensation), Benefits, Payroll, ePerformance, and eRecruitment. Assist with preparation of financial reports for grants/contracts in accordance with funding source requirements.
• Worked on Human Resources Information Systems (HRIS) PeopleSoft to support the timely, efficient and accurate processing of payrolls, administration of benefits, compensation and other HR programs and practices.
• Worked on FSCM Modules like PC, AM, PO, AP and GL; and HRMS modules like Core HR, Workforce Administration, Global and NA Payroll, ESS and MSS.
• Implemented, documented and Supported PeopleSoft HCM 9.2/9.1. Expert in Configuring Setup tables related to Core HR, Position Management, Global Compensation Management, Commitment Accounting and Budgets, Candidate Gateway, Performance Management, and Security.
• Conduct fit-gap sessions with HR, Pension, and Benefits business groups and gather business requirements for the Upgrade.
• Converting JOB, PERSONAL, PAYROLL, Person Profile, and setting up configuration for acquired company's data
• Bring together varying stakeholders to explore possibilities for a requirement set and work towards consensus understanding. Mapping from master features down to acceptance criteria and functional requirements.
• Working closely with business and application owners and actively look for opportunities to enhance standards and improve process efficiency.
• Experience in PeopleSoft production support, enhancements, and upgrades to existing and new PeopleSoft HCM and PeopleSoft CRM Customer Support.
• 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.
• Hands-on experience in Requirements Gathering, Data Modelling (logical and physical design of databases), Business Gap Analysis, Unit/Integration Testing, Data Migration, User Training, and System Maintenance. Implemented GL, AP and AR.
• Creation of new PeopleSoft Security Permission Lists and Roles to allow access to approval pages for eProcurement and Accounts Payable.
• Expertise in designing validations using Application Engine programs, People Code, People Tools 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 Creating Reports and Analytics using OBIEE and ODI tools in HCM Cloud BI
• Configure fluid functionality to include fluid tile design versus classic design. Setup workcenters, dashboards, pagelet, and customize end-user personalization.
• Strong upgrades skills and high level of business process knowledge of PeopleSoft 9.1 and 9.2 versions by experience in Application upgrades of ELM 9.1 & 9.2, Exalogic database and application server upgrade and support for tools upgrade 8.52 & 8.54.
• SME Expert on PeopleSoft9.2Core HR, NA Payroll, NA Payroll integrations, Time and Labor, Absence Management, Time and Labor, Base Benefits, Benefits Administration, Security, Self Service and Dash- boarding.
• Expert in designing and developing reports in SQR, Crystal Reports, BI Publisher, PS Query and PL/SQL scripts used for databases and integrations. Expertise in writing ad-hoc queries using PSQuery and Query Manager.

PROFESSIONAL EXPERIENCE:

Sr. Peoplesoft Consultant

Confidential, Macomb, IL

Responsibilities:

• Involved in analysis, customization and implementation of HR/Benefits/Payroll modules using PeopleSoft 9.1 and People tools 8.51
• In depth knowledge of PeopleSoft Fluid user interface and Elastic Search delivered in latest tools release.
• Configured Fluid and created fluid pages. Created pivot grids, Dashboard related actions
• Extensively worked on lot of Interfaces (In & Out bound) and Reports for converting data from AS400 system to PeopleSoft.
• Customized HR and Payroll menus, Inquiry pages, altered records, SQL View texts, People Code functions like SQL Exec, Scroll Select etc.
• Worked on setup of SetID table, Company Information, Define Establishments, Location, Department, Salary Grades, Job Codes and Pay Groups for the basic HRMS System.
• Retrofitted data from PeopleSoft 9.1 version to 9.2 for various modules like Core HR, Global Payroll and Self Service.
• Generated SQR reports to create summary reports on payroll details check and validate the data.
• Extensively worked on the Approval Workflow Engine (AWE) to provide capabilities for creating, running, and managing the approval processes.
• Involved in setting up the rules and routings for the various Workflow E-Mail notifications such as marital status change, reporting change, Benefits enrollment notification, dependent benefits info changes etc. in collaborative applications.
• Executed unit test plans for medium complexity batch interface programs for eRecruit and Self-Service Modules.
• Created SQR program to convert Entitlements, Takes, Adjustments and Leave Plan balances fromAbsence Management to Time & Labor
• Worked on customizing the built-in applicant tracking system delivered by Talent Acquisition Manager in the process of identifying and hiring talent quickly.
• Submitted absence requests on behalf of their employees, view current and projected absence balances for their employees and approve or deny absence requests.
• Enable plan participants to project pension benefits via the Internet by using PeopleSoft Enterprise eBenefits Self-Service Estimate Pension function.
• Installed PeopleSoft 8.4 tool in couple of development instances to test the changes.
• Involved in integration of pension data in a single database, store effective-dated employment history to track jobs, employment status, salaried or hourly status, union affiliation and more.
• Involved in the consolidation of the PeopleSoft HCM 9.2 (HR, Benefits and Benefits Administration & Payroll) modules based on organizational needs and requirements.
• Developed new Conversion SQR programs for flat file creation by mapping the fields between legacy (EIS and Tessaract) and PeopleSoft systems.
• Extensive experience in various phases of PeopleSoft EPM and HCM implementation life-cycle and strong knowledge of implementation methodology and Agile methodologies in context with PeopleSoft.
• Set up the open enrollment system for the new employees and prepared the election analysis reports for the Open Enrollment Process.
• Upgraded PeopleSoft HRMS - HR, Payroll, Base Benefits.
• Developed test Strategy, test Plan, requirements traceability matrix, use cases, test scripts for system and regression testing of HR and Manager Self Service applications using Quality Center.
• Worked on PeopleSoft Integration Broker to develop messaging integrations which included configuring messaging systems and managing integration gateways.
• Used Application Designer to create new pages to provide Graphical User Interface to the users, Search Views, Audit tables and to create menu.
• Used People Code to control the program flow logic and for the validation to meet the current business rules.
• Addressed major PeopleSoft functionality flaws including Amount Based approval routings and Expenses Header level department Approvals
• Customized the Time Admin process to post the Payable time to N.A Payroll before finalizing the Absence Management Process.
• Experience working on the latest features and functionalities of PeopleSoft - Implementing PeopleSoft Fluid UI, Deploying PeopleSoft to Oracle cloud, mobile approvals, installing updates images on cloud like AWS, Data Migration workbenches for migrating different configuration items and installing elastic search
• Developed Application Engine Program to Load the External Data into Temp Tables and from Temp Tables into PeopleSoft application tables.
• Conducted interactive sessions to transfer knowledge in People Tools, People Code and SQR to client employees.
• Provided technical and functional support on implementations, upgrades, configuration, deployment, and maintenance supports on PeopleSoft (HR and Portal) running on Oracle Exalogic and Exadata platform.
• Maintained and updated the Department Tree and the Query Tree in the development database.
• Modified existing report formats and developed crystal reports using PS query.

Sr. PeopleSoft Consultant

Confidential, Dublin, CA

Responsibilities:

• Modified the Mark-to-Market process to process the information based on the as of date entered on the run control page. This is a delivered AE process. Prior to the change, the process was extracting the information equal to the as of date entered on the run control page. The process was modified to extract the information closest to the as of date entered on the run control page.
• Improved the performance of the Cash Position Worksheet process, by adding addition criteria to the select SQL.
• Working on PeopleSoft Fluid user interface and Elastic Search delivered in latest tools release
• Configured the earnings, deductions for NA Payroll as per business requirements. Ran the test payrolls for validation of earnings and deductions in the employee paychecks and direct deposit advices.
• Created and administered CSRs (Change/Service Request) in STAT for each business processes and migrate the retrofitted objects from one PeopleSoft Instance to other using STAT.
• Modified the prompts for the EFT (Electronic Fund Transfer) components. Change has been made to display the accounting template, bank code based on the business unit entered by the user.
• Custom process to undo an equity sale transaction.
• Custom process to delete MTM related accounting entries.
• Custom process to consolidate number of shares based on the business unit, security ID and accounting date
• Worked on modifying the delivered Cash Management Business Process/Deal Management Business Process
• Modified the business process to base the routing on the business unit. Subsequent to the change, the selected payments will be sent for approval to the approver who is authorized to approve for that particular Business Unit
• Modified the business process to add an additional step to send e-mail notifications for approval (In addition to the delivered method of adding the approval to the work list of the approver)
• Added people code to include the URL of the approval component in the body of the e-mail
• Worked on custom workflow for EFT (Electronic fund transfer), the activities of which are detailed below
• Understanding and extracting data from PS HR and Financial application using PS Query Manager as required by the business for purpose of higher management decision, public requests or for other internal departments' requirement.
• Custom configuration page for defining the reviewers/approvers including their notification preferences
• Custom configuration page for defining the bank signers (at bank code and bank account level) along with their notification preferences
• Custom configuration page for defining the workflow events
• Custom process to send notifications for the EFT requests that are pending approval
• Custom process to activate/inactivate the reviewers/approvers/bank signers/bank codes/bank accounts that are participating in the workflow

PeopleSoft HCM Consultant

Confidential, Richmond, VA

Responsibilities:

• Involved in full software development life cycle including gathering requirements, fit-gap analysis, system configuration, testing, rollout, and post go-live support.
• Gathered client requirements and defined business processes for functionality within HR, Benefits, and Payroll.
• Put together functional specifications and worked with technical team as they did their technical design
• Led company-wide requirements gathering and setup for all PeopleSoft system users, including creation of user profiles, roles, permission lists, department security tree, and query access manager
• Led conversion/implementation team through defining business process, fit gap analysis, requirements gathering, and documentation.
• Migrated PeopleSoft application for DB2/ AIX stack to Oracle Exalogic and Exadata
• Wrote multiple end user reports, tested various inbound/outbound interfaces to vendors, and validated data conversion.
• Interacted and collaborated closely with business stakeholders to understand business needs as well as processes and data sources to translate the business requirements into effective Information System solutions.
• Involved in cutover activities at RBI Data Center and supported and review the migration of PeopleSoft objects from UAT to Production Instance.
• Created custom Component Interface programs to send Kronos absence data to PeopleSoft Absence Management.
• Assessed client's system, including business processes, configuration, and customizations, to advice and make decision on upgrade to PeopleSoft v9.2.
• Functional team lead for conversion of Lawson HRIS system to PeopleSoft HCM v9.2 system, including HR, Benefits, and Payroll modules.
• Managed company's workflow solution including strategy, development, installation and administration
• Managed the requirements gathering, setup and configuration changes, and testing for client's PeopleSoft system related to their annual benefits, open enrollment changes, including benefit programs, benefit plans, coverages, eligibility rules, event rules etc.
• Responsible for key deliverables including as-is business process, fit-gap analysis, to-be business process, functional specifications, security matrix, configuration workbook, test scripts, and training guides.
• Interacted and collaborated closely with business users to understand business needs, processes, interfaces, vendors, and data sources, to translate business requirements into effective HRIS solutions.
• Provided day to day reporting on HR, Benefits, Payroll, and Recruiting data and maintained programs and modules that support HR, Benefits, Payroll, and Recruiting.
• Responsible for production support as well as managing HRIS related projects, including conversion of data for acquired company and standardization of HR, Benefits, and Payroll data for multi entity organization.
• Led setup and conversion of PeopleSoft foundation/transaction tables, Base Benefit and Benefit Administration Tables, Payroll tables, user profiles etc.
• Led the building of interfaces to Benefits vendors, ACH and Positive Pay file for banks and GL.
• Acted as functional Lead for tasks including Core HR (Workforce Administration, Position Management, Succession Planning), Base Benefits, Benefits Administration, Payroll and Self-Service modules
• Responsible for hands on setup and configuration of PeopleSoft HR foundation tables, Base Benefit and Benefits Administration tables including Benefits Programs, Benefit Plans, Eligibility Rules and Payroll tables including pay groups, pay calendars, deductions, earnings codes etc.
• Led documentation concerning all HRIS project related work and activities including HR transactions, benefits administration and payroll calculation.
• Involved in production support and global rollout of the PeopleSoft system, conversion of employee population to PeopleSoft 9.0, conversion of the legacy retiree system to PeopleSoft
• Led client with all levels of testing including unit testing, systems integration testing, and UAT (User Acceptance Testing).
• Wrote multiple end user reports, tested various inbound/outbound interfaces to vendors, and validated data conversion.
• Completed all configurations and table setup for conversion of legacy retiree system employees to PeopleSoft, including foundation tables, HR tables, Benefits tables, Payroll tables etc.
• Monitored and maintained system to insure proper operation and data integrity, including data scrubbing/cleansing, tree maintenance, report maintenance, etc

Business Analyst

Confidential, Los Angeles, CA

Responsibilities:

• Designed and documented Data conversion and Interface development strategy.
• Configured workflow rules and approval sets to notify Employee's hiring/promotions/transfers/termination. Analyzed workflow requirement and designed custom workflow to initiate mails and worklists.
• Set up Core Time and Labor setups, which included Workgroups, Rule programs, and Value lists. Defined Holiday Schedules, Schedule calendars, TRC Programs and Time periods, which were used in the Rules.
• Documented "As-is" and "To-be" process maps as part of Gap Analysis for new functionality requirements, and thereafter prioritized them to align them with the project requirement.
• Created Impact Analysis documentation to address issues with moving to new HCM platform
• Developed relevant queries to get ad hoc data required by various Oracle users such as payroll, operations, tax and compliance for support of both Oracle Payroll and OTL
• Worked on requirement gathering, Fit Gap Analysis, creating Functional Design Documents for several complex Custom Rules, which take care of Holiday, Holiday premium, Call Back and Comp Time pay for state employees.
• Set up Calculation Elements, Eligibility rules, Accumulators, Schedules, Absences and Delegations in Absence Management.
• Worked on mapping the Time Reporting Codes to Earning Codes and creating Leave Plans and Benefit Plans as well as Benefit Programs.
• Worked on Creating and Updating Static and Dynamic Groups.
• Collaborated with product owners to write up and prioritize customer centric documents like User Stories for Product Backlogs.
• Involved in setting up Row Security Permission Lists for employees enrolled in Time and Labor.
• Worked on Reports, Interfaces, Conversions, Extensions Implementation and Customization of the HCM module.
• Worked on many PS Queries, created some new queries, converted from 8.0, tuned, replaced or removed as per the requirements for all the 4 financial modules.
• Acted as the primary liaison between analysts on the business team and the IT project team
• Worked with the Business Users to gather requirements and translated them into Use Cases and Functional Design documents.
• Developed simple and complex Use Cases using Requisite Pro and MS Visio as per UML methodology.
• Coordinated Joint Application Development (JAD) sessions with clients and business partners.
• Managed project scope and change requirements throughout the entire project life cycle with hands-on involvement in project management and scope management.
• Created UAT test cases and assisted senior business analyst in conducting UAT test.
• Tracked Defects and Enhancements using Test Director and created metric reports on the number of open defects and enhancements.
• Provided support to QA in testing the core functionalities of the project.