The Latest Project Highlights

FeaturePics.com – a stock photography website with an inventory of high quality images where image users can license images for specific uses.

I have developed and maintained www.featurepics.com for the past six years including ASP.Net development, complex Sql Server programming, and data analysis to produce practical solutions for e-commerce problems.

  • Database: ~250 tables and ~850 stored procedures and views
  • Business classes: ~100, number of ASP pages - thousands
  • Google Crawl Stats: Total indexed: ~2,255,038, Average Pages crawled per day - 70,000, Time spent downloading a page (in milliseconds) average - 74 milliseconds
  • 74 milliseconds time spent downloading a page - it is a very good number!
FeaturePics.com responsive design version

FeaturePics stat:

FeaturePics google stat
FeaturePics PageSpeed Insights stat

Main parts and challenges of FeaturePics include:


Image search
(Index server has been used for search purposes), improving search results based on analysis of contributors descriptions/customer preferences, speeding search results based on technical solutions.
Portfolio management
Set of procedures for Contributors to manage their portfolios. Challenge – to minimize efforts when submitting images (submission in bulk, retrieving all needed information from exif tags, checking duplicates etc.), additional procedures for Author to promote their images on their sites and blogs
Preparing data for QuickBooks Integration
Specific transaction types such as vendors, payments, sale orders, invoices, etc
Image licensing
Purchase plans (different type of purchasing in advance), E-commerce (PayPal, credit cards, Google Wallet)
Reviewing process
Challenge - providing reviewers with such screens and procedures so they can accept as many images as possible without quality loss. Web services have been used to make suggestions regarding categories, to check cameras (exif meta tags information), submission history etc. on the fly. Have built taxonomy table used to match hash tags to image categories. Image processing (EXIF & IPTC information, resizing, watermarks etc.).
Traffic stat monitoring
to be aware of the general “SEO” situation and cutoff “suspect” activity.
Web Services
SOAP and REST API Web API2 - procedures for partners (image search, image details, image purchase, reports etc)
Administrative part of the site
Image reviewing, product image monitoring, payment processing, reporting, SSIA, SSAS, daily DB tasks, payment fraud protection procedures, product description analysis.

FeaturePics Timeline 2006-2015