PROFESSIONAL SUMMARY:

• Having 9+ years of experience in implementation, development, customization and upgrade of PeopleSoft applications
• Successfully implemented Full life cycle projects - worked through the phases of requirement gathering, scope management, Process Analysis, GAP Analysis, Testing, Go-live, post live support and .
• Extensively worked on Application Designer, People Code, Application Engine, Maintain Security, Query, Approval Workflow Engine (AWE), Integration Broker, File Layout, Process Scheduler, Data Mover, Data Conversion, PUM, Query Manager, Component Interface and Reporting tools (SQR and Crystal Reports).
• Assistant/Change Assistant, Application Designer and Data Mover Scripts.
• Worked on Year End Processes and process involved for W2 generation and customization involved around all W2 process for the customers.
• Downloaded and applied the Tax updates 11-D, E, F and 12-A and involved in applying the retrofits on these tax updates on 9.1.
• Worked on a custom Bolton application called ETC (Exception Time Capture) involving several enhancements to the PS pages.
• Worked with Approval Workflow Engine to initiate a 3-level approval workflow process.
• Recently worked on Core HR, ELM, Payroll, Compensation, Base Benefits, workforce development, Time and Labor and ePerformance Modules. Developed customizations for PeopleSoft 9.2, 9.1 and Worked on SQR Reports, Delegation, AWE, Generic Templates and BI publishers. Written complex SQL queries and expertise in cutting down the query cost.
• PeopleSoft HRMS, Payroll, Base Benefits, Benefit Administration, ELM, Talent Acquisition Management, Manager Self Service, Absence Management, Finance 9.2 Time and Expense
• Excellent analytical, development and unit testing skills with the ability to work independently and as a team player.
• Participated in all phases of the Systems Development Life Cycle.
• Greatest strength is the ability to produce quality work.
• Capable of applying critical thinking concepts to problem solving, allowing for results that are high impact and high value to the client.
• Excellent ability to communicate with the business, providing clear and frequent updates.
• Proven ability to learn new functionality quickly.
• Experienced in using PeopleSoft Portal Development & Branding (Interaction Hub) for unique look and feel as per client's requirements.
• Involved in HCM, CRM and Enterprise Portal 9.2 Implementation for NY State Retirement System.
• Good knowledge of Security, Maintain Security (Roles, Permission lists, User profiles, Dynamic Roles) Row-level Security, Field Level Security, and Definition Security.
• Excellent process orientation in performing project scoping, business process re-engineering, fit/gap analysis, requirements gathering, functional design, application configuration, user interactions, testing and production support.
• Proficiency in PeopleSoft online development tools.

TECHNICAL SKILLS:

Operating Systems: UNIX Windows and NT.

Languages: SQL, SQR, PL/SQL, People Code

Database: SQL Server, Sybase, Oracle, MS Access

People Tools: Application Designer, PeopleCode, Security, Process Scheduler.

Data Mgmt Tools: Data Mover, Component Interface, Application Engine.

Third Party Tools: SQR, Crystal Reports

Reporting Tools: nVision, PS Query manager, XML Reports

Performance Tuning: Toad/SQL Developer

Migration Tools: STAT, Application Designer

PROFESSIONAL EXPERIENCE:

Confidential, Houston TX

Sr. People Soft Developer

Responsibilities:

• The design and development of online pages in peoplesoft internal hub using html, PeopleCode, Application Engine.
• Developed pages for eBenefits to deliver Benefit Enrollment pages, an employee can access.
• Developed and coded self-service applications in Peoplesoft HRMS 9.2
• Created Component Interfaces to populate data into selfservice pages. Created customized pages based on Derived Records.
• Worked on PeopleSoft Integration broker to open an interaction note between peoplesoft HCM and CRM.
• Involved in Unit, System and Preparation of Unit test cases Fixing any bugs that might come in Unit test.
• Developed and coded self-service applications in Peoplesoft HRMS 9.2.
• Handle the adhoc work requests which are raised from business
• Development of different types of objects including Application Engine, PS Query, Online PeopleSoft Component, PeopleCode, XML reports as per the Technical design document.
• Responsible for effective communication with the customer. Provide guidance to our customer in enhancing their Peoplesoft CRM implementation.
• Deliver new and complex high quality solutions to clients in response to varying business requirements
• Implemented 2nd Factor Authorization with SecureAuth on the Login pages and provided
• Worked with PeopleSoft Delegations in creating a new delegate transaction for Performance review Tracking and generated an outbound interface to send delegate details to third party systems which through the daily process.
• Created new page in SETUP HRMS where JOBCODES remapped with Client specific codes and developed an outbound interface to transmit this mapping to the third party system.
• Developed an SQR program in generating outbound interface files which contain employee information in a period and transmitted the Encrypted file to third Party and this Employee data acts as key records for data from ADP.
• Worked with Generic templates in creating a new Email Notification Template which is used to send Emails to Retired and terminated employees with hyperlink containing encrypted employee data to complete the survey.
• Involved in running the PS Delivered Application Engine process for data conversion from the current version to the newer version.
• Worked on BI- Publisher, XML reporting to generate PDF reports.
• Created new pages, permission list, roles and registered them in PeopleSoft portal.
• Maintain PeopleSoft user security using user profiles, roles & permission lists.
• Guided the QA team in defining test conditions & scenarios related to Enhancements and coordinated the SIT & UAT's along with issue resolution.

Environment: PeopleSoftHCM 9.1,PeopleSoftHCM 9.2, People Tools 8.52, People Tools 8.54, Application Designer, PeopleCode, Process Scheduler, PS-Query, Application Engine, SQLDeveloper, PL/SQL, Toad, MS Excel, SQR's, Crystal Reports, Unix.

Confidential, New York City, NY

Sr. people Soft Developer

Responsibilities:

• Worked in Design and Enhancement of PeopleSoft HCM for HR, ePerformance, TAM module.
• Worked on the ePerformance module, workforce development, performance documents e.t.c., on PeopleSoft HRMS 9.2 and People Tools 8.54.
• Designed Application Engine programs using component interface, Excel data capture templates and Excel to CI to process acquired company's HR data into PeopleSoft HCM.
• Moving application data between two PeopleSoft databases using Data Mover.
• Gathered approvals for functional requirement documents.
• Designed custom Online Pages, Run Control pages and PeopleCode to validate user interface meeting needs of the company.
• Created new page in SETUP HRMS where JOBCODES remapped with Client specific codes and developed an outbound interface to transmit this mapping to the third party system.
• Developed an SQR program in generating outbound interface files which contain employee information in a period and transmitted the Encrypted file to third Party and this Employee data acts as key records for data from ADP.
• Worked with Generic templates in creating a new Email Notification Template which is used to send Emails to Retired and terminated employees with hyperlink containing encrypted employee data to complete the survey.
• Involved in running the PS Delivered Application Engine process for data conversion from the current version to the newer version.
• Worked on BI- Publisher, XML reporting to generate PDF reports.
• Created new pages, permission list, roles and registered them in PeopleSoft portal.
• Wrote SQL queries using TOAD for Oracle to retrieve data from PeopleSoft HRMS. Besides this use PeopleSoft Query Manager to query different types of records of PeopleSoft.
• Designed new pages in administrative services to provide the ability for the user to specify document printing templates for various ePerformance documents and PeopleCode which prints the specified template when user click on the print icon.
• Designed customizations for ePerformance delivered pages to meet user requirements.

Environment: PeopleSoft HCM 9.2, People Tools 8.54, Application Designer, PeopleCode, Process Scheduler, PS-Query, Application Engine, Oracle 11g, Toad, OBIEE 10.3, MS Excel.

Confidential, Parsippany, NJ

Sr. People Soft Developer

Responsibilities:

• Worked in Design, Development, Testing, and Enhancement of PeopleSoft HRMS for HR, Payroll and Base Benefits, Absence Management, Time and Labor.
• Involved in writing App Engine Programs that which uses Component interfaces in order validate the components like Employee General Deductions and Additional Pay.
• Downloaded and applied the Tax updates 11-D, E, F and 12-A and involved in applying the retrofits on these tax updates on 9.1.
• Involved in writing the technical design documents and built them in 9.1 environments by reviewing the function design documents for the new customizations.
• Retrofitted and fixed the rules and related SQL objects in Time and Labor rules (e.g., Time Admin use to generate invalid offset).
• Designed and developed the XML Publisher reports in Time & Labor.
• Worked in the build or provide support of Benefits inbound and outbound interfaces such as 403B, FSA, 834 process, etc.
• Built an outbound interface that sends Personal Time Off data from PeopleSoft Absence Mgt to a third party Forecasting application.
• Participated in the research and resolution of Absence Management issues with formulas
• Provide support as needed for the Payroll Interface application
• Responsible for the maintenance of Jira and its reporting
• Involved in finding and fixing the errors that came out from the conversion programs which includes App Engines and Component Interfaces.
• Fixed the code in the delivered App Engine PER099 which populates the PS EMPLOYEES table.
• Worked on interface programs for migrating data from other systems to PeopleSoft.
• Worked on Integration Broker on messaging services to link PS HCM and Financial applications.
• Modified existing reports using PS query.
• Developed new Records, Online Pages, and Run Control Pages using People Tools for the specific needs of the company. Implemented PeopleCode for online validations and user interface.

Environment: PeopleSoft HCM 9.1, People Tools 8.52, Application Designer, PeopleCode, Process Scheduler, PS-Query, SQR, Application Engine, PL/SQL, Oracle 11g, Toad, MS Excel, STAT 5.3, Crystal Reports, Unix.

Confidential, Princeton NJ

People Soft Developer

Responsibilities:

• Worked on different kinds of issues on Core HR, Payroll, Absence Management, TAM in System Integration Testing.
• Liaison between the development and business teams to discuss and configure efficient solutions.
• Fixed the issue in PeopleCode when Operating Unit is getting a blank on Task Profile Page.
• Fixed the issue by activating the Service Operations and Domain Node when the data is not transferred from Prepare for Hires to Manager Hires and from Manage Hires to Person Data.
• Generated SQR reports creating Employee Data file which is sent to Finance system along with Payroll Data with CFT Transfer Protocol.
• Involved in development of requirements for PeopleSoft ePerformance and Portal Solution into functional designs and project plans as necessary.
• Worked on Payroll Execution, supporting Payroll and Tax issues, maintaining Tax patches, etc.
• Customized SQL Views, records and PeopleCode functions like SQL Exec, Scroll select, etc.
• Developed new Records, Online Pages, and Run Control Pages using People Tools for the specific needs of the company. Implemented PeopleCode for online validations and user interface.
• Worked on Payroll job scheduling, monitoring production cycle and Garnishments.
• Involved in preparing design and test documents for the enhancements given from Client.
• Worked on configuring & testing the core HR & NA payroll setup tables.
• Running and validating the current Benefits Elections of an employee in Open Enrollment and Event Maintenance process.
• Created and modified Components, File Layouts, Pages, Records, Fields, Process Definitions and registering Components in Portal, Menu and Permission Lists.
• Developed new Records, Online Pages, and Run Control Pages using People Tools for the specific needs of the company. Implemented PeopleCode for online validations and user interface.
• Developed complex SQR reports and SQC's to suit the needs of the company. Used Process Scheduler to make SQR available from within PeopleSoft.

Environment: PeopleSoft HRMS 9.0/HCM 9.1, People Tools 8.48/8.51, SQR, TOAD, ORACLE 10g, STAT 5.3, SQL PLUS 9.0.1.

Confidential, Chicago, IL

People Soft Developer

Responsibilities:

• Created the Vendor Voucher Inbound interface from Claims Center to PeopleSoft Accounts Payables.
• Developed the Payment status outbound interface to Claims Center system from PeopleSoft Accounts Payables.
• Automated the Stop/Void request on payments though interfaces.
• Designed and developed the Vendor Creation/Update interface between Contact Manager System and PeopleSoft.
• Setup the Prenote Functionality for ACH vendors.
• Setting up Custom Pay cycle Step Group, and made appropriate code changes to Pay cycle manager API's.
• Created custom POS pay interface file for new Banks.
• Created new EFT layout for ACH payments to banks.
• Created new Bank reconciliation interface to load bank Statements into Statement table through Component Interface.
• Created conversion interfaces for Payments and Vendors from legacy systems.
• Converted Crystal reports to XML publisher reports.
• Single point of contact for all AP, GL issues.
• Responsible for setting up new external bank accounts and payments reconciliation options.
• Performed the Onsite - Offshore activities.
• Ran Weekly Ticket status updates meetings with offshore team.
• Assist team members functionally/technically for the complex cases/issues. Identify repeated cases and investigate for RCA for permanent solution.
• Resolved highest no of Sev3, Priority 1 tickets and delivered the solution on time without any escalation.

