Wendy R. Yu
Potomac, MD *****
abnbjx@r.postjobfree.com
OBJECTIVE:
PeopleSoft position is in an Implementation, Upgrade, or Development
Environment.
SUMMARY:
** ***rs of Solid hands on experience in the area of PeopleSoft Human
Resources (HRMS), Payroll, and Financials Applications. This
includes extensive functional and technical expertise
gained from participation in a variety of PeopleSoft
Development, Implementation, and Upgrade Projects.
RELEVANT WORK HISTORY:
PeopleSoft Senior Consultant, Kforce, OH 10/2008 -
Present
DIMHRS Project: Functional analyzed on Workforce Administration,
Global Payroll, Job Data, Personal Data, Contract Data, and
Assisgment modules.
--Reviewed and analyzed existing report requirements of Air Force.
Meet with users to gather information. Wrote report requirements.
Map fields from current system to the DIMHRS system.
--Used SQL tool to validate data on the database level and application
level.
--Used PSTools to analyze the logic of chart fields in Line of Account
with SAF budgeting, accounting, disbursing and reporting process.
--Identified issues and provide solutions within DIMHRS system.
--Used PSTools to review table's structure within Data warehouse
between data marts. Prepare for reporting.
--Validated data in the EPM database.
--Reviewed test scripts and provided comments to the team.
Principal Test Engineer, Sapphire Technologies LLC, Woburm, MA
5/08 - 10/2008
Verizon:
--Write test scripts for Payroll and HR functionalities.
--Execute the scripts and verify data.
--Create data for testing.
--Migration projects.
PeopleSoft Senior Consultant, The Squires Group, Annapolis, MD
12/06 - 03/08
DIMHRS Project (Defense Integration Military Human Recourse system):
Implement and development with PeopleSoft HCM/HRMS on DIMHRS
--PeopleSoft Tools: v8.49.01
--Application Release: HRMS v8.90.000
--Database: DB2
--Functionalities: Modified and developed the functionalities on
Self Service, Manager Self Service, Workforce Administration,
Contract Data, eSignature, and Checklist.
--Tools: PeopleTools/Application Designer, Application Engine,
Portal, SQR, SQLs, DB2 as database, STAT as file management
tool, Clear Quest as tracking issue tool, and Actuate Report
tool.
--Documentation: Wrote test scripts and design document.
--Testing: Supported test group. Enter data to test PeopleCode,
Page and other PS objects, Security role, reports, and data files.
PeopleSoft Senior Consultant, Access System,Inc. Reston, VA
1/06-12/06
US Department of State:
Upgrade PeopleSoft HRMS (Human Resources) system from v7 to v8.8. My
project
is in the area of Workforce Administration, Position Management, and
Job Code, and the related set up tables.
--PeopleSoft Tools: v8.46
--Application Release: HRMS v8.8
--Database: Oracle v9.2
--Projects:
. Analyzed functional business requirement.
. Created technical design documents.
. Compared PeopleCode with V7 and V8.8.
. Customized all objects to meet the business requirement. They
are included Pages, Records, Menus, PeopleCode, Portal, and
others.
. Created scripts and Data mover scripts for upgrade conversion
clean up.
. Modified SQRs and SQCs for FS-52/50 and other reports.
. Tested the system. Validated all the PCs and other objects.
. Migrated projects from one database to other databases.
Principal Test Engineer, Titan Group, Reston, VA.
9/05-12/05 US Environmental Protection Agency (EPA):
Test EPA Payroll system with PeopleSoft HRMS module. Created test
script with all scenarios that they are related to the business
requirement. Run payroll cycle. Updated all test documents.
--Application Release: Payroll/HRMS v8.30
--Testing
. Use SQL to debug errors and to ensure the data store in the
correct table.
. Worked with developers for each object changes and with user for
business requirement.
. Validated all data, table set-up, layout format, and calculation
in each report.
Computer Senior Consultant (PeopleSoft), ETM, Silver Springs, MD.
3/04-9/05
US Environmental Protection Agency (EPA):
Analyzed, designed, and implemented PeopleSoft Training
Administration/eDev modules. Created conversion SQR programs to load
data from Lotus databases to Oracle database. SQR program was
modified for the SF-182 report. Modified PeopleCode to fix Workflow
and Email problems. Email message, Activities, Hyperlink, and
Workflow were modified to meet the requirement needs. eDev of Self
Service functionality was modified to allow employee to enroll
courses which they are not in the system. New tables, sub-records,
derived/work records, views, pages, components, and PeopleCode were
created on this project. Technical design document and test plan were
created for each project. Interviewed and met with user for business
requirement of each project. Prepared test materials, which included:
Test Plans, User Manual/Instruction, scenarios, scripts and Standard
Operating Procedures for User Test & development groups. Tracked test
issues and errors. Prioritized and resolved test related problems.
Provide training and technical assistance to other members in the
team.
--PeopleTools : v8.18
--Application Release: HRMS v8.30
Computer Analyst Contractor, TEKSystem, Bethesda, MD 7/03
- 2/04
American Chemical Society:
Support PeopleSoft Accounts Payable, Purchasing, and General Ledger
modules. Modify SQR programs, Crystal reports, and nVision reports.
Maintained PS system and production support. Set up security system
for user and other objects. Create SQL script to correct data issues
on production database. Gather business requirements. Write
technical design documents and test plan for each project. Utilize SQL
to analysis for problems/issues. Provide solution to solve Production
problems.
PeopleSoft Lead Developer, ALLEGIS GROUP, Hanover, MD 7/97
- 7/03
Led Analysis, design, and implement efforts for custom billing invoice
project in PeopleSoft FS module. Provided technical assistance to the
team members in the developing, coding, testing, and debugging relate
to the project. Maintained this project throughout entire systems
development life cycle from business requirement to design, develop,
test, and to production. Created and modified SQR programs. Used
Query and Crystal reports tools to generate reports. Used PeopleSoft
tools create and modify PS objects. Modified Application Engine for
business needs. Upgrade PeopleSoft FS module from version 5.x to
version 7.x and from version 7.x to version 8.x.
--Production Support:
. Maintained Billing, Account Receivable, Account Payable, and
Project Costing modules of PeopleSoft Financial Application
running in IMFORMIX (1997 - 1999) and Oracle (1999 - 2003)
database platform. Trouble shoots on these modules.
. Analyzed and Determined problem/issue in relate to Application,
Programming, Data, Database, or other relate computer on
Production database.
. Utilized SQL to search for the Production problems.
. Made decisions and provided solution to solve the Production
problems.
--Analysis:
. Gather and analysis business requirements.
--Design:
. Utilized business requirements to write technical design document
for each project. The design document focused on data mapping,
PS objects such as menu, panel/page, record, SQL, field, panel
group/component, Online logic (Peoplecode), query, and high level
application logic for both SQR program and Crystal report.
. Converted business requirement into technical design document.
--Development:
. Modified SQR programs for invoice portrait and landscape layout,
billing release, and billing interface process.
. Generate reports to meet user requirements by using Query and Crystal
reports tools. Created complex SQR programs to generate reports to
legal paper with graphics.
. Used PeopleSoft tools to create and modify all PeopleSoft objects and
to upgrade the objects from one database to another database and vice
versa.
--Test Plan:
. Wrote test plan based on business requirement. The test plan
focused on field validation, required fields, date validation,
Peoplecode validation, calculations/formulas, process validation,
and report layout.
--Migration:
. Checked out PS project files and other files from PVCS management
system.
. Copied/Imports PS project files into target database.
. Ran PS SQL and Data mover scripts in target database from Oracle
SQL/Plus if any SQL script was applied.
. Copied SQR and SQC to target database and set up security if it
is need.
--Business Process Reengineering:
. Implement custom billing invoice functionality. This
functionality allows user to select difference layout format for
their customer.
--Upgrade PeopleSoft:
. Analyzed DDDAUDIT and SYSAUDIT reports and applied patches.
. Analyzed the new PS version release.
Senior PeopleSoft Analyst, Coopers & Lybrand, Washington, DC
8/96 - 7/97
Analyzed, designed, and implemented ERIS application using
PeopleSoft Development tools for Ford Corp., as a Payroll and HRMS, to
manage Ford's international employee personnel and dependent data,
Immigration information, national tax, and business information for
home as well as foreign country, including utilizing PeopleTools to
develop a variety of records, panels, and menus for user interface.
Created records in parent/child relational database structure as well
as panels. Utilized Tree Manager tools to create query tree for
security. Utilized PeopleCode make the application more functional as
the customer required and more users friendly. Used PS/Query and
Crystal techniques generate various reports for the ERIS application.
Created SQR conversion programs to convert text files with different
delimiter into PeopleSoft application table in Oracle database. Set
up Crystal reports, SQR, and Window applications for process
scheduler. Developed test plan to test each component of the ERIS
application.
Researched and developed the ERIS application to run in Lotus Notes
V4.5 platform. Used Lotus Notes Tools set up user interface for
creating and modifying Notes databases, forms, views, agents, and
navigators. Utilized Notes formula, function, and script at field,
form, and database level to implement the application for
accomplishing business rules as the application needed.
PeopleSoft Developer, American Chemical Society, Washington, DC
4/96 - 8/96
Conducted with users to analyze, design, and set up GL function of
PeopleSoft Financial Application for upgrade from V2.2 to V5.1. Use
PeopleTools such as Data Designer, Panel Designer, Menu Designer,
Operator Security, PeopleCode, PS/Query, and Crystal Report to perform
the upgrade processing. Removed and added old/new chartfields for all
objects as ACS needed. Use Application Upgrader to copy objects of
ACS' applications from source database to target database. Modify
queries, crystal reports and SQR programs. Set up crystal reports and
SQR program for process schedulers. Create database link and SQL
script to load data from one database to another database. Ran
DDDAUDIT and SYSAUDIT report to maintain PS Application on both
PeopleTools and Database. Created, altered, and deleted tables and
views on Oracle database.
PeopleSoft Developer, PRC Inc., McLean, VA 3/95
- 4/96
Internal: Created and customized panels, records, fields, and menus
by use PeopleTools and SQR programs for HRMS and General Financial of
PeopleSoft accounting system. Created SQR interface programs for PRC
users to read data from ASCII input files and produce output data
files as well as customized reports. Set up audit trail in PeopleSoft
system to track system modification activities. Set up process
scheduler in PeopleSoft to run new SQR programs. Created database
query scripts to retrieve data from effective-dated tables using
PeopleSoft's PS/Query Tool, SQL*Plus, and DataPrism. Used SQL*Loader
to move data from external ASCII files into tables in Oracle database.
Conducted with users to analyze and design PO functional for upgrade
from V3.0 to V5.01.
Owens & Minor: Analyzed, designed, and customized PeopleSoft
accounting system of General Ledger and Assets Management functions.
This included create and modify panels, records, fields, and menus
using PeopleTools V3.0. Hide fields of 'Project', 'Product', and
'Stat' on all panels. Customize SQR reports according to the
customer's requirements.
National Academy Science (NAS): Responsible for analysis, design,
prototype, and customization of PeopleSoft accounting system of
Accounts Receivable and General Ledger functions. Created and
modified panels, records, fields, and menus using PeopleTools V3.0 to
meet NAS requirements. Used import utility to uploaded ASCII data file
from the NAS current system to PeopleSoft system Oracle database for
account number and department information.
Bookkeeper/Computer Sys.Admin.,Son's Quality Food Co.,Silver Spring,MD
3/94 - 3/95
Designed and created interactive applications to generate FICA
Reconciliation, Union, Pension, and health insurance reports using
Deltek QueryWriter tool. Maintained a NetWare 4.01 file server and
researched network problems. Upgrade Deltek module package software
and tax tables. Respond for full charge of Deltek Accounting AP and PR
systems. Set up Chart of account file, Time-Sheet control file,
employee master file, and vender master file. Prepared W-2 Form and
1099, FUTA, SUTA, 941, as well as others payroll tax returns.
Accounting Technician,Aspen System Corp., Rockville, MD.
5/91 - 1/94
Maintained vendor database files, processed invoices, and generated
checks using Deltek Accounting software. Use QueryWriter tool to
design and to create applications to generate a variety of Contract
weekly reports for contract managers.
EDUCATION:
Oracle Training, V8.0 1999 - 2000
- Introduction to Oracle: SQL and PL/SQL
- SQL Statement Tuning Workshop
PeopleSoft Training, V7.0 1995 - 2001.
o Data Management Tools
o Projects
o Business Processing
o Introduction to PeopleSoft Financials
o Receivable
o PeopleTools I & II (V8.1)
o PeopleCode (V8.1)
o PeopleSoft Financials 3 for the Public Sector Release Notes
o Query/Crystal Power Reporting
Lotus Notes Training, Coopers & Lybrand, Washington, DC, 1996
- Lotus Notes Development tools I
- Lotus Notes Development tools II
Diploma in Oracle 7 Developer/Toolset, Computer Learning Center,
Alexandria,
M.S. in Computer Science, Bowie State University, Bowie, MD.
(Candidate, 21 Credits completed)
B.S. in Computer Science, Bowie State University, Bowie, MD, 1988.
A.A. in Computer Science/Business, Montgomery College, Takoma Park,
MD, 1985.
SOFTWARE:
Oracle SQL*Plus; IMFORMIX ; Windows 95, Windows 98, Windows NT 4.0;
Novell NetWare V4.01, UNIX, MS DOS; Microsoft Word, Excel, Lotus 1-
2-3, and PowerPoint.