wayne plourde

software architect mcad mcsd scjp

home | articles | book | resume | projects | contact
skills

experience

certifications

education

publications



word version
Wayne Plourde Resume

skills summary

Planning And Architecture:

  • An MCAD (.Net), MCSD and SCJP with over 7 years experience providing full life cycle solutions as a lead in designing and developing architectures for complex systems with Microsoft and Java technology.
  • Project experience includes web-based and client-server applications with budgets in excess of $1 million.
  • Expert at bringing clarity and ease of use to complex systems and developing guidelines and frameworks for system development.
  • Certified in Microsoft Solution Architectures. Fluent in Microsoft Solutions Framework (MSF)
  • Work with clients to document requirements by conducting interviews and facilitating JAD sessions.
  • Develop multi-tiered object-oriented system architectures utilizing use cases, UML diagrams, Rational Rose, RUP tools and Visio.
  • Developed tools for capturing Use Case Scenarios and translating into reports and object models.
  • Expert in developing navigation maps and system prototypes.
  • Prepared project plans and budgets. Authored proposals for submission to clients.
  • Authored system and functional specifications. Specified testing objectives and acceptance criteria.
  • Implemented and deployed development, staging, and production systems for a number of clients and instructed clients on the best practices for maintaining and upgrading these systems.
  • Managed teams of up to 10 developers and outside consultants.
  • Possess excellent communication skills and frequently author articles on development topics.

Development Platforms:

  • Developed solutions with .NET since the release of the Beta 2 version (and current) extensive experience with Visual Studio.Net, ASP.NET, VB.NET, and C# with SQL Server as the database.
  • Highly skilled in web application development using Active Server Pages under both ASP.Net and ASP 3.0. Also familiar with IIS administration.
  • Certified in Web Application development in Visual Studio.Net and VB.Net.
  • Expert in Microsoft DNA platforms, COM and COM+ component development using Visual Studio 6.0. Deployed transaction-aware component systems to Microsoft Transaction Server (MTS) and Microsoft Component Services (MCS). Familiar with C++ ATL component development.
  • Certified in Visual Basic 6.0 desktop and distributed application development.
  • Mastery of ADO.Net and ADO including related XML functionality.
  • Expert in DHTML and client-side browser scripting using JavaScript, JScript & VBScript.
  • Expert in XML, XSLT and Microsoft XMLDocument component.
  • Experienced with additional Microsoft services such as MSMQ, CDO, ADSI, and Indexing Service. Familiar with Biztalk Server, Sharepoint Portal Server and Exchange Server.
  • Designed and protoyped user interfaces using HTML, DHTML, Flash, Photoshop and Illustrator.
  • Certified in Java 2 Platform - both client-side and server-side development. Proficient with CORBA.

Database:

  • 5 years of experience with SQL Server 6.5-2000. Over 7 years with MS Access.
  • Certified in Microsoft SQL Server 2000 Design and Implementation.
  • Expert in developing large scale, fully normalized, and highly complex relational databases (over 100 tables) for a variety of business domains.
  • Expert in developing highly relational and complex databases in both SQL Server and Access. Familiar with Oracle and Sybase systems. Utilize Erwin and other tools for modeling.
  • Proficient in all levels of Transact-SQL (T-SQL) development including stored procedures and processes for implementing transactional integrity in application logic and stored procedures.
  • Proficient with Reporting Tools like Crystal Reports.
  • Developed tools for mapping SQL schema to application logic including auto-generating code.
  • Developed Data Transformation Service (DTS) scripts for handling recurring and administrative task.
  • Experienced with index optimization and the analysis of execution plans and SQL profile logs.
  • Converted SQL Server databases from version 6.5 to 7.0 and MS Access to 7.0.

experience

SENIOR DATABASE ARCHITECT
US Postal Inspection Service, 2002 to Present

Serving on a team of lead architects tasked with the redesign of the Inspection Service's Case Management System. Primary responsibilities include migrating an existing mainframe system to a new client-server system using WinForms, .Net Remoting and SQL Server.

  • Gathering and documenting requirements.
  • Providing guidance on architectural issues - .Net Remoting, database design.
  • Giving presentations to Inspectors on requirements.
  • Providing training on Use Case development.

INDEPENDENT CONSULTANT/DEVELOPER
2001 to Present

Provide consultation services for small businesses. Develop independent projects.

  • FabulousBooks.com
    Developed a DBMS application for FabulousBooks.com, an online used bookstore, using SQL Server, C#, and the .Net Framework. Developed tools for managing listings on Amazon, ABE Books and Alibris. Utilized Amazon Web Services for automating competitive pricing processes. Pricing operations went from two days to 20 minutes.
  • RouletteRevenge.com
    Developed a roulette web portal providing Software Tools and Tutorials for Building Roulette Strategies and Systems with a Vengeance. The web-based service allows users to program roulette strategies, run simulations, and analyze results. System was designed as a full object-oriented, three tier architecture using ASP.Net, VB.Net, and SQL Server 2000. Also, developed site monitoring tools and search engine placement analysis in C# using windows services.

