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, Azure Databricks), designing the final schemas, and creating reports.Python programming using APIs to automate data intensive processes. Developing tools and processes to streamline data engineering from disparate customer data to unified end user reports that add value and provide timely business insight.

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 integration.Conducted Proof of Concepts (POC) to demonstrate and evaluate data migration solutions. Assisted with execution of data migration plan to transition all databases from AWS to Azure.

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 SSIS to efficiently move, transform, and integrate data from disparate sources including Oracle, SQL Server, MS Excel, CSV, JSON, and XML. Created tests and quality assurance queries to verify daily loads. Reconciled legacy reports with new results.Improved daily ETL performance from four hours to 30 minutes. Optimized the Azure SQL Data Warehouse to improve load and query performance.Developed logic apps to start and stop the Azure DW during non-business hours using Azure’s REST API, saving the business thousands of dollars each month. Solved service principal security configuration problems to make this automation work.

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 automated data transfers and transformations for the “growing operations” system, this allowed us to continue using the in-house software system for another season and saved money and extensive effort.

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 maintained backend web services and databases. Created and maintained reports using SSRS and Telerik Reporting. Wrote advanced SQL queries and stored procedures for ad-hoc reports. Designed, developed, maintained, upgraded and administered the agency's SQL Server Database instance. Starting with SQL Server 2000, upgraded to SQL Server 2008, 2012, and most recently to SQL Server 2014. Developed databases for internal and external (public) use. Programmed stored procedures, user-defined functions, and queries using T-SQL. Optimized and maintained indexes and queries.Designed and created our agency front-end website using Visual Studio, HTML5, CSS3, Javascript and ASP.NET WebForms. Developed database driven “Searchable Roster” for looking up licensees. Developed other database driven applications using ASP.NET WebForms that allow people to apply for licensure online - increasing efficiency, reducing paper, and reducing overall processing and wait time.Designed, developed, tested, deployed, and maintained our in-house database management client using SQL Server, the LLBLGenPro ORM, Visual C#, and the .NET Framework. Currently at version 4.5.2. Upgraded this client from Visual Basic 6, COM+, and SQL Server 2000.

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 the company’s premier customer history system working as required by 700+ stores and 4,000+ daily customers.