Author Image

Hi, I am David Palazón Bermúdez

David Palazón

Software Engineer & Senior Consultant at SAP business ONE - S4 / HANA at Etnia Barcelona

A remarkable virtue or defect is that I am in the world of computing by vocation, since I was 8 years old I have been passionate about technologies and development in general. I consider myself a dynamic and enterprising person. I am a great self-taught person always willing to learn from others and to share my knowledge with anyone who may be interested. On a professional level I am in the world of SAP consulting both at a functional and technical level. In addition to accumulating extensive experience in the systems area that allows me to share the same language with my system colleagues.

Project manager
Team Work
Communication
Persevering
Autonomous
Analytical

Skills

RPS (Grupo Ibermatica)
RPS (Grupo Ibermatica)

And what do I do in this consulting business! After 8 years in the automotive industry I decide to move to the consulting sector. Implementing an ERP designed for the RPS Industry of the Ibermatica group. I certify myself in their offices in the Technology Park of Bizkaiai. I apply my experience in the world of the production to the consultancy. In the consulting firm Telinformática

SAP B1 SDK
SAP B1 SDK

I started developing Addon’s with the 2004 version and I haven’t stopped until now. I fell in love with SAP products from day one. I am certified in version 9.2

Exact Globe
Exact Globe

For a few years I was combining my work as an SAP B1 consultant with two other products from the company Exact, products of which I am one of the first three people to be certified in Spain. Exact Globe and Exact Synergy

C#
C#

It is the language I use daily, for more than 8 years. I feel comfortable with it. I use it to develop Sap B1 Addon’s, desktop applications, web backends (together with the ServiceStack framework)

VB.NET
VB.NET

En la empresa aún conservamos código heredado (legacy code) realizado en Visual Basic.NET. Así que de vez en cuando me toca realizar algún que otro mantenimiento de los desarrollos realizados en este lenguaje

Docker
Docker

In 2018 our ERP department had to take over the workload of the Digital department. In our machines we had to be able to run an Apache, a mysql and php. After several weeks and a docker course we set up a custom image with Mailhog included, Laravel. Since then I don’t stop using it daily.

Linux
Linux

What can I say about this operating system. My first installation was a Slackware 1.0. Later I moved to RedHat 2.0 until I finally opted for Gentoo on a personal level, if that gives me a special character. I am currently an OSX user, but I can set up a linux server with the usual services with my eyes closed.

Git
Git

I’ve gone through several version controls Soursafe,CVS, Subversion until I get to Git. I’ve been using it daily for over 6 years and I really feel comfortable with it. I also use the Git-Flow workflow with my team.

Crystal Reports
Crystal Reports

I think the first time I used Crystal Reports was with Visual Basic 6.0. And it was not very pleasant. But the truth is that right now I would not use another product for reporting. But of course, more than 15 years with him and that I use it daily for SAP B1 One reporting. I have taken a liking to it!

Elasticsearch
Elasticsearch

A couple of years ago we found ourselves in the need to consolidate the logs of all our microservices. And after a lot of looking and researching. And also from a course that looked for me personally, we ended up implanting elasticsearch. We didn’t implant the whole stack but almost. Logstash , we don’t use it because we use Log4net with an appender for elastic.

Couchbase e InfluxDB
Couchbase e InfluxDB

Well, I liked the world of NOSQL databases. And at a certain point a project with Xamarin came up. It needed an indeterminate number of terminals to synchronize with a central server. This is where couchbase+Couchbase Lite+Sync Gateway came in. InfluxDB used it for a server log topic, it is a time series database

Grafana
Grafana

The truth is that I discovered it by chance. And at that moment I left Kibana more than a year ago. Currently I have mounted several Dashboards, but the one I usually use is the one that helps me sleep peacefully. It monitors the synchronizations between our SQL servers in the DMZ and those in MYSQL. Holy SymmmetricDS!

SymmmetricDS
SymmmetricDS

SymmetricDS, what can I say about him. I would need a whole post to talk about him. The truth is that it synchronizes millions of records per week between SQL Server and MYSQL systems without blinking an eye. And the most important thing I think I have only had one incident in 2 years. I use the Open Source version and I set it up without any graphical environment.

T-SQL y MS SQL SERVER
T-SQL y MS SQL SERVER

Well, of course almost all these ERPS work with a database engine. Yes, and in this case it is MS SQL Server. And I feel comfortable designing databases, administering them and why not tuning them.

Don't leave yet , ...
Don't leave yet , ...

There’s more. The truth is that in 27 years I have a lot of things left in the inkwell. Shell script programming, ada, xbase ,oracle, postgress, mysql, arduino, 3d print, …If you want to know more don’t hesitate to contact me

Experiences

1
Etnia Barcelona

