Brandon Vestal
Senior Solutions Engineer @Advata
Signup · Get unlimited contacts
WORK HISTORY
Senior Solutions Engineer @Advata
US
Utilized Azure technologies to build and manage clinical and revenue cycle data models, supporting multiple applications and enhancing data accessibility for various stakeholders.Designed and built a star schema data model in Azure Synapse and SSAS, facilitating comprehensive reports through PowerBI for multiple customers, thereby improving data-driven decision-making.Developed and automated a relational database in Azure SQL and Data Factory using customer-sourced x12 and HL7 data, streamlining data processing and management.Implemented full source control of all database/data model scripting in GitHub, enhancing code management and collaborative development.Created an automated deployment/management system for database code from GitHub using Azure pipelines, significantly improving deployment efficiency and reliability.In Azure Databricks, built and maintained data science and data platform notebooks containing SparkSQL and Python, supporting both data science and ETL processing, and contributing to more efficient data analysis workflows
SKILLS
ABOUT BRANDON VESTAL
Experienced Data Developer specializing in healthcare analytics and data warehousing, known for delivering quality and performance-driven solutions across cloud and on-premises environments. Strong in SQL and skilled in technical project management, I have a proven track record of leading successful data initiatives supporting software, analytic and data science.Over 16 years of healthcare experience, integrating 12 years of expertise in database development and analytics, predominantly in Azure SQL and SQL Server environments. Proficient in Databricks, IBM, and Oracle databases, demonstrating a strong track record in developing custom notebooks, stored procedures, functions, tables, and indexes. Expertise in SQL performance tuning, including Max DOP/Cost threshold, partition design, and index optimization. Skilled in Azure Data Factory and SSIS, developing both simple SFTP import/export processes and complex enterprise ETL solutions, overseeing hundreds of tables and stored procedures. Utilizing both cloud and on-premises SSAS, I have customized and maintained various data cubes, including creating predictive models and custom MDX calculations. Highly experienced in data modeling techniques, including normalization/denormalization and designing relational and star schema databases. History of creating high visibility analytical products and dashboards using tools like Excel, SSAS, PowerBI, SAP (BOE, Launch Pad, Webi, Universes, Crystal Reports), and Tableau.Proficient in git/GitHub command line use and implementation. Successfully managed, deployed, and automated database code from GitHub to support multiple customer software implementations.Holder of 7 Epic EHR certifications, including Clarity Data Model - ASAP, Cadence, EpicCare Ambulatory, Radiant and Cupid, Willow Inpatient, Cogito Project Manager.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.