Mihir Kansara
MSBI Technical Architect
About
Microsoft Certified BI Technical Architect with 11+ years of experience delivering enterprise-grade Business Intelligence solutions across BFSI, Healthcare, and Technology verticals. Proven track record of architecting BI solutions, integrating AI features in Power BI using Microsoft Copilot, and leading cross-functional teams delivering mission-critical analytics for Fortune 500 clients including Microsoft US.
Skills & Expertise (21)
Work Experience
BI Technical Architect
Wipro Connected Services (formerly Harman)
Jul 2021 - Present
Delivering enterprise BI solutions for compliance & analytics programs. Architected end-to-end BI platform for Microsoft's CELA Compliance Group, handling highly confidential investigation data with strict access controls. Led Data Profiling, ETL development (ADF pipelines), and Power BI report design covering multi-dimensional compliance metrics. Designed and delivered executive management dashboard that consolidated and replaced 20+ silo business reports, creating a single source of truth for compliance operations and significantly improving reporting efficiency and decision-making. Integrated Microsoft Copilot AI into Power BI reports. Implemented natural-language Q&A, AI-generated narrative summaries, and automated report summaries within Power BI reports, reducing manual reporting effort by ~40%. Sole owner of data access & authorization governance for sensitive investigation datasets.
BI Associate
Deutsche Bank
Sep 2020 - Jul 2021
Analyzed corporate procurement data and processes to identify accuracy gaps and reporting inconsistencies within a regulated banking environment. Delivered business reporting and data validation within enterprise governance and compliance standards typical of financial services. Gained hands-on exposure to enterprise-scale data accuracy controls - foundational to later architecture and governance-focused BI work.
Assistant Team Lead / Project Lead
AdvantMed LLC
Dec 2019 - Aug 2020
Led end-to-end BI project delivery under Agile methodology, from requirements through deployment, for healthcare data (PHA) reporting. Defined data points and logical visualization design for dashboards, translating complex healthcare data (PHA details) into actionable reporting. Owned technical decision-making across the project lifecycle, coordinating design, development, and delivery within sprint cycles. Built Enterprise Data Warehouse layer to compute Risk Adjustment Factors (RAF) at member level using CMS HCC & RxHCC models. Developed year-over-year RAF uplift dashboards, accelerating actuary review cycles.
Assistant Manager / Project Lead
Angel Broking Pvt. Ltd.
Jul 2017 - Nov 2019
Managed end-to-end BI project delivery — requirement gathering, scoping, development, self-testing, and production deployment — for financial services reporting. Designed automation solutions to resolve recurring process failures, improving reliability of scheduled reporting/data jobs. Operated as sole technical owner across the full delivery cycle, requiring both stakeholder-facing scoping and hands-on SSRS/SQL development. Built SSRS and Tableau reports tracking the end-to-end client acquisition journey across platforms, informing strategic onboarding decisions.
Assistant Manager (Core Developer)
Godrej Infotech Ltd.
Dec 2014 - Jul 2017
Installed, configured, and developed enterprise reporting platforms (Infor Reporting / Cognos Report Studio) alongside SSRS-based BI solutions. Built ASP.NET-based BI dashboards to surface SSRS business reports to end users, bridging custom application development with reporting delivery. Expanded technical scope from pure reporting (SSRS) into full-stack BI delivery, incorporating SSIS and ASP.NET. Delivered a secure, PAN-India accessible BI Dashboard website with full backend automation and granular-level drill-through reports.
Education
M.S. Embedded Systems - Manipal University (Manipal Centre for Information Science)
2011 - 2013 · Afghanistan
B.E. Electronics & Communication - Atmiya Institute of Technology & Science, Saurashtra University
2006 - 2010 · Afghanistan
Certifications
Fabric Analytics Engineer Associate
Microsoft · 2026
Azure AI Fundamentals
Microsoft · 2026
Power BI Data Analyst Associate
Microsoft · 2022
Azure Data Engineer Associate
Microsoft · 2022
Visual Analytics with Tableau
Coursera · 2019
Interested in this developer?
Profile Score Breakdown
Profile Overview
Skills (21)
Click a skill to find developers with the same skill
