PROFESSIONAL SUMMARY:

• Around 4 years of Extensive IT experience in Implementation and Upgrade of PeopleSoft HRMS/HCM applications covering HR, Payroll, Talent Acquisition Management, Absence Management, Talent Management, Manager Self Service (MSS), Employee Self Service (ESS), Benefits and Benefit Administration modules.
• Experience in all phases of SDLC which includes Analysis, Design, Implementation, Testing and Maintenance of Business Application Systems, experience working in Agile environment.
• Excellent working knowledge in peopletools, Application Designer, PeopleCode, Application Packages, Application Engine, Process Scheduler, SQR, Component Interface, Integration Broker, AWE, PS query and SQL Programming.
• Involved in the fit - gap analysis and implementation requirements gathering.
• Created Specification Documents, Detailed Design Documents, Test Plans and User Manuals.
• Expert at not only customizing delivered PeopleSoft applications, but also creating components, pages, Application Engine programs and SQRs from scratch to meet the business needs.
• Well-versed with delivered PeopleSoft objects and backend table structures.
• Strong Data Migration / Conversion experience from legacy systems to PeopleSoft systems.
• Expertise in using SQL tools with SQL Performance tuning experience.
• Loaded data from flat files to PeopleSoft tables using App. Engine/SQR programs and SQL scripts.
• Experience in creating interfaces with-in and outside of PeopleSoft applications using Integration Broker, Application Messaging, Component Interfaces, Application Engine programs and SQRs.
• Expert in preparing complex reports using SQR, PS Query and Crystal reports.
• Good understanding of databases and client-server architectures.
• Certified by Oracle as PeopleSoft peopletools Enterprise Developer Certified Expert.
• Excellent debugging and problem-solving skills, Worked in primary Production Support role.
• Provided estimated work efforts and development deadlines.
• Experienced in handling multiple tasks at a time emphasize on timely delivery of my deliverables.
• Good communication and inter-personal skills. Quick learner and a good team player.

TECHNICAL SKILLS:

Functional Areas/ Application (ERP): PeopleSoft HRMS/HCM 9.2/9.1/8.9/8.8 (HR, Payroll, AM, TAM, Talent Mgmt., ePerformance, MSS, ESS, Benefits, Benefit Administration modules, Succession Planning, ePay, eProfile, Time & labor)

PeopleSoft Technical/ Development Tools: Application Designer, People Tools 8.54/8.52/8.51/8.50/8.49/8.48/8.46/8.42 , PeopleCode, Application Engine, File Layout, Component Interface, PS Security, Portal, Process Scheduler, SQR, Crystal Reports, PS Query, Tree Manager, Data Mover, Application Messaging, Integration Broker, BI Publisher/XML Publisher, Workflow, AWE, Upgrade Assistant.

Reporting Tools: SQR, Crystal Reports, PS Query and Data Reports.

SQL Tools: TOAD, SQL Plus, Oracle SQL Developer.

RDBMS: Oracle, MS Access, SQL Server, DB2, MySQL.

Operating System: UNIX, WINDOWS XP/NT/98/2000 and MS DOS.

PROFESSIONAL EXPERIENCE:

Confidential, Minnetonka, MN

Peoplesoft Technical Developer

• Worked on upgrade from PeopleSoft 9.1 to 9.2, Fluid User Interface and Oracle Secure Enterprise Search (SES), customized batch processes and online pages.
• Worked closely with business to determine their needs, analyzed them and converted the functional needs into technical requirements.
• Created design and technical specification documents, test cases and user manuals, Provided work effort estimates and deadlines.
• Generated and compared reports between 9.1 & 9.2 and involved with business in keep/drop decisions.
• Retrofitted several customized objects like Records, Pages, Components, peoplecode.
• Designed and developed custom Self Service and administrator pages to meet client specific needs, which includes Absence History page with the ability to edit and delete absences.
• Customized peoplecode on different events, libraries and Application packages to implement validations and control of the program flow, generated custom notifications.
• Created custom records, pages and components, registered the components, created portal definitions and provide security using permissions lists, customized portal objects.
• Designed and developed batch processes and interfaces, knowledge on field and code mapping.
• Created interfaces between PeopleSoft HCM system and third-party vendor.
• Created Application Engine (AE) process to load UHG claims using absence event CI. Also, created payroll interface to load earnings and offsets for the STD and LTD payments from UHG.
• Designed and developed a custom Application Engine process that runs as part of payroll flow to fix negative pay checks due to unpaid absences, to apply payments from UHG, to make deductions for retro unpaid absences and UHG offsets.
• Used rapid entry Paysheet CI, PSHUP table to update the paysheets.
• Supported payroll runs and worked on issues related to payroll both in test and production.
• Created process definitions, run control pages and ran processes from process scheduler.
• Developed reports using SQR that give information about time not reported, time that needs approval, time that is over 8 hours per day and time that uses holidays.
• Created online reports for UHG claims, Payroll Interface and unprocessed absence process (holding tank) for administrators to monitor, make fixes and skip/reprocess rows that are errors.
• Created MSS reports using BI/XML publisher.
• Generated complex reports using SQRs/PS Query, written SQL scripts for data load and cleanup.

Environment: PeopleSoft HCM 9.1/9.2, People Tools 8.52/8.54, Linux, Oracle 11g, Application Engine, SQR, PS Query, Component Interface, Integration Broker , BI/XML Publisher, Toad 10.1, WinSCP, HP Quality Center 11.

Confidential

Peoplesoft Technical Developer

• Worked with clients and functional team during Requirements Analysis, Design phases and fit-gap analysis.
• Created technical design documents from the functional designs and requirement documents.
• Worked on interfacing PeopleSoft System with third party vendor, which handles the commuter benefits.
• Wrote SQR processes to load PeopleSoft general deduction tables with commuter benefits data from Hewitt.
• Configured general deduction and payroll settings to handle the commuter benefits.
• Ran payroll for both hourly and salaried employees (execs) to test Commuter Benefit deductions are taken out correctly and configured and tested arrears processing.
• Added new actions and action reasons to handle leaves based on the client needs.
• Modified online pages, peoplecode, SQR processes and reports to reflect the new action and action Reason changes.
• Worked on enhancements to Kronos (time reporting system) interfaces to PeopleSoft System.
• Created pay adjustment processing SQR and tied it online to a custom run control page to run the process through the process scheduler.
• Created processes that generate various personal data, job data, location data and other HR information files to send them to third party vendors Earnest &Young (E&Y), Sedgwick and Hewitt.
• Developed and modified JCLs to run the SQRs, Process Scheduler, FTP files and back up files.
• Customized online pages, wrote peoplecode, created new tables and views to meet the client needs.
• Supported existing PeopleSoft HR, Payroll, Absence Management and Benefits modules.
• Handled Security related issues for certain roles & giving department level security through Tree Manager.
• Co-ordination of the work with onshore development team and conducting conference calls.
• Interacting with users and preparation of relevant documents.

Environment: PeopleSoft HCM, People Tools (Application Designer, APP Engine, People Code, Component Interface, Workflow, Integration Broker, XML Publisher, Oracle 9i, DB2, SQR, UNIX).