SUMMARY OF EXPERIENCE

• Over 7 years of comprehensive experience with Enterprise Applications, Client Sever and Enterprise Technologies in designing and delivering solutions to clients across multiple industries.
• Two full life cycle Implementation, Upgrade and Support of PeopleSoft Financials solutions covering all the major modules including Inventory, Accounts Payable, General Ledger, Billing, Accounts Receivables, Purchasing and Order Management across multiple industries.
• Excellent technical skills of People Code, People Tools, Application Engine, SQRs, Crystal Reports ,Component Interface, and Integration broker, Workflows, Application Packages, PS Query, XML Publisher and N-vision.
• Excellent hands-on experience in PL /SQL, SQL loader utility and UNIX Shell scripts
• Experience in software development methodologies, design and implementations.
• Developed many reports using PS/Query Crystal, XML and SQR, including dynamically changing output-generating reports using SQR methods like Break Logic, Load-Lookup, Arrays, Multiple reports, and Form reports, Printing Logos, More Headers etc.
• Involved in addressing the issues related with PeopleSoft Security related to Users, Roles, Permission Lists, Password related, Object and Query Security.
• Worked on various Customizations, Interfaces, and Data Conversions Using SQR.
• Core competencies include communication, interpersonal, presentation and client interfacing skills.
• Domain experience includes Clinical Services, Banking , Financial ,Logistics, Manufacturing.

SKILLS SUMMARY

Functional Modules: PeopleSoft Financials Accounts Receivables, Accounts Payable, General Ledger ,Billing, Purchasing , Order Management , Inventory , travel and Expense 9.x/8.x/7.x

PS Technical : Application Designer, People tools, PeopleCode , Query designer, Application Engine, File Layouts, App Messaging, Integration broker, Component Interface, Workflow, Process Scheduler, Tree manager, vanilla security, EDI Manager , Data Mover Reporting: SQRs, PS Query, N-vision ,Crystal Reports, XML Publisher RDBMS: Oracle 9i/10g, SQL Server, Rapid SQL,SYBASE Languages: HTML/DHTML, VBScript, JavaScript, PL/SQL, UNIX Shell script Version control: VSS, PVCS, STATS

Operating Systems: Windows XP, UNIX Third party tools: Toad

PROFESSIONAL EXPERIENCE

Confidential

PeopleSoft Techno Functional

Responsibilities:

• Prepared Technical Specification documents based on functional requirements.
• As part of WCB implementation project a new page WCB Asmnt Part is created for customer maintenance under customer component.
• As part of WCB implementation project a new run control page and related definitions Tables, views and fields are created to accomplish the requirement.
• An Interface is developed to generate pending items and populates PS PENDING ITEM and PS GROUP CONTROL tables for appropriate customers Carriers .
• An application engine program is developed to create a new item with balance after calculating the base factor amount against the first 4 quarters.
• Prepared and verified security changes document permission lists, roles, user profiles based on user requirements.
• Worked on several UAT User Acceptance testing issues.
• Prepared go-live implementation plan document.
• Worked on XML publisherand Queries for reporting.
• Worked on several production issues on different modules.

Upgrade and Production Support Responsibilities:

• The main goal of the proposed system is process should not run for a long time and pick all the items by chunking the data. I need to come up with a method which has new conditions and actions and should fit into the system.
• Currently working on the Automatic Maintenance Process:
• Successfully completed the Ethics mandatory training, Information security, Internal Control, sexual harassment prevention, workplace violence prevention Training classes and Tests.
• Payments , Penalties.
• Worked on several data issues like interface program failed to pick the
• Modified the People code in payment predictor custom program,which is picking the oldest credit item instead of debit in new version while applying payments.
• Worked on few issues like Process name and type missing in the Process scheduler request page and other similar issues during upgrade testing.
• I wrote scripts for the missed customers, to insert into interface table manually.
• RanAR UPDATE to post the payments and other process Etc.,
• Applied payments manually by using Payment worksheet.
• Created Regular deposits and applied Payments using Payment Predictor for different Business units.
• In 9.1 Upgrade Project Itested complete AR module.
• Worked on Barcode zebra printer issues.
• Removed the Postal code error in AR Customer Statements for the customer and submitted the analysis about the reason why the Customer is not generating the Statement.
• Solved the data issue by deleting the pending item which has amount 'zero' and posted the group using ARUPDATE to create Open receivable item.
• Worked on User security testing for several User-ids on different modules before UAT.
• In AR Collections agency custom report, I worked on agency configuration to change the collection referral part based on the requirement given by the User.
• Modified the custom query to fix performance issue by adding Journal Date as a join Criteria.
• Worked on Customer Statements issues.
• Tested Queries, Crystals, N-Vision Reports for the 9.1 Upgrade Projects.
• Supporting the team with Upgrades, SQR Customization, nvision, People Tools development, customizations and People Code Debugging using People Code Debugger.
• Responsible for identifying, modifying and re-developing SQR programs, Crystal reports, PS queries and people code programs to be compatible with newer version.
• Involved in technical support in various stages of development to production environments.
• Involved with functional team in fixing and troubleshooting problems in designing and development.
• Involved with functional team to gather specifications and information in designing applications and reports.
• Migrated PeopleSoft projects, ran compare reports, created migration request, did code review for code created by other developers.

Environment: People Tools 8.50/8.45, PeopleSoft Financials 9.1/8.8

Confidential

PeopleSoft Techno Functional

Responsibilities:

• - Total Extended cost of all Business units.
• - Calculating and Printing Subtotals Extended cost of all items in a Business Unit.
• - Added run control parameter for all BU's.
• - At the end of the report perpetual weighted average cost is printed along with BU.
• - Printed total Summary for all BU.
• - Added new procedure to run for all Business Units and Inventory Group.
• - Developed a new custom Page by adding new run request parameters.
• - Condition on changing status.
• - Added Primary and additional procedure codes.
• Customized the SQR report INS9051 Counting Sheet by Storage Location by adding Vendor ID under Item ID.
• Developed a new Application Engine modified Null Accounting date based on the conditions given by the client requirements.
• Modified the Packing Slip INS6500 Report by adding InterunitID , Vendor Name, VendorItmNum fields to the Report.
• Developed anApplication Engine program based on STATS and CDS client interface usingpeople code and SQL.
• Developed a custom process to load the Inventory Balances data to the inventory staged table.
• Customized theINS7000 Current Inventory Balances as per the business requirements.
• Customized the INS5450 Report Limited Life Product List
• Modified the SQR PORQ010 Requisition Report AddedShip To ID to the Address.
• Customized the crystal report AR32000 by adding new fields PATIENT ID, procedure code ,po which are from different records.
• Involved in customization of Records, Pages, Components and Menus.
• Customized the custom PS Queries by adding Fields given by the Accounting Users.
• Made changes to Buyer ID not Defaulted to Multiple Req Line to the peoplecode to solve the production issue.
• Developed a new App engine to perform the tax calculations automatically which running proforma.
• Developed a new App Eng to solve Split Invoice Issue using peoplecode.
• Involved with functional team in fixing and troubleshooting problems in designing and development.
• Added Comments field on interunit tranfer page.
• Created CI for Customer Tax Exemption.
• Added Qty to Inventory Reconciliation Report,this modification add the actual quantity difference to the report.
• Customized the CMS2010 Report based on the Specifications.
• Solved few production issues.
• Worked on Inventory Replenishment process, picking, shipping, depletionprocess, PO calc, PO create, PO dispatch and other INV and PO processes.
• Modified the AR Dunning App Engine Extract AR DUNNING for adding more fields on the dunning letter AR33001 .
• Customized Automatic Maintenance Process AR AUTOMNT by defining new rules for matching process and specifying which matching method has to be followed by different BU.
• Developed an SQR to get the list of errors for the ARUPDATE App Engine process while loading the data from the Billing Interface.

Environment: People Tools 8.50, PeopleSoft Financials 9.1

