SUMMARY

• Over 8+ years of IT/ERP experience in Software Development Life Cycle particularly in PeopleSoft HCM, Financials and SCM systems. Experience in the areas of System Analysis, Planning, Design, Configuration, Upgrade, Implementation, Development, Support, Data Conversion, Migration, Reporting and Testing of various applications using ERP client server technologies with a strong background including:
• Proficiency in PeopleSoft PeopleTools
• Application Upgrades.
• Proficiency in SQR / SQL languages.
• Application Performance Tuning.
• PeopleSoft Architecture.
• Production Support.
• PeopleSoft Reporting.
• Develop jobs / scripts in UNIX.
• PeopleSoft Workflow design.
• Experience in PeopleSoft HCM (9.1, 9.0, 8.9, 8.8, 8.3, 8.0 and 7.x) & Financial modules HR, NA Payroll, Base Benefits, Ben Admin, Time and Labor, ELM, Talent Acquisition Management, Candidate Gateway, ESS and MSS; GL, Accounts Payable, Accounts Receivable, Billing and eProcurement.
• Implemented Collaborative applications such as TAM, Absence Management, ePay, eComp and eBenefits.
• PeopleSoft experience comprises Fit - Gap Analysis, Data Conversion, Objects Migration, Design and Development, Systems Testing, Application testing of custom applications to enhance the functionality of the system to suit the business practices.
• Extensively worked with People tools such as App Designer, App Engine, PeopleCode including Application Package people code, SQR, Integration Broker, Process Scheduler, Component Interface, File layout, Security Administrator, Upgrade Assistant, Data Mover and SQL Editors.
• Extensively worked on PeopleSoft Internet Architecture (PIA), debugging and troubleshooting of PeopleSoft Application modules.
• Extensively worked on relational database environments such as Oracle, DB2, SQL Server
• Good at analytical thinking, testing, troubleshooting and error fixing.
• Excellent interpersonal and analytical skills with ability to communicate effectively.

TECHNICAL SKILLS

ERP Applications: PeopleSoft HCM 9.1/9.0/8.9/8.8/8.3/8.0/7. x; FSCM 9.0/8.9

People Tools: People Tools 8.51/8.49/8.48/8.47/8.46/8.42/8.1 x/7.x

Databases: Oracle 10g, DB2, SQL Server 2000, MS Access

Tools: Application Designer, Application Engine, People Code, Application Package, Component Interfaces, Integration Broker, Workflow, Process Scheduler, Data Mover, PS/Query, File Layout, Upgrade Assistant, Change Assistant

Reporting Tools: SQR, PS/Query, Crystal Reports, PS/nVision

Programming: People Code, SQR, App Engine, SQL, PL/SQL, Cobol, JCL, C/C++, Java

Web Programming: HTML, XML, Java Script, VBScript

Web Servers: IIS 6.0 WebLogic 8.1/6.1/5.1

Operating Systems: UNIX, Windows, OS 390

PROFESSIONAL EXPERIENCE

Confidential

PeopleSoft Techno-functional

Responsibilities:

