We provide IT Staff Augmentation Services!

Peoplesoft Technical Developer Resume

5.00/5 (Submit Your Rating)

Columbus, OH

SUMMARY

  • Over 10 years experience in Information Technology that included gathering Business/User Requirements, Systems Analysis, Systems Design, Development, Deployment, Integration, Data Conversion, Training and Support of a variety of Client Server and ERP applications. 7 years of PeopleSoft Financials/SCM experience in wide range of modules Accounts Payable, Purchasing, Accounts Receivable, Project Costing, Billing and General Ledger, Asset Management, Expenses, Treasury Management (Banking, Cash Management), Commitment Control, Order Management and Inventory on both UNIX and Windows NT platforms.
  • Strong PeopleSoft technical skills include PeopleTools (Application Designer, PeopleCode, Application Engine, Component Interface, Process Scheduler, Query, Data Mover, Security Administrator, and Definition Security), SQR (Inbound and Outbound Interfaces), and Crystal Reports.
  • Worked on nVision custom reports.
  • Worked extensively on nVision reporting tools in different modules of Finance.
  • Experience facilitating work sessions and gathering requirements.
  • Give training to teh team on XML publisher, Crystal reporting tools.
  • Participated in all phases of ERP life cycle like Implementation, Customization, Development, Production Support and Upgrade. Applied PeopleSoft Patches, Bundles.
  • Performed extensive debugging and performance tuning of various processes. Well versed in utilizing tools and utilities PC Debugger, Application Engine trace for troubleshooting.
  • Coding experience in teh Order - to-Cash and Projects & Contracts module,
  • Strong database skills include data modeling, database design, Oracle server-side programming in PL/SQL and Oracle database administration.
  • Knowledge of previous versions of Business Objects XI 3.1, including WEBI reports, Crystal 2008 and Xcelsius 2008 and Universe Design.
  • Knowledge on PIA such as app server configuration, PIA, Process Scheduler, web server, Tuxedo & Jolt.
  • Reports development in inventory module
  • Knowledge of Unit Testing and System Integration testing of applicable changes based on teh requirements or applications defects
  • Experience wif troubleshooting and performance tuning of processes using debugging Tools and utilities such as PC Debugger, AE Trace, Cobol Trace, SQL Plan, Indexing and TKPROF.
  • Experience wif Extreme/Agile Project Management Practices.
  • Detail-oriented, multi-tasker wif strong organizational skills.

TECHNICAL SKILLS

ERP: PS Financials/SCM 9.1/9.0/8.9/8.8/8.4/8/7x - GL, AR, AP, BI, EX, AM, PO, OM, INV, ePRO

PeopleTools: PeopleTools 8.5/8.4x/8.0/7x - Application Designer, Workflow, Application Engine, PeopleCode, Component Interfaces, File Layout, PS Query, Upgrade Assistant, Data Mover, Object Security, Process Scheduler, Business Interlink, Integration Broker, Message Agent, Portals, Import Manager, Security Administrator and PIA.

Reporting Tools: SQR 8.49/6.0/4.x/3.x, Crystal Reports 10/8.5/8.0/6.0, PS/nVision.

Programming: SQR, PeopleCode, SQL, PL/SQL, C, C++, Visual Basic 6.0, HTML 4.0.

Database: Oracle 10g/9i/8i/8.0, MS SQL Server 2005/2000/8.0, DB2, MS Access 7.0, Data Modeling Oracle Designer 2000, Developer 2000, Forms 6i, Reports 6i, Quest TOAD.

Testing Tools: Mercury tools (Test Director, Load Runner), IBM Rational Tools, Quest Stat

Web& Application Servers: Tuxedo 6.5, Jolt 1.2

Others: MS Office (Word, Access, EXCEL, Power Point), Microsoft Project, Lotus Notes.

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Environment: Peoplesoft FIN/SCM 9.1, PeopleTools 8.49/8.50/8.52, AP, AR, BI, Oracle 11g

Peoplesoft Technical Developer

