David S. Gray

                72 International Lane    *     Grand Island, NY 14072     *   
 [Send email to request phone number] 73 – 2203     *      [Send email using form at bottom]


SUMMARY OF QUALIFICATIONS

	PeopleSoft Financials, Supply Chain and HRMS Technical/Functional
Support, Development and Project Lead using 
       PeopleTools through Version 8.49 and Applications through Version 9.0.
	Custom applications using Application Designer, PeopleTools, PeopleCode
and SQL and reporting using SQR, Query and Crystal Reporting. 
	Participation in implementations, conversion from legacy systems,
interfaces, upgrades/fixes, extracts and system testing.
	Broad background in computer applications, ranging from Personal
computer, Client Server and mainframe. 
	Experienced in financial applications including the monthly accounting
process, planning, financial reporting and analysis.
	Proficient in business analysis/project management skills involving
design, analysis, requirements, reviews, testing and documentation.
	Effective oral and written communication skills.


TECHNICAL SUMMARY
  
	Operating Systems: DOS, MS-Windows 95-XP, Windows NT, UNIX
	Applications: PeopleSoft Financials - Projects, General Ledger,
Accounts Payable, Accounts Receivable and Asset Management, PeopleSoft Supply
Chain - Order Management, Purchasing, Billing and Inventory, Expenses, PeopleSoft
HRMS- Payroll, Human Resources and Benefits, Oracle Financial/Express Analyzer
(OLAP), MS-Word, Excel, Access, PowerPoint, Visio.
	RDBMS: Oracle 7-9i, DB2, SQL Server 6.0 and 2000.
	Development Tools: PeopleSoft PeopleTools Version 3.25 – 9.0 (
PeopleCode, SQR, SQL, Ouery, Crystal Reporting, nVision, 
Data Mover, Application Engine, Security, Integration Broker), SAS, HTML, STAT
4.1.1, TOAD, BMC Control-M Enterprise Manager

			
PROFESSIONAL EXPERIENCE  

    PeopleSoft Systems Analyst
		Osmose Holdings, Inc., Buffalo, NY						June 2005 – Present
	Provide production maintenance and user support for the PeopleSoft 8.49
and 9.0Financial Modules: Accounts Payable, 
Purchasing, Asset Management, Projects and General Ledger and Supply Chain
Modules: Order Management, Inventory, Billing, Accounts Receivable and Project
Costing.
	Provide Functional Support 60%, Technical Support 40% and update and
maintain Security Access. 
	Assisting in the upgrade of  PeopleTools from version 8.48 to 8.49 and 
Financial applications from version 8.8 SP1 to 9.0 
       and applying custom changes and testing.
	Make development changes and fixes to applications using PeopleTools ,
SQR, SQL, PeopleCode, etc, per user requests. 
	Document procedures and programs including data flow diagrams.
	Research new applications of the product and make recommendations.


   PeopleSoft Consultant, for Weiser Enterprise Advisors., on assignment for the
following client: 
			Ubiquitel PSC, Inc.., Philadelphia, PA						December 2004 – May 2005
	Provide production, maintenance and user support for the PeopleSoft 8.0
and 8.8 Financial Modules: Accounts Payable, 
	       Purchasing, Asset Management and General Ledger. 
	Develop custom applications and fixes using PeopleTools  8.19 and 8.45,
SQR, SQL, PeopleCode, etc, per user requests. 
	Assisted in the installation of  PeopleTools  version 8.45 and 
Financial applications to version 8.8. 
	Assisting in the upgrade of  PeopleTools from version 8.19 to 8.45 and 
Financial applications from version 8.0 to 8.8.
	Make recommendations and advise in the application of the PeopleSoft
product in regards to its business application.

   PeopleSoft Consultant, for Computer Task Group,Inc., on assignment for the
following client: 
			Corning, Inc., Corning, NY							August 2004 -  December 2004
	Provided production, maintenance and user support for the PeopleSoft
8.8 Financial Modules: Accounts Payable, 
	       Accounts Receivable, Asset Management and General Ledger. 
	Developed custom SQR, SQL, PeopleCode, PeopleTools, etc, per user
requests. 

 David S. Gray - Continued
 

   PeopleSoft Consultant, for CAI,Inc., on assignment for the following client:

			Baush & Lomb, Inc., Rochester, NY						March 2004 -  July 2004
	Provided production, maintenance and user support for the PeopleSoft
8.4 Supply Chain Modules: Order Management, 
	       Billing, Inventory, Accounts Receivable. 

   PeopleSoft Consultant, for Computer Task Group,Inc., on assignment for the
