Ethan M. Gardner, Mba Email & Phone Number

Raleigh, North Carolina, United States

• Automated routine tasks, leveraging historical seasonal patterns and employing data checks in SQL and SAS languages, leading to a 25% decrease in workflow on reviewing data errors, enhancing efficiency and accuracy in.
• Utilized SAS and SQL in Metabase to consolidate quarterly datasets exceeding 5.6 million records from diverse databases, facilitating data aggregation and macro-level analysis ensuring data consistency by identifying.
• Conducted a yearly benchmark by converting administrative data into a time series, removing outliers from the model, and estimating employment in areas where data was lacking, realigning CES to reality and accurately.
• Led data migration between servers, implementing SAS-based ETL processes for automating encryption/decryption protocols, resulting in a 30% reduction in transfer time, 60% fewer inconsistencies, and compliance with.
• Verified and generated monthly and quarterly release tables for publication, employing a combination of SAS and Excel to ensure accuracy and facilitate timely dissemination of data to the public.

Raleigh, North Carolina, United States

• Reviewed monthly sample data, monitored WARN notices and news sources for employment shifts, and evaluated modeled output, offering recommendations to enhance data accuracy and providing local insights to optimize CES.
• Optimized handling of survey data in MS Excel, utilizing VLOOKUP to merge new data with existing system entries and pivot tables for comprehensive analysis, resulting in a 25% workload reduction and improved accuracy.
• Enhanced and upheld the integrity of the QCEW database, earning national acclaim for its exceptional cleanliness, through meticulous editing, cleaning, and conversion of administrative data into reliable economic data.
• Created a visual SQL mapping diagram to illustrate table connections, serving as a valuable training tool for the team to comprehend the relationships among frequently accessed tables.

• Evaluated students, promoted classroom engagement, and helped students adapt to the virtual environment.
• Worked directly with professors, students, and other academic coaches to set attainable academic targets.

Presentations:Gan, Lydia & Gardner, Ethan M. (2022). “An Exploratory Study of Students Performance in MBA courses,” 2022 Academy of Economics and Finance virtual conference, 3:15pm - 5:00pm EST, Feb 10.Gardner, Ethan M. & Gan, Lydia (2021). “Motivations for Pursuing an MBA Degree,” 2021 Academy of International Business US-Southeast Chapter virtual.

• Performed monthly sales forecasts for Global Impex and its two subsidiaries.
• Analyzed company operations to find new ways to cut company costs. Gave recommendations to company executives to change outsourcing partners, reducing the price by 63%.
• Conducted a monthly performance analysis of sales, website/social media traffic, and professional athlete audience pull.
• Investigated ways to improve SEO for Amazon, Etsy, and website store pages to boost web traffic and sales.

Pembroke, North Carolina, United States

• Updated research information and medical tourism resources on the Medical Tourism Research Center website.
• Transcribed interviews with administrators from international hospitals.
• Collected COVID-19 & national health data from 23 countries and created useful graphs for presentations.
• Edited lecture videos and updated course material for a graduate health economics course. Also, created supplemental tutorial videos on mathematical equations for the course.

Pembroke, North Carolina, United States

• Conducted 300 individual face-to-face surveys on medical tourism in the Winston-Salem & Greensboro, NC area in Summer 2019.
• Collected and analyzed data on 175 medical tourism facilitator websites and created a spreadsheet database.
• Researched and analyzed journal articles on study abroad, medical tourism, COVID-19, and telemedicine research studies.
• Face-to-face and virtual supplementary instructor for undergraduate statistics, economics, and spreadsheet database management, improving student grades and understanding of course concepts.

Clemmons, North Carolina

• Trained new team members, coordinated with staff, and provided excellent customer service.
• Worked in a high-pressure environment.

Master Of Business Administration - Mba, Business Analytics, 3.917 Gpa

Activities and Societies: Participated in the 2021 graduate research symposium

Bachelor Of Science In Business Administration - Bsba, Double Concentration In Finance & Economics, 3.817 Gpa

Activities and Societies: President of Economics club, Member of Passport to Professional Success, Member, Omicron Delta Epsilon.

International Business, 3.750 Gpa

5 week study abroad program

Associate Of Arts - Aa, Accounting, 3.60 Gpa

Activities and Societies: Dual-Enrollment

High School Diploma, 4.2 Gpa

Activities and Societies: NTHS, Dual-Enrollment