EXPERIENCE SUMMARY

• 9 Years of experience in PeopleSoft Implementation, Data Conversion, Production Support, Creating Reports, Interface development and RDBMS,
• Worked extensively on PeopleSoft HRMS 9.1, 9.0, 8.X, ELM 9.0, FSCM 8.9.
• Experience in live application/Server on call support 24/7 with timely delivery against aggressive deadlines.
• My technical areas of expertise include Application Engine, People Code, CI, Application Package, Integration Broker, SQR, PS Query/Crystal, XML Publisher, BIRT Reporting Tool, Data Mover, Security Administrator, AWE Workflow, Multilanguage Translation and Database Agent.
• Extensive HCM Functional experience in TAM/CG, Competency management, e-Performance, e-Development, e-Compensation and e-Profile, Base Benefits, Benefit Administration, Payroll, Payroll Interface, Employee Self Service ESS , Manager Self Service, Career Planning, Success Planning, Time and Labor and Service Procurement Finance and Training Management, Attendance Tracker ELM .
• Very good exposure in SQL query tuning and query optimization for PeopleSoft queries.
• Extensive experience in Unit, System and integration testing.
• Strong experience in applying bundles and reapplying the customization changes done on each module.
• Extensive experience in reporting using various reporting tools such as SQRs, PS Query and XML Publisher.
• Expertise in developing PL/SQL packages, procedures, functions, triggers, synonyms etc.
• Strong experience in Translate business requirements and functional designs into Technical specification document.
• Good experience in leading a team on different assignments. Experience in working with teams across geographical locations and exposure to offshore models being followed across IT Services industry.
• Key strengths include Excellent analytical and problem solving skills, quick learning on the job, good communication skills, good interpersonal skills and a good team player.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Senior PeopleSoft Techno Functional Consultant

Responsibilities:

• This Project contains production support and customization of Performance document and Benefits.
• Good experience of changing application package and customization of template change with AWE workflow approval.
• Sqr changes as per the requirement for Benefit Interface Changes.
• Created couple of PS Query and Connected query's for the report development.
• Created no of xml publisher reports. Very good experience with rtf template by handling large no of columns, using xdoxslt variables for different scenario, created different type of charts pie chart, stacked, radar chart..
• Actively involved with UAT Testing and bug fixing
• Had training on BIRT reporting tool and started creating the report using BIRT tool.

Environment: HCM 9.1 People Tools 8. 52 ,Oracle 11 and Unix

Confidential

Senior PeopleSoft Technical Consultant

Responsibilities:

• This Project contains supporting of TAM/CG and Benefits module with major customization on TAM/CG employee referral program.
• Created technical design document and designed new custom application for employee referral, external applicant along with compliance team page.
• Very good experience on Creating fields, records, Pages, Component, Menu, Permission List and writing the Peoplecode with parent child relationship on different scroll level. And very good experience on creating of security model created on different pages.
• Customized AE program for some of the conversion program.
• Creating the TAM/CG reports using PSQUERY and SQR.
• Started building XML publisher form for the compliance team.

Environment: HCM 9.1 People Tools 8. 51 ,Oracle 11 and Unix

Confidential

Senior PeopleSoft Techno Functional Consultant

Responsibilities:

• This Project contains production support and customization of Benefits and Time and Attendance module.
• Developed a custom Time Reporting Enrollment interface. Worked on Rule Programs, Time Reporting Codes.
• Having good experience on Integration Time and Attendance module with PS Finance module.
• Created row level security and assigned to the particular user of Time and Labor module.
• Handled AWE setup of configuration pages and written Application package and creating of records for Time and Labor module.
• Handled new table creation and Page design and Sqr creation for the new reporting where it's gets converted from Access to quick view.
• Good experience on Migrating the PS Object via STAT tool. And Exposure to Maestro Tool job schedule.

Environment: HCM 9.1 , FSCM 8.9, People Tools 8.49, 8.52 ,Oracle 11 and Unix

Confidential

