SUMMARY

• About 9 years of experience as a PeopleSoft professional in full lifecycle software development and maintenance.
• Experience in PeopleSoft application development in HRMS/HCM Modules including Human Resources, Benefits, Payroll and Employee Self Service on Oracle platform.
• Expertise in working with People Tools such as Application Designer, PeopleCode, Application Engine, Component Interface, File Layout, Workflow, Data Mover and Process Scheduler and App messaging (Integration broker).
• PeopleSoft-certified training on Application Engine.
• Proficient in creation of complex reports using SQR and Crystal Reports.
• Strong experience in working with Oracle database and PL-SQL programming.
• Good working knowledge of complete PeopleSoft Implementation cycleinvolving Requirements, Analysis, Specifications, Design, Development, Data Conversions, Installations, Maintenance, Application Performance and Tuning.
• Complete understanding of Peoplesoft client server and Internet Architectures.
• Strong at Analytical thinking, Testing, Troubleshooting and Error handling.
• Superior work ethic, excellent interpersonal skills and dedicated worker with quick learning capabilities.
• Ability to adapt, master new technologies and blend with the team and tempo.

SKILL SET

Peoplesoft skills:

• Peoplesoft Modules: PeopleSoft HRMS 8.8 (HR, Payroll, Base Benefits, Benefits Administration, Time and Labor and Employee Self Service modules)
• Development Tools: PeopleTools (8.4x) - Application Designer
• Data Management, Batch Processing and Integration Tools: Data Mover, SQL Loader, Process Scheduler, Process Monitor, File Layout, Application Engine, Component Interface, Workflow, Integration Broker and Application Messaging.
• Reporting Tools: SQR, PS/Query and Crystal Reports.
• Languages: SQR, Peoplecode, SQL, PL/SQL, C, C++, JAVA, HTML, XML
• Query tools: Toad, Oracle SQL Plus, Benthic.

Software skills:

• Operating Systems: Win XP/2K/9X/NT, UNIX, MAC and DOS.
• Databases: Oracle 9i, Oracle 7.x/8.x, SQL-Server 6.5/7.0/8.0 and Access
• Other Tools: STAT by Quest Software, Viper, Mercury Test Director, Lotus SmartSuite, Citrix 7.0, MS Office Suite, Ultra Edit, Edit Plus.

WORK EXPERIENCE

Confidential, Calabasas, CA
Programmer and analyst Nov 2004 - June 2009

Description: At Countrywide Financials, I have worked on various projects and provided production support for HR applications. Which included Payroll Implementation, PRP (Performance Review Program), JDC (Job Data Change), Network Id System, Orgmart system and Integration Broker and Application Messaging.

• Worked closely with the functional requirements team in the development of the detailed Functional Requirements document followed by the development of the Technical Specification documents.
• Defined and created solutions to implement business process changes.
• Developed additional code to meet new requirements.
• Worked with users on many CRM cases to solve the current Production issues.
• Analyzed all business functionality and developed back end database interfaces using PL/SQL stored procedures, functions and packages.
• Developed scripts to create tables, views, synonyms, sequences, PL/SQL stored procedures, functions, packages, database triggers to suffice the application needs.
• Developed and Enhanced the HR core applications, which included Workforce Administration, PRP (Performance Review Program), JDC (Job Data Change), Network Id System, Contractor system and Orgmart.
• Developed and Enhanced the Benefits core application such as Tuition Reimbursement.
• Involved in peer reviews. This includes in writing the test plans, test cases and in the process of analyzing the expected and actual results to ensuring that the developed software performs as detailed by the business requirements.
• Designed and developed inbound and outbound interfaces for updating and transmitting data such as Peoplmart, globalmart, CFC pages and HR-ETL interfaces.
• Developed Interfaces and SQL queries to bring data form India PS system and populate Global tables in US Peopelsoft system.
• Created a custom interface that would pull the 401K deductions from pay deduction tables and sent the file to Fidelity.
• Customized delivered BAS004 that generates Leave of Absence enrolment forms for employees who go on leave, so they can make their elections during Open enrolment.
• Enhanced BEN100 Run Control Page to enable user to run the snapshot by scheduling it and also to be able to run it manually when needed.
• Enhanced the Carrier EDI834 Changes File Interface to give a report to the user that has list of people who terminated from the benefit plan with a termination date other than the end of month.
• Designed various SQR Interfaces to generate separate health and life premium reports including detail files to verify what employees are covered and what the individual covered amount is by employee. The reports are provided to Standard once a month.
• Worked on EIP's (Integration broker) for integrating PeopleSoft HCM to CRM, ELM and Finance applications.
• Implemented EIP's, which includes JOBCODE_SYNC, LOCATION_SYNC, USER_PROFILE, VENDOR_SYNC, WORKFORCE_SYNC, DELETE_USER_PROFILE, PERSON_BASIC_SYNC and DEPT_SYNC etc.
• Documented many of the numerous site-specific customizations. This includes many PeopleCode customizations, as well as SQRs and other PeopleSoft objects.
• Provided technical assistance to the migration team, QA testing team, worked on issues and provided solutions.

