Todd Wilson Email & Phone Number

San Diego, California, United States

• Collaborated with the PaaS Enablement Team to plan and design an Azure Cloud project aimed at delivering on-demand, self-service access to data assets from centralized repositories, including Informatica and Snowflake data marketplaces, enhancing data accessibility and empowering users with efficient data provisioning capabilities.• Authored comprehensive use cases and architected a data model to seamlessly integrate Salesforce with DealCloud, a pivotal component of KPMG's front office transformation project, facilitating enhanced client relationship management and data-driven decision-making.• Actively participated in weekly scrum meetings with the PaaS Enablement Team, utilizing Azure DevOps for efficient task tracking and management within the context of two-week sprints, ensuring collaborative and agile project execution.

Lewisville, Texas, United States

• Constructed custom workflows to move data to Snowflake from various sources, including Teradata, Oracle, SQL Server, Azure SQL Data Warehouse, Db2, SAP Hana, Greenplum, Redshift, Postgres, MySQL, and Netezza. Also built a data movement tool supporting over 200 source and target system combinations.• Completed a successful POC with AT&T to migrate data to Snowflake from a legacy Teradata system, utilizing Teradata Parallel Transporter for export and multiple import methods into Azure Data Lake Storage Gen2.• Worked with AT&T to implement multiple authentication methods, including SAS tokens and OAuth.• Administered Coffing's Snowflake warehouse used for software testing and customer education, managing user access and monitoring resource usage at the account level.• Fulfilled POC requirements for the software with Dell, Zurich Bank, Nationwide, Highmark Health, and Wells Fargo.• Introduced value-added data movement suite, enabling the company to reprice software at $1,000 from $499.• Coordinated the creation of server software allowing remote scheduling of data movement.• Designed an in-memory OLAP analytics collection, integrated a Python editor, and added a spreadsheet control for pivoting and analyzing data into the software.• Engineered software to pull relationships and data model metadata using the erwin API.• Succeeded in expanding software support from a handful of data sources to almost 30.

Lewisville, Texas, United States

• DBA Consultant at Dell Inc. (November 2006—January 2008) — Saved $300,000 through Teradata performance optimization and played a key role in launching Dell's Active/Active data warehousing with Linux script development to compare two Teradata systems.• ETL Developer Consultant at Cingular Wireless (April 2005—October 2006) — Consolidated data from eight systems into a Teradata mart, created a KPI report for 65,000 retailers, and automated billing and discounting.• Engineered Nexus database tool, enabling concurrent data source access for enhanced productivity.• Led creation of the first query tool for SQL Server Parallel Data Warehouse, now Azure SQL Data Warehouse and Azure Synapse.• Developed data tools, including visualization, report builder, data cleanser, DDL converter, Teradata script builder, compression/sync tool, and data profiler.• Instructed Teradata Basics and Advanced SQL classes with customers.