Power Bi Business Intelligence

Rambabu Bollikonda

Hyderabad, India +91-994******* ************@*****.***

linkedin.com/in/rambabu-bollikonda

Professional Summary

Business Intelligence Analyst & Power BI Developer with 4 years of experience delivering end-to-end BI solutions across Compliance, Banking, Healthcare, and IT Asset Management domains. Skilled in Power BI, SQL, DAX, Power Query, Microsoft Fabric, Power Automate, and Agile/Scrum methodologies.

• Designed and delivered 50+ interactive dashboards with KPIs, drill-throughs, bookmarks, and advanced visuals.

• Implemented Row-Level Security (RLS) and role-based access, ensuring secure and compliant reporting.

• Optimized Power BI reports, reducing load times by 40% and improving adoption by 35% globally.

• Trained and mentored 100+ business users on self-service BI, driving higher engagement and adoption.

• Developed and optimized SQL queries, joins, stored procedures, and indexing to improve data performance by 60%.

• Built reusable SQL scripts for compliance and regulatory reports, saving 20+ hours/month.

• Integrated SQL Server with Excel, SharePoint, and ERP systems for enterprise-wide analytics.

• Automated database-driven reporting pipelines, reducing dependency on manual work.

• Created 100+ advanced DAX measures (ratios, variances, YTD/MTD, rolling averages, forecasting).

• Implemented time intelligence functions for accurate period-over-period analysis.

• Automated ETL pipelines with Power Query, reducing manual preparation by 50%.

• Designed star and snowflake schemas for scalable BI data modeling.

• Delivered BI solutions using Microsoft Fabric with Lakehouse and ingestion pipelines.

• Automated compliance alerts and approval workflows using Power Automate, saving 20+ hours/month.

• Connected Power BI with SharePoint, MS Teams, Outlook, and Power Apps.

• Applied Agile/Scrum methodologies, achieving 95%+ on-time delivery across sprints.

• Delivered BI solutions across domains: Compliance, Insurance, Banking, Healthcare, and Logistics.

• Recognized for cost-saving BI solutions, reducing reporting time by 40% and saving

$200K annually

Professional Experience

Power BI Developer Sysdoc Technologies Pvt Ltd, Bangalore March 2024 – Present Processor HDB Financial Services Limited, Hyderabad June 2023 – March 2024 Software Engineer Zisya Technology Pvt Ltd,Hyderabad Sep 2021 – June 2023 Key Projects (Case Studies)

Inventory Management Dashboard (IBM)

• Gathered requirements from IT Asset & Compliance stakeholders.

• Analyzed reporting gaps and defined KPIs for license usage.

• Designed star schema integrating SQL + Excel + SharePoint.

• Built data models with hierarchies and relationships.

• Created 20+ custom DAX measures for license utilization & variance.

• Implemented drill-through reports (Asset Department License detail).

• Applied RLS for business unit–level access.

• Developed bookmarks & tooltips for executive dashboards.

• Automated compliance alerts with Power Automate.

• Integrated dashboards with MS Teams + Outlook.

• Optimized refresh performance (40 min 12 min).

• Built scheduled refresh in Power BI Service for global use.

• Conducted UAT sessions and applied feedback.

• Trained 100+ business users and provided documentation.

• Delivered dashboards used by executives for audit preparation. Impact: Reduced audit prep by 35%, cut manual approvals by 50%. Technologies Used: Power BI, DAX, SQL Server, Power Query, Power Automate, SharePoint, MS Teams.

Banking – Loan Portfolio & Risk Analytics

• Collected requirements from Risk & Compliance teams and RBI reporting unit.

• Defined KPIs for delinquency, NPAs, disbursements, and repayment ratios.

• Integrated data from loan origination systems, repayment logs, and credit bureaus.

• Designed data warehouse schema for loan & risk management.

• Built dashboards for NPA trends, loan portfolio breakdown, and high-risk borrowers.

• Created DAX measures for overdue amounts, default ratios, and write-offs.

• Implemented drill-through navigation from customer loan repayment.

• Applied RLS for branch and region-based reporting.

• Automated NPA reports with Power Automate workflows.

• Optimized SQL queries with indexes (60% performance gain).

• Delivered dashboards for RBI compliance reporting.

• Built predictive analytics to identify high-risk loans.

• Integrated reports with MS Teams for compliance officers.

• Conducted UAT & validation with Finance leadership.

• Delivered dashboards that improved decision-making at CXO level. Impact: Improved NPA tracking by 25%, reduced default detection by 20%. Technologies Used: Power BI, SQL Server, DAX, Power Query, Power Automate, MS Teams.

Healthcare – Patient Care & Hospital Operations

• Gathered requirements from hospital administrators and operations staff.

• Defined KPIs: bed occupancy, emergency SLAs, patient discharge times.

• Integrated EHR, billing, and scheduling systems into Power BI.

• Modeled patient data for admissions, discharges, readmissions.

• Built DAX measures for patient length of stay, treatment time, and costs.

• Designed dashboards for real-time bed management.

• Implemented HIPAA-compliant RLS and governance.

• Automated alerts for over-capacity and billing delays.

• Integrated Power Automate workflows for discharge approvals.

• Developed predictive analytics for readmission risk.

• Designed dashboards for emergency response monitoring.

• Conducted BI training for doctors, nurses, and admin staff.

• Created role-based dashboards for finance vs. clinical users.

• Deployed dashboards to Power BI Service with scheduled refresh.

• Delivered executive dashboards for hospital performance review. Impact: Reduced wait times by 15%, improved billing efficiency by 20%, optimized hospital utilization.

Technologies Used: Power BI, SQL Server, DAX, Power Query, Power Automate, EHR Systems, SharePoint.

Education

• B. Tech – Electronics & Communication Engineering, JNTU Hyd

Contact this candidate