Derek D. Email & Phone Number

Eagan, Minnesota, United States

- Develop and execute complex queries using Microsoft SQL Server Management Studio to analyze data quality from internal and external sources.- Track tickets on ServiceNow system to communicate and resolve any issues on a daily basis.- Research, identify and analyze trends in complex data sets.- Categorize highly variant manually entered data to provide accurate and uniform product results- Execute tests for external clients and analyze results by querying data from SQL Server Management Studio- Implement GIS data to ArcGIS Pro relevant to products- Coordinate with technicians, developers and analysts to ensure proper results are recorded and discrepancies are resolved- Organize program data utilizing a range of products, including Excel and PowerPoint, for presentation to external clients and record keeping.

St Paul, Minnesota, United States

- Produce ad hoc reports and analyze data for business leaders across the agency- Maintain secure databases and extract data using SQL to generate daily metrics- Implement new and improved processes for multiple teams to better manage daily workload while recording efficiency and effectiveness- Develop automated workbooks utilizing Microsoft Visual Basic for Applications for ease of use- Track and collect consumer case data using Microsoft Dynamics CRM- Contribute to SharePoint for announcements, materials regarding operations, displaying reports and enhancing functionality- Train and educate team members to ensure an understanding of standard operation procedures applicable to positions and throughout the organization- Assist in special projects, maintenance and other submitted issues relating to desktop setup and support- Troubleshoot and reproduce issues with various technology devices for solving problems quickly or communicating clearly with internal IT to escalate for resolution

Shoreview, Minnesota, United States

- Managed hundreds of accounts to prevent or minimize loss on financed collateral facing conversion of ownership- Initiated outbound and receiving inbound calls to gather information on locations of vehicles, helping customers with their accounts- Worked with a team to track thousands of units in the United States that have been placed in storage yards, seized or confiscated and facing forfeiture- Created Microsoft Excel Workbooks and workflows to assist co-workers in gathering needed information from storage facilities and/or law enforcement agencies- Helped develop procedures in the Confiscation/Forfeiture process to minimize loss and worked with retained attorneys to finalize decisions- Improved old and created new documents with various document software including Microsoft Word, Adobe Acrobat Professional, for the team and other teams within the branch- Served as the first point of contact for any issues regarding IT to solve problems and troubleshoot to resolution

St Paul, Minnesota, United States

- Received, prioritized and handled multiple, simultaneous emergency and administrative phone calls for assistance- Multi-tasked by monitoring four or more computer screens, while efficiently gathering, prioritizing and documenting caller information- Responsibly transmitted public safety information effectively by radio and telephone- Received and entered information from law enforcement and emergency personnel over the phone and radio regarding subjects, property and events into local and national databases- Questioned callers in a timely, effective manner while making quick decisions with little margin for error in a fast paced environment with minimal supervision- Communicated clearly with co-workers and dispatchers in order to send the correct level of help- Effectively managed confidential information and maintained sufficient up-to-date knowledge of the responsibilities of all staff within the team

Associate Of Arts And Sciences - Aas, Air Traffic Controller, 3.57

Activities and Societies: - Air Traffic Control program within MCTC located at Flying Cloud Airport (KFCM) located in Eden Prairie.

Associate Of Arts - Aa, General Studies, 4.0

- General Education credits necessary for transfer