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

Responsibilities:

• Functional and technical design specifications for following inbound and outbound interfaces.
• 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.
• 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.

• 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 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.
• 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:

• Functional and technical design specifications for following inbound and outbound interfaces.
• 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.
• Invoice status Application Engine program.
• Invoice and Credit Memos Voucher build application message.
• Combo Data Application Engine to create the Pipe delimited files converted into XML using BizTalk.
• PO/Change Order Interface PeopleSoft delivered Application message mapped to PIDX format.
• 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.

Confidential

Lead Consultant

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

Responsibilities:

• Responsible for running the month-end, quarter-end processes that allocated the cost and created the mechanized bills.
• Worked with users on resolving the cost allocation issues.
• Modified a few AT T custom SQR programs to remove hard coded values and accommodate new fields.
• Worked on resolving the mechanize bill print process issue.
• Worked on PeopleSoft security to create new roles, permissions and user profiles.
• Responsible for supporting application server, process scheduler and web servers in absence of system administrator.
• Worked closely with DBA team to get the backups and test environment refresh.
• Changed the AT T custom AR performance update process to pick up missing data from previous months and updated the AT T custom tables behind the scenes for missing entries.
• Responsible for moving PS projects across test and production environments.
• Modified the crystal report used for reporting un-processed templates.
• Changed the views definition and built new views to get the data from product and chartfield2 tables.
• New accounting and migration to CFAS Corporate financial Accounting System .
• System study to understand the current accounting and be able to implement the new accounting.
• Prepared the business requirement and technical specification documents.
• Developed an Oracle stored procedure to validate the accounting on manual bills.
• Introduced new accounting by updating and inactivating the old accounting values.
• Responsible for maintaining PeopleSoft trees for new accounting.
• Modified bill load SQR program to use the new Business Unit, Company code tree and removed hard coded accounting values.
• Modified existing PeopleCode and developed new PeopleCode for new accounting.
• Responsible for changing the configuration tables with new values and writing the mass update scripts on automatic accounting entry and distribution code tables.
• Developed and scheduled a new SQR program to write the FRL Financial Record Layout file in new format with new accounting structure and values.
• Developed and scheduled a new UNIX shell script for file transfer.
• Setup and use of connect direct for file transfer.
• Modified a few mass change definitions and criteria to have the new accounting values.

Confidential

Lead Consultant

Technical Environment: PeopleSoft Financials 8.4, PeopleSoft Financials 8.9, SQL, Oracle 8i, Windows XP and UNIX.

Responsibilities:

• Involvement in the Fit-Gap analysis for 8.4 8.9 upgrade.
• Responsibilities included requirements analysis documentation for new modules, business and process analysis, customization rationalization, system configuration, report and customization specifications, conversion validation, prototyping and testing, troubleshooting and support. Modules included Payables, Purchasing, Billing, Contracts and Account Receivables.
• Configured new pay group codes and new bank setup to identify XIGN enabled suppliers.
• Integration broker setup for multiple interfaces.
• Payment Developed an EFT SQC to create outbound XML file.
• Discount Instructions Updated the relevant voucher tables using SQR program for processing inbound discount file from XIGN.
• Invoice status SQR program to create an outbound status flat file.
• Invoice and Credit Memos - Created new EDI maps for loading inbound invoice/credit memo data from XIGN.
• Combo Data Application Engine to create the flat files.
• PO Acknowledgment and Change Orders Used file utility to convert the XML file into a Application Message and subsequently processed data using change load application engine program to create PO change orders.
• PO Conversion and PO Interface SQR program to create the XML files.
• Designed the functional specifications and developed the following inbound and outbound interfaces to implement XIGN integration with Honda's PeopleSoft Financial and SCM modules.
• Changed Purchasing configuration to enable auto approval of change orders coming from XIGN.
• Configured a new Pay Cycle by creating an EFT layout and adding the EFT SQC developed to create the XIGN payment files XML .
• Customized the voucher entry, approval and inquiry pages to include the URL for XIGN comments and invoice links.
• Developed pages and components for comments, terms and conditions.
• Created run control pages, recurrences, process definition and job definitions to run the interfaces through process scheduler.
• Created dos batch files to execute from Application Engine programs to move files to Processed/Exception folders.
• Worked on resolving the Matching process AP MATCHING issues.
• Coordinated the UAT sessions using Mercury Quality Center, go live and production support.
• Developed pages to give users the access to flip flags in case of a matching failure and created new tables to keep the audit trail for SOX compliance.
• Resolved the in service date issue on depreciation calculation AMDPCALC SQR process by modifying the AMDCPOST.SQC, AMDPCALC.SQC, AMDCDATE.SQC programs.
• Developed SQR programs to load the buy up and leased assets into temporary tables INTFC FIN, INTFC PHY A, and INTFC PHY B and ran the trans loader AMIF1000.SQR to load the assets into application tables ASSET, BOOK, COST .
• Identified the issue and patches to resolve a unique constraint issue on the Withholding Update AP WTHD UPDT application engine process.
• Developed new and modified existing UNIX Shell scripts to run the batch processes.
• Developed translate SQR program to convert an inbound file into PeopleSoft business document layout to run it through ecin0001.sqr and load the vouchers into temporary EC tables.
• Created new EDI maps to load the voucher data.
• Developed the SQR programs to create pre 820 and final 820 reports.