Systems Engineer
2010 - PRESENTIndependent Consultant- 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: Delphi, MySQL, SQLite, Microsoft SQL Server, Visual Studio, C#, Eclipse, Android, JavaSoftware Development Manager
2008 - 2010Primestone S.A.- 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: ADO.NET, Visio, Reflection, C#, .NET, Oracle, Microsoft SQL Server, DelphiSystems Engineer
2006 - 2008Independent Consultant- 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: MySQL, PHP, Oracle, Microsoft SQL Server, DelphiSystems Engineer
2001 - 2006TIC de Colombia LTDA- 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: Microsoft SQL Server, Oracle, Java, DelphiSystems Engineer
1989 - 1997IBM Colombia- 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: IBM Lotus Approach, IBM Informix, AIX, C, TCP/IPSystems Engineer
1987 - 1988Bank Superintendency- 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: C, Oracle, Unix
Software Developer in Bogotá - Bogota, Colombia
Member since April 24, 2017
Fernando is a systems and computing engineer who graduated from the University of Los Andes in 1987 and has worked in software development ever since. He started developing in C on UNIX operating system with ORACLE SQL database. Fernando has kept his skills up-to-date and has developed in Java, C#, SQL Server, and more.
Fernando is now available for hire
Portfolio
- Independent ConsultantDelphi, MySQL, SQLite, Microsoft SQL Server, Visual Studio, C#, Eclipse...
- Primestone S.A.ADO.NET, Visio, Reflection, C#, .NET, Oracle, Microsoft SQL Server, Delphi
- Independent ConsultantMySQL, PHP, Oracle, Microsoft SQL Server, Delphi
Experience
- SQL 10 years
- C 6 years
- Java 5 years
- Delphi 7 4 years
- SQL Server Management Studio 3 years
- C# 3 years
- SQLiteManager 2 years
- .NET 1 year
Availability
Part-time
Preferred Environment
Microsoft SQL Server
The most amazing...
...language I designed and implemented was for complex data exchange operations.
Employment
Experience
- 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)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)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.
Skills
Languages
C#, C, SQL, Java, Delphi 7, Delphi, PHP, PHP 5Storage
SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server 2008, SQLite, Microsoft SQL Server, IBM Informix, MySQLOther
Software, French-English Translation, English-Spanish Translation, Spanish-English Translation, Objects, Web Services, Reflection, TCP/IP, IBM Lotus Approach, Unix Shell ScriptingFrameworks
.NET, ADO.NET, Apache Spark, HadoopTools
Microsoft Visual Studio, SQLiteManager, Visual Studio, Visio, Android Studio, Eclipse IDE, Spark SQLPlatforms
Unix, Windows, Android, Oracle, Eclipse, NetBeans, AIX, LinuxLibraries/APIs
Spark ML, Google Maps SDKParadigms
REST
Education
- Specialization in Big Data2017 - 2017University of California, San Diego | Coursera - Online
- Certificate in Social Sector Leadership2015 - 2016University of California, Berkeley | Philanthropy University - Online
- Diploma with distinction in Business Administration1997 - 1997University of California, Berkeley - Berkeley, CA, USA
- Bachelor's degree in Systems and Computing Engineering1981 - 1986University of Los Andes - Bogota, Colombia
