Professional Summary:
	Total IT experience of 7 years which includes 6 years in people soft HRMS v7.5/8.0/8.3 & v 8.9.
	Industry experience includes Banking, Finance, medical, Pharmaceutical and software. 
	Have good understanding of Functional and Technical aspects of various modules in PeopleSoft HRMS - HR, Payroll, Time & Labor and Base Benefits.
	Proficient in People Tools - Application Designer, Application Engine, Upgrade Assistant, Component Interface, Integration broker, Security Administrator.
	Involved in Fit/Gap analysis of the HRMS processes in the PeopleSoft Version 8.3 and identified the customizations that needed to be carried forward. 
	Development and modification of Outbound and Inbound SQR interfaces. 
	Upgraded PeopleSoft HRMS from 7x to 8x using Application Upgrade Assistant, Application Designer and Data Mover Scripts.
	Involved in Production Support.
	Proficient in writing complex database reports and customizing PeopleSoft Delivered SQR reports. 
	Experience in retrofit of SQRs during upgrade from HRMS 7.5 to HRMS 8.3.
	Involved in Unit Testing and Systems Integration Testing during up gradation of People soft system from 7.5 to 8.3. 
	Worked on mapping functional requirements to technical requirements. 
	Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process. 
	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.
	Applied bundles & patches for the enhancements.
	Worked on interface programs for migrating data from other systems to People Soft.
	Involved in documentation of technical specifications, developing test cases and technical design. 

Technical Skills:
ERP package			:   PeopleSoft   HRMS 8.9/8.8 /8.3 /7.5
People Tools 			:   Tools v 8.46 /8.42/8.21/8.18/7.5
Development Tools   		:   Application Designer, People Code, Application Engine 
                                                    Component Interface, Integration broker, Business Interlinks                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
Reporting Tools		:   PS/ query, Crystal Reports, SQR, Process Scheduler
Administrative Tools	:   Data Mover, Security Administration, Import Manager
RDBMS			:   Oracle 9i, Ms SQL Server, DB2, Toad
Languages			:   VB6.0, Pascal, TSL, SQL, PL/SQL
Operating Systems	 	:   UNIX, Sun Solaris, Windows 2000/NT/95/98, MS DOS

Professional Experience:
Client		: Glaxo Smith Kline, Atlanta			                   Aug’07-Till Date
Project	: Implementation of PeopleSoft HRMS 8.9 
Role		: PeopleSoft Technical Consultant 

GSK is the pharmaceutical company researching both medicines and vaccines for the World 
Health Organization’s three priority diseases. This was a PeopleSoft HRMS implementation
Project. The various modules being implemented were HR, Benefits, and Payroll.
Responsibilities:
•	Involved in Design, Development, Testing, and Enhancement of PeopleSoft HRMS for HR, Payroll and Base Benefits modules.
•	Created and modified Components, File Layouts, Pages, Records, Fields, Process Definitions and registering Components in Portal, Menu and Permission Lists.
•	Developed number of interface reports using SQR to read the data from file and load it into PeopleSoft tables and send data from PeopleSoft to other external applications.
•	Involved in online changes to the delivered pages, components, menus and translate values. 
•	Developed an Application Engine Programs like Blue cross blue shield and HRIS Premiums Interface.
•	Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process. 
•	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.
•	Worked on interface programs for migrating data from other systems to People Soft.
•	Also involved in acquiring Specifications from the functional team and modifying the SQR’s as per the SPECS.
•	Extensively 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.
•	Used File Layout Definition to get data from the legacy system to people soft tables. 
•	Modified, designed, configured and built fields, records, sub records, setting up keys to records, assign table edits like prompt table. 
•	Active role in changing the SQRs as per the change requests from the users.
•	Involved in Unit testing of people soft delivered and modified functionality & customized SQR programs using HR, Benefits and Payroll Modules. 
•	Handled bundles for the process of solving the issues in the enhancements.
•	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.

Environment	: PeopleSoft HRMS 8.9, People Tools 8.46, Application designer, People Code, Process Scheduler, PS-Query, SQR, SQL Plus, Application Engine, Oracle 9i, MS Excel, Crystal Reports, Windows NT/2000

