• 7 years of experience in implementing ERP using Peoplesoft 9.XCampus Solutions/Student Administration, StudentFinancial, Financial Supply Chain Modules and Purchasing Inventory modules.
• Experience integrating Peoplesoft with external systems likeSalesforceusing IntegrationBroker
• Extensively worked on Application Engine, PeopleCode and PeopleTools, Process Scheduler, Application Configuration, Peoplesoft Security
• Experience developing custom reports using CrystalReports, SQR , nVisionand XML Publisher.
• Experience in developing Java based web applications using Object Oriented concepts, Webservicesand Javascript.
• Good understanding of Data Warehousing and ETL concepts using Informatica.

Languages: SQR, SQL, PL/SQL, C, Java, JSP, Servlets, HTML, XML, JavaScript

ERP: Peoplesoft 9.0 Campus Solutions - Admissions and Recruitment, Curriculum Management, Student Financials, PeopleSoft 8.4/8.8 Financial Supply Chain Management Modules, Inventory, Purchasing, Accounts Payable and General Ledger Modules,Self Service,SQR, Application Engine, PeopleTools, PeopleSoft Security, Salesforce.com

Databases: Oracle 9i/10g, SQLServer 2005, MS SQL Server2000

Data Warehousing: Informatica Power Center 7.x/8.x Mapping Designer, Mapplets

Reporting Tools: Crystal Reports, OBIEE, Business Objects, SQR, MS-Office

Web: Apache, Tomcat, JSP, Webservices, Javascript

Operating Systems: Windows, DOS, UNIX, Linux

Confidential

Role: PeopleSoft Application Programmer

• Configure Communication Codes, Category, created query, created Email templates using XML Publisher, created mappings between queries and XML Publisher.
• Automated the process of comments and remarks generation for the Academy Resource Center by creating SQRCode and developing UI Components using Application Designer.
• Improved Process Scheduler performance by using XML Publisher, for customization of Academic Advisement Report and Transcript Report.
• Created PeopleCode to export Student Transcript data from Peoplesoft to Salesforce using Webservices.
• Performed Search Match for Student Leads in Peoplesoft for data obtained from Salesforce using Integration Broker
• Generated UI components using Application Designer and PeopleToolsto support Student Transcript creation in Peoplesoft system.
• Created various reports and customized various reports and pages for Finance department using Crystal Reports
• Implemented Peoplesoft Security by creating Users, Assigning Roles and Permission Lists. Also implemented Row Security. Also implemented Peoplesoft Query Security to control access to queries.
• Worked on the process that synchronizes data between student financials and finance department.
• Creating and modifying various SQRand Crystalreports for student records department like attendance reports and for online, onsite students or for international and domestic students.
• Collaborated with end-users, collected requirements, analyzed and provided technical implementation.
• Supported the application in Production and Test environments for high availability and integration testing respectively.

Confidential

Role: Techno-Functional Analyst.

• Involved in the implementation of Peoplesoft 8.8 General Ledger, Accounts Payable, Billing and Accounts Receivable modules of the client. As a techno-functional analyst was responsible for the following
• Configured General Ledger, Billing and Accounts Receivable modules as per the new requirement.
• Executed data integrity reports DDDAUDIT, SYSAUDIT and ALTERAUDIT and fixed anomalies that were surfaced in these reports.
• Developed new object and new pages and enforced new PeopleCode for new ACH payment details information in Accounts Payable Module.
• Created various critical queries in Accounts Payable modules to identify if there are any data related omissions with regards to vouchers and payments information.
• Created reports for business users using PS Query and SQL. Worked directly with clients to develop and/or refine monthly billing statements/invoices and related summary reporting.
• Responsible for the design and functional training for Accounts Receivable, AccountsPayable, General ledger, Billing.
• Created a process for effective receivable collection by generating weekly reports for business partners.
• Prepared and conducted Unit Test and Integration test cases and conducted code review.
• Designed workflows for PO and Payables system using Virtual approval and email capabilities.
• Responsible for developing reports using Trees, nVision, SQR and Crystal. Used Datamover to run various configuration scripts.
• Resolved various production issues in Requisition Loader Process and PO creation process for replenishment items.
• Responsible for setting up of control set up information that include new chart of accounts, Calendars to process the year-end financial statements. Ran various reports for business users for financial year closing using time spans and calendars.
• Created various new SQRs and modified existing SQRs as per the requirements of the business users. Customized Pay cycle managers to add new processes in the pay cycle. Resolved various issues related with payroll interface with GL.
• Resolved various issues related to data issues in PeopleSoftInventory, Purchasing and AP modules.
• Worked on creating Tabular and Matrix Layouts using PeopleSoftnVision Reports.
• Worked extensively in Application Engine in resolving various process-related issues.
• Developed various panels and PeopleSoft objects to suit the business process requirement. Worked extensively used PeopleCode to enforce functionality.

Confidential

Role: Trainee Software Engineer/ Peoplesoft Developer

• Involved in first level customization of PeopleSoft Financial Accounts Receivable, Accounts Payable, Inventory and Purchasing .
• Executed Data entry reports DDAUDIT, SYSAUDIT and ALTERAUDIT and fixed anomalies that were surfaced
• Involved in the Study of requirements, Design of the Financial System, Establishing the Business Rules, System Testing of the Business Processes.
• Extensively worked on creating Workflow, Application Engine, and Tree Manager for Chart fields, Summarization and Consolidation and Query.
• Creation and installing Peoplesoft Internet Architecture, Web server and PeopleSoft application.
• Responsible for running various DMS scripts in boot strap mode as a part of preparation for the installation of PeopleSoft
• Played a partial role of System Administrator in maintaining App Server and Process Scheduler Server.