Certified Professionals. Verified Work.
 
 
  • Feedback:   (4.15 of 5)
  • Percentile: 33%
    Based on 22 feedbacks
Hourly Rate: $22.22
Total oDesk hours:
1,320
Location:
CAGAYAN DE ORO CITY, Philippines (GMT+08:00)
English Skills: (self-assessed)
5.0
Member Since:
November 9, 2006
Last Worked:
November 19, 2008
Current Assignments:
5
Total Assignments:
29
oDesk Ready:  
Yes
 
 
 
 
Affiliated with:
 
 
 
 

Roy L. - Fulltime in oDesk VB6/VBA/MS Access/MY SQL/MS SQL/HTML/ASP.Net/VB.Net - Freelance Programmer / Developer, Philippines

Sr. Analyst Programmer Scibase Phil. http://www.scibasephil.net Over 11 years experience in IT industry, currently a Sr. Analyst/Programmer, has more than 10 years solid Client/Server experience and substantial expertise in standalone system since 1998, Proficient in development tools, and VBA/VB6/MS ACCESS/ASP.NET/VB.NET Database Administration tools and utilities in DOS, Windows 3.1x, Windows 95, Windows 98, Windows Me, Windows XP, Windows 2000, Windows Server 2003 environments....
See All Work History & Feedback (29 items, 22 with Feedback)
Recent Work History & Feedback
Buyer ID From/To Job Title Paid Feedback
60617 10/2008 - Present Development of a VB desktop application $1,347 (81 hrs @ $16.67)
43675 07/2008 - Present MS Access Programmer $3,557 (320 hrs @ $11.11)
59060 10/2008 - Present Access Accounting Software Developer $11 (1 hrs @ $16.67)
51871 11/2008 - Present WoW Addon Data to Website - Uploader $1,548 (70 hrs @ $22.22)
59950 10/2008 - Present MS Access Programmer $400 (24 hrs @ $16.67)
See All Tests Taken (3 items)
oDesk Tests Taken
Name of Test Score Percentile Date Taken Duration
oDesk Readiness Test for Independent Contractors and Company Managers 5.00 99% TOP 10% 1st Place! 07/13/2008 4 min
MS Access 2007 Test 3.40 77% 10/29/2008 36 min
Windows XP Test 4.00 75% 09/28/2008 16 min
Recent Candidacies
Job Opening Title Initiated By Date
Computer Software Programmer Provider November 19, 2008
Owner Provider November 18, 2008
Database Software Application to Manage Inventory Provider November 16, 2008
Data entry for 1.2 million tiff images - apply to access database Provider November 13, 2008
Web Mail and MS Access Provider November 12, 2008
Software developer required Provider November 9, 2008
Progress Programmer Provider November 9, 2008
POS developer Provider November 3, 2008
Racing Database Provider October 20, 2008
Job Category Interests

Software Development

Networking & Information Systems
Skills
Skill Experience Level Last Used Description
ActiveX 8 yrs 5.0 2007
ASP.Net 2 yrs 4.0 2007
Crystal Reports 8 yrs 5.0 2007
Database Modeling 9 yrs 5.0 2008
Data Entry 8 yrs 5.0 2006
Data Report 9 yrs 5.0 2008
HTML 7 yrs 4.0 2005
MS-SQL 7 yrs 5.0 2007
MS Access 97,MS Access 2000,MS Access 2003,MS Access 2007 9 yrs 5.0 2008
MS Office (Word, Excel, Powerpoint) 10 yrs 5.0 2007
MySQL 2 yrs 4.0 2008
Network and Systems Administration 7 yrs 5.0 2007
ODBC 9 yrs 5.0 2008
SQL Server 7.0/2000 7 yrs 5.0 2007
SQL Server 2005 3 yrs 5.0 2007
TCP/IP 6 yrs 5.0 2006
troubleshoot computers (hardware) 9 yrs 5.0 2007
VB/.NET 2 yrs 4.0 2008
VBA 8 yrs 5.0 2006
Visual Basic 6 8 yrs 5.0 2007
Winsock, Client/Server 7 yrs 5.0 2008
Certifications
Date Earned Name Score Percentile Organization Description
1997 Best Programmer of the year [197704]     Asian College of Science and Technology

