Power Bi Business Intelligence

*

Sushant Kadam

Sr. Power BI Developer / MSBI Developer

************@*****.*** www.linkedin.com/in/skadam9 480-***-****

SUMMARY

• Senior BI Developer with over 10 years of experience designing and delivering intuitive, visually engaging Power BI and Tableau reports, including paginated reporting solutions.

• Proven track record in the Capital Markets, Trading, and Hedge Fund domains, with expertise in high- volume, low-latency data reporting solutions.

• Expert in Power BI development, DAX, Power Query, and semantic modeling, with strong Tableau development background.

• Demonstrates excellent communication skills and long project tenures, delivering consistent results in collaborative and fast-paced environments.

• Proficient in Lakehouse architecture for managing structured and semi-structured data.

• Experienced in creating Delta tables, version-controlled layers, and performance-optimized data models within Fabric Lakehouse.

• Adept at integrating Lakehouse datasets into Power BI semantic models for real-time, unified business intelligence.

• Known for delivering high-performance, maintainable solutions that support enterprise-scale analytics and decision-making.

• Collaborated with business leaders to identify key requirements and implement BI solutions that aligned with overall strategic goals.

• Mentored junior team members, teaching best practices for Power BI development and project management to improve team performance.

• Developed dashboards and key Performance Indicators (KPI) with SQL Server Reporting Services (SSRS) and Power BI.

• Worked on Power BI and prepared dashboards using Tableau to make it more attractive.

• Monitored Power BI service capacity, ensuring high performance for reports and dashboards and troubleshooting any technical issues.

• Developed comprehensive documentation for all BI solutions, including data models, semantic layers, and technical specifications.

• Served as the point of escalation for Power BI-related issues, resolving critical problems to minimize downtime and ensure the smooth functioning of BI systems.

• Scheduled & distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio.

• Expertise in SQL Server Analysis Services (SSAS) to deliver online analytical processing (OLAP) and data mining functionality for business intelligence applications. CERTIFICATION

Microsoft Certified: Power Bi Data Analyst Associate Certified Scrum Master.

TECHNICAL SKILLS

Data Warehousing & BI SQL Server Business Intelligence Studio (SSIS, SSRS, SSAS, DTS), Power BI, SAP BI 7.4.

Database MS SQL Server 2012/2008, Oracle 10g/9i/8i, MYSQL, IBM DB2 7.1/8.0 and MongoDB

2

Reporting Tools SSRS 2012/2008, Crystal Reports XI/X/9/8, Power BI, Excel, QlikView and Tableau

Web Services SOAP 1.2 and REST 2.0

Web Technologies HTML, XML, JavaScript, Angular JS, PHP, Shell Scripting, jQuery Methodologies Agile, waterfall and Scrum.

Tools Eclipse 4.2, SAS, UML Rational Rose, Visio, MS Word, MS Excel, MS Access and MS Project

Web/Application Servers IBM Web Sphere 6.1, JBoss 3.2.x, Apache Tomcat 6.0, Microsoft IIS 6.0 Cloud Environments Azure, AWS and GCP.

Languages C, Python 2.7, UML, Visual C++ 6.0, VB 6.0, C#.Net, VB.Net, PL/SQL, TSQL, R programming and Java EE.

Operating Systems Windows, Linux, Unix

PROFESSIONAL EXPERIENCE

Farm Credit Financial Partners, Springfield, MA July 2022 - Present Sr. Power BI / MSBI Developer

Responsibilities:

• Designed and delivered paginated reports and highly interactive Power BI dashboards supporting business performance tracking and financial analysis.

• Developed Tableau dashboards for operational reporting and migrated key visualizations into Power BI.

• Built paginated reports in Power BI Report Builder for regulatory and client deliverables

• Integrated Power BI with Microsoft Fabric and to enable real-time analytics.

• Used DAX table functions including FILTER, ALL, VALUES, DISTINCT, and RELATEDTABLE.

• Created and managed robust Dataflows and Data Pipelines in Microsoft Fabric to support QA data validations and continuous data integrity checks.

• Ingested structured and semi-structured files into Fabric for testing purposes, enabling end-to-end quality assurance of data lineage and transformation logic.

• Used Power BI, and Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.

• Create and customize simple visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges, and single-number cards.

• Published Power BI Reports in the required originations and made Power BI Dashboards available to Web clients.

• Created multiple data models and used them as a common data source for reporting purposes.

• Used Power BI Gateways to keep the dashboards and reports up to date.

• Developed reports in Power BI by different time intelligence like year-to-date (YTD), month-to-date

(MTD), and same period last year.

• Delivered reporting solutions through Power BI Report Server and embedded visualizations for internal portals.

• Created and managed Lakehouse data layers with Delta tables and real-time integration with Power BI.

• Developed advanced DAX measures and KPIs to support interactive dashboards and business insights.

