PROFESSIONAL SUMMARY:

• PeopleSoft FSCM consultant with over 7+years of experience in all stages of systems development lifecycle including business requirements gathering, design, data conversions, programming, Database Administration, Production Support, system/integration/user acceptance testing, documentation and exclusive experience in PeopleSoft Financials andPeople Tools.
• Experience in implementation, upgrade, support, customization, writing interfaces and administration of PeopleSoft Financials/SCM (AP, AR, GL, AM, Project Costing, Contracts, Billing, Purchasing, Vendors).
• Experience in PeopleSoft FSCM 8.1 through 9.2 - Purchase Order (PO) and Procurement (ePro), Accounts Payable (AP), Accounts Receivables (AR), Asset Management (AM), General Ledger (GL), Project Costing, Contracts & Billing (PCB)
• Extensively worked and been a part of entire system development life cycle (SDLC) withAgile/Waterfall Methodologies
• Experience in writing PL/SQL queries and have exposure to different databases, includes SQL Server, Oracle.
• Worked with reporting and analyzing tools such asXML Publisher. Used PS/Query, Connected Query and Tree Manager for reporting purposes of fulfilling company's specific needs.
• Created specifications and programmed interfaces to and from PeopleSoft system to satisfy business requirements.
• Specialized in data extraction interfaces and conversion from legacy to PeopleSoft applications.
• Extensively worked with People Tools such as Application Designer, Approval Workflow Engine, Application Engine, PeopleSoft architecture, File Layout, Component Interface, People Code, Security, Tree Manager, Process Scheduler, Data Mover and Query tools.
• Worked intensively with Security Administrator to implement Creating Roles, Permission Lists, User Profiles, Portal Security and Definition Security.
• Configured PeopleSoft Update Manager.
• Experience in Objects and data migration using Application Designer and Data Mover.
• Extensive experience inPeopleSoft Internet Architecture (PIA), reporting tools, PeopleSoft implementation, upgrade, conversion, customization, and new development.
• Proficient in gathering and analyzing requirements to successfully design applications based on user needs.
• Demonstrated experience in analysis and documentation of various PeopleSoft Security.
• Excellent in Production Support, Documentation, Conversions, End-Users Training, Mentoring and Knowledge Transfer.
• Extensively developed report applications using BI Publisher, PS Query, SQR, Crystal Reports.
• Ability to deliver the best even in the most critical phases of the project.
• Possess excellent communication skills, zeal to adapt to new technologies and good Team Player.

TECHNICAL SKILLS:

Application: PeopleSoft Financials v8.0-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, Tree Manager

Administration Tools: Security Administrator, Object Security, and People Tools Utilities, Data mover

Operating Systems: Windows XP/2000/ 95/98, UNIX/LINUX.

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

Databases: Oracle 9i/10g/11g, MS SQL Server.

PROFESSIONAL EXPERIENCE:

Confidential, CA

PeopleSoft FSCM Developer

