PROFESSIONALSUMMARY:

• About 9+years of experience in PeopleSoft application development, customization, Upgrade & Support of Campus, Financial and HCM Applications.
• Experience in versions 8.8,8.9,9.0,9.1 providing functional support in various modules in PeopleSoft Campus (Student Admissions and Recruiting, Student Financials, Student Records, Campus Community, Graduation) Financials and Supply Chain including (AM, AP, AR, BI, PO, and GL)
• Proficient in gathering business requirements, creating functional design documents, test scripts, training materials, User Manuals, and conducting unite test, system integration test and user acceptance test (UAT).
• Proficient in setting up, configuring and troubleshooting issues using a methodical and analytical approach to problem solving and focused on end user satisfaction.
• Involved in Design, Development, Debugging, Troubleshooting and Testing of PeopleSoft Applications.
• Expertise in managing the complete SDLC gained functional skills in analyzing the client requirements translating new ideas into clients’ solutions including requirements development, delivery, support analysis and documentation.
• Experience in the analysis of Business processes, setups, and report customization, upgrades, data conversion from Legacy Systems to PeopleSoft application databases, writing interface programs, testing, and trouble shooting and providing online support
• Expertise with development Tools Application Designer, Application Engine, People Code, Scheduler, Process Monitor.
• Strong on Reporting Tools like SQR, Crystal Reports, PS/Query, XML/BI Publisher and PS/nVision.
• Expertise in PS Administration, Unix System, SQL and Oracle Tuning.
• Production support, Troubleshoot/Debug processes, Performance Tuning and fixing data/code issues in DEV/TEST and migrating to PROD.
• Experience in usage of Change management tools like STAT 5.3.1, 5.5 and Phire.
• Experience in using Oracle SQL, PS Queries, proficient in TOAD/SQL developer tools. 
• Experience in Conversion and upgrade of PeopleSoft Applications.
• Good experience in maintaining SLA.
• Strong documentation and written presentation skills, and developed various functional and technical specifications with Test Plans and Procedures.

TECHNICAL SKILLS:

PeopleSoft Modules: PeopleSoft Campus Solutions, PeopleSoft Finance (AM, AP, AR, BI, PO, and GL)

Development Tools: Application Designer, People code, Application Engine, Component Interface, Data Mover, AWE.

Reporting Tools: PS Query, SQRs, XMLP

Databases: Oracle, DB2 9.X, MS Sql server

Languages: People code, SQL, Oracle SQL/PL - SQL, JAVA, C

Source Control Tool: Maestro, HPQC

Version Control Tool: STAT

Operating Systems: UNIX, Windows NT, Windows 9x/2000, XP and Windows 7

PROFESSIONALEXPERIENCE:

Confidential, Sanjose, CA

PeopleSoft Upgrade Specialist HR/CS 9.2

Responsibilities:

• Extensive experience working with People Tools, People Code, Application Designer, Application Packages, Application Engine, Component Interface, File Layout, Application Messaging, Integration Broker, Security, Tree Manager, PS Query, Data Mover, Import Manager, Workflow (AWE), Upgrade and Change Assistant, SQR, Crystal Reports and XML Publisher in Student Financials, Student Admissions.
• Involved in PeopleSoft upgrade and split of CS and HR from 9.1 to 9.2 and performed several customized retrofits and moved the processes as per the requirement.
• Converted multiple reports from Crystal to BI Publisher reports as part of 9.2 upgrade.
• Involved in new business requirements has to be implemented in the new system and as well identified the unused customized objects which are needs to archived by file back up
• Configured the Integration Broker in the new instance and had identified the messages which are needs to be sync in both HR and CS applications such as personal data, email, visa information.
• Modified several old crystal reports to Bi Publisher Reports as needed
• Weekly meetings with the stake holders and users on the tickets in the Red mine server on the work completed
• Involved in user training for the latest technologies like fluid and other features.

Confidential, Washington, DC

PeopleSoft HCM Analyst

Responsibilities:

• Development Upgrade and Customization of PeopleSoft 9.2 HCM (Core HR, Payroll, Benefits, Benefits Administration Time and Labor, Talent Acquisition Management, ELM and Self-service modules)
• Analyzing the existing functionality of PeopleSoft HCM application and the customized objects used in PeopleSoft HCM 9.2.
• Played key role in Development of Interfaces, Online Customizations using SQR's, People Code, Integration Broker, Component Interfaces and Application Engine for People Soft HR, Payroll, Benefits, Time&Labor, Talent Acquisition Management, ELM and Self-service modules.
• Involved in analysis, coding, unit testing and review of the requests in the project.
• Developed and customized PeopleCode, Pages, Components, Component interfaces, Application engine, Approval workflow engine (AWE), Integration Broker, Application Packages. Worked extensively with configuring Integration broker between PeopleSoft financials and HR application including setting up page out if any channel is stuck or in error.
• Configured Unions for Multiple Bargain Agreements in Time & Labor Administration.
• Created the Templates/Approvals/Integration settings in TAM.
• Configured screening the applicants based on the Profile and experience and questionnaires in TAM.
• Created hiring the applicants via Managed Hires and Template based hire.
• Hands on experience in creating the Resume/Job Opening/Interview Evaluation/Recruitment and Job Posting Templates.
• Hands on experience in creating outbound interfaces to send the Job Requisition information to the Third party recruiting vendors.
• Involved in Upgrade from 9.1 to 9.2 did compare report and performed retrofit as needed.
• Involved in Branding for Classic and fluid implemented as requried
• Setups of Extended Leave Templates and configuration of extended leave calculation rules for client's FMLA, Maternity, Worker's Compensation and Infant Care leave types.
• Configured request approval functionality, including multilevel approvals and alternate approvers using Employee Self Service, Manager Self Service and Approval Workflow Engine.
• Setup and Configured Integration Broker and trusted nodes for PeopleSoft single sign on.
• Designed and developed various customizations based on Integration Broker Class and SOAP and XML Doc.
• Configured and Setup Integration Broker for retrieving real time data from the legacy/source systems.
• Automated Leave Donation, Leave Receipt, and Leave Return administration processes.
• Customization of batch programs, reports & interfaces. Involved in Implementation and Customization of employee self-service (ESS) modules such as eRecruit, ePay and eProfile. 
• Worked on integration PeopleSoft ELM & HCM using integration broker.
• Integration of Absence Management to Time and Labor to enable the processing of time information and to generate payable time data that is subsequently loaded into Payroll for North America and third party payroll interface.
• Also helped modify and debug some existing previous SQR Payroll reports and making updates for new business needs.
• Designed test plans and approach to validate complex Time and Labor, Absence Management business rules
• Involved in preparation and execution of the test scripts and performed Unit Testing.
• Used Quest Stat application change management tool to lock the objects while developing and used it for migrations.
• Developed PS Queries to generate a report so that users can run on demand showing a summary of the Order Fulfillment Status for a Business Unit.
• Modified delivered Direct Deposit Self-service pages to add custom validations.
• Created SQR Conversion program to assign Balance row for all active direct deposit employees.
• Modified delivered W4 Self Service page to include State and Local Tax capability.
• Designed and developed Application Engine program to sync PeopleSoft User Profile and Active Directory based on Application Engine/Web Service/Component Interface.
• Created Messages, Queues, Services, Service Operations, Nodes in Integration Broker.

Confidential, Waltham, MA

Sr Techno-Functional Consultant

Responsibilities:

• Worked on various customizations in Admissions, Student Records and Financial Aid.
• Developed Web Services, Services, Service Operations using CI IB Technology
• Developed and implemented data mapping templates and the mechanism to assist in legacy system data clean up and data mapping.
• Defined Security matrix templates to define the roles, responsibilities and permission lists for Users and then uploaded in the system using SQL scripts.
• Designed and developed data sources using File Layouts, connected queries and PS-Queries by analyzing the existing SQRs and crystal reports.
• Designed and developed complex BI Publisher reports using the SQL and XSL functions
• Customized in Student Admissions module and created new Components to cater the student Selection, ranking and enrolment of the student based on Academic Score and availability of Course.
• BI/XML Publisher report was developed to generate the Admission Offer Letter based on Admission action And appropriate letter will be sent to the students.
• Worked on Financial Aid modifications to create custom process to update student financial aid term campus. Also, worked on custom process to calculate budget durations based on the student fa term entries. Worked on update packaging variables which are used for conversion and every year updates for packaging variables in bulk. This process is created to run using flat file or based on query.
• Also involved in creating various documentations like Department security tree migration
• and processing documentation for various modifications
• Integration of PeopleSoft CS with LMS using Integration broker for active courses for employees and Students.
• Wrote documentation, trained users and production support for fluid interface.

