Changing How the World Works.
 
 
  • Feedback:   (4.83 of 5)
  • Percentile: 57%
    Based on 13 feedbacks
Hourly Rate: $22.22
Total oDesk hours:
359
Location:
Irapuato, Mexico (GMT-06:00)
English Skills: (self-assessed)
4.0
Member Since:
May 30, 2006
Last Worked:
August 22, 2008
Current Assignments:
0
Total Assignments:
14
oDesk Ready:  
Yes
 
 
 
 

Guillermo Hernandez - SQL DBA & Web ASP.Net Developer (US Central time) - Freelance Programmer / Developer, Mexico

See All Work History & Feedback (14 items, 13 with Feedback)
Recent Work History & Feedback
Buyer ID From/To Job Title Paid Feedback
49536 08/2008 - 08/2008 SQL Server DBA $17 (1 hrs @ $20.00)
22244 08/2008 - 08/2008 SQL Developer $162 (9 hrs @ $18.00)
27721 03/2008 - 03/2008 Ongoing Web Development - Guillermo $200 (10 hrs @ $20.00)
27721 01/2008 - 01/2008 ASP Function to create Excel Spreadsheet $43 (2 hrs @ $20.00)
23314 01/2008 - 01/2008 Grips Modification $97 (5 hrs @ $20.00)
See All Tests Taken (0 items)
oDesk Tests Taken
Name of Test Score Percentile Date Taken Duration
No oDesk tests taken
Recent Candidacies
Job Opening Title Initiated By Date
Application ASP.NET 1.1 VB convert to ASP.NET 3.5 VB Provider November 21, 2008
Job Category Interests

Web Development

