SUMMARY

• 7 years of experience as a HRMS technical consultant, with experience in analysis, design development, upgrading and production support of PeopleSoft HRMS Applications.
• Professional experience in PeopleSoft HCM modules (HR, NA Payroll, Time&Labor, Base Benefits, Benefits Admin, Payroll Interface).
• Participated in all phases of ERP life cycle like Implementation, Customization, Development, Production Support and Upgrade.
• Extensive experience in requirement analysis, fit gap analysis, technical design, conversion strategies, data mapping, development, major customization, issue resolution, performance tuning, testing and training.
• Extensively worked with Application Designer, Peoplecode, Application Engine, Process Scheduler, Security Administrator, Data Mover, File Layout, Object Security, Component Interface, Integration Broker, PS Query, Tree Manager, SQR, XML and Workflow.
• Involved in applying PeopleSoft Patches and Bundles.
• Worked closely with Business Users in understanding the Business Processes.
• Participated in complete Payroll processes and resolving issues for Payroll.
• Worked on PeopleSoft Security - User Profiles, Roles, Perm Lists, Components, Pages, Menus, CI, Process Groups, Query Security, and Department Security etc.
• Strong collaboration & team building skills with proficiency at grasping new technical concepts quickly and utilize the same in a productive manner.
• Great understanding towards the needs of the client to provide invaluable support from design to post-production stages.
• Worked with STAT release management tool.
• Possess excellent data modeling, analytical and problem solving skills.
• Very good team player with excellent communication skills.

TECHNICAL SKILLS

People Tools: Application Designer, PeopleSoft Internet Architecture, People Code, Process Scheduler, Configuration Manager.

Integration Tools: Application Engine, File Layout, Component Interface, Application Messaging, Application package, Integration Broker. Approval Workflow Engine (AWE)

Reporting Tools: PS Query, SQR, XML Publisher

Data Management Tools: Data Mover

Databases: Oracle 9i, Oracle 10g, SQL Server 2000, SQL Server 2005,DB2

Programming Languages: People Code, SQL, C/C++, Java

Operating Systems: MS Windows 98/NT/2000/XP, UNIX.

Migration tools: STATPeopleSoft HRMS Modules: North American Payroll, Time and Labor, HR, Benefits Administration, Base Benefits

PROFESSIONAL EXPERIENCE

Confidential

PeopleSoft HCM Techno-Functional Consultant

Responsibilities:

• Interacted with Users to understand the business requirements and developing technical specifications for various tasks involving object modifications, developing new objects, customizing delivered interfaces/reports and developing new interfaces and reports.
• Performed design of reports for the Payroll and Benefits using SQR and PS/Query Reports based on organizational needs.
• Involved in setting up new benefit plan, eligibility rule for life insurance.
• Developed new inbound & outbound file integration with VANGUARD for 401k deductions.
• Modified custom Absence date page to accept half-day absence for Non-Exempt hourly employees.

Environment: PeopleSoft HCM 9.0/9.1/9.2 (HR, Benefits, Benefits Administration, Payroll Interface), People Tools 8.50,8.51,8.52, SQR, SQL, SQL Server and PSNT.

Confidential

PeopleSoft HCM Techno-Functional Consultant

Responsibilities:

• Played various Roles within projects - Team Lead, Technical Consultant, Techno/Functional Consultant
• Leading the offshore team for all Technical Developments.
• Responsible for drafting the design and analyzing the documents for business process activities.
• Getting Time reporter data from a third party system into People soft system using TCD interface and processing the information to generate payable time for employees.
• Performed design of reports for the HR, Time & Labor using SQR, PS/Query and XML-P Reports based on organizational needs.
• Performed code review for the developments done by offshore team.
• Developed SSIS packages to fetch data from external database to PeopleSoft.
• Provided technical support of applications by managing the requests, gathering and translating business requirements to technical specifications through Project Estimation Document, Technical Design and Root Cause Analysis.
• Experience in working with Onsite / offshore model.
• Interacting with Functional consultants and users to discuss new requirements across the business
• Involved in setting Time Reporting codes (TRCs), Compensatory time off plan, Work Groups & Task Groups.
• Developed complex custom Time and Labor rules to calculate Late In, Excess Meal & short break, where the associates work in cross over shift and consists multiple login and logout on same day.
• Migration of People Tool objects from one environment to another environment through Quest Stat.
• Supported QA team till the projects moves from QA to UAT.
• Prepared new custom pages where employee can request for a Shift change and shift swap.
• Created User Profiles, Roles, Permission Lists, Components, Menus, Pages, Process Groups, Query Security, etc.
• Involved in User security (Roles, Permission lists) and row level security using Department tree.
• Developed AWE for Shift change and Shift swap request approvals.
• Involved in preparing unit testing planning document and executing the test scenarios for the process developed.
• Set up Work schedules and Holiday schedules for employees.
• Developed Integration broker for application messaging between ESA and HCM applications to send employee project allocation details in real time.
• Created Batch process application engine for Enrollment of Associates into Time and Labor.
• Extensively worked on rule performance and compilation of rules in Time and labor.
• Attending the Weekly review meetings, and Update the Client regarding the status of development.