Confidential, Pullman, WA

Sr. Techno-Functional Consultant

Responsibilities:

• Developing, modifying a variety of PeopleSoft-delivered and custom Campus Solutions modules with bolt-on using Applications Engine, People Code, Component Interface.
• Interaction with the various stake holder (including functional teams) for the requirement analysis, designing and implementing enhancements as per the business requirements
• Integration between PeopleSoft and non- PeopleSoft applications.
• Preparing the Technical Design document for the changes incorporated in the code.
• Developing unit test plans for the module.
• Involved in Unit testing and Functional Testing.
• Creations of Release Notes Document & Object

Confidential, Houston, TX

Technical Consultant

Responsibilities:

• Analysis of Requirements to ensure technical Feasibility.
• Conversion of legacy system to PeopleSoft.
• Customizing the delivered CS module like Admission, Student record by writing people code and designing new page, component according to requirement of client.
• Preparing the Technical Design document for the changes incorporated in the code.
• Developing unit test plans for the retrofitted SQR and Application engine.
• Involved in Unit testing and Functional Testing.
• Fine-tuning of the queries by Analyzing and applying indexes.
• Creations of Release Notes Document & Object

Confidential, Lawrence, KS

PS Technical Consultant

Responsibilities:

• Extensively Involved in Study and Designing of Exam Modules like Student Assessment, Exam Scheduling and Remarking.
• Developed end to end functionality of Manage Exams module.
• Worked of requirement gathering and design of student graduation module.
• Users can review and update the student Course Work and Mark entry for each term.
• Separate processes are written to cater the complete security setup for the Module.
• Created the components to setup Exam station and Invigilators.
• New reports are implemented to display Student Course work and Student Individualized Time table.
• Created a new bank setup for the students to store their Debit bank account and credit bank account separately in SF.
• Create a new interface to upload payments and charges from different banks and then posting the payments and charges to the Student Account.
• Complete point of contact for Data conversion for active and historical data.
• Provided templates to clients requesting the historical data and mapped them according to the business rules in the new system.
• Created new programs and interfaces to validate, load and verify data in the new system.
• Assisted in implementing the new CS system by creating the required integrations.

Confidential

PO-AP Technical Consultant

Responsibilities:

• Involved in the design of new pages, component.
• Worked on PO, AP and Billing Modules.
• Developed Voucher register and GL Archival in SQR.
• Developed the interface between PeopleSoft and third party inventory management system (Viaware) for Inventory adjustment, Demand Acknowledgment, RMA, Receipt and Expected Receipt.
• Using FILE LAYOUT Definition wrote Application Engine Programs to Import data from flat files to PeopleSoft database.
• Analyzing third party system/application data which was loading PeopleSoft staging tables and loading in PeopleSoft production environment application/transaction tables using Application Engine programs.
• Customized various Records, Pages and Components according to the client’s requirements using application designer and also created few new pages
• Worked on the XML publisher reports to generate Invoice layouts.
• Extensively used People Code, Application Engine, SQL and SQR. Custom Process using Application Engine which will generate outbound file from PeopleSoft HRMS with In-active employee details across the organization which will be transferred to Finance for process of payroll and provident fund termination.
• Developed complex SQR reports and SQCs to suit the business requirements of the company.
• Involved in customizing the items by issue inquiry, PO inquiry, and stock request inquiry pages.
• Worked with Application Designer to add new records, pages, and added People Code as required.
• Handling of Production issues and resolving them with quality within the specified deadlines