Dosapati Raja Gopal
Results-driven Power BI Developer with 5+ years of experience designing, developing, and optimizing enterprise-grade business intelligence solutions across e-commerce, logistics, and healthcare. Proven ability to translate complex, multi-source data into actionable insights through interactive dashboards, advanced DAX modeling, and automated ETL pipelines. Skilled in cloud data engineering on Azure, AWS, and GCP, with strong expertise in SQL, Python, SSIS, and Azure Data Factory. Experienced in Agile delivery, cross-functional collaboration, and mentoring teams to elevate BI maturity at scale.
Experience
Power BI Developer
Global Bees Pvt Ltd
Hyderabad, India
Designed and implemented advanced Power BI dashboards integrating SQL Server, Azure Data Factory, and 10+ data sources, providing real-time business insights to C-suite and operations stakeholders. Developed optimized DAX measures, calculated columns, and business KPIs (YoY Growth, MTD, QTD, YTD, Rolling 12-Month) — reducing query execution time by40%. Built end-to-end ETL pipelines using SSIS across heterogeneous sources (SQL Server, Oracle, Excel, CSV, FTP, APIs), loading into data warehouses with full transformation and error-handling logic. Engineered ADF pipelines with Linked Services, copy activities, triggers, and Salesforce-to-SQL integrations for automated, scalable cloud data movement. Implemented Row-Level Security (RLS), RBAC, and data governance policies ensuring GDPR compliance and secure multi-role access across all BI reports. Automated data refresh via Enterprise and Personal Gateway configurations, eliminating manual intervention and ensuring real-time data availability for all stakeholders. Created interactive reports with drill-down, drill-through, sync slicers, bookmarks, and visual-/page-/report-level filters for supply chain and logistics analytics — driving a25% operational efficiency improvement. Developed Tableau Desktop dashboards and TIBCO Spotfire visualizations (connected to SQL Server & Excel) for sales, marketing, and operations performance tracking. Leveraged Python scripts for advanced data cleansing, encoding fixes, date/time logic, and handling XML/JSON/inconsistent Excel formats beyond Power Query scope. Built paginated SSRS reports (tabular, matrix, drill-down, charts) with optimized SQL stored procedures and multi-format scheduled distribution. Collaborated cross-functionally to define KPIs, drove daily client requirement calls, and translated business needs into scalable dashboard solutions. Optimized data models and reporting structures, reducing report generation time by30%and significantly improving end-user experience. Mentored junior analysts on Power BI best practices, DAX functions, Power Query, and enterprise data modeling standards.
Power BI Developer
KVHR Human Resources
Hyderabad, India
Built dynamic Power BI dashboards visualizing HR metrics — employee attrition, payroll trends, and recruitment funnels — for HR leadership decision-making. Automated HR reporting by integrating Power BI with Excel, SQL databases, and cloud data sources, reducing manual effort by50%. Designed Power Query transformation workflows improving data quality, consistency, and pipeline reliability across HR systems. Created predictive analytics models to forecast employee turnover, enabling proactive HR workforce planning and intervention. Optimized DAX queries and report structures for large HR datasets, significantly reducing load times. Implemented role-based access control and user role management to secure sensitive HR data and maintain compliance. Partnered with HR leadership to define reporting requirements and improve strategic workforce analytics frameworks.
Education
Medicharla Radha Rani College
Master of Business Administration (MBA)
Andhra Pradesh, India
Skills
Key Achievements
Reduced query execution time by40%through advanced DAX optimization and data model restructuring, directly improving dashboard performance for 500+ end users.
Cut report generation time by30%and reduced manual reporting effort by50%via automated ETL workflows and scheduled Power BI data refresh cycles.
Delivered supply chain analytics suite driving a25% improvement in operational efficiencyfor a nationwide logistics network serving 3,900+ stores.
Architected real-time Power BI dashboards integrating10+ heterogeneous data sources, improving stakeholder decision-making speed by30%.
Implemented GDPR-compliant Row-Level Security (RLS) and RBAC across 5 organizational departments, ensuring zero data compliance violations.
Key Projects
Sales & Inventory Analysis — C&S Wholesale Grocers (Supply Chain BI)
C&S serves approx. 3,900 stores from 50+ locations across 11 US states. A Supply Chain Management transactional application handling order entry, order processing, delivery date computation based on supply & demand, and order releasing from warehouse to customer. Gathered and analyzed business and customer requirements through stakeholder meetings with users, business analysts, and team members. Designed and implemented ETL processes using SSIS packages with heterogeneous data sources and performed complex data transformations. Generated and consolidated monthly reports and budget analysis to drive forecast production planning using SQL Server Reporting Services (SSRS). Developed custom reports and distributed them in multiple formats using MS Reporting Services 2008 (SSRS) — including tabular, matrix, drill-down, and chart reports. Extracted data from .txt flat files and imported into SQL Server monthly using the Import/Export Wizard; validated data accuracy against Power BI Desktop using MySQL queries. Resolved problem/incident tickets based on priority, collaborating with end users for timely resolution; prepared release packages for production deployment. Scheduled automatic data refresh in Power BI Service; installed and configured both Enterprise Gateway and Personal Gateway. Created Bookmark Panes for view-detail actions on Text/Matrix tables; published reports to Power BI Server and provisioned access to required users.
Denial Cost Management Dashboard — Yale New Haven Hospital (Healthcare BI)
Yale New Haven Hospital is one of the largest hospitals in the USA (Connecticut) and the primary teaching hospital for Yale School of Medicine. The project focuses on insurance payer reimbursement denial tracking — identifying partial/no-payment patterns and forecasting denied payments over time to support denial cost management. Engaged with business users to gather requirements, drove daily client calls, and translated end-user needs into efficient Power BI dashboards for denial cost management. Imported data from multiple sources into Power BI reports and dashboards; developed and maintained content packs for large-volume data reporting. Built Azure Data Factory (ADF) pipelines including Linked Services, copy activities (Salesforce to SQL Server), and triggers for automated cloud data movement. Implemented Row-Level Security (RLS) per organizational and HIPAA security requirements to control data access across user roles. Created rich visualizations including Line, Bar, Histogram, Scatter Plot, Waterfall, Pie, Area, Donut Charts, Bullet Graphs, Heat Maps, and Tree Maps. Designed Drill-Down, Drill-Through, and Sync Slicer reports; applied Visual-Level, Report-Level, and Page-Level Filters for granular data exploration. Created workspaces and content packs for user access to developed reports; scheduled automatic refresh and configured Enterprise and Personal Gateways in Power BI Service. Created Bookmark Panes for action-based navigation on Text/Matrix tables; published finalized reports to Power BI Server with role-based user access provisioning.
Education & Certifications
Microsoft Power BI Desktop for Business Intelligence
Udemy
PL-300 Certification Prep: Microsoft Power BI Data Analyst
Udemy
Additional Information
Languages
English (Fluent), Telugu (Native), Hindi (Conversational)
Soft Skills
Analytical Thinking, Cross-functional Collaboration, Leadership, Problem-Solving, Client Communication, Agile Delivery