SUMMARY:

• I have been working as a PeopleSoft techno/functional consultant from the past 8+ years. I have been part of implementing PeopleSoft Financials & Supply chain modules for different clients which includes Full - Life Cycle (SDLC) implementation, Upgrade, Production Support and have extensive Functional and Technical Experience in implementation of PeopleSoft Financial & Supply Chain Modules like PC, Contracts, Billing & AR, Purchasing, AP, Inventory, Treasury, Grants, KK, Order Management, eProcurement,Travel & Expense and GL modules (Version 9.2, 9.1,).
• 5 years’ experience in Information Technology that included gathering user requirements, Systems Analysis, Design, Development, Implementation, Testing and Production Support of ERP applications.
• Good functional Understanding and working experience in Accounts Payable, Purchasing, Accounts Receivable, Billing, General Ledger, Cash Management, Treasury, Projects, eProcurement, Benefits,.
• Extensively worked with PeopleTools such as Application Designer, Application Engine, PeopleCode, Component Interface, File Layout, Integration Broker and AWE.
• Proficient in development and customization of complex pages using Application Designer.
• Extensive experience of different types of testing e.g. Unit Testing, Integration Testing, System Testing, Regression Testing, User Acceptance Testing, Load and Performance Testing.
• Involved in analysis, creation and updating the Functional Design Document (FDD), Technical Design Document (TDD), Process Flow, Processing Logic, Unit Test Plan Document (UTP), Migration Check List, Minutes of Meeting (MOM), Weekly Status Reports, Coding Standards Document, End User Documents, Data Mapping & Conversion Strategy Documents.
• Work Experience on UNIX, Windows Servers, Shell Script, Batch Scheduling Application Control-M, Database Access Tools like TOAD, Query Analyzer, Quest, SQL Plus, Version Control Tool STAT and Defect Tracking Tools like HP Quality Center and Test Director.
• Worked with reporting and analyzing tools such as XML Publisher, SQR and Crystal Reports.
• Experience in configuring Integration Broker with third party systems and PeopleSoft systems.
• Configured and Setup Integration Broker for retrieving real time data from the legacy/source systems.
• Participated in all phases of ERP life cycle like Implementation, Conversion, Customization, Development and Production Support.
• Hold good experience in working with reporting tools like PS Query, nVision, BI Publisher, Crystal Reports and SQR.
• Extensively worked on interfaces and conversions from legacy/third party systems to PeopleSoft.
• Worked intensively with to implement Row Level Security, Creating Roles and Permission Lists
• Experienced in the usage of Mercury Quality Center (9.0) and STAT 5.7.8 tools.
• Excellent troubleshooting and problem solving skills.
• Possess good knowledge in RDBMS, Web/Client-Server applications and security.
• Good at Analytical thinking, Testing, troubleshooting, and Error fixing.
• Served as the key point of contact/Liaison between on and offshore resources.
• Team player with excellent interpersonal communication skills and technical documentation skills.

TECHNICAL SKILLS:

Application: PeopleSoft Financials v8.8-9.2(AR, AP, GL,AM, GL,Billing, Treasury, PO, Project Costing, Contracts, ePro, Grants, KK, T&E and Inventory)

Development Tools: Application Designer, People Code, Application Engine, Process Scheduler,SQR,Cobol, Data mover Component Interfaces, Application Messaging, Integration Broker.

Reporting Tools: PS Query, PS/nVision, SQR, Crystal Reports, Xml Publisher, OBIEE

Admin Tools: Security Administrator, Phire, Object Security and PeopleTools Utilities, Data mover

Languages: SQL, PL/SQL, SQR, COBOL, Java, .NET, HTML, JDK, C, C++.

Databases: Oracle 11g, MS SQL Server.

PROFESSIONAL EXPERIENCE:

Confidential, Wilmington, DE

PeopleSoft Techno Functional Consultant

Responsibilities:

