About

Udbhav Photo

Dynamic Business Intelligence leader with over 8 years of experience with a passion for steering data-driven performance improvements through strategic collaboration with business partners. Demonstrated ability to deliver exceptional data models and communicate complex insights to stakeholders using industry-leading best practices and analytics standards.

  • City: Richmond, VA USA
  • Email: desai.udbhav@gmail.com

Interests

Dashboard Development

Data Model Architecture

ETL Pipeline Development

Advanced Data Analysis

People Management

Cloud Computing

Data Science

Dance

Education

Northwestern University

Sep 2014 - Mar 2016

Master's of Science in Chemical Engineering

Northwestern University

Sep 2011 - Mar 2016

Bachelor's of Science in Chemical Engineering - Cum Laude


Minor in Geography

Experience

Alight Solutions

Feb 2022 - Present

Senior Manager, Business Intelligence & Data Analytics

  • Lead a team of engineers and analysts by providing visionary leadership, mentoring team members, utilizing Agile methodologies to balance workload, prioritize tasks, and promote individual growth, resulting in a highly effective and motivated team.
  • Formulate innovative solutions to integrate data and metric logic from acquired companies into the Health Navigation product by utilizing cutting-edge analytical techniques and partnering with cross-functional teams.
  • Supervise report, forecast and pipeline development to meet contractual client requirements, drive product innovation, and support sales initiatives, while consistently monitoring clinical and research workflows to identify opportunities for streamlining and inform data-driven marketing strategies.
  • Provide guidance to steer project development towards optimizing data collection for reporting, ensuring the delivery of actionable insights.
  • Overseeing the migration of reports and dashboards from legacy Salesforce and SSRS reporting to Microsoft Power BI, leveraging advanced analytics techniques to deliver actionable insights and drive business growth.
  • Maintain a 50-50 time allocation between individual contributor development and management responsibilities, enabling me to remain actively involved in technical projects while providing strategic direction to my team.

ConsumerMedical, an Alight Company

Apr 2021 - Feb 2022

Lead Business Intelligence Engineer

  • Designed and implemented a highly efficient outbound files framework that automated the delivery of 15,000 reports per year by developing a seamless PowerApp front-end, automating report delivery through Azure Data Factory, and creating a Tableau CRM dashboard to track process health.
  • Designed and delivered an engagement dashboard to assess the impact of 20+ million outreach attempts, by developing a cutting-edge marketing schema, establishing a data quality scoring process, developing benchmarks, and collaborating with clients and marketing executives to ensure strategic coherence.
  • Achieved 15% monthly cost savings on Azure Data Factory by optimizing Salesforce import pipelines, and fine-tuning Azure integration runtime settings.
  • Pioneered and managed weekly Analytic TechTalks aimed at training team members on development practices and coordinating engaging discussions to enhance the quality of visual storytelling.
  • Discovered data gaps and anomalies in SmartSelect|MD, a proprietary physician ranking tool, by analyzing 6 billion rows of claims data, conducting an end-to-end pipeline analysis, and working closely with data scientists and product managers.

Epic Systems

Apr 2019 - Apr 2021

Business Intelligence Engineer, Division Operations

  • Developed a powerful COVID-19 Vaccine Administration dashboard that consolidated progress reports, system metrics, and forecasting results, enabling executives, solution engineers, and project managers to easily monitor the performance of 500+ health systems and take action to deliver software updates.
  • Led the overhaul of a personalized weekly SSRS digest for Epic’s Technical Solutions Engineers, which included the development of a prioritization algorithm in collaboration with escalation leaders, resulting in a 62% reduction in the time taken to deliver fixes for escalated issues to clients.
  • Transformed the management of software escalation processes across 14 independent channels by devising a set of escalation lifecycle metrics, building an automated data model with SSIS, and developing a dynamic Power BI dashboard for streamlined analysis and improved decision-making.
Jul 2017 - Oct 2019

Manager, Cogito Technical Solutions Engineer

  • Managed a team of 5 Technical Solution Engineers, providing exceptional analytics support to major healthcare organizations leveraging Epic Electronic Health Record software, overseeing product implementation, custom tool development, analyst training, issue investigation, and upgrade planning.
  • Spearheaded the creation of a novel process for publishing clinical benchmarks for over 800 metrics collected monthly from 500+ health systems by developing a robust steering structure, and constructing data-driven alerts that empowered subject matter experts to track trends and identify anomalies.
  • Trained 700+ Technical Solutions new hires on healthcare analytics and supporting Epic’s Cogito tools.
Jul 2016 - Jul 2017

Cogito Technical Solutions Engineer

  • Utilized extensive knowledge of Epic's analytics suite, patient registries and predictive models, combined with expertise in SAP Crystal Reports to proactively guide clients in leveraging EHR data for actionable insights.
  • Partnered with key customer stakeholders and developers to implement cutting-edge Business Intelligence tools and plan for seamless software upgrades for enhanced user experiences.
  • Analyzed and resolved complex customer production build and data errors, delivering customized strategies to improve production build, and advocated for new development on base Epic releases.
  • Led internal support group to consolidate material for implementing, customizing and troubleshooting Epic’s flagship self-service reporting tool, SlicerDicer, in order to maximize utilization across all clients.

Suncor Energy

Mar 2013 – Dec 2014

Junior Account Manager, Co-op

  • Delivered reports and performed quantitative analysis of regional sales data using SAP Business Warehouse, MapPoint and Excel to help Senior Account Managers improve sales strategy.
  • Coordinated 4 sales conferences by designing marketing content and assisting with logistics.

Projects

  • All
  • Work-Related
  • Extra-curricular

Net Promoter Dashboard


Vaccination Station


Aggregate Metrics Data Model

Standard Extracts Framework


Outreach Data Model & Engagement Dashboards

Escalated Support Log Digest


Family Leave Analysis Challenge

Skills

Scripting

SQL

Python

DAX

JSON

Visual Platforms

Tableau

Power BI

Microsoft SSRS

CRM Analytics

SAP Crystal Reports

Cogito Analytics

PowerApps

ETL & Automation

Azure Data Factory

SSIS

Epic Clarity

Epic Caboodle

Power Automate

Logic Apps

Database Systems

Azure

MS SQL Server

Amazon RedShift

Snowflake

Oracle

Microsoft Access

Amazon Redshift

Process

Jira

Confluence

Git

Lucidchart

UX Testing

Data Governance

Analytics

Data Cleansing

Statistics

Data Modeling

Query Optimization

Data Security

Database Administration

Data Types

EMR/EHR

Marketing

Survey

Workflow Optimization

Claims

People Analytics