Summary

PeopleSoft Certified PeopleTools professional.

• 10 years of experience as Technical consultant in implementation, Customization, Upgrades, Testing, Maintenance and Production Support of PeopleSoft HCM, CRM and EPM systems.
• Developed and modified PeopleCode to implement specific business rules and validations to enable the PeopleSoft system to perform the business process.
• Proficient on PeopleTools such as Application Designer, Component Interface, Application Engine, Integration Broker, Data Mover, PeopleSoft Query, Process Scheduler, Application Package, Process Monitor and Tree Manager.
• Have Good understanding on BORM, Customer Data Model.
• Implementing and Customization of Pages, Records and Menus using People Tools and Object oriented PeopleCode.
• Extensively worked on Integration Broker to integrate with third party systems.
• Hands-on expertise with Change Assistant Upgrade Assistant , and other data migration tools such as Data Mover.
• Proficient in writing SQL queries, Stored Procedures and PL/SQL programs.
• Have strong communication skills, well organized and able to work as individual or as part of a team.
• Good team player and strong troubleshooter.

Technical Skills

• ERP : PeopleSoft HCM 8.X, 9.X, CRM 8.X, 9.X, EPM 8.8 and Vantive
• Tools : Application Designer, Application Engine, Vantive Designer and Tools.
• Database : Oracle, DB2 and SQL Server 6.5
• Languages : PeopleCode, SQL, PL/SQL, VBA, SQR, PERL, Java and COBOL.
• Operating Systems : Windows NT, MS-DOS and UNIX

Professional Experience

Confidential

Nexus is an integrated family of peoplesoft and mainframe applications, enabling technical support for internal and external customers who request, use, and repair the technologies deployed by FedEx.

Responsibilities:

• Design, development and customization of components and pages.
• Modification to date fields to reflect server timezone and client timezone.
• Enhancement of existing business components/pages.
• Development and enhancement of stored procedures and triggers on Sybase/SQL.
• Production support of the existing peoplesoft application.

Environment: HP-Unix, PeopleSoft 8.9/ Vantive 8.0 and Application Designer.

Confidential

The MyHR Redesign project involves the re-design to the Core HR data and processes to resolve usability and data integrity issues experienced by peoplesoft end users. The proposed structure focuses on lines of business, the legal entities they are comprised of, and the functions they perform. This aligns with current organization chart and relevant HR reporting needs. Also, with the redesign of business units to lines of business, reducing the number of business units from 20 to 5.

Responsibilities:

• Identification/Impact assessment of hard coded setid transactions.
• Enhancement/customization of self-service transactions like 'Flexible work schedule', 'Telecommute request' and 'Protected status/Self identify'.
• Enhancement/customization of pay rate change transactions like 'Request Pay Rate Change' and 'Approve Pay Rate Change'.
• Technical specs/Migration report and unit testing for assigned work items.

Environment: HP-Unix, PeopleSoft HCM, PeopleTools 8.51, PeopleCode and Application Designer.

Confidential

Responsibilities:

• Design, development and customization of components/pages.
• Development of components/pages and code based on business/user requirements.
• Customization and enhancement of existing business applications.
• Development and enhancement of stored procedures and triggers on Sybase/SQL.
• Extensively involved in the Object Migration from DEV to TST and UAT.
• Production support of the current peoplesoft application.

Environment: HP-Unix, PeopleSoft 8.9/ Vantive 8.0 and Designer.

Confidential

Responsibilities:

• Customizing PeopleSoft components to meet the business requirements.
• Enhancement of 'portfolio management' component for portfolio parameter calculations.
• Developed PeopleCode functions to improve the performance of 'batch parameter' component loading.
• Analytical data system, which provides PeopleSoft pages, to select a subset of data tables and portfolio's from Basel II GCBC PeopleSoft database and transfer the same to 'analytical database'.

Environment: HP-Unix, PeopleSoft 8.8, PeopleCode, Application Designer, Application Engine and Oracle 9i.

Confidential

Responsibilities:

• Developing the control screens i.e. PeopleSoft components for the loaner status and also modifying the existing loaner components to track the movement of loaner items.
• Development of an application engine to send workflow notifications to the provider group on various stages of loaner cycle.
• Unit testing and UAT of the developed application.

Confidential

Responsibilities:

• Preparation of technical specs based on the business requirements document.
• Real-time Integration with Panasonic website application for creation of user profile, customer, case and notes in PeopleSoft using integration broker framework.
• Created messages and accompanying PeopleCode to parse the XML and create the user profile, customer, case and notes in PeopleSoft CRM BORM.
• Unit testing and UAT of the developed application.

Confidential

Responsibilities:

• To get a thorough understanding of existing application and the proposed fix.
• Defined Users, Roles and Permission lists using Maintain Security.
• To modify the dealer locator search engine to query the database by model number and
• product category.
• Allow an agent to search for the nearest dealer by model and product category.
• Preparation of Technical Specs Document.
• Unit testing and UAT of the modified application.
• Environment: NT Server, PeopleSoft 8.8, Application Designer, PeopleCode, Integration Broker and Oracle 8.

Confidential

Responsibilities:

• To develop/customize the OOB correspondence management using PeopleCode.
• Integrate correspondence with the programs and registration components.
• To configure workflows for the programs and registration components.
• Done analysis and ran compare reports between source and target systems.
• Involved in analysis of deleted, changed and added PeopleSoft objects and functionality. changes in 8.9 to retrofit client customizations.
• Retrofitted PeopleSoft objects like records, fields, CI, application engine, components, pages and PeopleCode.
• Preparation of Technical Specs Document.
• Unit testing of the correspondence management functionality.

