Kanwardeep Bachhal
Senior BI architect with 15+ years turning fragmented enterprise data into high-performance analytics — across Power BI and IBM Cognos — for firms like PwC, IQVIA, TCS, and EXL.
Kanwardeep Bachhal
I bridge complex engineering with executive-level insight.
I’m a senior BI architect with 15+ years delivering high-impact solutions for firms like PwC, IQVIA, TCS, and EXL. I specialize in architecting scalable data and analytics ecosystems across Power BI and IBM Cognos Analytics.
Skilled in data integration strategy, performance optimization, and advanced dimensional modeling, I turn fragmented enterprise data into high-performance systems that bridge complex technical engineering with executive-level business insight.
The work I’m proudest of is an analytics product integrating Argus safety data via custom ETL pipelines with out-of-the-box Power BI reports — serving global medical firms.
What I do
- BI architecture across Power BI & IBM Cognos
- ETL pipelines & data warehouse design
- Dimensional modeling & Dynamic Cubes
- Performance tuning & BI team leadership
From source system to executive dashboard.
Architected, modeled, and tuned end to end — with depth in healthcare and pharma data.
Power BI & DAX
High-performance tabular models, optimized DAX, secure workspaces, and RLS for HIPAA compliance.
IBM Cognos Analytics
Distributed Cognos 11 environments, Dynamic Cubes, and cache-warming for sub-five-second reports.
ETL & Data Warehousing
PL/SQL pipelines and star-schema warehouses that retire live-DB reporting and eliminate silos.
Oracle · SQL · Snowflake
PL/SQL tuning, SQL Server, and Snowflake — modeling and optimizing the data layer beneath every report.
Dimensional Modeling
Multidimensional cubes and conformed dimensions that make interactive, multidimensional analysis instant.
BI Leadership
Leading BI teams, mentoring developers, standardizing delivery, and aligning data work to business goals.
15 years, four global firms.
Lead Engineer & Senior Manager
- Built a Power BI reporting environment from scratch for a health-insurance client — high-performance models, secure workspaces, and RLS for HIPAA compliance.
- Migrated embedded SQL from 50+ semantic-model queries back to the database layer, boosting performance and cross-functional reusability.
- Led a team of 5+ BI developers with technical mentorship and milestone ownership.
Senior Consultant
- Architected an end-to-end analytics product for pharmacovigilance — PL/SQL ETL to warehouse Argus data, with a bundled suite of Power BI canned reports across global accounts.
- Converted relational models into Cognos Dynamic Cubes with automated cache-warming, cutting average report latency from 60s to 5s.
- Authored standardized test, requirement, and design templates; cross-trained teams on Power BI and Cognos.
Principal Consultant
- Architected a distributed Cognos 11 environment across five servers with load balancing and high-availability routing.
- Migrated enterprise reporting from Cognos 8 to Cognos Analytics 11; supervised a 5+ member team across Cognos, OBIEE, Informatica, and SSIS.
- Built complex BI on relational data and OLAP cubes for health-insurance and operations clients.
IT Analyst
- Implemented Cognos TM1 cubes for a healthcare client’s finance team — automating financial planning and budgeting workflows.
- Integrated Cognos reporting into SharePoint portals with secure embedded web parts.
- Led BI report validation with rigorous unit, system, and UAT scripts for high data fidelity.
Two projects, measurable impact.
Cognos → Power BI Modernization
A top-tier pharma client’s legacy Cognos reports queried a live Argus Safety DB — slow and siloed. I built an end-to-end ETL pipeline into a centralized warehouse with a star-schema model, migrated 60+ reports to Power BI, and automated regulatory canned reports. Result: 40% faster reports, zero production-DB stress, modernized UX.
Cognos Dynamic Cubes Optimization
An enterprise dashboard on Cognos 10 averaged 60 seconds per report, crushing adoption. I re-architected the relational model into multidimensional Dynamic Cubes, tuned data and aggregate caches, and scheduled pre-warming before business hours — a 91% latency cut and instant multidimensional exploration for decision-makers.
Foundations.
Master’s in Information Systems
Bachelor’s in Computer Science
Let’s turn your data into decisions.
Available full-time for BI architecture, modernization, and performance work. Tell me what you’re trying to see — I’ll help you get there.