Software Development
Skills
Skill Experience Level Last Used Description
ASP.NET+ADO 5 yrs 5.0 2007
Crystal Reports 7 yrs 5.0 2007
Database Modeling 10 yrs 5.0 2007
MS-SQL 7 yrs 5.0 2007
VB/.NET 5 yrs 5.0 2007
Certifications
Date Earned Name Score Percentile Organization Description
2002 Microsoft Certified Solution Developer [MCP ID# 2337171]     Microsoft Visual Basic y SQL 2000.
http://www.microsoft.com/learning/mcp/transcripts. Transcript ID (691546) and the Access Code (mcsdmemo),
Employment History
From To Company Title/Role Description
11/2006 06/2007 Centurion Auto Transporte DBA Administration and Windows .Net Developer / Independent Contributor
  • Analyzed, designed, developed, tested and implemented modules of invoicing, account receivables, account payables.
  • Developed and deployed payroll interface with Certy Pay software.
  • Installed and setup the database for the application.
  • Responsible for administration of the SQL Server 2000 database for the VIN Tracker Application.
05/2006 09/2006 Ajilon Consulting SQL Server DBA, MS Visual Studio Developer / Independent Contributor Project: Sales Invoice, Account Receivables, Account Payables, Payroll

Purpose: Invoicing Customer and Vendor System 
Technology used: WinForms VB.Net 2005, Crystal Report 11, Visio 2003
Database: MSSQL 2000 

Roles: System Analysis, Design, Development, Testing and Implementation. Database Manager
12/2005 04/2006 Independt Consultor DotNetNuke 4.x / IronSpeed 3 Developer / Independent Contributor Project: Construction Management System, 
Purpose: cost code, change order, and cost type, including labor, material, subcontract, other direct cost, and equipment. 
Technology used: ASP.Net / VB.Net 2005, IronSpeed 3.2, MS Reporting Services,Visio 2003
Database: MSSQL 2005 
Roles: System Analysis, Design, Development, Testing and Implementation. Database Manager

Project : DotNetNuke Hosting
Purpose: Hosting Dotnetnuke 3.x & 4.x Web Sites, DNN Store Module.
Technology used: ASP.Net / VB.Net 2005
Database: MSSQL 2000
05/2005 12/2005 Softtek SQL Server DBA / Independent Contributor Roles
- SQL 200X Server System and Database Administration,
- Query Analyzer and SQL Debuger, 
- Data integrity, security and user administration.
- Database Backup and Restore Strategy;
- Importing SQL data using BCP and DTS,
SQL Internals and Performance Tuning
Technology used:Microsoft SQL Server 7.0/2000, Windows Server 2000/2003

Project: Ticket Help Desk
Purpose: Allow users to submit tickets
Technology used: ASP.Net / VB.Net 2003, IronSpeed 3.2, MS Reporting Services, Infragistics 2005, ComponentOne 2005
Database: MySQL 5.0 
Roles: Redesign from Oracle 9i to MySQL 5.0
04/2003 03/2005 American Axle & Manufacturing Web Developer & DBA Support / Independent Contributor Roles
- SQL 200X Server System and Database Administration,
- Query Analyzer and SQL Debuger, 
- Data integrity, security and user administration.
- Database Backup and Restore Strategy;
- Importing SQL data using BCP and DTS,
SQL Internals and Performance Tuning
Technology used:Microsoft SQL Server 7.0/2000, Windows Server 2000/2003

Project: Quality Information System
Purpose:  Statistical & Reporting Web System  
Technology used:  ASP.Net VB.Net 2003, Infragistics 2004, ComponentOne 2004, FairPoint, MS Reporting Services
Database: MSSQL Server 2000
Roles: System Analysis, Design, Development, Testing and Implementation. Database Manager

Project: Monitor & Alerting System
Purpose:  Monitoring & Statistical SQL Servers such as jobs, logs error, databases errors, etc 
Technology used: ASP.Net VB.Net 2003, Infragistics 2004, ComponentOne 2004, FairPoint, MS Reporting Services
Database: MSSQL Server 2000
Roles: System Analysis, Design, Development, Testing and Implementation. Database Manager

Project: Data Collection System
Purpose:  Collection of data from the VLC to SQL databases at México & US 
Technology used:  WinForms  VB.Net 2003, Infragistics 2004, ComponentOne 2004
Database: MSSQL Server 2000
Roles: System Analysis, Design, Development, Testing and Implementation. Database Manager

Project: Image Collection System
Purpose:  Collect images from production lines taken at the stations and stored as binary data 
Technology used:  WinForms  VB.Net 2003
Database: MSSQL Server 2000
Roles: System Analysis, Design, Development, Testing and Implementation. Database Manager

Project: Ticket Help Desk
Purpose: Allow users to submit tickets
Technology used: ASP.Net / VB.Net 2003, Infragistics 2004, ComponentOne 2004
Database: Oracle 9i 
Roles: System Analysis, Design, Development, Testing and Implementation. Database Manager
08/1997 03/2003 Universidad Quetzalcoatl IT Manager / Manager Roles:
Design, implementation and administration of Windows 2000 networks
Technology Used: OS
 Windows NT 3.5 & 4.0, Windows 2000 Pro & Server, Windows 95,98, ME, XP
Development
 SQL 2000, Visual Basic 6.0, ASP
Other
 Exchange Server 5.5, 2000, IIS 4.0.

PrProject: School Management 
Purpose: Manage Students grades, classroom, time schedule, building, teacher timing.
Technology used:  WinForms VB.Net 2002 & VB6, Infragistics, ComponentOne.
Database: MSSQL Server 2000
Roles: System Analysis, Design, Development, Testing and Implementation. Database Manager

Project: Administrative Management System 
Purpose: General Ledger, scholar control, account receivable, account payable.
Technology used:  WinForms VB.Net 2002 & VB6, Infragistics, ComponentOne.
Database: MSSQL Server 2000
Roles: System Analysis, Design, Development, Testing and Implementation. Database Manager

Project: School Web Site 
Purpose: Official Web Site, Consulting grades for Students and Parents to access the grades.
Technology used:  Web ASP.Net & VB.Net 2002 & VB6, Photoshop.
Database: MSSQL Server 2000
Roles: System Analysis, Design, Development, Testing and Implementation. Database Manager
03/1992 08/1997 Del Monte Food Novell Network administrator and AS/400 IBM Technical Support / Independent Contributor Network Administration, Project Leader
 Installation of Novell NetWare 3.12 at the offices of Irapuato and Mexico contemplating the following stages:
 Analysis and selection of equipment.
 Installation of NetWare operating system 3.12
 Installation of Windows 3.1 3.11, Lotus 4.01, Microsoft Office 4.2, Microsoft Projects, Microsoft Office Win95, CC: Mail 2.02 and ArcServe 5.0 into the File Server.
 Installation of 80 PC's and 15 Printers Laser with the programs installed in the LAN at the offices of Irapuato and Mexico.
 Connection with all LANs via leased line.
 Installation a gateway between LANs and AS/400 via Token-Ring protocol.
 Installation of equipment at several warehouses of the company distributed in the whole country:
 Controllers and Terminals IBM.
 Remote PCs connected to the AS/400 via SDLC.
 Implementation of preventive and corrective plan for all LANs in the Company.
 Installation of internal Electronic Mail.
 Design, implementation and administration of Novell 3.12 networks
 AS/400 IBM Administration and Technical Support
 Support in BPCS (Manufacturing software) and implementation in ADAM (payroll and Human Resources software)
08/1989 03/1992 Empresas Cano Garc IT Manager / Independent Contributor Network Administration, Project Leader
Maintenance for all programs into the Office:
 General Ledger
 Account Payable.
 Account Receivable
 Inventory.
 Orders of reparation for cars.
 Payroll.

 Analysis and selection of the AS/400 of IBM.

 Analysis and development of General Ledger and Payroll in RPG programs for the AS/400
Other Experience
- Strong knowledge of Transac-SQL
- Strong knowledge of Transac-SQL
DotNetNuke
DotNetNuke expert 3.x & 4.x
Iron Speed Designer 3.2.4,
2 Years using Iron Speed Designer 3.2.4
tool to develop ASP.Net VB.Net or C# project as front-end and SQL 200X, Oracle (9i,10g), MySQL and MS Access 200x as Back-end
Web Design
- 2 years experience
- PhotoShop CS2
- SWiSHmax (Flash Programming)
Education
From To School Degree Area of Study Description
07/1999 06/2002 Instituto Tecnologico Celaya Masters Master Business Administration
01/1985 12/1989 Institute Technology of Celaya Masters IT
No items in portfolio
Hourly Assignment History
Buyer ID From/To Job Title Paid Feedback
49536 08/2008 - 08/2008 SQL Server DBA $17 (1 hrs @ $20.00)
22244 08/2008 - 08/2008 SQL Developer $162 (9 hrs @ $18.00)
27721 03/2008 - 03/2008 Ongoing Web Development - Guillermo $200 (10 hrs @ $20.00)