Cynthia Cole

 
CYNTHIA S. COLE

Computer Concepts and Methods
1413 Surrey Lane
Wynnewood, PA 19096-3819

PHONE:610/649-2769
FAX: 610/658-0576
EMAIL: CindyCole@ccam.biz
WEB SITE: www.ccam.biz

QUALIFICATIONS

29 years of professional experience in computer science ranging from assembly 
language programming to relational database, client/server, object oriented and 
web site development, most recently as an independent consultant, using various 
analysis and design methodologies and tools to implement a variety of technical 
and business systems. Experience also includes data modeling, database 
administration, records management, message and text processing, mathematical 
functions and statistics, data reduction and analysis, configuration management, 
quality assurance, testing, documentation and training. Particular skills 
include Oracle, Microsoft Access, Microsoft SQL Server, SQL, PL/SQL, Microsoft 
Office, MYOB, Visual Basic, REALbasic, Crystal Reports, Front Page, HTML, 
FoxPro, FileMaker, Fortran, Corporate Modeler, and ERwin.

CREDENTIALS

M.S.E., Computer Science, University of Pennsylvania, 1980.

B.S., Mathematics, Ursinus College, 1974, Valedictorian.

Planning Research Corporation's Chairman's Award.

Delaware Valley ORACLE User Group (DEVOUG), member, speaker.

Independent Computer Consultants Association (ICCA), Delaware Valley Chapter secretary.

Network of Women in Computer Technology (NWCT), member.

COMPUTING AND LANGUAGE EXPERIENCE

OS/Network Environments: Windows 3.1, 95, 98, NT; Macintosh OS 8 and 9; DOS, 
VMS, SCO UNIX

Development Languages/Tools: Access Basic, Visual Basic, REALbasic, Front Page, 
HTML, Dreamweaver, Oracle Power Objects, SQL, PL/SQL, SQL*Plus, Transact SQL, 
WinHelp, Visual FoxPro, IDXL, MAC BASIC, MAC PASCAL, DCL, ULTRA-16 Assembler, 
FORTRAN, PL/I, PASCAL, C

Database and Analysis: Oracle, Microsoft Access, Microsoft SQL Server, Reflex 
Plus, LIMS 2000, Crystal Reports, SQR, FileMaker Pro for Windows and Mac, 
FoxBase, SEEDPAK Laboratory Management System, SAS, ODBC

Project Design/Management: Corporate Modeler, ERwin, Visio, Oracle CASE, 
MacProject Pro, MetaDesign, Information Engineering Workbench, EXCELERATOR

Word Processing/Office: Microsoft Word, Microsoft Excel, Microsoft PowerPoint, 
WordPerfect, MacWrite, MORE, Lotus 1-2-3, TextBridge, RTF

Graphics: Fireworks, Microsoft Image Composer, Micrografx, ABC FlowCharter, 
MacDraw Pro, MacPaint

Mapping: ArcInfo, ArcView, MapInfo

Communications/Internet: Internet Explorer, Netscape Navigator, CompuServe, AOL, 
MacLink, MicroPhone Pro, ReachOut

Financial: PocketMoney for Apple Newton, Dollars and Sense, Quicken, MYOB 
Accounting

DETAILED EXPERIENCE

June 1994-present - Principal Consultant, Computer Concepts and Methods

Engagements have included:

* Data manipulation, analysis, and reporting of reliability statistics for naval 
aircraft. Developed methodology for manipulating raw data and using Microsoft 
Access and Excel for display, statistical analysis, and charting of results.
Currently porting Fortran data analysis programs into a Visual Basic GUI application.

* Design and implementation of a Microsoft Access sales database for tracking of 
sales contacts, proposals, jobs, and spare parts orders for an industrial 
equipment manufacturer, including interfaces to Microsoft Excel for engineering 
data and to Microsoft Word for report production. Extensive gathering and 
analyzing of functional requirements. Developed test cases and test checklist 
for each form and report comprising the database. Developed user and system 
documentation and training materials and conducted training sessions.

* Implementation of Crystal Reports modules and SQL Server queries for an 
insurance claim tracking system.

* Design and implementation of a Microsoft Access quality assurance tracking 
system for a firm that manufactures equipment for the semiconductor industry.

* Design and implementation of Microsoft Access and Microsoft Excel based 
interface for end user reporting and charting.

* Design and implementation of an Oracle/Visual Basic/Excel application for 
tracking logistics cost savings and return on investment analysis. Used 
SQL*Plus, PL/SQL and triggers extensively. Developed integration and system 
testing scenarios used in initial program development and in migrating from 
Windows 3.1/Novell to Windows NT.

* Development and enhancement of FileMaker Pro databases for various small 
business clients with Windows and Macintosh.

* Upgrade of Macintosh FoxBase financial database to Visual FoxPro for a 
financial services firm. Extensive regression testing of all modules on new 
system to ensure that each function and calculation worked exactly the same as 
the old system.

* Writing recommendations for upgrading a Macintosh office configuration.

* Writing Crystal Reports modules for an Oracle/Access database used for rail 
fleet tracking.

* Development of a Microsoft Access application for laboratory cost management.

