David R. Wallace


Developer - Trainer - Analyst - Artist

  • CREATIVE APPLICATION DEVELOPER WITH OVER A DECADE OF EXPERIENCE:

  • Front-end Web Development - full stack experience.
  • Report Development - SQL, Crystal Reports, MS Access.
  • MS Office automation – Custom Access and Excel Development.
  • End user and Technical Training.

Personal Information

Address
Mesa, AZ
USA
Email
 dave@davidrwallace.com
Phone
 480.259.5422
Website

Employment

2010 - 2014

Tag Employer Services

from 2010 to 2014

SENIOR APPLICATION DEVELOPER

  • Front-End Development using CSS3, JSON/AJAX, JavaScript, HTML5 and a variety of popular libraries and components.
  • MS SQL Server and MS Access development. Creation of queries, views and stored procedures using t-SQL. Complex relational and semantic data modelling.
  • Conversion of legacy components written in VBscript and Visual Basic, to JavaScript.
  • UI Design.

→ View Portfolio

2007 - 2009

Fluoresco Lighting & Sign

from 2007 to 2009

DATABASE APPLICATIONS DEVELOPER

  • Data management, reporting and Microsoft Access application development involving multiple databases and clients distributed across 3 states and 11 branch locations
  • Development of complex, custom reports using Crystal Reports, Report Smith, Access, Sql., Web.
  • Administering and development of Fluoresco's MS SQL Server that pooled all company data from several databases and ran as the back end to various desktop and reporting solutions.

→ View Portfolio

2002 - 2007

Skillramp

from 2002 to 2007

CONSULTANT & TECHNICAL TRAINER

  • Delivery of technical training courses, custom reporting solutions, database and application development.
  • Consulting and development for Arizona Department of Health to create some highly customized reports using Crystal Reports and Oracle data. Reports include tracking of average sample transit times between hospitals and the State testing lab taking into account location, holidays, weekends, work hours, volume, etc.
  • Programming in PERL training to the INTUIT internet team in Tucson, AZ
  • Microsoft C# .net training to development team from Intel, Sacramento.
  • Microsoft Visual Basic Application Development training to programmers from Microsoft's Finance and Data Team in Reno.
  • Microsoft Visual Basic Application Development training to Nevada State IT.
  • Microsoft ASP.net training to Wells Fargo web developers.
  • Consulting and VBA automation development 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 a a minute or two of sub-routine execution)
  • Development of "Work Estimation" application for a non-profit company in Phoenix, AZ. Outputs mufti-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.

1998 - 2002

ExecuTrain of Los Angeles/Irvine/Phoenix

from 1998 to 2002

TRAINING SPECIALIST

  • Delivery of training courses teaching desktop applications, web technologies, database modelling, application development and reporting solutions.
  • Delivery of Prosoft Certified Web Master bootcamps and web development courses
  • JavaScript training to the Disney.com development team.
  • Frame-Maker and Acrobat training to Earthlink's technical writing department.
  • VBScript training to Pacific Life's security division.
  • Database application development for ExecuTrain on in-house access database to track profitability and categorize courses.
  • Excel VBA consulting for Freemont Investments.

1994 - 1998

Self Employed Artist

from 1994 to 1998

PROFESSIONAL ARTIST

  • Created paintings in a variety of mediums.
  • 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 portraiture, 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.

→ View Portfolio

Education

1988 - 1990

University of Southern California

September 1988 - June 1990

Undergraduate Courses

1990 - 1994

Arizona State University

September 1990 - June 1994

B.A. Theatre

Extensive acting courses. Performed in several University Productions. Wrote and directed. Also took drawing & painting courses.

Skills

Design

Color Design
Expert
Web
Expert
Drawing
Good
Graphics/Photoshop
Very good
User Interface
Expert
Database Design
Expert
Report Design/Crystal Reports
Expert

Development

Programming Languages
HTML5 CSS3 JavaScript jQuery XML php5 C# ASP JSON PERL VBA Transact SQL VBScript
Other
CodeIgniter ADO AJAX Twitter Bootstrap Design Patterns OOP SEO Single Page Apps Relational Data Modeling Stored Procedures Queries/Views Microsoft Office Automation Distributed MS Access Development Crystal Reports Development

Hobbies

Movies Sailing Painting Guitar Trumpet Family

Portfolio

Member Manager

Popup member admin.

Report Manager

Custom report builder with criteria and export.

Slide Show Manager

On page slide show manager to customize animated show on home page.

Sharebox

Share box to allow users to share forum discussions via email, social networks, or to blog.

Dashboard

Working dashboard mockup as part of new TAG site design proposal.

Report Designer

Custom report wizard.

Payroll Entry Form

Styled Payroll Entry

Forum Thread Design

Clean member forum thread interface.

Work Estimation Application

Work Estimation Application made in Access with Excel output.

Crystal Reports Launcher

Report Menu with Criteria and Crystal Reports Generation.

SQL Query Builder

SQL Query Builder and SQL Parser.

Member Directory & Search

Member Directory page with search features.

HR Management - Payroll etc.

Payroll entry.

Action Report Designer

Management Tool for Community Chairs.

Efficiency Report

Made with Crystal reports.

Bookclub

Bookclub Website & CMS.

ASA Website & CMS

ASA Website & CM

Deployment Wizard

VB Desktop Deployment Application.

Contractor Panel

CAMS home builder database application.

Home Options Admin Panel

CAMS home builder database application.

AZMC Member Profile

AZMC Website & CMS

John Bernabei Actor- J-Sleave

Oil on Linen

Many People Face

OIl Pastel on Rag.

Everyhuman

Pastel on Rag Board.

Lined Face

Oil Pastel on Rag Board.

Seekers

Oil Pastel On Rag Board.

Good Heaven's

Oil Pastel on Rag.

Fenced In

Pastel on Rag.

Frog

Oil on Canvas.

Shack in Marsh

Oil on Linen.

Committee Page

Design & Development