PROFESSIONAL SUMMARY

• Strong PeopleSoft Techno Functional consultant with 11+ years of Extensive experience in PeopleSoft ERP Applications.
• Worked very closely with Business users in capturing requirements and creating Functional Design documents (BRD & FRD) and designing Technical Documents based on FRD.
• Hands on with various HCM modules: Administrator workforce, NA Payroll, Benefits, Time & Labor and Self Service (ESS & MSS).
• Strong Expertise in People tools such as Application Designer, Application Engine, Component Interfaces, PeopleCode, HTML, XML Publisher, Process Scheduler, DMS. Working knowledge of Integration Broker, Application Messaging and Pagelet development using PeopleSoft portal.
• Thorough knowledge and hands-on experience using reporting tools, extensively used in PeopleSoft like SQR, Crystal Reports and Query tools like PS/Query.
• Utilize Functional expertise to lead fit-gap sessions with primary stakeholders to setup and configure the system.
• Strong Expertise in documenting the As-Is Process and performing Complete Fit-Gap Analysis.
• Expertise in analyzing complex business process of various enterprise and design solutions in PeopleSoft.
• Worked closely with Developers, IT and UAT Testers to make sure work is progressing as expected.
• Documented all new changes in requirements and maintained up-to-date specifications for developers and testers.
• Have good exposure to Software quality processes and PeopleSoft Standards.
• Worked on various projects that include PeopleSoft Upgrade, Implementation, Development and Application Maintenance.
• Experienced in all testing types: Regression, Smoke, System integration, Data conversion testing.
• Experienced in writing the test plans, cases and scripts based on system specifications and expertise in regression system integration functional and performance testing.
• Expertise in PeopleSoft new person model and HRMS applications HR, Payroll, Benefits, Ben-Admin, Time and Labor, TAM, Candidate Gateway, Self Service Modules and ETA.
• Strong exposure in the development of Core HR, North American Payroll Process, Pay Calendar Creations,, Payroll Interfaces, Tax Audit Reports, Base Benefits, Benefits Administration, Time and Labor, TAM, Candidate Gateway, eBenefits, Manager /Employee Self Service, Benefits Processing, Vendor Integration and Leave Accrual Process.
• Worked on development and modification of Interfaces and data conversion from Legacy systems to PeopleSoft records by performing numerous validations using SQRs and Application Engine.
• Experienced in Batch Processes scheduling, Customization, Conversion and Migration.
• Possess sound experience in RDBMS concepts, good in SQL and PL/SQL programming and has been working on Oracle and SQL server platform.
• Worked on RICE Objects for generating reports, vendor Interfaces, Conversions and Client enhancements as needed.
• Highly organized, dedicated with positive attitude, self motivated and committed in individual and in team work.
• Possess good communication, analytical reasoning, logical and problem solving skills.

EDUCATION

• Master of Computer Applications, MCA

Technical Skills / Tools

PeopleSoft :Versions 9.1/9.0/8.9/8.8/8.3/8.0 (HR, Benefits, Ben Admin, Payroll, Time & Labor,
TAM, Candidate Gateway, ePerformance, eBenefits, eRecruit, eCompensation)
PeopleTools :Application Designer, Application Engine, PeopleCode Debugger, Import Manager,
Security Administrator, Object Security, Workflow, Application Messaging, PS/Query,
Process Scheduler, Process Monitor, Component Interface, Maintain Security,
Integration Broker, Upgrade Assistant.
Languages :PeopleCode, SQL, PL/SQL, C, C++, COBOL, HTML, XML, Java.
Reporting :SQR, XML publisher, PS Query, and Crystal Reports
RDBMS :Oracle 11g/9i/8i/7.x, MS Access.
OS :WINDOWS XP/2000/NT/98, UNIX/AIX 5.3.

PROFESSIONAL EXPERIENCE

Confidential, FL May 2012 – Till Date
PeopleSoft HCM Techno Functional Consultant, Upgrade from 8.9 to 9.1
Responsibilities

