SUMMARY

• 8+ Years’ experience in PeopleSoft that included gathering user requirements, Systems Analysis, Design, Development, Implementation, Upgrade, Testing and Production Support of various Client Server and ERP applications.
• Experience in wide range of PeopleSoft HRMS/HCM modules including PeopleSoft HR, Time and Labor, Talent Acquisition Manager (TAM), Benefits, e - Benefits, Benefits Administration and Payroll.
• Worked on setting up Core Time and Labor Setups, which include Workgroups, Rule Programs, Time Reporting Codes, Value Lists, Schedule Calendars, Time Ids, Holiday Schedules
• Expertise in developing, Customizing Interfaces and Conversion programs using SQR, Application Engine andComponent Interfaces forHCM modules.
• Participated in all phases of ERP life cycle like Implementation, Customization, Development, Production Support and Upgrade. Applied PeopleSoft Patches, Bundles.
• Strong working knowledge on People Tools - Application Designer, Application Engine, PeopleCode, Process Scheduler, PS Query, File Layout, XL to CI, Component Interface (CI), Application Package, SQL, Data Mover, BI Publisher, Integration Broker, Web Services, and SQR.
• Possess Functional Knowledge of Learning Management(ELM).
• Experience in Data Conversions between PeopleSoft and legacy systems including conversion of JOB data, Personal Data and Payroll Data (Earnings, Deductions, and Taxes) and Base Benefits Data (Dependents Data, Health Benefits, Disability Benefits, Pension Plan and Savings Plan).
• Expert understanding of PeopleSoft HR Modules - Core HR, Workforce Administration, Employee Self Service (ESS), Manager Self Service (MSS), Base Benefits, North American Payroll, Time & Labor and Talent Acquisition Management (TAM).
• Having On-shore/Off-shore team management experience with multi-tasking abilities.
• Extensive experience of different types of testing e.g. Unit Testing, Integration Testing, System Testing, Regression Testing, User Acceptance Testing, Load and Performance Testing.
• Having good experience of System Development Life Cycle (SDLC) for successful completion of projects.
• Work Experience on UNIX, Windows Servers, Shell Script, Batch Scheduling Application Control-M, Database Access Tools like TOAD, Query Analyzer, Quest, SQL Plus, Version Control Tool STAT and Defect Tracking Tools like HP Quality Center and Test Director.
• Analyzed and Applied Tax Updates, HR Bundles & Patches extensively.
• Team player with excellent interpersonal communication skills and technical documentation skills.
• Resolved issues during PUM 8 upgrade of SLMS.
• Designed custom module for helpdesk team to give users roles and make them learning admins.
• DOT report changes and development, Day to Day support of SLMS.
• Designed pages for external learner registration for OPWDD and DHSES.
• Modified SES search to make it work according to our requirements.

TECHNICAL SKILLS

ERP Module: PeopleSoft Hrms (8.0/8.3/8.8/8.9/9.0/9.1/9.2 ), PS HRMS (HR, Payroll, Benefits, TAM, eBenefits, eProfile, eRecruit, T & L), PS CRM (Call Center), PS ELM (9.1/9.0), PS Portal(9.0/9.1/9.2)

People Tools: Application Designer, PeopleCode, Application Engine, Component Interface, Security, Data Mover

Security Tools: Oracle Identity Manager 9.0.1 - 11.1.1.5 , Oracle Identity Analytics 11g, Oracle Access Manager 10g - 11g, Oracle Virtual Directory, Oracle Role Manager

Reporting Tools: SQR, Crystal Reports, Nvision, Business Objects, BI Publisher, OBIEE

Databases: Oracle,DB2 and MS SQL Server

Operating Systems: Windows Server 2008, UNIX (AIX, HP, Solaris).

PROFESSIONAL EXPERIENCE

Confidential, Albany, NY

Sr. PeopleSoft Consultant

Responsibilities:

