Description

Hi, I’m Tushar – a Power BI Developer & Data Analytics Consultant with 7+ years of experience helping businesses transform raw data into clear, actionable insights. I specialize in creating interactive dashboards, scalable data models, and automated reporting solutions that drive smarter decision-making.

I have worked across industries including manufacturing, supply chain, and finance, delivering end-to-end BI solutions – from data extraction and transformation (SQL, Python, Power Query) to visualization and performance optimization in Power BI.

What I Offer:

Custom Power BI dashboards tailored to your KPIs

Efficient data modeling and DAX calculations for dynamic insights

ETL workflows using Fabric, Synapse, Databricks, Power Query, SQL, Python and Data Flows

Optimization of existing dashboards for speed & performance

With experience in global projects and exposure to enterprise-level reporting, I ensure my solutions are accurate, user-friendly, and business-focused. I value clear communication, quick turnaround, and long-term client relationships.

Let’s work together to make your data smarter, faster, and more valuable for your business.

Languages

English
Native or bilingual
Hindi
Native or bilingual
Gujarati
Native or bilingual

Workplace preferences

Remote only

Primarily works remotely

NMDC Energy
Senior Power BI Developer & BI Consultant
ENERGY AND UTILITIES
October 2024 - Today (1 year and 8 months)
Abu Dhabi - United Arab Emirates
• Developed, orchestrated, and maintained scalable Python-based ETL pipelines integrating data from SQL, APIs, SAP, Excels, and Primavera P6, forming a centralized data warehouse for Power BI reporting
• Engineered complex DAX measures to deliver insightful KPIs around fabrication and erection planning, driving strategic decision-making
• Designed custom visuals in Power BI using Deneb, SVG, HTML and CSS such as a Matrix with embedded bar charts and Gradient area charts to enhance interpretability of tabular data
• Built and deployed Cloud and Desktop Power Automate Flows linked to Power BI report buttons that dynamically passed slicer inputs to Python scripts for automated execution
• Consulted teams on Power BI architecture, DAX optimization, licensing, and Python integration
• Optimized data models using Tabular Editor and created C# scripts for partial dataset refreshes, improving report load time and data integrity
• Implemented and scaled on-premises Enterprise Gateway for secure, organization wide data connectivity
• Served as a trusted mentor and consultant to team members, resolving roadblocks in Power BI, DAX, Power Query, and Python development

Key Projects & Achievements
• Simulated Material Delivery Forecasts using Python to optimize resource allocation by priority, enhancing planning accuracy
• Optimised and reduced Tabular model sizes by 200% achieving faster refreshes and reducing failures
• Spearheaded the adoption of Power BI architecture best practices across the department, standardizing report development
• Built reusable ETL flows and Python scripts to ensure consistency and scalability across multiple teams and projects
• Optimized existing ETL processes, Power BI reports, and data models, resulting in faster performance and reduced maintenance
• Developed a Quantity Survey dashboard that automated manual data tracking, saving 1440 hours per project annually — a 16.4% reduction in effort
Python ETL Microsoft Power BI Supply Chain Analytics SQL
Lingaro Group Pvt Ltd
Lead BI Consultant
RETAIL (LARGE RETAILERS)
March 2023 - October 2024 (1 year and 7 months)
Sofia, Bulgaria
• Developed and orchestrated robust ETL data flows in Microsoft Fabric, connecting sources including SAP BW, SAP HANA, SQL, Databricks, Snowflake, SharePoint, and Excel, enabling enterprise-grade analytics
• Architected CI/CD pipelines in Azure DevOps for version control and automated Power BI deployment across DEV, TEST, and PROD environments, eliminating manual overhead and securing controlled releases
• Engineered complex DAX measures to deliver actionable KPIs, following strict performance optimization best practices
• Migrated high-complexity Tableau dashboards to Power BI, preserving sophisticated UI/UX while significantly improving performance
• Enhanced reporting efficiency through Tabular Editor, field parameters, and model refactoring techniques
• Guided branding-aligned UI/UX design strategies for Power BI reports to ensure consistency and visual clarity
• Mentored the client's BI team to overcome roadblocks in Power BI, DAX, Dataflows, and Power Query, boosting technical maturity and delivery velocity
• Optimized legacy reports to streamline performance, reduce refresh time, and enhance end-user experience

Key Projects & Achievements
• Forecasted inventory and sales volume to ensure timely stock delivery and demand readiness
• Designed a comprehensive executive dashboard integrating multiple models and sources to surface insights around Fulfilment, Inventory, and Safety KPIs
• Optimized legacy reports to achieve 53-second faster refresh times, improving report responsiveness
• Developed reusable ETL flows and data models, reducing workspace capacity loads and enhancing solution scalability
• CI/CD pipeline automation saved $60,000 annually by eliminating dependency on premium deployment pipeline features in Power BI
Microsoft Power BI Microsoft Azure Data Engineer SQL Server ETL
Ingenero Technologies Pvt Ltd
BI Consultant
ENERGY AND UTILITIES
February 2022 - March 2023 (1 year and 1 month)
Thane, Maharashtra, India
• Designed, developed, and maintained the end-to-end Business Intelligence architecture, setting up optimized SQL infrastructure, managing Power BI licensing, and streamlining CI/CD pipelines
• Engineered direct query reports for real-time insights and performance-optimized user experience within Power BI
• Built a scalable data warehouse using SQL views and Stored Procedures, enabling seamless report development and analytics workflows in Power BI
• Applied advanced BI techniques including DAX, Power Query transformations, and dynamic M query parameters to facilitate environment-specific deployments (DEV, QA, PROD) via CI/CD automation
• Delivered consultation and technical support to data teams on Power BI and SQL, fostering skill upliftment and project delivery confidence
• Developed consistent, branded UI/UX designs for executive-level dashboards and visual reports

Key Projects & Achievements
• Built a predictive Power BI dashboard analysing performance metrics like Run Length, Fouling, and Selectivity for Furnace, Quench Tower, and Acetylene Reactor systems
• Delivered diagnostic and prescriptive analytics to enhance equipment efficiency based on benchmarks, driving data-backed operational decisions
• Achieved $3 million in annual savings by reducing unplanned downtime through predictive reporting and process visibility
Microsoft Power BI SQL Server Data Engineer Data Warehouse Big Data