Summary
Overview
Work History
Education
Skills
Websites
Certification
Personal Information
References
Timeline
Generic

Naveen Madduri

Toronto,Canada

Summary

Dynamic Business Intelligence Specialist with a proven track record at the College of Nurses of Ontario, excelling in data modeling and visualization. Expert in Power BI and DAX, I deliver actionable insights while fostering collaboration and ensuring data quality. Passionate about driving performance optimization and enhancing business intelligence solutions.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Business Intelligence Specialist

College of Nurses of Ontario
Toronto, Canada
04.2023 - Current
  • Data Engineering & Integration
  • Design and develop data pipelines using Microsoft Fabric tools (e.g., Dataflows, Data Factory).
  • Implement ETL/ELT processes to ingest, transform, and load data from various sources.
  • Ensure data quality, consistency, and lineage across the platform.
  • Modeling & Semantic Layer
  • Create and manage data models using Power BI datasets or Lakehouse models.
  • Define relationships, measures, and KPIs to support business reporting needs.
  • Report & Dashboard Development
  • Build interactive reports and dashboards using Power BI.
  • Collaborate with stakeholders to understand reporting requirements and deliver actionable insights.
  • Performance Optimization
  • Optimize data models and queries for performance and scalability.
  • Monitor and troubleshoot performance issues in data pipelines and reports.
  • Collaboration & Governance
  • Work closely with data architects, analysts, and business users.
  • Follow data governance, security, and compliance best practices.
  • Automation & CI/CD
  • Automate deployment of data pipelines and reports using DevOps practices.
  • Use tools like GitHub, Azure DevOps, or Fabric deployment pipelines.
  • Documentation & Support
  • Maintain technical documentation for data flows, models, and reports.
  • Provide ongoing support and enhancements for existing solutions.

BI Consulting Lead

Direct Travel
Canada, KY
01.2022 - 02.2023
  • Involved in Architecting and developing the Azure data factory pipelines by creating the datasets and source and destination connections to move the data from oracle database to Azure Data Lake Data Lake Store Raw Zone.
  • Created data bricks notebooks using Python (PySpark), Scala and Spark SQL for transforming the data that is stored in Azure Data Lake stored Gen2 from Raw to Stage and curated zones.
  • Design and develop business intelligence dashboards, analytical reports and data visualizations using power BI by creating multiple measures using DAX expressions for user groups like sales, operations and finance team needs.
  • Involved in developing complex Azure Analysis Services tabular databases and deploying the same in Microsoft azure and scheduling the cube through Azure Automation Runbook.
  • Involved in Configuring and Upgrading the On Premises Data gateway between various Data sources like SQL Server to Azure Analysis Services and Power BI service.
  • Involved in creating the external and internal tables in Azure SQL Data warehouse and created stored procedures to move the data from external to internal tables.
  • Design and develop Power BI reports for project initiatives design and Power BI Dataset sourced from non-DW DM sources.
  • Mentor team in Promoting best practices to enforce team standards and policies. Perform development code review for the team as appropriate.

Sr. Business Intelligence Consultant

Halifax regional Municipality (HRM)
Halifax, Canada
01.2021 - 12.2021
  • Collaborated with Subject Matter Experts and Product Owners to define data requirements and source-to-target mapping necessary to support advanced analytics initiatives with in HRM, including the interfaces between applications, databases and platforms.
  • Made Power BI reports more interact and activate by using storytelling features such as bookmarks, selection panes, and drill through filters also created custom visualizations using DAX.
  • Utilized Power BI to create various analytical dashboards that helps business users to get quick insight of the data.
  • Published and maintained workspaces in Power BI Service, allotted the time refresh for the data, maintained the apps and workbooks.
  • Converted the Boulder Tables from Excel to Power BI with better Graphs and visualizations for the understanding and improvement of business locations and combined them in Power BI to know the Data Integrity of the Product.
  • Provide Operational Support to modify existing Tabular SSAS models and extensive use of DAX (Data Analysis Expressions) functions for the Reports and for the Tabular Models.
  • Designed Dimensional Modeling using SSAS for End-User. Created Hierarchies in Dimensional Modeling, Relationships, Measures, Partitions, and Calculations using DAX and KPIs in SSAS Tabular model.
  • Created Roles for SSAS Tabular Model provide additional Security at the row-level by using row-level filters.
  • Identified Data discrepancy problem areas and opportunities to improve service, reduce Validation efforts, and increase Productivity.
  • Created and maintained Apps and Reports in Power BI for Customer Issue Resolution and maintained different Process of CRM.
  • Performed Queries, maintained and extracted Data from MS SQL, cleansing, and maintaining the Production Environment in MS SQL for the performance.

