EXPLORAR

5,0

(205 comentarios)

Alexandros B.

@abatsis

5,0

205

7,9

99%

SQL Dev | DB Modeling | Access | Excel | VBA

$65 USD / hora

・

Greece (8:46 p. m.)

・

Se unió el abril 29, 2022

・

12 Recomendaciones

$65 USD / hora

・

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.

Verificaciones

A tiempo

99 %

Dentro del presupuesto

99 %

Aceptar tarifa

98 %

Tasa de recontratación

21 %

Ver todo Excel Experts en Greece

Portafolio

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

5.0 · 205 Comentarios

Opiniones

Optimize-SQL-Server-Stored-Procedures Project- PROCESS_IFRS_FULL • $62 USD

He should High levels of knowledge and expertise and when he didnt know something, he said it and didnt waste my time or try to play tricks.

+1 más

Olufemi A.

@fay2000

•

BIRMINGHAM, United Kingdom

•

hace 8 días

Sales Proposal Ammendments • €1.500 EUR

We keep coming back to Alex because he delivers exactly what we want and does so in a timely manner. Alex asks the right questions to fully understand the project and deliver what we need, when we need it. His expertise helps to truly examine how we want to proceed with a project and helps us to streamline our approach. Alex, is a trusted partner to our business and we look forward to working with him again.

+1 más

Dennis J.

@dennisj6

•

Farmington, United States

•

hace 10 días

VBA Word and design project - 9 • €300 EUR

Thank you for this year’s collaboration Alex and I look forward to continuing it next year!

+1 más

Koen R.

@KoenGB

•

De Meern, Netherlands

•

hace 2 meses

VBA Word and design project - 8 • €100 EUR

Alex did a wonderful job again.

+1 más

Koen R.

@KoenGB

•

De Meern, Netherlands

•

hace 3 meses

Data Analyst – Warehouse vs ERP Data Reconciliation • $750 USD

Great work and very professional. I would recommend Alexandros for helping do reconciliation work.

+3 más

Gregory S.

@GregoryCru

•

Dubai, United Arab Emirates

•

hace 4 meses

Senior Systems Analyst, Project Manager

ene, 2003 - Presente

•

23 años

Flexopack S.A.

ene, 2003 - Presente

•

23 años

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

ene, 2003 - Presente

•

23 años

National Technical University of Athens

1990 - 1993

•

3 años

PhD in Industrial Engineering

Greece

1990 - 1993

•

3 años

National Technical University of Athens

1983 - 1989

•

6 años

Bachelors Degree Mechanical Engineering, specialize in Industrial Engineering

Greece

1983 - 1989

•

6 años

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

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.

Preferred Freelancer Program SLA

US English