Xiao Pei Jin
11426 Seneca Forest Circle
Germantown, MD 20876
Pjin5757@aol.com
240-899-9987
Professional Experience
US Senate, DC, 10/2011 – 02/2012
PeopleSoft Consultant
• Worked as a developer on HCM 9.1 implementation team. Developed custom reports
in SQR and XML Publisher. Created design and test documentation. Managed object
migration via STATS.
• Created customized process and reporting system for core HR, Payroll and
Benefits data auditing, using Database triggers, workflow, Application Engine and
XML Publisher.
Fujitsu for Amerigroup, Chesapeake, VA, 06/2011 – 09/2011
PeopleSoft Consultant
• Retrofitted customizations for PeopleSoft HCM and Financial upgrade from 8.9
to 9.1.
• Validated and rebuilt 8.9 custom component interfaces in 9.1, such as Job
Data, Compensation, Employee Reviews and eProfiles. Replaced custom
accomplishment component interface with new custom CI based on 9.1 Person Profile
components.
• Developed custom AWE process for Purchase Order and Requisitions in PeopleSoft
Financial.
Patriot Consulting for Mitre, Bedford, MA, 04/2011 – 05/2011
PeopleSoft Consultant
• Worked on PeopleSoft HCM upgrade from 8.9 to 9.1.
• Analyzed record structure changes from 8.9 to 9.1 and modified and tested
custom sqrs to incorporate record structure changes, new Personal Model and new
payroll balance ids.
Ferguson, Newport News, VA, 01/2011 – 04/2011
PeopleSoft Consultant
• Re-applied customizations on online pages, record structures, PeopleCode, SQR
and app engine programs for conversion project from PeopleSoft HCM 8.9 to 9.1 in
ORACLE 11g and UNIX platform.
• Created new app engine programs and application packages to transfer
PeopleSoft recruitment data in external system via outbound messaging. Programs
performed data mapping, parsing, validation and translation and special data type
handling.
• Developed custom app engine program to convert Recruitment file attachments
from HCM 8.9 to 9.1.
Cherry Road Technologies for Daimler, New Jersey, 10/2010 – 12/2010
PeopleSoft Consultant
• Developed SQR program for outbound interface of Payroll contributions from
PeopleSot 9.1 to Bancorp Bank. This interface contains the employee
contributions to the HSA plans for certain deduction codes.
• Developed Application Engine program for PeopleSoft to ADP outbound interface
for employee FSA contributions. Developed custom run control page and component
to allow users to run interface for full file or changes only and to allow users
to select multiple run ids.
• Developed PeopleSoft objects related to interfaces using PeopleTools.
USDA, Beltsville/MD, 11/2007 – 9/2010
PeopleSoft Consultant
• Converted Fill-a-position workflow approval process from traditional workflow
to new PeopleSoft 9.0 AWE technology.
• Converted PeopleCode, SQL Scripts and SQRs from Informix to Oracle platform.
• Worked on upgrade project from Federal HRMS 8.8 to PeopleSoft Federal HCM 9.0
in NT and SQL Server environment. Completed upgrade tasks in various phases such
as development, unit testing, QA testing and UAT.
• Used ClearQuest to manage full development life cycles.
• Upgraded online customizations for Employee and Manager Self Services.
• Created PeopleSoft Reports using XML Publisher.
• Created component interfaces programs to load BUS codes from external files.
State of Tennessee, Nashville/TN, 3/2007 – 10/2007
PeopleSoft Consultant
• Designed customized functionalities in eBenefits to allow employees to enter
and change their contribution percentages or amounts via Employee Self Service.
• Designed interfaces between payroll and financials and project costing so that
accounting data in synchronized in various systems after each pay run.
• Extracted data from HCM 8.9 via Application Engine and send to PeopleSoft
Budgeting via Integration Broker to be loaded by Budgeting module. This
asynchronous integration allows PeopleSoft Budgeting to receive HCM data on a
daily basis.
• Developed interface from Financial Speedcharts to HCM Time and Labor Task
Profiles, using integration Brokers technology and component interfaces with
PeopleTools 8.48. The integration allows users to enter speedchart data in
Financial and, via Integration Broker, update TL Task Profiles and Account Codes
in HCM, and via Application Packaging, log transaction details on UNIX
directories.
• Performed administrative tasks related to integration broker such as
configuration, web services, external connectors.
USI, Annapolis, MD, 4/2006 – 2/2007
PeopleSoft Consultant
• Worked on PeopleSoft implantation projects for various hosted clients, such as
NBA, Five Star Quality Care, Crane, ING, etc.
• Developed customized employee termination process using workflow and role
security technologies. Designed roles, roles queries, email, worklist and on-line
pages for the termination workflow process.
• Developed custom Workflow approval steps to manage employee action changes.
• Developed batch application engine programs and component interfaces to
automatically trigger termination process and load terminated rows into JOB
component on a daily schedule via schedule or on-demand.
Limited Brands, Columbus, OH 12/2005 – 3/2006
PeopleSoft Consultant
• Created and executed various test plans, such as unit testing, stress testing,
integration testing, and user acceptance testing of major payroll and Time and
Labor processes, such as TLAdmin, for year-end readiness. Identified bottle-neck
of payroll and T&L processes and provided resolutions.
• Troubleshooted various issues in Time and Labor such as T&L rules, dynamic
group security, Time Administration process, and provided resolutions.
Freddie Mac, Vienna, VA 6/2005 - 11/2005
PeopleSoft Consultant
• Conducted code reviews and tuning on DB2, PL-SQL and ORACLE, and provided
code recommendation for improving program efficiency for handling large data
sets.
• Developed custom queries and Crystal Reports for Financial account
reconciliations.
Target, Minneapolis, MN 12/2004 – 5/2005
PeopleSoft Consultant
• Worked on the PeopleSoft 8.8 Financial, HCM and EPM conversion team as a
consultant.
• Created data mappings to convert legacy financial history data to Financial
and EPM..
• Conducted code reviews, tuning and testing of SQR, application engine programs
developed by off-shore developers.
Excel Energy, Minneapolis, MN 6/2004 – 11/2004
PeopleSoft Consultant
• Worked on the PeopleSoft 8.8 HR, Payroll, Time and Labor and Benefit upgrade
project.
• Perform fit-gap analysis to identify needed upgrades from PeopleSoft 7.5 to
People8.8.
• Created detailed design specifications for off-shore developers to upgrade
COBOL, SQR and Natural program from legacy to PeopleSoft 8.8.
• Designed and tested UNIX shell script to replace MVS JCL.
Yum Brands, Louisville, KY, 2/2004 - 5/2004
PeopleSoft Consultant
• Designed and coded PeopleSoft Financial interfaces using Applications Engine
and Component Interfaces for GL, AR, AM. The interfaces transfer information
such as allotment, agreement and appropriation between AP, AM GL and project
costing and perform calculation and report generation.
• Coded conversion programs from GEAC legacy system to PeopleSoft Financial 8.8
modules, such as Asset Management, Project Costing, etc, using SAS, SQR, JCL,
SPUFI, etc, in DB2 MVS environment.
PNC Bank, Pittsburgh, PA, 10/2003 - 1/2004
PeopleSoft Financial Developer
• Developed programs to convert legacy GEAC financial data into PeopleSoft
Financial 8.8.
• Designed and coded PeopleSoft reports and interfaces using SQR, COBOL and
Application Engines in PeopleSoft Financial. Coded JCLs to execute SQR, COBOL,
and AE programs on mainframe.
• Coded data load programs to load asset data into PeopleSoft Asset Management
staging tables.
GTSI, Chantilly, VA, 7/2003 - 9/2003
PeopleSoft Consultant
• Worked as the Time and Labor technical and functional analyst in PeopleSoft
8.8 implementation.
• Performed fit gap analysis on major areas of implementation.
• Completed all Time and Labor setups and configurations, such as workgroups,
task groups, TRC, custom rules, security groups and TCDs.
• Designed Enroll Time Reporter process.
Department of Health and Human Services, Silver Spring, MD 4/2003 – 6/2003
PeopleSoft Systems Administrator
• Worked on the PeopleSoft HRMS, Payroll 8.4 for Federal government on
UNIX/Oracle and PIA.
• Provided production support for batch jobs and interfaces, such as
trouble-shooting, performance tuning using SQL tools and Applications Engines.
• Involved in PeopleSoft administrative tasks, such as administering Security,
patches, batch processes, Application Messaging and Portals.
EPA, Washington, DC 9/2002 – 3/2003
PeopleSoft Consultant
• Analyzed custom reporting requirements for PeopleSoft HRMS.
• Developed functional and technical specifications for performance management
module.
• Assessed the functional gap between your current workforce's competencies and
the current and future reporting requirements.
Thrivent Financial, Minneapolis, MN 3/2002 - 8/2002
PeopleSoft Consultant
• Worked on the PeopleSoft 8.14 HRMS conversion team as a consultant. Project
involved conversion of HRMS and payroll from legacy to PeopleSoft version 8.
• Participated in implementation of open enrollment module.
• Designed custom payroll interface.
• Performed systems design, coded extract, conversion and load programs in SAS,
COBOL, JCL and TSO. Designed mapping between legacy data and PeopleSoft HRMS.
Caterpillar, San Diego, CA 8/2001 - 2/2002
PeopleSoft Time and Labor Developer
• Worked on the PeopleSoft HR, Payroll, Time and Labor implementation team as a
Time and Labor developer.
• Participated in conversion to PeopleSoft version 6 to Version 8.15 using SQR,
DB2Command center, PeopleTools, Application Engine, Security Administration, etc
on Unix/DB2 platform.
• Converted custom SQR programs from using ORACLE to using DB2.
• Completed new implementation of Time and Labor Modules, which involved SQR
coding for interfaces with time collection, Application Messaging, rapid entry,
time validation, and overtime redistribution capabilities.
• Perform Application Engine testing for Time Administration, TRC and Workgroup
setup, Rule setup and SQL objects.
American Red Cross, Falls Church, VA 2/1999 - 7/2001
PeopleSoft Developer
• Worked on the PeopleSoft HRMS, Payroll and Pension/Benefit systems as a
technical specialist in PeopleSoft Version 7.5 on UNIX/Oracle.
• Responsibilities include upgrades and customizations using PeopleTools and
PeopleCode, Workflow, Business Process, SQR, Crystal reports, troubleshooting and
administrative tasks such as GL/Payroll interface, retirement systems, benefits,
pension plan, test scripts, tax updates, systems upgrades, securities, tree
managers, PL-SQL, ClearCase, etc. Participated in PeopleSoft Version 8 upgrade
using Internet architecture.
Shared Medical Systems, Omaha, NE 10/1998 - 2/1999
PeopleSoft Developer/Consultant
• Worked on the PeopleSoft Financial, GL, AR, AP, Inventory, Purchasing, Budget,
HR and Payroll implementation team as a technical developer.
• Provided technical assistance on the issues related to EDI setup, Workflow,
data conversion, data load, SQR and Crystal reporting, trouble shooting, applying
fixes and patches, user training, etc. Used PeopleSoft Version 6 on UNIX/Oracle,
especially Data Mover, Import Manager, Process Scheduler, People Tools,
Application Upgraders, EDI manager, GenTran, SQR, Crystal Report, VendorCom, etc.
• Customized purchase order sqrs and adjust file layout to work with VendorCom
EDI.
Montgomery Ward, Chicago, lL1/1998 - 10/1998
PeopleSoft Developer
• PeopleSoft Financial technical developer on financials, purchasing, asset
management, systems and financial interfaces using PeopleSoft Version 7 on
UNIX/DB2 platform of a 3-tier architecture.
• Used Data designer, Panel Designer, Menu Designer, Application Designer,
Application Reviewer, Security Administrator, Queries, Tree Manager, Import
Manager, PeopleCode, DB2 Command Center and SQR in development.
EDUCATION
University of Maryland
Graduate Study in Systems Engineering
Oakland University
Master's Degree
Applied Statistics
University of Science & Technology
Bachelor's Degree
Applied Mathematics
|
