Archive

Posts Tagged ‘MySQL’

Boomtown Internet Group

August 3rd, 2009 Comments off
  • Data integration. Integerated several commercial data sources into MSSQL server. Wrote data normalization schemes for each data source and built a custom search engine for new data.
  • Authorize.net and Squirrel Cart ARB integration.
  • Intrusion detection and resolution
  • Virtual Private Server architecture, development and troubleshooting
  • Website architecture conversions (ASP to PHP)
  • Linux DNS and Mail server configuration/troubleshooting
  • Apache and IIS setup.
  • PHP and Classic ASP Software Development
  • MSSQL Database installation (VPS) and management
  • Legacy System Maintenance and troubleshooting (OsCommerce and proprietary ASP frameworks)

“When our web development company has a difficult project that requires really technical expertise, we pick up the phone and call Jeremy Silva. He is a master programmer and knows the intricate ins and outs of servers and networks. He is able to estimate and accurately code all manner of outrageous programming requests and makes very creative suggestions which ultimately save our customers time and money. He is the first person I go to when I have a tricky programming problem, and he always gets the job done in a creative way, under budget and on time. I’d recommend Jeremy to anyone!” — Susan McCrossin

Tags: , , , , , , , , , , , , , , , , , , ,

The National Weather Station

August 3rd, 2009 Comments off
Working with meteorologists, Mr. Silva designed and developed a meteorology forecasting model capable of delivering short-term and extended reports to customers of The National Weather Station all across the United States. Mr. Silva engineered a deliver mechanism that would deliver the weather reports via email, web site, fax, or test message automatically. This single model was extended to calculate snow making conditions for ski operators, but using a proprietary algorithm based on summit / base heights and averaged weather station data. The data was used to allow ski operators to forecast ideal snow-making conditions throughout the entire winter season. The model was also adapted to calculate ideal farm spraying and drying conditions for farms across the country. The design was extremely flexible and allowed the client to run it from older equipment that ran on any type of operating system.
Tags: , , , , ,

Ken Gordon – DERC Framework Agent

August 3rd, 2009 Comments off

Created a personalized Robot Agent, based on Silva Tech’s flexible data extraction, reporting and crawling framework (DERC Framework, a Silva Tech Solutions framework) that has saved Mr. Gordon countless hours of monitoring his target system himself and responding to the monotonous events. The agent was setup on a very specific schedule, authenticated into a third party application system, searched for a very specific criteria and automatically submitted data. The agent monitored and reacted differently to a certain set of resulting events that were returned from the application system. The Crawl Agent would then email Mr. Gordon and shut itself down. Mr. Gordon could easily control his personalized DERC Framework agent, from a custom built secure web interface. The DERC Framework is a very flexible proprietary data extraction, reporting and crawling framework that Mr. Silva has been building upon and refining for five years.

Tags: , , , , ,

Everything Freight LLC

August 3rd, 2009 Comments off

Silva Tech Solutions was the complete technology consultant on the “over-the-road” based freight start-up company called EverythingFreight LLC. We managed and provided all of the IT services, from building a custom “Smarty Template” freight auction website to building a highly complicated system of web crawling agents that continuously crawled and updated data from the Department of Transportation. We collected and maintained the records on one of the nations leading databases of freight and freight broker information.

The system was built on a very tight budget and was specially crafted to minimize the cost of server hosting and bandwidth. The system was segmented in two tiers, a subscription website system with a minimal database architecture and the corporate data-center with the full freight database and associated statistical systems. The data-center system would upload refreshed data to the public side only as requested. This ensured that the data-center’s core product was very secure, and any (unlikely) breach of the public website would yield very little data loss.

Silva Tech Solution’s data crawlers would regularly monitor and notify a customer, if their record at the Department of Transportation had changed. The intricate data crawlers also monitored the Department of Transportation site for newer registered companies and then provided the data to enterprise customers who where in the freight broker or freight sales industries. Some of the custom data feed reports were based on a circular radius around the customer’s zip-code, ensuring that the customer would only receive sales leads within their geographic area.

Silva Tech Solutions created a massive array of in memory statistical models that could quickly calculate industry wide accident and safety statistics for like sized freight companies. The system would automatically detect changed company data in the master database and reload only the affected nodes back into the memory model. The models were tied to a custom graphing and reporting system, that was able to trend growth rates or trends of freight company and broker safety issues throughout the entire US.

Custom PDF reports containing all of the available data on a freight company were automatically generated and stored at the data center. Customers could then search the basic subscription front end database, and then request full reports on any freight broker or hauler from the main segmented data-center database.

Silva Tech Solutions was also responsible for the development of all corporate branding graphics and logos, as well as building the corporate website. We monitored all of the network traffic and were responsible for all SEO efforts to boost traffic and revenue.
Tags: , , , , , , , , , , , , , , , , , ,

Zip Code Development Framework

August 2nd, 2009 Comments off

A full zipcode search framework to minimize time for zip code range searches. Designed and built a full development framework that is ready to be integrated into any PHP web, Microsoft.NET, or Java application.

  • Cached system to drastically speed up zip code area searches
  • Complete samples of system code for C#, PHP and Java.
  • Research and Development already done.
  • Package includes a Census 2000 MySQL database, pre-cached for several ranges.
  • No license restrictions, buy once, integrate everywhere.
  • Software Integration contracts available.
Tags: , , , , ,