<p align="center"> <H3><b>sdwebpro</b> offers affordable web presence design, and IT infrastructure and application development services to small business in San Diego. Complete e-commerce packages available, including domain name registration, hosting, site development, search engine optimization, and database design.</p> <p align="center"> <b>sdwebpro</b> is Microsoft certified and expert with web site design, business solutions, Microsoft application development, e-commerce, online catalogs, database design, and project management. </p> <p align="center"> <b>sdwebpro</b> can turn your static website into a search engine optimized, customer magnet. </p> <p align="center"> Not Frames enabled? You can still navigate this site using our Table of Contents. <br><a href="./navbar.htm">Click here to find out more.</a></p>
Web Site Design and Business IT Developer San Diego
About Us Client List Major Projects Letters of Reference
Contact the professionals at SDWEBPRO


Major Projects



Database, Desktop and Web Applications

Microsoft Metrics Integrity project

Microsoft Intranet Dev project and ASP code sample

SSCC Distance Learning Program

ACC Data Archiving project

EPA/OSHA Compliance Automation project

hyperart:one of the first internet art galleries

Art Gallery Customer and Accounting POS system

Continental Mills (Krusteaz) Warehouse Locator

 

Educational Goals and Certifications

 

Community Service Projects and Awards

 

Writing Samples

Technical Writing and Editing

Art Criticism

Ed Op and Commentaries

Poetry

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Database and Web Applications

 

 

This Site

Top

Web Weaver HTML editor, Agile HTML editor, Microsoft Office, WS_FTP, JPEG Compression Wizard, Gumball Website Tracker and FastStats 2.69

     This site was built using tools and images that were downloaded from the public domain of the internet.  The JPEG compression tool worked very well, especially with the scanned letters of reference, cutting the amount of time they take to show by about two/thirds.  Gumball Tracker is an invisible counter that grabs a log every time someone comes to this site.  FastStats is the software needed to read these logs. 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Microsoft World Wide Operations

Metrics Integrity and Intranet Scorecard project

Top

SQL Server 7, Microsoft project, Access and Excel VBA pivot table and chart drilldowns:

As part of the Information Management team, I documented agreements as to World Wide Metrics definitions, utilized MS project to establish and maintain schedule, and created Visual Basic routines to display data.

     My other duties at Microsoft included: using a Siebel service manager to provide primary tier1 help desk support for the Microsoft Order Entry Tool.

 

Click here to view more information and recommendation from Joni Farley, IMG Manager, Microsoft.  

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Microsoft World Wide Operations

MOET Contact List Intranet Update Tool

Top

Visual Interdev, ASP2, VBScript, HTML SQL and Access2000:

As part of my support of the Microsoft Order Entry Tool, I created a database and database maintenance tool for the Microsoft intranet.  Click here to view my complete source code for this project.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

South Seattle Community College

Distance Learning Program

Top

Access with Excel input routines from legacy mainframe:

     During a two-month contract, I designed and implemented an Access dbms for the Distance Learning Program.  It quarterly inputs all course and student data from three separate legacy systems.  For more information and recommendation, please contact Dennis Colgan, Director, Distance Learning Program, SSCC  (206) 764-7930  

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Alaskan Copper Companies

Data Archiving project

Top

Access and Access forms with Watermark imaging and input routines:

Between 1995 and 1998 I served as dba for an Access / Watermark imaging archiving database.  As such, I improved archiving procedural efficiency, throughput and the amount of data handled by the system by adding a scanning with ADF and a CD burner and tower to the database.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Alaskan Copper Companies

EPA/OSHA Compliance Automation project

Top

Access and Access forms with Excel VBA input routines:

