Experience Skills:

• Obtained certificates of appreciation from clients like General Electric, Birlasoft Inc and BSL.
• Experience in all phases of the complete lifecycle of the project involving Requirements, Analysis, Specification, Design, Development, Conversions, Installations, testing and Maintenance, Application Performance and Tuning
• Strong documentation and written presentation skills, and developed various technical specs with Test Plans and Procedures.
• Strong application development skills using Oracle 9.x/8.x/7.x, Visual Basic 6.0, Java2.0, Crystal Reports 8.x/7.x
• Strong understanding of RDBMS concepts and experience in database design and development.
• Extensively used SQL and PL/SQL for writing Stored Procedures, Functions, Triggers and Packages.
• Worked on Full Life Cycle Implementation and production support of PeopleSoft.
• Extensively worked on design and development of bolt-on applications
• 12 years of experience in wide range of PeopleSoft HRMS modules including HR, Payroll, Time and Labor, Benefits, Employee Self Service and Manager Self Service.
• Over 12 years of experience in Information Technology that included gathering user requirements, Systems Analysis, Design, Development, Implementation, Upgrade, Testing and Production Support of various Client Server and ERP applications.
• Very good Team Player with strong communications and Interpersonal Skills

Tools Technologies used:

• PeopleSoft HRMS 9.1,9.0,8.9, 8.8, 8.3, 8.x 7.x
• Application Designer w PeopleTools w People Code
• Application Engine w File Layout w Component Interface
• Security Administrator w XML Publisher w Portal
• Tree Manager w Process Scheduler w SQR
• PS Query w Crystal Reports w Production Support
• Performance Tuning w Data Mover w Integration broker
• Workflow w PL/SQL w Java Script

Operating Systems:

Windows 2000, NT w UNIX

Databases:

Oracle 11g/10g/9i/8/7.x w MS SQL Server w DB/2

Applications:

• HR w Payroll for North America w Self Service
• Time and Labor w Accounts Payable w Project Costing
• Base Benefits

Work Experience:

Confidential

Role: Sr Peoplesoft Analyst HCM 9.1 Canada Implementation and USA Support

Responsibilities

• Conducted multiple Fit Gap Analysis sessions and analyzed and documented customizations to be developed in Peoplesoft.
• Worked on customization in Employee Self Service and Manager Self Service. Developed custom manager self service functions to change personal information of employees, to put employees on LOA and Return from Leave, to view employees paystubs, to change employees user profile password. All these custom functionalities are given to manager self service users.
• Worked on security design, designed row level security tree based , Role based permissions for payroll reporting, dynamic roles assignment, LDAP authentication and password controls. Created roles and permission list as per the requirement. Developed role based permission list security for Payroll reports.
• Designed and developed permissions and roles for ESS, MSS and business users. Worked on Core HR, Benefits, Payroll, Time and Labor modules.
• Worked on configuring and customizing Template Based Hire.
• Developed attachments functionality for Health and Safety and Labor Administration modules. Incident and Injury details attachments for Heath and Safety. Record Disciplinary Actions and Grievances in Labor Administration.
• Worked on data loads and loading several setup tables using ExceltoCI and developed interfaces using Application Engine and Component Interface.
• Developed Time and Labor rules using Template built rules and SQL Objects.
• Translating business requirements and functional designs into a technical design documents.
• Trouble shooting issues as part of daily production support
• Develop and coordinate application enhancements and bug fixes with offshore developers and testing resources.

Environment: PeopleSoft HCM 9.1 HR, ESS, MSS, Payroll, Benefits Administration, Time and Labor PeopleTools 8.51, App Engine, Component Interface, SQR, PS Query, XML Publisher, Oracle 11g, UNIX

Confidential

Role: Peoplesoft Technology Lead HCM 9.1 Implementation and Support

Responsibilities

