Akshay Birare

Senior Business Intelligence (BI) Developer with 6+ years of experience in delivering enterprise-level analytics solutions. Expertise in Power BI, Microsoft Fabric, Azure Databricks, Snowflake, and SQL, with a strong focus on performance optimization and semantic data modeling. Proven ability to engage stakeholders and support global teams across India and the US. Actively pursuing BI roles Outside of India.

Domain: Investment Banking
Client: Global Banking Client (UBS – via Atyeti Inc)
Role: Senior BI Developer / Technical Lead
Tools: Power BI, Azure Databricks, Impala, SQL, DAX, XMLA, Tabular Editor

Overview:
Led an enterprise-scale migration of critical investment banking reports from Tableau to Power BI, modernizing the BI stack and improving performance, governance, and scalability.

Key Contributions & Impact:

• Migrated enterprise Tableau dashboards to Power BI while preserving business logic and data accuracy.
• Re-engineered backend data layer from Impala to Azure Databricks, optimizing SQL queries for distributed processing.
• Designed high-performance semantic models with advanced DAX, star schemas, and aggregation strategies.
• Implemented Row-Level Security (RLS) and Page-Level Security for regulatory and data access compliance.
• Tuned models using XMLA endpoints, SSMS, and Tabular Editor, reducing dataset size by 40–50%.
• Delivered a centralized Power BI App, improving governance and stakeholder adoption.
• Acted as technical lead, supporting India & US teams and mentoring junior developers.

Domain: SaaS / Subscription Analytics
Role: Power BI Engineer
Tools: Power BI Embedded, DAX, SQL, GUID-based RLS, Databricks

Overview:
Developed embedded Power BI reports to track asset usage, portfolio activity, and customer subscription behavior within a SaaS platform.

Key Contributions & Impact:

• Built secure embedded dashboards to monitor active subscriptions, usage trends, and client activity.
• Implemented Dynamic RLS (DRLS) using GUID-based authentication for multi-tenant access.
• Designed models optimized for high concurrency and embedded performance.
• Enabled stakeholders to track customer engagement, portfolio health, and operational KPIs in real time.
• Improved decision-making through self-service analytics for business and product teams.

Domain: Logistics, Supply Chain & Sales Analytics
Client: Watkins Wellness
Role: Power BI Developer
Tools: Power BI, Azure Synapse, DAX, Power BI Paginated Reports, AI Forecasting

Overview:
Delivered end-to-end logistics and sales intelligence solutions for TRUCK and TRAX systems using Azure Synapse data.

Key Contributions & Impact:

• Developed Freight & Sales dashboards covering cost analysis, shipment performance, and revenue trends.
• Built Paginated Reports for operational reporting and compliance needs.
• Designed optimized semantic models for large historical datasets stored in Azure Synapse.
• Implemented AI-based forecasting in Power BI to provide future sales and demand insights.
• Packaged solutions into Power BI Apps for controlled enterprise distribution.

Domain: HR Analytics
Role: Power BI Developer
Tools: Power BI, DAX, Power Query, SQL

Overview:
Built a dynamic HR analytics solution to track and analyze employee competency assessment results.

Key Contributions & Impact:

• Designed a dynamic aggregated report showing assessment results across departments and participant groups.
• Enabled internal and client admins to monitor completion status, competency gaps, and performance trends.
• Optimized Power Query transformations and DAX measures for scalability.
• Improved reporting accuracy and reduced manual HR reporting efforts.

Power BI

• Retail Analysis
• Sales and Performance tracking
• Hospital Dashboard

Python

• Finance Analysis
• Time-Series Analysis
• Heart Disease Analysis

I hereby declare that the details and information given above are complete and true to the best of my knowledge.

• PL 300 (Microsoft Certified Data Analyst)
• Certified Data Scientist