SUMMARY

• Over 7+ years of IT experience in system analysis, design, development, testing, implementation, upgrade, testing, customization and support of ERP PeopleSoft applications.
• Experience in customization, implementation, and upgrades of PeopleSoft HCM, Core HR, NA Payroll, Benefits, Compensations, Time and Labor, ESS, MSS, HCM Portal Pack, and PeopleSoft e - Modules.
• Experience in upgrading PS 8.4/8.8 to PS 8.9/9.0/9.1/9.2.
• Experienced in design of technical specification based on the end user interaction.
• Experience in supporting various HR modules, Payroll issues, weekly and bi-weekly reporting tasks, and providing innovative and alternate solutions for their requirements.
• Strong PeopleSoft technical skills include Application designer, Application Engine, File Layout, Application Packages, Component Interface, Integration Broker, PeopleCode, Query manager, AWE, Data mover, SQR, SQL, Crystal and nVision reports.
• Proficient in performing fit gap analysis, designing, Reporting, Interfacing, Conversion, Extension and writing (RICEW) using PeopleCode, Application engine and SQR.
• Involved in Data Conversion between legacy to PeopleSoft system using FL, SQR, CI and IB.
• Good experience in complex reporting using SQR, nVision, PS Query and Crystal Reports.
• Commendable experience in Data Conversion, Migration, Import and Upgrade involving tools like SQL, SQR, XMLP, AE programs, Component Interfaces, Data Mover, Change Assistant and Import Manager.
• Good knowledge in PIA, Server and Security Administration, Tuxedo, Web logic and Web Sphere
• Expertise in the complete Installation process of PeopleSoft, Application Server and Portal Configuration.
• Developed complex PeopleSoft Work Flow’s for automation of the business processes.
• Experienced in Unit testing and Integration Testing of Peoplesoft objects and work products.
• Produced ad-hoc reports using SQL, SQR, PS Query and Crystal reports to verify data wifin the system data tables.

TECHNICAL SKILLS

PeopleSoft ERP: PeopleSoft HCM (Base Benefits, Time and labor, Payroll, Absence Management, Core HR, e-Benefits, ESS, MSS, e-pay)

People Tools: Application Designer, Application Engine, Component Interface, File Layout, Query Manager, Change Assistant, Data Mover, Configuration Manager, Process Scheduler, Workflow, Process Scheduler, Integration Broker, App Packages

Programming: People code, SQL, SQR, PL/SQL, HTML, XML, VB, Java, C, C++

Reporting Tools: BI/XML Publisher, SQR, Crystal, nVision

Data Bases: Oracle 9i/10g/11g, MS SQL Server, Sybase

Operating System: UNIX, Windows NT/2000/XP.

PROFESSIONAL EXPERIENCE

Confidential, Secaucus, NJ

PeopleSoft Developer

Responsibilities:

• Customized and added new functionality to SQR for outbound interface which extracts active employee data who are eligible for benefits and benefits programs
• Wrote PeopleCode that generates data in XML format which is inserted into BI Publisher and created SQR which will halp employees to print their benefits confirmation statement according to year
• Created new template design for benefits confirmation statement which included employee data, benefits plan, deductions, dependents and beneficiary information for BI Publisher reporting
• Wrote PeopleCode which will extract employees benefits plan and options, coverage level, pay period pre tax deductions information from the database and generate report according to given word file layout document format
• Created new deduction codes (GPC, PET) in the general deduction tables and attached them to certain companies and added few validations in Application Engine sections for inbound validations
• Created Application Engine, File Layout and Component Interface for the inbound process which will read and insert data into header, detail, and trailer records for further process.
• Designed result report for inbound process through Peoplecode which will display total rows received, rows wif errors, rows inserted, employee data and error reason
• Created inbound and then outbound process for Payroll Deduction load which included inserting data from file to PS using FL and created AE that performed reading, loading, deleting, validating sections
• Performed customizations in SQR which takes new deduction data from database based on check date which was previously inserted from inbound file and then ran the SQR process through Process Scheduler and sent the report to Insurance company
• Created run control page where employee can view and print their deduction information based on the check date
• Gatheird requirements and analyzed the documents for outbound SAP interface process where active employee details needs to be sent initially using SQR process and then send the file if any changes in employee level data occur
• Created new SAP outbound interface SQR where if changes occur in action types like hire, rehire, data changes, termination of an employee and organizational level data, changes will be sent to SAP
• Wrote another two SQR's(SerraView, Flyte) from scratch which extracts employee information according to their requirements and generate files in specified format.
• Created SAP-HR SQR interface and added new functionality where organizational and relationship level data needs to be extracted if any changes and then send the file to SAP interface.