• Conducted multiple Fit Gap Analysis sessions and analyzed and documented customizations to be developed in Peoplesoft.
• Designed and developed an interface to hire associates in Peoplesoft. ATS hires associates and sends the data to PS in XML file. Interface reads the XML data and inserts these hires into Peoplesoft using Application Engine and Component Interface.
• Designed and developed several outbound interfaces to iVos, ISC, AS/400, ATS Systems and several other vendors.
• Designed and developed an interface to automate the process of creating locations, tax location codes, departments and positions. Used ExcelToCI to load several setup tables.
• Designed and worked on interfaces for Data Analysis tool, DSS
• Translating business requirements and functional designs into a technical design documents. Extensively working Ad hoc queries requests either through PS Query or TOAD
• Worked on Self Service and workflow
• Worked on trouble shooting issues with Payroll, which included Pay Calc and Pay Confirm.
• Worked on customization and interfaces in Payroll
• Worked on Data Security and Page Access security
• Trouble shooting HR issues as part of daily production support
• Develop and coordinate application enhancements and bug fixes with offshore developers and testing resources.

Environment: PeopleSoft HCM 9.1 HR, Payroll, Benefits Administration, ESS, MSS PeopleTools 8.5, App Engine, Component Interface, SQR, PS Query, XML Publisher, DB2, UNIX

Confidential

Role: Peoplesoft Technology Lead HCM 9.0 upgrade

Responsibilities

• Actively involved in all stages of Upgrade of PeopleSoft HCM from version 8.8 to 9.0
• Developed technical specification documentation for the new changes brought out in version 9.0
• Conducted multiple Fit Gap Analysis sessions and analyzed upgrade compare reports to identify and document existing customizations
• Involved in Retrofitting of several customized objects like Application Engines, SQR's in the process of upgrade
• Developed Template Built Rules and Custom Rules using SQL objects and User Exists.
• Developed a custom Rapid Hire utility using Component Interfaces.
• Worked on Data and Page access security
• Develop and coordinate application enhancements and bug fixes with offshore developers and testing resources.

Environment: PeopleSoft HCM 9.0 HR, Benefits, Payroll, Time Labor, e-Modules PeopleTools 8.5, App Engine, File Layout, Component Interface, SQR, PS Query, XML Publisher, Oracle 10g, UNIX

Confidential

Role: Senior PeopleSoft Developer HR, Time and Labor and Payroll

Responsibilities

PeopleSoft Production Support and HCM 9.0 Upgrade Washington University

• Actively involved in all stages of Upgrade of PeopleSoft HCM from version 8.8 to 9.0
• Developed technical specification documentation for the new changes brought out in version 9.0
• Conducted multiple Fit Gap Analysis sessions and analyzed upgrade compare reports to identify and document existing customizations
• Involved in Retrofitting of several customized objects like Application Engines, SQR's in the process of upgrade
• Run SYSAUDIT, DDDAUDIT, Alter Audit reports to identify integrity issues
• Defined and built Work Schedules by creating Shifts, Workdays and Template Definitions for Weekly, Biweekly employees
• Developed an interface for reporting time from a flat file using File Layout, Component Interface, and Application Engine into the Peoplesoft Time and Labor system.
• Developed Template/Custom Built Rules using Daily Threshold, Holiday and Guaranteed Hours and customized the rules using SQL objects, actions and conditions
• Generated a process to create Interface between Benefits and Time and Labor which compares employee's leaves recorded in Time and Labor against the allowed leaves this process is used as an alternative to the existing Payroll feature, which calculates the Leave Accruals
• Defined Time and Labor Static and Dynamic work groups for specific group of time reporters.
• Worked on Time and Labor Employee and Manager Self Service.
• Developed Application Engine Program to upload Hire Information from data file into PS staging tables using File Layouts and PeopleCode, which will be further populated into Corresponding PS tables
• Developed Interfaces for Payroll, such as Deduction Calculation: this SQR generates deduction codes for each employee's benefit plans elected for that particular year these deduction codes are used by the payroll department to process Benefits Billing Process the pay of employees.
• Worked on trouble shooting issues with Payroll, which included Pay Calc and Pay Confirm.
• Modified existing offer letter report formats and developed XML Publisher reports using PS query
• Developed various reports using SQR and Crystal Reports
• Designed technical specification for customization in Recruiting, Candidate-Gateway eRecruit , Talent Acquisition Manager for employees to submit resumes and attachments online
• Created a customized Workflow which transfers a Hiring Document from one manager to another
• Designed and developed PeopleCode to set up Workflow for Hiring and triggering events to mail the new hire details to all administrators such as Payroll, Benefits
• Extensively used Workflow for Self Service applications in ESS and MSS. Customized Pages like Personal information, Leave apply, emergency, contact information pages
• Developed a process to load the timesheet information to payroll, benefits day accrual and employee balances. Created a Workflow for timesheet approval
• Used Integration Broker and Web Services to Integrate PeopleSoft HCM with third party services
• Used Integration Broker to publish the employee information from PS HCM to other application
• Designed and Developed Inbound Interface to import employee health care and benefit changes from third party benefit provider to PeopleSoft using Application Engine and Component Interface
• Created and modified the Application Packages to validate and move the applicant data from eRecruit to HR module
• Involved in changing search records to establish Row Level Security. Created Permission Lists, User Profiles to maintain Security
• Developed e-benefits pages for employees to enroll and check their benefits programs like health, vision, insurance, dental, savings plan
• Participated in on-going Production Support. Involved in the debugging of errors and modifications to various objects related to HR, Payroll, Benefits modules