• Generating and analyzing compare reports between PeopleSoft FSCM v8.55 to 9.1 and v9.2.
• Retrofitting and customizing interfaces and conversions programs written in SQR, Application Engine, and Component Interface.
• Retrofitting and customizing PeopleCode and Application Designer objects to implement business logic, validations and GUI for PeopleSoft FSCM v9.2 applications.
• Migrating Application Designer objects from v9.1 to v9.2.
• Participated as a one of the technical Member for the PeopleSoft FSCM 9.1 to 9.2 upgrade project.
• Involved in retrofitting SQRs, Crystal Reports, PeopleCode, and Queries.
• Customized and developed new fields, pages, record definition and People Code for the E-procurement, purchase order, GL andAccount Payable modules.
• Compared new enhancements with current customizations, performed code merged, tested.
• Revised technical documentation for the Upgrade.
• Creating and updating technical design documents for the objects that were created and modified as part of PeopleSoft upgrade project.
• Modified pages in GL module base on client specific requirements.
• Using Data Mover to create DMS scripts for moving the data from old version to new version for testing purpose.
• Developed technical specifications based on the Functional requirement document.
• Created new Application Engines for loading the data from CSV file to vendor and Staging tables.
• Created test scripts for Journal Entry, Journal Upload and Journal Processing.
• Created and executed Test Scripts for unit testing in GL for testing ‘Journal Entry’, ‘Open a Period’,‘Close a Period’, etc. functionality.
• Wrote inbound interface program using Application Engine and People Code to import Items from a third-party application to GL system tables.
• Worked with end users to gather necessary information for the tasks.
• Involved in team discussions and conferences to solve technical issues and improve project’s performance.
• Interacted with the Users and Functional analysts to come up with new requirements for the business unit.
• Expansively used tools like Process Scheduler and Process Monitor for the execution of SQL and Crystal Reports.
• Supported the end users in providing the queries and assisted in testing of the interface in UAT.
• Coordinated with the DBA in migrating the PeopleSoft projects from development to SIT and UAT and Prod.
• Involved in various phases of this project such as analysis, design, development Data Conversion Scripts using SQR, SQL Scripts, unit testing, devising string and integration testing, performance tuning of on-line and batch application.
• 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.
• Assisted functional teams with development of test plans and scripts, and responded to all technical issues and queries that arise during the integration testing.

Environment: PeopleSoft FSCM 9.2, PeopleSoft FSCM 9.1, PeopleTools 8.54,PeopleTools 8.55, Windows, BMC Remedy

Confidential, TX

PeopleSoft FSCM Developer

• Generating and analyzing compare reports between PeopleSoft FSCM v9.1 and v9.2
• Retrofitting and customizing interfaces and conversions programs written in SQR, Application Engine, and Component Interface.
• Retrofitting and customizing PeopleCode and Application Designer objects to implement business logic, validations and GUI for PeopleSoft FSCM v9.2 applications.
• Migrating Application Designer objects from v9.1 to v9.2.
• Coordinated team members and involved in assigning the project tasks within the team, based on workload.
• Apply fixes, Updates, and Patches for DEMO, DEV, TEST and PROD application.
• Retrofitting and customizing the reports from v9.1 to v9.2 using BI Publisher, SQR, Crystal Reports, and PS Query.
• Used change assistant to execute the steps from PeopleSoft application upgrade template.
• Researching and analyzing existing functional design documents to identify the purpose of customizations done on PeopleSoft FSCM v9.1.
• Technical feasibility analysis for existing and newly created functional design documents.
• Interacting with end-users and functional consultants to understand the purpose of customizations done on PeopleSoft FSCM v9.1.
• Involved in customizations in PeopleSoft Project costing using PeopleCode, PeopleTools, Workflow, component interface to develop a unified system for all the different types of projects.
• Using Data Mover to create DMS scripts for moving the data from theold version to new version for testing purpose.
• Participating in testing sessions with end-users and functional consultants and fixing the issues surfaced while user acceptance testing.
• Creating and updating technical design documents for the objects that were created and modified as part of PeopleSoft upgrade project.
• Analyzed Inventory process from a design perspective and recommended configuration and setup changes.
• Performing customization in eProcurement to transparently include inventory items in search category only to prevent from purchasing goods that are already in stock.
• Created custom SQR programs for creating transfer and maintenance worksheets using a specific logic given by the users to implement the split business unit as part of the new upgrade.
• Created and updated the test cases and test execution documents for theunit and system testing.
• Fine-tuning performance issues of SQR, Application Engine and Crystal Reports coordinating with theDatabase administrator.
• Worked on the Costing and Accounting for Supplier Managed Inventory.
• Developed Payment Interfaces to load bank recon data into PeopleSoft Payables from bank transaction files.
• Designed app engine programs to read duplicate assets from asset table and mapping table and create new asset ids. These new assets were inserted into the mapping table along with their business units.
• Implemented PeopleCode to dynamically change prompt table for anaccount on journal line, based on commitment control amount type selections. This involved use of component level PeopleCode, thepassingrow set objects from component level to field change PeopleCode.
• Created custom application engine process that automatically initiates the “submit Journal” process for journals with external system sources. This program allows the journals to be sent into theworkflow without any manual intervention from users making it more streamlined and user-friendly.
• Modified Journal Edit application engine process to avoid anchor concept. Added new AE Sections/Steps/Actions to implement Fund Balancing concept while generating offsets as a part of Journal Edit Process.
• Coordinating with thesystem administrator to apply for permissions, roles and user profiles to provide access to end-users.
• Involved in creating PeopleSoft security matrix and creating/modifying/retrofitting Permission Lists, Roles, and User Profiles.
• Involved in the creation of Accounting Entries for PeopleSoft Cost Management.
• 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.
• Provided on-call (24x7) support for critical issues.

