Summary

• Overall 7 years of experience in PeopleSoft HRMS/HCM Technical Consultant with expertise in Requirement, System Analysis, Design, Development,Reporting, Implementation, Upgrade and testing of various applications in Client/Server 3-tier environment.
• Domain expertise includes Banking, Trading, Retail, Aviation.
• Experience in PeopleSoft Implementation, Maintenance, Upgrading, Interfacing/Reporting, Troubleshooting and Production support.
• Strong PeopleSoft analytical experience in HR, Base Benefits, Payroll, Payroll Interface, Benefits administration, Absence Management, Employee Self-Services, Manager Self-Services, eBenefits, ePerformance and complete understanding of complete project life cycle.
• Excellent experience as a technical consultant in PeopleTools such as Application Designer, Component Interface, PeopleCode, Page Designing, Application Engine, Component Interfaces, Application Package, Application Messaging, Integration Broker, Data Mover, Integration Broker Administration, PeopleCode Debugger and Application Security.
• Very strong in SQL's. Extensively worked with SQR, PeopleSoft Query in creation and generation of organizational reports.
• Excellent skills in Customization of PeopleSoft HRMS. Wrote efficient row by row, mass update and parallel processing custom Application Engines, SQRs for data conversion from Legacy to PeopleSoft records by performing various validations, File Layout and Component Interfaces.
• Experience also includes debugging and performance tuning of processes. Well versed with Debugging tools like SQL trace, PC debugger, and Application Engine trace for troubleshooting.
• Understanding the functional design documents to develop Technical Design Document along with test strategy / test plan.
• Good understanding of PIA such as app server configuration, PIA, Process Scheduler, web server
• Worked intensively with Security Administrator to implement security in various levels. Creating Roles, Permission Lists User Profiles, Portal Security, Folders, Content References and Definition Security.
• Oracle PeopleSoft 8.5 PeopleTools Certified.
• Have experience of supporting batch schedule in Autosys. Work exposure in mainframe.
• Involved in knowledge transfer to the client's team for security, People Code, People Tools, Workflow, interfaces, reports and troubleshooting.

Technical Skills

PeopleSoft: PeopleSoft HCM 8.3, 8.8, 9.0, 9.1, 9.2 portal , Core HR Employee Self Service, Manager Self Service , Payroll for North America Payroll Process, Tax Updates , Base Benefits / Benefits Administration, Absence Management, PeopleTools 8.46-8.53

Business Analysis / Design: Technical Design Documents, Use Case / Test Documents

Databases: Oracle 9i to Oracle 11g, Microsoft SQL Server

Languages / Tools: PeopleTools Application Designer, Application Engine, Integration Broker, Application Packages, Component Interfaces / ExcelToCI, Configuration Manager, Data Mover, PS Query, PeopleCode, C, C , Java, HTML, XML, Web Services,Crystal Reports. TOAD, SQL Developer, MS Office Suite, Visio, Microsoft Project, STAT.

Operating Systems: Windows 8, 7, XP, NT, 2000, 98, 95, Mainframe,DB2.

Professional Accomplishments

• PeopleSoft 8 Certified Developer Oracle Implementation Champion
• PeopleSoft Enterprise Partner Support Champion
• PeopleSoft 8 People Tools Oracle Implementation Champion
• Oracle PeopleSoft 8.5 PeopleTools Certified.
• PeopleSoft 8 Technology Oracle Implementation Champion
• Domain certification in Retail and CPG industry.

Professional Experience

PeopleSoft HRMS/HCM Technology Lead

Confidential

• Design and review of Business Solution document , High level design and detailed designed documents and coordination between Onsite and Offshore team members.
• Involved in design, development, fit gap analysis and requirement gathering of enhancements to existing requirements for consolidation
• Estimate, plan, assign, assist and track development specific to Core HR and NA Payroll.
• Involved in Payroll Processing and have working knowledge on tables like PAY TAX, PAY CALENDER, PAY CHECK, PAY EARNINGS, PAY DEDUCTIONS, etc.
• Involved in Auditing and troubleshooting SQR's like PAY034, PAY035, PAY036, PAY011 and PAYGL01 and also build customized audit scripts.
• Involved in developing the SQRs for benefits out bound interfaces.
• Troubleshooting of COBOL SQL processes like PSPPYBLD, PSPPYRUN, PSPCNFRM by performing various audits
• Requirement gathering for Data conversion from PeopleSoft to Work Day.
• Data analysis in PeopleSoft HRMS and developing reports using PSQuery.
• Analyzing the custom functionalities in PeopleSoft
• Analyzing the Workday functionality
• Comparing Workday and peoplesoft HRMS functionalities
• Responsibility included requirement Gathering, Analysis,Design and Estimation.
• Technical Issues Resolution Analysis, fixing and Tracking
• Creating complex SQL to retrieve the data from PS.
• Customer Relationship Management
• Preparing test case documents and testing extracts.
• Fixing up technical issue by providing resolution as Technical Fixes for issues as part of code changes and process changes.
• Test case preparation and Quality analysis
• Leading the offshore team and interacting with business to understand the requirements.

