| David B. Hill | ||
|
Postal Address |
Phone and Email |
|
|
6025 Sandy Springs Cir |
|
770-722-8200 |
Skill Summary
Information Technology:
IBM AS/400, IBM S/38, IBM S/36, IBM S/34, IBM PC, SSP, OS/400, MS-DOS, MS Windows, Novell, DB2/400, dBase II, Informix, SQL, MS Access, Crystal Reports, RPG (II, III, 400, IV, ILE), C, BASIC, COBOL, FORTRAN, Visual Basic, HTML, Java, system administration, software development, web development, systems analysis, business process analysis, project management, MS Office (Word, Excel, PowerPoint, Access)
Industry experience:
Healthcare, Catalog / Mail-order, Distribution, Manufacturing, Cellular/Wireless
Personal:
Excellent personal communications, both written and verbal, good people skills, good listening skills, good problem solving
Employment History
Avita Community Partners, formerly known as Georgia Mountains Community Services, Flowery Branch, GA, Operations Analyst, Feb
2005 - present
Past projects have included converting printed forms to online forms using MS Word and Visual Basic, developing reports using Crystal Reports over Access and SQL databases, and developing a database, using VBA and MS Access, to help clinicians track their clients success in Supported Employment situations. Since August 2006, projects have been primarily VBA over MS Access and SQL databases, including an interface between the state medical authorization system and the in-house legacy system using VBA in MS Access.
Self-Employed Consultant, Sep 2001 - Jan 2005
Cingular Wireless, Atlanta, GA, Technical Requirements
Analyst (Consultant), Nov 2000 - Aug 2001
Enhanced the CARE package, a part of Cingular's customer
service and billing system. Took business requirements, determined technical
requirements, and prepared estimates and specifications that were passed
on to the Design Team. Required knowledge of the AS/400, CL and RPG ILE
programs, and the various systems and interfaces. Required constant communication
with all parties involved in a project to ensure that the end product fulfills
the original business requirements.
CibaVision, Atlanta, GA, Senior Systems Analyst, Apr
1999 - Oct 2000
ASMT-IT department (Applied Science & Materials Technology,
the manufacturing side of the business). Primary responsibility: support
of Mac-Pac, a manufacturing software package written in RPG (III and IV/ILE)
and CL for the AS/400. Met with users, determined requirements, analyzed
Mac-Pac software problems, and provided solutions. Also debugged and repaired
existing code, and developed new applications, including interfaces between Mac-Pac and a newly implemented PeopleSoft system. Mentored the less experienced
AS/400 programmers.
Self-employed Jan 1998 - Apr 1999
Contract programmer for Sportime using AS/400 RPG and CL.
Developed new sales and accounting reports to replace a manual order analysis
system. Created an RFM (recency, frequency, monetary) analysis and selection
tool for multiple mailing lists.
Sportime International, Atlanta, GA, Director of Information
Systems, Dec 1990 - Dec 1997
Hired to build an Information Systems department. Created
a department of five employees. Managed all aspects of computer hardware
and software systems, and participated in computer operations, software development,
and user support. Involved in all aspects of AS/400 software design and
development, from to modifications to the Order Power! software package, to proprietary purchasing systems and interfaces between Order Power! and E3. The company grew from 40 employees to approximately 120 and
approximate annual sales grew from $10 million to $30 million. It was producing
six catalogs four times a year and had an international dealer/distributor
network.
Genisys Business Software, Atlanta, GA, President and
Owner, Jan 1987 - Dec 1990
Genisys was a software consulting firm and an IBM Business
Partner. Developed custom software for clients using RPG, OCL, and CL on
the S/36 and AS/400 (DB2/400), and "C" and dBaseII on the PC. Acquired extensive experience in AS/400 standard utilities, including SDA, SEU, and Query/400 (SQL). Also sold IBM’s DMAS distribution
software package and A.B.May’s S2000 dispatched service management software
package, and provided on call I.T. services (technical support, business requirements
analysis, project management, software development) for various clients.
Prentice Hall Professional Software, Atlanta, GA,
Contract Programmer, Jun 1986 - Dec 1986
Programmer/Analyst, Nov 1985 - Jun 1986
Maintained and enhanced DAS, the distribution software (written in RPG and running on the S/36)
used to manage software sales and shipping. Developed a PC-based time and
billing system in BASIC.
Columbine Systems, Golden, Colorado, Programmer/Analyst,
Aug 1984 - Oct 1985
Developed a proprietary menu system for the S/34, S/36,
and S/38. Worked on a Fixed Assets Management package developed using Informix (SQL).
The company developed and sold Traffic Management software for radio and
TV stations.
MBI (McKallor & Bankes, Inc.), Atlanta, GA, Support
Analyst, Mar 1984 - Jul 1984
Hired as a programmer for product development using RPG on the S/36. Additionally
did customer support.
Bingham, Ltd., Atlanta, GA, DP Manager, Jan 1982 - Feb
1984
Automated Bingham, Ltd., a small import export company
distributing firearms and accessories using an IBM S/34 and MBI’s DAS (Distribution
Accounting System) software. Implemented DAS.
|
Education |
|
|