SUMMARY:

• Over 7 years of experience in IT Industry Requirement Analysis, Design, Full life cycle Development and Implementation of various applications in Client/Server & 3 - tier environment.
• Experience in customizing PeopleSoft HRMS(North America Payroll, Benefit Administration, Benefits, Compensation, Pension, Employee Self-Service & Manager Self Service) .
• Excellent Techno-Functional experience involved with all the facets of PeopleSoft Applications. Participated in all phases of Project life cycle Implementation, Customization, Development, Production Support and Upgrade.
• Excellent knowledge in Benefit Administration and North American payroll.
• Expertise working with tools STAT,HPQC,HPOV, Data Mover & CA

TECHNICAL EXPERIENCE:

PeopleSoft Applications: PeopleSoft HCM 8.3, 8.8, 8.9, 9.0, 9.1 and 9.2.

People Tools: Application Designer, PeopleCode, Application package, Workflow, Application Engine, Data Mover.

Reporting Tools: SQR, PS Query, and XML Publisher.

Integration Tools: Integration Broker, File Layout, Application Engine & Component Interface.

Migration Tools: Stat

QA Tools: HPQC

Other Tools: HPOV, CA & TOAD

RDBMS: Oracle 7.3, 8.x, 9.x, 10 g, 11g, SQL Base, MS-SQL Server 2000, IBM DB2.

Front Ends: PeopleSoft Portal-PIA

Scripting Languages: SQR, PeopleCode, HTML

PROFESSIONAL EXPERIENCE:

Confidential, Salt lake city, UT

Environment: PeopleSoft HCM (8.8)

PeopleSoft Benefits Administrator

Responsibilities:

• Techno-Functional consultant to Support Benefits & North American Payroll modules.
• Execution of yearly projects like Open enrollment.
• Fixing day to day benefits administration issues.
• Working closely with business team to help benefits setup issues.
• Documenting client requirements, initial estimation and execution plan and managing deliverables.
• Provided permanent fixes for many recurring support issues which as drastically reduced the support hours.
• Re-built couple of yearly projects making them to work without major changes for next year.
• Integration of benefits with 3rd party provider.
• Day-to-day Production issues with ADP
• Involved in the customization and enhancement of the PeopleSoft HRMS 8.8 (HR, Payroll, Benefits, and Benefits Administration) modules based on organizational needs and requirements.
• Written Benefit consolidation scripts.
• Experience in all phases of development life cycle - Requirements, Design, Development, Testing, and Support.
• Experience in Preparing Technical Design documents based on Functional Specs.
• Involved in discussion and analysis of Functional requirements and preparation of Test cases required for testing the complete functionality of System.
• Provide expert troubleshooting for isolating technical and functional problems in PeopleSoft environments.
• Analyze and debug issues with People Code, Application Engine, Component Interface and SQR.
• Debug and optimize SQL statements within PS-Query, SQR, and Application Engine.
• Written People code to implement the business rules.
• Knowledge and experience in PeopleSoft Workflows.
• Prepare and Execute Unit Test scripts
• Good interpersonal skills, able to build and maintain strong relations with users.
• Coordinating between onsite and offshore.

Confidential, Salt Lake city, UT

Environment: PeopleSoft HCM (9.2)

Responsibilities:

• Generated compare reports against Production and Vanilla Database
• Performed Fit/Gap analysis and building functional design documentation of the customizations.
• Analyzed business impact of inbound and out bound interfaces.
• Involved in SQR and People code Reapplied customization.
• Created DMS scripts using Data Mover
• Following efficient processes for the maintenance of the People Soft Payroll and Benefit Administration
• Monitoring processes and maintenance.
• Analysis of different processes (SQR, Application Engine).
• Responsibilities to understand the business requirement and prepare the solution design document, Unit Testing and Project Migration.
• Involved in troubleshooting and fixing bugs and problems.
• Developing/Coding the new design into a working functionality thereby resolving & handling all conflicts with other features and functionalities HCM. Met all the construct timelines and delivered all the features in maximum quality.
• Involved in the customization and enhancement of the PeopleSoft HRMS 8.8 (HR, Payroll, Benefits, and Benefits Administration) modules based on organizational needs and requirements.
• Experience in all phases of development life cycle - Requirements, Design, Development, Testing, and Support.
• Involved in discussion and analysis of Functional requirements and preparation of Test cases required for testing the complete functionality of System.
• Developed custom application functionality using People Code, Application Engine, Component Interface, XML Publisher, and Integration Broker, SQR, SQL.
• Analyze and debug issues with People Code, Application Engine, and Component Interface.
• Tune PS-Query, SQR, and Application Engine to improve Performance.
• Written People code to implement the business rules.
• Prepare and Execute Unit Test scripts

