Technical 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
• ERRORS Lists journal lines, which show a budget check error

Technical Expertise:

• 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

Role : PeopleSoft Upgrade Analyst

Project: This project is for providing Upgrade, attend specific requirements of client involving customizations, enhancements, reports and interfaces Upgrade

Responsibilities:

• Prepare and issue requested project status reports covering all assigned pending and current project activities
• 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
• Wrote Data mover scripts for Migration of Data Across Different Databases for the Custom and Delivered Tables to fix the Data conversion Issues
• Tailored People Code to implement data validation and to enforce field level security.
• Modification involved in changing Search records to establish row level security. Customized the views in order to accomplish row level security.
• 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.
• 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
• 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
• 1. Budget Transaction Detail B-T-D
• 2. AR CUSTPAYMENTS Payments received from customer
• 3. UB EX RPT LISTING expense report lines
• 4. UB GL JRNL BUDGET CHECK ERRORS Lists journal lines, which show a budget check error
• 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
• Extensively used Process scheduler for setting up the reports to run at specific time
• Development Environment: PeopleSoft FSCM 9.0, 9.2 , People Tools 8.50, 8.53 , Oracle11g
• People Tools used: Application Designer, PeopleCode, Application Engine, Application Packages, App Messages, CI, SQL, Process Scheduler Manager, BI Publisher and SQR

Confidential

Role : PeopleSoft Developer

Project: This project is for providing Development, attend specific requirements of client involving customizations, enhancements, reports and interface developments

Responsibilities:

• Setups at the business unit level, lifting of combo rules to post journals and Journal unlock
• Developed SQR Interfaces to get Siebel data and populate in PS Database
• Developing and running Post Go-Live scripts to perform select and deletes for Base and Non-Base tables.
• 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
• Provides technical design, development and support for the PeopleSoft Purchasing and Procurement Application
• 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
• 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
• Developed a Modal PeopleSoft Test Framework in PIA using PeopleCode
• Development Environment: PeopleSoft FSCM 9.2, People Tools 8.53, Oracle11g
• People Tools used: Application Designer, PeopleCode, SQR and Process Scheduler

Confidential

Role : 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 on Paycheck page Customizations 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 in Payroll processing, 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

1. Sanitation Worker's Holyday List

2. Sanitation Worker's Sunday List

3. Officers Chart List

4. BORO's Snow Vehicle's List

5. Dressable Equipment's for Garage/Boro

6. Down Vehicle list of Garage/Boro

• 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

Development Environment: PeopleSoft HCM/FSCM 9.1, People Tools 8.52, Oracle11g

People Tools used: Application Designer, PeopleCode, Application Engine, Application Packages, App Messages, CI, IB, SOAP, Process Scheduler Manager and BI Publisher

Confidential

Role : 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
• Development Environment: PeopleSoft HRMS 9.1 , People Tools 8.51 , Oracle 10g
• People Tools used: Application Designer, Application Engine, PeopleCode, Process Scheduler Manager and SQR

Confidential

Role : PeopleSoft Developer

Responsibilities:

• Retrofitting of SQL / XML or BI Publisher /nVision reports in the new version and reapplied peoplecode 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...
• Compare Report reviewed and impact analysis of customizations
• Configuring Base tables and Setup
• Upgraded PeopleSoft HRMS HR, Payroll, Base Benefits and Time Labor
• Upgraded the HRMS Application from 8.9 to 9.1 and PeopleTools from 8.48 to 8.51
• Retrofitted SQR's to incorporate 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

1 Part time working full time

2 Update calendars with runids from flat file

3 Import tax data

4 Payroll money order data

5 Equal Employee Opportunity EEO

6 Update sal plan/grade

• Development Environment: PeopleSoft HRMS 8.9, 9.1 , People Tools 8.48, 8.51 , Oracle 10g.
• People Tools used: Application Designer, PeopleCode, Application Engine, SQL, CI, XML, Process Scheduler Manager and SQR

Confidential

Role : PeopleSoft Developer

Responsibilities:

• Upgraded the application from 8.8 to 9.0 and PeopleTools from 8.44 to 8.50
• 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.

Development Environment: Windows 2000/ SQL Server, PeopleSoft FSCM 8.8, 9.0 , People Tools 8.44, 8.50

People Tools used: Application Designer, PeopleCode, Application Engine, Component Intfc, Process Scheduler Manager and SQR

Confidential

Role : 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.
• 1. 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

1. Passport Exp Details.

2. Termination Report.

3. Allowance Reports

4. Residence Report.

Development Environment: Microsoft SQL Server 2000, PeopleSoft HRMS 8.8 , People Tools 8.48

People Tools used: Application Designer, Application Engine, PeopleCode, CI, File Layouts, Process Scheduler Manager and SQR

Confidential

Role : PeopleSoft Developer

Responsibilities:

• Upgraded the Application from 8.8 to 9.0 and PeopleTools from 8.48 to 8.50
• 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...
• Apply customizations: Created and retrofitted SQR, Component interfaces and to fulfill the requirement of the latest needs on HCM 9.0
• Developed SQR's on Time and Labor Module.
• 1. Transfer Employees, Approve Transfer, Assign Work Schedule, Full/Part Time Status, Location Change
• Developed inbound and outbound interface programs using Application Engine and Component Interface based on data flow diagrams.
• Developed People code customizations on Employee Reported Time Start Time, End Time and Location Change on Manager Self Service Module.
• Customized the CI for Civil Id of the employee.
• 1. Mapping the Civil Id Data Using CI.
• Tested and Migrated developed objects to Target Database

Development Environment: Microsoft SQL Server 2000, PeopleSoft HRMS 8.8, 9.0 , People Tools 8.48, 8.50

People Tools used: Application Designer, Application Engine, PeopleCode, CI, File Layouts, Process Scheduler Manager and SQR