SUMMARY

• Senior Programmer Analyst. has over 11 years of global experience in PeopleSoft Development, Upgrades thorough experience with PeopleSoft Products, Financials 9.1,9.0, 8.9, 8.4, Upgrade of PeopleSoft HRMS 9.0, 8.9, 8.0, PeopleSoft CRM 8.9 and People Tools 8.43, 8.46, 8.48, 8.49, 8.50, 8.51, 8.52,8.53 and 8.54.
• He is expert in SQL scripts and having hands on
• Experience in Microsoft SQL Server and RDBMS concepts, worked on data conversions from old systems to new systems and worked on the development of Application Package People code.
• Good knowledge in Application Engine, Messaging, Process Scheduler, BI Publisher and PeopleSoft security.
• He also has experience in Page designing, and other object development using Application Designer. Good experience in configuring the Architectural components of PeopleSoft.
• He has good work experience with the SQR reports and PS Query and good knowledge in AWE Workflow.
• He is having knowledge in Financials PC, AR, AP, ePro, PO, AM, GL and Expense Modules.
• He is having knowledge in HR, Benefits, Payroll and having knowledge in CRM Call Center module.
• He experts in using People Tools & People Code with Integration technologies (Application Engine, Integration Broker / Application Messaging, Component Interface & File Layout).
• Experienced in full life cycle Implementations/ Upgrades/Production support, Data Conversion. Good knowledge on integration of PeopleSoft with third party systems.

TECHNICAL SKILLS

ERP: PeopleSoft 8.9/ 8.8/9.1/9.2 CRM

PeopleTools/concepts (8.49/8.51/8.52/8.53 ): Application Designer, PeopleCode, Application Engine, Application Packages, Integration Broker, Data Mover, Security Administrator and Utilities.

Reporting Tools: SQR, PS Query, BI Publisher, Crystal ReportsnVision

Languages: SQL

RDBMS: Oracle, Microsoft SQL Server

Other Tools: TOAD for Oracle, STAT(Application Change Management), Change Assistance, Control - M

PROJECT EXPERIENCE

Confidential

PeopleSoft Developer

Responsibilities:

• Co-ordinated with business users for requirement gathering and project development team.
• Created requirement analysis document and detailed technical design document for the new requirement and for the enhancement request.
• Developed an application engine program to load Concur SAE expense transaction in PS9.1 and created outbound files to AP Confidential interface process to create vouchers for the VZW, CFS and Telematics Business unit’s.
• Modified the existing 3 AP Confidential inbound Interface program (Stage program - Z IF APGSTG2 and Edit program- Z IF APG EDT, Z IF APGEDT2, Z IF APGEDT3) to process Concur interface file to create expense vouchers.
• Developed a Concur payment confirmation outbound interface process by using an application engine program.
• Developed a Concur SAE Ad-Hoc run application engine program (application engine: Z IF SAE ADH), to process concur expense transaction manually.
• Built a custom page to allow the Concur expense team to validate chartfield strings in Peoplesoft 9.1 prior to updating chartfield values on the Concur expense user profile and the expense report.
• HR Load process (Application Engine: Z HR LD VW) will be modified to load actual job codes for all employees.
• Currently the job codes are defaulted to VZGEN1 through VZGEN6 if the line of business is not VZW or VCG.
• Developed a new Job Code Approval Authority component / page to maintain job code to approval amount mapping.
• This is to eliminate the dependency on the PeopleSoft EWA setup for ER Approval process id.
• Developed a new inbound interface / Application Engine Process to capture Partial (Dollar) Delegations in PeopleSoft9.1 EX module from other ERPs (vSAP, nSAP, VDSI PS9.0, Cost Point).
• Developed a new interface / Application Engine Process to generate approval authority file (720 record) to concur as per concurs layout.
• Developed a new inbound interface application engine program to capture Vendor universal IDs, supplier parents and strategic suppliers with in PeopleSoft 9.1 to track working capital more accurately.
• Added some customization to the PeopleSoft vendor component to reduce exposure of the vendor sensitive personal information (bank account and withholding information) and to prevent potential fraud, the information must protected by masking the data for AP team members assigned the AP department user role.
• Worked on the below development to replace PACE system by VZ Time to collect VDSL employees weekly time reporting hours data with new field VAST ID value from inbound files (from VZ Time to PS 9.1) and supply it to outbound files (PS 9.1 to VDS India) for reporting purpose.
• Configured VZ Time inbound company code to enable VDSL Time transactions in VZ Time
• Modified the VZ Time Inbound process (Z IF LBR HRS) to populate Z VAST ID in Z HRS DTL VDSI table
• Modified the VDS India outbound interface process (Z PC HRS VDS) to include VAST ID value in Project Hours to VDSI India output file.
• Made configuration changes of Allocations to Inactivate the Labour, CAP and Benefit Allocation Groups i.e. Inactivate the Labour, CAP and Benefit Allocation Groups
• VDS India Capitalization Process to populate the VAST ID in Z IND CAP TBL
• Modified the VZ custom Labour Rating application engine process (Z LABOR RATE) to populate Journal line from JRNL LN record.
• Created test Scripts for the new developments and for the enhancements and tested the same in VZW environments.
• Developed 3 new inbound interface program to create TRIRIGA origin voucher for VZW, CFS and Telematics AP business unit’s with VZW custom AP Confidential program.
• Developed TRIRIGA payment confirmation outbound interface program to update back the TRIRIGA origin vouchers payment details.

