Current Work History:

• Over 17 years PeopleSoft project experience. Last 14 years PeopleSoft as an employee of Verizon Wireless Verizon Corporate.
• Last 10 years QA PeopleSoft HR/Payroll/Vets100/ELM/Kronos/Compensation/HR to Finance, working with users, writing requirements, writing test plans, testing, documenting, reporting and extensive experience with Test Director / HP Quality Center. Also, PeopleSoft Conversions, Upgrades, and Verizon Wireless Verizon Payroll HR Consolidations. Extensive use of VPN, Microsoft Excel, Outlook, Word, Visio Oracle11g, Quest's Toad SQL , Ultra Edit, PS/Query for testing creating test files.

Prior Work History:

• As a senior consultant W2, US Citizen with over thirty years of diversified data processing experience, including twenty years of consulting. Three mainframe to PeopleSoft/Unix/Oracle conversions two HRMS and one Financial EA AR . Extensive overtime for both clients. Training and experience in CONVOY to generate SQR's for conversions to PeopleSoft. Many SQR's for loading, extracting and reporting. Over 20 years Human Resources experience.
• Hands-on Training: PeopleSoft Payroll US Rel 8.9 at Oracle University August 2007
• Cognos 2 day training class on site at Verizon Wireless, 2007
• Oracle9i: Hands-On Introduction at Learning Tree in NYC June 2006
• PeopleSoft ELM 4 day class at PeopleSoft in Atlanta, 2005
• PeopleSoft Tools I 7.5 at PeopleSoft in Teaneck, NJ. 2000
• PeopleSoft Tools II 7.5 at PeopleSoft in Teaneck, NJ. 2000
• PeopleSoft Tools I at PeopleSoft in Bethesda, Maryland. 1996
• PeopleSoft SQL/SQR class at PeopleSoft in Philadelphia. 1996
• Home System: Dell 8400 Dimension Pentium 4, HP Photosmart 2710xi printer, Cablevision internet provider.

Confidential

• Conversion of Bell Atlantic Mobile from Ceridian HR/Benefits/Payroll to PeopleSoft 7.5 HRMS production 05/2000. Worked on conversion/merger of BAM, PrimeCo Wireless, GTE Wireless, Airtouch Wireless into Verizon Wireless 06/2000 to 01/01/2001. Ran Data Mover scripts, Import
• Manager PeopleSoft's SQRs to load tables from files supplied by the 4 merging companies. I wrote a new year 2001 SQR to insert a startup row with the 4 companies new Company codes, Location codes, Jobcodes, Dept codes, etc. Also wrote an SQR to insert new salary increases Merit for the companies now making up Verizon Wireless. Modified PeopleSoft Express' Conversion SQRs to load 8.3 PeopleSoft tables for Price Communications company we purchased . Moved from developer to QA tester in 2003. Worked with Compensation each year testing annual Merit enhancements and the changed process. Worked with HR to test the Annual EEO Vets100 reporting changes. Co-wrote test plan and co-tested the ongoing HR to PeopleSoft
• Finance interface, sending employee's chartfields to Finance. Facilitated daily QC defects conference calls sharing my computer screen QC defects with users developers. With HR and Java developer wrote test plan and tested with 3G cell phone phone app for store managers to give security and job functions to store employees over their cell phones. App interfaced with
• PeopleSoft HR database. Wrote test plan and tested Kronos Enrollment process for store
• employees to report their hours and schedule, over 2000 Verizon Wireless stores. Also, with HR wrote test plans testing of ongoing enhancements to Workforce Admin. One-HR project, tested the merger of Verizon Wireless Wireline domestic and international into one PeopleSoft 9.1 HR system. Validated converted tables and new WFA functionality.

Confidential

• IDMS CRS Contract Record System and A/R conversion to PeopleSoft 6.0 Financial System. Mainframe IDMS/COBOL extracts, FTP's to Unix, SQR's to load PeopleSoft Oracle tables. Unix, Oracle SQR experience. Created conversion task/checklist for consultants and employees to follow in doing this major financial conversion. Wrote VISIO flowcharts of the conversion process. Wrote Unix shell scripts to: execute multiple CONVOY generated SQR's in load order sequence, to count rows in FTP'd files, to move files, to concatenate load .dat files and to
• remove .dat files. Added commands to Unix shell scripts to call manager's pager if load SQR's failed and when the load scripts finished. I also wrote SQL to load certain default customers and projects. Forty-two tables where loaded. Final production load was completed on time in July 1999 for KPMG's fiscal year 2000. I wrote four post-load SQR's for Security they report on and compare security access of the production database to that of the reporting database. Using Database links the SQR's can compare the over 1,000 operator ID's on production and reporting, and the business units they have access to. The SQR's also write out files that are imported into Access and Excel. Two of the SQR's write out only the exceptions in security between the two database instances. These SQR's will be run nightly in batch using maestro job scheduler.

Confidential

• IDMS HR/Benefits MSA Payroll to PeopleSoft 7.0 HR/Benefits/Payroll project.
• Research and document current IDMS ADS/O and batch HR/Flex Benefits System for PeopleSoft conversion. Documented system and business rules using Word Visio. Data-mapped PeopleSoft records to fields in IDMS records using Excel for data-mapping document. Also, researched and documented MSA Payroll transactions DOE's that are generated by the flexible benefits system.
• Wrote Cobol programs to extract data from the legacy IDMS system for HR Benefits. Using CONVOY, generated load SQR's to load PeopleSoft tables. Tested SQR's using SQRW for small offices to build test training databases. Downloaded mainframe extract files to 'C' drive for SQRW loads. FTP'd SQR's and mainframe extract files to Unix directories for high-volume loads and the final production loads. Ran production loads using Unix scripts. Checked load status using Unix commands and Oracle SQL/Plus commands. Initialized the PS Installation table with the starting Emplid number before loading PS Personal Data. Loaded all KPMG's 55,981 employees 23,000 actives HR and Benefits tables over a million rows just in PS JOB. Wrote post-load SQR's for after conversion cleanup.