Started role mid-data migration from one database (Inteum) to another (Sophia). Quickly assessed situation and took charge to ensure a smooth transition with minimal data errors over the span of less than 2 months. Quickly learned SQL on the job to bring office up to speed with reporting needs. Have written upwards of 300 custom reports used for reporting internally, as well as externally to high profile end users such as USC Deans and the President’s Office. Single-handedly perform data audits regularly to find missing and bad data. Coordinate efforts to correct data and conduct office-wide training to 15+ individuals and a regularly rotating staff of interns to ensure correct data input into the database. Create documentation and flowcharts for office and conduct regular training sessions to entire office staff. Oversee and manage database of technologies, patents, licenses, and inventors – totaling over 100,000 person records, 30,000 object records, and revenues and expenses totaling upwards of $100 million. Manage Online Invention Disclosure portal – troubleshooting errors, setting permissions, and keeping an eye out for areas of improvement. Spearheaded effort to modify process to allow for better customer service and quicker turnaround, all while maintaining the highest level of security. Communicate regularly with staff, sister institutions, and database host to ensure that all needs are being met, all issued and enhancement suggestions are being addressed, and that our office stays on the cutting edge of technology solutions.