If you read the CV sequentially you might notice gaps in time. As an unemployed i spend time doing some freelancing parallel to honing skills and working\studying on apps that require tech savviness and business\economics acumen.These apps include project management, cash accounting, KPIs, forecasts. You may find details on the second section of work experience!
Work Experience (Full-time\project-based)
SpitiXorisMesiti.gr
Employer's Industry: Online Real Estate Ads
Implementation&Technologies:
Claude Code(context,skills,agents)
Laravel7.x Framework
Php 7.2
MySql
Modern Javascript
- Updated the tasks' pipeline by calibrating Claude code for smoother developing.Now tasks are unit-tested and documented automatically.Also we designed prompt engineering for users in order to paraphrase and personalize their searches(a text paragraph).
- Upgraded (multi-purpose) communications with an email marketing system that, either periodically or per event, populates templates with data from the database and sends emails to users\owners.
- Made (some crucial) improvements on UD\UX responsive Front-end(.js\.css)
- Acellerated the MySql database (achieving ~8x)
- Created Laravel Middleware for Auditing, Performance tracking and Sanitization
- Cooperated with admin to run database tasks and scheduled(cron) jobs
- Created live dashboard for most of the management’s needs
- Created Services to exchange information with other APIs like ERPs, Banks, Google analytics, ReCaptchas
- Created Google\Facebook events for ads and analytics
SpitiXorisMesiti.gr
Employer's Industry: Online Real Estate Ads
Implementation&Technologies:
Laravel7.x
Javascript Datatables\Filters
Javascript Canvas
Regression
KPIs\KRIs
as the analyst of a team, I..
- Created,Used,Corrected & Enriched (feature lifecycle) interactive Dashboards for stakeholders and decission makers
- Appended the database with daily collected of Performance Indexes (KPIs\KRIs) for the health of the software and the business.
- Time aggregation, trends and\or Growth Index of these are to be displayed in the dashboard...but were ALSO used as inputs (timeseries) to more advanced models created with the help of claude\copilot and 1) RStudio 2) Excel and 3) Realstats.xlam for presentations to VCs and investors
Blue Titans Hospitality
Employer's Industry: Tourism-Short term rental
Implementation&Technologies:
Monday
VBA
MS-Office
Google-Office
- Besides, daily routine(Monday, Slack, b&b Platforms) I developed some in-House Apps for:Warehouse Monitoring app for Amenities with Lots, Fifo, Multi-StockKeepingUnits (MS-Acccess) and decentralized data entry form (Google Sheets) Automated Email Sending in a cleaning service firm whenever bookings occurred that changed the schedule (With periodic check for new bookings in our calendar-sync-provider software (which is a site that offers Web API data access service).It was done with the help of PowerQuery in MS-Excel)
Blue Titans Hospitality
Employer's Industry: Tourism-Short term rental
Implementation&Technologies:
VBA
MS-Office
Google-Office
PowerQuery
Google Data Studio
as a tech expert of the team I..
- .. analysed peak season revenue with summary tables, descriptive statistics, histograms with classes for numerical data (added 3 KPIs to the existing table) and charts for non-numeric data. Clusters and trends or normality were not detected .
- .. data-crunched Google analytics data( users, views, sessions) across suggested dimensions like psychographics, demographics, technologies, etc
- .. used Google Data Studio to create a 4-page report\dashboard with maps, graphs with both short-term and long-term focus.
MIK3
Employer's Industry: Contracts
Implementation&Technologies:
MS-SQL database
MS-Word
- Application to fill in database data on MS-Word files
Assel(interview projects)
Employer's Industry: Learning&Multi-media
Implementation&Technologies:
compact MS-SQL .sdf database
C#
- Spot the differences Player(plays)\Editor(uploads differences for player) version
- Word guess games (Hang-man)
Mik3 on behalf of Amstel(PoC)
Employer's Industry: Brewery
Implementation&Technologies:
Bing Maps
C#
permutations
hierarchical clustering
- A schedule for Amstels Salesmen. A clustering and routing PoC was developed. Periodic visits, Working hours constraints and time spend on each point-of-sales made the project more challenging
Artefact
Employer's Industry: Creative technologists
Implementation&Technologies:
Bootstrap
Wordpress
WP_Queries
Q&A plugin
php
- WordPress BLOG portal for start-up support Website for an entrepreneurship hub:Developed pages for hosting videos, Questions & Answers discussions, Self-Assessment questionnaires and security that allows only entrepreneurs-users access to some services
i4g Consultants
Employer's Industry: Consultants
Implementation&Technologies:
Economic research
Mode of entry
Excel Ranking & Solver
- Comparison of countries for potential investment Choice of countries and mode of investment for a piece of software calculating dimensions for engineers on behalf of 3p software. Implementation with several ways to weigh and combine criteria and solve for amount of investment,ad expense, and mode of entry.
Artefact
Employer's Industry: Creative technologists
Implementation&Technologies:
php
MySQL
jQuery (Tiny MCE,LightBox)
- Mini-CSM Development of viewer-editor for pictures portfolio. Components of the viewer-editor app, which acts like a Content Management System, included .html blocks, images, links, quotes
for Mik3 for small teamwork projects
Employer's Industry: Information systems
Implementation&Technologies:
ASP.MVC
Crystal reports
C#
- R&D for AudioStreaming & crossfade,
- WebSite reports with ASP MVC, C# applying CrystalReports & the (innovative then)JQuery
- ErrorHandling dll for Greek,unified & friendlier messages from Sql server and Oracle[1]
for Mik3 on behalf of DODONI
Employer's Industry: Software Solutions
Implementation&Technologies:
Excel forecast functions
pivot tables
95%CIs
- Forecasts Statistival estimate of forecast (trend+seasonality) including best-worst scenarios for all of the columns of a pivot table.Columns are respoinsive to the user while row-months are fixed
ANELPA
Employer's Industry: Brand Development for restaurant & cafes
Implementation&Technologies:
Excel
Access
- In-house apps Store viability and profitability estimation
- Break-even analysis in Excel
- Asset Depreciation in ms-Access
- Data Consolidation & Pivot Table unifying workbooks based on file search(ie coming from the same template)
- MRP:FoodCost calculation & estimation of raw material needs(given Bill of Materials) from past consumption(ie for control purposes) or forecasted consumption(ie to purchase according to forecasted needs)
for Vimelia
Employer's Industry: Winery & Liquor store
Implementation&Technologies:
Excel
ERP backend
- Prices set (Cost plus) for the whole price catalog Created %margin verification spreadsheet with effective price rather than catalogue price(which is affected by, for example, discounts,offers,etc) .
for MIK3 for Fournos Sto Limani SA
Employer's Industry: Bakery chain stores
Implementation&Technologies:
DB2
OS-400
DCW
win-based GUI
- Data entry of t-accounts structure Design of ANSI SQL querys,. Customization of ERP Using OS/400 Hardware and DCW software.
for Lidl
Employer's Industry: Discount stores
Implementation&Technologies:
Lotus Notes
- Establish Document Flows given a job hierarchy with approvals and feedback loops centralizing and unifying anything from chat to signed documents like a budget.
Work\Study on software projects
For each of the following projects there exist Marketable demos
User role:Project manager,Project planner,CFO,CIO
Implementation&Technologies:
C#
Excel
R
PowerQuery
- A C# Project that implements an R-package, called forecastHybrid, to generate and parameterize monthly\quarterly forecasts. The output is historical forecasts(taking into account only the past behaviour and seasonality of the one variable in focus[2] ) that were created with cross-validation and box-cox transformations.The 6 models the package generates as output can be weighed in excel (ie based on the error(actual-forecasted) of each model and have some of the parameters tweaked so that the qualitative expectation of the analyst can be embedded in the ensemble model. Forecasts, aside from being a formal and objective expression of expectations and boundaries of the variable, they can be used in all sorts of foreward-looking optimization[3]
User role: Project manager\Project planner | Position/Role: Developer\Analyst
Implementation&Technologies:
VBA
Excel
Access
GeneticAlgorithms Solver add-in(for HR allocation)
Decission tree add-in(for risks)
- An Access/Excel application trying to meet an SME’s project planning and management needs without a large/upfront investment. Already in the CHEAP version I implemented: S-curves & Probability of on-time, on-budget completion, project indices: Tolerance/Variance, Earned Value Management. Whereas for the PRO version I extended the model with value-adding functionalities such as: Document and appraise Project(s), Calculation of optimal resource allocation per program (one or more projects), business KPIs/KRIs per activity for stakeholders' needs and target setting on them, Monte Carlo simulation for duration, cost, and indices with set value, compliance checks to the (latest) plan given the risk profiles of all sorts of stakeholders, special functions for time series[4]
User role: Economist\Business owner
Implementation&Technologies:
C#
.NET
Outlook
Janus Controls
Excel
Basic Accounting\Economic accumen
- In the friendly (CHEAP version) of the app, the income-expense ledger is approached by augmenting the windows or office calendar with a single form, Then, the value/monetary (periodic!!!) flow is entered directly onto the calendar/agenda. It allows the following few but rich in information and utility reports:1)Export to Excel Pivot Table & Chart, covering 75% of cash-reporting needs, 2) Forecasts of (filtered) Revenues or Expenses, 3) Break-even point calculation for all cash flows. After a clever intervention, in the PRO version, revenues and expenses, and cash flows and orders tie together allowing: 1) all features of the first version for NET values (inflows outflows per group) since now every order carries the relevant cost and outflows that enabled it, 2) Calculation of ROI per order (and group of orders e.g., product category), 3) Creation of Cashflow Cycle[5] for each group
User role: Business Owners\CEO\CIO\Strategist
Implementation&Technologies:
JS Canvas.
HTML 5.0.
Node Server.
- A smaller but potentially more impactful intranet application supporting up to 100 indices selected from a base of >3000 indices (PIs, RIs) for every aspect of the business. These business performance indices (leading), maybe seen by a hierarchy of employees frequently .these are precursors of economic performance indices (lagging \ goals), which are gathered into dashboards that the stakeholders consult less frequently. As for their selection, a survival process is required where some will emerge as Key (the 'K' in KPI) when their predictive capability and ability to transform information into knowledge and action are proven.
Skills in Software
Windows /Linux(usage+basic admin concepts)Very good
Visual basic,C# for:Web&Windows appsVery good
Javascript & .js technologies and frameworksVery good
VBA,MS-Office programmingExpert
SharePoint, AzureBeginner
Php7 , LaravelVery good
AI Prompts\Claude CodeVery Good
Analytics: Data factory ,Data studio, Data bricksBeginner
Analytics: Power BI/SQL Server Analysis services ,ExcelExpert
Project management (MS-Project / brightProject)Very good
ERP(KEFALAIO 4,Χ-line)Intermediate
Relational databases, SQL(any form even Big data or SQL ML procedures)Expert
Non relational databasesBeginner
Python Jupyter, Data bricks:Intermediate
Statistics tools: Excel, R, SPSS, Data Tab, RealStatsVery good
Site Dev. CMS (droopal,webmatrix,wordpress)Very good
Skills in CSci\STEM
Analytics: Simulation, Optimizations, Data-mining, Genetic algorithms, Neural networks, Forecasts, Regression(s),Clustering, Classification,Linear programmingExpert
Data science: Multivariate TimeSeries, Causality-Cointegration, Network effects, Data envelops, Factor analysis, SEMGood