Experience

Neurocom SA

• Greece
• Software Development
• 1 - 100 Employee

• Business Intelligence Engineer/Analyst

  • Aug 2018 - Present

  ⦿ Extensive use of Oracle Data Integrator (ODI) for designing data flows and building data integration and ELT processes across multiple systems ⦿ Design database tables, develop and optimize ELT jobs that run in Oracle Data Warehouse, using ODI tool ⦿ Work along with business users from different departments, developers, management professionals and other vendors in order to gather requirements and discuss Business Intelligence solutions ⦿ Collaborate with business users for the creation of test cases and assist them with the UAT testing ⦿ Involved in the process of migrating ETL flows and database schemas across database environments. ⦿ Production of reports in SAP Business Objects (Web Intelligence Tool) and design and creation of the relevant universe (data model) that will be used as a data layer for the reporting. Show less



Intertranslations S.A.

• Greece
• Translation and Localization
• 1 - 100 Employee

• Business Intelligence Consultant

  • Oct 2017 - Present

  ⦿ Creation of multiple process flows that run daily and feed the reports with the relevant data. ⦿ Production of advanced reporting using MS PowerBI that helps the company check their daily/monthly performance and whether they have achieved their targets in order to take the relevant actions. ⦿ Close cooperation with the Sales and Finance teams of the company so as to document their requirements and tailor the reports/dashboards based on their needs. ⦿ Extensive use of the database (MS SQL Server) from Entersoft Business Suite (EBS) which is the main source of information of the company. ⦿ Creation and performance tuning of complex SQL queries that run on SQL server so as to improve performance of the system and reduce the average response time. Show less



InfoSyntaxis

• United Kingdom
• Information Technology & Services

• Business Intelligence & Data Analytics Consultant

  • Mar 2015 - Present

  Provide advanced analytics services using various tools such as MS Excel, MS PowerBI, Qlikview, VBA, GoogleSheets, ArcGIS - QGIS and other BI Tools such as Tableau. Extensive use of SQL scripting, DAX language and Power Query to extract, transform and analyse the data. I have worked with various clients across the world (mainly from USA, Canada and UK plus other European Countries) and successfully completed more than 120 projects. Projects Involved: ⦿ Integration of multiple Xero Accounts with Azure Data Warehouse (Synapse SQL pool) using StitchData platform (Talend) and creation of accounting reports on MS PowerBI by fetching the data from the datawarehouse ⦿ Creation of mobile reports on MS PowerBI ⦿ Spatial analysis and creation of thematic maps using ArcGIS ⦿ Online tutoring to students on how to utilise the functionality of QGIS to analyse and present the spatial data ⦿ Perform data manipulation, analysis, and interpretation of various tabular or spatial datasets and finally presentation of the outputs on thematic maps, Excel tables/graphs and BI dashboards/reports. Show less



AutoRentals.com

• Technology, Information and Internet
• 1 - 100 Employee

• Business Intelligence Consultant

  • Apr 2019 - Apr 2020

  ⦿ Optimization of processes that run on SnowFlake so as to improve the performance of the Data Warehouse ⦿ Tuning of SQL Queries which are used for reporting purposes and creation of new ones ⦿ Assist on Tableau Reporting ⦿ Share ideas on business and technical related issues due to my extensive experience in the travel industry ⦿ Optimization of processes that run on SnowFlake so as to improve the performance of the Data Warehouse ⦿ Tuning of SQL Queries which are used for reporting purposes and creation of new ones ⦿ Assist on Tableau Reporting ⦿ Share ideas on business and technical related issues due to my extensive experience in the travel industry



e-Travel SA

• Business Intelligence Analyst

  • Aug 2015 - Jul 2018

  Advanced Data Analytics and Business Intelligence using QlikView, MS Excel, VBA Programming, MySQL & PostgreSQL. Creation of advanced data models on QlikView and Amazon RedShift and production of high performed, scalable and consistent databases for better analysis and visualisation of the data. Extensive use of real-world large-scale datasets (AWS - Redshift) and in depth analysis of the data so as to turn them into actionable insight and help the company identify risks and opportunities. Improve and monitor performance of the business through the creation of sophisticated dashboards on QlikView and Excel that help the end users quickly identify the problem that need to solve. Dashboards and ad-hoc reports which are tailored to meet the needs from various departments. Role involves close communication and interaction with key stakeholders across departments to help formulate and understand business requirements. Currently managing a cross functional project between Performance Marketing, Business Intelligence, Product and IT Teams to produce a data model and finally various dashboards that will show performance of the business, identify trends and patterns and also display alerts to notify end users of potential sales risks. Assist Finance Team with analysis on payments related data so as to increase online payment acceptance ratio and reduce payment failure ratio. Analyse information from various payment gateways and monitor their performance. Advanced programming on VBA Excel to automate processes, and script writing on QlikView to create reports and produce complex data models. Use or R programming and R algorithms so as to compare the relative importance of predictors in multiple regression Creation of python scripting (extensive use of pandas library) for more advanced data analytics and ETL tasks. Show less



rentalcars.com

• United Kingdom
• Travel Arrangements
• 100 - 200 Employee

