SUMMARY

• Over Thirteen years of experience as a PeopleSoft FSCM Lead Technical consultant. experience in Implementation, Customization, Upgrade and Development of PeopleSoft Financials applications. Managed and led teams from multiple geographies through all stages of the software development life cycle including defining the project scope, designing the application architecture, executing fit - gap analysis, designing, developing, testing major customizations to modules and end users.
• Successful bringing proven experience in delivering projects on-time, under budget, meeting milestones, interface with customers and communicating effectively. Thorough understanding of PeopleSoft Financial and Supply Chain Management modules, including AP, PO, GL, PeopleSoft’s Strategic Sourcing module, Project Costing, Contract, Inventory, Billing, Financial Learning Resources, Payment Method, Catalog Structure.
• Extensive experience in full life cycle of implementation, including design, configuration, development, integration, testing (Unit, System, Regression and User acceptance testing) and deployment of new conversion.
• Strong technical skills in PeopleSoft Application Development, PeopleSoft Data Conversion, PeopleSoft Reports and Relational Database Management Systems.
• Designed, built and tested reports, interfaces, conversion objects, enhancements.
• Demonstrated expertise in building Application Engine programs, PeopleCode, Component Interfaces (CI), Excel to CI, Workflow, Application Packages, Application Messages, Web Services, On-line Customizations using the Application Designer and working with the Integration Broker.
• Strong experience having developed several reports in SQR, Crystal Reports, BI Publisher and PS Query. Strong experience with PL/SQL scripts using SQLs having complex joins.
• Significant experience in a Business Analyst role, extensively involved in analyzing business issues and in preparing use-case and fit/gap documents. Substantial involvement in Implementation, Customizations, Bundle Application, People Tools Upgrade, Support and Maintenance.
• Review and understand established Should-Be state for General Ledger and Accounts Payable business processes for strategic improvement including inbound/outbound interfaces to third party system and sub-modules.
• Over EIGHT years of experience in several documents like: AUD (Application Understanding documents), Fit-Gap documents (Hardware & Software gap, Network gap and skill gap documents etc.), Business Requirement Documents (BRD), High Level Design (HLD) documents, High Level Flow, Low Level Design (LLD), Test documents, MOM (minutes Of Meeting), Weekly & monthly report, User Manual, Deployment documents and many more documents.
• Performed testing in PeopleSoft using test scripts and automated testing using PeopleSoft Test Framework (PTF).
• Over TEN years of honing skills in PeopleSoft reporting design and debugging and development using various tools, such as XML Publisher, Crystal Reports, SQR, and Business Objects. Also skilled with third party integration with (SOAP, WSDL and FTP), using Integration Broker, and load balancing and auto-testing tools (Winrunner and Loadrunner).
• Over EIGHT years of experience in Oracle Database including Oracle PL/SQL, DB2, Oracle 10g, 11i, SQL.
• Functional PeopleSoft application knowledge includes: PeopleSoft Applications FSCM & HRMS (OM, Project Costing, Contracts, AP, GL, PO, BI, IN, AR, AM, Expenses), eProcurement, Procure to Pay, O2C, Activity-Based Management and Business Planning and Budgeting.

TECHNICAL SKILLS

Reporting tools: SQR, XML Publisher, Crystal, nVision, PS query, BI Publisher.

Other area of expertise: It includes SQL, SQR, Data Modeling, Oracle PL/SQL, Indexing, DB2,Oracle10g., STAT, EMS, UC4 (Automic ),WinSCP, Shell Scripts, SQL Runner, SQL Navigator.

Other Languages: Java, COBOL, VB 6.0, PL/SQL, HTML, XML, Java Script.

Database/Servers: Oracle 9i/10g, 11gR2, MS Access, DB2, MS SQL Server.

Operating Systems: Linux, AIX, UNIX, Win 2003 Server, Win XP Professional, Win NT, Win 98/95/2000

Networking/Storage: TCP/IP, HTTP, FTP, SMTP, Familiar with SAN.

Migration tools: Phire, Stat.

Automation tools: UC4.

PROFESSIONAL EXPERIENCE

Confidential, Glendale, CA

PeopleSoft Lead Technical Consultant

Responsibilities:

• Provided application technical support for implementation of new functionality, development of user requested modifications to the system, coordinating updates from PeopleSoft support, and user .
• Used App Designer to modify the existing records and created some new Records, Pages and Menus based on the functional specifications. Developed an SQR program to generate an electronic statement of monthly bank statements.
• Created Asynchronous and synchronous (WSDL) for 3rd party vendors (Lexmark) to get the invoice information.
• Developed SQR reports for reconciliation data. Set up PeopleSoft out of the box cash management module for reconciliation of AP and AR data. In order to get GL data in the system created an application engine program to get GL data in to application table for reconciliation.
• Created custom Billing interface for international (Mexico & Canada) vendors, to accept the multi-Currency in Billing .
• Installed and apply the PUM 20 and Patch 23 for the current version.
• We are using Image-Now tools for voucher Screen Scraping and capturing the invoices. So, Confidential have created a interface between Image-Now (webNow) and PeopleSoft.
• Created Forecast report for asset management, to forecast the future asset deprecations.
• We are using RE (Real Estate) Module, Confidential have customized the RE header table to accept the all asset ids.
• Created AR Statement and Invoice reports in BI Publisher and used the BURST method for different vendors.
• Created several MoveIT services for transferring files to Wells Fargo and CITI bank.
• We are using Salesforce application to capture the Billing and CRM data. So Confidential created an interface between Salesforce and PeopleSoft to capture the Location and billing and customer data. Customer data created on Salesforce and it flow to PeopleSoft through interface.
• Performed Unit and Integration testing of General Ledger module and resolved issues. Executed performance tuning after migration. Provided guidance and help to the offshore development team in creating test cases for separate financial modules and overall financial integration testing.
• Work as the Subject Matter Expert for implementing PS Strategic Sourcing 9.0

Environment: PeopleSoft FSCM9.2, PeopleTools 8.54, Oracle 12c., WebNow, TFS, MoveIT

Confidential, CA

PeopleSoft FSCM Technical Lead Consultant

Responsibilities:

• Worked as the Project Team Lead for the implementation of PeopleSoft Financials for the university system of Lithuania. (General Ledger, Accounts Payable, Billing, Accounts Receivables, Commitment Control, Asset Management, Purchasing, Travel and Expense, Strategic Sourcing version 9.1)
• Developed Application Engines program from Scratch and Peoplecode changes based on the client's requirements. Wrote batch scripts using Unix Scripting (bash shell script) and created Interface Control jobs.
• Modified the AR to Billing interfaces for direct deposit using CI and application engine program.
• Built and customized Component Interface and used Excel to CI PS delivered feature for Item Loader process
• Enhanced existing SQR’s to print invoices, purchase orders, price confirmations and request for quotes. Receiving Vendor, Item, Receipt Date and Receiving Log by Date, Item reports.
• Migrations of customizations like Record definitions, pages, Components, Run control pages, Portal Registries, A.E Programs and Component Interfaces for all modules.
• Developed AR interfaces for direct deposit using CI and application engine program.
• Modify the Account receivable business process, configured the AR unit and entry type pages . Added new cost rate in AR.
• Developed AP interfaces (Voucher staging and edit program for Telematics interface ) using File layout and Application Engine program and converted the data from legacy system to PeopleSoft database, using TAB delimited files. Designed the Run control pages for run the interface (Telematics interface).
• Using STAT tools for migration and EMS tools to create the migration request.
• Developed several reports in SQR, XML publisher, PS query reports, Nvision and Crystal reports.
• Worked on several enhancement requests including changes to AR/express deposit pages, writing custom queries using the PS Query Tool, PeopleCode changes, importing conversion Data, creating and configuring 3rd party Interfaces into and from PeopleSoft and out/in, to/from other systems.
• Assist with impact analysis, decision making, workarounds, and designs related to the functionality being implemented in AP and eProcurement, Billing & Asset management module. Interfaces done from 3rd party system using integration broker.
• Developed many Queries likeAP Vendor Total PaymentsQuery, Purchase Order Accounting Review Query, Total Vouchers and Payments Query etc
• Create and execute various test scripts as per test plans and execute them in different environments for AP in bound and outbound Interfaces (AP and PO automated Interfaces ).
• Performed testing in PeopleSoft using test scripts and automated testing using PeopleSoft Test Framework ( PTF).
• Create test plans for System and Integration testing, Regression Testing, User testing.

