Anna Johnson
Business Intelligence Analyst · Blue Ridge Power
Bend, ORWork Experience
Business Intelligence Analyst
Blue Ridge Power2023 – Present
* Collaborate with teams across Blue Ridge Power, a full-service solar EPC, to improve processes and pursue key initiatives. The main customers in this role are the procurement and logistics teams, but service has expanded to sales, subcontract management, site management, and corporate communications teams. * Develop reports/dashboards in Power BI and Excel for wide audiences, including order/delivery tracking, project budget vs. spend, interconnection queue and labor market analyses, and more. * Define and document complex process flows and SOPs. Propose improvements to prevent data loss and maximize efficiency. * With the Director of Market Intelligence, research and create monthly intelligence reports outlining external market factors such as commodity pricing, transport metrics, industry news, and policy updates. * Accomplishments include: * Introduced a supplier scorecard and evaluation program for the procurement department, the framework of which was adopted by other business units within the company. * Created an exception report pulling data from multiple, messy sources (IFS, Intacct, P6, Smartsheets, and Sharepoint), condensing multiple long meetings among procurement and project management into one concise weekly session.
Buyer - Spare Parts
Vestas2021 – 2023
* Oversaw all purchasing activities for hydraulic, electrical, and motorized spare parts used in North American wind turbines undergoing service or repair through Vestas - a $20 million spend. * Successfully coordinated with a diverse supplier base, handling over 6,800 individual parts sourced from both domestic and overseas suppliers while maintaining dynamic, ever-changing master data in SAP. * Provided sourcing support for special projects, identifying opportunities, initiating RFQs, and controlling source of supply. * Collaborated closely with logistics partners to determine cost-effective and expedited shipping methods, navigating global supply chain constraints. * Within SAP, streamlined the order management process and implemented methods of tracking supplier performance.
Raw Materials Buyer II
Keurig Dr Pepper2020 – 2021
* Acted as the lead buyer on a team of three, overseeing procurement activities for packaging and ingredients at two high-volume coffee manufacturing facilities. Played a key role in launching and improving supplier relationships. * Collaborated cross functionally with logistics, production schedulers, receiving, QA, and AP to resolve exceptions and ensure smooth operations. * Created new SOPs for dispatching purchase orders, monitoring exceptions, and running inbound reports within SAP and Excel.
Buyer Packaging
Harry & David2016 – 2019
Managed all purchasing activity for packaging materials, an $18 million annual spend with around 45 suppliers and 1000+ SKUs.
Assistant Buyer
Default2013 – 2016
Managed apparel and accessory replenishment from 120+ vendors for an ecommerce/brick and mortar retailer.
Education
BSc
University of Oregon2017