SUMMARY

• Over 7+ years of progressive and full application life cycle experience in PeopleSoft HRMS/HCM Applications dat includes Workforce Administration, Manage profiles, Payroll, Base Benefits, Ben Administration and Self Service applications in the areas of, Design, Development, customizations, testing and deployment.
• Experienced in working with PeopleTools, Application Designer, PeopleCode, Process Scheduler, Application Engine, File layout objects, Data Mover, Security and Report Manager, Integration Broker, workflow, and Component interfaces.
• Worked customizations in eBenefits, ePay and eRecruit(TAM) areas of Employee Self Service.
• Experienced applying Maintenance Packs, Bundles, Patches and Fixes to the current applications and retrofitted the code.
• Extensively worked on SQR interfaces and reports with SQL and BI Publisher Reports.
• Extensively worked in Global Payroll as a technical analyst with exposure in core Payroll Application and Country extensions. Also involved in release and system testing Peoplesoft North American Payroll with benefits.
• Design & Development of Data conversion programs to facilitate the initial data loading from legacy system to the PeopleSoft system using Application Engine/FileLayouts/Component Interfaces.
• Maintenance and distribution of security for various environments (user profiles, roles, permission lists).
• Strong experience in PeopleSoft HCM upgrades and FIT/GAP analysis.
• Worked individually, as well as in team environment, to achieve project goals and quickly adapt to new technologies and scenarios.Building excellent client rapport by understanding the work culture and adapting quickly to it .

TECHNICAL SKILLS

System Development: Requirements Capturing, System Design, Development, Testing, Implementation, Documentation & User Training

PeopleSoft Modules: Payroll, Benefits, Ben Administration, Time & labor, Enterprise Learning Management(ELM),e - Recruit

Software / Tools: People Soft HCM 8.9, 9.0, 9.2, People Tools 8.54, SQR, Seagate Crystal Reports, PS/ nVision, Tree Manager, Data Mover, Microsoft Tools, Visual Basic.GUI

OOAD: Rational Rose, Web Sphere, web logic

Operating Systems: Windows NT, Windows 7, Unix

RDBMS: Oracle 8.x / 7.x, MS SQL Server, DB/2, Microsoft Access

Languages: People Code, PL/SQL, C, Visual Basic, Java, JavaScript

Development Methodologies(SDLC): Waterfall Model, Agile

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr. PeopleSoft HCM Consultant

Environment: PeopleSoft HRMS/HCM 9.2 and People Tools 8.54, Payroll, Benefits, Application Engine, PeopleSoft Query, People Code, Component Interface, SQR, Oracle 10g.

Responsibilities:

• Involved in requirements gathering, documentation of specifications and customization of the PeopleSoft HCM 9.2 (HR, Payroll, Benefits, Time and Labor) business processes.
• Designed and developed PeopleSoft objects records, pages, components, component interfaces and Application Engine programs with File Layouts.
• Created Application Engine programs to load legacy data into PeopleSoft using Component Interfaces. Loaded data for components Personal data, Job data, Emergency Contacts, Disability, Employee Tax data, Direct Deposits, Health and life benefits enrollments.
• Worked with security team to determine the organization security roles and permission lists to be assigned for various users. Created Application Engine process to load security data and user profiles into application
• Worked on defect resolutions of HR, Payroll, Benefits and Self Service applications for online transactions, Interfaces, Processes and reports.
• Developed customizations on Employee Self Service applications involving Persona data updates, Review payroll information, enroll in benefits pages.
• Developed and modified SQR reports (Salary Register, Bank Interface, and Pay Slips etc).
• Modified delivered SQR reports for their benefit enrollments and customized HIPPA reports as per their business need.
• Actively involved in TAX Updates Process, ran scripts and loaded application Upgrade projects in Application Designer.
• Unit Tested the developed applications and data validations. Documented the unit test results and Migrated the code to test environments.
• Created Batch inventory and helped the operations team to Schedule Processes.
• Used PS query to generate reports using BI Publisher.
• Validated test results using SQL.
• Worked individually, as well as in team environment, to achieve project goals and quickly adapt to new technologies and scenarios.

Confidential, Dallas, TX

PeopleSoft Analyst/Technical Consultant

Environment: PeopleSoft HRMS/HCM 9.1 and People Tools 8.51, Application Designer, Application Engine, Data Mover, PeopleSoft Query, People Code, SQR, Windows NT, UNIX, Oracle

Responsibilities:

• Responsible for design analysis, technical specifications, development, implementation, support, and maintenance of PeopleSoft HCM 9.1/PTOOLS 8.51.
• Develop custom reports utilizing XML, SQR, and File Layout with Application Engine.
• DevelopedInterfaces using Application Engine to HR and Payroll load data from eCert system
• Developed/Enhanced SQR Programs scheduled to run monthly to submit Personal and Payroll data to State HRIS.
• Assisted performance tuning on App Engine and SQR processes.
• Customized the Self Service Transactions Pages. Additional fields and component People Code was written to enhance the functionality to meet customer requirement.
• Customized HCM 9.1 Administer Workforce applications to add functionalities related to auto increment of GL PAY TYPE field in Job data.
• Developed on-line customizations, custom interface programs for Benefits, Payroll.
• Set up Integration Broker services(such as gateways, nodes, services and service Operations etc) for automatic updates between HR and FIN applications.
• Perform database level and Sql level performance tuning to increase the response time of various processes and jobs.
• Design and Developed Employee Allocation system which involved linking the location transfer with allocation based on temporary, permanent or intercity transfer, analyzing auto assignment cancellation process when employee is made inactive, facility to has department and grade wise list of unassigned employees and link for assigning them to buffer project only, implementing the validation for assignment dates, Service Order dates.
• PeopleSoft Test Framework Implementation (Peopletools 8.51/Peopletools 8.52).

Confidential - Tampa, FL

PeopleSoft Technical Consultant

Environment: PeopleSoft HRMS/HCM 9.0 and People Tools 8.48, Application Designer, Application Engine, Data Mover, PeopleSoft Query, People Code, SQR, Windows NT, UNIX, Oracle.

Responsibilities:

• Involved in Gathering requirement, fit-gap analysis, designed gap strategies, Design, data analysis, data mapping for conversion, data cleaning, preparing technical documentation, Table set up & interface design for PeopleSoft 9.0 Time & Labor and Payroll for NA Implementation.
• Gathered business process requirements and participated in fit-gap analysis, and Identified RICE Object & Proposed solution for the gaps.
• Involved in the Analysis, and Design of different phases of implementation.
• Set up and configured Time Collection Devices (TCD) which includes Local Node Setup, Gateway Configuration and Routing Rules while implementing the requirement where in employees would use Time Clocks to report time into the PeopleSoft Time and Labor system.
• Setting up of the module control tables in Benefits such as benefit plan table, coverage group table, leave plan table, salary rate table, retirement plan table, include field for employee deduction and company contributions. Load employee data from the existing Legacy system to PeopleSoft tables.
• Wrote conversion SQR’s to transfer existing Time and labor, Benefits and Payroll data from legacy system to PeopleSoft application database tables.
• Developed Application Engine programs to create flat files for new outbound benefits interfaces.
• Identifying and fixing Job and Personal data of employees.
• Developed customized Benefits reports for Open Enrollment, New Hires, and Employee Benefits.
• Customization of Health, Disability, and Savings plan, Life Panel. Etc in Benefits Module.
• Customized Daily Time Calendar, Weekly Elapsed Time Entry, and Punch Time Entry and Manager Time Approval pages as per the requirements. Extensively used PeopleCode and PeopleTools during the customization.
• Provided production support for Benefits, Payroll and HR systems.
• Designed PS query structure to reduce client efforts for duplicated activities.

Confidential

PeopleSoft Technical Consultant

Environment: PeopleSoft HRMS/HCM 9.0 and People Tools 8.48, Application Designer, Application Engine, Data Mover, PeopleSoft Query, People Code, SQR, Windows NT, UNIX, Oracle

Responsibilities:

• Worked with upgrade team during the upgrade of PeopleSoft from version 8.3 to version 9.0.
• Involved in Fit/Gap analysis of the HCM processes in the PeopleSoft Version 9.0 and identified the customizations by comparing the new application with the existing version.
• As a part of upgrade, reviewed Upgrade Documentation and reviewed delivered Upgrade scripts.
• Involved in running Upgrade Compare Reports between Demo database and Copy of production before we do the upgrade copy.
• Created data mapping documents to compare table structures of both versions of PeopleSoft.
• Modified customized SQR reports in version 8.3 to make it version 9.0 compatible and to accommodate the new key structure.
• Involved in Impact analysis and retrofitting of the internal and external objects such as peoplecode, Application Engine, SQRs, Component Interfaces as a part of upgrade team.
• Extensively used autosys for setting up the reports to run at specific time and used Process Monitor to monitor the status of reports.
• Has downloaded and applied upgrade Patches & Fixes periodically to the current environments
• Involved in Unit Testing and Integration Testing.
• Developed various Outbound and Inbound Interfaces for Transmitting and receiving Employee data from Benefits vendors and insert into various PeopleSoft Tables.
• Developed different SQR reports to meet the client’s requirements using the Payroll tables.
• Worked with Technical, Functional and business resources, managing tasks for dis project, ensuring issues/risks are identified and resolved in a timely manner.
• Worked on setting up the HRMS core tables- Business Unit, Permission list, Country, Jobcode, Department, Location etc.