Andrea G.

Senior Software Developer and Consultant, Freelance - ICT Contractor

Bologna, Italy

Experience

Jan 2023 - Dec 2025
3 years
Ascoli Piceno, Italy

Senior Software Developer and Consultant, Freelance - ICT Contractor

  • Internet Business

  • Joining professional training and assistance, going deep into Self Publishing and E-commerce projects on my own, using various AI tools like ChatGPT, PlottyBot, Gemini and others.

  • In October 2025 I will publish first books on Amazon USA, Germany and/or Spain.

  • First E-commerce shops will be active next year.

  • At the beginning of year 2026, this acivitities will become fully operational.

  • Those projects keep me busy only in the evenings and/or weekends.

  • Medium/Long-term size Python, C++ and Azure & Power BI project – ICT Services & Solutions Firm.

  • Technologies:

  • Python, C++, PySpark, Spark, Databricks, Azure Data Factory, Azure Synapse, Azure Data Lake. Building Pipelines for Data Ingestion and transformation using Azure Synapse and Azure Data Factory. MongoDB, Apache Parquet. Power BI, SQL.

  • AI: OpenAI, ChatGPT, Prompt Engineering

  • Medium size C#.NET, ASP.NET Project - Handling treins traffic in European railways.

  • Technologies:

  • C#, ASP.NET Core related web project, based on Razor pages.

  • Front-End: Javascript, Jquery, Knockout.js. HTML, CSS.

  • Various Small Pilot Projects and/or Requests about Delphi Migrations

  • Migration to Delphi 11 Alexandria

  • Analyzing news, pros and cons

  • Migration to Delphi 12

  • Analyzing news, pros and cons

  • Migration from Delphi 7 or 2007 to Delphi XE, Delphi 11, Delphi 12

  • Database drivres and engines: BDE vs ADO

  • DevExpress

  • Libraries

  • Units Organiation and Dependencies

  • Separations of concerns:

  • UI Form

  • Business Logic Unit

  • Datamodule

  • Third Party Components

  • Don’t exist anymore or having source code not compiled

  • Unicode Support.

  • Various Advanced Trainings:

  • Advanced Training in AI, Machine Learning, Deep Learning.

  • AI: OpenAI Python Library, LLMs, NLU, NLP, Conversational AI

  • AI: ChatGPT models, Prompt Engineering.

  • AI: Generative AI - Images Generation, Sound Generation, Text Translation.

  • Midjourney, Leonardo, BlueWillow Dreamstudio Stocking, Stable Diffusion, Whisper

  • Python & AWS, APIs Lambda Fucntion in Python in AWS.

  • Amazon Book Seller Advanced Training

  • Amazon Ads

  • AI: ChatGPT as assistant in writing books, Facebook Ads

  • Dynamic E-Commerce Training

  • AI: Drop AI, TikTok, Facebook Ads

Jan 2020 - Dec 2022
3 years
Groningen, Netherlands

Senior Software Developer and Consultant, Freelance - ICT Contractor

Involed in small/medium size assignments:

  • Small/Medium Size Python & C++ Project, for retail big store.

  • Technologies:

  • Python & C++, FastAPIs, RESTful APIs, Swagger. Oracle, SQL, PL/SQL, Docker. GitHub.

  • Small/Medium Size Python Project, updating back-office clients digital marketing logic in banking assigment.

  • Technologies:

  • C++, Python, Flask, FastAPIs, PySpark, Pytest.

  • AI: NLP, SpaCy, Keras.

  • Data Cleaning & Normalization. ETL Processes, building pipelinen in Azure Synapse, Databricks. PyCharm, Jupiter Notebook, Docker.

  • Medium Size Power BI Project, developing decision-making-tool dashboards for investment bank.

  • Technologies:

  • Training on the job required. Power BI Desktop, Power BI Services, Power Query.

  • Medium Size COBOL Project, developing financial modules in back-office for investment bank.

  • Technologies:

  • COBOL, Micro Focus, Visual COBOL. Working with XML and JSON data

  • Securities, Current/Savings Accounts, Internet Savings, Interest Calculations.

Also, starting as Digital Entrepreneur. I started building one web sit. A community-like idea, a global set of services, to upload/download and share specific multimedia material, developed in PHP & MySQL. I planned a very scalar architecture, hoping to overpass the million users mark in 5 years from now. Ambitious, but realistically possible in my opinion.This project involves a messaging system, AI tools, Text Analysis, NLP and other skills, to go deep into Digital Marketing.

At the end of 2022 I relocated to Bologna, Italy, and I am focused as a contractor.

Jan 2013 - Dec 2020
8 years
Bologna, Italy

