Power Bi Developer

Santhoshi

Power BI Developer

**************@*****.*** 314-***-****

•Accomplished Power BI Developer with 5+ years of experience delivering enterprise BI solutions that transform complex data into actionable insights.

•Innovative in designing interactive dashboards, drill-through reports, and KPI scorecards using Power BI Desktop, Power Query, and advanced DAX.

•Proficient in building scalable ETL pipelines through SSIS and Azure Data Factory, ensuring accurate and reliable data integration.

•Versatile in optimizing SQL queries, stored procedures, and dimensional models (star/snowflake) for efficient enterprise reporting.

•Skilled in leveraging Azure Synapse, Data Lake, and SQL Database to enhance scalability, performance, and cloud analytics adoption.

•Resourceful in automating workflows with Power Automate, developing custom Power Apps, and embedding Python for advanced analytics.

•Thorough in managing Power BI service components including workspaces, dataflows, gateways, and deployment pipelines for enterprise reporting.

•Strategic in aligning BI solutions with business objectives while presenting insights effectively to both technical and business stakeholders.

•Adaptive to Agile and Scrum practices, collaborating in cross-functional teams using Azure DevOps and Git for streamlined project delivery.

•Committed to continuous learning, staying updated on Power BI enhancements, Microsoft Fabric, AI-driven visuals, and best practices in data storytelling.

Power BI & Visualization: Power BI Desktop, Power BI Service, Power Query, Power Pivot, DAX, Dataflows, Custom Visuals, Drill-throughs, Row-Level Security (RLS), AI Visuals, Microsoft Fabric

Data Modeling & SQL: T-SQL, Dynamic SQL, MDX, SSAS (Tabular & OLAP), Dimensional Modeling, Star/Snowflake Schema, ER-win, MS Visio

ETL & Integration: SSIS, Azure Data Factory, Power Automate, Power Apps, REST APIs, Data Gateway, PowerShell, Scheduled Refresh

Programming & Analytics: Python, Pandas, NumPy, Scikit-learn, PySpark, Forecasting Models, Python Scripting in Power BI

Cloud & DevOps: Microsoft Azure, Azure SQL, Azure Storage, Synapse Analytics, Azure DevOps, Git, CI/CD Pipelines

Reporting & Tools: SSRS, SSDT, BIDS, Power Platform, SharePoint, SSMS, Team Foundation Server (TFS)

Methodologies: Agile, Scrum, Waterfall, SDLC, Sprint Planning, JIRA

Main Street Bank, Marlborough, MA Power BI Developer

July 2025 - Present

•Constructed dynamic Power BI dashboards showcasing business KPIs with bookmarks, drill-throughs, slicers, and custom visuals.

•Engineered advanced DAX measures, calculated columns, and KPIs to support executive scorecards and detailed analytics.

•Configured report-level filters, page-level filters, and parameters to deliver tailored, user-specific data exploration.

•Published interactive dashboards to Power BI Service, enabling real-time collaboration, secure access, and mobile-ready insights.

•Integrated Power BI with Power Apps and Azure SQL to unify data entry, visualization, and process tracking.

•Connected on-premises and Azure data sources, ensuring hybrid analytics and seamless refresh capabilities.

•Delivered responsive insights through Power BI Embedded and mobile-optimized reports aligned with UX best practices.

•Combined and transformed multi-source datasets using complex SQL logic to drive unified and actionable reporting.

•Automated operational workflows with Power Automate and created responsive business applications using Power Apps.

•Designed predictive churn models in Python with Scikit-learn and Pandas to strengthen customer segmentation strategies.

•Orchestrated large-scale data processing using Azure Data Factory and Azure SQL Database for scalable BI integration.

•Maintained and managed datasets in Azure Blob Storage and Data Lake Gen2 to support distributed analytics.

•Implemented SSIS ETL pipelines to extract, transform, and load structured data from multiple sources.

•Designed and curated a data mart from warehouse structures to enable self-service BI and advanced reporting.

•Optimized SQL performance with UDFs, CTEs, and stored procedures while enforcing strict data validation.

•Enhanced T-SQL efficiency by applying indexing strategies and performance-tuning tools like SQL Profiler and DTA.

