Power Bi Business Intelligence

HARISH M

Worcester, MA ***** 508-***-**** *****************@*****.***

Summary

Tableau Developer with around 4 years of experience in designing, developing, and deploying interactive dashboards and data visualizations.

Proficient in data extraction, transformation, and loading (ETL) processes using SQL, Excel, and other data preparation tools.

Proficient in writing and optimizing MSSQL Server, Teradata, and Oracle queries to support data analysis and reporting.

Skilled in creating complex calculations, parameters, and custom SQL queries for advanced analytics.

Expertise in designing user-friendly dashboards with a focus on usability, performance, and scalability.

Strong understanding of data modeling, data warehousing, and business intelligence concepts.

Experience in collaborating with cross-functional teams to gather requirements and deliver data-driven solutions.

Adept at optimizing dashboard performance and troubleshooting data-related issues.

Certified in Tableau Desktop and Power BI (if applicable, otherwise remove).

Proficient in integrating Tableau with Informatica for seamless ETL processes, data transformation, and data warehousing. Skilled in SQL, data modeling, and optimizing data pipelines for performance

Proven ability to translate business requirements into technical specifications and actionable insights.

Strong communication and presentation skills, with experience in training end-users on dashboard functionalities.

Hands-on experience with data blending, joins, and advanced visualizations in Tableau and Power BI.

Skills

Tableau: Tableau Desktop, Tableau Prep, Tableau Server, Tableau Online, Calculated Fields, Parameters, LOD Expressions, Dashboard Optimization

Power BI: Power BI Desktop, Power Query, DAX, Data Modeling, Power BI Service, Row-Level Security

Databases: MSSQL, MySQL, Postgre SQL, Teradata, Oracle

Programming: Python (Pandas, NumPy), R

Other Tools: Excel (Advanced), Google Sheets, Azure Data Factory, AWS Redshift

Soft Skills: Problem-Solving, Team Collaboration, Stakeholder Management, Agile Methodologies

ETL Tools: Informatica, Alteryx, Talend, SSIS

Experience

Tableau Developer 06/2023 to Current

Best Buy Richfield, MN

Designed and developed interactive Tableau dashboards for the client to visualize sales, inventory, and customer behavior metrics.

Collaborated with stakeholders to gather requirements and translate them into technical specifications.

Optimized dashboard performance by implementing best practices in data extraction and visualization.

Utilized Teradata for data extraction and transformation.

Created complex calculations, parameters, and LOD expressions to support advanced analytics.

Developed and maintained ETL workflows using Informatica Power Center to extract, transform, and load data from multiple sources into a centralized data warehouse

Conducted training sessions for end-users to ensure effective utilization of dashboards.

Integrated Tableau with various data sources, including SQL databases, and cloud platforms.

Integrated Tableau with Informatica Power Center to streamline ETL processes, ensuring accurate and timely data extraction, transformation, and loading

Optimized data connections and queries in MSSQL Server, Teradata, and Oracle, reducing data retrieval times by 50%.

Automated data refresh processes using Tableau Server and Tableau Online.

Performed data validation and quality checks to ensure accuracy and consistency.

Documented dashboard functionalities and provided ongoing support for troubleshooting.

Environment: Tableau Desktop, Tableau Server, MSSQL, Excel, AWS Redshift

Tableau & Power BI Developer 08/2021 to 03/2022

Bajaj Finserv Hyderabad, India

Developed and maintained Power BI dashboards to monitor real-time financial performance and risk metrics.

Utilized DAX to create calculated columns, measures, and KPIs for advanced data analysis.

Designed data models and implemented row-level security to ensure data confidentiality.

Automated data extraction and transformation processes using Power Query and SQL.

Wrote and optimized SQL queries in MSSQL Server and Oracle to support complex data analysis and reporting.

Collaborated with data engineers to integrate data from multiple sources into a centralized data warehouse.

Conducted performance tuning of dashboards to improve load times and user experience.

Provided technical support and resolved issues related to data visualization tools.

Worked in an Agile environment, participating in sprint planning and daily stand-ups.

Automated routine data processes using Informatica workflows and Tableau schedules, reducing manual effort and improving efficiency.

Delivered presentations to senior management, highlighting key insights and recommendations.

Environment: Power BI Desktop, Power BI Service, DAX, SQL, Azure Data Factory

Tableau Developer 02/2020 to 08/2021

Medicover Healthcare Hyderabad, INDIA

Designed and deployed Tableau dashboards to visualize patient data, treatment outcomes, and operational efficiency.

Designed, developed, and maintained Tableau dashboards to visualize key business metrics, enabling data-driven decision-making for stakeholders.

Extracted and transformed data from various sources, including Excel, SQL, and APIs.

Created custom SQL queries to support complex data analysis and visualization requirements.

Implemented data blending and joins to combine data from multiple sources.

Conducted user acceptance testing (UAT) to ensure dashboards met business requirements.

Provided ongoing maintenance and support for Tableau dashboards and reports.

Collaborated with business analysts to identify key performance indicators (KPIs) and metrics.

Documented technical processes and created user guides for dashboard functionalities.

Assisted in the migration of legacy reports to Tableau, improving accessibility and usability.

Environment: Tableau Desktop, Tableau Prep, SQL, Excel, Google Sheets

Education and Training

Master of Science: Data Analytics 05/2024

Clark University Worcester, MA

Websites, Portfolios, Profiles

Harish LinkedIn

Certifications

Microsoft Power BI Certification

Tableau Desktop Specialist

Contact this candidate