SUMMARY:
15 years IT experience including over 13 years of PeopleSoft implementation, production support and System Administration experience. This has been gained through full life cycle hands-on implementation, System Administration, customizing, testing and maintaining of PeopleSoft HCM Systems. Have been on the System Administration and development team for a variety of PeopleSoft HCM implementations and upgrades. Have been the lead system administrator and developer for multiple on-line/batch customizations of PeopleSoft applications as well as conversions, interfaces and reports. Have worked closely with both technical and functional members of a team and am able to interact well with both. Strong Team Player with strong communication skills and the ability to independently solve problems.

Skills: Software/Tools/Languages:

PeopleSoft 9.0/8.9/8.8 HCM, Peoplesoft 8.3/7.5 HCM, People Tools 8.49/8.48/8.47/8.44, HR, Payroll, Payroll Interface, Position Management, Benefits, Benefits Administration, Pension, Time & Labor, ESS Employee Self Service, MSS Manager Self Service, eBenefits, ePay, eRecruit, 9.0 Financials AP, AR, GL, IN, PO, Security, Tree manager, Application Designer, Application Engine, People Code, Component interface, Integration Broker, Process Monitor, Tree Manager , Workflow, nVision, Upgrade Assistant, Change Assistant, Process Scheduler, Data mover, SQR/SQL, QUEST STAT, Crystal Reports, PS Query, People code Debugger, AQT, TOAD, DB2,COBOL,JCL, Mainframe

Education:

Master of Science

Bachelor of Science

EXPERIENCE:

Confidential,NEW YORK (Aug’09 to Current)
Lead HCM/Financials Peoplesoft Techno functional Developer

HCM Upgrade from 9.0 to 9.1, 8.8 to 9.0, Financials upgrade from 8.8 to 9.0 and Production Support

• Currently involved in upgrading Peoplesoft HCM system from 9.0 to 9.1
• Responsible for new enhancements and production support activities in 9.0 HCM and 9.0 Financials system.
• Involved in all upgrade activities in upgrading Peoplesoft HCM (HR, Payroll, Benefits, Benefits Administration, ESS, MSS, E-Recruiting) system from 9.0 to 9.1. Upgrade activities were performed using Change Assistant.
• Responsible for applying tax updates, patches, fixes, bundles, year end updates to both HR and Financials system.
• Responsible for PS Project migrations, and working with PeopleSoft on issue resolutions
• Involved in developing the outbound benefits interface to Tricerion and inbound interface in enrolling the employees into Peoplesoft benefits system from Tricerion
• Involved in developing personal data, GL data interfaces from HR to Financials using Integration broker messaging technology.
• Involved in creating several PS queries in HR and Financials and nVision reports for GL reporting.
• Developed inbound interfaces to load the Pay rate increase, bonus payouts data into HR system system using Component Interface, Application engine.
• Developed application engine programs to load data from HR and financials systems to Oracel BI dataware house systems.
• Troubleshoot any problems that might arise in the payroll calc/confirm process, pay sheets update for employees time and salary information, salary increments etc.,
• Modified HR/Payroll systems SQR reports per user requirements
• Involved in database tuning to improve run time performance.
• Developed the process to auto load Voucher Invoices into Financials system from an external vendor GHX using Integration broker, Application engine.
• Involved in developing the approval workflow process for Requisitions, Purchase orders, Vouchers, General ledger entries
• Developed nVision reports GL year end, month end Income statement, balance statement, Profit and loss statements etc.
• Developed several integration broker messages between HR and Financials to exchange data,
• Environment: PeopleSoft 9.1/9.0/ 8.8 HCM, People Tools 8.49/8.47,HR, Payroll, Benefits, Benefits Administration, eRecruit, eBenefits, Manager Self Services MSS, Emloyee Self Service ESS, Security, eBenefits, ePay, eRecruit, 9.0 Financials, AP, AR, GL, PO, IN, SQR/SQL, PS Query, QUEST STAT, Application Designer, Component interface, Application Engine, PeopleTools, People Code, Workflow , Integration Broker, Messaging, Tree Manager , crystal reports, nVision , Web services, Process Scheduler, Process Monitor, Unix shell scripts, Oracle 10g, SQR, SQL, DB2, COBOL, JCL, Mainframe