March 2016 - Present, Esplugas de Llobregat, Barcelona (Spain)

My incorporation in Etnia Barcelona takes place as a functional and technical Senior Consultant in SAP Business One. Becoming part of a multidisciplinary team of 5 people who like me come from consulting with years of experience in major SAP partners in the industry. Later we made the signing of a functional profile 100% allowing me to assume the functions of Senior Technical Consultant managing the technical team. Currently due to our growth we are forced to migrate the system to SAP S4/Hana. Assuming in this process SAP S4/Hana Consultant tasks in SD/MM/PP.

Junior Consultant SD/MM/PP

March 2019 - Present

  • Establish the requirements and participate in their definition together with the Key Users of the company’s operations (logistics and production).
  • For the definition of the operational processes during 2019 I made several trips to our subsidiaries in Hong Kong and China.
  • Approval with the key users of the functional designs.
  • Carrying out the Unit tests with the Key Users of the SD/MM/PP areas.
  • Support and preparation of the migration from Business One to S4.
  • Establish procedures and reprogramming of current processes with Ecommerce, EDI and POS platforms to S4/Hana.
Senior Functional and Technical Consultant in Sap B1

March 2016 - Present

  • Internal analysis of requirements of the different departments of the company.
  • Design of printing and reporting forms with Crytal Reports.
  • Assessment of the developments and evaluation of economic or functional proposals of our IT service providers related to our ERPs.
  • Decision making on whether they are made internally or by the partner.
  • Design and Development of Addons for our ERPs.
  • Integration of our systems with those of large groups through EDI. Complying with different standards. In France with EDI-Optique, Edi-Fact in Spain, Look4 and Fosa in Germany and Bluedata in Italy.
  • Creation and maintenance of the backend of our corporate tools through technologies such as Api’s Rest. Some of these corporate tools are the Intranet, Extranet, PLM, HHRM, Control of presence and sales force (IPADS)
  • Maintenance and improvement of our intercompany processes with the subsidiaries in Miami, Canada and Hong Kong with applications in different locations
  • Integration with Openbravo , software used as POS (Point Of Sales) in our stores.
ETL Technician.

March 2016 - Present

  • Definition and implementation of the extraction, translation and loading processes so that our BI software (PowerBi and Tableau) can then exploit that information.
  • Installation, maintenance and configuration of the SymmetricDS synchronization software that allows the SQL server and Mysql databases in the extranet to be synchronized.
BI Consultant.

March 2016 - Present

  • Taking requirements from users normally from the controlling or sales department.
  • Definition and implementation of new data structures and dashboards with the 2 corporate tools Tableau and Power BI.
Medcomgroup – Medcomtech – Medcomflow – MedcomAdvance

June 2013 - March 2016, Viladecans

In June 2013, he became part of a company that is listed on the stock exchange and markets technologically advanced products in orthopedic and trauma surgery. I join Medcomtech after being a consultant for 2 years through its SAP Business One AdvanceGroup partner. As an anecdote point in the commercial network we had former stars of the handball world.

It Manager.

June 2013 - March 2016

  • Manage IT purchases, negotiation and coordination of suppliers.
  • PMO of both SAP business ONE projects, in the Digital area (Web and SEO) and in the area of sales force coordinating the development and deployment of software for IPADS.
  • Design of the reporting tools with Microsoft Reporting Services and Analysis Services.
  • Implementation and start up of SAP business ONE in our subsidiaries in the Dominican Republic, Portugal and Italy.
  • Implementation of electronic invoicing and declaration to the public finances of Spain (public institutions of the state, Health), Portugal and Italy.
  • Implementation and implementation of banking Edi (EDITRANS)
  • Start-up of the new logistics installations.
Senior Functional and Technical Consultant in Sap B1

June 2013 - March 2016

  • Internal analysis of requirements of the different departments of the company.
  • Design of printing and reporting forms with Crytal Reports.
  • Assessment of the developments and evaluation of economic or functional proposals of our IT service providers related to our ERPs.
  • Decision making on whether they are made internally or by the partner.
  • Design and Development of Addons for our ERPs.
  • Creation and Maintenance of the Backend of our corporate tools through technologies such as Api’s Rest. Some of these corporate tools are the Intranet, Extranet, PLM, HHRM, Control of presence and sales force (IPADS)
  • Maintenance and improvement of our intercompany processes with the subsidiaries in the Dominican Republic with applications in different locations.
  • Implementation in the other companies of the Medcomgroup Group. Medcomflow is a company specialized in the field of surgical ventilation and is specialized in the design, development and manufacture of innovative products for anesthesia. And MedcomAdvance company of investigation and development of patents in Nanotechnology. Currently participated by Grifols, Medcomtech, Scranton Enterprises BV, Rovira i Virgili University and Eurecat.
