Peoplesoft Consultant Resume Profile
Summary
I am a senior PeopleSoft specialist with a demonstrated experience of almost 11 yrs in PeopleSoft HRMS/HCM Applications. A strategic leader and a results-driven implementation professional with a demonstrated ability to architect solutions and successfully lead business or technical initiatives. Provided Technical and Functional Leadership in a variety of PeopleSoft projects which include Implementation and Production support. As a savvy consultant, I can leverage my diverse business, technical and industry experience to assist organizations to become more efficient and profitable using leading practices in business and technology. I also have experience delivering numerous Bolt-on applications integrated with PeopleSoft modules as per the client business. I am focused on effective business and technical leadership, facilitating consensus and understanding the business needs, as well as, an ability to work with executive leadership and line management has complimented my development and implementation of solutions.
Expertise / Skills Summary
- Worked in Government, University,HealthCare,Wireless,Utility,Retail,and Insurance
- Involved in 9 PeopleSoft implementations/Support/Integration/Upgrade projects in 9.0, 8.X versions.
- More than 3 full cycle implementation projects.
- Experienced Fit-Gap analyst planned and conducted Fit-Gap sessions.
- Experienced in data conversion of various modules Health and safety, Payroll, Benefits,Campus Solutions
- Have extensive hands-on experience with development tools and posses in-depth knowledge of PeopleSoft applications.
- Very good knowledge of PeopleSoft Architecture AppServer/WebServer/Tuxedo/PIA/Process Scheduler etc.
- Experienced in tuning processes, analyzing explain plan and determining necessary steps to improve timing and performance.
- Expert in designing/development of Interfaces with legacy and third party systems
- Experienced in PeopleSoft security related to creating and assigning Permission Lists / Users / Roles
- Conducted interviews with Subject Matter Experts to examine end user job responsibilities and module functionality to identify training needs User acceptance testing and documentation
- Have managed and architect applications and delivered them according to a defined project plan.
Professional Experience
Confidential
Sr.PeopleSoft Consultant
- Involved in Designing, developing HR modules for ATT Mobile users.
- Extensively used People code, Application Packages for developing action pages and interfaces.
- Developed interfaces to import employee time schedules from Kronos to PeopleSoft.
- Developed interfaces to send employees schedule information to Kronos from PeopleSoft using Integration Broker.
- Created Interfaces using people soft Web services, Integration broker, Application Engine and parallel processing.
- Involved in 3 full life cycle implementations.
Environment: Oracle 11g, people Tools 8.50.08, Peoplecode, Integration broker, Web services, App Engine, Process scheduler, Work flow, Application designer, FileLayout,IScript, XML Publisher,PSQuery,Component Interface,SQR, Excel to CI,ParallelProcessing
Confidential
Sr.PeopleSoft Consultant
- Worked with Production support team 24/7 during the Weekly/Bi-weekly Payroll run process to fix any problems for the Paycalc process and other nightly batch process.
- Resolved the issues related to Post payroll reports and interfaces like Payroll Register, Payroll Summary, DDP Register and the Payroll Calculation error for new Deduction code.
- Involved in resolving the unique constraint error on PS PAY DISTRIBUTN table during payroll process.
- Responsible for Tax updates and w2 yearend processing.
- Fixed issues related to GL statistical interface and Batch Interface
- Extensively involved in PeopleSoft HRMS upgrade from v8.0 to 9.1.
- Upgraded PeopleSoft HRMS HR, Payroll, Base Benefits
- Upgrading, Support and Troubleshooting Technical Functional issues.
- As part of Upgrade from PeopleSoft HRMS 8.0 to 9.1, performed impact analysis and retrofitting of internal external objects.
- Designed and Developed new interfaces for comp planning in the format requested by Workscape using File Layout, Component Interface and AE.
- Worked with core HR users to resolve the issue with new fields default values and translate values.
- Involved in Admin activities like applying Rimini Street bundles, patches to Tax Updates and post refresh activities
- Involved in HR mass data uploads using Excel to CI
- Modified/Created SQR reports/interfaces/PS Queries and Modified custom PS objects.
- Involved in Fine Tuning of SQR's, Application Engine Programs Component Interface to increase the performance using parallel processing and other techniques.
- Extensively used Control-M for setting up the reports to run at specific times
Environment: Oracle 11g, NA Payroll, Base Benefits, Ben Admin, HRMS 9.1, people Tools 8.50.08, Peoplecode,Integration broker, App Engine,peoplecode, Process scheduler,Work flow, Application designer,FileLayout,IScript, XML Publisher,Control-M Scheduling,PSQuery,Component Interface,SQR,PS-Query, Excel to CI,ParallelProcessing
Confidential
Sr.PeopleSoft Consultant
- Resolved Online processing errors, Calendar process errors, Pay sheet process errors, Pay cal errors and Pay confirm errors, Un confirm errors, Reversal errors as part of NA Payroll support.
- Involved in the development of Mass Upload program which will insert rows in JOB and Position Data Tables.
- Involved in the development of Leave Accrual Balance program which will inserts rows in to Leave Accrual Balances.
- Used PHIRE migration tool to migrate objects from one instance to another instance.
- Involved in Schedule of Classes, Combined Classes, Class Association conversion from legacy system to PeopleSoft campus solutions using App engine , Component Interface and Parallel processing.
- Involved in planning and executing PeopleSoft upgrade from 8.9 to 9.0
- Used Change assistantance to execute the upgrade activities.
- Detailed impact analysis was done to identify the objects, compared between old and new model to retro fit. All customized objects were identified, exported and migrated.
- Permission lists, Roles were modified to meet the upgrade system navigation and customization.
- Detailed testing was planned at various stages, executed and results were validated before releasing the system to users.
- Involved in Milestones conversion from legacy system to PeopleSoft campus solutions using App engine, Component Interface and Parallel processing.
- Involved in developing a notification to the students regarding their drop implications via email to direct them to the student center through a generic message to check their student account record.
- Created custom Component to provide LSCS students the ability to add banking information via self service in order to receive any type of student refund via direct deposit instead of having to wait for a paper check through U.S. Postal service.
- Developed an interface which will quickly and accurately load information about students and employees into the Library system Horizon in a batch mode, therefore preventing library staff from having to do this manually. It is a customer service issue for all the libraries. It greatly reduces the amount of time a student has to stand in line waiting to check out library materials for the first time.
- Created an Interface to send student, employee, course, and enrollment data from PS to Angel.Angel is a learning management system LMS software that is used for the delivery, tracking, and management of training or learning.
- Created a CE Daily Pull report which provides information to generate reports during term processing. It also provides a clear visual audit of courses already scheduled for the current and past terms for Continuing Education.
- Involved in course list creation which will allow LSCS staff to quickly and correctly create a course list in order to link a student to a third party contract
Environment: Oracle 11g, NAPayroll,BaseBenefits,HRMS and Campus Solutions 9.0, people Tools 8.50.05, Windows NT,Peoplecode,Integration broker,App Engine,peoplecode, Process scheduler,Work flow, Application designer,FileLayout,IScript, XML Publisher,PSQuery,Component Interface,SQR,PS-Query,PHIRE migration,Change Assistance,Upgrade
Confidential
Sr.PeopleSoft Consultant
- Customized Dynamic group sub-page TL GROUP SBP to add Dynamic Group ID to Row Security Permission List dynamically using TL GRP SECURITY table.
- Customized the Check Print SQR PAY003 to automate its size depending on number of earnings, taxes and deductions.
- Customized the PAY009 Print Paysheets sqr as per the clients requirement
- Created Mass update program to update the Line of work for Time and Labour module.
- Involved in developing new Application Engine to send Remainder mails to all the TimeReportees.
- Involved in Data base Designs ,technical design documents ,Functional Design Documents ,Dataflow diagrams ,Coding ,Bug fixing and Data conversions. 2 Full Life Cycles
- Developed new Health and Safety module for VZB and VZT Business Units later Integrated VZT with VZB.
- Participated in meetings with client to gather requirements and worked with offshore development team to ensure that requirements are dubbed correctly.
- Involved in E-performance bug fixing and enhancements.
- Designed the conversion approach for converting the legacy data into PeopleSoft and came up with a strategy to put conversion task into execution.
- Integrated Health and safety system with real estate system using Integration Broker.
- Review validated the design Proof of Concept scripts.
- Participated in the peer reviews of requirement analysis/assessments.
- Participate in Design Review sessions with Business user.
- Created, designed and implemented test plans, test scripts for various cycles of testing using Quality Center.
- Fixed the custom online pages using People Code.
- Created Technical and Functional design documents for the Interfaces and customizations.
- Used ExceltoCi tool to load the data into config tables.
- Using available resources efficiently to meet the project time lines.
- Developed interfaces, message definitions message channels to support third party system integration.
- As a day-to-day routine provided support to the users and knowledge transfer to users.
- Work in the area of Fit Gap analysis and prepared the Gap resolution documents.
- Worked on Interfaces and customizations Using AppEngine, Component Interface, People Code, File Layouts and Integration Broker.
- Implemented row-level security using Dynamic Views
- Created HELP documents using I-Scripts.
- Experience in creating the estimation documents by analyzing the metrics for the new enhancement projects.
- Involved in Fax to File implementation as per the clients requirement.
Environment: Oracle 10g, PeopleSoft HCM/HRMS 9.0, Performance Management, Health and Safety ,NA Payroll, Time Labor, Cognos , MS Office Visio, people Tools 8.49, Windows NT,Peoplecode,Integration broker,App Engine, Process scheduler,Work flow, Application designer,FileLayout,IScript, XML Publisher,PSQuery,ComponentInterface
Confidential
Sr.PeopleSoft Consultant
- Provided functional and technical support for Payroll, Time Labor, HR and Base Benefits modules. And resolving migration/version problems using application reviewer and trace files generated by SQL trace and People Code trace.
- Involved in creating a custom page for Time and Labour module to categorize employees based on their Line of Work.
- Involved in customization of SQR's and Application Engines.
- Involved in newly developed Supervisor Report Application Engine-SQR Process which sends Mails to All supervisors with their direct reportee's time sheet data.
- Involved in creating a custom page to categorize employees based on their Line of Work.
- Created Mass update program to update the Line of work
- Involved in developing new Application Engine to send Remainder mails to all the TimeReportees.
- Involved in bug fixing of calculation of total hours.
- Involved in the generation of SQR, which is an external interface to the GTMS System include interfaces with the PeopleSoft HRMS and OPX2 Systems.
- Involved in the development of SOX audit report.
- Handling Security Requests for both department super user and Manager Request
- Developed and customized reports according to client requirements using SQR, PS/Query
- Involved in customizing panels and developed new panels. Worked with People Code that is associated with the objects to meet the client requirements.
- Defined Process definitions, and created run control panels to run several processes using Process Scheduler.
Environment: Oracle 9i, PeopleSoft HCM/HRMS 8.8, Time and Labour, HR, Cognos, people Tools 8.44, Windows NT, peoplecode,App Engine, process scheduler,SQR,App Engine,Process scheduler,Work flow, C.I
Confidential
PeopleSoft Consultant
- Functional/Technical understanding of the clients Business
- Interacting with the user to understand the report and customization requirements.
- Analyzing user requirements
- Change request handling related to new reports and enhancement of people soft Application
- Developing the Queries using PS Query tool
- Issue analysis/Resolution
- Involved in Unit Testing
- Review Test plan/Test Result/Delivery
- Developed new Self service module called Reimbursement.Submodules in reimbursement are
- Accident on Duty
- Personal Accident Policy
- Family Planning Medical Expenses and Tuition Fee Reimbursement
- Created batch mass automated enrollment process to automatically enroll employees into appropriate Benefit Plans as per their eligibility
- Created batch mass automated enrollment process to enroll employees into Social Security Regulatory plan. This plan is mandatory for all the employees except Contractors FTH .
- Created batch mass automated enrollment process to enroll employees into the Obligation Fund. Contribution towards this fund is paid by Employer to the Social Security department once a year.
- Used Component Interface and Application Engine to load the data into custom component called SIMPLE BENEFITS.
Environment: Oracle 8.x, PeopleSoft HCM/HRMS 8.x,Core HR, people Tools8.x, SQR, Cognos Reporting Tools and Windows NT , PS Query
Confidential
PeopleSoft Consultant
- Involved as a Technical Consultant and responsible for the all the Technical Enhancements, Investigations and Development work on the H I Benefits as per the requirement by directly interacting with the client.
- Also responsible for running the Weekly, BI-monthly and Monthly Payroll-Interfaces Various reports sending the o/p files to different vendors of the client.
Environment: People Tools 7.59, PeopleSoft HCM/HRMS 8.x, NA Payroll, Base Benefits, UNIX, Windows NT, Oracle8i,SQR.
Confidential
PeopleSoft Consultant
- RDM PM Notification of Hiring Pipeline resource Status Workflow
- PM notification on Resourcerolloff within 30 days period Workflow.
- Inbound Interface to populate employee skills data from PD Tool by using File Layout
- PeopleCode validations while assigning a resource for a service order in the Assign Resource Page.
- Creation of new fields related to Employee and in Service Order Header and line.
- Customer master details- Owning Organization updation
- Experience in Migration of projects from Development to QA.
Environment: People Soft HCM/HRMS 8.44.06, CoreHR, PeopleTools8.x, Windows NT, oracle8i, WorkFlow, Peoplecode.
Confidential
PeopleSoft Consultant
- Involved in the development of an Application Engine interface, which will develop an automated process to pull and sort the current business day's employee adds/updates/changes/deletes and create files to FTP to Kronos UNIX server.
- Involved in the generation of Common HR file Format And Generated the OUTFILE by using File Layout based on the Common HR file Format for American Express which is a credit card vendor for Cargill.
- Involved in the development of an interface, which will pass all the earnings and deductions per employee per period on a monthly basis.
- Involved in the development of interface for communicating the contributions to Standard Life. Standard Life is the RRSP plan for Canadian employees.
- Involved in the generation of report, which is used to validate the different pay groups being processed for the current payroll.
- Involved in the generation of report, this reporting table is a copy of the existing PER099 App Engine process.
- Involved in sending new employee or newly eligible employees to the stand alone Pension Administration system as additions and also to send demographic data updates name, address, job data fields and monthly hours and earnings on existing employees in the system.
Environment: People Soft HCM/HRMS 8.44.06, People Tools8.x, NA Payroll, Core HR, Windows NT, oracle8i, AppEngine, WorkFlow, FileLayout, and Component Interface.
Confidential
PeopleSoft Developer
- Wrote People Code programs for online validations and for functional processing.
- Created new SQRs by cloning the existing and modified them to generate the SQR's.
- Involved in design and development of conversion programs using SQR for transferring of data from legacy system to PeopleSoft HRMS.
- Involved in Data conversion, Data migration and Integration solutions using SQR and Data Mover.
- Involved in customization of Pages and Menus using Application Designer.
- Defined Process definitions, and created run control panels to run several processes using Process Scheduler.
- Gathered, audited and finalized production data, setup HRMS data, BenAdmin tables, payroll data and loaded data into production and tested HR/Self-service pages. Involved in customizing the Employee portal for employees.
- Created and customized Workflows to automate the process of notifying helpdesk, security and facilities admin whenever a new hire/rehire/termination was made for regular / temporary employees for different regions.
- Involved in Development /Customization of Reports, Processes and Pages to meet the deliverable dates using AEs, App Messaging, SQRs, People Code and other PS Tools.
- Involved in production support and maintenance for Benefits and HR modules.
Environment: People Soft HCM/HRMS 8.44.06, People Tools8.x, Core HR, Windows NT, oracle8i, SQR, Process scheduler, Peoplecode, Application designer.