SUMMARY

• Over 10 years of experience in software development, including more than eight years’ experience in supporting, implementing and upgrading the ERP packages.
• Extensive Experience in PeopleSoft Financials (GL, AP, AR, PO, PC, AM and EX) and SCM (OM, Inventory, Billing, Purchasing). PeopleSoft HRMS/HCM (HR, Payroll, Benefits, Time and Labor, TAM and Candidate Gateway)
• Worked Extensively with PeopleTools, Peoplecode, Application Engine, Component Interface, File Layout, PS Query, Oracle, PL/SQL, and SQL Server environment.
• Extensive knowledge in report writing using SQR, BI Publisher and Crystal report 8.0.
• Active on - call
• Worked intensively with Security Administrator to implement security in various levels. Creating Roles, Permission Lists, User Profiles, Portal Security, folders, Content References and Definition Security.
• Operating Systems UNIX, Win NT / 98 / XP, Windows 2000.
• Excellent oral and written communication skills, short learning curve and strong team work spirit with excellent leadership qualities.

TECHNICAL SKILLS

ERP: PeopleSoft Financials, SCM /8.x/9.x (GL, AP, AR, BI, EX, AM, INV, ePro, PO, Budgets, Contracts, PC & Grants).

People Tools: Application Designer, Application Engine, PeopleCode, Component Interface, File Layout, Security Administrator, Process Scheduler, Workflow, App Messaging, PIA and Portal Technology.

Integration Tools: Integration Broker, Component Interface, Application Engine, File Layout.

Data Management Tools: Data Mover, Import Manager, EDI Manager.

Reporting Tools: SQR,PS/Query, Crystal Reports, nVision.

Operating System: UNIX, Windows 95/98/2000/2008/ XP/7/NT.

Languages: SQL, COBOL, PL/SQL, C/C++, and Java.

Web Technologies: HTML, Java Script, VB Script.

Databases: Oracle 8i/9i/10g/11g, SQL Server, DB2, MS Access.

GUI Tools: Visual Basic 6.0, Developer 2000.

Servers: BEA Web Logic 6.1, Tuxedo 6.5, Jolt 1.2.

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Involved in designing the Functional and Technical Specifications according to the business logic of the client. Worked with functional analysts and wrote technical specifications.
• Created eight XML reports using XML Publisher.
• Created an Application Package for XML Publisher based reporting using push button, instead of running it from reporting tools Created Custom Rules by using the user exits thru App Engine Program.
• Rewritten COBOL Process into PeopleSoft Processes using AE Programs to PeopleSoft Financials.
• Involved in Design and Development of conversion programs using AE for transferring data from Legacy system to PeopleSoft Financials.
• Performed extensive debugging and performance tuning of various processes. Well versed in utilizing Debugger, tracing tools for trouble shooting issues on PeopleCode, Application Engine.
• Updated Search View for pages in AP and GENERAL LEDGER based on the roles and permissions as per client needs.
• Developed reports using PS Query and Developed SQL scripts to Query the PeopleSoft tables to check the test results
• Documented all the new customizations and reports created to support new system
• Worked on Grants, Projects and KK at State. Involved various enhancements.
• Extensively worked with Grants Proposal Process to electronically find and apply for competitive grant opportunities.
• Worked on PeopleSoft Grants Proposal Preparation consisting of a statement of work, research plans, technical reports, and a proposal budget, as well as administrative, personnel, and submission information that is required by external funding agencies.
• Trained consultants by showing them how transactions are created and applied to PeopleSoft Grants Awards.
• Involved on structuring PeopleSoft Grants, Projects and enabling users to Grant Roles
• Created report for business users to view budget-checking exceptions by the source transaction for a range of dates.
• Designed and developed Commitment Control budget details report to display the budget details with or without tolerance for project and/ or activities.
• Modified and Created several complex time and labor rules to meet the business requirements.
• Developed several SQL’s on time & labor and Payroll tables for audit processing.
• Customized the Job Code, Job Data and Personal Data Panels in Manage Human Resources and Administer Workforce modules as per the user requirements.
• Fixed PAYCALC related issues which was a bending due to some bad data inserted in PAYLINE.

