Work Preference
Summary
Overview
Work History
Education
Skills
Certification
Additional Information
Technical Differentiators
Technical Stack
Websites
Interests
Timeline
Generic
Mason Tyler Crowe
Open To Work

Mason Tyler Crowe

Denison,TX

Work Preference

Desired Job Title

Data Analytic Internal Audit ManagerData Analyst ConsultantSenior Data AnalystData Analytics ManagerSoftware Programmer

Work Type

Full TimeGig WorkConsulting

Location Preference

RemoteHybrid
Location: Denison, TX, US
Open to relocation: No

Salary Range

115000/yr - 200000/yr

Important To Me

Work-life balanceCompany CultureHealthcare benefitsWork from home optionPaid time offPaid sick leave401k match4-day work weekStock Options / Equity / Profit SharingPersonal development programsFlexible work hours

Summary

Internal audit manager specializing in operational efficiency through advanced data analytics and continuous auditing. Recognized as 2023 internal audit employee of the year for innovative solutions that enhanced audit coverage and compliance. Proficient in SQL, Python, and Power BI to provide impactful insights.

Overview

1
1
Certification
10
10
years of professional experience

Work History

Data Analytic Internal Audit Manager

First United Bank & Trust
Sherman, TX
08.2024 - Current
  • Oversaw daily operations of the data analytics team by assigning audits, mentoring team members, and evaluating projects.
  • Developed strategic structure for data analytics team, including job role descriptions, competency matrix, and methodologies for project evaluation and continuous auditing.
  • Led data analytics for internal fraud investigations.
  • Performed Senior Internal Auditor – Data Analyst responsibilities for any gaps to ensure all projects are completed on time in accordance with the Internal Audit Plan.
  • Implement continuous auditing frameworks and managing internal audits database management.
  • Created Python class functions to extract data from multiple sources (on-prem servers, Snowflake, Power BI, Excel, APIs), scheduled daily refreshes into internal audit SQL server, and utilized new data tables for workpaper analytics and continuous auditing across departments.
  • Developed two Internal Audit department wide applications utilizing python
  • Internal Audit time tracking web base application
  • Established the current procedures for team’s competency matrix and job descriptions.
  • Contributed innovative solutions during 2024 First United's Build-A-Thon.

Senior Internal Auditor – Data Analyst

First United Bank & Trust
Sherman, TX
08.2021 - 08.2024
  • Led data analytic project end to end for 50% to 100% of the audit plan.
  • Utilized data analytics to execute audits for internal audit plan and conduct additional analytics for FDICIA compliance testing, action validations, and fraud investigations.
  • Developed data analytic reports, populations, and visuals for business units including incentive compensation, third party management, employee expenses, loan operations for consumer and commercial, mortgage origination and servicing, and various compliance-based analytics (HMDA, CRA, SAFE ACT, Reg E, Reg B, SCRA, HPA, FDPA).
  • Utilize tools such as Alteryx, Power Query, and Power Automate to create audit specific databases in the internal audit SQL on prem server.
  • Provided consulting services to other various analytic partners and departments across the bank.
  • Assist management in board level reporting with Power Bi.
  • Participated in First United’s Build-A-Thon and contributed to winning team in 2022 and 2023.
  • Recognized as 2023 Internal Audit Employee of the Year for outstanding contributions.
  • Transformed unusable accounts payable reports into actionable SQL analytics.
  • Provide consulting analytics for Enterprise Risk Management and Compliance Department.
  • Received CISA certification

Internal Auditor II – Data Analyst

First United Bank & Trust
Sherman, TX
08.2020 - 08.2021
  • Utilize SQL server reporting service (SSRS) and Power Bi to create dynamic automated paginated (rdl) reports as well as data visualization in Power Bi.
  • Executed SQL scripts to normalize on-prem data, enhancing analytics for annual audit plan and anomaly detection.
  • Developed data analytic reports and visuals for Accounting, Accounts Payable, General Ledger, and Demand Deposit Operations, supporting informed decision-making.
  • Assisted data analytic team in FDICIA compliance testing and validation of action items, ensuring adherence to regulatory standards.
  • Consistently delivered high-quality analytics on time
  • Acquired SQL and Power BI skills through self-directed learning and minimal training
  • Recognized as top performer for outstanding contributions in 2020

Internal Auditor II

First United Bank & Trust
Mckinney, TX
08.2019 - 08.2020
  • Executed audit fieldwork and internal control testing across operational areas, ensuring timely engagement completion and accurate risk assessments.
  • Performed walkthroughs, sampling, and substantive testing; documented results and recommended control improvements.
  • Delivered clear documentation and professional communication, reinforcing audit quality and fostering stakeholder collaboration.
  • Coordinated with business units to validate remediation efforts, enhancing accountability for follow-up items.
  • Developed strong documentation, analytical, and research skills through risk-focused audit engagement.

Internal Auditor I

