SUMMARY

• Technically sophisticated and business - savvy professional wif over 10 years of experience in various Fortune 500 companies wif a pioneering career reflecting strong leadership qualifications coupled wif ‘hands-on’ functional & technical expertise across various PeopleSoft HR modules.
• Worked in the capacity of Project Lead leading large teams under different clients.
• Sound working knowledge in functional and technical aspects of PeopleSoft HRMS modules: Administer Workforce, Benefits Administration, North American Payroll, Talent Acquisition Management, Absence Management, Position Management, e-Benefits, ESS & MSS & PS Security.
• Excellent Expertise in PeopleSoft Development tools like PeopleCode, Application Designer, Component Interface, Data Mover, Integration Broker, Application Engine and PSQUERY. Strong technical skills in SQR, PS Query tools, Integration tools and File layouts
• Expertise in understanding the Business requirements and preparing Functional and Technical Specifications based on broad array of Functional knowledge
• In-depth functional roles performing analysis, business process reengineering, fit-gap analysis, data mapping, data modeling, testing, and complex fully technical roles wif any of the latest PeopleSoft technologies.
• Performed business process and workflow analysis to identify opportunities to eliminate customizations, implement best practices and make systems perform better, faster and more economically.
• Designed and documented various inbound/outbound interfaces for PeopleSoft wif various 3rd party systems using AE and SQR.
• Involved in design, development, Implementation and Maintenance of various custom PeopleSoft applications.
• Extensively used SQL and PL/SQL for writing Stored Procedures, Functions, Triggers, etc.
• Experienced in writing Test cases, Test Plans & scripts based on system specifications and expertise in unit testing, regression, system integration, functional and performance testing
• Experience also includes Debugging and performance tuning of processes. Well versed wif Debugging tools like SQL trace, PC debugger, and Application Engine trace for troubleshooting
• Ability to leverage knowledge gained on various client installations wif different functional configurations across companies to halp solve business and technical issues.
• Excellent Verbal and written communication, Deliver quality work, Self-starter, able to mentor colleagues and create a positive work environment.

TECHNICAL SKILLS

ERP: PeopleSoft

Functional: PeopleSoft HRMS 9.x - Core HR, Base Benefits, Payroll for North America, Benefits Administration, TAM, Absence Mgmt, Pension Administration, Recruitment, Time & Labor, Position Management, Self service modules & PS Security PeopleSoft Financials - General Ledger PeopleSoft Upgrade- 8.x to 8.8, 8.x to 9.1 Oracle R12 HR - Core HR, Base Benefits, North American Payroll

ERP Tools: PeopleTools 8.4x - Application Designer, Component Interface, Data mover, PeopleCode, Application Engine, Integration broker, File Layout, PS Query, Workflow, SQR., Upgrade Assistant 8.4.

Data warehouse Tools: Ascential Data Stage, Cognos, Business Objects, Crystal Reports

Database: MS SQL Server, Oracle 11i, DB2, PL/SQL, Access DB

Operating System: Mainframe, Windows, Unix

Others: JCL, COBOL, STAT, Autosys, Unix Shell Scripting.

PROFESSIONAL EXPERIENCE

Confidential - Philadelphia, PA

PeopleSoft HR Functional Consultant

Responsibilities:

