NICHOLAS SCHAEFER
Falls Church,VA
Summary
Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Data Analyst in Customer Protection-Retail Bank
Capital One
McLean, VA
02.2023 - Current
- Curated feature significance across multiple data sources in Snowflake for a multivariate regression model to determine probability of Internal Fraud
- Created Tableau Dashboards to monitor and track Zelle Send Transactions
- Updated and optimized scripts and queries in SQL to extract and analyze data from multiple sources.
- Collaborated with stakeholders to identify business needs across all channels of fraud and cross-functional software engineering teams to ensure data integrity and accuracy
- Provided SQL and Python support for troubleshooting analytics,reporting issues, and new analysts.
- Developed and implemented data governance policies and procedures.
Junior Analyst in Core Business Operations
Deloitte
06.2022 - 02.2023
- Investigated system failures for the Kentucky Integrated Health Insurance Premium Payment (KI-HIPP) Program, monitoring accurate record entry through SQL queries
- Obtained AWS Certified Cloud Practitioner, AWS Certified Developer-Associate and AWS Certified Solutions Architect
Field Supply Chain Process Engineer Intern
Walmart
06.2021 - 08.2021
- Researched stacking designs and implementation to improve pallet density
REACH Engineer Co-op
International Paper
01.2021 - 05.2021
- Correlated total titratable alkaline (TTA) and conductivity for lime kiln sodium control
Engineering Co-op
GAF
08.2020 - 12.2020
- Lead alternate box vendor trial for commercial roofing packaging
Process Engineer Co-op
Annapolis Microsystems
05.2019 - 12.2019
- Machine programmed SMT equipment
Education
Master of Science - Data Science
University of Indiana-Bloomington
Bloomington, IN05.2028
B.S. in Chemical Engineering -
Virginia Polytechnic Institute And State University
Blacksburg, VA05.2022
Skills
- Python
- SQL
- R
- Tableau
- MS Excel
- MS Word
- MS PowerPoint
- MS Outlook
- Minitab
- MatLab
- HTML
- CSS
Certification
- AWS Certified Cloud Practitioner
- AWS Certified Developer-Associate
- AWS Certified Solutions Architect-Associate
Timeline
Data Analyst in Customer Protection-Retail Bank
Capital One
02.2023 - Current
Junior Analyst in Core Business Operations
Deloitte
06.2022 - 02.2023
Field Supply Chain Process Engineer Intern
Walmart
06.2021 - 08.2021
REACH Engineer Co-op
International Paper
01.2021 - 05.2021
Engineering Co-op
GAF
08.2020 - 12.2020
Process Engineer Co-op
Annapolis Microsystems
05.2019 - 12.2019
Master of Science - Data Science
University of Indiana-Bloomington
B.S. in Chemical Engineering -
Virginia Polytechnic Institute And State University