2
3
Advance Group

2011 - 2013, Barcelona Ciudad

The company where he worked until June 2013 ceases the consulting activity with SAP business ONE and transfers all customers (including its developments) to Software i Suport Informàtic. In this transfer I am also transferred (subrogation) as a person knowledgeable about both the technical and functional of all projects Infolan. A few months later I am not attracted by the project due to personal concerns, so when I report my intention to leave I propose to train and certify in Exact Globe and Exact Synergy in addition to going to functional consulting for these products. In this period I also certified in version 9.2 of Sap Business One

Senior Functional Business One Consultant.

2011 - 2013

  • Pre-startup requirements taking from customers.
  • Generation of functional documentation for the development team prior to the start
  • Unit tests with the client.
  • Pre-starting training to the client.
  • Data migration from legacy systems to SAP. Masters, Open Items, …
  • Support to the start up and later maintenance.
Consultor Senior Técnico Business One.

2011 - 2013

  • Maintenance of the addons developed for clients, creation of new addons
  • Second level support to customers and in moments of high workload of first level.
  • Development of printing and reporting forms.
  • During this period I have the opportunity to finalize the framework I had previously started in my personal time for unattended deployment of customer changes. Using techniques such as Shadow Copy, Deployment of binaries through repository, dependency injection and forms subclassing.
Infolan

2006 - Junio 2011, Barcelona City

After my previous company ceased activity I joined Infolan in a team of 8 people with a lot of experience in large systems (AS400 and SAP R3). This team was the first to install an SAP Business One in Spain. At that time the clients were in versions 6.5 and 2004. In infolan I was able to be part of a team that was more like a current Agile team than an old-fashioned consulting team. And they were the ones who showed me what a team can do. Here I start my professional career with SAP B1, a product that I fell in love with and that I am still in love with.

Senior Functional Business One Consultant.

2006 - Junio 2011

  • Pre-startup requirements taking from customers.
  • Generation of functional documentation for the development team prior to the start
  • Unit tests with the client.
  • Pre-starting training to the client.
  • Data migration from legacy systems to SAP. Masters, Open Items, …
  • Support to the start up and later maintenance.
  • With our client Tascon, we entered the retail and POS world.
  • With another of our clients BACLI’s entered the world of auctions, layout and catalogues. And the world of used goods.
  • Implementation and support of production verticals.
  • In this period I was also able to prepare the documentation and certify a logistics and customs management vertical in SAP.
Senior Technical Consultant Business One.

2006 - June 2016

  • Maintenance of the addons developed for clients, creation of new addons
  • Second level support to customers and in moments of high workload of first level.
  • Development of printing and reporting forms.
  • Integrations with POS terminals. In this case with our client Tascon.
  • Integrations with Adobe layout software. Automatic generation and maintenance of the printed catalogs of the auction house Balcli’s.
  • Integrations of Sap Business One with its big brother SAP R3.
  • Installation and update of SAP Business One in the clients. Installation and programming of SQL maintenance and backup software.
Technical automation of catalogs.

2006 - June 2016

  • Thanks to the experience acquired, I started to make small participations with the design department, automating its clients' catalogues.
  • I specialize in automation through JavaScript and AppleScript scripting for Adobe Indesign, through XML/JSON and through external modules such as EasyCatalog.
4
5
Telinformatica (Telefonia e Informatica integrada S,L)

2006 - 2006, Ripollet

After a long period as a final client, I decided to take the leap to consulting out of a desire not to stagnate. Jumping to a product of the Ibermática group adapted for the industrial and production company. Bringing my 8 years of experience in the automotive sector. In this period I certify myself in the Product. By closing the ERP department I am offered the opportunity to continue as a system technician due to my knowledge

Senior Consultant Production and Logistics in RPS.

2004 - 2006

  • Taking requirements before the start of the clients, as I commented in companies of the industrial sector of automotion like Kessel Automotive or Maquinaria Agricola Solà.
  • Generation of functional documentation for the development team before the start
  • Unit tests with the client.
  • Pre-starting training to the client.
  • Data migration from legacy systems to SAP. Masters, Open Items, …
  • Support to the start up and later maintenance.
  • Development of data acquisition application in plant in productive environments.
  • Warehouse automation for clients such as Industrias Iris with equipment such as ULMA’s https://www.ulmahandling.com/es/intralogistica-automatizada/sistema-mini-load .
Senior Technical Consultant in RPS.

2006 - June 2016

  • Programming of customizations for the ERP R.P.S with VBA and Visual Basic 6.0 (OCX generation)
  • Custom application development in Visual Basic 6 and Delphi.
  • Second level support to clients and in moments of high workload of first level.
  • Development of printing and reporting forms (Crystal Reports).
  • Development of interfaces with box and carousel stacker cranes for automated warehouse management.
  • Installation of the company’s ERP products (RPS, Axapta and Sage).
  • Administration and maintenance of MSSQL 2000 and MSSQL 2005. Programming in T-SQL