Environment: PeopleSoft FSCM 9.2, PeopleTools 8.54, Windows, BMC Remedy, Process Scheduler, Workflow, SQR, PS Query, Administration and Oracle, AP, AR, BI, GL.

Confidential, MI

PeopleSoft Developer

• The projects involved in thedesign, construction and testing phases of PeopleSoft Financials 9.1 on various modules. Participated in thefit-gap analysis.
• Customized and developed new fields, pages, record definition and People Code for the E-procurement, purchase order and Account Payable modules.
• Involved in defining approval rule sets for PO approvals in Purchasing.
• Involved in userdocumentation of the created processes.
• Involved in retrofitting SQRs, Crystal Reports, and Queries.
• Involved in business setup for Vendors.
• Involved in setting up of Expenses Approvals using Workflow.
• Participating in brainstorming sessions and proposed new ideas which improve the process of the existing system.
• Configured Inventory business units, options, and other Inventory configurable items.
• Involved in requirements gathering, creating afunctional requirements document, and testing of the custom sales and use tax process for inventory material transfers.
• Co-ordinate with Business Users, Functional Users, and Technical Team on aday to day support and on new requirements.
• Provided the ability to do Treasury regular and draw down EFT, BAX, and international SWIFT ACH/WIR transfers between Beaumont accounts and external accounts.
• Assisted users in suspense journal corrections. Worked with enhanced Spreadsheet Loader and Excel to CI utility.
• Performed month-end and quarter-end close. Troubleshot out of balance sheets, multi - currency and ADB issues.
• Involved in the creation of Accounting Entries for PeopleSoft Cost Management.
• Worked on the Costing and Accounting for the Repair and Maintenance of Assets.
• Automated PO Dispatch runs control page by creating a default set of run controls for each user, with appropriate parameters preset. A nightly batch job will be created as part of this work unit, which will reset those run controls back to the default settings.
• Provided support in solving Problems related to Voucher Posting and Payment Posting (App Engine Processes), AP matching process, GL, Purchasing modules.
• Troubleshoot billing interface program by adding intermediate commits to billing interface to avoid table locking and improve performance.
• Documented and designed the technical specifications for interfaces/data conversion and validation.
• Assisted functional team with troubleshooting issues and providing resolutions during preliminary testing and build phase
• Extensively involved in UAT andRegression Testing of interfaces (account receivables) like the open item inbound/outbound customer credit limits and total balance outbound export-parts(TOLAS) and Truck(XAPTA).
• Customized PeopleSoft delivered BI Publisher reports in Payables like Vendor Detail, Vendor Summary, Closed Voucher, APY1010 - Voucher Register, APY1010A - Posted Voucher Register, APY1040 - Open Voucher Report, APY2015 - Check Register.
• As a member of the Production Support team, responsible for support and development of GL, AP, IN, OM and Purchasing.

Environment:  PeopleSoft Financial/SCM V9.1 People Tools 8.54, People Code, SQR, Application Engine, Process Scheduler, Workflow, Administration, and Oracle.

Confidential

PeopleSoft Developer

