Matthew McDermott

Business Intelligence Engineer

• Successfully solve difficult and/or loosely structured problems

• Refine requirements from business stakeholders into a functional design that solves the problem

• Developed data feeds, aggregation BI tables, BI reporting, and down stream customer impact attribution responsible for Gifting, List, Social Share, and huddles features on the Amazon store ($60B revenue annualized).

• Built and managed infrastructure to analyze Amazon store A/B testing results

• Built and optimized multidimensional data models using extremally large datasets

• Managed multiple Tableau dashboards providing PM's, Directors, and VPs insights for weekly, monthly, and quarterly business reviews

• Collaborated with multiple functional groups to implement a ML attribution revenue model for the Social Share widget on the Amazon store

Sr. Business Analysis Manager

• Extensive experience with cross-functional collaboration to produce business solutions, build data, and leverage diverse skills and experience.

• Managed, built, and presented more than 50 multidimensional Power BI Reports.

• Spearheaded the creation and production of more than 15 nationally used Power Apps exceeding over 3 million logins in 3 years.

• Administrator for multiple on-premise and azure SQL servers, Polaris virtual machines, Power BI tenant, and Azure Data Warehouse.

• Constructed a full CRM management tool enabling T-Mobile’s outbound calling functional group.

• Sourced, processed, and provided analytics for the entire Sprint company customer base after merger.

• Extracted Power BI Metadata into a SQL database using XMLA, DML, and DAX queries enabling dynamic report refreshes and usage analytics.

• Geography analysis, distance mapping and creating organizational polygons for hierarchy mapping.

Business Analysis Manager

• Built underlying and reporting data for quarterly and annually business reviews.

• Constructed and automated 50 to 100 page Analytical PowerPoint decks for Region and individual Markets each week.

• Automated daily COVID-19 Emails using VBA for SLT and individual Markets containing critical daily business continuity information.

• Develop clear, accurate and timely reporting solutions for both internal and external customers.

• Implemented and managed server wide data governance on SQL server.

• Created financial reports and dashboards for forecasting, trending and results analysis.

Sr Analyst, Business Analysis

• Combine data from multiple data sets to provide a comprehensive picture and analysis of client usage and trends.

• Ensured accuracy and a high level of detail and the use of analytical thinking to resolve problems.

Sales Analyst

• Collected, analyzed, evaluated, and reported sales results and performance to identify and recommend steps to increase sales productivity.

• Built and presented weekly PowerPoint presentations for senior leadership.

Retail Store Manager

• Developed a hard working friendly competitive sales culture.

• Develop analytical data reports using excel to drive success.

• Adapt quickly to new company initiatives and goals.

• Coach and develop talent into leadership roles.

• Top Performing Store manager.

• Nominated to create and manage region and district wide ranker metrics.

• Priority district contact for peers to help teach company initiatives.

• Exceptional Operations and sales achievements.

• Expert at interviewing and recognizing talent.

Retail Sales Manager

Retail Sales Representative

Retail Sales Representative