As part of my duties as head MRO Buyer, I designed and implemented a procedure to track, index and distribute Material Safety Data Sheets (MSDS) and their respective chemical products in compliance with OSHA.  In addition, using straightforward forms, clerks input percentages of hazardous chemicals shown on the MSDS and the unique MSDS number associated with each product and size.  At the end of the year, purchasing history is input, resulting in accurate hazardous chemical consumption counts, as required annually by the EPA.  For more information and recommendation, please contact Patricia Cecchini, Buyer, ACC  (206) 382-8223  

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

hyperart:  one of the first internet art galleries

Mosaic/Netscape, Adobe, Corel Draw

Top

     I started planning hyperart in 1992.  It was a wonderful pioneering site.  Between 1993 and 1995 it featured dozens of NW artists, thumb-nailed catalogues that opened to download full screen-sized images of each piece, with descriptive text.  It was one of the first sites to use jpegs, counters, and online ordering. 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Art Gallery Customer and Accounting POS system

Microsoft Access, Word and Excel macros

Top

     Galleries have unique information management requirements.  For one thing, an accurate and extensive customer mailing list is crucial for a gallery.  Lists of artists’ addresses and publications’ addresses for frequent press releases are also essential.  Most galleries are not true retail but count their portion of a sale as a commission for professional services.  Shrink wrapped point of sale (POS) software does not capture the information necessary to perform all the transactions required for a gallery, like updating the artist’s agreement and generating a check.  So I created a gallery accounting system, which also captures customer addresses and artist addresses for mailings.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Continental Mills (Krusteaz)

Warehouse Prototype Locator

Top

Excel macro programming language

     In 1992 I was part of a development team, which built a warehouse locator for use in Continental Mills largest warehouse.  The tool was used by forklift operators, who put together orders and counted inventory.  It output the shortest path through the warehouse necessary to gather the order, taking into account product age. 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Education Goals and Certification Status

 

Top

      I am actively pursuing an MCSD and recently passed the Solutions Architechture test (70-100). In this, I am specializing in Visual Basic with elective in web development. About three years ago, I passed the COMPTIA A+ certification and studied Networking Essentials. My longterm educational goals include a graduate degree in Information Management, toward which I have completed one year of study in a Masters program at Seattle Pacific University.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Community Service projects and Awards

Top

 

Planning Committee:

Pike/Pine Neighborhood Association

 

Planning Committee:

Capitol Hill Arts Orbit Art Walk

 

Entrepreneurial Artist of the Year

Friends of apt. art

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Writing and Editorial Experience

 

Top

Technical Writing and Editing

      The SDWEBPRO team includes a former Technical Editor for a scientific journal. Our people know how to put a paragraph together, and we know how to place it on a webpage for maximum impact. Three technical writing samples are included: Application Overview for Troubleshooting and Future Development (for Amazon.com 11/2000), End User Recovery of Corrupted Excel Workbooks, (for Puget Sound Energy 7/2000), and ACD "Port Pull" Project Overview (for PSE 8/2000).   Click here to see Technical Writing Samples."

 

 

 

 

 

Art Criticism

      As part of my duties as owner/manager of a local artists’ gallery, I wrote and published criticism of dozens of shows between 1991 and 1996.  In addition to these press releases and articles about NW artists, my critique of Salvador Dali’s “Tarot” was accepted by the Seattle Times. 

Barbie

      I was also a featured writer in Portland’s Blue Stocking, with my critique of NW performance and visual artists exploring the Barbie phenomenon.   Click here to see “Barbie on the Half Shell.”

 

 

 

 

Ed Op and Commentaries

      I began writing for Newspaper Ed Op columns while in college and have had several essays published in the Seattle Times, The Rocket, The Seattle Weekly and the Seattle Post Intelligencer.  My non-fiction essays have won contests in The Rocket and in local Toastmasters competitions.  Click here to see "Older Cars and Older Men: Why You Want to go with Used."

 

 

 

 

 

Poetry

Top

      I published several poems in the late 1980’s, won a couple contests, and self-published a collection called “Quantum Theory of Romance.”  Click here to see "Ode to a '64 T-Bird."