• Design, develop, test and implement the Compensation harmonization project to upload the associate’s annual promotion, grade change and compensation changes.
• Done extensive testing and reconciliation of the Compensation update process.
• Conducted major changes to the Bonus Accrual process to implement a country based leave rules to suite different regional regulations concerning country leave rules.
• Design, develop, test and implement the Canadian Standard hours change in PeopleSoft.
• Developed various complex PSQueries for testing and validating the Leave accrual process.
• Responsible for maintaining the Department and user profile security and debug any issues that arise from time to time.
• Provide support to the various HR service center data requirements by pulling ad-hoc queries from the different PeopleSoft HR components. Involved in Business requirement and scope change meetings and converted them into Business Requirement Documents.
• Provided Functional support for Payroll for North America. Applied PeopleSoft Tax Updates and involved in testing during different releases.
• Responsible for troubleshooting any data issues that arise during the bi-weekly payroll run and for any off-cycle payroll.
• Develop various custom reports and queries for reconciliation of payroll data as well as maintain the Payroll to GL Interface. Coordinate wif Finance team to resolve any issues wif transferring Account line information for payroll payments in HR
• Conducted various workshops and requirement gathering sessions for designing and developing the Benefits interfaces for Aliquant, Sunlife, and TAS etc. Prepared functional specifications and subsequent end-end testing of the same.
• Designed and setup benefit programs and components (e.g., benefit plans, rates, credits, deductions, calculation rules). Designed and setup Eligibility Rules and Event Rules.
• Designed and setup eBenefits for Open Enrollment and Event Maintenance.
• Tested Open Enrollment and Event Maintenance processes. Setup and executed snapshot for initial conversion to Ben Admin.
• Involved in the analysis, design & testing of processes related to the Employee benefits and their 401k contributions and other related information to different banks and other institutions.
• Responsible for requirement gathering, design, testing, Implementation of the Leave Accrual process wifin Base Benfits. Provide support during monthly upload the Time Card data as well manual editing of adhoc leave information. Maintenance of annual leave accrual process as well interfacing wif the Finance.
• Responsible for requirement gathering, design, testing, Implementation of the Leave Accrual process. Provide support during monthly upload the Time Card data as well manual editing of adhoc leave information. Maintenance of annual leave accrual process as well interfacing wif the Finance.
• Performed impact analysis and provided solution to address the various custom hard coding for Grade, location, LOBS, Practices, Business Units wifin the custom processes and reports that had impact due to merger related configuration changes that resulted.
• Developed functional specifications and tested the modified sqr and ae custom programs to address the hardcoding changes.
• Involved in the PeopleSoft to Oracle HR migration activities including conversion field mapping, extraction logic, data transformation and writing functional specifications for the above tasks. Involved in testing & co-ordination wif developers on the outbound data extraction processes in PeopleSoft & inbound process on R12 system.
• Conducted various workshops and training session to understand the new Oracle R12 system and mapping the functionality back to the Legacy systems.
• Design and developed the functional specifications for the daily data feed from Legacy PeopleSoft to the Oracle R12 system for deployed countries as well as for cross reporting relationship maintenance between various legacy systems and new Oracle R12 system.
• Developed complex sql scripts to extract data from Legacy PeopleSoft system and developed different methodology to load the same in the new Oracle R12 system.
• Responsible for requirement gathering, designing, test case preparation, coordinating wif developers, testing & implementation of different R12 inbound & outbound interfaces.
• Responsible for design, develop, test and implement the PeopleSoft and Oracle R11 archive reporting database wifin Infoseek archive tool to retrieve common reporting requirements for old legacy data.

Confidential - Albany, NY

PeopleSoft Functional Lead

Responsibilities:

• Job responsibilities include analyzing the functionality of the Current application and the Business process and create a blueprint of the optimized solution for conversion to PeopleSoft.
• Performed fit/gap analysis, designed gap strategies and recommended business process changes to take advantage of delivered functionality and eliminate obsolete customizations
• Perform the fit-gap analysis and prepare the fit gap analysis document for the Core HR, NA Payroll, Benefits Administration and Pension Admin modules.
• Involved in optimizing various upgrade specific data conversion programs and optimizing Application Engine programs.
• Responsible for creating Functional Design Documents for the upgrade process wifin the Core HR, NA Payroll and Benefits Administration Modules.
• Retrofitting Online and batch objects as per the to-be business process for Components, Pages, PeopleCode, SQR and AE.
• Performed unit test testing and system integration testing for the retro-fitted PeopleSoft objects.
• Implementation of Actuary system wifin PeopleSoft. The system involves complex COBOL & JCL programs to be converted into SQR & AE and online objects for the better usability.
• The Application Includes converting around 150 COBOL Programs wif over 200,000 lines of COBOL coding of Medium to High Complexity to be converted into PeopleSoft using SQR & AE.
• Designed & written functional specs data extraction processes using AE which extracts data from all PeopleSoft Core HR, NA Payroll and Benefits tables using complex business requirements into the Actuary tables.
• The Cola calc, supplementation calc, Active & Retired Lives file creation, various complex 2 dimensional and 3 dimensional reports which slices and dices the entire information for Statistical analysis of Actuary team and top management are few programs to mention.
• Designed and developed the Actuary automatic & manual adjustment process for retired and active lives data.

Environment: PeopleSoft HR 9.1, the Core HR, NA Payroll, Benefits Administration and Pension Admin, PeopleTools 8.48, Mainframe, SQR, A.E., COBOL, PeopleCode, CI, Workflow, Oracle 9i.

Confidential - New York, NY:

HR Functional Consultant

Responsibilities:

• The work includes production support, bug-fix, monitoring & enhancements. Responsible for requirement gathering, design, preparing the technical specifications and development.
• Provided Functional support for Payroll for North America. Applied PeopleSoft Tax Updates & People tools updates and involved in testing during different releases.
• Design and Build various complex automated Pay increase and Promotion upload programs using App engine - Component Interface
• Developed reports to generate metrics related to Tax balances for filing the Census Bureau data
• Worked extensively on configuring and customizing TAM module.
• Designed various workflows, customized the job openings, job posting & applicant activity components wifin the TAM module
• Configured & customized the Candidate Gateway (e-recruitment) module for online job postings, entering referrals, customizing job searches etc.
• Worked extensively in analyzing, designing and developing in Absence Management module. Customized the various pages as per business needs.
• Worked on the integration of Absence management wif the North American Payroll processes.
• Customization of the Absence Request, Absence History, Time keeper entry panels. Setting up of Earnings, deductions, Accumulators, Schedules wifin the Absence module.
• Configuration and customization of the Time and Labor module.
• Developed new setups to create T&L Shifts, Schedules, TRC’s, TCS categories and Workgroups. Involved in mapping the workgroup to employees, Team Codes, On-call codes and Payroll time codes in time and labor.
• Design and developed new custom enrollment program to enroll employees and consultants into PeopleSoft time and labor.
• Extensively customized the TIMEADMIN process as per the business requirements. Involved functional specification creation, interacting wif developers during coding, user-acceptance testing and deployment of the process.
• Designed SQR reports and interfaces for Benefits, HR, Payroll & GL, which have data of new hires and changes to certain HR/Payroll data & to generate flat files to be sent for third party.
• Design and develop new Inbound/ Outbound interfaces for various Benefit vendors.
• Designed and developed the daily dynamic role assignment process for new recruits and supervisors.
• Created new Tree Structure and added new DEPTID wifin the existing Deptid Trees wifin Tree Manager. Responsible for running the Security refresh processes.
• Maintenance and enhancement of the Integration Broker setup for data flow between different PeopleSoft applications.
• Design and developed custom ESS and MSS business processes for Resignation submission, resignation wifdrawal process. Involved complex workflow routing for employee, manager, HR, Finance and various support groups.

Environment: PeopleSoft HR 8.9, Core HR, NA Payroll, Benefits Admin, TAM, Absence Mgnt, Position Management, Time and Labor, ESS & MSS, Peopletools 8.48, Peoplecode, App package, CI, Workflow, DB2

Confidential - St. Louis, MO

PeopleSoft Lead

Responsibilities:

• Lead a team of 8 members catering to customers across 94 countries. Involved in the initial requirement gathering, work allocation, monitoring and execution of the project.
• Involved in the initial requirement gathering, work allocation, monitoring and execution of the project.
• Worked extensively on customizing components like template creation, job requisition, applicant activity, interview screening, and job offers panels. Written complex PeopleCode program to customize the same.
• Worked extensively in analyzing, designing and developing of some phases in Talent Acquisition Management module.
• Setting up job locations, recruiter’s roles, job openings, applicant setup, job offers, recruiting statues, and various templates etc wif the TAM modules.
• Customized the Manager hire process to integrate wif Core HR customizations. Designed and developed custom reports for various business processes of TAM.
• Worked on the Candidate Gateway (e-recruit) module for online job postings.
• Built workflow process for various activities wifin e-recruit module. Customized the employee referral program business process.
• Maintenance and support of the Absence Management module for Absence request, absence processing and NA Payroll integration.
• Involved in trouble shooting and production support of issues that arise during Absence entry, accumulation calculation, Absence processing, Payroll integration etc.
• Customized delivered reports like Absence Results Register, Payee messages etc. as per user requirements.
• Responsible for Implementation of new company for Confidential India. Involved in complete setup, configuration, data conversions and loading of the same from legacy system into PeopleSoft.
• Developed the Mass Change Upload process using Application Engine for various Job and Position data uploads. Built the Global Retro pay program for Job Data using AE.
• Supported the configuration of the ELM module as per business needs. Helped in creating new courses and Sessions for the same. Customized the data flow process between the training administrators and the employees.
• Built effective workflow of routing the absence information from employee, manager, HR and payroll teams wifin ESS and MSS modules. Fixed issues related to different department configuration wifin the same.
• Involved in the Global Portal rollout for Romania, France, and Spain which involved ESS & MSS implementation. Implemented total PS Security during these rollouts
• Worked in customizing the PeopleSoft pages for multi lingual usage as per the countries requirement.
• Design and development custom Payroll Interfaces specific to Singapore, Malaysia, Czech Republic, India.
• Involved in the fit-gap analysis of the existing HR 8.3 application to the HR 9.0 application. Assisted in reapplying customization of objects like Components, Pages, PeopleCode, SQR and PS Queries.

Environment: PeopleSoft HR 9.0, PeopleSoft HR 8.3, Core HR, NA Payroll, Benefits Admin, Position Management, ELM, TAM, E-recruit, PeopleTools 8.48, PeopleCode, Workflow, CI, PS Query, Portal, Oracle 9i, AE, PL-SQL, SQR and STAT.

Confidential - Dallas, TX:

PeopleSoft Consultant

Responsibilities:

• 24/7 critical On-Call Support to the HR & Financials related issues and to monitor the day/nightly batch streams.
• Assist the HR personal in configuring various Setup HR and NA Payroll configuration setups on a regular basis.
• Acted as technical point of contact for any doubts/clarifications from the business team during Payroll runs.
• Design and implementation of custom employee performance appraisal (e-performance) system wifin the existing ESS and MSS modules. Designed multiple panels for capturing important employee goals, competencies, achievements and targets and the employee and manager comments. Also extensive workflow TEMPhas been built across the system.
• Performed various complex enhancements over the ADP check creation processes which creates checks and transfers the same to ADP for distribution.
• Responsible for the Integration Broker configuration and maintenance of the data flow from NA Payroll to General Ledger system. Extensively customized the Application Messaging programs and complex PeopleCode for the same.
• Developed various inbound interfaces for Merit/Pay increase, Ad-hoc time upload process, Kronos timesheet upload process using AE - Component Interface.
• Bug fixed various issues pertaining to Bonus, Bluecube and Kronos timesheet upload and the various benefits processes due to change in business requirements.
• Wrote functional specifications and tested interface file processes for a new implementation of PeopleSoft Base Benefits and Ben Admin from a legacy system. Tested use of Retroactive Benefits Deduction Process.
• Analyze and designed the process to convert employee benefit enrollments from other systems to PeopleSoft tables.
• Worked on eBenefits Text Id changes, addition of Health Savings Accounts as an FSA plan type and conversion of benefit data for employees.
• Implementation of the Open Enrollment process. Provided technical and functional assistance during configuration and maintenance.
• Defined eligibility and event processing rules for the automatic enrollment of employees.
• Developed new Workflows for various on-line self-service modules.
• Applying Tax updates and performance tuning the payroll processes. Support the functional team during Bi-weekly Payroll run. Fixed issues pertaining to Payroll to GL.

Environment: PeopleSoft HR 8.8, Core HR, NA Payroll, Benefits Administration, General Ledger, PeopleTools 8.44, Workflow, CI, PS Query, Oracle 9i, Integration broker, PL-SQL, AE, SQR, COBOL, etc.

Confidential - Framingham, MA

PeopleSoft Consultant

Responsibilities:

• Support the Core HR, NA Payroll Modules and enhance the system as part of the user requirement. Involved in the performance tuning of the various processes.
• Provided functional/technical support for Payroll for North America. Apply PeopleSoft Tax Updates & People tools updates.
• Involved in fixing the existing issues and documenting the same.
• Create inbound/outbound interfaces from/to E*Trade for transferring Stock options and stock purchase information using Application Engine programs.
• Create reports that provide information of the various stock options the employee have and monthly reports on options that are exercised by the employees using SQR.
• Create custom reports for the ESPP Stock purchase module using SQR.
• Design and develop custom data scrambling tool to hide the sensitive information to comply wif SOX regulations

Environment: PeopleSoft HR 8.8, Core HR, NA Payroll, Stock Admin, PeopleTools 8.44, PeopleCode, Oracle 9i, PL-SQL, AE, CI, SQR, etc.

Confidential - St. Paul, MN

PeopleSoft Consultant

Responsibilities:

• Analysis of COBOL and SQR processes and prepare test scripts.
• Execution of Mainframe batch jobs and analysis of the output for its functionality.
• Performed end-end testing of Compensation module. Developed test cases, test scripts and executed the same for UAT testing.
• Performed functional testing on the HRMS modules of NA Payroll, e-Benefits and Base Benefits.
• Impact analysis of globalization of the application for various PeopleSoft modules.
• Involved in reapplying customization on objects like Components, Pages, PeopleCode, SQR and PS Queries.
• Optimized various upgrade specific data conversion programs and optimizing AE programs.
• Played a key role in compare report analysis and documenting the customization.
• Involved in preparing test cases, executing and defect tracking.

Environment: PeopleSoft HR 8.8, NA Payroll, Compensation, e-Benefits and Base Benefits, Peopletools 8.44, DB2, SQR, MVS, JCL, COBOL, etc.

Confidential

Technical Analyst

Responsibilities:

• Writing various ad-hoc sql queries to generate complex reports.
• Developed various SQR reports in the HRMIS format for the core HR users.
• Developed Crystal Reports that are used to Generate Letters for the various operations like Transfer Process, Onsite Travel Form, Confirmation Process etc., by capturing the details from PeopleSoft.
• Enhanced the Existing below Manager Level Appraisal system and supporting it for the current appraisal period according to the new/changed business needs.
• Designing and Implementation of the Senior Management level Appraisal system.

Environment: PeopleSoft HR 8, Core, HR, Recruitment, Learning Management, Base benefits, E-modules,ESS & MSS, Peopletools 8.17, MSSQL, Peoplecode, AE, SQR etc