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.
• 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.
• 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.
• 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.
• 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.

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.

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.
• 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.