Environment: PeopleSoft HCM 8.8/9.0 HR, Benefits, Payroll, Time Labor, e-Modules PeopleTools 8.48, App Engine, File Layout, Component Interface, Integration Broker, SQR, PS Query, XML Publisher, Oracle 10g, Windows 2003, UNIX

PeopleSoft Financials System Confidential

Project: This project is undertaken to develop financial modules. Involved in understanding the legacy COBOL system and developing the same in PeopleSoft system.

• Involved in gathering defining requirements, overall scope definition in terms of functional technical requirements, legacy system COBOL integration.
• Developed various bolt-on financial modules like Grants Budgeting, Proposal Development System, Accounts Payable, change order and Line Item Invoice.
• Developed an application to generate the XML from PeopleSoft pages and submit the XML data to the Government websites.
• Developed an application to generate PDF forms using style sheets and XML data.
• Added new purchase orders in bulk to the PeopleSoft system by using Application Engine, CI and File Layout.
• Ability to understand COBOL system and implementing the same in peoplesoft Bolt-on environment.
• Created reports using SQR and Crystal Reports.
• Used Java script to generate image index on Change request, Travel Report and Invoices.
• Set up and implemented GL, AR and AP modules for pay sheet processing, Journal processing, detailed ledgers, purchasing, voucher processing.
• Developed an interface using SQR between project costing and billing to populate PO values
• Designed payables system by defining general options, customer-processing options, and payment processing options, setting up of banks, vendors and publishers.
• Involved in evaluating test results and make recommendations for possible solution and also responsible for coordination and administering user acceptance testing.
• Responsible for production support through defect handling, impact analysis when change request comes.
• Created written documents in support of system code, design or testing.
• Involved in gathering defining requirements, overall scope definition in terms of functional technical requirements for the Economic Stimulus related funds
• Developed new components, new pages etc to accommodate the changes required for Stimulus funds
• Developed several functions to generate the XML from PeopleSoft pages and submit the XML data for the different forms required by the Government agencies like NASA, NIH
• Developed several SQR reports to reconcile the Grants related data.
• Developed reports using XML Publisher

Environment: People Tools 8.49.03, PeopleSoft Application Designer, People code, SQR, PeopleSoft Security, Crystal Reports, Process Scheduler, DB2, WinSQL, Ultra Edit, Ultra Compare, MS Office Products, Lotus Notes

Confidential

Role: PeopleSoft Developer

Project: Upgrade and Customization of HRMS v8.3 v8.8

