◆ Home

◆ Recommendations

◆ PDF Resume

◆ Word DOC Resume

◆ LinkedIn

◆ STAR

Wayne D. Roesner

Creativity/Innovation
Generating creative solutions that were implemented and made an organizational difference; questioning traditional approaches to work; accepting and encouraging the innovation of others.

Situation:	Users complained about the Martin Engineering Reporting System (MERGS). It was difficult to use, understand and sometimes took hours to get a report out of. Outside users would have to call in to have someone run the report and email it to them.
Task:	Investigate a way to provide accurate, timely and secure information to all users both inside and out.
Action:	I went through a multitude of inside and outside users to define their needs. I went through the data that was available in the current system and determined how that information was collected. I designed a database that would store all the information. I designed and wrote the T-SQL to integrate the data from many servers/systems into the database. I designed a website to display the data. The T-SQL is generated on-the-fly using PHP.
Result:	Users now securely access data instantly, accurately and timely via the web with sorting and filtering capabilities. Since some of the users know SQL, I even provide the SQL that generates the data, on the bottom of the web page.