DATABASE

Database for not-for-profit

Designed and developed a donor database with over 10 years of data. Provided analysis of donor trends and demographics.

Database for small solar company

Developed a MYSQL database for sales tracking and proposals for customers. The database included an interface to add sales leads, tracking of sales process, and contacts with customers, and creation of proposals with different variables. The proposals had complex energy and return on investment calculations based on the configurations.

Data Warehouse for medium size bank

Evaluated and tested the data quality and structure of new data warehouse. Created Wikipedia-like reference on the company internet to solve the issue of different areas using different definitions and calculations for reporting metrics. It included searchable reports, the report description and purpose, and code used to create the report. The reference had business definitions, business calculations, code library, and a data dictionary for the data warehouse. The data dictionary defined over 9,000 fields and documented any data issues or caveats.

Data Warehouse for major publisher

Designed tests and automated the plans to check data quality and structure of new data warehouse.

Customer database for small marketing firm

Designed and developed a custom database for a marketing firm which specializes in ethnic marketing. The database tracked various surveys and events for analysis. In addition, the database a tracking system for managing names for list management and exchange process.