Supply Chain Data

Todd Stover

*** ******* **** *** ******, GA ***** H: 404-***-**** C: 404-***-**** ********@*****.***

DBA/SQL Developer / Business Intelligence Architect

** ***** ** ********* *** Insurance related data analysis. Proficient in an assortment of technologies, including MS SQL Server, Business Objects, Crystal Reports, Xcelcius, Data Integrator, VB.NET, ASP.NET, C Sharp.NET, XML, Windows and Unix (complete list on request). DBA skills include:

SQL Server 6.5, 7, 2000, 2005, 2008, 2012, 2014 Database Administration

Performance Tuning & Capacity Monitoring

Data Security, Backup & Recovery

Standby/Failover Administration

SSIS/SSRS 6 years

ETL using SSIS, DTS, Data Integrator

T-SQL

Database-Backed Web Solutions

SQL Tuning

Experience

AmTrust Financial, Alpharetta, GA 09/2015- present 06/2012 – Present

Senior Software Engineer/BI Lead – Claims IT

Redesign AmTrust Claims Reporting, ETL, and acquisition data conversion process

Design, Create and maintain ETLs, Data warehouses, and Reporting Tools.

Created SSIS ETL Framework and package template.

Ownership of all SSIS packages for various sources and destinations.

The Home Depot, Vinings, GA 06/2012- 08/2015 06/2012 – Present

Senior Logistics Analyst – Supply Chain Distribution – Business Solutions

Analyze and present data for Home Depot’s Supply Chain

Design, Create and maintain ETLs, Data warehouses, and Reporting Tools.

Provide the Supply Chain with vital data analysis essential to logistics.

Written .NET web applications for various Supply Chain input and output needs.

Responsible for design of databases to drive new applications and data integration.

Ownership of all SSIS packages for various sources and destinations.

Design and implementation of an interactive map listing all Home Depot distribution centers and their vital stats using JQuery.

Standardized 100+ SSIS packages using underlying XML configuration files and parent package configurations.

Drive process improvements by replacing hard coded redundant applications with table driven web services.

Southern Insurance Underwriters, Alpharetta, GA 12/1995 – 05/2012

Database Administrator/Developer/Business Intelligence Analyst

Managed SQL Server database administration assignments for a large managing general agency. Enhanced database performance, performed restores, implemented recovery procedures, handled performance tuning and conducted regular system backups. Ensured technical and functional designs to meet business requirements.

Key projects:

Served as DBA or project lead in the completion of 20+ medium- to large-scale implementations, managing projects from business requirements, analysis to solutions, delivery and support.

Designed, created and maintained data warehouses for all of company’s systems of record.

Created universes on top off all data warehouses.

Created ISO reporting systems for two auto dealership captives.

Developed web service interface for importing policies/quotes into company’s invoicing/accounting system (AIM).

Established and tested storage strategies and disaster-recovery plan for large manufacturing company’s operational database, delivering solution that guaranteed recovery performance and high availability.

Created companywide flash dashboards using Xcelcius, XML, and Business Objects.

Written 300+ accounting reports before Business Objects system purchase.

Designed and created an entire premium finance management system, agency promotion management system, and agency statement management system.

Developed several XML and SQL based rating engines for personal lines insurance.

Education & Training

AUBURN UNIVERSITY, Auburn, AL

Bachelor of Science, Major in Computer Science

6 Microsoft SQL Server Administration Classes (2000-2003)

2 Microsoft ASP.NET Classes (1999-2002)

5 Business Objects Classes (2009-2010)

Contact this candidate