• PeopleSoft HCM 8.9 to 9.1 upgrade (HR, NA Payroll & Benefits, eModules).
• Working on retrofitting various objects like App Engines, CIs and Views in 9.1 which are brought over to 9.1 and analyzing whether the custom functionality needed for 9.1 or not.
• Working on Integration between new hire interface between PeopleSoft and third party applications using Integration Broker.
• Working on App Engine/CI’s for Ben Admin, to load the JOB DATA for all the active employees to change their Benefit system to BA from BN. And also, working on Part time Hawaii employees to check their eligibility for Ben Admin to load Elig config2 field on JOB based on their TL payable time, also for Elig Field1 for Manager Level changes and Elig Field3 for Expat.
• Functional and Technical Analyst for the eProfile, eCompensation and ePerformance (Employee Self-service and Manager Self-Service) module, assisting client on Manager Dashboard setup and Org Chart viewer setup. Also, working on the AWE configuration setup for workflow transactions.
• Actively participated in the Requirements gathering Design sessions.

Environment
PeopleSoft HCM 9.1, PeopleTools 8.52, UNIX/AIX, Oracle 11.1g, SQR

Confidential, Pittsburgh, PA Jan 2011 – Mar 2012
PeopleSoft HCM Technical Consultant, Support & Development
Responsibilities

• Primary responsibilities including Supporting HCM, Portal and CRM applications and working on projects which includes gathering functional requirements by meeting with users and other parts of IS groups and coordinating with the development team to get the development tasks done in a timely manner.
• Prepared gap analysis and business requirements documents and developed functional design documents.
• Prepared and executed test scripts and sign off on changes to production environment.
• Prepared and delivered training materials used by both SIT and UAT testers during and post implementation.
• Worked closely with creating pay calendars, creating Pay Sheets and running through the final payroll process
• I have run North America payroll while testing Tax Updates to ensure the integration of the system with the new delivered patches and bundles.
• Configured and Setup Integration between FIN and HCM to auto update FIN Expenses table with HCM tables.
• Setup Integration between Portal and Peoplesoft HCM, Financials and CRM.
• Setup and Configured Integration Broker and trusted nodes for Peoplesoft single sign on
• Involved in the System Integration and Parallel testing of Time Tracking system Interfaces to PeopleSoft like Kronos and SmartTrack systems and Vise versa.
• Performed Hire, Rehire, Transfers, Retire, Terminate and data change events in PeopleSoft and tested the work flow process for provisioning and access control changes to the down stream systems.
• Gathered requirements and created Functional DD for new payroll interface between Kronos and PeopleSoft NA Payroll system to load hours for fulltime and part time employees based on the DeptID, Jobcode, Acct Code and earning codes provided on the file.
• Developed interfaces for new 401K vendor “Principal Financial Group” which are Demographic Data, Beneficiary Data and Loan amount Interfaces.
• Create a custom recruitment report using XML pub that Hiring Managers can run with the following user specified parameters: Job opening number, Highest degree, Language, Certification.
• Worked on PS admin tasks which include Start and stop app server and web server and clearing the cache when needed by the users and working on TAX updates with business in order to test and apply them in Prod in a timely manner.
• Worked on Employee Team Bonus program to load in to pay lines which loads into pay lines based on the Department Employee worked for the last quarter he/she worked on and reads the bonus percentages from the custom table at the department level.
• Worked on few conversion programs by utilizing Excel to CI utility for Company Local Tax Table and General deduction table and Additional Pay data tables.
• Worked on eBenefits and ESS module, which includes Open enrollment and customizing RELATIONSHIP (Deceased) values to control the beneficiary information on employee benefits summary when updating their Spouse to Ex-spouse etc … and developed ACT 32 Employee form for collecting their address and deduct local taxes based on their address and zip code.
• Worked on N/A payroll TAX updates on the Functional side to check any impact on the custom developed processes and occasionally download the tax updates using change assistant to demo DB.
• Worked on Payroll Year End tasks to assist users to load W2 data using delivered processes like Tax form definition table and Parameters and TAX960LD/US/LC.
• Ability to perform multiple tasks and adjust priorities based on workload or direction from management or clients and managing off shore team of 2 developers and PS Admin to distribute the work and give directions to work on the assigned tasks to deliver in a timely manner.
• Conducting Unit, System and Integration testing and adhere to predefined quality assurance standards.
• Strong analytical skills in troubleshooting issues as part of a team providing 24x7 production support.

