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 teh 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 noledge in PIA, Server and Security Administration, Tuxedo, Web logic and Web Sphere
• Expertise in teh complete Installation process of PeopleSoft, Application Server and Portal Configuration.
• Developed complex PeopleSoft Work Flow’s for automation of teh 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 within teh 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 teh database and generate report according to given word file layout document format
• Created new deduction codes (GPC, PET) in teh 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 teh 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 with errors, rows inserted, employee data and error reason
• Created inbound and tan 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 tan ran teh SQR process through Process Scheduler and sent teh report to Insurance company
• Created run control page where employee can view and print their deduction information based on teh check date
• Gatheird requirements and analyzed teh documents for outbound SAP interface process where active employee details needs to be sent initially using SQR process and tan send teh 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 tan send teh 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 teh data integration between KRONOS and PeopleSoft for teh Sales population and developed teh interfaces
• Gatheird requirements and developed teh interface for time sheet automation by integrating teh data from NAT into PeopleSoft Time and Labor
• Involved in interaction with teh 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 teh 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 teh external login page to lock-out teh users after certain number of tries and added more rules on teh passwords.
• Modified teh Application Packages to make teh profile active when teh person is hired through e-recruit
• Customized teh Application Packages after bundles were applied which were causing to populate wrong data on teh job records when a person is hired through e-recruit
• Customized a component to send mail notification to teh manager when an internal employee applies for another position
• Involved in writing an Application Engine program which looks over teh Leave Balances for teh employees and adjust teh Balances as per teh client’s requirements.
• Designed and developed teh conversion Application Engine programs to convert all of teh HR data from legacy system into teh PeopleSoft
• Designed and developed customizations for teh department and job data pages to include information at teh company and employee level
• Helped in creating and customizing teh '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 teh developed customizations/delivered functionality
• Created Custom Permission lists/Roles for teh 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 teh run control parameters based upon teh 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 teh staging tables through which we build teh Vouchers.
• Wrote Application package that reads teh XML message and voucher build with teh 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 teh 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 teh 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 tan validating teh data through Component Interface and loading into 9.2 PeopleSoft tables.
• Carried forward customizations and applied new customizations in 9.2
• Modified teh customized SQR reports in 9.0 to make it 9.2 compatible and to accommodate teh new key structure
• Worked on Integration broker setup in creating nodes, messages, services, service operations and generating teh WSDL from Provide Webservice component.
• Involved in finding and fixing teh errors that came out from teh conversion programs which included Application Engines and Component Interfaces
• Used Process Scheduler for setting up teh reports to run at specific time and used Process Monitor to monitor teh status of reports
• Created Permission lists, users, roles and assigned roles to users through Maintain Security
• Worked with Production support team during teh Bi-weekly Payroll run process to fix any problems for teh 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 with 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 teh data from teh Legacy System to load teh data into teh 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 teh employees fall under Exempt or Non-Exempt based upon certain requirements given by teh user
• Developed several App Engines for reading/writing and Inbound/Outbound files using File Layouts
• Customized different PeopleSoft delivered Pages and modified teh delivered PeopleCode as per teh requirements
• Involved in setting up of teh 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 teh 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 teh client requirements.
• Created new pages, derived work records, Function libraries and PeopleCode validations for custom templates
• Developed and tested teh interfaces for health Benefits, retirement Benefits and pension plans.
• Modified teh Initial and Termination (HIPPA) COBRA letters as per teh client’s requirement.
• Created teh Workflow with email events where if an employee terminates or gets newly hired tan 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 teh Row-level Security, Permission lists, Roles, Security trees for different aspects regarding to teh access to different users in teh 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 with 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 teh changes that needed to be made and documented teh impacts from technical perspective.
• Involved in designing technical and functional specifications for teh process changes with teh new release for teh upgrade process.
• Performed Fit Gap analysis and fixed teh gaps between teh tools.
• Ran compare reports between teh tools and application module and Object wise.
• Performed retrofit between teh 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 teh Student Records, Student Financials and Financial Aid as per teh business requirements
• Designed and developed Interfaces to enable teh users to search for required data from external applications in a Synchronous mode.
• Designed and developed Component Interface to populate teh PeopleSoft database with teh data received from external applications.
• Created custom App Engine programs to synchronously create user accounts in teh Portal Database for new employees.
• Assisted and modified various SQR and Application Engines to improve teh performance because of teh volume of teh data.
• Designed and developed Application Engine programs to extract teh hours from teh Time & Labor system and load it in PeopleSoft Payroll Pay sheets.
• Designed and developed complex pages using People Code for teh users to view all teh earnings to approve and load teh 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 teh course catalogs, Enrolling Students, Scheduling teh 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 teh Outbound SQR Interface to send appropriate Business Phone, Cell Phone and E-Mail Address Information to teh 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 teh “Look and Feel” of teh Portal Homepage and Pagelets using Branding Themes and Style sheets.
• Worked on customizations using PeopleCode, Application Engine, SQR, Java, Ajax within enterprise portal.
• Customized Application Engine to upload Time to Payroll Pay sheets.
• Modified teh 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 teh new population selection criteria was with POI TYPE as compared to EMPL RCD changes in teh former version.
• Involved in setting up teh Workflow for teh self service transactions such as Job Requisition approval as per teh business rules of teh 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 teh 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 with teh end users and guided teh domain team in User Acceptance Testing (UAT)
• Participated in applying Tax Updates and fixes and resolved payroll errors and halp users with 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 teh issue with on-line Checks in Portals for Check Print.
• Resolved teh issues related to Deductions Record using Query manager.
• Involved in resolving teh issue related to Off-Cycle checks, that are not showing on teh Payroll register and teh details of earnings were not showing on teh Earnings tab of Pay Check View.
• Added new PeopleCode to resolve issue related to PeopleSoft Delivered Page.
• Resolved teh Issue payroll related to Error Messages occurred after PAYLOAD Process runs.
• Analyzed teh 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 teh DDP003.sqr file and added logic as per teh client's requirement which produces interface files for printing of checks and advices history.
• Wrote Custom Interfaces for Tax Withholdings by Pay Cycle, Quarterly Unemployment, and Reconciliation Interface.
• CustomizedApplication Engineprograms based on user requirements and wrotePeopleCodeto customize teh 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 with 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 with HR, Benefits reports and interfaces by correcting teh logic and making necessary modifications as required to teh SQR programs.
• Modified teh PeopleCode by displaying teh Managers name and 'employee id' for all teh delegate Jobchange Request, Approve and Status pages.
• Added Zip Code match customization so that users don't make errors while entering teh Zip Codes in teh personal information pages or recruiting pages.
• Worked onPaycheck pageCustomizations to change teh search keys for better page performance on teh 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 teh new fields and modified table joins to make them run for better error handling.
• Performed troubleshootingduring Payroll process and on-line support to teh 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.