Software Developer / Consultant, BI Senior Developer & Data Engineer, multiple small/medium collaboration-contracts and

I followed many small projects ( 2 weeks – 3 months duration ), I report here the summary of the interesting skills/technologies I experienced and matured:

  • ERP business procedures in finance, sales, production
  • Dynamics AX, D365, Visual Studio, SAP PP module and BODS ( Business Objects Data Services ) , Data Modelling of Relational Databases and DWH
  • Progress OpenEdge
  • Front End Developer in web sites
  • JavaScript, Typescript, HTML, CSS, XML and XSLT transformations,
  • Back End Development
  • Delphi, Java JEE, Spring, Hibernate
  • Python BackEnd / Web projects
  • Financial Applications
  • Delphi
  • COBOL, Micro Focus COBOL, Visual COBOL, AS/400 mainframe
  • Business Analyst Activities
  • Machine learning, Text Mining, AI, DevOps
  • C, C++, QT, Python, R
  • Anaconda Suite ( Python Jupiter Notebook, R Studio, Spyder ), PyCharm
  • AI: Machine Learning, Financial Analysis, Predictive Models, Trends Analysis
  • AI: Text Analysis, NLP, Deep Learning
  • Data Cleaning & Normalization
  • Python APIs in AWS as Lambda Functions
  • RESTful APIs, FastAPIs
  • Terraform, Jenkins
  • Big Data, noSQL Databases
  • MongoDB
  • BI, eReporting, Data Engineering
  • Power BI, Power Query, DAX, Power BI Services, Power Apps
  • Microsoft BI: Stack ( SSIS, SSAS, SSRS )
  • Tableau, Tableau Prep. SQL-Server, SQL, T-SQL, ETL Processes
  • SAP, SAP BODS
  • Oracle, SQL, PL/SQL
  • AWS Main Basic Services, Azure SQL, Azure Data Factory, Azure Synapse, Azure Storage, Databricks
  • Progress OpenEdge ABL - Procedures building & calling through BI tools
  • Snowflake, Matillion
  • TDD, GitHub
Jan 2011 - Dec 2013
3 years
Bologna, Italy

Software Developer / eReporter in multiple small/medium collaboration-contracts and project-based assignments - ICT

I followed many small projects ( 2 weeks – 3 months duration ), I report here the summary of the interesting skills/technologies I experienced and matured:

  • ERP business procedures in finance, sales, production
  • Dynamics AX, X++ and C#.NET
  • Web Development
  • JavaScript, HTML, CSS, Java
  • Back End Development
  • Delphi, C++, Java
  • BI, eReporting, Data Engineering
  • Progress OpenEdge ABL - Procedures building & calling through BI tools
  • Jasper report system reports calling, through Java
  • Advanced Excel, DAX, Charts, Dashboards
  • Financial Applications
  • Delphi,C++, Java, COBOL, Visual COBOL
  • Business Analyst Activities
  • Software Development Techniques
  • TDD, GitHub
Jan 2007 - Dec 2010
4 years
Amsterdam, Netherlands

Business Intelligence Senior Developer and Consultant, Business Analyst - ICT contractor

During this period I had a long-term business relationship with an important Dutch consultancy firm, Ordina BPO, that stayed for more than 2 years, involving projects for investment banks. I also had other smaller contracts and IT ad-hoc lessons.

Relevant projects are the folllowing:

  • Portfolio Management, Dashboards and daily financial reports at Insinger De Beaufort Bank

  • Technologies:

  • Actuate/OpenText Magellan BI, Visual Basic, SQL, ETL, integration between Actuate and Triple’A Asset Management System.

  • Actuate reports integration with eBanking Front Ends.

  • Progress 4GL Open Edge - Procedures building & calling through Actuate Magellan

  • Oracle, TOAD, SQL, DB2, Sybase

  • LDAP Users SSO integration, JavaScript, CSS, HTML

  • Actuate / Magellan servers administration, tuning, monitoring at Insiger De Beaufort Bank

  • Technologies:

  • Actuate/Open Text Magellan

  • Quaestor to Thaler financial back-office database migration at NWB Bank

  • Technologies:

  • Actuate/Open Text Magellan, Oracle TOAD, SQL, Oracle, COBOL

  • Small BI projects, IT coaching

  • Technologies:

  • Advanced Windows, Unix, Qlik View, Advanced Excel, Microsoft Word.

Jan 2000 - Dec 2007
8 years
Hoofddorp, Netherlands

Senior Software Developer and BI Developer / Consultant. Data Analyst, Business Analyst

Allshare Media Banking

Senior Software Developer and BI Developer / Consultant. Data Analyst, Business Analyst in investment banks projects. Allshare Media Banking is a software house in the field of banking and finance.