• Gatheird requirements, designed gap strategies, Design, data analysis, data cleaning, preparing technical documentation, Table set up for PeopleSoft 9.1 Time & Labor and Payroll for NA Implementation. Also worked on implementing TAM/CG & ePerformance modules.
• Gatheird business process requirements and participated in fit-gap analysis, and Identified RICE Object & Proposed solution for the gaps
• Responsible for leading data mapping sessions for conversion (ADP to PeopleSoft) and assisted the Functional team with translation logic & preparation of conversion strategy plans (Data Profiling, Mapping, Cleaning & Reconciliation)
• Modified the Delivered workflow for Time and Labor for the approval of Next level Manager and Time Admin’s and Proxy Manager
• Developed Conversion Programs to load data into PS tables from legacy system ADP
• Developed conversion programs for PeopleSoft Payroll Components like Earning Balances, Special accumulator Balances, Deduction Balances, Payroll Data, Check Balances, Tax Data, Tax Distribution.
• Developed custom programs to enable the system to perform the business process for the Leave Accrual Component
• Developed Several Complex Reports for Payroll, Benefits and Time and Labor Module
• Designed and Developed Custom Auto TL enrollment & Maintenance time reporters Batch process
• Maintain and modify real time and batch rules used by time administration process. Work with the business users to clear up low and medium exceptions. Recognize high exceptions generated through Time Administration and Payroll Calc and works to correct any configuration set-up errors dat resulted in the high exception.
• Maintain Technical documentation for the PeopleSoft Time and Labor, Benefits and Payroll customizations.
• Assisted & Participated in cut-over activities with coordination with functional team
• Worked as functional & technical for Implementing Employer Benefit contribution in PeopleSoft.
• Worked on Implementing Single Sign-on and LDAP integrations. Gatheird requirements and Developed Provisioning model for new hires/ terms which in turn triggers LDAP activities.
• Worked on implementing TAM/CG module according to Crowley Requirements. dat Involved in deep understanding and customizing of PeopleSoft TAM/CG module.
• Worked on All Hire pages (Applicant Hire, non-EE hire, Hire) to customize Crowley reserved EE id and Travel name enhancements.
• Developed Background Investigation components to track Applicants and EE’s Background Investigation Records history and Information by using workflow.
• Customized Applicant Index and Job Index App Engine programs to facilitate Crowley Search option for Recruiters.
• Customized Resume processing in eRecruit to store dedicated resume for each Job req.
• Implemented ePerformance module for Crowley.
• Performed Test cycles for both System Test and Regression Test.
• Worked on ER benefit contribution in Peoplesoft to be calculated with each payroll and printed on W2 at year end. This involved configuration changes in Health benefits contributions and Pay calc Process alter.
• Ran payroll test to test ER benefit contributions and W2.
• Rewrote Annual Benefit Statement Program for PeopleSoft 9.1.
• Wrote EE Head Count Reports for New hire, Terminated, Retirees and LOA with statistics.
• Customized Pay advice and online check (PAY003, DDP003).
• Built a customized Interface module for Crowley Peoplesoft to generalize all Interfaces interacting with Crowley peoplesoft. This Involved writing generic App package and new interfaces for User. This Interface module provides user to edit the interface file data online if their is any error and resubmit the program.
• Involved in the fixing the problem for the integration Broker dat is setup for syncing the payroll data between PeopleSoft HR and PeopleSoft Financials
• Involved in developing real time Asynchronous Integration from PeopleSoft Financials to HCM for the Payroll chart strings.
• Resolved Delivered Integration Broker Issues.
• Created App Engine to run SSIS packages on Peoplesoft server using peoplesoft process scheduler to load interface data from external Exactus System to PeopleSoft staging table.
• Implemented Provisioning system using app Engines, CI’s and LDAP integration.
• Implemented necessary security for TAM/CG module.
• Implemented External Applicant module (Candidate Gate way) for External Applicants to be login and apply Job Req using new web profile and new web server instance.
• Coordinated with third party vendors to resolve Interface issues.
• Provided support to end clients and internal customers with ad-hoc Queries, Reports and training.

Environment: PeopleSoft HCM 9.1 / 8.51, People Tools 8.51.10/8.48.20 , Oracle 11g, UNIX 64 Bit, 5.5, Windows 2003/NT, CRYSTAL, TOAD.

Confidential, Chicago, IL

Sr.Techno-Functional Develop & Analyst

Responsibilities:

• Played a key role in PeopleSoft 9.1 HCM upgrade.
• Responsible for Identifying all 8.9 (old version) Customizations and Retrofitting them in 9.1.
• Involved in upgrade Issues HR, North American Payroll, Base Benefits and Time & Labor, TAM & CG. Support and Troubleshooting Technical & Functional issues.
• Provided technical expertise on Fit Gap Analysis, Build, System Integration testing phase I & II.
• Retrofitted customizations in SQR, App Engine’s, Interfaces, Online pages, components, peoplecode, Component Interfaces, App packages, PS Query and crystal Reports.
• Worked on many HRMS 9.1 upgrade issues.
• Extensively worked on TAM security changes to retain 8.9 Security.
• Worked on upgrading complex objects related to Security such as permission lists, roles, portal structures, pagelet and portal collection, People Soft Trees and query trees.
• Worked on pagelet and portal collection security.
• Coordinated with business analyst to use 9.1 features in Payroll, Time and labor and TAM/CG.
• Involved in activating & troubleshooting some delivered service operations in 9.1.
• Worked on Verity troubleshooting and coordinated with oracle support to resolve Issues with Applicant Index, Job Index creations & search collection build.
• Added additional search fields.
• Worked on enhanced Mass Updates functionality in 9.1 to create additional payments to particular group of Employees. created new workflow notifications for MSS and ESS.
• Worked with testing team to resolve defects in SIT (system integration test.) phase I & II. Coordinated with offshore team in daily conference to monitor the status of defects and provided guidance on defect solutions.
• Coordinated with third party vendors to resolve Interface issues.
• Used STAT extensively for migrations.

Environment: PeopleSoft HCM 9.1 / 8.9, People Tools 8.51.10/8.48.20 , Oracle 11g, UNIX 64 Bit, STAT 5.5, Windows 2003/NT, CRYSTAL, TOAD, CITRIX.

Confidential, NY

Sr.Techno-Functional Developer/Analyst

Responsibilities:

• Worked as a Sr.Technical Resource in upgrade & Implementation of PeopleSoft 8.9/9.0 HCM.
• Upgraded PeopleSoft HCM: HR, North American Payroll, Base Benefits and Time & Labor Upgrading, eRecruite Support and Troubleshooting Technical & Functional issues. Configuring Base tables.
• Extensively worked in System testing and Parallel/Intigration Testing testing phases.
• Worked in configuration of PeopleSoft Time & Labor report time, scheduled time, exceptions, rules and manager approvals.
• Responds to Payroll/Time and Labor issues dat are opened through the Phire and Siebel system.
• Investigates tests and resolves any of T&L, HR payroll and eRecruite more complex issues.
• Worked on self service of Time entry and manager approval for T&L.
• Worked on Ben Admin Customizations for new hire where New hire Accruals didn’t start until they enroll. (This takes more than 30 days.) Created custom process to create BAS Table Entry with custom action so dat accruals didn’t miss before EE enroll in Benefit Plan.
• Worked on schedules for part time and full time employees, entitlements and Leave accruals for vacations, absences types (Leave of absence, unjustified, vacations, PTO..etc)
• Worked on Custom Leave Accruals Process for New Earning codes Implementation.
• Expertise in Web server application and web services using Application Packages and Integration Broker.
• Created Messages, Service Operations to receive the chartfields details from Financials to HRMS using integration broker.
• Configure and setup the User Profile, Role Maint, Delete User Profile, Delete Role, Role Sync Message EIP’s between the Enterprise Portal and HR/FSM.
• Developer customized AWE(Workflow Engine) from end to end for PAR transactions Approval process, so dat EE Information Change need to be approved by HR managers. Created query roles. And customized PAR component.
• Worked on XML Publisher using Application Engine Processes.
• Developed App Engine Using Job CI to load Job Details for long term Incentive Plans.
• Worked on numerous Inbound & Outbound Interfaces for vendors and Agencies.
• Modified/Created SQR reports/interfaces, Crystal reports and Modified custom PS objects.
• Developed new reports using SQR, Crystal and PS-Query. Writing and running Test cases/scripts, Defect tracking and fixing.
• Created new pages, derived work records, Functions and PeopleCode validations for custom templates. Created Translate records and translate values for templates.
• Modified customized SQR reports in version 8.8 to make it version 9.0 compatible and to accommodate the new key structure.
• Created Permission lists, users, roles and assigned roles to users through Maintain Security.
• Worked with Production support team (24/7) during the Bi-weekly North American Payroll run process to fix any problems for the Paycalc process and nightly batch process.
• Created HR, Benefits Administration, and North American Payroll custom interfaces and processes using SQR and Application Engine.
• Developing reports using SQR, PS Query. Also creating inbound (program, which takes data from flat data file and puts it into database) as well as outbound (program, which takes data from database and puts it into flat data file) interface programs using SQR for data migration between systems.
• Developed Inquire panels for Dependent Benefits and Employee Benefits.
• Involved in the discussions related to adding contractors to the PeopleSoft. Defined and implemented the process for adding contractors to the PeopleSoft. Modified Records, Translate values, People Code during this process.
• Extensively worked on writing .ksh shell scripts for unix to run Programs.
• Prepared Test cases and Test Plans.