Environment: PeopleSoft 9.2 FSCM & HCM (AP, BI, AR, Projects, Contracts, GL, Grants, Time & Labor, Payroll), People Tools 8.53, Oracle 11G.

Confidential, Nebraska, NE

PeopleSoft Financials Techno-Functional Consultant

Responsibilities:

• Involved in Design, Development, Testing, and Enhancement of PeopleSoft FSCM for ePro, Purchasing, AP, AR, BI, GL, AM, T&E and Treasury modules.
• Created Components, File Layouts, and Pages, Records, Fields, Process Definitions and registering Components in Portal, Menu and Permission Lists.
• Involved in online changes to the delivered pages, components, menus and translate values.
• Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process.
• Customized Mass Change page to update CAP and Sequence number for all accounting lines in people soft tables.
• Involved in item conversers ion to extract the data from 8.8 via SQR and uploaded data into 9.2 using File Layout App Engine
• Worked on interface programs for migrating data from other systems to People Soft.
• Also involved in acquiring Specifications from the functional team and modifying the SQR’s as per the SPECS.
• Extensively used process scheduler for scheduling recurring process for conditional Scheduling of successive process for setting up the reports to run at specific time and implementation of batch processing.
• Used File Layout Definition to get data from the old version to new people soft tables.
• Active role in changing the SQRs as per the change requests from the users.
• Involved in Unit testing of people soft delivered and modified functionality & customized SQR programs using AR, BI, ePro, Purchasing and AM Modules.
• 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.
• Analyzed user requirements and developed plans for Change Request, New applications and Interfaces Developments using PeopleTools, PeopleCode, SQR, AE, File Layout procedures.
• Identified and documented all customizations and mapped them to functional specifications for the customizations.
• Identified all customized interfaces, reports and queries and prepared design documents to list the impact of the upgrade on these programs and identified parts of the program that needs to be altered.
• Created SQL scripts to update Voucher Line and Distrib Line tables with the Receipts data.
• Configured and set-up billing processes including billing cycles, bill types, bill sources, bill identifiers, distribution codes, billing interface and invoice formats.
• Supported and troubleshot Pending Item Entry, Deposit and Payment application, Dispute Maintenance, Contacts, Custom Statements, Custom Dunning Letters, Conversations and Customized Aged Reporting.
• Mapped bill to- sold to customers, set up accounting entries and identified sales teams
• Designed business logic and application engine program to add Tax authorities and Tax codes and map them to the existing customers.
• Configured Receivable module including entry type, entry reason, group type, item entry type, accumulation rules, account distribution, customer maintenance, collection status codes, collectors, payment processing including Banking, MICR information, payment terms and aging.
• Prepared Technical Documentation based on their format.
• Tested application manually for verifying objects and functionality.
• Customized the online panels for Travel & Expense module as per the Users request. This involves major enhancements to the Expense report panels while picking up attendees for an expense Item.

Environment: PeopleSoft Fin 8.8 / 9.2, People Tools 8.46/8.53, Application designer, People Code, Process Scheduler, PS-Query, SQR, SQL Plus, Application Engine, Oracle 9i, MS Excel, Crystal Reports, Windows NT/2000.

Confidential, Troy, MI

PeopleSoft Financials Techno-Functional Lead Consultant

Responsibilities:

• Involved in Production Support and fixing bugs and problems in Accounts Receivables, Billing and AP.
• Modified Pages, Components for users to enter data and run reports for the AR and Billing modules.
• Involved in Performance testing of Batch Processing jobs.
• Involved in troubleshooting various issues related Lock Box Files and Item Management.
• Involved in AR Worksheet Performance Issue.
• Involved in troubleshooting and fixing bugs and problems in Accounts Payable (pay cycle Process and Bank recon process)
• Involved in user enhancement and maintenance of PeopleSoft Financials (Account Payables, Billing, Receivables) utilizing PeopleTools and PeopleCode.
• Working on other minor enhancements in AR (worksheet) and BI
• Involved in troubleshooting the Expense AWE.
• Developed an Interface using Application Engine and File Layouts to load AMEX Credit Card Transactions into Expenses Module
• Developed Test Strategy, Test Script documentation, Test Plan and Problem/Issue documents for various tests.
• Developed unit test plans for Accounts Receivable and Billing Modules.
• Created Process Definitions for the Application Engine Programs and scheduled them to run through Process Scheduler.
• Created Messages and Message Nodes for integration with 3rd party system.
• Developed new reports for users.
• Worked with BizTalk team on various production issues in loading 3rd Party files into PS.
• Worked on Invoice Printing and troubleshooting all custom invoice Printing for UK, Canada.
• Worked on the payment loader (AR PAYLOAD) and lockbox (AR25001) SQR process
• Worked with DBA’s on resolving performance issues by using explain plans, indexes and stats for fine tuning the SQL’s.
• Third party systems will be sending PeopleSoft invoices in the form of XML Messages and customized Message Peoplecode and populated EC Tables (VCHR HDR QV, VCHR LINE,VCHR DIST QV).
• Worked intensively with Security Administrator to implement security in various levels. Creating Roles, Permission Lists, User Profiles, Portal Security, folders, Content References and Definition Security.
• Remediated customizations for bundles 10 to 20.
• Used STAT 5.6 for migration of PeopleSoft objects between environments.
• Created new PeopleSoft PIA environment, UNIX / NT process scheduler for PeopleTools, created report nodes and setup report repository, compiled COBOL and tested sample processes on UNIX / NT Scheduler and SQR and Crystal reports.
• Involved in performance testing and fine-tuning of the SQR programs.
• Provided production support for HR, Benefits and Payroll applications
• Customized pages for eBenefits to deliver Benefit Enrolment pages, Health Plan pages, Managing
• Insurance Plans an employee can access.

Environment: PeopleSoft 9.1 FSCM & HCM (OM, BI, AR, Projects, Contracts, GL), People Tools 8.51, Oracle 11G.

Confidential, Storrs, CT

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Involved in designing the Functional and Technical Specifications according to the business logic of the client.
• Developed new reports for users using BI Publisher.
• Developed Application Engine programs to load third party data into PS.
• Assisted functional team with trouble-shooting issues and providing resolutions during preliminary testing and build phase
• Created Excel to CI templates to the functional team.
• Prepared functional and technical specifications for the Asset Management which allows NBV (Net Book Value) of the different asset categories being written to a output file.
• Resolved Issues with InterUnit Asset Transfers in Asset Management module
• Involved in the customizations and new development of business functionality using People Code for the GL, AP,PC,AM modules
• Asset Management: Developed AM to GL reconciliation Report
• Project Costing: Modified PC AP TO PC application Engine to avoid duplicate entries in PROJ RESOURCE table for Payments and Payment Cancellation rows
• Involved in the process to capture the vendor ids as apart of the AP/GL interface which populates the Journal Entries to GL module.
• Created HR, Benefits, and Payroll custom interfaces and processes using SQR and Application Engine.
• Involved in setup and design of automated benefits enrollment process, setting up core tables in HR and Benefits Administration, defining eligibility rules and creating event rules.
• Analysed, designed and developed various SQRs like Garnishment reports, General Deductions Report, Termination Report, Absence Report, Fund report, Severance Report, Unemployment Wages Report, New Hires reporting by locations and fund locals, multiple locations worked, Quarter to date Labor hours Report, and employee Benefits report.
• Developed SQR for one time deduction in Payroll.
• Customized Application Engine program to upload Time to Payroll Pay sheets.
• Modified Payroll Check Print report and Direct Deposit Advice Print Report programs as per client's requirement.
• Worked with PeopleSoft to fix bugs and provide enhancements.

Environment: PeopleSoft 9.1(FSCM HCM, TAM, CG), People Tools 8.52, Oracle 11G.

Confidential, Portland, OR

PeopleSoft Financials Techno-Functional Consultant

Responsibilities:

• Involved in designing the Functional and Technical Specifications according to the business logic of the client. Worked with functional analysts and wrote technical specifications.
• Involved in Fit-Gap Analysis, design, development, testing and support for PeopleSoft Financials
• Developed application engine batch process which would invoke component interface for ITEM DEFN component to generate XML and XML is sent to Maximo.
• Performed Performance tuning on various queries and application engine programs.
• Involved in Knowledge Transfer, Documentation, and Presentations to help all the members of the Development team and Users and sharing the knowledge to complete the job successfully.
• Developed custom Interface using People code for validations, Components, Interfaces for Inventory modules.
• Create Requisition Status report to display requisitions approved but not yet sourced to a purchase order; schedule to run daily at 10a and 2p and deliver to Procurement’s point of contact
• Developed various Excel to CI to load data and update data for users.
• Developed Application Engine to Load Items from the flat file into Inventory module.
• Involved in complete Procure-to-Pay process through Purchasing, procurement and Payables.
• Converted the legacy data from Maximo to PeopleSoft.
• Developed conversion programs to load vendors into people soft using Application Engine and component interface.
• Customized PeopleSoft delivered pages in PO and INV using People Code.
• Setting up Application Security and Portal Security by defining User roles and permission lists.
• Involved in migrating the objects between different database environments (DEV, CFG, CNV, & TST).
• Developed custom Archive process for interface Staging tables by application package and Application Engine.
• Setup Excel to CI tool to load Items and Requester Profile and User Preferences.
• Involved in technical support & online support in various stages of development to Production environments.

Environment: PeopleSoft 9.1 (IN, PO, AM, GL), People Tools 8.52, Oracle 11G.

Confidential, Troy, MI

PeopleSoft Financials Techno-Functional Consultant

Responsibilities:

• Involved in Fit-Gap Analysis, design, development, testing and support for PeopleSoft Financials
• Involved in Fit/Gap analysis and identified the existing customizations for upgrade and analysed the required changes for the new release.
• Upgrade the existing run control pages and process which include Extract Agreements App Engine, Create Agreements App Engine, Print Batched Agreements SQR, Review Staged Agreements, Review Print Batches etc.
• The Create Agreements App engine is modified to look for the newly created component interface which loads the OM tables from flat files.
• Implemented the customizations identified in RMA fit gap analysis which include defaulting and greying of fields on RMA header, restricting users to manually enter the RMA Line and must select from the Customer Shipment History in order to populate the RMA Line, RMA Online Entry Modifications to prevent RMA Return quantities greater than the Quantity shipped by providing a warning message etc.
• The Billing RMA Adjustment process (BIRMAADJ) is modified to populate the TARGET INVOICE field on the INTFC BI with LAST MAINT OPRID field on the RMA HEADER.
• The billing processes, BIIVCSTS (Bill Status Change), BIIVC000 (Finalize), BICURCNV (Currency Conversion), BIPRELD (Preload), BILDAR01 (Load AR) and BILDGL01 (Load GL) are upgraded to 9.1 and additional customization which are identified in fit gap analysis have been implemented.
• Upgraded components/pages in the areas of Bill Entry, Bill Inquiry, Bill Adjustments, application engine programs like Billing Interface and Payment Predictor and other SQR programs in BI and AR.
• Developed custom SQR process to accept information from various billing systems to bring in the billing information to AR, thereby populating PS GROUP CONTROL, PS PENDING ITEM and PS PENDING DST tables.
• Upgraded various pages used to create and define Projects and assisted the client in assigning Projects and activities to Contracts.
• Worked on the Contracts/Billing Interface Process (CA BI INTFC) to load billing information from PeopleSoft Contracts and PeopleSoft Projects into PeopleSoft Billing.
• Customized the report Billing Management (CA BILL) and Revenue Management (CA REV) in Contracts as per the client’s requirement.
• Created several new fields, records (tables, views, work records), components, and SQL objects and extensively used application designer.
• Developed SQL Queries using PS Query and used them generate reports using Crystal Report.
• Created test cases and test scripts for testing applications.

Environment: PeopleSoft 9.1 (OM, BI, AR, Projects, Contracts, GL), People Tools 8.51, Oracle 11G.

Confidential

PeopleSoft Financials Techno-Functional Consultant

Responsibilities:

• Involved in Fit-Gap Analysis, design, development, testing and support for PeopleSoft Financials
• Involved in integration CRM and FSCM system
• Involved in setting up Business Units, Customer Groups, Entry Types and Reasons in Accounts Receivables.
• Involved in setting up Payment Terms, Deposit Types, Adjusting Reason Codes, Setting up Credit Card Bank Accounts in AR
• Involved in setting up Team Member Information, Collectors, Credit Analysts in Billing.
• Involved in setting up of credit card data with in Expenses via Integration Broker.
• Created additional non-unique indexes on the feeder tables like Voucher accounting line, CM accounting line and EX accounting line to increase the performance of the interface programs. As delivered indexes are not created on PC business unit, PC distrib status and GL distrib status
• Designed and wrote Functional and Technical Specification (pseudo code) for Interfaces, conversions and Reports which includes financial modules like AP, AR, BI, GL, PO and INV from the functional specifications.
• Setup Direct Connect for eProcurement requisition users to interact directly with supplier (Dell) website to create requisitions.
• Setup and created Change Orders in eProcurement.
• Wrote SQR reports for Trading, Non Trading allocations, Daily and Monthly Billing.
• Purchase Orders were configured correctly to be dispatched to supplier using either Print/ Fax/EDX/Phone/Email in Purchasing.
• Customized the code on the distribution pages to not trigger project status control edits in search mode. Project status control edits would not allow to even look up an entry if the project is in a closed/finished status
• Worked on enhancements and fixing problems which include both technical and functional understanding of the Application and good knowledge of processes in AP, GL, PO, INV, AM, Billing, Project costing modules.
• Did testing using test scripts provided by the functional team in AR and BI modules in Staging and QC environment, reported technical and functional issues to the Issue Tracking team.
• Developed Purchasing Interface using File Layout, Application Engine, which loads data from flat file into staging tables while doing various data validations using AE People code and finally loads into PeopleSoft tables.
• Involved in troubleshooting Billing Interface process (BIIF0001) and extensively used SQL to analyse the interface staging tables to correct the errors.
• Supported Security Analysts in creating new Roles and Permission lists, to grant PeopleSoft single sign on access, amount approvals, run various processes to the end users.

Environment: PeopleSoft Application Release 9.0, People Tools 8.51, Oracle 11g.

Confidential, Troy, MI

PeopleSoft Analyst

Responsibilities:

• Involved in the design &development of Functional and Technical specifications, to automate the current manual Inventory Picking process, by using the Bar Code Readers, with Test Plans and Procedures.
• Involved in the development of high-level Flow diagrams for the total automated process of the Inventory Process. And also developed separate Flow diagrams that can be used by the end users, to understand and follow the new automated Inventory Picking Process.
• Involved in the customization of the delivered PeopleSoft objects, and creation of the new objects as required for this Inventory Picking atomization process.
• Educated and done production support with e Procurement.
• Performed Extensive Application tuning for Order to Cash Business process.
• Done the SQL tuning where the report was taking a long time.
• Customized the workflow in e Procurement.
• Provided technical approach and architecture for remaining conversion development.
• Worked independently and closely with business users to improve Order to Cash processing.
• Configured the Workflow and setup the Supervisor for the requester and Buyer.
• Involved in the development of the relevant and required Component Interfaces and the Application Engine batch programs, using the delivered Components, to populate the Bar-Code Reader file Inventory Picking data through PeopleSoft Front-end application validations, avoiding manual online entry.
• Involved in the configuration of the Integration Broker on PeopleSoft Financials, to Convert / migrate the data from different legacy systems to Financials modules.
• Involved in design and development of Inventory Items data Conversion /migration from different legacy systems like FleetMax and others into PeopleSoft, by creating Cross-reference tables, custom Component Interfaces for the delivered Components, that were called in the Custom Application Engine program, with the client specific business rule of unique Vendor Item ID checking.
• Performance Improvements in PeopleSoft Batch Processes which include Application Engine, COBOL & SQR's.
• Involved in customizing PO Expediting Reports as per the requirement of the Client and scheduled them to run on every Friday at 8AM, to send the reports as PDF attachments to the respective Buyer email account.
• Involved in the design and development of Inventory Usage Value report for given Period of time.

Environment: PeopleSoft FSCM 8.9, People Tools 8.48, Oracle 10G, Windows XP.

Confidential, Dallas, TX

PeopleSoft SCM/CRM Technical Developer/Production Support

Responsibilities:

• Worked as a PeopleSoft Technical/Upgrade Analyst for upgrading PeopleSoft CRM, OM, BI, AR and Inventory modules from 8.0 to 9.0 in an Oracle environment.
• Involved in Fit/Gap analysis and identified the existing customizations for upgrade and analysed the required changes for the new release.
• Upgrade the existing run control pages and process which include Extract Agreements App Engine, Create Agreements App Engine, Print Batched Agreements SQR, Review Staged Agreements, Review Print Batches etc.
• Performed fit/gap analysis of PeopleSoft CRM 8.0 and subsequently PeopleSoft 9.0 SP1 CRM for suitability to the business processes.
• Developed functional design specs for managing single order entry into multiple fulfilment locations / business units, using the Order Capture module.
• Used PeopleSoft CRM 360 Degree Customer view to access data across multiple CRM Modules as well as Order Management modules.
• Worked to address production support issues relating to the integration of CRM 9.0 SP1 Help Desk and Order Capture with third party Inventory and Order Management systems.
• The billing processes, BIIVCSTS (Bill Status Change), BIIVC000 (Finalize), BICURCNV (Currency Conversion), BIPRELD (Preload), BILDAR01 (Load AR) and BILDGL01 (Load GL) are upgraded to 9.0 and additional customization which are identified in fit gap analysis have been implemented.
• Upgraded components/pages in the areas of Bill Entry, Bill Inquiry, Bill Adjustments, application engine programs like Billing Interface and Payment Predictor and other SQR programs in BI and AR.
• Developed custom SQR process to accept information from various billing systems to bring in the billing information to AR, thereby populating PS GROUP CONTROL, PS PENDING ITEM and PS PENDING DST tables.
• Developed SQL Queries using PS Query and used them generate reports using Crystal Report.
• Created test cases and test scripts for testing applications.

Environment: PeopleSoft v8.0/9.0, (FSCM/CRM, BI, AR, IN, GL), People Tools 8.48, Windows XP, UNIX.

Confidential, Houston, TX

PeopleSoft Techno Functional Consultant / Production Support

Responsibilities:

• Interacted with users to gather information & requirements to anticipate functional deliverables.
• Designed a Data Conversion Strategy for converting data from PS 8.0 to PS9.0, using Component Interfaces, File Layouts and Application Engine.
• Upgraded PeopleSoft Database Platform from SQL server to Oracle 10g. Rewritten and tested Custom PeopleCode, SQL definitions, PS/Query, SQR and Application Engine programs.
• Designed and developed Automatic Bank Reconciliation application to reconcile cleared checks coming from all the banking institutions and interface this application with Accounts Payables.
• Modified the delivered EDI Inbound process to load data from various internal systems and external vendors in compliance with custom fields added to delivered Accounts Payables tables.
• Performed extensive debugging and performance tuning of various processes. Well versed in utilizing Debugger, tracing tools for trouble shooting issues on PeopleCode, Application Engine, COBOL and SQR
• Coded and enhanced new and existing JCLs, batch programs and COBOL CICS programs
• Fixed Project Costing transactions to show detailed transaction data in USD dollars entries
• Resolved Issues with FS ALLC Allocation process not working for EPEC business Unit
• Corrected CAPEX by Division report in Project Costing Module as per Client Requirements
• Project Costing: Developed Capital/Expense Project Expenditure report by Department Tree
• Project Costing: Customized PC TL TO PC interface added Error handling logic and generating log file
• Asset Management: Resolved several issues with Asset transfers, Depreciation calculation, Asset Retirements after Go Live.
• Used Integration Broker to send a XML document across databases and schemas to synchronize data for members such as personal information, and Vendor data.
• Resolved any issues related to Subscription and Publication contracts stuck in NEW or Error Status in the Integration Broker.
• Developed various Messages and Message channels for communicating the PeopleSoft with Third party systems in the XML Format.
• Customized the Aging Summary and Detail SQR Reports in Accounts Receivables.
• Resolved Production Issues with Payment Predictor and AR Update Processes
• Developed Lockbox SQR process to load information from various Banks into payment staging tables in Accounts Receivables
• AP: Worked on modifying the delivered SQR's, worked on creating the report extract files like Use tax which is send to the government and customized the delivered SQR's like 1099 reports.
• Designed and developed AP Voucher Match Exception workflow process to send worklists and emails for the Match exception to the appropriate users.
• Developed Conversion program using Application Engine and Component Interface for loading open Vouchers from legacy system into People Soft Accounts Payable.
• Worked on a requirement for an EFT/ACH file using the current data in AP module
• Customized the delivered Accounts Payable Checks, Advices, Trial register and Match Exceptions report.
• Involved in designing and developing Bank Statement Processing for AP.
• Developed a Interface to Load External billing Transactions into Billing Interface Tables
• Customized the Billing Invoice, added Client Logos and custom fields onto the Invoice report
• Designed and developed Credit Card Load Interface to load new credit cards and update existing cards data with complete history or incremental changes provided by AMEX. Encryption and decryption of credit cards was used in the interface.
• Applied Patches and Fixes to PeopleSoft delivered and customized applications.