Client		: Chase Bank, Columbus			 	                  June'06 – Aug’07
Project	: Implementation & Customizing PeopleSoft HRMS 8.9 
Role		: PeopleSoft Technical Consultant 
Chase is a consumer& commercial banking service unit its business includes Small business, Home finance, Auto and education finance and Insurance .The commercial banking businesses include middle market, Corporate, Commercial Real Estate, Business Credit and Equipment Leasing.
Responsibilities:
•	Involved in Design, Development, Testing, and Enhancement of PeopleSoft HRMS for HR, Payroll, Time & Labor and Base Benefits modules.
•	Created and modified Components, Pages, Records, Fields, Process Definitions and registering Components in Portal, Menu and Permission Lists.
•	Created new SQR Programs like employee eligibility for FMLA/STD and Prudential 401K Deferral/Catch-Up Load.
•	Developed ad-hoc reports and ad-hoc queries developed Run Control Pages as per requirements and attached to menu to run SQRs for the developed sqrs. 
•	Developed an application engine program to create security interface file with all terminated employees information after each pay period and sent to the information security department 
•	Developed complex SQR reports and SQCs to suit the business requirements of the company.
•	Handled patches & bundles for the process of enhancements.
•	Developed SQR reports that displays leave accrual information by leave plan and employee. It includes information such as plan year eligibility hours, carryover hours earned year-to-date, hours taken year-to-date, and remaining leave balances.
•	Developed various PS queries in order to help the client day-to-day activity.

Environment	: PeopleSoft HRMS 8.9, People Tools 8.46, Application designer, People Code, Process Scheduler, PS-Query, SQR, SQL Plus, Application Engine, Oracle 9i, MS Excel, Crystal Reports, Windows NT/2000

Client		: Praxair, Danbury CT					          Jan’05-May’06           
Project	: Upgrade of PeopleSoft HRMS 7.5 to 8.3 
Title		: PeopleSoft Technical Consultant
This was a PeopleSoft HRMS implementation and simultaneous upgrade project. 
The various modules being implemented were HR, Benefits, Payroll, Time and Labor, 
Pension Admin.
Responsibilities:
•	Team member in the PeopleSoft Stabilization team with active role in interaction with the users and their specifications.
•	Application development experience with People Tools 8.16.
•	Upgrade HRMS module from version 7.5 to 8.3
•	Assisted in upgrading PeopleSoft HRMS from version 7.5 to 8.3. Converted all custom panels to PeopleSoft web pages for PeopleSoft 8.0
•	Involved in implementation of PeopleSoft HRMS 7.5 system.
•	Created new and customized existing PeopleSoft objects (Panels, Panel Groups, Menus, People Code, Process Definition) and applied Security
•	Involved in the development of SQR’s related to the Employee benefits and their 401k contributions and other related information to different banks and other institutions.
•	Worked with the Testing team and the users and helped them out in the testing process of different SQR’s.
•	Handled bundles & patches  to resolve issues & upgrade the application.
•	Enroll employees into benefit plans and setup dependent and beneficiary data.
•	Loaded Pension Plan information from Spread Sheet to PS Tables
•	Setup Pension Plans, Employee deductions for Pension contribution, retiree administer control tables, calculation rules for Pension Plans
•	Created Pension status codes.
•	Active part in the panel development, people code, and menu creations and creating new record definitions as per the client requirement.
Environment: People Soft 7.5/8.3, People tools 8.16, HRMS (HR, Payroll, Benefits, Time and Labor, Pension Admin), People code, SQR, Oracle 8.x and UNIX.

Client		: H&R Block, Kansas				 	        Feb '04 - Dec’04
Project	: Implementation of PeopleSoft HRMS 8.8 
Role		: PeopleSoft Technical Consultant 
H&R Block is a tax preparation and personal finance management company headquartered at Kansas .Operating out of more than 9,000 tax offices and 98 Financial Centers in the United States, as well as more than 1,000 tax offices in Canada, Australia, and the United Kingdom, serving more than 19 million taxpayers worldwide.
Responsibilities:
•	Involved in analysis, customization and implementation of HR/Benefits/Payroll modules using PeopleSoft 8.8 and Oracle 9i.
•	Involved in the design, development and testing of all HR, Payroll, Benefits.
•	Involved in Data mapping between the two systems.
•	Customized HR, payroll menus, enquiry pages as per the user requirement so that user can view more information.
•	Customized SQL Views, records and People Code 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 setup of SetID table, Company Information, Establishments, Location, Department, Salary plan, Job Code and Pay Group tables for HRMS System.
•	Generated SQR reports to create Time Load to pay sheets, master employee listing, employee pension plan data, new hires and terminations.
•	Maintaining PeopleSoft user security using user profiles, roles & permission lists. 
Environment	: PeopleSoft HRMS 8.8, People Tools 8.42, Crystal Reports, SQR, Oracle 9i , Web Logic 8.1/6.1, Tuxedo 6.5, Toad, Windows NT/2000, Query Analyzer, Application Designer, People Code, SQR, PS/Query, security/View, Process Scheduler .

