This project was completed using a very unattractive MS Access '97 client to provide a very customized solution that looks visually appealing. Extensive VBA was used to meet the requirements of this project that serves to automate the production tracking (while providing manual edit capability) for a division of 350 employees. This project outputs over 50 different types of reports via a custom reporting dashboard built into MS Access.
Much cleaner/beautiful databases can be designed today in Access 2010 with better links to external data sources, but this is a prime example of ability & willingness to stretch an application to its limits to meet the needs of a client. This has been in use for 5+ years and continues to be a valuable asset to the client.
I am an expert in MS Office Suites (Top 1% on eLance.com!), VBA, SQL, and automated solutions. I have over 11 years experience in designing technical solutions. I have led numerous projects, designed and implemented several databases, and I can stretch Excel to its limits.
In addition, I am customer-focused and driven to build solutions that focus on user-experience.
-Six Sigma Green Belt
-Advanced Business Objects Universe Designer
-Certified MS Excel E...