• Designed and Developed a Report Table according to the requirements of the hospitals to have the Source, Fund Distribution and Target transactions in one line by using PROJ RESOURCE Record joined multiple times and deleting the unwanted rows in an App Engine Program.
• Created complex queries for functional users to support day to day processing.
• Designed XML Publisher Report Definitions, Templates and Data Sources to generate PC/AP/GL/PO/TR/T&E module reports using People Code and Process Scheduler.
• Involved in Development of GL Interface SQR, which reads flat file containing journals and loads into PS JRNL HEADER, PS JRNL LN and custom table ACS JRNL TRAIL. The file is opened for reading with open command when header row is loaded it checks for header edit rules and valid header data is inserted into Jrnl header. If line data is loaded.
• Added indexes to JGEN ACCT ENTRY and ITEM DST tables to tune the FS JGEN application engine process and worked with Oracle global support team on the performance tuning of ARUPDATE job in financials version 9.2.
• Customized the BIIF001 App Engine so as to avoid populating the fields ACTIVITY ID and BUSINESS UNIT PC in the BI HDR table as per the Functional user requirements.
• Receiving notification customization - Created an application engine program which notifies users if a Purchase Order has not been received for 4,8,12, or 16 day’s after the due date.
• Tuned various application engine programs like Billing Interface Program, Billing Preload, AR Update, Payment Predictor, Voucher Build and Post processes for optimum performance.
• Integrated Chrome river app for expenses with PeopleSoft by Inbound and Outbound interfaces.
• Developed a new interface using Application Engine to populate the quick voucher tables (PS VCHR HDR QV, PS VCHR LINE QV, PS VCHR PYMNT QV, PS VCHR DIST QV) from the input files, which in turn is used by the voucher build process AP VCHRBLD to create PeopleSoft Vouchers.
• Developed custom SQR process to accept information from various billing systems to bring in the billing information to Accounts Receivables, thereby populating PS GROUP CONTROL, PS PENDING ITEM and PS PENDING DST tables.
• AP Voucher and PO Conversions: Involved creating the mappings, getting data files from users, and then running edits with good ratio. Used File Layouts, App Engines and Component interfaces extensively for conversions and data edits.
• Customized Ap-post voucher(Approved Information) to send voucher details to GL.
• Re-Designed and Developed 6 core integrations between PeopleSoft Purchasing/eProcurement and IBM Maximo system. I used variety of technologies, mainly People tools in developing these integrations. I worked extensively on getting the data mappings of these interfaces.
• Designed, configured and developed the approval framework for the PeopleSoft v9.2 Procure to Pay (PTP) business processes (Requisitions, Purchasing, Vouchers, Vendors, Journals, Commitment Control) and credit invoices using the new approval workflow engine (AWE).
• Responsible for setting up the EIP (Enterprise Integration Points) for integrating Projects, Contract and Expense modules.
• Experienced in the design of the Workflow, which was primarily used to develop Work lists, Events and Routings for various business needs.
• Involved in setting up of Integration Broker between HR and Expenses module.
• Reapplied Customization on AMEX Load Process, Expense Report Custom Validations and Other Expense Processing Application Engine Steps.
• Modified existing PC EX TO PC process as per requirements for time sheets from Expenses to Projects.
• Carried a major customization (Attachments) in AP, GL and AR which allows the users to attach (add, replace, delete) any softcopies related to transaction. Extended the dev work and used the same in other modules like T&E.
• Good understanding for Critical aspects of PC Fund Distribution and Pricing. Worked with Oracle to resolve some critical issues with these processes.
• Performed XMLP troubleshooting and reverse engineering in the CONQRSMGR, QUERYITEMPROMT and Process Report
• Application Packages to resolve Connect Query queries prompt values.
• Developed a vendor and region-wise nVision report to forecast the accounts payable in the following month. This report shows the region wise cash requirement by scheduled pay date.
• Worked extensively in nVision reports in GL. Developed Matrix & Tabular layouts for Income statement reports, Cash-flow statement reports, Balance sheet reports, Equity Reports.
• Designed and Devloped Custom XMLP Active Grants Report.
• Modified Fin2025 SQR, Fineft.sqc and created New SQC for creating Vendor Data Payment file to Wells Fargo in their required format.
• Designed and Devloped the Custom XMLP Pre spending Report in Grant/PC/Contracts.
• Designed and Developed the Custom XMLP ed Grants report.
• Did testing using test scripts provided by the functional team in AR and BI modules in Staging and QC environment, reported technical and functional issues to the Issue Tracking team.

Environment: PeopleSoft 9.2(GL, AR, AP,OM,T&E,SCM, BI, PO,), People Tools (8.55), App Designer, SQR,Phire, Windows NT, UNIX and Oracle.

