OBJECTIVE:

• Looking for a challenging position as a technical resource in Peoplesoft HCM application.
• Eighteen year experience in process analysis, application design, and development of intelligent user interfaces in PeopleSoft.
• Eighteen years of technical experience in a complete implementation, support and upgrade of PeopleSoft HR, eRecruit and Performance application.
• Proven ability to consistently deliver high-quality applications on time, under budget, and with optimal design.
• All experience with large corporations with over 50,000 employees.
• Leadership and mentoring of development team.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Technical

• HPD is a performance monitoring system developed for HR in PeopleSoft 9.1. The system provides an interface for the employee to enter goals for the year. The performance of the employee is evaluated at midyear and end of the year. The manager and the second level manager rate the employee's performance. The interface also allows input from a matrix manager for the employee who works for multiple managers. The ratings help HR to then categorize employees on 1 9 scale based on performance. This system also allows for setting up succession plans based on readiness scale of immediate , within one year , etc. Multiple reports can be generated both at Mid-year and End of the year summarizing the goals, performance, succession plans, readiness, etc. HR uses these reports to generate efficiency in resources by aligning the goals of individuals with the corporate vision. The system interfaces with Payroll to generate bonus, etc. based on individual's performance. I was involved in multiple aspects of this system design and development using various technologies like Javascript, Peopletools, HTML, with Oracle back end.
• An offline module was created using Oracle database to enable the management to complete reviews of employees while in office. The system stores data locally and then synchronizes with the main Peoplesoft system when connected back to intranet.
• Created functionality for the Managers and Employees for entering goals and manager feedback using PeopleTools 8.5 and Javascript.
• Designed and developed a functionality for entering multiple parameters required for generating custom reports for Succession Planning and Performance Development Summary PDS .
• Designed and developed functionality for offline performance tool using Peopletools and JavaScript.
• Redesigned and developed pages to accommodate Matrix manager approval for Goals and PDS.
• Extensively updated and modified multiple Application Engine SQLs to accommodate evolving requirements.

Confidential

• Supported HCM 8.9 an eRecruit modules.
• Worked with users to gather requirements and customized the Online Application templates. Worked on configuring the security for the custom modules by identifying the new pages and creating new permission lists and Roles. Worked with the security team in designing testing the dynamic security to assign the new roles for the users.

Confidential

Technical Workforce Manager

Worked on moving part of HR transactions to Manager Self Service in PeopleSoft 9.0, PeopleTools 8.49. Generated Word and PDF documents using XML publisher. Generated HTML emails for the transactions.

Functional/Technical eRecruit/Talent Acquisition Manager

Extensive functional and technical experience in all phases of HRMS system development. Expert-level knowledge of application development using PeopleTools. Worked closely with functional and strategy analysts to define and refine requirements. Built collaborative relationships with strategy, QA, and documentation teams in order to guarantee successful software delivery. Broad experience fixing reported customer issues across all applications and releases.

PeopleSoft 9.0 TAM CG Upgrade

• Lead a team for the implementation of TAM CG and upgrade from eRecruit 8.3 to 9.0.
• Conducted Fit Gap Analysis for the eRecruit application from 8.3 to 9.0. Analyzed the impact of the Person model in PeopleSoft 9.0.
• Leveraged the delivered functionality in PeopleSoft 9.0 eRecruit/ Talent Acquisition Manager to remove redundant customizations from 8.3.
• Determined the customizations required to the delivered PeopleSoft 9.0 eRecruit/ Talent Acquisition Manager system to implement the corporate hiring policies.
• Created and directed the creation of technical specifications to be used by the co-source/offshore partners for development of the PeopleSoft 9.0 customizations.
• Created numerous pages, Component Interfaces, Records, Application Engines, and other objects using PeopleTools 8.49.
• Developed a system to purge the historical applicant data to remove 700,000 profiles in an efficient manner using SQR, PL/SQL, and Import and Export functions of Oracle database engine The delivered PeopleSoft purge program is inadequate for the volume of data to be purged.
• Reports Created reports in SQR for -
• Open Job Requisitions for a given Business Unit/Department
• Employee Referral Validation report
• Quarterly Applicant Flow Report
• Days Posted
• Applicant Source
• Time to Offer a Job
• Generate eApplication PDF

