Kerrie Smith

Knoxville, TN • 865-***-**** • ad0tck@r.postjobfree.com

Professional Summary

Driven professional with demonstrated success providing high-impact data analysis to ensure business continuity for customer-facing, product, and leadership teams. Spearheads projects from concept to close to drive positive business outcomes, increase visibility, and automate workflows. Champions proactive approach towards data visualization initiatives, developing scalable solutions that encourage cross-functional collaboration efforts and centralize IT functions. Extensive experience architecting data flows and data warehouses in Microsoft SQL Server and Azure Data Factory.

Core Competencies

Data Analysis Report Tracking and Automation Process Improvements Cross-functional Collaboration

User Engagement Business Intelligence Data Visualization Quality Assurance

Training and Development Server Management Product Management Detail-oriented Project Execution

SQL Servers ASP.Net C# ETL Power BI Tableau Workday SOAP Salesforce Restful API

Software Development Lifecycle Microsoft Azure Data Factory Python

Azure DevOps Git Software Development Lifecycle (SDLC) Agile/SCRUM

Career Highlights

Highway Transportation Logistics, LLC – Knoxville, TN April 2016 – August 2023

Data Warehouse Engineer (February 2018 – August 2023)

Progressed from Senior Programmer position to incorporate emerging technologies and create long-term technology roadmap that encourages cross-functional collaboration. Drove continuous improvement mindset to enhance data quality and implement automated solutions. Defined best practices for financial reporting, telematics mining, and data warehousing efforts. Managed data warehouse and SQL servers companywide.

Designed and introduced new integration system utilizing Workday Financials, modernizing financial systems and transitioning data into a cloud environment leading to a streamlined workflow.

Developed ETL packages from TMW, TMT, Omni telematics, and financials using SSIS to populate a Microsoft SQL Data Warehouse.

Steered vendor team to install Salesforce, improving management of customer interactions and communications.

Migrated period budget data into data warehouse, refining reporting processes and optimizing budget reporting.

Enhanced telematics mining and reporting processes from SOAP web services to REST API platforms to remain up to date with industry trends.

Skillfully incorporated metrics including telematics and product temperature data to trailer fleet, increasing visibility for drivers, team members, and customers.

Worked diligently throughout tenure to continuously eliminate outdated manual functions across multiple departments, refine operations, automate processes, reduce data entry errors, and elevate productivity.

Engaged in validating trailer and product temperature tracking data in conjunction with newly secured data from equipment on all trailers.

Participated in SCRUM/Agile Development activities as Engineer and Product Owner utilizing Azure DevOps

Senior Programmer (April 2006 – February 2018)

Championed process enhancements to centralize IT functions, improve reporting, and create systems that enable future growth. Architected Safety Alert System which automated notifications, photo storage, on-demand self-service reporting, HOS self-auditing tools, and violation management activities. Modernized user databases, payroll and staffing applications including driver pay grade increases and payroll detail integrations with ADP and Workday.

Converted numerous Access databases and ASP websites into one online portal to improve access for internal teams, customers, drivers, and partners by utilizing knowledge of ASP.Net.

Conceptualized and implemented new safety database and web application to effectively monitor safety incidents in compliance with DOT and OSHA protocols.

Propelled development of first fully online driver employment application comprised of DOT and FMCSA regulations, serving as the foundation for Tenstreet applications to adapt to ever-changing transportation requirements.

Solidified development of data warehouse by creating new costing data framework.

Established data-driven menus with management functions comprised of seamless functionalities to add items, access grants and e-mail notifications, provide detailed reports to users, and maintain data for application down-menu items.

Served a crucial role in transitioning HR and payroll functions to ADP to ensure smooth integration of employee data.

Constructed automated per diem system, additionally initiating automations for tank hazmat and periodic maintenance schedules.

Utilized detail-oriented mindset to identify data gaps between dispatch and telematics teams, automating 99% of company driver payroll functions and revising payroll processes to weekly payouts.

Additional Professional Experience

Application Programmer/Analyst, Dialink/Callbright Corporation

Phone Technician, Dialink Corporation

Engineering Technician, Elo Touch Systems

Education & Professional Development

Associate of Applied Sciences in Pre-Engineering – Ohlone College

Product Leader Certified

Certified in Product Management

Completed Project Management Essentials Course – New Horizons Computer Learning Centers

Contact this candidate