SUMMARY:

• 10+ 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 for HCM 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
• 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 reference to objectives/competenc- cies 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.
• Designed and developed many inbound and outbound interfaces to and from PeopleSoft payroll system.
• Debugged and modified several batch processes like Vacation Process, Sub Credit Union Process for the Payroll team.
• Developed Application Engine Program to upload Hire Information from Data file into PS Staging Tables using File Layouts and People code, which will be further populated into Corresponding PS tables using Conversion SQR programs.
• Modified the labels for the User fields on the pages. Changed the default settings for the labels.
• Supported PeopleSoft Payroll by debugging user and system errors in Payroll processes which includes SQR, Component Interface and Application Engine Processes.

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.
• 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.
• Performed Unit test and system test on Data conversion programs
• 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.
• 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.
• 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.
• 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.
• 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.
• Worked on detailed designs for HR module for retrieving the employee’s historical data from Oracle Data Warehouse.
• Worked on Performance tuning of Customized Application Engine and SQR Processes.
• Online development/customizations of pages, queries and also online validation using PeopleCode.
• Worked on custom Disability batch process which calculates the number of pay hours of the Employees who are on disability in the current pay period.
• 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.

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.
• 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.

Environment: PeopleSoft HCM (Time and Labor, Payroll, Manager Self-service (MSS), ESS, Benefits Administration, Position Management, ELM) 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 Technical Consultant

Responsibilities:

• Setup, configured and troubleshoot PeopleSoft Enterprise Integration Points (EIP’s) between ELM 9.1 system and HRMS 9.1 PeopleSoft system. Person and Organization, Objective and Competency EIP Messages (Full Sync and Incremental Sync EIP’s). .
• Performed installation, maintenance of PeopleSoft ELM software and migration of configuration (i.e. setup data) between environments.
• Setup EE information in Payroll Module to calculate EE Earnings and Taxation of their Earnings and Benefits.
• Analyzed the Customizations to the delivered SQR reports and worked with the functional analyst to determine if the Customizations need to be reapplied or retired.
• 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).
• Reapplied the Customizations to SQR reports in the new release.
• Modified custom built SQR interfaces, conversion, and report programs to in corporate new fields and changes that were introduced in new release.
• Involved in design and implementation of standard heading SQC’s customized to suit client requirements for all the payroll-related reports.
• Designed and developed several interfaces to load data into PeopleSoft Payroll from different vendors/systems using SQR, Application Engine and Component Interface.
• Designed and developed to modify Health and Safety module to add new fields to track if the accident is the result of the operation of motor vehicle.
• Designed and developed Component Interface to terminate the benefit due to death, Utilized Application Engine to invoke the Component Interfaces.
• Involved in upgrade of existing PeopleSoft TAM/CG application from version 8.9 to 9.1.
• Managed a team of 5 developers and also managed Talent management offshore testing team in Malaysia.
• 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.
• Configured Work Experience (TAM/CG) as content type and modified the HRS application classes/CG pages to store the work experience data as content items.
• Configured the Resume Mirror/Hire Right vendor setup and customized the HRS HROI application classes for the client custom passive applicant type.

Environment: PeopleSoft HCM v9.1 (T&L, Payroll, TAM, CG), Tools v8.50, SQR, BI Publisher

Confidential, Charlotte, NC

PeopleSoft HRMS 9.0 Consultant

Responsibilities:

• Designing, coding and testing PeopleSoft Human Resource and Payroll modules.
• Involved in converting the general designs to detailed designs for PeopleSoft HR/Payroll products for custom reports and online PeopleSoft processes according to the client requirements.
• Involved in design and implementation of standard heading SQCs customized to suit client requirements for all the payroll-related reports for PeopleSoft.
• Worked on detailed designs for HR module for retrieving the employee’s historical data from Oracle Data Warehouse.
• Worked on Automatic Union Dues Set-Up utilizing PeopleTools and PeopleCode to in corporate new and complex validations.
• Developed many tax calculation reports like percentage of Tax variation from previous quarter current quarter. Federal and State tax reports.
• Involved in impact analysis, design and testing of the Application Engine, SQR reports, SQR Interface, Pages.
• Study of Functional design and Documents provided by Client and prepared the Technical design specifications.
• Set up Workgroups, TRC’s, TRC Programs, Rule Programs, Value Lists, Static and Dynamic Groups.
• Developed Custom Time & Labor Reports which included Compare Reports, which were extensively used while transferring data from a Third party system to PeopleSoft Time & Labor.
• Created custom processes to have hourly employee counts based on the Full or Part Time status and the number of active hours worked.
• Developed Queries to modify reported hours. Queries are using by Task Group employees as they are allowed to report over time.
• Developed data mover scripts to migrate Rules, SQL Objects, Messages and Message Catalogs, and Exceptions.

Environment: PeopleSoft HCM (TAM, Profile Management, ePerformance, NA Payroll, T&L) v8.9/9.1, People Tools v8.50, AWE, IB, App Engine, Application Packages, Send Master, SOAP UI

Confidential

Techno-Functional Consultant

Responsibilities:

• Did online Customization in the People soft 8.9 environment according to the Technical Specification.
• Conducted Unit Test and documenting the Unit Test Plan with Unit Test result for the online Customization.
• Registered online components and documenting the Unit Test Result.
• Created and used permission lists and Roles for the requirement and implemented row level security for payroll module of North America and Canada and time and labor.
• Involved in compliance related activities of the system like security and confidentiality.
• Run the Compare report between the Source and Target databases and did the retro fit.
• Worked with row level security to manage employee and manager self-service.
• Created roles and permission lists for specific modules and assigned them to user profiles.

Environment: PeopleSoft HCM v8.9 Upgrade, PeopleTools v8.49, Integration Broker, App Engine, STAT