SUMMARY

• 8 years of IT experience in design, development and implementation of PeopleSoft applications working five years with Oracle Corporation, presently working with Collective brands Inc (Payless Shoe Source).
• Strong technical skills in the area of PeopleSoft Application Development, PeopleSoft Reports, Interfaces development and Relational Database Management Systems.
• Worked extensively on PeopleSoft Financials 8.4,8.8, 8.9, 9.0 and 9.1
• Worked as technical developer in following PeopleSoft modules: Accounts Payables, Receivables, billing , ebilling and General Ledger.
• Extensively worked on Bolt-on Applications like Retail Lease Mangement, Xign Interfaces and International Sales Audit
• Expertise in PeopleSoft Query and reporting tools like SQR, nVision and Crystal Report for various EFT Payments, ACH Payments, Payroll Processing, Withholding Reports and Tax Reporting.
• Worked as a Technical Lead and extensively worked on VAT and its implementation.
• Extensively worked on R.I.C.E (Reports, Interfaces, Conversions and Extensions).
• Strong experience in Technical design documentation.
• Strong experience in PeopleSoft Development and related tools like PeopleCode, PeopleSoft Query, Application Designer, Component Interface, Integration Broker, Application Engine, Application Packages, File Layouts, PS Tree Manager, PS Change Control and Work Flows.
• Experience in working with teams across geographical locations and exposure to offshore models being followed across IT Services industry.
• Key strengths include Excellent analytical and problem solving skills, Quick learning on the job, good communication skills, good interpersonal skills and a good team player.

TECHNICAL EXPERTISE

• Expert in development, enhancements and customizations to Online PeopleSoft Applications using PeopleCode and various other PeopleTools.
• Strong knowledge in Taxation rules for VAT, Sales Tax and Withholding.
• Hands on experience and knowledge on RDBMS concepts, Database Data Definition Language and Stored Procedures on SQL Server 2000 and Oracle 8.x, 9i.
• Extensively worked on Reporting Tools like SQR, nVision and Crystal Reporting.
• Expert in developing Batch programs and Reports using Application Engine and SQR.
• Excellent troubleshooting capabilities and Testing skills.
  

SKILLS:

Primary: PeopleTools 8.49, PeopleCode, Datamover , SQR, Process Scheduler, Change Assistance, Crystal Report, PS Tree Manager, Application Engine Program, nVision, PS Change Control, File layout, Application Package, PS Query & Oracle/MS SQL Server.

Secondary: PSADMIN Utilities, PIA, Tuxedo 8.1, App/Web server setup, IB & Component Interfaces, Application Messaging, MS Office, MS Word, MS Excel.

PROFESSIONAL CERTIFICATIONS AND AWARDS

• PeopleSoft Peopletools Advanced Developer Certification

MAJOR PROJECTS HANDLED:

• Interact with internal teams to establish and clarify requirements in order to develop and write specifications.
• Worked extensively on Data Mappings and New Interfaces for various requirements reading Legacy data into PeopleSoft systems.
• Developed a new interface for Integration of Peoplesoft with Wells Fargo for Authorization and Payment of Credit card data.
• Designed online panels in PeopleSoft to provide Tax Dept a screen to track tax claim exemptions by PSS store for sales tax returns.
• Develop new application program to monitor Activity in Vendor table and auditing of Vendor Data.
• Develop SQR, nVision and Crystal Report Customizations using PeopleSoft Query tools.
• Wrote new People code programs to bring new functionalities to the system and also modified the existing People code programs to meet the Business needs of the client.
• Customized/ Restructure PeopleSoft Delivered AE program by adding code and new sections, steps and actions in order to make it compliant for meeting the Business requirement.
• Created new Interface for Bolt-on Applications like Retail Lease Management and International Sales Audit.
• Designed and developed run control pages, Reports and Interfaces for bolt-ons.
• Worked on new interface to receive Electronic Remittance Advices from the customers.
• Provide end-user development support for business users of PeopleSoft Finance.
• Created new Application engine Program for Archival of files.

• Implemented file transfer mechanism, using Secure FTP in support of file transfers both to PeopleSoft from internal systems and external vendors, and from PeopleSoft to clients and vendors.
• Provide Production Support to Peoplesoft Financial Applications, Analyze and Troubleshoot production issues.
• Implemented the AP EFT project. Successfully transitioned the organization’s vendor payment from checks to EFT payments. Customized PeopleSoft delivered EFT sqr processes and the Pay Cycle, Vendor and Voucher pages to alter the default bank defaulting behavior to meet the functional requirements and generate EFT files compatible to the requirements of 2 major banks [TD Bank and Wachovia]
• Design and development of interface with ARIBA and PeopleSoft Payables.
• Supporting, maintaining and troubleshooting GL, AP and Payroll modules. Other activities include detailed documentation of problems and their resolutions with root cause analysis to prevent future occurrences.
• Provided quality assurance on development activity including interface and report development, conversion programming, application configuration and system customization.
• Perform basic fixes and data maintenance.
• Perform problem identification and provide system support in order to resolve the same.
• Troubleshoot and assist users with production support issues.
• Troubleshoot extensively with debug tools like People Code Debugger, People Code trace and SQR logs to analyze the business logic for trapping errors in unit testing and UAT testing.

PeopleSoft 9.1 includes some of the new VAT functionality in terms of reverse charge, intrastat, VAT registration id extension etc. HM Revenue and Customs (HMRC) are concerned that the UK exchequer is currently losing around £2.0 bn a year in lost revenue due to Missing Trader Intra-Community (MTIC) Fund Fraud, otherwise know as Carousel Fraud. To combat this, HMRC are introducing Reverse Charge VAT on specified categories of goods being traded between businesses. The reverse charge will only apply to sales within the UK where specified goods are purchased by a VAT-registered business for business purposes – sales to non-business customers are unaffected by the change, and normal VAT rules continue to apply. Under the reverse charge procedure, the purchaser of the goods, rather than the seller, will be liable to account for the VAT on the sale. The supplier will not charge VAT, but will have to specify on the sales invoice that the reverse charge applies and state the amount of VAT that would have been accounted for. Provided that the purchaser has correctly accounted for the VAT under the reverse charge procedure, he will retain the right to input tax recovery, subject to the normal rules. In order to enable HMRC to ensure that the reverse charge mechanism does not lead to any new revenue losses, there will be a requirement for suppliers to submit a reverse charge sales list to HMRC (similar to EC Sales Lists) listing customer and transaction details where the reverse charge has been applied. This return can only be made electronically, either by completing a web based form or by sending an electronic message to HMRC.

• Worked as a Technical Lead and single point of contact for technical issues.
• Responsible for the creation of Technical Design document in accordance with the Functional Document prepared by the Functional analyst.
• Involved in Design, Development, Unit testing and User Acceptance testing.
• Customized various VAT records and pages to do metadata setup at various levels of VAT Hierarchy to incorporate new functionality.
• Used Data mover scripts to do metadata setup in PIA( PeopleSoft Internet Architecture)
• Modified Application Engine Programs to run batch processes to determine VAT Defaults for sales and purchase transactions.
• Modified Temp and staging tables to determine amount of VAT self assessed by customer.
• Written various algorithms to determine VAT Hierarchy and VAT Amount calculations. Also written peoplecode at Record level, Component level and in Funclib records to determine various VAT default values.
• Worked on Application packages to implement VAT Defaulting and VAT Calculations for various transactions.
• Written various Peoplecode functions and app classes to determine VAT Validation rules.
• Modified various SQL in Application Engine program.
• Created a new report for VAT Report Definition process to identify VAT Reverse Charge Sales List to produce a report which can be filed by HMRC.
• Implemented the feature in eight product lines including Purchasing, Order Management, billing, Receivables, Payables, EProcurement, Asset Management etc and tested feature end to end.

Employer: Confidential,

Responsibilities:
Worked in PeopleSoft Worldwide support group and was responsible for providing post-implementation product support of PeopleSoft Financials 9.0.

• Automatic Bank Reconciliation by generating positive pay file.
• Setup for Vendors, Vendors bank and Customers for tax and payment processing.
• Customization of AP Checks for as per company’s Requirement.
• Configuration and troubleshooting of Paycycle for different payments (EFT and ACH).
• Created run control pages, records, components and process definitions components as per Business requirements.
• Modified and added new SQR reports to add new EFT layout payment codes as per the business requirement.
• Performed various modifications for application engine programs to resolve isssues with Statutory loader process to format journal entries for the statutory reports and load them into the statutory reporting tables.
• Wrote new People code programs to bring new functionalities to the system and also modified the existing People code programs to meet the Business needs of the client.
• Customized/ Restructure PeopleSoft Delivered AE program by adding code and new sections, steps and actions in order to make it compliant for meeting the Business requirement.
• Administration, production and development support, applying fixes and updates.
• Customizing and troubleshooting the production processes.
• Troubleshoot and fix multiple GL/AP issues.

