Freelancer logo
Log In Sign Up
Post a Project
EXPLORE
Data Entry
Data Processing
Excel
SQL
Visual Basic
Profile cover photo
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
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

Alexandros B.

@abatsis

annual-level-four.svgverified-v2.svgpreferred-freelancer-v3.svg
5.0
185
7.7
7.7
98%

SQL | Access | Excel | VBA | Web Aps | Flowcharts

$65 USD / Hour
・
Flag of
Greece (1:37 AM)
・
Joined on April 29, 2022
$65 USD / Hour
・
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.
Verifications
On time
99%
On budget
99%
Accept rate
98%
Repeat hire rate
21%
Freelancer Excel Experts Greece
See all Excel Experts in Greece

Portfolio

Portfolio

10025748
Example Flowcharts of an Automated Robotic Handling System.
Flowcharts - Systems Analysis
Example Flowcharts of an Automated Robotic Handling System.
Flowcharts - Systems Analysis
10003729
Excel Spreadsheet for Tracking Stock Price with Buy and Sell Signals with Color Symbols Using Custom Formatting
Excel Spreadsheet for the Stock Market
9991255
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
9991251
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
9991123
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
9990791
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
10025748
Example Flowcharts of an Automated Robotic Handling System.
Flowcharts - Systems Analysis
Example Flowcharts of an Automated Robotic Handling System.
Flowcharts - Systems Analysis
10003729
Excel Spreadsheet for Tracking Stock Price with Buy and Sell Signals with Color Symbols Using Custom Formatting
Excel Spreadsheet for the Stock Market
9991255
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
9991251
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
9991123
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
9990791
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
Changes saved
5.0 · 185 Reviews
Reviews
I
MySQL cursor/procedure extension and optimisation -- 2 • €160 EUR
Excellent job by Alex. You are a champion!. Will definitely use again.
Jag P.
@IconicStones
•
Flag of
Lynbrook, Australia
•
5 days ago
Share
H
AOS Database Architecture for Warehouse System • £1,440 GBP
Very positive experience, would certainly use again.
Harry W.
@harrydwatts89
•
Flag of
Stevenage, United Kingdom
•
2 months ago
Share
R
Coding Task for Candidate Feedback Reports - 12/11/2024 07:23 EST • £650 GBP
Easy to work with, prompt and translated my needs as a non techie into something that works well!
Rebecca .
@rebeccaGC
•
Flag of
Chester-le-Street, United Kingdom
•
2 months ago
Share
User Avatar
update on planning sheet • €155 EUR
A+++ Quick solution for the requested project at a good price. Hope to be working with alexandros in the future also.
Claus N.
@Cnnielsen
•
Flag of
Hjørring, Denmark
•
2 months ago
Share
P
Searchable Database - DPX • $1,750 USD
Alexandros goes above and beyond to make sure his projects are Completed and at the best level expected. we have used him many times and every project came out perfect. i would Highly recommend him.
Evan B.
@purchasingAEI
•
Flag of
Garfield, United States
•
3 months ago
Share
Experience
Senior Systems Analyst, Project Manager
Jan, 2003 - Present
•
21 years, 11 months
Flexopack S.A.
Jan, 2003 - Present
•
21 years, 11 months
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
Jan, 2003 - Present
•
21 years, 11 months
Education
National Technical University of Athens
1990 - 1993
•
3 years
PhD in Industrial Engineering
Flag of
Greece
1990 - 1993
•
3 years
National Technical University of Athens
1983 - 1989
•
6 years
Bachelors Degree Mechanical Engineering, specialize in Industrial Engineering
Flag of
Greece
1983 - 1989
•
6 years
Qualifications
Member of Institute of Industrial & Systems Engineers
1993
IISE
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.
1993
Member of Production and Operations Management Society
1993
POMS - Production and Operations Management Society
Production and Operations Management Society (POMS) is an international professional organization representing the interests of POM professionals from around the world.
1993
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.
Certifications
P
Preferred Freelancer Program SLA
US English - Level 1
US English
Invite sent successfully!
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Freelancer logo United Kingdom / English
Help & Support
Freelancer
Categories Projects Contests Freelancers Enterprise AI Development Membership Preferred Freelancer Program Project Management Local Jobs Photo Anywhere Showcase API for Developers Get Verified Desktop App
About
About us How it Works Security Investor Sitemap Stories News Team Awards Press Releases Careers
Terms
Privacy Policy Terms and Conditions Copyright Policy Code of Conduct Fees and Charges
Partners
Escrow.com Loadshift Warrior Forum
Apps
Apple App Store logoGoogle Play logo
Copy to clipboard failed, please try again after adjusting your permissions.
Copied to clipboard.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2025 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.