Alexandros B. Profile

EXPLORE

5.0

(158 reviews)

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.

$50 USD / hour

vouliagmeni,

greece

$50 USD / hour

It's currently 1:06 PM here

Joined April 29, 2022

10 Recommendations

Alexandros B.

@abatsis

5.0

(158 reviews)

7.4

98%

$50 USD / hour

vouliagmeni,

greece

$50 USD / hour

99%

Jobs Completed

98%

On Budget

99%

On Time

23%

Repeat Hire Rate

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

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.

See all Excel Experts in Greece

Contact Alexandros B. about your job

Portfolio

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

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

Flowcharts - Systems Analysis

Excel Spreadsheet for the Stock Market

Pallets Movement System

Production Weighing System

Palletization Algorithm, Excel VBA

Relational Database Modeling

Reviews

Changes saved

Showing 1 - 5 out of 50+ reviews

Filter reviews by:

5.0

$2,000.00 USD

Comprehensive ROI Calculator Development

Alex did an incredible job on a very complex, difficult project. Incredibly bright and patient - an absolute pleasure to work with!

Excel

Statistics

Business Analysis

Andrew W.

@AndrewWert

•

5 days ago

5.0

€50.00 EUR

MySQL Performance Enhancement

Alexandros was a gentleman. He rescued me after my high traffic website near ground to a halt. This was due to SQL database errors and high CPU usage on server. Before I even posted a project, he had a look a fixed things. He charged me for half hour's work, but I paid him for a full hour in appreciation.

MySQL

Database Programming

Tom C.

@themediapro

•

11 days ago

5.0

£2,000.00 GBP

Development of new features in our Inventory management application

Great as always. Great work at an always great level.

Microsoft Access

Visual Basic for Apps

Database Programming

Microsoft SQL Server

SSIS (SQL Server Integration Services)

Karl B.

@totesisotoneruk

•

12 days ago

5.0

$600.00 USD

Project for Alexandros B. -- 3

Alex was wonderfully respectful, communicated clearly and managed expectations well. I will use Alex again and am looking forward to it.

+1 more

Ben B.

@CybersmithAUS

•

18 days ago

5.0

$1,100.00 USD

Project for Alexandros B.

Alex is a talented professional, patient, collaborative and a joy to work with.

+1 more

Andrew W.

@AndrewWert

•

1 month ago

Experience

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

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.

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.