SUMMARY:

• 14+ years of IT industry experience encompassing a wide range of skill set, roles and industry verticals.
• Having 9 Years of progressive IT Experience which includes experience in Implementation, Customization, Upgrade and Maintenance of PeopleSoft HRMS/HCM Applications.
• Experience in PeopleSoft HRMS (HR/ NA Payroll/ Base Benefits/ CSS and MSS).
• Proficient in People Tools - Application Designer, Application Engine, File Layout, Component Interface, Process Scheduler, PS Query, SQL, Complex SQL, Data Mover, XML Publisher, Integration Broker and AWE.
• Expertise in PeopleCode to implement specific business rules and validations to enable the system to perform the business process.
• Strong Data Conversion experience from legacy systems to PeopleSoft systems and from version PeopleSoft 8.9 to PeopleSoft 9.2 using Component Interface, Application Engine, Excel to CI, Data mover and Complex SQL.
• Configured and maintained all the tables involved in Payroll processing, such as Pay calendar, JobCode, Deductions and Processes such as Paysheet creation, PayCalc, Payconfirm, Tax Tables etc.
• Created new Application Engine & Component Interface program to move employees from some of the Jobcodes to another Jobcodes to make them qualify for new Pay Rate increase .
• Experience in writing complex database reports and customizing PeopleSoft Delivered SQR reports and development of Outbound and Inbound SQR interfaces.
• Good in Fit/Gap analysis of the HRMS processes and identified the customizations that needed to be carried forward.
• Good experience in Impact Analysis, writing Technical design specifications for any customizations requested by business users.
• Worked as Team Lead in different Projects with very good team co-ordination skills and also as an Effective Team Player and an individual contributor with steep learning curve.

TECHNICAL SKILLS:

ERP: PeopleSoft HCM 8.9/9.0/9.2

PeopleSoft Products: HRMS (Core HR, Base Benefits and North America Payroll)

PeopleSoft Technology: Application Designer, Application Engine, Component Interface, Data Mover, Peoplecode, People Tools, SQR

Functional Modules: Core HR and North America Payroll

RDBMS: Oracle 8.1/9i/10g, MS-SQL Server 6.5/7.0 and DB2

Languages: Java, JSP, Oracle SQL, Oracle PL/SQL, SQR, PeopleCode

Tools: Oracle Developer2000/6i

O/S: Windows NT/2000 Server, HP-UX 11.1, SCO UNIX

Processes: Gathering Requirements, Fit-gap Analysis, Implementations, Business Process Analysis and Reengineering, Joint Application Development (JAD), Methodology Selection, Quality Control Processes, Issue Resolution, End User & Management Communication

General IT: Data Modeling, Documentation, On-Call & End-User Support, SQL, Systems Analysis, Team Leadership, Technical Design & Programming, Testing & Quality Assurance, Training & Education, Change Control PeopleSoft Product Experience.

PROFESSIONAL EXPERIENCE:

Confidential, Peoria, IL

Senior PeopleSoft Consultant

Responsibilities:

• Responsible for leading a team in delivering solution and support to our customer Confidential Inc.
• Ensures the tasks is delivered on time and produces high quality deliverables.
• Involved in Resolving day-to-day production tickets in HR and Payroll.
• Involved in Resolving day-to-day production tickets in eBenefits(Benefits enrollment, Health plan, Saving Pan and Dependent and beneficiary).
• Retrofitted HR and Payroll based on new requirements and customizations.
• Created customized Application Engine programs based on user requirements.
• Wrote People Code to customize the delivered objects for HR records.
• Worked on several customs Table Audits and created Test scripts for functional test.
• Designed and Developed Inbound Interfaces and processing procedures for processing and Loading Employee Benefits, Deferred Compensation, Loan and 401K Contributions and Vacation Buy and Health & Welfare information into PeopleSoft Tables.
• Configured and maintained all the tables involved in Payroll processing, such as Pay calendar, JobCode, Deductions and Processes such as Paysheet creation, PayCalc, Pay confirm, Tax Tables etc.
• Involved in running weekly and biweekly and Monthly payroll with functional team and error solving.
• Applied tax updates and Retrofitted customizations after each tax update.
• Worked on Data Mover Scripts(DMS Scripts) on HR and Benefits tables to validate in different environments
• Created Run control Pages, Components and Records and attached them to required menus through Application Designer and made them available to various operators through Maintain Security to have the reports run under Process Scheduler.

Environment: Window7, UNIX, Mainframe, PeopleSoft HCM 9.2 (Enterprise Resource Planning), PeopleTools 8.53 and Oracle

Confidential, Peoria, IL

Senior PeopleSoft Consultant

Responsibilities:

• Working as a Senior Technical Team member for Upgrade PeopleSoft HCM 9.2 from PeopleSoft HCM 8.9.
• Involved in requirements gathering and write specification for converting data from PeopleSoft 8.9 to PeopleSoft 9.2.
• Develop programs to transform data using SQR, Application Engine, Complex SQL, Component Interface and Data mover from PeopleSoft 8.9 to PeopleSoft 9.2 for HR and NA Payroll modules.
• Converted data for Personal Data, Job, compensation, Employment etc using component interface and complex SQL.
• Converted data for Additional Pay, General Deduction, Garnishments, Direct Deposit, Payroll Data, Employee Tax Data and Employee Tax Distribution for NA payroll using Application Engine and complex SQL.

