Thomas Brown Email & Phone Number

Las Vegas, Nv, Us

Las Vegas, Nv, Us

Las Vegas, Nevada

Riverton, Utah

• Managed process to switch data analytics vendors• Developed conceptual, logical and physical models for designing SQL databases• Planned and organized implementation of TFS environment• Subject matter expert for writing SQL queries, stored procedures, and jobs• Worked with external vendors to import and export data feeds• Automated processes for loading and visualizing data for multiple departments• Led monthly department meetings to train analysts on optimizing SQL code and keep everyone updated on database changes• Designed majority of SQL tables used by all data analysts• Performed ETL processes for all analytics departments using SSMS and SSIS

Greater Salt Lake City Area

• Managed permissions, indexes and quality of SQL database for all of PEHP data analysts• Developed relational database for analytical reporting• Awarded Most Valued Employee for creating a process for HEDIS reporting• Subject matter expert for writing SQL queries, stored procedures, and jobs• Worked with external vendors to import and export data feeds• Worked with other departments to show the value of making decisions using data analysis• Automated processes for loading and visualizing data for multiple departments• Led monthly department meetings to train analysts on optimizing SQL code and keep everyone updated on database changes• Created extracts and a process to analyze gainsharing agreements with various clinics• Led and coordinated projects between IT and analytical departments • Created a development environment and transitioned and trained entire analytics department to utilize a development approach• Familiar with TFS using Visual Studio• Designed majority of SQL tables used by all data analysts

• Created a dashboard that was sent to PEHP’s largest external groups to inform them of areas that could be improved • Analyzed healthcare trends of PEHP members based on risk• Implemented process for loading lab extracts and structured tables for easy SQL access• Trained new analysts in SQL and how to use database tables for analytical reports• Developed dashboards using Tableau and Excel

• Automated process for pricing groups that reduced process from multiple days to two hours using Excel• Created analytical reports for multiple departments• Supported IT for implementation of new tables for data warehouse

• Created tables in SQL database for Altius to relate to corporate database for Coventry• Analyzed and presented on business trends for monthly executive meetings

• Developed surveys for clients to analyze areas of improvement• Trained clients on how to improve their business

• Used SAS and R to create statistical models for analyzing text

Master Of Business Administration - Mba, Management Information Systems And Services

Bachelor Of Science - Bs, Actuarial Science

Bachelor'S Degree, Actuarial Science

Activities and Societies: Program Chair - BYU Actuarial Club