Experience

Point Blue Conservation Science

• United States
• Research
• 100 - 200 Employee

• Technical Product Manager, Ecoinformatics

  • Mar 2022 - Present



American AgCredit

• United States
• Financial Services
• 700 & Above Employee

• Senior Business Intelligence / SQL Programmer

  • May 2015 - Mar 2022

  BI/SQL Developer May 2015 – January 2020; Senior January 2020 – present • Developed code for a system of 25 databases supporting an Operational Data Store (ODS) and a Data Warehouse (DW). • Established deployment protocol and use of source control for database code. • Documented procedures, processes, and troubleshooting guides in Wikis. • Maintained and improves an in-house ETL codebase to load data from APIs, linked servers, flat files, and other SQL databases into the ODS and DW. • Automated code merges, code deployments, and environment refreshes, resulting in an 80% reduction in deployment prep and execution time. • Coordinated provisioning, testing, and cutover of roughly 20 new SQL 2019 servers. • Coordinated and implemented conversion of ETL process and database architecture to an API-centric framework. • Coordinated implementation of CI/CD practices for our database systems. • Coordinated transition of production support from the old operations team to the product team, including training, documentation, and system configuration updates to modify notifications and system access. • Led and participated in the Senior Developer Community of Practice (CoP). Lead of Software Development, July 2020-July 2021 • Managed a team of developers, assisting with career planning and addressing performance issues. • Collaborated with department leadership to maintain a high-performing Development CoP, set vision and goals and planned new job families and classifications. BI/SQL Team Lead, American AgCredit, September 2017 - January 2020 • Coordinated day-to-day workload and on-call coverage of SQL Development team. • Tracked critical issues and communicated with stakeholders. • Participated in a company-sponsored IT Leadership training series. • Participated in a pilot IT Mentorship program. Show less



Sonoma Technology, Inc.

• United States
• Environmental Services
• 1 - 100 Employee

• Project Manager/Meteorologist

  • Jun 2001 - May 2015

  Meteorologist, Sonoma Technology, June 2001-May 2015 Database Analyst • Technical lead for the Data Management Software (DMS), a SQL Server-based software package for managing, quality assuring, and analyzing real-time air quality data. Responsibilities included: o Designing and implementing new database functions o Deploying database upgrades to domestic and international client servers o Leading user interface and database administrator training with clients o Acting as product owner in agile development cycles • Maintained a variety of SQL Server databases for many different projects, ranging in complexity and size up to a billion records. • Built and maintained functions in a PostGreSQL database that ingested real-time weather data for display on an interactive website. • Wrote SQL queries to fulfill complex data requests from database stakeholders • Managed data flow for field projects, ensuring data integrity from collection at the instruments through final reporting. • Assisted with conversion of U.S. EPA’s AirNow program from an Oracle database system to a SQL Server system. Training Coordinator • Led in-person training for DMS users and database administrators in several cities in the U.S., Mexico, and China. • Co-developed and taught numerous training courses on air quality forecasting for the U.S. EPA and the WMO. Air Quality Forecasting and Analysis • Developed air quality forecasting tools for cities across the U.S. and internationally. • Managed and maintained SQL database systems that automatically ran these forecast tools and published the results to a website. • Produced daily air quality forecasts for several regions across the U.S. Project Management • Served as project manager on a variety of projects, with budgets ranging from roughly $7,000 to $200,000. • Wrote project plans, tracked budgets, ensured timely project execution, authored project presentations and reports, and communicated with clients and stakeholders as needed. Show less



Santa Rosa Junior College

• United States
• Higher Education
• 700 & Above Employee

• Adjunct Meteorology Instructor

  • Aug 2005 - Dec 2010

  Instructor for the introductory meteorology lecture and lab courses at SRJC. Instructor for the introductory meteorology lecture and lab courses at SRJC.