SUMMARY

• 8+ years of experience in Software Development.
• Rich experience in developing and maintaining PeopleSoft Applications.
• Experience in Upgrade,Support,Customization and Implementation of PeopleSoft Financials 9.2/9.1/9.0/8.9/8.8/8.4/8.0.
• Strong programming skills in People code, Application Engine, Application Designer, Application Packages, Integration Broker, PS Query.
• Excellent skills in generating Reports using SQR 3.x/4.x, PS/Query.
• Extensive experience in People Tools, Application Designer, People Code, Ps Query,, SQR programming, Application Engine, Application Engine, Component Interface, Application Messaging.
• Good Understanding of record structures and data flow of PeopleSoft Financial modules like Asset Management, Accounts Receivables, General Ledger, Inventory Accounting.
• Good Understanding of development of reports using XML Publisher.
• Experience in writing Interfaces from PS to PS and Third party to PS (inbound) & PS to third party (outbound) using SQR & Application Engine.
• Excellent Analytical, Organizational, Interpersonal and Communication skills.

TECHNICAL SKILLS

• PeopleSoft Inventory PeopleSoft Asset Management.
• PeopleSoft General Ledger.
• PeopleSoft Purchasing.
• PeopleSoft Cost Management.
• PeopleSoft Accounts Receivable.
• People tools 8.51.
• PeopleSoft Application Engine.
• PeopleSoft People code.
• PeopleSoft Component Interface.
• PSQUERY.
• SQR Reporting.
• PeopleSoft Security.
• PeopleSoft Online Page development.
• PeopleSoft Application Packages.
• PeopleSoft Message Subscription People code.
• Excel to CI.
• Core Java Programming.
• XML Publisher.
• Web Services.

PROFESSIONAL EXPERIENCE

Confidential, St Paul, MN

Peoplesoft financial Developer

RESPONSIBILITIES:

• Worked as a team player in the PeopleSoft Financials Development and Maintenance team to enhance the current applications.
• PeopleSoft Development with XML Publisher, Application Engine, Excel - to-CI, SQR and File Layout.
• Analyzed the query requirements of the Users and preparing Technical specifications and coordinating with Offshore Support team in developing the queries.
• Design, developing and Generating/Modifying the XML Publisher reports, PS Queries and nVisions.
• Maintained and resolved issues with delivered Messages in Integration Broker like PERSONAL DATA message.
• Worked with Accounts Payable on various customizations, which involves Manage Vouchers, EDI Processing, Pay Cycle, AP Processing, AP Interfaces, Refund Processing, AP Reports and AP Security.
• Creating queries for all Open invoices and Modifying Invoice Print Crystal in PS Billing.
• Worked on creating new IB messages for Inventory (Journal) module, subscribing from third party.
• Worked on utilizing delivered IB messages for voucher, chart field and combo data sync.
• Customized voucher build application engine process.
• Created a custom page and application and IB messages to sync combo data rules with a third party.
• Developed application such that the same IB message (VOUCHER BUILD) can be used for multiple environment (Peoplesoft and external companies). Also made use of the partition concept to create sub-channel so that one failed message does not block another.
• Created schedules, recurrences, batch jobs as needed.
• Customized several SQR and Crystal reports like Pending items, aging reports like AR30001, AR30002, AMPS1000.sqr, Invoice printing (BIIVCEN).
• Modified the setup on check printing process to print the overflow advices along with the checks on the regular check stock and also sort the printing by handling codes as per client’s requirements and tested the same.
• Performed extensive debugging and performance tuning of various processes. Well versed in utilizing Debugger, tracing tools for troubleshooting issues on Peoplecode, Application Engine and SQRs.
• Creating custom reports on aging details and summary for regular bills and Expense bills.
• Creating a report for the Account Receivable on Pending items that runs and gives report periodically, that gives the list of all Pending Items, and Pending Payments.
• Customized PO Dispatch/Print to change headings and print in duplex mode for Company Terms & Conditions.
• Implemented IB (integration Broker) calls to third party systems for AP and Purchasing.

Confidential, Springfield, VA

Peoplesoft financial Developer

RESPONSIBILITIES:

• Worked as a team player in the PeopleSoft Financials Development and Maintenance team to enhance the current applications.
• Involved in resolving several data issues as a part of production support by creating and running scripts (in SQL) and SQRs.
• Created Message, Service, Service Operation, Queue in PeopleSoft 9.1 Integration Broker to send and receive synchronous and asynchronous messages between PeopleSoft and Third party system.
• Interacted with the end user for customizing reports, fixing the errors in the data that has not been converted and generating various interfaces and reports using SQR.
• Developed Purchasing Interface with File Layout, Application Engine, AE Peoplecode and Component Interface. It loads data from flat file into temporary staging tables and queries external database via Database link to retrieve chartfield information. This interface performs various data validations using Application Engine PeopleCode, finally loads validated data into PeopleSoft tables through Component Interface.
• Created security permission lists, user roles, and assigned appropriate roles to user profiles to allow authorized access to view/update data.
• Developed an SQR report that would list the Purchase Order details with receipts and vouchers against it. This SQR would help in finding out if the Purchase Order is in sync or not and identify the issues with it at a glance.
• Involved in the Performance Tuning for canceling and closing purchase orders by creating custom indexes, using oracle hints etc.
• Involved in testing the system and interfaces writing, reviewing, running and validating test scripts.
• Developed custom Account Payable Functional specifications and data mapping for ACH/EFT Payment files sent from Wachovia as part of Bank reconciliation process. Also documented the custom process with the test results.
• Modified the setup on check printing process to print the overflow advices along with the checks on the regular check stock and also sort the printing by handling codes as per client’s requirements and tested the same.
• Performed extensive debugging and performance tuning of various processes. Well versed in utilizing Debugger, tracing tools for troubleshooting issues on PeopleCode, Application Engine and SQR’s.
• Creating custom reports on aging details and summary for regular bills and Expense bills.
• Creating a report for the Account Receivable on Pending items that runs and gives report periodically, that gives the list of all Pending Items, and Pending Payments.
• Developed an Application Engine program to modify the Serial Controlled inventory item into a non-serial Controlled Item.
• Customized PO Dispatch/Print to change headings and print in duplex mode for Company Terms & Conditions.

