Nagesh Ekbote

Data Analyst with total 7+ years of experience Data Analytics, Business Intelligence, Power BI Development, SQL Reporting, and Advanced Excel. Skilled in transforming complex business data into actionable insights through interactive dashboards, KPI reporting, data modeling, and automation solutions. Experienced in SQL querying, DAX development, ETL processes, Power Query, and stakeholder management.

Strong domain expertise in Logistics, Freight Pricing, Supply Chain Analytics, and Operational Reporting.

Senior Analyst - SHIPCO IT PVT. LTD.

(2021-07)

Key Achievements

• Developed and maintained 15+ interactive Power BI dashboards and reports supporting Tariff Rates, Operations, Rates and Pricing team, and Management teams.
• Built scalable data models using Star Schema principles and developed advanced DAX measures for KPI tracking and business analysis.
• Created executive dashboards enabling leadership teams to monitor operational performance, shipment trends, pricing analysis, and business KPIs.
• Integrated data from SQL Server, Excel, and SharePoint into centralized reporting solutions.
• Performed extensive ETL activities using Power Query including data extraction, transformation, cleansing, validation, and standardization.
• Developed advanced DAX calculations including Year-to-Date (YTD), Month-to-Date (MTD), Quarter-to-Date (QTD), Rolling Averages, Variance Analysis, Dynamic KPI Calculations.
• Implemented Dynamic Row-Level Security (RLS) ensuring secure access to reports across multiple business functions and regions.
• Published and managed enterprise reporting solutions in Power BI Service with automated refresh scheduling through On-Premises Data Gateway.
• Created complex SQL queries using joins, subqueries, CTEs, aggregations, and window functions to support reporting requirements.
• Developed SQL views to improve reporting performance and simplify business reporting processes.
• Conducted data reconciliation and validation between source systems and reporting outputs, improving reporting accuracy.
• Automated reporting workflows using Power Automate, reducing manual effort and improving reporting turnaround time.
• Partnered with stakeholders to gather requirements, define KPIs, and deliver business-focused analytical solutions.
• Converted large volumes of operational data into meaningful insights, supporting strategic decision-making.
• Supported freight pricing analysis, shipment cost validation, and operational reporting across global regions.

MIS Executive - LOKMANGAL BIO-TECH PVT. LTD.

(2018-06 - 2021-06)

• Generated Daily, Weekly, Monthly, and Annual MIS reports using Advanced Excel.
• Developed management dashboards and presentations for business performance tracking.
• Analyzed sales performance, incentive calculations, target achievement, and operational metrics.
• Extracted, transformed, and analyzed ERP data to support reporting requirements.
• Created automated reports using Pivot Tables, Power Query, and advanced Excel formulas.
• Delivered actionable insights supporting sales planning and operational decision-making.

Bachelor of Science - Statistics - Solapur University (2014-01 - 2017-12)