SUMMARY

• Over 5 years experience in the Information Systems involving in Design, Development and Implementation of application software.
• Strong PeopleSoft analytical and technical experience in PeopleSoft HCM/HRMS
• Expertise in PeopleSoft Implementation, Upgrades, Implementation, Reporting, Data Conversion and Troubleshooting.
• Expertise in Application Designer, People code, SQR, Crystal Reports, nVision, Process Scheduler, File Layout, PS - Query, XML publisher, Application Engine and Integration Tools Like Component Interfaces Integration broker
• Proficient in conducting business process analysis and user training, gathering Requirements, analyzing them, creating functional & technical design specifications and developing customizations
• Solid working experience in PeopleSoft production support
• Proficient in System Analysis, and Design of Application Programs
• Good hands on experience in trouble shooting the problems and improving the performance of application processes by Debugging, tuning and tracing.
• Strong documentation and written presentation skills, and developed various technical specs with Test Plans and Procedures
• Experience in Performing Developer Unit Testing (DUT)
• Very good team player with excellent interaction/communication skills and willing to travel.

TECHNICAL SKILLS

ERP: PeopleSoft 9.2/9.1/9.0/8.9/8.8/8.3/7.5 ; People Tools 8.53/8.52/8.51/8.49/8.48/8.47/8.45

People tools: Application Designer, Application Engine, Component Interface, People Code, Workflow, Application Packages, File layout, Integration Broker, Data Mover, Process Scheduler, Process Monitor, Tree Manager

Modules: HR, Payroll, Base Benefits, Benefits Administration, Time and Labor, eProfile, eRecruit, eBenefits, ePay, Enterprise Learning Management, Manager Self Service.

Reporting Tools: SQR, Crystal Reports, PS Query

RDBMS: MS SQL Server 2005, SQL Server 2008, Oracle 10g/9i/8i/7.0, MS Access

Programming Languages: PeopleCode, Java, PL/SQL, C++, C, BASIC

Operating Systems: MS-DOS, Windows 98/ XP/ Vista, Unix, Sun Solaris

Internet Tools: JSP, PHP, Java Servlets, XML, HTML

Other Concepts: Data Structures, OOPS

PROFESSIONAL EXPERIENCE

Confidential - Minneapolis

PeopleSoft Developer

Responsibilities:

• Analyzed the requirements from Business and created technical design documents as per the requirements.
• Worked on 9.2 upgrade. Worked on setting up Mouse over popup pages and Related action in demo versions.
• Involved in creating printed versions of W-2 for all the 126K Team members(Terminated, Inactive and International) of Confidential using XML Publisher
• Worked extensively in modifying the email sent to the managers when an employee is Hired, terminated or Rehired.
• Developed an App Engine program from scratch that will create around 60 PDF files (W2’s) NDM them to a different server and upon successful transmission archive them.
• Extensively worked on all the XML publishers templates (PDF, RTF and XSLT)
• Customized ESS and MSS transactions
• Worked on Network Data Mover (NDM) to transmit the files from one server to another.
• Developed App Package (NDM NW) which transmit the PDF files from local server to Remote server
• Worked on Page’s customization using PeopleCode to provide extra detail values to the users on various pages and also worked in menu customization.
• Worked on Data Mover Scripts (DMS) to migrate data from one environment to another.
• Created a New Transaction Return From Leave(RFL) in Staff Management that will allow a manager to enter the return from leave information when an employee is back from a leave
• Extensively worked on PeopleCode to perform various edits on the effective date entered by the managers in RFL transaction.
• Extensively worked on Component Interface to post the data entered by Manager during the RFL transaction to the JOB data.
• Worked on Integration broker to Trigger Messages depending up on the inputs from user.
• Worked on modifying the current SQR to meet the requirements of the business.
• Upon successful completion of Development, performed Unit Testing and bug fixes if any.
• Developed an engine program that purges the Sensitive data for all the Non-employees of Confidential who have been terminates one year from the current date. A single app engine program that would delete the data and create multiple reports based on the run control parameters.
• Worked on modifying the critical mainframe jobs for 9.2 upgrade.

Environment: Windows XP/windows 7, Mainframes, PS HCM 8.9, Peoplesoft 9.1, Peoplesoft 9.2 PeopleTools 8.52, Peopletools 8.53, DB2, Integration Broker, Application Packages, PeopleCode, Component Interface, PS Security, PS Query, PeopleSoft Architecture (PIA).

Confidential

Sr. PeopleSoft Consultant

Environment: Windows XP, RedHat Linux, PS HCM 8.9., PeopleTools 8.50, Oracle 11g, Integration Broker, Application Packages, PeopleCode, Component Interface, PS Security, PS Query, PeopleSoft Architecture (PIA).

Responsibilities:

• Analyzed the requirements and created functional and technical design documents.
• Involved in data analysis and data conversion during the implementation
• Customized ESS and MSS transactions (viz., Name Change, Date of Birth Change, Location Change, Termination etc,.).
• Redesigned ESS & MSS Workflows according to the requirements.
• Configure Talent Acquisition Manager & Candidate Gateway according to the requirements of the client
• Involved in System Integration Testing of Talent Acquistion Manager & Candidate Gateway.
• Developed peoplecode from scratch for including Organisation as a beneficiary for an employee in ESS
• Worked on Page’s customization using peoplecode to provide extra detail values to the users on various pages and also worked in menu customization.
• Designed and Developed custom reports using application package in XMLP
• Developed custom App engine program to load the interface data
• Created custom Component Interfaces to load data posted from the subsystems
• Implemented Integration broker between HR system and Payroll syatem
• Created detailed unit test case documents.
• Developed new interfaces using SQR Reporting and Application Engine in the areas of Benefits, Payroll and HR. Created new Application Engine programs to replace some of the existing SQR processes.
• Developed an Application Engine program using File Layouts to load New Hire interface file into PeopleSoft tables
• Trouble shooting issues occurred during the implementation and conversion process.
• 24*7 Production Support

Confidential - CA

Sr. PeopleSoft HRMS Technical Consultant

Environment: PeopleSoft HRMS 8.9, People Tools 8.46, Application designer, People Code, Process Scheduler, PS-Query, SQR, SQL Plus, Application Engine, Oracle 9i, MS Excel, Crystal Reports, Windows NT/2000

Responsibilities:

• Designed and developed conversion programs to populate JOBCODE table from Legacy Systems using Component Interface
• Created data conversion scripts to convert the data from the legacy system to Peoplesoft HRMS tables such as Personal Data, Job Data, Employment Data and Payroll tables, General Deduction and General Deduction code table.
• Developed new custom SQRs for Benefits including health Benefit, Dependent Benefit, Dependent Coverage, Health Dependent Coverage and health Dependent.
• Supported data conversions, developed various reports and interfaces.
• Developed Application Engine programs for conversion .
• Involved in Setup of Eligibility rules and Plans in Benefits Administration
• Developed Queries using PS Query and export the results with Microsoft Excel
• Developed Crystal Reports as per the business requirements for complex calculations.
• Involved in design and usage of Application Engine, usage of Data Mover and SQR for efficient data transfer.
• Used Import Manager extensively to transfer data from ASCII text files to Peoplesoft tables.
• Extensively worked on PeopleCode to validate data, setting default values for fields, Calculations and events.
• Created new report formats using PS Query for customized application.

Confidential - San Antonio, Tx

Sr. Peoplesoft HRMS Consultant

Environment: PeopleSoft 8.9/9.0 (HR, Benefits, Payroll, e-Profile), People Tools 8.45.13, Application Engine, WorkFlow, Component Interface, People Code, SQR 8.x, SQL, PL/SQL, SQL*Plus 9.2.0, Oracle 9i, Windows 2000.

Responsibilities:

• Involved in PeopleSoft HRMS upgrade from v8.9 to 9.0.
• Upgraded PeopleSoft HRMS - HR, Base Benefits, Time & Labor.
• Identified the new process and tables in PeopleSoft version 9.0. Installed PeopleTools program files, as well as loading new stored SQL programs while upgrading PeopleTools.
• Used People Code extensively to validate objects in building application processes based on the functional business specifications.
• Created new Application Engine programs to replace some of the existing SQR processes.
• Developed Component Interface programs to load external data into production environment.
• Used Process Monitor to control the processes that are submitted to the Process Scheduler and to check the status of processes
• Performed clean up and testing of the database as a step to upgradation.
• Created /modified various Crystal Reports based on PS Queries.
• Migrated objects for Test and Conversion environment using System Change Request Form.

Confidential, San Jose, CA

Sr. PeopleSoft HRMS Technical Consultant

Environment: PeopleSoft v 8.3/8.8 HRMS (HR, Payroll, Base Benefits, T&L, and, Ben-Admin), PeopleCode, SQR, Crystal Reports 8.0, PeopleTools 8.2/8.46,SQL Server2000, ORACLE, Windows NT 4.0.

Responsibilities:

• Worked with functional analysts to determine what customizations are needed for the new release and reinstated the pertinent customizations.
• Analyzed existing customizations in 8.3 and documented the changes required for new release.
• Analyzed compare reports to determine objects to carry forward during the upgrade effort.
• Involved in retrofitting of both online and batch objects, (i.e., pages, fields/records, modified People Code, SQR, etc.) through patch application and/or application development.
• Modified Peoplesoft Enterprise delivered Batch Objects and upgraded the Custom added Batch Objects to the new release environment.
• Performed Interfacing, Conversions, data migration and report writing (using People Code, People Tools and SQR).
• Responsible for ensuring the customized SQR reports work in the new release. Modified the SQR Interfaces for version 8.8 compatibility.
• Involved in Fine Tuning of Data Conversion Application Engine Programs to increase the performance.
• Worked on Component Interfaces for Payroll and Benefits.
• Developed Application engine program to update personal status whenever there is change in the valid life event.
• Worked on Annual Benefits enrollment project. This project includes design and coding of various programs that are related to annual enrollment. The programs includes Annual Enrollment/Termination Reports, IVR Outbound Interface, Pension System Feed, Age based Reports, and HMOs eligibility listings.
• Developed and executed test cases, Benefits administration (Event Maintenance and Annual enrollment) test cases. Involved in testing quarterly and annual reporting batch processes.
• Involved in developing training material for PeopleSoft HR, Payroll and Benefits.
• Worked on various self-service screens to hide or display only some of the options on the pages based on certain conditions driven by functional requirements.
• Involved in Unit Testing, System Integration, User & Parallel testing during upgrade of PeopleSoft system from 8.3 to 8.8.