Neel Darji | BI Consultant with Power BI, SQL, ETL expertise and Data Analytics experience.

Neel Darji

BI Consultant with Power BI, SQL, ETL expertise and Data Analytics experience.

Based in Richmond Hill, Ontario, Canada

About

With 3+ years of professional experience in Business Intelligence, I bring a robust skill set encompassing data analysis, validation, and identification of data discrepancies. My expertise extends to data reporting through platforms such as Power BI, Tableau, SSMS, and Excel VBA, allowing me to effectively communicate insights and facilitate informed decision-making. I am particularly interested in SQL Reporting, Data Engineering, and Data visualization. Possessing strong problem-solving abilities and organizational skills, I am a self-motivated and innovative team player capable of embracing and driving change.

Skills

Projects

End to End Azure Data Warehouse Solution

This project demonstrates a comprehensive data warehousing and analytics solution, from building a data warehouse to generating actionable insights. Designed as a portfolio project, it highlights industry best practices in data engineering and analytics.

Power-BI-Netflix_streaming_dashboard

This Power BI dashboard provides an analytical view of Netflix's content, showcasing key metrics such as total shows, movies, series, duration breakdown, awards received, and IMDb ratings.

Power-BI_Healthcare-Workforce-Mental-Health-Dataset

To analyze key factors that contribute to high burnout and turnover rates in the healthcare workforce, identifying departments, job roles, and workplace conditions that are most at risk.

DataBricks_SparkSQL

End to end Spark SQL project a hands-on exploration of Azure Blob Storage, Azure Databricks, and Spark SQL, using a real-world e-commerce dataset.

Power-BI_Sales-Performance-Report

Dashboard Overview This interactive Sales and Performance Report provides a comprehensive analysis of sales, customer trends, and performance metrics. It includes various visualizations and key performance indicators (KPIs) to help users gain insights into sales performance, customer behavior, and o

Power-BI_Ecommerce-Business

Interactive Financial Dashboard for small Ecommerce company

Tableau Dashboard

A university student requested tableau dashboard for their project submission Goal was to achieve/create dashboard that includes functions, calculated columns, various graphs and etc. Created a dashboard on simple topic-'What Does 1GB of Mobile Data Cost by Country?' Data took from - MakeoverMonday

Experience

2022-Present

Business Intelligence Consultant

The primary responsibilities include extracting, transforming, and loading data from the client's prior software, and constructing custom reports and dashboards to meet the client's specific requirements. Provide (10+) training per week and support for in-house reporting that functions similarly to other BI visualization tools. The revenue of $35,000 per month is the average amount generated by providing these services to clients. Utilize data analytic tools like Excel, VBA/Macros, SQL server (SSMS), and Informatica to convert and cleanse client data. Developed automation scripts for conversions and reporting, using VBA, Stored Procedures, and SSIS packages. Engaged with project stakeholders, including Business Analysts, Project Managers to address their specific requirements.

2019-2019

Business Intelligence Developer | Intern

Created real-time interactive dashboards with Drill down & filters that helped hospitals to achieve a meaningful target of 50% quarterly (Tableau, SQL, Excel). Designed and built ETL process to combine multiple data sources to a SQL framework for analyzing ~2M records data of 3 different departments. Extensive use of deploying SQL Queries, stored procedures, and functions. Organized a forecasting dashboard on a monthly basis that provides a performance comparison of different consumer products at both monthly and quarterly levels, maintaining a constant exchange rate. Gathered data from various cross-functional stakeholders to assess the historical business performance.

Education

2020-2021

Data Analytics for Business

St Clair College, Canada, Windsor

2015-2019

Computer Science & Engineering

BITS university, India, Vadodara