PeopleSoft 8.3 eRecruit Implementation and Production Support

• Lead and directed a team for the eRecruit implementation providing Technical support through the entire development cycle.
• eHire system integrated with eRecruit - with eOffer and eResponse modules Singlehandedly designed, created specifications, and developed this custom system to enable the recruiters to have the offer approved by managers, send the offer to the candidate and get online response from the candidate. This system was created using PeopleSoft Workflow and extensive PeopleCode programming. Candidates can see the offer letter created online in Word RTF format. RTF programming was embedded in PeopleCode.
• Recruiter Desktop Created a pagelet on the Portal for the recruiters to display information about their open requisitions. Links are provided to navigate to the eRecruit pages.
• Customized the PeopleSoft eRecruit to allow for multiple Recruitment Administrators.
• Created a process to generate Word RTF documents for communication to the applicants. This module was created using PeopleCode to create MS Word documents for user-friendly color RTF output. These reports were created using word templates and rtf programming.. These documents, e.g. Offer letters, Rejection letters, Interview letters, etc. were created and displayed online to the user.
• Mass Applicant Transfer Created a module to mass update the status of the applicants for any Job requisition.
• Designed and created a completely new Verity Index for the applcants to search through the Job requisitions. This was not available via delivered PeopleSoft. This allowed for a quick keyword search on job descriptions. This was programmed using SQR and UNIX Shell scripts.
• Singlehandedly redesigned, and developed a process to build the Verity Index on Applicant Profiles for weekly complete refreshes and hourly incremental refreshes. The PeopleSoft delivered verity Index build program only ran efficiently for 80,000 profiles which did not meet the business requirement. The redesigned program efficiently processes and indexes 1,200,000 applicant profiles.
• Integration with HireRight Configured Business Interlinks to integrate with HireRight to provide Backround check report. The messages, report, from HireRight are routed to the PeopleSoft eRecruitment using Application messaging. Tested the sync and async messages generated via transactions with HireRight.
• Integration with Arbita This is a vendor for the all the Job Posting Boards like Monster, Dice, etc. eRecruitment posting can be published to Arbita and from Arbita to all the Job Posting sites. Arbita manages the posts on all the Job Posting boards on behalf of PeopleSoft eRecruit. The information from eRecruitment to Arbita is managed by Business Interlinks and Application Messaging. The asynch Messages from Arbita to PeopleSoft eRecruit were customized to provide additional information relating to the Job Posting board.
• Created a module to track applicant activity. This is a Bar Chart on a page to display statistics for the applicants and Job Requisitions.
• Interfaces Created interface to the American Job Bank using SQR. This included information about the about all the open Jobs posted in the eRecruit system. This is a nightly batch process scheduled via Maestro Scheduler and the output was sent via ftp.
• Created interface to Arbita for the Job Posting Delete. This interface communicates all the postings that are to be removed from the Job posting boards. This is a nightly batch process and the output is sent via ftp.

PeopleSoft 8.3 HRMS

• Created an SQR program to create Benefits Enrollment forms for Open Enrollments. These forms listed all the options and the costs of all these options available to the colleagues depending upon their locations of work and status orf employment. This could be run for an individual or in batch mode through nightly processing for the entire population. The data was sourced from Benefits Administration tables. The SQR program was customized from the delivered application.
• Created a program to issue refunds to the employees for the partial deductions in case of a mid month terminations. The premium paid for benefits was prorated for the number of days in a month the employee was employed and the refund amount was uploaded to the paysheets as a Pay One Time refund. A panel was created for the user to see such refunds and approve them before they were paid out.
• Created a report in SQR to generate a Total Compesation report. This included all the forms of compensation that was made to the employee and included the base pay, the bonus, the employer contributions to the 401K, the pension payments on behalf of the employee, the cost of benefits given for free to the employee, etc. This report was created and used during the annual talent review.

