SUMMARY

• Over 8+ years of IT/ERP experience in Software Development Life Cycle particularly in PeopleSoft HCM, Financials and SCM systems. Experience in teh 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 teh functionality of teh system to suit teh 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, Jacksonville, FL

PeopleSoft Techno-functional & Analyst

Responsibilities:

• Gathered 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.
• Gathered business process requirements and participated in fit-gap analysis, and Identified RICE Object & Proposed solution for teh gaps
• Responsible for leading data mapping sessions for conversion (ADP to PeopleSoft) and assisted teh Functional team with translation logic & preparation of conversion strategy plans (Data Profiling, Mapping, Cleaning & Reconciliation)
• Modified teh Delivered workflow for Time and Labor for teh 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 teh system to perform teh business process for teh 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 teh 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 that resulted in teh high exception.
• Maintain Technical documentation for teh 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. Gathered 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. That 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. dis 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. dis Involved writing generic App package and new interfaces for User. dis Interface module provides user to edit teh interface file data online if there is any error and resubmit teh program.
• Involved in teh fixing teh problem for teh integration Broker that is setup for syncing teh payroll data between PeopleSoft HR and PeopleSoft Financials
• Involved in developing real time Asynchronous Integration from PeopleSoft Financials to HCM for teh 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 teh 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 that are opened through teh 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. (dis takes more TEMPthan 30 days.) Created custom process to create BAS Table Entry with custom action so that 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 teh chartfields details from Financials to HRMS using integration broker.
• Configure and setup teh User Profile, Role Maint, Delete User Profile, Delete Role, Role Sync Message EIP’s between teh Enterprise Portal and HR/FSM.
• Developer customized AWE(Workflow Engine) from end to end for PAR transactions Approval process, so that 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 teh new key structure.
• Created Permission lists, users, roles and assigned roles to users through Maintain Security.
• Worked with Production support team (24/7) during teh Bi-weekly North American Payroll run process to fix any problems for teh 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 teh discussions related to adding contractors to teh PeopleSoft. Defined and implemented teh process for adding contractors to teh PeopleSoft. Modified Records, Translate values, People Code during dis 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 teh PO and load teh freight information back into PeopleSoft.
• Involved in gathering teh requirements for integration and participated in teh business meetings with third party.
• Configured teh integration gateway, loading teh connectors and defining teh JOLT connection strings.
• Created remote/external nodes and defined teh connector properties.
• Created routings and service operations.
• Configured teh integration gateway properties file for error log and message log files.
• Created JCL wrappers to run batch programs.
• Asynchronous messages are fired from teh 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 teh issue of giving teh wrong accounts in teh vouchers and realized after teh voucher is posted.
• Solved teh issue when teh POs are not getting created from Requisitions
• Updated EFT fineft23.sqc to print teh invoice number on teh EFT text file, which will be comfortable to teh vendors. dis solved teh problem of getting teh court id on teh EFT file for teh payments to teh Garnishment.
• Worked on PC AP TO PC application engine program to collect all teh costs occurred in AP.
• Removed teh Product translation from a custom Application Engine
• Solved teh issue of Vouchers were not getting created from teh staging tables
• Solved teh issue of check when one invoice line has not been printed
• Created a new nvision to get teh vendor name for some nvision report.
• Created a Query to get all teh vouchers created for a particular vendor
• Solved teh issue of Voucher Matching since teh POs were forcefully closed before they were matched completely modified an application package AP to get teh back up of teh positive payment file each time teh pay cycle runs
• Created a notification template for teh users to notify their superior through teh notify button
• Created a custom Application Engine Y IBI PREREF Interface to create teh vouchers from a flat file, which saves alot of time and we can get rid of entering all teh one time vendors and tan create vouchers from those vendors.
• Developed a Component Interface to load teh vendor information from a flat file.
• Also involved in teh fixing teh problem for teh integration Broker that is setup for syncing teh payroll data between PeopleSoft HR and PeopleSoft Financials
• Set up teh business process to get teh link between teh 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 teh Re-Design of teh complete interface of teh TODS Interface Customized Interface which involves teh inbound interface of teh 3rd Party file prep for teh AR Update with teh Billing Information
• Created buyer purchasing attribute where buyers can update certain fields instead of all on teh 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 teh WSDL’s.
• Customized POPO005.sqr to teh business requirements
• Involved in code and test work unit identified by teh Inventory and Order Management functional team.
• Worked on ePro workflow process.
• Added Lines to teh Billing Interface Tables INTFC BI, INTFC BI HDR
• Involved in teh Dunning letters to teh customers, streamline teh issue of teh level of letters send to customers Involved with tune couple of SQL’s in teh 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 teh PO workflow for Expense PO's. Redesigned teh workflow to add teh new business rule to route teh Expense PO's to appropriate approval levels and approvers. Teh requirement was to pick a different Approval rule set if it is Expense PO and dis was done dynamically.
• Involved in creating public queries for teh users to query against teh CUSTOMER and CUST CRSPD tables for obtaining teh Dunning details of teh customer.
• Solved various issues with ePro Workflow in UAT and Regression testing
• Fixed closure part of teh 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 teh checks using new printer in AP.
• Involved in design of teh SQR, to run before Payment Predictor job to avoid failing of teh job. By updating teh PAYMENT ID CUST where there is no entry for teh 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 teh 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 teh users to review teh edits.
• Designed & Developed 4 Outbound Interfaces and 1 Inbound Interface using SQR for State Goverment Vendor. Used SFTP PGP Encryption for teh 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 teh pages and prompt records.
• Extensively used DMS Scripts with Data Mover for teh teh data conversion.
• Involved in setting up user security, creating custom Roles and Permission list according to teh 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 teh Crystal Report APY2021- for solving teh issue of check overflow which causes teh creation of live check in teh next paper.
• Modified teh custom Application Engine Y IBI ITSCLM when vouchers are not getting creating from a flat file if teh amount is over $999.99
• Solved teh issue of giving teh wrong accounts in teh vouchers and realized after teh voucher is posted.
• Solved teh issue when teh POs are not getting created from Requisitions
• Worked on PC AP TO PC application engine program to collect all teh costs occurred in AP.
• Removed teh Product translation from a custom Application Engine
• Solved teh issue of Vouchers were not getting created from teh staging tables modified an application package AP to get teh back up of teh positive payment file each time teh pay cycle runs
• Modified PORQ010.sqr to get teh comments printed or not printed according to a check box
• Modified teh APY2021- query to print teh invoice lines even if teh vouchers are over teh vouchers specified in Banking of peoplesoft
• Created a notification template for teh users to notify their superior through teh notify button
• Created a custom Application Engine Y IBI PREREF Interface to create teh vouchers from a flat file, which saves alot of time and we can get rid of entering all teh one time vendors and tan create vouchers from those vendors.
• Set up teh workflow for Purchasing. dis will save alot of time to create e-mail and explain teh PO and copy teh approval text to teh PO.
• Set up teh workflow for Requisitions. dis will save alot of time to create e-mail and explain teh Requisition and copy teh approval text to teh PO.
• Customized PO Dispatch/print, Close purchase order(POPO005), Back order status(POPO012), PO not received(POVRB300) Reports.
• Developed a Component Interface to load teh vendor information from a flat file.
• Also involved in teh fixing teh problem for teh integration Broker that is setup for syncing teh payroll data between PeopleSoft HR and PeopleSoft Financials
• Set up teh business process to get teh link between teh 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 teh business needs of teh client, which encompasses study of teh business process and flow.
• Writing PeopleCode to implement teh required business rules and to validate teh data entry process.
• Providing security for teh pages, components and objects using maintain security and object security.
• Modifying existing report formats and added new reports using SQR to generate reports of teh customized application as per teh requirements.
• Used Process Scheduler to run teh processes & reports through PeopleSoft and used process monitor to view teh status of teh reports.
• Developed Application Engine programs to convert teh data from flat files to PeopleSoft Tables.
• Used PS/Query to develop ad-hoc queries.
• Aided teh users and functional analysts to perform data mapping from teh legacy system to PeopleSoft.
• Customized and developed various Crystal Reports according to teh user requirements.
• Involved in data migration using Component Interface.
• Helping teh users in Payroll and Benefits with various transactions involved.
• Developed and customized teh SQL objects to insert them into teh customized rule steps for T&L
• Involved in applying patches to Development and Test environments.
• Involved in Communicating and collecting teh 3rd party schedules through flat files & Time Reporting Codes analysis.
• Worked with File Layouts to Load teh 3’rd party Schedules in T&L.
• Involved in meetings with users to understand teh business requirements and to design teh Rule’s.
• Worked with App Messaging EOP PUBLISH and ST LOADER to load teh time into teh 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 teh Contracts.
• Involved in analyzing and mapping teh TRC’s to ERNCD in development and testing environment.
• Developed AE program to load teh 3’rd party schedules from flat file to SCH ADHOC DTL.
• Developed SQR to report teh TCD load after ST LOADER successful.
• Developed and customized rule’s using templates for Bargained and Non Bargained contracts.
• Involved in tracing and fixing teh 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 teh 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 teh rules when teh 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 teh PeopleSoft HRMS to maintain human resource data.
• Designed data conversion strategy to convert teh 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 teh access of teh 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 that check for eligibility, time not reported, time that needs approval, time that is over 8 hours per day, time that uses holidays, and an assortment of other queries that 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 teh Project Requirements.
• Designed and developed custom PeopleSoft on-line panels with extensive PeopleCode, conversion and interface programs for teh Time & Labor.
• Developed audit and log reports, which give teh information about teh records being updated during import process and also of those data, which do not meet teh 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 teh modules and business processes, and carry forwarding teh existing business processes to teh new version of PeopleSoft HCM 8.8 and supporting all HR dept.
• Creating technical design documents based on teh functional specifications and gathered requirements.
• Creating/Customizing Fields, Records and building records to create database objects related to these records, Pages, Components, Menus and Registering teh objects into Portal Registry.
• Identified teh structural differences and did analysis on reports and interfaces which need’s modification.
• Re-implemented teh customizations that are not applied after running teh 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 teh 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 teh pages and SQR’s related to Benefits.
• Involved in teh implementation, customization of Self Service modules ePerformance, eProfile, ePay and eBenefits.
• Tested teh SQRs and Application Engine programs developed for PeopleSoft 8.3 environment and making necessary changes for running teh program in PeopleSoft 8.8 environment.
• Unit Testing of PeopleSoft Objects, Interfaces and Reports. Preparing Test cases and Test Plan.
• Managing teh 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 teh new functionality and environment, troubleshooting and resolve problems faced by teh users.
• Writing Shell scripts for scheduling teh batch programs.
• Involved in PeopleSoft server’s administration related tasks.
• Migration and comparison of teh objects using Upgrade Assistant.
• Involved in applying Tax Updates and patches.
• Researched some of teh security policies proposal issues needed by teh 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)