Summary
Overview
Work History
Education
Skills
Websites
Timeline
Generic

Mitchell Trafton

Indianapolis, IN,USA

Summary

Results-oriented data analyst with a strong foundation in data analysis and a keen interest in transitioning into a data engineering role. Proficient in leveraging SQL to extract, manipulate, and analyze data, generating meaningful insights and reports for stakeholders. Skilled in data cleaning and ensuring data quality to maintain accuracy and reliability. Experienced in working with diverse datasets and utilizing tools such as Excel, Tableau, and Power BI for data visualization and storytelling. Strong problem-solving abilities and a detail-oriented mindset, with a passion for optimizing data processes and improving efficiency. Adept at collaborating with cross-functional teams to understand business requirements and contribute to data-driven decision-making. Eager to apply my analytical skills and technical acumen to the field of data engineering, bringing a solid foundation in data analysis and a drive to learn and grow in a data engineering role. If you feel that this resume would be a good fit for another position in your company, don’t be afraid to pass it forward

Overview

3
3
years of professional experience

Work History

DATA ANALYST

Capital one
12.2022 - Current
  • Efficiently managed ETL process, transferring and organizing customer data from vendor databases to our marketing platform
  • Utilized SQL to conduct in-depth analysis of consumer data for marketing campaigns, generating insightful reports using Excel and Tableau for data visualization
  • Implemented data validation and transformation techniques within ETL process to ensure data integrity, consistency, and accuracy
  • Wrote regular reports on data piping outcomes, providing valuable insights and ensuring accuracy of information
  • Promoted within team, now overseeing and mentoring group of team members, ensuring consistent results across the team
  • Leveraged advanced SQL queries to perform complex data manipulations, including aggregations, joins, and sub-queries, to extract meaningful insights from large datasets

Data Analyst

United Healthcare
09.2021 - 11.2022
  • Developed SQL scripts to extract data for reporting and analysis for both internal stakeholders, as well as regulatory bodies.
  • Developed reports using both Excel and Tableau.
  • Assisted with data migration from a recently acquired company, transforming data to meet our standards.
  • Created various Excel and Tableau spreadsheets/visualization to assist with pulling metrics data in an automated manner, streamlining data access for stakeholders.

Education

B.S. Computer Science -

Northern Illinois University
DeKalb, IL
05.2021

A.S. Computer Programming -

Joliet Junior College
Joliet, IL
06.2019

Skills

  • SQL Server
  • Snowflake
  • ETL Tools
  • Excel Functions
  • Tableau
  • Data Migration
  • Agile Methodology
  • ETL Processes
  • MS SQL Server
  • Python
  • C# / NET
  • Git
  • JSON
  • UNIX/Linux
  • Marketing Platforms
  • Efficient integration and transformation of data from various sources, ensuring seamless data flow and adherence to quality standards
  • Expertise in programming languages (Python, C#, C) and scripting for automation and efficient data processing
  • Proficient in designing and optimizing ETL processes using Airflow and cloud-based solutions
  • Extensive experience in robust data modeling and warehousing, facilitating efficient storage, retrieval, and analysis of structured and unstructured data
  • Knowledge of big data technologies like Hadoop, Spark, and distributed computing frameworks
  • Proven ability to implement data governance frameworks ensuring privacy, compliance, and security
  • Proficiency in managing and optimizing relational databases (SQL Server, Snowflake) for high performance and data integrity
  • Skilled in implementing data quality frameworks and performing data cleansing for improved accuracy and consistency
  • Proficient in data visualization tools (Tableau, Power BI, QlikView) for impactful dashboards and reports

Timeline

DATA ANALYST

Capital one
12.2022 - Current

Data Analyst

United Healthcare
09.2021 - 11.2022

B.S. Computer Science -

Northern Illinois University

A.S. Computer Programming -

Joliet Junior College
Mitchell Trafton