SUMMARY

• 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, 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.
• Extensive experience in designing, development, fit gap analysis and requirement gathering of enhancements to existing requirements for consolidation
• Troubleshooting of COBOL,SQL processes like PSPPYBLD, PSPPYRUN, PSPCNFRM by performing various audits
• Requirement gathering for Data conversion from Oracle fusion to Peoplesoft.
• Requirement gathering for Data conversion from PeopleSoft to Work Day.
• Analyzing the Workday functionality.
• Comparing Workday and peoplesoft.
• 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 s and Definition Security.
• Data analysis in PeopleSoft HRMS and developing reports using PSQuery.
• Analyzing the custom functionalities in PeopleSoft
• 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 .

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 EXPERIENCE

Lead PeopleSoft HRMS/HCM Senior System Analyst

Confidential, MI

Responsibilities:

• Design and review of Business Solution document, High level design and detailed designed documents.
• 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 business requirements.
• Involved in developing the SQRs for benefits and payroll out bound interfaces.
• Responsible for handling the complete payroll process’s (Pay Calendar, Pay Sheet, PayCalc, Pay check printing) and involved in developing the customized payroll reports.
• Data analysis in PeopleSoft HRMS and developing reports using PSQuery.
• Analyzing the custom functionalities in PeopleSoft
• Comparing Workday and peoplesoft HRMS functionalities
• Responsibility included requirement Gathering, Analysis,Design and Estimation.
• Creating complex SQL to retrieve the data from PS..

Environment: PeopleSoft HRMS 9.1/9.2, People Tools 8.51/8.53, Windows NT,UNIX, Oracle Database

Senior PeopleSoft HRMS/HCM Technology Lead

Confidential, Boston, MA

Responsibilities:

• 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 Oracle fusion HCM.
• Data analysis in PeopleSoft HRMS and developing reports using PSQuery.
• Analyzing the custom functionalities in PeopleSoft and integrate with oracle fusion.
• Comparing Oracle HCM fusion 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 Peoplesoft.
• 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 Analyst

Confidential, Pheonix,AZ

Responsibilities:

• 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 Analyst

Confidential, St Louis,MO

Responsibilities:

• 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, Houston,TX.

Responsibilities:

• 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, Renton, WA.

Responsibilities:

• 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

Junior PeopleSoft HRMS Technical Developer

Confidential

Responsibilities:

• Developed and modified various interface SQR programs and reports in HR, Payroll and to meet the business requirements.
• 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. 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