Confidential, Atlanta, GA

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Involved in fit-gap analysis from PS9.0 to PS9.2 version. Designed the document for master customization list which will take care of all the gaps should be fulfilled in PS9.2 version.
• Handling Business Process Workflows for the PeopleSoft Financials & HR modules (AR, BI, GL, AP, AM, PO, Contracts, PC, Travel and Expense) in a technical capacity.
• Installed bundles PeopleSoft PUM Images using Oracle Virtual Box and configured and instruct client in use of the PeopleSoft Update manager PUM for their upgraded 9.2 FSCM system. He has installed and configured of PeopleSoft
• Resolved Several Issues that came on DDDAUDIT And SYSAUDIT Reports
• Created the Technical designs for Invoice extract process changes, new invoice layout designs for CATFS, Contracts to Billing Interface changes, and Expense Employee Data update changes to the delivered Application Engine program, Accounts Receivable Update changes.
• Developed Purchasing Interface using File Layout, Application Engine, People Code and Component Interface, which loads data from flat file into staging tables while doing various data validations using Application Engine People Code and finally loads into PeopleSoft tables through Component Interface.
• Implemented Work Centers, AWE and BI Publisher Reports in 9.2.
• Involved in migration of PeoplSoft image 5 to image 23.
• Worked on PeopleSoft image 23 features such as Resource Management keyword search, Approval workflow engine for assignment approval and miscellaneous cash receipts.
• Designed and developed custom process to allow approx 25 to 50,000 vendor requests and invoice entries through batch. Process has allowed the freeing up of several individuals in AP to focus on other more important tasks.
• Involved in the PO - AP matching issues in PeopleSoft allowing the system to match the Purchase Order, Receipts and Vouchers - as the converted data was manually matched in legacy system. For this, I developed an interface inbound/outbound Application Engine process to make sure the data in PeopleSoft AP table are consistent with the ones in the third-party system.
• Created Reconciliation process (SQL scripts, Word Doc, etc.) in order to validate and verify the accuracy of the results.
• Worked with Accounts Payable, General Ledger Cash Management on various customizations, which involves Positive Pay, Vendor Interface, Automation of journal entries, Service Fee Automation, Cash Reserve Priority.
• Created PS Queries as per the Functional Design document.
• Created Data Sources and Report Definitions using PS Query and XML files.
• Designing Process Schedulers and giving Permission lists to the process.
• Developed a Custom App Engine to perform the Conversion of Customer Data from PS9.0 to PS9.2. Used PeopleCode to perform Long Data type inserts from PS9.0 to PS9.2 for Customer Conversation Conversions.
• Involved in Customizing and Testing the AP Pay Cycle Process to print the Custom Checks.
• Designed and developed a modal PTF (PeopleSoft Test Frame) in PIA and developed a custom application engine process to generate multiple test cases for different test types like test, shell test etc, the design differs for each type. Also, developed a search component whose functionality is simulation of PTF tool, to make user easy to search the specific test script related details.
• Created a new custom component for Vendor Management System for Vendor tracking using PeopleSoft Activity guides and work centers. This customization is to mimic the PeopleSoft Vendor Management system which is decommissioned by the client.
• Designed Outbound Process to schedule master files extracts on a daily basis. These master file extracts are used by the agencies to sync-up their systems with SFS.
• Used Integration Broker, Web Services and SOA to Integrate PeopleSoft Financials with third party services and publish the employee information from PS Financials to other application.
• Enabled access to Financials from Enterprise Portal by setting up a single link to PeopleSoft Financials application content provider and set up the single sign on.
• Modify contract prepaid amounts on contracts in progress using amendment mode, even if the associated bill plan has been processed or utilization has begun for that prepaid.
• Involved in Setup of Email Notification Templates and Escalation Rules for Journal Approvals AWE.
• Tested AdHoc GL Journal Approvals and ePro Requisition Approvals .
• Setup and configured purchasing Approval framework.
• Implemented T E expense rules for reviewing and Prepay auditing expense reports.
• Integrated, Designed, Developed interface programs for Travel Expense module with Accounts Payable for payments of employee expense reports
• Migrations of customizations like Record definitions, pages, Components, Run control pages, Portal Registries, A.E Programs and Component Interfaces for all modules
• Customized the BIIF001 App Engine so as to avoid populating the fields ACTIVITY ID and BUSINESS UNIT PC in the BI HDR table as per the Functional user requirements.
• Receiving notification customization - Created an application engine program which notifies users if a Purchase Order has not been received for 4,8,12, or 16 days after the due date.
• Tuned various application engine programs like Billing Interface Program, Billing Preload, AR Update, Payment Predictor, Voucher Build and Post processes for optimum performance.
• Migrated AWE Process Definition, Transaction Registry and Transaction Configuration from One Environment to Other Using Data Mover Scripts.
• Customized the Vendor Approval AWE Process. Triggered AWE only when a New Vendor Is added or Updates on Certain Field Like: Vendor Address, Location and Vendor Name.
• Creating a report for the Account Receivable on Pending items that runs and gives report periodically, that gives the list of all Pending Items, and Pending Payments.
• Modified Dunning Application Engine AR DUNNING, which was not populating the values to print Customer country
• Designed and developed a program that loads assets from a comma delimited file into asset interface tables.
• Applied PeopleSoft patches to fix PS bugs in a reactionary incident bases, making sure all Prerequisites are applied in order and proper documentations are kept.
• Created, modified, analyzed and validatedmulti currency nVision layouts, scopes and reports
• Modified, created and corrected PeopleSoft Trees to meet GL reporting requirements.
• Developed, analyzed, modified and validated nVision, SQR, Crystal and XML reports nVision setup and configuration
• Designed and Devloped Custom XMLP Active Grants Report.
• Modified Fin2025 SQR, Fineft.sqc and created New SQC for creating Vendor Data Payment file to Wells Fargo in their required format.
• Designed and Devloped the Custom XMLP Pre spending Report in Grant/PC/Contracts.
• Worked with the DBA team and developers, troubleshoot and Performance Tune Conversion scripts and code as required
• Using PHIRE for all Migrations.
• Modified and tested various SQR interfaces like General Ledger activity, Posted Journal summary and Journal entry details.
• Assisted with security changes/recommendations for upgrade.
• Setup users in system by role, permission lists, security sets, query access groups, department security tree, row level security, LDAP, Single Signon, and Active Directory integrations.

