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 Javascript programs and perform adjunct data manipulation to:• 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• provide Excel versions at intermediate process waypoints for client direction, approvals, and changes• compute derived fields and segment lists per specified criteria

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• OCR and artwork Scanning• Equipment maintenance and calibration• Photo retouching and color adjustment for successful printed results• Data conversion, e.g. excel to press-ready layout, etc.PROGRAMMING: Write scripts to automate repetitive business processes including page imposition, crop marks placement with arbitrary element rotations, as well as artwork proof approval e-mail generation. Automate mailing list manipulation and data conversion tasks for variable-data mailings. Write time-saving script to extract information from customer supplied Filemaker databases to automatically typeset approval-ready business card artwork.PREPRESS SOFTWARE:Adobe Illustrator, InDesign, Photoshop, Acrobat, Quark XPress, Word, Excel, PowerPoint, etc.IT: Macintosh networking, Internet LAN/WAN, firewall, cabling, switch installation, wireless access implementation. Upgrade hardware and software to keep pace with evolving customer and industry advancements. Install internal web/dns/ftp/e-mail server to expedite online receipt of customer supplied artwork. ADMINISTRATIVE: Job production scheduling. Price estimation, quoting, resource planning, data archiving and maintenance of customer artwork for future projects. Work with repair vendors for problem determination and resolution. Manage all company operations while owners away.

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 fast-paced, ever-changing print production environment. Consult with customers when new artwork arrives, advising necessary changes to achieve print-ready status. Answer customer questions regarding graphic arts software selection and use.

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 fourth generation programming tools. Responsible for future internetwork planning, evaluation, and implementation. Also responsible for implementation and maintenance of division-wide e-mail system. Evaluate new software and establish vendor contacts. Assist in end-user problem determination and resolution. Create multimedia presentations. Champion Data Access Language pilot program.

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 office automation specialist for Advanced Programs Office. Tasks include software and hardware recommendations, problem resolution, and administration of all data processing related issues.

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.