Awarded best programmer of the year.
Employment History
From To Company Title/Role Description
12/2007 Present SCIBASEPHIL Manager/Analyst/Developer / Manager
Responsibilities:
  • Project Management
  • Preparation of project plans and time estimates
  • System Analysis and design
  • System Development
  • Staff Training
 
web: www.scibasephil.net
11/2007 01/2008 CEPALCO METER MONITORING SYSTEM(MMS) / Independent Contributor
Assigned to developed a client/server METER MONITORING SYSTEM (MMS) application and provide information on programs, modules, timetables, activities, staffing, users training, evaluates and reevaluates programming languages to better suits of the projects in relation to clients budget cost and with its existing hardware setup. The system provides a hierarchical level of security (up to row level) depending on the grants/privileges given to users for specific projects. It resides in an MS SQL Server on trusted mode on Windows 2000 NT Server. Client application is being developed using Visual Basic 6.

Responsibilities:
  • Project Management
  • System Analysis and design
  • System Development
  • Staff Training
12/2007 01/2008 AVRM MARKETING Inventory System,Account Receivables,Account Payable / Independent Contributor
Assigned to developed a Inventory System Using Visual
      Basic 6 / MS Access Database System.

      Responsibilities:

      * Project Management
      * System Analysis and design
      * System Development
      * Staff Training
08/2007 10/2007 MAXANDRIA HOTEL BILLING SYTEM / Independent Contributor

Assigned to developed a Billing System using MS Visual Basic 6 with

MS Access Database.



      Responsibilities:

      * Project Management
      * System Analysis and design
      * System Development
      * Staff Training
01/2007 06/2007 HIGHTIME DRIVE INN HOTEL PAYROLL SYSTEM / Independent Contributor Assigned to developed a Fingerprint Payroll System Using MS VisualBasic 6 / MS Access Database System. 
Responsibilities:
  • Project Management
  • System Analysis and design
  • System Development
  • Staff Training
12/2002 05/2007 HILLS SMALL LOANS AND LENDING FACILITIES CO., INC. ACCOUNT RECEIVABLES, ACCOUNT PAYABLES, DISBURSEMENT / Independent Contributor Assign to developed LOAN SYSTEM using Visual Basic6 under SQL Server7, developed LOAN SYSTEM with modules ACCOUNT RECEIVABLE, ACCOUNT PAYABLE, DISBURSEMENT, CHECK PRINTING.

Responsibilities:
  • Project Management
  • System Analysis and design
  • System Development
  • Staff Training
05/2005 02/2006 NUMENOUS MARKETING Inventory System,Account Receivables,Account Payable / Independent Contributor
Assigned to developed a Inventory System, Account Receivable, Account Payable using Visual Basic 6 / Access Database.

Responsibilities:
  • Project Management
  • System Analysis and design
  • System Development
  • Staff Training
04/2003 09/2004 HIGHTIME DRIVE-INN HOTEL HOTEL AND RESTAURANT SYSTEM / Independent Contributor Assigned to developed a Hotel and Restaurant System using MS Visual Basic 6 with MS Access Database.

Responsibilities:
  • Project Management
  • System Analysis and design
  • System Development
  • Staff Training
02/2003 07/2003 CEPALCO HUMAN RESOURCE INFORMATION SYSTEM(HRIS) / Independent Contributor
Assigned to developed a client/server HUMAN RESOURCE INFORMATION application and provide information on programs, modules, timetables, activities, staffing, users training, evaluates and reevaluates programming languages to better suits of the projects in relation to clients budget cost and with its existing hardware setup. The system provides a hierarchical level of security (up to row level) depending on the grants/privileges given to users for specific projects. It resides in an MS SQL Server on trusted mode on Windows 2000 NT Server. Client application is being developed using Visual Basic 6.

