Data Warehouse MANAGER

Jan 2013 - May 2016

🎯primary objective

To collect, organize, normalize, warehouse, and manage all essential data on the thousands of wind turbine and solar panel components required to maintain our vast and varied fleet – both in various locations within our global SAP system and on our local Microsoft SharePoint servers

🛠️SCOPE OF WORK

🗄️ Data Collection, Organization, & Management

• Photographed all wind turbine & solar panel components required to service our fleet

• Collected all essential identifying information from all wind turbine & solar panel components required to service our fleet

• Honed, organized, and normalized this data into a cohesive, standardized dataset

• Integrated and managed this dataset into our global SAP Item Master as well as other essential isolated databases

• Created & maintained a searchable Parts Catalog in Microsoft SharePoint based on this dataset

🗺️ Process Management

• Created and managed a cross-functional New Item Request Process, which allowed me to capture photographs and data from new, never-before purchased components and integrate this information into various local and global databases – as well as to capture new identifying images and/or datapoints for materials already in our system

• Created and managed a cross-functional SAP Framework Agreement Process to ensure that, when purchasing any of these materials, the correct part was being purchased using the correct identifying part number(s), on the correct SAP Framework Purchase Agreement associated with the correct vendor at the correct price – a misalignment of which often resulted in a costly down turbine situation.

⚡IMPACT

The comprehensive dataset of wind turbine and solar panel components I created and managed enabled our company to source the majority of these materials from alternative vendors (other than the OEM), resulting in global, to-date savings in the hundreds of thousands of dollars

💻 Programs Used

• Microsoft Office (Outlook, SharePoint, Excel, Visio, Word)

• Adobe CS (Photoshop)

• SAP

• Formsite

👋🏽 ReasonS for Leaving

➜ I had mastered all the skills necessary to succeed in this role and was ready to seek new challenges for continued growth.

➜ The role transitioned from a creative, dynamic endeavor to a more steady-state position, prompting me to pursue opportunities better aligned with my strengths and interests.

➜ I had two young kids at home and the increasing traffic congestion in and out of Portland made the commute unsustainable, leading me to explore opportunities closer to home.

🧾 SUMMARY

Eager to contribute to the renewable energy sector, I joined Avangrid Renewables (then Iberdrola Renewables) in October 2012 on a contract basis. My primary objective was to build a comprehensive dataset of wind turbine and solar panel components across a diverse fleet—including equipment from GE (USA), Gamesa (Spain), Suzlon (India), Mitsubishi (Japan), and Siemens (Germany). This initiative aimed to standardize material identification beyond OEM part numbers, allowing us to diversify vendor sourcing and drive significant cost savings.

For several months, I traveled nationwide, gathering images and data from warehouses and wind turbines to create this dataset. Upon successfully completing the project, I was offered a full-time role as Data Warehouse Manager, responsible for integrating and managing this dataset within our global SAP Item Master and ensuring its accurate use across multiple departments and independent databases.

🔑 Key Contributions & Achievements

From-Scratch Dataset Development

Independently designed and built a comprehensive dataset comprised of all information available to uniquely identify the thousands of wind turbine and solar panel components required to maintain our fleet.

Data Integration & Global Cost Savings

I collaborated with our headquarters in Spain to integrate this unique and valuable dataset into the global SAP Item Master, co-managing its maintenance thereafter. This effort enabled our entire company, in addition to our US team, to expand vendor options outside of the Original Equipment Manufacturers (OEMs) – thus amplifying cost savings across the organization globally.

Cross-Departmental Process Development

I designed and implemented key processes to improve data integrity and streamline procurement:

• New Item Request Process:

This process allowed site personnel to identify unprocured components, triggering a structured workflow for verification, data collection, and SAP updates. This ensured database accuracy and eliminated duplicate entries.

• SAP Framework Agreement Process

This process standardized material data across vendor purchase agreements to prevent discrepancies that could disrupt procurement and lead to financial losses.

User-Friendly Parts Catalog:

Recognizing SAP's limitations for frontline technicians, I developed and maintained a searchable Parts Catalog in Microsoft SharePoint, significantly improving ease of use and adoption across teams. This initiative streamlined parts identification and procurement, earning strong user feedback.

Among my achievements, I take particular pride in the Parts Catalog, which exemplifies my ability to blend vision, creativity, efficiency, and user experience to enhance operational effectiveness.