Ethan Johnson

Analyzed 252K+ retail transactions and 72K+ customer records in R to identify purchasing trends, segment performance, and growth opportunities. Used Python to evaluate 3 store-layout trials through uplift testing. Delivered a client-facing PowerPoint with visualizations and recommendations on promotions, pack sizes, multi-buy offers, and rollout strategy.

Analyzed product trends to support stocking, reordering, and shelf availability. Balanced 10 rotating responsibilities, including inventory review, donations, 240+ daily packages, and customer support. Troubleshot store hardware and software, resolving order, barcode, and inventory issues. Trained new hires on daily processes to improve speed, accuracy, and consistency.

Founded and managed a direct-to-consumer clothing brand, increasing customer engagement 60% through targeted social media campaigns and driving a peak of 718 monthly store sessions while maintaining a 3% conversion rate.

Led development and testing of a secure hospital appointment system using SQL and MS Visio, designing ER models and data flows and ensuring reliable handling of patient and appointment data.

Built a data-driven endorsement scoring model using SQL and Python to rank NBA athletes by endorsement upside and delivered multi-page Power BI dashboards to inform targeting and brand opportunities.

Analyzed multi-year bike-share data with SQL and Power BI to compare casual vs. member usage, uncovering behavioral differences to inform membership conversion and targeted marketing strategies.

Grade: 3.83 GPA, magna cum laude

Activities and societies: Dean's List (2019-2023); member of Delta Sigma Pi (marketing, scholarship, recruitment, interchapter, finance, social committees).

Graduated magna cum laude with a cumulative GPA of 3.83 while completing coursework in information systems and decision sciences and making the Dean's List.