* Enhancement of an Oracle/Access application for facility management.

* Design and implementation of a paratransit research tool which automatically 
generated specifications documents, for Windows and Macintosh using Oracle Power 
Objects.

* Data modeling, design, and implementation of environmental laboratory 
information management systems (LIMS). Developed test cases and test scenarios 
and documented results.

* Requirements analysis and detailed design of an environmental assessment 
database.

* Design and implementation of a Visual Basic front end for an Oracle records 
management system

* Development of word processing templates for desktop publishing stationary on 
the Macintosh for Microsoft Word and WordPerfect.

* Implementation of accounting solutions for own business and client offices 
using MYOB.

* Documentation of commercial application software for the Apple Newton.

* Design documentation for a Decision Support System used in the pharmaceuticals 
industry.

* Recommendation, acquisition, and set up of hardware, software and networking 
for small business clients.

January, 1989-September, 1995 - Senior Technical Manager, Roy F. Weston, Inc.

Designed and implemented an extensive customized Laboratory Management 
Information System (LIMS), including a laboratory management component for 
sample tracking and results analysis, an inventory tracking component, for 
ordering and stocking laboratory supplies, and an industrial waste component, 
for monitoring and permitting industrial waste water usage, using ORACLE and 
CASE tools for a UNIX-based target machine. Interfaced with geographically 
separate implementation staff, including several subcontractors. Responsible for 
all documentation and training.

Integrated an ORACLE front end application with an imaging package for records 
management. 

Integrated and enhanced a Commitment Accounting System, an ORACLE-based database 
for tracking research funds. 

Supervised various information management tasks for U.S. Environmental 
Protection Agency clients, including system conversion/development, life cycle 
strategic planning, data administration and modeling, records management, 
security planning, and electronic bulletin board systems evaluation. Used 
PC/PRISM as a planning and analysis tool. Developed methodology for handling 
security through all tasks of the system life cycle. Developed methodology for 
system evaluation. 

Instructor for ORACLE database training sessions. Developed course materials for 
SQL*Plus, SQL*Forms, SQL*Report, SQL*Loader and Easy*SQL and conducted training 
classes.

January, 1987-January, 1989 - Section Manager, Roy F. Weston, Inc.

Responsible for designing and implementing, Weston's Technical Information 
Management System (TIMS), a customized user-friendly package designed for DEC 
VAX and IBM PC equipment, which integrates an ORACLE database, various ground 
water models, the SAS Statistical Analysis package, and the CPS-1 numerical 
analysis and plotting package. TIMS was used in remediation of environmental 
pollution and hazardous waste disposal. It supported a large database containing 
borehole and well information, soil and water samples and their chemical 
constituents, environmental parameters, topographic and soil properties data, 
and mapping information. The software included data entry screens, batch loading 
procedures, quality control procedures, and reporting and analysis modules. 
Efforts have included both system design and user documentation as well as 
development of in-house and client training sessions. Integrated TIMS with 
various Geographic Information Systems (GIS).

January, 1985-January, 1987 - Systems Analyst, Roy F. Weston, Inc.

Analyzed information systems needs and developed plan for automating water 
resource engineering and administrative procedures and upgrading computer 
hardware and software. Used comprehensive Information Engineering techniques for 
developing recommendations and documenting current and proposed systems.

Served as a Task Leader on design of the Operations Reporting System development 
for WESTON Corporate Information Management, using EXCELERATOR as a design and 
documentation tool.

Evaluated database management packages and developed technical database for 
life-cycle costing for storage of nuclear waste.

January, 1977-January, 1985 - Computer Scientist, Planning Research Corporation

Software Manager responsible for designing and implementing an interactive, 
graphics ocean surveillance analysis system, written in assembly language for a 
military minicomputer. This project was part of the Naval Intelligence 
Processing System (NIPS), an aircraft-carrier-based system supporting naval 
intelligence personnel. The software included the executive and memory 
management functions, user interface, database manager, graphics display of 
strategic platform identification and landmass outlines, incoming message 
recognition and storage, and navigational calculation commands. Also responsible 
for client liaison, software development and debugging tools, program 
documentation, testing, and trouble resolution. Used VAX 11/780, particularly 
MTASS, for software development. 

July, 1974-January, 1977 - Programmer/Analyst, KETRON, Inc.

Responsible for Resource Cost Aggregation Program (RECAP), a series of analysis 
programs and a simulation model for naval aircraft maintenance and support 
costs, written in FORTRAN. 

Also responsible for database, design and implementation of FORTRAN error 
checking, update and analysis programs for industrial engineering study of 
underground, conventional coal mining techniques for the Bureau of Mines.

January, 1974-July, 1974 - Programmer, Keystone Computer Associates

Wrote computer program performance specifications and test plans for CV-TSC 
antisubmarine warfare tracking system.


REFERENCES AVAILABLE UPON REQUEST



Member number:7294
Additional Contact information is available on the Information Page.
Software Contractors' Guild (www.scguild.com)
Copyright(c) 1995 - 2001 Cynthia Cole and Software Contractors' Guild, Post Office Box 257,Nottingham, NH USA 03290-0257