Jack D. Email & Phone Number

Redmond, Washington, Us

Teams team - Data Analytics for New Teams update and cross-organization collaboration & messaging

Redmond, Washington, Us

• Drive data analytics in MS Teams - MWT FL&W (Frontline & Workflows)

Redmond, Washington, Us

• Improve Bookings product decision making and application functionality by developing a multi-environment analytics suite that combines Power BI, Kusto, Interana/Scuba, and Aria to create a comprehensive Bookings BI hub, providing a single source of truth to a wide array of data consumers• Help clients fully utilize Teams’ industry-leading analytics features by developing call quality dashboard (CQD) distributed reporting systems using Power BI and custom connectors and then preparing clients to launch their near-real-time QA dashboards & telemetry pipelines• Develop and present telemetry analytics sales presentations to attract more customers and leveraging Teams’ data advantages over other video conferencing competitors while improving on existing customer experiences• Reduce reporting overhead and analytics delays by developing Teams Bookings data infrastructure using SQL and Cosmos/ADL Scope scripts while also building data pipelines in Azure Data Factory• Measure the impact and success of newly deployed Teams healthcare features using MS sales finance data (MSRA) in Excel and Power BI to analyze license usage and feature adoption habits• Manage analysts and data engineers across disparate international teams by directing project vision, planning timelines, helping troubleshoot queries and data pipelines, and prioritizing analytics features• Cultivate MWT’s human capital and data literacy by mentoring teammates in healthcare and the MS data stack, interviewing new prospective engineers and analysts, presenting both structured and round table information sessions, and leading collaborative research/productivity hacking sessions • Provide healthcare subject matter expertise and develop telehealth solutions by planning features and maintaining product backlog for healthcare, EHR integration, and virtual visits analytics

Seattle, Washington, Us

• Instructor and TA for Data Analysis & Visualization, Machine Learning, & Healthcare Analytics programs• Instruct and present to students on SQL, Tableau, Power BI, & R for data analysis, visualization, & reporting• Manage online classroom and assist instructor in presentations

Redmond, Washington, Us

• Detect major performance improvement opportunities for the Xbox Series X/Scarlett and Xbox One S/X consoles by creating the automated alpha & beta flight analytics system: Hardware Early Warning System (HEWS) using Scope scripts & Power BI to analyze storage reliability, controller enrollment timing, ODD, & network connections • Ensure data quality, security, & integrity by developing and maintaining data models via Cosmos Scope & Kusto scripts, Xflow and DataGrid scheduling, UAM Dynamics DB, validating datasets using T-SQL queries and Power BI DAX code, and by developing advanced analyses with slicer-enabled Excel Pivot Tables & PowerPivot DAX• Plan V2 database for UAM (Unified Asset Management) system , develop data dictionary and schema for expansive hardware management database, and outline best use procedures for asset analytics• Identify and surface prototype Xbox hardware issues for leadership by directing the Hardware Beta analytics as the lead BI developer, assigning resources to develop dozens of reports & datasets, & working with stakeholders in a highly agile environment to rapidly architect Cosmos/ADL data pipelines and polished Power BI reports• Leading Hardware Beta analytics by providing data visualization, Scope & Kusto query code reviews, Power BI & data engineering guidance, data validation & modeling, defining KPIs, and data security procedures update• Managing script version control & report storage with Azure DevOps/GitHub synced repositories • Supply analysts with reliable data pipelines for Xbox testing & usage analysis by leveraging Cosmos Scope & PowerShell scripts, R & SQL code, and Azure Data Factory to develop data egress & reporting infrastructure • Test and deploy data modeling improvements to increase report and pipeline performance on widely distributed, data-intensive Power BI reports, SQL & SSIS/SSAS, and Cosmos structured streams

Redmond, Washington, Us

• Developed Power BI data visualizations and dashboards in support of Microsoft gaming studios, QA teams, & Xbox live platform to provide performance benchmarks & market insights to Xbox studios & corporate leadership• Created Kusto (Azure Data Explorer) queries & functions to power GDPR-compliant live telemetry data flows and reports to help track and resolve trending game/app crashes• Developed Cosmos (Azure Data Lake) streams with Scope to prepare queries and create data pipelines that drive historical data analysis and enable insightful data visualizations with validated data engineering• Regularly used Azure SQL & PowerShell to schedule, transform, & prepare data views for reporting/analysis • Continuously improved reporting accuracy, accessibility, and reliability for business users by maintaining data mart dependencies using SQL/DataGrid/Xflow/Fiddler and detecting data quality issues prior to analysis• Focused data access, increased report relevance, improved data security across dozens of teams by managing reporting data privacy in Power BI & SQL with row level security and role-based access controls• Maintained a complex cross-workspace Power BI report via advanced Excel ODC connections in order to analyze usage metadata on hundreds of reports across dozens of workspaces, allowing Microsoft BI administrators to efficiently measure and optimize their reporting value by trimming or improving disused reports• Conducted regular, in-depth training sessions and scrums to assist with intra-team and inter-departmental BI, data visualization understanding, and standardization of organizational reporting methods

Redmond, Washington, Us

• Demonstrated client exercise & nutrition program value, results, and participant satisfaction by designing & implementing a client-facing automated reporting system while simultaneously developing hundreds of Redshift SQL queries and views to power interactive Highcharts dashboards and data visualizations• Improved operational efficiency and data accuracy by automating numerous HIPAA-compliant ad-hoc analyses in Excel with Redshift/PostgreSQL queries, pivot table slicers, PowerShell scripts, & VBA macros• Led agile database development projects in order to create a robust new reporting infrastructure while managing project scopes, stakeholder needs & expectations, user stories, and bug fix requests for international data architecture and web design teams using Confluence/Jira, Wrike, & Bitbucket project management tools• Manipulated data models and enhanced database structures using SQL data normalization, MS Access, and R for increased database performance, data accuracy, and reporting responsiveness, & maintained HIPAA certification

Seattle, Washington, Us

• Led database development, RBAC/software UAT, and data virtualization projects by respectively providing database subject matter expertise, experience in data analytics, & project vision/business process optimization• Improved operational efficiency and business analytics by delivering projects plans and budget analyses with Excel data visualizations and dashboards based on H/VLookups, complex pivot tables/slicers, & VBA macros • Responsible for successfully directing and planning data audit & security training projects, optimizing database operations, analyzing query data, and maintaining HIPAA certification

• Provided in-depth analyses of market data, client trade logistics, and export opportunities• Composed quantitative market briefs for client companies• Researched markets' relevant economic policies and potential trade barriers• Provided writing and data analysis to support International Trade Specialists

Clinton, N.Y., Us

Certificate Program, Data Visualization

Bachelor Of Arts (Ba), Economics & Spanish

Education record

International Economics

Economics

Education record