We provide IT Staff Augmentation Services!

Peoplesoft Lead Techno-functional Consultant Resume

5.00/5 (Submit Your Rating)

Folsom, CA

SUMMARY

  • Over ELEVEN years of experience as a PeopleSoft Financial FSCM 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 training 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, 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
  • Defined and executed rigorous test plans for unit, system integration and user acceptance testing.
  • 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.
  • In-depth project management experience involving communication with stakeholders to provide accurate reporting and information regarding ongoing projects and initiatives. Excellent oral/written communication and presentation skills.
  • 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 (minute Of Meeting), Weekly & monthly report, User Manual and many more documents and Deployment 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.
  • Includes client business process analysis and re-engineering, configuring applications, leading fit and gap product review sessions, creating business requirements, writing detailed specifications, development of change management procedures and policies, creating and maintaining project plans, facilitating meetings with user and management communities for requirement fathering, production support, maintenance management, incident/issue tracking, writing test scripts, troubleshooting, Ad-Hoc client reporting (SQL, PS Query, Crystal, SQR, Business Objects).
  • 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

Technical skills: Include proficiency in PeopleSoft versions (7.x, 8.3, 8.4, 8.8, 8.9, 9.0, 9.1, 9.2), development with advance PeopleTools (Peoplecode, Application Package, Application Engine, Panel/Page Design, XML, Data Mover, Business Process Designer, Component Interfacing, Application messaging, Process Scheduler, Mass Change, Query Tools, Portal, Excel To CI, Workflow, Security Configuration), assisting in application upgrades (Change Assistant & Upgrade Assistant services).

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, and 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.

PROFESSIONAL EXPERIENCE

Confidential, Folsom, CA

PeopleSoft Lead Techno-Functional Consultant

Responsibilities:

  • Developed Application Engines program from Scratch and Peoplecode changes based on the client's requirements. Wrote batch scripts using UNIX Scripting and created Interface Control jobs.
  • Developed AP interfaces (Voucher staging and edit) 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).
  • Wrote Queries like AP Vendor Total Payments Query, Purchase Order Accounting Review Query, Total Vouchers and Payments Query etc.
  • 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.
  • Analyzed PeopleSoft delivered functionality of PS-9.1 for Project costing and Contract module, and performed a fit/gap based on the client's requirements. Grouped fits and gaps logically for design.
  • 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.
  • 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.
  • Create and execute various test scripts as per test plans and execute them in different environments for AP inbound 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

Lead Techno - Functional Consultant

Responsibilities:

  • Involves in Resolving day-to-day Production Tickets in PeopleSoft FSCM system. Configure Account Payable System (Pay cycle), Pay cycle processing eProcurement, Purchasing, EDI process and notifications for the PO.
  • 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) 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.
  • Debugged AP PSTPYMT and AP PSTVCHR for issues in payments and voucher posting.
  • Perform customizations on delivered business process and work on new enhancements using People Code, AE, CI, and SQR, UNIX shell script and Web services.
  • Creates new 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

Lead Functional Consultant

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, Philadelphia

Lead Functional 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 training 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 Confidential (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). 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.

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

Confidential

Senior Functional 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.
  • Designed AP 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

Functional Consultant

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

Functional 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 training.
  • 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 AP 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 (Telematics 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

Functional Consultant

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.
  • Scheduled reports through process scheduler to run on a daily, semi-monthly and monthly basis. Responsible for debugging issues by reviewing application flow and trace. Involved in design and development of new pages to receive user feedback and complaints.
  • Developed the new pages and records, Components, Menus and modified the existing Peoplecode based on the specific needs of the client.
  • 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.
  • Defined new GL Business Units, defined Journal Options, Approval options, and currency options for each new GL Business Unit. Setup Locations, Schedules and Time Spans control tables. Created User Training documentation for the Journal Upload Process.
  • Participated in designing and implementation of Online Journal Entry Template and validation checks for online journal entries.

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

We'd love your feedback!