PROFESSIONAL SUMMARY:

• Confidential is a PeopleSoft technical consultant having 13+ years of PeopleSoft technical experience.
• Worked extensively on People Tools 8.44, 8.49 and 8.50, 8.52, 8.53, 8.54 Application Designer, Application Engine, PeopleCode, PeopleSoft Portal, Component Interface, SQR, Workflow, Integration Broker, Oracle Data Integrator, BI Publisher, XML Publisher, Crystal Report, PSQuery and File - Layout. He also has knowledge on using Quest STAT.
• Worked in the functional domain of PeopleSoft HRMS modules like Workforce Administration, North America Payroll, Time and Labor and Enterprise Learning, of PeopleSoft CRM modules like Order Capture, Marketing, of PeopleSoft FSCM modules like Order Management, Inventory, Purchasing, Strategic Sourcing, General Ledger, Commitment Control, Purchasing, Billing and Accounts Payable, Asset Management.
• Worked on Healthcare, State, Oil and Energy, Banking, Communication and Transportation industry projects.
• Currently working as a PeopleSoft Consultant in techno-functional role at Confidential OAKS PeopleSoft 9.2 support project.
• Well versed with Software development methodologies and has been trained extensively on integration tools such as Component Interface, Integration Broker.
• Extensively involved in designing and developing online customizations, interfaces using integration broker, application engine and component interfaces, reports using BI Publisher, SQR, conversion programs using application engine, component interface, file-layout.
• Confidential has presented two papers at National level Tech Festival (AUREOLE and PARAM), one on Optical Networks and another on Real - Time Operating System. He also got a consolation prize in the C++ competition in the same National level Tech Festival.
• Possesses excellent communication skills as well as very good interpersonal relationship with all his colleagues, seniors and juniors. He has been a very good team member and his contributions in the team were highly satisfactory. During the project implementation at Confidential and RSMeans, he has acquired good leadership qualities .
• Worked in onsite-offshore model.
• Good track record in demonstrating strong analytical and problem-solving skills.
• Excellent team player.

TECHNICAL SKILLS:

ERP Package: PeopleSoft 8.8, 9.1 (PS HRMS),PeopleSoft 8.9 (PS CRM), PeopleSoft FSCM 8.8, 9.0, 9.1, 9.2

ERP Tools (PeopleSoft): PeopleTools from 8.46 till 8.55 (PUM 17) Application Designer, Application Engine, Component Interface, SQR, PSQuery, Crystal Reports, Process Scheduler, knowledge about Workflow, Integration Broker, Oracle Data Integrator and File-Layout, Data Mover.

Operating Systems: Windows XP and onwards, Unix

Languages: PeopleCode, C, C++, Java

Databases: MS SQL SERVER, Oracle

GUI: Windows

Web Related: JSP

Domain Knowledge: PeopleSoft HRMS 8.8, 9.1, PeopleSoft CRM 8.9, 9.1, PeopleSoft FSCM 8.8, 9.0, 9.1, 9.2

Type of Customization: Online customizations, Data Conversions, Interfaces (Application Engine and file based as well Integration Broker based), Reports (SQR, PSQuery, Crystal)

EXPERIENCE:

Confidential, Columbus, OH

PeopleSoft Consultant

Responsibilities:

• Work on production related issues like researching and providing solutions to the business users. This involves working with the technical teams explaining them the cause, and the possible solution.
• Techno Functional support expert for PeopleSoft eSupplier and eSettlements modules.
• Perform UAT for every production bug fix..
• Perform UAT for AP related interfaces. (Voucher import etc)
• Work as the subject matter expert on eSupplier and eSettlements modules for ongoing ODX eSupplier projects. Perform UAT to validate that the data entered on the external website is coming into PeopleSoft correctly. Also, make sure that the data shown on the external DX eSupplier website matches with that in PeopleSoft.
• Provide functional support and feedback during the design sessions for DX eSupplier portal website.
• Create and validate the functional designs for the customizations (AP, GL, eSettlements, eSupplier, Supplier, Asset Management etc) related to existing OAKS system.
• Perform requirements gathering and interact with end users to help them resolve their issues.
• Create and approve eSettlements agreements between the Agency ( Confidential AP Business Unit) and the eSupplier.
• Manage the eSettlements and eSupplier related setups.
• Provide demos to various agencies for eSettlements onboarding.
• Work with Oracle support in case of any delivered bugs (report and test).
• Providing sql scripts to the technical team to fix certain production issues.

Environment: PeopleSoft Finance 9.2, People Tools 8.55, Database Oracle

Confidential

Senior PeopleSoft Consultant

Responsibilities:

• Part of phase 4a support team.
• Working on resolving defects related to 4a implementation objects. These defects included fixing the bugs related to online customizations, reports, application engines, application packages related to Integration Broker as well as online pages.
• Working on performance tuning of various CRM pages.
• Providing support to NY State Comptroller employees.
• Working on PeopleSoft CRM modules like HelpDesk, Marketing, Case Management.
• Used Phire to migrate projects one database to another.
• Created complex online customizations, and reports

Environment: PeopleSoft CRM 9.1, People Tools 8.53, Database Oracle

Confidential, NY, Albany, NY

Senior PeopleSoft Techno-Functional Consultant

Responsibilities:

• Initially part of the upgrade team doing the retrofit analysis of objects.
• Moved to interface team to develop inbound and outbound interfaces for Procurement Contracts using Oracle Data integrator (ODI) and PeopleSoft application packages, integration broker.
• Developed conversion programs.
• Performed online customizations.
• Now part of Functional integration team also, working on functional specifications parts.
• Also working on the project management side to organize work between users, bulkload interface teams, and consolidate and organize documents on sharepoint.
• Discuss issues and concerns with the user facing teams and come up with the solutions releases to address those concerns. Communicating with the interface development team and upgrade team related to these changes.
• Perform functional testing.
• Conduct peer reviews.
• Analyze production incidents, communicate with users and the develop teams to resolve these incidents.
• Create defects based and test them, to resolve the incidents.
• Work on incidents related to modules like Accounts Payable, General Ledger, Purchasing, Supplier Contracts, Commitment Control, Asset Management, Project Costing etc.
• Perform requirements gathering with third-party for development of interfaces.
• Create functional specification based on requirements gathered.
• Develop ER diagrams for new PeopleSoft system process flow, and work with the web development team to launch new process flow web pages for users

Environment: PeopleSoft Finance 9.0, 9.2, People Tools 8.49, 8.53, 8.54, Oracle

Confidential, Pittsburgh, PA

PeopleSoft Lead

Responsibilities:

• Involved in the initial fit-gap analysis of various interfaces like Inbound Requisitions, Outbound Purchase Order, Inbound Receipts, Account Codes, Vendors, Vendor-Contracts, Item Master.
• Worked a PeopleSoft FSCM and HCM techno-functional consultant.
• Designed functional specifications based on requirements gathered from the client and the third-party vendor.
• Involved in requirements gathering with the client and the third-party vendor.
• Designing the Outbound Vendor, Vendor Contracts, Purchase Order interface to MWOS.
• Designing the Inbound Requisitions, Purchase Order Receipts, Stock Request, Inventory Adjustment, Item Definition interfaces from MWOS.
• Vendor, Vendor Contract interfaces are file based. Delivered service operations Purchase Order Receipts, Inventory Adjustment are being used.
• Custom Service operations being designed for Requisitions, Purchase Orders, Item Definition, Stock Request interfaces.
• Designing the Time and Labor timesheets interface with Trapeze

Environment: PeopleSoft Finance 8.9, PeopleSoft HRMS 9.1, People Tools 8.52, 8.48, MS SQL Server

Confidential

PeopleSoft Lead

Responsibilities:

• Resolving defects arising during various test cycles.
• Defects relating to Finance, Supply Chain, Portal, HCM.
• Develop reports using XML Publisher, SQR and crystal.
• Develop, test, prepare test scripts and give demo to BAs of the Bank Interfaces.
• Interact with end users to gather requirement, develop, test, provide demo and get final sign-offs on Bank Interfaces like Wells Fargo, Bank of America etc.
• Worked on designing, developing and testing the customizations, interfaces.
• Worked on Portal (menu integration, pagelet development, homepage customization etc.)
• Worked on Accounts Payables Check printing using crystal report APY2021, designed custom check form as per client’s requirements. Worked on MICR code printing issues involving working with printer vendor to configure printer for correctly printing the MICR code on the check.
• Worked on customization of HCM payroll check sqr pay003.sqr to print HCM payroll checks as per the client requirements. Involved in signature and MICR code printing on the check

Environment: PeopleSoft Finance 9.1, People Tools 8.52, Crystal, Oracle

Confidential, NY, Albany, NY

Senior PeopleSoft Techno-Functional Consultant

Responsibilities:

• Resolving defects arising during various test cycles.
• Work on defects related to modules like General Ledger, Accounts Payable, Asset Management, Purchasing, Supplier Contracts, Banking, Commitment Control, Project Costing etc.
• Defects relating to Interfaces using Integration Broker, Oracle Data Integrator.
• Develop reports using BI Publisher and SQR.
• Develop, test, prepare test scripts and give demo to BAs of the Bank Interfaces.
• Interact with end users to gather requirement, develop, test, provide demo and get final sign-offs on Bank Interfaces like Key Bank, Chase etc.
• Worked on designing, developing and testing the customizations.
• Utilized Quest STAT to migrate projects from one database to another

