About Kate

Career Overview

Self-motivated database professional with two decades of experience crafting custom solutions on the Microsoft platform across various industries. Extensive knowledge of SQL Server Reporting Services and advanced SQL development. Skilled in SSIS and crafting ETL Frameworks using BIML. Highly proficient in requirements gathering and customer communications from end-users to C-Level executives. Microsoft Certified Technology Specialist in SQL Server Database Development. Certified Biml Hero as of April 2017.

Qualifications

  • Biml Hero certified in April 2017
  • Microsoft Certified Technology Specialist in SQL Server Development
  • Microsoft Reporting Services & Integration Services
  • Microsoft programming and design skills
  • Power BI
  • TSQL expert
  • SQL Server 2000 thru 2017
  • Crystal Reports
  • Infor Visual Manufacturing and Quality
  • Microsoft Office Automation (VBA, Access, Word, Excel)
  • Excellent problem solving skills
  • Customer needs assessment
  • Effective communications
  • Sarbanes-Oxley compliance

Experience

Exemplar Analytics

Lead Architect

December 2015 – Present

  • Responsible for the creation and maintenance of a fully customized, metadata-driven, ETL framework using Biml
  • Provide research and development on various technologies
  • Backend system architecture for new and existing projects, specifically involved in systems integrations

Grass Williams Enterprises, Inc.

President and SQL Developer

June 2012 – December 2018

  • Provide SQL consultant services to numerous manufacturers, focusing on custom ERP reporting using SQL Services Reporting Services
  • Manage back office operations for IT Consulting firm specializing in internet marketing and database solutions

Aviation Communication & Surveillance Systems

Phoenix, AZ

Sr. Programmer Analyst

Jan 2002 – Aug 2014

  • Implemented over 300 custom reports and applications to support end users and executives in a manufacturing environment
  • Provided administration and support of Infor Visual Manufacturing & Quality
  • Supported legacy applications written in multiple languages by various developers
  • Integrated new and existing in house and third party application systems with Infor Visual Manufacturing
  • Managed multiple major ERP System upgrades with project cycles spanning more than six months in duration
  • Created procedures to ensure compliance with Sarbanes-Oxley regulations
  • Provided mission critical support on an on-call 24×7 basis

DriveTime

Phoenix, AZ

Lead CRM Developer

May 2000-Dec 2001

  • Designed and implemented robust system of customizations to SalesLogix CRM system to support a new department within the company
  • Led a team in providing technical support to customers and internal users

New Horizons

Tucson, AZ

Instructor

Sept 1999 – May 2000

  • Instructed classes in Microsoft Office and QuickBooks
  • Assisted in curriculum development

University of Advancing Computer Technology

Tempe, AZ

Instructor

Aug 1998 – Aug 1999

  • Instructed courses in Programming Concepts and College Algebra
  • Co-taught courses in Database Theory

Education

Virginia Tech

Bachelors of Science, Sociology

1995-1997

  • Minor in Political Science
  • Graduated cum laude