Environment
PeopleSoft HCM, Portal and CRM 9.0, PeopleTools 8.50, UNIX/AIX 5.3, Oracle 11.1g, SQR, STAT, Autosys, Mobius.

Confidential, Boston, MA Jul 2010 – Dec 2010
Senior PeopleSoft HCM Technical Consultant, Reimplementation/Upgrade 8.9 to 9.1
Responsibilities

• Developed project functional requirements by meeting with users and other IS personnel.
• Gather Data conversion/ Consolidation requirements for foundation and employee data tables and build the code for all the setup tables and Transactional tables for new 9.1 environments.
• Gather data conversion requirements for any key functionality that should be migrated to 9.1 as a part of upgrade.
• Analyze, design, build, test, document, and implement reports and interfaces/conversion programs.
• Developed integration between 8.9 and 9.1 environments for few personal data records and setup tables.
• Strong analytical skills and a clear understanding of ERP, HR Systems, and business concepts.
• Utilize hands-on creation and management of new applications using PeopleTools, Crystal Reports, SQR, Application Engine, Component Interface, and Integration Broker.
• Translating business requirements and functional designs into a technical design documents. Extensively worked on Ad hoc queries requests either through PS Query or TOAD.
• Ability to perform multiple tasks and adjust priorities based on workload or direction from management or clients
• Conducting Unit, System and Integration testing and adhere to predefined quality assurance standards.
• Maintaining consistent delivery of PeopleSoft and other supported applications throughout the product suite by adherence to rigorous code development standards and the architecture framework, and by following the requirements of the project management methodology for project participation (providing timely, regular updates, etc.).

Environment
PeopleSoft HCM 9.1/9.0/8.9, PeopleTools 8.50/8.49, Linux, Oracle 11.1g, SQR.

Confidential, Phoenix, AZ Oct 2007 – Jun 2010
Senior PeopleSoft HCM Technical Consultant, Support & Development
Responsibilities

• Developed a comprehensive understanding of the core functionality offered in HR, N/A payroll and Benefits modules of PeopleSoft 8.9, including the PeopleSoft integration with Virtual Edge for Recruiting, PS Time & Labor for Time and Attendance and Focus for ESS and MSS applications.
• Trouble shooting HR and Payroll issues as part of daily production support and supporting N/A payroll for Semi-Monthly, Bi-Weekly and LTIP payrolls in order to confirm the checks in the timely manner.
• Worked closely with vendors related to file transmission issues and proactively working closely with other application team members to resolve any integration issues in timely manner.
• Conducts analyses and research on a variety of issues related to the PeopleSoft payroll and time and labor applications, communicates results.
• Worked on RICE Objects for generating reports, vendor Interfaces, Conversions and Client enhancements as needed.
• Redesigned most of the Time and Labor rules and written most complex rules to stabilize the environment and tested all the rules by compiling and running the time and Admin process.
• Responsible for managing open case activity to ensure timely closure and trends.
• Worked with business and system analyst(s) in defining the business requirements, determining scope, estimating the effort, and determining duration.
• Experience in setting up new benefits plans and reconfigure existing system.
• Integration experience with external Benefits Providers, handling Open Enrollments and setting up and maintenance for Savings Plans within PeopleSoft application.
• Translating business requirements into functional designs and into a technical design documents. Extensively worked on Ad hoc queries requests either through PS Query or TOAD and created reports using XML publisher for eCompensation Manger desktop like Budget and Status Report, and Manager Details Employee Data etc
• Configured Payroll to General Ledger interface, using Integration Broker, based on industry best practice
• Coordinate with users and the other IT teams to process payrolls and resolving any issues to confirm the payroll in a timely manner to send/receive the interfaces to/from the external vendors.
• Gathered requirements for custom interface was developed for Time & Attendance and Payroll deductions.
• Executes the most complex research and completion of client, participant and employee requests and to create complex reports as per the client/Internal request.
• Worked on Garnishment and Vendor table Interfaces, GFS Accounts Payable Department requires a file containing the Garnishment Vendor, Voucher and Distribution Line information for Chubb Employees on a Semi-Monthly basis. The file is used by the Accounts Payable Department to print and distribute the Garnishment Checks to vendors.
• Extensive experience in testing of NA payroll issues while running pay calc and confirm payroll, ability to diagnose an issue, and execute driving towards a resolution and fixing issues on time to meet clients SLA.
• Maintained and Modified ADP interfaces Quarterly (PBZQTR.sqr) which runs every quarterly and Periodic extract (PBZPER.sqr) which runs after every pay confirm based on Run ID to send tax related information.
• Conducting Unit, System and Integration testing and adhere to predefined quality assurance standards.
• Maintaining consistent delivery of PeopleSoft and other supported applications throughout the product suite by adherence to rigorous code development standards and the architecture framework, and by following the requirements of the project management methodology for project participation (providing timely, regular updates, etc.).
• Strong analytical skills in troubleshooting issues as part of a team providing 24x7 production support.
• Develop and coordinate application enhancements and bug fixes with offshore developers and testing resources.

