Tony Dean

Data Science support for Stablecoins, Payments and Coinbase Developer

Managing the day to day delivery of mission critical reporting and technology services. Developing new solutions using Tableau, Hadoop and Impala, always testing new tools and technologies.

Working in the MS SQL Server 2012 and BI suite 2012 to produce database and analytic solutions for the Production Operations group.

Working in the Home Loans and Insurance reporting environment, developing SQL Server BI Solutions to drive collection and contact rates, and meet regulatory reporting requirements for bank owned second lien portfolio, operational and governance teams. Also designing ETL and database solutions to enable reporting and analyses in SQL Server 2005 and 2008 with a focus on high availability and redundancy. Experienced in managing both development and support teams working mainly in Microsoft BI tools in high volume, high up-time environments.

Designed load process, database objects and reporting structure for outbound list generation and reporting on call center results where none had existed previously, interfacing with Sybase 12.5, SQL Server 2005/2008 and SSIS Designed sliding window partitioning scheme to ensure ETL process loaded ~5mm rows daily within SLA and passing quality checks while causing minimum downtime for query users Brought knowledge of SQL Server query optimizer and implemented methodical approach to performance improvement by testing several alternatives to long standing load routines in T-SQL procedures and SSIS packages Educated new report developers on writing efficient SQL code and using an iterative development process Successfully managed team of six BI developers across multiple states and time zones including budgetary and performance management Operated in matrix environment with technical, front line and program managers to ensure data flowed to reports accurately and leadership had required decision support tools.

Managed a five person team supporting a portfolio of 30 web applications and a clustered and replicated SQL Server environment totaling 90TB capacity over 35 servers Identified efficiencies in the design of .NET and SQL Server based web applications that saved over 200 hours in support costs yearly Lead the Support Team through several major initiatives, including the roll out of multiple web based applications with over 100,000 users in a zero downtime environment by designing proactive monitoring routines to address data anomalies before downtime occurred Maintained 24 hour support for customer facing applications to ensure the highest customer service standards were met

Collected on seriously delinquent consumer credit card accounts, ranging from 30 days to 210 days past due.

I worked in outward telesales, marketing and account retention. Additionally provided reporting, training and manager coverage.

Cumulative GPA 3.934