• Used Power Automate and Dataflows for automated data refresh and workflow notifications.

• Led discussions with cross-functional teams and clients to review pipeline performance and data visualization deliverables.

• Deployed Power BI reports using Azure DevOps for CI/CD and report lifecycle management.

• Optimized Lakehouse query performance using indexing, data pruning, and partitioning techniques.

• Built end-to-end Lakehouse pipelines using Microsoft Fabric's native tools to support reporting and machine learning workloads.

• Built Power BI reports that integrated with Power Apps forms for project tracking and reporting workflows.

• Used DAX to create complex calculations and KPIs, ensuring report accuracy and performance.

• Developed automated dataflows and transformations using Power Query and Power Automate. 3

Environment: Power BI, Power BI Pro, Power BI Desktop, Power BI Service, Power BI Gateway, SAP HANA BW, SAP S4, SharePoint, Microsoft Office, Visio, Outlook, Microsoft Teams, Skype for Business, MS SQL Server 2016/2012, MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), Salesforce, Intacct, Data Gateway, DAX, T SQL, SQL Profiler, XMLA, MS Excel, Excess, Windows 10. NextEra Energy, Houston, TX September 2020 - July

2022

Power BI Developer / MS SQL BI Developer

Responsibilities:

• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them via Power BI.

• Building ad hoc reports in Power BI depending on Business requirements is one of the major responsibilities.

• Used to connect different data sources like SQL DB (SQL Query), Tabular Model (MDX Query), and Web Trends to Power BI and generate reports with different visualizations.

• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.

• Responsible for creating and changing the visualizations in Power BI reports and dashboards based on client requests.

• Created bottom count, top count, cross join, non-ascendants, and log MDX queries for creating Calculations and KPIs on a cube.

• Responsible for scheduling jobs for weekly, and daily data refresh on different Power BI reports.

• Designed a data model with multiple Fact Tables and Dimensions depending on the business requirements.

• Built a Tabular Model cube from scratch data and by MDX queries fetched data to SSRS and Power BI reports.

• Worked with the business users to understand the architecture, data model, business logic and rules to be applied to meet the business needs.

• Discussed with the team to capture high-level transformation rules, produce features, define metrics, and User Interface Design Document acceptance.

• Updated mapping tables related to assigned functional areas as directed by the Business Analysts.

• Worked with Excel Power Pivot Tables.

• Created PowerPivot models and PowerPivot reports, published reports onto SharePoint, and deployed models into SQL Server SSAS instance. Created Parameterized SSRS Reports and PowerPivot Workbooks using data from the Tabular model and Cube data model to prove the functionality of the database.

• Created and published Power BI reports utilizing complex calculated fields, table calculations, filters, and parameters.

• Participated in building and visualizing dashboards using Power BI Desktop.

• Used Power BI to generate combination dashboards and wrote SQL queries for testing the Power BI report/dashboard.

• Implemented Extract filters, calculation Filters, Context filters, and Data source filters to exclude certain values or a range of values as well as better performance.

• Created a story using the sequence of worksheets to convey information using Power BI.

• Developed dashboards in Power BI using different bars and charts like stack bars, bar graphs, scattered plots, and Gantt charts.

• Blended data from multiple sources like SQL Server 2014, PostgreSQL, Oracle 10g, and Teradata into one report by selecting primary keys from each database for data validation.

• Performed advanced analysis, through field calculation and table calculation and was also involved in forecast analysis.

• Used different functions like number, string, date, Type conversions, and aggregate functions.

• Created performance recording to improve Power BI’s performance.

• Effectively used data blending feature in Power BI desktop.

• Combined views and reports into interactive dashboards in Power BI Desktop that were presented to Business Users, Program Managers, and End Users.

• Wrote complex SQL queries to read data from source databases to analyze source systems. 4

Environment: MS SQL Server 2016/2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, Business Intelligence Development Studio (BIDS), SQL Server Analysis Services

(SSAS), SVN (source control), MS Visual Studio.NET, C #, TFS, Visual Studio 14.0/VB.net, VB Script, ETL and Windows 2012 Server, ServiceNow.

Visa Inc, Austin, TX May 2019 – September 2020

Sr MSBI Developer / Power BI Developer

Responsibilities:

• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them via Power BI.

• Building ad hoc reports in Power BI depending on Business requirements is one of the major responsibilities.

• Used to connect different data sources like SQL DB (SQL Query), Tabular Model (MDX Query), and Web Trends to Power BI and generate reports with different visualizations.

• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.

• Responsible for creating and changing the visualizations in Power BI reports and dashboards based on client requests.

• Created bottom count, top count, cross join, non-ascendants, and log MDX queries for creating Calculations and KPIs on a cube.

• Responsible for scheduling jobs for weekly, and daily data refresh on different Power BI reports.

• Designed a data model with multiple Fact Tables and Dimensions depending on the business requirements.

