SUMMARY OF QUALIFICATIONS:

• Over 15 years of experience in PeopleSoft HCM FSCM as Programmer/System Admin/DBA/Project Lead in various Industries.
• Performed several upgrades and implemented several projects on-time by leading and guiding the teams using appropriate tools and Project Management Methodologies.
• Excellent understanding of PeopleSoft SDLC, that include gathering business requirements, functional and technical designs, development, integration, testing, migration, documentation and deployment in large databases.
• In-depth working knowledge at different levels of management including C-level officers, internal customers at various levels, and variety of external vendors such as Banks, Insurance Companies, 401k, Benefits Service providers and government agencies.
• Extensive experience in data conversion from-and-to PeopleSoft AP/Expenses/HR/ Payroll/Benefits systems with legacy systems, ADP, Ceridian Workday.
• Highly experienced in the PeopleSoft system administration such as software installation, domain configuration, upgrades, patches, tax updates, bundles etc.
• Excellent verbal written communication skills, problem solving abilities and analytical skills. Excellent team worker and capable of working autonomously.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENECE:

Confidential

Consultant

• Working on PeopleSoft Financials Project to implement the Travel Expenses and Accounts Payable. The applications are highly custom in nature and the development effort is geared towards two separate implementations of each for different companies, 4 separate implementations in-all.
• As a technical lead in the Travel Expense module, I have created over 50 technical designs and documents that include several custom bolt-on applications.
• Responsible for design and development of several custom applications in both Accounts Payables and Travel Expenses modules using PeopleCode and Application Engine programs. Also, performed several customization s to delivered applications.
• Involved in AP vendor data conversion from Legacy system and responsible for complete conversion of Expenses data from EZPay system into PeopleSoft using SQR and Application Engine programs.
• Worked with a team of 6 developers on offshore/back office to coordinate the development of various applications/customization towards the implementation the project.
• Working with various internal and external vendors to integrate the new PeopleSoft applications for smooth flow data automatically.
• Integrated the Travel Expenses attachments framework with ECM Documentum for both PeopleSoft delivered applications as well as for Custom Bolt-on applications.
• Developed an interface process to Load the employee data from an external source into PeopleSoft using Application Engine program by utilizing Component Interface. This process includes an automatic creation of employee profile for Expenses purpose with minimum security granted for Employee Self-Service. This process also keeps track of surrogate information for approval process.
• Created a separate development database for Travel Expenses module and configured the Application Server, Webserver and Process Scheduler, and applied necessary Maintenance Packs.
• Involved in technical training and knowledge transfer to end user trainers and the IBM Cap Gemini production support teams.
• Also, working on integrating the Employee and Benefits information with Workday as the company is moving its HR systems from SAP.

Confidential

Consultant

• Successfully completed the project on time to implement the North American Payroll data conversion from ADP to PeopleSoft. Played a crucial role in data conversion of earnings, deductions, taxes and garnishments as well as YTD balances using Component Interface and SQR programs.
• Developed custom SQR and Application Engine programs using CI to load HR Benefits data from ADP for 6k employees.
• Developed several ACH, Pos. Pay and 401 k interfaces for US Canadian employees. Also, developed highly complex General Ledger interface programs to three different systems SAP, JDE and BAAN for 6 companies along with accruals process.
• Worked on integrating the PeopleSoft system with Workday. The company moved its HR system to Workday from PeopleSoft, and the Payroll remained in PeopleSoft as it has been heavily customized. The HR Benefits data was extracted from PeopleSoft for all employees to load into Workday system. The PeopleSoft was integrated with Workday using Integration Broker to receive the HR and Benefits data in through messaging.

Confidential

PeopleSoft System Lead