Environment: PeopleSoft HCM and North American Payroll 9.0/8.8, People Tools 8.49/8.42/8.46 , Oracle 10g, UNIX, PHIRE, Windows 2003/NT, SQR, COBOL, SQL.

Confidential, WI

Sr.Technical Developer/Analyst

Responsibilities:

• Modified Change Assistant templates such as adding steps to template, editing steps, deleting chapters, tasks and updating scripts.
• Ran compare reports to get all customizations in Production environment. Also worked on Fit gap analysis to detect applicable new functionalities implemented in PS 9.0 v.
• Ran SysAudit, dddaudit and Alter audit reports and has cleared Target environments by deleting inconsistent tables and orphaned objects.
• Integrated a third party system using Integration broker to transfer the PO and load the freight information back into PeopleSoft.
• Involved in gathering the requirements for integration and participated in the business meetings with third party.
• Configured the integration gateway, loading the connectors and defining the JOLT connection strings.
• Created remote/external nodes and defined the connector properties.
• Created routings and service operations.
• Configured the integration gateway properties file for error log and message log files.
• Created JCL wrappers to run batch programs.
• Asynchronous messages are fired from the integration engine in XML which is built using XML doc classes.
• Issued with message wrapping has been solved.
• Tested inbound messaging by posting messages on LOCAL node using send master tool.
• Configured send master tool.
• Solved the issue of giving the wrong accounts in the vouchers and realized after the voucher is posted.
• Solved the issue when the POs are not getting created from Requisitions
• Updated EFT fineft23.sqc to print the invoice number on the EFT text file, which will be comfortable to the vendors. This solved the problem of getting the court id on the EFT file for the payments to the Garnishment.
• Worked on PC AP TO PC application engine program to collect all the costs occurred in AP.
• Removed the Product translation from a custom Application Engine
• Solved the issue of Vouchers were not getting created from the staging tables
• Solved the issue of check when one invoice line TEMPhas not been printed
• Created a new nvision to get the vendor name for some nvision report.
• Created a Query to get all the vouchers created for a particular vendor
• Solved the issue of Voucher Matching since the POs were forcefully closed before they were matched completely modified an application package AP to get the back up of the positive payment file each time the pay cycle runs
• Created a notification template for the users to notify their superior through the notify button
• Created a custom Application Engine Y IBI PREREF Interface to create the vouchers from a flat file, which saves alot of time and we can get rid of entering all the one time vendors and then create vouchers from those vendors.
• Developed a Component Interface to load the vendor information from a flat file.
• Also involved in the fixing the problem for the integration Broker dat is setup for syncing the payroll data between PeopleSoft HR and PeopleSoft Financials
• Set up the business process to get the link between the Contracts and Purchase Orders and Vouchers.
• Created custom Set up for Bank Reconciliation.
• Extensively worked on writing .ksh shell scripts for unix to run Programs.
• Prepared Test cases and Test Plans.

Environment: PeopleSoft FSCM 9.0(GL, AP, AR, BI, PC, INV, AM, PO, ePro), PeopleTools 8.50,XML Publisher, DB2,JCL,TSO, People Code, Application Engine, Integration Broker, SQR, Component Interface, Crystal reports 9.0, PS Query.

Confidential, Chicago, IL

PeopleSoft FSCM 8.9 Technical Consultant

Responsibilities:

