OBJECTIVE

Over Eleven years of IT experience and Ten plus years of extensive experience in Implementation, development and Production support of PeopleSoft Financials/HRMS 9.1/9.0/8.9/8.8/8.4/8.0/7.5, Accounts Payable, Purchasing, Accounts Receivable, e-Procurement, Commitment Control, General Ledger, Asset Management, Billing, Project Costing, Order Management, Inventory, Payroll applications as a Techno-functional Analyst using Unix and windows environment.

Summary

Functional experience would include client business process analysis and re-engineering, configuring the applications, leading fit and gap product review sessions, creating business requirements, writing detailed specifications, development of change management procedures and policies, create and maintain the project plan, facilitate meetings with the user and management community to gather requirements, production support incident/issue tracking, writing test scripts, trouble shooting, configuring the application, ad-hoc client reporting SQL, PS Query, Crystal, nVision, SQR, Business Objects , job stream configuration, and user training. My functional PeopleSoft application knowledge includes PeopleSoft Applications SCM financial modules OM, PC, Contracts, AP, AM, GL, PO, BI, IN, AR, BU , eProcurement, Procure to Pay, VAT and SUT setup. Very familiar with the EU EDPA requirements and implications of the Sarbanes-Oxley Act SOX for corporate governess and how it relates to the PeopleSoft applications.

Technical skills Proficient in PeopleSoft versions 7.x, 8.3, 8.4, 8.8, 8.9, 9.0, 9.1 include development with PeopleTools PeopleCode, Application Package, Application Engine, Panel/Page Design, XML, DataMover, Business Process Designer, Component Interfacing, Application messaging, Process Scheduler, Tivoli Scheduler, Mass Change, Query Tools, ETL Data loader, Portal, Cube manager, ExcelToCI, Workflow, Security Configuration, as well as assisting in application upgrades Change Assistant Upgrade Assistant services and installations from versions 2.0 through 8.9. Other technical skill include Web logic, SQL, SQR, nVision, Date Modeling, Business Objects, ETL Tools Informatica, Abinitio, Accentual , C , VB, ORACLE PL/SQL, DB2, COBOL. I also have over 10 years extensive PeopleSoft reporting design, debugging skills and development skills using various tools such as XML Publisher, nVision GL Reporting , Crystal Reports, SQR, and Business Objects. Third party integration with SOAP, WSDL and FTP using integration Broker. Load balancing and auto-testing tools Winrunner and Loadrunner.

Skill Set

• PeopleSoft Financials 7.5/8.0/8.4/8.8/8.9/9.0/9.1.
• PeopleTools 7.5, 8.0, 8.12, 8.20 and 8.42, 8.44, 8.46, 8.47, 8.48, 8.49, 8.51 Application Designer, Application Engine, PeopleSoft Internet Architecture, Administration, Process Scheduler, PeopleCode, PSQuery, PS nVision and Tree Manager Upgrade Assistant, Application Packages, PeopleSoft Integration Broker/Tools Application Messaging, Component Interfaces ,WSDL etc ,jDeveloper.
• SQR, Oracle Reports, Crystal Reports 6.0/8.0/8.5
• ORACLE 11g/10g/9i/8i/7.x, MS SQL Server6.5/7.0/2000, MS Access.
• UNIX, Linux, DOS, Windows 2000/NT/xp/7/4.0/98/95/3.12.

Experience

Confidential

Techno-Functional Consultant

Technical Environment: PeopleSoft Financials 9.1, People tools 8.51, SQL, DB2, Windows 7 and UNIX.

Responsibilities:

• Data Mapping between PeopleSoft delivered XML messages and iPay XML.
• Invoice status Application Engine program for creating the XML files using XMLDoc.
• Invoice and Credit Memos Voucher build application message for loading the voucher data and transform program XSLT using jDeveloper to convert iPay XML into PeopleSoft format.
• Vendor Data Application Engine to create the XML files using XMLDoc.
• PO Schedule Application Engine program to send pipe delimited files with PO Schedules.
• PO/Change Order Interface Application Engine program to send the XML file to iPAy for PO Activity using XMLDoc.
• Functional and technical design specifications for following inbound andoutbound interfaces.
• Used jDeveloper to do the message transformations.
• Integration broker setup for multiple interfaces.
• Developed a new special request form in ePro for e-check reqs.
• Designed and developed an application engine program to convert e-check PO's into Vouchers.
• Created new voucher origins for loading vouchers in specific control groups and automated the entire voucher process.
• Prepared the Unit Test plans for testing the interfaces.