•Utilized SSMS, SSDT, and Azure DevOps for version control, CI/CD pipelines, and collaborative development.

•Facilitated JAD sessions to capture requirements and reinforce enterprise-wide data quality standards.

•Applied Agile Scrum practices, contributing to sprint planning, backlog refinement, and iterative BI delivery.

•Partnered with cross-functional teams to translate business objectives into robust, end-to-end BI solutions.

Environment: SQL Server, T-SQL, SSMS, SSDT, SSIS, SSAS, ETL, Erwin, Power BI, Power BI Desktop, Power Pivot, Power Query, DAX, MS Excel, Power Apps, Power Automate, Python, MS Azure, TFS, Agile

Ascension Health, St. Louis, MO Power BI Developer

March 2024 - April 2025

•Translated business needs into technical specifications, ensuring alignment with development goals.

•Created and managed Agile backlogs and storyboards, adjusting priorities based on evolving business demands.

•Built and shared Excel Power Pivot reports and published Power BI dashboards for key insights.

•Designed interactive Power BI dashboards with advanced visualizations like maps, bar charts, and word clouds tailored to user needs.

•Delivered live Power BI reports and dashboards through Power BI Service, enabling real-time access.

•Optimized Power BI reports with custom themes, slicer synchronization, and advanced interactions to boost user engagement.

•Implemented advanced DAX functions to enhance reporting capabilities with in-depth analysis and dynamic metrics.

•Configured Power BI gateways for real-time data refresh from on-premise sources.

•Integrated Power View reports into Power BI dashboards for a unified, cohesive data visualization experience.

•Optimized T-SQL database objects, including tables, views, indexes, and stored procedures for improved performance.

•Created dynamic T-SQL functions, triggers, and stored procedures to streamline data operations and improve processing efficiency.

•Created reusable test cases with table variables and temp tables for validation, improving code reusability.

•Validated SSIS ETL packages for data extraction, transformation, and incremental loading into data warehouses.

•Modeled and partitioned data in SSAS with DAX to build high-performing OLAP cubes and tabular models.

•Designed a dimensional data model for a new data mart using ERwin, integrating fact and dimension tables.

•Utilized Azure Databricks and Synapse Analytics for processing and transforming large datasets efficiently.

•Automated data pipelines with Azure Data Factory for seamless data flow across services.

Environment: SQL Server, T-SQL, SSMS, SSDT, SSIS, SSAS, Erwin, ETL, Power BI, Power BI Desktop, Power BI Gateway, Power View, DAX, TFS, Azure, Agile

mTouch Labs, India Reports Developer

January 2020 - July 2023

•Collaborated with project teams to define and document requirements during Joint Requirements Definition (JRD) meetings.

•Involved the implementation of Agile methodology throughout the SDLC to enhance flexibility and iterative delivery.

•Developed a data mart using a top-down approach from the existing data warehouse, enhancing reporting and analytics capabilities.

•Designed a robust Power BI data model with multiple fact tables and dimensions to meet business reporting needs.

•Built interactive reports in Excel and Power BI, supporting decision-making and enabling data exploration.

•Developed dynamic Power BI reports by joining tables across multiple databases using advanced SQL queries.

•Created insightful Power BI dashboards and authored user stories to guide the development of impactful reports.

•Enhanced Power BI reports with slicers, filters, subscriptions, and alerts to improve user interaction and data analysis.

•Automated data refresh for Power BI datasets using the Power BI gateway and optimized DAX functions.

•Defined security policies for Power BI reports, linked resources, and data sources to regulate user access.

•Managed report definitions and implemented security policies at the report level to ensure proper access control.

•Created complex T-SQL queries, stored procedures, and user-defined functions (UDFs) to meet customer-specific requirements.

•Automated T-SQL queries for efficient data reconciliation and validation, ensuring smooth data migration.

•Supported management and operations by optimizing data warehousing and reporting processes, improving efficiency.

Environment: SQL Server, T-SQL, SSMS, SSDT, SSAS, SQL Profiler, DTA, Erwin, MS Excel, Power Pivot, Power BI, Power BI Desktop, DAX, Power BI Gateway, TFS, Agile

MS in Information Systems, Saint Louis University.

Contact this candidate