pavana yanamandala

Developed KPI-driven Power BI and Microsoft Fabric dashboards and executive reporting for retail banking, regulatory reporting, risk, and customer operations, improving decision-making efficiency by 40%. Built 50+ interactive dashboards and automated workflows that increased business user engagement by 30%, and streamlined MIS/regulatory reporting to reduce report generation time by 25%.

Delivered healthcare analytics using Azure Databricks by building scalable data processing jobs for patient, claims, clinical, and operational datasets. Orchestrated end-to-end pipelines with Azure Data Factory and Apache Airflow, and built Power BI dashboards with advanced DAX and KPI frameworks to support patient outcomes and operational reporting.

Built Power BI Desktop data models using Power Query (M) and DAX, including mashups and transformations such as unpivot/pivot to shape reporting datasets. Implemented row-level security, governed publishing and access for compliance/auditing, and delivered dashboards across web and mobile clients.

Developed QlikView dashboard extension objects and created an Esri maps connector for client reporting. Built QlikSense/QlikView applications with end-user dashboards, QVD-based data modeling, incremental transaction loads, set analysis expressions, and performance optimizations by removing synthetic keys and circular loops.

Designed and developed QlikView 11 end-user applications including scorecards, dashboards, reports, and monitors, using complex expressions with set analysis. Extracted and transformed data from Teradata, SQL Server, MS Access, and flat files, wrote SQL for validation/analysis, and built QVD-based models with incremental transaction loading and optimized script/data transformations.

Imported and modeled data from web files, MS SQL Server, and MS Excel using OLEDB/ODBC, supporting enterprise DW/BI and dashboarding initiatives. Implemented QlikView 9.0 solutions by generating ETL scripts, developing complex reports, and scheduling reload and distribution tasks with QlikView Publisher.

Converted business requirements into Oracle Forms/Reports and web-based interfaces using Oracle Designer 9i and related tooling. Tuned SQL for performance, created Unix shell scripts for scheduled batch processing, and supported rollout, UAT, and ongoing application support.

Produced database and low-level technical designs, enhanced physical data models, and optimized SQL queries for large transaction datasets. Implemented range-hash partitioning and developed ETL/cleansing SQL mappings with scheduled Korn shell scripts, supporting unit test planning and defect tracking.

Earned a Master of Business Administration (MBA) from the Carlson School of Management at the University of Minnesota.

Earned a Master of Science in Information Systems from the University of Aberdeen in the United Kingdom.

Earned a Bachelor of Technology from NIT Warangal.