SUMMARY

• 7 years of IT experience of working in diverse PeopleSoft Technical and functional areas which include PeopleSoft HRMS/HCM applications.
• Proficient in complete PeopleSoft Implementations involving, Requirements analysis, Fit - Gap-Analysis, Specification, Design, Development, Conversions, Upgrade, Maintenance and Performance Tuning.
• Strong Functional and Technical noledge of various modules in PeopleSoft HCM/HRMS such as Human Resource, Payroll, Benefits, Benefits Administration, Absence Management, Employee Self-service (ESS) and Manager Self-service (MSS).
• Well conversant wif documentation for specifications, developing test cases, technical design and writing training manual for end users.
• Expert Knowledge of People Tools in implementation, customization, upgrade and maintenance of HR, Benefits, Benefit Admin, Payroll, Absence Management and Self Services modules (eRecruit, ePay, eProfile, ePerformance, eCompensation and eBenefits).
• Extensively worked on People Tools, People code, Application Designer, SQR, Maintain Security, Object security, Tree Manager, Process Scheduler, Component Interfaces, Data Mover, Application Messaging, Application Engine, Workflow, Component Interfaces, Integration Broker etc.
• Expertise in PeopleSoft Internet Architecture (PIA) and Open Integration Technology tools Application Engine, Component Interface, Approval Workflow Engine and Approval Framework.
• Extensively used reporting tools such as PS Query, SQR, XML Publisher, Crystal Reports and nVision to continually improve the reporting experience for the user base.
• Developed new SQR’s from scratch to meet the customer requirements and supported the customization. Developed and modified Outbound and Inbound SQR interfaces
• Built Application Engine processes for ensuring data integrity and third-party interfaces and was involved in performance tuning of the Application Engine Programs using Traces.
• Extensively worked on implementing updates/fixes and upgrades for PeopleSoft applications and People Tools.
• Worked individually, as well as in team environment, to achieve project goals.
• Skilled at building a strong team environment, and has the ability to acclimatize to new technologies and situations wif ease.

TECHNICAL EXPERIENCE

ERP: PeopleSoft HRMS/HCM 9.2/9.1/9.0/8.9/8.8 (Core HR, Payroll, Base Benefits, Benefits Administration).

Development Tools: Application Designer, People Code, Application package, Portal Utilities, Application Reviewer, Workflow, Application Engine, Component Interface, Process Scheduler, Tree Manager, Data Mover, Change Assistant.

Administration Tools: Configuration Manager, Process Scheduler, Process Monitor, Upgrade Assistant, Security Administrator and Utilities.

Integration Tools: Integration Broker, File Layout, Application Engine & Component Interface.

Reporting Tools: XML Publisher, SQR, PS Query, Crystal Reports, Query Analyzer 8.0.

Programming Languages: PeopleCode, PL/SQL, C, C#, JAVA, VB and HTML.

Database: Oracle 9i, 10g/11g, MS SQL Server, MS access, MySQL.

Operating Systems: Windows 10/9/8/7/XP/2000/NT/98/95.

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

Sr. PeopleSoft Techno-Functional Developer/Analyst

Roles and Responsibilities:

• Involved in requirement gathering, fit-gap analysis, design, development, Testing and documented processes.
• Involved in running and analyzed Upgrade Compare reports to identify and document existing customizations.
• Used People Tools in carrying over the customizations from the existing version to new upgrade version. Extensively used Application Designer for creating new objects, modifying the existing customizations and bringing them over successfully into 9.2.
• Resolved a security issue where row level security functionality was no longer available after the application was upgraded.
• Developed a batch Application Engine which uses Component Interface to load General Deductions and Garnishments for each employee to reflect the company changes.
• Customized the eBenefits module according to functional requirements so dat the employee has the ability to review and update benefits information online.
• Created new SQR Programs to update Annual Base Salary, and to add new Benefit programs, Plan, Plan Types and automated Benefit Admin Process.
• Involved in creating of Task Groups and establishing Time Periods, Calendars, Shifts, work schedule templates and work groups..
• Worked on setting up HSA and FSA Retirement Benefits.
• Developed Application Engine Process to Evaluate Retirement Indicators based on Employees Birth & Service Dates.
• Modified 401K Interface to change the employee company.
• Retrofitted Integration Broker Service Operations including Routing configuration and Handler People code.
• Implemented online and batch customizations in Payroll, HR, Benefits and Benefits Administration modules as per functional requirements..
• Created an App Engine, XML Publisher report for new hire reporting purposes which captures all New Hires & Rehires whose Hire/Rehire date is wifin the Pay Period Begin and Pay Period End Date. The report also compares the current and previous Pay Run ID’s to determine if the employee has gross earnings currently; but had not wifin the last 60 days.
• Developed new queries using XML Publisher to replace some existing SQRs.
• Effectively utilized tools and utilities provided by PeopleSoft (Debugger, tracing etc.) for trouble shooting issues on PeopleCode, Application Engine, COBOL, SQR’s.