Relevant projects and related used technologies are the following:

  • CAM ( Corporate Action Management ) complete analysis, for Securities Trading Management
  • Complete analysis data modelling, work flow diagrams, GUIs design, and each financial process in pseudo programming language, therefore it can be theoretically developed in any programming language.
  • Banking Data Analyst, BI Developer / eReporter / Data Analyst
  • Technologies:
  • Actuate/OpenText Magellan BI, Visual Basic, HTML, CSS, JavaScript, SQL, ETL processes.
  • Oracle SQL, PL/SQL, Integration of BI reports into eBanking Front End
  • Qlik View, financial reports
  • Front End Developer in eBrokerage web site pilot-project
  • Java, JavaScript, HTML, CSS, XML and XSLT transformations
  • Back End Developer in SOAP project related to BI reports
  • Java, SOAP, XML, Java SOAP Actuate Magellan library
  • Version Management Software
  • CVS
  • Back Tracking Software
  • Jira
  • Customers:
  • DSB Bank, Delta Lloyd Bank, Argenta Bank, NWB Bank,
  • Alternatif Bank Instanbul.
Jan 1998 - Dec 2000
3 years
Bologna, Italy

Analyst / developer specialized in the sector of furniture shops. IT teacher, coaching, mentor.

Freelance ICT Contractor

Relevant projects and related used technologies are the following:

  • Easy Store System (furniture shops software) by Sintesys Informatica
  • Delphi, Object Pascal.
  • Data Modelling, Database Business Logic and Rules
  • eReporting, Report Builder.
  • Basic IT training for groups of professionals, entrepreneurs
  • Basic teaching of Windows, Word, Excel
Jan 1997 - Dec 1998
2 years
Bologna, Italy

System Administrator / Engineer

Teko Telecom S.r.L.

System Administrator / Engineer, specialized in maintaining and implementing applications for Mobile Phone Repeaters, machine able to enhance and maintain the cell phone signal under tunnels in highways, and under circumstances where the cell antenna is not available and can’t be reached by the phone itself.

Also, various pilot projects playing with low level routines, serial port communication, file transfer.

Relevant projects and related used technologies are the following:

  • Sun Unix Server Maintenance, System Administration
  • Technologies:
  • Shell scripting, C
  • Mobile Phones Repeaters Software Application
  • Implementing, customizing, monitoring, tuning, upgrades.
  • RS232 serial port programming pilot-project, low-level routines, PC to PC file transfer through cable
  • Technologies:
  • Shell scripting, C, C++.
Jan 1992 - Dec 1997
6 years
Bologna, Italy

Senior Software Analyst & Developer

Datalogic S.p.A.

Datalogic is worldwide leader in Automatic Identification Technology, manufacturing high-tech barcode readers, optic pens, temperature controllers, industrial scanners, machine learning and artificial vision devices, with factories and trading branches all over the world. I was in charge as Senior Developer and Analyst, developing software for the main ERP (MFG-PRO), as well as for programming high-tech laser devices.

Relevant projects and related used technologies are the following:

  • ATP (available-to-promise).
  • ATP is a business function that provides a response to customer order enquiries, based on resources and availability. It generates available quantities of the requested product, and delivery due dates. Therefore, ATP supports order promising and fulfillment, aiming to manage demand and match it to production plans. One of my best and hardest projects so far.
  • Technologies:
  • Progress OpenEdge
  • Roll Up for the Balance Products Costs procedure.
  • Total reverse down-top implosion of Bill of Material, in order to calculate for each element:
  • Purchase cost, if element is to buy.
  • Labor costs, if element is to produce.
  • Outsourcing costs, if any.
  • Technologies:
  • Progress OpenEdge
  • Technical software engineering. Embedded Systems, Real Time Systems.
  • Routines to control/manage high-tech devices.
  • Technologies:
  • Turbo Pascal, C, C++

Summary

28 years of IT working experience as Senior Software Developer, BI Developer/Consultant, Data Engineer, IT Coach. Handling complex data pipelines, ETL processes, data ingestions, data transformations in Data Projects. Building scalable software architectures and leading technically data-driven projects, following BI & Data Engineering projects end-to-end. Expert in ERP systems, Business Intelligence, AI, Machine Learning, Deep Learning, Statistical Models, Predictive Models, Financial Analysis.I followed numerous projects in sectors like Manufacturing, Sales, Retail, Banking, Embedded, Telecommunications and other.

Languages

Italian
Native
English
Advanced
Dutch
Advanced
German
Elementary

Education

Oct 1984 - Jun 1989

I.T.I.S Bologna (Industrial Technical Institute)

Information Technology Diploma · Information Technology · Bologna, Italy

Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions