Database Systems Manager / Gis Development
Santa Rosa, Ca
Designed, developed and supported numerous database and reporting systems throughout company. Responsible for defining user requirements, data modeling, reporting and user interface to data. Maintained enterprise data standards while also acting as technical resource to end-users in access, use and development of reporting systems. Reviewed, evaluated and provided automation related to data collection and exchange with enterprise reporting systems. Prepared extensive analysis and presentational materials for ownership, Board of Directors, external groups as well as Sales and Marketing. Built and supported systems for the following data sets: shipments, depletions, DA’s, pricing, IRI/Nielsen, BDN, production, vineyard attributes, competitive wine data and acclaim. GIS Development - Responsible for introduction and development of GIS mapping tools. Developed mapping application for use in general analysis, targeted sales efforts, marketing, vineyard development, BATF compliance, water rights and marketing, promotional materials. Developed 3D models, geocoding, ortho-rectified aerial photos, incorporated CAD drawing and used Spatial Analyst software for hydrological, soil and overlap analysis studies. Linked GIS systems to other company data sources for graphical display of sales information and other variables. Used overlap analysis to data mine census/income information for direct to consumer sales.