PROJECT ENGINEER/ARCHITECT
Applied Visions, Inc., 1998 to 2002

http://www.avi.com

Applied Visions (AVI) is a software engineering and consulting firm providing services in diverse areas including application development and integration.

  • Guided projects at the inception phase, including interviewing clients, gathering and documenting requirements, and prototyping.
  • Planned and facilitated Joint Application Development (JAD) sessions.
  • Utilized UML. Developed tools for documenting Use Cases and generating object models.
  • Spearheaded information architecture issues and interface design.
  • Defined internal development processes as part of a select task force.
  • Architected sophisticated web-based and client-server business applications.
  • Designed fully normalized, highly relational databases using SQL Server 6.5, 7 & 2000 and MS Access. Utilized diagramming tools in SQL Enterprise Manager and Erwin.
  • Developed transactional data access components in VB 6 and .Net using ADO and ADO.Net.
  • Developed deployment strategies for production databases and web applications.
  • Developed best practices for managing production systems such as configuring separate development, staging and production systems and implementing processes for migrating changes to production.
  • Consulted with clients on optimizing existing database systems including index optimization and the analysis of execution plans and SQL profile logs.
  • Managed best practices for developing, optimizing and load-testing web apps and databases.
  • Supported sales efforts, including giving presentations to potential customers, preparing proposals and developing corporate web site.

REPRESENTATIVE PROJECTS

  • Hillier Group
    Developed an extensive proposal for an enterprise integration project for a large architectural firm in New York. Developed prototypes for utilizing Sharepoint Portal Server 2001 and Exchange Server 2000 as a comprehensive knowledge and document management system.
  • Minolta - Page Scope Router - Document Management Interface
    A client-server document routing application built on the .Net Framework for interfacing with Minolta Copier hardware. Developed a skinnable interface utilizing XML, Photoshop and ImageReady.
  • Goldfinger - Payment Management System
    A prototype web application developed with Visual Studio.Net, ASP.Net, VB.Net and SQL Server 2000 to manage recurring automated payment transactions for the Fort Knox National Company. The application was designed to manage customers, payment histories, and process payment transactions uploaded from Fort Knox clients through an ACH (Automated Clearing House). Utilized typed datasets in ADO.Net. Utilized Use Cases and UML for identify entities for system design and business logic.
  • EZFrame Platinum
    A client-server Optical Practice Management application developed with Visual Studio 6.0, Visual Basic 6.0 and SQL Server 7.0 (and MSDE) for the Luxottica Corporation (owner of LensCrafters). Designed database with nearly 200 tables. Utilized Use Cases for system design. Designed and implemented a multi-tier COM component architecture featuring data access components utilizing ADO and driven by customizable metadata and stored procedures. Provided transactional integrity in all components. Developed utilities for backup, restore and conversion of databases from previous versions. Developed Data Transformation Service (DTS) scripts to for data migration and a utility for managing and editing metadata.
  • AVINet
    A corporate intranet designed and implemented for AVI utilizing all aspects of Microsoft DNA, utilizing Visual Studio.Net, Homesite 5.0, ASP and SQL Server. Handled security issues with user profiles integrated with Windows accounts and custom security logic supported by ADSI accessing system permissions. Developed secure data access COM components and deployed them in MTS. Managed IIS configuration and deployment. Intranet services include employee profiles, library resources, development resources and document management through ADO's Index Service provider. Made extensive use of DHTML client scripting in JScript to enhance usability.
  • Call Center Real Time Reports
    A web-based real-time reporting tool for CosmoCom Call Center using ASP, XML, XSLT, DHTML and ISAPI technology. Client app running in Internet Explorer utilized the Microsoft XMLDocument components for dynamically polling the server for updates and rendering the resulting XML both through XSL transformations and business logic in JavaScript using the XMLDocument object. Server-side reporting logic in ASAPI module received real-time call center data via MSMQ.
  • Account Management Exchange and ROAM
    Remediation and redesign of two existing customer-facing applications from Netscape Application Server to ASP 3.0, ADO and SQL Server 7 for the Bernard Hodes Group, an ad agency specializing in recruitment advertising. Provided best practice analysis and documentation. Provided consultation on configuration of IIS servers and SQL Servers for establishing distinct development, staging and production environments. Developed scripts for converting existing SQL Server 6.5 databases to version 7.0. Developed complex workflows and full transaction integrity and auditing. Transaction history could be reviewed and rolled back at anytime. Used CDO to handle email notifications at steps along the workflow process. Significantly reduced the size of code base and database redundancy. Doubled performance capacity of both apps.
  • Impact.com
    An extensive prototype demonstrating the conversion of a mainframe help-desk application to a web-based solution for the Allen Systems Group utilizing Microsoft DNA including ASP 2.0, SQL Server and ADO. Server-side logic was implemented in VBScript; client-side scripting was developed in JScript. Designed as a portal application to be hosted by an ASP, the application accommodated customization for specific customers, including web-based tools for altering database schema (with ADOX and TSQL) and dynamically including new fields in the user interface. Provided ability to customize workflow for handling and tracking help-desk requests.
  • SecureScope
    A state-of-the-art 3D visualization tool for analyzing network security data utilizing Java, CORBA and VRML. Developed database for storing network security data with over 100 tables. Developed tools for dynamically reading schema from SQL Server 6.5 and Access the auto-generating java code for CORBA objects mapping to database entities. Utilized Rational Rose for maintaining class diagrams. Utilized Erwin for managing database schema.