Environment: PeopleSoft HCM 9.1/9.2 (HR, Time and Labor, Benefits, Benefits Administration, Payroll Interface, Compensation), People Tools 8.51,8.52,Oracle 11g, SQR, SQL, SQL Server and Unix.

Confidential

PeopleSoft HCM Techno-Functional Consultant

Responsibilities:

• Interacted with Users to understand the business requirements and developing technical specifications for various tasks involving object modifications, developing new objects, customizing delivered interfaces/reports and developing new interfaces and reports.
• Creation of objects specified in Technical Design document and changes the design as and when requires to match the client requirement.
• Developed many Inbound/Outbound interface Application Engine Processes to get data between PeopleSoft system and third-party systems.
• Developed several payroll & Core HR reports using SQR, PS Query, and XMLP.
• Worked with the payroll team on setting up the pay calendar tables, deduction tables and pay group tables.
• Worked extensively with the functional resources to understand business requirements.
• Created security matrix to identify desired access levels for users and mapping them out to permission lists, roles and user profiles.
• Worked on defects and bugs on developed Application Engines and fixed the defects
• Analyzed Data Mover Scripts as part of Upgrade process
• Involved in documenting the business process by identifying the requirements.
• Conducted Compare Report analysis for PeopleSoft Changes, Customer Modified changes and analyzed the objects to be upgraded
• Involved in Defect prevention process to deliver the work more efficiently.
• Involved in preparing unit testing planning document and executing the test scenarios for the process developed.
• Managed to be a part of development team as well as testing team simultaneously.

Environment: PeopleSoft HCM 9.0/9.1(HR, NA Payroll, Benefits Administration, Payroll Interface), PeopleTools 8.51, PeopleTools 8.49,Oracle 10g, SQR, SQL, STAT and Unix.

Confidential

PeopleSoft HCM Techno-Functional Consultant

Responsibilities:

• Involved in working and fixing the user requests and Change Requests.
• Involved in Requirements gathering, Fit gap analysis and prepared Functional Design specs.
• Created Test Plans, Test case and test the programs with actual data.
• Involved in HR Inbound Interface from ADP.
• Worked on issues involving modifications to the existing people code to incorporate proposed functionalities, creating new fields on pages, hyperlinks, push buttons for secondary pages, etc.
• Developed custom AE to create off cycle pay sheets based on feed received from Meryl Lynch.
• Worked on Employee payroll deductions, pay calendars, ran the payroll process (from pay calendar, pay sheet/unsheet, pay calculation to pay confirm/unconfirm).
• Maintained Security. Involved in creating permission lists, users, roles and assigned roles to users.
• Involved in fine-tuning and modifications of PeopleSoft records, which will be TEMPeffected by the upgrade process.
• Extensively involved in reapplying customizations to records, pages, People Code, components, menus, permission lists, message channels, portal registry structures and various other PeopleSoft objects post upgrade.
• Involved in applying patches, tax updates and maintenance packs to PWC now upgraded copy of production.
• Performed project and data migration from one environment to another using PeopleSoft data mover tool.
• Debugged and modified Cobol processes.
• Given complete requirement transition to the QA team to go the QA testing smoothly.
• Supported the QA team till the projects moves from QA to UAT.
• Created the complete understanding documents for new requirements for the future reference.

Environment: PeopleSoft HCM 8.3/9.1(HR, NA Payroll, Payroll Interface, Benefits, Benefits Administration), PeopleTools 8.50, Oracle 10g, SQR.

Confidential

PeopleSoft HCM Technical Consultant

Responsibilities:

• Involved in working and fixing the user requests and Change Requests.
• Performed development, testing, modifying of some of the SQR, Query, existing pages, various PeopleSoft objects.
• Involved in BATCH processing to setup the jobs in Control - M tool.
• Created the UNIX shell scripts as per the application process.
• Developed new inbound interface programs and XLS based reports using AE and File Layout.
• Interacted with Hewitt functional consultants to understand their functional needs and customized the system to incorporate the same.
• Involved in creating Technical design documents and Unit testing.
• Impact analysis of various Tax Updates and Fixes.
• Extensively involved in reapplying customizations to records, pages, People Code, components, menus, permission lists, message channels, portal registry structures and various other PeopleSoft objects.
• Worked extensively on SQR’s and created several inbound and outbound interfaces to meet the client’s requirements.
• Developed and modified Unix scripts for batch process scheduling.
• Created custom application pages and records as per client business needs.
• Developed different custom reports using PS Query and SQR according to user requirements.
• Modified & Created records, on-line pages, and components according to the requirements using Application Designer.
• Migration of People Tool objects from one environment to another environment through Quest Stat.
• Involved in creating Users Profiles, Roles, and Permission Lists.

Environment: PeopleSoft HCM 9.0(HR/Benefits/Payroll), PeopleTools 8.47, DB2, COBOL, Control-M, DB2, Stat, and Maestro