SUMMARY:

• Having 9 years of Experience as PeopleSoft HRMS/HCM 9.2/9.1/9.0/8.9/8.8/8.3/8.0/7.5 x /CRM8.8 Technical/Functional Consultant.
• Involved in Design, Development, Enhancement, maintenance of PeopleSoft HR, Base Benefits, Ben - Admin, Payroll and Self Service (ESS, MSS, Recruiting, Payroll, NA Payrollmodules (eRecruit, eBenefits,ePay).
• Extensively Involved in Customization, Maintenance, Upgrade and Implementation of PeopleSoft HRMS applications.
• Very strong in Generating custom reports, Customizing Interfaces, Conversion programs, using SQR, Application Engine, peoplecode, Component Interfaces for HR, Base Benefits, Ben-Admin and Payroll modules.
• Involved in Object-Oriented Analysis & Design techniques for maintaining Application Packages, Asynchronous application messaging to communicate with external systems.
• Involved in working on JavaScript for page refreshes, worked on Integration Broker, Application Messaging XML Inbound Messages.
• Involved in Inbound, out bound HR Interface with Authoria for requisitions, Mellon Bank for Stock Purchase, open Enrollment, Custom conversion for Acquisition, Kronos interface for Time and attendance.
• Proficient in using peopletools for development, upgrade, Administration on applying patches and fixes, customizing PeopleSoftHCM Applications applying online validations, applying Integration Technologies Such as peoplecode,Application Engine, File Layout,Component Interface(CI) based on organizational needs.
• Functionally proficient in PeopleSoft HCM modules(Human Resource, Base Benefits,Benefit Administration, Payroll ) coordinated with functional source for Fit/gap analysis during upgrade, Data mapping during conversion selecting optimal, utilizing conventional method for a mass upload, Generating ADHOC queries for PORTAL NAVIGATION, Migration of Department security Trees to other Instances .
• Proficient in Generating optimized reports such as Employee Job Changes, Salary Planning summary Detail reports, Turnover, Benefit participation, Cost Center, regulatory reports using SQR, Crystal, PS Query, nVision and attached necessary security to run as Batch process in process scheduler.
• Involved in applying associated security for Customized applications such as user profile,role,permission list, row-level security, register and provide links for Navigation.
• Involved in working on Data Administration tools such as DataMover, Change Assistant.
• Tested Peoplesoft Applications by creating Test plans and test cases.
• Experienced in STAT 5.4 Tools for Archiving Objects, follow Migration path, submitting workflow, attaching detail documentation, outputs and remigration after refresh.
• Adept at establishing effective working relationships with clients, colleagues with ability to assess client needs co-ordinate and deliver with in the time schedule.

TECHNICAL SKILLS:

ERP: People Soft HRMS 8.3, 8.8, 8.9,9.0,9.1,CRM 8.8

People Tools: Application Designer, Process Scheduler, Import Manager, Application Engine, File Layout, Component Interface, Integration Broker, Squirmy, Object Security, Tree Manager, Native SQL, People Code, workflows, App messaging, Data Mover.

Internet: CSP, ASP, HTML, VB Script, Java Script.

Languages: Java, COBOL, C, SQL, and PL/SQL.

RDBMS: SQL Server, Oracle7.x-10g, SQL Server, DB2, MS-Access.

GUI: Oracle Forms4.0, Visual Basic.

Reporting: Crystal Reports 7.5, 8.0, 8.5, 9.0, 10, SQR

Case Tools: Rational Rose (SDLC), UML, Test Director,STAT 5.3.1.

Operating Systems: Windows, 95/98/NT/2000, OS/390 Mainframe, DOSUNIX (Solaris 8.0).

PROFESSIONAL EXPERIENCE:

Confidential, NY

Responsibilities:

• Developed Custom Pages and Maintained Peoplecode for Business Validations.
• Maintain Security to control access for Batch Jobs run through Process Scheduler.
• Developed Peoplecode for Conversion validation based on Business Process Requirement.
• Generated Data Mover Scripts to Migrate Objects to other Instances.
• Involved in Customization for HR applications Developed Additional Pages to maintain Additional Legacy Data In Peoplesoft HRMS module.
• Generated Unit Test Cases and test on Customized Applications to adhere Business Needs.
• Worked with HR Functional to Map Business Unit,Department,Location,Job Code,Action Reason,Empl Class,Comp Frequency,Pay Group,Comp Rate,Benefit Program Participation,Union Code,Work Group based on Business Needs.
• Performed Post Conversion Tasks to Fit with Current System Needs.
• Generated Peoplesoft Reports using XML PUBLISHER
• Involved in Creation of Adhoc Queries and Optimized SQL for Comparison Reports and
• Mass updates.
• Developed Inbound Interface For Time and Labor Module to Load Shift and Shift Details.
• Worked on Creating Permission List, Role based quires for security needs .
• Generated Employee Delete Process for Redundant Loads and Compare data Rows
• Using Setup Manager Data Administration Process.

Environment: - HCM 9.2, PeopleTools 8.53, Oracle 11g UNIX, Windows

Confidential, NY

Responsibilities:

• Involved In working on Benefit and HR Interfaces to Various Vendors.
• Worked on Data Mapping, Conversion SQR and Generation of Statistical Report
• From Legacy System to Peoplesoft 9.0 TAM, Benefits,ELM Modules .
• Worked on Base Benefits,Ben Admin Modules for Employee Benefit Coverage’s.
• Generated Carrier Interface files for Benefit Vendors such as BCBS, AETNA, UNITED, METLIFE,HIP.
• Involved in working on Ben Admin for ON DEMAND,EVENT Maintenance,Open Enrollment Process.
• Identify &resolve BenAdmin Issues for smooth run on BenAdmin Cobol Process .
• Customized BAS004 reports based on client needs .
• Generated Medicare Entitlement reports, Depenedent Beneficiary Report,Surviving spouse Reports,Retirement Report, Adhoc Quires for user needs.
• Involved in gereating staging Tables for ELM For various Course session, different vendors and Locations .
• Customized several pages for effective run on Applications to satisfy Custom standards on look and feel of delivered Application .
• Worked on Creating Permission List, Role based quires for security needs .
• Apply periodic patches and Fixes to make it current.

Environment: - HCM 8.9, PeopleTools 8.49, Oracle 10g UNIX, Windows

Confidential, NY

Responsibilities:

• Interface With External Systems, Page Enhancements with JavaScript, Generate Custom Reports in Peoplesoft HCM 8.9/8.49.21 CRM8.8/8.49
• Involved in Working on Debit Card Issuance and Leverage cards Applications.
• Developed Interfaces with External and Internal system using Integration Broker and Application Messaging .
• Involved in working on Application packages to communicate with Internal and external systems, monitoring Inbound XML messages, Message logs f
• Involved In Generating Custom SQR Reports for Internal Client Needs.
• Developed Application Engine Program for mass updates and Enhanced existing application Engine program to fit with current standards.
• Developed Adhoc queries using Query tool as per Business needs.
• Developed JavaScript on customized pages for quick refreshes and enhanced Optimization on effective data fetches .
• Enhanced existing data conversion and Mass a updates using SQR and AppEngine programs .
• Worked on Data mover, Application Designer for applying Periodic patches and fixes.
• Involved in working on Tree Manager generating Data security tree, applying row level security using security search views.
• Worked on Delivered compliance Crystal Reports to suit the Business needs.
• Involved In Enhancing Peoplecode online validations and select scrolls for effective data fetch .
• Performed Unit Testing, Generated Manual Test Cases using HP quality center, Involved in Generating Automated test scripts using WinRunner.
• Coordinated with Database Admin for patch updates, cost analyzing on Indexes for Optimized data retrieval .

Environment: - HCM 8.9, PeopleTools 8.49, CRM 8.8 Oracle 10g UNIX, Windows

Confidential, Wi

Responsibilities:

• Interface with Vendors Handled Inbound Using Ben-Administration, Generate Custom Reports & Maintenance of Peoplesoft HCM 8.9/9.0
• Involved in Understanding the Needs and developed proto to Confirm With the CSR request in STAT .
• Involved in Customizing BAS004 SQR report for open Enrollment .
• Developed Appengine Program to Interface with Melon bank on Stock purchase Elections get loaded as Savings Benefit using Ben-Admin Tables.Generated Error files for outbound interfaces and success files to generate reports .
• Involved in Developing SQR Reports using XML SQC(summary detail reports for union /location employee, salary plan no increase for 18+ months,Turn over reports on head count, Reports by recruiter on Job Requsition,Talent aqusition …………) conversions programs for Alcan Acquisitions, Interface programs to handle HR and Benefit Vendors.
• Customized Self Service pay pages for printing, developed online Validations
• Using Peoplecode to filter Necessary and optional parameters.
• Involved in developing Mass Check process using App engine and used Appengine/CI for Mass department uploads.
• Generated Adhoc quires for reporting navigational path of requested Job Names.
• Migrated Department security tree to other Instance for functional users .
• Modified compliance crystal report based on company needs.
• Performed unit testing, Optimizing quires based on cost analysis, performing traces to identify exceptions, attaching test report, post migration steps and helping QA for newer Functionality .
• Involved in applying necessary changes on the customized SQR for time and
• Attendance based on the change from vendor on the Input File .
• Involved in handling interface, report issues by running schedule process manually due to delayed input, making report changes based on change requests .
• Involved in applying necessary patches and fixes from meta link.

Environment: - HCM 8.9, PeopleTools 8.49, STAT 5.4,SQLSERVER, UNIX, Windows

Confidential, Tx

Responsibilities:

• Interacted with Business users to gather the requirements that include business process, enhancements, issues, production change requests and developed new/modified objects.
• Documented user requirements and developed specifications for customization of PeopleSoft HRMS.
• Extensively Developed, modified HR, Benefits and Payroll module SQR reports to suit needs of the Client, Integrated SQR with Process Scheduler.
• Actively generated customized Hires/Rehires, Promotions, pay band/ level, Laterals, Deductions, Transfers, Status Changes, Leave of absence, short term disability, Pay changes, Terminations SQR reports for Employee Job changes.
• Customized and created record definitions, designed new pages, components using Application Designer to display additional information and used Peoplecode to in corporate validation rules according to specifications
• Developed Run control Pages with optional and necessary filters .
• Responsible for building various search records preserving the row level security.
• Generated people code to display/Hide filters and activate reports based on user choice .
• Generated all Tab delimited related reports to fit as various worksheet in single Excel Work Book using XML SQC .
• Done required analysis and Generated section 16 officers and reapplied customizations to delivered various regulatory SQRs reports based on user requirements .
• Worked closely with the HR, and Payroll department heads and users to gather information, designed and developed Interfaces/Reports with HR and Benefit
• Developed an Application engine, CI which update Benefit Status on Dependent Benef based on age Limit processed by AppEngine.
• Involved in archiving, change control, migration management and issue Tracking of objects using STAT tools
• Performed unit Testing as Post development and involved in helping QA understand the new functionality and pointers on preparing test cases for the same.

Environment: - HCM 8.9, PeopleTools 8.49, Oracle, UNIX, Windows

Confidential, NJ

Responsibilities:

• Involved in Functional and Technical Business process/ Fit Gap analysis between our present PeopleSoft (8.3) systems with Updated version of PeopleSoft System (8.9).
• Installed Upgrade Assistant and created jobs to automate the upgrade process.
• Ran SYSAUDIT, DDDAUDIT ALTER ADUIT and SQR Reports on our copy of production to cleanse the Database.
• Ran upgrade compare report between vanilla and clean copy of production, to identify all the customizations perform tools upgrade from PeopleTools 8.42 to PeopleTools 8.46 by running the Release Scripts
• Reviewed and analyzed upgrade compare reports, specified upgrade actions and upgrade flags as to preserve our customizations.
• Performed Data Conversion by modifying the existing delivered SQR and Application Engine programs.
• Converted current panels to pages to run on people soft internet architecture.
• Converted our current class based security to role based security to take advantage of new delivered roles and permission lists.
• Defined user id for all the employees in our organization using group build functionality to take advantage of self service applications.
• Deployed Initial Upgrade and from Test instance made Final Move to Production.
• Involved in Unit, User Acceptance and parallel testing.
• Involved in customizations, applied Row level security on E-Recruit applications registering Components for user Access.
• Generated custom Interface reports on location code, salary grade, Job code, Pay group using PS JOBCODE TBL, PS JOB FAMILY TBL, PS BUS UNIT TBL HR, PS JOB to make Entry for each grade and sending PS HCM Departments to Authoria.
• Applied current Patches and Bundles in related to HR, BENEFITS, PAYROLL modules.
• Developed Interface, Migration reports for the outsourced system.
• Performed Data Conversion and MassUpload using Application Engine Programs for Company Acquisitions .
• Involved in generating summary and detail reports using SQR and Crystal
• In corporate people code for additional data validations as per our business requirements.
• Created private and public queries to address our Adhoc reporting needs.

Environment: - HRMS 8.9, PeopleTools 8.46, Oracle, UNIX, Windows.

Confidential, Somers, NY.

Responsibilities:

• Made functional and technical decisions for the customized objects to carry over to PeopleSoft 8.8 System.
• Generated Audit reports to cleanse the copy of production.
• Reviewed and assisted our fit gap Analysis to identify new Business Process, which we need to be implemented.
• Applied updated Bundles on copy of production.
• Ran the Upgrade Compare Reports between our copy of production and Demo 8.8Database
• Applied actions on carry over customizations.
• Performed the Upgrade tasks, to upgrade people Tools and applications.
• Involved in running Data mover scripts to import DAT files.
• Involved in modifying Custom SQR’s in PeopleSoft 8.3 to PeopleSoft 8.8.
• Developed Run Control tables, pages, menus, and define process definitions for custom SQR/App Engine programs to run on process scheduler
• Generated custom SQC to address our heading needs for every custom SQR’s toaddress our organizational reporting needs.
• Generated error message in Applicant Hire Err.log for location codes usingPS DEPT TBL, PS AUDIT DEPT TBL.
• Wrote People code to in corporate our Business rules for the purpose of data validation
• Involved in applying patches and fixes on Demo and production as it available on people soft .
• Designed and Developed SQR programs to extract data from custom objects of HR and payroll as Flat files to external
• Developed Search views to use as component search records.
• Organized associated components in permission list to implement Role base security.
• Developed Drill down reports, cross Tab reports using Business objects for summary and detail overview.

Environment: PeopleSoft 8.3/8.8 HCM, People Tools 8.16/8.42, People Code, SQR, Oracle 8.0, Unix-AIX:

Confidential, NJ

Responsibilities:

• Involved in the Table loading sequence for the HR & Benefit application as per the functional requirements.
• Involved in designing of Benefit Information, defining Benefit Plans and customizing benefit programs.
• Wrote data conversion programs to load benefits related data in to Peoplesoft benefit tables.
• Developed new SQR reports from scratch for Number of employees in each Benefit Program, and List of employees in each major Benefit Plan, such as Medical, dental, and Life AD/D.
• Written Inbound/outbound SQR Interface programs to Load up the HR, Benefits data’s from the external source in to our peoplesoft application tables.
• Created Pay groups for employees with different sets of benefits or earnings and attached People Code in the record definitions for validations, set default values.
• Responsible for generating the Standard Reports in various forms by using SQR and Queries formatting in Crystal Reports for different requirements of the organization.
• Used Process Scheduler to Schedule the process at a specific time and run recursively on the server periodically.
• Used Process Monitor to find out the status of the process.
• Created Run control panels, panel groups, attached them to required menus through Application Designer .
• Written People code to implement our business rules and to validate the data entry process and Used Application Reviewer to debug People code.
• Created SQL Views and Query Views to optimize our Query performance and used views as search records.
• Have used Data Mover to load projects into Application Update database.
• Involved in Post Implementation Enhancements to the People Soft HRMS including Customization of HR, Benefit records, Panels up to user requests.
• Involved in the testing phase of the application by setup the test cases and did manual testing by means of adding new rows of data, deleting the data from the panel and people code validations.

Environment: People Soft HRMS 8.3, SQR, PeopleTools, Crystal Reports, COBOL,DB2, People Code, Windows'95/NT, Unix.

Confidential, Ok

Responsibilities:

• Assisted in analysis, design and documentation of the business process as required by our business units.
• Defined table loading sequence and mapped the legacy data with the corresponding PeopleSoft tables
• Implementation of complex interface programs to move data from the legacy system to the People Soft using SQR as primary tool and generating status reports.
• Developed and Modified People code for various validations as required by our business process
• Customized PeopleSoft applications in HR, Benefits and Payroll modules.
• Created Pay groups for employees with different sets of benefits or earnings and attached People Code in the record definitions for validations, set default values to implement business rules and to enhance applications
• Created SQR for resetting flags for positive pay status. Also modified SQR to include payment methods of manual and check, and to set positive pay status to “S” for cancelled checks. Set positive pay date to cancel date + 1 to stop sending payment to the bank multiple times.
• Developed interface reports such as BUCK 401k Inbound, BUCK 401K Outbound and DREYFUS UNION 401K Interface.
• Used application reviewer extensively to debug PeopleCode
• Involved in writing numerous SQRs for various reports and used PS/Query to develop ad hoc Queries and Crystal Reports.

Environment: PeopleSoft 8.3, PeopleCode, SQR, Crystal Reports, Oracle 7.3, Windows'95/NT, Unix

Confidential

Technical Developer

Responsibilities:

• Involved in Designing GUI.
• Involved in Developing Web pages in HTML
• Used Java Script for Client Side validations.
• Implemented JDBC statement objects that passes SQL queries to the
• Backend database server for retrieving and storing information.
• Involved in Designing of Servlets.

Environment: Java1.2, JDBC, HTML, JavaScript, Servlets, Oracle 7.3, Windows NT