Senior Peoplesoft Consultant. Resume
Bradenton, FL
EXPERIENCE SUMMARY:
- Overall9+ years of experience in PeopleSoft as a Senior Techno Functional Resource.
- Extensive exposure to full software development life cycle from Requirement Gathering, Analysis, Design, Development and Deployment.
- Proven expertise in PeopleSoft HRMS as a Techno Functionalconsultant
- Strong working knowledge in functional and technical aspects of PeopleSoft HRMS modules: Administer Workforce(Core HR), Base Benefits, Benefits Administration, Payroll for North America, Talent Acquisition Management, Time & Labor,Position Management,Profile Management, Compensation, ePerformance,eProfile, eDevelopment,ESS, MSS, Absence Management&PeoplesoftSecurity.
- Strong working knowledge in PeopleSoft Development tools like PeopleCode, Application Designer, Component Interface, Data MoverScripts(DMS),HTML, Application Package, Integration Broker, Application Engine, PSQUERY, XML Publisher, SQR. .
- Experience in PeoplesoftHRMS Implementation 9.0 & 9.1 from end - to-end.
- Proven expertise in PeopleSoft CRM as a Techno Functional consultant.
- Experience in Peoplesoft Application upgrade from Peoplesoft HRMS8.9 to 9.0 &Peoplesoft HRMS9.0 to 9.1
- Experience in Peopletools upgrade from 8.50 to 8.52.
- Experience in data conversion from legacy systems into Peoplesoft system using Application Engine & Component Interface.
- Part of production support team after successful implementation of PS modules for enhancement and supporting customer queries.
- Sound knowledge of ERP implementation methodology and relevant associated quality processes
- Expert at not only customizing delivered PeopleSoft applications, but also creating Components, Pages, Security, Application Engine programs, Component Interfaces and SQRs from scratch to meet the business needs.
- Expertise in using SQL tools with SQL Performance tuning experience.
- Good knowledge of Approval Workflow Engine (AWE), configured the same.
- Loaded data from flat files to PeopleSoft tables using App. Engine/SQR programs and SQL scripts.
- Expert in preparing complex reports using SQR, PS Query& XMLP.
- Good knowledge of Peoplesoft Patch, Maintenance Pack & Bundle.
- Good working knowledge of Peoplesoft Internet Architecture (3-Tier), Weblogic, Tuxedo & Web services.
- Excellent debugging and problem solving skills.
- Experienced in handling multiple tasks at a time, emphasize on timely delivery of my & Team deliverables&able to mentor colleagues.
- Quick learner and a good team player.
- Key strengths - Good communication skills, analytical skills& Leadership skills.
TECHNICAL SKILLS
PeopleSoft: HRMSversion8.3, 8.9, 9.0, 9.1.
Modules: PeopleSoft HRMS Core HR, Benefits, Talent Acquisition Management, ESS/MSS, ePerformance, eDevelopment, Payroll for North America, Position Management, Compensation, Profile Management,eProfile,Absence Management Time & Labor,PeoplesoftSecurity.
People Soft: CRM versions8.8, 8.9, 9.0, 9.1
Modules: Peoplesoft CRM Support, Helpdesk, Service Order,Active Analytics Framework, Worker, Worklist, Customer Data Model (CDM),360 degree, Business Object Relationship Model(BORM), Worker 360 degree view,Configurable Search, Display Templates.
PeopleTools: 8.4x, PeopleTools 8.5x, PeopleCode, Application Engine, Application Package, Component Interface, PS Query, XML Publisher, SQR, Integration Broker, Business Interlink, Workflow, SQL,HTML, Data Mover Scripts(DMS), Application Messaging, Approval Workflow Engine (AWE), Integration Broker, Unix Environment & Unix shell Scripts.
Languages: PeopleCode, C, C++, SQL
Database: Oracle 10g, MS SQL Server
PROFESSIONAL EXPERIENCE
Confidential, Bradenton, FL
Senior Peoplesoft Consultant.
Responsibilities:
- Performing the Role of Senior Peoplesoft HRMS Consultant.
- Involved in Effort estimation, Requirement gathering & analysis, Development, Unit Testing& Support of Projects.
- Extensively worked on Projects including Inbound & Outbound Peoplesoft HRMS Interfaces using Application Engine, Component Interface, File layout, etc.
- Designed and developed custom applications from scratch. This includes creating new PeopleSoft objects like fields, records, pages, components and registering the components and providing security.
- Created Application Engine using Component Interface to put the Pay End date in Additional Pay for Termination cases.
- Created Benefits Outbound Interface using Application Engine for Employees & their Dependents who are enrolled in Medical Benefits. This was a change only Interface where if Empls attains certain age or if there is any change in the field (Rehire date, Death date), Employee & Dependents will come provided they are enrolled in Medical Benefits.
- Worked in Data conversion for a Company acquired by Confidential called Ambrose. Wrote Application Engine/Component Interface to put their data into Peoplesoft HRMS system. Converted their Job data & Personal data into Confidential system.
- Created custom Application engine to upload the Net Promoter Score of different Companies supported by Confidential & display the same in Custom Page.
- Uploaded the Compensation data(Market Pay Data) using Matrix functionality from flat file. This is done using Application Engine & Component Interface. Used 3 Component Interfaces for this, Matrix creation, Matrix association with Job Code & Job Code insert. In the end Matrix data was displayed in Job Code Page.
- Created multiple custom fields in the Custom Page to act as a Set up data for Company acquired by Confidential .
- Extensively worked on Integration Broker between Peoplesoft HRMS &Peoplesoft CRM.
- Implemented messaging like Person sync & Workforce sync between Peoplesoft HRMS &Peoplesoft CRM.
- Extensively worked on PS Query for multiple Reports requested by Customer.
Environment:PeopleSoft HRMS 9.0
Confidential, Columbus, Ohio
Tech Lead, Application Developer.
Responsibilities:
- Performing the role of Technical lead for Peoplesoft HRMS Projects.
- Involved in Effort estimation, Requirement gathering & analysis, Development, Unit Testing& Support of Projects.
- Meeting with Business to gather requirements, translating them into Technical design doc, Development & Unit Test.
- Expert in Customization, did lot of Customization as per Business needs.
- Preparing Tech design doc based on requirements from Business & then assigning to Developers for Development. Supervising till it goes to Production.
- Experience in implementation of ePerformance, eDevelopment, Profile Management(My Profile).
- Worked in Data conversion for a Company acquired by Nationwide. Wrote Application Engine/Component Interface to put their data into Peoplesoft HRMS system. Converted their Job data & Personal data into Nationwide system.
- Implemented ePerformance Reports. This was done using XMLP. Pie Charts &Bar graphs were created in the Customized Page to help Managers in analyzing their direct reporting EmplsePerformance data. Reports were prepared to show for different ePerformance Steps, about how many Empls have Not Started, In Progress, Completed, No Document of ePerformance. This helped Managers to follow up with the Team for completing their ePerformance steps.
- This functionality was provided to HR so that at higher level, Business can run the Reports for Managers.
- Worked in Peoplesoft HRMS application upgrade from HRMS 9.0 to 9.1.
- Retrofitted many SQR’s as part of Peoplesoft Upgrade from HRMS 9.0 to 9.1.
- Responsible for People Tools upgrade of PeoplesoftHRMS from PeopleTools 8.50 to 8.52
- Customized MyProfile Page as per Business need.
- Helped Business in setting up the Profile set up data like Degree, Licenses & Certificates.
- Responsible for People Tools upgrade of Peoplesoft CRM from PeopleTools 8.50 to 8.52
- Working in PeopleSoft HRMS following modules: Core HR, Benefits, Talent Acquisition, ESS/MSS, Payroll for North America,ePerformance, eDevelopment, Security.
- Worked in Helpdesk Module of Peoplesoft CRM 9.1.
- Modified Termination Workflow as per Business requirement.
- Modified Approval Workflow Engine (AWE) for Promotion transaction.
- Created multiple HTML fields in Customized Peoplesoft Pages as per Business need.
- Worked on a Summary Annual Report (SAR) project where SAR doc’s needed to be sent to Active Empls having enrolled for Medical, Dental & Vision Plan, Empls having Your time off, Retired Empls participated in the particular year. Created Page/Component/Application Engine to handle this. Allowed Business to run 3 types of Reports & send Email to Active Empls with SAR docs. Handled the Out of office Response as the Emails had to be sent to 30K+ Empls& there could be Empls who are out for vacation.
- Worked on eDevelopment Reports using XMLP. This was implemented so that Managers can view the Reports of their direct reporting Empls. The xml File being generated for an Executive at very high level had to be zipped using Java functions as Lotus Notes cannot handle big file.
- Responsible for meeting the SLA agreements with Nationwide.
- Designed and developed custom applications from scratch. This includes creating new PeopleSoft objects like fields, records, pages, components and registering the components and providing security.
- Extensively worked on Projects including Inbound & Outbound Peoplesoft HRMS Interfaces using Application Engine, Component Interface, File layout, etc.
- Uploaded the Job data through Application Engine & Component Interface.
- Extensively worked on Integration Broker between Peoplesoft HRMS &Peoplesoft CRM.
- Implemented messaging like Person sync & Workforce sync between Peoplesoft HRMS &Peoplesoft CRM.
- Extensively worked on PS Query & XMLP Reports.
- Worked on Customizationof Absence Management module. Customized the various pages as per business needs.
- Customization of the Absence Request, Absence History. Setting up of Earnings, deductions, Accumulators, Schedules within the Absence module.
- Worked on Outbound Benefit Interfaces using SQR & Application Engine.
- Worked on Application packages to support the Customizations.
- Extensively worked on SQR for creation of new Reports & modifying existing Reports.
- Worked on Project including integration with Peoplesoft Finance 9.1 using Integration Broker. Set up/Created asynchronous Direct Deposit Messages to Finance.
- Applied PeopleSoft Payroll Tax Updates that includes updates to tax tables, COBOL program changes and SQRs for payroll reporting.
- Resolving high priority bugs for the Employees of Nationwide.
- Solving Clients Functional & Technical requests on higher priority.
Environment: PeopleSoft HRMS 9.1, Peoplesoft CRM 9.1Peopletools: 8.50, 8.52
Confidential, Chicago, IL
Senior TechnoFunctional Consultant.
Responsibilities:
- Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
- Worked in Helpdesk Module of Peoplesoft CRM 9.0 & Core HR, ESS/MSS, Security of People soft.
- Meeting with Business to gather requirements, translating them into Requirement doc, Technical design doc, Development & Unit Test.
- Created test plans which is used by testing team to test the Project/Enhancement/Defect. Involved in end to end testing.
- Customized online pages, wrote PeopleCode, created new tables and views to meet the client needs.
- As part of requirement, created Dynamic view to help HR Business partners to see the HR information one level above what they are authorized to view. View used SJT (Security Join tables) & a customized role (+1 access means Supervisor access) to provide them this access. Used SQL queries in the Dynamic view.
- Implemented below Manager Self Service Transactions to update the Job data of Empls after the transaction got approved.
Confidential
Termination
Responsibilities:
- Made extensive PeopleCode changes at various places throughout the Application including Events, Application Packages, App Engine programs and Component Interfaces to meet the business needs.
- Created Application Engine using Job data Component Interface to upload the Job data from the csv file. This is extensively used in ABN AMRO to upload the Job data throughout the year.There could be Job data change for different reasons like Data change, Transfer, etc.
- Worked on creating Interfaces to upload the data in Job data Component using Component Interface.
- Expert in Customization, did lot of Customization as per Business needs.
- Created Delegation Process (Application Engine) in Peoplesoft 8.3 which allowed Managers to create their Proxy when they are not available in the Organization. This includes assigning new User Id’s to Proxy Users, new Roles to them, sending them Email for notification. The process had capability to revoke the delegation when Manager is back.
- Worked on the Candidate Gateway (e-recruit) module for online job postings.
- Customization, Enhancement & Production Support of ESS/MSS Module in Peoplesoft HRMS, Helpdesk in CRM
- Extensively worked on Integration Broker between Peoplesoft HRMS &Peoplesoft CRM.
- Implemented messaging like Person sync & Workforce sync between Peoplesoft HRMS &Peoplesoft CRM..
- Extensively worked on PS Query & XMLP Reports.
- Worked on Outbound Benefit Interfaces using SQR & Application Engine.
- Responsible for meeting the SLA agreements with ABN AMRO.
- Resolving high priority bugs for the Customers of ABN AMRO.
- Make the customers understand the Functionality Core HR, ESS/MSS, Security Modules, Talent Acquisition Management,Administer Workforce of People soft HRMS, Helpdesk CRM.
- Created Department, Created new Tree Structure and added new DEPTID to the Department Id Trees within Tree Manager. Responsible for running the Security refresh processes.
- Maintenance and enhancement of the Integration Broker setup for data flow between different PeopleSoft applications.
- Worked extensively in analyzing, designing and developing in Absence Management module. Customized the various pages as per business needs.
- Worked on the integration of Absence management with the North American Payroll processes.
- Customization of the Absence Request, Absence History, Time keeper entry panels. Setting up of Earnings, deductions, Accumulators, Schedules within the Absence module.
- Designed and developed new AE programs for effectively capturing employee absence information and feed the same into Pay earnings and pay other earnings.
- Mentoring & giving KT to new members of the Team.
- Setting up the data as per Business Requirement. Added Action, Action reason, Department, earning Codes in the set up Table.
- Solving Clients Functional & Technical requests on higher priority.
- Coordinatingwith offshore Team for resolution of their Queries.
- Compare and migrate projects from one environment to another using Application Designer and copy data using Data Mover.
Environment:PeopleSoft HRMS 8.3, 8.9, Peoplesoft CRM 9.0
Confidential, MO
Techno Functional Consultant
Role &Responsibilities:
- Responsible for meeting the SLA agreements with the Sprint.
- Involved in the Development, Upgrade and testing of all the HR/Benefits, Payroll, Time & Labor interfaces as a key team player of the Interface team.
- Successful in creating, upgrading and generating custom HR, Payroll, Time & Labor inbound and outbound SQRs and SQCs for the HR upgrade project.
- Performed research and study of the existing system tables and business processes. Also involved in the in-depth study of customizations made in HR, Payroll, Ben Administration and Time & Labor modules.
- System Support, Providing Solutions to Sprint for PeopleSoft Benefit Module &Peoplesoft CRM Helpdesk module.
- Analysis, Troubleshooting and debugging of Application engines.
- Fixed critical and urgent priority bugs and giving workarounds to the Client.
- Wrote & Executed Test Cases to check the Functionality of PeopleSoft Benefit Module&Peoplesoft CRM Helpdesk module.
- Worked extensively on customizing components like Job requisition, applicant activity, interview screening, and job offers panels. Written PeopleCode program to customize the same.
- Worked extensively in analyzing, designing and developing of some phases in Talent Acquisition Management module.
- Setting up job locations, recruiter’s roles, job openings, applicant setup, and job offers, recruiting statues, and various templates etc. with the TAM modules.
- Responsible for Implementation of new company for Sprint. Involved in complete setup, configuration, data conversions and loading of the same from legacy system into PeopleSoft.
- Addressed various issues related to Performance tuning and troubleshooting of various SQR Processes which included SQL Query Tuning which was taking very long time to execute
- Developed, tested and modified SQRs, PS Queries as per Business need.
- Involved in creation of records, pages, components and menus, to display additional information, using People Code to incorporate validation rules according to the specifications.
- Customized Application Engine process as per client requirement.
Environment:PeopleSoft HRMS 8.9, HRMS 9.0, CRM 8.9
Confidential
Techno Functional Consultant
Role &Responsibilities:
- Worked as part of primary production support team and provided production support to HR, MSS, ESS, TAM, Payroll for North America, Benefit modules.
- Designed and developed custom applications from scratch. This includes creating new PeopleSoft objects like fields, records, pages, components and registering the components and providing security.
- Cleaned up Security for old Roles & Permission lists which are not being used anymore in the system. Streamlined Security process & naming convention of every new Permission list to be created. Created new Roles for different Permissions as per Roles being played by different Team members. Different Roles were created for different environments like Dev, ST, UAT & Production.
- Involved in the Development, Upgrade and testing of Core HR, Benefits, Payroll.
- Successful in creating, upgrading and generating custom HR, Payroll,Inbound and Outbound SQRs and SQCs for the HR upgrade project.
- Performed research and study of the existing system tables and business processes. Also involved in the in-depth study of customizations made in HR, Payroll, Benefits Administration.
- Customized several pre-delivered Payroll SQR Reports.
- Involved in Setting up Pay sheets and Pay Calendar for Hourly and Salaried Employees. Building time period calendar and employee schedules. Maintain Payroll data viz., Employee tax data, general deductions, direct deposits, and savings bond. Establish run controls for payroll process. Perform pay calculations and pay confirmations. Modified delivered payroll reports.
- Worked with clients to design and implement modifications and customizations to tables, components and programs to meet business requirements.
- Worked on various customizations for upgrading application from 8.8 to 8.9 involving People Code, SQR, Application Engine, Component Interface, Components, Pages, Menus.
- Worked to retrofit customizations to the upgraded 8.9 system.
- Responsible for applying any production data changes to the upgrade environment while upgrade is in progress. This includes tax updates and other client specific customizations.
Environment:PeopleSoft HRMS 8.8, 8.9 & 9.0
Confidential
Techno Functional Consultant.
Responsibilities:
- Attended Boot camp Training for PeopleSoft.
- Involved in the gathering the specifications, Design and development of the Inbound & Outbound Interfaces by using SQR and Application Engines.
- Cleaned up bad data for My Profile.
- Involved in configuring and customizing e-Performance, e-Profile.
- Implemented various outbound interfaces benefit/payroll interfaces being sent to different vendors, to health plan providers, to banks and also for various other benefit plan providers using SQRs.
- Identified, supported and involved in trouble-shooting the issues of the Interfaces by modifying the SQRs and App. Engine Programs for the Integration Testing, System Testing.
- Worked on creating multiple reports using SQR.
- Customized People Code on different events to implement validations and control of the program flow.
- Involved in fixing defects during system testing.
- Involved in writing System Test Scripts for System testing.
- Analysis, Troubleshooting and debugging of Application Engines (Interfaces).
- Fixed critical and urgent priority bugs and gave workarounds to the Client.
Environment: PeopleSoft HRMS 8.8, 8.9 & 9.0