PROFESSIONAL SUMMARY:

• Twelve years of experience in intensive software development in client/server technologies, including experience in customization, implementation, Production support and development of PeopleSoft Applications HCM, CRM this involves development of numerous interfaces and reports.
• Twelve years of technical experience in HCM, CRM & FIN.
• Strong knowledge and Experience in PeopleSoft 9.x/ 8.x, PeopleTools, PeopleCode, SQR, Data Mover, Component Interface (CI) and Integration Broker.
• Experienced in PeopleSoft 9.x/8.x and above (Implementation, Upgrade, Production Support and Product Development).
• Well versed in resolving the incidents, by fixing the bugs.
• Designed, Customized Fields, Record, and Pages, validated using People Code in Application Designer.
• Strong working knowledge in RDBMS (SQL, PL/SQL) in Oracle, DB2.
• Good Knowledge in Query, Application Engine and Tree Manager.
• Possess strong problem - solving skills, self-starter and a good team player with the excellent communication and documentation skills.

SOFTWARE SKILLS:

ERP: PeopleSoft HCM 8.x/9.x (HR, Payroll, Base Benefits, Benefits Administration, Manager/Employee Self-Service, eRecruit, eComp,ePay

PeopleSoft HCM: Campus Solutions 9.0, Financial Aid 9.0, People Tools 8.49

ERP Tools: PeopleTools 8.2x/8.3/8.4x/8.5x (Application Engine, Application Messaging, PeopleCode, Component Interface, Workflow, AWE Manager, Upgrade Assistant, Process Scheduler, Import Manager

Languages: People Code, SQL, PL/SQL, VB and SQR.

Database: Oracle, MS SQL Server, DB2

Operating System: Windows, UNIX, LINUX

Technical: People Tools, Integration Tools, Portal and People Code.

Functional: HCM, CRM.

Development Tools: Application Designer, Application Engine.

Integration Tools: Component Interface, Integration Broker

Reporting Tools: SQR, PS Query, PS/nVision, XML Publisher and Tree Manager Crystal Reports

Data Management Tools: Data Mover and Import Manager

Other Tools: STAT, CVS Repository

PROFESSIONAL EXPERIENCE:

Confidential, Wayne, NJ

Sr. PeopleSoft Techno Functional Consultant

Responsibilities:

• Involved in GEMS (HCM) upgrade from 9.1 to 9.2 versions. Key participant in the analysis and upgrade. Extensively involved in analyzing & running compare reports, Retrofitting SQRs, Queries, Application engines, Menus, modifying Query tree Security. Created scripts for Data Conversion activity. Supporting testing, training, security setup and upgrade tasks.
• Worked on Integration of PeopleSoft HCM 9.2 HR & CRM applications.
• Interacted with Business users to gather the requirements that include business process, enhancements, issues, production change requests and developed new/modified objects.
• Coordinated development and testing efforts between functional, technical and user groups. Managed issue tracking and creating project documentation.
• Performed fit/gap analysis, designed gap strategies and recommended business process changes to take advantage of delivered functionality and eliminate obsolete customizations.
• Configuration and Functional Setups for HR and Benefits tables like Providers/Vendor tables, Age-Grades, Rate codes, Zip codes, Schedule table, Geographic Location and Benefit Program tables etc. for new Vendor tables for the existing Benefit Program structure.
• Developed conversion programs to convert the data from the legacy to the HCM modules such as (HR, Base Benefits and Employee Self-Service) for acquisitions.
• Written Data Mapping document and developed various SQR and Application Engine Interfaces programs for HR and Payroll to retrieve data from and load data into PeopleSoft system.
• Developed various SQR and Application Engine programs to retrieve the data from the PeopleSoft Benefits module and send it across to third party vendors.
• Configured / customized Fluid pages for Managerial Self-service pages.
• Developed Inbound SQR Program N867IQN1 to Load Staging table with non-employee data from IQN.
• Developed App Engine Program to generate requested data elements in XML format.
• Worked on customizing the messages and nodes for the delivering activities as per the client requirements.
• Involved in row-level security for PS Queries and table level access for the specific users using query access groups.
• Created Application Engine Program to send an email notification to the supervisor of the newly added applicant after new hire process to inform them to begin the provisioning process.
• Developed Pivot grids using PS Query as per business requirement.
• Created application packages for retrieving the driver information Motor Vehicle data from External vendor using XML doc classes. Used XML publisher to generate Motor vehicle certificates which are transferred to XEROX.
• Worked on STAT Tool for migrations, used Data Mover to run the DMS scripts.

Environment: PeopleSoft HCM 9.1/9.2 (HR, Benefits, Payroll, Benefits Administration, Manager Self Service and Employee Self Service, Pension Administration), People Tools 8.53/8.54.

Confidential, Ewing, NJ

Sr. PeopleSoft Technical Consultant

Responsibilities:

• Worked Closely with Customers on developing business requirements on the Financial Aid System for some of their key business processes relating to Authorization, Disbursement and Federal Work Study.
• Configured and designed row level security system according to the requirements and as per the compliance.
• Designed, Developed and tested Permission lists, users, Roles and assigned roles to users.
• Worked with Business Analysts to get the Business process information for the custom built pages and Custom Records for Query.
• Customized the Student Records, Student Financials and Financial Aid as per the business requirements.
• Writing Technical specifications for user acceptance.
• Involved in complete life cycle of Student Administration (Student Records - - Creating the course catalogs, Enrolling Students, Scheduling the classes), (Financial Aid - - Awarding and Packaging, Direct Lending, Processing Financial Aid), (Student Financials - - Calculating Tuition and Fees, Returning Tuition and Fees) module.
• Created demoralized tables to optimize the performance of the applications and loaded the data for legacy system in flat file format into PeopleSoft Financial Aid tables using SQR.
• Participating in the Student working groups and arriving Confidential the focus topics.
• Worked Extensively on Authorization Probation & Edits Process in OSU as per there specifications as there are many specific customizations pertaining to OSU’s business practice.
• Developed Multiple Application Engine program for Authorization Proration (OFA AUTH PRO) and Authorization Edits (OFA AUTH EDT) in the Disbursement Processing arena.
• Developed an Application engine that would automate the Entrance and Exit interview Acknowledgement Process (OFA ENTR EXT). The data from External System was received to PS tables through a File layout and it used a component Interface to update the Service Indicator Page after the Exit Interview process was complete.
• Also Involved in Developing an Interface to the Online Federal Work Study System from the People soft Federal Work Study data. Developing an Application Engine to take care of this procedure. (OFA FWS2ISE)
• Accomplished tasks involved in developing interface and data migration processes. Developed report generation processes using SQR, and Crystal reports.
• Also developed programs to call the Application Messages and Component Interfaces from the Application Engine programs.
• Developed Inbound and Outbound Interface Programs by using Application Engine and Component Interface/ File Layout/ SQR to load the data into HR, Payroll and Benefits tables.
• Developed a custom Ceridian to PS interface through various staging tables using Application Engine program to load the pay data, earnings data, tax data and deduction data from Ceridian.
• Experienced in the design and development of the Workflow . This tool was primarily used to develop Work lists, Events and Routings for various businesses needs.
• Also is currently involved extensively in developing other business process relating to the Federal.

Environment: PeopleSoft HCM Campus Solutions 9.0, Financial Aid 9.0, People Tools 8.49, People Code, Oracle, Application Designer, SQL, Process S.0cheduler, Pages, Components, Component Interfaces, Queries, Application Engine.

Confidential, Jacksonville, FL

Sr. PeopleSoft Consultant

Responsibilities:

• Customization of PeopleSoft HCM 9.0 HR, Benefits, Payroll, Benefits Administration.
• Developed custom Workflow\CI for the managers where they can request Department and Location changes for their direct reports. The changes are then updated by a custom Component Interface after going through various levels of Approval steps and validations.
• Customized delivered Termination Workflow as part of the Manager Self Service where a manager can submit a request for the Termination of their direct reports. The changes are then updated in the JOB by a custom component Interface after going through the various Approval steps.
• Customized delivered Reporting Change Workflow as part of the Manager Self Service where a manager can submit a request for a reporting change of their direct reports. The changes are then updated by a custom component Interface after going through the various validations and approval steps.
• The Email notifications and Worklists are routed appropriately Confidential various stages of the transaction.
• Developed and customized record definitions and views, Pages, Components, Menu’s and assigning the permission by running the wizard using Application Designer.
• Created Application engine program and invoked the component interface program for the migration of payroll information from the legacy to the PeopleSoft system.
• Performed Data Mapping and developed various SQR and Application Engine Interfaces (inbound & outbound) to retrieve data from and load data into PeopleSoft system.
• Ensured that all the requirements, enhancements were documented and reviewed by the Business users before the final sign off.
• Worked on scheduling jobs using CA ESP Scheduler.
• Extensively developed Object-Based People Code for data validation and customizations.
• Designed and developed many new Benefits and HR Reports by using PS Query and SQR.
• Extensively worked on crystal reports for reporting.
• Executed the payroll cycles such as Pay sheet Generation, Pay Calculation and Pay Confirmation and compared them with the expected result sets.
• Developed SQRs that had to do a lot of file handing and ran them from SQR Dialog Box, Process Scheduler on UNIX and command line depending on the user requirements.
• Interacted with the end users and provided training to them to run Payroll processes, Custom Processes and reports.
• Developed SQRs that had to do a lot of file handing and ran them from SQR Dialog Box, Process Scheduler on UNIX and command line depending on the user requirements.
• Used the PS query tool to generate reports as required for analysis of performance of Batch programs.
• Used the STAT tool to migrate the PeopleSoft projects into different instances.
• Performed Unit Test and assembly test of PeopleSoft modules and the integrated products.
• Documented the implementation, integration and Testing procedures in detail.

Environment: PeopleSoft HCM 9.0 (HR, Benefits, Payroll, Time & Labor, Absence Management, Benefits Administration, Pension Administration), PeopleTools 8.49, ORACLE 10g.

Confidential, San Ramon, CA

PeopleSoft Technical Consultant

Responsibilities:

• Actively involved in the Production support and Enhancement of project for HRMS 8.8
• Reviewed functional requirements and created technical design specifications according to the new business requirements.
• Upgraded the custom SQRs and Application as per the client requirement.
• Developed a custom App Engine program to load Employee Additional pay data into the payroll tables using a Component Interface.
• Developed new Synchronous and Asynchronous Interfaces to the external systems using Integration broker tool using XML structures.
• Developed new reports using SQR, Crystal and PS-Query.
• Worked on Integration Broker and Application Messaging with third party integrated applications like PeopleSoft CRM call center module
• Developed PL/SQL scripts to update the JOB records of Terminated Employees using TOAD application against Oracle 9i database.
• Worked extensively on CVS repository to store the build scripts, data mover scripts, one time scripts and STAT application to migrate the Projects.
• Developed Application Engine programs and schedules to run daily/weekly basis.
• Worked on PeopleSoft security by creating Roles and permissions lists to give access to configure the setup data, attributes.
• Worked on Performance tuning of tables by identifying and updating the indexes and views by updating the SQL’s for better performance of the application.
• Customized the delivered SQRs and various PeopleSoft online objects in HR, Payroll, Benefits
• Involved in configuring the security and creating new custom Roles and Permission lists.
• Responsible for resolving the production issues (High Priority) Confidential onsite.

Environment: PeopleSoft - HRMS 8.8, (HR, Benefits, Time & Labor, Absence Management, Payroll, Manager Self-service, and Employee Self-service, e-Recruit) People Tools 8.42.

Confidential, Pleasanton, CA

Applications Engineer for Support Development Team

Responsibilities:

• As a part of the team involved application integration, & testing.
• Involved in Development of PeopleSoft HRMS 9.0 version
• Involved in Support and Enhancement of PeopleSoft HRMS 8.9 version.
• Involved in Support and Enhancement of PeopleSoft HRMS 8.8 version.
• Involved in Client interaction with PeopleSoft Global Service Center (GSC).
• Involved in fixing the incidents (bugs) throughout the HRMS product for 8.9& 9.0 versions
• Worked on multiple database platforms - Oracle, SQL Server, DB2
• Involved in Documentation for the latest version of PeopleSoft HRMS.
• Involved in migrating the data across the applications using Data mover and Import manager.
• Worked extensively on Component Interface, Integration Broker and Application Messaging.
• Possess thorough knowledge of Support Development Process.

Environment: PeopleSoft 8.9/9.0, PeopleSoft Human Resources (HR, Ben Admin, Payroll), PeopleTools 8.16, Integration Tools, SQR Interface/reports, SQL, FTP, Unix, STAT and Oracle 9i.

Confidential, Pleasanton, CA

Software Engineer

Responsibilities:

• Involved in Development of PeopleSoft HRMS/CRM 8.9 version.
• As a part of the team involved application integration, & testing.
• Involved in Support and Enhancement of PeopleSoft HRMS 8.8SP1 Versions.
• Involved in Client interaction with PeopleSoft Global Service Center (GSC).
• Involved in solving the incidents (bugs) throughout the HRMS product.
• Worked on multiple database platforms - Oracle, SQL Server, DB2
• Migrated the data across the applications using Data mover.
• Involved in modifying Delivered Component Interfaces and worked on Integration Broker.
• Involved in Documentation for the latest version of PeopleSoft HRMS.
• Developed test plans and performed project migration, quality assurance and data integrity testing to meet core business requirements.
• Worked on PeopleSoft security, created new Roles and queries and Role user queries for the work flow.

Environment: Implementation of PeopleSoft HRMS/CRM 8.9/PeopleTools 8.46 (HR, Benefits, e-Recruit, Manager Self-service, Employee Self-service), MS SQL Server, oracle, DB2.

Confidential

PeopleSoft Technical Team Consultant

Responsibilities:

• As a part of team involved in implementation, design and development
• Developed and Customized Records, Pages, Components, Menus and Application Engine Programs through Application Designer.
• Worked in PeopleCode, Debugged SQL queries, enhancements of the existing programs according to the Business Process.
• Performed modification and enhancements to People Code on different events to implement in Business Rules.
• Creating process schedules for customized Reports.
• Created reports using PS Query and Crystal Reports.
• Maintenance of all the issues and following it up with the user requirement.
• Mentored team members throughout PeopleSoft implementation.

Environment: PeopleSoft 8.x Application Designer, People Code, Application Packages, Application Engine, Workflow, Process Scheduler, SQL Server 2000.