Confidential, ramsey, nj (March’06 to July’09)
Lead HCM Peoplesoft Techno functional Developer

HCM Upgrade from 8.8 to 9.0 and Production Support

• Involved in all upgrade activities in upgrading Peoplesoft HCM (HR, Payroll, Benefits, Benefits Administration, ESS, MSS, Recruiting) system from 8.8 to 9.0. Upgrade activities were performed using Change Assistant.
• Performed analysis and redesign of the Group 1,2,3,4,5,7,8 conversion processes for 9.0 upgrade due to performance issues.
• Involved in tuning and redesigning several SQL scripts for 9.0 upgrade process due to performance issues.
• Create functional design and technical design specifications to upgrade custom processes from 8.8 to 9.0 New hire, rehire and Mass hire process is a heavily customized process.
• Re-designed and developed New hire, Rehire, mass hire online process. Existing 8.8 process had to be totally redesigned because of 9.0 Person model changes
• Designed and Developed SQR, App Engine/Component Interface process to load employee training, job data into Peoplesoft HCM database.
• Responsible for security design and migration from 8.8 to 9.0 due to security architecture changes.
• Liaison with Peoplesoft for several critical issues during the Upgrade and production support.
• Analyze and retrofit customizations, test during version upgrades, tax updates, patches, fixes and bundles.
• Developed App Engine/Component Interface process to load Department changes, employee status changes from an external application to Peoplesoft HCM database.
• Retrofitted sqr and online modules to 9.0 record and table design structures.
• Developed several crystal reports to present the HR, Payroll, Benefits information in a more user friendly graphical interface screens.
• Served as Lead developer for HR, Benefits, Benefits Admin, Payroll, Recruiting, Self Service system.
• Designed and Developed SQRs to create medical extract interface files to Aetna, CIGNA,BCBS etc.
• Solely responsible for installation, configuration, implementation for Peoplesoft HCM 9.0 version and for Upgrade process from 8.8 to 9.0
• Redesign and retrofit customizations into HCM 9.0 people code and batch components
• Configure and maintain Integration broker gateway, IB nodes, messages, message channels, transactions, publication (pub) and subscriptions (sub) servers for 9.0 HCM system
• Created Web services, WSDLs to exchange HR data with several external systems using Integration Broker technology.
• Configure and create SOAPTOCI Integration Broker messages to exchange Peoplesoft HCM data with external systems in real time mode.
• Create and Publish Integration Broker messages for Job data, personal data, new hire, Rehire, Promotion etc functionalities.
• Tuned the application engine programs, data mover and SQL scripts to improve Data conversion performance for 9.0 Upgrade.
• Monitor Integration Broker gateway activities for any message subscription/publication errors and resolve the issues.
• Analyze the tax updates, fixes and bundles release notes and estimate its impact to the Payroll system.
• Apply tax updates 08 A,B,C,D and E using Change Assistant to DEMO, development and Production databases.
• Migrate code (projects) between Development, test and Production databases. Run compare reports and analyze the changes thoroughly before production migration.
• Installed People tools 8.49 tools version software on file server (Windows 2003), app server (Unix), web server PIA (Unix) and process scheduler/batch servers (Unix).
• Applied Peopletools patch versions 8.49.07, 8.49.08, 8.49.09 on file server (Windows 2003), app server (Unix), web server PIA (Unix) and process scheduler/batch servers (Unix).
• Install and configure BEA WebLogic and Tuxedo software on app and web servers.
• Install Peoplesoft HRCS 9.0 software on app, web, batch and file servers.
• Install, create and configure Peoplesoft 9.0 HRCS DEMO database using Peoplesoft Installer and also using manual step process.
• Upgraded Peopletools version from 8.47 to 8.49 as part of 9.0 HRCS database creation process.
• Create, configure and maintain app server, web server PIA and process scheduler server domains for 9.0 HRCS DEMO database.
• Resolved several issues with Oracle 10g Unicode data format by coordinating with Peoplesoft.
• Uploaded DEMO database to Peoplesoft Customer connection.
• Install and configure Change assistant tool to apply Bundles 1,2,3,4,5,6,7 for Peoplesoft 9.0 DEMO database.
• Configure Change Assistant tool to automatically detect current updates/fixes/bundles status and download required updates/fixes/bundles to install.
• Configure Environment Management Hub (EVMHUB) and Environment ManagementAgents on app server, batch server and file servers to apply Updates/ Fixes/ Bundles.
• Configure Change Assistant tool to perform Peoplesoft HCM version upgrade from 8.8 to 9.0
• Configure change assistant upgrade job for 9.0 upgrade by using the delivered Peoplesoft template.
• Perofmed all Upgrade system admin activities requires for 9.0 Upgrade process.
• Executed all the steps involved in the 9.0 upgrade change assistant job and successfully upgraded HCM version from 8.8 to 9.0
• Configured the Change Assistant to automatically execute the complex processes ( like data conversion for Groups 1, 2, 3,4,5,6,8,9) on the server instead of the client, to improve performance and shorten the Upgrade execution time.
• Create and configure app server, web server PIA and process scheduler server domains for 9.0 HRCS databases during Initial Pass, Test move to production and final production move.
• Assisted the Oracle DBA in cloning production database for Initial pass, Test moves and final production upgrade execution.
• Used QUEST STAT change management tool to migrate the Peoplesoft objects from Development to System test, then to Production environments.
• Developed Unix shell scripts to schedule the execution of payroll sqr and application engine programs on Unix server.

