PROFESSIONAL SUMMARY

• Over 11 years of experience and 10 years as PeopleSoft Techno-Functional Consultant
• Oracle PeopleSoft Certified Tools Developer
• Expertise in PeopleSoft Upgrades and re-implementations
• Expertise in Order to Cash and Procure to Pay business process configurations and testing
• Thorough technical knowledge and experience in People Tools Application Designer, People Code, Portal,
• Query, Process Scheduler, Application Engine, Security and Tree manager
• Experience in variety of PeopleSoft projects covering Implementations, upgrades and production support project types
• Good understanding of SOA Technologies
• Excellent in documentation pertaining to requirements gathering, Technical and functional design specs, test cases, test plans and procedures
• Expertise in reporting tools like SQR Reports, Crystal Reports and XML Publisher
• Very good in analytical thinking, testing, troubleshooting, and error fixing
• Experience in integrating 3rd party and other Peoplesoft applications using integration broker, Application Engine, Component Interfaces and SQR
• Can efficiently handle Production Support, Bug fixing Fine tuning processes for improving performance
• On- Call support for System Maintenance and also involved in Performance tuning of the new and existing code

SKILL SET

PROFESSIOINAL EXPERIENCE

PeopleSoft Consultant / Lead

• Analyzed the requirements and created Technical design documents.Responsibilities:
• Acted as a Techno-Functional SME for projects and provided guidance.
• Developed Payment extract process in Application engine to load in to staging tables.
• Developed Payment outbound process in Application engine to create flat files for different payment methods.
• Developed an SQR to create a Credit card EDI file for Banks.
• Developed an inbound Application engine process to load the Bank confirmation data in to PS tables.
• Developed a Reconciliation process to reconcile Payment information send by Bank and PS AP payments.
• Developed a Process to create Invoices and External transactions for reconciled Payments.

PeopleSoft Consultant / Lead

Responsibilities:

• As a Track lead responsible for entire China Track Upgrade retrofit and development activities.
• Created Technical Analysis and Technical design documents for entire upgrade.
• Generated Fit/Gap analysis document with compare reports.
• Worked along with PS Admin in all Technical issues during initial pass.
• Performed Pre-functional and Post-functional tasks in Upgrade project for AP, AR GL Modules.
• High level Design reviews, Functional/Technical advice.
• Defect solutions provided for AM delivered Application engine processes during build phase.
• Provided solutions in carry forward requirements.

PeopleSoft Consultant / Lead

• As a Technical Lead analyze all the FDD's and make sure development and TDD's are creating as per the FDD's for AM, BI and AR modules.Responsibilities:
• Prepared Technical specifications for customizations, reports and conversions.
• Involved in the configuration setup of AR BI systems.
• Developed a very complex interim process 'Soft cost allocation' in Application engine program for Project costing module.
• Configured Excel deposit upload process in Receivables.
• Configured Lockbox configuration and Payment predictor process.
• Configured and Customized the AR Refund process in Receivables.
• Analyzed delivered Asset disposal workflow process to implement a bolt-on workflow process through AWE in Asset Management module.
• Configuration of Travel and Expense Approval Workflow engine AWE .
• Developed new XML publisher reports.
• Worked extensively with SQL, Functions and PL/SQL.
• Worked with Unix scripts.
• Tested the transaction flow between the modules Accounts payable, Project costing and Asset management and Accounts payable, Project costing, Contracts and Billing modules..
• Customized the CA BI INTFC process to create the temporary bill with the 'Invoice Notes' based on the Project Id.
• Worked as a Security Administrator in helping the functional leads to create the Security matrix for their relative modules.

PeopleSoft Consultant / Lead

Responsibilities:

• Conversion:
• Involved in design and development of conversion programs using SQR for transferring of data from legacy system to PeopleSoft Finance.
• Involved in Data conversion, Data migration and Integration solutions using SQR and Data Mover.
• Participated in Data conversion of Applicants, Customers from staging tables to Peoplesoft delivered tables using custom Application engines.
• Involved in the analysis of the Legacy System and formulating the strategy for the implementation.
• Development:

