Lakshmi Prasanna Mudiyala
Bi Developer @Public Partnerships | PPL
Signup · Get unlimited contacts
WORK HISTORY
Bi Developer @Public Partnerships | PPL
Developed and optimized complex SQL queries and data models using Databricks SQL and SQL Server, creating external tables from the Gold layer to support BI tools and enterprise reporting on operational and performance metrics.• Designed and built Power BI dashboards and Paginated Reports using advanced DAX, Power Query, and semantic data models to deliver insights on business performance, process efficiency, and compliance tracking.• Created and maintained analytical datasets for self-service BI, enabling business users to perform ad hoc data exploration and access real-time insights on key business metrics.• Implemented Row-Level Security (RLS) and Column-Level Security (CLS) in Power BI and SSRS Paginated Reports to control access based on user roles, ensuring compliance with data privacy and security policies.• Configured data gateways to enable automatic data refresh and real-time data access; integrated interactive dashboards into PowerPoint presentations to support dynamic reporting on healthcare metrics.• Monitored and optimized Power BI datasets, dataflows, and SSRS report delivery, automating report scheduling and publication to ensure timely access to critical business insights.• Designed and implemented dimensional data models using SQL and Star Schema methodology to support high-performance analytical querying and scalable reporting solutions.• Collaborated with cross-functional stakeholders to gather reporting requirements, define KPIs and business metrics, and document data models that align with strategic business objectives.• Participated in all phases of the Software Development Life Cycle (SDLC), including requirements gathering, solution design, development, testing, deployment, and maintenance of BI solutions.• Conducted unit testing, regression testing, and peer code reviews to ensure data accuracy, performance optimization, and adherence to development standards before production deployment.
EDUCATION
JNTU Anantapur
Bachelor's degree, Computer Science
ABOUT LAKSHMI PRASANNA MUDIYALA
Boasting over a decade of immersion in the IT field, I\'m thrilled to share how my journey…
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.