Peoplesoft Senior Technical Consultant Resume
PROFESSIONAL SUMMARY:
- 13+ years of total IT experience in analysis, design, development and implementation of PeopleSoft HRMS and Financials Modules.
- Expert in developing and customizing PeopleSoft HRMS modules including Core HRMS, Benefits Administration, Base Benefits, Payroll, Time and Labor & Payroll for North America, Position Management, Talent Acquisition Manager, Candidate Gateway, Time & Labor, Self Service Modules like eProfile/eProfile Manager, eRecruit, ePerformance, eCompensation.
- Expert in developing and customizing PeopleSoft General Ledger (GL), Accounts Receivables (AR), Billing, Order Management, Accounts Payables, Program Management, Project Costing, Staffing Front Office, Resource Management Modules.
- Involved in the complete life cycle of PeopleSoft HRMS Modules.
- Knowledge of PeopleSoft EPM Module.
- Excellent working experience of PeopleSoft 8.x PIA (PeopleSoft Internet Architecture), Web Browser, Web Server, Application Server, Data Base Server and Change Assistant.
- Proficient in Integration Tools including Component Interfaces.
- Expert in Peoplecode and People Tools including Application Designer, Security Administration, Change Assistant, Application Engine, Application Debugger, Data Mover, Approval Workflow Engine (AWE), File Layout and Process Scheduler.
- Extensive experience implementing and supporting Application Messaging using Integration Broker..
- Extensively developed report applications using PS Query, SQR and Crystal Reports.
- Excellent data modeling, analytical and problem solving skills.
- Proficient in all phases of the systems development lifecycle, including Requirements Definition, Data Conversion, System Implementation, System Testing and Acceptance.
- Familiar in Application messaging tool.
- Very good team player with excellent Communication skills.
- Proficient in Manual Testing.
- Worked on PVCS tracker for issue logging and communicate the fix to the users and testers.
- Worked on STAT Version Control Tool for Migration between Development to Testing and Production Environments.
TECHNICAL SKILLS:
OPERATING SYSTEMS: MS - DOS, Windows Vista, 2000/98/95/NT4.0, Unix.
ERP TOOLS: PeopleSoft 9.0/8.9/8.8/8.4/8/7 HRMS and EPM
DATABASES: Oracle 9i/8.0.4/7.x, SQL Server7.0/6.5/6.0,DB2/OS390.
LANGUAGES: SQL, PL/SQL, C
GUI TOOLS: Dev 2k, and People Tools
REPORTING TOOLS: SQR, Crystal Reports, PS Query Security
INTEGRATION TOOLS: Component Interfaces, File Layouts
PROFESSIONAL EXPERIENCE:
Confidential
Peoplesoft Senior Technical Consultant
Responsibilities:
- Worked on requirement gathering from users to support HCM applications.
- Involved in developing interfaces with medical providers for new benefit changes for HQ and Country office staff.
- Extensively developed pages for new self-service data display using Peoplesoft Application designer.
- Involved in writing code for newly developed pages.
- Involved in developed Oracle functions and procedures to retrieve data from Peoplesoft tables and used them in Application Engine programs and SQR reports.
- Developed interfaces to send to CVS and Van Breda vendors for medical coverage.
Technologies: PeopleSoft HCM 9.1 People tools 8.52, People code, Application Engine, Component Interface, SQR, Oracle, SQL, PL/SQL.
Confidential
Peoplesoft Technical Lead
Responsibilities:
- Involved in releases related to HCM applications.
- Worked on Solutions specifications, Technical Design Documents, Unit test cases as part of the documentation.
- Worked on IBM DOORS for document repository and uploads.
- Coordinated technical/functional teams to create design and deliver on-time solution.
- Provided technical support to existing development team.
- Worked on Vision service plans related to Benefits enrollments as Confidential introduced new Vision plans as part of 2015 open enrollments.
- Worked on Open enrollment confirmation letters changes to include new Vision plans.
- Worked on SQR to update interfaces like Aetna, Kaiser, Care Mark, VSP to send updates for 2015 Open enrollments.
- Extensively worked on Same Sex Spouse functionality for the eligible states in Benefits module.
- Worked on Employee Termination process from Manager Self Service.
- Worked on Employee Assisted Housing program issues and maintenance.
- Worked on ACE functionality for employee education funding and changes.
- Worked on Approval Workflow Engine for approvals in HCM modules.
- Worked on Application Engine and File Layouts to fix custom processes developed by Confidential .
- Worked on Payroll for North America Federal and Local tax pages and calculations.
Technologies: PeopleSoft HCM 9.1 People tools 8.51, People code, Application Engine, Component Interface, AWE (Approval Workflow Engine), SQR, Oracle, SQL, PL/SQL, and User Productivity Kit (UPK)
Confidential
Peoplesoft Technical Lead
Responsibilities:
- Involved in gathering requirements from business users.
- Worked as a technical lead in Upgrading Peoplesoft HCM application from 8.8 to 9.1.
- Co-ordinated with Functional and technical team members to ensure timely completion of the project.
- Involved in creating functional design documents and conducting Conference Room Pilots in every stage of the implementation process.
- Configured Time and Labor, Recruiting modules to meet new requirements.
- Worked on Peoplesoft and outlook integration for recruiting module.
- Fixed issues encountered in UAT testing.
- Worked on Benefits Administration and Open enrollment process.
- Worked on benefits plans and benefit program setup for ambassadors’ type employees.
- Worked on modifying benefit eligibility and event rules.
- Worked on Time and Labor rules creation and over time calculation.
- Worked on ADP file creation for exempt and non-exempt employees.
- Worked on Talent Acquisition Management and Candidate Gateway modules to track applicants and in recruiting process.
- Fixed issues related to Manual positive payment process, check reprint, pay cycle processing in Accounts Payable module.
- Developed Approval work flow engine for newly created components for Performance management mass approval.
- Fixed issues related to performance management competencies and goals sections.
- Worked on Compensation manager for employee and manager self-service.
- Worked on Compensation history and compensation pages.
- Developed new SQR reports for Over Time Balance, Salary trend changes, PTO trend analysis for Executive Committee budget processing.
- Worked on setting up different PTO plans for full time and part time employees.
- Worked on Employee and Manager self-service modules.
- Worked on delegation functionality for approval process.
- Worked on Approval Work Flow Engine (AWE) for Recruiting and Time and Labor modules.
- Worked on Integration Broker setup and trouble shooting for Employee and Department sync between PS Financials and HRMS modules.
- Worked on XML publisher for Interview letters to include GMAC specific text.
- Setup Security definitions to meet new functionality.
- Working on Bundles and maintenance pack analysis with new customizations introduced in the system.
Technologies: PeopleSoft HCM 9.1 People tools 8.51, People code, Application Engine, Component Interface, AWE (Approval Workflow Engine), SQR, Oracle, SQL, PL/SQL, and User Productivity Kit (UPK)
Confidential
Peoplesoft Techno Functional Consultant
Responsibilities:
- Worked on Application Engine programs to read Peoplesoft HCM employee information into PS ELM system.
- Worked on Benefits interface for Peoplesoft HCM to benefits system to send employee open enrollment and benefits data.
- Worked on application packages to modify existing logic to in corporate new requirements.
- Extensively worked on peoplecode, file layout and application engine program to integrate PS system with third party vendor system.
- Fixed issues in HCM related to performance management module.
- Developed Head count SQR’s for executives review to analyze Hire, Rehire, Transfer and Termination trends.
Confidential
Peoplesoft Techno Functional Consultant
Responsibilities:
- Implemented Integration Broker messaging components which includes defining and customizing messages, routings and handlers.
- Extensively worked on troubleshooting of IB messages stuck in new status and various types of errors.
- Implemented Combo Code Edit processing on Timesheet Entry and Reported Time components.
- Worked on TIAA CREF interface process sends and receives data from PeopleSoft to Tiaa Cref and ADP.
- Developed and customized People code to in corporate organization requirements.
- Enhanced Future time entry process in Time and Labor during go live.
- Worked on Order management buying agreement issues.
- Worked on Pay sheet creation and payroll calculation in North America Payroll.
- Worked on Create and Update buying agreement page to control display of fields.
- Worked on Candidate Gateway issues when applicants applying from outside Brookings system.
- Fixed issues related to resumes and cover letters not coming in proper order.
- Working with PVCS to work on issues logged by the testers and users.
- Worked on setting up Absence Management types and setup entitlements and group.
- Customized PeopleSoft delivered Timesheet Entry Page to in corporate Brookings requirements
- Responsible for implementing all technical customizations related to PeopleSoft HRMS and Time & Labor Application.
Technologies: PeopleSoft HCM 9.0 & 9.1, Financials 9.0 & 9.1 People tools 8.49.04, 8.50, People code, Application Engine, Component Interface, AWE (Approval Workflow Engine), SQR, Oracle, SQL, PL/SQL, and User Productivity Kit (UPK)
Confidential
Business/Technical Lead
Responsibilities:
- As a Subject Matter Expert in PeopleSoft HCM - performed functional analysis in both 8.8 and 9.0 versions (eRecruit, ePerformance, eCompensation, Core HRMS, Time and Labor, Position Management, Talent Acquisition Management, Candidate Gateway, Payroll for North America, Benefits Administration).
- Worked on development, customization and security on the eCompensation MSS.
- Worked on direct reports and customized approval for ePerformance Module.
- Worked with the business users to gather requirements to apply system solutions to business problems.
- Performed all PeopleSoft configurations to meet business requirements. Involved in documenting system enhancement proposals, outline issues, costs, scheduling, time and benefits.
- As an active team player taking initiative and adhere to coding and documentation standards, file design and storage. Involved in development of HCM modules as a senior level Technical expertise to develop any necessary customizations.
- Worked on Absence takes, Absence entry types, entitlements setup.
- Worked on Absence Management customizations setup absence types and absence entitlements.
- Worked on People code and SQR to customize PeopleSoft HCM modules based on user requirements and generate various reports.
- Involved in Technical Fit/Gap based on the Functional Fit/Gap and documenting the Customizations.
- Worked on Approval Workflow Engine for approval flow in ePerformance and Talent Acquisition Manager Modules.
- Developed ‘Create Maintain Position and Update Reports to Components’ to make Position and Job in Sync and introduced Approval Workflow Engine (AWE) in the mentioned components.
- Worked on configuration of Approval Workflow Engine for new enhancements and customizations to the existing approval workflow.
- Worked on the compare of delta and plugged in the new changes in 8.8 to 9.0 systems.
- Worked on Time and Labor and added the Delegation to the Time and labor Pages as a new functionality.
- Introduced separate custom pages in all existing components to bring the customizations from 8.8 to 9.0 to be a bolt on customization without modifying the delivered code.
- Added new components to MSS for Managers to view compensation history, view job summary, view total compensation for their direct reports.
- Enabled managers and directors to drilldown ‘reporting hierarchy’ to view and perform mass approval of performance documents in MSS.
- Introduced bar charts and pie charts for custom performance analysis and compensation pages.
- Managers and directors can do Performance analysis statistics in graphical representation from MSS.
- Worked on analysis, development for eRecruit, Performance Management, Enterprise Learning Management (ELM), Compensation Management, HCM Data Warehouse and Workforce Analytics (Data marts) PeopleSoft HCM 9.0 Talent Acquisition Manager/Candidate Gateway and User Productivity Kit (UPK).
- Used PVCS Tracker extensively to communicate about the issues between the team members.
- Worked on Priority Placement Process and Basic Eligibility Process SQR’s in Talent Acquisition Management/Candidate Gateway in 8.8 and 9.0.
- Developed new Component Interfaces for Position Management and Job Data to take care of PAR Process.
- Developed new Workflow Definitions to send email Notifications on Approval Process to key people such as HR Advisors, Directors and Agency Directors.
- Created new run control pages for new processes and scheduled the jobs.
- Introduced New Functionality of adding SSN in ‘Applicant Home’ Component in 8.8 eRecruit Module to identify employees applying from outside and populate employee data in the job application.
Technologies: PeopleSoft HCM 8.8, 9.0, 9.1 People tools 8.49.04, People code, Application Engine, Component Interface, AWE (Approval Workflow Engine), SQR, Oracle, SQL, PL/SQL, and User Productivity Kit (UPK)
Confidential, CA
PeopleSoft Technical Lead
Responsibilities:
- Involved in creation of Technical Design documents for People soft new requirements.
- Involved in Fit Gap Analysis for existing system and the current requirements for various processes.
- Involved in understanding Interfaces and Error message for Time and Labor and Recruiting modules.
- Worked on issues and fixes related to ePerformance, Time and Labor, Recruiting, Benefits modules.
- Developed various Test Scripts for User Acceptance Test and uploaded them to Mercury Quality Center.
- Involved in Team Monitoring and mentoring activities and participated in review meetings.
- Developed various Application Engine programs for Time and Labor reminder emails for supervisors and employees.
- Developed SQR reports for compensation trend analysis and Performance trend analysis.
Environment: PeopleSoft 8.8 HRMS, Benefits, North American Payroll, Time and Labor, Employee Self Service, Manager Service, ePerformace, eCompensation, Compensation, PIA, People Tools 8.48.07 Oracle 10g and Windows NT.
Confidential, Tampa, FL
PeopleSoft Techno Functional Consultant
Responsibilities:
- Involved in producing Functional and Technical Design Documents for Record Suites and Current Month for BI functionalities.
- Developed Records, Views, Pages, and Components as part of the Development using Application Designer.
- Extensively Used Application Packages to use Methods across the development.
- Extensively used People code and People code Functions in various People code events to achieve the required functionality.
- Worked on Order Management module issues.
- Worked on AR Update Process in Receivables.
- Worked on Aging Reports in Receivables and Payables.
- Worked on 2 way and 3 way matching of Accounts Payables.
- Worked on Journal Generator process in GL.
- Worked with Chart fields configuration and Calendar setup in GL.
- Worked with Time Zone functionality to work with Day Light Savings for processing Calendar.
- Customized various SQR reports in Purchasing according to the user requirements.
- Participated in testing functionality as a Cross Functional Testing Developer and involved in writing Test Cases and Unit Testing Documents to report the Defects.
- Worked with Quality Center Tool to track and post the Defects.
- Used STAT version control tool to migrate Objects after the development to Testing and Production Environments.
- Worked on STAT to check the upgrade flags while migrating the projects from Development environment to other environments.
Environment: PeopleSoft 8.8 Financials, GL, AR, AP, Purchasing, Billing PIA, People Tools 8.48.07 Oracle 10g and Windows NT.
Confidential, IA
PeopleSoft Techno Functional Consultant
Responsibilities:
- Participated in delivering PeopleSoft Application with new tools and additional enhancements.
- Upgraded SQR’s, Workflows, Crystal Reports, PS Query definitions, Application Engines successfully.
- Involved in different phases of Upgrade includes taking back up of the application in various phases without disturbing the production environment.
- Involved in Entire Upgrade process and performed various online modifications from scratch in HRMS in Version 8.21 using People Tools, Peoplecode and SQR.
- Good Understanding on Billing Interface. eProfile MSS configuration for viewing employee information.
- Made changes to the code according to the business requirement.
- Modified Peoplecode and Application Engines programs to meet the new PeopleSoft version changes.
- Supported client for the post upgrade issues.
- Involved in fixing bugs reported by the onsite team while doing the Upgrade.
- Involved in running the DDD AUDIT and SYS AUDIT to find out the database and application compatibility issues.
- Actively participated in Team mentoring activities as a Team Lead.
- Conducted Trainings to the Team on various Tools like People Code, Application Engine and Component Interface.
- Conducted Trainings on PeopleSoft for ERP and Non ERP consultants in various locations of CSC.
- Worked on PS Query Security, Object Security and Row Level Security.
Environment: PeopleSoft HRMS 8.8, eRecruit, eBenefits, ePay, North American Payroll, eProfile, Absence Management, ePerformance People Tools 8.48, Peoplecode, Data mover, SQR 6.0, Oracle, Unix, PeopleSoft Upgrade Assistant.
Confidential, CA
PeopleSoft Techno Functional Consultant
Responsibilities:
- Completed writing Technical Design Document for the new enhancements.
- Added new field to the Installation options page and displaying it depend on the projects installed in PeopleSoft.
- Involved in General Ledger Consolidation.
- Worked on Standard and recurring Journal process in GL.
- Worked on Maintenance work sheet to cancel the Invoices for balancing Positive and Negative Invoices.
- Working on Integration between AR and Billing module using Application Packages.
- Worked on Direct Debit processing in Accounts Payables for setting up EFT routings with banks.
- Worked on AP Matching Process.
- Worked on Voucher creation, customers, Voucher Hdr and Line tables in Payables.
- Worked on Transfer work sheet to transfer balances to other customers that are posted by mistake.
- Worked on AR Update (AR UPDATE) Application Engine Process.
- Worked on Load Accounting Entries to AR process of Billing.
- Used Purchasing Requisition Loader process to collect the purchase requests from PeopleSoft Inventory, Inventory Replenishment, Order Management, Projects, Product Configuration, and from PeopleSoft Purchasing or external systems.
- Involved in the approval of requisitions and Purchase Orders (POs) using workflow.
- Worked on Standard Journals.
- Worked on Bill Creation and Bill Finalization.
- After finalizing the bills successfully posted invoices to AR.
Environment: PeopleSoft Version 9.0 ESA for IT - Resource Management, Program Management, 8.8 Version of Financials, GL, AR, AP, Purchasing, Billing and People Tools 8.48.03, People code, SQR, Application Engine, PSQuery and Ms Sql Server, Unix and Windows NT.
Sr. Software Engineer
Confidential
Responsibilities:
- Participated in preparing Technical Design Documents and review meetings.
- Performed research and study of the existing system tables and business processes.
- Used Application Classes for various purposes to get better usability from Object Oriented Programming.
- Used Derived fields to display data horizontally depend on the code.
- Programmatically displayed translate values for fields.
- Worked on Journal Edit and Journal Post Process in GL.
- Used Working scrolls in pages to display data according to the user changes.
- Worked on Integration Broker for customizing messages.
- Participated in Unit and Buddy testing for newly developed module.
- Created different pages with new functionality to show field values according to the user selection.
- Created new Workflow definitions to meet the business requirements.
- Worked on Journal Generator process in General Ledger.
- Worked on Aging Analysis in Accounts Payables modules to calculate the Aging reports and categorize them based on deduction etc.
- Worked on Order Management for Sales Order Entry.
Environment: PeopleSoft Version 8.9 ESA for IT - Resource Management and Program Management, Financials - GL, AR, AP, Order Management and Inventory. People Tools 8.46, People code, SQR, Application Engine, PSQuery, Application Messaging, Crystal Reports and, Unix, Ms Sql Server, Windows NT.
Support Engineer
Confidential
Responsibilities:
- Responsible for taking cases, which are logged by customer through customer connection (C1).
- Creating cases in situations like customer contacted through mail or call.
- Handling cases and giving first contact according to the priority of the case.
- Communicating with customer effectively through Customer Interaction Tool and giving on time response.
- Communicating with developer in some issues to give valuable solution to the customer.
- Handling cases in GL, Accounts Payables, Purchasing, Inventory, Resource Management, and Staffing Front Office and started in Billing Module.
- Worked on issues raised in AR UPDATE Application Engine process.
- Debug and give the fix to the customers based on the platform or code changes related issues.
- Worked on BI to AR SQR and provided the fix to the customers.
- Meeting SLA’s (Service Level Agreements) as per the company standards.
- Creating Incidents with development team to give the Fix to the customer if necessary.
- Analyzed various issues, which delivered by PeopleSoft and logged PeopleSoft cases.
Environment: PeopleSoft Version 8.9/8.8/8.4/8. x, GL, Accounts Payables, Inventory, Purchasing, Accounts Receivables, Billing, Resource Management, Staffing Front Office and Order Management modules. People Tools People code, SQR, Application Engine, PSQuery, Crystal Reports.
Confidential
PeopleSoft Techno Functional Consultant
Responsibilities:
- Worked on the HR, Benefits, Payroll, eBenefits, ePay Design and Deployment in HCM 8.8.
- Worked with various Workflows and customizations.
- Developed various Pages, Components, Menus and Record definitions as per the client requirement using Application Designer.
- Customized and created record definitions, designed new page (Summary pages) to display additional information and used People code to in corporate validation rules according to specifications.
- Developed run control pages and components to get user input and added process definition to SQR and Business Objects.
- Involved in configuration setup, workflow and security in Time and Labor eBenefits, eRecruit, and ePerformance.
- Performed customization so that Manager can create performance documents for their employees via MSS with pre-populated document and template.
- Time and labor duties include setting up reporting schedules, edits, rules, time clock, configuration, customization of batch T&L processes, creating a financials labor interfaces and writing client specific reports.
- Developed several new SQR reports from scratch like number of employees in each benefit program, and list of employees..
- Created permission lists, users, roles and assigned roles to users (Maintain Security)
- Modified existing Report Formats and added new Reports using PS/Query to generate reports of customized application as per user requirement.
- Developed SQR interfaces to convert legacy system data to PeopleSoft Application tables. SQR functionality included data validation, processing, and error handling procedures and data conversion.
- Performed data loading of existing data from legacy system through Import Manager to People Soft application database tables.
- Created Application Engine programs and files layout definitions such as writing data to file, reading from flat file by adding new Sections, Steps and Actions through Application Designer.
- Developed and customized Several Crystal Reports as per the business process requirement.
Environment: PeopleSoft 8.8, People Tools 8.46, Process Scheduler, HCM Payroll, Benefits, eBenefits, ePerformance, eRecruit, Windows 2000/Xp,Toad and Oracle9i
Confidential
PeopleSoft Programmer Analyst
Responsibilities:
- Developed Record definitions, Pages and Components, SQR & ad-hoc queries.
- Developed Run control Pages as per corporate requirements and attached menu to run the SQRs online.
- Involved in customization of existing Pages using People code and SQR. Written People Code extensively to increase functionality of Pages.
- Customized the existing Interfaces and reports in order to match the new Record Layouts given by the vendors.
- Updated field labels and length to make them available to do the different customizations by doing impact analysis.
- Involved in Testing and Documentation.
- Analyzing problems/issues with the functional users.
- Coordinated with Developers, Users and Testing Team in various purposes to improve the Quality of the PeopleSoft Application.
- As a team member of project, involved in Customization of Application Engine programs to perform background SQL process.
- Involved in performance tuning of existing SQR Programs.
- Modified Work flow definitions to add different activities and business process maps.
- Performed research and study of the existing system tables and business processes. Good co-ordination with development and QA team to make the module Success.
- Used different methods and built in functions to make the code work effectively.
Environment: PeopleSoft HRMS 8, People Tools 8.12, Peoplecode, SQR3.1, Oracle 8, PeopleSoft HRMS Implementation