PROFESSIONAL SUMMARY

• Strong technical PeopleSoft resource with over ten years of experience in PeopleSoft Application Design, Development, Upgrade and Support using People Tools including Component Interfaces, Integration Broker, Application Engine, Application Packages, AWE on Oracle, DB2 and MS SQL Server databases.
• Expertise in PeopleSoft 9.1 and PeopleTools 8.52.
• Served as a Technical resource on PeopleSoft HCM and CRM modules as well as Financial modules.
• Utilized Integration Broker for third party integration with PeopleSoft using XML, SOAP and WebServices.
• Wrote Application Packages, created new Component Interfaces, used delivered interfaces.
• Worked on AWE Customizations, implemented processes using AWE batch approvals.
• Developed and maintained reports using XML Publisher.
• Worked on several Interfaces from HCM to external systems.
• Supported day-to-day operations by analyzing and resolving production issues.
• Strong experience in building SQL Queries and adhoc reports.
• Excellent skills in Performance Tuning of Applications.
• Worked on several bolt-on customizations and interfaces for Global Payroll, Treasury interfaces, Benefits, Payroll, eCompensation, ePerformance, HR,Time Labor, Absence management, MSS and ESS modules.
• Experienced in CRM with strong technical knowledge in using CDM classes and BORM model.
• Worked on components in CRM like Customer, Company, Worker, Sales, Order Capture, Help Desk Modules.
• Possesses skills utilizing Java Script, IScript, AWK, UNIX scripting and Ruby.
• Excellent written and verbal communication.

TECHNICAL SKILLS

• PeopleSoft 9.1
• Integration Broker
• CI/App Packages
• PeopleCode
• Workflow incl. AWE
• Data Mover
• Application Engine
• SQR
• PS Query
• STAT
• PHIRE
• JAVA
• Core Java
• XML/SOAP AppMessaging
• ADF
• PL/SQL
• SQL
• Unix Scripts

ERP: PeopleSoft latest version worked on 9.1 Tools 8.52

MODULES: HCM HR,Global Payroll, Payroll, Time Labor, ePerformance, eCompensation, eProfile CRM Sales leads, Opportunities and Order Management , ELM

PROFESSIONAL EXPERIENCE

Confidential

PeopleSoft Consultant

• Work on Customized AWE approval processes.
• Develop Interfaces for Treasury.
• Work on Treasury-GL Reconciliation Interface and set up Deductions/Earnings for Global Payroll along with the supporting elements.
• Develop new components to support organization specific functionality.
• Customize components.
• Develop Reports using PS/Query, XML Publisher.
• Utilize custom and delivered component interfaces to process online and batch data.
• Create Application Packages, and common classes to optimize and standardize code.
• Provide production support.
• Participate in upgrade tasks and full-cycle implementation of custom modules.

Confidential

PeopleSoft Consultant

• Implemented AWE framework for Time and Labor and Absence Management.
• Created Custom batch program for AWE Timesheet approval, Absence from Timesheet and Absence from Absence Request page approvals.
• Created batch load program to convert leave balances from mainframe to PeopleSoft AM tables.
• Supported go-live and worked on issues and change-controls identified during project implementation.
• Worked on Smart Load process to load eComp Salary Planning Amounts to Job Data along with custom validations and reports.
• Worked on Changes to interfaces due to implementation of a new Company code.

Confidential

PeopleSoft Associate

• Implemented ePerformance/eTime,HR-JAMIS,HR, Payroll interfaces, T L and bolt on eCompensation modules among other customizations.
• Involved in the design, development and support of Integration projects. eg. Taleo To HR, Equity OutSourcing, ESPP, HR-ELM, Thirdparty LMS to ELM, Demographic interfaces etc.
• Implemented customizations to T L /Absence Management modules at BAH.
• Worked on Data conversion by uploading third party eTime data into PeopleSoft T L.
• Worked on design and development of a bolt-on Leave Administration Module.
• Developed a custom process to bring in data from legacy application and calculated the computed Absence Results for payroll.
• Developed custom code to apply business in calculating PTO balances, absence types based on employee schedules and groups.
• Developed adhoc reports and worked with DW team to map PS fields to the data coming from different sources for analysis and reporting purposes.
• Developed several App Engine Programs eg. mass Job load, Salary Payout process etc , used CI's and App Packages.
• Developed and maintained SQR's.
• Provided production support.

Confidential

Technical Consultant, PeopleSoft CRM/Financials Integration

• Designed and developed architecture for integrating PeopleSoft HCM/CRM with Legacy applications.
• Worked on customized CASE components.
• Developed Application Packages for the Request, Response, Product and Case Objects.
• Designed pages to display XML and Error logs from legacy applications.
• Created Cases using Asynchronous messages.
• Made Synchronous calls to Legacy systems supported by Java web services.
• Included Retry capability based on business rules.
• Implemented Fraud detection and Business functionality to support that.
• Wrote Test Cases and provide Production Support.
• Delivered data for Reporting.
• Implemented XML schemas with support for SOAP.
• Implemented Data Conversion projects to load data from legacy systems to PS Financials AP/AR modules.

Environment: Environment: Oracle 9.2, PeopleTools 8.45- Integration Broker, Application Packages, Application Engine, Component Interfaces, Application Designer, Process Scheduler, Security, Data Mover, PeopleSoft 8.9,XML Spy, Aqua, Toad, Test Director.

Confidential

PeopleSoft CRM/HCM, Technical Consultant

• Created an interface to integrate Contractor data from HR to CRM using Application Engine and Component Interfaces.
• Created New App Engine programs to run batch processes.
• Created new Component Interface with Customized attributes.
• Developed reports based on Support module.
• Customized Workforce/Support/HRHelpDesk/Employee SelfService Component /Pages with Client-Specific fields.
• Created New Application Packages to simplify running reports.
• Designed/Developed/Implemented and Maintained CRM Support related applications and Customized Employee Relations Application in HR.
• Created queries for end-user use and Create reports using Crystal reports.
• Developed DMS scripts for migrating customizations.
• Provide Production Support.
• Interacted with End users and Management to gather functional requirements and design technical specs.
• Co-ordinated with the DBA team in applying Patches and migrations.
• Analyzed Database and work on Tuning SQL for better performance.
• Performed Defects management using Test Director.

Environment: Oracle 9.2, PeopleTools 8.44- Application Engine, Component Interfaces, PS/Query, Application Designer, Process Scheduler, Security, Data Mover, PeopleSoft 8.8, Aqua, Toad, Test Director.

Confidential

PeopleSoft HCM/CRM- Support Module Integration Technical Consultant

• Customized the SOAPTOCI message for integrating PeopleSoft data with an external Visual Basic Interface.
• Generated Synchronous messages in response to requests from external Applications.
• Created new Component Interfaces that could be invoked from external applications.
• Supported maintenance and customization of Application Engine programs.
• Customized Support module- Helpdesk component to include new attributes.
• Designed/Developed and Implemented the custom PeopleSoft application.

Confidential

PeopleSoft HCM/CRM Customization Technical Consultant

• Responsible for creating new PeopleSoft objects such as Menus, Components, pages, records using Application Designer.
• Wrote the Interface Programs by using the SQR and Application Engine.
• Worked extensively with Component Interface-used the delivered interfaces and create new thin component interfaces for integration with external systems.
• Exposed Component Interface methods as web services to external systems.
• Modified the existing objects like Components, Pages, Records and Menu definitions.
• Involved in customizing the Customer, Company, Worker, Relationship and Sales components to meet the client's requirements.
• Developed In-bound, out-bound interfaces for Accounts Module.
• Involved in creation and maintenance of Roles and Permission list for all PeopleSoft account users in the CRM system.
• Involved in Setup and customizing Integration Broker.
• Developed Standalone Pages for Company Internal use.
• Wrote new SQR's and modifies the existing ones for different Reporting Purposes.
• Wrote Batch Interfaces in SQR's to execute in Different Scheduling timings.
• Wrote the application logic's to consume Client delivering XML files.
• Developed SQC's for centralized Application Logic Development Environment.
• Involved in Integration of Crystal Reports with Process Scheduler.
• Wrote SQL Queries with different conditions, relations and criteria.
• Developed Stored Procedures, Views and created Index on the table for fast execution of SQL Queries.
• Involved in Tuning SQL Queries for Faster Execution of SQL's.
• Worked extensively on integration of CRM components with Third Party applications using XML/SOAP protocols.
• Designed applications using Component Interfaces and Application Engine.
• Proficient in using Object Oriented Programming and in writing Application packages.
• UtilizeTest Director for defects management.
• Worked on Production Support team. He has good analytical skills in resolving defects.

