Freelancer logo How It Works Browse Jobs Log In Sign Up Post a Project
EXPLORE
Data Entry Data Processing Excel SQL Visual Basic
Profile cover photoundefined
You're now following .
Error following user.
This user does not allow users to follow them.
You are already following this user.
Your membership plan only allows 0 follows. Upgrade here.
Successfully unfollowed user.
Error unfollowing user.
You have successfully recommended
Error recommending user.
Something went wrong. Please refresh the page and try again.
Email successfully verified.
User Avatar
$50 USD / hour
Flag of GREECE
vouliagmeni, greece
$50 USD / hour
It's currently 9:49 PM here
Joined April 29, 2022
3 Recommendations

Alexandros B.

@abatsis

annual-level-four.svgpreferred-freelancer-v2.svgverified.svg
5.0 (80 reviews)
6.4
6.4
$50 USD / hour
Flag of GREECE
vouliagmeni, greece
$50 USD / hour
99%
Jobs Completed
96%
On Budget
98%
On Time
23%
Repeat Hire Rate

Web Aps | SQL | Access | Excel | VBA | Top 2%

I have more than 30 years of experience in Data Modeling and Analysis, specializing in the Industrial Production sector. I work with MS SQL, MySQL, SAP, Excel, Access, Power BI. Since 1990, I have completed many projects in Production Control, Production Data Acquisition (machine data acquired from PLCs, scales, etc.). I also program with T/SQL through stored procedures and table triggers. I have also created many projects in MS Excel and MS Access. I guarantee 100% quality execution of your project. I can work 20/30 hours/week.
Freelancer Excel Experts Greece

Contact Alexandros B. about your job

Log in to discuss any details over chat.

Portfolio Items

Example Flowcharts of an Automated Robotic Handling System.
Flowcharts - Systems Analysis
Example Flowcharts of an Automated Robotic Handling System.
Flowcharts - Systems Analysis
Excel Spreadsheet for Tracking Stock Price with Buy and Sell Signals with Color Symbols Using Custom Formatting
Excel Spreadsheet for the Stock Market
Pallets are loaded from a fully Automated Handling System.
The Robot places the Items on the Pallet and the Automation System updates the Database.
Whith the use of Table Triggers (SQL code that fires when we have a Insert/Update/Delete event in the table).
Pallets Movement System
A web interface for a Production Weighing System build in PHP utilizing Webshockets.
The system is connected to a scale and reteives the Product Gross Weight.
All Production data are saved in a MS SQL Server Database.
Production Weighing System
With use of Heursitic Algorithms the system is trying to find the best area match of Rolls (max rolls) on a Pallet.
The algorithm finds all possible solutions. And suggests for the Optimal solution.
Full parametrical with different:

- Material thickness (affects roll diameter)
- Core diameters (affects roll diameter)
- Role Length (affects roll diameter)
- Pallet types (different pallet sizes)
Palletization Algorithm, Excel VBA
System's and Data Analysis in order to create a normalized Relational Database Model.
Complex SQL Programming in SQL Server or MySQL (Queries, Stored Procedures, Triggers).
Relational Database Modeling

Reviews

Changes saved
Showing 1 - 5 out of 50+ reviews
Filter reviews by: 5.0
$30.00 USD
Nice work. Like always.
Visual Basic Data Processing Data Entry Excel SQL
+1 more
User Avatar
Flag of Thomas K. @TomSamui2
3 days ago
5.0
$1,600.00 AUD
Excellent work. I have really enjoyed working with Alex and his team.
JavaScript Software Architecture Statistics MySQL HTML
User Avatar
Flag of Mike H. @MikeInline
9 days ago
5.0
$60.00 USD
Very satisfied with the work of Alexandros. Will work with him again.
Visual Basic Data Processing Data Entry Excel SQL
+1 more
User Avatar
Flag of Thomas K. @TomSamui2
9 days ago
3.4
₹3,000.00 INR
The task was not completed as it was challenging.
SQL Microsoft Access MySQL Database Programming Microsoft SQL Server
S
Flag of Gautam G. @smsdigitalteam
14 days ago
5.0
$250.00 USD
Excellent job, good communicator
D
Flag of Joost H. @Dutchie
15 days ago

Experience

Senior Systems Analyst, Project Manager

Flexopack S.A.
Jan 2003 - Present
Many years of experience in systems analysis, Relational Database Models design, SQL programming and documenting (ERD, flowcharts, data dictionaries), especially in industrial production projects. The latest project, is a large scale web based Data Collection System for a production process with IoT capabilities. Connected to scales and various sensors. Through WebSockets, data are viewed simultaneously on operator screens and on the administration system. Also the system sends data to SAP

Education

PhD in Industrial Engineering

National Technical University of Athens, Greece 1990 - 1993
(3 years)

Bachelors Degree Mechanical Engineering, specialize in Industrial Engineering

National Technical University of Athens, Greece 1983 - 1989
(6 years)

Qualifications

Member of Institute of Industrial & Systems Engineers

IISE
1993
IISE is the global association of productivity and efficiency professionals specializing in industrial engineering, healthcare, ergonomics and other related professions. IISE is where these varied fields come together to advance the engineering profession through networking, training, and knowledge sharing.

Member of Production and Operations Management Society

POMS - Production and Operations Management Society
1993
Production and Operations Management Society (POMS) is an international professional organization representing the interests of POM professionals from around the world.

Publications

Development of an IT Application for Online Statistical Surveys

Conference: Consolidation of the Statistical Systems of EU Candidate Countries, Romania 2006
Development of an IT Application for Online Statistical Surveys

Orders Loading and Release in Flow Shops including Outsourcing Networks

January 2006IFIP International Federation for Information Processing 257:75-92
Purpose of this paper is to analyse and compare the behavior of workload control models in flow shops of both the MTO (Make-To-Order) and MTS (Make-To-Stock) classes. A simulation model has been built, where a manufacturing cell is loaded through an input control mechanism with shop orders coming from a pool. The pool itself is fed with planned orders coming from an MRP system.

A methodology and Simulation of Workload Control in Cellular Manufacturing

APMS’93
In this paper, a new approach of Workload Control of a Manufacturing Cell is presented. An effort is made to develop a model, using a computer simulation language, to extract conclusions about the application of workload control methodology in cellular manufacturing environment. The manufacturing cell is loaded with work orders using an input control mechanism 'the pool' that is also loaded by planned orders from an MRP system.

Contact Alexandros B. about your job

Log in to discuss any details over chat.

Verifications

Preferred Freelancer
Identity Verified
Payment Verified
Phone Verified
Email Verified
Facebook Connected

Certifications

preferredfreelancer-1.png Preferred Freelancer Program SLA 1 84%

Top Skills

Excel 57 Visual Basic 40 Data Processing 40 SQL 34 Data Entry 32

Browse Similar Freelancers

Excel Experts in Greece
Excel Experts
Visual Basic Developers
Data Processing Executives

Browse Similar Showcases

Excel
Visual Basic
Data Processing
SQL
Previous User
Next User
Invite sent successfully!
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2022 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.