Konstantinos Karagiannis Email & Phone Number

Greece

Greece

Worked for client EFG Eurobank:- Led end-to-end large scale DWH projects from requirement gathering, prioritization and planning, to design, development, testing, deployment and operation.- Translated business needs into technical specifications and then into robust, scalable and cost-efficient ETL/ELT pipelines, ensuring data quality and integrity.- Built, maintained, enhanced and owned core datasets for critical regulatory reports consolidating high volume data from several transactional banking systems, internal files and external partners’ datasets.- Migrated projects from on premises to Azure Cloud Big Data stack through rehosting and refactoring migration strategies.- Onboarded, trained, did code reviews and coordinated junior colleagues.- Mentored junior and mid-level engineers through Coaching practices. Has received the golden 'Rookie Coach' company award for his effectiveness and initiatives.- Documented development processes, delivered projects and domain knowledge.- Delivered presentations on data-related topics at internal meetups.Technologies and tools:PySpark, Databricks, Airflow, Azure DevOps, Git, SQL, IBM Db2, IBM AS/400

Patras

- Developed and maintained 2 TB enterprise data warehouse (EDW) used for reporting purposes by the company’s departments (Product, Customer Success, Finance, Sales, Marketing, etc.), executive management and investors.- Utilized REST API to ingest data from several web services (advertising platforms, CRM, ERP).- Designed, developed, tested, optimized, deployed, orchestrated and owned batch ETL pipelines that built key metrics and dimensions.- Built impactful reports and dashboards that drove business decision-making.- Gathered business requirements from stakeholders and translated them into technical requirements.- Worked with Agile software development methodologies.- Managed database lifecycle; analysis, design, implementation, testing and maintenance.- Developed, maintained and deployed OLAP cubes.- Documented delivered projects and data processes.- Automated manual processes and increased efficiency of several business departments by saving over 300 man-hours per month.- Improved ingesting data from web services performance by 60%, by writing from scratch optimized REST API clients for company’s major data sources.- Improved ETL performance by 40% by optimizing queries, parallelizing data flows and simplifying data warehouse architecture.- Reduced bugs by 25% and saved over 30 man-hours per month from my team by introducing best practices that improved code quality, QA process and reduced maintenance overhead.Technologies and toolsPython, T-SQL, SQL Server, SSIS, SSAS, Windows Server, Google Cloud Platform (GCP), Jira, Confluence, TARGIT

Lefkada

- Increased bookings by 60% by planning and executing business digital strategy focused on the Balkan market.- Designed, developed, deployed and maintained company’s website.- Managed bookings via reservation platforms (Airbnb & Booking.com), email, phone and social media.- Provided customer service in person, by email and over the phone.- Collected deposits and payments.Technologies and practices: Business Development, Reputation Management, WordPress, SEO

Prefecture Of Achaia

- Led over 250 fast-paced matches from junior to adult amateur level.- Collaborated with the assistant referees for decision-making.- Resolved conflicts and dealt with players' complaints.

Lefkada

- Provided customer service in person, by email and over the phone.- Managed vehicle bookings, availability and delivery via the Wheels Car Rental System software.- Was responsible for collecting deposits and payments, cashing up and opening and closing the premises.

Bachelor'S Degree, Department Of Electrical And Computer Engineering (Ece)

- Modules studied include: Algorithms, Data Structures, Programming, Databases, Operating Systems, Computer Networking, Systems Design.

Bachelor'S Degree, Department Of Primary Education

- Modules studied include: Mathematics, Psychology, Sociology, Ethics, Music, Greek Literature, History and Geography. - Taught.