This position was a change of scenery for me in multiple regards as it was my first experience in marketing, in an analytics team, and in the sports industry. Lining up with my personal passions, it was clear from the beginning that it would be a watershed in my career. It was my first exposure to working on analytics projects and to marketing, and while I learned the ins and outs of both, my contributions primary leveraged my relational database and VBA scripting experience.Early on I identified that we had a data problem, with our digital marketing data failing to lend itself to connecting across sources or to segmentation by its qualitative attributes. The solution I developed to address both was standardization of our digital campaign names. In order to implement the standards and ensure consistency in campaign names that would be created by several team members, I developed an MS Access-based form application to automatically generate campaign names that could later be parsed into separate data columns for campaign reporting and analysis.With greatly improved data quality, I was able to build out a local database that could connect and perform ETL on our disparate digital marketing datasets, dumping the cleaned data into Excel dashboards I developed to replace manual marketing reports. This process still had manual components and was constrained by MS Office and PC computing power limiting it to monthly cycles, but would serve as the blueprint for true automation of our marketing data leveraging a central database.

In this position I was half of a two-person team responsible for managing the pricing of a $1.5 billion portfolio of over 300,000 Mercedes-Benz passenger car and Sprinter van parts. My primary objectives were to achieve target revenue increases and to maximize MBUSA's market share of the Mercedes-Benz parts business by offering competitive prices.In order to achieve these goals, I implemented price changes based on analysis of historical MBUSA pricing and sales data, as well as competitive industry pricing data. When implementing pricing strategies with high exposure, I would present a business case summarizing the need for price repositioning, as well as opportunity and risk to revenue and profitability.While my primary method of impacting the Mercedes-Benz business was through the pricing of high volume wholesale parts, I also made it a priority to target vehicle owners directly. Two ways in which I did this were:• Decreasing prohibitively expensive part prices for older Mercedes-Benz vehicles to reduce total loss insurance claims and keep vehicles in operation• Decreasing prices of parts that are tangible to the customer and influence the customer's perception of value in Mercedes-Benz partsHere were some of my accomplishments:• Achieved 2014 target revenue contribution due to price within 0.02%• Improved consistency of Mercedes-Benz parts pricing by identifying related parts and matching prices, including more than 8,000 supersessions• Reversed trend of years of cost-plus pricing by re-calculating prices based on vehicle value• Created the first MBUSA pool of 1500 collision parts eligible for discount and developed a discount formula in order to convert aftermarket part sales to Mercedes-Benz sales in insurance vehicle repairs, generating $462,000 in additional revenue in the first 5 months at 1.8% cost• Reduced MBUSA warranty expenses by applying 12% smaller price increases to warranty parts in 2014 than in 2013

I was hired into this position to perform simple tasks such as keeping records of technical inquiries and posting web documents, though as I developed my technical skills and parts knowledge I greatly expanded the scope of my role. After a few years I rewrote the Coordinator Parts Technical job description to accurately reflect my additional responsibilities, including part research, database design, data analysis, development of training materials, and execution of various department projects.Two years into this job, the Electronic Parts Catalog (EPC) specialist in our Parts Technical team left for another position. Despite still being the most junior member of the six-person team, I assumed the role as the EPC subject matter expert responsible for improving its integrity by identifying and reporting errors to Daimler AG, flagging them in the catalog, and tracking the error correction process from start to finish.To improve department recordkeeping, I developed a deep knowledge of Access, and created two databases with form interfaces to facilitate data entry and extraction. I also used macros and VBA programming in these databases to automate data imports and monthly reports, saving countless man-hours over the years.As part of an effort to develop EPC training for dealer personnel, I learned to use Adobe Captivate to create software training slideshows. Between 2009 and 2013 I created eleven 20-30 minute training modules, directing the audio recording and animating screens of the software to simulate a live personal walkthrough of the system.To add a valuable resource for the Parts Technical team, in 2009 I collected data for over 600 Mercedes-Benz models dating back to 1946 and created a database with a search application interface to cross-reference vehicles by technical specifications. I continue to update this database annually and used it in 2014 to update a promotional Model Information Chart that is available to Mercedes-Benz dealers.