Tracy Wayland

About Tracy Wayland

Equally effective in business and technical environments, my unique background bridges…

Experience

1. Reporting Manager

   First American

   Jun 2015 — Present · Sacramento, CA, US

   Responsible for design through implementation and maintenance of automated solutions to gain business insights and operational efficiencies in forecasting, budgeting, pipeline, white space, market share, commissions, and trended reporting. Serve as subject matter expert (SME) for creation of derived content and aggregation of disparate data assets. Administer relational data warehouse and develop ETL processes. Management of data quality, content, and currency. Duties include:• Design, maintain, and enhance BI infrastructure including SQL Server relational data warehouse, SQL Server Reporting Services application, ETL packages to sync data from Salesforce, and database views to allow for power user Tableau access• Build, maintain, and enhance data models, workflow packages, SSRS reports and DOMO dashboards • Partner with stakeholders to gather business requirements, perform analysis to determine best course of action, gain requirements signoff, manage and track development tasks, perform unit and/or functional testing, coordinate UAT testing, implement solution, plan rollout with the business, and communicate status updates regularly to stakeholders • Design, implement, and document automated cross-functional enterprise solutions• Identify and implement solutions solve for business pain points• Build and implement complex SQL queries to extract datasets for reports and dashboards• Build ETL processes to load disparate data from 20+ sources into BI data warehouse• Load and reconcile Oracle Accounts Receivable data to BI data warehouse• Manage scheduled data refresh and distribution of reports• Provide ad-hoc analysis and reporting as required by the business• Act as SME and Steward for BI data assets and manage data quality• Provide administrative support to database and reporting power users• Continually improve skill set to evolve as new best practices and technologies arise

Education

• Shorewood High School

  Diploma

  1984 — 1988

• Consumnes River College

  None

  1991 — 1992

• University of Phoenix

  None

  2009 — 2009