Paul Harding

Locations
Ingham
Job Interests
Information Technology

40 hours per week

Seeking

Access Database, Data Analyst, Crystal Reports

Explanation of Disability

reduced function in one hand

Resume

Paul Kenneth Harding

630 W. Rouse Street

Lansing, Michigan  48910-4433

(517)
394-4564    Email: PHarding2012@att.net

 



Objective




To use my 40 years of computer
experience to secure a responsible position that offers an opportunity to
work with people and use computer programming, reporting and data
manipulation skills to increase productivity & improve the work
environment  






Programming Languages




VBA (Access, Excel, Visio, Word, Outlook),
Formulas & Procedures for Crystal Reports, Visual Studio (VB), Visual
FoxPro, FoxPro, Oracle Designer 2000, SQL Server, Clipper, dBase, C++, 4th
Dimension, Basic, COBOL, Fortran and Assembler.


 






Op Systems




Windows 7, Windows XP, Windows NT,
Windows 2000, Windows 95/98, MS DOS, CPM.


 






Software




Crystal
Reports, Microsoft Office (Word, Excel, Access, PowerPoint, and Outlook),
Visio, R & R Report Writer 8, Corel Office (WordPerfect, Quattro Pro,
Presentations), Lotus, GroupWise, GIS, and AutoCAD.


 






Work
Experience




 






2012
- Present




PROGRAMMER
/ PREVENTION AND PEER SUPPORT ASSISTANT




Clinton
Eaton Ingham Community Mental Health




Lansing, MI






·                 
Created
Case Management Access database to record activity, notes, goals and  client information for case managers which
could not be recorded on CareNet health care system


·                 
Created
Peer Support Access database to record activity and client information which
could not be recorded on CareNet


·       
Provided data, 
reports and analysis as needed for Peer Support and Prevention


·                 
Created
systems to convert state database extracts to common reports, graphs, and
charts to compare treatment outcomes






2009 -  2012




DATA
ANALYST / REPORT WRITER / IT SUPPORT




Mid-South
Substance Abuse Comm




East Lansing, MI






·                 
Developed
a system in Access to allow Care Coordination Center, to track and analyze
client trends and characteristics


·       
Generated charts and graphs from CCC system to
analyze agency trends and data entry


·       
Provided data using Crystal Reports to assist
administration decision making


·       
Provided IT support including, PC repair, Server
maintenance, and backup


·       
Provided technical support to fellow workers for
Excel, Word, Access, and Crystal Report problems


·       
Attend relevant committee and association
meetings


 






Jun
2008-Dec 2008




DATA
ANALYST / REPORT WRITER




MSHDA




Lansing, MI






·                 
Created
a complete system to track VMS Housing Assistance Payments financial expenditure
reporting


·       
Provided user and technical documentation for VMS
system


·       
Developed a reporting system to track report
modifications, providing an audit trail and internal control support


·       
Performed data analysis and verification on
several reports using VBA macros, including financial and problematic data


·       
Created new reports to retrieve, and make
calculations for data including (but not limited to) New Admissions, End
Participation, and various SEMAP indicator reports


·       
Provided technical support to fellow workers for
Excel, Word, Access, and Crystal report problems


 






Nov 2007-Jan
2008




SYSTEM
ANALYST / DATA ANALYST




Starr
Commonwealth




Albion, MI






·                 
Assisted
with help desk issues


·       
Assisted in implementation and training for
Family First program using ANASAZI program


·       
Prepared data for input and implementation






Jul
2006-Apr 2007




VBA
PROGRAMMER / DATA ANALYST




GM
Tech Center  (PMC & AeroTek )




Warren, MI






·       
Built
complete system to track, edit, analyze, and 
report service terminal information for GM SPO (Service Parts).


·       
Built
system to report progress on engineering aspects of current car models.


·       
Created
Excel macros for several manual processes.


·       
Created
macros and links between Access projects and Visio flowcharts to provide
easier documentation.


·       
Created flowcharts (using Visio) and
documentation (using Word) for projects.


 






Feb
2006-May 2006




PROGRAMMER
/ DATA ANALYST




AT Kearney
(Momentum)




Southfield, MI






·       
Programmed
in Excel and Access VBA to correct and analyze data for Table of Routing.


·       
Analyzed
data from vendors and advise in processes for cleaning/correcting data.


·       
Assisted in analysis of  processes to correct data and related
problems.


 






Dec
2004-Feb 2006




SURVEYOR
/ DATA TECHNICIAN




Capitol
Area Transit Authority




Lansing, MI






·         
Wrote
macros in Excel to assist in data analysis to analyze and remove invalid data
from bus GMI units.


 






Aug
2004-Feb 2006




WEB
PROGRAMMING / SALES




Chief
Cart




Lansing, MI