Employer: Confidential,
Project 5:Implementation of PeopleSoft Financials (Payables, GL and Procurement) 8.9 at an international supermarket chain Target.
Duration: Oct 2007 to Apr 2008.

Responsibilities:

• Customization, Support development and configuration of PeopleSoft Financial modules.
• Create Unit and UAT Test Scripts, co-ordinate executions of test plans, develop and maintain quality procedures, and ensure that appropriate documentation is in place.
• Worked in Production Support for Payables. Involved extensively working with the end user and resolving priority level one ticket\'s.
• Extracted data from PeopleSoft system to create SQR Report for synchronization with Third party system for creating vouchers and payments.
• Mapped data for SQR reports to produce a single output file with multiple business units and single EFT Layout and Bank.
• Worked with reporting and information management tools viz. SQR and Crystal Report.
• Modified various SQRs to customize Statutory requirements tracking journal entries, transactional details, journal summary, transactional balances by vendor, accounts etc
• Setup and configured vendor tables as per the business requirement and redesigned European VAT.
• Designed and created various custom applications and reports within implementation using SQR, SQL, Crystal Reports to produce customer reports, payments etc.
• Responsible for creating and modifying Process scheduler job definitions, creating new end user reports and the enhancement of PeopleSoft reporting capabilities using the online and batch reporting tools.
• Troubleshoot extensively with debug tools like People Code Debugger, People Code trace and SQR logs to analyze the business logic for trapping errors in unit testing, system testing and UAT testing.

Project 6: Implementation of India VAT Localization and Sales Tax at Confidential, (PeopleSoft Financials 8.8)
Duration: Dec 2006 to Oct 2007
Responsibilities:

• Involved in documenting the business process by identifying the requirements.
• Participated in design, development and user acceptance testing.
• Prepared Technical specification document for VAT localization and sales tax calculation.
• Effective communication between technical and business team
• Performed various data model changes at the record level to incorporate new fields.
• Modified various VAT pages and impacted products transaction pages to include fields modified at the record level.
• Written peoplecode for various algorithms to match new applicability and other salient features.
• Also written various validations for sales tax calculation and added new error message catalog entries in PSMSGCATDEFN table.
• Written various functions in peoplecode to execute the calculation of Tax.
• Modified Application engine program to make batch process calculation in sync with the online calculations.
• Ensured role based security through PeopleSoft security.
• Due to my wide knowledge in Oracle Financials, I also involved in user-training of Oracle Financials related to Business process and also was responsible for implementing the same.
• Also helped QA to prepare Integration Test Plan which was used by functional team as well as development team for doing a detailed testing on the business application.
• Modified various reports in nVision.
• Post Implementation review and support for all enhancements.
• Received Award of Excellence for this implementation.

Employer: Confidential,
Project 7: Enhancement and Support Development for PeopleSoft Financials 8.8 & 8.9 releases
Duration: April 2003 to Dec 2006
The project involves enhancements and support development activities for PeopleSoft prior releases 8.4, 8.8, 8.9 & 9.0.
Responsibilities:

• Responsible to communicate and coordinate with Global Service Centre in order to analyze and understand the scope of an issue created by the customer in Customer Connection portal .
• Assigning the new tickets to team members and slotting it with correct target dates, build numbers etc as part of Support Development activities for 8.4/8.8/8.9/9.0 version.
• Mentor team members on a regular basis. Respond and act on assigned tasks in a timely manner.
• Participate in weekly project team meeting with counterparts and close the issues arising thereon. Also submit the team status report to IDC Manager and onsite Product Manager.
• Responsible for build and release management activities for PS Globalization module.
• Providing support and guidance to team members and GSC for supported products and to escalate incidents in particular as measured by response with in a 24 hour time window.
• Demonstrate and share knowledge within/across team through formal knowledge sessions.
• Developed SQR reports as well as Crystal reports as per the customer requirement
• Involved in Development, Customization, Unit testing, User Acceptance training and System Testing and Support.