Responsibilities:
  • System Analysis and design
  • System Development
  • Staff Training
 
http://www.cepalco.com.ph
03/1998 10/2001 MCR INFONET SENIOR DATABASE PROGRAMMER / Team Lead Assign to developed and design computer system using Visual Basic6 under SQLserver7, developed a system like Account Receivable, Account Payable, Inventory System, Sales, Point of Sale System, Hotel and Restaurant System, Disbursement System, Payroll System, Check Printing and PABX System,and conduct a users training base on per client.

Responsibilities:
  • Project Management
  • System Analysis and design
  • System Development
  • Staff Training
 
06/1997 01/1998 CAGAYAN ELECTRIC POWER AND LIGHT CO., INC. DATABASE PROGRAMMER / Independent Contributor Assign to developed a system like PAYROLL system, HRIS system, BILLING system, developed the using Visual Foxpro.
Other Experience
BANDAG
HARDWARE MAINTENANCE
FEBRUARY 1998
NESTLE MAGNOLIA
COMPUTER INCODER
MARCH 1997 
WORLDS OF FUN
SERVICE CREW
FEBRUARY 1994
Education
From To School Degree Area of Study Description
04/1995 04/1997 Asian College of Science and Technology Bachelors Computer Science
06/1990 03/1994 Southern de oro philippines colleger High School High School
06/1984 03/1989 City Central School Diploma Elementary School

[+] enlarge
  • Project Title: PGM
  • Attachment: none
  • Completed: 08/10/2008
  • Category: Software Development > Desktop Applications
  • URL: none
  • Description: Assigned to develop frontend PGM system, using VB6/VBA tools with MS Access backend database.

[+] enlarge
  • Project Title: Pavement Database Summarizer
  • Attachment: none
  • Completed: 07/17/2008
  • Category: Software Development > Desktop Applications
  • URL: none
  • Description: This project is to develop a computer tool and standard operating procedures to allow faster and more efficient statistical data processing of Hawaii pavement management-related data.

[+] enlarge
  • Project Title: EDEN BODY WORKS
  • Attachment: none
  • Completed: 06/17/2008
  • Category: Software Development > Desktop Applications
  • URL: none
  • Description:
    MS Access database needed for EDEN BodyWorks customer service representatives.
    The system needs to:
    ·         be able to import a flat .csv (or .xls) file with order data records
    ·         reassemble flat .csv file into a relational database format so multiple product items can be associated with the same customer order.
    o   Note: Multiple products can be in the same order but will always belong to one customer
    ·         use the invoice number as one of the primary keys
    ·         be able to augment orders to existing customer records provided the customer ID matches
    ·         not import order records without an invoice order ID. If the user attempts to import, the system should import all valid records and create an exception report (.csv) for the user.
    ·         have data input fields: date/time spoken to customer; memo field for CR to enter details of conversation; promises/next steps made to customer; issue resolved [yes/no]
    o   Note: Multiple notes can be added to an invoice ID.
    ·         allow the customer data record to be edited
    ·         pull EDEN-formatted reports (to be determined)
    ·         be accessible in a desktop environment
    o   Assumption: Microsoft Access 2003, Windows XP

[+] enlarge
  • Project Title: The Falconwood Corporation
  • Attachment: Error Catcher.pdf - 28.729KB
  • Completed: 05/16/2008
  • Category: Software Development > Desktop Applications
  • URL: none
  • Description: Error CatcherDevelop a memory resident application that can be started/stopped from the system tray that works as follows:Specifications:a. User presses the “Print Scrn” button on their keyboard.b. An input box pop-up as below and ask the user for description of the problem.c. User presses the send button and then following happens1. Program will make a screen capture of current windows desktop [our desktop are currently 1920 x 1200].2. Save the file as image file [JPG or TIFF] file.3. Sends an e-mail to a  defined in an XML or INI file and attach the image file and user’s description of the problem.

