Business Intelligence Analyst; Access/vba Developer
Developed a site-wide Metrics tracking and reporting system for the NASA White Sands facility, using MS Access & VBA. Project encompassed 8 departments with over 100 reports and growing. Utilized solid design and best technology to quickly create solutions that met immediate needs, yet are flexible enough to grow with business.
- Planned, developed, implemented and administered for the acquisition, storage and retrieval of data for a variety of databases that support the programmatic and administrative functions of this system.
- Collaborated with department managers to determine functionality requirements, resolve data quality issues, and improve the quality of the source data. Analyzed and defined data requirements, specifications and procedures; planned for and anticipated changes in data capacity requirements, and evaluated new technologies and architectures.
- Worked with the Health & Safety department manager on the design and implementation of a database driven web portal for monthly check-up reporting, using VB.net and ASP.net.
- Extracted data from Maximo and Remedy for storage and reporting into custom SQL data warehouse. Built VBA UDF's (user defined functions) for conversion of Julian dates (ddd/hhh:mm:ss) for use across applications.