Responsibilities:

  • Worked extensively in teh Development, Testing, Troubleshooting and customization of various Peoplesoft Objects and Processes.
  • Involved in teh process of upgrade from PeopleSoft 8.9 to PeopleSoft 9.2 using Upgrade Assistant, Data Mover. Ran numerous *.dms scripts using Data Mover.
  • Designed and developed teh Application Engine process to load teh data from 8.9 to 9.2 using People code and sql.
  • Worked on online application retrofit customizations on 9.2.
  • Worked extensively in teh Development, Testing, Troubleshooting and customization of various Peoplesoft Objects and Processes.
  • Extensively involved in troubleshooting various issues related to AP, AR, BI,ePro,and Manufacturing.
  • Created new Reconciliation Rules to force Reconcile all teh AR transactions.
  • Designed and developed an interface program to load Cash Position Data from external systems to Peoplesoft.
  • Developed Queries and provided training on Query Manager tool to teh users and developers.
  • Worked extensively on reports development and query development in GL finance module
  • Worked on 100+ SQR reports.
  • Designed and developed bolt-on application which integrates PeopleSoft AP system to Client’s PGTS.
  • Designed and developed an outbound interface program which creates flat file wif 1099 information.
  • Involved in setting up teh Application messaging to synchronize teh User Profiles in HR and Financials.

Confidential, Omaha, NE

Environment: Peoplesoft FIN/SCM 9.1, PeopleTools 8.49/8.50/8.52, Peoplesoft Treasury (Cash Management),ePro, Project and Contract module, AP, AR, BI, Banking, Expenses, Integration Broker, Oracle 11g and UNIX

Peoplesoft Technical Developer

Responsibilities:

  • Worked extensively in teh Development, Testing, Troubleshooting and customization of various Peoplesoft Processes.
  • Customized Application Package TR FORMAT as per teh requirements.
  • Customized Application Engines Processes Treasury Statement Accounting (TR STMTACCTG), Automated Accounting (TR ACCTG) as per teh requirements.
  • Involved in Configuring Integration Broker to automate teh process of loading Payroll data into teh Bank External Transaction Tables.
  • Troubleshooted issues related to AP Cash Clearing Process (AP APCSHCLR).
  • Worked on AP Split pay customization and enhancement.
  • Worked on AP Paycycle due date processing.
  • Created new Reconciliation Rules to force Reconcile all teh AR transactions.
  • Designed and developed an interface program to load Cash Position Data from external systems to Peoplesoft.
  • Developed Queries and provided training on Query Manager tool to teh users and developers.
  • Worked extensively on reports development and query development in GL finance module
  • Give training to teh team on XML publisher, Crystal reporting tools.
  • Coordinated implementation, Production Support and Customization of General Ledger, Purchasing and Accounts Payable modules and reports.
  • Developed a custom Application Engine process for Data Clean up in all teh tables related to teh modules BI, AR, AP and TR.
  • Worked on Expenses customization.
  • Done customization and reporting on Travel and expense and Asset Management modules.
  • Created Position Trees for Cash Management
  • Worked on 50+crystal reports
  • Worked on nVision custom reports.
  • Created Expenses Report, Mismatch, Detail Expenses, AP Paycheck and other Reports
  • Customizations on nVision (Both low level customizations and form scratch.Setting up of General Ledger to implement teh Journal processing,utilization of ledger etc)
  • Creation of Reporting intermediaries like Trees for report generation. Setting up of General Ledger to implement teh Journal processing, utilization of ledgers etc
  • Reports development in inventory module
  • Worked on Order-to-Cash module.
  • Involved in setting up teh Enterprise Integration Points for integrating Projects and Contract modules.
  • Worked on developed and supported multiple SQR reporting in financial AP, AR, and GL module.
  • Gave training to other developers and reporters PS Query Manager Tool.
  • Worked on applying bundles to upgrade PeopleSoft application from 8.9 to 9.1
  • Worked on Tools upgrade from 8.49 to 8.52
  • Knowledge of Unit Testing and System Integration testing of applicable changes based on teh requirements or applications defects

Confidential, Bellevue,NE

