Senior MSBI, Power BI & Data Analytics Lead

Pravalika Reddy

Sr. MSBI/Power BI Developer /Data Analyst

513-***-**** *************.*@*****.***

PROFESSIONAL SUMMARY:

Over 6+ years of hands-on experience in Microsoft Business Intelligence (BI), Data Warehousing, Data Analytics, and Azure Cloud Platforms, with strong expertise in SQL Server, Power BI, SSIS, SSRS, SSAS, and Oracle BI for delivering end-to-end enterprise BI solutions.

Proficient in building KPI-driven, real-time dashboards and executive-level reports using Power BI, leveraging DAX, Power Query, and M Code for dynamic reporting, advanced calculations, and optimized data transformations.

Designed and maintained Power BI composite models with aggregations and dual storage modes to improve performance on large datasets, while implementing secure Dynamic Row-Level Security (RLS) on both Power BI Service (Cloud) and Power BI Report Server (On-Prem).

Specialized in SCADA systems, PLC/DCS integration, and real-time data acquisition using tools like Wonderware, Siemens, and GE iFIX.

Built robust data pipelines and automated ETL workflows with SSIS, Azure Data Factory, and Informatica, integrating SQL Server, Oracle, and cloud sources.

Designed and implemented KPI-driven dashboards and executive reports using Power BI, Oracle Analytics, and BI Publisher, including Dynamic RLS and data flows.

Expert in T-SQL, PL/SQL, Python, and embedded C for developing data logic, control software, and system simulations.

Worked with time-series databases like InfluxDB, OSIsoft PI, and integrated Azure Data Lake for scalable industrial data solutions.

Developed multidimensional and tabular models using SSAS, authored complex DAX/MDX queries for OLAP analytics.

Experienced in managing Power BI assets across DEV, QA, and PROD environments using Power BI Premium, deployment pipelines, and workspace governance frameworks. Strong experience managing enterprise BI environments including capacity planning, deployment pipelines, and role-based user provisioning in Power BI Service and Premium.

Developed and maintained Power BI Data flows, applying Data Folding and Query Reduction techniques to enhance performance and scalability. Proficient in developing KPI-based reports for real-time streaming data using Power BI Premium.

Expert in writing advanced T-SQL queries using CTEs, derived tables, complex joins, sub-queries, window functions, and views across SQL Server, Oracle, PostgreSQL, and IBM DB2 for data aggregation and reporting optimization.

Led multiple ETL projects using SSIS, building pipelines that extract, transform, and load data from SQL Server, Oracle, and IBM Cognos BI into centralized data warehouses and marts.

Skilled in dimensional modeling with Star Schema (Kimball) and Snowflake schema, designing Data Marts across OLTP and OLAP systems to support analytical reporting.

Built advanced SSRS reports, including Drill-Down, Parameterized, Cascading, Conditional, Ad-hoc, Sub-Reports, and visualizations tailored for business reporting needs. Hands-on in optimizing SSRS reports with drill-down, cascading, parameterized, and ad-hoc features for operational reporting.

Experienced in developing SSAS multidimensional and tabular models, creating analytical cubes, and authoring MDX and DAX queries to support complex OLAP analytics.

Hands-on experience with Azure Data Factory, Azure SQL Database, Azure Analysis Services, and Azure Blob Storage for cloud-based ETL processing, data integration, and analytics delivery.

Worked on AWS RDS, S3, and Redshift, managing cloud-based relational databases and integrating them with Power BI and other tools for enterprise reporting.

Developed analytical dashboards in Oracle BI, integrating Oracle Databases into Power BI and Tableau, and delivered large-scale BI solutions hosted on Oracle Cloud and IBM Cloud.

Created and orchestrated automated reporting workflows using Python scripts, SSIS packages, and Azure Logic Apps to streamline operations and reduce manual intervention.

Processed and analyzed massive datasets using Apache Spark and PySpark, integrating big data outputs into Power BI for real-time analysis and insight generation.