Client		: Cigna Insurance, Philadelphia	                                            Apr'03 – Dec’03
Project	: Upgrade of PeopleSoft HRMS 7.5 to 8.3 
Role		: PeopleSoft Technical Consultant 
Responsibilities:
•	Extensively involved in PeopleSoft HRMS upgrade from v7.5 to 8.3.
•	Upgraded PeopleSoft HRMS – HR, Payroll, Base Benefits, Time & Labor.
•	Upgrading, Support and Trouble shooting Technical & Functional issues. 
•	Configuring Base tables.
•	Modified/Created SQR reports/interfaces, Crystal reports and Modified custom PS objects.
•	Developed new reports using SQR, Crystal and PS-Query.
•	Writing and running Test cases/scripts.
•	Involved in Vanilla compare to find out level of customization. 
•	Used Upgrade Assistant to automate some of the upgrade tasks and to keep track of the begin time and end time to run a process.
•	Ran release scripts to upgrade tools from version 7.5 to 8.18. 
•	Involved in running Upgrade Scripts & Process using Upgrade Assistant Tool.
•	Involved in running Upgrade Compare Reports between Demo database and Copy
of production before we do the upgrade copy. 
•	Used Application up grader to migrate objects from Demo to Target instance. 
•	Involved in Fine Tuning of Database Tables, which are used in Data Conversion.
•	Application Engine Programs to increase the performance. 
•	Converted the panels to PeopleSoft 8.3 pages by running the PS delivered SQR 
 process. 
•	Modified customized SQR reports in version 7.5 to make it version 8.3 compatible and to accommodate the new key structure. 
•	Extensively used Process scheduler for setting up the reports to run at specific time and used Process Monitor to monitor the status of reports. 
•	Created Permission lists, users, roles and assigned roles to users through Maintain 
Security. 
•	Worked with Production support team (24/7) during the Bi-weekly Payroll run process to fix any problems for the Paycalc process and nightly batch process. 
Environment	: PeopleSoft HRMS 8.3/7.5, People Tools 8.18/7.5, Oracle 8.1.7, AIX, 
Windows 2000/NT, SQR, COBOL, SQL, PL/SQL

Client		: Citi Corp, NY   		 	       		                June '02 – Mar’03
Project	: Implementation of PeopleSoft HRMS 8.3 
Role		: PeopleSoft Technical Consultant 
Responsibilities:
•	Responsible for the design, development and testing of all HR, Payroll and Time & Labor modules. 
•	Responsibilities included data conversion, implementation of all business practices and business logic, providing technical assistance to the implementation process. 
•	Involved in customization and implementation of PeopleSoft Payroll and Time & Labor module. 
•	Coded SQR reports for Ad Hoc, Weekly and Annual Leave Accruals according to the company procedure. 
•	Wrote People Code programs for online validations and for functional processing.
•	Created new SQRs by cloning the existing and modified them to generate the SQR’s. 
•	Designed and developed customized overtime calculation report for the employees with shift and more than 40-hour workweek calculation. 
•	Involved in design and development of conversion programs using SQR for transferring of data from legacy system to PeopleSoft HRMS. 
•	Involved in Data conversion, Data migration and Integration solutions using SQR and Data Mover.
•	Involved in customization of Pages and Menus using Application Designer.
Environment: PeopleSoft 8.3, People Tools, SQR 6.11, People Code, Oracle 8i, UNIX, Win NT

Project	: PF Trust Accounting System	             	    	    Mar ’01 – May ’02
Client		: KCP sugar & Industries Corp. Ltd.,
Role		: Oracle Developer 
Responsibilities:
•	Involved in designing, development, deployment and Implementation of the entire P.F.Trust module.
•	Creating Databases, Developing Forms, Coding and debugging forms, Developing Reports, Testing of Forms and Reports and Creating Pl/Sql Packages, Procedures, Functions, Views and Database Triggers. 
•	P.F. Trust: Employee PF masters creation, PF and Pension Data transferred from Payroll. Employee PF loan details are maintained. Loans Interest calculation, Ledger Processing, Settlements, and loan recoveries.
•	Accounting: Maintain cash/bank Payment/Receipt voucher, adjustment vouchers, Correction of authorized and posted vouchers, automated cheque preparation and restricted access for printing of cheques. Maintenance of accounts, monitoring of General Ledger.
•	Investments: Maintenance of Funds invests the funds into various Sectors and accrued Interest Calculation. Monitoring funds status Preparation of funds statement.
Environment	: Developer 2000 (Forms 6i, Reports 6i) Database:    Oracle 9i
	
Education:
 	Bachelor’s Degree in Computer Science Engineering .