• Built a Tabular Model cube from scratch data and by MDX queries fetched data to SSRS and Power BI reports.

Environment: MS SQL Server 2016/2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), SQL Server Analysis Services (SSAS), Power BI, SVN (source control), Tableau, Informatica, MS Visual Studio.NET, C #, TFS (SharePoint), Visual Studio 14.0/VB.net, VB Script and Windows 2012 Server. IKS Health, India October 2016 – December 2018

Power BI / SQL BI (SSIS, SSAS, SSRS) Developer

Responsibilities:

• Conducted comprehensive database performance tuning using tools such as SQL Profiler, Data Engine Tuning Advisor, and Index Tuning Wizard, ensuring optimal performance for mission-critical systems.

• Designed Star and Snowflake Schemas, building robust data models that supported complex business requirements and optimized query performance.

• Sustained Power BI solutions for healthcare data analytics, prioritizing data integrity and reliable access to improve service delivery.

• Partnered with business stakeholders to define and develop Power BI reports, ensuring alignment with healthcare operational goals.

• Designed SQL procedures for healthcare analytics, facilitating efficient data handling and complex calculations necessary for operational and clinical reporting.

• Optimized SQL queries and database indexes to enhance performance of healthcare data systems,

• Built data analysis prototypes with Power Pivot and Power View, enhancing reporting capabilities through interactive visualizations and advanced data models.

• Extracted and transformed data using Power Query, streamlining the data preparation process and integrating external sources into Power BI.

• Upgraded DTS packages to SSIS, optimizing data integration workflows and improving performance for large-scale data migration projects.

• Migrated heterogeneous databases (Access, Oracle, flat files) to SQL Server 2014 using SSIS Import/Export, facilitating seamless data consolidation.

• Developed tabular models for dashboards, generating Power View reports that offered rich, interactive insights for business decision-makers.

• Configured SQL Mail Agent to automate notifications for SSIS package failures and successes, ensuring proactive monitoring of data workflows.

5

• Designed and maintained multi-dimensional objects (cubes, dimensions) in SSAS, enabling advanced analytical capabilities and supporting data-driven decision-making.

• Built star schema cubes using SSAS, optimizing performance for OLAP systems and enhancing data accessibility for users.

Environment: SQL server 2008/2012/2014 Enterprise Edition, SSRS, SSIS, SSAS, Power BI, .NET Framework, C#, ASP.NET, ADO.NET, Oracle 11g/10g, Visio, MS IIS, XML, MS Excel, Access and Visual Source safe. Billion Apps, India April 2014 – October 2016

MS SQL BI Developer

Responsibilities:

• Developed custom scripts tailored to client needs, focusing on building robust data solutions that support high-performance reporting systems.

• Extensive experience in data modeling and warehousing, applying best practices in OLTP and OLAP environments to ensure efficient data organization and retrieval.

• Transformed data using advanced SSIS transformations, focusing on building streamlined, efficient data pipelines rather than emphasizing ETL development.

• Engineered automated workflows through SSIS package scheduling, supporting business processes with reliable and consistent data updates.

• Designed and migrated complex data systems using SSIS and DTS Wizard, ensuring smooth transitions between platforms and enhancing the overall data infrastructure.

• Built SQL Server solutions, including custom stored procedures and triggers, focusing on data architecture that enables scalable, high-performance operations.

• Developed integrated data flows between SQL Server and other platforms (Excel), focusing on the architecture and design that facilitated seamless data exchange.

• Engineered error-handling frameworks and optimized data flow tasks in SSIS, contributing to the reliability and robustness of the data architecture.

• Designed Power BI dashboards to provide intuitive, interactive insights for business users, reducing the focus on manual report generation.

• Optimized Power BI queries, focusing on building efficient data models that support rapid, on-demand insights rather than traditional reporting.

• Created interactive reports in Power BI, enabling dynamic data exploration for business decision-makers.

• Engineered cascading reports and dynamic queries, allowing business users to drill into data and customize their own views, focusing on the design and flexibility of the data architecture.

• Collaborated with business leaders to design and implement data models and reporting systems, ensuring alignment with strategic goals and focusing on the architecture of solutions.

• Designed and implemented dimensional models in SSAS, creating scalable and high-performance reporting environments.

• Built drill-down reports in Power BI and SSRS, focusing on architecture and the flexibility for end-user customization.

• Developed and deployed multi-dimensional cubes in SSAS, architecting solutions that enhance the ability of users to explore data dynamically.

Environment: SQL Server 2008/2012, SSIS, SSRS, SSAS, T-SQL, Access, Tableau, Tableau Server, Excel, Visual Studio, Data Analyzer, Business Objects 6.5, ER Win 4.0, Visual Studio.NET 1.1, IIS, ASP, C#, Oracle 9i. EDUCATION

Bachelor of Engineering, University of Mumbai, India

Contact this candidate