Environment: PeopleSoft Application Release 9.0, People Tools 8.49.

Confidential

PeopleSoft Developer and Support

Responsibilities:

• Generated AP Vouchers and populated the AP external interface staging tables (PS VCHR HDR EC, PS VCHR LINE EC, PS VCHR DISTRIB EC) with Inter Unit Billing Information from the PeopleSoft Billing tables.
• Developed inbound interface to load the files from Wachovia and BOA banks. The data loaded is used by PeopleSoft 8.9 financials system for reconciliation.
• Developed a new outbound interface to send vendor and employee details to Apex Source system. Enabled the option to run the interface for complete extract or delta extract based on date modified.
• Provided Production support to various production issues reported by user on day-to-day basis.
• Worked with Accounts Payable on various customizations, which involves Manage Vouchers, EDI Processing, Pay Cycle, AP Processing, AP Interfaces, Refund Processing
• Modified APY2021 Check Copy Crystal Report so that it includes additional fields on the check copy.
• Modified APY2027 Wire Advice Crystal Report according to the client requirements.
• Resolved Match Exceptions and Configured the Matching Rules for the AP Matching Process
• Worked on modifying the delivered SQR's, worked on creating the report extract files like Use tax which is send to the government and customized the delivered SQR's like 1099 reports.
• Customized the Purchase Order consolidation process to allow for consolidation based on the Ship To locations to accommodate vendor requirements.
• Written Peoplecode to give access to Edit PO comments to certain role users on the Create Purchase Order Component
• Configured the Requisition Approval workflow to have 4 levels of approval
• Involved in developing a new process called Punch Out with 3rd Party vendors like Dell, Apple etc. Have intensive understanding of XML and EDI’s
• Involved in development of outbound sqr interface which reads entries from ledger table and summarizes details at Business unit, market and account level based on the run control parameters.
• Developed an interface which generates an output file for Tax Data Store, with GL Balance data for Trial Balance Accounts for the purpose of user access in completing tax returns and estimates for the various tax disciplines.
• Built several custom SQR routines to correct out-of-balance conditions throughout budgets and expenses in PeopleSoft Financials, and specifically Commitment Control, Projects, and Grants.
• Developed a custom report, Project Information Notification (PIN) report - UMGM7014.sqr, using SQR for the Grants module. The PIN Report contains key award and project data and will be sent to PI’s and Business Managers to notify them of new projects and key changes to existing projects.
• Created Messages and Message Nodes for integration with 3rd party system.
• Created report for business users to view budget-checking exceptions by the source transaction for a range of dates.
• Designed and developed Commitment Control budget details report to display the budget details with or without tolerance for project and/ or activities
• Developed Application Engine to still further validate the Data and Populate Valid Transactions into Proj Resource if the Data is valid after cross verifying / validating the Data against respective Control tables.
• Developed Application engine, File Layout and Component Interface to eliminate win runner usage to mark in-house date on escheated payments in Accounts Payables.
• Developed an Application engine program to generate two reports, one with a list of all control groups through a specific date range and another with a list of 25 randomly chosen control groups and the largest dollar amount voucher within the selected control group.
• Extensively used PeopleCode at record, page and component level to maintain history of all the actions taken on an expense report against PeopleSoft delivered code to overwrite Hold action by approval or denial. This customization helps the business in having audit trail of all the actions.
• Involved in complete Procure-to-Pay process through Purchasing, procurement and Payables.
• Configured and customized the Approval workflow for PO requisition approval based on Supervisors and dollar amounts by creating new Route Control profiles.
• Modified PO Dispatch program (POPO005.sqr) to change the PO Layout for Business units and print Ship to comments for printing the address and include company logo.
• Performed Performance tuning on various queries and application engine programs.
• Resolved trouble tickets mostly in Accounts Payables and Expense on issues related to query timing out, Voucher Posting and Payment Posting process, matching, interfaces, AP NIGHT job and expense reports being partially paid, partially approved, routed to previous supervisor, etc.