Environment: PeopleSoft FSCM 9.1, PeopleTools 8.54, Microsoft Windows, Oracle 10g.

Confidential, Pittsburgh, PA

PeopleSoft Technical Lead Consultant

Responsibilities:

• Expert in full lifecycle Implementation from different levels like Requirements gathering, Design, Development, Tuning, Testing and Application Maintenance.
• Extensive experience working with PeopleTools, PeopleCode, Application Designer, Application Packages, Application Engine, Component Interface, File Layout, Application Messaging, Integration Broker, Security, Tree Manager, PS Query, Process Scheduler, Data Mover, Import Manager,Workflow (AWE), Upgrade and Change Assistant, SQR, Crystal Reports and XML Publisher.
• Identified and performed the design, build, test for upgrades or modifications to next Legacy systems.
• Closely monitoring offshore project activities and testing team daily works .
• Assist with impact analysis, decision making, workarounds, and designs related to the functionality being implemented in AP and eProcurement, Billing & Asset management module. Interfaces done from 3rd party system using integration broker.
• Helped modify requisition, PO, voucher and receipt pages so that the asset information flows through correctly from the source systems to the asset management tables
• Publish file through integration Broker (PS query report and Vendor delta file) in HTTP. Create detailed test scripts for Functional Unit Testing and System Testing. Execute testing scripts for Functional Unit Testing, System Testing and Data Conversion validation testing.
• DebuggedAP PSTPYMTandAP PSTVCHRfor issues in payments and voucher posting.
• Perform customizations on delivered business process (P2P and O2C process flow )and work on new enhancements using People Code, AE, CI, and SQR, UNIX shell script and Web services.
• Creates new Unix shells scripts and power shell for batch processing and for file processing using network share drive (Winscp) and Autosys (scheduling tools). Develops various PS queries in order to help the client day-to-day activity.
• Conducted meetings with the Users and the testing team and involved in discussing their problems and helped them out in finding the proper solutions for their requirements. Work on different scheduling tools like UC4 (Automic tools). And Migration tools (STAT tools).
• Developed test cases and executed for creating, editing different online and other Journal Entry in General Ledger module.

Environment: PeopleSoft FSCM9.1 PeopleTools 8.53, Microsoft Windows, Unix, Oracle 10g.

Confidential, Denver, Colorado

PeopleSoft Technical Lead Consultant, PeopleSoft FSCM 9.2

Responsibilities:

• Involved in Resolving day-to-day production tickets in FSCM system. Configure Payable System (Pay cycle), Requisition, Inventory, Templates, Workflow and notifications for the PO. Worked on Order Management and picking, packing and Shipping process.
• Fixed the issues involved in O2C phases (order to cash). Modified the O2C business processes as per the client requirement. Lead functional walk-thru sessions with clients and executives, including project status presentations.
• Prepare and execute fit/gap sessions with the user community; analyze all functional requirements for translation into functional fits and gaps. Prepare and maintain project plan, project scope, functional requirements, and functional solution specifications documents.
• Assist with impact analysis, decision making, workarounds, and designs related to the functionality being implemented. Assist project manager with overall project planning. Built detailed "road maps" for conversion planning and data mapping to PeopleSoft Products/Applications.
• Assist technical development staff with technical specification documentation and technical unit testing. Create detailed test scripts for Functional Unit Testing and System Testing. Execute testing scripts for Functional Unit Testing, System Testing and Data Conversion validation testing.
• Document and manage defects and issues related to the testing of designed solutions. Develop and deploy enhancements to inventory module and implemented Purchasing Processes.
• Work on several enhancement requests including changes to AR/express deposit pages, writing custom queries using the PS Query Tool, Peoplecode changes, importing conversion Data, creating and configuring 3rd party Interfaces into and from PeopleSoft and out/in, to/from other systems.
• Perform customizations on delivered business process and work on new enhancements using Peoplecode, AE, CI, and SQR. Uploading bundles and patches for maintenance management activities. Generate several Expenses reports. Taking data from 3rd party system.
• Spreadsheet upload of Vouchers and other voucher interfaces (Excel to CI ).
• Have prepared Grants chart for projects. Developed various PS queries in order to help the client day-to-day activity. Conducted meetings with the Users and the testing team and involved in discussing their problems and helped them out in finding the proper solutions for their requirements.
• Execute test for creation of online and batch process of vouchers, edit vouchers, approve vouchers, posting of vouchers in Account Payable module.