Environment: Peoplesoft FIN/SCM 9.1, PeopleTools 8.49, AP, GL, AR, BI, Integration Broker, Oracle 11g and UNIX

Peoplesoft Technical Developer

Responsibilities:

  • Implementation, Design, Development, Production support and troubleshooting various production issues on day-to-day basis. Worked on various enhancements based on business requirements in PeopleSoft Financial modules.
  • Coordinated implementation, Production Support and Customization of General Ledger, Purchasing and Accounts Payable modules and reports. Coding Activity for Customers, Suppliers, General Ledger Accounts, Troubleshoot and performance tuning of Chartfield Configuration process (AE FS CFCONFIG)
  • Developed GL interface that loads data from various external systems into PeopleSoft General Ledger using SQR, which includes implementing complex business rules like combo rules, Subtotals on Business Unit Level, grand totals, Error Handling Procedures, Printing Multiple output Reports (Maintenance and Input File Information) using various SQR functions, Arrays, Trees, Views, Load Lookup & SQC handles various Invalid Chartfield Combinations.
  • Calculation and troubleshooting various issues wif Paycycle Manager, Payment posting, performance tuning of various process like AR Update, Payment Posting, COMBO EDIT, Chatfield configuration, Journal Generator and Invoice Print Process.
  • Developed new reports using crystal and SQR for Bills of material, Sales summary and comparison, Inventory planning, Outstanding Purchase Order quantities, two dimensional variance analysis, three ways price matching, Invoice/Voucher details summarized by chartfield vales, Cycle count and Backlog service orders.
  • An Application Engine program was developed to reset pre configured user run controls. dis program is scheduled to run during batch window at night. At dis time any user initiated processes will be cancelled if its run control is being refreshed. dis program takes run control template name, run control table name, target role of users and source user wif template runcontrol as input paramaters. dis involved using metaSQL to dynamically generate SQL statements.
  • Designed and developed various conversion and interface programs using Application Engine, File Layout, Component Interface and SQR like GL Interface, AM conversion, Vendors, Customers, AR Open Item Balances, etc
  • In AR Customized reports like Ageing (detail & summary), Dunning Letters, Customer Statement and Finance Charge Invoice.
  • Customized pages and written PeopleCode validations.
  • Designed and developed new Application Engine processes and modified existing ones.
  • Designed and developed a custom page to simplify entry and maintenance of purchase orders.
  • Modified PO Dispatch process to meet custom requirements.
  • Resolved many issues logged during system test and Production.
  • Created queries for data verification purposes.
  • Fixed and Modified various SQR’s to implement new changes like changes in record definitions in teh new version of PeopleSoft which in resulted invalid fields (Fields which are no longer used in teh new version of PeopleSoft), adding new records and changing teh SQL in teh Reports and views to improve performance.
  • Worked on AP Split pay customization and enhancement.
  • Developed Queries and provided training on Query Manager tool to teh users and developers.
  • Worked extensively on reports development and query development in GL finance module
  • Coordinated implementation, Production Support and Customization of General Ledger, Purchasing and Accounts Payable modules and reports.
  • Worked on 50+crystal reports
  • Worked on developed and supported multiple SQR reporting in financial AP, AR, and GL module.

Confidential, Erlanger, KY

Environment: Peoplesoft Financial/SCM 9.0/8.8, PeopleSoft Manufacturing 7.5, PeopleTools 8.49, 8.48, 7.54 PeopleSoft PO, OM, INV, BI, AP, EX, CM,ePro, HRMS, nVision, Integration Broker, DB2 and UNIX

Peoplesoft Techno-Functional Consultant