• Commercial Insight Manager

  • Oct 2013 - Jul 2015

  Extensive use of MS Excel, VBA Programming, MySQL and SQL Server BI Tools: Tableau Role Accountabilities: * Support the product and commercial team by providing information and insight into current trading, highlighting opportunities and risks to increase business performance. * Rationalise and develop management information ensuring trading messages are delivered in a concise, accurate and timely manner * Develop the competitive data collection to understand market trends, interacting with key stakeholders across the business * Analyse large amounts of data looking for trends and patterns and presenting in a simplified and compelling manner to senior product and commercial management. * Support improved pricing decisions impacting on bookings and profits through interaction with commercial managers. * Analyse customer trends highlighting areas of sales opportunity. * Support AB testing process by analysing and interpreting results driven from the testing process. Show less



Hellenic Army - Communications/Signals Corps

• Private

  • Nov 2012 - Aug 2013

  Communications/Signals Corps of the Greek Army 9-month compulsory military service. As part of my 9-month military service I was assigned the task to create a VBA based program in Excel which allocates the daily duties to soldiers and exports them to a word format. Communications/Signals Corps of the Greek Army 9-month compulsory military service. As part of my 9-month military service I was assigned the task to create a VBA based program in Excel which allocates the daily duties to soldiers and exports them to a word format.



ATD Travel Services

• United Kingdom
• Travel Arrangements
• 1 - 100 Employee

• Data Analytics Architect / Information Analyst

  • Apr 2012 - Aug 2012

  Data Cleansing, Data Validation, Data Integrity, Data Integration, Information Management, Google Analytics MySQL (Oracle), MySQL Workbench, Oracle Databases, MS Excel, MS Excel VBA, MS Access Job activities • Analysing data and clearly communicating findings • Identifying and helping fix problems with our data • Compiling summaries of our data to highlight key points • Helping prevent bad data from entering our systems • Establishing procedures and tests for maintaining the integrity of our data • Working closely with the Finance, Marketing, Operations and Web teams • Balancing long term projects with day-to-day adhoc requests • Assuming overall responsibility for the accuracy and accessibility of 3 back office systems • Modifying incorrect historical data and tracking any such changes • Pulling data from numerous back office systems to present in one standard format • Challenging existing controls and processes • Customer and Product data analysis Show less



University of Cambridge - Department of Architecture

• Research Assistant on Spatial and Transport Modelling - GIS/Data Specialist

  • Oct 2010 - Apr 2012

  ReVISIONS Project: http://www.regionalvisions.ac.uk/ Responsible for data capture, data management and analysis of the spatial, demographic and socio-economic data obtained from multiple sources. Extensive use of MS Excel and MS Access for manipulating and integrating the various national-scale data sets. I have used SQL expressions to select and export the spatial features or table records from the databases and also to display the new feature datasets as graphical representations (thematic maps) or tabular outputs. I have performed statistical analysis of the collected information and created graphs and charts using Excel and GIS so as to describe the trends and patterns of the data such as housing density, population, employment, traffic etc. I have also examined how these spatial and socio-economic features change over space and a specific period of time. I have influenced and supported colleagues in developing, maintaining, and operating GIS (Geographic Information Systems) and database systems. I have assisted on developing a web based GIS application where we can upload the spatial data and make them available to the users through a visual editing interface. Responsible for operating and maintaining a website/forum where our partners can easily exchange information, data and resources related to the project. Show less



Mott MacDonald

• United Kingdom
• Civil Engineering
• 700 & Above Employee

• Graduate Transport Planner / Modeller - GIS/Data Analyst

  • Oct 2007 - Jul 2010

  Projects: << Norfolk County Council – Norwich Area Transportation Strategy (NATS) >> Creation of what-if scenarios for analysing the transport data. Performed analysis of data (e.g. recognised and interpreted trends and patterns in transport data) and produced graphs and charts to illustrate the results. Development of VB applications for the analysis of the data. Extensive use of the Query Builder to build SQL expressions to select and export the data from the spatial databases created on ArcGIS. Performed cost-benefit analysis (social and financial) both on the highways and public transport network and suggested the most beneficial option for the project team to pursue. << Liverpool City SATURN Highway Model >> Extensive use of statistical analysis tools (Excel, SPSS) and database management systems (MS Access, ArcGIS and MapInfo). I provided assistance not only in the statistical analysis of the transport data but also in transport economic analysis. As a data management specialist I had to coordinate all the tasks which were related to the creation and development of the data sets. The data sets came in various formats and they had different structures so I proposed a methodology on how to integrate the data by using the functionality of Excel and also by creating small VBA applications. << Liverpool City Region Transport Model >> Responsible for the delivery and management of the following tasks. Collection of data from different data sources in a variety of formats (csv, dbf, shp, txt, dat etc). Performed data cleansing by detecting and correcting (or removing) inaccurate records from the database. Presentation of the data on thematic maps using the GIS software. Performed economic analysis on transportation networks focusing mainly on congestion costs, parking costs and vehicle ownership costs. Investigated the nature and scale of the economic impact of road infrastructure improvements. Show less


University of Thessaly / Department of Planning and Regional Development
• GIS and Data Analyst

  • 2002 - 2006