Environment: NT Server, PeopleSoft 8.9, Application Designer, Application Engine, PeopleCode and Oracle 9i.

Confidential

Responsibilities:

• To Scope the PeopleSoft incidents assigned
• Providing fix for the PeopleSoft incidents
• Done analysis and ran compare reports between source and target systems.
• Preparation of code review document
• Unit testing of the fixed PeopleSoft incident

Environment: NT Server, PeopleSoft HCM 8.X, CRM 8.9, 8.8, 8.4, Application Designer, PeopleCode, Application Engine, Test Director 7.6 and SQL Server 7.0.

Confidential

Responsibilities:

• Enhancement and maintenance of Vantive Support objects.
• Development and maintenance of VBA Scripts
• Testing of the module
• Bug fixing on their existing system

Environment: NT Server, Vantive CRM and SQL Server 6.5.

Confidential

Responsibilities:

• Development of 'Send Action' and 'Forward Action' dialog boxes and related scripts.
• Preparation of test cases for Unit testing
• Unit testing of the module
• Bug fixing on their existing system
• Preparation of 'Design Specification' and 'User manual' documents
• Environment: NT Server, Vantive CRM and SQL Server 6.5.
• Employer: US Interactive Ltd.
• Period: Jun. 00 May 02

Confidential

Responsibilities:

• Development of 'Plan' and 'Adjustment' Components
• Creating 'fields', building 'records', development of 'pages' and 'components'.
• Development of PeopleCode scripts and functions
• Preparation of 'Low level design' documents
• Preparation of 'Work User Specification' documents

Environment: Solaris 5.7 and NT Server, PeopleSoft CRM 8.x, Application Designer, PeopleCode, SQR, Process scheduler, Portal Infranet 6.1, e2eHub 3.1.3 and Oracle 8.1.7.

Confidential

Responsibilities:

• Writing VBA scripts and functions for various field and form level validations.
• Design and development of Vantive screens.
• Writing PL/SQL procedures to implement the functionality required.
• Bug fixing on the existing 'Customer care' application.
• Environment: HP-UNIX Machine, Vantive 8.0, Oracle 8, ConnectEx and HP UNIX.

Confidential

Responsibilities:

• Developed Corridor Plan Object and Embedded the Vangrid controls on corridor plan page.
• Writing VBA scripts and functions for various field and form level validations.
• Writing PL/SQL procedures to implement the functionality required.
• Preparation of test cases for Testing.
• Preparation of User release notes.
• Preparation of Technical release notes.
• Bug Fixing for the existing system.

Environment: HP-UNIX Machine, Vantive 7.0 and Oracle 7.3 on HP-UNIX

Confidential

Responsibilities:

• Identification and creation of Objects required to meet the functionality
• Writing VBA scripts and functions for various field and form level validations.
• Exploration of Survey Template functionality.
• Preparation of test cases for Unit testing.
• Unit testing of modules involved.

Environment: IBM Server, Vantive 8.0, SQL Server 6.5 and Windows NT

Confidential

The CBRE Maintenance Project involves maintenance and enhancement for the Vantive applications developed originally by CBRE. Design and development for new requirements, coding, unit testing, integration testing and assistance to on-site during acceptance testing also come under the scope of the project.

Confidential

The strategic objective of this module, which is developed as an extension of Vantive Sales module is to primarily focus on servicing a set of premium CBRE clients in the Institutional Customer segment. The shared communication platform will empower the Sales Professional in day-to-day dealings with the clients by creating a centralized database of specified client information that can be accessed by each 'sales' professional.

Responsibilities:

I was involved in designing and developing the interface between IG/IP PropertyFirst system.

Developed PERL scripts to run server side background process to retrieve data from the database using oracle procedures, write it to a flat file and pass it on to the Property first system. Similarly, getting information from the Property First system periodically and populating the Opportunity records through Oracle Triggers.

Developed PL/SQL procedures and a trigger to take care of writing to a flat file, reading from flat file and inserting the data from flat file to an oracle table.

Preparation of test cases for Unit Testing.

Confidential

The objective of the PIMS module was to capture the property information for CBRE. The PIMS module aimed at creating a centralized database of property information. Hence, it involved the whole gamut of property related matters like buying, selling, making the property available, transaction, etc.

Responsibilities:

• I was involved in modifying screens, coding VBA scripts.
• Writing PL/SQL procedures to meet additional functional requirements.
• Preparing test cases for unit testing.

Confidential

The primary objective of this module was to develop a system for building a database of CBRE's global clients and to keep track of the transactions undertaken with them.

Responsibilities:

• Development of Vantive Screens.
• Preparing test cases for unit testing at offshore.
• Testing of Vantive screens and VBA Code to meet the specified functional requirements.

Environment: IBM Server, Vantive 8.0, Oracle 7.3 and Windows NT

Confidential

• The purpose of the project is to make all the COBOL - 74 programs Y2K compliant.
• The source codes were first converted on PC. We used Microsoft Visual Source Safe for version control of the sources. The system flow was later carried out at onsite.

Responsibilities:

• Carry out the Conversion of affected COBOL code.
• Compilation of the COBOL code on Unisys mainframe.
• Testing of the affected COBOL programs on Unisys mainframe.

Environment: Unisys A19 Mainframe, COBOL 74, DMS II and Cande