Brent Smith Email & Phone Number

Lexington, KY, US

Lexington, Kentucky, US

Analytics Engineer in charge of original development of analytics pipelines using dbt core to transform data from disparate sources to data structures suitable for consumption by reporting tools (Power BI and Apache Superset). I am involved in every aspect of this effort - administering and developing on multiple data platforms (PostgreSQL, Azure SQL.

Lexington, Kentucky, US

Subject Matter Expert in PostgreSQL cloud database administration and performance tuning within AWS RDS and within Azure.Performance consultant advising application teams how to improve performance with query optimizations and improved database design.Spearheaded the initial use of Azure Data Factory within the company to perform data orchestration and.

Lexington, KY, US

Database Developer specializing in data warehouse ETL design and development. Developed procedures and processes to manage full and incremental loads of data from on-premises databases to Azure SQL Data Warehouse using Azure Data Factory v2 pipelines to coordinate movement of data.Automated complex business processes by creating workflow packages using.

Paris, Kentucky, US

Automated the processing of customer EDI documents, including:Discovering and documenting requirements;Designing the database schema; Creating T-SQL queries and stored procedures to process the data;Implementing SQL Server Agent jobs and SSIS packages;Working effectively with company executives, business analysts, and financial department users.Developed.

Converted agency from paper based renewals to 100% online renewals. Worked with contractors to design web site flow for renewing a license online. Completed the project on time and within budget. Reduced the license renewal processing time from three months and five people to fully automated and real time. Designed, developed, implemented, tested, and.

Analyzed, fixed, and optimized complex T-SQL stored procedures used to drive daily business reports. Worked to resolve trouble tickets from users. Maintained backups for domestic and offshore SQL Server databases. Upgraded database server software. Researched and chose hardware for server upgrades. Coordinated with the infrastructure team to reduce downtime.

Wilmington, Delaware, US

Designed, developed, tested, and deployed a data warehouse for customer invoices. Converted historical invoices from FoxPro to SQL Server 7, and later upgraded to SQL Server 2000. Wrote a garbage collector in Visual FoxPro that implemented a dummy delete process to reclaim space within the database files that were approaching a 2GB size limit. This kept.