Confidential

Functional/Technical

Peoplesoft HRMS 6.0

• This is PeopleSoft system based on Oracle 7.0
• Created a system bolted on the Benefits module of PeopleSoft HRMS. The employee elections were made and the beginning of the year each year. The Benefit enrollment information was used to create enrollment records in intefrface files to be sent to the vendors for each Benefit. The interface programs were written for each vendor. These interfaces ran each month and the output files were sent via ftp. SQR was used to create the interface programs. Created Pages to set up data for the vendors. The enrollment records were also used to create vendor invoices. These invoices were then sent to the Accounts Payable department to make the payments to the Vendors. Any terminations were also reported to the vendors via the interface files. Any creadits due from the vendors were also reported to the Vendors.
• Created SQR reports to generate Imputed Income information. This information was generated for the Life Insurance benefits. The Amount of Tax due was inserted into the General deduction table in the payroll modules for deduction from the employees paycheck.

Confidential

Functional/Technical

Peoplesoft Financials 6.0

• This is PeopleSoft system based on Oracle 7.0
• This is an PS Financials systems based on Oracle 7.0 designed and developed Workflow Process to interface with Lotus Notes Forms and E-MAIL. Extensively involved in the conceptual /configuration/setup and design of PeopleSoft Accounts Receivable.
• Created Technical specifications from the Functional specifications for the custom reports.
• Developed custom reports in SQR for Accounts Receivables system. Used Stored procedures for implementing corporate policies and for easier maintenance and consistent results between different programs and processes across the departments and business units.
• Involved in Performance and Tuning of complex queries in various batch programs that were running for a long time. Effectively used Indexes and Autotrace, and Explain Plan to determine a better way of writing the SQLs for a more efficient response.
• Set up Shell scripts to manage the output files created via batch programs and ftp'ed the files created to the vendor sites.

Confidential

Functional/Technical

Peoplesoft HRMS 5.0

• This is an HRMS systems based on Oracle 7.0
• Set up and facilitated JAD sessions with the clients. Created Functional as well as the Technical requirements for the bolt-on application for Direct Reports Event Tracking system.
• Created an SQR to generate an Employee Profile from PeopleSoft HR tables. The Profile included the information relating to Education, Work Experience, Training, Certifications, and Licences and other details like Awards, etc. The PS HRMS database was an Oracle 7.0 database.
• Created Panels using Application Designer to set up data for direct reports' email information.
• Created and customized PeopleCode in the HRMS system to process information from JOB and Employment records.
• Designed a bolt-on system in PeopleSoft to manage events for a manager's direct reports. Custom tables were created to house events triggered from Personal Data, JOB or Employment data. Created an SQR to generate emails nightly congratulatory emails from Manager to the direct reports on Birthdays, Anniversaries, or Return from LTD, etc.
• Created shell scripts for UNIX to schedule and run the nightly SQR batch jobs.
• Provided guidance and technical support to the development team.
• Created SQL queries and views for Crystal reports. Improved the performance of complex queries through efficient use of Indexes and better form of the queries to leverage the advantages of Rule based optimizer in Oracle.

Confidential

Consultant

Annual Meeting System

• Finance ministers of the world meet once a year. The logistics were managed using a Sybase-Uniface system. SQR reporting, stored procedures, triggers were extensively used. I was involved in all the phases of system development - requirements gathering, prototyping, developing, and testing.
• SQR was used to Mail Merge invitation letters to create Word Perfect documents. These were printed and mailed to the more than 200 delegates from around the world.
• The hotel accommodation information for the delegates was tracked in the database and all the information was compiled to create a Phone Book for the event. This processing was all performed via SQR programs employing stored procedures and triggers.
• Badges were created via sqr reports at the registration.
• Worked on designing and developing the user interface in Uniface.
• Created a report for expense reimbursement. The expenses of the delegates were partly paid by the organization.
• Created an SQR report to print checks for the expense reimbursement.