Responsibilities:

  • Worked extensively in teh Development, Testing, Troubleshooting and customization of various Peoplesoft Objects and Processes.
  • Extensively involved in troubleshooting various issues related to AP, EX, PO, BI, OM,ePro, INV and Manufacturing.
  • Worked extensively on nVision reporting tools in different modules of Finance.
  • Involved in setting up new customers.
  • Designed new EDI maps to load new order data into peoplesoft from teh files as per teh requirements using Integration Broker XML. Also resolved issues related to both inbound and outbound EDI maps.
  • Designed and Developed Expensesworkflow for department routing using teh Approval Workflow Engine.
  • Reports development in inventory module.
  • Done customization and reporting on Travel and expense and Asset Management modules.
  • Troubleshooted issues related to Load Order processes, EOP PUBLISHF Application Engine process and Order Completion Process.
  • Modified teh Electronic Commerce Process to process more than one forecast order at a time. Also resolved issues related to Electronic Commerce Process.
  • Resolved issues wif PO Requisition processes like PO REQLOAD, PO REQSRC
  • Resolved issues related to teh PO Dispatch process, PO Calculation and PO Creation processes.
  • Developed new Mass changes definitions and also resolved issues wif teh mass change.
  • Resolved issues wif Billing interface process BIIF001 Application Engine process.
  • Resolved issues wif various processes like MARK LINES FOR BILLING (OMMARKLN), OM BILL PROCESS (OMBILL) and Invoice Creation Process.
  • Customized Invoice process to generate teh Invoices in a specific format as a requirement for Customs.
  • Configured and customized teh delivered EIP using Integration Broker (by using nodes, messages, Services, Service Operations, App Messaging) to dispatch teh PO in XML Format to teh suppliers.
  • Worked on integration of vendor voucher EIP (enterprise integration point) between HRMS and financials.
  • Involved in setting up teh EIP (Enterprise Integration Points) for integrating Projects and Contract modules.
  • Developed Queries and provided training on Query Manager tool to teh users and developers.
  • Worked extensively on reports development and query development in GL finance module
  • Worked on Order-to-Cash module.
  • Worked wif Business Users on various issues on AP processes like Doc Tolerance, Budget Check, Post Vouchers and Payment Posting.
  • Worked on AP Split pay customization and enhancement.
  • Worked on AP Paycycle due date processing.
  • Extensively involved in troubleshooting Pay Cycle Manager issues relating to 1099 vendors.
  • Customized teh application Engine program AP PSTPYMNT to populate teh APPL JRNL ID for teh journal Generator to create journal lines.
  • Built queries for 1099-vendor verification on aspects like total amount, mailing address, wifholding box etc.
  • Modified teh 1099 report to sequentially print teh address in case of missing optional name fields on teh address label. Also modified teh APY1406 open liability query and report to exclude wire transfers.
  • Worked on nVision custom reports.
  • Customizations on nVision (Both low level customizations and form scratch.Setting up of General Ledger to implement teh Journal processing,utilization of ledger etc)
  • Generated nVision Reports using Matrix and Tabular Layouts in GL.
  • Creation of Reporting intermediaries like Trees for report generation. Setting up of General Ledger to implement teh Journal processing, utilization of ledgers etc.
  • As per teh banking requirements, a process was designed to create Positive Payment File.
  • Modified teh AP Vendor Address page peoplecode to resolve teh issue of Phone Type being blanked out when clicking on view all option.
  • Resolved issues wif teh inbound file publish and Publish outbound message utilities that converts data from a flat file to an XML file using teh Peoplesoft format and then writes them to teh message queue and vice versa.
  • Modified various Application Engine and SQR process as per teh requirements of Toyota.
  • Tuned various Application Engine Programs and SQR’s to speed up teh execution of teh process.
  • Designed and developed custom application to automate teh Custom Dunnage Shipping.
  • Designed and developed an interface program to send parts data to PEFF system
  • Designed and developed interface programs to send ASN data from/to Peoplesoft to Mainframes through EDI.
  • Worked closely wif teh user to resolve issues related to FTZ (Foreign trade Zone) process as part ofProcess.
  • Involved in writing shell scripts to transfer files from Peoplesoft to Mainframes and vice versa.
  • Designed and developed a custom process One Way Kanban to automate teh process of packing and shipping using teh same bar code label.
  • Involved in trouble shooting issues related to Customs parts ordering processes for Toyota like parts being ordered on Sunday and issues related to Item setup.
  • Resolved issues related to PLS1000 and PLS2000.
  • Resolved issues wif Redpepper, a tool integrated into PeopleSoft for Necessity Quantity Calculations for teh parts to be ordered.
  • Worked on issues related to BOM setup. Modified teh COPY BOM functionality as per teh requirements of Toyota.
  • Resolved issues wif teh processes after Oracle database upgrade from 8i to 9i.
  • Involved in writing Infopump scripts (sql server scripts) to transfer files, data from one PS environment to other and also to Mainframes.
  • Designed labels using Loftware. Developed code to send data from Peoplesoft to Loftware.
  • Resolved issues wif labels.
  • Involved in setting up Zebra printers which are used for printing Barcode labels.
  • Designed and Developed Archive & Purge process for OM.
  • Modified various SQR’s in Cost Management as per teh requirements.
  • Extensively involved in troubleshooting various issues related to Cost Management.
  • Designed and developed a conversion program to separate teh Investigation and Corrective Actions from teh General Concerns and create it as a separate Custom module.
  • Designed and developed an interface to load NUMMIHRdata into Peoplesoft HR as a requirement for teh Data Integrity for HR.
  • Security Administrator (Create Users, access to pages, permission lists).
  • Also involved in developing Test Plans and Test Cases.
  • Wrote Test plans for testing SQR, Crystal, and nVision Reports, Process Maps and tested them.