Environment
PeopleSoft HCM 9.1/9.0/8.9, PeopleTools 8.48/850, UNIX, Oracle 9X, SQR, XML Publisher.

Confidential, Irvine, CA Feb 2007 – Aug 2007
PeopleSoft Analyst, Development
Responsibilities

• Serving as Peoplesoft HCM 8.9 on HR, N/A Payroll, Benefits and Ben admin.
• Analysis and design of Global Leave Accrual Process, involving into setup the leave plans, event rules, and eligibility rules and link it to a specific benefit program. Designing and testing custom Vacation and Sick Leave Accrual programs to accrue current and future leave balances based on fiscal year hours worked, service/seniority dates and union rules.
• Worked on field mapping of legacy data with the corresponding PeopleSoft benefits and payroll data and prepared test cases for the interfaces.
• Analysis and Design of the Functional specification, Preparation of Technical Specifications, Design and Development, Testing and issue resolution of PeopleSoft Interfaces and Enhancements objects.
• Designed and Developed functional, Technical specification, build code and prepared test cases for Grant Summary Data Interface for processing of RSU Awards and Option Grant data into PeopleSoft HCM.
• Involved in the development outbound applications (SQR reports) based on the specifications like Grant details, Issued share capital
• Designed and Developed UNUM Life Consolidated Interface functional and Technical specification, build code, which is reporting of eligibility and enrollment information, is being manually reported to UNUM.
• Designed and Developed COBRA Outbound Interface which is sending a Current COBRA eligible Employee personal, Spouse and Dependent information for the Medical and FSA plans to the Vendor.
• Design and Development of Functional, Technical Specification and prepared test cases for Fidelity Outbound Interface which is sending an employee personal and employment data and 401k and Roth benefit plans data to the vendor using Application Engine which is used Benefits Snap tables.

Environment
PeopleSoft HCM 8.9, PeopleTools 8.48, Windows XP, SQL Server 8.00, SQR.

Confidential, Westwood, MA Jul 2006 – Feb 2007
PeopleSoft Analyst, Development
Responsibilities

• Worked on HRMS v8.9 person model on HR, North American Payroll, Benefits and Talent Acquisition as part of production support.
• Worked on weekly payroll system to run for the NSTAR 369Gas employees and resolving issues on the payroll system.
• Worked on Conversions and Interfaces like loading the educational data and e-mail addresses into PeopleSoft and Sending personal and benefits data to the vendor.
• Created Manager Self-Service pages to create/hire an External Applicant profile into Recruiting system.
• Worked on eRecruit Applicant & Job Index processes and related Application packages to apply HRMS v8.3 customizations.
• Involved in Fine Tuning the SQLs, which are used in Data Conversion Application Engine Programs to increase the performance.
• Documented the specifications on regular basis for every change required and implemented.
• Interfaced PS/Query with Crystal Reports for Ad-hoc reports.
• Interpreted Functional Documentation to Technical Documentation.

Environment
PeopleSoft HRMS 8.9, People Tools 8.46/8.44, Peoplecode, Application Engine, Workflow, Component Interfaces, SQR, Windows XP, oracle 9i.

