![]() |
Major Projects |
Database, Desktop and Web Applications
Microsoft
Metrics Integrity project
Microsoft Intranet Dev
project and ASP code sample
SSCC Distance Learning
Program
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 Certification Status
Community Service projects and Awards
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
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
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
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
Data Archiving project
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.
EPA/OSHA Compliance
Automation project
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
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
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.
Warehouse Prototype
Locator
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
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
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
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."
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.
I was also a featured writer
in Portland’s Blue Stocking, with my critique of NW performance
and visual artists exploring the Barbie phenomenon.
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."
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."