Scott M. Tann
328 N. State Street Westerville, OH 43082
(614) 899-2908
Summary of Qualifications
Programmer, database developer since 1991; Web designer and application developer since
1998; Fluent in OOP and RDBMS/Procedural; Extensive experience in all phases of the SDLC
Programming Expertise
- AJAX, Javascript (vanilla + libraries: jQuery, Prototype/Scriptaculous, Dojo), HTML, CSS, Apache/LightTPD
- PHP & frameworks (Zend, CodeIgniter, ATK), Ruby & frameworks (Rails), XML/XSL, SOAP/Web services, some Perl
- PostgreSQL, SQLite, MySQL, Access, 4th Dimension; Magento, X-Cart; Wireshark, SNMP; Visio & Office; Crystal Reports
Strong knowledge of traditional and internet telephony
- SIP client configuration, operation and troubleshooting, IP PBXs (in particular Asterisk), Class 5 softswitches, MUXes, session border controllers, voicemail servers
- Layer 3 switching, QoS/DSCP, SIP trunking, circuit emulation, TDMoIP, subnetting, vLANs, WiMAX
Operating systems
- Unix/FreeBSD, Linux (Red Hat, Cent OS, Ubuntu), Solaris 10, Macintosh OS X
- Windows Server/XP/Vista/7
Freelance technical writer and journalist
Fluent in French, some Spanish, German, and Russian
Professional Experience
Cincinnati Bell Technical Services, Cincinnati, OH, March 2011 - present
Senior Application Developer
All projects below are for General Electric:
Refactoring "Touchless Build" for General Electric, a Zend application that allows users to initiate virtual server builds
- XML data is received from provisioning system (Kintana) and pushed to application engine
- Virtual server options are parsed, processed, and sent to Perl and Bash scripts for server build
- Result variables are processed and packed into XML, user/admins notified
Migrating "Touchless Build" to DynamicOps
- Touchless Build decommissioning process started in August, 2011
- Converted mission-critical PHP functions to PowerShell and Bash scripts
Added reporting functions to "Tiered Security" Network Segregation Application, a Zend app which allows engineers to analyze network traffic. Features of Reporting module:
- User enters source (and, optionally, destination) IP address, port and protocol
- Network traffic records are queried and presented to user at /24 level
- User can view host records for each IP address
- All results can be exported to CSV
Channeltivia, Fremont, CA, March 2010 - present
Chief Data Architect
Responsible for design and alpha/beta development of channeltivia.com, a site which offers "Channel as a Service"
functionality and collaboration space to the I.T. vendor, distributor, and reseller communities.
Digital Pottery, Westerville, OH, October 2001 - present
President
Founded a firm specializing in web development, VoIP consulting, technical writing, and app development for iPhone,
iPad, and Android.
Resource Interactive, Columbus, OH, February 2011
Web Application Developer
Facebook App: Built Facebook Application for Frédéric Fekkai's It Girl campaign:
- Users can vote for their favorite "Look" and hair care products, share styling tips, and "Like" the It Girl
campaign
- Built MySQL database, wrote all PHP code, responsible for CSS and jQuery scripting
catchow.com: Worked on content management system for Purina Cat Chow website
Promedia Ohio, Columbus, OH, Periodically from July 2009 - present
Web Application Developer
Built two real estate web applications for use with HER/RealLiving listing data: prorealtour.com and reallivingtours.com, currently rebuilding application for nationwide use.
reallivingtours.com allows agents and brokers to add listings to virtual tour website
- Data is sent as CSV file from HER's central office to site, processed via cron job
- Connects to remote SQL Server and retrieves additional listing information & images
- Listing information is pushed as XML to 3rd party search engines (including realtor.com)
- Dynamically generates downloadable flyers as PDFs
- Tours generated on-the-fly for user, virtual tours are integrated with Flash and MP3s
- Administrative interface allows agents and brokers to sort images, add captions, and select music
prorealtour.com allows agents to update real estate listing and users to receive text messages with links to listings
- Built PHP-based SOAP clients to connect to SMS gateway
- Built XML interface to load reallivingtours.com image URLs into Flash ActionScript
Tracer Media, Columbus, OH, June - September 2010
Web Application Developer
Involved in three projects:
McGraw-Hill DLM Early Childhood Express - Class Assessment & Reporting Application for Teachers & Administrators
- Complex web application written almost completely in javascript/AJAX using Prototype with a PHP service layer
- Built two distinct, complex report generators for classes and students - nine reports total
McGraw-Hill TEAM Math Assessment Tool - Math Scoring & Reporting Application for Teachers & Administrators
- Complex web application written almost completely in javascript/AJAX using Prototype with a PHP service layer
- Built three distinct, complex report generators for classes and students - seven reports total
Mariposa Insurance Services, Ltd
- Brought in to rescue insurance adjusters web application at mariposaltd.com
- Fixed bugs in legacy code, added features (custom scripts for form validation, list sorting, cron jobs to warn adjusters when software licenses were about to expire, etc), normalized existing database
Welspun USA, Columbus, OH, July - August 2010
Web Application Developer
beddingstore.com: Built PHP middleware application to regulate data exchange between Magento online store and
Richter, a legacy order fulfillment system
- Application reads and processes order data from Magento and pushes to CSV files for Richter; a reverse process is used to push tracking and shipping data to Magento via PHP/MySQL calls
Data Resolutions, Columbus, OH, February 2010 - April 2010
User Interface Engineer
- Completed advanced javascript routines for company flagship product, SiteQuarters, a web-based CMS
- Documented PHP and javascript codebase
Health Compliance Associates, Columbus, OH, September 2009 - February 2010
Database Administrator, Data Miner
- Maintain PostgreSQL database containing over 200 million rows of health insurance claim data
- Write ad hoc Ruby/BASh scripts and SQL queries to mine claims for recovery
Quest Software, Columbus, OH, July 2009 - August 2009
Web Designer
- Created CSS templates and built jQuery-based script library for Quest Software's Support website
- Tested on all major browsers and made site 100% compatible with Internet Explorer 6
383 Inc, Columbus, OH, September 2008 - April 2009
Senior Software & Web Application Developer, Telecommunications Engineer
- Built EnergyEdge, an application for TAC, a division of Schneider Electric, to communicate with SOAP servers to
regulate HVAC, power, and lighting systems; pilot installations at 30 Rockefeller Center and the McGraw-Hill
Building in New York City
- City of Wadsworth IP PBX with all accounts stored in secure web databases for online access/modification
- Wholesale telephony invoice auditing application for cluster of IP PBXs at Datacenter 101, Columbus
- Contributed to ePlan Room, a web application for managing construction project documentation at
constructionone.com
- Built online In/Out Board for Four Points Real Estate private network
- Thoroughly hacked Redmine, an open-source project management web application, for internal use
Chris Hillseth Enterprises, Westerville, OH, May 2008 - September 2008
Web Application Developer
- Integrated ERP with X-Cart online store and AJAX multimedia auction site
Valtech Communications, Reynoldsburg, OH, August 2005 - May 2008
Manager, Senior Software and Web Application Developer, Telecommunications Engineer
- Built wholesale invoice auditing application; recovered $100,000 of overbilled charges over a 20 month audit for a company that averaged $4 million in revenues
- Built IXC and BAF call record extraction applications, integrated with legacy billing system
- Maintained and administered local area network and data center routers, layer 3 switches, servers
- Customized voicemail server to e-mail audio files, include paid advertising in messages, and provide MWI; created web interface for voicemail account creation
- Customized open source technical support ticket web site, trained users
- Managed team to test and troubleshoot wired & wireless (WiMAX) network infrastructure, long-haul circuitemulation (TDMoIP) trunk and transport system between Mansfield and Columbus; implement packetization and quality of service (QoS) policies
- Built and modified Crystal Reports to generate sales commission, line change, and inventory reports
- Wrote technical documentation (troubleshooting, user guides, etc) for all of the above
Quantum Leap Financial Services, Worthington, OH, November 2004 - August 2005
Web Application Developer
- Built ClientView, a back-end web application used to manage life insurance and credit repair accounts
- Built secure online application for credit repair customers, easy life insurance quote engine
- Wrote web copy for life insurance and ROI primers; assisted in seminars on the basics of life insurance and FICO credit scoring for first-time homebuyers
Education
University of California-Davis, Davis, CA, September 1992 - June 1998
- PhD program for French Literature, concentration on the 19th century novel
- Awarded a Wakeham Fellowship to study at the Ecole Normale Supérieure, Paris (1995-1996)
- Teaching Assistant, Graduate Student Representative to the Faculty, member of Graduate Student Assembly
University of Pennsylvania, Philadelphia, PA, September 1987 - June 1991
- Bachelor of Arts, graduated cum laude
- Columnist, Daily Pennsylvanian; Prose editor, Penn Review
- Varsity Track
Columbus Academy, Gahanna, OH, September 1983 - June 1987
- Graduated in First Quintile, with honors
- Varsity Soccer & Track