PROFESSIONAL SUMMARY:

• Over 8 years of experience in PeopleSoft, includes gathering user requirements, Systems Analysis, Fit - Gap-Analysis, Design, Implementation, Upgrade, Development, Testing, Production support for Client Server and ERP applications.
• Expertise in PeopleSoft Implementation, Maintenance, Upgrading, Interfacing/Reporting, Troubleshooting and Production support.
• Strong PeopleSoft analytical experience in HR, Base Benefits, NA Payroll, NA Payroll Interface, Benefits administration, Time and Labor, Employee Self-Services, Manager Self-Services, Enterprise Learning Management (ELM)and complete understanding of complete project life cycle.
• Strong PeopleSoft technical skills including PeopleTools (Application Designer, PeopleCode, Application Engine, Component Interface, Process Scheduler, Component Interface, Workflow, Data Mover, Security Administrator and Security), Integration Broker, XML Publisher, SQR, and Crystal Reports.
• Experience in developing interfaces, reports, and processes using Component Interface, File Layout, Application Engine, SQR and PeopleCode development.
• Extensive experience in Tableau architecture, designing, developing and publishing visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making. 
• Expertise in the development of Interface applications by creating PeopleSoft objects such as fields, records, page, component, grids and menus.
• Expertise in PeopleSoft Internet Architecture (PIA) and Open Integration Technology Tools Application Engine, Component Interface, Approval Workflow Engine and Approval Framework, PeopleSoft Update Manager(PUM).
• Expert in design and setup of PeopleSoft Security through creation of Roles and Permission lists creation of client Query tree and Query access groups.
• Experience in testing and issue resolution during the parallel test and the postproduction support.
• Excellent management and documentation skills.
• Proven ability to work in a team as well as individually in various projects.

TECHNICAL SKILLS:

ERP: PeopleSoft HRMS/HCM 9.2/9.1/9.0/8.9 (Core HR, Payroll, Global Payroll, Performance Management, Time & Labor, Benefits, Benefits Administration, Absence Management, Compensation, Profile Management, ESS & MSS).

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

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

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

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

EXPERIENCE:

Confidential, Philadelphia, PA

Sr. PeopleSoft Technical HCM

Responsibilities:

• Retrofitted multiple Interface Programs in Core HR, Time & Labor and NA Payroll Modules during Upgrade from Version 9.0 to 9.2.
• Prepare the Compare report analysis after identifying the objects to be carried forward to 9.2 and objects to be dropped from carrying forward.
• Retrofitted multiple Custom template built rules.
• Retrofitted multiple agencies custom Time and Labor Auto enrollment application engine Programs.
• Customized number of existing SQR’s/PS Queries/Crystal Reports etc. to suit the Business requirements. Worked on SQR’s to bring them in sync with the new features brought in PS 9.2.
• Modifying, Compiling and Running Payroll Batch Processes.
• Developed Technical Design documents for the existing reports identifying the retrofits to be made to run them in 9.2.
• Customized the View Pay Check functionality.
• Connected  Tableau  server to publish dashboard to a central location for portal integration. 
• Connected  Tableau  server with share-point portal and setup auto refresh feature.
• Created dashboards using  Tableau  Desktop and prepared user stories to create compelling dashboards to deliver actionable insights.
• Retrofitted Enhancements, build new and retrofitted existing interfaces to support to extract and load HR/ NA Payroll Data for Internal and External interfaces and also load data into PeopleSoft HR/Payroll tables.
• Participated in fit/gap analysis of an Integrated NA Payroll and Benefits System.
• Performed Performance Tuning on Time and Labor’s Time Administration processing and resolved Time and Labor production issues.
• Responsible for retrofitting the interface programs for NA Payroll and Benefits with Vendors and customizing delivered functionality according to Client.
• Modified SQR s and online pages according to new Version Changes as per the business requirement.
• Worked on interfaces with Kronos time keeping device and time & labor.
• Retrofitted Custom Time and Labor Interface application engine program that loads data from the flat files sent by various different Time Keeping Systems into PeopleSoft Reported Time table.
• Retrofitted multiple Payroll PeopleSoft Queries, SQR’s and XML publisher Reports.
• Created Security Roles and Permissions for end users in PeopleSoft, gave specific security access to supervisors to enter, approve and process reported time.
• Resolved tickets on priority basis and attend calls with functional team for early resolutions.
• Performed an inventory of existing Time and Labor rules and identify and document the rules that need to be modified for Version 9.2.
• Primary Support for Time and Labor and NA Payroll Modules during User Acceptance Testing and after Upgrade go-live.

