Project Type: Data Warehouse, Business Intelligence

Summary: Responsible for the management, data architecture, data integration and the design, development and implementation of the enterprise data warehouse platform.

Technology: Informatica PowerCenter 8.1/9.1, Autosys, SQL Server 2005-2008, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Microsoft Office, Visio Architect, SharePoint

Project Type: Data Warehouse, Business Intelligence

Summary: Developed prototype data warehouse and reporting system based on restaurant sales data consisting of over 125 million records for national sales account manager.

Technology: Microsoft SQL Server 2005, SQL Server Integration Services, SQL Server Reporting Services

Project Type: Data Warehousing, Business Intelligence

Summary: Worked with sales & marketing department to design, develop and implement a sales & marketing prototype web based Business Intelligence platform.

Technology: MS SQL Server 2000, SQL Server DTS, SQL Server Reporting Services, Windows

Project Type: Web Services, Web Scraping, Data Extraction, Data Cleansing

Summary: Developing proto-type JSON/RESTful web services in Ruby on Rails to facilitate data loads from suppliers into application database and to allow external customers access to sales data. Developed PHP/cURL scripts to scrape websites to gather information, analyze and categorize potential customer leads. Wrote batch applications to extract chemical data from Technical Data Sheets (TDS) in HTML and PDF formats. Wrote scripts to scrape web sites to gather information and analyze data of potential customers.

Technology: Web Services, Ruby on Rails, JSON, RESTful, PHP, cURL, Java SDK 1.6, PHP, cURL, MS Excel, PDF, XML, HTML

Project Type: Database Development, Web Scraping, Data Cleansing & Data Integration

Summary: Developed web scraping scripts to extract NBA, NCAA, D-League and European team, player and coach data and stats from multiple reference web sites. Integrated data into database and between databases. Enhanced existing mySQL database structure and assisted in design of overall database schema for Operational Data Store and Data Warehouse.

Technology: mySQL, PHP, cURL, Unix Shell Scripts

Project Type: e-Commerce, Web Design & Development, SEO, Database Programming, Data Integration, Data Migration, Data Cleansing

Summary: Designed and built a customized e-commerce site to include over 25,000 educational products.  Product inventory and prices on site are updated with nightly data feeds.  Developed data feeds to Google Products and Amazon Store.

Technology: Interpsire Shopping Cart 4.0, PHP, MySQL, Unix Shell Scripts, CSS, HTML, SSL, LivePerson, Authorize.net, Google Checkout, Paypal and other web development tools.

Project Type: e-Commerce, Pay Per Click Management, Data Integration, Data Migration, Data Cleansing, Web Scraping

Summary: Developed batch applications to build data files consisting of over 25,000 products used to generate custom PPC campaigns, load into Google® Products (Froogle), build an eBay® store, build an Amazon® store. Setup and manage customized Pay Per Click campaigns.  Increased monthly revenue of bike shop by 300% !

Technology: Java SDK 1.6, MS Excel, eBay Turbo Lister2, HTML, Windows