SUMMARY:

• IT technology consultant with over sixteen years of experience in implementation and upgrade of PeopleSoft Enterprise Systems across multiple industries.
• Expertise in Database Analysis, Design and Development using PeopleTools, LINUX/UNIX, ORACLE, and DB2.
• More than ten years of Lead experience providing Technical and Functional support to PeopleSoft HCM and FSCM applications.
• System development and implementation skills include programming, data modeling, data analysis, database tuning, systems integration, data conversion, application upgrades, and business process analysis.

EXPERTISE:

Languages: C, C++, Java, HTML, Pro*C and SQR

OS: UNIX, Windows NT, AIX, OS/2, VAX/VMS

Platforms: IBM RS6000, SUN SOLARIS, NOVELL, VAX4500, VAX8250, DEC ALPH, APC/AT, NT

RDBMS: ORACLE, SQL Server7.0, DB2, IMS, IDMS

Software: PeopleSoft(HCM, Payroll, Payroll Interface, Financials) 8.x - 9.x, SQL*Plus, PL/SQL, Informatica 1.6.

EXPERIENCE:

Confidential, Pleasanton, CA

Technical Consultant

Responsibilities:

• Conducted impact analysis and applied key Tax updates 11-D thru 11-F.
• Built custom processes for PA ACT-32 changes to update/insert tax data for Pennsylvania employees.
• Supported Year-End Payroll and GL activities.
• UI for time entry, approvals, and proxy approvals workflow and routing based on business rules
• Application Engine programs to execute business logic
• Implementation of row level security
• Integration between PeopleSoft and Active Directory based on Application Engine/Web Service/Component Interface
• Also, assisted in design and execution of performance testing.
• Upgrade/Re-Implementation of PeopleSoft (HCM) 9.0 from 7.02: The project involved reimplementation of the Enterprise HCM system in PeopleSoft v9.0 (modules HR, Payroll and Ben-Admin). The scope included conversion of HR, Benefits, and Payroll data for 1.5 million employee records from the legacy heavily customized PeopleSoft v7.02 system.
• Designed and developed numerous SQR and Application Engine conversion processes to move PeopleSoft V7.02 HR, Payroll & Benefits data to PeopleSoft V9.0 schema. Tuned these conversion processes to complete the cutover activities within 36 hrs. Also, actively participated in cutover planning and execution.
• Redesigned the legacy (V7.02) customizations and applied them in V9.
• Designed and developed customizations to support Payroll to GL Interface (PAYGL01.SQR) and custom GL accruals and other accounting entrees to Corp GL system. Set the Chart fields based on Client requirements to support temp employees payrolls.
• Setup Integration Broker between PeopleSoft FSCM and PeopleSoft HCM to integrate Departments, GL Accounts, Product, Operating unit and Locations.
• Developed customizations to support Bill-139 Canadian regulatory requirements.
• Applied Tax-Updates and mentored the team to apply Tax-Update and Test Tax-Update changes.
• Support Day to day payroll issues. Created payroll audit reports legal requirements.
• Designed, developed, deployed batch schedules using AutoSys.

Environment: SUN Solaris, Oracle 11G, PeopleTools 8.4X and SQR

Confidential, San Mateo, CA

Technical Consultant

Responsibilities:

• PeopleSoft ELM Upgrade From v8.8 to v8.9 - As a member of the development team, built custom Full-Sync JOB process, applied customizations to the online application and batch processes. Also, customized LM-Search based on customer needs and setup Integration Broker to publish Job Data & Personal Data transactions from PeopleSoft HCM to PeopleSoft ELM. Configured Messages, Queues, Services, Service Operations, Nodes in Integration Broker.
• Separate Account Revenue Automation (SARA) - Technical consultant to the multi-million dollar strategic project to build a custom bolt-on module to the Enterprise PeopleSoft FSCM system to automate revenue fee calculation for Individual and Group high net worth accounts of Franklin. The calculations were based on Fee type and other complex business rules. Integrations were built to interface the data to PeopleSoft BI, AR & GL modules.
• PeopleSoft FSCM 8.4 to PeopleSoft 8.9 Upgrade - Member of the technical team involved in the upgrade of PeopleSoft v8.4 to v8.9. Upgraded modules include AP, AR, BI, GL, PO, PC and ePRO.
• Upgraded reports, interfaces, and re-applied customizations. Researched application bugs in Project costing. Since PeopleSoft redesigned project costing in v8.9, there were a lot of bugs introduced which were identified and resolved. Also modified upgrade conversion scripts/post SQL scripts to fix related data issues.
• PeopleSoft HCM 8.3 to PeopleSoft 8.9 Upgrade - Member of the technical team involved in the upgrade of PeopleSoft HCM v8.3 to v8.9. Modules included HR, Payroll Interface, and Base benefits.
• Designed and developed process to Convert Contractors and employees to single Employee id (8.9 Person Model). Developed Cutover scripts to get PeopleSoft User id Info from 8.3 and Roles and Permission info from 8.9 source database. Configured payroll interface for US and Canada for ADP and supported. Designed and developed Interface between HR to Microsoft Project server (MSPS) to create/lock user id
• Designed and developed a custom bolt-on application to the PeopleSoft HCM system for automating Server and application access management. The solution leverages real time HR data and workflow to administer system accounts.

Environment: SUN Solaris, Oracle 10.X, PeopleTools 8.4X, and SQR

Confidential, Pleasanton, CA

Technical Consultant

Responsibilities:

• Redesigned PeopleSoft Payroll Batch to improve performance & meet service level agreements with Business.
• Also, was involved in the implementation of the PeopleSoft HCM 8.8 for an employee base of 120,000.
• Designed and developed many on-line customizations for eProfile, eCompensation, Manager Self service, and eBenefits.
• Also built custom solutions to track licenses and certificates (LCRC) of hospital staff and send 30, 15, 7 Day and expired notification to managers.

Environment: Mainframe, DB2, PeopleTools 8.4X and SQR

Confidential, San Mateo, CA

Technical Consultant

Responsibilities:

• Implementation of PeopleSoft ELM 8.8: Converted Course & Class room related data from legacy system (Training server) to PeopleSoft ELM 8.8. Customized PeopleSoft delivered Learning group logic. Built integrations to the PeopleSoft HR and Financials and also developed a custom solution for administering the Tuition assistance Program (TAP).
• Designed and developed a set of processes to automate Fund Fee Revenue from CODA (Fund Accounting System) to PS Financials system.
• This involved development of Interfaces from CODA to Billing, Payment Interface in PS Receivables, modifications to BI to AR interface, Payment Predictor implementation, and Bank Letter Processes.
• Designed and developed data mapping between CODA and PS Financials systems.
• Sales and Commission system: Designed, Developed and implemented a complex SOX compliant bolt-on solution to the PeopleSoft HCM system for Sales & Commission calculation, tracking, review and approvals.

Environment: SUN Solaris5.X, Oracle 10.X, PeopleTools 8.X, and SQR