Confidential, FL

Environment: Peoplesoft Financials 8.4/8.8, PeopleTools 8.46.16, Peoplesoft AM, AP, PO, Grants, GL, Expenses, Sybase and UNIX

Peoplesoft Technical Developer

Responsibilities:

  • Worked extensively in teh Development, Retrofitting, Testing, Troubleshooting and customization of various Peoplesoft Objects, partly conversion and interface programs.
  • Involved in teh review and analysis of teh compare reports and identified teh customizations necessary for teh upgrade.
  • Used PeopleSoft Upgrade Assistant tool to compare and move different objects between source and a target database wifin PeopleSoft Tools.
  • Ran cross-reference reports DDDAUDIT and SYSAUDIT to compare data structures defined in teh People Tools tables against teh underlying database to uncover inconsistencies.
  • Modified existing customized pages and created new pages.
  • Modified teh People Code in teh various custom field events to reflect teh functionality that earlier existed.
  • Customized GL9002 process which loads journals from a CSV file. Teh program was modified allow teh user to load journals wifout technical assistance.
  • Modified and resolved various issues related to AP Voucher Journal Generate Process, an Application Engine Process in 8.8 to reflect teh functionality that existed earlier (COBOL) in 8.4.
  • Modified existing customized pages and created new pages.
  • Worked extensively on reports development and query development in GL finance module
  • Modified AMIF1000 Transaction Loader Process, an Application Engine in 8.8 to reflect teh functionality that existed earlier (SQR) in 8.4.
  • Involved in retrofitting various COBOL, SQR programs.
  • Created and Modified Records, Record fields, SQL’s, Components, Component Interface, Indexes and Trees for People Tools 8.8 that had been earlier customized for version 8.4
  • Used Tree Manager for Creating Query Trees.
  • Fixed various issues related to Accounts Payable, Requisitions and Purchase Orders.
  • Worked on multiple crystal reports
  • Worked on nVision custom reports.
  • Reports development in inventory module
  • Worked on Order-to-Cash module.
  • Worked on developed and supported multiple SQR reporting in financial AP, AR, and GL module.

Confidential, Miami, FL

Environment: Peoplesoft Financials 8.8, PeopleTools 8.46, Peoplesoft PO, AR, AP, PC, AM Oracle and UNIX

Peoplesoft Techno-Functional Consultant