Senior PeopleSoft Techno Functional Consultant

Responsibilities:

• Implemented Manage Hire data automation from Confidential to Workforce Administration.
• Having good experience on Integration Broker setup and configuration for Manage Hire automation Hire Request, Post Hire Request .
• Analysis and customization of Application Package HR HIRE, HCR JOB TYPES to auto populate the job and compensation record when the applicant hired from Manage Hire link.
• Having good experience on debugging the Application Package
• Good experience interacting with Taleo tool and team for applicant's resume.
• Having good Integration experience of Offer Letter Creation, Background Check information on TAM, CG Candidate Gateway module to other vendor using sqr's.
• Providing valuable input and solved the problems when ever the TAM/CG production issues occurs. And customized some of the benefit sqr's as per new requirement.
• Customization of Job detail page and applicant detail page on TAM module by modifying record, page and writing People Code.

Environment: HCM 9.1 Workforce Administration, TAM/CG , Benefits and People Tools 8.52, Oracle 11

Confidential

Senior PeopleSoft Technical Consultant

Responsibilities:

• Exposure to Confidential rollout project of PeopleSoft 9.1 implementation.
• Handled data conversion for different HCM modules like Benefit Administration, Profile Management, Salary Administration and Performance Management.
• Good experience in mock conversion and reconciliation of total count and fixing of any errors and manual update.
• Good exposure to table changes and differences between the two versions 8.9 Vs 9.1.
• Handled fit gap analysis and preparing the design document and fixing the sqr's code as part of retro-fit.
• Good exposure on analysis of different object like Application Package, Application Engine, SQR, Records, and Peoplecode.
• Created a new Approval Workflow Engine AWE for Address change in self service module. Created new pages, component, Application Package, written Peoplecode and setting up of configuration pages.
• Created complex reports using PS Query.
• Skilled in writing test plans, and test cases and documenting the test result.
• Good experience on Migrating the PS Object via STAT tool.
• Handling multiple task with team management and Communicating to different country users as part of this rollout.

Environment: HCM 9.1 Self Service, Manager Self Service, Workforce Administration, Profile Management, Performance Management, Payroll Interface and People Tools 8.51, Oracle 11, Unix

Confidential

PeopleSoft Conversion Specialist

Responsibilities:

• Handled PeopleSoft HCM Data Conversion for Benefits, Payroll, Time and Attendance module.
• Modified code rewrite number of interfaces for the better performance using Application Engine, CI and SQR.
• Build sequenced SQL reconciliation scripts to quickly verify conversion accuracy and provide end user reports.
• Good exposure to number of Mock conversion runs. Troubleshoot and fix the issues.
• Experienced in post-production Support. Handled Manual data conversion for future dated employees for all the PeopleSoft tables and custom tables due to dependencies of downstream system.
• Having good experience in Phire Tool and Migration standard.
• Created the test scripts for the users and updating the technical specification.
• Provided knowledge transfer to MTA employee after the Post-Production period with the proper documentation and with past issue.

Environment: HCM 9.0 Core HR, Base Benefits, Payroll and Time and Labor and People Tools 8.49, Oracle 11i, Unix.

Confidential

PeopleSoft Technical Consultant

Responsibilities:

• Handled Production Support activates and new enhancement of various HRMS modules Employee Self Service, Manager Self Service, Benefits, Workforce Administration and Custom Modules.
• Monitor and troubleshoot issues related to PeopleSoft batch interfaces . Check the impact of job failures and communicate to business. Fix the failures and rerun scheduled jobs.
• Responsible for file failure issue 24/7 whether inbound /outbound PeopleSoft file. Good exposure to handle the file to the server within the scheduled time.
• Created new outbound interfaces using SQR to provide the Employee Information to other vendor.
• Involved in Data Conversion from the legacy System into PeopleSoft using SQL Loader, DMS scripts and SQRS. Developed number of conversion scripts and uploaded data into Competency module.
• Migrate changes from Development environment to UAT environment to the Production environment following the PeopleSoft Change Management SOP which includes use of True Change software for migration of batch objects and also exposure in giving security access to tables, components. Experience in creating recurrence and scheduling the job/process.
• Created a Department Security Tree in PeopleSoft HRMS 9.0. And Involved in creating Users Profiles, Roles, Permission Lists and assigned User Profiles to users Maintain Security .
• Having good experience in Creating /Modifying Unix shell scripts to pass the files to the different service provider.
• Experience in modifying the shell scripts for many of the process which trigger emails as the user moved from lotus notes to outlook.
• Resolved the tickets in different PeopleSoft module Self Service, MSS, Workforce Administration and Benefits.
• Configured and tested open enrollment using PeopleSoft 9.1 eBenefits.
• Tested Open Enrollment and Event Maintenance processes. Documented eBenefits for employees and administrative staff.
• Developed SQRs to convert employee benefit enrollments from other systems to PeopleSoft tables.
• Created new interface using application engine and exposure to create new run control p ages and new unix script to pass the file to outside PeopleSoft server.
• Created ad-hoc reports using PS Query also created new reports using XML Publisher.
• Tuning SQL query's to very good extent to increase the performance. Very good exposure to the 'Explain plan' and 'Create index' for tuning.
• Having experience in SFTP File Transfer and PGP encryption.
• Having experience in tools like VSS, GCM and Magic, Remedy , FileZilla for the day today activists.
• Having good knowledge on new features and changes of PeopleSoft HRMS 9.1 by participating the functional training.
• Played good team player role with onsite and off-sore model.

Environment: HCM 9.0 Self Service ESS , Manager Self Service MSS , Workforce Administration, Base Benefits, Benefit Administration, custom module and People Tools 8.49, Oracle 10, Unix.

Confidential

Senior PeopleSoft Developer

Responsibilities:

• Handling new enhancement and Production Support activities of Service Procurement.
• Extensively working on Service Procurement module - Create and Maintain Service Provider, workorder creation, manage workflow and approval flow. Create Requisition, manage Requisition and Manage approvals.
• Strong in requirement gathering and translate to detailed techno functional documents.
• Developing new application Package for IB handler to create synchronous message from service provider and workorder creation component.
• Have good debugging experience of Integration Broker while passing synchronous message from PeopleSoft application.
• Good exposure to SOAPUI tool to pass the synchronous messages using WSDL documents.
• Strong experience in AWE setting using online page with multiple approval testing.
• Tuning PS Query to very good extent to increase the performance. Very good exposure to the 'Explain plan' and 'Create index' for tuning.
• Implemented Query Security for the given requirement.
• Created number of application engine to produce the control table data to the other vendor.
• Have good exposure to solve the number of critical production issue.
• Having good experience of debugging the online application and application engine through online tracing and application server tracing.
• Creating custom modules and enhancement of existing PeopleSoft modules as per client requirements by developing new/change records, pages, Component and Peoplecode.
• Designing of Technical Specification Document and writing test cases
• Review and validate the offshore team code.
• Conduct the status meeting with business team and Technical leads.
• Mentoring technical and Business information to offshore team members and addressing their technical queries. Good exposure to managing offshore team.

Environment: FSCM 8.9 Service Procurement and People Tools 8.49, Oracle 11 and UNIX.

Confidential

Senior PeopleSoft Developer

Responsibilities:

• Handled Production Support activates and New enhancement on various HRMS modules are Self Service, Manager Self Service, e-Performance , e-Compensation, Base Benefits, Payroll, Benefit Administration and Profile Management.
• Extensively worked on ELM new implementation and production support activities for attendance Tracking and Training Management modules.
• Created Data Conversion programs using Application Engine and Component Interface to load the data into Learning Activities component.
• Created new reports using XML Publisher with rowset/ Query type. Experience in creating complex reports displaying with chart diagram and hide / unhide the particular section to requested user in the same template.
• Created custom modules and enhancement of existing PeopleSoft modules as per requirements by creating new records, pages and Component on various HRMS module.
• Applied HR Bundles 5 to 10 and reapplied the customization changes.
• Major customization on e-Performance module including template changes and creation of new XML Publisher report. Prepared the Data Mover Scripts to move the Text Catalog changes for e-Performance enhancement.
• AWE workflow process has been followed for multiple approval testing for e-Performance
• Designed and setup benefit programs and components e.g., benefit plans, rates, credits, deductions, calculation rules . Designed and setup Eligibility Rules and Event Rules.
• Designed and setup Benefits for Open Enrollment and Event Maintenance.
• Created number of interfaces to convert employee benefit enrollments using application engine from other systems to PeopleSoft tables.
• Good exposure on Template Based Hire for contractors on MSS through Integration Broker and Integration with Time and Labor as well.
• Good experience on setup of Payroll Interface module to generate interface file to ADP.
• Good experience in modifying existing reports using Crystal Reports.
• Designed PeopleSoft role-based security. And good exposure in Query and Department Security.
• Extensively worked on different customization and New implementation of both Confidential Modules.
• Strong in requirement gathering and translate to detailed techno functional documents.
• Written new data conversion programs using application engine to load data from TALEO to Corresponding TAM Modules.
• Some customization are
• Adding some additional customization and adding fields on Job Details, Job Posting,
• Find Applicants and Manage Applicants page.
• Candidate Webpage Modifications New enhancement of advanced search page in place of the basic search page.
• Careers page Customization - search results page should include some additional fields and Providing Error message for a candidate cannot apply to the same requisition more than once.
• Extensively worked on style sheet appearance changes only for the Candidate Gateway module but not for the TAM PeopleSoft application to look like web page when External Applicant uses.
• Enhancements of SQR Report and Creation and Modification XML Publisher reports on CG Module.

Environment: HCM 9.0 Core HR, e-Performance, e-Compensation, Base Benefits, Benefit Administration, Payroll Interface, TAM/CG and People Tools 8.49, SQL Server2005, WinNT.

Confidential

Senior PeopleSoft Developer

Responsibilities:

• Implemented Compensation, Competency Management, Performance Management module, Profile Management and customization on Self Service, Manager Self-service.
• Involved in setup of Compensation: Comp rate code and Salary Plan table. And experience in development of e-Compensation - Bolt-on online pages batch process.
• Involved in setup of Competency, Sub-Competency and Rating Model along with the customization.
• Developed data conversion program using application engine and component interface to load the Compensation Rate Code, Salary plan competency data.
• Customization of self-service are verbiage changes, kept error/warring message and addition/modification of some fields in Training page, Education Detail page, Honors and Awards, Languages, Licenses, Designations and Certificates page, Memberships page and Prior Work Experience page.
• Involved in setup of Sections, Template on e-Performance module.
• Involved several customization done on both performance and development documents on e-performance module.
• Customization involved changes of people code in EP APPR MAIN, EP APPR BASE component and pages and additional EP Function Application Package.
• Involved in the Design of four Appraisal Process PIP, FFW, INT and FEED.
• Designed new pages and written batch process. By running this process the performance template will be created automatically.
• Involved full testing cycle starting from template creation to each and every status changes by administrator or Reviewer /Appraiser and till the document goes to historical page.
• Customization done on workflow as well.
• Interfaced PeopleSoft with External Vurv system for Recruiting candidate Profile load information.
• Coding and development of SQRs for processing data for foundation and delta load to external Vurv system.
• Preparation of UNIX script for the corresponding SQR to run in UNIX environment.
• Preparation of Unit test plan and System test plan.
• Good experience in creating new reports using Crystal Reports
• Involved in the complete testing of the modules and provided full support to the testing team during the UAT phase.

Environment: PS HCM 8.9 Core HR, e-Performance, e-Profile, Compensation, e-Compensation, Profile Management, Competency Management and People Tools 8.48, Oracle 9i on UNIX

Confidential

Senior PeopleSoft Developer

