Doug McCaughan GreatHire@sidesigns.com 8215 Phlox LN, Knoxville, TN 37919-8490 865-382-3080 cell · 865-691-5748 home · 865-670-7512 fax Internet Application (webmaster) and Database Developer OBJECTIVE Visionary, hardworking, self-starter seeks opportunity to use skills in databases, project management, development, interface design, CF, PHP, ASP, JavaScript, HTML, CSS and web development. Available immediately as a full time employee or temporary contract. EXPERIENCE ---------- Independent Consultant Self-employed, Knoxville, TN 11/2002-present Website design and maintenance such as the retooling of http://www.lng-patent.com and the addition of a satisfaction survey showing only information pertinent to the users previous answers written in PHP. Redecorating websites for holidays and special events (see http://www.cfninja.com/holiday/ for samples). Computer repair and instruction. Added classifieds section to http://www.farragutnow.com/ including a secure backend for ad management using PHP and MySQL. Updates to GA Boot/EJFootwear intranet product management system using ColdFusion MX and MS SQL 2000. Code improvements included ColdFusion User Defined Functions (UDFs) and Custom Tag creation. Core Competencies: PHP, Photoshop, Illustrator, ImageReady, MySQL, ColdFusion 6.1 (CFMX), MS SQL 2000, JavaScript, CSS, HTML, Visual Source Safe, Client Management, Marketing ---------- MS SQL and ColdFusion Developer Internet Billing Systems, Knoxville, TN 1/2002 - 11/2003 Consultant for Internet Billing Systems to maintain, update and expand their MS SQL 2000 database of over 200 related tables and a comparable number of stored procedures. Work involved transaction sql, triggers, cursors and integration with a ColdFusion web application front end including decoupling complex jobs from the interface to prevent timeouts. The work required keeping the database optimized while maintaining the flexibility to fit the business rules of any multilevel marketing company’s billing, inventory, store front and commission needs. Core Competencies: MS SQL 2000, ColdFusion 5, JavaScript, HTML, CSS, Client Management, Remote Development, Terminal Services ---------- Project Management Consultant Popular Enterprises, Inc, Knoxville, TN 11/2002 - 9/2003 Project Manager Consultant for Popular Enterprises, Inc developing an Internet Explorer toolbar allowing their clients to search the Internet directly from a search box and shortcuts on their Internet Explorer window as well as spyware and 404 redirection. Software developed remotely using foreign resources. Core Competencies: Project Management/Planning, QA Planning/Testing, Directing Remote Developers ---------- Senior (Sr.) Web Developer Kasega, Knoxville, TN 7/2000 - 1/2002 High-end web applications using MacroMedia's ColdFusion and Microsoft SQL 2000 databases including implementation of roles based security in a web browser. All applications created with an end user front-end and a client backend such that the company could manage inventory, content, members and the intricacies of their website without having to know any HTML. Taught dynamic web page delivery and structured programming concepts to a young Internet company, trained incoming entry level employees as well as existing developers, directed database designs, and worked with customers to deliver the expected product using ColdFusion 4.5, MS SQL 2000, JavaScript, XML, WDDX and Flash 5. · http://www.WellPlanet.com combined three data packed, similar yet unrelated, databases of herbal medicines using complex MS SQL queries giving end users a wealth of information on natural remedies. An employee backend interface allows for the editing and scheduling of content including streaming media. · http://www.efcusa.com uses JavaScript, ColdFusion and SQL 2000 to allow non-technical personnel to map individual parts on an uploaded CAD drawing to parts in inventory. Changes are immediately available to web site visitors. · http://www.physicianspractice.com uses SQL 2000, JavaScript, and ColdFusion to create an online magazine of content managed and scheduled through an employee backend complete with a banner ad campaign manager written from scratch. Almost all content including categories seen on the front end are created and managed through the backend. · http://www.coacheslocker.com combined SQL 2000, ColdFusion, JavaScript, Flash, XML and WDDX to create an online catalog of apparel fully manageable by a non-technical staff through an employee backend. Features of the Flash movies and particular aspects of the apparel can be made available or removed at the click of a button. Everything from color to styles to availability can be controlled through the backend interface. Orders are placed online. · http://www.coacheslocker.com/spiritstore creates vertical markets for CoachesLocker by using backend inventory controls to brand sites for individual high schools allowing students to purchase their own school apparel online. Core Competencies: ColdFusion 4.5, MS SQL 2000, MS Access, HTML, CSS, JavaScript, Visio, XML, WDDX, Flash, Client Management, IEAK, VNC, PCAnywhere, MS Project ---------- Owner/Operator City Online of Knoxville, Knoxville, TN 9/1997 - 3/2000 Web developer with a concentration on highly, interactive database driven web sites using Allaire's ColdFusion Application Server. Use software development techniques including project planning and proper documentation to assure high quality web sites. Provide hosting solutions on both Linux and NT. Provide dialup access to the Internet. · Front-end (customers) and backend (employees) systems using some or all of either an Microsoft Access or Microsoft SQL 6.5-7.0, SSL, ColdFusion, JavaScript, Flash, Verity, and e-commerce with Authorize.net include http://www.ace-online.com, http://www.bidexpress.com (contracted through Weberize), http://www.walloffame.com, http://www.spinoffdigest.com, http://www.our-link.com, http://www.angielloyd.com, http://www.talentrek.com and http://www.mytom.com. Features include customer management, inventory control, automated submission to E-bay, custom ColdFusion tags for code reuse, Fusebox programming style, user signups, credit card processing, verity searches, invoice management for fulfillment and tracking, multiple levels of controlled access, dynamically generated web sites, customer managed content, and replicated sites. · Marketing sites with no backend include but are not limited to http://www.steelvisionsinc.com, http://www.audiomediagroup.com, http://www.knoxobgyn.com, http://www.colknox.com, http://www.mtginternet.com, http://www.tennlaw.com and http://www.oplanet.net. · Non-programming duties include but are not limited to hiring and training of personnel, client management and billing, marketing including creation of new marketing materials, and all IT duties including cat 5e wiring, building development systems, software installations and upgrades, and networking. Core Competencies: Business Management, Business Development, Client Management, Sales, Accounting, Human Resources, ColdFusion 3.0-4.5, HTML, JavaScript, MS Access, MS SQL 7-2000, FileMaker Pro 3.0, Photoshop, Illustrator, ImageReady, Fireworks, Quickbooks Pro, Visio, Acrobat ---------- Software Test Engineer SAIC, Oak Ridge, TN 8/1998 - 5/1999 Created and executed test plans for various large-scale projects. Web design and programming with ColdFusion. · Created and executed test plans and documentation for a cargo tracking and billing system written in PowerBuilder for a major intermodal transportation company. · Created and executed test plans and documentation for a land management document control system using Internet technologies. · Created and executed test plans and documentation for a dosimetry tracking and reporting system written in FoxPro. · Created an intranet based tool for company adherence to standards, procedures, and documentation during product development using ColdFusion, Visual Source Safe, and Oracle stored procedures. Directly responsible for 1 of 5 modules with feedback and peer review input into the other 4 modules. Core Competencies: ColdFusion 4, PowerBuilder, Visual Source Safe, Oracle, FoxPro, Test Planning/Execution, Specification Writing ---------- QA (Quality Assurance) Central Testing Manager The Learning Company, Knoxville, TN 10/1993 - 3/1998 Created the Central Testing Division of The Learning Company. Central Testing (CT) is an inter-company third party test lab supporting the five development divisions of The Learning Company from a single location in Knoxville, TN; two development divisions are in Knoxville 5 miles from Central Testing, one development division is in Minneapolis 500 miles from Central Testing, and the two are in Fremont, CA 2000 miles from Central Testing. CT grew from zero employees to 60 employees in merely one year's time and quickly out produced the quality of testing by contract testers at the other sites. Documentation showed a substantial savings to The Learning Company in the first year of Central Testing. Duties included facilities coordination with the facilities manager and subcontractors to build and maintain the infrastructure required to support a 120 computer test lab and 60 personnel, hiring and termination of fulltime and contract employees, employee training and mentoring, human resources issues, reviews and promotions, budgeting and forecasting, public relations to the vice-presidents of other company divisions, procedure creation and implementation for providing timely and accurate quality assurance testing and feedback of projects in development to remote development teams, and direct management and training of two managers, an administrative assistance, a quality assurance manager, and a information technology manager. Other jobs within The Learning Company included: · QA Engineer II. Assisted in the creation of the Foreign Language Division's Quality Assurance Department. Created and executed test plans, developed defect tracking procedures, participated as a technical and quality advisor in development meetings, and supervised a team of product testers. · Software Technician. Developed and executed procedures for creation of the final master release CDs for the Foreign Language Division, tested products prior to release, revised product documentation for one updated product and created product documentation for three new products, and maintained and updated division web pages. · Technical Support Help Desk. Provided Level 1 support to customer via phone, fax, and email. Assisted MIS with telcom support, 10 base T and cat 5 wiring, and hardware and software troubleshooting. Core Competencies: Business Development, Facilities Design, Personnel Management, Training, FileMaker Pro, MS Access, MS Project, QA Planning/Testing, Telcom, Wiring, Hardware Support, Software Support ---------- Unix System Administrator University of Tennessee, Knoxville, TN 8/1992 - 3/1993 Supervised 5 backups personnel and revised the backup scheme as the network grew, configured new Sparc stations, troubleshot hardware and software issues for the Computer Science Department staff, provided second level support to the Lab Assistants, and participated in planning sessions on managing the TCP/IP based network. Core Competencies: Leadership, Organization, SunOS 4.12 and other OSes, Hardware Support, Software Support ---------- Lab Assistant and Backup Administrator University of Tennessee, Knoxville, TN 8/1991 - 8/1992 Operated a help desk for students working on Solaris SunOS 4.12, HP-UX, Windows 3.1, Macintosh 6.07. Performed nightly tape backs of a large heterogeneous UNIX network and reorganized backup procedure for efficiency. Core Competencies: UNIX, Training ---------- Resident Assistant University of Tennessee, Knoxville, TN 8/1990 - 8/1991 Mentored approximately 40 students per term while providing educational and social opportunities, facilities security, managed emergency situations, performed regular administrative duties, peer advising, and counseling. Core Competencies: Leadership, Crisis Management, Event Planning ---------- ---------- ADDITIONAL INFORMATION ---------- Soft Skills: · Communication: 20 years of juggling and live entertainment lend to great people skills, very personable, customer relations · Writing: Well written, exceptional grammar, technical writing skills · Organizational: very spatial oriented, structured, can work equally well with hierarchical or abstract concepts and organization, 5 years practical experience in Software Quality Assurance and associated training compliment organizational skills · Esoteric: Creative, Visionary, Self-starter, Entrepreneurial, Rapid Learner, Both Independent and Team Player Training: · Bondware training by Nashville-based EdgeNet · Systems Testing & Quality Assurance Tech Seminar by Advanced Information Technologies · Software Project Management by Educational Services Institute in association with The George Washington University · Participant in E3s QA Day - An all day QA Conference and open forum with influential persons and trend setters from the gaming industry’s quality assurance field (sponsored by Advanced Quality) · First Things First Time Management Seminar by Covey Leadership Seminars · Basic Supervision by Keye Productivity Center a Division of American Management Association · How to Develop and Administer a Budget by Fred Pryor Seminars ---------- ---------- REFERENCES ---------- Available upon request.