• As a member of PeopleSoft HRMS technical team, responsibilities include:
• Involved in the PeopleSoft v8.3/8.8 Upgrade Project for HR, Benefits, Payroll, e-Pay and e-Performace.
• Involved in running Upgrade scripts using Upgrade Assistant. Analyzed Upgrade Compare reports to identify and document existing customizations
• Interacted, designed and implemented Employee Services Custom Module of PeopleSoft HRMS/HCM System for Blue Cross Blue Shield.
• Designed and developed custom HR, Base Benefits Employee Services Projects like Case Tracking, Leave Management, Retiree Case Processing, Pre-Employment Screening and Nightly Audit Modules.
• Involved in writing Technical Specifications according to the business requirements in consonance with the client needs.
• Created a number of Workflow Application Engine programs for processing custom requirements of Leave, Retiree and Pre-Employment applications of PeopleSoft system.
• Created FMLA subprogram using Application Engine Process. This process calculates the FMLA hours available for each employee and helps in the approval of FMLA leave processing.
• Created New Benefits SQR program for auditing the benefits data that will identify some specific errors that occur during data entry into the HCM PeopleSoft System.
• Created a number of SQR reports for auditing and generating the Error Reports for Benefits, Requisition, Job data Nightly Audit Reports.
• Created SQR's to generate Gift check reports, Retire life reduction letters, Retire life volume change letters in Retiree processing. These letters are printed on-line from portal pages for sending to the retirees.
• Created and customized Workflows to automate the process of Case Tracking, Leave, Retiree, and Pre-Employment Projects. Workflows involved creation of a number of Business Process Maps, Activities etc., in generating different work lists and send emails.
• Involved in Development /Customization of Reports, Processes and Pages to meet the deliverable dates using AEs, App Messaging, SQRs, People Code and other PS Tools.
• Developed pages using extensive people code involving component buffer access and workflows.
• Preparing the Test Scripts and Procedures and train the user to use them.
• Involved in production support and maintenance for Benefits and HR modules.
• Created Payroll Workflow notifications which are triggered for an employee going on leave of absence or being suspended.
• Modified the given Workflows in eProfile for name change and marital status change
• Developed an Application Engine to update/insert phone numbers using component interface CI PERSONAL DATA
• Written people code to send automated emails to the specified persons with the summary of data after submitting the Self Service forms

Environment: PeopleSoft HRMS 8.8, People Tools 8.44, Peoplecode, Application Engine, Component Interfaces, SQR, Windows 2000, oracle 9i.

Confidential

Project: BIPS-HRMS HR/Recruitment/Monitor Absence

• Developed SQR interface for AMS Attendance Monitoring System .
• Extensively used Application engine, SQR and Peoplecode for new development and enhancements.
• Customized Leave according to client requirement CL/PL/General Absences. Added new components for capturing Casual leaves of accrual nature.
• Added/Customized Record/Menu/Page/Component Peoplecode.
• Worked in setting up of workflow, resolving problems related to workflow for existing setup and creating new Business Process/Activities.
• Customized Hire/Terminate workflows.
• Developed eLeave where Employee applies for online leave, which is approved by the Department Manager and will be sent to HR Administrator for final approval using Workflow.
• Added new Notification templates in different components.
• Customized/Added Permission lists, Roles and Users.
• Generated several Queries using PS Query.
• Developed self-service modules to help employees with online access to HR activities, including vacation requests, personal profile, leave balances, ePay and compensation details.
• Handled Security related issues for certain roles and also giving department level security through Tree Manager.
• Involved in setting up of eDevelopment and Training and other self-service transactions.
• Created run control records, run control pages and menus for SQR programs and linked to PeopleSoft using Process Scheduler.
• Involved in development of SQR Reports like Appointment Letter, PF, Gratuity, Relieving Letter and LTA etc.
• Experience in production support of HR/Recruitment/Resume processing/Absence Management/Training Administration modules.
• Worked in Application Engine for developing batch processes and for creating Inbound and Outbound interfaces.
• Used Component Interfaces ExcelToCI utility, File Layout and SQR for data conversion.
• Involved in User Acceptance testing and Training the users and post implementation support.

Environment: HRMS 8.3/Tools 8.17, Windows 2000, Oracle8i, SQR 6.1.2 and Crystal Reports 8.0.

Confidential

Project: PeopleSoft HRMS HR/ Payroll/Time labor

• As a PeopleSoft HRMS technical team member responsibilities include:
• Extensively worked with Application Designer to modify record definitions, pages, components, menus and giving access to them by using maintain security.
• Troubleshooting the problem areas in Payroll process like setting up tables, setting up employees, working with pay sheets, performing pay calculations, pay confirmations and producing payroll reports.
• Developed different custom reports using SQR and Crystal Reports according to user specifications.
• Tailored People Code to implement data validation and to enforce field level security.
• Modification involved in changing search records to establish row level security.
• In order to accomplish row level security, Views were created.
• Developed interface reports using SQR to read the data from file and load it into PeopleSoft tables, and send data from PeopleSoft to other interfaces.
• Implementation of PeopleSoft customized application objects from development into production.

Environment: HRMS 8.3/Tools 8.12, Windows 2000, Oracle8i, SQR 6.1.2 and Crystal Reports 8.