Brian Comer Email & Phone Number

Waynesboro, Tennessee, US

- Define policies, procedures, and governance for the data warehouse/platform that is aligned with the overall data strategy and requirements to ensure consistent use of data architecture standards and business definitions. - Developed a unified COVID reporting solution based on state-mandated guidelines. - Created a Data Model for Visits and Charts across.

Alpharetta, Georgia, US

· Design, build, and maintain data warehouse solutions to support Business and Reporting projects using Azure and BI Stack (SSIS, SSRS, SSAS)· Define policies, procedures, and governance for the data warehouse/platform aligned with the overall BI strategy and requirements to use data architecture standards and business definitions consistently.· Optimized.

Nashville, TN, US

• Advance the knowledge of the BI Team and promote the adoption rate of data analytics across all facets of the organization.
• Member of IT Senior Leadership Committee
• Development, documentation, support, and performance tune of ETL/ELT processes related to Data Warehouse and EMR data loads.
• Uncovered $4.3 Million in unbilled / over-accrued claims by creating solutions to automate the department's audit controls using SSIS and SSRS. This process saved the company 2.4 FTEs weekly, providing greater accuracy.
• Architected a solution to tie the Organizational Chart with the OLAP reporting structure.
• Developed a data warehouse consisting of data marts supporting clinical, financial, accounting, and EMR systems using SSIS and SSAS, which served as the foundation for reporting and analytical applications.

Nashville, TN, US

• Generates SSRS reporting utilizing advanced techniques such as aggregates, cascading parameters, dynamic visibility, drillthroughs, and sub reporting.
• Developed enterprise level EDI solution for FBOP (Federal Bureau of Prisons) Claims Invoicing utilizing.NET, SSIS, and SSRS saving approximately 20 hours support staff time monthly.
• Create enhancements and maintains the Integrated Claims Paid Solution using the BI Stack to add additional data feeds to Claims Paid Data Warehouse and created audit tools to promote data integrity.
• Developed and maintains benefits and payroll data feeds to providers from Kronos database.
• Developed and maintained the Pharmacy Data Solution to load to BI Reporting Data Warehouse and Great Plains.
• Works with business users to document processes and workflows in order to set and meet requirements for projects and requests that would be performed by myself or other Business Intelligence team members.

Nashville, TN, US

• Responsible for the installation, configuration, upgrade, planning, and migration of 30+ MS SQL Servers.
• Handles database server tuning, database backups, capacity planning, database security, and documentation.
• Provided end-to-end guidance for functional requirements, data flows, and work flows on various projects; oversees the ETL development lifecycle of JMS, Benefits, Medical Records Interfaces
• Streamlined the production of Jail Maintenance System (JMS) ETL using SSIS best practices, server stored configurations and parent child packaging, reducing future development time from 20+ to 2 hours, QA testing time.
• Created weekly and monthly COMMVault SQL backup reports using SSRS.
• Developed and tested storage strategies and disaster-recovery plan on operational database, delivering solution that guaranteed recovery performance and high availability.

• Converted existing UNIX legacy system to SQL based system utilizing MS-SQL Server Business Intelligence solutions with a Visual Studio WINForms frontend.
• Converted existing Data Transformation Services (DTS) from 2000 to 2005 using SQL Server Integration Services(SSIS). Responsible on all new development and maintenance of SSIS packages.
• Wrote multi-threaded service to import, process, and compare client reference data in order streamline and automate a string of tasks performed manually by staff. Written in VB.net and plugged into an existing Business.
• Developed multiple reporting applications. Applications written in VB.net with a WinForms client, implementing third party components Infragistics, SoftArtisans, and Crystal Reports. Back-end designed and implemented.
• Implemented detailed SSIS error logging in both nightly and manual processes, providing greater visibility to issues for support staff.
• Monitor the software development processes and methods used to ensure quality and cohesion.