PROFESSIONAL SUMMARY

• Overall 16 twelve years of IT experience
• Over 13 years of experience in the Implementation, Design, Development and testing of PeopleSoft HR/Campus Solutions/FSCM.
• 3 years of experience in various Web Based Applications, Client / Server Applications.
• 4 years of Functional domain experience in areas of Finance / Accounts, HR Administration.
• Good interpersonal skills and a team player.

TECHNICAL SKILLS SUMMARY

ERP: PeopleSoft FSCM 9.0, 9.1, 9.2

PeopleSoft HCM 7.5, 8.x, 9.0, 9.1,9.2

PeopleSoft CAMPUS SOLUTIONS 9.0

Languages: SQL, PL/SQL, SQR, C, and VB 5.0/6.0

Web Services: HTML, DHTML, XML DOM/SAX and ASP, JDeveloper, SOAP UI.

Scripting languages: Java Script, VBScript

Development Tools: People Tools, PeopleCode, and Visual Interdev

People tools: Application Engine, Component Interface, Integration Broker, Workflow, Excel to CI

Reporting Tools: SQR, PS Query, Crystal reports, PS/nVision, Actuate e-report, XMLP/BI, OBIEE.

Management Tools: Import Manager and Data Mover

Databases: Oracle 8i, SQL Server 7.0, MS Access

Operating systems: MS Windows 95/98/2000/ NT 4.0, MSDOS, HP UNIX

PROFESSIONAL EXPERIENCE

Confidential

Tech Lead

Responsibilities:

• Working on Integration Broker. App messages, consuming and providing web services .
• Building the new environments. Running Interfaces, deciding on scheduling jobs, Fixing Security, Making sure of all the migrations happened correctly, Smoke testing and fixing any issues arising out of these actions .
• Conversion of data from Legacy system using Application Engine, File Layouts CI.
• Reports customization and Development using SQR BI Publisher.
• Responsible for testing and signing off Design and Code.
• Attending workshops with business and creating functional design documents.
• Extensively work with clients closely to understand the Business and processes.

Environment: PeopleSoft FSCM 9.1 Windows, People Tools 8.52, SQR, Oracle, XML Publisher, JDeveloper, SOAP UI

Confidential

Tech Lead

Responsibilities:

• Worked on App messages and consuming and providing Web services.
• Used SOAP UI and JDeveloper for testing and creating now rowset messages.
• Performed customizations on delivered business process and also new enhancements using People Code, AE and CI, SQR
• Attended client meetings and gave presentations of the work done and resolve any critical production support issues. Identified the functional Gaps, Customization lists, Impact analysis of customizations.
• Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process.
• Worked extensively in XML reports.
• Worked on Web services and App messages.
• Created and modified reports using XML/BI publisher.
• Developed queries that can be used by the testing team and functional users.
• Developed query based XML reports.
• Scheduled all types of reports and jobs using process scheduler and monitoring the status of the jobs.

Environment: PeopleSoft HRMS CS 9.0 Windows, People Tools 8.50, SQR, Oracle, XML Publisher

Confidential

Reports Lead

Responsibilities:

• Reports Lead and directing the project teams in-terms of business processes, gathering requirements and involved in creating Fit-Gap analysis and Functional/Technical Design Documents. Process of completing the development of a large and complex reporting system for the AEP through XMLP, SQR, PSQUERY and some of GL reports in nVision.
• Created and customized SQL queries which are used in XML/BI publisher.

• Extensively worked on Workflow development.
• Worked on developing Pay Process Table for running the Off/On cycle payroll and creation of Run Control card for Pay calc, Pay Confirm, Pay Sheet and Time Admin Process.
• Responsible for writing, tuning and debugging the PeopleCode, SQR and Application
• Engine.
• Created interfaces using SQR, Application engine and Component interface.
• Used Process Scheduler to schedule SQR, Application Engine, PS-Query and Crystal reports.
• Extensively used Application engine, SQR and PeopleCode for new development.
• Worked on Application Designer to customized Run Control Pages and Menu, developed new process definitions and attached to PeopleSoft system.
• Customized SQR reports in AR, BI like Detail Aging Report, pending items, Invoice details.
• Defined Ledger Templates, Ledger Groups and Speed Types for journal processing.
• Provided troubleshooting support for the Journal Generator process
• Tuned the performance of the SQR reports using SQL, Stored Procedures and Temp Tables.
• Documented internal processes, procedures.
• Environment: PeopleSoft HRMS 8.9 and FSM 9.0 Purchasing, AP and GL Windows, PeopleTools 8.47, SQR, SQL server 2008, Crystal reports.