HCM Upgrade from 8.0 to 8.8 and Production Support

• Involved in all upgrade activities in upgrading Peoplesoft HCM (HR, Payroll and Benefits) system from 8.0 to 8.8SP1. Upgrade activities were performed using Upgrade Assistant.
• Developed Integration broker messaging capability to integrate UPS GEMS system with UPS Freight application. HR/Payroll data entry performed on UPS GEMS system automatically gets loaded into UPS Freight system for job data updates, New hire, Terminations, Rehire, Foundation table updates etc
• Integration of two Peoplesoft HCM systems using Integration Broker, Messaging, Web services
• Set up Integration broker gateways, nodes, messages, message channels, transactions, SOAPTOCI web services for Peoplesoft HCM 8.8 version
• Production Support and apply 8.8 maintenance packs 1-6 using Change Assistant
• Developed several complex Component interfaces and people code to load additional earnings data on pay sheets, job data for pay increases, training data from external systems etc.
• Migrate the code between Development, UAT and Production regions for 8.8 Upgrade and post upgrade implementations
• Apply tax updates 07A, B, C, D, E and F to DEMO, Development, UAT and Production databases.
• Involved in all upgrade activities in upgrading Peoplesoft HCM (HR, Payroll and Benefits) system from 8.0 to 8.8SP1. Upgrade activities were performed using Upgrade Assistant.
• Involved in production support and maintenance of UPS HCM system. Apply tax updates, patches, fixes and Peoplesoft maintenance packs 1,2,3,4,5,6. Resolve issues as and when they arise
• Executed scripts, application engine programs, sqrs etc in upgrading Peoplesoft HCM system from 8.0 to 8.8
• Involved in developing integration broker code to transfer HR data in real time mode from UPS GEMS system to Overnite system.
• Involved in developing a component interface to update employee Job data received from external system.
• Involved in developing a process to hire employees on a large scale (mass hire process).
• Applied Peopleosft maintenance packs 1,2,3,4,5,6 to HCM 8.8SP1 system.
• Developed application engine programs to load annual merit increases, promotion/demotion data into Peoplesoft.
• Set up and configure workflow rules for Workflow Administration New Hire, Rehire processes.
• Created and executed Test Plans (System, Integration, and End-User Acceptance tests).
• Performed Unit, System and Integration testing
• Interacted with Client functional & technical resources.
• Worked on People Tools, People Code & SQR for customization & enhancements.
• Led a role as a primary technical resource on HR, Benefits & Payroll Modules.
• Installed People tools 8.45 tools version software on file server (Windows 2003), app server (Unix), web server PIA (Unix) and process scheduler/batch servers (Unix).
• Install and configure BEA WebLogic and Tuxedo software on app and web servers.
• Install, create and configure Peoplesoft 8.8 HCM SP1 DEMO database using Peoplesoft Installer.
• Create, configure and maintain app server, web server PIA and process scheduler server domains for 8.8 HCM DEMO database.
• Peoplesoft HCM Upgrade to 8.8 from 8.0 using Upgrade Assistant.
• Install and configure Upgrade assistant tool to perform HCM version upgrade from 8.0 to 8.8.
• Install and configure Change Assistant tool to apply updates, fixes, tax updates and Bundles to 8.8 HCM system
• Install, configure and execute change assistant job to perform Peopletools upgrade from 8.43 to 8.47
• Create, configure and maintain new app server, web server PIA and process scheduler/batch server domains during 8.8 upgrade and 8.47 tools upgrade process.