PeopleSoft Support and Development (PeopleSoft HCM 8.3, 8.8, 8.9, 9.0, 9.1 and 9.2.)

Confidential

Responsibilities:

• Periodic release planning.
• Tracking all updates delivered by Oracle and keeping US regulations related to Payroll and HR.
• Coordinating Business users on their day to day support issues.
• Coordinating with product management team (Change control board) on all upcoming regulatory enhancement and enhancement requested all the clients.

Confidential

Environment: PeopleSoft HCM (8.8)

Responsibilities:

• Involved in the customization and enhancement of the PeopleSoft HRMS 8.8 (HR, Payroll, Benefits, and Benefits Administration) modules based on organizational needs and requirements.
• Experience in all phases of development life cycle - Requirements, Design, Development, Testing, and Support.
• Experience in Preparing Technical Design documents based on Functional Specs.
• Involved in discussion and analysis of Functional requirements and preparation of Test cases required for testing the complete functionality of System.
• Developed custom application functionality using People Code, Application Engine, Component Interface, XML Publisher, and Integration Broker, SQR, SQL.
• Provide expert troubleshooting for isolating technical and functional problems in PeopleSoft environments.
• Analyze and debug issues with People Code, Application Engine, Component Interface, XML Publisher, and Integration Broker, SQR.
• Debug and optimize SQL statements within Query, SQR, and Application Engine.
• Reapply customizations in conjunction with large application upgrades.
• Written People code to implement the business rules.
• Knowledge and experience in PeopleSoft Workflows.
• Prepare and Execute Unit Test scripts
• Involved in the complete payroll process (Pay Calendar, Pay Sheet, Pay Calc, and Pay Confirm).
• Good interpersonal skills, able to build and maintain strong relations with users.
• Generated compare reports against the Production and Vanilla Database
• Analyzed compare Reports and Prepared Technical design document to customized objects
• Identify the objects need to be fixed and Prepared Technical Design documentation.
• Modified all objects in development environment
• Compared modified objects with production and tested impacted functionality in lower environment.
• Prepared Migration documents and unit test cases.
• Testing of the fixes before promoting the issue to QA team. Migration of the fix to test database, complete the testing.
• Move the project to QA where QA’s will review and test.
• After QA and UAT Approved project migrated to production.

Confidential

Environment: PeopleSoft HCM (8.8)

Responsibilities:

• As a programmer, fixing the problems.
• Provided the solutions for possible causes which were impacting the PeopleSoft issues.
• Customized many SQR reports for better performance.
• Created and modified Components, File Layouts, Pages, Records, Fields, Process Definitions and registering Components in Portal, Menu and Permission Lists
• Involved in online changes to the delivered pages, components, menus and translate values
• Modified, designed, configured and built fields, records, sub records, setting up keys to records, assign table edits like prompt table
• Involved in Design, Development, Testing, and Enhancement of PeopleSoft HRMS application modules.
• Customized SQL Views, records and People Code functions like SQL Exec, Scroll Select etc.
• Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process
• Developed number of inbound-outbound interfaces using SQR to read the data from file and load it into PeopleSoft tables and send data from PeopleSoft to other external applications
• Developed SQR programs to create Time Load to pay sheets, employee pension plan data.
• Involved in Data mapping for legacy data conversion
• Developed an application engine program using File Layouts to load New Hire interface file with all New Hired employees' information after each day and load them into the people soft tables
• Involved in acquiring Specifications from the functional team and modifying the SQR's as per the specifications
• Used process scheduler for scheduling recurring process, for conditional Scheduling of successive process, for setting up the reports to run at specific time and implementation of batch processing
• Involved in Unit testing of people soft delivered and modified functionality & customized SQR programs in HR, Benefits and Payroll Modules
• Conducted meetings with the Users and the testing team and involved in discussing their problems and helped them out in finding the proper solutions for their requirements.