Environment: PeopleSoft 8.8 CRM, PeopleCode, Application Engine, Component Interface, Integration Broker, Work Flow, SQR, Data Mover, DB2, UNIX, Windows XP.

Confidential

PeopleSoft CRM 8.8 Order Management Implementation and Maintenance Technical Consultant

• Designed Technical Specification, for Order Management to suit the client's specification.
• Involved in Design and Development of the Customizations on Opportunities, Order and Quote components.
• Updated RO CAPTURE CI and created new component interfaces to meet business requirements.
• Wrote new SQR's and modified the existing ones for different reporting purposes.
• Involved in preparing the Fit/Gap Analysis for the Upgrade project.
• Developed Business Process Maps and had setup WorkFlow to fire on different events.
• Wrote PeopleCode as per the requirement on different events to implement the Business rules and validations.
• Performed adhoc queries using PS/Query and Developed Crystal Reports as per user requirements.
• Wrote new reports using Crystal Reports.
• Performed data conversion from legacy system to PeopleSoft.
• Provided post implementation support.
• Modified and developed Application Packages.
• Implemented SOAP interface to integrate external system with the Quote component.

Environment: PeopleSoft 8.8 CRM, People Tools 7.5-8.3, Application Designer, Component Interfaces, People Code, Application Engine, Data Mover, Work Flow, Security, SQR, Oracle 8.x

Confidential

Implementation and Maintenance

• Performed conversion of pages, SQR's and GUI to the new PeopleSoft Environment in version 8.4.
• Developed interfaces between TIMS and PeopleSoft Expenses.
• Developed a number of SQR's according to user requirement.
• Modified and created PeopleCode on record fields to implement business functionality.
• Performed testing and Production support.
• BRS and TIMS are customized applications supported on ASP and PeopleSoft.
• Involved in HR, TIMS and BRS design, implementation and maintenance phases.
• Worked on Web Self Service Kiosk for BRS It is available as PeopleSoft module and also as ASP module on intranet.
• Created Query definitions, Process Scheduler definitions, defined Security used Application Designer extensively.
• Worked on UNIX scheduling using Maestro and created and ran MERCATOR interfaces. He has developed UNIX scripts as per the client's needs.
• Utilized Toad and SQL extensively to connect to the Database on Oracle, Remedy for Production Support, and Application Messaging to asynchronously update Expenses data from TIMS and Vice Versa.
• Utilized Application Engine and new File Objects to interface with text files.
• Wrote Unix shell scripts to create and upload to reports to the Department's web sites.
• Exposed PeopleSoft Components to external systems using Component Interfaces.
• Built web based PeopleSoft Employee Self Service Paycheck and Loan Summary and Detail Web Applications.
• Employee Self Service Web Site User authentication ASP, MTS COM, Visual Basic .
• Worked extensively on SQR reports to present data in user requested formats and also exported files to Excel.
• Created complex queries to summarize data which are used as views on which reports are based.

Confidential

PeopleSoft HR/Payroll/Time Labor/Benefits Implementation Technical Consultant

• Modified PeopleCode for existing panels and extensively used all administrative and development tools. Has thorough process flow and functionality knowledge of all the HRMS modules.
• Assisted in implementation of eBenefits and eProfile, the self-service product modules for HR.
• Customized the records, panels etc, using Application Designer to fulfill the customer requirement.
• Developed and customized various HR and Payroll interfaces and created adhoc reports using SQR PS/Query and Crystal Reports.
• Created security classes for operators for Payroll menus.
• Generated reports related to employee job details, absence history, and scheduled the programs to review the absence details of employee periodically.
• Generated Payroll reports pertaining to employee YTD balances, Loans, general deduction details.
• Customized reports pertaining to employee benefits/deductions contributions for benefit plans.
• Utilized Peoplecode, to implement check constraints and business rules at various levels of human resources application panels.
• Developed MassChange definitions for updating the database for changes in Dept, Employees tables.
• Transferred Data from COBOL flat files to PeopleSoft tables using SQR and Import Manager.
• Used Crystal Reports to create various drill down reports for department employee salaries, Salary admin plans and employee checklists, and created various business processes for operators in Payroll applications.
• Extensively used DataMover to push the development modules into production environment and for updates and fixes.
• Used Process Scheduler to schedule SQR's and the program modules which were developed using Application Engine.

Environment: PeopleSoft HRMS 7.5/8.0, PeopleTools, Process Scheduler, Crystal Reports.