Profile photo of Ashwin Raphel

Welcome to my portfolio

Ashwin Raphel Illiparambil Gabriel

Data Analytics • Business Intelligence • Process Improvement

Business-oriented analytics professional with more than 10 years of experience in project coordination, reporting, stakeholder management and process improvement. I use Excel, SQL, Python and Tableau to transform data into clear, actionable business insights.

Based in Northeim, Germany

Explore Projects Contact Me Download CV ↓

Professional Profile

Business management professional with 10+ years of experience in B2B operations, project coordination, stakeholder management, KPI reporting, and process improvement.

After completing the Google Data Analytics Professional Certificate, I transitioned into Data Analytics and have built 2+ years of hands-on experience through self-directed learning and real-world analytics projects using Excel, SQL, Python, Tableau, and BigQuery.

My goal is to combine strong business knowledge with modern analytical tools to transform data into actionable insights that improve decision-making and drive business growth.

Technical Skills

  • Microsoft Excel logo

    Excel

    Pivot Tables, XLOOKUP, Power Query, reporting and data cleaning

  • SQL logo

    SQL

    Data extraction, filtering, joins, aggregation and analytical queries

  • Python logo

    Python

    Pandas, exploratory data analysis, data preparation and basic visualization

  • Tableau logo

    Tableau

    Interactive dashboards, data visualization and business storytelling

Additional Competencies

KPI Reporting • Dashboarding • Data Validation • Business Analysis • Market Analysis • Stakeholder Management • Process Improvement • Cross-Functional Collaboration

Professional Experience

Senior Executive

Joeltech Systems, India

2014–2023

  • Managed more than 40 customer projects involving operational, technical and process-related data.
  • Prepared reports, tracked KPIs, maintained project records and supported management decision-making.
  • Used Excel extensively for reporting, validation, analysis and performance monitoring.
  • Coordinated a team of six engineers and collaborated with customers and international partners.
  • Supported process improvement initiatives that increased efficiency by up to 30%.

Assistant Manager

Pilotsmith India Pvt. Ltd.

2013–2014

  • Coordinated turnkey engineering projects and technical documentation.
  • Managed dealer relationships, customer communications and supplier coordination.
  • Planned and executed marketing campaigns, promotional events and exhibitions.
  • Prepared marketing materials, product information and customer communications.
  • Supported technical sales activities and strengthened client relationships.

Assistant Manager

Campus Global

2012–2013

  • Coordinated student admissions, visa applications and administrative workflows.
  • Managed key client accounts and maintained strong customer relationships.
  • Scheduled meetings, coordinated with external partners and supported strategic initiatives.
  • Maintained documentation, processed records and managed office administration.
  • Supported social media activities and daily customer service operations.

Engineering Trainee

Quest Innovative Solutions (P) Ltd.

2008 – 2009

  • Supported embedded systems development and student engineering projects.
  • Assisted the R&D team with product research, testing and technical feedback.
  • Gained practical experience in microprocessor and microcontroller programming.
  • Worked with 8085, 8086, ARM, 8051 and PIC embedded platforms.
  • Built a strong foundation in electronics, embedded systems and problem-solving.

Data Analytics Projects

German EV Market Analysis (2020–2026)

Python • Pandas • Matplotlib • Seaborn • Data Visualization

Analyzed Germany's battery electric vehicle market using official KBA registration data together with manufacturer verification and model mapping. Explored market growth, manufacturer performance, vehicle segments, model popularity, and EV adoption trends between 2020 and 2026.

Explore Case Study

Marketing Campaign Performance Analysis

Python • Data Cleaning • EDA • Tableau

Analyzed campaign KPIs, customer engagement and conversion performance to identify optimization opportunities and support marketing decisions.

Explore Case Study

Cyclistic Bike-Share Analysis

Python • Data Cleaning • EDA • Data Visualization

Analyzed customer behaviour, rider segmentation and usage trends to develop recommendations supporting membership growth.

Explore Case Study

Bellabeat Product Usage Analysis

Python • Tableau • Data Cleaning • EDA

Examined fitness tracker usage data to identify consumer behaviour patterns, wellness trends and potential marketing opportunities.

Explore Case Study

Professional Certifications

Education and German Recognition

IR Creative Works

Alongside data analytics, I create informative and documentary-style digital content covering technology, artificial intelligence, automotive topics and life in Germany.

Visit My YouTube Channel ↗

Contact

I am open to opportunities in data analytics, business intelligence, reporting and data operations across Germany.

Email Me LinkedIn ↗ Kaggle ↗ Tableau ↗ YouTube ↗ Download CV ⭳