Environment: PeopleTools 8.52/8.53, PeopleSoft Application 9.1 (GL, AP, AR, AM, PO, BI, Contracts, Travel & Expense and OM) Sql Server, SQR, Application Designer, PeopleCode, PS Query, Data Mover, Application Engine, Integration Broker, XML Publisher.

Confidential, HOUSTON, TX

People soft financial Developer

RESPONSIBILITIES:

• Performing production support and daily enhancements for PeopleSoft Finance Modules like Asset Management, Purchasing, Project Costing and Accounts Payables.
• Handling offshore team of 4 PeopleSoft developers.
• Delivering weekly status reports of work done to higher management.
• Understanding client’s business process and architecture and doing knowledge transfer and training to the offshore team.
• Modified existing sqr programs to in corporate business requirements not delivered by PeopleSoft.
• Developed XML Publisher reports to help business run queries directly into word.
• Worked on creating complex Application Engine Programs for automation of repetitive tasks for business users like reading data using a query and calling component interfaces using people code.
• Worked on writing custom Excel to CI interfaces to help business load burden rates, Bill of Materials into PeopleSoft using excel.
• Worked on creating application engine programs to load rate tables in GL which includes reading rate files and calling Rate load Message using AE people code.
• Designed and developed custom application engine programs to write archiving logic for item master which involved loading item files from external systems, writing custom qualification logic, taking backup of data and purging data.
• Worked in SLA driven environment which includes answering to business questions, queries based on priorities.

Confidential

People soft financial Developer

RESPONSIBILITIES:

• Worked on Application Classes and People code.
• Prepared Technical specifications depending on the functional specifications.
• Responsible for conducting peer-to-peer technical review.
• Extensively involved in development and bug fixing across all modules.
• Providing technical solutions for complex problems.
• Coding standards and GUI guidelines were followed as per Citibank’s requirement.
• Responsible for Unit Testing and Bug Fixing.
• Responsible for solving STR (System Trouble Reports) at the time of IST (Integrated System Testing) and preparing STR documents.
• Responsible for development of change control arising at the time of IST.
• Worked with business to do Fit Gap Analysis, suggest changes to system or configurations to accommodate business needs and also suggest best solutions in PeopleSoft.
• Worked in Production Support Model for Asset Management module which involved Loading Assets from interface tables into PeopleSoft, Fixing jobs abends related to Calc Depreciation process, resolving business user’s issues or inquiries regarding asset transfers Balances.
• Worked on performance tuning of long running Application Engine programs which involved identifying long running queries working with DBA for creating indexes.
• Worked on creating Application Engine Programs for automation of repetitive tasks for business users.
• Worked on writing Excel to CI interfaces to help business load burden rates, Bill Of Materials into PeopleSoft using excel.
• Designed and developed custom app engine programs to read data from external files load them into PeopleSoft and perform processing.
• Designed and developed custom application engine programs to write archiving logic for item master which involved loading item files from external systems, writing custom qualification logic, taking backup of data and purging data.

Confidential

People soft financial Developer

RESPONSIBILITIES:

• Involved in the implementation of Financials 8.4 (AP, AR & GL) and SCM (Inventory, Purchasing and Order Management) and upgrade to 8.8/PeopleTools 8.43/8.44.
• Extracted, converted and loaded data from legacy system to Peoplesoft tables.
• Systems converted - Vendors, Purchase Orders.
• Methodologies used - from flat files using Peoplesoft File Layout/Peoplecode/App Engine program and Peoplesoft Component Interface API.
• Written new SQR to report Cost by BU report to get all the details of the items for all business units.
• Worked extensively on application engine programs like Payment Predictor, Receivable Update of AR and Voucher Posting, Payment Posting, Matching of AP.
• Customized the POP0005.sqr for printing Purchase Orders.
• Written new application engine code to take care of the user’s new requirements.
• Involved in modification and fine-tuning of delivered SQR reports.
• Extensively Involved in Post-Production Activities, Trouble shooting, fixing patches, Documentation and end user training.

Environment: PeopleSoft Tools 8.4x, PeopleSoft FSCM 8.4, Windows NT/XP,Peoplesoft Sqr,Peoplesoft Query, Peoplesoft Integration Broker, Peoplesoft Application Designer,Peoplesoft Application Engine.