• Involved in the Re-Design of the complete interface of the TODS Interface Customized Interface which involves the inbound interface of the 3rd Party file prep for the AR Update with the Billing Information
• Created buyer purchasing attribute where buyers can update certain fields instead of all on the Inventory Purchases.
• Integrated third party vendors using Integration broker and webservices.
• Used SOAP doc messages to interact with third party system.
• Familiar with providing and consuming a web service.
• Used SOAP doc classes to generate SOAP complaint XML messages.
• Used SOAP UI tool to check the WSDL’s.
• Customized POPO005.sqr to the business requirements
• Involved in code and test work unit identified by the Inventory and Order Management functional team.
• Worked on ePro workflow process.
• Added Lines to the Billing Interface Tables INTFC BI, INTFC BI HDR
• Involved in the Dunning letters to the customers, streamline the issue of the level of letters send to customers Involved with tune couple of SQL’s in the BIIF0001.
• Extensively worked on OM sales orders, quotations, agreements, claim backs, return material, rebates, direct shipments and order tracking customizations.
• Also customized Sales order (OMS1000), overdue shipment (OMS6210).
• Involved in setting up PeopleSoft Inventory. Setting up location accounting, business unit & item options and using workflows in inventory.
• Defined PeopleSoft inventor, Defining shipping serial control, and negative inventory option and order fulfillments.
• Enhanced the PO workflow for Expense PO's. Redesigned the workflow to add the new business rule to route the Expense PO's to appropriate approval levels and approvers. The requirement was to pick a different Approval rule set if it is Expense PO and this was done dynamically.
• Involved in creating public queries for the users to query against the CUSTOMER and CUST CRSPD tables for obtaining the Dunning details of the customer.
• Solved various issues with ePro Workflow in UAT and Regression testing
• Fixed closure part of the reversal entries to GL are out of balance by $.68 in AP.
• Written publish and subscribe people code to publish and subscribe messages.
• Fixed match exceptions issue for business unit 04 in AP.
• Developed data mover scripts to migrate Allocation steps and Groups.
• Developed SQR program for People Soft/FKAIS AP Comparison Report
• Fixed existing crystal check formats altered to move micro line on the checks using new printer in AP.
• Involved in design of the SQR, to run before Payment Predictor job to avoid failing of the job. By updating the PAYMENT ID CUST where their is no entry for the CUST ID
• Involved in integration testing and system testing. Developed Testing Scenarios. Troubles hooted and fixed bugs and errors as per client requirement after applying patches and bundles.
• Involved in resolving the AR UPDATE running slow
• Developed data mover scripts to migrate Allocation steps and Groups.

Environment: PeopleSoft FSCM 8.9(GL, AP, AR, BI, PC, INV, AM,P O, ePro), PeopleTools 8.48, People Code, Application Engine, Integration Broker, SQR, Component Interface, Crystal reports 9.2.3, Oracle 9i,Unix. PeopleTools 8.48, People Code, Application Engine, Integration Broker,SQR, Component Interface, Crystal reports 9.2.3, Oracle 9i,Unix.Environment: PeopleSoft FSCM 9.0(GL, BI, AP, AR, BI, PO, ePro and AM,) PeopleTools 8.50,XML Publisher, DB2,JCL,TSO, People Code, Application Engine, Integration Broker, SQR, Component Interface, Crystal reports 9.0, PS Query.

Confidential, MN

Techno-Functional Consultant

Responsibilities:

• WorkedonHCM 9.0 Enhancements, Support and fixes in HR, Payroll, TAM/CG and self-service modules
• Implimented Incentive Plan (ePerformance) for all Confidential US & Global Employees salary planning. As part of Implementations, created cutom HTML pages, Edits, SQR's, App Engines, CI’s (Excel to CI).
• Customized Contract Administration in HR to Include Employee Agreement Contracts.
• Responsible for Requirement gathering & Analysis for Contract Administration changes to Include employee agreements from Users. Involved in interface developing with third party vendor Meetings.
• Involved in Creating & Customizing Records/pages/components to implement Merit Increase Plan and Employee agreements.
• Responsible for developing Interfaces, online page/component changes with required business rules, Edits using SQR, peoplecode Programming.
• Designed & Developing Inbound & outbound interfaces using SQR to vendor Towers&Watson for Processing Employee Agreement Contracts.
• Responsible for Calculating Plan ratings and Consideration Amounts for MIP Salary plan.
• Extensively worked with creating Group Builds and Used them for Queries and SQR's.
• Responsible for Developing SQR to Load Contract Data for Employee Agreements from variable pay and MIP data.
• Extensively used FTP/SFTP with pgp Encryption for transfer of files via Jscape/webmethods to vendors. Responsible for Setting up FTP definitions in Confidential Custom FTP setup.
• Wrote & Documented Minnesota new hire Report. Worked on custom payroll Summary and Detail, Compensation by state and Sick hours Audit Reports.
• Worked on CI Excel to CI to load Incentive Plan.
• Involved in SOX Automated Audit process to Audit Hrsytem Changes in Production with proper Ticket Numbers. Responsible for developing sox audit pages/componentsand SQR's. Worked on creating workflow work list items for the users to review the edits.
• Designed & Developed 4 Outbound Interfaces and 1 Inbound Interface using SQR for State Goverment Vendor. Used SFTP PGP Encryption for the transfer of files via Jscape/webmethods.
• Designed and Developed one inbound Interface to load Deduction tables with proper deduction data coming from Vendor.
• Developed and Used Custom views for the pages and prompt records.
• Extensively used DMS Scripts with Data Mover for the the data conversion.
• Involved in setting up user security, creating custom Roles and Permission list according to the user groups.
• Performed Unit Testing and involved in System integration and UAT testing.
• Responsible for gathering user-requirements, Project Plan, and develop technical documentation including technical specifications.
• Hands on Experience with Tree manager, and investigation of issues and data integrity using PS query and TOAD.
• Extensively used process scheduler to create & schedule Processes/batch Job Processes with Recurrences.
• Extensively used TOAD for database queries.
• Extensively used STAT to migrating peopolesoft objects/post migrate dms/SQR’s.

Environment: PeopleSoft HCM 9.0, People Tools 8.49, HR, N.A Payroll, TAM/CG, Self-Service, ePerformance, Benfits, Security, SQR, Application Engine, People code, Application Package, Work flow, PIA, STAT 5.5, Oracle 10g, TOAD, Jscape/Web Methods, Documentum 6.0sp1, UNIX, Windows

Confidential, Houston, Texas

PeopleSoft FSCM 8.8/9.0(Up gradate and support) Technical Consultant

Responsibilities:

• Modified Change Assistant templates such as adding steps to template, editing steps, deleting chapters, tasks and updating scripts.
• Ran compare reports to get all customizations in Production environment. Also worked on Fit gap analysis to detect applicable new functionalities implemented in PS 9.0 v.
• Ran SysAudit, dddaudit and Alter audit reports and has cleared Target environments by deleting inconsistent tables and orphaned objects.
• Involved in discussions with Financial and HR functional teams for Upgrade Project planning and for listing new functionalities to be applied.
• Completed initial test pass and Move to Production phases of upgrade.
• Modified the Crystal Report APY2021- for solving the issue of check overflow which causes the creation of live check in the next paper.
• Modified the custom Application Engine Y IBI ITSCLM when vouchers are not getting creating from a flat file if the amount is over $999.99
• Solved the issue of giving the wrong accounts in the vouchers and realized after the voucher is posted.
• Solved the issue when the POs are not getting created from Requisitions
• Worked on PC AP TO PC application engine program to collect all the costs occurred in AP.
• Removed the Product translation from a custom Application Engine
• Solved the issue of Vouchers were not getting created from the staging tables modified an application package AP to get the back up of the positive payment file each time the pay cycle runs
• Modified PORQ010.sqr to get the comments printed or not printed according to a check box
• Modified the APY2021- query to print the invoice lines even if the vouchers are over the vouchers specified in Banking of peoplesoft
• Created a notification template for the users to notify their superior through the notify button
• Created a custom Application Engine Y IBI PREREF Interface to create the vouchers from a flat file, which saves alot of time and we can get rid of entering all the one time vendors and then create vouchers from those vendors.
• Set up the workflow for Purchasing. this will save alot of time to create e-mail and explain the PO and copy the approval text to the PO.
• Set up the workflow for Requisitions. this will save alot of time to create e-mail and explain the Requisition and copy the approval text to the PO.
• Customized PO Dispatch/print, Close purchase order(POPO005), Back order status(POPO012), PO not received(POVRB300) Reports.
• Developed a Component Interface to load the vendor information from a flat file.
• Also involved in the fixing the problem for the integration Broker dat is setup for syncing the payroll data between PeopleSoft HR and PeopleSoft Financials
• Set up the business process to get the link between the Contracts and Purchase Orders and Vouchers.
• Created custom Set up for Bank Reconciliation.