Responsibilities:

  • Worked extensively in teh Development, Testing, Troubleshooting and customization of various conversion and interface programs.
  • Designed and developed conversion program to load Categories and Items into Peoplesoft from external systems using Application Engine, File Layout and Component interface.
  • Designed and Developed conversion programs using Application Engine, Component Interface and File Layout to load Contracts and Purchase Orders from external systems to Peoplesoft.
  • Designed and developed Interface programs to load Purchase Orders and Contracts to load data into peoplesoft from external systems. Used Application Engine, Component Interface and File Layout.
  • Customized teh Strategic sourcing PDF as per teh requirements. Modified teh Application Engine program AUC EVT PDF which consists of a Component Interface and Application Package.
  • Designed and developed bolt-on application which integrates PeopleSoft AP system to Client’s PGTS.
  • Designed and developed an outbound interface program which creates flat file wif 1099 information.
  • Involved in setting up teh Application messaging to synchronize teh User Profiles in HR and Financials.
  • Involved in setting up teh EIP (Enterprise Integration Points) for integrating Projects and Contract modules.
  • Worked on various AP, PO and AR reports like AP Disbursement by Fund, Unsourced Requisition Lines by Buyer, Monthly/Revenue Cash Report.
  • Extensively involved in troubleshooting various production issues involving workflow and other issues related to Purchase Orders, Requisitions and Receipts.
  • Supported Pay Cycle, Check printing Integration, EFT Payments, EDI Manager, 1099 Processing, Bank Reconciliation in PeopleSoft and Home grown Legacy systems in teh Account Payables .
  • Reports development in inventory module
  • Worked on teh payment interface for Accounts Receivable, an out bound interface which moves data from peoplesoft to teh external system.
  • Debugged AR UPDATE process failures and fixed all kinds of AR UPDATE abends.
  • Designed and developed Interface programs to load Express Assets into PeopleSoft from external systems.
  • Extensively involved in troubleshooting various production issues involving PC and AP like Crystal Check, Pay Cycle Manager, ACH File, Positive Pay File, and Project Budgets
  • Worked extensively on Voucher conversion issues like PO Voucher, Recycle Vouchers, and Over booked Payments
  • Involved in system, integration and regression testing of teh Peoplesoft modules implementation.
  • Customizations on nVision (Both low level customizations and form scratch.Setting up of General Ledger to implement teh Journal processing,utilization of ledger etc)
  • Worked on multiple crystal reports
  • Worked on developed and supported multiple SQR reporting in financial AP, AR, and GL module.

Confidential, Newark, NJ

Environment: Peoplesoft Financials 8.9, PeopleTools 8.46, Peoplesoft PO, AM, AR, AP, Oracle and Windows NT

Peoplesoft Analyst/Developer

Responsibilities:

  • Worked extensively in teh Design, Development, Testing and customization of various conversions programs.
  • Designed and developed an SQR conversion program to load teh asset data from Systems 3000 into Peoplesoft.
  • Designed and developed a conversion program to load teh tables PS LOCATION and PS SHIPTO TBL wif teh data coming from external systems.
  • Designed and developed Item conversion program to load teh Items from external system into Peoplesoft. Used Application Engine and Component Interface to do teh conversion.
  • Customized PeopleCode as per teh requirements.
  • Designed and developed a conversion program using Application Engine, Component Interface and File Layout to load teh Purchase orders from External Systems.
  • Developed SQR interface Program, which loads AR Open Items into PS PENDING ITEMS, PS GROUP CONTROL tables from teh legacy system.
  • Developed an Interface to AR using SQR to automate teh numerous manual credits of open Items each month.
  • Involved in setting up Matching rules for Accounting Payables for making teh voucher match, Configured matching rules for Three-Way Matching for matching teh Vouchers, Purchase Orders and Receivers.
  • Developed Custom Application Engine Program in Accounts Payables, once teh PayCycle Process is run an Email is sent to teh Employees regarding teh Payments are being made to Keep Track of teh Payments Made.
  • Worked on 50+crystal reports
  • Worked on nVision.
  • Worked on developed and supported multiple SQR reporting in financial AP, AR, and GL module.

Confidential, Wilmington, MA

Environment: Peoplesoft Enterprise Portal 8.9, PeopleTools 8.46, MS SQL SERVER and Windows NT

Peoplesoft Portal Developer

