Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Overview
Declaration
Timeline
Generic

Vishal Avachar

Senior Software Engineer
Pune,

Summary

Detail-oriented and highly analytical Business Intelligence Specialist and Data Engineer with a Bachelor's degree in Information Technology from Pune University. Extensive experience across the complete BI lifecycle includes proficiency in Microsoft Power BI for crafting interactive dashboards and analytical reports, as well as expertise in Pentaho for ETL development and data integration. Skilled in advanced DAX calculations, Power Query transformations, and data pipeline optimization, ensuring seamless data flow and high-performance analytics. Demonstrated ability to deliver comprehensive BI solutions that transform complex datasets into actionable insights, driving operational efficiency and supporting strategic business growth.

Overview

7
7
years of professional experience
1
1
Certification
3
3
Languages

Work History

Senior Software Engineer

Netlink Software Pvt. Ltd.
01.2022 - 05.2025
  • Managed complete MIS Reporting solution using Power BI and Pentaho (PDI).
  • Gathered and analyzed client requirements to design interactive dashboards and KPI reports.
  • Created Data Models and Star Schemas using SQL and Vertica; performed Power Query transformations.
  • Developed Opportunity & Sales Reports, CRM Reports, Technical Reports, Target vs Actual Reports using advanced DAX measures and calculated columns.
  • Implemented Row-Level Security (RLS) for controlled data access.
  • Developed Pentaho ETL routines to integrate multiple data sources and automate data pipelines.
  • Performed data validation, testing, deployment, and post-production support.
  • Deployed reports to Power BI Service and configured scheduled refreshes.
  • 1. EDS Tech – Power BI & Pentaho (PDI)
  • 2. THK SPD/ODS/VIN – Power BI & Pentaho (PDI)
  • 3. ACG – Lumenore & Pentaho (PDI)

BI Developer

DRAiT Solutions LLP
08.2020 - 01.2022
  • Worked as Power BI Developer for complete MIS Reporting solution.
  • Gathered and analyzed client requirements using Agile/Scrum methodology for timely delivery.
  • Designed Data Models with multiple sources including SQL, Excel, and Flat Files.
  • Developed reports such as Daily Sales Report, Monthly & Year-to-Date Sales Analysis, and Value Revenue Analysis using DAX measures.
  • Applied Power Query transformations for data cleaning and integration.
  • Conducted thorough Data Validation and Testing for accurate reporting.
  • Published reports on Power BI Service and configured scheduled refresh.
  • Provided post-deployment support and enhancements for business continuity.
  • 1. Me N Mom
  • 2. Spicer India Ltd. (DANA ANAND Group)
  • 3. Flash Electronics Pvt. Ltd.
  • 4. NIVEA India Ltd.

BI Developer

Quick Report Software Pvt. Ltd.
02.2018 - 07.2020
  • Western Refrigerators Pvt. Ltd. – Built Data Warehouse and Data Marts, developed reports and dashboards, and conducted end-user training.
  • Ultra Engineering Ltd. – Designed and implemented Data Warehouse and Data Marts, developed reports and distribution solutions, and provided training.
  • Jesons Ind. Ltd. – Managed data warehousing, report generation, and developed E-waybill and GST reports.
  • Fleetguard Filtrum Ltd. – Developed data warehouses and data marts, created GST reports, and handled report distribution.

Education

B.E. - Information Technology

AISSMS IOIT
01.2016

Diploma - Information Technology

MIT, SSPP
01.2012

SSC - General

SMV, D. Raje
01.2007

Skills

    Microsoft Power BI (Desktop, Service, Report Server, Mobile) for interactive dashboards, KPI tracking, drill-down reports, forecasting, and trend analysis

undefined

Accomplishments

  • 6.6 years of overall experience in Business Intelligence and Data Warehousing, including 4+ years specializing in Microsoft Power BI and Pentaho (PDI).
  • Worked as Senior Software Engineer at Netlink Software Pvt. Ltd. (Jan 2022 – May 2025), BI Developer at DRAiT Solutions LLP (Aug 2020 – Jan 2022), and Quick Report Software Pvt. Ltd. (Feb 2018 – July 2020).
  • Delivered 30+ Power BI implementations and 100+ Pentaho ETL routines, developing interactive dashboards, KPIs, and analytics across Manufacturing, Retail, and Healthcare sectors.
  • Designed end-to-end BI solutions using Power BI, Pentaho (PDI), MyReport, and Lumenore, including data modeling, DAX measures, Power Query transformations, ETL workflows, and report deployment.
  • Built 20+ Proof of Concepts leveraging Power BI and other BI tools across ERP systems and databases.
  • Conducted training sessions for end users on Power BI and MyReport Suite, improving adoption and analytical capabilities.

Certification

Complemented BI expertise with certifications in SQL, Lumenore, and BI & Analytics fundamentals, reinforcing multi-tool BI solution delivery.

Overview

  • Professional Summary:
  • A highly skilled Business Intelligence (BI) and Data Warehouse (DWH) Developer with 6.6 years of firsthand experience in BI consulting, data design, and reporting, including 4+ years specializing in Microsoft Power BI and Pentaho (PDI). Proven expertise in developing interactive dashboards, implementing advanced DAX calculations, Power Query transformations, Row-Level Security (RLS), ETL pipelines, and data integration solutions. Adept at analyzing business requirements and delivering data-driven solutions that enhance reporting efficiency, process accuracy, and stakeholder decision-making.
  • Core Competencies:
  • BI & DWH Expertise: Experience in designing, building, and maintaining data warehouses, ETL pipelines, and reporting solutions across industries including Telecom, Financial, Retail, Health, and Manufacturing.
  • Power BI Development: Skilled in Power BI (Desktop, Service, Mobile) with advanced DAX and Power Query capabilities. Experienced in importing data from SQL Server, Excel, CSV, and web sources. Proficient in building interactive dashboards, KPI reports, drilldowns, forecasting models, and complex analytics.
  • Pentaho (PDI) & ETL Tools: Firsthand experience in Pentaho (PDI) for ETL design, data integration, workflow automation, and data transformation. Experience also includes MyReport ETL tool for Excel and web-based dashboards.
  • SQL & PL/SQL: Strong knowledge of SQL and PL/SQL scripting for data extraction, transformation, and reporting across multiple platforms.
  • Report Design & Deployment: Expertise in designing and deploying reports (tabular, matrix, drill-down, sub-reports), configuring Power BI On-Premises Gateways, scheduling refreshes, and delivering reports via Power BI Service and Workspaces.
  • Leadership & Collaboration: Effective communicator and team player, skilled in requirement gathering, project delivery, and stakeholder management.

Declaration

I hereby declare that the above-mentioned information is correct up to my knowledge and I bear the responsibility for the correctness of the abovementioned particulars. 


Date: 

Place: 

Timeline

Senior Software Engineer

Netlink Software Pvt. Ltd.
01.2022 - 05.2025

BI Developer

DRAiT Solutions LLP
08.2020 - 01.2022

BI Developer

Quick Report Software Pvt. Ltd.
02.2018 - 07.2020

Diploma - Information Technology

MIT, SSPP

SSC - General

SMV, D. Raje

B.E. - Information Technology

AISSMS IOIT
Vishal AvacharSenior Software Engineer