• Resolved issues during PUM 8 upgrade of SLMS.
• Modified SES search to make it work according to our requirements.
• Responsible for conversion of legacy system data into PeopleSoft ELM v9.2.
• Worked with business users to gather requirements and converted them into technical design
• Analyzed and designed data mapping methodology for moving data to PeopleSoft ELM v9.2.
• Designed various queries to meet the client requirements
• Designed the file structure to be imported to make sure all fields are converted to appropriate fields in the ELM system.
• Devised strategies for conversion of the Catalog Items, Delivery Method, Activities, Learning Components and Sessions
• Created custom pages using Portal PeopleTools and PeopleCode. These pages integrated with delivered Student Records and Enrollment. Used by colleges to validate students who have Veteran status.
• Created custom SQR and Crystal reports tracking Veterans info based on the pages created above, student enrollment, and student grades.
• Involved in Analysis, Design, Implementation and Production Support of PeopleSoft Student Admin - (Campus Community, Student Records, Financials, Admissions and Financial Aid).
• Prepared Technical design documents for the enhancements inStudent Records, Campus Community, Financials, Admissions and Financial Aid.
• Configured the application with new setup data for conversion including Learning Environment, Categories, Learner Groups and New learner profiles
• Designed and developed conversion programs to move data into ELM.
• Worked with ExcelToCI tool to import Learning Resources, update/map Learning references to objectives/competencies and written SQL data loading scripts.
• Designed custom module for helpdesk team to give users roles and make them learning admins.
• DOT report changes and development.
• Day to Day support of SLMS.
• Designed pages for external learner registration for OPWDD and DHSES.
• Involved in upgrade of PeopleSoft HCM 9.2 and People Tools 8.54. Involved in the design, development and testing of all HR, Manager Self Service, Employee Self Service and Benefits Administration.
• Developed application package for web service project to send the required data fields based on the position number from PeopleSoft system to other system. Prepared Technical Design Document for the project.
• Responsible for resolving production issues after upgrade to v9.2 which gets created thru Service Manager Ticket tracking Tools.
• Modified the application package people code on different TAM pages like Career, Job Opening and Job Posting pages.
• Involved in designing and implementing the application enhancements for HCM modules like Recruiting, E-Performance and Core HR.
• Prepared technical design documents for new and existing projects.
• Resolved many issues in Recruiting and E-Performance modules.
• Modified the existing HR interface programs (SQR, Application Engine) as per new version changes.
• Actively involved in the testing and issue resolution of system integration testing and UAT.

Environment: PeopleSoft HCM v9.2, Tools v8.54, App Package

Confidential, Boston, MA

Sr. PeopleSoft Consultant

Responsibilities:

• Involved in upgrade of PeopleSoft HCM 9.2 and People Tools 8.54. Involved in the design, development and testing of all HR, Payroll, Time and Labor, Benefits Administration, Manager Self Service and Employee Self Service.
• Created Application Engine program to enroll associates to STD benefit once they have completed 5 years of service in the organization.
• Analyzed table structures in PeopleSoft and performed data mapping to UltiPro HR system
• Customized the Candidate Gateway to be section 508 compliant per the PeopleSoft Accessibility guide. Worked with screen reader software JAWS to test the Candidate Gateway for visually impaired users.
• Developed several SQR programs for data migration from PeopleSoft to UltiPro
• Worked on Absence Pay Outbound Interface for NA Payroll: The OT Calc system calculates Overtime Pay for non-exempt employees. A new program is needed to create a file for OT Calc containing time entry transactions for these employees. Prior to PeopleSoft PTO, the old DOTS system used to create this file, which was called OTABS.DAT. This new program will create INTPY022.DAT file will be received at the Payroll office each morning from PeopleSoft. It is a flat fixed length ASCII file, and contains the absence data for each employee.
• Performed Unit test and system test on Data conversion programs
• Created Application Engine program to enroll associates to STD benefit once they have completed 5 years of service in the organization.
• Perform analysis, apply and testing of Tax Updates as supplied by Oracle/PeopleSoft
• Performed System Development Life Cycle (SDLC), from analysis and design through testing and supporting. new reports & interfaces for Disability Benefits, Life Benefits, Health Benefits, and FSA benefits. Designed new run control panels and customized the existing ones by writing People Code.
• Managed full SDLC implementation projects starting from requirements gathering to deployment to transition.
• Involved in development and setup of Payroll module and customization of the Pay003.sqr, DDP003.sqr paycheck, and pay advice generation process.
• Created an Application Engine program which populated a custom table that held Student Health Insurance data and allowed Student Health Insurance link to be displayed on the Student Center.
• Developed a custom Student Financials Self-Service Health Insurance form which allowed students to enter their information on-line. Once the form was completed, 3Cs, the custom table, Service Indicators were updated.
• Modified the existing SQRs to generate interface files to include new Benefit plans and new benefit programs and the most relevant data from the respective benefits Records.
• Collected the requirements from the users and prepared both functional and technical speciation documents
• Verified and Responsible for running the biweekly (On-Cycle and Off-Cycle) payroll by providing analysis support on PeopleSoft Time & Labor and Payroll modules. Resolved several payroll issues in production environment

