SUMMARY

• Over 11+ years of extensive experience as PeopleSoft HCM Functional Consultant. Involved in maintenance/ support/ upgrade/ implementations of PeopleSoft HRMS projects.
• Extensive experience in Scoping, Requirements Analysis, Design, Development and Maintenance of PeopleSoft HRMS for full life cycle projects.
• Have 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, e - Benefits, e-Compensation, e-Pay, e-Performance), Recruiting solutions, Profile Management, Absence Management etc.
• Study of current HR processes and identification of GAP/Workaround.
• Validating the result for UAT and Integration testing to meet the business requirements.
• Analyzed Human Resources/ Time & Labor/ Payroll/Benefits/ Time Capture business processes work with business owners to achieve consensus for business process changes, and facilitate transition to best practices as supported by PeopleSoft HCM 9.1,9.2.
• Worked with PeopleSoft - HCM Core HRMS 9.1-HR, Base benefits, Benefit Administration, vendor Profile, deductions, Earnings, Compensation, calculation rules and North American payroll & its interfaces
• Business object searches that enable you to locate an existing business object to use in transactions.
• The capability to quickly create a business object immediately by entering essential information
• In-Depth understanding of PeopleSoft Internet Architecture (PIA), Data models and client server applications.
• Worked extensively on PeopleSoft tools like SQRs and Application Engines for reporting, Mass uploads, Outbound and Inbound Interfaces, Email messaging and Data Processing programs.
• Developed different SQL to generate the reports for active/inactive/LOA/termination details based on the date ranges.
• Gathering of business requirements in consultation with users and prepared compensation Business requirements document.
• Worked on help tools like TOAD, SQL developer to view employee transactions.
• Excellent experience in setting up Integration broker to send the notifications to the third party system like Web Methods once the PS process got success.
• To communicate with the end users to gather the BR for different payroll interfaces like ITA, FRA, GER and SGP. These interfaces will send the day-to-day employee changes to the third party system.
• Setting up the record group Setid and Table sets based on Business units defined.
• Setting up the HRMS core tables- Business Unit, Permission list, Country, Job code, Department, Location, Salary plan etc.
• Worked on the Support and enhancement projects to add the additional new functionality with the existing FDD.
• Worked with the data conversion projects to perform test scripts and generating reports for quality assurance to make sure we are clean from system, Integration defects.
• Worked on building PS queries and security for users on ad-hoc reports.
• Worked with the DBA team to schedule the interfaces as per the user request.
• Analyzing the user needs, Conferring with the users to improve procedure and identifying and resolving the issues.
• Managed Team size of 15 - Offshore and 1 - Onshore
• Proficient in People Tools, PIA and People Code. Proficient in the creation of complex reports using SQR, PS/Query. Accomplished in successfully customizing modules based on organizational needs and requirements.
• Performed Application Updates and Fixes, People Tools Patches and People Tools Upgrades.
• Hands on experience with Change Assistant for PeopleSoft Application upgrades, Maintenance Packs and Patches.

TECHNICAL SKILLS

Web Technologies: SOAP, XML,XSD, Web Services (WSDL & SOAP),XSLT

ERP: PeopleSoft HCM/HRMS 9.1, 9.0, 8.9, 8.8, 8.3, People Tools 8.5x, 8.4x

HCM/HRMS: Core HR, Payroll, Base Benefits, Benefits Administration, Global payroll, NAPayroll,, eComp, ePay, benefits, Workforce Administration, Absence Management Time and Labor, Portal content Management, Employee Self Service and Manager Self Service.

People Tools: Application Designer, Application Engine, Component Interface, PS-Query, Workflow, File layout.

Reporting Tools: SQR, Crystal, PS-Query, XML Publisher.

Programming Languages: People code, C, C++, SQL, Core Java (Basics).

Database: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2003/2000/7.0 , DB2, MS Access 7.0.

Testing Tools: HPQC,QTP, Manual, IBM Rational Tools, Quest Stat

Operating Systems: Windows NT, Windows 2000/98, Unix

PROFESSIONAL EXPERIENCE

