Microsoft SQL Server
Brett Walker
Database Architect / Developer
Franklin,Tennessee
Summary
An experienced IT professional specializing in Microsoft SQL Server; focused on T-SQL development including stored procedures, query tuning, server tuning, database architecture and design, SSIS, and SSRS. Experience managing teams of developers, DBAs, and BI/SSIS developers.
Overview
22
22
years of professional experience
Work History
Senior BI Developer
Trexis Insurance
Franklin
11.2022 - 05.2024
- Developed and maintained complex SSIS packages
- Developed T-SQL code (stored procedures, ad-hoc queries, etc.) to efficiently respond to business needs
- Created CSV files using T-SQL to load an AgentSync Salesforce database
- Implemented Git source control for Business Intelligence SSIS packages
- Implemented Red Gate SQL Source Control for SQL Server databases
- Developed SQL code on AS-400 with IBM DB2 and RPG.
Senior Developer
HealthStream
Nashville
08.2020 - 10.2021
- Developed and maintained SSIS packages to generate reports and .txt files for delivery to customers
- Developed and supported SQL Server stored procedures to retrieve data used by SSIS packages described above.
Database Engineer
Sovereign Sportsman Solutions
Nashville
12.2019 - 03.2020
- Developed SSIS packages in SQL Server 2016 to process hunting and fishing license extracts and FTP them to the client for processing
- Deployed SSIS packages to production
- Developed complex T-SQL stored procedures, views, and ad-hoc queries in SQL Server 2016 to determine eligibility for hunting and fishing licenses
- Configured and implemented log shipping in SQL Server 2016
- Developed a database diagram in TOAD from the existing database which was contractually required as documentation to be delivered to the client
- Developed and supported stored procedures in SQL Server 2016 to load the legacy data as well as write SQL scripts to correct production data issues
- Wrote ad-hoc queries to assist users with database questions and data anomalies.
Solutions Architect
AdhereHealth
Brentwood
04.2018 - 12.2019
- Developed the architecture for a new Software as a Service (SaaS) application using SQL Server 2016
- The application housed multiple clients, was user configurable, and used a common code base
- Developed SSIS packages in SQL Server 2016
- Developed stored procedures to determine CMS Star ratings
- Developed data flow diagrams for existing applications and systems
- Generated database diagrams of existing databases
- These diagrams improved the understanding of database objects and the relationship between them
- Managed the stored procedures, views, and ad-hoc queries to refactor a major application
- This refactor enhanced performance, improved maintainability, and increased overall accuracy of the application
- Implemented git source control for C# code, SSIS packages, and SQL Server stored procedures, etc.
Database Team Lead
Cigna Healthspring
Nashville
07.2016 - 04.2018
- Maintained SSIS packages and T-SQL stored procedures in SQL Server 2016 that processed claims data for CMS Risk Adjustment Payment System (RAPS)
- Designed synchronization process which synchronized data modifications on a production OLTP server to a dedicated report server
- Responsible for the overall architecture of the process and database design
- The sync process was developed in SSIS and stored procedures in SQL Server 2016
- Researched performance problems and determined potential improvements related to stored procedures, indexes, application architecture, and data hygiene
- Developed and modified functionality, fixed bugs, and improved performance
- Reverse engineered existing databases to better understand current database design
- Used resulting model to determine and propose improvements in architecture.
BI Developer
Community Health Systems
Franklin
07.2015 - 07.2016
- Developed accounting and financial reports (income statements, balance sheets, etc.) using SSRS and SQL Server 2008 R2
- Designed the database tables and stored procedures for use in processing the reports
- Developed reports in SSRS
- Worked on a project that allowed the accounting team to create customized reports for the business user that would have taken months if developed in the corporate accounting system.
BI Developer
Deloitte, Electronic Discovery Division
Nashville
05.2015 - 07.2015
- Analyzed electronically discovered data to be used by legal counsel in court cases
- This included reviewing hundreds or thousands of documents (emails, Word Documents, mobile device information, etc.) for specific words, phrases, and/or patterns
- The criteria for pulling the data from these documents was extremely complex and required advanced T-SQL code and techniques
- Analyzed existing database looking for ways to improve performance and reliability.
Senior Manager – Data Services
ServiceSource
Franklin
01.2013 - 05.2015
- Managed team of eight Data Analysts responsible for data content and quality in Microsoft Dynamics CRM
- Responsibilities included ETL (SSIS), data updates, and data analysis
- Data loads (ETL) followed complex business rules and generated detailed exception reports as well as executive summaries for management
- Loaded client data into the ServiceSource CRM
- Applied complex business logic via stored procedures as well as transformations in SSIS
- Incoming data was complex and changed often
- Business rules varied by client, so the SSIS packages and stored procedures had to be easily changed to meet each client’s needs.
Owner / Consultant
Prism Data Solutions
Franklin
06.2010 - 01.2013
- Consultant for Harmony Information Systems
- Lead DBA reporting to CTO
- Responsible for 200+ production databases
- Duties included query performance tuning, server performance tuning, managing projects and tasks for off-shore DBA team, and ensuring database up-time and performance met service level agreements
- Consultant for Celera Group
- Consolidated 52 individual databases into a single centralized database
- Developed complex T-SQL scripts to purge data according to business rules defined by client
- Purge scripts were complex due to the number of tables, FK relationships, constraints, etc
- Performed database tuning and suggested ways to improve performance.
Database Architect
Solveras Payment Solutions
Franklin
04.2009 - 06.2010
- Performed design analysis of existing database using reverse engineering
- The reverse engineered database was used when designing the new database to ensure all data was accurately captured in the new database
- Designed a new database in SQL Server 2008 from scratch to replace an existing poorly designed and inefficient database and support a new CRM application simultaneously under development
- Followed database best practices including normalization and referential integrity
- Developed SSIS packages to migrate data from old database to new
- SSIS packages scrubbed the data and converted free-form text to columns, used foreign keys, and enforced referential integrity
- Developed SSIS packages to copy data from credit card application database to CRM database for tracking and reports
- Developed SSIS package to generate files for transmission to credit card processor
- Developed SSIS package to read incoming files from credit card processor to support invoicing to merchant, reporting, and customer service
- Created reports in SSRS for management, customer service, and accounting
- Supported credit card payment application development and ongoing maintenance
- Continued to improve data integrity, develop and modify SSRS reports, and improve performance.
Software Developer
Passport Health Communications
Franklin
04.2008 - 04.2009
- Developed tool to synchronize configuration data between production and QA in VB.NET/ASP.NET/SQL Server for internal use to ease QA testing
- Developed tool in VB.NET/SQL Server to help QA in finding and capturing transactions for use in testing
- This tool determined the file(s) to search for the transaction
- When found, it parsed each of these files until it found the required transaction
- Debugged and maintained various VB.NET/SQL Server production applications.
Database Administration – Manager
Link2Gov (a Metavante Company)
Nashville
03.2007 - 03.2008
- Managed staff of six DBA’s responsible for over twenty production databases
- Responsibilities included backups, index tuning, query tuning, architecture, design, and database security
- Experience with Merge Replication and Transactional Replication
- Helped with architecture of new production environment.
Manager, Application Systems Analysis/Programming
Emdeon Business Services (formerly WebMD)
Nashville
06.2002 - 02.2007
- Manager for six-person development team
- Delegated assignments based upon resource availability and expertise
- Worked with EDI – specifically ANSI X12 835, 837, and 997 transactions
- Developed extremely complex Stored Procedures to query Meta Data database
- Database was housed in SQL Server 2000 but the database design was not a typical normalized database
- All claim data was stored in a single 4-column table
- For example, to store last name and first name would take 2 rows in this table
- The data was hierarchical with multiple nested hierarchies per claim
- It was critical that queries be as efficient as possible since the primary table reached over 1 billion rows by month end
- Migrated all databases to SQL Server 2005 (Meta Data database and traditional OLTP databases)
- Lead four-person team for designing database for Code Sets Consolidation project
- This database was intended to house multiple disparate code sets (diagnosis codes, procedure codes, etc.) in a “single source of truth database.” When implemented, this project reduced costs significantly by allowing the company to buy only one set of code sets.
Education
Bachelor of Science - Computer Information Systems
Murray State University
Murray, KYSkills
- Microsoft SQL Server
- Database Administration
- T-SQL query development
- Database design and architecture
- SQL Server Integration Services (SSIS)
- EDI (ANSI X12 835, 837, 997 Transactions)
- SQL Server Reporting Services (SSRS)
- Git
- Critical thinking abilities
- Performance Tuning
- Data Modeling
- Source and Version Control: Git, Github
- Teamwork and Collaboration
- JIRA
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Affiliations
- Association of Information Technology Professionals
Quote
There is a powerful driving force inside every human being that, once unleashed, can make any vision, dream, or desire a reality.
Tony Robbins
Work Preference
Work Type
Full TimeContract WorkSoftware
SQL Server Management Studio
SQL Server Integration Services (SSIS)
SQL Server Reporting Services (SSRS)
Erwin Data Modeler
Git Source Control
Jira
Microsoft Office
Microsoft Teams
WebEx
Visual Studio
Interests
Microsoft SQL Server
Woodworking
Aviation
Reading
Gardening
Photography
Timeline
Senior BI Developer
Trexis Insurance
11.2022 - 05.2024
Senior Developer
HealthStream
08.2020 - 10.2021
Database Engineer
Sovereign Sportsman Solutions
12.2019 - 03.2020
Solutions Architect
AdhereHealth
04.2018 - 12.2019
Database Team Lead
Cigna Healthspring
07.2016 - 04.2018
BI Developer
Community Health Systems
07.2015 - 07.2016
BI Developer
Deloitte, Electronic Discovery Division
05.2015 - 07.2015
Senior Manager – Data Services
ServiceSource
01.2013 - 05.2015
Owner / Consultant
Prism Data Solutions
06.2010 - 01.2013
Database Architect
Solveras Payment Solutions
04.2009 - 06.2010
Software Developer
Passport Health Communications
04.2008 - 04.2009
Database Administration – Manager
Link2Gov (a Metavante Company)
03.2007 - 03.2008
Manager, Application Systems Analysis/Programming
Emdeon Business Services (formerly WebMD)
06.2002 - 02.2007
Bachelor of Science - Computer Information Systems
Murray State University
Similar Profiles
Tishanda JohnsonTishanda Johnson
Liability Claims Adjuster at Trexis InsuranceLiability Claims Adjuster at Trexis Insurance
Cameron KelleyCameron Kelley
FNOL Represenative at Trexis InsuranceFNOL Represenative at Trexis Insurance
Ivanna ChamblinIvanna Chamblin
Inside Claims Adjuster at Trexis InsuranceInside Claims Adjuster at Trexis Insurance
Cristy ButlerCristy Butler
Application Support Manager at Trexis InsuranceApplication Support Manager at Trexis Insurance
Yasmaykel TestamarckYasmaykel Testamarck
Associate (Flexible shift) at AmazonAssociate (Flexible shift) at Amazon