Environment: PeopleSoft 9.0/9.2 (HR/ELM), Benefits, Payroll, TL, People Tools 8.55, App Designer, People Code, Application Engine, PS/Query, Application Messaging, Data Mover, Crystal Reports, SQR.

Confidential, Oakland, CA

PeopleSoft HCM Developer

Responsibilities:

• Developed Application Engine programs to export Personal Data - Name, date of birth and address information to flat files using File Layout.
• Developed Conversion Application Engine programs to export Job Data information to flat files.
• Developed programs to extract setup information Departments, Job Codes, Locations, and Department security to flat files to send to SAP.
• Compared the exported information from PeopleSoft to the imported information to data dumps from SAP.
• Involved in analyzing the Data Errors that occurred when offcycle NA payroll is run and fixed those Issues.
• Developed and maintained Manual Checks Detail Report. This report is intended to provide complete details of the manual checks issued in a pay cycle.
• Developed a custom Application engine program using Component Interface to create User Profiles in HR for all employees based on their location.
• Customized and Printed SQR Report ‘Tax910PR’ for the layout of W-2 forms as per the client requirement.
• Developed data mover scripts (DMS) to migrate Rules, SQL Objects, Messages and Message Catalogs, and Exceptions.
• Developed workflow to automate the notification for the employee about the open enrollment dates and changes occurred in the benefits and NA payroll rules.
• Configure, troubleshoot and Support all the tables involved in NA Payroll processing like Pay calendar, Job Code, Deductions and processes such as Pay Sheet creation, Pay Calc, Pay Confirm, Tax Tables etc.
• Reviewed client data and prepared Data Mapping for File Layouts from legacy to PeopleSoft formats.
• Produced PDF and spreadsheets report formats for HR by creation of SQR processes.
• Migrated customized objects from Development to Test Instances using STAT.
• Composed Queries and Crystal Reports for generating reports for modules HR, Benefits, Time and Labor.
• Handled security related issues for certain roles and also gave department level security through Tree Manager.
• Worked on various queries to provide information for TPIA requests.

Environment: PeopleSoft HRMS/ELM/CRM 9.0 and People Tools 8.52 (App Designer, People Code, Application Engine, Component Interfaces, App Packages, AWE, XMLP), SQR, MS SQL Server

Confidential, Albany, NY

Sr. PeopleSoft Consultant

Responsibilities:

• Gathering requirements from functional users to implement Time and Labor for Hourly and Exceptional Hourly employees.
• Setup Time Periods including Daily, Weekly, Bi-weekly and Monthly and Build Time Period Calendar.
• Worked extensively in setting up Shifts, Workdays, Templates and creating Schedule definitions, building Schedule Calendars and Assigning Work Schedule
• Closely worked with Functional teams for Semi-monthly to Biweekly payroll conversion.
• Fit-gap and impact analysis for the semi-monthly to biweekly conversion.
• Setting up core payroll tables like paygroup table, pay calendar table, run id table for biweekly payroll cycles.
• Customized various payroll, benefit inbound and outbound processes as a part of biweekly conversion.
• Developed custom conversion programs using SQRs and App Engines to load legacy data into payroll and benefit tables.
• Developed custom SQRs to merge the paylines split in multiple paygroups due to mid-week transfers.
• Involved in applying tax updates, retrofit changes, unit testing the on and off cycle payroll processing before and after applying the tax updates.
• Extensively worked on ESS and MSS for customize the timesheet audit page, Leave Request pages for Managers and Delegates.

Environment: PeopleSoft HR 9.1, People Tools 8.51, Taleo, People Code, App Designer, Application Engine, ELM, PS/Query, SQR, Oracle 11g, ODI, SQL, PL/SQL Oracle APEX, Windows 2003/XP/7.

Confidential, Boston, MA

PeopleSoft Techno Functional Consultant

Responsibilities:

