Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download
Download Resume Format
Brookville, HA
(610) 920-3555
Summary
¨ Information
System professional with over twenty years of experience.
¨ Broad background
working in a variety of industries including human resources, payroll, aerospace,
healthcare, telecommunications, retail and others, using various system
platforms and database environments. Worked
in all aspects of full life-cycle system development including requirements
definition, program development, testing, and user training.
¨ Nine years
experience as a PeopleSoft consultant participating in successful projects to
implement and upgrade PeopleSoft CRM v8.9, HRMS v7.x, and 8.x HR, benefits,
payroll, and financial modules.
¨ Two years
experience as a PeopleSoft/SAP consultant working to convert from PeopleSoft
HRMS to SAP ECC 6.0.
¨ Eleven years
experience working as a programmer, programmer analyst, and business/system
analyst in a mainframe environment.
¨ Currently seeking
a position as a SAP business/data analyst on a project utilizing SAP HR and/or
payroll systems.
Technical
Skills:
Applications: SAP ECC (HR, Payroll), Mercury Quality Center (QC), PeopleSoft CRM, PeopleSoft HRMS (HR, Base
Benefits, Payroll, Time and Labor, Position Management, Health & Safety,
MSS), Financials (General Ledger, Purchasing, Receiving)
Tools: Ascential DataStage, Application
Designer, Process Scheduler, Query, Envision, Import Manager, Application Engine, Workflow, Crystal Reports, SQL Plus
(Oracle), Query Analyzer (SQL Server), SPUFI,
QMF, WinSQL, Querryman, TOAD
OS: Windows
XP/NT/98, UNIX, MVS, MS DOS, OS2
DBMS: Oracle,
DB2, SQL Server, SQLBase, Total, IMS DB/DC, VSAM
Languages: SQR, SQL,
PLSQL, PeopleCode, COBOL, ISPF, JCL, Eztrieve Plus, APS
Professional
Experience:
British Petroleum (BP), Houston, TX 11/07
– Present
PeopleSoft Consultant, PeopleSoft HR/Payroll
Conversion to SAP ECC 6.0 (outsourced to ADP)
¨ Documented existing PeopleSoft
HR, payroll, benefits, and financial SQR interface and report programs. Worked closely with SAP and BP business
analysts to convert program logic into SAP business requirements.
¨ For US
·
Coordinated training and access of new team members.
·
Provided support for data loading via Excel and data
setup within the requirements, test planning, test execution and defect
tracking modules.
·
Utilizing the Excel Report Generator developed
custom SQL queries to satisfy unique reporting requirements and data analysis
not supported by the delivered QC functionality.
·
Using custom and QC delivered report functionality,
developed daily management status report for tracking script development, test
execution and defect resolution.
¨ Throughout all phases of
testing, provided PeopleSoft analytical support to the testing team to confirm
PeopleSoft program logic and help resolve discrepancies between PeopleSoft and
SAP systems and/or business requirements.
¨ As an SAP tester, executed BP
SAP info type configuration test scripts, documented results, and raised
defects within the QC testing application.
¨ Utilizing SAP tools such as
wage type reporter, payroll reconciliation report, SE16, ad hoc query and
others, tested and validated ADP outbound interface files to verify they met
business requirements. Documented
defects within QC, designed solutions with ADP developers, and retested until
complete.
¨ Worked extensively on testing
and validating the numerous requirements and complex logic of the ADP Single
Client Feed (SCF) interface file to Fidelity Investments. Employee
data on the file consisted of pension, 401K, indicative, equivalency earnings
and stock option types of data.
¨ Co-developed a custom Access
database for parallel testing of the SCF interface file which provided a field
level comparison between PeopleSoft and SAP data for all record types.
Environment: PeopleSoft HRMS 7.0, SAP
ECC 6.0.
Caterpillar, Peoria , IL
PeopleSoft Consultant, Tesseract Conversion to PeopleSoft Payroll 8.9
¨ Defined the functional and
technical requirements for inbound and outbound interfaces including:
§ Employee stock option interface from PeopleSoft
Stock Administration to third party provider.
§ Inbound interface
to load exercised stock transaction data into payroll paysheets for updating of
tax balances and corporate tax reporting.
§ Outbound
interface to send all confirmed payroll tax data to corporate tax for
government reporting.
§ Outbound
interface of employee earnings data to Towers Perrin to support the Total
Rewards web site.
¨ Developed the
payroll batch schedule by identifying dependencies between existing mainframe
jobs and new PeopleSoft processes running on Process Scheduler. Utilized a custom process for submitting PeopleSoft
processes to Process Scheduler from the mainframe.
Environment: PeopleSoft Payroll 8.9, Windows XP, DB2.
Dollar/Thrifty Automotive Group, Tulsa
PeopleSoft Consultant, PeopleSoft HCM 8.8
¨
Developed employee stock purchase plan (ESPP) outbound and inbound
interfaces with Computershare to support the new company benefit.
¨
Made online enhancements to the Manager Self Service application.
¨
Modified the Kronos time-keeping to Peoplesoft upload process to
automatically create pay sheets per new business logic.
¨
Updated
leave accrual processing to incorporate new company leave policies and
developed a process to adjust employee leave balances based on retroactive job
changes.
Environment: PeopleSoft HCM 8.8, Windows XP, SQL Server.
Southern Ute, Durango, CO 06/06
– 08/06
PeopleSoft Consultant, PeopleSoft HCM 8.3 – 8.9
Upgrade
¨
Developed technical specifications for upgrading existing
applications to use the 8.9 table structures as well as reapplying of 8.3
customizations.
¨
Coded and tested HR, Benefits and Payroll SQRs and online
applications per 8.9 technical specifications.
Environment: PeopleSoft HCM 8.9, Windows XP, SQL Server.
Hawaiian Telecom/Verizon, Denver, CO 12/05
– 4/06
PeopleSoft Consultant/Conversion Analyst, PeopleSoft
CRM 8.9 Implementation
¨
Using Ascential DataStage 7.5 development tools, developed, and
maintained data conversion programs.
¨
Performed analysis on numerous source system data extracts using
SQL to identify problems and assisted developers with resolution.
¨
Supported the conversion team by acting as liaison to the project
management office, billing and other CRM functional teams, Hawaiian Telecom,
and Verizon. Tasks included coordinating
data deliverables, submitting and tracking change requests, and resolving data
format and data mapping issues.
Environment: PeopleSoft CRM 8.9, Windows XP, Oracle 9i.
Dana Corp., Toledo ,
OH
PeopleSoft Consultant, PeopleSoft HCM 8.3 - 8.9
Globalization/Upgrade
¨
Developed
detail technical specifications and unit test plans for developing HR
interfaces to Dana global payroll systems and Peopleclick recruitment
management system (RMS).
¨
Designed
and developed Oracle database triggers using PLSQL to capture audit information
from numerous PeopleSoft HR tables for the payroll and RMS interfaces.
¨
Worked
on developing the Sqr interface programs to process the audit information and
create interface files of jobcode,
department and location data in XML format.
Environment: PeopleSoft HCM 8.3/8.9, Windows XP, Oracle 9i.
Home, Denver ,
CO
Domestic Engineer, aka “Mr. Mom”
¨
Performed
necessary activities to maintain correct balance of personal and work time.
¨
Enjoyed
all aspects of parenting, family, friends, school, and recreational activities.
Merck & Co Inc., Lebanon , NJ
PeopleSoft Consultant, PeopleSoft
HRMS 8.8 Implementation/Upgrade
¨ Worked closely
with HR department to define conversion requirements and analyze test
results.
¨ Developed
conversion processes using SQL and PL/SQL scripts to merge and convert HR
reference data and all employee HR history data from multiple legacy systems
into PeopleSoft 8.8.
¨ Systems included
Tesseract (US employees), LAAP (Latin American/Asia
Pacific employees – PeopleSoft 8.3), Contingent workers, LDAP Names, Disability
and others.
¨ Reviewed
requirements and assisted in development of Manager/Employee Self Service
modules.
Environment: PeopleSoft HRMS 8.8, Windows XP, Oracle 9i.
Northrop Grumman, Dallas , TX
PeopleSoft Consultant, PeopleSoft
HRMS 7.5-8.8 Upgrade
¨ Performed
analysis of existing customized system (v7.5) and defined the requirements for
mapping the data into the v8.8 Skills Certification module.
¨ Developed the SQL
scripts to load and convert the data into PeopleSoft 8.8 system.
¨ Made manual
reapplies of client online customizations into v8.8.
¨ Upgraded SQR’s to
utilize new and modified v8.8 data structures.
Environment: PeopleSoft HRMS 8.8, Windows 2000, UNIX,
Oracle 9i.
Exelon Corp, Chicago , IL
PeopleSoft Consultant, PeopleSoft
7.5-8.8 Upgrade
¨ Upgraded SQR’s to
utilize the new and modified v8.8 data structures.
¨ Using PeopleTools
v8.4, made modifications to pages, components, PeopleCode, etc. within the HR
and payroll modules to incorporate the v7.5 client customizations into the v8.8
system.
Environment: PeopleSoft HRMS 8.8, Windows 2000, UNIX AIX,
Oracle 9i.
Lowe’s, Wilkesboro, NC 09/02 – 12/02
PeopleSoft Consultant, PeopleSoft
HRMS 7.5-8.3 Upgrade
¨ Upgraded
applications affecting the corporate-wide use of location number to correct
payroll, benefits and general ledger processing and reporting problems.
¨ Set up test data
for unit and system testing utilizing the Position Management module.
¨ Team modified,
tested, and documented more than forty programs including Payroll, Benefits,
Time and Labor, and General Ledger applications.
Environment: PeopleSoft HRMS 8.3, Windows NT, MVS, DB2, COBOL.
QWEST Communications,
Denver, CO 02/02 – 05/02
PeopleSoft Consultant, PeopleSoft
HRMS 8.0 Union Employee Conversion
¨ Performed
requirements analysis of existing interfaces to determine modifications
required for processing union employees.
¨ Developed the
functional and technical specifications and coded AP and GL interfaces.
¨ AP interfaces included
garnishment and parking vendor information; benefit accruals for life
insurance, medical and dental and quarterly bonuses sent to GL; eligibility
information for tuition reimbursement sent to outside vendor.
Environment: PeopleSoft HRMS 8.0, Windows NT, UNIX, Oracle
8.0, SQR
Children’s Hospital, Boston , MA
PeopleSoft Consultant, PeopleSoft
8.0 Implementation
¨ Developed the
Payroll conversion program to load legacy data from Cyborg into
PeopleSoft.
¨ Developed an
online modification/SQR process within Time & Labor to update fund year
information on task profiles.
¨ Developed the
payroll 403B interfaces and the Benefits pension interface.
¨ Developed SQR
reports in Payroll, Benefits, Time & Labor, Health & Safety, and
Financials.
¨ Developed all
necessary PeopleSoft objects for setting up run controls and execution within
process scheduler.
Environment: PeopleSoft HRMS 8.14, Windows NT, UNIX,
Oracle 8.0, SQR.
AG Edwards & Sons, St. Louis , MO
PeopleSoft Consultant, PeopleSoft
HRMS 7.5
¨ Redesigned custom
SQR management attrition reports to calculate average attrition rates over the
reporting period.
¨ Developed a SQR
process to calculate and store prior fiscal year information to improve
performance.
¨ Developed SQR
table load processes and reports of monthly Broker commission data from BULL
mainframe.
¨ Developed a
Benefits interface to process survey results data from brokers.
¨ Made maintenance
enhancements to other custom HR and Benefit reports and processes.
¨ Utilizing
PeopleTools, developed/modified all necessary fields, records, panels, menus,
process definitions, PeopleCode, etc. to support the development.
¨ Assisted in
setting up scripts for processing reports using PeopleSoft Autosys
adapter.
Environment: PeopleSoft HRMS 7.58, Windows NT, UNIX,
Oracle 8.0, SQR.
Vail Resorts Inc., Avon , CO
Lead PeopleSoft Developer, PeopleSoft
HRMS 7.5 Implementation
¨ On six-member report development team provided
mentoring and training to team members in areas of specification development, SQR development,
SQL, Query, PeopleTools, PeopleCode, and Process
Scheduler.
¨ Worked with HR
and payroll departments to define reporting requirements and develop
specification documents.
¨ Team developed
specifications and coded approximately forty SQR reports on schedule within
tight deadline.
¨ Developed custom HR,
Payroll and Benefits reports and modified PeopleSoft delivered reports.
¨ Worked to develop
standards for SQR development and implementation of PeopleSoft objects required
for report run-controls.
¨ Supported
functional team during parallel testing by developing ad-hoc queries and
reports for reconciliation of payroll data.
Environment:
PeopleSoft HRMS 7.51, Windows NT, SQL Server, SQR
Colorado Interstate Gas,
Colorado Springs, CO 10/97
– 10/99
PeopleSoft Developer, PeopleSoft HRMS 7.5 Implementation
¨
Worked closely with HR and payroll departments to
define requirements for reports and interfaces.
¨ Coded SQR
interface programs including medical/dental, prescription drug, 401K, savings
plan, bank reconciliation and pension.
¨ Developed
numerous other SQR interfaces and reports of Payroll, HR, and Benefits data.
¨ Developed an
online Reports Interface Application to standardize the HR report parameter
selection process.
¨ Developed conversion
load programs using Import Manager and SQR.
¨ Installed
user-developed Crystal Reports into online system.
¨ Utilized
PeopleTools to develop/modify all nechttps://docs.google.com/uc?id=16byNEs_RvodEbKjEegWYrsIYn2Mpk8J8&export=downloadessary objects to support the
development.
¨ Utilized PS
Query, WinSQL, and SPUFI to perform ad-hoc reporting and testing of SQL.
¨ Provided
post-production technical support for off-site HR users.
Environment: PeopleSoft HRMS 7.01, Windows NT, MVS, DB2,
SQR
Kaiser Permanente, Denver,
CO 02/96 – 07/97
Analyst/Programmer
¨ Responsible for
the upgrade/conversion of the Claims Processing System
Environment:
OS2, COBOL2, VSAM, DB2, COBOL
Fred Meijer Corp, Grand Rapids , MI
Programmer
¨ Provided
analysis/development on a retail reporting system
Environment: MVS, COBOL 2, EZtrieve Plus, DB2, TOTAL, COBOL
State of Maryland ,
Baltimore , MD
Programmer
¨ Programmer/Analyst
on a Claims Processing System for the State Developmental Disabilities
Administration
Environment: MVS, COBOL 2, DB2, COBOL
Northrop Corp, Pica Rivera , CA
Support Analyst
¨ Programmer, and
Systems Analyst on the Integrated Logistics Support System for the B2 bomber program.
Environment: MVS, COBOL 2, APS, IMS DB/DC, DB2
Education
¨ BS, Information
Systems Management, University of Maryland , Baltimore ,
Maryland
Download Resume Format
.JPG)
0 comments:
Post a Comment