Senior Data Analyst & Power BI Developer

SAIRAMREDDY KATHI

Data Analyst **************@*****.*** +1-773-***-**** https://www.linkedin.com/in/kathi-sai-ram-reddy-b99902246/ Professional Summary:

• Experienced Senior Data Analyst & Power BI Developer with 5+ years of expertise delivering enterprise-grade analytics, reporting, and BI solutions across banking, pharmaceutical, and manufacturing domains.

• Developed interactive reporting using Power BI Desktop, incorporating custom visuals, drilldowns, bookmarks, slicers, KPI cards, and intuitive navigation for strategic insights.

• Built advanced analytical logic using DAX, including complex measures, time-intelligence (YoY, MoM, YTD, rolling averages), forecasting, KPIs, and performance indicators.

• Designed scalable data models using star/snowflake schemas, optimized relationships, semantic layers, and storage modes to improve dashboard performance.

• Performed extensive data shaping with Power Query / M Language, including merges, unpivoting, conditional logic, and complex transformations.

• Wrote high-performance queries using SQL (T-SQL, SQL Server, Azure SQL, Oracle)—joins, CTEs, stored procedures, views, aggregations, and optimization.

• Built end-to-end ETL/ELT pipelines using SSIS, Azure Data Factory (ADF), Synapse, Logic Apps, and on-prem/cloud integrations.

• Created enterprise-grade operational reports using SSRS and Power BI Report Builder, including drill-through paths, dynamic parameters, conditional formatting, and automated subscriptions.

• Integrated data from multiple sources including Azure SQL, SQL Server, SharePoint, REST APIs, Power Apps, Excel, and cloud/on-prem systems.

• Strengthened BI governance with Row-Level Security (RLS), workspace permissions, dataset refresh management, gateway configuration, and Power BI Service administration.

• Applied Python (Pandas) for data validation, preprocessing, outlier detection, and preparing refined datasets for BI models.

• Collaborated closely with business stakeholders, engineering teams, QA, and leadership to gather requirements, validate data, document logic, and support self-service analytics adoption. Technical Skills:

BI & Reporting: Power BI (Desktop, Service, Dataflows), Tableau (Desktop, Server, Online), SSRS, Power BI Report Builder, Paginated Reports, Custom Visuals, Drill-through/Drill-down, Bookmarks. Data Modeling & Analytics: DAX (Time-Intelligence, KPIs), Power Query (M), Power Pivot, Star & Snowflake Schemas, Semantic Models, Calculated Columns, Measures, Data Profiling. ETL / Data Engineering: SSIS, Azure Data Factory (Pipelines, Dataflows), Azure Synapse (SQL, Pipelines), Alteryx, Tableau Prep, Power Automate Flows, Incremental Refresh, Data Gateways. Databases & SQL: Azure SQL Database, SQL Server, Oracle DB, T-SQL, Stored Procedures, Views, CTEs, Query Optimization, Joins, Indexing.

Cloud & Integrations: Azure (ADF, Synapse, Logic Apps, Functions), REST APIs, SharePoint, Power Platform, On-Prem Gateways, Excel, CSV/Flat Files, OData, JSON.

Automation & Applications: Power Automate, Power Apps, Azure Functions, Logic Apps, Scheduled Refresh & Subscriptions, Workflow Integrations.

Programming & DevOps: Python (Pandas, NumPy), M Language, Git, Azure DevOps (Repos, Pipelines), RLS, Workspace/Admin Governance, Performance Analyzer.

Education:

Master of Science (M.S.) in Data Science

• Depaul university Chicago, IL USA Sep 2023 - July 2025 Bachelor of Technology (B.Tech.) in Electronics and Communications Engineering

• Swarna Bharathi Institute of science and technology, Khammam, India Aug 2015 to May 2019 Certifications:

• Azure Data Engineer Master Class DP-203 DP-600 DP-700 – Udemy

• Microsoft Power BI: PL-300 Certification

• SQL Bootcamp

• Scrum Certification – In progress

Professional Experience:

Bank of Montreal May 2024 – Current

Sr. Data Analyst / Power BI Developer Chicago, IL

• Developed interactive reporting solutions using Power BI Desktop, creating user-friendly dashboards with custom visuals, drilldowns, slicers, bookmarks, and filters that delivered real-time insights into sales trends, customer engagement, and financial performance.

• Built scalable semantic layers through strong data modeling, applying star schema design, calculated columns, and optimized relationships to improve report performance, clarity, and usability for business stakeholders.

• Applied advanced DAX and time-series intelligence (YoY, MoM, rolling averages, forecasting) to build accurate measures, trend analyses, KPI scorecards, and performance indicators that supported strategic decision-making.

• Integrated diverse systems—Azure SQL Database, SQL Server, SharePoint, REST APIs, and Logic Apps—into unified reporting environments, ensuring consistent, high-quality data across departments.

• Designed end-to-end ETL solutions using SSIS and Azure Data Factory, extracting data from multiple sources, transforming it into usable formats, and loading it into SQL Server and Azure SQL for downstream analytics.

• Created sophisticated enterprise reports using SSRS, including drill-through paths, dynamic parameters, conditional formatting, pagination, and automated subscription emails for quarterly and monthly reporting cycles.

