SUMMARY

• 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.
• 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.
• Extensively worked on design and development of bolt - on applications
• Worked on Full Life Cycle Implementation and production support of PeopleSoft.
• Extensively used SQL and PL/SQL for writing Stored Procedures, Functions, Triggers and Packages.
• Strong understanding of RDBMS concepts and experience in database design and development.
• 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 documentation and written presentation skills, and developed various technical specs with Test Plans and Procedures.
• 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
• Very good Team Player with strong communications and Interpersonal Skills

TECHNICAL SKILLS

• PeopleSoft HRMS (9.1,9.0,8.9, 8.8, 8.3, 8.x 7.x)
• Application Designer w PeopleToolsw People Code
• Application Engine w File Layout w Component Interface
• Security Administratorw XML Publisher w Portal
• Tree Managerw Process Schedulerw SQR
• PS Query w Crystal Reports w Production Support

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Sr Peoplesoft Analyst

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

Peoplesoft Technology Lead

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

Peoplesoft Technology Lead

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

Senior PeopleSoft Developer

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
• 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, UNIXConfidential

Senior PeopleSoft Developer

Responsibilities:

• 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

PeopleSoft Developer

Responsibilities:

• 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
• 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.