Experience Summary:

• 14 Years of Overall IT Experience and 13 years of PeopleSoft Development
• Experience working within the HCM and HRMS modules and GL, AP, AR and AM.
• Excellent verbal and written communication skills.
• Strong Technical design documentation skills.
• Good knowledge in UNIX and Windows Environments.
• Extensive Experience in Production support 24/7.

Technical Skills:

• ERP Packages PeopleSoft 7.02/7.5/ 8.15 /8.3 /8.8 /8.9 /9.0/9.1 HCM Formerly known as HRMS HR, NA Payroll, Benefits Administration, Base Benefits, Time Labor, Self-Service, PeopleSoft Financials AP, AR, GL, AM
• Software/Languages C, C , People Code, SQR, C, JAVA, SQL, PL/SQL and HTML, VB, COBOL
• RDBMS Databases Oracle 7.x/8i/9/10, MS-SQL Server, DB2
• Development /
• People Tools Application Designer, Process Scheduler, Application Engine, Data Mover, Component Interface, Security Administrator, Tree Manager and People Code
• PeopleSoft
• Reporting Tools SQR, PS Query, Crystal Reports, XML Publisher
• Operating System Windows NT/ 2000/XP/8.1, UNIX HP-UX, Sun Solaris

Professional Experience

Confidential

Sr. PeopleSoft Technical Consultant Production Support Enhancements PeopleSoft 9.1

• Developed Design specification for HR, Payroll and Benefits data for new interfaces Reports
• Developed new Application Engine SQR process for Interfaces Inbound .
• Developed written DMS scripts for migrating data from one environment to another.
• Involved in writing design specifications, Technical documents for custom interfaces reports.
• Involved in unit testing, documentation end-user training.
• Developed new Application Engine SQR process for Interfaces for benefits vendor files. Outbound .
• Created Database Audit tables for HR, Payroll and benefits tables.
• Worked on position data to create job requisition.
• Created new custom pages people code as per the client business requirement.
• Developed new queries using query Tool, SQR XML publisher to generate reports.
• Involved in Production support, Trouble shooting, coding testing.

Environment: PeopleSoft 9.1, People Tools 8.52, Oracle 11 G, Stat, Toad, PeopleSoft HCM, Remedy

Confidential

Sr. PeopleSoft Technical Consultant conversion from Legacy to PeopleSoft 9.1

• Developed Design specification for HR, Payroll and Benefits data from Legacy Data to PS system.
• Developed new Application Engine SQR process for Interfaces Inbound .
• Developed written DMS scripts for migrating data from one environment to another.
• Involved in writing design specifications for developing custom interfaces.
• Involved in unit testing, documentation end-user training.
• Developed new Application Engine SQR process for Interfaces for benefits vendor files. Outbound ..
• Developed new queries using query Tool, SQR XML publisher to generate reports.

Environment: PeopleSoft 9.1, People Tools 8.52, Oracle 11 G, Stat, Toad, PeopleSoft HCM

Confidential

Sr. PeopleSoft Technical Consultant conversion from Legacy to People soft 9.1

• Developed Design specification for all HR, JOB, Personal, Payroll and Benefits data from Huntington Hospitals Legacy data to LIJH PS system.
• Developed new Application Engine SQR process for Interfaces Inbound .
• Developed written DMS scripts for migrating data from one environment to another.
• Involved in writing design specifications for developing custom interfaces.
• Involved in unit testing, documentation end-user training.
• Developed new Application Engine SQR process for Interfaces for benefits vendor files. Outbound .
• Written SQR's from scratch to generate Reports in PDF format.
• Developed new queries using query Tool to generate reports.

Environment: PeopleSoft 9.1, People Tools 8.51, Oracle 10 G, Stat, Toad, PeopleSoft HCM

Confidential

Sr. PeopleSoft Technical Consultant conversion from ADP to PeopleSoft 8.9

• Developed Design specification for Payroll data from ADP to Canon PS system.
• Developed new Application Engine SQR process for Interfaces Inbound .
• Developed written DMS scripts for migrating data from one environment to another.
• Involved in writing design specifications for developing custom interfaces.
• Involved in unit testing, documentation end-user training.
• Developed new Application Engine SQR process for Interfaces for benefits vendor files. Outbound .
• Written SQR's from scratch to generate Reports in PDF format.
• Developed new queries using query Tool to generate reports.

Environment: PeopleSoft 8.9, People Tools 8.47, Oracle 10 G, Stat, Toad, PeopleSoft HCM,

Confidential

Sr. PeopleSoft Technical Consultant UPGRADE from 8.9 to 9.1

• Involved in identifying table differences from 8.9 to 9.1
• Modified SQR program and online pages according to new Version Changes as per the business requirement.
• Developed new Application Engine SQR process for Interfaces Inbound Outbound .
• Involved in writing design specifications for developing custom interfaces.
• Involved in unit testing, documentation end-user training.
• Developed new custom pages for self service Employee applications Manager Applications ePay,eProfile,ePerformance,ePay and TAM Candidate Gate way Erecruit Applications .
• Created Roles Permission lists for new users using PeopleSoft HR security.
• Created New Data Archive tables for custom data transaction tables.
• Written SQR's from scratch to generate Reports in PDF format.
• Developed new queries using query Tool to generate reports.