Environment: PeopleSoft Financials 9.2(AR,AM,Billing,T&E,GL,Epro), People Tools 8.55, Phire,Windows NT, UNIX and Oracle.

Confidential, Tampa, FL

PeopleSoft Technical Consultant

Responsibilities:

• Worked on a conversion of core legacy mainframe systems into a modern SOA, BPM, portal based solution.
• Developed Application Engine Programs to populate Asset and Asset Related custom data using file layouts from the legacy SCAN system. Design is to populate the INTFC PHY A and INTFC PHY B staging tables and AMIF0001 will create the Assets from staging tables. Custom application engine process is developed to populate asset related custom tables using component interfaces.
• Fixed the issue, transaction ID (TRANS ID) not generating after running the Transaction Loader (AMIF1000) monthly process. Resolved by removing the bad data for one intfc id.
• Modified changes for the ePro comments displaying incorrectly on the Requisition Detailed Summary (PV REQ APP DTL GRD) page when choosing the expand bar under Display Shipping and Distribution.
• Worked extensively in reports in GL using n-vision. Developed Matrix & Tabular layouts for Income statement reports, Balance sheet reports, Equity reports, Underwriting, Operating Expense, Investment Tax.
• Generated AP Vouchers and populated the AP external interface staging tables (PS VCHR HDR STG, PS VCHR LINE STG, and PS VCHR DISTRIB STG) with Inter Unit Billing Information from the PeopleSoft Billing tables.
• Involved in setting up of Payment Predictor, which is used to manually match payments to open items and to create adjustments or write-offs for open payments and under payments.
• Developed a new interface using Application Engine to populate the quick voucher tables (PS VCHR HDR QV, PS VCHR LINE QV, PS VCHR PYMNT QV, PS VCHR DIST QV) from the input files, which in turn is used by the voucher build process AP VCHRBLD to create PeopleSoft Vouchers.
• Developed custom SQR process to accept information from various billing systems to bring in the billing information to Accounts Receivables, thereby populating PS GROUP CONTROL, PS PENDING ITEM and PS PENDING DST tables.
• Created complex queries for functional users to support day to day processing.
• Modified FIN2025.SQR to keep track of Payment files, and created interface to Electronic files transfer the Payment File to Bank.
• Customized AR30003.SQR, AR30004.SQR to print the number of disputed items for each customer along with the number of disputed items for the business unit, order number, and reports.
• Implemented PeopleCode to dynamically change prompt table for account on journal line, based on commitment control amount type selections. This involved use of component level PeopleCode, passing rowset objects from component level to field change PeopleCode.

