Codebasics Logo

Powered by
Codebasics Bootcamp

Home

About

Projects

Experience

Certificates

Contact
Hello, I am

Harshilkumar Patel

Data Analyst
Resume
Harshilkumar Patel

1

Excel
Project

1

SQL
Project

1

PowerBI
Project

1

Python
Project

About

Me

Hey, I'm Harshil Patel, a Data & Business Analyst based in Utrecht, Netherlands, with a background that bridges engineering precision and business strategy. Before analytics, I spent four years as a Production Engineer and Automation Lead — scaling a manufacturing operation from 750 to 4,000+ units/month, cutting costs by 30% through in-house automation, and growing revenue from ₹12 Cr to ₹100 Cr+.
More recently, I've applied that operational mindset in the Dutch market through my work at Bever B.V. in Utrecht, where I gained hands-on experience in a Dutch retail environment.
I hold an MBA in Data Analytics from Wittenborg University, Amsterdam, with skills across SQL, Power BI, Excel, and Python — applied to real business problems in FMCG, hospitality, and finance. I hold a Zoekjaar visa, giving me immediate work authorisation in the Netherlands — no sponsorship needed.
Currently open to Data Analyst and Business Analyst roles where analytical thinking meets real business Impact.

Key

Skills

SQL

Python

Power BI

Advance Excel

Data Modeling (Star Schema/ Dimensional Modeling)

KPI design and Metric Governance

Financial and Commercial analysis

Ad-hoc executive insight

Business Requirements and Documentation

Stakeholder Management

Cross-Function Alignment

My

Projects

SALES & FINANCE ANALYTICS (Transforming Disconnected Data into a Strategic Governance Ecosystem)
SALES & FINANCE ANALYTICS (Transforming Disconnected Data into a Strategic Governance Ecosystem)

Domain/Function: Computer Peripherals (FMCG)/ DA Analyst

The aim of this project is to counter the Data silos and generate the single source of Truth . Unified fragmented Excel reporting Using Power Pivot, DAX and Power Query. cutting manual work by 83% and preventing $180K+ margin leakage through automated discount governance & star-schema modeling.

See My Work Excel
SQL Ad-Hoc Business Intelligence Analysis
SQL Ad-Hoc Business Intelligence Analysis

Domain/Function: FMCG (Computer Peripherals)

SQL BI case for AtliQ Hardware: answered 10 leadership ad-hoc questions, validated KPIs, and delivered an executive dashboard + management deck. Highlighted portfolio imbalance, discount governance risk, seasonality, and channel dependency.

See My Work SQL
Business Insight 360
Business Insight 360

Domain/Function: FMCG

End-to-end Power BI platform for AtliQ Hardware — MySQL, star schema, 50+ DAX measures, 5 dashboard views covering Finance, Sales, Marketing, Supply Chain and Executive across $4.97Bn revenue data. Live on Power BI Service.

See My Work PowerBI
Hospitality Performance Analytics — Python EDA
Hospitality Performance Analytics — Python EDA

Domain/Function: Hospitality

134,590 bookings analysed. 5 critical problems found. ₹480M opportunity identified. Exploratory Data Analysis on hotel booking data using Python — occupancy, revenue, cancellation and ratings insights.This project analyses 134,590 hotel bookings across 4 cities and 25 properties to find out exactly.

See My Work Python

My

Experience

Bever b.v.

  • Managed regional sales forecasting, conversion analysis, and inventory planning, supporting sales for The North Face across Amsterdam and Utrecht.
  • Coordinated across sales and merchandising teams to ensure timely stock replenishment and performance alignment with business goals. 
  • Involved in target setting, performance tracking, and execution of seasonal campaigns, directly impacting regional sales success.
  • Optimized retail operations and sales performance across high-traffic Amsterdam and Utrecht locations by analyzing daily sales data for demand forecasting and friction-point reduction, resulting in a store-wide conversion increase from 6% to 13% and a revenue growth from €6.3M to €7.2M while maintaining high NPS through data-backed customer service.

Techno Electromech Pvt.Ltd. (Vadodara, India)

July - 2015 to December - 2019

  • Spearheaded the end-to-end setup of the "Pick and Place" automation unit, from equipment selection to workflow design.
  • Successfully automated 80% of LED mounting, significantly reducing manual error rates and increasing production speed by 18%.
  • Developed new SOPs (Standard Operating Procedures) for the automation team.
  • Achieved a seamless transition from manual to automated lines with zero downtime during the implementation phase.
  • Executed a strategic shift from outsourced to in-house LED panel production and optimized resource allocation.
  • Contributed to a revenue increase from ₹6 Cr to ₹20 Cr and boosted net profitability from 7% to 16%.
  • Identified and resolved supply chain bottlenecks through rigorous data-driven planning and Bill of Materials (BOM) optimization. Also, providing Material Requisite (MR) to the store department.
  • Ensured 100% on-time delivery for high-tier clients like Greatwhite and Lighto, maintaining a 0% penalty rate for late shipments.

Awards

& Certificate

CB Cert

Excel: Mother of Business Intelligence

CB Cert

Get Job Ready: Power BI Data Analytics for All Levels 3.0

CB Cert

SQL Beginner to Advanced For Data Professionals

Introduction to Data Science

Introduction to Data Science