SUMMARY:

• 8 years of Dynamic experience in ERP, Software Design, Development, Reporting, Testing, Implementation and Support of Client/Server applications using People Tools, SQL Server and Oracle.
• Involved in the implementation of full life - cycle projects encompassing (PO, INV, AR, AP, AM, GL, Project Costing, Billing, Supplier Contracts and Travel & Expenses).
• Extensively worked on Technical side as well functional side of PeopleSoft Financials and Supply Chain.
• Involved in Implementation, Customization, Product Development, Upgrades and Support.
• Knowledge on Business Process and Data Models.
• Extensive experience in performance tuning of On-line pages, Application Engine programs, SQRs good understanding on different levels of trace settings.
• Involved in requirements gathering in converting the legacy systems data to PeopleSoft staging tables of Billing, Receivables, Payables, General Ledger and Travel & Expenses.
• Possesses good knowledge as an Application Developer with a focus on Design, Development, Implementation and Maintenance of Software Packages.
• Experience with Agile, Scrum and Waterfall project life cycle methodologies.
• As a consultant supported day-to-day operations like applying updates and fixes, analyzing production support issues.
• Have hands on experience in Application Designer, PeopleCode, SQR, Application Engine, Integration Broker, Component Interface, File Layout, Workflow, Security, Operator Security, Data Mover and Upgrade Assistant.
• Extensive knowledge in developing and customizing reports using reporting tools such as SQR, PS Query, Crystal Reports, BI Publisher (XML) and nVision.
• Experienced in Client / Server, 3 Tire Architecture and Application Server.
• Have excellent data modeling, analytical and problem solving skills and very good team player with excellent communication skills. Excellent Troubleshooting and enhancing skills.

SKILL:

Operating Systems: Windows 2000/03/08, Windows NT 4.0, UNIX, Mainframes

ERP: PeopleSoft Finance 9.x/8.x

Modules: FSCM (GL, AP, AR, AM, PO, Inventory, Billing, ePro, T&E)

Development Tools: Application Designer, Application Engine, PeopleCode, AWE Workflow and Portal Technology, Tree Manager, Component Interface

Reporting Tools: SQR, Crystal Reports, nVision, PS Query Tool, XML Publisher

Data Management Tools: Data Mover and Import Manager, Configuration Manager, Process Scheduler, Process Monitor

Integration Tools: Integration Broker, Component Interface, File Layout, Workflow, Application Messaging, AWE

Programming Languages: PeopleCode, C, C++ Java, SQL and PL/SQL

GUI: Microsoft Visual Basic 5.0/6.0

Web Technologies: JavaScript, XML, XSL, XSLT, HTML and DHTML, Phire, Appsian, DellboomiServiceNow, Jira

Web Servers: WebLogic

RDBMS / DBMS: Oracle 8i, 9i, 10g, 11i, DB2, MS-SQL Server 2000

Application server: Tuxedo, WebSphere

Testing Tools: HP QC 10.0, QTP

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

PeopleSoft Techno Functional Consultant

Responsibilities:

• Provided production support and functionality enhancements to improve AP, AM, GL, and PO, Supplier Contract and Travel & Expenses efficiencies. Also, support for various PO/INV/AP/GL/TE process such as PO Dispatch, Outbound File Publish, Process Receipts, Reservations, Order Release Request, Picking Confirmation, Depletions, Cost Accounting Entries, INV Journal Generate, Voucher post, Payment Post, Matching, AP Journal Generate and expense processing.
• Collaborated with other departments, offshore team during system downtime. Played a team role in resolving the system downtime and Up-time monitoring the dependencies jobs in process monitor. Developed log for system downtime, within the server and Network.
• Did the analysis of existing customizations, conversion, interfaces, and report programs and identified the changes that needed to be made and documented the impact from the functional and technical perspective.
• Designed and developed inbound and outbound interfaces to and from PeopleSoft system using SQR, App Engine, File Layout, Component Interface and Integration broker (Cast Iron and Dellboomi tools).
• Developed new XMLP reports using XML file as data source and developed new app engine program to invoke the reports from Supplier contracts, PO, AP and T&E modules
• Managed PeopleSoft user accounts in multiple instances. Designed the local network, to import all the Month-end Financial ReportBook. Setup Synchronization of users to the Report server for Reports Security.
• Analyzed, designed and implemented the modifications for the Replenishment process in Ceridian Interface to load the payroll data.
• Worked on loading a new BU employee expense visa file into Mywallet from PNC Bank.
• Developed multiple complex interfaces to receive vendors/contracts/customers\contacts\Billplans from SDFC and create and send back.
• Worked on integrating the system with plants all over the world and developed programs and interfaces to handle multi-currency.
• Reviewed existing security architecture and policies and implemented changes to improve procedures and structure. Lead security requirements, design, development, and testing activities for PeopleSoft security including roles, row level security, permission lists, query security, Access Grid, object security, Process Groups and Query Trees. Read/Write access and enabling/disabled links. Deployed Security by creating FF profiles and assigning the user ID’s and maintaining password control page. Developed scripts to clean up users in PeopleSoft environments in order to synch users to OBIEE.
• Assist the Governance, Risk & Compliance team with necessary information for external Audits, like Roles analysis and Provide SOD Audit results for Queries received from external auditors.
• Extensively worked on Application Packages for the development of AWE workflows for Vendor Approval Voucher(AP) Approval Payment Approval Expense Approval.
• Created multiple paths to fit in the requirements for the workflow using route controls.
• Support security related tasks for Workflow and AWE. Revamped the PeopleSoft workflow and rebuild according to the new policies as company changed requisition approval policies.
• Gathered all the production issues, initiated and developed recommended steam line new process, with less turnaround time. And provided examples, clear communication and ensure they were well understood and enthusiastically embraced.
• Configured the Integration Broker delivered EIP incremental sync person basic, workforce, jobcode and department sync between HR and financial. Also configured one-time full sync between HR and financial for person basic, workforce, jobcode and department sync.
• Unit tested the developed application and created test scripts and test cases for the Unit Testing and System Testing.
• Developed reports for items, item categories, item catalogs, material transactions, material statuses, item costs, item locators and item on hand in Inventory.
• Involved in setting up workflow and involved in defining workflow roles, route controls for Traven and Expense module.
• Designed and developed voucher Approval workflow process to send worklists and emails for the Match exception.
• W orked on the PeopleSoft Asset Management AM team for a Maintenance Management MM implementation.
• Review & apply Maintenance Packs, Patches & Bundles to newly created environments. Applied Certificates inserts when implementing DellBoomi Integration tools. Created scripts to move security to lower environments on refresh. Also, worked on updating all the non-prod and Phire environments from http to https Internet to Intranet.
• Involved in setting a multifactor authentication also expensively worked in LDAP set-up in PeopleSoft application.

