Shreenivas Achari

Business Intelligence Consultant

Bangalore 5+ yrs exp 90 · Outstanding

About

Results-driven Business Intelligence Consultant with 5+ years of experience in designing, developing, and deploying enterprise Power BI and Tableau solutions. Expertise in Power BI Desktop, Power BI Service, DAX, Power Query (M), SQL Server, Snowflake, Azure Data Factory, SSRS, Tableau, and Power Automate. Strong background in dimensional data modeling, ETL, report performance optimization, Row-Level Security (RLS), deployment pipelines, and stakeholder management. Proven ability to build scalable dashboards, automate reporting processes, optimize data models, and deliver business insights across Healthcare, Insurance, Retail, and pharmaceutical domains using Agile methodologies.

Skills & Expertise (54)

Power BI Service Advanced

9.1/10

Years Exp

Power Query Advanced

9.1/10

Years Exp

Power BI Desktop Advanced

9.1/10

Years Exp

DAX Advanced

9.1/10

Years Exp

Microsoft SQL Server Advanced

8.5/10

Years Exp

Power Automate Advanced

8.0/10

Years Exp

Star Schema Advanced

8.0/10

Years Exp

Fact & Dimension Modeling Advanced

8.0/10

Years Exp

Microsoft Azure Intermediate

7.5/10

Years Exp

SSRS Intermediate

7.5/10

Years Exp

Snowflake Schema Intermediate

7.0/10

Years Exp

Scrum Intermediate

7.0/10

Years Exp

Agile Intermediate

7.0/10

Years Exp

Snowflake Intermediate

6.5/10

Years Exp

Tableau Intermediate

6.5/10

Years Exp

Azure Data Factory Intermediate

6.5/10

Years Exp

AWS Intermediate

6.0/10

Years Exp

MySql Intermediate

6.0/10

Years Exp

Oracle Database Intermediate

5.0/10

Years Exp

DAX Optimization Azure SQL Database Amazon Redshift Amazon S3 AWS Glue Query Optimization Power Pivot Pivot Tables XLOOKUP VLOOKUP SDLC Requirement gathering UAT Production support Drill-through Power Query (M Dataflows Incremental Refresh Deployment Pipelines Workspaces Apps Gateways Scheduled Refresh Interactive Dashboards KPI Reporting Joins Drill-down Bookmarks Tooltips Conditional Formatting SQL Stored Procedures Views Functions CTEs

Work Experience

Senior BI Consultant

Santander Holdings USA

May 2024 - Present

Designed and developed end-to-end Power BI dashboards for Recruitment, Candidate Pipeline, Client Performance, Revenue Tracking, and Operational KPIs. Gathered business requirements from stakeholders and translated them into scalable BI solutions. Developed optimized data models using SQL Server, SharePoint, Excel, and CRM data sources following Star Schema principles. Created reusable DAX measures, calculated columns, KPIs, and time intelligence calculations (MTD, YTD, QTD, YoY). Implemented Row-Level Security (RLS) to secure recruiter, client, and regional data. Built interactive reports using drill-through, bookmarks, tooltips, slicers, and conditional formatting. Automated report refreshes and business notifications using Power Automate and Power BI Service. Published reports, managed Workspaces, Apps, Gateway, and deployment across environments. Optimized report performance by improving DAX calculations and reducing dataset refresh time. Performed data validation and production support to ensure report accuracy. Worked in Agile methodology and collaborated with business users throughout the project lifecycle.

BI Analyst

Santander Holdings USA

Apr 2023 - Apr 2024

Developed interactive Power BI and SSRS reports for Claims, Policy, Premium, and Operational reporting. Worked closely with business stakeholders to gather reporting requirements and prepare functional Documentation. Created optimized Power BI data models and DAX measures to support business KPIs. Developed advanced SSRS reports using drill-down, drill-through, grouping, sub-reports, and parameterized reports. Implemented Row-Level Security (RLS) to secure confidential insurance data. Managed Power BI Service, Workspaces, Apps, scheduled refreshes, subscriptions, and dataset publishing. Automated recurring reports using Power Automate to reduce manual reporting efforts. Performed data validation and troubleshooting to ensure report accuracy and reliability. Collaborated with QA and business teams during UAT and production deployment.

BI Consultant

Santander Holdings USA

Dec 2021 - Mar 2023

Designed and developed interactive Power BI dashboards to analyze Sales, Revenue, Profitability, Inventory, and Customer Trends. Integrated data from SQL Server, Azure Data Lake, Excel, ERP, and POS systems into a unified reporting model. Developed Star Schema data models and optimized relationships for improved report performance. Created advanced DAX measures including Sales Growth, YoY, Running Total, Profit Margin, and Product Performance KPIs. Built drill-through, drill-down, bookmarks, field parameters, and dynamic slicers for enhanced user experience. Automated monthly and quarterly reporting processes using Power BI Service. Worked with business stakeholders to understand reporting requirements and deliver analytical solutions. Improved report performance through optimized Power Query transformations and efficient DAX calculations. Supported business users by resolving report issues and validating data accuracy.

Power BI Developer

Santander Holdings USA

Nov 2020 - Dec 2021

Developed interactive Power BI dashboards for Manufacturing, Inventory, Sales, and Quality reporting. Extracted and transformed data using SQL Server, Power Query, and Excel. Created data models using Power Pivot and implemented relationships between fact and dimension tables. Developed calculated columns, measures, KPIs, and time intelligence calculations using DAX. Created hierarchies, drill-down reports, and interactive visualizations for business users. Published reports to Power BI Service and configured scheduled refresh using On-Premises Data Gateway. Implemented Row-Level Security (RLS) and managed report access based on user roles. Developed SQL objects including tables, views, stored procedures, and optimized SQL queries. Performed data validation and production support to ensure reporting accuracy.