Summary
Overview
Work History
Education
Skills
Skills Summary
Timeline
Generic

Pavan Prabhakar Kalepu

Business Intelligence Lead | Tableau & Power BI Expert| SAP BO & Data Strategy Specialist
Hyderabad,Telangana

Summary

Seasoned and results-driven Business Intelligence (BI) Lead with over 14 years of experience in developing and managing enterprise data solutions. Possess 8+ years of strong expertise in Tableau and Power BI, designing and deploying highly interactive dashboards and robust data models. Proven ability to lead cross-functional teams and deliver actionable insights using tools like SAP BO, Alteryx, and Snowflake. Expert in implementing Row-Level Security (RLS), Object-Level Security (OLS), and role-based access control for enterprise-scale reporting solutions.

Overview

17
17
years of professional experience

Work History

BI Lead

Everest Technologies
Hyderabad
03.2023 - 05.2025
  • Led a BI team to deliver cross-functional Tableau and Power BI dashboards and reporting solutions.
  • Built complex data models and visualizations using both Tableau and Power BI.
  • Designed and enforced Row-Level Security (RLS) in Power BI using DAX filters and Azure AD roles.
  • Developed RLS/OLS documentation and integrated governance with security teams.
  • Used REST API for Tableau Server automation and metadata management.
  • Created centralized dashboards integrating Snowflake, Oracle, and Excel-based data.

BI Lead

Cardlytics
05.2020 - 03.2023
  • Designed and deployed enterprise-level dashboards using Tableau and Power BI.
  • Managed data models, optimized DAX calculations, and created KPI frameworks.
  • Implemented Object-Level Security (OLS) in Power BI for sensitive column protection.
  • Led development of scalable dashboards with bookmarks, drill-through, and tooltips.
  • Created multiple RLS roles for region, department, and role-based access.
  • Published Tableau dashboards to Server, set up subscriptions, and alerts.

Technical Lead

HCL Technology Services
04.2017 - 05.2020
  • Migrated reports and universes from SAP BO XIR3 to XIR4 and DB2 to Teradata.
  • Developed Tableau dashboards and Power BI reports from Oracle and Exadata systems.
  • Implemented Power Query (M Language) to transform and cleanse data.
  • Created DAX-based KPIs, drill-down visuals, and data security models using RLS.
  • Collaborated with stakeholders across APAC, EMEA, and NA for report delivery.
  • Clients: Citi Bank, Franklin Templeton

Associate Consultant

Cognizant Technology Services
04.2013 - 04.2017
  • Designed multi-source reports in SAP BO and Tableau for healthcare and banking.
  • Administered Web Intelligence, created BO universes (IDT/UDT), and managed BO migrations.
  • Implemented row-level and user-specific access within BO and Tableau environments.
  • Conducted UAT with business users and coordinated go-lives.
  • Clients: Kaiser Permanente, JPMorgan Chase

Senior Consultant

IT Convergence
06.2012 - 04.2013
  • Developed BO reports using multiple data providers, contexts, and formulas.
  • Created RLS restrictions in BO Universes and implemented security roles.
  • Client: Belkin

Data Warehouse Consultant

Futura Solutions
10.2010 - 06.2012
  • Built reports in BO WebI, Deski, and Crystal Reports.
  • Designed BO Universes and migrated them across environments.
  • Created FTP scripts to automate report publishing.
  • Client: Global Foundries

Software Engineer

Cybermate Infotek Pvt. Ltd.
07.2008 - 12.2009
  • Created and optimized BO reports and universes for retail data analysis.
  • Migrated BO content from Dev to Prod using import wizard.
  • Client: Sainsbury Ltd.

Education

Bachelor of Technology (B.Tech) - Electronics and Communication Engineering

JNTU University – Al-Ameer College of Engineering And IT
12.2006

Skills

  • Business Object XI R2/3/4

  • Oracle 9i/10g

  • Tableau

  • Power BI

  • Tableau Servers

  • Tableau Desktop

  • SQL Data Modeler

  • Snowflake

  • Teradata

  • SAP BO suite

  • Designer (IDT/UDT)

  • CMC

  • Web Intelligence

Skills Summary

Around 14 Years of Experience in Business Object XI R2/3/4, Oracle 9i/10g, Tableau and Client/Server Applications, 8+ years of experience as Team Lead / Project Lead, managing onshore/offshore BI teams, mentoring junior developers, and ensuring project delivery across multi-vendor environments., 1 year 8 months of client-facing experience in Singapore, handling direct customer engagements., Tableau (Desktop, Server, Public), Power BI (Service, Desktop, Dataflows), SAP BO (WebI, IDT/UDT, CMC), Streamlit, Python (Pandas, NumPy, Matplotlib, Plotly), SQL, PL/SQL, Snowflake, Oracle, Teradata, SQL Server, Star and Snowflake Schema Design, OLAP Structures, Alteryx, SAP BODS, RLS, OLS, Azure AD Integration, Workspace Role Management (Power BI & Tableau), Tableau REST API, Metadata API, Tableau Server Client (TSC), Team management, mentoring, stakeholder coordination, delivery ownership

Timeline

BI Lead

Everest Technologies
03.2023 - 05.2025

BI Lead

Cardlytics
05.2020 - 03.2023

Technical Lead

HCL Technology Services
04.2017 - 05.2020

Associate Consultant

Cognizant Technology Services
04.2013 - 04.2017

Senior Consultant

IT Convergence
06.2012 - 04.2013

Data Warehouse Consultant

Futura Solutions
10.2010 - 06.2012

Software Engineer

Cybermate Infotek Pvt. Ltd.
07.2008 - 12.2009

Bachelor of Technology (B.Tech) - Electronics and Communication Engineering

JNTU University – Al-Ameer College of Engineering And IT
Pavan Prabhakar KalepuBusiness Intelligence Lead | Tableau & Power BI Expert| SAP BO & Data Strategy Specialist