Confidential, Chicago, IL May 2005 – Jun 2006
PeopleSoft Analyst, Implementation
Responsibilities

• Prepared the General Design Documents and Detail Design documents for the new custom processes and reports and worked on Position management system.
• Work involved analysis of functional specification and preparing technical specifications based on the given functional specification.
• Used Application Engine, Peoplecode and SQR extensively to create processes, outbound files and reports. Developed outbound files like Employee, Benefits etc using SQR.
• Designed and Developed Prudential Outbound Payroll Interface, to transmit deductions taken for elected employee-paid life insurance for full-time benefit eligible employees to Prudential.
• Customized the existing interface programs for the HR to send flat files to various vendors for employees enrolled in different medical and dental plans. Developed complex SQR program that creates multiple reports dynamically based on various parameters.
• Work involved development of interfaces with Component Interfaces and File Layouts to read inbound files and manipulating the PeopleSoft tables.
• Involved in Analysis, Coding, Testing and review phases of work.
• Involved in preparing test cases for Unit testing and Source control requests.

Environment
PeopleSoft HRMS 8.8, People Tools 8.44/8.43, Peoplecode, Application Engine, Component Interfaces, SQR, Windows 2000, oracle 9i.

Confidential, Dallas, TX Mar 2004 – Apr 2005
PeopleSoft HRMS/Finance Analyst, Implementation
Responsibilities

• Worked on Peoplesoft HRMS 8.8 on HR, Payroll, Benefits and Pension and AP, AR and GL.
• Worked on field mapping of legacy data with the corresponding PeopleSoft benefits and payroll data.
• Analysis of the Functional Specifications, Preparation of Technical Specifications, Design and Development, and Testing of PeopleSoft (RICE) Reports, Interfaces, Conversions and Enhancements objects.
• Worked on RICE objects, creating Reports, third party Interfaces and Converting data from the legacy system as part of the implementation.
• Designed and Developed interface for transfer earnings codes and hours from the time keeping modules, Kronos and Bluecube, to PeopleSoft for Corporate Employees and Distribution Center Employees, and store employees.
• Designed and Developed interface for Unicru – Compliance file which sends for the prior calendar month to unicru with all active and terminated store employees.
• Extensively used Application engine, SQR and Peoplecode for new development.
• Involved in Fine Tuning the SQLs, which are used in Data Conversion Application Engine Programs to increase the performance.
• Documented the specifications on regular basis for every change required and implemented.
• Interfaced PS/Query with Crystal Reports for Ad-hoc reports.
• Involved in Unit Testing and Integration Testing for the customized SQR Programs.
• Interpreted Functional Documentation to Technical Documentation.

Environment
PeopleSoft HRMS 8.8, People Tools 8.44/8.43, Peoplecode, Application Engine, Component Interfaces, SQR, nVision, Windows 2000, oracle 9i.

Confidential, New Jersey, NJ Mar 2001 – Mar 2004
PeopleSoft HCM Consultant (Upgrade and Enhancements)
Responsibilities

• Developed SQR interface for AMS (Attendance Monitoring System).
• Extensively used Application engine, SQR and Peoplecode for new development and enhancements.
• Customized Leave according to client requirement – CL/PL/General Absences. Added new components for capturing Casual leaves of accrual nature.
• Developed self-service modules to help employees with online access to HR activities, including vacation requests, personal profile, leave balances, ePay and compensation details.
• Handled Security related issues for certain roles and also giving department level security through Tree Manager.
• Involved in development of SQR Reports like Appointment Letter, PF, Gratuity, Relieving Letter and LTA.
• Experience in production support of HR/Recruitment/Resume processing/Absence Management/Training Administration modules.
• Worked in Application Engine for developing batch processes and for creating Inbound and Outbound interfaces.
• Involved in Upgrade of customized SQRs from HRMS 8.3 to Peoplesoft HRMS 8.8.
• Involved in User Acceptance testing and Training the users and post implementation support.

Environment
PeopleSoft HRMS 8.8/8.3, PeopleTools 8.44/8.43/8.17, Windows 2000, Oracle8i, SQR 6.1.2 and Crystal Reports 8.0.