Confidential, McLean, VA

PeopleSoft FSCM Analyst

Responsibilities:

• Involved in Fit Gap Analysis for GL, AP, Purchasing, INV, ePro, AM, Project Costing, Grants, Treasury and Contracts modules and assisted the technical team in setting up the financial modules as per the client’s requirements.
• Analyzed the compare reports between the current production and the demo 9.2 version.
• Identified the objects, which needed to be retrofitted by doing the complete impact analysis.
• Created Technical designs for AP, GeneralLedger, AR, AM, Billing, PC, PO, ePro and Expenses modules.
• Develop and test report, interface, conversion, and enhancement programs to meet the requirements in the technical specifications.
• Customized the delivered pages and Debugged the peoplecode and the SQR reports for the requested requirements for AccountPayable and AccountReceivable Aging reports.
• Customized delivered GL SQR’s (GLS 7010, GLS 7002, GLS7014) to run the reports for ‘ALL’ Business Units.
• Analysis and planning upgrade approach and upgrade of all preproduction environments.
• Developed and Troubleshooted the XML Publisher Reports.
• Customized My Wallet and EX SHEET ENTRY page to display Procurement card information
• Created functional specifications based on business process needs, wrote test scripts and supervised the entire customization process in collaboration with the technical team.
• Involved in the setup of business units, configuring the setup options for Supply Chain Modules (AP, Purchasing, eProcurement)
• Developed an SQR data conversion program to import payments from a third party system to AR module.
• Customized PeopleSoft delivered Posted Voucher Listing Crystal report APY1020.rpt for AP module.
• Modified pages in GL module base on client specific requirements.
• Maintained all application engine applications like PC TL TO PC, PC EX TO PC, PO CALC, ARUPDATE, GLPEDIT, VOUCHER EDIT & POST, Payment selection, Payment creation, Pay check creation processes as daily work.
• Helped modify requisition, PO, voucher and receipt pages so that the asset information flows through correctly from the source systems to the asset management AM tables.
• Reviewed and corrected Order Management (OM), Inventory, Billing and Purchasing Configurations in PeopleSoft.
• Tested Enable Employee Self-service Enhancement where the user is unable to change his/her home address in Update Profile page and enable expense payments to be routed to alternate locations (addresses) other than the address sent from PayServ.
• Interacted with the Users and Functional analysts to come up with new requirements for the business unit.
• Modified the AR to Billing interfaces for direct deposit using CI and application engine program.
• Expansively used tools like Process Scheduler and Process Monitor for the execution of SQL and Crystal Reports.
• Provided 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.
• Performed extensive debugging and performance tuning of various processes. Well versed in utilizing tools and utilities provided by PeopleSoft (Debugger, tracing etc.) for trouble shooting issues on People Code, Application Engine, SQR’s & Online.

Confidential, Roanoke VA.

PeopleSoft Techno Functional Consultant

Responsibilities:

• Provided detailed test plans and technical documentation
• Developed Custom Billing interface program, added functionality for Discounts and surcharges for custom invoices, per client requirement.
• Created Process Definition, Run Control Record, Page and component to run the batch program through Process Scheduler and Scheduled the jobs through process scheduler.
• Worked on several inbound and outbound interfaces using Application Engine, Component interface, File layout and also Integration Broker.
• Modified the delivered BI Invoice attachment program using Integration Broker.
• Developed a new online inquiry page to view Open commitment on the Purchase order by comparing the data related to the Requisition and Receipts.
• D eveloped Static and Dynamic AWE workflow paths depending on the requirement.
• Involved in writing SQR, which moves data from ESI system to PO tables like PO HDR, PO LINE and PO LINE SHIP etc.
• Designed and developed multi-level approval workflow process for requisitions, purchase order and for material stock request etc. and suggested modification for dispatch process(POPO005), requisition print report etc.
• 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.
• Developed several new reports using various reporting tools such as PS Query, nVision, Crystal Reports, BI Publisher and SQR .
• Developed programs using File Layout, Application Engine and PeopleCode extensively for the Import and Export of flat files and BI files.
• Changes to PeopleCode so as to reflect the customizations as per the Clients requirements and execution of Queries on Security tables for Performance checks.
• Developed SQR programs for one-time conversion of Vendor and Customer’s Data from legacy system to PeopleSoft.
• Created around 20 crystal Reports and ran through the process scheduler.
• Performed extensive debugging and performance tuning of various processes. Well versed in utilizing tools and utilities provided by PeopleSoft (Debugger, tracing etc.) for trouble shooting issues on People Code, Application Engine, SQR’s & Online
• Expansively used tools like Process Scheduler and Process Monitor for the execution of Crystal Reports