Environment: PeopleSoft Finance 9.0, People Tools 8.49, BI Publisher, Crystal, Oracle

Confidential

Senior PeopleSoft Techno-Functional Consultant

Responsibilities:

• Resolving defects arising during various test cycles.
• Develop, test, prepare test scripts and give demo to BAs of the Bank Interfaces.
• Developed the interfaces using application engine and complex sqls utilizing application engine meta -sql functions as well as tradition sqls. The interfaces were file-based.
• Worked on designing, developing and testing the customizations.
• Utilized Quest STAT to migrate projects from one database to another

Environment: PeopleSoft Finance 9.0, People Tools 8.49, BI Publisher, Crystal, Oracle

Confidential

Senior PeopleSoft Techno-Functional Consultant

Responsibilities:

• Creating detailed technical specifications based on functional requirements provided by the client’s functional analysts.
• Conducting Peer Reviews for the Technical Design preparation and Coding phases.
• Interacting with client users and functional team for developed object walk through and technical review sessions.
• Development and Unit Testing of RICE components.
• Resolving defects arising during various test cycles.
• Work on defects related to modules like Accounts Payable, General Ledger, Commitment Control, Strategic Sourcing, Asset Management, Purchasing, Supplier Contracts, Project Costing etc.
• Customized two delivered PS crystal reports.
• Did enhancement relating to Transactions in Project costing.
• Did 2 conversions, one of which is Vendor Conversion.

Confidential

Sr. PeopleSoft Technical Consultant

Responsibilities:

• Designed Application Engine program to calculate RFM i.e., Recency, Frequency and Monetary score for each ship-to-contact to find out the most favourable customer and then store those results in a table. This process is being scheduled to run every Friday.
• Created new holds like Future Order Capture Date to be applied on orders placed through Order Capture component of PS CRM 8.9. Customized already existing hold CORPCR i.e., Exceed Corporate Credit Limit hold, to suit the needs of both RSMeans and RCD, the parent company, based on the business unit.
• Created a Component Interface and an Application engine process to submit the orders on hold, without any manual intervention, once the hold condition on those orders is no more valid.
• Customized the Manage Audiences component of PS CRM 8.9 and designed a completely new page to allow the user to enter various criteria for generating an audience. Used PeopleCode Query classes to programmatically generate a PS Query which is then used by the existing application engine process to generate the Audience.
• Worked on Inventory and Billing of PS FSCM 8.8 on Multiple-Billing issue to solve the problem of multiple invoices being generated for a single order placed through PS CRM 8.9 Order Capture module. The solution was to stop direct invoicing and assign Target Invoice the value same as the order number. Later on, the parent company of RSMeans, i.e., RCD objected as it didn’t suit their process so, another approach is being followed. Till then, multiple billing was working as desired by RSMeans.
• Currently working on the alternate solution for the problem in point above. This solution is TBP (Transaction Billing Process). This involves billing for all type of products e.g. subscription, service, inventory to be done through contracts. For this, the customized application engines created by the Lexis Nexis, LN RO SUB SM and LN RO MNT SM to move inventory products from CRM to FSCM contracts have also been modified in addition to some other modifications done. In FSCM side, the clone of OM BILL application engine, CRM OM BILL was created with some changes done in it.
• The application engine CA BI INTFC has also been modified to solve the problem of incorrect quantity and amount passing to billing.
• Currently working on 2 marketing enhancements in CRM 8.9 related to audience list generation.

Confidential

Sr. PeopleSoft Technical Consultant

Responsibilities:

• Implemented successfully Enterprise Learning module of PeopleSoft HRMS 8.8.
• Created multiple pages and components based on the client requirement and integrated those components among themselves and with the delivered components of PS HRMS 8.8 Enterprise Learning module.
• It included creating new components and pages for their program which involved Pre-Assessment, Post Assessment CSEP (Communication Skills Enhancement Process), Process and Nesting.
• These included new pages with multiple scrolls. They consisted of new records and views created to meet the client’s requirements. These new components were in sync with the already delivered components of Administer module.
• The newly created records were also in sync with the base tables of Enterprise Learning module.
• The implementation required discussing requirements with the functional consultant and also with the client directly.
• Created Component Interface on JOB DATA component of PS HRMS 8.8 for data conversion.
• Customizing SQR reports and developing queries using Query Manager.
• Developed SQRs for porting data regarding employee details and details of employees.
• Created processes, jobs, jobsets, and recurrences and scheduled Jobs to run automatically at certain time periods.
• Created permission lists to grant access to employees to various components in both PeopleSoft HRMS & Finance.
• Designed a workflow for the newly created application for Enterprise Learning module and customized existing workflows in Workforce Administration.
• Provided support for existing Finance and HRMS systems, which included module like AP, AR, GL of finance and workforce administration, of HRMS.