Title:PeopleSoft Consultant
*****************@***.***
Document
Source below
NAME:,
ADDRESS:
ADDRESS2:
CITY:
STATE: MA
ZIP:
CANDIDATE ID: 2922951
US CITIZENSHIP:
EDUCATION:
EXPERIENCE: 0
WILL RELOCATE: No -
JOB WANTED:
RATE NEEDED:
TELEPHONE: 508-***-****
EMAIL: *****************@***.***
HOMEPAGE:
HOTTEST SKILLS: peoplesoft, oracle, sql, cisco, programmer, unix, payroll, banyan,
database, db2, perl, risc, financial, as/400, cms, cobol, graphical user interface, jcl,
macintosh, netware
REVISION: 08-SEP-02
RESUME:
NAME: Francisco Andrade
ADDRESS:
CITY:
STATE:
ZIP:
COUNTRY:
CANDIDATE ID: NA
EXPERIENCE: Not Entered
DESIRED POSITION: Not Entered - See Resume
WILL RELOCATE: Not Entered
US CITIZENSHIP: YES
JOB WANTED:
EDUCATION: Not Entered
RATE NEEDED: Not Entered
TELEPHONE: 508-***-****
EMAIL: *****************@***.***
HOMEPAGE:
COMMENTS:
HOTTEST SKILLS:
PASSPORT_RESUME
Francisco Andrade
*****************@***.***
PROFESSIONAL EXPERIENCE
PeopleSoft Consultant
- PeopleSoft 6.1 Financials, SQR, Oracle 7.1, HP UX
Wrote new highly complex SQR reports for new AP implementation.
Created Application Engine applications to control group processing.
Assisted in the development of PS related coding standards.
Recommended and implemented legacy combo edits functionality in PS.
PeopleSoft Consultant
- PeopleSoft 5.12 HR, SQR, Oracle 7.3, DG U/X
Designed Panels, Records, Process Definitions, and SQRs for new and enhanced
reports.
Established standards for coding and migrations.
Worked extensively with the Process Scheduler API to develop automated
scheduling and requeuing of the calc and confirm Payroll processes.
Wrote interfaces using SQR to external systems.
Developed an operator security migration facility modeled after Application
Upgrader in SQR.
PeopleSoft Consultant
- PeopleSoft 5.12, SQR, DB2 v4, MVS, QMF
Analyzed and implemented interfaces and modifications to a new implementation
of PeopleSoft 5.1.2.
Designed Panels, Records and wrote specifications for report and update
programs.
Created conversions programs in SQR to migrate data from legacy to PeopleSoft
and feed programs with data returning to legacy.
Designed Payroll interfaces from legacy TIME system to PS Payroll tables.
PeopleSoft Consultant
- PeopleSoft 6, Windows NT, NT server, SQLServer
Upgraded PeopleSoft HR and Financials systems from version 6 to 6.1. Used
application upgrader and datamover in the upgrade process.
PeopleSoft Consultant
- PeopleSoft 3.24 - 6.1, Oracle 7.3, UNIX, HP 9000, AWK,
Perl
Worked on large conversion project to upgrade HRMS from a highly customized
PeopleSoft 3.24 Allbase HP 3000 environment to a more vanilla installation of
PeopleSoft 6.0 in Oracle on a HP 9000 UNIX machine.
Separated customized code from PeopleSoft vanilla code and utilized the new
look and feel for panels which were created in-house.
Wrote SQR conversion programs and converted existing SQR reports to work in
the new environment.
Created SQR that traversed the PeopleSoft Supervisory / Department Tree to
display the correct hierarchical employee / manager relationships for wage
reviews.
PeopleSoft Consultant
- PeopleSoft 5.10, SQR, RISC 6000, AIX, Oracle 7.1
Involved in the conversion of two HRMS legacy systems into PeopleSoft.
Made extensive use of SQR and SQLPLUS scripts to load data into PeopleSoft.
Worked very closely with the functional analyst to refine the conversion
mappings.
PeopleSoft Consultant
- PeopleSoft 3.24 - 5.1, SQR, Allbase, MPE, HP 3000
Developed and maintained PeopleSoft graphical user interface using PeopleSoft
GUI development tools including PeopleCode, panel editor, record editor, menu
editor, etc., for HP's US wide Human Resources systems (HRMS).
Documented and communicated activities to HP employees and other contractors.
Programmer/Consultant
- SQR, HP U/X, UNIX, Sybase 4.92 - 10, JAM 5.0
Programmer on client/server portfolio management application running on PCs
and HP U/X with Sybase 4.92 - 10 and used SQR to design and modify report per
user and functional specifications.
Created front-end screens and processing with JAM 5.0.
Created and modified database triggers for table auditing and created shell
scripts to automate SQR performance.
Wrote Korn Shell scripts to automate certain tuning tasks.
TECHNICAL SUMMARY
Hardware - Data General, HP 3000, HP 9000, RISC 6000, SUN, DEC VAX, IBM 3090,
AS/400, PCs, Macintosh, Wang
Operating Systems - DG U/X, HP U/X, UNIX, AIX, MPE, Open VMS, MVS/XA, MS/DOS,
MS Windows 95, MS Windows 3.1, MS WFW, Banyan Vines, Novell Netware
Databases - Oracle 6.0 - 7.3, Sybase SQL Server 4.92 - 10, DB2 v 4, Allbase,
Ingres
Software - PeopleTools, PeopleSoft HRMS, PeopleSoft Payroll, SQLForms,
SQLPlus, PowerBuilder, SQR, SQRW, JAM, Datatrieve, QMF, Spufi, CMS, MMS, LSE,
Hyperchannel, Supertracs, MS Excel, MS Word, Pagemaker, Powerpoint
Languages - SQL, SQR, C, COBOL, BASIC, Macro, DCL, JCL, Shell, AWK, Perl,
PeopleCode
EMPLOYMENT HISTORY
4/98
- 7/98PeopleSoft ConsultantCVS/Pharmacy Summit Systems
1/98
- 4/98PeopleSoft ConsultantGenesis Health Ventures
NexGen SI
9/97
- 1/98PeopleSoft ConsultantPECO Energy InfoQuest Group, Inc
.
9/97
PeopleSoft ConsultantPeopleSoft System Integration Solution
12/96
- 9/97PeopleSoft ConsultantHewlett-Packard Gentry, Inc
.
9/96
- 11/96PeopleSoft ConsultantKaiser Permanente GW Consulting, Inc
.
12/95
- 9/96PeopleSoft ConsultantHewlett-Packard Gentry, Inc
.
7/95
- 12/95Programmer/ConsultantShaw Data Services Seek, Inc
.
3/95
- 6/95Programmer/ConsultantBanyan Systems, Inc. Contract Solutions