Prensas y Montajes Industriales S.A (Preindsa)

1999 - 2006, Ripollet

Well, I’m very fond of Preindsa. I was given the opportunity, as a young computer engineering student in his first year, to be part of a company in the automotive sector. With clients such as Robert Bosch, Brose, Ficosa, Yamaha, … Here I could learn about Production, Quality, Logistics, Warehouse, Master agreement, …

Becario.

1997 - 2006

  • Management of the company’s infrastructure, at that time a Novell network with coaxial cable.
  • Distribution and installation of consumables and pcs
  • At times when there was no workload I participated in the logistics department. Preparing the shipments and analyzing the results of the MRP.
  • If necessary, he also participated in the management of the production data. Generation, launch and distribution of work orders. Introduction of the production parts. And maintenance of the polyvalence tables of the employees.
IT Manager.

1999 - 2006

  • Digital transformation of the company, consisting on the one hand in the updating of the network infrastructure.
  • Migration and later administration of the network, passing from MS Lanman (Lan Manager) to a Novell 4.1 network and an Exchange mail server.
  • Later, Linux machines with Samba are also incorporated to the network.
  • Maintenance and customization of the corporate ERP made in XBASE (FOXBASE),
  • Development of production software for plant capture and connection of the machines via RS485 bus.
  • Later I was in charge of the implementation of the ERP R.P.S.
6
7
Linux Systems Technician.
COMPLEIX EDUCATIU DE TARRAGONA.

1996 - 1996, Tarragona

Right after finishing my Professional Module 3 of Maintenance and Equipment of computer science equipment the opportunity arises to me to make a project with my hobby (Linux) and the telephone of the complex for the department of Maintenance

Responsibilities:
  • Installation and configuration of RedHat Linux server as an 8-line RAS server and implementation of the TCP/IP stack.
  • Installation and administration of the Web server (Apache) , e-mail (qmail) for internal messaging.
  • Application development for sending and managing incidents for the maintenance department HTML/PHP for the server part and Borland Delphi for the client part
Office software teacher and network administrator.
GREMIO DE LA CONSTRUCCION DE TARRAGONA. (Fegco)

1995 - 1995, Tarragona

For one season, I am in charge of managing the network and the computer system of the guild. And also during the summer I teach office automation.

Responsibilities:
  • Office automation teacher (Word, Excel, PowerPoint, Windows) for the Forcem.
  • Novell Netware 3.11 network installation and administration
  • Office and desktop administration.
8
9
MASTER INFORMATICA I MUNTATGES S.L.

1992 - 1994, Tarragona

I have only one word for this company, a big family. The owner of the company was the sweetest, most professional, and above all, the best person I have ever met. He treated me like a son. And his technicians, great professionals, who explained to me all his secrets. It is a pity that Mr. Ortega’s death caused the company to close down.

IT Technician.

1993 - 1994

  • Assembly and installation of Clone computer equipment.
  • Installation and configuration of networks in a Novell Netware environment.
Photocopy and Printing Technician.

1992 - 1992

  • Repair and maintenance of large format printers for rent or sale of second hand.

Recent Posts

Card image cap
Conectando Business One y la centralita virtual 3cx (Parte 1/3)

Conectando Business One y 3cx Hola que tal, espero que no juzgueis demasiado mi primer artículo en mi blog. Hace bastante tiempo por hobby y en mis horas libres inicie un proyecto , en el que uniria dos de mis grandes pasiones el mundo de Sap Business One y mi vertiente más de sistemas, en este caso con la centralita virtual 3cx. Estos son dos productos que utilizamos en la empresa donde trabajo.

January 26, 2021 Read
Card image cap
Conectando Business One y la centralita virtual 3cx (Parte 2/3)

Conectando Business One y 3cx En la primera parte vimos como crear el esqueleto para nuestro plugin de 3cx. En este artículo crearemos el plugin que nos permitira comunicar SAP B1 con el cliente de 3cx. La primera vez que vi la documentación me parecio un poco confusa. Pero basicamente todo plugin de 3cx consiste en una clase que será la encargada de conectarse con el cliente y gestionar los diferentes eventos.

October 26, 2020 Read
Card image cap
Shortcodes Samples

This is a sample post intended to test the followings: Default hero image. Different shortcodes. Alert The following alerts are available in this theme. This is sample alert with type="success". This is sample alert with type="danger". This is sample alert with type="warning". This is sample alert with type="info". This is sample alert with type="dark". This is sample alert with type="primary". This is sample alert with type="secondary".

June 8, 2020 Read