Environment : PeopleSoft HRMS 8.9, People Tools 8.51 , Windows NT,UNIX, Oracle Database

PeopleSoft HRMS/HCM Technology lead

Confidential

• Design and review of Business Solution document , High level design and detailed designed documents and coordination between Onsite and Offshore team members
• Involved in design, development, fit gap analysis and requirement gathering of enhancements to existing requirements for consolidation
• Involved in gathering the information from the Time and labour team and Intergrating with Time and labour module.
• Enhanced existing SQRs to accommodate requests for new processes and reports.
• Developed Interface using File Layout, Application Engine, and Component Interface, which loads data from flat file into staging tables while doing various data validations using AE PeopleCode and finally loads into PeopleSoft tables through Component Interface
• Used PeopleSoft delivered Time and Labor rules and also developed and Customized Time and Labor rules which included Holiday, Weekly Threshold, Daily Threshold, and Day Breaker Rules
• Analyzed the impact on current production environment and support their processes simultaneously
• Working on enhancements for the customizations required for the user's requirement.
• Leading the offshore team and interacting with business to understand the requirements.
• Fixing up technical issue by providing resolution as Technical Fixes for issues as part of code changes and process changes.
• Enhanced the Integrations using TCC client and SQR's to pull applicant information from Taleo System
• Recruiting Application to Manager Hire process.
• Data migration activities from legacy systems to PS.
• Involved in testing with the business in all the process.

Environment : PeopleSoft HRMS 9.1 People Tools 8.52 , Windows NT, Oracle Database

PeopleSoft HRMS/HCM Technology lead

Confidential

• Involved in consolidation of the business processes, which reside in PeopleSoft 8.4 and 8.9 instances, and support US operations and Canada operations
• To implement the above mentioned business processes in PeopleSoft 9.1, the latest release currently available
• De-customize and reduce the amount and complexity of customizations that have been done in current instances, and use more vanilla functionality which will reduce the Total Cost of Ownership for Lowe's.
• Design and review of Business Solution document , High level design and detailed designed documents and coordination between Onsite and Offshore team members
• Developed Interface using Integration Broker to consume Inbound Asynchronous Messages and update location table in PeopleSoft. Location Address and vendor ID were updated in this process.
• Developed Reports for the business.
• Created web services to interact with third party.
• Involved in design, development, fit gap analysis and requirement gathering of enhancements to existing requirements for consolidation
• Enhanced existing SQRs to accommodate requests for new processes and reports.
• Analyzed the impact on current production environment and support their processes simultaneously
• Leading the offshore team and interacting with business to understand the requirements.
• Created Test scripts for all the process and Involved in System Testing ,User Acceptance testing.
• Actively involved in the unit testing, issue resolution during the parallel test and the postproduction support.
• Implementing security in the new system by creating new roles and permission lists and consolidating them across users.

Environment : PeopleSoft Financials 8.4, 8.9 and 9.1 People Tools 8.45 , 8.51 and 8.52 , Windows NT, OS390, DB2 on OS390

PeopleSoft HRMS/HCM Technology Analyst

Confidential

• Extensively worked and given support to Payroll, ESS, MSS, HR users.
• Worked with customers to analyze and resolve the Payroll related issue for multiple regions.
• Provided 24x7 support including on-call support to customers resolving their priority issues.
• Experience with Microsoft Service Manager for daily ticket resolutions.
• Created SQR's to pull applicant information from Taleo System Recruiting Application to Manager Hire process.
• Troubleshooting the problem areas in interfaces with Benefits programs, enrolling employees into Benefit plan BEN PROG PARTIC , calculating payroll deductions in producing Benefits reports which indeed worked on tables like LEAVE PLAN, SAVINGS PLAN, HEALTH PLAN, DISABILITY PLAN, LIFE ADD BEN.
• Extensively used PeopleCode, PeopleTools, Application Designer and SQRs during customization/Support.
• Used PeopleCode to control the program flow, logic and validation to meet the current business requirement. Written the PeopleCode in save edit, save post change, save pre change.
• Resolved numerous Payroll, HR and custom modules production issues.
• Documenting customer problem information, recommendations, and resolution
• Assisted technical team members during critical payroll runs.
• Generate Reports for users.
• To schedule the jobs and monitor the same.
• To solve all the issues and request raise by business users.
• Ensure that the Inbound and Outbound interfaces of the application are working fine
• Assisted in analyzing various Production Issues pertaining to XML Publisher, Integration Broker, PS Queries, etc.

Environment: PeopleSoft HCM 9.1, People Tools 8.51, Oracle Database

PeopleSoft HRMS/HCM Technology Analyst

Confidential

• The scope of the project involves support of PeopleSoft HRMS Module for Boeing on PeopleSoft version of 8.9.
• This includes smooth running of Interfaces, Enhancements and support activities including daily ticket resolution.
• Responsible for handling the complete payroll process's Pay Calendar, Pay Sheet, PayCalc, Pay check printing and involved in developing the customized payroll reports.
• Received client appreciation for quick analysis and timely bug fixing on critical issues.
• It involves a complete redesign of the system to support the changes to the discipline policy and to provide a user friendly system.
• Responsible for Requirements Gathering, Estimation, Technical Design, Development, Unit Testing and Implementation of the system.
• Developing new reports using SQRs.
• Helped users to test the system thoroughly and timely fixed the bugs before implementing the system.

