Drew Mcelroy Email & Phone Number

Southfield, MI, US

Southfield, Michigan, United States

• Analyzed digital retail markets, industries, and strategies to identify best practices, strategic failures, and new opportunities for growth. Conducted in depth qualitative research, forecasting, and data analysis.
• Wrote and presented a LinkedIn webinar about common mistakes and success strategies for sellers on Walmart.com
• Gathered case studies to draft a competitor scan that identifies key learnings regarding digital shelf management, promotions, product activations, platform tests, and new product launches
• Analyzed top markets in Latin America in-depth to identify the fastest growing sales channels, product categories, retailers, and on-demand delivery operators

Novi, Michigan, United States

• Worked independently to originate new housing development opportunities by networking with property brokers, reviewing past and present land listings, and contacting owners of vacant or underutilized parcels. Carried.
• Negotiated a multimillion-dollar contract for the acquisition and development of a luxury condo community
• Created new tracking tools to streamline and standardize the Land Acquisition Team’s work flow, minimizing risk of miscommunication and improving information sharing across multiple work groups (Title, Legal, etc.)
• Developed and produced monthly reports to track key sales metrics in both target and active markets, providing the sales teams with holistic data to generate effective sales strategies

Hoboken, NJ

• Managed product category generating $42M in annual revenue, identifying new opportunities to drive sales through Walmart.com while maximizing assortment profitability. Developed merchandising strategies to increase.
• Generated comprehensive sales forecasts, emphasizing periods of high spending (including Tax Time, Back to School/ College, and Holiday) to plan promotions and inventory orders
• Developed a new pricing ladder based on market competition and pricing, utilizing the ladder to develop more profitable pricing strategies while improving the shopping experience for customers.
• Improved margin of top-selling imports by an average of 6.3% by renegotiating costs with top vendors
• Enhanced overall margin of core product category by 330 basis points and increased profitability by 380 basis points through new pricing strategies and better costing
• Increased revenue 4 fold by dynamically pricing top sellers, securing additional inventory, and managing the product assortment to quickly replace OOS items

Detroit, Michigan

• Analyzed residential sales trends and other market data to quantify the economic impacts of targeted neighborhood investments, emphasizing the positive impact on mortgage lending and homeownership rates
• Conducted interviews with current and former associates of the Land Bank to develop a how-to guide that will serve other American cities developing community investment and blight reduction initiatives
• Co-wrote a case study detailing the origin and economic impact of the Detroit Land Bank Authority’s home renovation and blight reduction program

Ann Arbor, MI

• Contributed to the creation of a new center for affordable housing at the University of Michigan, identifying resident needs, partnering with organizations with parallel missions, and creating an organization hierarchy
• Developed mutually beneficial partnerships with policy research and advocacy centers at the University of Michigan, enabling coordination and visibility of affordable housing services
• Created on-boarding materials so new students quickly learn industry trends, company mission, and project goals, minimizing required transition time between semesters

Greater Chicago Area

• Composed and uploaded over 300 new ads for local build of client’s Google Ads campaign, aligning messaging with client’s campaign goal of increasing in-store traffic and maximizing campaign revenue, resulting in 7.5:1.
• Overhauled 2 pre-General Data Privacy Regulation LinkedIn campaigns by writing 4 new ads, selecting audiences, and setting budgets, generating a 2.7% increase in conversion rate while decreasing cost per conversion by.
• Managed 14 accounts by monitoring key performance indicators and fixing rejected ads and broken links, producing a higher quality score and click through rate
• Generated 4 weekly campaign reports using Google Analytics and Google Ads to track ad conversions, impressions, and cost per click to deliver comprehensive reports to clients

Sydney, Australia

• Developed product diversification and gamification template, informed by industry data and psychological motivation frameworks, improving user experience and customer retention
• Utilized Google Adwords Editor and Facebook Blueprint to monitor active campaigns, removing outdated and irrelevant ads to reduce marketing expenditures
• Examined search terms linked to sponsored search results, adding irrelevant terms to a negative keywords list, improving salience of all paid search campaigns

Downtown Detroit

• Systemized vendor contracts by important terms such as expiration date, price, and insurance, compiled 200 Certificates of Insurance to discover construction and injury liabilities, shielding the company from potential.
• Redesigned emergency response reference documents, establishing communication and responsibility hierarchy in event of emergency
• Coordinated replacement for electric car charging stations in 4 employee parking garages, upgrading customer amenities and encouraging electric vehicle use

39533 Woodward Ave., Bloomfield Hills, MI 48304

• Explored new development opportunities by scheduling property tours, accessing public records, and analyzing comparable projects, presenting recommendations to the CEO
• Developed conceptual construction budgets, contacting suppliers to receive material and service quotes, reducing overall costs of development
• Prepared 30 years of company documents for proper disposal by removing sensitive information, contacting recycling company to provide secure recycling bins, making additional property square footage available for lease

Farmington Hills, Michigan

• Tutored nonverbal, special needs individual for 3 years, aiding the development of fine motor skills, coordination, and meaningful communication techniques, teaching him gestures and software proficiency to express his.
• Researched software and exercises to develop lesson plan for conveyance of emotions and desires, forming streams of communication between individual and caregivers

Master Of Science - Ms, Real Estate

Bachelors Of Business Administration, Business Administration And Management, General, 3.6/4.0

Activities and Societies: • Minor in Entrepreneurship • Director of Community Relations, Out for Business • Marketing and Event.

3.883/4.000

Activities and Societies: Rapporteur for Model United Nations, member of Future Business Leaders of America, and member for Campus.

High School, 4.0/4.0

Activities and Societies: Eagle Scout Rank in Boy Scouts of America, Students Against Destructive Decisions President and Vice President.