Christopher Collins

Background

About Christopher Collins

Experienced data analyst using both structured and unstructured data to identify trends, perform statistical analysis, identify and creatively solve problems to accurately report data. I excel data validation, problem solving, thinking outside the box and accounting for unexpected anomalies to identify previously unfound trends and drive business decisions to benefit the business as a whole. High aptitude and possess the ability to quickly learn new software, analytical techniques and analysis tools. Advanced in using SQL, Hadoop, Teradata, Redshift, SQL Server, MySQL Workbench, Microsoft Office, VBA, and Tableau. Committed to solving problems, accurately reporting results, identifying new trends and benefiting the business.• Write complex SQL queries in Hadoop, Teradata and Microsoft SQL server using complex joins, nested subqueries, grouping and aggregation across multiple tables and data sets• Work with colleges to help teach colleagues SQL and database structure enabling them to gather their own data to help strengthen and improve business efficiency • Work with the development team to help troubleshoot data errors and deficiencies • Perform analysis on viewership and subscription data and present results using SQL, Excel, Tableau, MS Access and Visual Basic scripts• Write and automate tools using Visual Basic Scripts and Tableau to increase departmental efficiency and automate repeatable tasks for the business user• Import, export and manipulate large data sets in multi-million row databases for rapid delivery to clients under tight deadlines• Collaborate with internal clients to understand requirements and potential uses to accurately gather and present data to meet and exceed client project needs and goals• Combine and explore existing unused data to provide new and unique analysis to better benefit business needs