following client: 
			Corning, Inc., Corning, NY							November 2003 -  February 2004
	Provided production, maintenance and user support for the PeopleSoft
8.18 Financial Modules: Accounts Payable, Accounts Receivable, Asset Management
and General Ledger. 

   PeopleSoft Consultant, for Data Trend Information Systems, Inc., on
assignment for the following client: 
			Capital One Bank, Richmond, VA							November 2002 -  November 2003 
	Provide production, maintenance and user support for the PeopleSoft
8.18 Financial Modules: Accounts Payable, Purchasing, 
		       e-Pro, e-Expense, Asset Management and General Ledger. 
	Applied Financial Application Bundle upgrades and fixes. 
	Use Oracle 8 to create queries, write SQL scripts and do general
database maintenance to PeopleSoft data and configuration. 
	Act as liaison with business analysts and PeopleSoft, Inc. to record
known software issues, keep track of the progress and resolution of PeopleSoft
Cases.
	Translate business users’ requirements into designs documents for
programmers. 
	Performed development of customization.
  

    PeopleSoft Consultant, for Infinity Technical Services, Inc., on assignment
for the following client: 
			Giant Eagle, Inc., Pittsburgh, PA							May 2002 -  September 2002
	Assisted on implementation of  PeopleSoft’s Asset Management  module
with data conversion, interfaces, setup, 
	customization, and testing.
	Participation in PeopleSoft upgrade from 7.5  to 8.4.
	Researched and documented the purposed additions of new functionality
to existing PeopleSoft applications.
	Developed custom SQRs, PeopleCode, PeopleTools, etc. per user
requests.
	Provided production, maintenance and user support for the PeopleSoft
7.5 Financial Modules: Accounts Payable, 
	       Accounts Receivable, and General Ledger and Oracle 8 query, SQL scripts
and general database maintenance. 

    Principal Consultant, for Keane, Inc. on assignment for the following
clients:  
			Allmerica Financial Corporation, Worcester, MA					April 2001 -  December
2001
	Acted as Project Lead and advisor for Keane’s PeopleSoft outsourcing
project which involved managing five people.
	Conducted interviews, meetings and documented procedures   
	Provided production, maintenance and user support for the PeopleSoft
7.5 Financial Modules: Accounts Payable, 
	        Purchasing, General Ledger and Asset Management. 
		
			National Fuel Gas, Inc., Buffalo, NY						August 2000 – March 2001
	Provided production/user support and resolution of issues or problems
for the PeopleSoft 7.5 HRMS/Payroll system.
	Applied patches, fixes and tax updates.
	Performed day to day maintenance, queries, troubleshooting and new
enhancements to system and reports.
	Wrote SQL and DataMover scripts for database manipulation. 


    PeopleSoft Consultant, for Professional Support, Inc. on assignment for the
following clients:  
	National Fuel Gas, Inc., Buffalo, NY 						June 1999 – July 2000
	PeopleSoft HRMS/Payroll development using PeopleTools 6.0, created SQR
applications/reports and queries.
	Assisted on the HRMS/Payroll upgrade from Version 6.0 to 7.5.
	PeopleSoft Financials – Projects and Asset Management implementation
using PeopleTools 7.5, created SQR applications/reports, queries, interfaces and
crystal reporting.
	Created and ran data conversion from legacy systems to PS Projects and
PS Asset Management.
	Wrote SQL and DataMover scripts for database manipulation. 

David S. Gray - Continued


Osmose, Inc., Buffalo, NY								June 1998 – May 1999
	Participated in PeopleSoft Financials upgrade from version 6.0 to 7.5,
this included modules: General Ledger,                Accounts Payable, Order
Management, Inventory, Billing and PeopleTools.
	Created and modified SQR/Crystal Reporting and made numerous
customizations to applications using Application 
	Designer, this included creating panels, records, menus, reports, PeopleCode,
and Application Engine.
	Acted troubleshooting application problems, provided fixes and logged
cases with PeopleSoft,Inc..
	Participated in the implementation of Accounts Receivable Module.  
	Wrote SQL scripts for database manipulation and query.

	PeopleSoft Consultant, for Technology & Process Consulting, Inc. on assignment
for the following clients: 
	Integrated Health Systems, Inc., Baltimore, MD					January 1998 – June 1998
	Assisted PS HRMS/Payroll Technical Manager in managing Production
Support issues and resolution.
	Troubleshot the PS system and worked with programmers in the completion
