Dustin Teter Email & Phone Number

Eagle, ID, US

Denver, Colorado, US

• Work closely with RevGen clientele to perform deep dive data analysis of various systems and related data to improve data flow, business continuity, and definitive actionable results to stakeholders.
• Data warehouse design, ETL development, and data migration from various disparate systems into a singular robust reporting platform.
• Design and development of Tableau and Power BI paginated reports, and interactive dashboard implementation.
• Data visualization and story telling using data to inform stakeholders and C-Suite alike of what is working and what can be improved across their complex systems resulting in improved customer lifecycle experience.
• Design and development of internal company Survey database to collect, store, and report on survey results received back from employees, clients, and project staff.
• Using various visualization and dashboards to convey survey results back to leadership and stakeholders in a consumable, interactive, and robust ways to enable future business improvements and critical decision making.

Earth, OO

• Collaborate with stakeholders and C-Suite generate revenue KPI’s and analysis of current customer base and lifetime value as related to revenue and potential CHURN.
• Business Systems analysis, procurement, technical documentation, and implementation across the company to support daily operations ensuring accurate data collection and consumption.
• Solicit C-suite, and stakeholder input as requirement specifications to be documented and translated into development specs and onto actionable KPI metrics development.
• Perform quantitative and qualitative analyses and data modeling to translate data into actionable statistics and insights.
• Deep customer and prospect research to better understand personas of potential and future passengers.
• Design and develop standardized post-mortem methods to analyze sales and marketing initiatives quickly and efficiently.

Santa Monica, California, US

• Analyze audience data from different sources and tell a story with that data using standard market place tools such as Snowflake, BigQuery, Tableau, Google Analytics, Advanced SQL, and various dashboards.
• Provide marketing team with deep and actionable audience, creative, and marketing platform insights.
• Conduct audience research to identify key behavioral, demographic and attitudinal traits to inform the development and targeting of future marketing campaigns.
• Partner with direct response and media buying agencies to define and implement campaign measurement of integrated marketing campaigns, including TV, OOH, Digital and Social Media.
• Work closely with agencies to identify opportunities for campaign optimization to ensure everymarketing dollar is spent as efficiently as possible.
• Develop and maintain holistic campaign dashboards to identify key drivers of performance and inform future campaign activity.

Irvine, California, US

• Upgraded Excel based lead generation and tracking system to a comprehensive lead aggregation environment using MySQL, resulting in rapid revenue and company growth.
• Designed, implemented and managed a large-scale lead mining solution consisting of approximately 100 virtual machines across 10 VMware Clustered Servers. The lead mining solution was responsible for producing more than.
• Performed complex ETL processes.
• Developed an extensive lead grading algorithm based on known quality factors.
• Utilized Tableau, SQL and coordinated with offshore Ruby Developers to develop necessary company dashboards and KPI’s.
• Designed, implemented and managed on-premise FreePBX phone system, consisting of 500+ extensions across call centers in California, Egypt, Jamaica and the Philippines.

Boca Raton, Florida, US

• Designed and developed several large scale MySQL staging and production databases. Production database consisted of more than 450 million consumers and business marketing records which grew by 1 million+ records daily.
• Developed logic and scripting to automate record scrubbing of all leads to ensure legal compliance and record accuracy including Spam Trap Removal, CASS and NCOA Validation/Verification and National Do Not Call Registry.

• Analyzed and documented Screen Inc’s back-office operations to determine technical areas for improvement and introduce new technologies to solve existing issues.
• Collaborated with IT Manager and sales staff to identify the various COTS software in use at the company and provide CRM integration recommendations.
• Maintained MySQL database and new development of a custom access reporting environment used to scale and identify new business opportunities.

Redmond, Washington, US

• Provided data and analytical expertise to several teams and key stakeholders in support of the MS Live Search product.
• Identified relevant data sources across the globe and extracted necessary information to satisfy requested Ad-Hoc and KPI requirements for key departments and stakeholders.
• Designed and developed ETL processes to normalize data from several disparate data sources.
• Participated in monthly and quarterly meetings with department heads and key stakeholders to present critical findings for inquiries.

Las Vegas, Nevada, US

• Developed project plan to migrate numerous Excel and Access reports to a standardized and secure Crystal Reports/Business Object environment.
• Lead design sessions with appropriate management to identify reporting/extract requirements.
• Worked with data team to identify correct data sources, scheduling extractions, load scripts to a data warehouse and related ETL processing.
• Designed, developed and delivered updated reporting environment and necessary reports.

• Created Project Plan to add a new data warehouse reporting platform to supplement a legacy child protective services reporting system.
• Reverse engineered existing reports to identify structure and required data sources.
• Mapped and documented necessary data items from legacy system to Oracle data warehouse.
• Met with key staff to ensure report validity and ensure future requirements are met.
• Designed and developed Cognos reporting environment.

Reston, Virginia, US

• Project manager on a large-scale shipyard systems reporting migration project.
• Design and development of Oracle data warehouse used to consolidate and store data from more than 20 desperate databases. This would become the source reporting repository for many systems and users across the base.
• Met with team leads, program managers, and department heads to acquire and document current reporting specs, related sources, code, and define future requirements.
• Collaboration with systems DBA’s to evaluate data requirements, schedule scripted extracts to data warehouse and to gain general system knowledge.
• Design and development of new Oracle Discover / Reporter reporting repository to be used by upward of 1k users. Users of more than 20 desperate systems would use this as their new report retrieval and writing repository.
• Development of training program and documentation on report retrieval, and report creation specific to each system and user’s needs.

Reston, Virginia, US

Consulting Project with CACNorfolk Naval Shipyard/Department of Defense - Norfolk, VA.

Reston, Virginia, US

Consulting Project with CACIJoint Base Lewis McChord - Fort Lewis, WA.

Reston, Virginia, US

Consulting Project with CACI

Bethesda, MD, US

Lockheed Martin / American Management Systems (CACI)

Associates, Data Management

Data Management