Environment: PeopleSoft 9.0/ 8.8 HCM, People Tools 8.49/8.47,HR, Payroll, Benefits, Benefits Administration, eRecruit, eBenefits, Manager Self Services MSS, Emloyee Self Service ESS, Security, eBenefits, ePay, eRecruit, SQR/SQL, PS Query, QUEST STAT, Application Designer, Component interface, Application Engine, PeopleTools, People Code, Workflow , Integration Broker, Messaging, Tree Manager , crystal reports, nVision , Web services, Process Scheduler, Process Monitor, Unix shell scripts, Oracle 10g, SQR, SQL, DB2, COBOL, JCL, Mainframe

Confidential, (Dec. 05 to Mar’06)
Peoplesoft HCM Techno functional developer
Implementation of Peoplsoft HR, Payroll, Benefits system from DB2, COBOL,JCL mainframe based platform to Unix, Oracle based platform.
As a Techno functional Consultant,

• Identified the current business processes including online processing, reporting and interfaces.
• Converted custom interfaces and reports written in Cobol, JCL to SQR
• Understood existing JCL, Cobol modules to convert them into Peoplecode/SQR/Shell script.
• Created and executed Test Plans (System, Integration, and End-User Acceptance tests).
• Performed Unit, System and Integration testing
• Worked on People Tools, People Code & SQR for customization & enhancements.
• Developed Crystal reports for Business users to enter HR Forms job data.

Environment: PC/LAN, UNIX, IBM mainframe, Tools: PeopleSoft 8.3 HCM, People Tools 8.0,HR, Payroll, Benefits, Security, eBenefits, ePay, eRecruit, SQR/SQL, PS Query, Application Designer, Component interface, Application Engine, PeopleTools, People Code, Process Scheduler, Process Monitor, Crystal Reports , Unix, Oracle 9i, DB2, COBOL, JCL, Mainframe

Confidential, (Oct. 05 – Dec. 05)
Upgrade of Peoplesoft HCM system from 7.5 to 8.9
Information Technology
Peoplesoft HCM Techno functional developer
Upgraded from 7.5 ver to 8.9 of PeopleSoft utilizing the modules HR, Base Benefits, Ben Admin & Payroll Interface.
As a Techno functional Consultant,

• Identified the current business processes including online processing, reporting and interfaces.
• Reviewed the new release functionality and comparing it with current functionality to identify possible conflicts and impacts.
• Completed Technical Fit Gap Analysis according to PeopleSoft guidelines.
• Modified SQRs for Base Benefits, Benefits Administration modules to reflect new 8.9 table structures.
• Documented the new customizations and developments to the system.
• Created and executed Test Plans (System, Integration, and End-User Acceptance tests).
• Performed Unit, System and Integration testing.
• Interacted with Client functional & technical resources.
• Executed payroll interface application engine programs to process payroll
• Customized Dec_calc process to perform custom benefit plans.
• Worked on People Tools, People Code & SQR for customization & enhancements for HR, Benefits and Payroll Interface.
• Developed new SQR’s and customizing existing SQR’s as required.
• Developer several crystal reports to create HR, Payroll data reports for Business users
• Developed new portal entries, menu paths,, Component interface etc

