Meet Chauhan.

Vertica · Power BI · Power BI Service · DAX · Python · SQL · ETL · Tableau

• Built and maintain 20+ product-level Power BI dashboards tracking ad engagement metrics (clicks, open rates, impressions) across millions of users, with daily automated data refreshes published via Power BI Service to 5+ internal client teams.
• Implemented Row-Level Security (RLS) in Power BI data models to enforce client-level data access controls across multi-tenant product dashboards.
• Designed end-to-end ETL pipelines ingesting data from multiple source systems into Vertica, improving report availability to near-100% uptime for all production dashboards.
• Implemented Slowly Changing Dimensions (SCD Type 2) in the data warehouse to enable accurate historical trend analysis across 20+ product lines.
• Developed an automated environment-cloning process for entity configurations, reducing deployment turnaround time by 70% and eliminating manual errors across dev, staging, and production.
• Partnered with business stakeholders and product managers to translate reporting requirements into technical data models and KPI frameworks, maintaining data integrity across all client-facing analytics products.

Power BI · Power BI Service · DAX · Power Query (M) · Azure Data Factory · Azure SQL

• Designed and delivered an end-to-end Power BI reporting platform tracking supplier sustainability performance for 7 major retailers — including Walmart, Costco, Sam's Club, Dollar Tree, and Tractor Supply — covering thousands of suppliers per retailer.
• Engineered Azure Data Factory pipelines to ingest supplier questionnaire exports, applying multi-stage data validation, transformation, and cleansing before loading into Azure SQL for downstream Power BI consumption.
• Developed a custom sustainability scoring framework using DAX and Power Query (M), translating raw supplier responses into comparable metrics enabling retailers to benchmark and prioritize supplier engagement.
• Reduced report turnaround time by 80% by automating the full report development and delivery lifecycle, replacing manual data preparation workflows.
• Introduced Power BI Service as the organization's primary reporting and sharing standard; trained team members on building real-time interactive dashboards and established governance documentation for long-term maintainability.

Power BI · DAX · Azure SQL · Azure Databricks · SQL Server · T-SQL · Python · C#

• Led BI delivery end-to-end for healthcare clients, building clinical and financial reporting dashboards on patient data — providing actionable analytics across billing, outcomes, and operational metrics.
• Developed interactive Power BI dashboards and advanced DAX measures to support strategic KPI monitoring, enabling data-driven decisions across clinical and finance departments.
• Architected relational star schema data models in Azure SQL and Azure Databricks to support scalable, performant reporting against large healthcare datasets.
• Built ETL pipelines in Python and SQL integrating data from multiple clinical and financial source systems, ensuring data accuracy and consistency across all reporting outputs.
• Implemented NoSQL solutions for high-throughput, large-volume data ingestion scenarios where relational models were insufficient.
• Created RESTful APIs to expose data services to downstream applications; collaborated directly with business users to gather, refine, and document reporting requirements.
• Promoted to Lead Developer within 2.5 years; mentored junior team members on BI best practices, data modeling standards, and Power BI development workflows.