Application Developer – Data and Report Architect – Artist

David R. Wallace - Online Resume - 2011 - | email: Dave@davidrwallace.com
Resume	Work Sample Gallery	Client Evaluations	Courses and Teaching History	Detailed Skills List

SKILLS

LANGUAGES: VB6, ActiveX, VBA, PERL, VB.NET, C#.NET, Crystal VB., ASP.NET, VBScript, JavaScript, Classic ASP WEB: JavaScript, VBScript, ASP, ASP.net, XML, XSL, DTD, DHTML, HTML, CSS1, CSS2, CSSP, Microsoft FrontPage, DreamWeaver, Homesite, Flash. AJAX,, JQUERY PROGRAMMING SKILLS: COM, ActiveX, Interfaces, Highly Creative Querying Skills DATABASE: Access + VBA + Security, SQL Databases, Structured Query Language, Lotus Notes, ODBC, ADO, ADO.net, OLEDB REPORTING: Access, SQL, Crystal Reports, Monarch, Excel (VBA Automated). GRAPHIC DESIGN: Corel PhotoPaint, PhotoShop, Macromedia Flash, Corel Depth, FreeHand, Macromedia Fireworks, GIMP LAYOUT: Quark Xpress, MS Publisher, Adobe Acrobat, FrameMaker, CSSP, XSL OFFICE: Excel, Word, PowerPoint, Outlook, Access, Automation INTERNET: Cross-browser UI, SEO master, AJAX, Jquery, Custom CMS, Payment Processing, community platforms, forums, web2.0, usability, interactive design

Work Experience

WEB APPLICATION DEVELOPMENT 2009-Present Employer: Self/Contract - Arizona Mexico Commission Built website for the Arizona Mexico Commission AZMC.org Dynamic website with custom CMS. Built with MSSQL, Classic ASP, JQUERY, Javascript, HTML, CSS, AJAX DATABASE APPLICATIONS DEVELOPER 2008-2009 Employer: Fluoresco Lighting & Signs Data management and development of multiple databases and clients distributed across 3 states and 11 branch locations. Development of custom reports using Crystal Reports, Report Smith, and Access. Creation of a wiki based library of all company data and development history and definitions. WEB DEVELOPER February 2007-November 2007 Employer: ITtoolbox Groups Project: New Global Post Form. (view live on ITtoolbox.com) New group messages page with dynamic message reply form and choice of expanded vs. collapsed view. (view live on ITtoolbox.com) New "Watch This" feature to mark and track group threads. (view details here) Sharebox Project: Auto centering, auto-sizing, cross-browser, multi-tabbed popup box with a single asp function call implementation. Send to blog tab that sends current page content to several popular blog applications using their APIs Send to friend tab to email current page content to one or more email addresses. Social networking tab to post current page to many of the popular social networking web sites. News Letter Project: HTML news-letter version with formatting and images designed for optimal viewing in all major email clients. Text news-letter version. Administration tools to select news letter content, featured items from content News letter preview Stored procedures to calculate most active web site users and subtotal contributions by contribution type Stored procedures to determine most popular white paper and output related summary data Excel VBA application to import recent journal posts to facilitate the selection of journal entries that will be available for news-letter inclusion. Web based admin forms to assign journal entries and blog entries to particular knowledge categories. Assignments are store in SQL and determine what consent will be available for weekly news-letter inclusion. Both forms generate scriplet for future activation. Keyword manager project: AJAX based keyword to knowledge area assignment web application. Implementation of keyword assignments to create dynamic meta tags based on assignments Implementation of keyword assignments into parameters for custom ad requests. Alerts and Newsletters Signup Page: (view live on ITtoolbox.com)

CONSULTANT AND TECHNICAL TRAINER 2005-2007 Contracted-For: Skillramp, Learn It, Mindworks, American Express Delivery of technical training courses and consulting (Course List) Most recently, development of custom application for American Express to be used worldwide.