Confidential

Techno-Functional Consultant

Technical Environment: PeopleSoft Financials 9.1, SQL, Oracle 11g, STAT 5.6, Windows NT/7 and Linux.

Responsibilities

• Created several functional/technical design documents based on the business requirement.
• Worked as a liaison between technical and functional team to understand the functional requirements and converting them into functional/technical design documents.
• Involved in the implementation and customization of the PeopleSoft 9.1 Financials e-Pro, PO, AP, KK, GL and PC modules based on organizational needs and requirements.
• Implemented a Single Sign On solution for the integration between PeopleSoft and OnBase.
• Designed and developed Component Interfaces and Web Services in e-Pro/PO/AP modules to integrate with a third party system, OnBase, for approvals and storing documents.
• Customized the REQ/PO/AP/GL Workflow based on distribution level routing for Columbia Specific workflow using AWE.
• Developed and customized several PeopleSoft Objects, Pages/Components/Application engine programs, using Application designer.
• Worked extensively on new Application Packages and customizing the existing ones as per Columbia requirement.
• Cloned GL entry component, customized it for Inter/Intra fund transfers in GL, and routed the users to right pages/components based on the source transaction.
• Customized and wrote PeopleCode based on the requirements.
• Application engine program to load data, 27 tables full refresh, into the budget tool integrating system.
• Created process definitions and used process scheduler to schedule the processes/jobs.
• Worked with Security/admin team to grant access, design new permission lists, roles based on the requirements.
• Assisted technical team with using string tables and removing hard coding from possible areas of peopleCode and application engine programs.
• Developed a new component interface/application engine program to load purchase orders/change orders from an integrating system.
• Developed search views/records to implement row level department security in e-Pro/PO/AP and GL modules.
• Worked with DBA's on resolving performance issues by using explain plans, indexes and stats for fine tuning the SQL's.
• Opened cases with Oracle support to report PeopleSoft bugs and found incidences/patches to resolve open issues.
• Unit tested all the solutions before migrating into to QNA and assisted the testing team with Performance testing and understanding the functionality.
• Worked on resolving the issues during testing phases and used SIR logs/share point to keep track.
• Used STAT 5.6 for migration of PeopleSoft objects between environments.

Confidential

Functional Consultant

Technical Environment: PeopleSoft Financials 8.9, SQL, Oracle 10i, STAT 5.6, Windows NT/7 and Linux.

