SUMMARY: 10+ years database architect and development
experience, emphasizing:
MS SQL Server 2000 and 2005
Stored Procedures/User Defined Functions (T-SQL)
Multi-Terabyte databases
Reporting Systems, SSRS
Data Warehouses, Star Schema
Marketing/Advertising program/API/SEM
Web application development
Oracle (older versions), PL/SQL
EXPERIENCE Senior Database Programmer SHOP.COM, Monterey, CA, September 2004-Present
Designed and implemented database-driven ad management, delivery,
and tracking systems for the SEM team.s ad programs. I designed these
systems from the ground up; each system involved 30-40 database tables,
25-35 stored procedures, 10-20 user defined functions, and 10-20 sql
scheduled jobs. Each system manages between 500,000 and 3,000,000 ads;
among these systems are Google.s Adwords API, Yahoo.s Search Marketing
AWS system and API system, and MSN.s AdCenter API. These systems run on
SQL Server 2000 and 2005, and use T-SQL scripts, stored procedures,
user defined functions, DTS packages, and sql jobs. (T-SQL, MS SQL
Server)
Wrote a set of T-SQL stored procedures, functions, and DTS packages
to warehouse our daily traffic and financial data, and to generate a
set of daily reports consisting of the complete breakdown of our
traffic (SEO, SEM, and natural), ad spend, ad revenue, GMS, and net
revenue figures. Many teams throughout the company as well as the
executive staff use these reports.
Provide ad-hoc queries and reports for all teams throughout the
company, pulling data from our multi-terrabyte data warehouse, using
T-SQL, SQL Server Reporting Services (SSRS), and DTS packages.
As a senior member of the database team, I mentor and provided
consultation as needed to other members of my team as well as our java
engineers.
Senior Database Web Consultant
Santa Cruz, CA, 2002-2005
University of California
Lead developer for the UC Gateways system, providing college prep
services for students throughout
California, and data maintenance and reporting services for staff
(Cold Fusion, Perl, MS SQL Server, Fusebox).
Assisted other developers with complicated SQL queries
and stored procedures, and with debugging tricky issues.
Designed CFC web service for communication between
Flash module and Cold Fusion module.
California Community College System
Ongoing maintenance and enhancements to the extensive
data warehouse, ETL, and online reporting system I designed,
used by all 113 Community Colleges in California (MS SQL Server, JSP).
Developer II Tartan Technology, Santa Cruz, CA, 1999-2002
Designed and implemented a star schema data repository with a
web-based reporting system used by all 113 California community colleges
(MS SQL Server).
Coded a complete set of database APIs for an eCommerce system,
facilitating rapid creation of java modules, thus reducing application
deployment time (Oracle PL/SQL).
Developed all database procedures and functions for an online
business directory system for use by chambers of commerce throughout
the world (Oracle PL/SQL).
Web Developer Cisco Systems, Milpitas, CA, 1998-1999
Created a web-based product management system for the worldwide
sales organization which plugged into a global network design tool,
allowing sales engineers to design networks on the fly at customer
sites (Oracle PL/SQL, Perl, CGI).
Maintained a complete set of project documentation throughout the project;
when it needed to be handed off unexpectedly, the hand off went very quickly
and smoothly.
Senior Database Web Developer Premier Consulting/SCO, Santa Cruz, CA, 1996-1998
Designed, developed, and implemented an online
hardware
compatibility guide, still in use today
and considered to be one of the most important online tools available to
SCO customers (Oracle PL/SQL).
Created a modular text system for an eCommerce system such that new
language translations could be added almost effortlessly, expanding
online sales to support non-English speaking customers
(Oracle PL/SQL, localization).
Wrote an online ordering system for certain SCO products, thus
expanding SCO’s sales venues and customer base (Oracle PL/SQL).
Wrote an online enrollment application, interfacing the company’s HR
data warehouse, reducing the paperwork and manpower costs of the former
non-electronic enrollment process (Oracle PL/SQL).
SKILLS
MS SQL Server 2000 & 2005
T-SQL, Stored procedures, UDFs
SSRS; Reporting Systems
Data Warehouses, Star Schemas
Cold Fusion
eCommerce
JavaScript
HTML
Perl
JSP
C
Fusebox
Windows, Unix
Oracle PL/SQL
EDUCATION
B.A. in Mathematics with honors, Minor in Computer Science,
University of California, Santa Cruz
Certificate in Database Systems and Concepts,
University of California, Extension Program
TECHNICAL TRAINING
Relational Database Concepts, UCSC Extension, Cupertino, CA
Relational Database Design, UCSC Extension, Cupertino, CA
Building a Data Warehouse, UCSC Extension, Cupertino, CA
Advanced SQL Techniques for Oracle & SQL Server, UCSC Extension,
Cupertino, CA
Introduction to MySQL and PHP, UCSC Extension, Cupertino, CA
Introduction to Open Database Connectivity (ODBC), UCSC Extension, Cupertino, CA
Microsoft Access Fundamentals, UCSC Extension, Cupertino, CA
Microsoft Access Intermediate, UCSC Extension, Cupertino, CA
Microsoft Access Advanced Topics, UCSC Extension, Cupertino, CA
Business Objects Intermediate Reporter, Tartan Technology, Santa Cruz, CA
Java Programming, De Anza College, Cupertino CA