First United Bank & Trust
Durant, OK
08.2018 - 08.2019
  • Conducted internal audits of financial records and operational processes.
  • Assessed compliance with internal policies and regulatory requirements.
  • Collaborated with departments to identify risk areas and improve controls.
  • Supported audit engagements, enhancing audit, risk assessment, and stakeholder communication skills.

Accounting Management Trainee

Nestlé Purina
Bloomfield, MO
06.2017 - 07.2018
  • Conducted monthly and quarterly audits on internal controls for all areas involving the factory’s materials.
  • Analyzed and researched material variances through monthly audits, cycle counts, and daily reports, communicating findings to management for informed decision-making.
  • Managed Technical Store accounting procedures independently, ensuring compliance and accuracy.
  • Analysis and complete Material Accounting month end procedures.
  • Developed and collaborated with cross-functional departments to enhance inventory management practices.
  • Perform investigative research to ensure accuracy and effectiveness and prompt process improvements.
  • Completed the Bloomfield Accounting Management process documentation.

Internal Audit Associate

First United Bank & Trust
Durant, OK
05.2016 - 05.2017
  • Coordinated planning, fieldwork, and reporting for Internal Audit Department to drive process improvements.
  • Conducted compliance and internal control audits based on risk assessment scores, identifying improvement opportunities for business units.
  • Delivered value and quality through internal audit engagements, fostering positive relationships with management and enhancing core processes.
  • Conducted follow-up activities to ensure timely implementation of corrective actions identified in audits.
  • Assist in prompting process improvements across various departments such as marketing, vendor management, and payroll.

Education

BACHELOR’s Degree - Science of Accounting

Southeastern Oklahoma State University
Durant

BACHELOR’s Degree - Aviation Science

Southeastern Oklahoma State University
Durant

Skills

  • Data Analytics
  • Continuous Auditing
  • Audit automation
  • Internal Audit Reporting
  • Risk Assessment
  • SQLite Compliance
  • Internal Controls
  • Data Quality Management
  • Pyodbc architecture
  • Pandas Transformation
  • ETL development
  • Power BI Dashboards
  • SSRS Dynamic Reporting
  • Data Visualization
  • Python Automation
  • SQL
  • Advanced SQL
  • APIsMentorship
  • DAX
  • Excel
  • Alteryx
  • SSIS
  • SQL Server
  • Snowflake
  • Python
  • SQL
  • DBeaver
  • Streamlit
  • Django
  • Tkinter
  • Power Automate
  • Power BI
  • SSRS
  • NumPy
  • SQLAlchemy
  • Matplotlib
  • Power BI
  • VBA
  • HTML
  • CSS
  • Java
  • Visio
  • SharePoint
  • OneDrive
  • Outlook
  • OneNote
  • PowerPoint
  • Word
  • Adobe Acrobat
  • Team Leadership
  • Audit Guidance
  • Audit Team Development
  • Stakeholder management
  • Cross-functional collaboration
  • Process Improvement
  • Operational Efficiency
  • Problem solving
  • Time management
  • Leadership
  • Stakeholder communication
  • Team Engagement
  • Continuous improvement
  • Presentation skills
  • Leadership
  • Data Quality Management
  • Team Engagement
  • Continuous improvement

Certification

Certified Information Systems Auditor (CISA), ISACA, 242395759, 01/01/24

Additional Information

Additional work experience and references are available upon request.

Technical Differentiators

  • Combines internal audit expertise with hands-on analytics, engineering and application development
  • Experience building end-to-end data solutions from ingestion and transformation through reporting and visualization
  • Proven ability to translate business and audit objectives into scalable technical solutions
  • Strong self-directed learner with a track record of rapidly adopting and implementing emerging technologies

Technical Stack

Python, SQL, DAX, VBA, HTML, CSS, Java, Power BI, SSRS, SSIS, Alteryx, Excel, SQL Server, Snowflake, SQLite, SSMS, DBeaver, Streamlit, Django, Tkinter, Power Automate (Desktop & Web), pyodbc, Pandas, NumPy, SQLAlchemy, Matplotlib, Visio, SharePoint, OneDrive, Outlook, OneNote, PowerPoint, Word, Adobe Acrobat

Interests

Mountain Biking

Camping

Church

Timeline

Data Analytic Internal Audit Manager

First United Bank & Trust
08.2024 - Current

Senior Internal Auditor – Data Analyst

First United Bank & Trust
08.2021 - 08.2024

Internal Auditor II – Data Analyst

First United Bank & Trust
08.2020 - 08.2021

Internal Auditor II

First United Bank & Trust
08.2019 - 08.2020

Internal Auditor I

First United Bank & Trust
08.2018 - 08.2019

Accounting Management Trainee

Nestlé Purina
06.2017 - 07.2018

Internal Audit Associate

First United Bank & Trust
05.2016 - 05.2017

BACHELOR’s Degree - Science of Accounting

Southeastern Oklahoma State University

BACHELOR’s Degree - Aviation Science

Southeastern Oklahoma State University
Mason Tyler Crowe