SENIOR PROJECT CONSULTANT 2002-2003 Employer: Skillramp Delivery of technical training courses and consulting (Course List) Most recently, development of custom application for American Express to be used worldwide. The application was a customization of excel using VBA and to automate the distribution, customer entry, collection, and reporting – of a highly variable and involved contract form/process. Combining programming with leading reporting tools such as Crystal Reports and VB Creation of custom management application with Camelot Homes of Phoenix (VIEW) Arizona Department of Health to create some highly customized reports using Crystal Reports and Oracle data - including one that tracks average sample transit times between hospitals and the State taking into account location, holidays, weekends, work hours, volume, etc. Oracle based data using custom Access queries and VBA to re-render old Oracle data into new definitions used by a few of the State Health department's Crystal Reports solutions. VBA automation with Thermador/Bosch Corporation to automate the processing of data into a variety of summaries and graphs i.e. Lines of equal life time, Product failure trends, etc. (Helped Transform a week+ long reporting process into 20 seconds) Extended the database application of a national recruiting company to allow them to create dynamic queries by including and/or excluding any amount of variables. The application includes a custom UI, and also generates dynamic SQL code that can be directly altered and saved if desired. The application includes several dynamic report output options. (View) Development of "Work Estimation Application" for a non-profit company in Phoenix, AZ. Outputs multi-dimensional reports and graphs comparing all of the requested dimensions of employee, actual work. Extensive VBA used to create a totally custom, real-time, measure and reporting tool - reports and graphs are dynamically generated in Excel from COM VBA behind the ACCESS UI - managers dynamically add and remove factors that they wish to have influenced the compensation. Every factor is assigned a weight to specify a degree to which that task, or dimension, should influence the estimates. Bonus functionality to track historical transactions. This provides reporting functionality to compare multiple result sets, to assist managers in measuring the effectiveness of policy decisions, over any span or time, and any periodic perspective (View #1) (View #2)

CERTIFICATION TEST AND COURSEWARE DEVELOPER 2000-2002 Employer: Igeneration Review JavaScript, HTML, and ASP Certification exams Evaluate and advise on certification goals Writing questions for certification exams Instructor for IGeneration's Talent Boost program.

TECHNICAL TRAINER 2001-2002 (note: employed by ExecuTrain while contracting with Igeneration) Employer: ExecuTrain of the Southwest Training a variety of technical courses both custom and standard (a few examples listed) C#.net to 20+ Java and C++ developers from Intel Sacramento VB development to programmers from Microsoft's Finance and Data Team in Reno ASP.net for Wells Fargo web developers VB development to Nevada State IT PERL to the INTUIT internet team in Tucson, AZ

SENIOR TRAINING SPECIALIST 1999-2001 Employer: ExecuTrain of Los Angeles Develop database and Intranet solutions critical to in-house operations Trained Adult Desktop Courses Attended entire track of the Microsoft Developer (MOC) Courses at night and began to merge into technical training JavaScript to the Disney.com development team Frame-Maker and Acrobat to Earthlink's technical writing department VB-script to Pacific Life's security division Programmed ExecuTrain's in-house access database to track profitability and categorize courses Programmed Excel VBA solutions for Freemont Investments.

CORPORATE INSTRUCTOR 1997-1999 Employer: ExecuTrain of Los Angeles/Irvine Delivery of adult computer training courses, specializing in database, programming and web development technologies. Primary courses of delivery: Microsoft office applications and a variety of web applications and languages Attainment of Prosoft Certification and delivery of Prosoft's Web Fundamentals and Web Design courses (both week long curriculum)

PROFESSIONAL ARTIST 1994-1997 Employer: Self Created paintings in a variety of mediums. Maintained a self-designed web domain for the advertising and selling of artwork. Planned and executed private showings and participated in art fairs ; festivals in CA and AZ. Arranged consignment in stores, galleries, coffee houses and film studios. Pursued contact artistry and design work, specializing in portraitures, J-sleeves, restaurant menus, business cards, and letterhead. Illustrated story boards for the film Alice through the Looking Glass, On Ice Productions (1997); collaborated with directors, set designers and actors to prepare scene-by-scene drawings for use in production.

Education

Universities ArizonaStateUniversity 1990-1994 BA in Theater University of Southern California 1988-1990 Engineering coursework

Other Education Sources Executrain - train the trainer program in Atlanta Georgia (1999) Attended and completed the entire MOC development path (night courses 2001-Los Angeles)

CERTIFICATIONS

Microsoft Office Master Igeneration Certified Instructor ExecuTrain Certified Instructor Prosoft Associate.

Other notable clients include

American Express, city of Scottsdale, SRP, United States Postal Inspector Service, Avon, 21st Century Insurance, Union Bank of California, PIMCO and Conexant Technologies, Banner Health, City of Orange, State of Arizona, Westword Vision