Sr. Business intelligence Analyst

HOOPP (Healthcare of Ontario Pension Plan)
Toronto, Canada
08.2019 - 11.2020
  • Created required Data Models to accomplish various client report requirements and created Dashboards after publishing into Power BI Service.
  • Excellent Command of using DAX (Data Analytic Expression Language) and M Code Language.
  • Worked with most of the features available in Power BI Desktop in creating Reports and updated knowledge with all features.
  • Created different types of visualizations viz., geographical visualizations after slicing and dicing the account operations-related data to analyze financial data across different locations of the bank.
  • Experienced in working with DAX commands to pull up more calculated data out of the tables.
  • Command in the creation of Calculated Columns / Measures/Tables with appropriate techniques having the best performance.
  • Dynamic Row-level security (RLS) was implemented successfully on Power BI Service (Cloud).
  • Worked with gateways to schedule the report and data using different gateways.
  • Developed custom-calculated measures using DAX in Power BI to satisfy business needs.
  • Worked with data models with complex relationships in Power BI and connected different data sources to the Power BI desktop.
  • Created complex Custom Views using SQL Developer to create data sets for Power BI dashboards.
  • Extensively involved in designing and developing the power BI data model using multiple DAX expressions to build calculated columns and calculated measures.
  • Developed Azure Data Factory pipelines to move data from source systems and transform the data in Azure blob storage and created ADLA USQL jobs to transform the data in Azure.
  • Used VSTS for version controlling, assisted in documentation, and created a data dictionary.

Business Intelligence Consultant

FedEx Express Canada
Mississauga, Canada
02.2019 - 07.2019
  • Import data from multiple data sources and create automated reports in Power BI after cleaning and preprocessing the data.
  • Create reports in Excel by importing data from the SQL database using T-Sql and writing queries according to the business requirement.
  • Modify datasets using DAX query, Merge statements, Refresh Schedule, Row level security, and Modelling within Power BI.
  • Provide recommendations and Business Insights based on analytics.
  • Work with process owners to identify and assess appropriate automation use cases.
  • Work with the stakeholders to understand the application development and enhancements requirements.
  • Create documentation in support of business and technology requests.
  • Perform data quality control and assurance and handle quality issues.
  • Use of IBM Rational and Agile craft to get the business requirement from Stakeholders and work in Sprints to complete and track the user stories.
  • Develop scalable and efficient process automation and reusable components that can be leveraged across different lines of business.
  • Use of industry-leading RPA tools implementing full life cycle RPA solutions - use case selection, requirements gathering, implementation, testing, deployment, monitoring, and support.
  • Build COE Scorecards, Daily and Monthly tech Ops reports, SteerCo reports, and Engagement Lead reports that contain financial details crucial for the Business.
  • Translate business requirements, and current and future state prod designing to create automation-readymade process flow.
  • Work on enhancements, security models, and ad-hoc reports based on the management requirement.
  • Attend daily stand-up meetings for reporting.

Business Intelligence Analyst