Environment: PeopleSoft HCM 9.1, People Tools 8.51, SQL, SQR, PeopleCode, Application Engine, File Layout, Component Interface, BI Publisher, Process Scheduler

Confidential, Boston, MA

PeopleSoft Technical Consultant

Responsibilities:

• Gatheird requirements for the data integration between KRONOS and PeopleSoft for the Sales population and developed the interfaces
• Gatheird requirements and developed the interface for time sheet automation by integrating the data from NAT into PeopleSoft Time and Labor
• Involved in interaction wif the users, gatheird requirements, user documentation, designing process, converting requirements to technical documentation and implementation
• Performed functional configuration and technical development which included designing, building, testing and deploying the technical components required for successful ERP PeopleSoft solutions, especially RICE (Reports, Interfaces, Conversions, Extensions/Enhancements)
• Involved in development of RICE components using SQL, BI Publisher as per Applications coding/ Customization/ User Interface standards.
• Modified the external login page to lock-out the users after certain number of tries and added more rules on the passwords.
• Modified the Application Packages to make the profile active when the person is hired through e-recruit
• Customized the Application Packages after bundles were applied which were causing to populate wrong data on the job records when a person is hired through e-recruit
• Customized a component to send mail notification to the manager when an internal employee applies for another position
• Involved in writing an Application Engine program which looks over the Leave Balances for the employees and adjust the Balances as per the client’s requirements.
• Designed and developed the conversion Application Engine programs to convert all of the HR data from legacy system into the PeopleSoft
• Designed and developed customizations for the department and job data pages to include information at the company and employee level
• Helped in creating and customizing the 'About You Portal' to access PeopleSoft ESS/MSS functions like Paychecks, W-2, W-4, DDP and other PY Admin options using SSO.
• Assisted users in testing the developed customizations/delivered functionality
• Created Custom Permission lists/Roles for the HR Users
• Functional testing and designing of interfaces - Payroll interfaces from PeopleSoft to banks
• Designed and Implemented NA Payroll - GL Interface
• Designed and developed custom time interface for time entry into Pay sheets
• Designed and developed custom interface from NA Payroll to GL (GL interface)
• Reviewed design of Reports, Interfaces and Extensions
• Involved in creating new Run control Pages for different pages in order to handle the run control parameters based upon the user requirements for generating different reports.
• Converted reports to SQR’s and used XML Publisher to generate different types of reports.
• Involved in writing interface that reads an XML message and inserts that data into the staging tables through which we build the Vouchers.
• Wrote Application package that reads the XML message and voucher build wif the halp of App Engine.
• Modified several XML Publisher templates which is part of reports, International Paychecks and Direct Deposits.

Environment: PeopleSoft HCM 9.2, People Tools 8.54, SQL, PeopleCode, Application Engine, Application packages, XML/BI Publisher, Security, Oracle

Confidential, Ann Arbor, MI

PeopleSoft Technical Consultant

Responsibilities:

