Power Bi Business Intelligence

Smriti Chauhan (Power BI Developer)

https://www.linkedin.com/in/smriti-chauhan-08a802232

Email:****************@*****.*** / Phone: 469-***-****

Address: McKinney, TX 75070

7+ years of experience as a Business Intelligence (BI) Developer with a strong focus on Power BI, Snowflake, ETL processes, and data integration across various domains.

Certified Power BI Professional, with expertise in creating interactive dashboards, reports, and visualizations using DAX, Power Query, and Power BI Pipelines.

SAFe 6 Certified Product Owner/Product Manager, with hands-on experience leading Agile teams, managing product backlogs, and ensuring the successful delivery of BI solutions.

Specialized in designing and developing a wide range of financial reports, including Loan Analytics, Payments, Member and Account Portfolios, Deposits, Merchant Relationships, Transactions, and Executive Summaries, providing insights into financial performance, customer relationships, and operational trends to support data-driven decision-making.

Skilled in Visual Studio for version control, utilizing Git and Azure DevOps for source control management, ensuring efficient collaboration and streamlined development workflows.

Proficient in Power BI workspaces version control, handling report deployments, refresh scheduling, and ensuring smooth collaboration across team members in the Power BI Service environment.

Experienced in building and sharing MDM-based semantic data models across teams, leveraging shared datasets and ensuring consistent data sources across Power BI workspaces.

Expertise in working with PBIX/PBIT file formats, creating reusable Power BI templates for efficient report development and standardization across business units.

Proficient in bi-layer data sharing, designing multi-layered data models to ensure efficient data access, transformation, and presentation in Power BI reports.

Skilled in leveraging calculation groups in Power BI for creating reusable and efficient DAX calculations across reports and dashboards.

Implemented drill-through functionality and cross-report navigation, enabling users to seamlessly interact with reports and gain detailed insights from multiple data sources.

Extensive experience with Q&A functionality in Power BI, allowing users to ask natural language questions and receive real-time insights from the reports.

Expertise in using bookmarks and field parameters to create dynamic, interactive reports and dashboards that meet business needs and enhance the user experience.

Extensive experience with Snowflake for data warehousing, data modeling, and creating high-performance BI solutions to support business needs in industries like financial services and credit union reporting.

Expertise in CI/CD processes using Azure DevOps, Power BI Pipelines, and Airflow for automating report deployments, ensuring quality control, and maintaining report integrity.

Strong knowledge of Agile methodologies, effectively collaborating with cross-functional teams to deliver impactful Power BI solutions while focusing on stakeholder needs and product goals.

Enhanced Power BI dashboards with dynamic slicers, calculated measures, and interactive visualizations, enabling better user experience and real-time data insights.

Provided support to product teams by resolving Power BI-related issues, ensuring smooth functionality, and optimizing reporting solutions based on stakeholder feedback.

Assisted QA resources in defining test cases and setting up scenarios for QA testing and User Acceptance Testing (UAT), ensuring the accuracy and reliability of Power BI reports.

Certifications:

Microsoft Certified: Data Analyst Associate (Power BI)- PL-300 - Expertise in Power BI Desktop, Power Query, DAX, and Power BI Service, delivering advanced business intelligence solutions and visualizations.

SAFe 6 Product Owner/Product Manager (POPM) Certification - Certified in Agile methodologies, with experience in driving product development, managing backlogs, and leading cross-functional teams to deliver customer-centric solutions using the SAFe framework.

Education:

Bachelor of Technology in Computer Science & Engineering

Technical Skills:

Power BI: Power BI Desktop, Power BI Service, Power Query, DAX, Power BI Gateway, Power BI Pipelines, Power BI Apps, Bookmarks, Drill-Through, JSON Themes, Measure-Killer, Tabular Editor

Snowflake: Data Warehouse Design, SQL, Snowflake Schema, Data Transformation, Data Integration

ETL Tools: SSIS, Azure Data Factory, Airflow

Version Control: Git, Azure Repos, Visual Studio, GitHub

Cloud Platforms: Azure, Azure Data Factory, Power BI Service, Azure Analysis Services (AAS),Power App, Power Automate

Data Integration: SQL Server, Snowflake, MySQL, Excel, Flat Files, Oracle

Agile Methodology: Sprint Planning, Task Management (JIRA), Backlog refinements, Daily Standups, sprint planning

Other Tools: Tableau, Toad, SQL Developer, JSON, XML, Erwin, PowerShell

Programming Languages: SQL, T-SQL, Python, JavaScript, HTML5, CSS3

CI/CD: Azure DevOps, Git, Power BI Pipelines, Automated Reporting

Key Achievements:

Led the design and development of credit union reporting solutions (loans, payments, member data) leveraging Power BI and Snowflake to deliver real-time insights.

Designed and implemented Agile workflows in the development of Power BI reports and dashboards, ensuring continuous integration and rapid delivery of business intelligence solutions.

Optimized ETL processes and data integration strategies between Snowflake, Power BI, and Azure platforms, reducing report generation time by over 30%.

Successfully deployed Power BI reports using CI/CD pipelines, enabling seamless deployment across environments (Dev, Test, and Production) with minimal manual intervention.

Enhanced Power BI dashboards with dynamic slicers, calculated measures, and interactive visualizations, enabling better decision-making for stakeholders.

Designed and developed financial reports, providing insights into loans, payments, accounts, deposits, transactions, and executive summaries to support data-driven decisions.

Professional Experience:

BI Developer II

Trellance, Tampa, FL April 2022 – Present

Designed and developed ETL processes for Snowflake, utilizing stored procedures, functions, and Power BI as the primary reporting tool for the credit union industry, focusing on loan, member payments, and other financial reports.

Managed Power BI pipelines, utilizing Power BI Service and Azure DevOps to automate report deployments, data refreshes, and version control across multiple environments (Dev, Test, Production).

Led the creation of shared semantic models and Snowflake data models, ensuring efficient integration between Power BI and Snowflake for reporting and analysis.

Experienced in building and sharing semantic data models across various teams, utilizing shared datasets to ensure consistent data sources across Power BI workspaces.

Expertise in working with PBIX/PBIT file formats, creating reusable Power BI templates for efficient report development and standardization across business units.

Proficient in bi-layer data sharing, designing multi-layered data models to ensure efficient data access, transformation, and presentation in Power BI reports.

Utilized Power BI features such as DAX, M Query, Power Query, calculated columns, and drill-through reports for dynamic data visualization.

Skilled in leveraging calculation groups in Power BI for creating reusable and efficient DAX calculations across reports and dashboards.

Implemented drill-through functionality and cross-report navigation, enabling users to seamlessly interact with reports and gain detailed insights from multiple data sources.

Extensive experience with Q&A functionality in Power BI, allowing users to ask natural language questions and receive real-time insights from reports.

Enhanced Power BI reports using customized JSON themes, bookmarks, and interactive dashboards for a more engaging and user-friendly experience.

Automated Power BI report deployment using Airflow and CI/CD pipelines for efficient and error-free report updates.

Implemented Agile methodologies, including task planning, sprint execution, and task tracking using JIRA, to ensure alignment of deliverables with business goals.

Collaborated with data analysts and business stakeholders to gather and analyze requirements, providing regular updates on progress and performance.

Enhanced Power BI dashboards with dynamic slicers, calculated measures, and interactive visualizations, enabling better user experience and real-time data insights.

Provided support to product teams by resolving Power BI-related issues, ensuring smooth functionality, and optimizing reporting solutions based on stakeholder feedback.

Assisted QA resources in defining test cases and setting up scenarios for QA testing and User Acceptance Testing (UAT), ensuring the accuracy and reliability of Power BI reports.

Power BI Developer/ETL

Ecolab, Saint Paul, MN October 2019 – March 2022

Created data models and developed advanced Power BI reports for financial, operational, and credit union-based reporting, integrating data from Snowflake into Power BI.

Built and maintained ETL workflows with Azure Data Factory and SSIS to load and transform data into Snowflake for reporting.

Migrated legacy SSRS reports to Power BI, optimizing data models and implementing time-series analysis, DAX measures, and calculated columns.

Worked within an Agile environment, participating in daily standups, sprint planning, and backlog grooming, ensuring timely completion of tasks and clear communication of progress.

Developed Power BI reports with a focus on self-service BI capabilities, enabling business users to create ad-hoc reports with minimal IT intervention.

Utilized Power Query for data transformation and DAX for advanced business logic and calculations, ensuring the creation of relevant and actionable reports.

BI Developer/SSIS/SSRS/Power BI

Cardinal Health, OH July 2017 – September 2019

Spearheaded the migration of legacy SSRS reports to Power BI dashboards, applying Snowflake as the backend data warehouse.

Created and maintained ETL packages in SSIS for data integration into Snowflake and SQL Server for reporting purposes.

Designed and deployed Power BI dashboards with custom visuals, interactive filters, and advanced DAX calculations to support financial reporting.

Implemented performance tuning for both SSIS and Power BI to ensure efficient report generation and data loading, reducing processing time.

Participated in Agile teams, taking ownership of tasks and ensuring proper alignment with project milestones and deadlines.

Contact this candidate