Tony Dean Email & Phone Number

Remote

Institutional Products Team

Westborough, Massachusetts, United States

Greater Boston Area

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… Show more 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. Show less

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 usersBrought knowledge of SQL Server query optimizer and implemented methodical approach to… Show more 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 usersBrought 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 packagesEducated 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 managementOperated in matrix environment with technical, front line and program managers to ensure data flowed to reports accurately and leadership had required decision support tools. Show less

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 serversIdentified efficiencies in the design of .NET and SQL Server based web applications that saved over 200 hours in support costs yearlyLead 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… Show more 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 serversIdentified efficiencies in the design of .NET and SQL Server based web applications that saved over 200 hours in support costs yearlyLead 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 occurredMaintained 24 hour support for customer facing applications to ensure the highest customer service standards were met Show less

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.

As, Computer Information Systems, 3.934

Cumulative GPA 3.934

Economics

Activities and Societies: Skiing and golf