Implemented a variety of machine learning algorithms in Python, including KNN, Logistic Regression, SVM, Decision Trees, Random Forest, XGBoost, and LightGBM for classification, prediction, and pattern recognition in enterprise datasets.

Utilized R programming for data wrangling, statistical modeling, and generating advanced reports using RMarkdown and Flex Dashboards.

Integrated external datasets into BI systems using RESTful APIs and Web Services, enabling live connections and automated data refreshes for timely insights.

Led multiple BI initiatives, provided hands-on training in Power BI, DAX, M Code, and SQL, and mentored teams on best practices in modern BI development and delivery.

Experienced in coordinating across Production, UAT, and Development environments to ensure report accuracy and deployment readiness.

Strong communication and problem-solving abilities, with a proven track record of working across cross-functional teams and delivering results under tight deadlines in diverse environments.

TECHNICAL & BUSINESS SKILLS:

Category

Key Skills

Data & BI Skills

Power BI, SSAS, Tableau, Cognos BI, KPI Reporting, Data Visualization, Big Data Analytics

ETL & Integration

SSIS, Informatica, Azure Data Factory (ADF), RESTful APIs, Web Services, Data Pipelines

Cloud Platforms

Azure (ADF, SQL DB, Databricks, Blob Storage), AWS (RDS, S3, Redshift), Oracle Cloud, IBM Cloud

Programming Languages

Python (Pandas, NumPy, Matplotlib, Seaborn, Scikit-learn), R (Tidyverse, RMarkdown), PL/SQL, T-SQL, MDX

Data Science & ML

Machine Learning (Supervised), Hypothesis Testing, Regression, ANOVA, SciPy, PySpark, Apache Spark

Reporting & Visualization

Power BI (DAX, M Code), SSRS, Tableau, RMarkdown, Flex Dashboards, Power Query, Real Time Streaming

Wonderware, Siemens SCADA, GE iFIX, PLC/DCS Integration

Data Modeling & Warehousing

Star Schema, Snowflake, OLAP, OLTP, Data Marts, ODS, Database Design,TFS,Windows Server

SQL & Database Tools

SQL Server (2008–2019), Oracle (9i–18c), PostgreSQL, DB2, Teradata, Index Tuning, Performance Tuning

API & Web Integration

API Integration, Data Services, Power BI REST API, XMLA, Microsoft Flow

Project & Team Skills

Agile, Scrum, Jira, Waterfall, Team Collaboration, Stakeholder Communication, Mentoring

Statistical Analysis

Descriptive & Predictive Statistics, Correlation Analysis, Mathematical Modeling, Trend Forecasting

Methodologies & Tools

Business Objects, OBIEE, BI Stack (Power Pivot, Power Query, Power Map), ADLS, Databricks Delta

PROFESSIONAL EXPERIENCE:

CARESOURCE, DAYTON, OH July 2023 to present

MSBI/Power BI Developer /Data Analyst

Responsibilities:

Gathered and analyzed business requirements in collaboration with key stakeholders, including finance teams and senior management, to define relevant metrics and KPIs for dashboards and reports. Based on these insights, created optimized data models using Power BI and Erwin Data Modeler, applying Kimball Dimensional Modeling principles to ensure the structure supported scalable analytics.

Developed robust data acquisition pipelines integrating financial systems with real-time monitoring dashboards using Power BI and Oracle Analytics.

Optimized PL/SQL procedures for performance tuning and seamless integration with BI Publisher for scheduled financial reporting.

Led automation of SCADA-like event alerts for transaction anomalies using custom DAX logic and embedded Power BI rules.

Created dynamic dashboards for executive insights leveraging dual storage modes and large-volume composite models.

Collaborated across teams to implement data integrity and compliance frameworks, ensuring secure and governed BI access.

