SUMMARY

• Over 8 years of experience as a PeopleSoft Financials/SCM, HCM Techno - Functional Consultant.
• Experienced in PeopleSoft application Design, Implementation, Development, Customization, Maintenance and Support, Upgrade, Security Administration, System administration, Requirement Analysis and Testing
• Experienced in application development using People Tools and has knowledge on application designer, people code, component interface, application engine, PS query and sqr reports and is well conversant with PS HCM and PeopleSoft Financial applications
• Has working knowledge of retrofitting the customizations during upgrades(8.9 to 9.1, 8.8 to 9.0, 9.0 to 9.2)
• Experienced in functional aspects of PeopleSoft HCM in Core HR, Benefits and NA Payroll, TAM and LAM and PeopleSoft Financials in OM, INV, PO, AP, AR, Billing, Project Costing AM, MM, RM, Commitment Control/Budget and GL modules
• Developed reports for these modules using PS Queries, SQR and XML/BI Publisher
• Worked on mapping functional requirements to technical requirements.
• Extensively worked with Security Administrator to implement security at various levels. Created Roles, Permission Lists, User Profiles, Portal Security, Folders, Content References and Definition Security
• Performed extensive Debugging and Performance tuning of various processes. Well versed in utilizing tools and utilities like PC Debugger, Application Engine trace for troubleshooting.
• Planning and Implementing Post-Production support and services like End-user Training, Data Archives and Reporting.
• Expertise in applying Patches and Bundles and retrofitting SQRs.
• Modified SQL / XML or BI Publisher /nVision and Crystal reports in the new version
• Well experienced in configuring and maintaining PeopleSoft Internet Architecture (PIA) elements like Application Server, Webserver, Tuxedo and Process Scheduler.
• Worked on interface programs for migrating data from other systems to People Soft
• Involved in analysis, implementation and customization of HR/Benefits/Payroll modules
• Proficient in PeopleSoft online security and row level security and PS query and setting up foundation tables for Core HR, Benefits, Ben Admin and Payroll
• Proficient in administering Jobs in Process Scheduler
• Experience interacting with End Users and Customers to gathering requirements
• Experienced in gathering requirements for creating and maintain PS queries and administer queries.
• Developed PS queries in order to help the client day-to-day activity like Budget Status Report,, Journal Entry Detail, Un Paid Items which have been billed
• Developed Pivot grids and pagelets as per the client requirement for Budget Transaction Detail (B-T-D), AR CUSTPAYMENTS (Payments received from customer)UB EX RPT LISTING (expense report lines), UB GL JRNL BUDGET CHECK

TECHNICAL SKILLS

OPERATING SYSTEMS: Windows NT/ 95/ 98/ 2000

ERPs: PeopleSoft HCM/FSCM (8x, 9.x), PeopleTools 8.53/8.52/8.51/8.50/8.48

LANG/ TECH: C, C++, HTML, SQL Plus and PL-SQL

DATABASES: MS SQL Server and Oracle 9i/ 10g, 11g

TOOLS: Application Designer, People Code, Application Engine, Application Package, Component Interface, File Layout, IB, Workflow, Process Scheduler, SQR, PS Query, Data Mover BI Publisher, Configuration Manager, Tree Manager, Query Manager, Process Scheduler, Process Monitor, Security Administrator and Utilities

PROFESSIONAL EXPERIENCE

Confidential, CA

PeopleSoft Upgrade Analyst

Responsibilities:

• Involved in upgrading of FSCM 9.0 to 9.2 along with streamlining of customizations and testing of all new 9.2
• Involved in the PeopleSoft Upgrade Project for Project Costing, OM, INV, PO, AP, AR, BI, Commitment Control and GL Modules.
• Involved in fit/gap analysis, analyze customization of online objects after reviewing the compare reports, detail design, development, testing. Troubleshoot/debug, performance tuning and Production Support. Developed and tuned scripts for data conversion using SQL/SQR, Application Engine and Data Mover.
• Modified the functionality in Order Management to disallow change or cancellation on orders if the item on the order is on allocation, reservation or confirmed status.
• Developed conversion program to load un processed accounting entries into GL
• Developed, retrofitted and customized SQR and online PeopleSoft objects such as Translate values, Fields, Record, Pages, Component, Menus, PeopleCode, AE, SQL, CI, App Packages, App Messages, Service Operations, Jobs, Job Definitions, Process Definitions etc...
• Modified SQL / XML or BI Publisher /nVision and Crystal reports in the new version
• Retrofitted and applied customizations to delivered SQR PODISP.SQR to Dispatch/Print Purchase Order and then the Email process
• Modified the POPO005.SQR to not to send the email notifications
• Retrofitted and applied customizations to delivered Application Engine programs PO Stage Load process(PO POSTAGE) and Receive Load process(PO RECVLOAD)
• Applied customizations to Allocation Workbench in Fulfilling Stock Orders(Added Group by Item and Group by Bill To search)
• Applied customizations the Create/Update Order page
• Retrofitted and applied customizations to the Item Loader process(IN ITMLOAD) which validates and process the Item Price from vendor and Item master data
• Applied customizations and Troubleshooted the job definitions (ARAUTOMT, ARUPDATE, NEM MAIN, PODISP, PO POREP, RECV 04, SFCLOPRD)
• Customized the Application Engine process (PO RECVACCR) Interfaces Receipt Accrual process to load unbilled receipt amounts in a receipt accrual liability account and debits identical amounts from the designated expense accounts into General Ledger module. Before loading, the data would be edited through ChartField validations and combo rules
• Developed ad-hoc reports and ad-hoc queries and developed run control pages as per requirements and attached to menu to run SQRs
• Involved in training the users and developed hand out documents that are used by the users for understanding the new changes
• Retrofitted and fixed numerous queries and Crystal reports as part of 9.2 upgrade.
• Developed PS queries in order to help the client day-to-day activity like Budget Status Report,, Journal Entry Detail, Un Paid Items which have been billed
• Involved in training the users and developed hand out documents that are used by the users for understanding the new changes
• Developed Pivot grids and pagelets as per the client requirement
• Designed and developed various other conversion and Interface programs using SQR, like Customer Conversion & Interface, AR Open Item Balances, Asset Conversion, Vendor Conversion, Voucher Conversion etc.
• Used Application up grader to migrate objects from Demo to Target instance.
• Applied customizations to the Trial Balance Page in GL by maintain the dynamic prompt between Business Unit and Ledger and set default values to Currency Option and Currency Code
• Modification involved in changing Search records to establish row level security. Customized the views in order to accomplish row level security.
• Tailored People Code to implement data validation and to enforce field level security.
• Extensively used Process scheduler for setting up the reports to run at specific time
• Wrote Data mover scripts for Migration of Data Across Different Databases for the Custom and Delivered Tables to fix the Data conversion Issues
• Attend project status meetings to review project progress and present risks including issues and constraints that are impeding or may impede project performance. Provide recommendations for risk mitigation
• Prepare and issue requested project status reports covering all assigned pending and current project activities

Confidential, CA

PeopleSoft Developer

Responsibilities:

• Implemented PeopleCode to dynamically change prompt table for PIM, based on SETID and PRODUCT ID selections. This involved use of component level PeopleCode, passing rowset objects from component level to field change PeopleCode.
• Developed Interfaces to populate Project Costing data into Billing
• Provides technical design, development and support for the PeopleSoft Purchasing and Procurement Application
• Developed an Interface to publish the Denied Party Screening data from External system to Order Management using Application Engine, Application Packages, File Layout & Component Interface
• Developed SQR’s which creates a copy of the existing test script and updates the same with different test data for Test Cases types ‘Test’ and ‘Shell Test’
• Worked on online PeopleCode to meet the customizations, validations and dynamic sqls
• Developing and running Post Go-Live scripts to perform select and deletes for Base and Non-Base tables.
• Developed SQR Interfaces to get Siebel data and populate in PS Database
• Setups at the business unit level, lifting of combo rules to post journals and Journal unlock
• Developed a Modal PeopleSoft Test Framework in PIA using PeopleCode

Confidential, NY

PeopleSoft Developer

Responsibilities:

• Created Technical Specs for the use cases and FDD’s and undergone the development and testing for the same
• Involved in the PeopleSoft Implementation Project for Core HR, Benefits, NA Payroll Modules, TAM and LAM and Asset Management, sPro (Resource Management and Maintenance Management)
• Involved in setup of Set ID table, Company Information, Establishments, Location, Department, Salary plan, Job Code and Pay Group tables for HRMS System
• Developed an application engine program using file layouts to load new hire interface file with all new hired employees’ information after each day and load them into the people soft tables.
• Created custom setup pages and developed asynchronous integration between setup pages in HCM and FSCM using integration Broker
• Worked onPaycheck pageCustomizations to change the search keys for better page performance and comma formatting of the amount fields on the Pay Check Summary page
• Applied Customizations and maintained all the tables involved inPayrollprocessing, such as Pay calendar, JobCode, Deductions and Processes such as Paysheet creation, PayCalc, Payconfirm, Tax Tables etc
• Developed a custom page(Additional Employee details of NYC) under JOB DATA component
• Customized the PERSONAL DATA and JOB DATA components
• Applied customizations to Work Order page
• Developed Integrations to populate the employee in HR as Resource in Resource Management
• Developed Application Engine Programs to populate Job data and Job Related custom data using file layouts and component interfaces
• Created New PeopleSoft Objects like Fields, Records, Pages, Menus, and Components, Application Packages, Application Messages, SQL Objects, Application Engines, Component Interfaces, IB Services
• Customized HR, payroll menus, enquiry pages as per the user requirement so that user can view more information
• Customized SQL Views, Records and People Code functions like SQL Exec, Rowsets etc.
• Maintaining PeopleSoft user security using user profiles, roles & permission lists
• Involved in analysis of bugs during SIT and UAT. Used HP quality center for defect analysis, defect resolutions and closure
• Developed various PS queries in order to help the client day-to-day activity
• Tested the developed Applications and interfaces
• Involved in Data mapping between PS system and Third Party system
• Created Web Services to Publish the work force and assets data on Operations Board
• Tested WSDL’s by using FUSION SOAP middle ware
• Worked extensively on Application Engine, Application Designer, People Code, Application Package, Integration Broker, Fusion(SoapUI), CI, PS Query, BI Publisher
• Done the peer-review for the developments, UTP Preparation and documentation

Confidential

PeopleSoft Developer

Responsibilities:

• Developed Inbound Interfaces using SQR for loading employee’s data into PeopleSoft HRMS system for Payroll Deduction Life Cycle from MetLife Insurance
• Developed Inbound Interfaces using Application Engine for writing file of employees who are eligible for MetLife Auto & Home policy based on employee status code
• Developed tax reports using xml and application engine and Rowset as a source
• Developed SQR which generates report based on program run status
• Created New PeopleSoft Objects like Fields, Records, Pages, Menus, and Components
• Created and executed SQL scripts to perform select and deletes on Base and Non-Base tables
• Performance review and testing of conversion programs as per the design documents

Confidential, TX

PeopleSoft Developer

Responsibilities:

• Upgraded the HRMS Application from 8.9 to 9.1 and PeopleTools from
• Upgraded PeopleSoft HRMS - HR, Payroll, Base Benefits and Time & Labor
• Configuring Base tables and Setup
• Compare Report reviewed and impact analysis of customizations
• Developed, retrofitted and customized SQR and online PeopleSoft objects such as Translate values, Fields, Record, Pages, Component, Menus, PeopleCode, AE, SQL, CI, App Packages, App Messages, Service Operations, Jobs, Job Definitions, Process Definitions and Permission Lists etc...
• Retrofitting of SQL / XML or BI Publisher /nVision reports in the new version and reapplied peoplecode customizations
• Retrofitted SQR’s to in corporate the functionality in the upgraded version: Payroll summary, Report promotions/demotions, Payroll money order data, Set environment, Part time percentages, cost center report, life rates, load one time pay adj from flat file, custom - prompt for dates, create file for ckmgrbs from spreadsheet data.
• Involved in design and development of conversion programs using SQR for transferring of data from legacy system to PeopleSoft HRMS
• Reapplied SQR customizations for modules like North American Payroll, Time and Labor, Benefits Administration, eProfile (self service applications) etc.
• Task monitoring, Status reporting On Daily and Weekly Basis
• Tested all retrofitted and customized SQR’s
• Retrofitted and developed SQR’s

Confidential, LV

PeopleSoft Developer

Responsibilities:

• Upgraded the application from 8.8 to 9.0 and PeopleTools from
• Compare Report reviewed and impact analysis of customizations
• Developed, retrofitted and customized SQR and online PeopleSoft objects such as Fields and Translate values, Record, Pages, Component, Menus, PeopleCode, AE, SQL, CI, App Packages, App Messages, Service Operations, Jobs, Job Definitions, Process Definitions and Permission Lists etc...
• Applied Enhancements to People Code programs
• Developed new online objects and Queries
• Troubleshooted various issues related to Voucher posting and payment posting
• Customization of existing interfaces, reports and queries
• Developed new SQR and Application Engine programs for interfacing
• Executed SQL’s to change the voucher origin for the specified voucher.
• Performed interim refresh job for every quarter.

Confidential

PeopleSoft Developer

Responsibilities:

• Generated SQR’s for employee nationality details.
• Created new PeopleSoft objects like Fields, Records, Pages, Menus, and Components.
• Developed Peoplecode to get Employee Leave Date in Absence Monitory Module.
• Employee Absence History and Leave Break History.
• Inbound data from legacy system to PeopleSoft database using Excel to CI.
• Developed an AE program to get employees Job data related to Self Service Module.
• Developed AE Program to get employee degree data
• Customized and retrofitted SQR’s