SUMMARY

• 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

Languages/Tools: PeopleCode, PeopleTools, Application Engine, Component Interface, Business Interlinks, Application Messaging, SQR, PSQuery, SQL, HTML, PL/SQL, Shell scripting, Javascript

DBMS: Oracle, Sybase, Informix

PS Applications: eRecruit, Talent Acquisition Manager, Performance Management, HRMS, Benefits

PROFESSIONAL EXPERIENCE

Confidential, NJ

Technical Lead

Responsibilities:

• Created functionality for teh 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 . NJ

Technical (Workforce Manager)

Responsibilities:

• Conducted Fit Gap Analysis for teh eRecruit application from 8.3 to 9.0. Analyzed teh impact of teh Person model in PeopleSoft 9.0.
• Leveraged teh delivered functionality in PeopleSoft 9.0 eRecruit/ Talent Acquisition Manager to remove redundant customizations from 8.3.
• Determined teh customizations required to teh delivered PeopleSoft 9.0 eRecruit/ Talent Acquisition Manager system to implement teh corporate hiring policies.
• Created and directed teh creation of technical specifications to be used by teh co-source/offshore partners for development of teh PeopleSoft 9.0 customizations.
• Created numerous pages, Component Interfaces, Records, Application Engines, and other objects using PeopleTools 8.49.
• Developed a system to purge teh 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 - Teh delivered PeopleSoft purge program is
• eHire system integrated with eRecruit - with eOffer and eResponse modules - Singlehandedly designed, created specifications, and developed dis custom system to enable teh recruiters to have teh offer approved by managers, send teh offer to teh candidate and get online response from teh candidate. dis system was created using PeopleSoft Workflow and extensive PeopleCode programming. Candidates can see teh offer letter created online in Word RTF format. RTF programming was embedded in PeopleCode.
• Created a pagelet on teh Portal for teh recruiters to display information about their open requisitions. Links are provided to navigate to teh eRecruit pages.
• Customized teh PeopleSoft eRecruit to allow for multiple Recruitment Administrators.
• Created a process to generate Word RTF documents for communication to teh applicants. dis 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 teh user.
• Created a module to mass update teh status of teh applicants for any Job requisition.
• Designed and created a completely new Verity Index for teh applcants to search through teh Job requisitions. dis was not available via delivered PeopleSoft. dis allowed for a quick keyword search on job descriptions. dis was programmed using SQR and UNIX Shell scripts.
• Singlehandedly redesigned, and developed a process to build teh Verity Index on Applicant Profiles for weekly complete refreshes and hourly incremental refreshes. Teh PeopleSoft delivered verity Index build program only ran efficiently for 80,000 profiles which did not meet teh business requirement. Teh redesigned program efficiently processes and indexes 1,200,000 applicant profiles.
• Configured Business Interlinks to integrate with HireRight to provide Backround check report. Teh messages, report, from HireRight are routed to teh PeopleSoft eRecruitment using Application messaging. Tested teh sync and async messages generated via transactions with HireRight.
• dis is a vendor for teh all teh Job Posting Boards like Monster, Dice, etc. eRecruitment posting can be published to Arbita and from Arbita to all teh Job Posting sites. Arbita manages teh posts on all teh Job Posting boards on behalf of PeopleSoft eRecruit. Teh information from eRecruitment to Arbita is managed by Business Interlinks and Application Messaging. Teh asynch Messages from Arbita to PeopleSoft eRecruit were customized to provide additional information relating to teh Job Posting board.
• Created a module to track applicant activity. dis is a Bar Chart on a page to display statistics for teh applicants and Job Requisitions.
• Created interface to teh American Job Bank using SQR. dis included information about teh about all teh open Jobs posted in teh eRecruit system. dis is a nightly batch process scheduled via Maestro Scheduler and teh output was sent via ftp.
• Created an SQR program to create Benefits Enrollment forms for Open Enrollments. These forms listed all teh options and teh costs of all these options available to teh colleagues depending upon their locations of work and status orf employment. dis could be run for an individual or in batch mode through nightly processing for teh entire population. Teh data was sourced from Benefits Administration tables. Teh SQR program was customized from teh delivered application.
• Created a program to issue refunds to teh employees for teh partial deductions in case of a mid month terminations. Teh premium paid for benefits was prorated for teh number of days in a month teh employee was employed and teh refund amount was uploaded to teh paysheets as a Pay One Time refund. A panel was created for teh user to see such refunds and approve them before they were paid out.
• Created a report in SQR to generate a Total Compesation report. dis included all teh forms of compensation that was made to teh employee and included teh base pay, teh bonus, teh employer contributions to teh 401K, teh pension payments on behalf of teh employee, teh cost of benefits given for free to teh employee, etc. dis report was created and used during teh annual talent review.

Confidential, Manhattan, NY

Functional/Technical

Responsibilities:

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

Confidential, Hackettstown, NJ

Functional/Technical

Responsibilities:

• dis 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 teh conceptual /configuration/setup and design of PeopleSoft Accounts Receivable.
• Created Technical specifications from teh Functional specifications for teh 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 teh 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 teh SQLs for a more efficient response.
• Set up Shell scripts to manage teh output files created via batch programs and ftp’ed teh files created to teh vendor sites.

Confidential, Washington DC

Functional/Technical

Responsibilities:

• Set up and facilitated JAD sessions with teh clients. Created Functional as well as teh Technical requirements for teh bolt-on application for Direct Reports Event Tracking system.
• Created an SQR to generate an Employee Profile from PeopleSoft HR tables. Teh Profile included teh information relating to Education, Work Experience, Training, Certifications, and Licences and other details like Awards, etc. Teh 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 teh 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 teh direct reports on Birthdays, Anniversaries, or Return from LTD, etc.
• Created shell scripts for UNIX to schedule and run teh nightly SQR batch jobs.
• Provided guidance and technical support to teh development team.
• Created SQL queries and views for Crystal reports. Improved teh performance of complex queries through efficient use of Indexes and better form of teh queries to leverage teh advantages of Rule based optimizer in Oracle.

Confidential, Washington DC

Consultant

Responsibilities:

• SQR was used to Mail Merge invitation letters to create Word Perfect documents. These were printed and mailed to teh more than 200 delegates from around teh world.
• Teh hotel accommodation information for teh delegates was tracked in teh database and all teh information was compiled to create a Phone Book for teh event. dis processing was all performed via SQR programs employing stored procedures and triggers.
• Badges were created via sqr reports at teh registration.
• Worked on designing and developing teh user interface in Uniface.
• Created a report for expense reimbursement. Teh expenses of teh delegates were partly paid by teh organization.
• Created an SQR report to print checks for teh expense reimbursement.