Matthew Allison Email & Phone Number

Darien, Connecticut, Us

Lead the technical team for consulting projects, utilizing technologies including Snowflake, SQL Server, PostgreSQL, Python, dbt, Power BI, Tableau, ChatGPT and other technology tools. • Refactored a SQL Server data warehouse, migrated BI to Power BI and created data input web portals for a major manufacturing company with 6 ERP systems serving 16 plants around the world. (SQL Server, Airflow, Django, dbt, Power BI, Python)• Built a data warehouse and BI environment for a medical clinic company with multiple locations, and two CRM’s. This included creating data pipes from the two CRM systems to Snowflake and then transforming the data into the data warehouse using dbt Cloud and feeding the data into a Tableau BI system. (Snowflake, dbt cloud, Stitch, Tableau)• Identified all branches from a list of companies, and calculated the driving times between them using Google Maps api and python. Then built a visualization to present this data. (Google API, Python, Excel)• Created an AI assistant capable of querying a clients data base based on a customer’s natural language question and return both language-based answers and tabular data as well as the ability to create a visualization

Dallas, Tx, Us

Managed team of four data analysts supporting marketing and sales with ad-hoc reports, data analytics and application development using Power BI, Snowflake SQL, Teradata SQL, Micro Soft Azure, Alteryx, Tableau, MS Office, and Python.• Served as team lead for migrating business marketing’s data processes from Teradata to Azure/Snowflake environment. This migration not only reduced AT&T’s cost for data storage, but also gave my team access to many innovative tools which were not available in our previous environment. (Azure Cloud Storage, Snowflake Data Cloud, Data Bricks, Power BI, Python, Alteryx)• Devised and guided team which created AT&T’s Business Contacts and Accounts Management System (BCAMS), a system which mastered account and contact data from multiple third-party data sources (Duns & Bradstreet, Equifax, ZoomInfo, etc.) and internal billing systems to deliver as qualified leads to sales team in SalesForce.com as well as other applications. (Teradata SQL, Alteryx, Unix, Snowflake Data Cloud).

Dallas, Tx, Us

Headed team responsible for migrating and supporting wireless sales and marketing campaigns from Cingular systems to AT&T systems. (Teradata SQL, Unix, FTP, PGP Encryption, GPG Encryption)• Oversaw identification of requirements and devised targeted marketing campaigns for the business marketing and sales teams, creating between 800 and 1000 campaign lists each year.• Created and maintained a data set within Teradata where different sources of mobility customer data were brought together in order to simplify ad hoc reporting and create a more consistent view of AT&T’s Business mobility customer base. This also provided for improved time to market for sales and marketing campaigns.

Dallas, Tx, Us

Support AT&T’s business marketing team to fix an identified challenge within the marketing process.• Envisioned, conceived, and led team to establish new web-based application which standardized AT&T’s business marketing process. The Integrated Marketing and Target Tracking System ( iMATTS) tool tracked process from offer ideation through pricing approval, campaign modeling and measuring final sales results, including tracking projected and real costs. (.Net, Java, Teradata, Unix)• Oversaw team in development of web-based application used by Network planning and Real-estate for AT&T’s Fiber build out.• Responsible for continued development and maintenance of these tools via the Agile method of sprints and releases.

Dallas, Tx, Us

Led team of 32 second line managers and contractors to Onboarded Bell South business data processes from external vendor (Harte-Hanks) to internal systems during AT&T/Bell South merger. (Teradata SQL, Unix)• Visualized, designed, and built a new data schema for business marketing called Business Marketing Opportunity System (BMOS) used by data analyst teams as single source of truth for AT&T business analytics data.• Headed team of data analysts responsible for creating targeted marketing lists for AT&T business marketing and sales. Partnered with channel marketing team to identify business goals and turn into requirements for team to create lists using Teradata SQL and HCL Unica.