Environment: PeopleSoft FSCM 9.0(GL,AP,AR,BI,PC,INV,AM,PO,ePro) PeopleTools 8.50,XML Publisher, DB2,JCL,TSO, People Code, Application Engine, Integration Broker, SQR, Component Interface, Crystal reports 9.0, PS Query.

Confidential, Houston, Tx.

PeopleSoft Technical Developer

Responsibilities:

• As a technical consultant, my responsibility was to customizing record and page definitions, components, menus, App engine, SQR and PeopleCode programs needed to be changed to meet the business needs of the client, which encompasses study of the business process and flow.
• Writing PeopleCode to implement the required business rules and to validate the data entry process.
• Providing security for the pages, components and objects using maintain security and object security.
• Modifying existing report formats and added new reports using SQR to generate reports of the customized application as per the requirements.
• Used Process Scheduler to run the processes & reports through PeopleSoft and used process monitor to view the status of the reports.
• Developed Application Engine programs to convert the data from flat files to PeopleSoft Tables.
• Used PS/Query to develop ad-hoc queries.
• Aided the users and functional analysts to perform data mapping from the legacy system to PeopleSoft.
• Customized and developed various Crystal Reports according to the user requirements.
• Involved in data migration using Component Interface.
• Helping the users in Payroll and Benefits with various transactions involved.
• Developed and customized the SQL objects to insert them into the customized rule steps for T&L
• Involved in applying patches to Development and Test environments.
• Involved in Communicating and collecting the 3rd party schedules through flat files & Time Reporting Codes analysis.
• Worked with File Layouts to Load the 3’rd party Schedules in T&L.
• Involved in meetings with users to understand the business requirements and to design the Rule’s.
• Worked with App Messaging EOP PUBLISH and ST LOADER to load the time into the T&L System
• Worked extensively in debugging Time Administration.
• Involved in customizing PeopleSoft delivered SQR reports such as Non-monitory awards report, List of vehicles report etc.
• Created TRC Programs and Value List’s and added them to Rule Programs and Rules to Validate the Contracts.
• Involved in analyzing and mapping the TRC’s to ERNCD in development and testing environment.
• Developed AE program to load the 3’rd party schedules from flat file to SCH ADHOC DTL.
• Developed SQR to report the TCD load after ST LOADER successful.
• Developed and customized rule’s using templates for Bargained and Non Bargained contracts.
• Involved in tracing and fixing the problems for Time and Labor and Payroll
• Developed a Query for field managers to collect their employee’s schedules.
• Created & worked with Time Admin temp tables & state records
• Involved in the setup of Variable Compensation and its corresponding self-service module.
• Involved in writing App-Engines from scratch for loading compensation information from 3rd party systems.
• Created Data Mover scripts to copy rules between databases and to compile the rules when the production flag is on for Time and Labor.
• Worked Extensively with Component Interface, application messaging and App Engine.
• Involved in upgrading PeopleTools from 8.1 to 8.4.
• Involved in writing technical specification and unit testing documentation.

Environment: PeopleSoft HRMS 8.8 (HR, Benefits, Time and Labor, NA Payroll), PeopleCode, SQR, Oracle 9.x, People Tools 8.40, PS Query, Crystal Reports, Windows NT.

Confidential, Tampa, FL

PeopleSoft Technical Developer

Responsibilities:

• As a Technical Consultant I was responsible for Implementation enhancements to the PeopleSoft HRMS to maintain human resource data.
• Designed data conversion strategy to convert the existing data in legacy system to PeopleSoft application tables incorporating required validations and data transformations
• Developed SQR programs to perform data conversion and import data from legacy system to PeopleSoft database
• Creation of records views and pages using Application Designer and modified several pages to take care of additional fields and validations.
• Extensively used PeopleCode for achieving field level security.
• Designing and development of several new SQR Reports and also edited several reports.
• Developing SQR Reports for data migration.
• Extensively used People Tools for creation and modification of Process Definitions, Records, Pages, and Menus to run Custom SQR reports through PeopleSoft environment.
• Controlling the access of the different objects using different security features.
• Setup tables and manage Payroll process. Create Paysheet (earnings), Payline, and Online check.
• Extensively worked on set-up of Time periods, shifts, reason codes, Task profile templates Task entity codes, Task Groups and Work Groups.
• Created rules for overtime, holiday, time reporter status, TRC approvals, and comp time. Developed queries dat check for eligibility, time not reported, time dat needs approval, time dat is over 8 hours per day, time dat uses holidays, and an assortment of other queries dat payroll had requested.
• Customized various delivered rules for Time Administration.
• Extensively worked on set-up of Time periods, shifts, reason codes, Task profile templates Task entity codes, Task Groups and Work Groups.
• Used Process Scheduler to Schedule Tasks as per the Project Requirements.
• Designed and developed custom PeopleSoft on-line panels with extensive PeopleCode, conversion and interface programs for the Time & Labor.
• Developed audit and log reports, which give the information about the records being updated during import process and also of those data, which do not meet the imposed validations.
• Implemented object and operator security using Maintain Security.

Environment: PeopleSoft HRMS 8.3 (Core HR, NA Payroll, Benefits, Time and Labor), PeopleCode, SQR, MS SQL Server 2000, People Tools, Windows NT.

Confidential, Austin, TX

PeopleSoft Technical Developer

Responsibilities:

• As a Technical Consultant I was responsible for studying existing systems through discussion with Users to understand the modules and business processes, and carry forwarding the existing business processes to the new version of PeopleSoft HCM 8.8 and supporting all HR dept.
• Creating technical design documents based on the functional specifications and gatheird requirements.
• Creating/Customizing Fields, Records and building records to create database objects related to these records, Pages, Components, Menus and Registering the objects into Portal Registry.
• Identified the structural differences and did analysis on reports and interfaces which need’s modification.
• Re-implemented the customizations dat are not applied after running the upgrade scripts.
• Creating inbound (program, which takes data from flat data file and puts it into database) as well as outbound (program, which takes data from database and puts it into flat data file) interface programs using SQR for data migration between systems.
• Involved in Customization/Development using SQR, PS Query for reports and Application Engine Programs for background Processing.
• Loaded the custom setup rules data files to PeopleSoft through Component Interface using AE.
• Worked on setting up approval process workflow for job offer and job opening.
• Developed and created e-mail notifications, worklist items in workforce administration workflow.
• Customized the pages and SQR’s related to Benefits.
• Involved in the implementation, customization of Self Service modules ePerformance, eProfile, ePay and eBenefits.
• Tested the SQRs and Application Engine programs developed for PeopleSoft 8.3 environment and making necessary changes for running the program in PeopleSoft 8.8 environment.
• Unit Testing of PeopleSoft Objects, Interfaces and Reports. Preparing Test cases and Test Plan.
• Managing the objects into project for migration.
• Involved in Performance Tuning, Optimization of SQL statements used and Monitoring of PeopleSoft Environment.
• Following specified Quality procedures and documenting all tasks during SQR reports and PeopleSoft Objects development.
• Impart end user training in the new functionality and environment, troubleshooting and resolve problems faced by the users.
• Writing Shell scripts for scheduling the batch programs.
• Involved in PeopleSoft server’s administration related tasks.
• Migration and comparison of the objects using Upgrade Assistant.
• Involved in applying Tax Updates and patches.
• Researched some of the security policies proposal issues needed by the Security team.

Environment: PeopleSoft HCM 8.8/8.3 (HR, Base Benefits, N.A Payroll, Time & Labor, People Tools 8.42/8.46, Oracle 10g, PS Security, workflow, SQR, PL/SQL, Toad, MS-Access, Windows NT, AIX/UNIX)