RanarTech
AK

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.

Power BIMicrosoft FabricData AnalyticsGenerative AI

Experience

Data & BI Consultant Current

Jun 2022 – Present
RanarTech · India

BI 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.
Stack: Power BI Desktop, PBI Gateway, PBI Admin & tenant mgmt, SQL Server, Azure Synapse, SSIS, Power Automate, MS-Planner

Senior Manager

Oct 2021 – Jun 2022
Conduent Business Services · India
  • 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.
Stack: Power BI Desktop, SQL Server

Senior Manager

Jul 2019 – Sep 2021
Adani Port & SEZ Ltd. · India
  • 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
Maersk Line · India & Denmark
  • 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.
Stack: Power BI Desktop, PBI Admin, SQL Server, Oracle, HR Analytics, SSIS, SSAS

Analytics Consultant

May 2011 – Jun 2015
Hewlett Packard · India

Analytics consulting engagements across HP's enterprise clients — data warehousing, reporting, and BI delivery on Microsoft stack.

Research Lead

Feb 2006 – May 2011
Evalueserve · India

Led research and analytics engagements for global clients — data quality, custom research, and decision-support reporting.

Team Member

Feb 2005 – Feb 2006
Hewitt · India

Early-career analytics role supporting HR and benefits data workflows.

Selected Projects

WFM Reporting & Analytics Platform

RanarTech · 2022–present

Power BI + Azure SQL implementation to help operations establish standard reporting structure for a global workforce.

Stack: Power BI Desktop, Azure Synapse SQL, Analytics

Fuel Analytics — Adani

Adani Port & SEZ Ltd.

Business impact driven through data analytics — optimising vehicle movement and effective fuel usage in warehouse operations.

Stack: Power BI Desktop, PostgreSQL, Analytics

Vehicle Movement Analytics

GPS + real-time

GPS-integrated tracking with API data feed in PostgreSQL; real-time dashboard developed in Power BI.

Stack: Power BI Desktop, Live reports, PostgreSQL, Analytics

Skills

Data EngineeringData AnalystPower BISQLSSISSSASPostgreSQLExcel VBAAutomationPower AutomateAzureMS-PlannerWorkforce ManagementScorecardKPI DashboardProject ManagementStakeholder ManagementJiraCSM®

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 →
Want to work with Arpan?

Tell us about your project. We will set up a discovery call within 48 hours.

[email protected] →