Fernando Martinez - Freelance SQL Developer for Hire

Systems Engineer

Independent Consultant

2010 - PRESENT

Developed a programming audit solution using Delphi and Developer Express components to identify SQL sentences in programs and store them in a DB2 database.
Built an experimental app for Android 2.3 which included geolocation and data graphics, using Eclipse, Java, and SQLite. I uploaded this app in Google Play for testing purposes too.
Created an operational app on Android 4.2 which included RESTful web services, signature collection and label printing, using Eclipse, Java, and SQLite.
Supported and enhanced the server component for the previous development, using Visual Studio, WCF, C#, SQL Server, and Integration Services.
Designed the data model and the software functionality for a logistics application that will be implemented on the web and on Android.

Technologies: Java, Android, Eclipse, C#, Visual Studio, SQL Server, SQLite, MySQL, Delphi

Software Development Manager

Primestone S.A.

2008 - 2010

Led the team of engineers, developers, and tester to improve the software development process in the company, working on Delphi, SQL Server and Oracle.
Designed the functional architecture of the upcoming .NET version of the company's application using Visio. Defined the object abstraction and database design considerations for massive information storage and performance.
Designed the data model in Visio for the .NET application which was to be implemented on SQL Server or Oracle.
Developed, using Visual Studio (C#) and SQL Server, a data access system (ADO and reflection), domain (entities and business logic), and services for the configuration component of the .NET application.
Developed a visualization tree for energy metering in Delphi.

Technologies: Delphi, SQL Server, Oracle, .NET, C#, ADO, Reflection, Visio

Systems Engineer

Independent Consultant

2006 - 2008

Developed a library of routines to enable data interchange in format EDI867 using Delphi.
Created a language for data interchange in Delphi on the databases SQL Server and Oracle in order to simplify the development of interfaces to other programs in formats: text, CSV, fixed length fields, delimited, and XML.
Expanded the EDI867 development to generate analytics by means of a complex SQL sentence that did 12 joins of a table on itself. This sentence, which later on was transformed into a view, worked on SQL Server and Oracle.
Downloaded, implemented, and upgraded the osCommerce open source B2C solution to PHP5 on MySQL to provide eBusiness services to companies.
Designed and implemented adaptations to the osCommerce platform to establish an art gallery on the internet; using PHP5 and MySQL.

Technologies: Delphi, SQL Server, Oracle, PHP, MySQL

Systems Engineer

TIC de Colombia LTDA

2001 - 2006

Created a medical diagnostics tracking and reporting application using Delphi.
Built an application to enable metadata definition and dynamic data entry forms generation to create EDI XML files for companies data interchange (in Delphi).
Developed a web server in Java (JSP) on an Oracle database and a client API in Delphi to allow software remote-tracing (transmission and storage of internal values for diagnostics and debugging).
Supported and developed add-ons for a local ERP developed by NCR for a telecommunications company, using C and Oracle SQL*Forms.
Designed and developed a sales opportunity tracking application using a Progress database and tools.

Technologies: Delphi, Java, Oracle, SQL Server

Systems Engineer

IBM Colombia

1989 - 1997

Taught all the IBM portfolio of AIX (C-Shell, X Windows, TCP/IP, NFS) and TCP/IP (in platforms AS/400 and RISC/6000) courses.
Developed the transparent printing facility for AIX using C language. I traveled to a residency at the IBM Support Center in Austin (Texas) to document this development in a technical IBM manual.
Acted as the the technical leader of a joint venture between IBM and the Bogota telephone company (ETB)—designing, developing, and implementing the administration and IVR applications using C, Informix, and DirecTalk/6000.
Led the implementation of the first IBM Internet service in Colombia, and developed the interface to invoice these services using the C language.
Designed and developed the sales opportunity tracking application for the channels area using the Lotus Approach.

Technologies: TCP/IP, C, AIX, DirectTalk/6000, Informix, Lotus Approach

Systems Engineer

Bank Superintendency

1987 - 1988

Developed the Customs General Storage Warehouses application in C and Oracle Pro*C.
Participated in the design and development of the bank surveillance application using C and Oracle Pro*C.
Developed the first communications application between the Superintendency and the banks.
Developed the first WYSIWYG bank accounting reports application using C and Oracle Pro*C.
Participated in the Colombian IT Award Competition in 1988 for my development to enable communication with the banks.

Technologies: UNIX, Oracle, C

Project Línea 5 (IBM and ETB Joint Venture) (Development)

Took part in the contract negotiation and led the implementation of the voice mailbox service as well as the development of the necessary software for the administration and operation of the service. At the end, ETB gave the project an 87% of satisfaction which made me win the 1994 IBM Marketing Excellence Award that entitled me to assist to the 1995 Latin American Convention in San Francisco.

IBM RISC/6000 Product Specialist (Other amazing things)

Gave presales support to the first IBM open systems platform, RISC System/6000, with many success cases that entitled me to participate in technical residencies in Austin, Mexico, Toronto, and Gaithersburg.

In 1991, I wrote the transparent printing module in AIX. In 1990, the success in many RISC/6000 cases was recognized with the 1990 IBM Marketing Excellence Award that entitled me to assist to the 1991 Latin American Convention in New Orleans.

IBM Global Network Product Manager (Other amazing things)

Led the launch of the IBM Internet Connection Service in Colombia. Developed the internet service invoicing application.

Part-Time Professor of Operating Systems (Other amazing things)

Between 1994 and 1996, I worked as a part-time professor at the Colombian School of Engineering teaching a class called Operating Systems 1.

NCR | Sintel ERP (Development)

I managed the execution of a support and software development contract with NCR Colombia for their software SINTEL—an ERP specialized in the telecommunications industry which was installed in their customer Empresa Regional de Telecomunicaciones del Valle del Cauca (ERT). As a result of these services, NCR could successfully close the ERT project, after many years of execution.

Brainbench Certifications (Other amazing things)

Between 2006 and 2008, I achieved Brainbench (http://www.brainbench.com) certifications of Project Manager, Systems Architect, IT Manager, Product Manager, Manager/Coordinator, and Sales Specialist.

Deliveries and Returns Android App (Development)

This app is used in a construction equipment rental company to handle the deliveries and returns in a controlled manner. It is used by warehouse coordinators and by transporters to report the loading, transportation, and delivery of the equipment to the customer construction site, and to, when the rental expires, to register the pickup, transportation, and restocking of the returned equipment.

It uses advanced features like location reporting, ticket printing, signature gathering, photography of items, and web services to get master data and report activities to the main business application of the company.

Tips to Attract, Manage, and Retain Software Developers (Publication)

https://www.toptal.com/software/attract-retain-software-developers

What makes software developers tick? With this theme in mind, we will present some ways to retain employees that we have identified in successful software development teams.

Bad Practices in Database Design: Are You Making These Mistakes? (Publication)

https://www.toptal.com/database/database-design-bad-practices

Flaws in your database design are like cracks in your application’s foundations. If left unchecked, trying to fix them down the line will be costly to say the least. In this article, Toptal Freelance Software Engineer Fernando Martinez discusses some of the most common database design bad practices and how to avoid them.

Languages

SQL, Java, C, C#, Delphi 7, PHP 5

Storage

SQL Server Management Studio, SQL Server 2008, SQLite, SQL Server Integration Services (SSIS), MySQL

Other

Spanish-English Translation, Software, French-English Translation, English-Spanish Translation, Web Services, Objects, Unix Shell Scripting

Frameworks

.NET, Apache Spark, Hadoop

Tools

Visual Studio, SQLiteManager, Android Studio, Eclipse IDE, Spark SQL

Platforms

Android, Unix, Windows, AIX, Linux, NetBeans

Libraries/APIs

Spark ML, Google Maps SDK

Specialization in Big Data

University of California, San Diego | Coursera - Online

2017 - 2017

Certificate in Social Sector Leadership

University of California, Berkeley | Philanthropy University - Online

2015 - 2016

Diploma with distinction in Business Administration

University of California, Berkeley - Berkeley, CA, USA

1997 - 1997

Bachelor's degree in Systems and Computing Engineering

University of Los Andes - Bogota, Colombia

1981 - 1986