Confidential, MD

PeopleSoft Functional Consultant

Responsibilities:

• Customized pages for e-Benefits to deliver Benefit Enrollment pages, Health Plan pages, Managing Insurance Plans an employee can access.
• Involved in testing setup Enroll employees, Benefit plans, and Dependent and Beneficiary data.
• Involved in setup tested table, Company codes, Establishment IDs, Location Code, Salary Plan, Job Code, Pay Group tables, Employee Deductions, Calculation Rules for a particular business user.
• Involved in System testing, Regression testing, Integration testing and Defect retesting.
• Automated Leave Donation, Leave Receipt, and Leave Return administration processes.
• Created custom exceptions for hours over or below scheduled hours, meal break, and overtime in Time and Labor.
• Assisted in building a Business Process Model (BPM) like As-Is and To-Be structure using Case wise corporate modeler suite.
• Gathering business requirements and performing fit/gap analysis for e-Compensation and e-Benefits.
• Prepared the Mapping Template for the conversion team with the mapping rules for each and every NA Payroll record.
• Data validation during go-live.
• Worked on managing leave module based on guidelines at state / federal level. Need for accurately showing available leaves for every employee based on criteria.
• Developed Quires using Query Manager Depend on the Functional and Business analyst requirements to see the reports.
• Co-ordinated with multiple vendors on file transfers both inbound and outbound interfaces.
• Created the anticipated functional testing for different business requirements.
• Has been the To-Go person for both IT management and business community from the HCM application perspective.
• Developed audit records for core absence records
• Created new process for Long Leave and Maternity Long Leave reports it is used by variable pay calculations based on revenue enablers.
• Coordinates employee payroll request between unions and payroll for employees on leave of absence.
• Implements FMLA/Leave of Absence Database to process all leave of absence request within Octo and Quickbase.
• Created upload functionality for medical leaves for employee/manager and Admin Login.
• Worked for yearend logic for applying leave.
• Provided new functionality on HR Login page to apply leaves on previous months.
• Worked in creating Leave without pay, Leave taken, Project wise and department wise Leave related SQR reports.

Confidential, Madison, WI

PeopleSoft Functional Analyst

Responsibilities:

• Involved in complete full-life cycle implementation of PeopleSoft HRMS, gathered business requirements and collaborated to prepare functional designs, developed Tech designs and obtained approval from functional team.
• Function as the primary functional consultant for ongoing enhancements, problem analysis and resolutions.
• Responsible for gathering information from the clients, customers, core users regarding data and business processes and make proper documentation.
• Interacted with end users on daily basis to understand more about the PeopleSoft customizations required by them. Also worked closely with the end users in resolving their issues and queries.
• 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.
• Designed Functional Specification Documents for Time and Labor module; teamed with developers to produce technical documentation.
• Produce Workday reports for various types and levels of end users.
• Liaison between clients and Workday.
• Preparing fit-gap document in keeping with their business requirement of copy forward of compensation increase retroactively on converted data
• Perform testing, pilot/implementation and deployment systems integration; conduct product fit analysis
• Setup Time and labor rules for Overtime, Comp-Time, Holiday Comp-Time etc.
• Created custom Dependent Ben verification page to check whether the Dependents/ Beneficiary has been verified or not by the approving manager.
• Consult with clients on a variety of data integrity issues; conduct product fit analysis and adjust as needed
• Designing and integrating interfaces between PeopleSoft Absence Management and WorkBrain(T&A).
• Defining providers, rates, and beneficiaries, including spouses, domestic partners, and dependents, and calculate coverage’s and premiums for employees who have multiple jobs.
• Create test strategies and plan for System Integration and User Acceptance Testing.
• Added two new fields for FULL/Part time & Year/Seasonal to HRS JO FIND JOB page & modified Application package Search people code.
• Document system enhancement proposals, outline issues, alternatives and provide recommendations detailing performance, costs, scheduling, time and benefits.
• Work on Mass uploads and Leave accrual process for business units across the organization. Worked on North America Payroll while testing Tax Updates to ensure the integration of the system with the new delivered patches and bundles.
• Provide post go-live 24 x7 support for the Global Workforce for the HR, Payroll and Benefits.
• Document system enhancement proposals, outline issues, alternatives and provide recommendations detailing performance, costs, scheduling, time and benefits.
• Customized the delivered Direct Deposit function to restrict employees to option of having their total check direct deposited or receiving live check, but not a combination of the two.