[+] enlarge
  • Project Title: Revelations Technology, Inc.
  • Attachment: RateTemplateValidation.doc - 25.5KB
  • Completed: 05/15/2008
  • Category: Software Development > Desktop Applications
  • URL: none
  • Description: Developer with VBA, excel, and MSAccess experience

[+] enlarge
  • Project Title: WWE
  • Attachment: none
  • Completed: 04/24/2008
  • Category: Software Development > Desktop Applications
  • URL: none
  • Description: none

[+] enlarge
  • Project Title: OPENION LEADER
  • Attachment: none
  • Completed: 04/16/2008
  • Category: Software Development > Desktop Applications
  • URL: none
  • Description: none

[+] enlarge
  • Project Title: OSHC
  • Attachment: none
  • Completed: 04/16/2008
  • Category: Software Development > Desktop Applications
  • URL: none
  • Description: none

[+] enlarge
  • Project Title: WHEELERS TEXTILES
  • Attachment: none
  • Completed: 02/20/2008
  • Category: Software Development > Desktop Applications
  • URL: none
  • Description:

    Address: Canada
    Platform:
    Assigned to developed a and design Inventory/Sales System
    Using MS Access 2007.

[+] enlarge
  • Project Title: CEPALCO
  • Attachment: none
  • Completed: 01/05/2008
  • Category: Software Development > Client-Server Applications
  • URL: http://www.cepalco.com.ph
  • Description: Platform:
    Assigned to developed standalone or a client/server METER MONITORING SYSTEM application and provide information on programs, modules, timetables, activities, staffing, project achievements and milestone, users training and project cost assessment. Evaluates and reevaluates programming languages to better suits the projects in relation to clients budget cost and with its existing hardware setup. The system provides a hierarchical level of security (up to row level) depending on the grants/privileges given to users for specific projects. It resides in an MS SQL Server 2005 on trusted mode on Windows Server 2003. Client application is being developed using Visual Basic 6.

[+] enlarge
  • Project Title: AVRM
  • Attachment: none
  • Completed: 12/20/2007
  • Category: Software Development > Client-Server Applications
  • URL: none
  • Description:

    Platform:
    Assigned to developed standalone or a client/server SALES/INVENTORY/AR application and provide information on programs, modules, timetables, activities, staffing, project achievements and milestone, users training and project cost assessment. Evaluates and reevaluates programming languages to better suits the projects in relation to clients budget cost and with its existing hardware setup. The system provides a hierarchical level of security (up to row level) depending on the grants/privileges given to users for specific projects. It resides in an MS Access 2000 Database on trusted mode on Windows XP. Client application is being developed using Visual Basic 6.

[+] enlarge
  • Project Title: MAXANDREA HOTEL
  • Attachment: none
  • Completed: 10/31/2007
  • Category: Software Development > Client-Server Applications
  • URL: none
  • Description: Platform:
    Assigned to developed standalone or a client/server BILLING SYTEM application and provide information on programs, modules, timetables, activities, staffing, project achievements and milestone, users training and project cost assessment. Evaluates and reevaluates programming languages to better suits the projects in relation to clients budget cost and with its existing hardware setup. The system provides a hierarchical level of security (up to row level) depending on the grants/privileges given to users for specific projects. It resides in an MS Access 2000 on trusted mode on Windows XP. Client application is being developed using  Visual Basic 6.

[+] enlarge
  • Project Title: HIGHTIME PAYROLL
  • Attachment: none
  • Completed: 06/30/2007
  • Category: Software Development > Client-Server Applications
  • URL: none
  • Description: Platform:
    Assigned to developed standalone or a client/server Fingerprint Payroll System 
    and provide information on programs, modules, timetables, activities, staffing, project achievements and milestone, users training and project cost assessment. Evaluates and reevaluates programming languages to better suits the projects in relation to clients budget cost and with its existing hardware setup. The system provides a hierarchical level of security (up to row level) depending on the grants/privileges given to users for specific projects. It resides in an MS Access Database on trusted mode on Windows XP. Client application is being developed using Visual Basic 6.