VICE PRESIDENT / PRODUCT ARCHITECT
Vuepoint Corporation, 1996 to 1998

http://www.vuepoint.com

Vuepoint is a software development company specializing in Electronic Performance Support Systems (EPSS) to assist corporations in training individuals on the job, at their workstations. The company's product, Performance Learning System (PLS), integrates knowledge assessment tools, interactive training modules, searchable library documents, and communication tools such as multi-room chat and message board systems.

  • Directed PLS from the conceptual stage as a multi-tier web-based application. The client portion of the application was built with Java using Netscape IFC classes (a precursor to Swing). Back end system was built using ASP, MS Access and eventually SQL Server.
  • Designed a database-driven content management system with authoring tools using both MS Access and SQL Server 6.5. Directed the development of content authoring tools in VB 5.0.
  • Designed and developed a web-based administration application for PLS to manage user accounts and report on scoring and usage.
  • Directed art and design of the user interface, in addition to course content.
  • Hired and managed a team of 10 programmers and outside consultants.
  • Implemented systems for source code management and version control.
  • Developed several designs for the Vuepoint website.

PRODUCTION MANAGER / ART DIRECTOR
Dolphin Software, Inc., 1996

Dolphin Software was a startup Internet Advertising agency providing web design and marketing services.

  • Oversaw all web and multimedia production including the NY Giants 1986 Superbowl Reunion and the Market Central Investment Newsletter sites.
  • Developed database-driven content including product catalogs using MS Access.
  • Designed the company logo and promotional materials.

COMPUTER CONSULTANT / WEBMASTER
Spring Lake Associates 1995 to 1996

A computer consulting firm providing sales and service for custom hardware and software solutions, including network design, database programming, and training for private and corporate clients.

  • Developed an MS Access 2.0 database for a large insurance company.
  • Developed analysis applications using MS Excel.
  • Provided training to corporations on business applications.
  • Developed hardware solutions for customers.

GENERAL PARTNER / ARCHITECT
Richard P. Donohoe Architects, 1982 to 1995

Donohoe Architects was a traditional architectural design firm specializing in custom residences, multi-family housing, historic renovations, and commercial projects. Initiated partnership with firm principals in 1991.

  • Acted as lead designer and job captain on major projects.
  • Prepared construction documents and specifications.
  • Developed 3D computer models for photo-realistic renderings and fly-thrus.
  • Prepared construction estimates and reviewed bids from contractors.
  • Prepared and negotiated contracts with clients & contractors.
  • Reviewed construction on site.
  • Computerized the firm's bookkeeping and billing.

DESIGN PARTNER
Timber Lake Communications, 1993 to 1995

Timber Lake Communications was a part-time design agency formed with a partner outside of Donohoe Architects. Specialized in providing quality graphic design for small businesses and non-profit organizations.

certifications

Microsoft Certified Applications Developer (MCAD) - 2002

  • 70-305 - Developing Web Applications with Microsoft VB .NET and Visual Studio .NET
  • 70-310 - Developing XML Web Services and Server Components with Microsoft VB .NET

Microsoft Certified Solutions Developer (MCSD) 2001 - MCP ID: 2344558

  • 70-100 - Analyzing Requirements and Defining Solution Architectures
  • 70-176 - Designing and Implementing Desktop Applications with VB 6.0
  • 70-175 - Designing and Implementing Distributed Apps with VB 6.0
  • 70-229 - Designing and Implementing Databases with SQL Server 2000

Sun Certified Java Programmer (SCJP) - 2001

  • 310-025 - Sun Certified Programmer for the Java 2 Platform

education

Bachelor of Architecture

  • New York Institute of Technology 1983-87 - Graduated Magna Cum Laude
  • Syracuse University 1981-83

publications

Articles

Book

Contributed an extended outline and 10 chapters for a collaborative book, "ASP 3.0: The Complete Reference for Osborne-McGraw-Hill. Project was cancelled due to problems finding other contributors. My contributions for the book can be viewed on my website.

(C) copyright 2003 - Wayne Plourde