Craig Olsen Email & Phone Number

Administrator of an Enterprise Asset Management System: Infor Public SectorProvide day to day technical support for our maintenance and operations team within Public Works Sewer Division. Provide spatial/data analysis and reports in support of Sewer Maintenance and Operations, utilizing Microsoft SQL Server Reporting Services, Power BI, Crystal Reports, ESRI. Database administrator for various applications that support our business utilizing Microsoft SQL Server.

Supervised student intern for conversion of sewer billing reports. Development of business processes; for optimizing scheduling, workflow processes, and asset management business rules. Project manager: for conversion of Pretreatment access database system, restructuring of the windows file structure for the sewer utility maintenance and operations division. Perform analysis and recommendations on program strategies for performing maintenance and operations of the sewer utility assets. Development of reports for assisting management and staff on the current status of our programs/services utilizing Microsoft SQL Reporting Services. IT Project Manager for Sewer Billing Senior/Permanent Disability Discount Program. System Administrator/Database Administrator for Infor Public Sector enterprise asset management software. IT Liaison between Public Works and Utilities and Information Technology Department. Provide application support on county developed applications that support Public Works and Utilities. Provide Business Analysis on IT projects for Public Works and Utilities.

Administered asset management software that is used in day-to-day operations and provided ad-hoc reporting utilizing various database platforms. Performed spatial analysis, and developed maps utilizing various ESRI technologies. Developed data collection processes and applications for field data collection. Performed various database administration tasks, including transferring of data from various sources, database backup, data recovery tasks, and system performance monitoring utilizing Microsoft SQL Server. Advised and consulted with software’s vendors for improvements and customization of software to match business functions of the organization. Provided analysis of workflow processes and developed procedures for incorporating into software applications. Developed and conducted trainings on various software applications.

Newport, Wa

Performed road surface condition rating, Data management of roadway data, developed SQL Reports, assisted in performing topographical and construction Surveying, Worked on a team to divert a stream for fish passage during a bridge installation and installing a new precast concrete bridge , assisted Public works in addressing new homes for 911 and assessors, assisted in performing traffic analysis studies, and assisting new home approach approval process.

Assisted in pavement surface condition ratings, sql report writing, traffic analysis studies.