Environment: PeopleSoft 9.1 PeopleSoft 8.9, People Tools 8.5 8.47, Oracle 10 G, Stat, Toad, PeopleSoft HCM

Confidential

Sr. PeopleSoft Technical Consultant UPGRADE from 8.8 to 9.0

• Involved in identifying table differences from 8.8 to 9.0
• Involved in Fit-Gap Analysis for 8.8 vs. 9.0
• Modified SQR program and online pages according to new Version Changes as per the business requirement.
• Developed new Application Engine SQR process for Interfaces Inbound Outbound .
• Involved in writing design specifications for developing custom interfaces.
• Involved in unit testing, documentation end-user training

Environment: PeopleSoft 9.0 PeopleSoft 8.8, People Tools 8.5 8.45, Oracle 10 G, Stat, Ultra Edit, Toad, PeopleSoft HCM, PeopleSoft Financials, Student Administration.

Confidential

Sr. PeopleSoft HRMS Technical Consultant

• Involved in writing new benefit programs for new company MGI employees from scratch.
• Developed all pages, menus, and department and user security reports. Also modified the department security Tree.
• Involved in setting up of the HR security by creating new roles and permission lists.
• Developed and modified all benefits life plans pages and self service for MGI company people.
• Modified people code for workflow for new hires, Terminations and Loa's. To payroll department and benefits department.
• Developed new Interface program for sales people Incentive compensation with all business rules.
• Involved in writing Interfaces Inbound Outbound using SQR's for HR, Benefits, Payroll and Sales.
• Interact with business analysts end users to gather requirements to write the technical design specifications.
• Involved in portal Registry using component Registry for web based application according to People soft portal node standards to meet client business requirements for portal, 3-tier web browser used web logic server
• Involved in unit testing, documentation end-user training
• Worked with users business analyst to fix the production issues.
• Worked with performance modifications as per client requirement.
• According to priority of the production issues, analyzed fixed the production issues.
• Involved in unit testing and integration testing according to business requirement.
• Involved in System Production Support. Run the DMS scripts for the migration.
• Involved in writing design specifications for developing custom interfaces.

Environment: PeopleSoft HRMS/HCM8.9 production support Enhancements payroll, Benefits, HR

Peopletools8.47, Oracle 10, UNIX, SQR5.3, Toad, ultra edit, windows XP, Lotus notes, STAT

Confidential

Sr. PeopleSoft HRMS Technical Consultant

• Involved in writing Interfaces Inbound Outbound using SQR's for HR, Benefits, Payroll, Work Brain Time Labor to PS and Payroll to GL.
• Interact with business analysts end users to gather requirements to write the technical design specifications.
• Involved in portal Registry using component Registry for web based application according to PeopleSoft portal node standards to meet client business requirements for portal, 3-tier web browser used web logic server
• Involved in unit testing, documentation end-user training
• Worked with users business analyst to fix the production issues.
• Modified SQR program and online pages according to new business process.
• According to priority of the production issues, analyzed and fixed the production issues.
• Involved in unit testing and integration testing according to business requirement.
• Involved in System Production Support.Run the DMS scripts for the migration.
• Involved in writing design specifications for developing custom interfaces.
• Involved in setting up of the HR security by creating new roles and permission lists.
• Developed Interface program to load the requisition data into PeopleSoft tables.
• Involved in implementing eRecruit with resume processing to track and recruit various applicants online.
• Upgraded the PeopleSoft system from 8.9v to 9.0versions with applicable changes and Updates.
• Worked with ePerformance modifications as per requirement.
• Designed developed AP Interface for client vendor
• Designed developed GL interface to feed into Oracle application financials system.

Environment: PeopleSoft HRMS/HCM8.9/9 production support Enhancements payroll, Benefits, HR, GL

Peopletools8.46, DB2, UNIX, SQR5.3, Toad, ultra edit, windows XP, Remedy 6

Confidential

Sr. PeopleSoft Technical Consultant

• Interact with business analyst end users to gather requirements to write the technical design specifications
• Involved in technical design for various conversions Interfaces and Reports.
• Developed various data conversion SQR's from legacy systems JD Edwards to PeopleSoft
• Involved in portal Registry using component Registry for web based application according to PeopleSoft portal node standards to meet client business requirements
• Involved in writing Interfaces Inbound Outbound using SQR's Application Engine for HR, Benefits, Payroll, AP and GL.
• Involved In writing custom people code w.r.t client business requirements
• Developed new Application Engine programs and also customized existing Application Engine programs.
• Used Test Director 8.2 to post issues. Used Quest Stat for Migrations.
• Involved in unit testing, system and parallel testing. Documentation End-user training
• Involved in writing DMS scripts to copy the Record structures into the seed database during database creation.
• Involved in Performance tuning of various SQR's and Queries that were taking too longer to run.
• Involved in setting up of the security by creating new roles and permission lists.
• Involved in system production support.
• Designed developed GL, AR and AP interface from JDE system to PeopleSoft feed to SAP financial system.

