Summary
Overview
Work History
Education
Skills
Leadership and Mentoring
Advanced Analytics
Timeline
Generic

SANDEEP KOMMINI

Columbus

Summary

Results-driven Business Intelligence leader with 15+ years of experience transforming data into actionable insights. Expert in the Microsoft BI stack, machine learning, and architectural design. Proven ability to build and mentor high-performing teams, drive strategic initiatives, and deliver impactful solutions that optimize business performance.

Overview

13
13
years of professional experience

Work History

Senior Manager, Business Intelligence

CPS/Optum
03.2024 - Current
  • Directed the development and maintenance of the enterprise Business Intelligence platform, ensuring its reliability and scalability.
  • Enhanced team capabilities by recruiting and onboarding a Principal Developer and Architect, bolstering technical expertise and strategic vision.
  • Empowered end-users with self-service BI capabilities through the implementation of Row-Level Security (RLS) within application permissions.
  • Optimized platform performance by implementing semantic model partitioning and refining SQL and DAX query processes, resulting in significant improvements in query response times.
  • Developed and executed a strategic BI roadmap aligned with organizational goals, driving data-driven decision-making across departments.
  • Established and enforced data governance policies and procedures, ensuring data quality, security, and compliance.
  • Cultivated strong relationships with stakeholders across the organization, acting as a trusted advisor and champion for BI initiatives.

Principal Developer

CPS
12.2022 - 02.2024
  • Drove the strategic upgrade of the company's Business Intelligence platform, enabling key features for a SaaS offering.
  • Assumed ownership of the BI team, strategically expanding its capabilities through targeted recruitment and comprehensive training in both technical skills and streamlined processes, fostering end-to-end development proficiency.
  • Transformed reporting capabilities by implementing a standardized styling framework, leveraging bookmarks for enhanced user interaction, and optimizing DAX and SQL queries for significant performance improvements.
  • Established and enforced rigorous code versioning (Git) and code quality (code reviews) processes, ensuring maintainability, collaboration, and long-term project success.

BI Developer

CPS
07.2020 - 11.2022
  • Served as the app lead and BI developer for a new application, driving its development from conception to launch, including managing complex requirements, engaging with diverse consumers, and delivering impactful Power BI reports with advanced visualizations.
  • Proactively addressed project challenges by effectively communicating with and influencing senior leadership, mitigating the impact of ineffective project management.
  • Established a company-wide standard for telehealth reporting by developing a comprehensive platform, providing actionable insights to both business stakeholders and customers.
  • Revolutionized reporting aesthetics and function by implementing innovative visualization techniques, transforming traditional spreadsheet-style reports into engaging and insightful Power BI dashboards and reports.

BI Developer

PRIORAUTHNOW
06.2019 - 04.2020
  • Transformed the reporting platform by migrating from a fragmented and inefficient SSRS environment to a centralized Power BI solution, delivering real-time dashboards and reports for executive, customer, and operational stakeholders.
  • Designed and implemented robust data models within the data warehouse and Azure Analysis Services, utilizing a star schema to optimize performance and data accessibility.
  • Developed DAX measures to calculate critical business metrics, providing actionable insights for decision-making.
  • Performed diverse technical tasks, including database administration and ETL development using SQL and C#, demonstrating versatility and a broad skill set.
  • Developed a classification model to predict prior authorization success
  • Conducted proof-of-concept work for the company's AWS migration, validating the feasibility and performance of ElasticSearch, Kibana, S3, and DynamoDB..

S&OP Manager

VERTIV CORPORATION
01.2017 - 05.2019
  • Orchestrated the Sales & Operations Planning (S&OP) process, facilitating collaborative Demand, Supply, and Executive reviews to align production with sales forecasts.
  • Developed a comprehensive Power BI dashboard, utilizing advanced DAX calculations, to provide real-time insights into sales forecasts, orders, backlog, inventory, and capacity, enabling data-driven decision-making.
  • Proactively identified and resolved demand and supply chain challenges, including forecast errors, capacity constraints, and material shortages, ensuring operational efficiency.
  • Designed and implemented company-wide inventory bridge analyses to track the progress and impact of improvement initiatives and projects.
  • Led monthly presentations to senior leadership, providing clear updates on performance, potential risks, and mitigation strategies.
  • Directed the data architecture and dashboard development, streamlining data integration and visualization for enhanced reporting capabilities.
  • Engineered a global inventory dashboard by consolidating data from three distinct ERP systems, providing a unified view of inventory levels across the organization.

Supply Chain Planning Analyst

VERTIV CORPORATION
01.2012 - 12.2016
  • Directed an analytics team in Manila, The Philippines, providing comprehensive data support for all supply chain department requirements.
  • Mentored and trained junior analysts in inventory management and supply chain principles, fostering their professional development.
  • Developed a dynamic Buyer Dashboard using MS Excel VBA, standardizing buyer workflows and enhancing operational efficiency.

Education

Bachelor of Industrial and Systems Engineering -

OHIO STATE UNIVERSITY
Columbus, Ohio

Skills

    Business Intelligence

  • Skills - Dimensional and semantic modeling, report building (advanced DAX and interactive visualizations), deployment pipelines, capacity monitoring and scaling
  • Tools - Power BI Desktop, DAX Studio, Azure Analysis Services, Tabular Editor, Report Builder, SSRS
  • Machine Learning and AI

  • Skills - prompt engineering and fine tuning of LLMs Building regression and classification models, including all key activities such as data pre-processing, hyperparameter tuning, and model validation through various performance metrics and functional testing
  • Frameworks - Pytorch, scikit learn
  • Data Engineering:

  • Skills - ETL, query performance tuning, indexing SQL skills - DDL, DML, DCL, and TCL
  • Tools - Azure Data Factory, SSIS, Databricks, MS SQL Server, MS Fabric pipelines, notebooks, and lakehouses

Leadership and Mentoring

  • Led and mentored a team of BI developers and analysts, fostering a collaborative and high-performing environment.
  • Developed and implemented a training program for junior team members.
  • Successfully guided cross-functional teams in the delivery of complex BI projects, ensuring alignment with business objectives.


Advanced Analytics

  • Developed a sophisticated DAX solution to visualize year-over-year price changes adjusted for inflation, providing key insights into market trends.
  • Developed reporting for a critical telehealth application that revealed trends in pharmacist workload and busy periods, enabling optimized staffing decisions.
  • Developed and implemented machine learning models, including logistic regression, support vector machines, decision trees, and random forests, aimed at reducing pharmacist workload. Utilized synthetic sampling and hyperparameter tuning to optimize model performance.


Timeline

Senior Manager, Business Intelligence

CPS/Optum
03.2024 - Current

Principal Developer

CPS
12.2022 - 02.2024

BI Developer

CPS
07.2020 - 11.2022

BI Developer

PRIORAUTHNOW
06.2019 - 04.2020

S&OP Manager

VERTIV CORPORATION
01.2017 - 05.2019

Supply Chain Planning Analyst

VERTIV CORPORATION
01.2012 - 12.2016

Bachelor of Industrial and Systems Engineering -

OHIO STATE UNIVERSITY