Aviva Canada
Toronto, Canada
09.2016 - 10.2018
  • Working extensively on the Power BI report creating a tabular cube, and data model for the Power BI Report, and Validating the data quality of the report.
  • Created different types of visualizations viz., geographical visualizations after slicing and dicing the operations-related related data to analyze financial data across different locations of the bank.
  • Experienced in working with DAX commands to pull up more calculated data out of the tables.
  • Developed custom calculated measures using DAX in Power BI to satisfy business needs.
  • Worked with data models with complex relationships in Power BI and connected different data sources to the Power BI desktop.
  • Published many reports and visualizations created for the Power BI service, thereby developing dashboards.
  • Experienced in creating many dashboards by pinning many visualizations in the workspace as per the insights provided.
  • Experienced in Data Modeling used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations.
  • Created data visualizations using various visual objects (Line chart, Bar chart, Treemap, Single card, KPI, Map, Pie chart, custom visuals).
  • Created complex Custom Views using SQL Developer to create data sets for Power BI dashboards.
  • Generated Drill down, Drill through, Matrix Reports, and Parameterized reports using expressions to calculate, group, filter, and parameterize reports using SSRS.
  • Created Universes and Complex Reports with BO IDT and WEBI and created several Crystal.
  • Universes have been created on IDT with single and Multi-source Data Sources.
  • Right from gathering Reporting Requirements, preparing TDD and WEBI Reports, and Unit testing completed and moved them from the Dev environment to PROD.
  • BO and Crystal's report created to meet as is the approach with various Reporting techniques.
  • Designed and developed SSIS Packages (.dtxs files) to import and export data from MS Excel, SQL Server, Oracle, and Flat files.
  • SSIS packages to update tables with monthly data and automated it through scheduled jobs for the beginning of every month.
  • Created reports using stored procedures. Involved in scheduling, and creating snapshots and subscriptions for the reports using SSRS.
  • Expertise in validating the data between source and target systems.
  • Designed packages that utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, and Derived Column.
  • Created Package Configurations to deploy packages from the development to the production server.
  • Successfully managed the Extraction, Transformation, and Loading (ETL) process by pulling large volumes of data from various data sources using BCP in staging database from MS Access, excel.
  • Experienced in participating in meetings with business users to gather requirements.
  • Involved in the analysis of existing database structures and creating new tables and views as per the requirements.

Business Intelligence Developer

Agranee Solutions
Vancouver, Canada
04.2013 - 08.2016
  • Created views in Tableau Desktop that were published to the internal team for review and further data analysis and customization using filters and actions.
  • Involved in reviewing business requirements and analyzing data sources from Excel, Oracle, and SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
  • Created a dashboard from scratch that included drill-through, filters, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, and Bullet Graphs.
  • Involved in creating interactive, parameterized dashboards by extracting data from various sources using data blending and applying actions - filter, highlight, and URL.
  • Developed unlinked, on-demand sub-reports and linked sub-reports using shared variables and complex reports like crosstab, drill down, and hierarchical reports.
  • Creating visually compelling and actionable interactive reports and dashboards.
  • Developed different reports and dashboards using SAS Enterprise Guide.
  • Created Context filters on the existing filters and Tableau data extract to publish it in the server by optimizing it to reduce the report rendering time.
  • Reviewed and optimized SQL queries and edited inner left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
  • Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that has happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
  • Involved in data conversion to provide reporting capabilities as per the requirement.
  • Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.
  • Participated in weekly meetings, reviews, and user group meetings as well as communicating with stakeholders and business groups.
  • Validated the reports before publishing reports to the Tableau server, troubleshoot Tableau reports, dashboards, etc.

Education

Masters' degree - Business Administration

University Canada West
01.2013

Bachelor's degree - Computer Science

JNTUH College of Engineering Hyderabad
01.2009

Skills

  • Data modeling
  • Data visualization
  • Power BI development
  • ETL processes
  • DAX expressions
  • Data pipeline automation
  • Azure power BI integration

Certification

  • Strategic Planning Associate (SPA), NASBA
  • Advanced SQL Server: Reporting Services, LinkedIn
  • Data Dashboards in Power BI
  • Project Management Simplified
  • Advanced SQL for Data Science: Time Series, LinkedIn
  • The Data Science of Marketing
  • Tableau 10: Mastering Calculations
  • Power BI Data Flow Essential Training
  • Power BI Essential Training
  • Excel Business Intelligence: Power Query
  • SQL Server: Triggers store procedures and Functions
  • Statistics Foundations-Level 2
  • Project Management Support Certificate, Project Management Institute

Personal Information

Willing To Relocate: Anywhere

References

References available upon request.

Timeline

Business Intelligence Specialist

College of Nurses of Ontario
04.2023 - Current

BI Consulting Lead

Direct Travel
01.2022 - 02.2023

Sr. Business Intelligence Consultant

Halifax regional Municipality (HRM)
01.2021 - 12.2021

Sr. Business intelligence Analyst

HOOPP (Healthcare of Ontario Pension Plan)
08.2019 - 11.2020

Business Intelligence Consultant

FedEx Express Canada
02.2019 - 07.2019

Business Intelligence Analyst

Aviva Canada
09.2016 - 10.2018

Business Intelligence Developer

Agranee Solutions
04.2013 - 08.2016

Masters' degree - Business Administration

University Canada West

Bachelor's degree - Computer Science

JNTUH College of Engineering Hyderabad

Similar Profiles

CREATE PROFILE
Naveen Madduri