Environment: 8.44 PeopleTools, 8.8 HRMS, SQR, Windows NT, Oracle 9i, SQL*Plus, PL/SQL developer and SQL-Server 8.0

Confidential Woodland Hills, CA
PeopleSoft Technical Consultant Feb 03 - Oct 04

• Developed reports and interfaces using SQR, Application Engine and File Layout.
• HR: Directory service export, New Hire and Department Change report.
• Payroll: Customized payroll register.
• Retrieved data from application tables using SQL for report generation.
• Developed scripts to create tables, views, synonyms, sequences, PL/SQL stored procedures, functions, packages, database triggers.
• Handled enhancements as service requests.
• Attended day to day trouble tickets.
• Provided support for queries.
• Developed & Modified SQRs; Created run control records and pages; Used Process Scheduler to run SQRs recursively at predetermined intervals of time.
• Applied regular Tax updates, Patches and customizations.
• Supported in the compare reports for Tax updates.
• Reapplied customizations in the process of Tax updates.
• Extracted and loaded Jobcodes, locations, salary grades, department, and Personal data in to a homegrown web based Recruitment system

Environment: People Soft 8.8HRMS (HR, Payroll), PeopleTools, PS Query, Application Engine, SQR, Oracle 9i, SQL, UNIX, Shell Scripting, FTP.

Confidential Kansas City, MO
PeopleSoft Technical Consultant Feb 02 - Jan 03

Description: PEOPLESOFT HRMS (Version 8.8) the job is to upgrade Customized Peoplesoft projects with Records, Pages, Components, Menus and Process Definitions from version 7 to version 8.42, which includes developing and creating various, Interfaces and Reports using SQR for HRMS (Payroll, Benefits, e-recruit). The job involves creating new Records, Pages, Components, Menus and Process Definitions in version 8.42

• Designed new Records, Pages, Components and Menus for the Human Resources Department (Payroll, Benefits, e-Recruit) using the various PeopleTools.
• Designed and created various Interfaces, which generate output files required for the Vendors.
• Extensively used Application Designer and other People tools of version 8.42 to modify existing tables and create some new tables and views to suffice the application needs.
• Made the whole project Process Scheduler enabled by creating the Process and Job definitions and giving the security to those process and jobs.
• Created many panels and modified the existing menus to reflect the customized panels and controlled the program flow with PeopleCode.
• Worked extensively on various account structures, record layouts of the output files generated by various Interfaces.
• Created Multiple Reports using SQR and provided security using the peoplesoft delivered security tables. So that respective departments get reports concerning to there departments instead of getting the reports of the all the departments in the university.
• Part of the team to analyze the compare reports and Upgrade override decisions.
• Handled the compare reports to identify the customizations and reapplied online customizations.
• Worked with DBA and Team lead in planning the database instances for the upgrade.
• Done upgrade from version 7.0 to 8.8 and migrating projects from development to test and production databases.

Environment: 8.42 PeopleTools, 8.8 HRMS (Payroll, Benefits, e-recruit), SQR 4.0, UNIX, Windows NT, and Oracle 8i

Confidential,Chicago, MO
PeopleSoft Technical Consultant Aug 2000 - Jan 2002

• Created new SQR Programs for benefits confirmation, Benefits Election, Employee personal Profile, Benefits premium summary, STD eligibility extract, Head count turnover and Employee referral source
• Developed interfaces using SQR for various Benefit carriers
• Crated new permission list, user profiles and roles
• During this project worked extensively with Import Manager, SQR, Process Scheduler, Query Manager, Security Administrator, and People Tools
• Having a full cycle implementation experience in Design, Analysis, Development, testing and production support
• Tax updates and Upgrades
• Customized PeopleSoft modules (including tables, menus, panels and process definitions) using People Tools
• Reports were generated using SQR
• Created Test Plan Documents and Procedures
• Data migration using Data mover
• Accomplished PeopleSoft project migration from SQL Server to UDB using Data mover
• Prepared technical and user documentation for customizations.
• Carried out PeopleSoft in house technical training in People Tools I & II and SQR.

Environment: People Soft 7.5x HRMS / PeopleTools 7.5x (HR, Benefits, Payroll), PS Query, SQR, Oracle 8i, UNIX.

EDUCATION

• Master's Degree - MS Computer Sciences