• Detailed impact analysis was done to identify the objects, compared old and new model to retro fit and customized objects were identified, exported and migrated
• Involved in handling data conversion using file layout for Core HR and Benefits and performed PeopleSoft RICE components (Reports-Interface-Conversion-Extension)
• Created technical design documentation for various customizations and performed retro fitting
• Retrofitted and fixed the rules and related SQL objects in Time and Labor rules
• Participated in fit gap analysis meetings for PeopleSoft HRMS - HR, Payroll, Base Benefits
• Created and modified SQR reports, Crystal reports and custom PeopleSoft objects
• Performed Upgrade, Support and Troubleshooting technical issues
• Developed new reports using SQR, Crystal and PS-Query
• Writing and running Test cases/scripts, requirement traceability matrix and involved in Vanilla comparison to find out level of customization
• Involved in running Upgrade Scripts & Process using Upgrade Change Assistant Tool
• Involved in running Upgrade comparison reports between Demo database and copy of production
• Involved in converting HR, Tax, and Recruiting related tables from 9.0 to 9.2 by loading into staging tables through App Engines and then validating the data through Component Interface and loading into 9.2 PeopleSoft tables.
• Carried forward customizations and applied new customizations in 9.2
• Modified the customized SQR reports in 9.0 to make it 9.2 compatible and to accommodate the new key structure
• Worked on Integration broker setup in creating nodes, messages, services, service operations and generating the WSDL from Provide Webservice component.
• Involved in finding and fixing the errors that came out from the conversion programs which included Application Engines and Component Interfaces
• Used Process Scheduler for setting up the reports to run at specific time and used Process Monitor to monitor the status of reports
• Created Permission lists, users, roles and assigned roles to users through Maintain Security
• Worked wif Production support team during the Bi-weekly Payroll run process to fix any problems for the Pay calculation process

Environment: PeopleSoft HCM 9.2, People Tools 8.53, SQR, SQL, People Code, Application Engine, Change Assistant, Integration Broker, Component Interface, Crystal report, PS Query, Process Scheduler, PS Security, Oracle

Confidential, Chicago, IL

PeopleSoft Developer

Responsibilities:

• Involved in gathering, defining requirements and overall scope definition in terms of functional & technical requirements
• Implemented Human Resources, Benefits, Payroll for North America solution in alignment wif overall business requirements including business process design, RICEW design, testing, and deployment
• Involved in technical aspects in implementation of Core HR, Benefits, Payroll for North America and Benefits Administration
• Involved in writing Conversion programs using App Engines that converts the data from the Legacy System to load the data into the staging tables
• Modified several BI Publisher templates which is part of reports, International Paychecks and Direct Deposits
• Involved in writing Application Engine Program which determines whether the employees fall under Exempt or Non-Exempt based upon certain requirements given by the user
• Developed several App Engines for reading/writing and Inbound/Outbound files using File Layouts
• Customized different PeopleSoft delivered Pages and modified the delivered PeopleCode as per the requirements
• Involved in setting up of the module control tables in Benefits such as benefit plan table, coverage group table, leave plan table, salary rate table and retirement plan table
• Extracted and loaded the data into PeopleSoft Payroll, HR, Benefits tables using Application Engines and Component Interface
• Loaded important tables like Job Data, Personal data, Health Benefits, Payroll Data and tables related to Tax data
• Developed Application Engine Program to upload Hire Information from Data file into Staging Tables using File Layouts and PeopleCode, which will be further populated into corresponding PeopleSoft tables using SQR Conversion programs
• Implementation of self-service offerings to enable all associates via role-based self-service and integrating processes.
• Created customized Check Reconciliation process as per the client requirements.
• Created new pages, derived work records, Function libraries and PeopleCode validations for custom templates
• Developed and tested the interfaces for health Benefits, retirement Benefits and pension plans.
• Modified the Initial and Termination (HIPPA) COBRA letters as per the client’s requirement.
• Created the Workflow wif email events where if an employee terminates or gets newly hired then email notification will be sent to set of Managers
• Involved in converting data from Legacy system to PeopleSoft using Integration Broker, Component Interface and Application Engine.
• Involved in setting up the Row-level Security, Permission lists, Roles, Security trees for different aspects regarding to the access to different users in the organization.
• Submitted processes to Process Scheduler to run daily tasks at a specific time to run process recursively at a specific interval
• Modified and dealt wif different nVision reports

