David Colwick Email & Phone Number

• Determine potential points-based competitor outcomes prior to surfing contest completion from website data available only in a heats-based format. Results used during live contest broadcasts. Write Python code to:
• generate Excel spreadsheets by screen scraping data from multiple html pages lacking a public-facing API into a concise format for viewing competition data during contest
• calculate potential points-based outcomes as contest progresses through each heat of multiple rounds
• generate JSON files containing competitor attributes used to inform subsequent calculations
• screen scrape separate competition calendar web pages and combine for unified Excel export

• Programming and data-manipulation work for a consultancy that directs fundraising campaigns for non-profit hospital foundations. Significantly decrease cost and turn-around time of prior process. Write custom.
• apply probabilistic inference of record similarity to efficiently deduplicate redundant mailing list names and to suppress separately specified names and addresses
• acquire, synthesize, and sanitize mailing list data supplied in multiple formats into standardized format
• convert fixed-field files into tab delimeted files from file structure specification
• create and verify fixed-field files and associated file structure specification from tab delimeted files to ensure mailing vendor database suitability
• add unique IDs to ensure data auditability and process integrity

Mission Viejo, CA

• Layout, typesetting, print artwork preparation to various vendor and customer specifications
• Cost-estimating, pricing, vendor identification and selection, and job progress tracking of brokered print jobs

Garden Grove, CA

• Primarily responsible for all aspects of computer prepress processes. Assist in all aspects of business function as required, including managing operations when needed. Revise customer artwork to be production-ready.
• Create artwork, layouts, typography
• Rebuild and/or revise customer supplied artwork to meet stringent printing process requirements
• Evaluate and fix artwork, correcting typos, centering graphic elements, grammar, spelling, alignment, adding bleeds, etc. to ensure quality results
• Film output
• Pagination, imposition, creep calculation, trapping, gripper adjustment

Garden Grove, CA

Help manage and operate family-owned commercial printing company, growing annual revenues from $300K to $1.3M. Install company’s first imagesetter to transition from analog to digital prepress processes. Learn nearly all business operation and production manufacturing functions. Primarily responsible for all aspects of computer prepress operations in a.

Long Beach, CA And Fullerton, CA

Assist Information Systems Group in support of 700+ node multi-vendor mixed OS microcomputer environment. Advise management on key information technology issues, including hardware and software selection, investigation and application of new technology, and future direction and planning. Responsible for Macintosh based applications development tasks using.

Fullerton, CA

Implement Business Opportunity Assessment Tool using Excel’s Macro language. Duties include specification, design, implementation, and writing of requirements documentation, a user’s manual, a detailed design description, and a configuration management plan. Test and verify model’s mathematical calculations including numerical integration. Also serve as.

Santa Fe Springs, CA

Support Management Action Task Team in all aspects of Macintosh and PC DOS computer usage. Tasks include hardware installation, project scheduling, computer aided graphic design, software development and software modification, mainframe connectivity, and software evaluation for applicability to team requirements.

Anaheim Hills, CA

Responsible for development, implementation, and documentation of a database using Pascal to aid test engineers in designing fault detection and isolation tests. Earned Cost Improvement Program award for this effort.