Senior Software Engineer
2009 - PRESENTFreelance- Designed and implemented (for nVent HOFFMAN) a SQL Server and AWS-DMS integration controller and supervisor for a BI DW. It automates all tasks, using AWS-DMS with full automation of BCP and synchro processes and a complete Ext JS front end.
- Designed and implemented (for nVent HOFFMAN) a system for the supervision and control of SQL Server ETL processes with time-step evolution analysis, error control, and reporting.
- Implemented most of the remote control system for public lighting and ornamental fountains for the Madrid City Council—a very complex solution that controls 300,000+ lighting points, pumps, and other devices.
- Created a BI portal for the analysis and verification of the compliance indicators for the Madrid remote control lightning and ornamental fountains service.
- Designed and built Iberdrola's system for the sale of shares to employees and a platform to manage flexible compensation for top managers. This global energy leader is no. 303 in the Fortune Global 500, with €36.4 billion in annual revenue (2019).
- Migrated and optimized database servers in the non-stop production environment for ALK-Abello (a pharma company), converting from the old SQL Server version to the new version, with 100% empirical testing of all data and the T-SQL business layer.
- Migrated, optimized, and consolidated database servers in the non-stop production environment for Telepizza, converting the old version that had 12 synchronized SQL Servers to two new SQL Servers, with 100% empirical testing.
- Built several Sencha Ext JS applications for Everis SA and CLH SA, with SAP through REST services in the integrated development system of CLH.
- Developed extensions and modifications for Maxxium España's BI system and data warehouse to support internal business transformation projects.
Technologies: ETL Development, JSON, ETL, SSH, Data Engineering, T-SQL, SQL, Microsoft SQL Server, IntelliJ IDEA, Business Intelligence (BI), Data Warehousing, Data Warehouse Design, Full-stack, Software Development, Software Analysis, JavaScript, AWS API Gateway, Node.js, Ext JS, Java, ETL Implementation & DesignCTO and Software Developer
1999 - 2009Jaune Sistemas SL- Founded this software development company from where I oversaw and developed 100+ software projects with 10 other developers for multinational companies and some small and medium-sized enterprises.
- Built and led development teams for 10 years while also working as a developer and serving customers directly, both from a commercial and technical point of view.
- Implemented a CRM product that was a complete success for 10+ clients. The only problem was its excessive success in relation to the constraints on my capacity to expand the business to ensure its continuity.
- Served as the CIO of Georg Fischer Spain for 5+ years in an outsourced arrangement. Developed internal and B2B management systems, including CRM, links with EDI, Scala, ERP, control and monitoring of ISO 9000 standards, and workflow processes.
- Adopted the code from Geofactory's GIS mapping system (La Netro), whose developers had left the company. Performed reverse engineering to help Geofactory restart its map production line. This system was eventually sold to Nokia.
- Created the portal for Cotos de Pesca (fishing preserves), which became the leader in the fishing sector in Spain and was finally sold to Editorial América Ibérica.
- Implemented the database system and the front-end operating system of the real-time license plate reading surveillance system to control La Moraleja, the most exclusive large urbanization in Madrid.
- Designed and implemented 20+ significant software projects related to engineering for various public administration bodies in Spain. I did this in collaboration with SICE, a systems integration technology company.
- Implemented dynamic data presentation and animation functionalities for a web UX with JavaScript.
Technologies: ETL Development, ETL, JSON, SSH, Data Engineering, T-SQL, SQL, Microsoft SQL Server, Full-stack, Software Development, Software Analysis, JavaScript, Ext JS, Java, .NET, JavaScript 6, ETL Implementation & DesignProject Manager and Software Developer
1994 - 1998Intecsa Internacional (ACS Group)- Conceptualized, redrafted, and presented 6+ successful urban services control system contracts for Barcelona City Council.
- Led the development of a dam exploitation management system for the Spanish Ministry.
- Converted the diisopropyl ether (DIPE) system from VAX/VMS and DMRS to Unix/DOS and Oracle for Telefonica de España.
- Led conceptualization, drafting, writing, and budgeting for 15+ IT bids to public state tenders.
- Developed a street cleaning control system that integrates remote terminals and other resources to control subcontractors and cleaning processes.
- Built a control system for the collection of solid urban waste, covering collection services and the assignment of weights taken on the scale.
Technologies: Data Engineering, T-SQL, SQL, Microsoft SQL Server, Full-stack, Software Development, Software Analysis, Visual Basic 6 (VB6), MicroStation MDL, C++, CSoftware Analyst and Developer
1993 - 1994Intecsa Internacional (ACS Group)- Developed a software system for road layout for the Spanish Ministry of Transport.
- Built a multimedia system for organizing and presenting civil works. It was used by Dragados for several years to present its biggest offers. I built this in MicroStation MDL (C and C++) as my final graduate-level university project.
- Created a verification system for linear works regulations for the Spanish Ministry of Transport.
- Built a system to monitor and manage public construction works.
Technologies: Data Engineering, Software Development, Software Analysis, Microsoft SQL Server, Visual Basic 6 (VB6), C++, C, MicroStation MDLAnalyst and Software Developer
1992 - 1993Software Ibérica 92- Designed and implemented the restructuring of the management system and the conversion to a multicompany and local area network for Industrias Protecno SA.
- Defined and executed the complete management system and application for CECOM SA.
- Designed and implemented the warehouse control, billing, and accounting software and the software application for a POS terminal for Franquicias de la Moda SA.
- Defined and delivered a multi-warehouse, multi-type manufacturing control system for Interisa Electronica SA.
- Designed and implemented a complete management software system and POS terminal.
Technologies: Software Development, Software Analysis, dBASE, ClipperSoftware Developer
1992 - 1993Software Ibérica 92- Developed a multi-warehouse management system with various breakdown levels and multi-select self-reporting in a geo-split environment with automatic margin adjustments, priority selection, and group creation.
- Built a reporting system to track sales against a budget plan, along with subsequent analysis charts.
- Developed a budget-based economic reporting system, including break levels down to vendors and multi-select reporting.
Technologies: Software Development, Software Analysis, dBASE, Clipper