Kevin Havice Email & Phone Number

Bend, Or, Us

San Diego, Ca, Us

New York, Ny, Us

• Manage a team of 8+ other data engineers, BI developers and data scientists. Plus, coordinate and lead a cross-functional team of 20+ analysts and data stewards ("matrixed" team).• Product owner (business analysis) – own the global/enterprise-wide business intelligence function; speak with business stakeholders/users across the organization; understand their needs; document and estimate requirements (user stories); and coordinate with the "BI steering committee" to prioritize development----> Tools: Jira• Data modeling – model logical and physical data structures for reporting and analytics (data warehouse/data marts)• Data integration – extract, clean, transform, integrate and move data from multiple, heterogeneous sources into an enterprise data warehouse----> Tools: Kimball dimensional modeling techniques; Amazon Redshift; Matillion; Fivetran; Funnel; custom SQL queries; Python; cloud service APIs; Microsoft Power Query ("M")----> Data sources include: cloud-based databases (PostgreSQL, MongoDB and MySQL on Amazon RDS); on-premise databases (SQL Server); cloud services (Salesforce.com, Workday, SurveyMonkey); flat files• Build and maintain BI platform – administer, maintain and continually develop Microsoft Power BI tenant with Premium Capacity; design and build reports/dashboards; train power users and end users; embed reports/dashboards into internal- and client-facing applications----> Tools: Microsoft Power BI (Desktop, Service, Premium); DAX; Microsoft SharePoint Online; Power BI Embedded/Microsoft Azure

New York, Ny, Us

Essentially the same as above, except during these years I did not manage any direct reports. (Though during this time, I *did* coordinate and lead a team of BI Analysts, in "matrix" fashion.)Single-handedly migrated the company's initial QlikView implementation to a modern BI stack, with a data lake layer in AWS; a dimensional data warehouse layer (in Amazon Redshift); and Power BI.

New York, Ny, Us

• Analyzed margins, productivity and other KPIs, and presented to senior leadership• Built custom reports using BI platform (QlikView), Excel, custom SQL queries and other tools; and delivered analysis and decision support to managers at all levels, across North America• Executed and improved processes for budgeting & forecasting; financial planning & analysis; and business intelligence/reporting• Led the selection, implementation and ongoing development of new EPM/CPM software (Host Analytics) to support budgeting, forecasting, consolidations and financial reporting processes• Initiated a project to design and build an enterprise data warehouse

Portland, Oregon, Us

• Member of agile development project team to replace SAP BusinessObjects business intelligence platform with Microsoft SQL BI ----> Elicited requirements and wrote user stories ----> Did prioritization with product owner and solution architect ----> Modeled enterprise data ----> Wrote ETL specifications ----> Provided change management and training• Validated and managed incoming reporting requirements, as well as data requirements for the ongoing maintenance and development of data warehouse and reporting systems• Produced and published reports using SQL Server Reporting Services (SSRS) Report Designer & Report Builder; Excel 2010 & 2013; Excel Services for SharePoint; Power View; PowerPivot; and SharePoint 2010 & 2013• Designed and built SQL Server Analysis Services (SSAS) cubes, both multidimensional and tabular• Used DAX and MDX languages to configure cubes and reports• Produced and published reports using SAP BusinessObjects Web Intelligence

Portland, Oregon, Us

• Provided data analysis and reporting in support of commercial sector energy efficiency programs, using SAP BusinessObjects business intelligence tools, Microsoft Reporting Services (SSRS) and SQL• Developed data and managed data quality for energy efficiency measures and program activity• Trained and supported commercial sector team on systems and business processes• Analyzed and designed improvements to program processes• Coordinated and participated in program audits• Supported program planning/budgeting with historical reporting and predictive analytics• Contributed to designing and building new systems for data collection, entry, use and destruction• Supported Energy Trust's New Buildings program, a 2013 ACEEE Exemplary Energy Efficiency Program

Portland, Oregon, Us

• Coordinated the work of contractors and consultants• Produced and managed concurrent project schedules and plans• Designed and wrote project management procedures for a 15-person cross-functional team• Developed and managed a complex SharePoint site• Designed and managed a document repository for hundreds of active project documents• Produced weekly project status reports for executive team• Processed invoices; tracked and analyzed project budget; detected and corrected invoice issues• Coordinated and led team meetings

Spokane, Wa, Us

• Provided coordination and data entry for a high-volume energy-efficient HVAC and appliance incentive program• Completed project QA and approvals• Reported bugs/issues related to the program tracking application, and collaborated with IT on resolutions• Worked directly with multifamily customers to efficiently process large, complex rebate applications• Helped prepare the program for a successful audit by the utility client

• Created a strategic plan for marketing a development consisting of net-zero energy homes in the Portland metropolitan area• Provided planning and knowledge of logistics and international business operations for an import/export start-up• Developed marketing strategies for an urban organic farming business

• Led the company's branding, marketing strategies and creative efforts.• Initiated and led a project to implement a new CRM system for tracking leads, customers and sales; generated and reported new data for marketing and forecasting• Trained users on new IT systems, including CRM, document management and email• Initiated and led a project to improve business processes around the design, production and delivery of custom furniture orders• Initiated and led a project to measure and report organization-wide direct and indirect greenhouse gas emissions; empowered operations group to reduce GHG intensity by 15 percent

San Francisco, Ca, Us

• Produced a business conference and managed other events• Contributed to the design and production of marketing and public relations pieces• Provided administrative support to the business development function

Portland, Or, Us

• Wrote and updated content, including web pages and blog posts• Ensured quality, timeliness and availability of online marketing materials• Designed and built a collaboration/content management/social media website for student cohorts

Bachelor Of Arts, Computer Science

Masters, International Management

Education record

Microsoft Analytics/Bi Stack

Certificate, Business Analysis