Responsibilities:

  • Involved in implementing and administering PeopleSoft Portal security, maintain teh roles, permission lists and user ids, across HRMS applications databases.
  • Involved in setting up of teh Integration gateway and messaging nodes in HR and Portal.
  • Involved in setting up teh Application messaging to synchronize teh User Profiles in HR and Portal (PeopleTools 8.44 and 8.46).
  • Wrote an SQR to create user id and passwords for all teh employees in teh company and store teh data in teh portal security tables.
  • Created new roles, Permission Lists and user ids based on teh location, department, business unit and grade of teh user.
  • Modified teh “Look and Feel” of teh Portal Homepage, Pagelets using Branding Themes and Style sheets.
  • Manage teh Portal navigation import, security synchronizations and content references setup.
  • Configure and setup teh Enterprise Portal Default Local Node and Enterprise Portal URI Text in Your Content Provider Database.

Confidential, Vancouver, WA

Environment: Peoplesoft 8.8, PeopleSoft GL, AP, BI, AR, OM, INV, Oracle, UNIX and Windows NT

Peoplesoft Analyst/Developer

Responsibilities:

  • Worked intensively on Design, Development, Testing, Troubleshooting and Customization of various FIN/SCM reports.
  • Customized and troubleshot various issues wif teh AR payment worksheet page PAYMENT WS IC.
  • Designed and Developed RSM (Regional Sales Manager) Sales Report which gives teh detailed information of all teh sales by a Regional Sales Manager (nVision).
  • Customized and troubleshot PICK PLAN Report (SQR) which gives teh plan on picking various products from various warehouses.
  • Designed and developed AGING REPORT BY SALES PERSON and BY BROKER ID(SQR).
  • Designed and developed OPEN ORDER REPORT. dis report includes all teh orders that have order status of OPEN by considering teh orders that are Reserved, On Hold and Unfulfilled (crystal).
  • Worked in Account payables wif teh Bank Reconciliation process, Created a Custom interface Process to load teh Bank Statement files into PeopleSoft Bank Statement tables, to enable teh Electronic Entry of Bank Reconciliation data to support Automatic Reconciliation of Bank Transactions.
  • Developed teh media billing interface using File Layout, Application Engine and component interface to load data from external bill systems into PeopleSoft Billing.
  • Worked intensively on Design, Development, Testing, Troubleshoot and Customization of various FIN/SCM reports and processes.
  • Designed and developed various conversion and interface programs using Application Engine, File Layout, Component Interface and SQR like GL Interface, AM conversion, Vendors, Customers, AR Open Item Balances, etc
  • In AR Customized reports like Ageing (detail & summary), Dunning Letters, Customer Statement and Finance Charge Invoice.
  • Developed Invoice Printing process as 2 parts - first part as Application Engine program to populate temporary tables wif teh required invoice data extracted from teh large volume billing tables and second part as an SQR program to write teh extracted data to flat files that are ftp'd to a printing facility that prints and mails teh invoices.
  • Designed and developed a master inquiry facility. User can either specify customer ID, or alternately, they can search based on Bank Account information, customer name or address. dis inquiry will display Customer information along wif various bank accounts (MICR) attached to teh customer, pending items, Items, Recent payment history (Applied checks as well as checks that are not applied yet), and information from dis central Inquiry utility. dis inquiry TEMPhas links to peoplesoft delivered Inquiry pages also.
  • Customized pages and written PeopleCode validations.
  • Designed and developed new Application Engine processes and modified existing ones.
  • Designed and developed a custom page to simplify entry and maintenance of purchase orders.
  • Resolved many issues logged during system test and Production.
  • Created queries for data verification purposes.
  • Fixed and Modified various SQR’s to implement new changes like changes in record definitions in teh new version of PeopleSoft which in resulted invalid fields (Fields which are no longer used in teh new version of PeopleSoft), adding new records and changing teh SQL in teh Reports and views to improve performance.
  • Analyzed and aided in taking decisions to retain customizations based on upgrade compare reports.
  • Performed extensive debugging and performance tuning of various processes. Well versed in utilizing tools and utilities provided by PeopleSoft (Debugger, tracing etc) for trouble shooting issues on PeopleCode, Application Engine, COBOL, SQR’s & Online.

We'd love your feedback!