Arpan Karmakar
Senior Manager — Data Analytics & Business Intelligence
Bengaluru, Karnataka, India
Summary
BI & Data Analytics Leader with 15+ years of experience specializing in Power BI, SQL, Microsoft Fabric, Data Engineering, and AI/GenAI-driven analytics. Experienced in building enterprise dashboards, governed semantic models, data pipelines, reporting solutions, and executive insights. Strong in translating complex business requirements into scalable, data-driven solutions and partnering with stakeholders across business and technology teams.
Experience
Data & BI Consultant Current
Jun 2022 – PresentBI transformation for a global WFM initiative, plus enterprise CRM and HR/Finance reporting.
- Lead BI Transformation initiative for WFM globally to drive FTE saving.
- Developed CRM reports using Salesforce data; drove Workday migration activity at enterprise level.
- Enabled HR and Finance reporting through Workday PRISM and Power BI.
- Built Power BI reports and dashboards connected to SQL Server, Postgres, and Snowflake — matrix, bar, line, pie, donut, bubble, and stacked bar charts.
- Designed and managed BI dashboards tracking customer data quality, compliance, and governance metrics.
- Created data models with calculated fields (periodic and aggregate calculations), drill-throughs, tooltips, bookmarks, and row-level security.
- Administered Power BI service & tenant — usage monitoring, RLS, incremental refresh, gateway configuration.
- Owned process flow documentation and client/vendor management.
Senior Manager
Oct 2021 – Jun 2022- Provided insights and analytics to the WFM leadership team on key metrics through Power BI dashboards.
- Drove data and BI process streamlining across WFM.
- Built analytics and dashboards that surfaced business problems and guided automation teams on reporting dashboards.
- Managed customer data quality — accuracy, consistency, compliance with data governance policies.
- Developed and implemented data governance frameworks to standardize customer data management.
Senior Manager
Jul 2019 – Sep 2021- Mentored and led a team of 12+ developers.
- Owned data analysis, performance dashboards, and operational reporting.
- Used multiple custom visuals and complex DAX to develop KPIs in Power BI; gave CXOs and clients better visibility.
- Developed end-to-end data pipeline in AWS with Python automation; configured Power BI Gateway for hourly refreshes.
Practice Advisor
Jun 2015 – Jun 2019- Leveraged data visualization tools (Power BI, QlikView) to improve clinical outcomes and patient safety.
- Built data marts on Microsoft SQL Server to surface meaningful data to decision makers.
- Managed projects deploying Health Catalyst products for data warehousing and analytical reporting.
- Led Power BI Premium implementation; conducted monthly usage reviews and recommended changes to report owners.
Analytics Consultant
May 2011 – Jun 2015Analytics consulting engagements across HP's enterprise clients — data warehousing, reporting, and BI delivery on Microsoft stack.
Research Lead
Feb 2006 – May 2011Led research and analytics engagements for global clients — data quality, custom research, and decision-support reporting.
Team Member
Feb 2005 – Feb 2006Early-career analytics role supporting HR and benefits data workflows.
Selected Projects
WFM Reporting & Analytics Platform
RanarTech · 2022–presentPower BI + Azure SQL implementation to help operations establish standard reporting structure for a global workforce.
Fuel Analytics — Adani
Adani Port & SEZ Ltd.Business impact driven through data analytics — optimising vehicle movement and effective fuel usage in warehouse operations.
Vehicle Movement Analytics
GPS + real-timeGPS-integrated tracking with API data feed in PostgreSQL; real-time dashboard developed in Power BI.
Skills
Credentials
- CSM® (Certified ScrumMaster)
- Data Visualization using Power BI & QlikView
- Intro to Python for Data Science
- Financial Market (NCFM)
- Certificate in Information Technology (CMC)
- Wilson Learning — Working in Challenging Times
Connect
Perspective
Read Arpan on production-grade data infrastructure:
23-item validator infrastructure checklist →Tell us about your project. We will set up a discovery call within 48 hours.
[email protected] →