Environment: PeopleSoft HCM/ELM v9.2 (TAM, CG, T&L, Payroll, Benefits), Tools v8.54, AWE, App Package

Confidential, Madison,WI

Sr. PeopleSoft Techno-Functional Consultant

Responsibilities:

• Designed specs Involved in the PeopleSoft Upgrade Project for Base HR, T&L, Payroll, Benefits Administration, ELM, AP, AR and Purchasing Modules
• Developed various technical specification documents for the new changes brought out in version 9.1.
• Worked on setup of Manager Dashboard Pages and Direct Report Pagelet and Alerts Pagelet.
• Designed specs for and developed HR Reports like Position History Report, Head Count, Departmental Budget, Position Budget Report, Inactive/Active Position Reports, Position Hierarchy Reports, etc.
• Developed and Interface that will read PS PAY CHECK, PS PAY SPCL EARNS and PS GENL DEDUCTION Payroll tables and extracts deduction information to create 401K loan repayment and deferral file for Fidelity after biweekly and semi-monthly payroll process. The file will be used by Fidelity to load contribution and loan payment information into employee 401K accounts.
• Analyzed the Customizations to the delivered SQR processes & reports and worked with the functional analyst to determine if the Customizations need to be reapplied or retired.
• Designed, Developed and tested New Application Engine Program’s to read Open Requisition’s and Pre-boarding data from Taleo CSV files to PeopleSoft tables.
• Involved in the Upgrade and testing of all the HR, Benefits, Time and Labor and Payroll interfaces as a Key team player of the Interface team. Verified and Responsible for running the biweekly (On-Cycle and Off-Cycle) payroll by providing analysis support on PeopleSoft Time & Labor and Payroll modules.
• Designed & developed Job Requisition Report &customized the Diversity of Hires report as per the business needs.
• Configured workflow (email and work-list) to be routed to the payroll administrator when there is a change in the employee state information for tax purposes.
• Customized the Manager Self Service pages to accommodate the custom review and salary, appraisal pages and also added links for the compensation pages.
• Involved in Testing & Defect tracking few processes in HR, Benefits & Payroll modules.
• Designed and developed the Java classes to create the compressed images from the online Time Sheets. Created an Interface to store online Time Sheet images in Live Link (Document Management System).
• Modified delivered XML Publisher templates PYCHKUSA and PYADVUSA for check printing / advice form printing specific to client requirements. Customization of Health, Disability, Savings Plan, Life panel, FMLA panel etc. in the Benefits module. Involved in setting up Payment terms, accounting, billing options, taxes and currency options, Vendor, Items, Item Category.
• Involved Asset Management Open Transaction Edit program to update the appropriate dates based on the type of transaction coming from Supply Chain.
• Modified the labels for the User fields on the pages. Changed the default settings for the labels.

Environment: PeopleSoft HCM (Time and Labor, Payroll, Manager Self-service (MSS), ESS, Benefits Administration, Position Management, ELM, AP, AR and Purchasing modules) v8.9/9.1, People Tools v8.50, AWE, IB, SQRPeopleSoft HCM/CRM v9.1 (MSS, ESS, HR Help Desk).

Confidential, Philadelphia, PA

Sr. PeopleSoft Techno/Functional Consultant

Responsibilities:

• Involved in upgrade of existing PeopleSoft TAM/CG application from version 8.9 to 9.1.
• Retrofitted all the workflow objects (business processes, activities, steps, events). Configured the AWE workflow for the HR Self s Involved in upgrade of existing PeopleSoft TAM/CG application from version 8.9 to 9.1 service transactions. Involved in Production Support and Work Request Change Activities for PeopleSoft 8.8 HR, Payroll, Benefits, Benefits Administration, TAM and ePerformance. Designed and developed a custom notification process to notify each responsible rating manager when a performance needs to be created.
• Verified also the setup of employee payroll deductions, pay calendars, running of the payroll process (from pay calendar, pay sheet/unshed, pay calculation to pay confirm/unconfirmed). Customized paycheck interfaces and yearly earnings statement reports.
• Brought customization from 8.9 to 9.1 for online changes in MSS and ESS and ePerformance.
• Involved in the Upgrade and testing of all the HR, Benefits, ePerformance, Time&Labor and Payroll interfaces as a Key team player of the Interface team.
• Worked on all the pages/component of ePerformance for Annual and PIP doc.
• Set up the open enrollment system for the new employees. Prepared the election analysis reports for the Open Enrollment Process. Good knowledge of the configuration of ePerformance template definitions.
• Developed HR Self Service Tool which enables users to generate transactions to be inserted / deleted into/from Job, Bonus, Payroll and Employment.
• Developed two nightly processes, which include Application Engine and Component Interface to insert the HR Self Service transaction data into job component performing all the job component validations.
• Added URL links to external websites on Self Service benefits pages based on Plan type.
• Worked with PeopleSoft Global Support team to resolve the issues in XML Publisher.
• Designed and developed application engine programs to convert job data and person data in the Health spring Acquisition. Developed several conversion SQR programs and application engine programs for Dependent Information, Benefits and Payroll