Environment: PeopleSoft FSCM9.2, PeopleTools 8.54, Oracle 10g.

Confidential

PeopleSoft Technical Lead Consultant

Responsibilities:

• Performed Production Support, enhancements and customizations of PeopleSoft FSCM 9.1. Configured Requisition, Purchasing, Payable, Project & Billing business unit in PeopleSoft FSCM system.
• Created Business Requirement Documents (BRD), High Level Design (HLD) documents, High Level Flow, Low Level Design (LLD) and Deployment documents for all financial modules where the modifications were identified and listed.
• Organized and provided sessions to development and QA team to reinforce their understanding of financial modules functionality and specifics of PeopleSoft applications.
• Significantly involved in the re-application of Saint-Gobain (SG) customizations for the new 9.1 PeopleSoft application.
• This included custom approval work flows for the PeopleSoft applications, customizations, upgrading SQRs, Peoplecode, SQL Queries, and Application engine programs to the new 9.1 table structures.
• Created XML interfaces to other SG systems and vendors using the Integration Broker (SOAP, WSDL and FTP) methods. Applied PeopleSoft bundles fixes and patches.
• Responsible for application configuration, creating client specific PeopleSoft applications (components, pages, Peoplecode), using the Application designer, and performance tuning the 9.1 applications to improve user experience. Fixed the issues involved in O2C phases (order to cash).
• Modified the O2C business processes as per the client requirement. Responsible for creating journal uploads through the use of MS Excel program. Done the setup of all the chart accounts, chart fields and Business unit for inventory and manufacturing modules.
• Developed a fully automated picking, packing & shipping system (in inventory system) by using Application engine, CI and file layout, designed page, component, menu etc.
• Created detailed test scripts for Functional Unit Testing and System Testing and load testing using HP.
• Executed testing scripts for Functional Unit Testing, System Testing and Data Conversion validation testing. Documented and managed defects related to the testing of the designed solutions.
• Developed and deployed enhancements to the Inventory Module and Implemented Purchasing Processes.
• Troubleshot Journal Generator process for ‘missing Inter-Unit Accounting Lines', ‘Unbalanced Journal Entries', 'subscript out-of range' errors. Created and executed Test Scripts for unit testing in GL for testing ‘Journal Entry', ‘Open a Period', ‘Close a Period', etc. Functionality.
• Developed various PeopleSoft queries in order to help the client day-to-day activity.
• Conducted meetings with the users and the testing team to identify issues and helped to identify the proper solutions for their requirements. Utilized various scheduling tools such as Control M(jobs).
• Reviewed all custom batch processes such as SQR, AE, COBOL and prepared documentation for all nVision re-mapping.

Environment: PeopleSoft FSCM9.1, PeopleTools 8.53, Oracle 10g.

Confidential

PeopleSoft FSCM Technical Consultant.

Responsibilities:

• One of the on-site team leads; responsible for the functional and technical aspects of the implementation of the following modules/products: Requisition, Purchasing, Payable, Receivable, and Billing.
• Also, responsible for interfacing with the clients external fund system & corporate applications. Co-Lead on functional fit-gap and walk-thru sessions for the clients and stakeholders.
• Responsible for data conversion from the FSCM 8.9 to FSCM 9.0 product. (Finance, Requisition, AP, PO, Project Costing, Contract, Billing, Receivable). Interacted with customers to gather requirements for the implementation of pricing module.
• Created Business Requirement Documents (BRD) and Application Understanding Document (AUD) for all implemented financial modules. Prepared and maintained project plan, scope and requirement documents.
• Analyzed all functional requirements and translated into functional fits and gaps. Grouped fits and gaps logically for design and implementation. Detailed legacy application conversion planning and data mapping to PeopleSoft Products/Applications.
• Created detailed test scripts for Functional Unit Testing and System Testing. Worked on the integration and customization of fund price modules and PeopleSoft Account payable. Worked on several enhancements, including rapid data entry/express pages.
• Worked on performance tuning of SQL and the on-line application. Developed the security matrix module in the PeopleSoft application. Planned and executed Integration testing.
• Worked closely with users and testers during UAT and helped resolve issues by giving detailed explanations of the problems and methods of remediation. Responsible for monitoring market share price (equity and floating price) on pricing model.
• Prepared migration documentation and coordinated migration to production with DBA, System Support group, Security and users. Set all the chart of accounts maintenance into the PeopleSoft 8.9 Financial System globally.
• DesignedAP Voucher approval workflow.
• Created, modified, maintained general ledger numbers, department numbers, business units, cost codes. Implemented procedures for PeopleSoft maintenance within the General Ledger module.