Operating System: Windows-XP Professional

Languages: PeopleCode

Special Software: PeopleSoft ( Confidential 9.1), People Tools (8.53.14), Oracle11.2.0

People Tools: Application Designer, PeopleCode, Application Engine, SQL, Process Scheduler Manager, AWE and IB

Confidential, California

PeopleSoft Senior Technical Consultant

Responsibilities:

• Co-ordinated with client BSA’s and business users for requirement gathering and project development.
• Created requirement analysis document and TDD for new change request and created test Scripts for the same and tested in ROSS environments.
• Developed the ROSS custom minimum wage and hour’s variance report by using SQR processes.
• Integrated ROSS custom HR escalation system data between Service now and HR application by using application engine process.
• Writing Interface programs AE to connect third party systems which used to send data to Legacy systems to PeopleSoft

Operating System: Windows-XP Professional

Languages: PeopleCode

Special Software: PeopleSoft ( Confidential 8.0), People Tools (8.19), Oracle10g

People Tools: Application Designer, PeopleCode, Application Engine, CI, SQL, Process Scheduler Manager and SQR

Pleasanton, California.

Confidential

PeopleSoft Techno Functional Consultant

Responsibilities:

• Co-ordination between onsite and offshore, played lead role during requirement gathering and project migration with business users and client BSA’s.
• Created requirement analysis document and TDD for new change request and created test Scripts for the same and tested in Confidential environments.
• CreMonitored daily, weekly and Monthly processes.
• Worked on the production issue and client PeopleSoft customizations.
• Worked on nVision, XMLP reports and PS Query.
• Develop and test new features/enhancements to the PeopleSoft
• Serve as a technical resource to team members in all phases of development and implementation
• Coordinating with the Legacy system consultants to understand the data volume in different modules like procurement, PO, Accounts payable AP, Accounts Receivable AR, Asset Management AM, General Ledger GL
• Writing Interface programs AE to connect third party systems which used to send data to Legacy systems to PeopleSoft
• Worked with end users for scheduling End User testing and getting testing done.
• Developed several SQR Crystal reports to generate similar reports which client demanded to be part of migration.
• Developed several Application Engines to process data in the PeopleSoft and also to upload data into PeopleSoft.
• Created modified several components, pages, PeoplCode.
• Involved in Unit Testing System Integration testing.

Operating System: Windows-XP Professional

Languages: PeopleCode

Special Software: PeopleSoft ( Confidential 9.0), People Tools (8.49), Oracle10g

People Tools: Application Designer, PeopleCode, Application Engine, Application Packages, App Messages, Integration Broker, AWE, CI, SQL, Process Scheduler Manager, BI Publisher and SQR

California.

Confidential

PeopleSoft Techno Functional Consultant

Responsibilities:

• Co-ordination between onsite and offshore, played lead role during project transition (With Confidential and previous service providers about client business process and PeopleSoft system) from client SME’s and end users.
• Monitored daily, weekly and Monthly processes for PeopleSoft Confidential 9.1 modules.
• Customized the below BI Publisher Reports
• AP/GL OPEN LIABILITY ACCOUNT RECONCILIATION REPORT
• AP OPEN LIABILITY RECONCILIATION REPORT
• AP UNRECORDED LIABILITY REPORT BY AP BUSINESS UNIT
• AGED VENDOR LIABILITY
• Summary/Details AP/GL OPEN LIABILITY ACCOUNT RECONCILIATION REPORT
• Prepared XMP reports for employee revised salary, leaves summary and designation change.
• Worked on the production issue and client PeopleSoft customizations.
• Created custom AWE in Confidential work force administration for employee disability functionality.
• Created requirement analysis document and TDD for new change request and created test Scripts for the same and tested in Confidential environments.
• Worked in nVision, XMLP reports and PS Query.