Environment: PeopleSoft Financials 8.9, PeopleTools 8.48, Windows 2003.

Confidential, IN

PeopleSoft Techno/Functional Consultant

Responsibilities:

• Created Messages and Message Nodes for integration with 3rd party system.
• Involved in designing the Functional and Technical Specifications according to the business logic of the client. Worked with functional analysts and wrote technical specifications.
• Prepared functional and technical specifications for the Asset Management which allows NBV (Net Book Value) of the different asset categories being written to a output file.
• Developed and modified Application Messages to integrate Accounts Receivable node with a third party Application.
• Implemented Application Messaging in order to transmit the Financials Chart fields Accounts, Dept, Projects, Products to the Clients sub system.
• Extensively used sourcing analysis pages in PO module to identify the issues regarding selection criteria for PO build process and auto select process for requisitions.
• Tuned the Load Invoice Application Engine process for loading Invoice data from Excel files.
• Customizing Journal Entry Detail Report, FIN2001 to show correct chart field values.
• Designed a SQR report which captures potential incorrect inventory transfer Journal entries for each store by period. The report lists details for both the sending and receiving store of the transfer
• Designed and Developed workflow approval rules in AP for voucher matching exceptions.
• Defined approval rule sets depending on unmatched Amount. This required approval by authorized person to approve depending on amount. Associated Business process and Activity for the approval rule sets. Assigned roles in activity for workflow security.
• Involved in setting up Consolidation elements for DATA, SCOPES, RULES and PROCESSES for running the delivered consolidations COBOL-SQL process GLPOCONS.
• Developed application engine batch process which would invoke component interface every one hour to check for exception match rules after voucher edit and send it to authorization of the concerned person.
• Involved in SQL Optimization, Patches/Fixes and Production Support.
• Modified the PS delivered GL Journal Approval Workflow by adding four approval rule sets and created new route control profiles according to company requirements.
• Developed a Conversion Program for converting the data from Legacy system to AM and made sure that all relevant data for an asset are included on the flat file to be interfaced to PeopleSoft.
• Interface for validating Pricing data in upload process from Excel spreadsheet Developed AE Process using Component to PeopleSoft Tables.
• Performed customizations of the Project Costing Module like graying out and adding fields as per the business requirement.
• Involved in modifying the PeopleSoft delivered Payment Posting process App engine AP PSTPYMNT to allow the process to restart from the latest commit after a failure.
• Developed an interface using Application Messaging and Component interface to load Purchase orders and Requisitions data from third party application to PeopleSoft system.
• Worked on customizing various pages using Peoplecode for validations, Components, Interfaces and SQR Reports for Expenses, Inventory modules.
• Did modify the search page used to return PO that is open for receipts.
• Creating process definitions and scheduled the custom/modified SQR’s in the Process Scheduler.
• Customized the Fin2025 Process to create the Payment file based on the Company Requirements.
• While testing the application, i.e., tuning, we run each new panel through a series of check points like accessing panels from a menu, ensuring if all application activities are valid, ensuring if the search criteria is correct, insertion, updating and deletion of rows. Involved in system corrections and system stabilization.
• Created the SQL Queries using PS/Query tool and used the Queries to generate Reports using Crystal Report tool.
• Loaded items from billing in to AR using AE and Component Interface.
• Customized the Payment forms for Payables using Crystal Reports.
• Involved in Knowledge Transfer, Documentation, and Presentations to help all the members of the Development team by being an active member in bridging the gap and sharing the knowledge to complete the job successfully.

Environment: PeopleSoft Financials 8.9, PeopleTools 8.46, Oracle 10i.