Marketing Analyst, Financial Officer

Gautam Nagpal *****@******.*** • 267-***-****

https://www.linkedin.com/in/nagpal-gautam/

**** ***** ******, ************, ** 19104

Education:

Drexel University, Lebow College of Business Philadelphia, PA Bachelor of Science in Business Administration Expected Graduation: June 2023 Major: Marketing and Business Analytics Minor: Sports Management GPA: 3.41

● Dean’s List, 2019-Present A.J. Drexel Scholarship 2019-Present Drexel’s MVP - Men’s Squash, 2019 Professional Experience:

Diggs Pet New York, NY

Marketing Analyst March 2022- June 2022

• Analyzed data from 100,000 users every month, and used insights to guide marketing and product development strategies

• Designed and incorporated custom Excel Worksheets and Power BI dashboard to track, analyze, and capture inaccuracies resulting in over $1M growth in 3 months

• Maintained and analyzed marketplaces like Amazon and Walmart, resulted in an increase of customer traffic by 40%

• Ascertained changes to assortment and marketing using behavioral and financial analysis enabling company expansion internationally The TO Show Philadelphia, PA

Marketing Intern January 2022 – March 2022

● Planned and prepared advertising, promotional material to increase sales of products and services, coordinating with customers and departments

● Identified, developed, and evaluated marketing strategy, based on knowledge of establishment objectives, market characteristics, cost, and markup factors

● Gathered data on consumer opinions, market research and collaboration with sports professionals Fair Lighting Products Pvt. Ltd. New Delhi, India

Marketing Intern December 2018 – September 2019

● Created quarterly and annual financial statement amounting to $70,000 and implemented Excel Macros for automating tasks such as word processing and Power BI for graphical representation of the same

● Developed marketing strategies to manage accounts and invoices, social Media Marketing strategies were implemented and resulted in addition of 439 new customers in the 3-month beta testing stage

● Initiated tasks associated with generation of a centralized customer review database using MySQL Co-Curricular Experience:

Organization of Intramural Sports Event Philadelphia, PA Deputy Head of the Event Management September 2021 – Present

● Organize and officiate games with a total of 112 teams participating in 20 sports events and competition

● Enforce fair play practices and judicating misconduct claims

● Co-chair committee meetings and pre-game briefings and delineated tasks to the volunteers to minimize scheduling conflicts Drexel Recreation Center Philadelphia, PA

Equipment Window Assistant June 2021 – Present

● Maintained discipline on fitness floor, basketball court, and recreational facility floor through policies and regulations enforcement

● Utilize expert skills on Fusion software & Excel to complete inventory ledgers and equipment log

● Demonstrated management skills by creating a safe/welcoming environment for all students and community members Academic Projects:

MarketPlace Simulation September 2020 – December 2020 Assigned Position and Role: Chief Financial Officer

● Collected research data by reading academic publications, financial market reports, actively following institutions such as NYSE, WSJ, FT etc., and by participating in Mock Stock Market competitions

● Based on research, established paper trading accounts, and conducted simulations which explored different assets classes and documented their key performance metrics

● Managed marketing strategies for increasing client base Skills:

● MS Office Suite (VBA and Macros)

● Attention to detail

● Power BI

● Statistics

● Google Analytics

● MySQL

Extra-Curricular Activities:

Assistant Marketing Director, Drexel E-Sports Marketing Committee, Drexel DISHA Marketing and Recruitment Committee, DAC Pack

Member, American Marketing Association Member, Drexel Sports Business Association

Contact this candidate