SUMMARY

• MS in Computer Science with 10 years of IT experience in design, development, testing and analysis of software applications.
• Experience in the areas of system analysis, design, development and implementation of various application using PeopleSoft, MS SQL Server, Oracle, Oracle Designer/2000, Developer/2000, Visual Basic 6.0/5.0
• Experience in design, construction, integration testing, data conversation, and implementation activities of small/large scale PeopleSoft projects.
• Proficient in design, developing customizations, interfacing, conversion activities.
• Strong knowledge in PeopleCode, People Tools, SQR, Application Engine, Component Interfaces, WorkFlow,Integration Broker.
• Very good understanding of Relational Database Design, Object Oriented Design and Structured Methodology Concepts.
• Good logical and business analytical thinking, excellent communication skills, and positive approach to work independently or in a team.

TECHNICAL SKILLS

ERP: PeopleSoft HRMS v7.5x/8.x/8.8/9.0 (HR, Payroll, x Benefits Administration, Time and Labor), PeopleSoft Financials V8.4, SQR 3.x/4.x

People Tools: Application Designer, Application Engine, Workflow, Component Interfaces, Integration Broker, PeopleCode,PSQuery

Reporting Tools: SQR 3.x/4.x/6.0, Oracle Reports, Crystal Reports

Languages: C/C++, SQL

Operating Systems: UNIX, Windows 98 / NT 4.0, DOS

RDBMS: Oracle 10, DB2,MS Access 2000, Postgre - SQL, MSSQL-SERVER, mySQL

Web Development: HTML, PHP, Perl, XML, JavaScript

GUI: Visual Basic 5.0, Developer 2000

PROFESSIONAL EXPERIENCE

Confidential, Pleasesanton, CA

PeopleSoft Benefits Consultant

Responsibilities:

• Worked on various enhancement projects ACA,Harrington Health, Confidential Dental etc.
• Worked on benefits side of Maintenance pack project in 2014.
• Mainly worked on the enhancements and maintaining Authoria bridge which supplies benefits information to Peoplefluent Authoria.
• Modified authoria bridge to accomdate adding new plan types to support OE and accomodating accrued timeoff changes .
• Retrofitted authoria program for HCM 9.1 release.
• Retrofitted various leave accruals interfaces for HCM 9.1 upgrade.
• Enhanced Fidelity inbound and outbound interfaces for adding new eligibility rules and eligibility date calculations.
• Worked as production support resource for monitoring nightly batch support.
• Worked on various production critical batch programs.

Environment: PeopleSoft HRMS 8.8/9.1, PeopleTools,8.45/8.50 PeopleCode, SQR Reports, DB2, Mainframex.

Confidential, San Leandro, CA

Production support

Responsibilities:

• Designed and developed Date of Hire interface for automation of change in the date of hire process through different components of PeopleSoft.
• Modified vendor export AETNA program for different reasons like excluding terminations, waivers for weekly enrollees, sum-up negative contributions to a whole dollar amount.
• Automated price increase for financial systems for calculating service fee for customers.
• Modified open regional enrollment program to include new plan types for states in east coast.
• Towards the end of the year did PeopleSoft application upgrade to version 9.0.
• Designed developed and implemented business unit security to the system by newly adding business unit structure to the Employees.
• Converted some of the programs for make the compatible for version 9.0.
• Converted all the application messages currently existing for interacting with Web dev team into container messages using Integration Broker.
• Resolved issues with the payroll processing and messaging on a daily basis.
• Got certifications for PeopleSoft functional and technical delta classes.
• Worked extensively on integration broker messaging maintainance.
• Made changes to the programs supporting Payroll engine V2.
• Modified special payroll hours process program for off-cycle payrolls.
• Worked on a group project for bringing another clients plans to Confidential .Mainly worked modifications to bas activity records and changing benefit options pages.
• Developed interface for company Billing Load and Min funding project for Benefits team.

Environment: PeopleSoft HRMS 8.8/9.0, PeopleTools,8.46/8.48 PeopleCode, SQR Reports, Oracle 10.2, Unix.

Confidential, Oakland, CA

PeopleSoft HRMS production support

Responsibilities:

• Turned various processes to production like check jobcode, Severance calculation based on hire date and service date, Meba Salary Progression, Location Report.
• Created several reports for HR processing with the ability of showing hierarchical structure of the organization.
• Fixed the issues with the master employee record report to calculate the exchange rates of the currencies accurately.
• Developed a SQR report for calculation of one year service awards for OC Tanner.
• Developed workflow to sending out notification to Payroll Dept upon termination of an employee.
• Developed workflow for sending notification to HR manager upon employee termination.
• Customized pages to allow processing of multiple employees in Employee Profile Process.
• Developed a process for updating office number of the employees.
• Developed component interfaces for updating job data with promotion/demotion information.
• Developed component interface for updating job data with data changes.
• Developed changes in Job Data component to enable to view HR Mangers at the work location.
• Developed reports for detail Merit reporting by Organization Managers.
• Developed Americas region employee headcount report for counting employees by location.

Environment: PeopleSoft HRMS 8.8, PeopleTools, PeopleCode, SQR Reports, Oracle 9i, Unix

Confidential, Pasadena, CA

PeopleSoft HRMS Consultant

Responsibilities:

• Developed interfaces for staging in employee relocation expense data from ADP to PeopleSoft
• Payroll based on the new codes for relocation reimbursements and relocation invoices.
• Turned the leave report (CWPAY250) giving employee information for a particular pay period to production.
• Performed ‘U’ runs for batch inserts for employee payroll information having adjustments in production.
• Developed and coded an interface for updating PeopleSoft Garnishment tables with limit amounts obtained from ADP input files.
• Modified the delivered employee other earnings register to list by payroll analyst and be able to run from the portal thru the run control page.
• Developed employee current pay period report to show employees current pay period time data.
• Turned incentive stock options interface to staging to payroll from where it eventually is entered to pay sheets for further payroll processing.
• Fixed the issues with the ISO staging to payroll staging tables from where the data gets loaded to pay sheets.
• Provided support in repass of employee SSN, Employee Bonus OT details in production for the discrepancies to ADP.
• Development of the back pay employee books in ADP for above 3000 Employees
• Developed interface program for Garnishment to AP interface where garnishment pays were being sent to AP.
• Fixed customized Direct Deposit File program to accommodate multiple pay check employees also turn off prenotfication records being sent on the direct deposit file.
• Turned eligibility file to production after payroll going live with the changes to ignore 2 month waiting period.
• Worked as production support in running various inbound files for ADP prior to go-live for each payroll run.
• Developed Correction timecard program for getting OT amounts of employees with correction in the timecard of previous pay periods.
• Modified Service date adjustment program in Benefits to accommodate the changes in Leave accruals status.
• Modified Direct Deposit program to turn on prenotification on Direct Deposit file also made changes to include wait period on source bank table for receiving direct deposits.
• Modified multiple worksite report(Tax004) for BLS reporting to correctly represent the addresses.
• Modified CES report as per BLS requirements.
• Serviced one time requirements for Confidential organization.

Environment: PeopleSoft HRMS 8.8, PeopleTools, PeopleCode, SQR Reports and Oracle 9i

Confidential, Hartford, CT

PeopleSoft Financial Consultant

Responsibilities:

• Developed design specifications and developed interface and unit tested for GL Enhancement wherein ChartFields with no activity within 12-month period were reported and finally were closed by Corporate Finance.
• Developed design specifications and developed interface and unit tested for Treasury Enhancement wherein Bank Reconciliation Extracts were created for Treasury on daily basis and FTP’d to Treasury server.
• Fine-tuning of SQL queries was done to report ChartFields that were created newly but not used on ledgers.
• Participated in the design phase for AP enhancement, which adds contact information on unclaimed property letter.
• Developed build documents for the interfaces developed and unit tested for various conditions.
• Developed an interface to send payment details to Check data (apycrx01.sqr)
• Developed an interface, which reads in ChartField values and writes to flat file, which is FTP’d to FSDB mainframe.

Environment: PeopleSoft Financials 8.0, PeopleTools, PeopleCode, SQR Reports, and Microsoft SQL Server 2000

Confidential

PeopleSoft HRMS Consultant

Responsibilities:

• Modified delivered workflows in Birth/adoption Marriage/divorce life event and made of more user friendly and complaint with the current version.
• Customizations were done to the delivered workflows to change the activity guide steps and also the delivered notification through e-mail was modified according to company needs.
• Applied fixes for the Birth/adoption workflows in ebenefits to deliver the functionality of getting the person processing the event to dependent/beneficiary component.
• Created salary change workflows, which triggers in salary change once its approved by all three managerial levels.
• Modified the workflows to trigger benadmin process, which opens up open enrollment on registering of a life event.
• Customized existing modules in eBenefits to refresh data on adding new dependents.
• Written SQR's for Retiree's Passive Birth date Event and Service Years Passive Event.
• Turned SQR to production (ADDUNWAY), which adds United Way Pledges from a spreadsheet. It verifies that the Employee exists and they are active as well as making sure the Company on the file matches the company in PeopleSoft or it won't add the pledge.
• Applied the patch LWHX4WT 801 to the application release to enable the person handling birth/adoption event to the dependent/beneficiary information.
• Resolved the issues with the workflow for Salary Change in eCompensation Mgr Desktop.
• Customized eRecruit module to show exact status on requisition screening.
• Modified the underlying workflow in eRecruit to inform the alternators correctly about the approvals.
• Developed reports for TIA year-end reporting and customized existing reports (lge merit incr) to take in data based on current year.
• Applied Tax Updates 03-E, which includes updates to U.S. tax and garnishment rules tables, COBOL program and store statement changes and re-delivered SQR's for U.S. and Canadian Reporting.
• Designed and developed PeopleSoft Benefit customizations for vacation & other leave processes utilizing SQR.
• Modified PeopleSoft delivered reports to accommodate the changes that need to be made to accommodate the BLS reporting requirements.
• Modified several Reports like Benefit Enrollment report and Employee Processing reports, Absence History Report.

Environment: PeopleSoft HRMS 8.0, PeopleTools, PeopleCode, SQR Reports, and Microsoft SQLServer 2000

Confidential

Responsibilities:

• Analyzed existing customizations and determined the required changes to be made. Worked with the functional resources to decide the required customizations for the project.
• Designed and Developed inbound interface used to upload bonus or one time payments via an excel spreadsheet into PeopleSoft using SQR.
• Developed reports on Accrued Vacation using SQR.
• Configured and Implemented the Business Process Design for Leave approval (Workflow).
• Modified Peoplecode to resolve eBenefits Enrollment issues.

Environment: PeopleSoft HRMS 8.30/8.15/7.53, PeopleTools, PeopleCode, SQR Reports, Tree Manager, nVision, Crystal Reports, Oracle 8i, Unix (Sun Solaris)

Confidential, Philipsburg, MT

Programmer

Responsibilities:

• Designed and developed Young Voters Program.
• Developed matching game with the given zip code with the current candidates using PHP.
• Modified existing VB programs to make them compliant with the new database.
• Wrote stored procedures and triggers using Postgre-SQL

Environment: Windows 2000, PostgreSQL, PHP, and JavaScript