Environment: PeopleSoft Financials 9.2, People Tools 8.55, Windows NT, UNIX and Oracle.

Confidential

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Provide functional support to offshore for all Student Record customizations to include functional spec design, testing, and user acceptance testing.
• Gathered requirements, drafted designs and tested requirements for course substitutions, foreign language waivers and waivers per client’s business processes.
• Gathered requirements, drafted designs and tested requirements course equivalency transfer credit rules.
• Gathered requirements, drafted designs, developed mapping and tested requirements for conversion of comments data from client’s legacy system.
• Assisting with end-user and UPK Development as required for Admissions, Campus Community and Student Records.
• Researched and configured Self Service and FERPA based off client’s business needs.
• Configuring PDL process for applications and test scores from clients’ legacy system.
• Reconfiguration of set-up table to ensure items supports client business needs.
• Troubleshooting security issue triggered during User Acceptance Testing.
• Configuration validation between environments to ensure clean migrations. sessions, configuration, testing and end-user .
• Assist clients with the implementation and optimization of PeopleSoft Campus Solutions modules Structuring Campus Solutions Frameworks and utilities; 3C's (Communication, Checklists and Comments), AAWS, Pop Select, BI Publisher and PeopleSoft Query to improve client’s business processes.
• Perform complex analysis, evaluation, design, development, testing, implementation, documentation and maintenance of PeopleSoft Campus Solutions application specific to the functional needs of Admissions, Student Services and Campus Community, including admission, recruitment, financial aid, student accounts, records, registration, transcript and diploma processing, graduation evaluation, and quality service operations.
• Customized Accounts Payable reports like APY2050, APY3020 etc.
• Involved in Customizing and Testing the AP Pay Cycle Process to print the Custom Checks.
• Setup pagelets, contents, website branding, and Portal Security design.

Environment: PeopleSoft FSCM 9.1,PeopleSoft Campus Solutions, Portal, Tools v8.52, IB, AE, CI, Web Server.

Confidential

Jr. PeopleSoft Technical consultant

Responsibilities:

• Re-Designed and Developed 6 core integrations between PeopleSoft Purchasing/eProcurement and IBM Maximo system. I used variety of technologies, mainly People tools in developing these integrations. I worked extensively on getting the data mappings of these interfaces.
• Designed, configured and developed the approval framework for the PeopleSoft v9.1 Procure to Pay (PTP) business processes (Requisitions, Purchasing, Vouchers, Vendors, Journals, Commitment Control) and credit invoices using the new approval workflow engine (AWE).
• Good understanding for Critical aspects of PC Fund Distribution and Pricing. Worked with Oracle to resolve some critical issues with these processes.
• Developed GL Interface that loads data from various external systems into PeopleSoft General Ledger using SQR, which includes implementing complex business rules like Combo Rules, subtotals on Business Unit level, grand totals, error handling procedures, printing multiple output reports maintenance report and processead file report. Used various SQR functions, Arrays, Trees, Views, Load Lookup & SQC (which handles various Invalid Chartfield Combinations).
• Consumed third party webservice to create service operations, nodes and Message schemas.
• Generated outbound synchronous SOAP doc and manipulating response using SOAP doc classes.
• Customized Application Engine IN ITMLOAD during item load process.
• Customized the PO Dispatch and Print SQR (POPO005) to print the Ship To comments at the Ship To label, which is used for printing the address. This change is made specifically for customized Ship To’s with just single Ship To address. Also made changes to accommodate the standard Ship To comments for customized single Ship To’s at the Ship To label.

Environment: PeopleSoft v9.1 (GL, AR, AP, OM, SCM, BI, PO,), People Tools (8.52), App Designer, SQR, Windows NT, UNIX and Oracle.