Rowan Rishe

Electric Estimating Intern @National Grid

Syracuse, NY, US

Database Management: Developed a system to pull macro and compatible units from construction standards documentation, matching SAP IDs and quantities using STORMS and various SQL queries. Created models and assemblies for these units in the NY-Electric Database, allowing estimators to select upon them based on various specifications and ratings.SQL, Server Management, Report Generation: Utilized Snowflake Cloud Database and SSMS to run SQL queries on the NY-Electric Database and collect data for report generation.Python Scripting, Programming with API’s: Wrote Python scripts that pull forecast data and past weather data using the NOAA API and run calculations on it. This will provide estimators with scope on weather patterns that will impact future projects and contribute to their risk analysis.Excel Power Query & VBA Modules: Enhanced Excel workflow using Power Query and VBA to extract and consolidate project estimate data from PDFs, with features to prevent duplicate processing and maintain dynamic file tracking.Excel Formulas & VBA Modules: Utilized Excel formulas and VBA modules to assign completion dates and production stages to project estimates. Assisted in the accessibility of information that estimators require to create accurate and timely estimates on multi-million-dollar projects.Power System Operation & Equipment: Shadowed operators at the central regional and transmission control centers, observing and assisting in the circuit switching required to de-energize when storms and 911 emergencies result in faults along the transmission and distribution infrastructure.

Clarkson University

Master of Science - MS, Electrical Engineering

Clarkson University

Bachelor of Science - BS, Software Engineering