Environment: PeopleSoft HCM 9.0/9.2,PeopleTools 8.49/8.54, Oracle 10G, Windows NT. (People Code, Application Engine, Component Interface, SQR, XML Publisher)

Confidential, St. Louis, MO

Sr. PeopleSoft Techno-Functional Consultant

Responsibilities:

• Retrofitting of both online and batch objects, (me.e., pages, fields/records, modified PeopleCode, SQR, Application Engines, Component Interface, Application package etc.) through patch application and/or application development.
• Involved in Fit Gap analysis of the upgrade project.
• Customized PeopleSoft delivered transcripts and Application Engine Program to meet Client requirements.
• Created new templates and sub templates for Hospitals requirements.
• Developed new Application Engine Program and Component interface for inactive employee process.
• Involved in working on Approval Workflow setup.
• Involved in gathering functional requirements.
• Retrofitted AWE customizations.
• Setting up configurable sections for extended absences & approvals wif absence management.
• Customized workflow Message Notification Templates.
• Participated in Design meetings, code reviews and implemented Technical Design documents.
• Modified the Roll prior term’s schedule program to copy the facility information.
• Developed new interface using Integration Broker to publish messages when the vendor information is updated.
• Verified SYSAUDIT and DDDAUDIT reports and fixed the errors.
• Involved in modifying the custom SQR reports and developing new SQR reports.
• Involved in writing new XML Publisher reports for their needs.
• Developed outbound interfaces PeopleSoft HR Vendor information using Web services, Integration Broker.
• Involved in Preparing design document & technical specifications.
• Involved in preparing the change control package, implementation log for production moves.
• Involved in Preparing Test Plans & Executing the Test Cases for Unit, System testing.

Environment: PeopleSoft V 9.0 (HR, Payroll, Benefits, Self Service), People Tools - 8.49, People code, SQR, UNIX, COBOL, Oracle (TOAD, SQL*plus).

Confidential, Chicago IL

PeopleSoft Technical Consultant

Responsibilities:

• Conversion and implementation of PeopleSoft 9.1 (HR, Payroll, Benefits, Self Service).
• Involved in requirement analysis sessions for health & welfare, 401k, Total rewards projects.
• Worked wif functional analysts in gathering the requirements for converting the third party vendor interfaces according to requirements.
• Involved in Taleo data migration to load data from excel sheets to load it into oracle database.
• Designed & Developed an SQR process to read the payroll instructions files for a third party vendors called Hewitt & Travelers into PeopleSoft module.
• Designed & Developed an SQR process to write a third party vendor outbound interface as per Hewitt, Traveler & Mass Mutual vendors as per their file layout formats, which contains amounts dat has been deducted from their salary towards their deductions as and when payroll runs.
• Designed & Developed an SQR to generate salary & Incentive Database file from PeopleSoft for ecomp module.
• Involved in customizing workflow for self-service modules.
• Conversion of COBOL programs to SQR’s and App Engines.
• Involved wif Functional Analysts to design & develop an SQR processes to process roll over plan in savings plan module when an employee hits their maximum contribution limit as per client business requirements.
• Involved wif Functional Analysts to develop several data migration sqls to compare the before and after converted data between Tessreact legacy system and PeopleSoft system.
• Developed ecomp statement custom pages as per new business requirements.
• Modified custom eligible pay compensation app. engine to incorporate new business requirements.
• Involved in Benefits annual enrollment project to modify batch interface programs as per functional requirements.
• Worked wif external providers to understand interface requirements and deliver solutions to meet those requirements
• Responsible for converting interfaces into PeopleSoft from legacy Tesseract system using SQR’s.
• Involved in ExcelToCI process to load the rapid entry data into PeopleSoft environment.
• Involved in preparing the change control package, implementation log for production moves.
• Involved in preparing NDM Unix Scripts and Auto sys Jill scripts for newly developed batch interfaces.
• Involved in Preparing design document & technical specifications.
• Involved in Preparing Test Plans & Executing the Test Cases for Unit, System testing.