AR/BI Activities

• Customized Aging Run Control pages to facilitate the users to select multiple options such as Global BU, Department Id, Sales Person, and Acquisition code, Collector, Customer and Collection ID and also modified the SQR's ARR003 and ARR004 to incorporate the above additional fields in the report output.
• Developed and Customized Record definitions, pages, components, process definitions SQR's to run through Process Scheduler.
• Extensively Customized the ARR003 as per client needs where I have customized the report to generate Aging Summary and Detail Reports based on the option in the run control page. Received appreciations from receivables director for the same .
• Customized BIIVCPN.SQR Invoice Print - Portrait / Non-Consolidated to implement multiple logos for various customers based on their Billing invoice ID.Got appreciation for the multiple logos logic for different customers in their invoice format.
• Customized several reports, dunning letters sqr and statements with brand logos to print in pdf's for Billing and Receivables.
• Developed new deposit upload process to load the payments.
• Worked extensively with SQL, Functions and PL/SQL.
• Fixed AR PAYLOAD process to handle different bank information on the same payment batch.
• Extensively worked on PS-QUERY and SQR to develop various reports related to Receivables, Billing and front Office modules.
• Customized Bill to option page in customer component to add a functionality 'preferred communication'.
• Created new application engine process which sends the email with an invoice as an attachment when the customer related to that invoice was setup as preferred communication as an email only.
• Created new Application Engine program to create a flat file for the purpose of EDI invoice format.
• Followed SDM Solution Delivery Methodology for documentation from ID assess to implementation phase.
• Responsible for resolving application message issues related to applicant hire process.
• Involved in customizing a custom application package to resolve issues related to the customer and applicant forms, Added new methods to implement the functionality as per user requirement.
• Assisted users in resolving various issues related to Billing, Receivables and Front Office modules.

Staffing Activities

• Extensively customized Applicants Component as per user needs.
• Prepared the technical specifications for customizations, reports and interfaces related to Applicants, Orders, Account payables, Billing and Receivables.
• Developed a new Component interface program to create quick applicant process. Also created a new page to accomplish the same.
• Customized COPY ORDER Component interface as per client needs.
• Extensively worked on application package programs to implement the forms functionality used in applicants, orders and customers
• Customized delivered application message program which publishes the applicants data to HR system during the hire process.
• Responsible for creating Technical Requirements Document for various business requirements.

PeopleSoft Consultant / Lead

• Involved in the development and enhancement of PeopleSoft Finance and SCM modules.Responsibilities:
• Provide technical support and expertise for PeopleSoft Financials like Accounts Payables, Receivables, and General Ledger and SCM modules.
• Worked on Unpaid Voucher Conversion loaded data into VOUCHER, VOUCHER LINE, and DISTRIB LINE.
• Created new Application engine, component Interface to load VOUCHER data into PeopleSoft tables.
• Created custom SQL views involving complex calculations with rolling 12 month averages, multiple effective dated rows, and more.
• Customized few processes and Created few reports in Order to Cash flow process.
• Worked with Different banks to set up payments directly to Vendor accounts. Configured the Bank setup along with modifications to Pay cycle to include payments of type, EFT.
• Implemented check printing for Vendor Payment.
• Worked extensively with SQL, Functions and PL/SQL.
• Made the necessary changes for the VCHR BUILD process incorporating the needs of the business process.
• Created new Application engine for creating outbound files for Gross margins for every month.
• Developed new SQR Unvouchered and Matched Liabilities Mismatches between Sub ledger and GL .
• Developed new Application Engine Programs to create flat files in UNIX server and Using Unix Shell scripts FTP the files from Unix server to Main frame server.
• Customized PeopleSoft delivered crystal reports in Accounts Payable module like Vendor Detail, Vendor Summary, Closed Voucher, APY1010 Voucher Register, APY1010A - Posted Voucher Register, APY1040 - Open Voucher Report, APY2015 - Check Register.
• Developed following out bound Application Engine Programs in Accounts Payable module are as follows :
• 1. Invoice Information from PeopleSoft to Baan.
• 2. Pending/Settled Month-End Summary Report.
• Worked on creating the EDI files in the formats requested by Banks across the world, to do automatic payments.
• Worked on Crystal Reports, to furnish information as required by the client for reporting and generating customized reports.
• Worked on Outbound Interfaces using File Layout to generate the extract file and FTP it to the Mainframe Server.
• Provide new reports Like Summary and Detail List of GL Account Conversion updates on Journal Records, Account and Business Unit based Transaction Amount Reports.
• Worked with Unix scripts.
• Developed Test Plans, Test Scripts and Test Cases.
• Involved in different phases of QA Testing like Unit Testing, Integration Testing and Regression Testing.
• Involved in the AR Configuration Set-up for new plants.