Confidential Chicago IL

PeopleSoft Functional Consultant

Responsibilities:

• Lead consultant for Data Transformation and data migration from Legacy Systems to Workday HRMS. Participated in design activities for Fit-Gap and Setup Configurations in one of the largest HRMS migrations.
• Worked on North American Payroll Support requests for IndyMac. Support requests include errors in North American payroll interface applications while sending data in and out of North American Payroll base tables.
• Customized delivered additional pay data page to remove dollar signs from the fields on Additional pay page.
• Integrating Absence Management with Payroll for North America.
• Applied Payroll Tax updates to the existing PeopleSoft system whenever there is a new release of update by PeopleSoft. I have applied PeopleSoft Taxupdate06A to Taxupdate06D, starting from execution of DMS scripts to testing of the whole instance after the application of update. Also, I was part of team that applies bundle updates to vanilla and demo instances.
• Customized the delivered Direct Deposit function to restrict employees to option of having their total check direct deposited or receiving live check, but not a combination of the two.
• Customized using PeopleTools to track escheated checks - Checks not encashed by employees that needs to be handed over to the government.
• Customized View Federal Tax Letter page using PeopleTools to enables employees to view their W2 related information in PeopleSoft.
• Worked in Production Support, monitoring jobs submitted and reporting back the status of jobs. If any abends occur they are to be reported to the Onsite coordinator. Fixing the abends is also a major issue for the offshore support group.
• Adjusted leave balances due to improper entry such as leave entered under the wrong plan, leave cards submitted late and leave cards entered under the wrong earnings code for the pay group.
• Worked on developing Functional design document for custom reports (Adhoc) based on client needs- Payroll deduction reports, Employee Classification reports etc.
• Configured the Employee Self Service for the Personal data update, marital status update, Name changes and Address changes.
• Responsible for the configuration of Manager Self Service for promotion, salary change and termination processes.
• Provided 24x7 supports to customers, resolving their priority issues.
• Developed programs for Uploading of configuration data for business users when required.
• Developed interfaces with third party systems to PeopleSoft with the help of Component interfaces.

Confidential, Pittsburgh PA

PeopleSoft BA/Functional Consultant

Responsibilities:

• I have involved in HCM reports enhancements, Interfaces and online page customizations. Involved in fit/gap analysis for HCM / Financials requirements and interacted with business users and translated the requirements into Technical design for the IT.
• Prepared and delivered functional training materials to end users during and post implementation.
• Played a key role in developing, customizations and conversions using Component Interfaces, Application Engines and SQR's for PeopleSoft HCM/HRMS 9.1.
• Working on gathering requirements on personal profile section of the employee self service application where employee can see the PTO hrs.
• Also gather requirement around manager self service functionality like manager can request the online check request for his employees.
• PAF tool managers use the tool to request any sort of changes to the employees who directly report to them or indirectly report to them, like job change, manager change, Pay change, etc. It works according to the workflow for approvals. Once the HR approves then it is loaded into PeopleSoft.
• Working with Kronos.
• Working on Vacation benefits plan.
• Gathering requirements in interface between Kronos and PeopleSoft Payroll.
• Gathering requirements for interface between Kronos and PeopleSoft Benefits.
• Gathering requirements on different interfaces in PeopleSoft Payroll.
• Gathering requirement for some features in AP/GL.
• Preparing the Business requirement Documents and interacting with business users and translating the requirements to Technical designs for the IT team.
• Conducting meeting to get the approvals from Business users and Tech team.
• Discussing Pros and Cons of enhancements.
• User Acceptance Testing is done when ever required.
• Production support. Resolving issues related to Payroll, Kronos and Vacation accruals.

Confidential, Pittsburgh PA

