Alan Pauley: Office Technology Specialist in Torrance, CA

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.

Manage the database of prospects and applicants, a population of over 200,000 individuals, manipulating data structure to import from various sources. Create and run reports to analyze data and ensure marketing efforts are yielding the ROI aimed for. Run monthly regression tests, looking for errors or technical problems within system of record, People Soft, all while maintaining a keen eye for details and looking for ways to further improve operations while coordinating results with multiple offices. Oversee large projects with aggressive deadlines among many departments, vendors, and employees to ensure a seamless end product for the customer. Coordinate both hardcopy and electronic mailings to increase university reach totaling over 1 million communications sent annually to over 100 countries.