Transformed raw data into clean analytical formats using Power Query and M Code, building calculated columns and custom parameters. Created accurate relationships in Power BI between datasets from SQL Server, Oracle, and Excel, ensuring proper joins and consistent measures across reports.

Implemented near real-time data pipelines using CDC (Change Data Capture) with Dibarium connectors and Kafka message compaction, supporting real-time reporting scenarios. Enhanced user interaction by developing custom Power BI applications using Power Apps, automating workflows and embedding reporting features into business processes.

Built complex models in Azure Analysis Services (AAS) and integrated them with Power BI for high-performance enterprise-level analytics. Handled Power BI administration tasks such as capacity management, deployment governance, and user provisioning, ensuring platform reliability and security.

Utilized advanced Power BI visuals—including tree maps, KPI indicators, line and bar charts, maps, and what-if parameters—to create engaging and interactive dashboards tailored for decision-makers. Maintained continuous communication with business stakeholders, managed expectations, and ensured all reporting deliverables aligned with regulatory and business needs.

Delivered training and mentorship to business analysts and power users on tools like Power BI, SSRS, and Tableau, enabling self-service reporting and analytics. Documented all developed assets including ETL processes, dashboards, and reports, promoting maintainability and knowledge transfer across the team.

Finally, implemented composite models in Power BI using both import and Direct Query modes to balance performance and flexibility in handling large-scale datasets and complex business use cases.

Project Impact: Enhanced operational intelligence by integrating SCADA-like monitoring into financial systems, enabling automated data acquisition and real-time reporting via Oracle BI and Power BI, which reduced manual intervention by 50% and supported faster compliance analysis.

HUMANA, DALLAS, TX May 2021 to Jun 2023

Role: MSBI/Azure Data /Power BI Developer

Responsibilities:

Collaborated with finance teams, business analysts, and stakeholders to gather healthcare reporting requirements, ensuring full compliance with HIPAA, Medicaid/Medicare, and EDI standards (837, 834). Designed and developed dynamic Power BI dashboards and scorecards focused on Customer Deep Dive, Sales Trends, and Revenue Metrics, leveraging advanced features like DAX and M Code.

Led the migration of over 100 legacy Crystal Reports to Power BI, using SQL Server as the primary data source, and ensured adherence to ICD coding and Medicaid/Medicare EDI compliance. Designed complex data models in Erwin Data Modeler, accurately representing healthcare data structures while ensuring consistency and audibility.

Integrated Power BI with SQL Server Analysis Services (SSAS), developing both multi dimensional and tabular models, and utilized MDX and DAX to analyze large healthcare datasets efficiently. Configured and implemented Dynamic Row-Level Security (RLS) in Power BI Service to safeguard sensitive healthcare data and align with internal data governance policies.

Transitioned legacy ODBC and ANSI SQL connections to secure SQL Server integrations to enhance data integrity, access control, and HIPAA compliance. Developed robust ETL pipelines using SSIS and complex SQL queries, migrating data from legacy systems into Power BI, with focus on healthcare reporting and regulatory alignment.

Collaborated with data engineers and DBAs to tune SQL queries, manage indexes, and optimize performance across the SQL Server ecosystem. Automated ETL workflows using Azure Data Factory, streamlining ingestion and transformation processes from sources like PostgreSQL, Oracle, and flat files into Power BI.

Integrated medical device data and imaging systems into centralized analytics using Python, Power BI, and time-series databases.

Implemented real-time dashboards for MRI operations using Power BI Service with row-level security (RLS) for clinical roles.

Built automated control workflows simulating SCADA behaviors to track equipment status and alerts.

Designed and tested embedded logic scripts for predictive maintenance, optimizing equipment uptime and reducing false alerts.

Supported ETL pipelines that combined EHR systems, Azure Data Lake, and Oracle backend for scalable reporting.