PeopleSoft HR Functional Consultant

Responsibilities:

• I have involved in HCM reports enhancements, Interfaces and online page Testing. Writing Test Scenarios, Test scripts. Reviewing test scripts, test Scenarios Coordinating the offshore team.
• Played major role in analysis, testing, coding and designing in the customization, development and maintenance of Contractor/Driver Administration and Settlement (CDAS) for Confidential .
• Providing functional support for HR, Payroll, MSS applications and their interfaces Configured new Plans, Programs for Benefits, FSA Open Enrollment.
• Requirements Gathering, designing Employee Interface for UNUM Employee Interface, Virtual Edge Employee Interface.
• Facilitating Fit Gap Analysis, Research for a new Absence Management tool.
• Configuring new Holiday Schedules, Countries, Currency Codes, Locations, and Salary Ranges using Setup Tables.
• Working closely with IT in resolving MSS issues.
• Managing HR Security - Creating new roles, Permission Lists, Department Security.
• Create test conditions, test cases, and execute tests per schedule and plan for Plateau Interface, SONAR6 Interface.
• Creating ad-hoc custom Peoplesoft Reports for HR Business Partners and Management using PS Query.
• Defining Business user requirements, facilitating Fit-Gap analysis meetings & delivering a new ORG CHARTING Tool for the company for 2200 employees.
• Creating Trial Org Charts for the HR Team from the Trial versions for reference purposes.
• Calculated salaries for a specific pay period using Pay Sheets to perform pay in payroll module and used pay calculations to calculate employee's net pay and process manual checks.
• Wrote specification to several Reports for Payroll like Direct Deposit, modified Payroll summary by dept id and location.
• Facilitating Requirements Gathering meetings for SONAR 6 Interface to be implemented through Peoplesoft.
• Auditing Employee Personal and Job data and bringing the system up-to-date with latest employee information.

Confidential, CA

PeopleSoft Functional Consultant

Responsibilities:

• Currently leading the Application Support Benefits team as Benefits Supervisor.
• Configuring Benefits for new eligibilities such as new Union codes and creating special enrollment process for enrolling employees into new eligible plans.
• Solving Incidents logged in Remedy for Production Support for PeopleSoft Benefit Administration module for Ver 9.1
• Creating New Benefit Plans, Rates and Benefit Programs as requested by Business Users.
• Making correction to PeopleSoft Event Rules and Eligibility Rules to resolve enrollment issues occurring during Event Maintenance or Open Enrollment.
• Involved in preparing BRD-FDs (Solution Documents) for Maintenance requests.
• E.G: Designed a Job to run as part of batch which enhance performance of Benefits batch jobs
• Designed a UI where criteria to Mass insert events for Special Enrollment Processes
• Designed Custom Mapping tool to Map Employees from old Plan to New Plan.
• Supporting and troubleshooting issues around Benefits interfaces.
• Lead major conversion activities for employee data conversion for acquisitions, divestitures and new interfaces.
• Handled major Employee data clean up with a quick turnaround in order to fix employee data before the Payroll run and interface run.
• Supporting National interfaces like Delta, Metlife, Harrington and Vanguard.
• Provided SME support for enhancements of PeopleSoft Ben Admin and interfaces.
• Reviewed issues with users which were caused due to Upgraded version of PeopleSoft and suggested work around to users to deal with issues.
• Part of Implementation team for moving from PeopleSoft to Oracle HCM cloud. Participated in Requirement gathering and Fit Gap Deep Dives.

Confidential, Albany, NY

PeopleSoft HCM Techno Functional Consultant

Responsibilities:

• Involved in full-life cycle implementation of PeopleSoft 9.1. Developed Technical designs and also involved in development of the Customizations as per Clients requirements.
• Developed outbound / inbound interface which generates / reads flat files to and from third party vendors.
• Participated in scheduling / running the jobs in mainframes environment using JCL.
• Involved in several online customizations for Benefits and HR to meet business needs for clients of different regions.
• Produced multiple reports for Benefits, HR, including BASxxx reports, and customization of leave accrual reports.
• Used People Code extensively to validate objects in building application processes based on the functional business specifications.
• Involved in developing technical specification documents based on functional specifications.
• Developed data conversion programs for Benefits election components like state benefits, Life, Disability, and Flexible Spending Account (FSA).
• Generated a SQR Report for the Employees details.
• Wrote SQR program to upload Flat file information into People Soft database for HR & Benefit tables.
• Knowledge of Remedy for creating RFC’s, working on the assigned RFC’s and making sure that all the related documents as part of SOX Compliance are attached for CAB approval.
• Developed the upgrade plan, Installed and upgrade People Tools, Executed and reviewed compare reports. Setup menu security, helped in Audit and clean-up databases.
• Customized the pay check page (ESS) as per the client’s requirement.
• Implemented new functionalities to the existing HR, Benefits, and Payroll (ESS).
• Developed the entire module in PeopleSoft with help of People Code in order to allow employees to enter their time away, managers to view those and approve or deny the same. Employee component was tightly integrated with Employee Self Service. Manager’s approval & view status component was tightly integrated with Manager Self Service.
• Customized e-Applications (e-Benefits, e-Recruit) as per business requirements. These include the customization of Manager Self Service where we added new customized pages to view the information about the employees returned from vacation etc.
• Implemented Single sign on.
• Created Auto Security updating process which updates Users' security.
• Implemented Row level security.
• Created Roles and permission list to grant the users with appropriate access to specific pages.
• Created Permission list as a part of row level security and assigned the appropriate Permission list to users.
• Migrated users and applied security to the users between different instances using Data mover.
• Developed new Application Engine conversion program associated with Component Interfaces for Personal Data, Job Data for Employees and Contingent Workers, Emergency Contacts, Security/ User Profiles, and Badge Numbers.
• Totally Responsible for doing the Migrations to the other Environments like testing and Production, used a tool STAT for all the Interface migrations and creating version controls.

Environment: PeopleSoft 9.1HCM (HR, Benefits, E-Applications Suite), People Code, SQR, Application Engine, Application Messaging, Integration broker, People Tools 8.49, STAT, OS390, Portal, Grants, Windows NT, DB2, SQL Server 2000 and JCL.

Confidential

PeopleSoft HRMS Technical Consultant

Responsibilities:

• Involved in the implementation and customization of the PeopleSoft HRMS 8.8 (HR, Benefits, and Benefits Administration) modules based on organizational needs and requirements.
• Designed and developed the conversion programs for Base HR and Benefits components using SQR, People Code and Component Interfaces. Also used File layout to import the data from files to staging tables.
• Prepared field-to-field mapping for the data conversions.
• Played key role in development of Interfaces, Online Customizations using SQR’s, People Code and Application Engine programs.
• Rewrote the Base Benefits Audit report application engine program to SQR.
• Customized the online pages of the Recruitment and benefits.
• Customized BAS005 process in benefit administration.
• Performed customizations to add new Fields to the record FH EMPLYMENT clone of PS EMPLOYMENT record to meet the client requirement. Used People Code to control the program flow logic and for the validation to meet the current business rules.
• Developed new Conversion SQR programs for flat file creation by mapping the fields between legacy and PeopleSoft systems.
• Developed several outbound interfaces to transmit the benefits related data to the vendors.
• Involved in troubleshooting many Employee Self Service issues.
• Customizing self-service pages of e-pay, e-Recruit, e-benefits and e-Compensation with Manager Self Service’s (MSS).
• Modified search records to implement row level security.
• Developed Application Engine Program to Load the External Data into staging Tables and from staging tables into PeopleSoft application tables.
• Developed main SQR interface to convert legacy system data to PeopleSoft Application tables. SQR functionality included data validation, processing, and error handling procedures.
• Participated in scheduling / running the jobs in mainframes environment using JCL.
• Communicated with the testing team to resolve the issues.

Environment: PeopleSoft HRMS (HR, Benefits, Benefits Administration), People Tools, STAT, Windows NT, UNIX, SQR, Application Engine, File Layout, People Code, Component Interface, JCL.