Environment: PeopleSoft HRMS 8.8/9.0 (HR, Campus Solutions, Benefits, Payroll, E-Profile, Profile Management, TAM, ELM), PS-Query, Tree Manager, Security, TOAD, Ultra Edit, SQL Plus, PL/SQL, Test Director, Oracle 10 and UNIX

Confidential, Toledo, OH

People Soft Developer

Responsibilities:

• Developed Panels which provides GUI for the user.
• Participated in the 9.0 HCM implementation for two Accenture clients, New York City Health and Hospitals - HHC and Metropolitan Transportation Authority. Modules included HR, Benefits, Payroll for North America, ELM and Talent Acquisition Management.
• Wrote Technical Designs, Unit Test scenarios and Developed applications for the Release 2 implementation of HR, Payroll, Benefits and ELM for PeopleSoft 9.0.
• Created Functional and Technical designs, also built custom solutions for several applications for Talent Acquisition Management (TAM), including the Applicant's Screening process, Applicant, Outreach and Applicant Flow reports.
• Responsible for the design and build of RICE items such as Interfaces, Reports, Extensions and Conversions.
• Built complex reports in Application Engine/XML Publisher (XMLP) for numerous processes including Dependent Age limits notification letters and Mass Update tool, which also used a Component Interface.
• Key contributor to the successful implementation of customizations for ELM 9.0, despite being unfamiliar with this functionality.
• Provided technical advice on ELM that helped the functional team determine the right approach for the conversion of the legacy application to the new ELM system.
• Worked with functional users in the development of customizations for the delivered HIPAA interface process and coordinated with vendors for testing.
• Investigated and worked on the resolution of development defects using tools such as PeopleCode debugger, trace logs and other more traditional techniques for SQRs.
• Received recognition from the Account Executive for taking the initiative to fill in for an unavailable resource in a different team and completing a task highly visible to the Client.
• Provided technical advice to peer and junior developers, and recommended best technological approach to functional folks when project requirements were being written, as needed.
• Contributed to the Chase 8.9 to 9.1 Upgrade by creating an App Engine process to compare Table keys and counts between 8.9 and 9.1 and report table differences in Excel worksheets. Process was designed to help with the Upgrade by comparing up to 100 tables at a time reducing days of manual work to hours.

Environment: PeopleSoft HRMS 8.8, PeopleSoft HCM 9.1 (HR, Benefits, Compensation, Benefits Administration, Payroll, TL, ELM), E-Performance, E-comp, E-Profile, TOAD, Oracle 9i

Confidential, Salisbury MD

People Soft consultant

Responsibilities:

• Work involved development of SQR's and also customization using People Tools based on the technical design specification given by the client.
• Worked on analysis, coding, testing and review phases of work based on user requirement.
• Coordination of the work with on-site development team and conducting conference calls.
• Data validations, Setting default values, dynamically deriving the field values, implementing business rules, etc., using PeopleCode. Debug the PeopleCode using debugger.
• Involved in the design, development and testing of all HR, Payroll, Benefits.
• Involved in Data mapping between the two systems.
• Customized HR, payroll menus, inquiry pages as per the user requirement so that user can view more information.
• Customized SQL views, records and PeopleCode functions like SQL Exec, Scroll select, etc.
• Involved in developing various routines to transform the date to the Client database format by using SQRs and Application Engine programs.
• Involved in the setup of the SetID table, Company Information, Establishments, Location, Department, Salary Plan, Job Code and Pay Group tables for HRMS System.
• Generated SQR reports creating Time Load to pay sheets, master employee listing, employee pension plan data, new hires & terminations.
• Maintain PeopleSoft user security using user profiles, roles & Permission Lists.

Environment: PeopleSoft HRMS 8.9, People Tools 8.48, Crystal Reports, SQR, Query Analyzer, Application Designer, PeopleCode, SQR, PS/Query, security/View, Process Scheduler.