·         
Updated
Web Site, assisted with Quickbooks and accounting data, and managed client
database.


 






Feb
2004- Jul 2004




REPORT
WRITER / DATA ANALYSIS




Flagstar
Banks  (Tek Systems)




Jackson, MI






·       
Generated
reports at users request.


·       
Extracted
data from BISYS system using Crystal Reports.


·       
Imported
data into Excel and used macros to modify data.


·       
Assisted with backups and daily report
generation.


 






Aug
2001-Mar 2003




COMPUTER
INSTRUCTOR




Lansing Community College




Lansing, MI






·         
Taught
16 week college-level Courses in: Office 2000 (Word, Excel, Access,
PowerPoint, Outlook) and .  Programming
Logic


 






Sep
2000-Feb 2004




PROGRAMMER
/ COMPUTER TECHNICIAN




Phone Banks Systems, Inc




East
Lansing
,
MI






·       
Created
and modified data entry & conversion programs (from Fox Pro 2.6 to Visual
Fox Pro).


·       
Integrated
Visual FoxPro with Office and Crystal
reports.


·       
Provided
documentation and training on all modifications.


·       
Programmed
in Access, SQL server, and Macros (WordPerfect, Word, Excel). 


·       
Troubleshot
& assisted with computer problems, set up backup batch files and
programs.


 






May
2000-Sep 2000




PROGRAMMER / REPORT WRITER




RSDC of MI (Daystar)




Holt, MI






·       
Created
and modified Crystal
reports on steel production, inventory.


·       
Processed
in ORACLE and FoxPro. Created and modified applications in FoxPro.


·       
Created
and modified macros with VBA in EXCEL and Word.


 






Dec
1995–Feb 2000




PROGRAMMER / ANALYST




State Court Administrative
Office Automation Division (Compuware)




Lansing, MI






·       
Worked
on data design and system development in Oracle Designer 2000.


·       
Worked
with Oracle Designer 2000 Forms & Report Writer.


·       
Converted
data from Clipper to Oracle.


·       
Created
and enhanced programs in Clipper and assisted users in Clipper applications.


·       
Wrote
reports in R&R Report Writer 8 and Crystal Reports


 






Education




 






 




CompTIA (New Horizons Learning Center) 2010




Certification 
A+ IT Technician (MS certification)






 




MI Virtual University, East Lansing MI, 2003




Certification 
Virtual College Instruction






 




Oracle Education, Troy Michigan,  1999




Designer 2000 /  System Modeling Tools





















 




Design
& Build Database Objects


Reports


GUI Objects         




SQL /
PSQL Procedure Builder




Design & Build Applications






 




Lansing Community College, Lansing, MI   GPA:
3.81




Associates
Degree -

Digital Electronics, June 1991


Certificate
of Achievement

Computer Repair Technician






 




Relevant Courses:


Web
pages (HTML) (2008)


Web Site Design (2008)




VB
Net I & II (2008)


Visual
Basic I & II (2002)


JAVA (2001)




Accounting
(1996)


C++
(1993)       


Industrial Auto CAD (1993)






Associations and Committees




 




 






 




Michigan Association of Substance Abuse Coordinating
Agencies -  Finance Committee






 




Michigan
Association of Substance Abuse Coordinating Agencies -  Treatment
Outcomes Committee






 




(Both
are now replaced by SAPT - Substance Abuse Program Directors






 




 













Additional
employment history and education available upon request. (1978 to 1995)

Additional Education

 



 




LCC Additional Courses:


Geometry
II (Winter 1993)




Business
Law (Spring 1996)


Drafting
(Fall 1992)




Calculus
II  (Winter 1993)


 






 




Hennepin Vo-Tech, Brooklyn Park, Minnesota


Degree   Data Processing
Certificate, June 1978, GPA: 4.0



 

Additional
Employment History

 



1994-1995




COMPUTER INSTRUCTOR Ross Technical Institute




Oak
Park
, MI






1993 - 1994




4D PROGRAMMER, Practicom Consulting Services, Inc.




Holt, MI






1991 - 1992




COMPUTER PROGRAMMER, Accident Fund of Michigan




Lansing, MI






1991 - 1993




COMPUTER LAB SUPERVISOR, Jackson Community College 




Jackson, MI






1992 - 1993




COMPUTER INSTRUCTOR & LAB SOFTWARE
SPECIALIST, Lansing Community College 




Lansing, MI






1985 - 1991




COMPUTER PROGRAMMER, CREATE Ministries 




Lansing, MI






1983 - 1985




WAREHOUSE MANAGER, Morning Star, Inc. 




Eden
Prairie
, MN






1979 - 1982




PROGRAMMER ANALYST, Hagen Systems, DCD, Inc., 




Minneapolis, MN



 

References