Summary
Overview
Work History
Education
Skills
Research Projects
Projects
Certification
Languages
Timeline
BusinessAnalyst
Faiz Karol

Faiz Karol

Data Analyst
Essen,NW

Summary

Analytical and results-driven professional with a knack for turning complex data into clear, actionable insights. Known for improving processes, solving problems, and delivering meaningful impact in dynamic environments.

Overview

6
6
years of professional experience
6
6
years of post-secondary education

Work History

Werkstudent ALCM

HSBC Trinkaus & Burkhardt
03.2025 - Current
  • Automated complex liquidity reporting processes using VBA and Python, improving reconciliation accuracy across datasets and saving significant manual effort.
  • Supported regulatory stress testing and scenario modeling contributing to data-driven insights.
  • Collaborated with finance and risk teams to develop dashboards and financial models that drive capital planning and balance sheet optimization.
  • Recognized for a proactive, solution-oriented mindset and quickly entrusted with core ALCM initiatives in a high-impact, regulatory-driven environment.

Senior Software Engineer

Capgemini Technology Services
10.2021 - 02.2024
  • Led the migration of credit decision systems to SAS ID, streamlining data workflows, and improving operational efficiency.
  • Developed and refined batch and online models in SAS Viya, enhancing accuracy in credit risk analytics.
  • Designed and delivered dashboards using SAS Visual Analytics and Advanced Excel to support business reporting and decision-making.
  • Executed comprehensive unit, regression, and load testing, and automated deployments to improve system reliability.

Mentorship and Recognition:

  • Mentored junior engineers, fostering team development.
  • Awarded "Rising Star of the Year" for outstanding performance and leadership.

Python Developer Intern

Peace Infotech Pvt. Ltd.
08.2019 - 10.2019
  • Developed and optimized Python automation scripts, improving workflow efficiency, and reducing manual effort.
  • Collaborated with senior developers to enhance coding standards and gain hands-on experience in real-world development practices.

Intern Software Engineer

Intragate Solutions Pvt. Ltd.
03.2018 - 12.2018
  • Built interactive quiz applications using Flutter and Dart for U.S. based educational clients, focusing on user experience, and rapid development.
  • Improved database performance and application reliability by optimizing data retrieval with Oracle SQL and enhancing debugging processes.

Education

Master of Science - Big Data & Business Analytics

FOM University of Applied Sciences
Essen, Germany
03.2024 - Current

Bachelor of Engineering - Electronics & Telecommunications

University of Mumbai
Mumbai, India
08.2016 - 05.2021

Skills

Programming Skills

  • JAVA
  • SQL
  • Python
  • SAS ID (DS2)
  • COBOL

Tools and Platforms

  • Mainframe Servers
  • Visual Studio
  • SAS Viya
  • Power BI

Technical Skills

  • Manual Testing
  • Software Development Lifecycle
  • Agile Methodology

EDV Skills

  • MS Office
  • Specialization in Excel (VBA)

Soft Skills

  • Analytic
  • Collaborative
  • Leadership
  • Detail-Oriented

Research Projects

Promotion Profitability Optimization Engine (PPOE)

  • Created a synthetic yet realistic FMCG dataset for Storck Germany, simulating promotions across product categories and channels.
  • Applied K-Means clustering and Random Forest regression to segment campaigns and predict ROI with 98% R² accuracy.
  • Built a rule-based recommendation engine to filter underperforming setups and suggest high-ROI promotional strategies.

Fan Momentum Index (FMI)

  • Conceptualized and led development of a real-time index integrating live tweet sentiment, tweet volume, and stadium audio to quantify fan momentum.
  • Designed a Python-based pipeline for multimodal data collection, preprocessing, feature engineering, and visualization.
  • Validated FMI against match events (e.g., goals, red cards) in a Real Madrid vs Dortmund case study, demonstrating predictive orchestration potential.

Toni Kroos Data Corpus & Analysis

  • Built a structured corpus from 600+ matches using match videos, articles, and performance stats; applied Python-based data cleaning, NLP, and video processing.
  • Developed heatmaps, tactical diagrams, and interactive dashboards to analyze career milestones, passing trends, and seasonal performance patterns.
  • Integrated structured and unstructured data sources to deliver visual insights and statistical comparisons with other players.

Projects

Tripsy: An artificial expedition guide for your dream city (Bachelor final year project)

  • Tripsy’s main objective is to make traveling easier for the tourists visiting the city (Mumbai)
  • Made using Dialogflow and presented as the final year project for my Bachelor of Engineering
  • Chatbot link: https://t.me/tripsybot

Restaurant Virtual Assistant : A personal assistant to a restaurant(Restobot)

  • A personalized assistant to a specific restaurant that provides all the information and details about the restaurant, its cuisine, and other attributes
  • Made using Google Dialogflow, Restobot achieved first place at the 3rd national-level paper and model contest, "Technovation 2020," organized by the IEEE student branch of Poornima College of Engineering, Jaipur.
  • Chatbot link: https://t.me/RestaurantVirtualBo

Certification

  • Technovation 2020 Winner, Won first prize for RestoBot at IEEE's national contest at Jaipur University, recognized for innovation in AI-driven virtual assistants.
  • QSPIDERS-certified, Manual Testing, Core Java, Web Security Testing, Database Testing, Agile Methodology

Languages

English
First Language
German
Beginner (A1)
A1

Timeline

Werkstudent ALCM

HSBC Trinkaus & Burkhardt
03.2025 - Current

Master of Science - Big Data & Business Analytics

FOM University of Applied Sciences
03.2024 - Current

Senior Software Engineer

Capgemini Technology Services
10.2021 - 02.2024

Python Developer Intern

Peace Infotech Pvt. Ltd.
08.2019 - 10.2019

Intern Software Engineer

Intragate Solutions Pvt. Ltd.
03.2018 - 12.2018

Bachelor of Engineering - Electronics & Telecommunications

University of Mumbai
08.2016 - 05.2021
Faiz KarolData Analyst