SUMMARY:

• Over 7 years of experience in wide range of PeopleSoft HCM including Core HR, Benefits, Payroll, ELM & TAM.
• Strong experience in technical role and good functional understanding during implementations, upgrades, interfaces reports development, conversion, migration, production support, operational procedures, scheduling, performance tuning, Application development and database solutions.
• Strong PeopleSoft technical skills include PeopleTools (Application Designer, People Code, Application Engine, Component Interface, Process Scheduler, PS Query, Data Mover, Security Administrator), File layout, SQR (Inbound and Outbound Interfaces), and publisher (BI, XML).
• Expertise in the Fit - Gap Analysis, Design, Development, User Acceptance Testing, Conversion, Integration and User Training of PeopleSoft Financials and Supply Chain modules.
• Expertise in Legacy Systems Data Conversions using SQR, Application Engine, Component Interface, File Layout, and Excel to CI, SQL/ PLSQL
• Expertise in developing interfaces, both outbound and inbound with 3rd party systems using SQR, Application Engine, Component Interfaces, File Layout and Excel to CI.
• Extensive knowledge and experience developing and customizing of PeopleSoft Reports and Interfaces like SQR, Crystal Reports, n/Vision, PS Query, Publisher (BI, XML), and Application Engine.
• Familiarity with the Software Development Life Cycle (SDLC).
• Expertise in Interfaces, Conversions, Customizations, Reporting, Migrations and Performance Tuning.
• Proficient with People Tools, PeopleCode, Application Engine, SQR and Reporting Tools.
• Production Support and System support during System testing and User Acceptance testing.
• Resolve data quality issues and day to day production issues.

TECHNICAL SKILLS:

Operating Systems: Mainframes, UNIX Windows 95/98 and NT, Windows2000, Windows XP

Languages: SQL, SQR, PL/SQL, C and People Code

Database: SQL Server, Sybase, Oracle, ODI, MS Access

People Tools: People Code, Application Messaging, Application Package, Application Class, Application Engine, AWE, Workflow, Component Interface, File Layout, EDI Manager, Security, Process Scheduler, Portal, Tree Manager, and Data Mover

Data Mgmt. Tools: Data Mover, Component Interface, Application Engine.

Reporting Tools: SQR, Crystal Reports, nVision, PS Query manager, Publisher (BI, XML)

HCM Modules: Core HR, Benefits, NA Payroll, TAM, ELM & Self Service

PROFESSIONAL EXPERIENCE:

Technical Developer Consultant

Responsibilities:

• Involved in Client IT team to understand the existing business processes PeopleSoft Customizations.
• Study of Custom PeopleSoft Changes and providing estimates to IT Manager.
• Involved in PeopleSoft Technical development in retrofitting & Unit testing activities
• Designed and developed CI-Based web services to integrate the PeopleSoft and Internal Portal applications.
• Rebranding HR application (PeopleSoft) login pages as per the Brinker standards.
• Involved in several Security changes in user profiles, roles & Permission lists.
• Customized several AWE transactions for ESS/MSS modules.
• Involved in online-batch objects migration between the development and testing environments.
• Prepared migration forms for production deployment.
• Created Excel to CI templates to load new configuration/prompt values, Job codes, department IDs and other foundation tables. Also created Excel template to create new effective dated row on job data component.
• Responsible for migrating user SQR/Crystal/Nvision to various databases and finally into Production.
• Involved in batch objects, on-line objects and PS queries retrofitting during upgrade.
• Prepared UAT test cases.
• Developed Documentum feed for Legal department in SQR.
• Prepared shell scripts where needed to transfer the files effectively.
• Addressed PeopleSoft delivered Tax Update issues on-time without affecting the business.
• Retrofitted Tax Update objects and successfully implemented

Environment: PeopleSoft 9.2, Tools 8.54, Oracle 12C, Windows, UNIX, Toad

PeopleSoft Techno-functional Consultant

Responsibilities:

• The project involved implementation, customization of PeopleSoft HCM (HR, Payroll, and Benefits).
• Gathered requirements, designed, developed and tested application enhancements.
• Played key role in development of Interfaces using SQR’s, Application Engine.
• Developed custom reports using SQR and XML Publisher.
• Created custom approval process using Application Workflow Engine (AWE) for terminations.
• Designed and developed an SQR process to generate files, containing all checks issued and reversed, to be used for Account Reconciliation.
• Oracle PeopleSoft Applications: 7.x through 9.2. ( FSCM , HCM, ELM, EPM, Campus Solution & Integration Hub ) 
• Developed an Application Engine program to generate a file (biweekly or annual) containing hours worked in Terminals to be used for staffing and budgeting purpose.
• Developed an automated process to calculate and load adjusted salary used to determine life and disability benefits for commissioned employees using Application Engine and Component Interface.
• Created a SQR process to load the file containing Short Term Disability monthly payments from Hartford. Developed custom objects to store short-term payments made to employees.
• Resolved various issues with Time Admin runs.
• Designed and developed a custom process to enroll employees in Time and Labor using Application Engine.
• Developed a Reconciliation process to report variances between Reported time and Payable time using SQR.
• Created Test scripts and executed various test cycles for System testing and parallel testing.
• Developed custom reports needed per the client requirements using PS Query.
• Worked in a Production Support role to resolve issues related to Payroll processing.
• Provided quality documentation including Design Documents, and Test Scripts.

Environment: HRMS 9.2, People Tools 8.53, SQR, Oracle 11i, Windows NT, UNIX, Toad.

Confidential,St. Louis, MO 

PeopleSoft Technical Developer

Responsibilities:

• Involved in the PeopleSoft implementation and production support of Version 9.1 for Core HR, Payroll, Benefits and Benefits Administration
• Involved in data analysis and data conversion during the upgrade of the person model. 
• Created/Customized/Modified Records, Pages, Components and Menu definitions as per the client requirements using Application Designer.
• Modified/Customized the existing Application Engine & SQR programs as per the table changes of 9.1 without affecting the existing functionality.
• Developed SQR reports and interfaces for Benefits, HR, Payroll, which have data of new hires and changes to certain HR/Payroll data & to generate flat files to be sent for third party.
• Retrofitted Annual Enrollment Process. Designed and customized various Employee Self Service Pages and Benefits Audit Reports. And got recognized for Best Performance.
• Customized Education and Training pages to populate data into Custom tables PS SC HRS EDU INFO and PS SC HRS TRAINING.
• Responsible for migrating user SQR/Crystal/Nvision to various databases and finally into Production.
• Developed custom PS Queries to enable Benefits Functional Users to identify specific employees.
• Created a new page where the user can enter his/her Schedule for the entire Week. This page will save the data into SCH ADHOC DTL with the help of a new work/derived record. Also added different functionality and validations for this page.
• Implemented Component Interface based Web Services for Integration broker between HR and Finance for Payroll Accounting Entries.
• Developed rules using delivered templates like Holiday, Shift Premium, Period Threshold, and Weekly Threshold and customized new rules as per the client requirement.
• Developed Custom Interface Programs using Application Engine and file layout to validate and then Load Time data from Flat files into Rapid time table.
• Retrofitted custom PeopleCode programs according to the new table changes.
• Developed new Component Interfaces, Application Engine programs for FRS (Fidelity) system.
• Defined Exceptions for the reported time and created custom error/warning messages in message catalog.

Environment: PeopleSoft HRMS 9.1, PeopleTools 8.50, PS Query, SQR, SQL, Oracle 11g, JCL, Citrix (Remote Access), Lotus Notes, Data Mover, Change Assistant, Component Interface.

Programmer Analyst 

Responsibilities:

• Prepared System appreciation documentation during the initial discovery phase of project. Attended knowledge transition sessions with Clients SMEs to get thorough understanding of existing application.
• Worked closely with onsite coordinators to understand the requirements and prepare functional designs/Detail design document
• Oracle PeopleSoft Applications: 7.x through 9.2. ( FSCM , HCM, ELM, EPM, Campus Solution & Integration Hub ) 
• Estimated the project and planned project implementation in multiple phases
• Lead the application development team which was responsible for changes to the mainframe system.
• Acted as point of contact to the front end java development team
• Published timely status of project to onsite coordinators
• Worked on all phases of Application development - Coding, Unit Testing, UAT and IT support, Implementation and Post implementation stabilization
• Provided application support by being primary on call on a rotation basis
• Involved in compare report analysis and retrofitting the customizations for 8.8 to 9.1 upgrade
• Involved in retrofitting the customization for benefits interfaces, Pages and SQRs.
• Worked on analyzing the issues with Ben admin COBOL process (PSPBARUN).

Environment: PeopleSoft HCM 9.0, People Tools 8.47, Oracle, Windows, UNIX.

PeopleSoft Technical Consultant

Responsibilities:

• Involved in the PeopleSoft Upgrade Project from Version 8.8 to 9.1 for Core HR, Payroll, Base Benefits, Benefits Administration and Time and Labor.
• Extensively worked on PeopleCode according to the requirements to implement the business rules and data validations.
• Created/Modified/Customized all tables related to benefits such as Benefit plan types, Benefit plans and Benefit programs.
• Developed Record Definitions, Pages, Components, ad-hoc SQRs & ad-hoc queries, and Run Control Pages as per corporate requirements.
• Customized Benefit program pages to include fields like eligibility criteria and rate factor etc.
• Extensively worked on making online changes such as adding customized translate values, modifying People Code, adding fields to pages and modifying Components and menus.
• Involved in creating permission lists, users, roles and assigned roles to users (Maintain Security).
• Customized Recruiting Profile page (HRS CE PROFILE) to populate data into PS SC HRS APP INFO (delivered table PS HRS APP PROFILE).
• Setting up Vendor profiles and Vendor policies according the organization requirements.
• Designed and developed an interface in SQR to send time from custom Time and Labor table to a flat file to be exported to another department.
• Oracle PeopleSoft Applications: 7.x through 9.2. ( FSCM , HCM, ELM, EPM, Campus Solution & Integration Hub ) 
• Worked on retrofitting row-level security in all SQR PAR reports from 8.8 to 9.1, like replacing FAST SCRTY 2 view with FAST SQR SEC VW.
• Wrote an SQR Interface to populate data from the external system into PeopleSoft tables HRS APPLICANT, HRS APP ADDRESS, HRS APP EMAIL.
• Worked on developing complex queries using SQR to retrieve the benefit transactions information as per the client requirements.
• Responsible for migrating user SQR/Crystal/Nvision to various databases and finally into Production.
• Designed interfaces for Benefit Plans, customized Benefit programs integrating them with the Benefit/Deduction Program Table Group. Also enhanced the Benefit's module in People soft with the Company's Benefit program.
• Worked on Tree manager to add records in Access Group to view in PS Query.
• Extensively worked with Process Scheduler to run processes & reports through PeopleSoft panels.
• Used process monitor to view the status of the reports and scheduled various periodic reports.

Environment: PeopleSoft HRMS 8.8/9.1, PeopleTools 8.45/8.51, Windows, Application Designer, People Code, SQR, SQL, PS/Query, Crystal Reports, Oracle 10, PL/SQL.

PeopleSoft Developer

Responsibilities:

• Handling the requirements and analysis of source systems & the database architecture of the CCM data base
• Managing development with Application Engine, PeopleCode.
• Involved in functional analysis and all data design discussions
• Developed PeoplTool objects like Fields, Records, Pages, Components , Menus and other objects to meet the requirements.
• Involved in the maintenance and support operations

Environment: SQL Server 2005, PeopleSoft HCM 8.8, People Tools 8.47, Oracle 9i.