Environment: PeopleSoft HCM (Payroll, TAM, ePerformance) v8.9/9.1, People Tools v8.50, AWE, IB, COBOL, SQR

Confidential, Charlotte, NC

PeopleSoft Techno/Functional Consultant

Responsibilities:

• Extensively Involved in the PeopleSoft Implementation Project for Core HR, Ben Admin, Payroll Interface, TAM/CG/eRecruit, Profile Management and ELM.
• Designed technical specifications for the gaps in HRMS/ELM based on functional Specifications.
• Conducted data mapping sessions for the personal data, dependent data, position data, job data, benefits data, catalog items, activities and enrollments conversion with the legacy team.
• Disabled the delivered route applicant functionality in TAM/eRecruit and developed a custom application engine process to route all applicants to their corresponding hiring managers.
• Designed and developed a custom notification process to notify each responsible rating manager when a performance needs to be created. Customized various pages in Core HR, TAM/CG, Profile Management and ELM as per the client needs. Created custom application package for the peoplecode.
• Created name change email notification process to inform subsidiary systems about the employee name change. Worked with PeopleSoft Global Support team to resolve the issues in XML Publisher.
• Requirement gathering, fit-gap analysis and development of HR Self Service Tool and Talent Planner Tool.
• Developed HR Self Service Tool which enables users to generate transactions to be inserted / deleted into/from Job, Bonus, Payroll and Employment.
• Developed two nightly processes, which include Application Engine and CI to insert the HR Self Service transaction data into job component performing all the job component validations.
• Designed and Developed different custom reports using XML Publisher in Talent Planner module.
• Involved in developing the SQR programs of Benefits carrier interfaces like AETNA, Blue Cross Blue Shield, Met Life, Cobra interface, FSA interface etc.
• Customized e-Applications (e-Profile, e-Benefits, e-Recruit, and e-Compensation) 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 and to view the summary leave details. Developed and modified Application Engine programs to suit the modifications brought out in Version 8.8 application release. Developed interface programs in Benefits and Payroll through Application Engine.
• Worked with ExcelToCI tool to import Learning Resources, update/map Learning references to objectives/competencies and written sql data loading scripts.
• Used Integration tools consisting Application Messaging, Component Interface to interact with the external applications. Created employee self-service customizations for e-Benefits (online enrollment), e-Compensation (MSI), and payroll

Environment: PeopleSoft HRMS 8.9, People Tools 8.49, Oracle 11g, Web Services, App Engine, XMLP

Confidential

PeopleSoft Developer

Responsibilities:

• Managed a workgroup aligned by business capability to handle day-to-day production issues and change requests from clients. Worked on a lot of customizations of pages, components, People Code.
• Created paycheck SQRs to get the transit and account numbers from the Pay Group Table, the bank information from the Bank Table, and the check number from the pay sheet (check numbers are assigned during pay confirmation). Customized the TL TR WEEKLY page. The purpose of this customization is to display a Schedule Hour field on the Rapid Time Entry Page and Weekly Elapsed Time Page.
• Designed and executed test scripts to test converted data using SQL scripts and reporting tools.
• Worked on different Production support issues for Time&Labor and Payroll. Resolved many payroll issues to restart the payroll calc and payroll confirm process.
• Streamlined and tested payroll process and analyzed Payroll interfaces for updates to financials and third parties. Created an SQR report that calculates the FLSA payment for nonexempt Employees who work more than 40 hrs in a week. Developed Application Engine programs to convert flat files from legacy into PeopleSoft tables using file layouts. Developed custom rules for the Time Administration process. Applied Time and Labor bundles and tax updates. Downloaded and applied patches and bundles in the system.
• Developed Time and Labor security. Defined dynamic groups.
• Coordinated with the end users and Business Analysts in understanding the business process and implementing their ideas into technical specifications.

Environment: PeopleSoft HRMS 8.8 (HR, Time and Labor, ePay, Benefits and Payroll), People Tools 8.44, People Code, Oracle 9i, Application Engine, SQR, Integration Broker, Component Interface, UNIX