Responsibilities:

• Involved in Design, Development, Testing of PeopleSoft Interface program and Data Conversion program using PeopleSoft HRMS modules like Workforce Administration, Self Service, Manager Self Service and Base Benefits.
• Involved in online changes to the delivered pages, components and translate values.
• Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process.
• Developed data conversion program using application engine with 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.
• Enroll employees into benefit plans and setup dependent and beneficiary data.
• Developed number of interface reports using SQR to read the data from various PeopleSoft tables employee personal information, Job information, Benefit and send data from PeopleSoft to other external applications.
• Involved in the development of SQR's related to the Employee benefits and their 401k contributions and other related information.
• Worked with the Testing team and the users and helped them out in the testing process of different SQR's.
• Extensively worked on creation of application messages and setup of Integration Broker to pass the asynchronous message into other vendor server.
• Developed ad-hoc reports and ad-hoc queries developed Run Control Pages as per requirements and attached to menu to run SQRs for the developed sqrs.
• Developed various PS queries in order to help the client day-to-day activity.
• Good experience in creating new reports using Crystal Reports.
• Extensively 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.
• Mentoring technical and Business information to team members and addressing their technical queries.
• Coordinating the off-shore team to meet the quality deliverable on time.

Confidential

Developer

Responsibilities:

• Developed and implemented the module called Compensation which will cover Data Sourcing and Data Processing and Reporting of Cash Bonus, stock Compensation plans and other expenses related to this such as Swap Interest and Equity Administration Costs.
• Preparation/ Updation of Technical Specification Design Document.
• Created new and customized existing PeopleSoft objects Fields, Records, Panels, Panel Groups, Menus, People Code, Process Definition, registering Components in Portal, Roles and Permission list and applied row level Security.
• Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process.
• Based on the business requirements, design user friendly application in people soft by make use of Peoplesoft features like internet Architecture, Security, Process scheduler, Application Engine etc.
• Created new permission list and roles. Good exposure to row level security to display the data to limited users.
• Developed new workflow by creating business triggers and events for this new custom module.
• Involved in Unit testing of PeopleSoft functionality customized SQR programs using HR, Benefits.
• Created Application engine programs to load the stock and equity data into PeopleSoft custom table.
• Created run control pages to run these batch process.
• Strongly participating in performance tuning in the project.
• Creating Oracle Tables, Procedures, Packages and Triggers based on the requirement.
• Involved in solving production issues, change request processing and bug fixing.

Environment: PS HRMS 7.5 Core HR, Compensation Custom Module and People Tools 8.46, Oracle 9i, WinNT.

Confidential

Developer

Responsibilities:

• Oracle Migration 8i to 9i Migration of the People Soft databases of the Development, UA, PT environments.
• People Tools 8.18/8.43 upgrade to 8.46 for the Development, UA, PT and Production environments. Across 47 Environments
• Modified/Created SQR reports/interfaces, Crystal reports and Modified custom PS objects.
• Writing and running Test cases/scripts to check PeopleSoft modules.
• Used Upgrade Assistant to automate some of the upgrade tasks and to keep track of the begin time and end time to run a process.
• Involved in running Upgrade Scripts Process using Upgrade Assistant Tool.
• Involved in running Upgrade Compare Reports between Demo database and Copy of production before we do the upgrade copy.
• Used Application up grader to migrate objects from Demo to Target instance.
• Involved in Fine Tuning of Database Tables, which are used in Data Conversion.
• Application changes as part of people tools upgrade.
• Extensively used Process scheduler for setting up the reports to run at specific time and used Process Monitor to monitor the status of reports.
• Created Permission lists, users, roles and assigned roles to users through Maintain Security.
• Analysis and development for CDO application to solve the problem related to long Zero field in Peopletools 8.46.
• Bug fixing for issues due to upgrade of people tools 8.18 to 8.46.
• Testing of application changes/bug fixes.

Environment: PS HCM 8.0 and People Tools 8.46, Oracle 8i, 9i, WinNT.