IT Manager - Analyst Programmer

• Jul 2019 - Present

Migration of accounting database preserving database relational structure, from Fortune1000 Acomba to Commsoft Fidelio, design and execution of several procedures to - Find duplicates, removing or merging data. - Split fields in valid segments (addresses, multiple emails, references, etc.) - Execute validations ( valid emails, address, other fields) - Create relational information from source data using predefined identifiers Analyze current status of company reports, using as source the old set of reports, doing extensive department requests, to generate more functional procedures. - Reduce in a ratio of 10 to 1 the number of reports without lost functionalities - Redesign by the use of joins on SQL request to reduce and improve the request time - Filter information unrequested to reduce the data to process. - Use of pivot tables and VLOOKUP to improve the user experience on reports. Setup a local hosting based on CentOS 7 mariaDB 10.5.5, Apache 2.4, PHP 7.1, composer, SE Linux. - Use virtual hosts under apache to setup multiple sites on server. - Use of Microsoft ODBC driver to access SQL database - Use of fstab to mount shared drives under CIFS - Setup several quick sites under WordPress 5.7 to promote products. Development of web interface linked to Fidelio database (by the use of ODBC module). This Interface includes : - Users and roles administration. - Multi-language access ( currently in English, French, Spanish, German) - Multi-platform visibility (by the use of bootstraps 4, font awesome 5, JQuery 3.x) - Images manager, system is able to load, manage and export images at any size in JPEG, PNG (transparent layer) or GIF formats, backup of delete images, generator of barcode images and QR code image based on product information. - Export to XLSX from a dynamic report builder using information located on 3 different sources (databases). - Integration of information to be use inside Fidelio reports, and in the company website Show less

C# ASP .NET Software Developper

• Apr 2013 - Jul 2019

Head programmer for ODR (On Demand Reporting) ODR is a FMX web interface to manage and print graphical information located in standalone software. The information is gathering by the use of an REST API (POST requests). The web interface was built from the scratch, analyzed and executed follow SDLC (software development life cycle) - Intensive use of nested AJAX request, to recover information from server. - Image cache, use of MD5 function to refresh new info on map. - The map view includes instructions to slide, zoom-in or zoom-out, select objects inside images, get components information, create, delete objects. - use of Git, PostMan, PHPStorm, Jquery 2.2.x, Bootstraps 3 Development of iOS/ Android APP based on Cordova to allow read barcodes Filter AutoCAD information to be imported into proprietary software, multiple procedures to remove unwanted information and reduce at maximum the amount of data. Show less

Full Stack Software Developer PHP Linux MySQL

• Mar 2007 - Mar 2013

Implementation of Linux LTSP (Linux Terminal Server Project) to centralize all resources on the server and reduce the cost of the user workstations. - All software is located on the server; users access the system using diskless computers. - Software is installed and managed only on server; all resources are managed by the server (printers or CUPS, shared data, user administration, etc.) - This model was quickly replaced due the issues on speed , passing from a thin client ( diskless) to a fat client, where the terminal computer use its own processor - Setup Ubuntu Linux 14.4 LTS, integration to access Windows server (accounting software) by the use of VNC client server. Development of content manager for main website by the use of PHP 4.4.6 (upgraded then after to 5.6), MySql 5.1, Javascript ES3 and HTML 4. This content manager was able to - Create tree structures of max 4 levels. - Administration of users and roles. - Manage multiple languages ( default EN, FR , ES, DE) - Manage multiple product description using the Multilanguage module - Manage product status (active, inactive, clearance, dead item etc.) - Manage products documents (rules, test, hints, directions, etc.) - Manage multiple product images, and determine a main image based in filename - Generate a store locator map, based on address of the retailer sales. - Generate list of products for reporting - Export reports in excel .XLS - Export Tear sheet documents in PDF - Use of POST AJAX request to move data between servers ( Backup and synchronization of sites ) Report manager using PHP, ODBC and set of instructions limited by Acomba interface. Setup a local PHP server in a WAMP environment, - Overcoming Acomba's ODBC-imposed data filtering and processing limitations - Conceiving of a new, fully SQL-based architecture that circumvents Acomba-imposed limitations - Use of dynamic HTML to generate, filter and export reports requested from Acomba Show less

PHP joomla support

• Jan 2011 - Jan 2012

Social Media Manager

• 2004 - 2006

Promote the organization into forums and social networks as MySpace, hi5, etc. Offer technical support on emails, information and web schedules. Promote the organization into forums and social networks as MySpace, hi5, etc. Offer technical support on emails, information and web schedules.

Java Programmer

• Jan 2001 - Jul 2004

perl programmer

• Jun 2000 - Dec 2000