offline
Last seen: Jul 24, 2014 2:42 AM EDT
Hire Me!
Rate: $15.00 USD/hour
Follow Invite to Project
 

Diego Garcia

Software Developer: AutoCAD, ArcGIS, VBA Automation, Database Expert, SQL developer

Username: diegogarcia0531

  • Has made a deposit.
  • Has verified their email address.
  • Has completed their profile.
  • Has verified their secure phone number.
  • Verified
  • Payment is verified.

Location: Bucaramanga, Guatemala

Member since: May 2012

Reputation:

4.9/5

(46 reviews)

5.7
[see more]

2 users have recommended this freelancer.

My skills:

My projects:

  • $90.00 AUD
    5.0
    Profile image for Seller bigmuz

    bigmuz

    Jun 20, 2014

    Top work...

    Project Description:We have a large inventory file that we wish to review what images are associated to what inventory code. We are looking for someone to load the images into a spreadsheet so we can visually view the image in the spreadsheet...
    [more]
  • [Sealed]
    5.0
    Profile image for Seller a0563517993

    a0563517993

    May 31, 2014

    he is great and he will do what ever u want

    Project Description:Ok what i need in this assignment is to do SQL. BUT what i need more is to do this assignment in TEACHER WAY don't ever do it in your way if u CAN"T then don't ask me to choose u .He explain every thing...
    [more]
  • $200.00 USD
    5.0
    Profile image for Seller infovertica

    infovertica

    Apr 15, 2014

    Extremely thorough developer, and knows his stuff. He is excellent at translating requirements into finished product. Highly recommended!!!

    Project Description:I have an old VB-6 project, that I would like converted to a .Net 2 and upwards .Net versions-capable project. It also includes an older .hlp Help file, complete with documentation, that I would like imported or otherwise converted to .Net 2 and upwards .net version-compatible help files...
    [more]
  • $34.00 AUD
    5.0
    Profile image for Seller wilson12

    wilson12

    Jan 20, 2014

    Quick and Effective

    Project Description:Basically i have started a building a basic program for work purposes that will handle the information that is entered into different fields and generate structured notes in a textbox that can then be edited to add additional notes...
    [more]
  • $70.00 CAD
    5.0
    Profile image for Seller urbantree1

    urbantree1

    Oct 21, 2013

    Very quick Freelancer..

    Project Description:We need a Microsoft access form made to calculate the weight of wood as well as the carbon content. we will supply the calculations. please see the attached pdf for specifics.
    [more]
  • [Sealed]
    5.0
    Profile image for Seller itsmevic

    itsmevic

    Oct 15, 2013

    Fantastic experience! Top notch job!

    Project Description:[This is a Private Project. You must be logged in to view the Project Description]
    [more]
  • [Sealed]
    4.8
    Profile image for Seller AndrewLangdon

    AndrewLangdon

    Sep 24, 2013

    Diego was great. He did what he quoted to do, quickly and to my satisfaction. Testing was simple as most of the project was right first time. Very good Access programmer.

    Project Description:This project is to create a database preferably in Microsoft Access 2010. The specification is attached. Once we have agreed to work together, I will provide sample data for the externally linked tables.
    [more]
  • $30.00 USD
    5.0
    Profile image for Seller vadeoye

    vadeoye

    Aug 26, 2013

    Simply the best<br/>

    Project Description:Hello, I love your work and I need a similar code in SQL SERVER 2010 and MS Access.nnPlease see requirements below and attached sample file. Thanksn1. Sort by Equip_no Ascendingn2. Sort by Date_Time Ascendingn3...
    [more]
  • $30.00 USD
    5.0
    Profile image for Seller vadeoye

    vadeoye

    Aug 21, 2013

    I will definitely hire him again. He's very good. Simply the best.

    Project Description:I have a flat table containing millions of records (900 million rows) Write SQL function and VBA function to do the following: 1. Sort Ascending by Train_ID 2. Sort Ascending by Actual_Datetime 3...
    [more]
  • $250.00 USD
    5.0
    Profile image for Seller edjanesvw

    edjanesvw

    May 19, 2013

    Diego was great, turned the project around quickly and handled delays my end very well. Will definitely use again.

    Project Description:I require a programme/script to be written and supplied which creates a fixed template to populate the fields in the attached Word document. The script is required to restrict staff from having the ability...
    [more]
    Diego Garcia has not completed any projects.
  • $75 USD In Progress

    Voy a necesitar una persona para instalar un servidor sql server en un windows server 2012Es una migración, hay que copiar las bases de datos del servidor viejo y pasarlas al servidor nuevo.El trabajo sería:1-Instalar sql server 2012,2-Copiar y configurar las bases de datos del servidor viejo en el nuevo.Espero respuestaGracias

    [more]
  • $15 USD/hr In Progress

    Necesito un colaborador para una pequeña aplicacion access que estoy diseñando, asi como para el mantenimiento de un par de aplicaciones mas que tengo, por si en algun momento surge algun problema, que pueda resolverlo con rapidez.Las aplicaciones todas son bases de datos access 2010, con codigo vba para realizar determinadas acciones. Nada complicado para alguien con conocimientos de visual basic y microsoft access. El pago seria por tiempo de trabajo empleado por el programador, ya que busco alguien con quien mantener una relacion de trabajo a largo plazo.Necesito alguien honesto y que realmente cobre por el tiempo dedicado a la programacion, para asi poder mantener una relacion de trabajo por largo tiempo. Para saber que el aspirante tiene un buen nivel, el primer trabajo sera hacer una pequeña modificacion en una de las bases de datos existentes. Aunque se ingles, preferiria trabajar con alguien que pueda comunicarse correctamente en español exclusivamente.Me considero una persona que explica bien los trabajos a realizar, con detalle y siempre intentando facilitar la tarea del programador. Cualquier duda podemos hablarla por privado, sin problema y sin compromiso alguno.

    [more]
  • $200 USD In Progress

    I am short a developer and I need someone with experience in VBA (Visual Basic for Applications) and some desktop VB.NETI have a number of SQL (2005 and 2008) databases with Microsoft Access (2007 and 2010) front end. These use Microsoft Access and VBA as the user interface and I need someone to help out on an ongoing bases. It is not a huge volume of work but it does come in small projects.The specific project I have now is related to one of my databases. I need to develop a data collection form in Excel and VBA. The form will be e-mailed out and will be completed by field technicians and e-mailed back. I have started the form and have some working code but workload and priorities mean I need someone else to help out.The Excel file contains 8 forms (Excel Worksheets) and 2 worksheets of data.The basis is the user fills in the form and there are some fields that have upper and lower limits and some fields that require a look-up and auto complete. The data for the upper and lower limits is in the workbook (on one of the two data sheets). I need the developer to write some VBA code so that when the &quot;cell update&quot; event is triggered the code will compare the value entered to the value in the other sheet. If it is outside the limit the user gets a message and the cell focus is set back to the cell with the out of limit value.This is not hard to do but there are 8 forms and each form has 25 to 30 fields that need validated (it is a lot but if the code is written correctly it can be cut and pasted) I am part way through the first form but I need someone to finish it and complete the other 7 forms using the same code template. I also need the developer to help lock the sheet so when it is sent to the user that they only enter data in certain fields.When this project is done I will be posting a second project to write a desktop application to take the results entered and post them to a table in Access so there will be a bit of ongoing work.For this Excel project I am estimating that there is about 2 or 3 hours work in each form. I am also assuming USD10 per hour so USD10 x 3 hours per form x 8 forms = USD 240 max My two main criteria will be cost and quality. I am not going over 240 USD and I will be looking for someone who can come in under that and I am also looking someone who has some history of doing a good job (feedback) with VB development (either VBA or VB.NET)

    [more]
  • $25 USD/hr In Progress

    The application needs to give us a comparison between what is scheduled to what is actually done.

  • $20 USD/hr In Progress

    As discussed in our on going conversations......................................l As discussed in our on going conversations......................................lAs discussed in our on going conversations......................................lAs discussed in our on going conversations......................................lAs discussed in our on going conversations......................................lAs discussed in our on going conversations......................................lAs discussed in our on going conversations......................................l

    [more]
  • $220 USD In Progress

    Our company use Microsoft Visio and AutoCAD to draw and define what components that are included in our products. We want those components to be automatically specified in the excel list we use to set the product price through an off-take command, which we have for one of the products but not the oters. As of now, our engineering employees have to manually specify add each component to the price list and enter length, quantities etc. The excel list is already predefined and the logic will basically be &quot;quantity and length of component X (defined in Visio) should be uploaded to Cell XY&quot; in the predefined excel list.We are also reviewing the entire construction and quotation process to see where we can free up time through automation like this, so we will post more projects that are related to this area. It is therefore important for us to find a reliable partner who can help us with these other projects once this first one is successfully implemented. The final scope of this project (and its price) might be revised based on discussions we will have with freelancer who get this project.

    [more]
  • $11 USD/hr In Progress

    I need someone who is always available on SKype to do job in MS Access. You must also have Teamviewer.I have the first job available right now.

  • $35 USD In Progress

    We are looking for a Native Spanish Speaker to Audio record Spanish words.Number of words: 300Language of word: Spanish & EnglishAudio format: MP3Freelancer must have a high level of English.It should take no longer than 1/2 hours

    [more]
  • $35 USD In Progress

    Research options and help me organize my email accounts with attention to security, privacy and encryption

  • $2000 AUD 9 days ago

    Client requires a production management database developed from a currently used Excel spreadsheet system.They want to track the following information:•Quotes for both existing and new customers with calculation of fixed and variable costs and calculation of prices for varying numbers ordered.•Materials required for production including Stock Held and Ordered / Received•Job tracking with costs, materials and production stages - Labour, Machines, Processes with data from Quote plus time scheduling data.•Schedule to manage workflow depending on job urgency, date required, materials in stock/ordered, available staff hours, machine capacity, maintenance•Calendar of staff availability including rostered days off, public holidays and weekends, and available machine and man hours for each day.•Efficiencies in use of man and machine hours, and targets set and achieved.Some information is stored in a business finance package files that are available as read only files.This includes:•Customer details •Stock Items•Stock Purchases •Suppliers •Employees •Addresses

    [more]
  • $150 USD 9 days ago

    I need a VBA that, in the press of a button on excel, will search my outlook inbox for a specific email and then extract the content of the email into excel spreadsheet.

  • $230 CAD 14 days ago

    Dance Studio Access DBWe need to have the ability to enter a new list of classes, that we can populate with students registering for the upcoming dance season.The DB is only one year old, and this feature was not incorporated.We also need to establish, a starting point to the dance year of 2014-2015. We obviously want to keep all the students in the DB but we need a way to separate this coming year from last dance season and other years to come.Iam not sure how best to do that, I am hoping you have a suggestion

    [more]
  • $200 USD 14 days ago

    Need someone to take my excel files and create a simple Client/Services database

  • $230 USD 14 days ago

    Need someone to create a simple CRM for Clients and Daily Services for my Massage practice. Will include client contact, daily services log, session credit purchase and use log, paid-in paid-out etc

  • $5300 USD 15 days ago

    I have a very large MS Access 2010 database that I would like to consider creating a stand alone application that can perform all the same functions. I have data in MySQL or MS Access format. I need someone to first review the application and then decide the possibilities. The individual needs to fully understand MS Access and evaluate to determine the feasibility of creating a fully functional duplicate written in a standalone program preferably web enabled. The current database is used for medical record keeping in a allied services facility providing speech, occupational and physical therapy. It includes scheduling, session notes, progress tracking and billing.Number of forms: 403Number of tables: 258Number of reports: 148Number of Mods: 120Number of Queries: 307Extensive VBAThank You.

    [more]
  • $270 USD 15 days ago

    Our company currently has a MS Database.We are unable to upload Excel Reports to our database.Also, we&quot;d like to add a field that contains our new sales regions:North America, South America, Europe & Africa.The region field would be great to see when we create our monthly, yearly sales report.Please let me know if you can help and provide your fees and how long you&quot;d think this project would take.Thanks,EG

    [more]
  • $100 USD 18 days ago

    Tengo una base de datos en access y quiero migrar a MS SQL Server , los datos y la estructurala base con datos pesa unos 35 MBahora tengo el front y las tablas por separadonecesito esto muy rapido si alguien puede hacerlo con eficacia le agradesco contactarmeAngel

    [more]
  • £150 GBP 23 days ago

    I require a simple interface for the management of data and the print of labels for participant passes at the Edinburgh Festival Fringe. i would like a single terminal where the user can enter three data fields (Name; Show Title; Company) to generate a label for the pass. Ideally one person could enter multiples in a company without retyping the info so the option to enter a number of labels with shared data would be helpful. i would like the data form to clear once print has been clicked but for the data to store to an excel/access for our records. The interface will be loaded onto a PC terminal and should run in standard windows systems (access, excel, etc). I would also appreciate some advice on the purchase of a label printer that will produce labels (simple sticky ones!) quickly with the click of a button. The key priority is speed of production so the participant would print a label which is then stuck to the back of the pre-printed participant pass to go into the lanyard holder. This is required by 18/07/2014

    [more]
  • $500 USD 24 days ago

    I am looking for a freelancer who has good expertise in oracle and DBA. Professionals need to take a test for qualification. Please bid if you are looking for remote opportunity with good qulification.

    [more]
  • $100 USD 25 days ago

    Hello,I have a game and i want to update the database item base on the notepad database file i want to update he ms access databaseIf you see the records the notepad database item group and sorting is the same on access database now there are some codes there that i dont understand and maybe someone can help me update this.I have attached the filesdb.txt = Updated Listdb2.mdb = ms access that needs to be updatedThanks!

    [more]
  • $250 USD 25 days ago

    I have a payroll software done in vb6. i have done the software. i am not a professional that why it having problems and design look not good. i need to someone to redesign and add some more features to it.now i have doneemployee mastermonthly timesheetmanual salaryautomated salarysalary data for banks etc....in U.A.E some salary rules are there. that details i will give.additional features needed:-document expiry reminderdatabase backupi need it in vb6 coz i can make some changes if i need lateri will give my code for modificationplease bid after understanding the project

    [more]
  • $40 AUD/hr 25 days ago

    You will be working for one of Australia&quot;s big 4 banks Oracle PL/SQL Developer - Banking My client is looking for the services of an experienced Oracle PL/SQL Developer to assist them with migration of client-based applications that have been user-developed using the Microsoft Office suite (MSAccess, VBA, MSExcel) onto a client-server based platform, centred around Oracle 11g. Role: Data Layer: Migration of data from existing MSAccess & MSExcel stores, onto some pre-existing Oracle 11g artefacts (our own people will perform this task)Logic Layer: Migration of logic from existing VBA procedures & MS-SQL scripts acting on the existing data artefacts, to Oracle PL/SQL procedures acting on the Oracle 11g artefacts above (the Oracle PL/SQL developer will perform this task)Presentation Layer: Development of presentation layer, using tools compatible with Oracle 11g, to present and publish results (this will be a shared responsibility between our own people and the Oracle PL/SQL developer) Competencies: The Oracle PL/SQL developer will need to be able to understand procedures written in VBA used in conjunction with MS-SQL on MSAccess databases, and be able to functionally translate these procedures to PL/SQL on Oracle Databases.

    [more]
  • $250 USD 25 days ago

    I have a payroll software done in vb6. i have done the software. i am not a professional that why it having problems and design look not good. i need to someone to redesign and add some more features to it.now i have doneemployee mastermonthly timesheetmanual salaryautomated salarysalary data for banks etc....in U.A.E some salary rules are there. that details i will give.additional features needed:-document expiry reminderdatabase backupi need it in vb6 coz i can make some changes if i need lateri will give my code for modificationplease bid after understanding the project

    [more]
  • £500 GBP Jun 11, 2014

    We are seeking a good developer (s) to develop a fast to use streamlined database application. This is to assist in the good purchased process within our IT Company that currently makes use of a single spreadsheet. Each purchase we make of goods is entered into a spreadsheet.That data later gets imported into our accounting application Sage.So the fact it’s just currently one spreadsheet that we are turning into a database, should make it a straight forward project for anyone with relevant skills. The database may grow on to include many other features that support our internal business process and in some regards, this project is a test project for us to develop a relationship with developer(s).Initially we had strong ideas about the development / coding platform that should be used, even considering Access at one time because of the UI speed it can give (As we are from a coding background), but now we are open to anything that can give, good interface performance, is scalable (we have big ambitions) and is able to developed and well documented The attached document outlines the project in greater detail.

    [more]
  • $600 USD Apr 2, 2014

    HolaNecesito migrar una aplicación VBA de AutoCAD a la versión .NET de AutoCAD.Quisiera saber si estarías interesadoSaludosBruno

  • £222 GBP Aug 21, 2013

    We have an excel workbook that has a GUI to enter / update values in a number of sheets. We would like to use the same user interface in a different workbook that is structured in exactly the same way, and therefore need the existing GUI and associated macros to be modified to work with the other workbook. The following would need to be modified.The GUI in a master file (in excel 2010)An identical GUI that is used in a standalone version in excel 2003 A macro that copies the values from the standalone GUI to the master fileThe GUI / macros have been created and only need to be adapted to work with the other workbook.The GUI consists of 9 screens (10 for the adapted version), that each contain 4-8 tabs. Each screen corresponds to a sheet in excel. Each tab consists of 6 (2 in the new version) static fields that need to be read from excel sheets and 5 dynamic field that read / write to cells in excel.The stand alone GUI (in excel 2003, so it can be used on different platforms) is identical, and additionally includes a function to have the file expire after a certain date and a protected macro to hide / unhide sheets to protect the content.The import macro copies the (dynamic) fields from the stand alone GUI to the master file.All GUI components / macros have been created and only need to be adapted to work in the other workbook. There are some screenshots in the attachment. The deadline for the project (including testing and bug-fixing if required) is 3 September.

    [more]
  • $250 USD Jun 26, 2013

    Hola, el proyecto consiste en un programa que dada una tabla de excel con los datos 5 o 6 columnas y varias filas, llene un formulario de un programa en la web, y repita el proceso automaticamente hasta finalizar los datos existentes en la tabla.

    [more]
  • $15 USD/hr May 16, 2013

    Desarrollo de aplicaci&oacute;n en Access, utilizando Visual Basic. La aplicaci&oacute;n cuenta con m&oacute;dulos en los que el usuario ingresa informaci&oacute;n a trav&eacute;s de formularios y puede obtener salidas (tablas, gr&aacute;ficas y consultas aplicando filtros). Necesito disponibilidad inmediata.

    [more]
  • $30 USD May 3, 2013

    Hi I have a very small project in excel vba programming. I have an excel sheet where stock market datas are updating dynamically, based on 5 fields, i need to plot the graph. What i need from you is to store 5 fields data for every 5 minutes in an access database or in same excel and plot it for graph. As it is very small project, I can offer 20$

    [more]
    Diego Garcia does not have any open projects.
    Diego Garcia does not have any work in progress.
[see more]

Portfolio

[see more]

Résumé

Experience

Developer Engineer Senior

Jan 2011 - Jul 2012 (1 year)

INGCORMAP LTDA

VBA projects for ArcGIS and AutoCAD<br />VB6 systems, <br />Visual Baisc .NET systems,<br />Implementation of mapserver sites.<br />Database: ORACLE, SQL Server, MySQL, MS Access

Education

Systems Engineer

Universidad Industrial de Santander

2012-2012

Certifications

Technological expertise in database administration

Servicio Nacional de Aprendizaje - SENA

Managing the database to ensure the integrity, availability and quality of data.