Mahesh
Mobile: 813-***-****
Email: ************@*****.***
PROFESSIONAL SUMMARY
Over 7 years of experience in Implementation and Upgrade of PeopleSoft Financials & Supply chain Management.
Extensive experience in Upgrade, Support, Customization and Implementation of PeopleSoft Financials/SCM (General Ledger, Account Receivables, Account Payables, Project Costing, Contracts, Billing and Purchasing).
Experience on the Analysis (Fit-Gap), Design and Development of PeopleSoft Financials.
Expertise in PeopleSoft Development tools (Application Designer, Application Engine, Data Mover), Integration tools (Web Services, Component Interface, Business Interlink, Workflow), Administration tools (Upgrade Assistant, Security, Tree Manager), and Reporting tools (PS Query, nVision, Crystal Reports & XML/BI Publisher).
Worked in a variety of engagements involving all phases of SDLC such as system study, analysis, design, development, testing and implementation.
Hands on experience in Integrating PS applications with other PS applications as well as 3rd party vendors.
Experience in Database -SQL Server, Oracle, SQL Base, MS-Access.
Expert knowledge in applying fixes & patches, performing upgrade tasks, developing interfaces and converting & migrating data.
Experience with Data mapping and Conversion of data from legacy systems to PeopleSoft system.
Served as the key point of contact/Liaison between on and offshore resources.
Positive attitude and superior work ethics combined with excellent communication, interpersonal skills and fast learning capabilities.
Excellent logical, analytical, presentation and time management skills and self-learning attitude.
SKILLS:
Applications
PeopleSoft Financials (9.2, 9.1, 9.0, 8.9, 8.8) (General Ledger, Accounts Payable, Purchasing, Account Receivables, Billing, Project Costing and Contracts.
People Tools
Application Designer, People Code, Application Engine, Application Packages, Approval Framework and Portal technology.
Reporting Tools
Crystal Reports, PS Query, XML Publisher, PS/nVision.
Administration Tools
PS Security, Object Security, People Tools utilities and Upgrade Assistant.
Integration Tools
Component Interface, EDI Manager, Message Agent, Database Agent
Operating Systems
WindowsNT, Windows 2000 Server, Unix (Solaris), NovellNetware3.12 and Linux 7.1
WORK EXPERIENCE
PeopleSoft Techno/Functional Consultant
Verizon –NJ - Feb 2015 to Present
Upgrade of the PeopleSoft Financials (Account Payables, Account Receivables, General Ledger, Billing and PeopleSoft Projects) modules based on organizational needs and requirements.
Developed and customized run control panels, components, menus and records using People Tools – Application Designer, for aging reports, adding reports by payment, Asset Accounting entries.
Involved in trouble shooting and fixing problems at development, System Testing and post-production stages.
Used Application Engine to run batch processes & handled the application messaging system.
Created the setup pages to configure the Vendor Details and Chart fields based on the GL Business Units.
Developed custom reports, utilized formulas setup parameters, created sub-reports and exported report using Crystal Reports to assist the Accounting Users.
Created the setup pages to configure the Vendor Details and Chart fields based on the GL Business Units.
Developed a Matching Process to match the Shipping Details with the Invoices and to generate Invoice Files which are sent to AP.
Customized the voucher online entry pages using Application designer and wrote the PeopleCode to modify the document sequence numbering in Payables.
Ran the Custom Journal Generator process to format and distribute journals to GL in PeopleSoft Purchasing and Payables modules.
Implemented Mobile Approvals - Purchase Order and Requisitions for the Executives to approve Purchase Orders and Requisitions on the go.
Configured the Business Units (AP, PO) for the Wire lined Business.
Designed the PO and Requisition Approval Workflow Process.
Configured the Master Contracts for selected vendors.
Developed PO Online Processing Enhancement. Modified the process and components to accommodate the client's customization.
Developed Data Migration Programs to Load data from 8.4 system to 9.1 system.
Environment: PeopleSoft Financials 9.2, PeopleTools 8.53, Crystal Reports, PS Query, PS Security, People Code, Oracle 11g, Windows 2003
PeopleSoft Financials Techno Functional Consultant
USAA- Dallas, TX - January 2014 to February 2015
Project: PeopleSoft Financials Upgrade 9.0 to 9.2
Involved in Table Analysis, Retrofit, Fit-Gap analysis and Enhancements.
Existing customizations in 9.0 are analyzed and the changes required for 9.2 are documented.
Compare reports are analyzed to determine objects to carry forward during the upgrade effort.
Retrofitted both online and batch objects, (i.e., pages, fields/records, modified and People Code) through patch application and/or application development.
Implemented online and batch customizations in AP, GL, PO and Expenses modules as per user requirements.
Configured Bank Accounts for reconciliation of payments in the AP system.
Analyzed the existing business process in AP and rewrote the Payment archiving AE process to select the right payments for archiving.
Involved in the documentation of several processes like Return to Vendor etc.
Retrofitted PeopleSoft delivered App engine programs to add custom fields to various sections in payables modules.
Retrofitted code to change the Vendor Bank information even though there are ACH vouchers waiting to be paid.
Created custom approval process using Application Workflow Engine (AWE) for the Order Management.
Created custom process for tracking items using Application Workflow Engine (AWE) for Inventory.
Design and developed Requisition status page which displays all the requisition details as well as its corresponding PO details and receiving details.
Developed and tested a Purchasing report which is scheduled to run monthly to show amounts invoiced against PO.
Involved in debugging Application Engine programs and People Code using People Code Debugger.
Worked with the functional team in developing test plans and scripts for AP, and Purchasing for Unit Testing each module and Integration Testing for Transaction flow and Data flow.
Used Application Engine and File Layouts in developing conversion programs to load data into PeopleSoft tables from files and legacy systems.
Environment: PeopleSoft Finance 9.2/9.0, People Tools 8.54/8.49, Windows 7, XMLP, Crystal reports, Oracle.
PeopleSoft Technical Consultant
Thomson Reuters West Legal Ed center, Eagan, MN
Aug 2012 – Dec 2013
Modified (AR_DUNNING) Application Engine in Receivables, to create report of all accounts for which the customers are past due and send them to Collection Processing.
Create the application engine process to calculate the Monthly and Daily financial Charge for customer based on their Financial terms and create the item Activity entries for those financial charges.
Developed Conversion Strategy, designed documents, File Layouts, Data Mapping and Conversion Programs (Vendors, GL Chart fields, Balances, Projects, Project Activities, Grants, CFDA, Assets, AR Pending Items and Customer Contracts) for Financials using Application Engine and Component Interfaces.
Modified Customer statements crystal report in Accounts receivable to include additional discount for qualifying customers. .
Applied patches and bundles in Purchasing, Inventory modules, to bring the existing version to the current level of patches.
Developed the Customer Service message to create the customer from third party system to PeopleSoft and send the Customer information back to third party using the web services BIZTALK and XML message.
Environment: PeopleSoft Financial/SCM 9.1 (AP, GL, PO, AR, BI, BizTalk, Crystal Report, nVision, Oracle 11, People Tools 8.52, XML Publisher.
Peoplesoft Technical Consultant
Bank of Baroda, Gujarat, India
April 2010 to July 2012
Developed various objects using App Designer as required per the enhancements.
Developed various SQR Reports i.e. PO Activity report, PO Accrual Report, FORM 26, VAT Details etc.
Developed Crystal Reports i.e. Voucher Journal Print, Journals not posted, AP/GL transaction details.
Developed various PS Queries & XML Publisher reports.
Developed Multi Language Pages to support Spanish/English language.
Developed Crystals for Spanish/Japanese Language.
Developed custom components to calculate Vendor Balance as of Date functionality, Restrict Employee Vendors details, Inactivate PO Origin Codes functionality and other functionalities.
Configured & tested ExcelToCI utility Interface to upload the Vendor details and Invoices to PS System.
Implemented auditing for Vendor Master Records for significant fields and developed formatted report to ease to read the audit information.
Responsible for Unit Testing & prepared Unit test scripts.
Involved in discussions/status meetings with Client.
PeopleSoft FSCM Technical Consultant/Production Support
Tata Consultancy Services - Hyderabad, India.
August 2008 to March 2010
Technical design document preparation, Coding, Testing and resolving technical issues.
Developed Debt summary Report with Application engine and the crystal report.
Worked on the Billing report to populate the Sponsor ID on the required Crystals, which involved changing the Query, People Code and using an unused field in the delivered record.
Modified Crystal Reports, Queries, and Application Engine and SQR programs depending upon the Change Control.
Worked on the Security by creating new Permission lists, Roles to the users.
Worked closely with functional users in resolving issues during configuration and functional testing.
Developed custom Approval Workflow engine using Application Package for Contract Approval process which includes setups.
Tracing and Debugging of People Code, App Engines and SQR's to resolve issues in production.
Responsible for generating the Standard Reports in various forms by using SQR and Queries formatting in Crystal Reports for different requirements of the organization and setting up these reports in Processing Scheduler to run and print them in a specific time.
Rendered support for the Custom Application in UAT, System Test.
Documented test scripts and executed them with the users for User Acceptance Test.
Coordinated and participated in code walkthroughs as directed by technical manager.
Prepared for and attended weekly/operations status meetings with technical staff and management.
Environment: PeopleSoft 8.9/9.1(AP, AR, BI, PO, GL, AM, PC) People Tools 8.48/8.52, Application Designer, Integration Broker, Application Engine, People code, Query Manager, Crystal, UNIX, Oracle.