Vishal Kumar Medavarapu

Business Intelligence Developer

Linamar

11.2022 - Current

Managed ServiceNow support tickets for Power BI, handling report access, troubleshooting, and customizations for multiple business units.
Designed, developed, and optimized complex Power BI reports using advanced DAX, calculated columns, and Power Query, driving better data-driven decision-making.
Reduced report loading times and improved visualization performance for high-volume purchasing data by restructuring semantic models, optimizing measures, and refining table relationships.
Automated the distribution of Power BI PDF reports using Power Automate, streamlining delivery to on-premises directories and improving reporting efficiency.
Developed C# applications in Visual Studio to extract SentinelOne API data and automate loading into on-premises SQL Server, enabling real-time analytics for the security team.
Integrated data collection from Microsoft Forms into Power BI reports, supporting streamlined business process monitoring.
Authored and maintained MDX queries using OPENQUERY and linked servers in SSMS to retrieve KPI data from cubes, enabling advanced drill-through dashboards.
Implemented data governance initiatives, including PowerPoint presentations and recommendations on data quality and compliance best practices.
Built Power BI reports supporting waste elimination initiatives, such as energy and project savings, contributing to company-wide cost reduction.
Led data migration projects by developing ETL pipelines to extract data from SharePoint API and Tenable API, building Lakehouse tables, and connecting reports to OneLake from on-premises servers.
Structured and managed user permissions and roles for Lakehouse environments, ensuring secure and compliant data access.
Utilized Microsoft Fabric features, including Dataflows, Pipelines, Web Activities, and Copy Data activities to enhance data integration and automation.
Improved data gathering, analysis, and visualization procedures with strategic optimizations.
Collaborated with cross-functional teams to gather requirements and create tailored BI reports for stakeholders.