IT Auditor Intern

Nathan Shierk

*** ******** **, **** ****, NC ****1 561-***-**** ad19k0@r.postjobfree.com

EDUCATION

Western Carolina University, School of Business May 2023

Bachelor of Science in Business Administration, Major in Computer Information Systems (BSBACIS) Cullowhee, NC

Carolina Village Retirement Home Scholarship Recipient

Asheville Buncombe Technical Community College

August 2021

Associate in arts

TECHNICAL SKILLS

Asheville, NC

Data Tools: SQL, MySQL, phpMyAdmin, MS Access, Excel

Data Visualization Tools: Tableau, Lucid Charts, Plotly, Pandas

Operating Systems: Linux, Windows

Office Depot July 2023

IT Internal Auditor Intern

oSox Compliance Review: Collaborated with the internal audit team to assist in testing Sarbanes-Oxley (SOX) controls across various departments within the organization.

oTesting Procedures: Conducted substantive testing and walkthroughs of key controls to evaluate their effectiveness in mitigating financial and operational risk.

oControl Documentation: Assisted in documenting and updating control narratives.

PROJECTS

Western Carolina University Food Waste Database (Database administrator, Project Manager) May 2022

Created a phpMyAdmin database to record food waste, delivery dates, and current inventory. The project was completed for a senior-level Database Management Systems course.

oCoordinated colleagues to ensure the project was done punctually.

oUtilized phpMyAdmin database to store food waste data.

oGenerated relationship tables and flow charts using Draw.io.

oUsed Tableau to visualize statistics on food waste.

oPresented findings on food waste to the University to assist in reducing overall waste.

Visualizing Census Data with Tableau May 2022

Researched 2021 Census data was selected as the main source of information to gather information on commute times between states and counties within a certain state.

oDemonstrated web data extraction and data cleansing for accurate information required.

oDesigned a Tableau chart that differentiates suburban, rural, and urban to display commute times.

oUtilized the Census Library to create multiple graphs to assess the different commute times within North Carolina counties.

Contact this candidate