SHANKAR RAJPUT
Power BI Architect
Pune
Summary
Power BI Architect with 12+ years of experience designing and governing enterprise BI platforms. Specialized in Power BI semantic model architecture, advanced DAX patterns, large-scale SQL optimization, Azure-based data platforms, and security-driven BI (RLS). Proven ability to design scalable, reusable, and performance-optimized analytics ecosystems for banking, retail, and HR domains.
Skilled BI professional with deep expertise in designing, implementing, and optimizing business intelligence solutions. Strong background in data modeling, ETL processes, and data visualization tools. Proven ability to enhance decision-making through insightful data analysis. Focused on team collaboration and adaptable to evolving project needs. Known for reliability and results-driven approach.
Overview
11
11
years of professional experience
2
2
Certifications
Work History
Power BI Architect
Infosys
03.2023 - Current
- - Designed enterprise Power BI architecture supporting multi-business-unit reporting
- - Built governed semantic models with reusable datasets and standardized KPIs
- - Implemented Dynamic RLS using USERPRINCIPALNAME() and role mapping tables
- - Optimized SQL and data models, improving report performance by 25%
- - Defined Power BI Service governance, workspace strategy, and deployment pipelines
- - Improved Azure Data Lake processing efficiency by 30%
- Implemented robust security measures to protect sensitive data from unauthorized access or breaches.
- Collaborated with cross-functional teams to identify key performance indicators and align data strategies accordingly.
- Performed routine maintenance of BI infrastructure, ensuring optimal performance and minimal downtime.
Senior Data Analyst
flexAbility HR Solutions
04.2022 - 03.2023
- - Led Power BI data modeling and dashboard architecture for HR analytics
- - Designed secure, scalable models supporting 30+ dashboards
- - Partnered with stakeholders to define enterprise KPIs
Data Analyst
TeamLease Services
06.2015 - 04.2022
- - Owned BI data models and reporting architecture for workforce analytics
- - Automated enterprise MIS reporting and KPI tracking
Education
Master of Science - Computer And Information Sciences
Pune University
Pune, India 04.2001 -
Bachelor of Science - Computer And Information Sciences
RSML
Latur, India 04.2001 -
Skills
- Enterprise Power BI architecture
- Semantic model development
- Proficient in advanced DAX techniques
- Composite Models & DirectQuery Strategy
- SQL Server optimization
- Data integration development
- Proficient in data governance
- Proficient in Python programming
Certification
PL-300: Power BI Data Analyst
Timeline
Power BI Architect
Infosys
03.2023 - Current
Senior Data Analyst
flexAbility HR Solutions
04.2022 - 03.2023
Data Analyst
TeamLease Services
06.2015 - 04.2022
Master of Science - Computer And Information Sciences
Pune University
04.2001 -
Bachelor of Science - Computer And Information Sciences
RSML
04.2001 -