• Successfully lead and upgraded the PeopleSoft system from HRMS 8.9 to 9.1 along with Oracle database upgrade. The system is heavily customized, that includes several in-house custom projects, over 200 SQR programs, Application Engine programs, PeopleCode, Large number of Queries, SQL scripts, COBOLs and several vendor interfaces.
• Responsible for keeping system up-to-date by running SYSAUDIT, DDDAUDIT Alter Audit reports as and when required and take appropriate action to clean up the system.
• The Security has been created and administered using Permission Lists Rolls as well as highly customized version using PeopleCode within the system. Also, setup custom batch processing in Process Scheduler and implemented forgotten password functionality.
• Experienced in transitioning the PeopleSoft data to external systems as a part of business split/sale of the company. This task has been accomplished twice, once to ADP HR/Payroll and another time to Ceridian HR/Payroll/Benefits system. The data conversion was accomplished in two phases. Initially, the current data was extracted from the system and later, the historical information was transitioned.
• Successfully implemented the project to convert the data from ADP into PeopleSoft system for Sofitel and Novatel Hotels. The HR, Payroll and Benefits data has been mapped to PeopleSoft tables and loading has been accomplished using Application Engine and SQR programs.
• The Open Enrollments and Benefits projects have been implemented by working with several external vendors such as BCBS, UHC, Aetna, Walgreens, Fidelity, Milliman, Express Scripts, Delta Dental, VSP, Ceridian, P5, Cigna, Spectera and Kaiser Etc.
• Lead the team and successfully upgraded the PeopleSoft HRMS from version 8.3 to 8.9 along with database 9i to 10g, on-time. After analyzing the compare reports, the customizations have been successfully implemented in the new version along with upgrading over 150 custom SQRs, COBOLs, custom projects, PeopleCode and Queries.
• The entire Garnishments process has been automated by collecting the data from states' centralized database LMCO and loading into PeopleSoft after proper validation interfacing with Oracle Accounts Payable to produce the checks, and with Expert Pay system to electronically transfer the information for the mandated states'.
• Designed developed several Dashboards and Answers in OBIEE for Human Resource and quality departments. Also, built several XML/BI publisher reports within PeopleSoft system using Microsoft Word to create the templates.

Confidential

PeopleSoft Senior Programmer/Analyst

• Successfully developed the integrated Time Labor process in PeopleSoft system for payroll processing by collecting the time from various systems such as WinStar, Simplex Integretime systems. This process involves a complex time re-distribution of regular, overtime double time for employees who are employed in one location and working in multiple locations.
• Experienced in implementing several internal and external interfaces in HR, Benefits and Payroll by different techniques such as interfacing through database links, data import and export using SQR and Application Engine programs with variety layouts/formats such as fixed width, CSV and XML. The Payroll and Benefits related COBOL programs have been customized and supported.
• Responsible for successfully upgrading the PeopleSoft system from HRMS 7.5 client/server to internet based 8.3 version and simultaneously converting the data from Informix to Oracle database as well as HP UNIX to Sun Solaris.
• Successfully completed the project to integrate the PeopleSoft system with external vendors for annual Open Enrollment. The Benefits Administration has been extensively used for data flow between PeopleSoft and external vendors.
• Experienced in working with several banks and government agencies, and implemented ACH, Positive Pay, Reconciliation process, Garnishments interfaces between Payroll AP and external agencies.
• Supported PeopleSoft Financial Modules General Ledger, Accounts Payable Accounts Receivables for over 4 years. Involved in the data conversion from PeopleSoft Financials to Oracle Financial implementation.
• Implemented a project in the GL called 'Labor Cost Control' to support the chain of Red Roof Inns, Motel6 and Studio6 hotels to monitor the labor cost by gathering the business requirements from various sources. The labor cost was calculated at different levels such as Location, Area, Division and Company levels. The reports from this process are being used from location managers to CEO in the company.
• Responsible for developing several Interfaces and data conversion from Legacy System WANG to PeopleSoft HRMS as a part of Accor/Motel6 upgrade.

Confidential

PeopleSoft Programmer Analyst IV

• As a member of development team, involved in the project management and planning efforts for PeopleSoft application upgrade from version 6.x to 7.5. The heavily customized system has been successfully upgraded to PeopleSoft version 7.5.
• Responsible for applying all the Tax Updates, system patches and production moves.
• Designed and developed custom projects for Bonus eligibility process, highly complex custom compensation module with combination of quartile review ratings.
• Successfully converted/validated over 200 custom SQR programs for Y2K compliance.
• Designed and developed several interface programs from PeopleSoft to Main Frame system and external Benefits and Payroll vendors.