RETAIL

Sigma Faucet

A product and showroom website for American Faucet and Coatings Corporation, supporting detailed product discovery, content management, customer contact, and catalog operations.

Sigma Faucet product website
01
Handles and Finishes

Implemented jQuery imgPreview rollovers so shoppers could inspect enlarged handle and finish images by hovering over thumbnails without clicks, loading, or page refreshes.

02
Content Management System

Integrated CKEditor into the administrator portal, giving site owners a familiar WYSIWYG editing experience for publishing and maintaining website content.

03
Contact Form

Built a secure, validated contact form using jQuery Form and Validate plugins, with AJAX submission and duplicate-submission prevention.

04
Showroom Locator

Created an interactive U.S. image map for finding showrooms by state, loading database-backed showroom results asynchronously into a Thickbox modal.

05
Product Images

Implemented thumbnail-to-large product image viewing with Thickbox and a focused lightbox treatment that highlighted high-quality product photography.

06
Product Data ETL

Developed an SSIS process that modeled the product category hierarchy and imported thousands of Excel catalog records, including images, PDF specifications, SKUs, and product descriptions, into SQL Server.

Technology stack

Product content and commerce

ASP
SQL Server
SSIS
jQuery
AJAX
CKEditor
PDF
Photoshop
Back to portfolio

© 2026 Amar Kota. All Rights Reserved.