Leianne Fajutagana Email & Phone Number

Sacramento, California, United States

▪ Pumped Hydro Storage Python Model: • Improved code to optimize pumping plant operations.• Reviewed monitoring data, prepared data inputs, and created graphs of model results.• Documented changes in software for ongoing development & team collaboration.• Clearly presented code modifications and results to an audience of ~30 key stakeholders.▪ Excel VBA Scripting:• Wrote Excel VBA scripts to automate running Excel models that manipulate sophisticated data.• Created various scripts to meet coworkers’ needs: data cleaning, formatting, and calculations.▪ R Volatility Code Maintenance:• Maintained R code (that calculates price volatility) to improve functionality and user experience.• Wrote a technical user guide that included step-by-step instructions and troubleshooting.• Conducted a training session over Microsoft Teams to instruct coworkers on how to run the code.▪ Monthly Energy Report & Highlights:• Summarized monthly operations in Excel and created a PowerPoint to present at monthly stakeholder meetings.• Clearly presented to an audience of ~30 people from various agencies over Microsoft Teams.• Sent out an email with report highlights to a distribution list of ~80 people. - Consistently met strict deadlines for report submission and highlights release.▪ Energy Roadmap Report:• Served as the primary editor; gathered and compiled content from colleagues into a comprehensive report.• Maintained consistent grammatical tense, spelling, references, and image/graph formatting. • Collaborated with the graphic designer and higher management to adhere to DWR branding & tone.• Selected photographic assets and graphs for use in the report.▪ Solar Panels Over Canals• Authored a whitepaper on placing solar panels over DWR canals, and gave multiple presentations to executive staff and external stakeholders.• Co-facilitated a workshop to identify key performance indicators for a $20 million pilot project.

Davis, California, United States

• Handled and prepared filter samples from about 160 field sites for sampling and post-sampling analysis.• Analyzed optical absorption of filter samples using the Hybrid Integrating Plate and Sphere (HIPS) equipment.• Prepared shipping arrangements, confirmed mailing costs, and filled out international delivery forms.