Oakland University

Market Analyst at Magna International

Detroit, Michigan, United States

- Japanese & Korean OEM/Country Business Development Models: Collect data, analyze and develop reports that summarize regional automotive market data for automotive production, sales, customer strategies, and company position in the market. Ensure that vital customer and industry information, requirements, and related content is maintained and distributed as necessary.- Global Sales and Capital System Support: Provide support in running reports, doing program and customer specific analysis of sales data, and work with groups to make necessary corrections and adjustments.- Global Mapping Tool: Developed a global mapping tool to help Magna better understand the competitor landscape, OEM customer footprint, and also Magna's own locations (>400 globally). Perform buffer and aggregation analyses to identify opportunities and threats for obtaining new business as well as maintaining current business. Traveled internationally to train over 50 colleagues who I continue to support. Maintain and publish data to Portal using Esri's ArcGIS software suite.- Market Share: Created a template to track Magna and competitor market share by product segment. Products range from door handles and outside mirrors to powertrain components and complete seat assemblies. Collaborate with global sales lead across 7 Magna groups to upkeep data.

Magna International

Market Analyst

- Research performance fuel pump market (sales trends, competitors, etc.) to determine if business opportunity exists for Delphi to expand its product portfolio.- Gather data and construct competitive stocking matrices to better understand customers.- Reduced a data transfer process by 30 minutes by reconstructing a spreadsheet with various formulas and macros through Excel to automatically format and calculate data as needed.

Delphi

Marketing Intern

- Responsible for the marketing, promotions, and game-day customer service and in-game operations of Division I Oakland University athletics.- Planned promotional in-game giveaways, games, and themes to help draw new fans and retain current fans.

Oakland University Athletic Department

- Researched and contacted vendors for various work related processes such as outsourcing.- Used Google Analytics to track visitors, measure conversion rates, and track A/B testing for website alterations.- Created Google Adword campaign to increase visibility of company’s website.

Tyler Drabek