. Environment: PeopleSoft 8.9 HCM, People Tools 8.47,HR, Payroll Interface, Benefits, Benfits Administration, Security, eBenefits, ePay, eRecruit, SQR/SQL, PS Query, Application Designer, Component interface, Application Engine, PeopleTools, People Code, Process Scheduler, Process Monitor, Crystal Reports , Unix, Oracle 9

Confidential,(Feb. 05 – Sep. 05)
Implementation of Peoplesoft HCM system
Information Technology
Peoplesoft HCM Techno functional developer
Migration Project from ADP Legacy Systems to PeopleSoft implementing HR, Base Benefits & Payroll. It is a Full life cycle Implementation.

• One of 4 developers to participate in a full life cycle implementation of PeopleSoft HCM/Payroll system for Canada population. The implementation was highly customized. Wrote functional/technical specifications, designed and developed on-line (pages, records, People Code, components, security) customizations. Developed conversion programs in SQR, component interface to convert ADP HR,Payroll and Benefits data into Peoplesoft. Developed interface data extracts in SQRs and PS-Query reports. Worked very closely with functional team members to resolve issues - both technical and functional. In preparation for testing, it was my responsibility to migrate changes from the development environment to the testing environment.

Environment: PeopleSoft 8.8 HCM, People Tools 8.44, HR, Payroll, Benefits, Security, eBenefits, ePay, eRecruit, SQR/SQL, PS Query, Application Designer, Component interface, Application Engine, PeopleTools, People Code, Process Scheduler, Process Monitor, Unix, Oracle 9

Confidential,(May 02 – Jan. 05)
Support of Peoplesoft HCM system
Information Technology
Peoplesoft HCM Techno functional developer
Production support of Peoplesoft HCM system. Modules worked on are HR, Payroll, Base Benefits, Benefit Administration, Security and Pension Administration.
As a Techno functional analyst,

• Involved in full life cycle implementation of Peoplesoft HCM system
• Involved in enhancement/maintenance and production support of the Peoplesoft modules in HR, Payroll, Benefits and Pension Systems, which includes off hours support.
• Performed tax updates/patches and fixes/bundles when Peoplesoft delivers new releases, which includes monitoring PS Customer Connection for PS Tools Updates, Maintenance Packs, and Tax Updates.
• Solely responsible for generating W2s, 1099Rs in the year end process.
• Designed and developed adhoc fixes to correct various Payroll issues
• Responsible for PS Project migrations, and working with PeopleSoft on issue resolutions Involved in creating/modifying a process to accommodate arrears process.
• Responsible for ongoing HCM system maintenance.
• Developed a new peoplesoft interface to incorporate a Bank change for ACH direct deposit files from Bank One to Chase Manhattan Bank
• Involved in developing/modifying a process to pay out bonus/executive compensations.
• Troubleshoot any problems that might arise in the payroll calc/confirm process, pay sheets update for employees time and salary information, salary increments etc.,
• Responsible for creating a process to insert new job data rows for annual contract wage increase for hourly/union employees
• Developed a SQR extract for retiree medical benefits
• Involved in Open Enrollment/Ben Admin process.
• Modified HR/Payroll systems SQR reports per user requirements
• Involved in database tuning to improve run time performance.
• Developed a process upload general deduction information for united way
• Immensely Involved in Implementation of complex interface programs to move data from the legacy system to the PeopleSoft using SQR as primary tool.
• Used PeopleTools like Data Mover, Import Manager, and PS-Query to load the data from test database to production database and to develop queries for Business users to validate data.
• Developed a weekly interface for Whirlpool Retiree Benefits to the providers using SQR. Assisted the business in setting up the online retiree process using PeopleTools and People Code. Customized and developed People Code to define the client business rules for the retire process. Created the reports using Crystal reports and SQR as per business needs.

Environment: PeopleSoft 8.8/8.3 HR, People Tools 8.44, Payroll, Benefits, Pension, Security, e-Recruit, e-Performance , FLS, SQR/SQL, PS Query, Application Designer, Component interface, Application Engine, PeopleTools, People Code, Process Scheduler, Process Monitor, DB2, COBOL, JCL, Mainframe