Environment: PeopleSoft FSCM9.0, PeopleTools 8.51, Oracle 9i.

Confidential

Technical Consultant, PeopleSoft FSCM 9.0, Oracle 10g

Responsibilities:

• Analyzed PeopleSoft delivered functionality of PS-9 for Project and Contract module, and performed a fit/gap based on the client's requirements. Grouped fits and gaps logically for design.
• Created business requirement, functional solution specifications and design documents for all implemented modules and for identified new functionality, modifications and gaps. Involved in successful end-to-end implementation of PeopleSoft Contract and Project Costing modules.
• Prepared impact analysis documentation for all customizations in PeopleSoft system. Successfully loaded bundle and patches, for Contract module, on the server. Efficiently utilized previously developed work in design for the latter phase.
• Assisted functional lead with overall test planning and created detailed scripts for Functional Unit Testing and System Testing. Executed scripts for Functional Unit Testing and System Testing. Documented and managed defects related to the testing of designed solutions.
• Appropriately retrofitted customizations, wherever presented as a collision between customized objects and ones delivered in the bundles. Developed workflow and an additional information page in the Contract module.
• Created interface in-between contract and Quote module, so that the user can create contracts through the Quote model.
• Created Several XML and SQR reports, such as Contract month wise invoice calculation report, Project master report, Quarter wise invoice report, Event Details report, Event Based FP contract report, Active Project valid contract Report, Non-Event FP contract report, Project Details Report, Active Project Valid contract report, IDU Wise PMO Details report, Non Event Fixed price CA report, Project contract linking report, Team details reports.
• Carefully managed the client's expectations and met milestone dates for successful implementation of the project.
• Execute tests for create journals; approve journals,payment processing, posting payments etc in General ledger module.

Environment: PeopleSoft FSCM9.0, PeopleTools 8.51, Oracle 9i.

Confidential

Technical Consultant

Responsibilities:

• Provided application technical support for implementation of new functionality, development of user requested modifications to the system, coordinating updates from PeopleSoft support, and user .
• Engaged in extensive fit/gap analysis and business process discovery.
• Used App Designer to modify the existing records and created some new Records, Pages and Menus based on the functional specifications. Developed an SQR program to generate an electronic statement of monthly bank statements.
• Designed application Engine program to get finance data into HRMS system for employee salary calculation. Customized the Peoplecode for semi manual reconciliation. Worked extensively on SQR in leave system; generated reports based on the functional specification.
• Developed SQR reports for reconciliation data. Set up PeopleSoft out of the box cash management module for reconciliation of AP and AR data. In order to get GL data in the system created an application engine program to get GL data in to application table for reconciliation.
• Developed interfaces using File layout and Application Engine program and converted the data from legacy system to PeopleSoft database, using CSV files. Designed the Run control pages for run the interface .
• Performed Unit and Integration testing of General Ledger module and resolved issues. Executed performance tuning after migration. Provided guidance and help to the offshore development team in creating test cases for separate financial modules and overall financial integration testing.
• Documented instructions on developed processes for the Help Desk support and provided technical consultation for Help Desk staff.

Environment: PeopleSoft FSCM8.8, PeopleTools 8.51, Oracle 9i.

Confidential

PeopleSoft Developer

Responsibilities:

• Technical duties included developing/implementing technical requirements using PeopleSoft Tools 8.48, these tools include Application Designer, Peoplecode, CI, Work Flow, SQL, SQR, Crystal reports, Interfaces (inbound and outbound).
• Used Change Assistant to apply bundles and maintenance packs to the application. Created bolt-on tools and applications for reporting and data consolidation. Involved in documentation of test scripts and executing functional unit testing, system testing and data conversion validation testing.
• Upgraded and retrofitted custom software into a PeopleSoft 8.8 environment, coordinating custom development objects and the tuning, optimizing and streaming the online component of the application.
• Used Upgrade Assistant to automate upgrade tasks and to keep track of the begin/end time to run a process.
• Handled bundles and patches to resolve issues and upgrade the application.
• Ran release scripts to upgrade the PeopleTools.
• Ran Upgrade Scripts & Process using Upgrade Assistant/manager Tool.
• Ran Upgrade Compare Reports between Demo database and Copy to Dev instance.
• Coordinated upgrade of PeopleSoft from 8.0 to 8.8 for supply chain management.
• Documented and managed defects and issues related to the testing of designed solutions.
• Developed and deployed enhancements to the Inventory Module and Implemented Purchasing Processes.
• Designed and mapped data for a conversion program which reads the data from a flat file and writes it into a file so that Journal load program (GLS9002) will read that data and insert into Journal Tables.
• Troubleshot Journal Generator process for ‘missing Inter-Unit Accounting Lines', ‘Unbalanced Journal Entries', 'subscript out-of range' errors. Created and executed Test Scripts for unit testing in GL for testing ‘Journal Entry', ‘Open a Period', ‘Close a Period', etc. Functionality.
• Developed various PeopleSoft queries in order to help the client day-to-day activity.
• Conducted meetings with the users and the testing team to identify issues and helped to identify the proper solutions for their requirements. Utilized various scheduling tools such as Control M(jobs).
• Reviewed all custom batch processes such as SQR, AE, COBOL and prepared documentation for all nVision re-mapping.

Environment: PeopleSoft FSCM8.8, PeopleTools 8.51, Oracle 8.

Confidential, CA

PeopleSoft Developer, PeopleSoft Finance 8.8, DB2

Responsibilities:

• Detailed legacy application conversion planning and data mapping to PeopleSoft Products/Applications. Designed customized Faculty management applications and an accreditation tracking and academic resume building process.
• Designed detailed functional solution specifications for logically grouped requirements.
• Technical duties included developing/implementing technical requirements using PeopleSoft Tools 8.48, these tools include Application Designer, Peoplecode, CI, Work Flow, SQL, SQR, Crystal reports, Interfaces (inbound and outbound).
• Used Change Assistant to apply bundles and maintenance packs to the application. Created bolt-on tools and applications for reporting and data consolidation. Involved in documentation of test scripts and executing functional unit testing, system testing and data conversion validation testing.
• Worked on several Application Engines, SQR's and Peoplecode changes based on the client's requirements. Wrote batch scripts using UNIX Scripting and created Control-M jobs. Created several reports using SQR and PS Query.
• Developed interfaces using File layout and Application Engine program and converted the data from legacy system to PeopleSoft database, using flat files. Designed the Run control pages for running reports; these run control pages are added in report menu bar.
• Analyzed the functionality delivered in the Bundles with the impacted objects, and created conclusion reports for the Keep or Drop of the customization decisions.
• Designed and mapped data for a conversion program which reads the data from a flat file and writes it into a file so that Journal load program (GLS9002) will read that data and insert into Journal Tables.
• Troubleshot Journal Generator process for ‘missing Inter-Unit Accounting Lines', ‘Unbalanced Journal Entries', 'subscript out-of range' errors. Created and executed Test Scripts for unit testing in GL for testing ‘Journal Entry', ‘Open a Period', ‘Close a Period', etc. functionality.
• Setup Banks for Accounts Payable. Involved in setup of Sales and Use Tax defaults and options. Setup Payment Timing codes, Single and Multiple Pay Terms. Established Vendors, Vendor Locations and Vendor Pay Group Codes.
• Troubleshot POP0005 process to identify and resolve issues like inconsistent printing of ‘Vendor Part numbers'. Integrated Expenses with GL to post liabilities, payments etc. Executed Test Scripts for unit testing PO functionality like ‘Requisition Loader', ‘Purge Requisition Load Request', etc.

Environment: PeopleSoft FSCM8.4, PeopleTools 8.51, Oracle 8.8