• Involved in Pre and Post production support of HR modules like Global Payroll, Absence Management, Benefits and ESS/MSS.
• Reviewed Technical design documents, Test Case Plans for Absence Management.
• Involved in applying the patches and bundles to the existing system.
• Implemented Delegation and Block out Functionality for absence management.
• Closely working with the business for gathering the requirements.
• Migrated Projects between different environments, Applied the patches and bundles.
• Fixed the issues due to patches and bundles, issues during UAT, System and Integration Testing.
• Prepared the end user training documentation for new functionalities.
• Involved in end to end implementation.
• Developed 9-box functionality
• Designed Delegation and Lock-down functionality for talent.
• Implemented Succession planning for the key positions.
• Developed new Records, Online Pages, and Run Control Pages using People Tools for the specific needs of the client, implemented People Code for online validations.
• Design and developed the applications with Application Designer, Application Engine, People Code, Component Interface and Workflow.

Environment: PeopleSoft HCM 9.0 (HR, Payroll, Absence Management, Benefits, Self Service), People Tools - 8.50, People code, SQR, UNIX, LINUX, COBOL, Oracle (TOAD, SQL*plus).

Confidential, Bloomington, IL

PeopleSoft HCM Developer.

Responsibilities:

• Involved in full development life-cycle and new implementation of PeopleSoft HCM 9.0.
• Collaborated with various resources during meetings to discuss business requirements.
• Analyzed, designed and created technical specifications for Data Conversions.
• Applied Tax Updates for the fiscal year 2009 using Change Assistant.
• Developed conversion programs to convert the data from the legacy system to HR, Benefits and Payroll tables.
• Involved in running a NA payroll error tracking report before and after pay confirmation to debug payroll errors.
• Verify the configuration changes by running the BenAdmin to create OE event for all the EE’s. Make changes to the benefits of the test Emplid’s and run the BenAdmin followed by customized confirmation page process BAS005.
• Customized delivered Open Enrolment Confirmation Form BAS005, and developed online confirmation form to provide employees the ability to print their own Confirmation Statement.
• Modified BEN100 Process to run successfully after the NA Payroll changes.
• Customized delivered BAS004 that generates Leave of Absence enrolment forms for employees who go on leave, so they can make their elections during Open Enrolment.
• Implemented T&L Security to support numerous Dynamic Groups attached to Manager’s Access.
• Worked on changing the online OE forms placed on the portal for the EE’s during Open Enrollment.
• Enhanced BEN100 Run Control Page to enable user to run the snapshot by scheduling it and also to be able to run it manually when needed.
• Setup Pay groups, Time Periods, Validation Set, Workgroups, Compensatory Time Plans, Time Reporting Template, Rapid Time Template, Rules Programs.
• Resolved Issues related to TL TA000900 Time Administration Process related to validating data and issue exceptions, rounding rules.
• Enhanced the Carrier EDI834 Changes File Interface to give a report to the user that has list of people who terminated from the benefit plan with a termination date other than the end of month.
• Supported data and process conversions from legacy systems to PeopleSoft tables.
• Created TRC (Time Reporting Codes) and TRC Programs along with functional users.
• Developed new SQR reports like Employee earnings history report EMP E HIS by from/thru dates range, Garnishment Deduction details etc.
• Debugged and resolved various issues on SQRs, Application Engines and Component Interfaces.
• Created SQL’s to generate one time report as per the client requirements.

Environment: PeopleSoft HRMS/HCM 9.0, People Tools 8.49, HR, Benefits, Time and Labor, e-Pay, e-Benefits, MSS, ESS, SQR, Oracle 9i, UPK, Crystal reports.

Confidential, Dallas, Texas

PeopleSoft Developer

Responsibilities:

• Involved in Design, Development, Testing and Enhancement of PeopleSoft HR and Time & Labor.
• Developed a very complex Time & Labor Interface which was useful in attendance reporting.
• Executed unit test plans for medium complexity batch interface programs for NA Payroll, Human Resource and Benefits modules.
• Worked with Prompt tables, Variable prompt tables with multiple keys and familiar with Table set sharing techniques for HRMS database.
• Developed Carrier interfaces (inbound and outbound) using SQR/App Engine Programs for the Vendors to send the enrollment data electronically.
• Generated reports that included writing of complex SQL for HR, Benefits, Time & Labor Modules.
• Generate the SQR reports and match with the existing system reports.
• Participated in system testing and parallel testing of the PeopleSoft system.
• Created Interfaces using Application Engine, Component Interface and File Layout to create user profiles depending on the employee information in a flat file.

Environment: PeopleSoft HRMS 8.9, HR, Payroll, Benefits, Time and Labor, SQR