Spencer Franklin Email & Phone Number

Texas, United States

Dallas, Texas, United States

Addison, Texas, United States

Dallas/Fort Worth Area

Identified safety concerns and raised them to the Safety Management Systems (SMS) groups. Briefed concerns and trends to senior leadership with mitigation strategies.Developed, maintained, and published Tableau dashboards and data visualizations for each ASAP program: flight, maintenance, dispatch, and cabinImplemented corrective actions with operational groups, labor partners, and regulatory agenciesCategorized and trended pilot submitted ASAP reports using airman knowledge, company SOPs, and navigation data

Dallas/Fort Worth Area

Lead developer and program coordinator for Intelex EHSQ system implementationCreated and maintained dashboard / dataset for tracking SMS barrier effectivenessPerformed monthly oversight analysis of Service Difficulty Reports; presented to FAA as required in OpSpecsDeveloped Alteryx data workflow to download, cleanse, and transfer Error Correction data to database for use in station dashboardAnalyzed vendor quality data during Supplier Business ReviewsWrote SQL queries to pull safety report data for use in SMS

Fort Worth, Texas

Conducted compliance investigations and coordinated with various department directors for corrective actions. Defended actions to FAA inspectors.Performed Quality Assurance during supplier auditsLead program for Quality Assurance checklist consolidation; from 1300 questions to 500Developed standardized process for changing checklist questions with consolidated manual references

Stillwater, Ok

OSU Police Department IT Support Specialist and Public Service Officer:Tier 1 support for departmental employees; addressed issues with desktops, servers, OSU web services, etc.Assisted departmental employees with the operation of enterprise software and answered questions relating to OSU services.Escalated issues to OSU IT Helpdesk as needed. Served as point of contact for the police department with other OSU IT-affiliated personnel.Served as a public safety officer and assisted uniformed officers with issues and calls throughout the day. Assisted the department as needed with special events, motorist assists, and general public safety.

Stillwater, Oklahoma

Phone Agent for OSU IT Helpdesk:Diagnose and repair issues with OSU-affiliated web services.Work with different departments to coordinate responses to customer questions and issues.Assist in the development of ticket processing and resolution.Serve as point of contact for the different departments under the Information Technology umbrella.Contribute content to the OSU 4Help technical assistance website.