Confidential

RICE Lead

Responsibilities:

• Involved in Design, Development, Testing, and Enhancement of PeopleSoft HRMS for HR and NA Payroll modules.
• Created and modified Components, Pages, Records, Fields, Process Definitions and registering Components in Portal, Menu and Permission Lists.
• Attended client meetings and gave presentations of the work done and resolve any critical production support issues. Identified the functional Gaps, Customization lists, Impact analysis of customizations.
• Used Process Scheduler for setting up the reports to run in batch process and Process Monitor to supervise the status of processes and reports.
• Worked in developing and customizing complicated Portal Pages using multiple level scrolls and derived records.
• Tuned SQL/SQRs to improve performance using advance features like Load lookup and Arrays.
• Worked on Application Designer to customize Run Control Pages and Menus, developed new process definitions and attached to PeopleSoft system.
• Customized the existing interface programs for the HR to send flat files to various vendors for employees enrolled in different medical and dental plans.
• Tested the end-user desired output and application functionality.
• Developed various PS queries in order to help the client day-to-day activity.

Environment: PeopleSoft HRMS HR, NA Payroll, Benefits 9.0, People Tools 8.50, Application designer, People Code, Component Interface, PS-Query, SQR, Application Engine, Oracle 9i.

Confidential

Technical Lead

Responsibilities:

• Responsible for writing, tuning and debugging the PeopleCode, SQR and Application Engine programs.
• Created interfaces using SQR, Application engine and Component interface.
• Used Process Scheduler to schedule SQR, Application Engine, PS-Query and Crystal reports.
• Developed a process for mailing the employee paychecks if employee transferred temporarily and made changes in all SQRs impacted by the new process.
• Developed a process for holiday pay using SQR as per the company rules and requirement.
• Developed an Interface using SQR for telephonic enquiry by employees for their latest paycheck and payroll information.
• Worked in developing and customizing complicated Portal Pages using multiple level scrolls and derived records.
• Customized Order entry pages using Peoplecode for incorporating sales person information and accepting the orders in subject to the due dates criteria for specific product groups.
• Extensively used Application engine, SQR and PeopleCode for new development.
• Worked on Application Designer to customized Run Control Pages and Menu, developed new process definitions and attached to PeopleSoft system.
• Customized SQR reports in AR, BI like Detail Aging Report, pending items, Invoice details.
• Defined Ledger Templates, Ledger Groups and Speed Types for journal processing.
• Provided troubleshooting support for the Journal Generator process
• Responsible for develop a process for Automatic termination of employees.
• Responsible for customized the application like creating the new records, fields, pages, components and menus using application designer.
• Tuned the performance of the SQR reports using SQL, Stored Procedures and Temp Tables.
• Documented internal processes, procedures.

Environment: PeopleSoft FSM 8.8 AP, AR and GL Windows, PeopleTools 8.47, SQR, SQL server 2008, Crystal reports.

Confidential

Module Lead

Responsibilities:

• Involved in online changes to the delivered pages, components, menus and translate values.
• Modified, designed, configured and built fields, records, sub records, setting up keys to records, assign table edits like prompt table
• Involved in Design, Development, Testing, and Enhancement of PeopleSoft HRMS application modules
• Customized SQL Views, records and People Code functions like SQL Exec, Scroll Select etc.
• Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process
• Active role in changing the SQRs as per the business requests from the users
• Developed number of inbound-outbound interfaces using SQR to read the data from file and load it into PeopleSoft tables and send data from PeopleSoft to other external applications
• Developed SQR programs to create Time Load to pay sheets, employee pension plan data.
• Involved in Data mapping for legacy data conversion
• Developed an application engine program using File Layouts to load New Hire interface file with all New Hired employees' information after each day and load them into the people soft tables
• Involved in acquiring Specifications from the functional team and modifying the SQR's as per the specifications
• Used process scheduler for scheduling recurring process, for conditional Scheduling of successive process, for setting up the reports to run at specific time and implementation of batch processing
• Involved in Unit testing of people soft delivered and modified functionality customized SQR programs in HR, Benefits and Payroll Modules
• Conducted meetings with the Users and the testing team and involved in discussing their problems and helped them out in finding the proper solutions for their requirements

Environment: PeopleSoft HRMS HR, NA Payroll, Benefits 9.0, People Tools 8.50, Application designer, People Code, Component Interface, PS-Query, SQR, Application Engine, Oracle 9i.