Built real-time, interactive Power BI dashboards for key healthcare metrics such as patient outcomes, resource utilization, and compliance tracking. Designed intuitive visualizations using Power BI Desktop, including bar charts, line graphs, tree maps, KPIs, cards, and maps for analyzing performance across healthcare locations.

Developed detailed paginated reports using Power BI Report Builder, enabling drill-down and drill-through functionality to explore financial and healthcare data with precision. Configured and monitored Power BI gateways to support secure, on-premises data transfers and scheduled refreshes to the Power BI Cloud Service.

Managed full Power BI administration, including deployment pipelines, capacity management, and role-based access provisioning, ensuring governance and scalability across enterprise reporting. Delivered hands-on training to business analysts and end-users, enabling self-service analytics while upholding HIPAA and EDI standards.

Monitored and audited Power BI reports for adherence to HIPAA, EDI 837/834, and ICD coding guidelines, resolving discrepancies and ensuring secure data handling. Developed and maintained custom Power BI applications using Power Apps to automate workflows and enhance report interactivity in compliance with healthcare regulations.

Integrated Power BI with Azure Analysis Services (AAS) to enhance analytics capabilities and support real-time operational and financial insights. Leveraged SQL Server features like query plans, indexed views, and Data Folding to optimize report performance, significantly reducing load times for large datasets.

Published numerous reports to Power BI Service, enabling secure access for internal teams and external partners through role-based access controls. Ensured transparency and consistency across reporting outputs through stakeholder reviews, collaborating closely with finance, compliance, and operations teams.

Automated report generation and distribution cycles (daily, weekly, monthly, quarterly) to replace manual processes, enhancing reporting reliability and responsiveness. Supported the upgrade and maintenance of the Power BI infrastructure, ensuring migrated reports remained compliant with HIPAA, EDI, and ICD standards.

Maintained ongoing communication with clients, project managers, and stakeholders via Jira, Microsoft Teams, and Zoom, ensuring alignment on deliverables, timelines, and data compliance requirements.

Project Impact: Delivered automated control workflows and real-time device analytics that mirrored SCADA control capabilities, improving system reliability and predictive maintenance in clinical settings by 30% using Power BI, Azure, and embedded Python logic.

INTEL CORPORATION, DETROIT, MI January 2020 – April 2021

MSBI/Azure Data /Power BI Developer

Responsibilities:

Collaborated closely with Business Systems Analysts and key stakeholders to refine business requirements and ensure all database constraints were satisfied. Conducted thorough impact analysis for changes in data structures to maintain system integrity.

Designed and developed advanced Power BI data models using DAX and M Code, validating accuracy with data from SQL Server, Azure SQL Database, and Oracle sources. Created highly interactive dashboards and custom measures aligned with Intel’s strategic KPIs.

Built complex ETL pipelines with SQL Server Integration Services (SSIS) to extract and transform data from Excel, Oracle, SQL Server, and Azure Blob Storage, preparing it for enterprise reporting. Automated ETL workflows using Azure Data Factory, ensuring seamless, timely data ingestion and transformation

Developed embedded analytics modules using C and Python to process edge data streams from industrial sensors

Designed and deployed automated acquisition systems integrated with Influx DB and Azure Data Lake.

Simulated control feedback loops using MATLAB for device response modeling and predictive tuning.

Configured data pipelines for real-time sensor data ingestion and visualized KPIs in Power BI and BI Publisher.

Aligned control logic and analytics with ISA-95 and cybersecurity standards for system reliability and compliance.

Optimized Power BI dashboards by implementing best practices in data modeling, Row-Level Security (RLS), and Incremental Refresh, improving both performance and data protection. Published reports to Power BI Service and configured Power BI gateways for secure data access and scheduled refreshes across business units.

Developed custom SQL queries, stored procedures, and views in SQL Server Management Studio (SSMS) to support Power BI reporting. Collaborated with data engineers and DBAs to enhance SQL performance, leveraging tools like SQL Profiler and Index Tuning Wizard.

