SUMMARY

• Over 8 Years of experience in PeopleSoft HCM/HRMS (Technical - 70%, Functional-30%) and Confidential Enterprise HRMS Ev5/Ev4
• Modules worked on HRMS/HCM( HR, Benefits, Payroll, Benefits Administration) and capable of working on all modules Technically.
• Management Activities: Experience in all phases of Software Development Life Cycle (SDLC). Provided Estimates or Work Break-Down Structure (WBS) based on teh Business/Functional requirements. Module Design & Build, Business System Testing, Performance Testing, End User Training/Documentation.
• Well versed with AGILE, Waterfall model, Project Management and Sarbanes-Oxley (SOX) rules.
• Functional Responsibilities/Activities: Requirements gathering, Functional gap analysis, application design, writing training guides, training end users and production support.
• Technical Activities: Solution Architect/Technical Lead/Developer: Interfacing with users, identifying functional and technical gaps, designing custom solutions, programming, leading developers both onsite & Offshore, scheduling, documentation, providing production support.
• Extensively worked on PeopleTools (Application Designer, PeopleCode, Application Engine, Component Interface, File Layouts, Integration Broker, XML Publisher, PS Query, Data Mover, SQR and Crystal Reports
• Hands on experience with PeopleSoft Process Scheduler, Oracle PL/SQL, Stored Procedures, Functions and Database triggers
• Involved in Upgrade, Implementation, Migration, Data Conversion, Interface Development of PeopleSoft Applications
• Involved in development and customization using Application Designer, Integration Tools, Reporting Tools, PeopleTools, Data Mover and SQL Scripts
• Analyzing and Applying Taxupdates and Bundles.
• Experience in applying PeopleSoft Updates(PUM), Patches Fixes, Tax Updates, Maintenance Packs
• Experience in Fit-gap Analysis, Design, Development, Coding, Testing, Bug Fixing, Applying Patches, Updates, Production Support
• Experience in Administering, Monitoring, Debugging, Troubleshooting and Performance Tuning of PeopleSoft Applications
• Worked intensively with Security Administrator to implement security in various levels. Involved in Creating Roles, Permission Lists, User Profiles, Portal Security, Folders, Content References and Definition Security
• Proficient in all phases of teh system development life cycle including requirements definition, data conversion, system implementation, Unit and System testing
• Experience in gathering requirements from business groups, writing technical specifications, coding and test plans
• Excellent verbal and written Communication Skills, interpersonal skills, good team player, quick learner

TECHNICAL SKILLS

• Application Designer
• Application Engine
• Security
• SQR
• Tree Manager
• Query Manager
• Integration Broker
• File Layout
• Crystal Reports
• App Messaging
• People Code
• Component Interface
• Process Scheduler
• PS Query
• Data Mover
• PUM
• XML Publisher/BI Publisher
• PeopleSoft HCM/HRMS Versions 9.2/9.1/9.0/8.9/8.8/8.3/8.0
• Windows 95/98/2K/NT/XP, UNIX
• Oracle 7x/8x/9x/10x/11x
• MS SQL Server

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Actively involved in all stages of Upgrade of PeopleSoft HCM application from version 9.0 to 9.2
• Involved in PeopleTools upgrade from .06 on HRMS 9.2
• Supported Integration, System, Performance and User Acceptance testing.
• Conducted multiple Fit Gap Analysis sessions and analyzed upgrade compare reports to identify and document existing customizations
• Involved in Retrofitting of several customized objects like Application Engines, People Code and SQR’s in teh process of upgrade
• Used PeopleSoft Update manager (PUM) to apply patches and updates and build PeopleSoft Image database on Oracle Virtual Box.
• Worked on Setup of Pay group Calendar, Payroll Groups, Employee Data and Payroll Extracts Processes in Test Environment.
• Co-ordinated cutover activities for final move to production.
• Run SYSAUDIT, DDDAUDIT, Alter Audit reports to identify integrity issues
• Developed Application Engine Program to upload Hire Information from data file into PS staging tables using File Layouts and PeopleCode, which will be further populated into Corresponding PS tables using Conversion SQR programs
• Modified existing report formats and developed XML Publisher reports using PS query
• Used Integration Broker to publish teh employee information from PS HCM to other application
• Designed and Developed Inbound Interface to import employee health care and benefit changes from third party benefit provider to PeopleSoft using Application Engine and Component Interface
• Developed Template/Custom Built Rules using Daily Threshold, Holiday and Guaranteed Hours and customized teh rules using SQL objects, actions and conditions
• Involved in changing search records to establish Row Level Security. Created Permission Lists, User Profiles to maintain Security
• Involved in post go-live production support.
• Supported Integration, System, Performance and User Acceptance testing.
• Designed and developed People Code to set up Workflow for Hiring and triggering events to mail teh new hire details to all administrators such as NA Payroll, Benefits
• Participated in on-going Production Support. Involved in teh debugging of errors and modifications to various objects related to HR, NA Payroll, Benefits modules.

Environment: PeopleSoft HCM 9.0/9.2 (HR, Benefits, Benefits Administration, NA Payroll, Time & Labor, ESS/MSS) People Tools, App Engine, File Layout, Component Interface, Integration Broker, SQR, PS Query, XML Publisher, Oracle 11g, Windows 2008

Confidential, Omaha, NE

PeopleSoft Technical Consultant

Responsibilities:

• As a PeopleSoft Developer, was involved in designing teh Payroll and Benefits Systems, Paycheck Generation, setting up of employee payroll data, calculating pay and customizing payroll and tax reports
• Used People Code to control teh program flow logic and validation to meet teh current business requirement
• Created Process definitions for Application Engine Program and run through teh Process Scheduler and also used Process Monitor to keep track of status of teh report
• Worked on performance related issues in AE programs using Managing Abends and Application Engine Debugging, Restarting Abended Programs
• Designed and developed teh Interface programs to move data from Mainframes to PeopleSoft tables using SQR as teh primary tools
• As a PeopleSoft Developer, was involved in designing teh Payroll and Benefits Systems, Paycheck Generation, setting up of employee payroll data, calculating pay and customizing payroll and tax reports
• Used ExcelToCI which is used to upload data from Excel into PeopleSoft using teh CI to execute business logic for each transaction
• Involved in parallel testing of different payroll processes by creating Pay Calendar entries and Pay Run IDs to combine different pay groups with same pay end dates
• Involved on all teh technical issues related to Application Customization and Reports/Interfaces
• Interacting with end users and helping them in any kind of production problems by fixing teh problems. Assisted customers with teh understanding of teh key payroll processes
• Involved in teh development of Pages, Components and Menus using PeopleSoft Internet Architecture
• Generated teh SQR reports, Interfaces and Process from teh scratch
• Involved in developing technical specification documents based on functional specifications. Documented various developed tasks for future guidance

Environment: PeopleSoft HCM 9.0(HR, Benefits, NA Payroll), People Tools, App Engine, File Layout, Component Interface, Integration Broker, SQR, PS Query, XML Publisher, Oracle 10g, Windows 2003, UNIX

Confidential

PeopleSoft Developer

Responsibilities:

• Extensively involved in upgrade of PeopleSoft HRMS v8.0 to v8.8
• Involved in teh retrofitting of SQR'S and Application Engine programs for 8.8 Upgrade
• Analyzed SYSAUDIT and DDDAUDIT report to fix orphaned objects and inconsistencies
• Created and maintained documentation of all changes in teh upgrade process
• Participated in teh daily meetings to discuss teh status of issues with teh user groups
• Troubleshooting of day to day production support problems from technical as well as functional perspective for teh business processes
• Analyzed teh existing Applications and evaluated teh customization involved in teh Development, Upgrade and Testing of all teh HR, Benefits, Payroll and Time and Labor interfaces as a key team player of teh Interface team
• Custom designed delivered Pages, Components as per teh required functionality
• Used Application Engine program, its related objects like State and Temp record, File Layouts and PeopleCode for extracting data, validating data, creating outbound files and other processes like updates and insertion of data into various tables
• Established teh connections between PeopleSoft and Third-Party systems for bi-directional data flow using PeopleSoft Component Interface Framework and PeopleSoft Application Messaging Manager
• Used teh Upgrade Assistant tool to guide in upgrade process by creating and running jobs in sequence as listed. Involved in running and reviewing teh compare reports to override or keep teh custom objects from version 8.0. Teh new release objects were copied from 8.8 databases to teh Copy of Production databases
• Applied Patches and Fixes to Time and Labor modules and Modified Time and Labor reports
• Involved in online changes like adding customized-translated values, modifying PeopleCode, adding fields to record definitions and pages. Involved in unit testing. Coordinated with developers, users and testing team in specifically implementing teh business requirements and customization into PeopleSoft application
• Conducted meeting with users to understand teh business requirements and produced user documents. Worked with business users to execute teh test cases and verify teh test results
• Created test cases, scripts and test results in all teh testing phases from unit testing through system testing
• Analyzed and applied one-offs (PL/IR) and tax update bundles.

Environment: PeopleSoft HRMS 8.0/8.8 (HR, Benefits, Time & Labor, NA Payroll), PeopleTools 8.42, Application Engine, PS Query, SQR, Oracle 10g, Windows NT 4.0

Confidential

PeopleSoft Technical Developer

Responsibilities:

• Used People Code to control teh program flow logic and validation to meet teh current business requirement
• Created Process definitions for Application Engine Program and run through teh Process Scheduler and also used Process Monitor to keep track of status of teh report
• Worked on performance related issues in AE programs using Managing Abends and Application Engine Debugging, Restarting Abended Programs
• Designed and developed teh Interface programs to move data from Mainframes to PeopleSoft tables using SQR as teh primary tools
• As a PeopleSoft Developer, was involved in designing teh Payroll and Benefits Systems, Paycheck Generation, setting up of employee payroll data, calculating pay and customizing payroll and tax reports
• Involved in parallel testing of different payroll processes by creating Pay Calendar entries and Pay Run IDs to combine different pay groups with same pay end dates
• Involved on all teh technical issues related to Application Customization and Reports/Interfaces
• Interacting with end users and helping them in any kind of production problems by fixing teh problems. Assisted customers with teh understanding of teh key payroll processes
• Involved in teh development of Pages, Components and Menus using PeopleSoft Internet Architecture
• Generated teh SQR reports, Interfaces and Process from teh scratch
• Involved in developing technical specification documents based on functional specifications. Documented various developed tasks for future guidance
• Analyzed and applied one-offs (PL/IR) and tax update bundles.

Environment: PeopleSoft HRMS 8.3 (HR, Benefits, NA Payroll), PeopleTools 8.15, Application Engine, SQR, Oracle 8, Windows NT 4.0

Confidential

PeopleSoft Developer

Responsibilities:

• Involved in teh Review of teh upgrade process manuals, participated in teh preparation of assessment plan for teh upgrade, creating and configuring copy of teh Production Database and identification of teh customizations necessary for teh upgrade.
• Ran vanilla compare reports between our copy of production and demo database to identify all teh customizations.
• Documented teh impacted Records, Record fields, Panels and Components to implement existing functionality, which was in teh Version 8.3.
• Developed People Code to in corporate specific requirements while Upgrading Version 8.3 to 8.9.
• Created Run control Pages, Component, attached them to required menus through Application Designer and made them available to various operators through Maintain Security.
• Modified Custom 8.3 SQR’s into PeopleSoft 8.9 version standards as per field name and record name changes.
• Retrofitted delivered SQR's/SQC’s for reporting with additional parameters and customized SQC files as per teh Client Requirements.
• Analyzed and applied one-offs (PL/IR)/bug-fixes.

Environment: PeopleSoft HRMS, People Tools, People Code, SQR, PS Query, Oracle 9x

Confidential

PeopleSoft Developer

Responsibilities:

• Customized and Implemented People soft applications and developed various reports using PS Query and SQR
• Testing & Deployment of various complex reports using SQR.
• Worked on Application Engine Programming to run teh background SQL process and creating outbound interfaces.
• Performed Internal Reviews to ensure quality of AE and SQR programs.
• Created SQL Views to optimize our Query performance and used views as search records.
• Involved extensively in Technical Documentation of Implementation.
• Designed and developed PeopleSoft objects such as Menus, Components, Pages and Records using teh Application Designer and modified teh existing objects like Components, Pages, Records and Menu definitions.

Environment: PeopleSoft HRMS, People Code, SQR, PS Query, People Tools, Oracle 9x