Hi, I 'm Kostas
I have been developing databases and desktop applications for the last 20 years, both as a freelancer and a contractor for various organizations.
I have a bachelor’s degree in computer science. I speak English fluently, and I am always available to talk about what you need and provide specific advice for your needs. I can help your business automate everyday workload, avoid repetitive work, and use reports that are meaningful and help you see the information behind your data. You will be able to eliminate errors, work in a more efficient and organized way, reduce unnecessary costs, and polish your business image. The application will be customized exactly to your needs, and I will provide support as long as needed.
I can help you with:
• Databases: MS Access, MS SQL, Oracle, MySQL
• Application development VBA, PowerApps, PL/SQL, VB .NET, PL/SQL
• Reporting and Dashboards: Power BI, Excel, Google sheets

CRM application for manufacturing company

An MS Access CRM application that allows a medium sized company to manage many aspects of its everyday business. The database can be further customized to better suit specific companies needs and meet all kinds of requirements

• View this project on Upwork

AML client risk assessment reports

An MS Access application that is used to automatically create AML risk management assessments for clients. A configurable questionnaire is filled in and then various factors are automatically calculated. Then a Risk assessment report is created and saved as PDF. Also, a consolidated report is available for the company as well as a report by client and by assessment. An alert is displayed on start up, if there are assessments that must be reviewed in the next 30 days. Manage clients and their assessments Completely configurable questionnaire, the user can add/edit/delete questions and the answers per question Alert for AML assessments that need to be reviewed in the next month AML risk assessment report, consolidated report and list per client and assessment report, all exportable to PDF and Excel

• View this project on Upwork

PERSONAL INFORMATIONKostas Mexias
Athens, Greece,[email protected]
https://www.linkedin.com/in/kostas-mexias/
Skype [email protected]PERSONAL STATEMENT
Professional SW/DB developer/analyst, with more than 15 years of experience
on Banking/Financial and Casino/gambling sectors, at leading companies
(OPAP, CHCL, Oracle).Participated in large projects in Greece and abroad.
Goal-oriented and analytical. Solid communication and organizational skills.WORK EXPERIENCE2015 - Present IT Technical / Business Analyst
OPAP S.A
www.opap.gr
▪ IT Technical Process analyst for VLTs (Video Lottery Terminals) project
▪ Responsible for OS/games distribution (~20.000 VLTs across 660 venues in Greece )
▪ Software/Technical support for VLT technicians / operators / OPAP employees
▪ VLT Software testing using tools such as HP ALM, TestRail and JIRA.
▪ Business process analysis for Jackpot project development, QA testing and roll out to venues2009 - 2015 Database / .NET developer
Club Hotel Casino Loutraki
www.chcl.gr
▪ Hands on experience with IGT software (Galaxis) and underlying SQL/Oracle databases
▪ Application development (.NET,C#, Android, Oracle Forms Designer)
▪ Reporting development (MS SQL Reporting Services, Business Objects, BI, C# Frontends)
▪ Database programming and design (Oracle PL/SQL, MS SQL Server, MySQL)
▪ Design & implementation of the cashless accounts for casino members
▪ Cooperation with IGT (Spielo) and other major companies of the gambling sector.
▪ Deployment, configuration and support of all Casino slots machines systems.2007-2009 IT Technical Analyst – Financial Reporting
Oracle Financial Services
https://www.oracle.com/industries/financial-services/banking/
▪ Central (National) Bank reporting design and development for Alpha Bank Balkans.
▪ Reports development for various bank sectors (Retail, Treasury, Money Market, Loans/Deposits)
▪ Reports development and consulting for Alpha bank Bulgaria, Romania, Serbia, Skopje.
▪ Application and Database programming (Java, PL/SQL, Oracle Forms Designer)
▪ Functional consultant for FLEXCUBE (Banking Software)
▪ 3-month seminars in Banking related procedures (Oracle Training Center, Bangalore, India)2005-2007 IT Manager
Direct Line Call center
▪ Network administration and hardware/software support (120 workstations)
Application development with MS SQL, Borland Delphi and .NET technologies (C#).
▪ Reports Development (Crystal Reports, Borland Delphi, Java, HTML, PHP).
[Public]
▪ Hands-on experience with Cisco Routers, Alcatel Call Centre, firewalls, TCP/IP Networking, DSL/LMDS
Technologies2003-2005 Programmer
IRI Hellas (Information Resources Inc.)
https://www.iriworldwide.com
▪ Database design and development (MS-SQL Server, Oracle).
▪ Development of user-tools and utilities with Borland Delphi, Visual Basic, C#.
▪ Participation in the "Transition" project. Programming in S.A.S. (Statistical Analysis System).
▪ Retail Audit production/data quality control for clients including L’Oréal, Johnson & Johnson, Unilever, P&G1998-1999 Systems administrator
Hellenic Agricultural Organization (E.N.A.)
▪ System administrator of the Organization’s Network throughout Greece
▪ Web Database development and maintenance using Lotus Notes, containing Agricultural news, relevant
legislation online help and forums for a variety of agricultural-related topics
▪ Corporate web site updating and maintenance
▪ Software/hardware remote troubleshooting through teleconferencingEDUCATION AND TRAINING
1999-2001 Bachelor of Science (Computer Science)
University of Salford, UK
Courses :Software Engineering and Design, HTML Web Development, OOP (.NET, C#, VB), Database
Architecture, Java / WEB Programming, Database Analysis and Design, Delphi Programming ,
Communications, Artificial Networks
1996-1998 Computer Applications Specialist
Public Training Institute (IEK), Greece
Courses: Pascal, Clipper, Unix / Linux , Visual Basic, MS SQL, Networks and Communications, MS Office
2008 Banking - IT Concepts Procedures & Software/Financial reporting
3-month training at Oracle training center, Bangalore, India
2004 Diploma in SAS (Statistical Analysis System)
SAS Institute (Athens)PERSONAL SKILLS
Communication
Job-related skills
Tools
▪ Solid communication skills gained through my experience as business analyst at OPAP S.A
▪ Technical analysis skills (OPAP VLTs roll out project : 25.000 VLTs across 660 gaming halls and ~2.500
OPAP stores throughout Greece)
▪ Business Analysis skills (IT business consulting for several banks including Alpha bank )
▪ Business Process analysis skills (experience as Analyst at Club Hotel casino Loutraki, Oracle and OPAP)
▪ Familiar with banking and financial concepts (Oracle financial services trainings)
▪ Solid skills on Database design and architecture
▪ Software development :.NET (C#, VB), Delphi, Python, SAS, Linux scripting
▪ Databases (MS SQL, Oracle, MySQL, MS Access)
▪ Database programming (PLSQL, TSQL)
▪ Reporting development (Power BI, SRSS, Crystal Reports, BI)
▪ QA – Software lifecycle tools (HP ALM, TestRail, OTRS)
▪ UML modelling tools (Enterprise Architect, MS
Visio) ▪ XML, XSD, WSD