AJ

Anna Johnson

Business Intelligence Analyst · Blue Ridge Power

Bend, OR

Work Experience

Business Intelligence Analyst

Blue Ridge Power

2023 – 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

Vestas

2021 – 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 Pepper

2020 – 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 & David

2016 – 2019

Managed all purchasing activity for packaging materials, an $18 million annual spend with around 45 suppliers and 1000+ SKUs.

Assistant Buyer

Default

2013 – 2016

Managed apparel and accessory replenishment from 120+ vendors for an ecommerce/brick and mortar retailer.

Education

BSc

University of Oregon

2017

Skills

DatabaseBusiness IntelligenceInternetSupply Chain and LogisticsLogisticsInformation TechnologyERP and CRMOperations, Monitoring and Software ManagementSupply ChainPurchasingBig DataProgramming