of modifications and fixes.
	Assisted on the PS HRMS/Payroll software Upgrade from version 5.0 to
7.0.
	Researched and documented new version enhancements that were used in
JAD session discussions/presentations 
	that led to improvements/enhancements for existing PS HRMS applications. 
	
The Federal Aviation Administration  (FAA), Washington, DC 			June 1997 –
January 1998 
	Provided technical support for the implementation of PS Project Costing
Module, version 6.0, for the Public Sector.
	Developed SQR reports and performed SQL queries and table updates.
	Performed modifications and setup using PeopleTools and worked with
users to make modifications and fixes                     during user and system
testing.
	Prepared User documentation for using PeopleSoft Query, Crystal
Reporting and Nvision.

Bell South, Inc., Atlanta, GA							May 1997 – August 1997
	Performed analysis of HRMS/Payroll upgrade from version 3.25 to 6.0
using compare reports to identify customizations.
	Wrote technical specifications from functional requirements.
	Made modifications using PeopleTools, analyzed and modified SQRs and
JCL and tested in an IBM DB2 environment.
 

    Project Lead / Business Analyst Consultant, for COMSYS, Inc. on assignment
for the following clients: 
              First Union Corporation, Inc., Charlotte, NC						July 1996 – May
1997
	Acted as project lead on the implementation and definition of the
Oracle - PC Express/Express Analyzer, OLAP system.
	Prepared and maintained the Business Design Document, Test plans and
scripts.
	Ran team status meetings, prepared projects issues list, project plan
and time line.
	Verified and tested system to ensure it met the stated requirements.


     Senior Systems Business Analyst Consultant, for DataMasters, Inc. on
assignment for the following clients: 
              AT&T, Inc., Greensboro, NC						 	August 1995 – June 1996
	Worked as a member of a project team that was implementing Oracle - PC
Express/Express Analyzer, OLAP system.
	Created requirements/planning documentation and worked with users to
meet their objectives. 
	Worked as a member of a project team testing PeopleSoft – HRMS
applications, this involved becoming very familiar 
with the flow of these modules, the content of the data fields and identifying
where bugs occur and then referencing the        underlying PeopleSoft code so
errors could be corrected.
	 Both manual and automated testing tools, such as WinRunner were used
in the testing process.


     Senior Business Analyst Consultant, for Computerpeople, Inc. on assignment
for the following clients: 
              ProServ, Inc., Buffalo, NY – Health Care Software
Provider				October 1992 – March 1995
              CitiCorp, Inc., Buffalo, NY – Financial Services Provider
		Key Services Corp, Buffalo, NY – Financial Services Provider
	These assignments included the analysis, requirements definition,
testing, documentation and user acceptance of 
		        various in-house systems supporting HRIS and financial applications.

David S. Gray - Continued


 Manager of Financial Systems and Consolidations
		Varity Corporation, Inc. 								October 1990 – June 1992
	Acted as corporate headquarters systems administrator for IMRS’s Micro
Control (currently Hyperion), PC LAN                based consolidation package.
	Liaison between worldwide user community and software vendor
coordinating the implementation of version upgrades, 
		adding of new functionality and resolution of problems.
	Improved the functionality and efficiency of the system ultimately
reducing the time required to do the monthly close.

	
     Financial Systems Analyst
      	Empire Federal Saving Bank							March 1989 – September 1990

	
     Project Manager / Financial Systems Analyst 
		 Marine Midland Bank								January 1984 – February 1989	


EDUCATION                       
     
     MBA – Business Administration -  Canisius College, Buffalo, NY 				May
1984
     BA – Economics, State University of New York at Buffalo, Buffalo NY			May
1977

Continued Education
	Oracle, PeopleSoft Integration Broker 8.49, Toronto, ON					September 2007
	Oracle, PeopleSoft Security 8.48, Toronto, ON						April 2007
	PeopleSoft, Billing and Accounts Receivable Accelerated 8.8, Sacramento,
CA		May 2006
	PeopleSoft, PeopleTools 8.1 Delta Training, Toronto, ON	 				January 2002
	Keane Methodology Training								July 2001
	PeopleSoft, Query and Crystal Reporting, Buffalo, NY   					October 1999
	PeopleSoft, PeopleTools Foundation 7.5 Training, Pleasanton, CA	 			June 1998
	PeopleSoft, Projects 6.0 Training, Atlanta, GA						May 1997 
	PeopleSoft, People Tools 3.25, Greensboro, NC						February 1996