• Part of the configuration and implementation team, implementing PeopleSoft SCM 8.9 modules such as eProcurement, Purchasing and Account Payable.
• Performed a dual role of leading a PeopleSoft testing team and of a PeopleSoft Functional Consultant.
• Involved in the Requirements Gathering for PeopleSoft modules ePro, PO, AP.
• Involved as one the key functional Analyst in the implementation/integration between PeopleSoft and Ariba Network.
• Interacted with Vendors and Ariba SMEs to onboard CIF/Punchout catalogs onto APC Ariba Procurement Content .
• Involved in the design of Multilayer Fiscal/Non-Fiscal WorkFlow model for requisition approval in eProcurement module with EHU and FDA data.
• Interacted with Vendors to onboard them as Punchouts in PeopleSoft eProcurement.
• Designed and tested inbound and outbound interfaces between PeopleSoft and WISE Warehouse and Inventory System Expert Legacy system where materials are received and asset tags and serial numbers are assigned.
• Designed and tested intermediate solution for outbound interfaces between PeopleSoft and ACTR Asset Center Legacy system where Asset information is stored.
• Involved in the design and testing of modifying existing Auto Sourcing process of creating Purchase orders from Requisition as per User requirements.
• Involved in the design and testing of new features in PeopleSoft modules ePro/PO such as 3rd Party leasing items, Bundling items, Trade-In items, Requestor/additional Information on FAX/EDI/cXML Purchase Orders.
• Provided Demos of the complete ePro/PO implementation to Business Stakeholders and Production Support team.
• Verified the impact analysis, User sessions, prepared functional design, and functional specs for the implementation/integration between PeopleSoft and Ariba Network.
• Performed the Fit Gap analysis and the Upgrade lab sessions to sort out the new functionalities to be added to the existing system.
• Lead a team of 10 testers onshore and offshore to perform SIT System and Integration and Regression testing.
• Interacted with Business Analysts to figure out the Process flow in various Business processes.
• Involved in end to end testing of the Peoplesoft modules eProcurement, Purchasing, Accounts Payable, General Ledger, BRPT, Taxware, TWS
• Responsible for maintaining the Project Plan and attending business requirements sessions, Fit-Gap sessions with business and Technical teams.
• Developed Test Cases , Test Scenarios and created Test data and executed tests in Quality Center 9.2
• Tested and validated the Customizations to the Desktop delivery system in eProcurement module.
• Worked in processing inbound and outbound EDI transactions in PO and AP.
• Worked on the configuration setup for eProcurement, PO,AP which includes setting up core people soft Tables, vendor tables, customer tables and Procurement core tables, Interface configurations.
• Carried out Integration test, System test for eProcurement, Purchasing and Account Payable.
• Tested Customized PO dispatch Report POPO005 which creates EDI 850s.
• Created test approach, traceability matrix, and test plans to test new functionality.
• Tested the Interface programs for interfacing Purchase Orders from external systems. Set up the EDI Manager for Purchase Orders to load the PO's into stating Tables.
• Developed the scripts to verify the validity of the converted data according to the functional requirements.
• Conducted regular smoke tests for every test environment refresh.
• Provided Test Evidence for User Acceptance Testing to the business team for SOX Auditing
• Extensively working on Production support and resolved issues in ePro/PO/AP/BRPT. Modules based on the priority levels.
• Conducted weekly Team meetings to discuss the status of testing process with QA Lead, QA managers and lead developers. Updated management with project status, defects, issues and risks.

Confidential

Functional Consultant

Technical Environment: PeopleSoft Financials 8.8, People tools 8.44, SQL, Oracle 9i, Windows XP and UNIX.

• Involved in the Requirements Gathering Phase for AP, PO, AR, Inventory, Order Management, Project Costing and designed functional design documents for AP, PO, Inventory, E-Procurement, Order Management, E-Procurement and Project Costing modules.
• Developed Test Cases, Test Scenarios and created Test data and executed tests in Quality Center 9.2.
• Responsible for maintaining the Project Plan and attending business requirements sessions, Fit-Gap sessions with business and Technical teams.
• Involved in end-to-end testing of the PeopleSoft modules Purchasing, Inventory, Accounts Payable, General Ledger, Order Management and Project Costing modules.
• Involved in framework design to automate Test cases in QTP 9.0/QC 10.0
• Worked extensively in debugging, tracing and compiling various Application Engine, SQR programs of PO, INV, AP, and OM.
• Created test plans test cases and tested the various Peoplesoft financial modules Maintenance, new Request, and Problem tickets.
• Run the SQR's, batch jobs, AP Cycles using Control-M scheduler and online process scheduler and generated various financials Reports.
• Extensively worked on Order Management/Billing Interface OM BILL Process, used SQL to analyze the interface staging tables to correct the errors.

Confidential

Integration Architect

Technical Environment: PeopleSoft Financials 8.9, People tools 8.48, SQL, Oracle 10g, Windows XP and UNIX.

Responsibilities:

• PO/Change Order Interface PeopleSoft delivered Application message mapped to PIDX format.
• Functional and technical design specifications for following inbound and outbound interfaces.
• Combo Data Application Engine to create the Pipe delimited files converted into XML using BizTalk.
• Invoice and Credit Memos Voucher build application message.
• Invoice status Application Engine program.
• Data Mapping between PeopleSoft delivered XML messages and dO2's PIDX MIME messages.
• Discount Instructions Updated the relevant voucher tables using SQR program for processing inbound discount file from dO2.
• Used BizTalk to do the message transformations.
• Integration broker setup for multiple interfaces.
• Configuration and Integration Broker setup for catalog Punch-Out using OCI standard.
• AP workflow design document.
• Prepared the Unit Test plans for testing the interfaces.
• Delegated and managed the development work to an offshore team.