[+] enlarge
  • Project Title: HILLS SMALL LOANS
  • Attachment: none
  • Completed: 05/15/2007
  • Category: Software Development > Client-Server Applications
  • URL: none
  • Description: Platform:
    Assigned to developed standalone or a client/server LOANS SYSTEM application and provide information on programs, modules, timetables, activities, staffing, project achievements and milestone, users training and project cost assessment. Evaluates and reevaluates programming languages to better suits the projects in relation to clients budget cost and with its existing hardware setup. The system provides a hierarchical level of security (up to row level) depending on the grants/privileges given to users for specific projects. It resides in an MS Access Database on trusted mode on Windows XP. Client application is being developed using Visual Basic 6.

[+] enlarge
  • Project Title: SCIBASE COMPUTER SYSTEMS
  • Attachment: none
  • Completed: 04/30/2007
  • Category: Web Development > Other - Web Development
  • URL: http://www.scibasephil.net
  • Description: Assigned to manage Scibase Computer System and also a become an ANALYST/PROGRAMMER , provide information on programs, modules, timetables, activities, staffing, project achievements and milestone, users training and project cost assessment. Evaluates and reevaluates programming languages to better suits the projects in relation to clients budget cost and with its existing hardware setup. our system provides a hierarchical level of security (up to row level) depending on the grants/privileges given to users for specific projects. It resides in an MS SQL Server / MS Access Database  on trusted mode on Windows XP/Windows 2000 NT Server/Windows Server 2003. Client/Server application is being developed using either MS Access 2000/2003/2007 or Visual Basic 6.

[+] enlarge
  • Project Title: NUMINOUS
  • Attachment: none
  • Completed: 02/28/2006
  • Category: Software Development > Client-Server Applications
  • URL: none
  • Description:

    Platform:
    Assigned to developed standalone or a client/server SALES/INVENTORY/AR/AP/BILLING application and provide information on programs, modules, timetables, activities, staffing, project achievements and milestone, users training and project cost assessment. Evaluates and reevaluates programming languages to better suits the projects in relation to clients budget cost and with its existing hardware setup. The system provides a hierarchical level of security (up to row level) depending on the grants/privileges given to users for specific projects. It resides in an MS Access Database on trusted mode on Windows XP. Client application is being developed using Visual Basic 6.

[+] enlarge
  • Project Title: HIGHTIME INVENTORY
  • Attachment: none
  • Completed: 01/28/2005
  • Category: Software Development > Client-Server Applications
  • URL: none
  • Description: Platform:
    Assigned to developed standalone or a client/server SALES/INVENTORY application and provide information on programs, modules, timetables, activities, staffing, project achievements and milestone, users training and project cost assessment. Evaluates and reevaluates programming languages to better suits the projects in relation to clients budget cost and with its existing hardware setup. The system provides a hierarchical level of security (up to row level) depending on the grants/privileges given to users for specific projects. It resides in an MS Access Database on trusted mode on Windows XP. Client application is being developed using either Visual Basic 6.
Hourly Assignment History
Buyer ID From/To Job Title Paid Feedback
60617 10/2008 - Present Development of a VB desktop application $1,347 (81 hrs @ $16.67)
43675 07/2008 - Present MS Access Programmer $3,557 (320 hrs @ $11.11)
59060 10/2008 - Present Access Accounting Software Developer $11 (1 hrs @ $16.67)
51871 11/2008 - Present WoW Addon Data to Website - Uploader $1,548 (70 hrs @ $22.22)
59950 10/2008 - Present MS Access Programmer $400 (24 hrs @ $16.67)
60031 10/2008 - 10/2008 Access DB Design $333 (20 hrs @ $16.67)
53443 08/2008 - 08/2008 Access $120 (11 hrs @ $15.00)
52799 08/2008 - 08/2008 VB Programmer with Access backend $1,104 (50 hrs @ $22.22)
51880 08/2008 - 08/2008 add functionality to existing MS Access Database $513 (34 hrs @ $15.00)