Environment: PeopleSoft 8.9, People Tools 8.47, Oracle Database

PeopleSoft Technology Analyst and Developer

Confidential

• Worked for improving Asset Management business processes by moving towards more delivered processes and reporting.
• To drive out non-invasive customizations.
• Applied Asset Management patches on the existing environment.
• Involved in mitigation of data issues through root cause analysis and subsequent remediation.
• Move off-line assets into PeopleSoft 8.4 Asset Management system.
• Move toward IFRS Fixed Asset Reporting Requirements.
• Developing and implementing solution for Asset Componentization according in IRFS rules.
• Taken up the data cleansing of assets by resolving many issues though automated scripts and SQRs.
• Implemented new month end processes as per client's need and trained users accordingly .

Environment: PeopleSoft 8.4/8.9, People Tools 8.47, Windows NT, OS390, DB2 on OS390

PeopleSoft HRMS Technical Developer

Confidential

• Played key role in Development and Testing of Interfaces, Online Customizations and data conversions
• using SQR, People Code, Application Engine and Component Interfaces for PeopleSoft HR module.
• Extensively worked on Preparing Test scenarios and scripts and executing the test cases and code fixes.
• Worked on critical Interfaces and tested the interfaces thoroughly.
• Was part of data conversion team and developed batch programs to convert data from legacy system to Peoplesoft using application engine, file layouts and peoplecode.
• Worked on Application Engine, Peoplecode and Component Interfaces, Inbound/Outbound Interfaces ,SQR and queries.
• Development of Online pages, customizing PeopleSoft objects and Unit testing and preparing the test cases.

Environment: PeopleSoft HRMS V8.4 and V9.0, Crystal Reports XI, Oracle 9i, People Tools 8.47

PeopleSoft HRMS Technical Developer

Confidential

• Customized the existing interface programs for the HR to send flat files to various vendors for employees
• Developed and modified various interface SQR programs and reports in HR, Payroll and to meet the business requirements.
• enrolled in different medical and dental plans.
• Developed complex SQR program that creates multiple reports dynamically based on various parameters.
• Involved in modifying various online pages.
• Supported in Troubleshooting and fixing of batch processes for HR, payroll modules.
• Worked with Employee Self Service Module and Manager Self Service Modules.
• Extensively used People Tools for creation and modification of Process Definitions, Records, Pages,
• components to run Custom SQR's/AE through People Soft environment.
• Interacted with QA Team for conducting functional testing, regression and user acceptance testing for
• PeopleSoft HR, Payroll applications.
• Understanding project plans, templates, checklists and standards.
• Coordinating with the on-site team for requirement gathering.
• Analyzing the business cases and the critical production issues.
• Estimating the effort required
• Applying bundles and Tax updates to Development environment.

Environment: PeopleSoft HRMS V8.4 and V9.0, Oracle 9i, People Tools 8.47

PeopleSoft HRMS Technical Developer

Confidential

• Involved in detail design, development and testing .
• Analyzing the SQR Code and People Code and retrofitting the same.
• Analyzed requirements and applied customizations.
• Performing unit testing and System Integration Testing
• Created the Fields, Records, Pages, Components and Menus for customization as per the requirement.
• Created new Permission list and Roles for the specific business rules.
• Created and registered the Processes, associated permission lists and run SQR Program through PIA.
• Involved in Scheduling the Batch Programs to run periodically through the Process Scheduler.
• Developed Data Mover Scripts to move the data between the environments.
• Participated in migrating of project in different environments such as development, testing and production.
• Developed Unix Shell Scripts to run the SQR, App Engine Programs and for FTP of the generated Outbound files.
• Involved in extensive Data validation using SQL queries and back-end testing..

Environment: PeopleSoft 8.3/9.0, People Tools 8.49

PeopleSoft HRMS Developer

Confidential

• Trained employees at different levels in People Tools, SQR, design and development.
• Designed, customized and developed various PeopleSoft custom applications with different organizations to meet their standards and respective requirements.
• Involved in detail design, development, testing, conversions and modifications of the client as part of implementation.
• Designed, developed and implemented various conversion/interface programs starting from extracting data from Oracle Applications, designing the Flat File Layout by conducting Field Mapping, Fit/Gap Analysis by understanding both the systems.
• Developed programs using File Layout, Application Engine and People Code extensively for the Import and Export of flat files and XML files.
• Created Various SQR Interfaces Inbound Outbound and Reports to load data from external systems into PeopleSoft GL which in result conducts various Chatfield validations, Combo Rules, Trees, Derive various values based on the data from the external system.
• Designed, Developed various crystal reports across various modules for specific requirements.

Environment: PeopleSoft HRMS, Financials 8.4, People Tools, People Code, SR, Oracle 8i, Process Scheduler, Tree Manger, Unix Scripts, Security, Query Manager and Windows XP.