Environment: PeopleSoft HRMS/HCM 9.1, People Tools 8.53, SQR, SQL, People Code, Application Engine, File Layout, Integration Broker, Component Interface, workflow, PS Security, nVision, BI Publisher, Oracle

Confidential

PeopleSoft Technical Consultant

Responsibilities:

• Analyzed existing customizations, interfaces, and reports, identified the changes that needed to be made and documented the impacts from technical perspective.
• Involved in designing technical and functional specifications for the process changes wif the new release for the upgrade process.
• Performed Fit Gap analysis and fixed the gaps between the tools.
• Ran compare reports between the tools and application module and Object wise.
• Performed retrofit between the custom interfaces, customized object pages, components and records using Application Engine Programs, SQR and pages
• Wrote Data Conversion Scripts to convert legacy data to PeopleSoft Oracle Database.
• Used Component Interface to migrate data from Excel/CSV to PeopleSoft components in HR module
• Involved in Migration of PeopleSoft Objects through Quest Stat Tool and applying Maintenance Pack
• Used Application Messaging/IB to integrate HCM, and Siebel Master Data Management.
• Fix integration between PeopleSoft and third party system
• Used Upgrade Change Assistant and Data Mover tools and ran various DMS scripts.
• Customized and modified HR related MARKET DATA table structure which involved research on market analysis in three main campuses
• Customized the Student Records, Student Financials and Financial Aid as per the business requirements
• Designed and developed Interfaces to enable the users to search for required data from external applications in a Synchronous mode.
• Designed and developed Component Interface to populate the PeopleSoft database wif the data received from external applications.
• Created custom App Engine programs to synchronously create user accounts in the Portal Database for new employees.
• Assisted and modified various SQR and Application Engines to improve the performance coz of the volume of the data.
• Designed and developed Application Engine programs to extract the hours from the Time & Labor system and load it in PeopleSoft Payroll Pay sheets.
• Designed and developed complex pages using People Code for the users to view all the earnings to approve and load the approved data to PeopleSoft system using Application Engine utility.
• Configured and designed Row Level security, Permission Lists, Roles and assigned roles to users
• Involved in life cycle of Student Administration (Student Records, Creating the course catalogs, Enrolling Students, Scheduling the classes, Financial Aid, Awarding and Packaging, Direct Lending, Processing Financial Aid, Student Financials, Calculating Tuition and Fees, Returning Tuition and Fees, Payroll module.

Environment: PeopleSoft HCM 9.0, People Tools 8.52, SQR, People Code, Application Engine, Change Assistant, Component Interface, Integration Broker, Data Mover, Oracle

Confidential, Tampa, FL

PeopleSoft Technical Consultant

Responsibilities:

• Project involved development, customization and production support
• Customized the Outbound SQR Interface to send appropriate Business Phone, Cell Phone and E-Mail Address Information to the labor office. Testing, design of interfaces - Payroll interfaces from PeopleSoft to ADP and banks
• Worked on customization, support and reporting of ELM and ePerformance.
• Worked on Recruitment and customization of eRecruit module
• Modified the “Look and Feel” of the Portal Homepage and Pagelets using Branding Themes and Style sheets.
• Worked on customizations using PeopleCode, Application Engine, SQR, Java, Ajax wifin enterprise portal.
• Customized Application Engine to upload Time to Payroll Pay sheets.
• Modified the Payroll Check Print report and Direct Deposit Advice Print Report programs as per clients requirement.
• Involved in generating Security and Audit Reports.
• Modified SQRs which involved changing of PeopleSoft components like Job Data and Personal Data as the new population selection criteria was wif POI TYPE as compared to EMPL RCD changes in the former version.
• Involved in setting up the Workflow for the self service transactions such as Job Requisition approval as per the business rules of the organization.
• Designed and developed custom Paycheck summary page which displays employee’s earnings, deduction, taxes, bonds and flex credits as per client’s requirement.
• Customized Workflow events for various modules in HR, for sending emails for different scenarios, restricted workflow events based on Permissions security.
• Customized the pages and created custom reports based on user requirements in Absence Management module
• Created queries for Time and Labor reporting by using PeopleSoft Query tool.
• Developed Batch processes using SQR’s and App Engine Programs.
• Modified CS Reports using PS-Query and SQR.
• Worked on nVision reporting and customizations.

Environment: PeopleSoft HRMS 8.9, SQL, SQR, People Tools 8.50, People Code, Application Engine, Workflow, PS Query, nVision, Process Scheduler, Security, Oracle.

Confidential, Rockville, MD

PeopleSoft Technical Consultant

Responsibilities:

• Customized PeopleSoft objects using People tools
• Customize new payroll interfaces and reports
• Worked wif the end users and guided the domain team in User Acceptance Testing (UAT)
• Participated in applying Tax Updates and fixes and resolved payroll errors and halp users wif Payroll related queries and issues.
• Resolved Issues related to PeopleSoft Delivered Benefits Confirmation Forms Report and Benefits ABBR Daily Update Process.
• Customized and Modified Enrollment Workflow
• Resolved the issue wif on-line Checks in Portals for Check Print.
• Resolved the issues related to Deductions Record using Query manager.
• Involved in resolving the issue related to Off-Cycle checks, that are not showing on the Payroll register and the details of earnings were not showing on the Earnings tab of Pay Check View.
• Added new PeopleCode to resolve issue related to PeopleSoft Delivered Page.
• Resolved the Issue payroll related to Error Messages occurred after PAYLOAD Process runs.
• Analyzed the Data Errors that occurred when off cycle payroll is run and fixed those Issues.
• Resolved Issue related to Payroll Error Messages when Rapid Entry Pay sheet runs.
• Duplicated the DDP003.sqr file and added logic as per the client's requirement which produces interface files for printing of checks and advices history.
• Wrote Custom Interfaces for Tax Wifholdings by Pay Cycle, Quarterly Unemployment, and Reconciliation Interface.
• CustomizedApplication Engineprograms based on user requirements and wrotePeopleCodeto customize the delivered objects for HR records.
• Worked on several customs TableAuditsand created Test scripts for Functional test.
• Suggested and fixed thePayroll InterfaceCOBOL time-out issues related to an App Engine.
• Involved in running weekly and biweekly payroll wif functional team
• Sending Payroll deduction information to 3rd party vendors.
• Involved in writing custom error messages on Benefits records and pages to hide beneficiary information based on different plan types.
• Resolved issues wif HR, Benefits reports and interfaces by correcting the logic and making necessary modifications as required to the SQR programs.
• Modified the PeopleCode by displaying the Managers name and 'employee id' for all the delegate Jobchange Request, Approve and Status pages.
• Added Zip Code match customization so that users don't make errors while entering the Zip Codes in the personal information pages or recruiting pages.
• Worked onPaycheck pageCustomizations to change the search keys for better page performance on the Pay Check Summary page.
• Involved in Unit Testing for SQR programs and tuned them to resolve performance base issues
• Designed and developed critical reports, extract programs and interfaces using SQR.
• Developed application engine programs to convert flat files from legacy into PeopleSoft tables using File Layouts.
• Created new field definitions and added it to existingrecordandpagedefinitions through Application Designer.
• Developed and modifiedvarious PeopleCodefor certain validations as required by our business process.
• Modified customSQR reportsand processes by including the new fields and modified table joins to make them run for better error handling.
• Performed troubleshootingduring Payroll process and on-line support to the end-users.
• Involved in resolving customer issues related to PeopleCode, SQR, PS-Query, Crystal Reports and Process Scheduler.

Environment: PeopleSoft HRMS 8.9, SQL, SQR, People Tools 8.49, People Code, Application Engine, Workflow, Query Manager, PS-Query, Crystal report, File Layout, Oracle.