• Interacted with Users to gather functional Requirements

Developer

Responsibilities:

• Worked on data Conversion Programs PS VOUCHER, PS VOUCHER LINE, PS DISTRIB LINE.
• Created new Application engine, component Interface to load VOUCHER data into PeopleSoft Voucher tables.
• Created new CI for load PO data into PO TABLES
• Developed Week over week hour report for Gross margin comparison for every week.
• Involved in debugging Application Engine programs and PeopleCode using PeopleCode Debugger.
• Modified PO Dispatch process to meet the custom requirements.
• Built online queries in Query tool that can be accessed by users via process scheduler.
• Customized PeopleSoft delivered crystal reports like

1. Vendor Detail,

2. Vendor Summary,

3. Closed Voucher,

4. APY1010 Voucher Register,

5. APY1010A - Posted Voucher Register,

6. APY1040 - Open Voucher Report,

7. APY2015 - Check Register.

Developed new reports like

1. AR cash receipts,

2. Check summary log,

3. Customer summary information,

4. Employee summary report,

5. Daily Backlog Report.

• Customized Customer Aging report in Receivables with Sorting Enhancements.
• Created new Application engine for creating outbound files for Gross margins for every month.
• Created and modified Pages, Records, PeopleCode, Components and Menus.
• Extensively worked on Process Scheduler, Tree Manager and Query.

• Involved in the development and enhancement of PeopleSoft Finance modules.

Developer

Responsibilities:

• Provided customizations to the pages and wrote People Code validations to satisfy the customer needs.
• Worked on PS Query to generate reports according to the customer requirements.
• Worked on Crystal Reports, to furnish information as required by the client for reporting and generating customized reports
• Worked on Outbound Interfaces using File Layout to generate the extract file and FTP it to the Mainframe Server.
• Formatted the delivered SQR's according to the client's requirements.
• Developing new SQR's according to the client requirements.
• Extensively Customized the ARR003 as per client needs where I have customized the report to store Contract Modifications Information and modified the Header Suffix and Line Suffix and Contract History Information on the report output.
• Extensively customized the delivered Purchase contract sqr POCNT100.SQR as per client needs.
• Created Standard layout and Bank Layout for Aging report in one SQR.
• Provided customizations to the pages and wrote People Code validations to satisfy the customer needs.
• Customized the Dunning Letter SQR as per the Client need.
• Involved in the AR Configuration Set-up for new plants.
• Involved in identifying, developing test scripts and testing for the receivable process starting from Entering Receivables, Entering Payments, and Applying Payments to generating accounting entries for the AR application.
• Developed a Component interface to load General Ledger data to PeopleSoft tables using EXCELTOCI utility to read an Excel file.
• Developed new Application Engine Programs to create flat files in UNIX server and Using Unix
• Shell scripts FTP the files from UNIX server to Main frame server.
• Created a new Application engines to create a flat files of invoice information for their legacy system BAAN.
• Developed new pages, record and fields.