When you have a challenge, it's best to call upon an expert!
I would love to talk with you about your database needs. I have worked in database design, Storage Area Networks. integration. implementation and security, logging.
What are my greatest victories?
A) Developing a reporting suite for the National Association of Realtors. This is easily the most elegant solution I have ever coded. Profit and Loss statements, balance sheets and projected growth rates for commercial real estate properties that allowed NAR to formulate an estimate of what a real estate property is worth.
B) When I was working for an Analytics company about ten years back, I developed a solution called Tieback that would allow us to easily audit data across multiple levels. I don’t know how normal people compare summary queries between an operational data store, a data mart, an Olap Database, mining. I quickly built a solution that made it simple to compare and contrast query results across different database engines. There is a certain bit of magic to storing connection strings in a relational database and then writing .Net console applications to automate the comparison and storage of results from Sql to SSAS to data mining. Send me an email if there is more than a five percent difference between these two databases.
C) Creating a prototype for calculating an estimate of ‘how much would it cost to get my roof replaced?’. Our software was running in an offline manner in work stations in every Home Depot store Nationwide. How many people deal with terabytes of pricing and inventory information throughout Home Depot stores Nationwide?
D) My favorite role of all time? Working in Corporate Security for Microsoft and I was given a simple edict. ‘Make everything ten times faster’. When was the last time that anyone used ten terabytes of logging information on a Pentium 3 server? When I started every query took about one hour to complete. Within about sixty days, I had written screen scraping utilities to help automate the analysis of whole categories of traffic from every computer in use at Microsoft Worldwide? Isa Server used to be one of my favorite tools. Working in an antivirus capacity allowed me to build key infrastructure that would help Microsoft minimize risks throughout dozens of different areas?
Aaron has saved Microsoft millions of dollars in bandwidth alone.