SUMMARY

• Proficient in all phases of the system development life cycle including requirement definition, data conversion, system implementation, system testing and acceptance testing.
• Strong technical expertise in Application Designer, Process Scheduler, People Code, Application Package, SQRs, Component Interface, Application Engine, File Layout, PSQUERY Excel to CI, Integration Broker, and BI Publisher.
• Strong PeopleSoft HCM analytical experience in the modules like Core HR, Payroll for North America, Benefits, Position Management, ePay and the custom Bolton projects.
• Developed and Modified Outbound and Inbound SQR interfaces.
• Hands on experience on Fluid pages and Tiles.
• Proficient in writing complex database reports and customizing PeopleSoft Delivered SQR reports.
• Extensively worked on the integrations between different systems (Core HR, Payroll, Benefits, Recruitment, Performance Management and Time & Labor).
• Performed extensive debugging and performance tuning of various processes. Well versed in utilizing tools and utilities PC Debugger, Application Engine trace for troubleshooting.
• Developed the Data Conversion Tool to convert the data from PeopleSoft to Workday.
• Worked extensively in setting up Security Setups.
• Extensively worked on interfaces and conversions from Legacy/third party systems to PeopleSoft using SQR and Application Engine.
• Worked on applying, retrofitting and testing of tax update & HCM bundles
• Hands on experience in HPQC, Maestro tool, HPSM, Test Link, Share Point, Lotus Notes and Stat.
• Implemented and upgraded the application by following the SDLC.
• Certified Oracle/PeopleSoft technical expert.
• Excellent Communication Skills
• Strong presentation and demonstrating skills; Confident, articulate and professional speaking abilities.
• Good team player and communicates effectively to enable execution of projects flawlessly.
• Experienced in full life - cycle implementations, application upgrades, application support and maintenance.
• Results-focused, quality-driven professional and dedication to organizational goals.

TECHNICAL SKILLS

ERP: PeopleSoft 8.0/9.0/9.1/9.2 People Tools 8.x, Application Designer, XML Publisher, Application Engine, Application Package, PeopleCode, File Layout, Data Mover, Tree Manager, Mass Change, Process Scheduler, Application Messaging, Component Interface.

Database: SQL SERVER, DB2, Oracle7.x/8.x/9.x/10g/11g, 12c Toad. SQL developer, AQT

Operating System: Unix, Windows NT, Windows 2000, Windows 98, Windows XP, Windows 8

Reporting Tools: PS Query, SQR, Application Engine

Programming Languages: PeopleCode

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, IL

Senior PeopleSoft Technical Consultant

Responsibilities:

• Worked on customizing of PeopleCode, SQR, Application Engine and Application packages, PSQUERY, Integration broker, File layout, Web services, XML to meet the business requirements.
• Worked on PUM upgrade, Tax Updates, Security Patch Upgrade defects / bug fixing.
• Created, reviewed and modified the technical design documents and Unit test documents.
• Worked in technical analysis, requirements gathering and help the team in conduct fit-gap analysis.
• Provide guidance to the team to identify feasible alternative solutions and assist in the scope of people code modifications.
• Developed complex SQL in DB2.
• Created the interfaces using Application Engine, Component Interface, File Layout and SQRs to load the data from the feeder area into PeopleSoft HCM system.
• Customized the classic and fluid pages based on the business needs.
• Developed new tiles to access the fluid pages in ESS & MSS applications.
• Worked on the integrations between Core HR & Recruitment system using Application Engine and Component Interface.
• Developed the interfaces to send the HR information to benefits, get the benefit enrollments for payroll processing and send the benefit confirmation details from Payroll to Benefit system.
• Customized the delivered SQR programs for quarterly filing and yearend processing based on the business needs.
• Good experience in using People Code Trace and other debug methods to identify the root cause of an issue.
• Created Component Interface to export data from Excel to CI.
• Good experience in compare report verification and retrofitting.
• Modified delivered component and pages as per the requirement.
• Modified the existing People Code, Application Engine and Application Package as per the requirement.
• Configured the PeopleSoft security by assigning roles/ custom roles and ps to the user as per the requirement.
• Worked on Process Scheduler to schedule the batch jobs.
• Performed the Job monitoring and provided the technical solutions and support.

Environment: PeopleSoft 9.2, People Tools 8.56, People Tools 8.55, People Code, SQR, Application Engine, Integration broker, Component Interface, Application Package, PSQUERY), DB2.

Confidential, Bloomington IL

Senior PeopleSoft Technical Consultant

Responsibilities:

• Performed the FIT-GAP Analysis between 9.1 and 9.2.
• Extensively worked on customizing and retrofitting of PeopleCode, SQR, Application Engine and Application packages, PSQUERY, Integration broker, File layout, Web services, XML to meet the business requirements for 9.2
• Worked on performance tune up in by modifying SQR’s.
• Created and modified Technical design documents and preparation of Unit testing.
• Developed complex SQL in DB2.
• Involved in verify the status of the schedule jobs using process scheduler and Control-M.
• Involved in defect/ bug fixing.
• Customized the PeopleCode, Application Package, Integration Broker and BI Publisher to meet the business requirement on the delivered PDF Federal & State W-4 Withholding forms.
• Worked on People Code Trace and other debug methods to identify the root cause of an issue.
• Created Component Interface to export data from Excel to CI.
• Worked in support by monitoring jobs in Control-M tool and few jobs in process Scheduler.
• Worked in BI publisher and customized HTML tags as per the requirements.
• Coordinating with the offshore team and mainframe team as required.
• Used STAT for migrating object between environments.
• Worked with Business Analyst during the Function Integration Testing and System Testing phase.
• Worked with the Project Manager and Implementation Coordinator for the Dress Rehearsal.
• Worked with the technical teams (Migration, Server & Security) for the Roll to Production activities.
• Provided support during the implementation period.
• Taken care of the Production Tickets.
• Worked on HCM Bundles Tax Update and Security Patches.
• Worked with the Business Analyst for the Quarterly filing and Yearend activities.

Environment: PeopleSoft 9.1, PeopleSoft 9.2, People Tools 8.55, People Code, Application Engine, Component Interface, Application Package, PSQUERY, BI Publisher, SQR), DB2.

Confidential, Bloomington IL

PeopleSoft Technical Consultant

Responsibilities:

• Analyzed functional requirements and get the clear understanding of the requirement.
• Analyzed the Check / Advice Print delivered option provided by PeopleSoft.
• Performed the POI to achieve the additional features needed for the client.
• Identified the correct method to get the pdf and printed checks/advice/W4 while running the process through the mainframe.
• Prepared the technical design document based on the business requirement.
• Customized the SQR & Application Engine Programs to meet the business and system requirements.
• Customized the BI Publisher Templates to add and delete few details from the delivered templates.
• Developed new SQR and Application Engine programs based on delivered programs to make it feasible on mainframe system
• Worked with the Printer Team to setup the signature and MICR settings in the printer.
• Developed the Unit Test Scripts.
• Performed the Unit Testing and walkthrough the test results with the Business Analysts.
• Assisted the Business Analyst and Business Partners during System and UAT Testing.
• Assisted the team members and provide on-call support.
• Taken care of tickets regarding the production issues.
• Worked with the Migration and Server team to apply the Tax Updates and performed the retrofitting and testing of the patches.
• Performed the year end activities based on the yearend schedule.
• Examined systems application issues, problems, improvements and presented options for resolution.

Environment: PeopleSoft 9.1 HCM (Core HR, ESS, MSS, NA Payroll), People Tools 8.55, Application Engine, BI Publisher, Mainframe People Code, SQR, PSQUERY, DB2, Lotus Notes.

Confidential - Lincolnshire, IL

Team Lead

Responsibilities:

• Worked with the Workday Business analyst and get the requirement from Workday side to load the data from PeopleSoft to Workday System.
• Prepared the High-Level Technical Design Document.
• Delegated the tasks to the team based on the requirement.
• Worked with the team and identified the correct technology and develop the conversion programs.
• Developed a data conversion tool using People Tools to extract data from PeopleSoft for Workday
• Reviewed the programs developed by the team and reviewed the unit test results.
• Tracked the project schedule and ensure that the project is meeting the deadline for all the deliverables.
• Coordinated with the Workday data conversion team and fixed the defect in the converted data.
• Provided the support during the Implementation phase.
• Prepared the Weekly Status Report and Presented during the WSR meeting.
• Worked on Applying, Retrofitting and Testing of PeopleSoft 9.0 delivered patches
• Taken care the Production issues came on existing PeopleSoft 9.0 Environments.

Environment: PeopleSoft 9.0, People Tools 8.49, Workday 23, People Code, Application Engine, Component Interface, DB2)

Confidential

PeopleSoft Technical Consultant

Responsibilities:

• Performed the impact analysis and identified all the impacted objects.
• Created the technical design documents based on the requirements.
• Conducted the design walk-through with the client and get the approval for the design.
• Created and modified the PeopleSoft pages, PeopleCode, Component Interfaces, and batch processes (SQR & Application Engine) based on the business requirement to calculate the Canada overtime data and load into the payroll system.
• Modified the SQR programs for leave accrual and leave plan assignment.
• Performed the retrofitting of the setup pages based on the new requirement.
• Performed the Unit testing and make sure everything is as expected.
• Assisted the Business Analyst during the functional testing phase.
• Handled the production tickets and on-call support.
• Applied and performed the retrofitting for Tax Updates.

Environment: PeopleSoft 9.0, People Tools 8.49, People Code, Application Engine, Component Interface, SQR, PSQUERY, DB2)

Confidential

PeopleSoft Technical Consultant

Responsibilities:

• Prepared the technical solution/design document for each requirement in Business Requirement Document.
• Created and modified the PeopleSoft pages, components and provided the proper security access.
• Developed the interfaces between Core HR to Benefits, Benefits to Payroll & Payroll to Benefits using Application Engine, Component Interface, File Layout and SQR.
• Prepared the unit test scripts and test data.
• Performed the Unit testing and make sure everything is as expected.
• Assisted the Business Analyst during the functional testing phase.
• Worked with Business Analyst and prepared the DMS scripts to migrate the configuration setups.
• Handled the production tickets and on-call support.
• Applied and done the retrofitting of Tax Update patches.

Environment: PeopleSoft 9.0, People Tools 8.49, People Code, Application Engine, Component Interface, File Layout, SQR, PSQUERY, DB2)