Power Bi Data Analyst

Rohan Bhatt

R **************@*****.*** Ó +91-861******* LinkedIn Portfolio

Academics

M.Tech (C-C & Automation) NIT Silchar — CGPA: 9.58/10 B.Tech (ME) Vellore Institute of Technology — CGPA: 7.87/10 Professional Experience

Absolute Agritech (ECSO Global Pvt. Ltd.) Gurgaon

Engineer – Power BI / Data Analyst Aug 2022 – 2025

• Delivered end-to-end BI solutions with 2.5+ years of experience in Power BI, SQL Server, and SSAS Tabular, transforming raw ERP and MES data into actionable insights.

• Designed and optimized SSAS Tabular Models and developed Power BI reports using DAX measures, custom visuals, drill-through, and row-level security (RLS), improving decision-making across operations and supply chain.

• Built and maintained ETL pipelines (Python + SQL stored procedures) to automate data extraction, cleaning, and loading from ERP/MES systems into SQL Server, reducing manual effort by 30%.

• Implemented data modeling best practices (Star Schema, Snowflake, Dimensions, Fact Tables) and developed reusable semantic layers for consistent analytics across teams.

• Improved report refresh performance by tuning DAX queries with DAX Studio, reducing query runtime by up to 40%.

• Partnered with stakeholders to translate business requirements into scalable BI solutions, ensuring alignment between analytics delivery and strategic objectives.

• Recognized for strong communication, cross-functional collaboration, and adaptability in learning new data engineering concepts and tools.

Project – UPAJ AI

Role: Data Analyst (Soil & AgriTech Insights)

• Extracted real-time soil testing data from external APIs and ingested it into SQL Server using Python

(requests, pandas) scripts for automated data collection.

• Designed ETL pipelines to clean, normalize, and transform raw soil data (pH, nutrient levels, moisture) into structured tables for analytics.

• Implemented data validation checks to ensure accuracy and consistency across multiple regions, improving reliability of agri-insights.

• Modeled curated datasets in SQL Server and created Power BI dashboards with advanced DAX measures to track soil health trends and seasonal variability.

• Developed KPIs to assess nutrient deficiency risks and conducted A/B testing on fertilizer recommendation strategies, improving yield prediction accuracy.

• Delivered actionable insights to agronomists and operations teams, enabling data-driven soil management stra- tegies and optimizing overall farming practices.

Project – Insoil: ERP–MES Analytics

Role: Data Analyst & Operations Support

• Extracted data from Microsoft Dynamics ERP(.json) and MES (Excel/CSV) using Python (pandas, pyodbc) and SQL queries, creating reliable data pipelines for production and material usage. 1

• Cleaned, standardized, and transformed datasets (handling missing values, duplicates, and inconsistent hierar- chies) before staging them in SQL Server on-premises.

• Designed relational models and built SSAS Tabular cubes to support fast query execution and flexible self- service reporting.

• Automated end-to-end ETL workflows by linking Python scripts with SQL stored procedures, reducing manual reporting effort by 30% and improving refresh frequency.

• Loaded curated datasets into Power BI, developed advanced DAX measures (OEE, Return-to-Vendor, ABC quality tests), and delivered interactive dashboards that improved supply chain visibility.

• Applied Just-in-Time (JIT) principles in data-driven planning, improving material allocation and achieving

15% cost efficiency across operations.

• Collaborated with cross-functional teams to ensure data quality, governance, and lineage, aligning opera- tional reporting with long-term analytics strategy. Skills

Analysis Tools Languages Databases Productivity Tool Power BI Desktop SQL ERP (MS Dynamics) Power BI Service DAX Studio DAX MES Systems MS Office Suite

Excel M-Query MS SQL Server JIRA

SSAS (Tabular) Python (pandas, pyodbc) ETL

Certifications

Certified Data Analyst Skillovilla

CSSC Lean Six Sigma White Belt CSSC

CSSC Six Sigma White Belt CSSC

Languages

English: Intermediate Hindi: Native

2

Contact this candidate