Creating specifications, user cases. Testing output, data automation.

Report preparation, ad-hoc requests. Data bases and system development. Create systems that make it easier for people to work with and understand their dataAccess, Excel, VBA programming, Oracle, SQL Server, and MySQLCreate financial and production reportsProject ManagementMake and maintain Access databasesdata stream automationstandard and ad-hoc reportingproject, budget and expense trackingData analysis and data system documentationTeach Access and Excel capabilities to my co-workers and answer technical questionsExecute inter-team system projects, so others can be more effective at their own jobsHIPAA trained

In Pavement ManagementIn charge of the Pavement Management System (an Asset Management tool)Worked with upkeep of the system, improved data entry, and data QC/QAUpdated system data, interfaced with GIS, and created Access database interfacesOn the subcommittee to negotiate with our Pavement Management System vendorAssisted with the annual District Resurfacing contracts, from inception to completionIn Project ProgrammingTracking of project data, financial analyses and reporting of project data Access and Oracle databasesResponsible for taking complex data and presenting it in easily understandable formats for internal and external audiencesProject ManagementResponsible for the creation of the Ten Year Plan and State Transportation Improvement Plan (STIP) reportsInterpreted Federal regulations and integrated those requirements into our systemsManaged the Congestion Mitigation and Air Quality (CMAQ) and Statewide Planning and Research (SPR) special studies selection programsContinuous process improvement for our databases to add new features and to improve the data entry process and data accuracyAssisted in the development of our Data warehouse and fixed bugs the consultants missedCollected and reported project data, including ArcView maps, for the Project ManagersSupervisory experience included up to six peopleIn TrafficReviewed Traffic Impact StatementsCreated Traffic Analysis ReportsAssisted with the Traffic model and created traffic mapsDeveloped systems to analyze trends and spot outliersCreated many Access databases to increase the availability and accuracy of traffic dataExamples of these include a database to replace the microfiche for traffic countsCreating a database that turns an average daily traffic count into estimated hourly countsCreating a database that helped turn a week-long process into a few minutes processSupervised two people.