Environment: PeopleSoft v9.1 (HR, Payroll, Benefits, Self Service), People Tools - 8.50, People code, SQR, UNIX, COBOL, Oracle(TOAD,SQL*plus), Serena Change Control, Tesseract.

Confidential, Ewing Township, NJ

PeopleSoft Technical Consultant

Roles and Responsibilities:

• Designed Technical specifications and Developed new objects, Student detail Reports and Customization of vanilla Reports, Objects as per the Business process requirements and End User / Client requirements.
• Involved in writing Interface programs, Data Conversion programs and Key reports for HR and Benefits modules. Setup Workflow rules and roles, wrote queries. Also modified pages and panels according to the user’s requirements.
• Worked wif functional analysts and collected data requirements for Conversion and Interface programs.
• Executed test plans to cover from the initial acceptance of employee time from the third party to pay sheet creation by the custom modules. Modification and Customization using Application Designer and PeopleTools.
• Developed Conversion programs using App Engine, File layout and Component Interface to load data from the Legacy system to People Soft HEALTH BENEFIT Table, LIFE ADD BENTable, SAVINGS PLAN Table, LEAVE PLAN Table, and LEAVE ACCRUAL Table.
• Customized various components/pages in the areas of Job Data, Job Entry application engine programs and other SQR programs in HR and Payroll Modules.
• Devised, Documented, Implemented Security features (Page, Processes, Definition Security, and Data security) for all modules.
• Developed Application Messaging to poll Job data from legacy system.
• Wrote validation SQL for Payroll interfaces to provide new organization structured Payroll related data to the ProBusiness such as Deduction data, Direct Deposit data, Earnings data etc.
• Extensively worked on Approval Workflow Engine in transfer, Overtime and Regularization Process.
• Involved in setting up the rules and roles and routings for the various Workflow E-Mail notifications such as marital status change, reporting change, Benefits enrollment notification, dependent benefits info change in collaborative applications.
• Created Interfaces using Application Engine, Component Interface and File Layout to create User profiles depending on the employee information in a flat file.
• Implemented Sign-on security, Row-level security, Field-level security, Object-level security to control application security using Administrator and Object Security.
• Developed an Application Engine program, which loads employee data for multiple Business Units from flat file via Component Interface. Various data validations are performed using Application Engine PeopleCode.
• Developed Custom Workflow to notify Managers, Leave Administrators after running time admin where an employee’s reporting time has leave TRCs.
• Requirement gathering, analysis and estimation.
• Global Payroll support and Enhancement for India, Mexico and China Payroll.
• Bulk upload utility for data and Third party Interface Integration using Encryption and decryption using Application engine, SQR and shell script.
• Global Payroll Bundles and Tax Updates for country Extinction payroll, Compare and retro fitting.
• UAT- User interactions and assigning of the tickets to the team.
• Analyzing Issue and Providing Root cause and provide Solution.
• Quality Standard Documentation for each task, User Manual and check List for Business User.
• Generating Status Report using Salesforce application and following SLA timeline.

Environment: PeopleSoft 9.1 HRMS (HR, Payroll, Benefits), People Tools 8.50/8.51, SQR, Application Designer, Application Engine, Windows, and Oracle 10i.