Operating System: Windows-XP Professional

Languages: PL/SQL, UNIX, PeopleCode

Special Software: PeopleSoft ( Confidential 9.1), People Tools (8.51), Oracle11g

People Tools: Application Designer, PeopleCode, Application Engine, Application Packages, App Messages, Integration Broker, AWE, CI, SQL, Process Scheduler Manager, BI Publisher and SQR

Memphis, TN, Confidential

PeopleSoft Upgrade Analyst

Responsibilities:

• 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.
• Application support for CRM Sales, marketing, call center support, self-service, ERMS, Customer management, CRM application security
• 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
• Designed and developed Confidential 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
• Perform Insert/Update on METADATA tables using application engine, peoplecode and SQR
• 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
• Worked on Integration Broker and Application Class PeopleCode and AWE Allocation Workbench in Fulfilling Stock Orders

Operating System : Windows7 Professional

Languages : PL/SQL, UNIX, PeopleCode

Special Software : PeopleSoft ( Confidential 9.1), People Tools (8.51), Oracle11g

People Tools : Application Designer, Application Engine, Application Packages, App Messages, Integration Broker, AWE, CI, SQL, Process Scheduler Manager, BI Publisher, STAT and SQR

Pleasanton, CA

Confidential

PeopleSoft Techno Functional Consultant

Responsibilities:

• Applied Customizations to the Pay Cycle Process (AP PAY2015) and Payment Selection Process(AP PAYSELECT) to replicate the new development
• Developed Brand New PeopleSoft Objects to create a row of approved vouchers for which the Payment Method is ‘ACH’, ‘Wire’ and vendor layout is CCD+
• 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
• Developed Aging, Aging Summary, Aging Conversation and Aging summary conversation Reports.
• Applies Customizations to Expenses staging process (EX STAGEPMT) to pay the cancelled /voided payments.
• Developed Audit for Open Periods by Products(FIN OPEN ADJ, FIN OPEN PERIOD)
• Applied customizations to the POPO005.SQR to place the client Business Unit and Address Details in Header
• Worked on Integration Broker and Application Class PeopleCode, the Timesheets can be created and Approved now with the option of manually selecting the time reporting codes differently across the lines.
• Monitored daily, weekly and Monthly processes.
• Worked on the production issue and client PeopleSoft customizations.
• Worked in nVision and PS Query.

Operating System: Windows-XP Professional

Languages: PL/SQL, UNIX, PeopleCode

Special Software: PeopleSoft ( Confidential 9.1), People Tools (8.51), Oracle11g

People Tools: Application Designer, PeopleCode, Application Engine, Application Packages, App Messages, Integration Broker, AWE, CI, SQL, Process Scheduler Manager, BI Publisher and SQR

Confidential

PeopleSoft Operation Analyst

Responsibilities:

• Provided L1 and L2 production support by directly interacting with end users in PeopleSoft CRM (Call Center module), Worked with different teams to resolve production support issues.
• Addressed several P1, P2, P3 tickets and small Enhancements.
• Performed PS Admin activities.
• Performed configuration changes and functional testing activities for the custom, custom added components.
• Involved in Ticket analysis, solving crucial tickets and Root cause analysis.
• Primarily responsible for Handling tickets/tasks and application Support to the end-users.
• Involved in researching and documenting system user’s requirement.
• Organized weekly status calls with L3 support team and client manager to discuss about project deliverables.
• Worked with the functional team to gather initial requirement analysis with client.
• Load the CRM Case, Employee data into PeopleSoft CRM using Component Interface and App Engine.
• Involved in designing and implementing Workflow enhancement for the Case page.
• Customized Case Component extensively by adding Trouble Section, Notes Section and Contact Section etc. on case page.
• Set up workflow rules to trigger related task when a business project is submitted.
• Performing code fixes and testing to resolve production defects, communicating with users as needed for defect questions and clarification of issues, Acting as an informal mentor for more junior members of the team, and supervising the work of the report developer on the team and approving report migrations.
• Responsible for providing development and support for custom interfaces to and from other inside client systems and outside providers' systems.

Operating System: Linux Operating System

Languages: UNIX shell script, PeopleCode

Special Software: PeopleSoft CRM 9.0, People Tools (8.52), Oracle11g

People Tools: Application Designer, PeopleCode, Application Engine, Application Packages, CI, SQL, Process Scheduler Manager, Change Assistance