Confidential

Peoplesoft Technical

Responsibilities:

• Involved in technical and online support in various stages of development to production environments.
• Involved in troubleshooting and fixing bugs in Accounts Payable and General Ledger.
• Design and Development of SQR programs for converting existing legacy flat files to PeopleSoft Financials application database tables.
• Prepared conversion strategy and used SQR and Data Mover to load the data from legacy system to the PeopleSoft.
• Developed a Component Interface to load data from flat file to PS BI HDR, PS BI LINE tables.
• Used File layout, Application Engine and component interface to load data from legacy system into PeopleSoft financials application database tables.
• Wrote an SQR program to print the details of the customers who failed to pay the dues within last six months in AP.
• Modified the GL Chart Field Maintenance Pages as per the client's requirement by adding an additional field by name Comments.
• Developed an interface program to fetch all direct POs including Change Orders, Cancellations from legacy system to PS system.
• Modified the GLS7002 report in GL to get the ledger balances for a combination of both multiple and single periods.
• Modified the AR STMTS App Engine and crystal reports to get the required fields for the statements that are populated in the temporary tables during processing.
• Involved in creating a custom process in payment cycle to create a new status and Modified the people code behind the pay cycle manager component to add the new status to the process.
• Modified the AP MATCHING process to develop a report which gives a list of vouchers that are matched and not match.
• Developed reconciliation reports to reconcile the data sent to GL from AP, AR.
• Fixed the AR UPDATE step which did not insert the values in PENDING ITEM when an item is created through a payment worksheet.
• Set up Integration Broker services such as gateways, nodes, services and service Operations etc. for automatic updates between HR and FIN application
• Customized Journal Entry Detail Report, FIN2001 to show only correct chart field values.
• Created an interface to load data from flat file into the PeopleSoft Journal Header JRNL HDR and Journal line JRNL LN tables in GL.

Environment: People Tools 8.48, PeopleSoft Financials 9.0 and web logic 8.1

Confidential

PeopleSoft Techno Functional

Responsibilities:

• Analyzing the existing customizations and end-user requirements and assist in the upgrade process from 8.0 to 8.8.
• Involved in Data Conversion for converting AP/AR/BI/PO/GL from PeopleSoft 8.0 to PeopleSoft 8.8.
• Supporting the team with Upgrades, SQR Customization, nvision, People Tools development, customizations and People Code Debugging using People Code Debugger.
• Responsible for identifying, modifying and re-developing SQR programs, Crystal reports, PS queries and people code programs to be compatible with newer version.
• Modified AR33001 dunning letter and created new Queries for the newly created dunning letters.
• Developed a SQR program in AR for lockbox interface of different record layout as per the client requirements to read the data sent by the banks.
• Developed a SQR program to populate the data from other sources to Receivables pending tables.
• Created a hyperlink on a pay cycle manager page for the custom process that is created at the pay cycle level to transfer to the custom run control record in Payables.
• Involved in the setup of the bank replacement rules in the pay cycle process AP APY2015 to replace bank accounts automatically for payments.
• Involved in developing the business analysis Queries and reports like General Ledger activity and Employee Expenses report using the capabilities of Business Objects reporting capabilities.
• Worked on various Customizations, Interfaces, and Data Conversions Using SQR.
• Modified the Travel and Expense entry page to add client specific expense type included the new expense type in the delivered code.
• Modified the Accounts Payable vouchers page with more fields and description as per the client requirements.
• Coded new SQR's and modified the existing ones using Trees, current tables and new tables for generating GL reports and for uploading and downloading data with brief descriptions and logs.
• Converted Customer, Customer Contacts from Files extracted from Legacy system into PeopleSoft using Application Engine, File layouts and Component Interface.
• Interacting with end users and technical resources. TroubleshootedAP, GL processissues. Sufficiently unit test all coded programs prior to migration to the Test environment.
• Customized the AP VCHRBLD App Engine to insert the voucher details in to the custom tables

Environment: PeopleTools 8.48, PeopleSoft Financials 8.8