Led the migration of legacy Crystal Reports to Power BI, including integration with Azure Cosmos DB and applying hierarchical RLS for secure data access. Built financial and operational SSRS reports using expressions, parameters, and drill-down capabilities for Intel’s finance teams.

Implemented robust data governance policies within Intel’s BI framework, improving data accuracy and maintaining compliance with internal standards. Configured Azure Analysis Services (AAS) for ad-hoc data exploration, enabling real-time interaction with multidimensional models via Power BI.

Integrated Tableau Desktop and Tableau Server for additional dashboarding needs, analyzing data from sources like PostgreSQL and SQL Server. Designed Power BI dashboards tailored for sales forecasting, incorporating Python scripts and R for predictive analytics and trend modeling.

Collaborated with IT teams to implement Change Data Capture (CDC) pipelines, keeping front-end reports in sync with backend transactional systems. Created custom views using SQL Developer for financial and operational reporting in Power BI.

Executed extensive performance tuning within Power BI and SQL Server, significantly reducing dashboard load and query execution times. Managed Power BI administration including deployment pipelines, capacity, and access provisioning across Intel’s analytics environment.

Trained Intel’s business users in Power BI, enabling widespread adoption of self-service BI capabilities through tailored training and hands-on sessions. Documented all BI processes including ETL workflows, report configurations, and SQL scripts for long-term maintainability and team onboarding.

Engaged continuously with data modelers, business analysts, and key stakeholders, gathering feedback and iteratively enhancing dashboards, ETL pipelines, and reporting solutions to meet Intel’s evolving business demands.

Project Impact: Enabled real-time executive reporting and self-service analytics at scale, reduced manual data preparation by 65%, improved query performance by 50%, and empowered Intel’s global teams with timely, actionable insights across finance, operations, and sales.

WELLSFARGO, CHARLOTTE, NC Oct 2018 to Dec 2019

MSBI (SSAS, SSIS and SSRS)/ Tableau Developer

Responsibilities:

Joined the Data Analytics team as an intern, where I quickly became an active contributor across multiple high-impact projects. Collaborated with stakeholders and clients to analyze business requirements and ensure clear alignment on goals, deliverables, and timelines throughout the project lifecycle.

Gained hands-on experience developing and debugging dashboards using Power BI and Tableau, leveraging both tools for interactive data visualization and insight-driven reporting. Documented stakeholder requirements in detail to build dashboards and reports that met precise business needs.

Worked closely with POD and supply chain teams, applying data-driven insights to support strategic planning and improve operational efficiency. Used Alteryx for data preparation, combining and transforming data from multiple sources to produce clean, meaningful datasets.

Defined key performance indicators (KPIs) and translated them into actionable visualizations. Designed mock-up dashboards in Tableau to prototype solutions and incorporate stakeholder feedback through iterative improvements.

Built dynamic Tableau dashboards using both out-of-the-box and custom features, utilizing functions like Level of Detail (LOD), WINDOW_SUM, WINDOW_AVG, and conditional logic to support complex calculations. Troubleshot performance bottlenecks and implemented optimizations to ensure smooth user experiences.

Implemented row-level security in Tableau, setting up user filters to restrict access to sensitive data. Managed report scheduling, data connections, and permissions in Tableau Server, streamlining access and deployments.

Used SQL to handle large datasets, writing optimized queries involving joins and aggregations for accurate and timely reporting. Developed specialized dashboards, including usage analytics and GIS-based assessments, connecting to various data sources to drive deeper insights.

Provided training and mentoring to end-users, helping them build their own reports and enabling a culture of self-service BI. Conducted data quality testing by validating dashboard outputs against source systems and supported UAT and QA testing teams with data for validation.

Tools Used: Power BI, Tableau, Alteryx, SQL, SQL Server, Tableau Server, SSRS, SSIS, TFS, and other data visualization tools.

EDUCATION: Masters in Computer Science from University of Dayton

Contact this candidate