Confidential

PeopleSoft Techno-Financial Consultant

Responsibilities:

• Successfully completed transition from client.
• Experienced in onsite & offshore customer support.
• Provided First level production support at client place (Framingham, MA) by directly interacting with end users in PeopleSoft (AR and Billing), worked with different teams to resolve production support issues
• Addressed several P1, P2, P3 tickets and Enhancements.
• Performed functional testing activities as required by the outcome of analysis.
• Involved in Ticket analysis, solving crucial tickets and Root cause analysis.
• Primarily responsible for Handling tickets/tasks and application Support to the end-users.
• Assisted the business user in researching and documenting system user’s requirement
• Supported the AR and Billing application that includes Journal Edit, and post, Journal generator, Ledger Balancing, Voucher build, Voucher Post, Payment Post and Paycycle processing
• Preparing and Reviewing Test Scripts based on the scenarios for module.
• Worked on Functional Test Script writer in Financials - AR and Billing modules. The scripts were written manually.
• Configuring the Environment where ever required to develop test scripts.
• Participating in Project Meetings with onsite Project Manager and Consultants.

Operating System: Windows-XP Professional

Languages: PeopleCode

Special Software: PeopleSoft Confidential 8.8, People Tools (8.48), Oracle10g

People Tools: Application Designer, PeopleCode, Application Engine, CI, SQL, Process Scheduler Manager, Control-M.

Confidential

PeopleSoft Technical Consultant

Responsibilities:

• Worked under Accounts Receivable and Billing modules. Designed Confidential setup pages, Invoice generation pages, Transaction logs and interfaces.
• Completely developed Bill group setup pages and Confidential bill types’ transaction pages.
• Involved in page designing, people code, reviews, client reviews. Designed pages from scratch and related people code.
• Worked on PS/Query.
• Worked on Functional Test Script writer in Financials - AR and Billing Modules. The scripts were written manually
• Worked on support activities.
• Uploading data from legacy system to PeopleSoft system using Application Engine.
• Involved in Confidential conversations and interface programs code design.
• Involved in creating Technical documents.
• Customized some of the PeopleSoft delivered SQRs and sustained online objects to meet the requirement of the client.

Operating System: Windows-XP Professional

Languages: PeopleCode

Special Software: PeopleSoft Confidential 8.9, People Tools (8.48), Microsoft SQL Server 2000

People Tools: Application Designer, PeopleCode, Application Engine, CI, SQL, Process Scheduler Manager

Confidential

PeopleSoft Technical Consultant

Responsibilities:

• As a team member of project involved in the development and customization of on-line panels, record definitions and menus using People Tools like Application Designer.
• Involved in requirement gathering, prepared TDD and unit test documents for the developments, customizations.
• Extensively used People Tools for creation or modification of Process Definitions, Records, Panels, and Menus to run Custom SQRs through PeopleSoft environment.
• Used Application Engine to create applications and performed background SQL processing against the data.
• Tuned SQL/SQRs to improve performance using advance SQR features like Load lookup and Arrays.
• Developed and customized PeopleSoft PS Query objects for reporting employee’s data.

Operating System: Windows-XP Professional

Languages: PeopleCode

Special Software: PeopleSoft Confidential 9.0, People Tools (8.51), Oracle 10g

People Tools: Application Designer, PeopleCode, Application Engine, CI, SQL, Process Scheduler Manager, Query Manager

Chicago, Confidential

PeopleSoft Technical Consultant

Responsibilities:

• As a team member of project involved in the development and customization of on-line panels, record definitions and menus using People Tools like Application Designer.
• Involved in requirement gathering, prepared TDD and unit test documents for the developments, customizations.
• Extensively used People Tools for creation or modification of Process Definitions, Records, Panels, and Menus to run Custom SQRs through PeopleSoft environment.
• Used Application Engine to create applications and performed background SQL processing against the data.
• Tuned SQL/SQRs to improve performance using advance SQR features like Load lookup and Arrays.
• Developed and customized PeopleSoft objects, created reports using PS Query and created complex SQR reports.
• Created data conversion application engine process for e-compensation and e-performance modules.

Environment: PeopleSoft Confidential 9.0, People Tools 8.51, Oracle 10g.

Operating System: Windows-XP Professional

Languages: PL/SQL, UNIX, PeopleCode

Special Software: PeopleSoft ( Confidential 9.0), People Tools (8.51), Oracle10g

People Tools: Application Designer, PeopleCode, Application Engine, SQL, Process Scheduler Manager and SQR