Environment: Window7, UNIX, Mainframe, PeopleSoft HCM 9.2 (Enterprise Resource Planning), PeopleTools 8.53 and Oracle

Confidential, Peoria, IL

Senior PeopleSoft Consultant

Responsibilities:

• Responsible for leading a team in delivering solution and support to our customer Confidential Inc.
• Ensures the tasks is delivered on time and produces high quality deliverables.
• Involved in Resolving day-to-day production tickets in HR and Payroll.
• Involved in Resolving day-to-day production tickets in eBenefits(Benefits enrollment, Health plan,Saving Pan and Dependent and beneficiary).
• Retrofitted HR and Payroll based on new requirements and customizations.
• Created customized Application Engine programs based on user requirements.
• Wrote People Code to customize the delivered objects for HR records.
• Worked on several customs Table Audits and created Test scripts for functional test.
• Designed and Developed Inbound Interfaces and processing procedures for processing and Loading Employee Benefits, Deferred Compensation, Loan and 401K Contributions and Vacation Buy and Health & Welfare information into PeopleSoft Tables.
• Configured and maintained all the tables involved in Payroll processing, such as Pay calendar, JobCode, Deductions and Processes such as Paysheet creation, PayCalc, Pay confirm, Tax Tables etc.
• Involved in running weekly and biweekly and Monthly payroll with functional team and error solving.
• Applied tax updates and Retrofitted customizations after each tax update.
• Worked on Data Mover Scripts(DMS Scripts) on HR and Benefits tables to validate in different environments
• Created Run control Pages, Components and Records and attached them to required menus through Application Designer and made them available to various operators through Maintain Security to have the reports run under Process Scheduler.

Environment: Window7, UNIX, Mainframe, PeopleSoft HCM 8.9 (Enterprise Resource Planning), PeopleTools 8.49 and DB2

Confidential

Senior PeopleSoft HCM Consultant

Responsibilities:

• Responsible for leading a team in delivering solution and support to our customer Confidential .
• Ensures the tasks is delivered on time and produces high quality deliverables.
• Manages project team including: Assigning roles and responsibilities, Assigns tasks and activities, resolves resource issues, Communicates accurate task status through reports, sponsor reviews.
• Performed Production Support, enhancements and customizations of PeopleSoft HRMS 9.1.
• Resolved issues with HR and benefits reports and interfaces, by correcting the logic and making necessary modifications as required to the SQR programs.
• Modified Application Engine programs and processes (SQL and Application Engine PeopleCode) based upon business requirements.
• Worked on Paycheck page Customizations to change the search keys for better page performance and comma formatting of the amount fields on the Pay Check Summary page.
• Developed new SQR programs to pull the Payroll related data from PeopleSoft HRMS Database and to generate Flat files.
• Involved in designing new Application Engine programs utilizing SQL commands and PeopleCode. Utilized the Application Engine restart capabilities to restart failing Application Engine programs.
• Wrote Inbound and Outbound Interface Programs to send/receive HR related data to/from different systems using SQR.
• Applied tax updates and Retrofitted customizations after each tax update.

Environment: WindowXP, UNIX, PeopleSoft HCM 9.1 (Enterprise Resource Planning), PeopleTools, PeopleCode, Application Engine and Oracle 10g

Confidential

PeopleSoft Consultant

Responsibilities:

• Involved in Resolving day-to-day production tickets in NA Payroll.
• Retrofitted NA Payroll based on new requirements and customizations.
• Created customized Application Engine programs based on user requirements.
• Wrote PeopleCode to customize the delivered objects for HR records.
• Worked on several customs Table Audits and created Test scripts for functional test.
• Configured and maintained all the tables involved in Payroll processing, such as Pay calendar, JobCode, Deductions and Processes such as Paysheet creation, PayCalc, Payconfirm, Tax Tables etc.
• Involved in running weekly and biweekly payroll with functional team and error solving.
• Applied tax updates and Retrofitted customizations after each tax update.
• Created Run control Pages, Components and Records and attached them to required menus through Application Designer and made them available to various operators through Maintain Security to have the reports run under Process Scheduler.
• Working closely and proactively with United Airlines to manage the business relationship and provide the services through the Term
• Functional & Technical design, coding & testing and enhancements including Portal Objects, Roles & providing connections to multiple application instances.
• 24 hours On Call Production Support for PeopleSoft HRMS (North America Payroll) technical issues.

Environment: WindowXP, PeopleSoft HCM 9.0 (Enterprise Resource Planning), PeopleTools, PeopleCode, Application Engine and DB2

Confidential, Mount Prospect, IL

Conversion Team Lead

Responsibilities:

• Implementation of PeopleSoft North America Payroll Module ver. 9.1.
• Mapping payroll processes to elaborate a GAP Analysis and identifying the customizations required to fulfill the business processes. Mapping of tables like Employee Tax W4, Tax distribution, Direct deposit, Saving Plan, General Deduction, Payroll Balance, Arrears Balance, Additional Pay, Garnishment, check YTD of PeopleSoft with Legacy to migrate the data from the Legacy system to NA Payroll.
• Configuring payroll elements such as Earnings, Deductions, Paygroup, Tax Data, Pay Calendar, etc. according to client’s payroll processes.
• Data Migration from Legacy systems.
• Executing payroll processes in a parallel way comparing results between PeopleSoft and the payroll system of the client,
• Coordinating all the activities needed to make go-live and Post implementation support
• Analyzing user needs, conferring with users to improve procedures and identifying and solving problems.
• Responsible to develop scripts using SQR, Application Engine which would read the Mainframe data of Legacy payroll system convert it into PeopleSoft format and then load it into PeopleSoft Payroll tables.

Environment: WindowXP, PeopleSoft HCM 9.0 (Enterprise Resource Planning), PeopleTools, PeopleCode, Application Engine and DB2

Confidential

Conversion Team lead

Responsibilities:

• Responsible for developing scripts using SQR, People Tool which would read the Saba data, convert it into PeopleSoft format and then load it into PeopleSoft ELM tables.
• Responsible to create a dump of Saba system tables in PeopleSoft ELM. Which allow us to read the data directly from Saba backend tables.
• Responsible for identify data elements which need to be converted from Saba into PeopleSoft LMS.
• Responsible for identify the mapping between Saba LMS tables and PeopleSoft LMS tables.
• Responsible for developing conversion scripts, table loading sequence.
• Responsible for Execute and testing the conversion and Generate audit report.
• Responsible for effective communication between the team and the Project Manager. Provide day to day direction to the team and regular project status to the Project Manager.
• Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.

Environment: WindowXP, PeopleSoft HCM 9.0 (Enterprise Resource Planning), PeopleTools, PeopleCode, Application Engine and Oracle9i

Confidential

Conversion Team lead

Responsibilities:

• Responsible for leading conversion team in delivering solution to our customer to Upgrade PeopleSoft 8.9 to PeopleSoft 9.0
• Deliver new and complex high quality solutions to clients in response to varying business requirements
• Responsible for identify data elements which need to be converted from PeopleSoft 8.9 into PeopleSoft 9.0.
• Responsible for identify the mapping between PeopleSoft 8.9 tables and PeopleSoft 9.0 tables.
• Responsible for developing conversion scripts, table loading sequence.
• Responsible for Execute and testing the conversion and Generate audit report.
• Responsible for effective communication between the team and the Project Manager. Provide day to day direction to the team and regular project status to the Project Manager.
• Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.

Environment: WindowXP, PeopleSoft HCM 9.0 (Enterprise Resource Planning), PeopleTools, PeopleCode, Application Engine and Oracle9i

Confidential

Team lead

Responsibilities:

• Responsible for leading a team in delivering solution to our customer in the financial sector.
• Deliver new and complex high quality solutions to clients in response to varying business requirements
• Responsible for managing change control, aspects of the project.
• Responsible for effective communication between the team and the Project Manager. Provide day to day direction to the team and regular project status to the Project Manager.
• Utilize in-depth knowledge of functional and Technical experience in PeopleSoft ERP and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.
• Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.

Environment: WindowXP, PeopleSoft HCM 9.0 (Enterprise Resource Planning), PeopleTools, PeopleCode, Application Engine and Oracle9i

Senior Technical Associate

Confidential

Responsibilities:

• Responsible for leading a team in delivering solution to our customer in the Telecom sector.
• Deliver new and complex high quality solutions to clients in response to varying business requirements
• Responsible for managing change control, aspects of the project.
• Responsible for effective communication between the team and the Client. Provide day to day direction to the team and regular project status to the client.
• Coordinate and communicate tasks with developers
• Ensure that development is performed as per requirements
• Work with QA to create test scripts and scenarios for enhancements and customizations to the core product
• Develop implementation and test plans, build software acceptance criteria, coordinate and work with clients.
• Database design on Oracle9i
• Writing code using JAVA, JSP.

Environment: WindowXP, JAVA, JSP, Web Logic and Oracle 9i

Confidential

Team lead

Responsibilities:

• Responsible for leading a team in delivering solution to our customer in the Telecom sector.
• Deliver new and complex high quality solutions to clients in response to varying business requirements
• Responsible for managing change control, aspects of the project.
• Responsible for effective communication between the team and the Client. Provide day to day direction to the team and regular project status to the client.
• Coordinate and communicate tasks with developers
• Ensure that development is performed as per requirements
• Work with QA to create test scripts and scenarios for enhancements and customizations to the core product
• Develop implementation and test plans, build software acceptance criteria, coordinate and work with clients.
• Performance tuning, SQL query enhancements, code enhancements to achieve performance targets

Environment: Windows2000, SQL, PL/SQL, JAVA, Oracle9i