• Improved analytical performance with strong SQL development—writing optimized queries, stored procedures, views, and validation scripts, while troubleshooting dataset refresh issues and SQL bottlenecks.

• Created analytical logic using DAX (time-intelligence, KPIs, calculated columns, complex measures) and Tableau calculations to support trend analysis, forecasting, and performance measurement.

• Strengthened governance and security in enterprise reporting by implementing Row-Level Security (RLS), managing permissions in Power BI Service, automating refresh cycles through Power BI Gateway, and ensuring accurate and timely data availability.

• Enhanced reporting capabilities through custom Power BI visuals, dynamic filters, interactive tooltips, and intuitive navigation pages, creating a seamless user experience and encouraging self-service analytics adoption.

• Streamlined operations with Power Automate workflows and Azure Functions, automating recurring data processing, handling complex transformations outside the primary ETL pipeline, and reducing processing time and manual workload.

• Performed big-data analytics and cross-platform integrations using Azure Synapse Analytics, enabling near real-time insights, reconciling data between multiple systems, and collaborating with analysts, engineers, and business leaders in Agile environments to deliver high-quality BI solutions. Cipla Jun 2021 – Aug 2023

Data Analyst (Power BI) Hyderabad, IN

• Designed end-to-end reporting solutions using Power BI Desktop, building dashboards with diverse visuals (KPI cards, waterfall charts, maps, bubble charts, heat maps) to support strategic, operational, and financial analysis.

• Developed detailed analytical layers using DAX and time-intelligence logic, creating measures for trends, forecasts, period comparisons, and performance tracking across multiple business domains.

• Modeled data using star and snowflake schemas, optimized relationships, reduced cardinality, and structured semantic layers to improve refresh speed, storage efficiency, and overall dashboard performance.

• Transformed and cleansed complex datasets using Power Query, applying joins, merges, unpivoting, conditional logic, and custom M scripts to shape data for consistent reporting.

• Built secure reporting environments by implementing Row-Level Security (RLS) and managing workspace permissions in Power BI Service for controlled, role-based data access.

• Wrote high-performance SQL (T-SQL) scripts, including joins, aggregations, stored procedures, CTEs, and views, to prepare, validate, and automate data pipelines supporting BI and analytics workloads.

• Developed robust ETL/ELT processes using SSIS and Azure Data Factory, migrating data pipelines to the cloud and automating transformations across on-prem and Azure environments.

• Integrated Power BI with Azure SQL, SQL Server, SharePoint, REST APIs, Power Apps, and on-prem data sources through dataflows and gateways, ensuring consistent and reliable multi-source reporting.

• Used Python (Pandas) for data validation, outlier detection, preprocessing, and exploratory analysis, feeding refined datasets into Power BI models for deeper insights.

• Created paginated and operational reports using SSRS and Power BI Report Builder, incorporating drill-through logic, parameters, subscriptions, and compliance-focused formatting.

• Managed Power BI administration tasks—gateway configuration, workspace governance, refresh monitoring, version control with Azure DevOps, and troubleshooting performance issues.

• Collaborated with business users, product owners, and engineering teams to gather requirements, translate them into scalable BI solutions, prepare documentation, conduct training, and support self-service analytics adoption. M&M (Mahindra & Mahindra) Mar 2019 – May 2021

Associate Data Analyst Hyderabad, IN

• Built analytical dashboards using Power BI, creating clear visual stories with bar/line charts, maps, KPIs, scatter plots, heat maps, and advanced drill-down/through interactions to support business decision-making.

• Developed efficient data models using Power BI (star/snowflake schemas, Power Pivot) and Tableau data sources, optimizing relationships, reducing cardinality, and improving dashboard performance across large datasets.

• Created analytical logic using DAX (time-intelligence, KPIs, calculated columns, complex measures) and Tableau calculations to support trend analysis, forecasting, and performance measurement.

• Cleaned, transformed, and shaped raw data with Power Query (M Language), Alteryx, and Tableau Prep—performing joins, merges, unpivoting, conditional logic, and applied steps to ensure structured and reliable datasets.

• Used SQL (Oracle & SQL Server) extensively to extract, validate, and prepare data; wrote optimized queries, joins, aggregations, CTEs, views, and stored procedures to support reporting and automated data processing.

• Worked with ETL and ELT workflows using SSIS, Azure Data Factory (ADF), and internal pipelines, including copy activities, transformations, and migrating on-prem ETL processes to cloud-based solutions.

• Integrated dashboards with multiple data sources including Azure SQL, SQL Server, SharePoint, Excel, REST API outputs, and internal systems to deliver consistent and unified reporting.

• Managed report deployment and data refresh pipelines in Power BI Service, Tableau Server, and Tableau Online by configuring scheduled refreshes, monitoring failures, and handling basic gateway setups for on-prem data.

• Implemented secure access using Row-Level Security (RLS) in both Power BI and Tableau, ensuring that users only viewed data aligned with their department, role, or region.

• Leveraged Power Apps and Power Automate to build simple forms, workflow automations, and data-driven enhancements that supported operational processes and improved reporting efficiency.

• Collaborated with business stakeholders across marketing, operations, finance, and supply chain to gather requirements, document logic, perform data validation with QA teams, and provide training for self-service analytics adoption.

Contact this candidate