• Gathered the requirements from users for reports, interfaces, conversions and implementation of different modules. Created Functional and Technical Design Documents (FDD & TDD).
• Developed and test report, interface, conversion, and enhancement programs to meet the requirements of the technical specifications.
• Developed numerous custom complex reports in AP, PO, AR, INV, OM, AM, GL using Crystal reports, nVision, SQR, XML Publisher and PS Query.
• Identify business requirements and align them to Oracle Cloud/Fusionfunctionality for Core HR, Benefits.
• Configure the Cloud/Fusion HCM Application based on client requirements.
• Developed several inquiry pages and modified existing pages for the users to enter data and run reports for the AP, INV, PO, OM, AR and GL modules.
• Provided Hands on training to the users to run the delivered and customized reports using run control pages, scheduling reports, process scheduler, report manager and also trained the users on creating new and running existing queries using Query Manager.
• Performing customization in eProcurement to transparently include inventory items in search category only to prevent from purchasing goods that are already in stock. Configured Inventory business units, options, and other Inventory configurable items.
• Developed and modified several SQR reports as per the client’s requirements which involved changes in selection criteria and changes in layout.
• Used PS/Query in conjunction with Crystal Reports and nVision to develop complex reports for AP, AR like Payment aging by vendor report and to customize existing reports like Payment aging by bank report to accommodate new currency codes and payment methods and Trial Register report to troubleshoot pay cycle in AP.
• Excellent experience in troubleshooting, debugging and tracing.
• The scope of Projects for conversion includes open, existing projects including CIP, Rail Construction, ARRA, Reimbursable, and Safety & Security.
• Developed Excel to CI component interfaces to mass update the buyer data for the items and the Item Categories.
• Developed pseudo code and unit testing procedures in the technical specifications for the development team.
• Defined the system testing and integration procedures for System testing and User Acceptance testing.
• Extract Data files from the database for mapping into Standard Oracle Fusion fields, design.
• Worked on several interfaces using Component Interface to load data into HCM. 
• Developed control reports, error reports, and reconciliation reports for the interfaced and converted data.
• Developed Data integrity reports validating the orphan data in the PeopleSoft tables.
• Technologies: PeopleSoft Financials 9.0, Oracle 10g, PeopleTools 8.51
• Modules: GL, AP, PO, AR, BI, Time and Labor

Environment: Application Engine, Oracle 10g, MS Excel, PeopleCode, SQR, Component Interface, Integration Broker / App. Messaging, XML Publisher, Crystal Reports and PS/Query

Confidential

PeopleSoft Developer

• Handled BI, AR, AP, PO, GL, CA and Inventory production issues.
• Designed and developed aninbound interface to load vendor’s data from Oracle Financials system into custom PeopleSoft tables.
• Implemented a completely new bolt-on application integrating CRM sales 8.9 and ESA project costing and contracts 8.8 using multi-layered workflow, CI, integration broker, People Code on 8.46 tools.
• Identify business requirements and align them to Oracle Cloud/Fusion HCM functionality.
• Configure the Cloud/Fusion HCM Application based on client requirements. 
• Extensively involved as a key functional analyst in analyzing, designing, testing and production transitioning of Contracts 9.0 by interfacing contracts data from custom-built Sales Flow Quote system where the contracts are billed under different bill plan utilizing Billing module and recording payments utilizing AR module.
• Involved in requirements gathering, creating afunctional requirements document, and testing of the custom sales and use tax process for inventory material transfers.
• Applied patches and bundles in Purchasing, Inventory modules, to bring the existing version to the current level of patches.
• Fixed the AR PAYLOAD step which populated only the customer number and business unit as part of customer information, ignoring other fields.
• Developed a new Crystal Report to determine the Buying Agreement Expiration Details.
• Modified the Sales Order Report OMS1000 (SQR) to include the detailed information of the customer.
• Created custom email messages to notify employees about their expense report status.
• Fixed the AR UPDATE process which did not insert values into PENDING ITEM when an item is created via a payment worksheet.
• Involved in customizations of pages, components, and People Code related to all Financials & SCM modules.
• Tuned PS queries and several programs reducing processing times from hours to minutes.

Environment: PeopleSoft Financials 8.8/9.0(Account Receivables, Billing, Account Payables, General Ledger, Project Costing), People Tools 8.49, SQR, Application Engine, Component Interface, People Code, Workflow.