Environment: PeopleSoft HRMS/HCM8.9 payroll, Benefits, HR, GL, AP, AR Peopletools8.46, Oracle 9, UNIX, SQR5.3, Toad, STAT, ultra edit, windows XP, Test Director 8.2

Confidential

Sr. PeopleSoft Technical Consultant

• Involved in technical design for various conversions.
• This project was implementation of new modules Upgrade.
• Developed various data conversion SQR's from legacy systems to PeopleSoft.
• Developed Component Interface for salary changes.
• Designed developed various custom Audit reports for various PeopleSoft Tables using SQR
• Modified employee Termination Work flow according to the client business requirement.
• Designed developed various inbound outbound Interfaces using SQR's Application Engine. Involved in unit testing performance tuning.
• Interact with business analyst end users to gather requirements to write the technical design specifications.
• Involved in portal Registry using component Registry for web based application according to PeopleSoft portal node standards to meet client business requirements for portal, 3-tier web browser used weblogic server
• Involved in unit testing, documentation end-user training
• Used Brio performance engine for SQR testing
• Involved in unit testing, system and parallel testing. Documentation End-user training
• Involved in writing DMS scripts.
• Developed modified various online pages according to business requirement.
• Worked extensively on online customizations for Employee self-services Manager self-service and eBenefits as per the End User Requirement and Business need.
• Involved in developing modifying the interfaces and reports for Global payroll for India, Mexican countries.
• Migrated objects from one environment to another environment using STAT.
• Designed customized eBenefit Home Pages Benefits enrollment Flexible spending Accounts pages life Events Marital status Change Using Application Designer, People Tools, People Code
• Wrote application engine programs to insert the Salary Plan, comp rate changes into the Job Table and the Salary Plan Table.

Environment: PeopleSoft HRMS/HCM8.8 payroll, Self service, Benefits, HR, Global Payroll Peopletools8.44, Oracle 9, UNIX, Brio, Clarify, SQR5.3, Toad, STAT, Control M, DB2

Confidential

Sr. PeopleSoft HRMS Technical Consultant

• Involved in the customization and Upgrade of the PeopleSoft 7.02 HRMS HR, Payroll and Benefits Administration Modules to 8.3 Version based on Organizational needs and requirements. Performed interfacing, conversions, data migration and report writing using People Code, People Tools and SQR . Primarily involved in Report Customizations using SQR and Crystal reports conversions to version 8.3
• Involved in applying on-line customizations to HR, Payroll and Self Service modules of PeopleSoft HRMS v8.3. Also responsible for developing SQR interface programs and Application Engine programs that are of high degree complexity.
• Extensively used PeopleSoft Application designer, Report Manager, Process Scheduler, PeopleSoft Query and other development tools.
• Extensively applied Peoplecode validations. Developed generic Peoplecode function library programs for various tasks, for example, implementing field level security based on end user roles.
• Designed developed Technical documents for various reports Interfaces.
• Using eRecruit MSS Manager Self Service posted the job descriptions and requirements online and enabled the external and internal applicants to submit resume online Enabled Manager to select applicants for interview, scheduled interviews and entering interview results.
• Customized pages for ePay to deliver Pay check information, Direct Deposit information, W4 online
• Experienced in applying SP1 service pack 1 for People Tools 8.2
• Developed tested different new Pages and SQR Reports based on the Client's requirements.
• Developed technical and End-User documentation and conduct PeopleSoft end-user Training.
• Involved in System Production Support.

Environment: PeopleSoft HRMS 8.0/7. 0.2, PeopleTools, People Code, SQR 5.3.2, SQL, UNIX, Kintana for migration Windows 2000 and Oracle 8.0, SP1, DB2, Crystal Reports

Confidential

PeopleSoft Developer

• Technical/functional analysis, documentation, requirements gathering, design, and development of PeopleSoft Payroll Reports.
• Developing and coding of new SQR's for running Interface programs after Merges and Exporting data from database to the other.
• Gathering requirements from the End User, analyzing the process flow, creating and modifying Reports, coding new SQR programs as per the requirement.
• Upgrading the PeopleSoft HRMS 7.5 to 8.0 by using the Upgrade Assistance.
• Identifying Fields and Tables that were changed from Ver 7.5 to Ver 8.0 and making necessary changes to the Client's Customized SQR's in order to perform in PeopleSoft 8.0 Environment.
• Developed and Customized Records, Panels and Menus using People Tools like Application Designer.
• Involved in development and maintenance of People Soft Applications like HR, Payroll, Benefits, and GL-Interface etc.
• Import and export of the database using the Data Mover.
• Involved in solving problems related to Benefits, HR, Payroll and GL-Interface etc.
• Regularly interacted with the end-users and work according to the modifications required by them.
• Developed Various Reports using SQR for various Reporting requirements.
• Involved in customization of various interface programs related to Benefits, Payroll etc.
• Involved in design development of Self service Modules eRecruit, ePay, eBenefits eCompensation
• Involved in System Support 24/7

Environment: PeopleSoft HRMS 7.0/7.5/ 8.0, People Tools, People Code, SQR 4.0, SQL, Windows NT, Oracle 8.0