Social Media Marketing

Trevor Bertsch

570-***-**** *** Kathryn St. Shohola, PA 18458 adhpw6@r.postjobfree.com

EDUCATION

West Chester University of PA, West Chester, PA Aug 2018 - May 2020

Bachelor of Science, Finance GPA: 3.855 Summa Cum Laude

Description of Coursework: Developed an understanding of proper accounting principles, in-depth financial and valuation analysis, business and strategy, investment strategy, market research, business writing and presentation.

Honors: Dean’s List (Fall 2018 – Spring 2020), 2019 Benzing Family Scholarship (Finance Dept)

Lebanon Valley College, Annville, PA Aug 2016 - May 2018

Bachelor of Science, Actuarial Science and Economics (Transferred) GPA: 3.01

Description of Coursework: Independent study of mathematical analysis and writing. Each actuarial course required analytical thinking using established definitions in the development of proofs. Computer applications include projects using MS Excel, VBA, SQL, MS Access, and R.

Honors: Board of Trustees Scholarship, National Society of Leadership and Success

WORK EXPERIENCE

Marketing & Business Analyst, Bill Bertsch Construction, Shohola, PA Nov 2019 – Present

oResponsible for the initiating and restructuring of the website and social media platforms

oAnalyze current data using Google Analytics and develop strategies to drive growth

oManage operational and marketing plans

oWebsite and social media marketing management

Finance Intern/Business Analyst, All-Star Baseball Academy, West Chester, PA Sept 2018 - Dec 2019

oResponsible for financial reporting and bookkeeping duties using QuickBooks and Salesforce

oDeveloped automated solutions using MS Excel, Macros, VBA and Google Suite

oP&L management and analysis in MS Excel, presented analysis to management weekly

oAnalyzed large data sets and presented verbal and written reports to management

oCollaborated with the marketing department in web analytics and social media analytics by using Google Analytics, Ads and Facebook Creator Studio

oUtilized Salesforce daily and duties included sales reporting, data analysis, data input/correction, and data gathering for visualizations in Excel (Pivot tables)

Assistant Manager, Bill Bertsch Construction, Shohola, PA June 2012 – Aug 2020

oSupported over 100 residential projects including interior/exterior renovation and new construction

oPoint of contact between customers, suppliers, and management for multiple, simultaneous projects

ACTIVITIES

LVC Baseball Team Sept 2016 - May 2018

Played and practiced over 40 hours per week as Shortstop and Pitcher

MAC Commonwealth All-Conference Baseball Team

SKILLS AND CERTIFICATES

Microsoft Excel, VBA Script, Macros, Tableau, Python, R, Word, PowerPoint, Access, Visual Basic, SQL, Google Suite, QuickBooks, SalesForce.com

Data Visualization, Web Scraping, Data Analysis

LICENSES AND CERTIFICATIONS

LinkedIn Learning

Financial Foundations: Business Valuation, Financial Modeling and Forecasting Financial Statements, Python Essential Training, Python for Data Science Essential Training Part I, Tableau Essential Training

Skills Badge: Microsoft Excel, Python, QuickBooks

Contact this candidate