Bill Grogg

Programmer Analyst @Public Utility Commission, State Of Oregon

Salem, OR, US

Public Utility CommissionInformation SystemsKey Achievements:o Designed and developed a cutting-edge, secure application framework in Microsoft Visual Studio.NET and C#.o Introduced spatial data into the agency\'s SQL Server environment along with geographic reporting and automated address geocoding through a State web API backed by Esri\'s ArcGIS services.o Designed structured organizational reporting security and implemented an enterprise-wide reporting solution based on Microsoft SQL Server Reporting Services (SSRS).o Created an ETL process to import and convert federal government data from Excel spreadsheets into Microsoft SQL Server and then provided access to the data from SSRS to streamline data analysis for the Utility Safety, Reliability and Security Division.o Designed, developed, and implemented a new system to track investigations of possible violations of excavation laws for the Utility Safety, Reliability and Security Division and the Oregon Utility Notification Center. The entire project from concept to deployment was just a few short months in duration.o Designed, developed, and implemented an immutable audit log solution to meet the required controls of the United States Social Security Administration (SSA) for handling of SSA-provided data.o Designed, developed, and implemented automation to bring in data from DMZ-based servers to internal servers for processing.o Quickly rewrote an entire SharePoint-based intranet site as an ASP.NET MVC web application.Responsibilities:o Provide complete solutions and software development services for use throughout the agency.o Lead efforts to formalize standards and processes around the Software Development Lifecycle (SDLC).