Programmer / Analyst
- Designed SQL server databases, queries, stored procedures and managed permissions. Automated business processes and reporting tasks. Created interactive Excel reports using VBA.
- Created application to monitor, log and report database usage and patterns for all databases that IT department supported, eliminating 71% of 496 databases that IT supported.
- Reverse-engineered legacy sales tax application by creating user interface that led user through sequence of well-defined step… Show more Designed SQL server databases, queries, stored procedures and managed.
- Reverse-engineered legacy sales tax application by creating user interface that led user through sequence of well-defined step to complete process, reducing workload of both IT and finance departments.
- Documented HP 3000 tape rotation and archiving procedures, which included instructions for daily and weekly tape rotation, month-end closing, in-house and off-site tape storage, tape labeling and drive-head cleaning.
- Created application to search code and objects across multiple access databases, allowing references to be discovered quicker to solve problems. Show less