A SQL Developer from November 2017 up to present in an Australian-based Enterprise Logistics System with T-SQL,  Software Developer for 32 months in a US-based BPO-IT industry using PHP, Perl, T-SQL and MySQL.  An IT teacher in college for more than 10 years handling Database Systems with IBM DB2-UDB, MySQL and T-SQL, Computer Programming with VB6 and C, and Data Structures with Java.  I am also a Freelance Programmer for more than 10 years catering small and medium scale industries in their Inventory, Payroll and Production Costing systems using MS Access, DOS-based Clipper and VB6.

PROFESSIONAL SKILLS

Programming Languages  : Clipper, Visual Basic, C, Java, PHP, Perl

Databases                             : MS Access, MySQL, T-SQL, IBM DB2-UDB, MongoDB

Tools                                      : Visual Studio 6, Tortoise SVN,   Eclipse, Slack, Textpad

Platforms                               : Windows 95/98/XP/7/8.1/10, Linux

Networks                               : Novell-NT, Windows NT, Linux

PROFESSIONAL EXPERIENCE

Position: Fulltime SQL Developer

Company Name: House of IT, November 2017- Present

Address: 7th Flr, Crown 7 Bldg.  Pope John Paul II St., Kasambagan, Mabolo, Cebu  Tel. No. (032) 412 0602 Local 865

Project: CargoWise Logistics System support

Project name: Navia Logistics System

Project Description: A technology that provide logistics system support of client goods from source to destination

Responsibilities:

·         Provides custom report based on clients’ needs and format which are not included in the system.

·         Provides system custom SQL in retrieving transaction records

·         Prepares T-SQL functions and/or procedure on data mining.

·         Submits work to direct head for clients verification and testing.

·         Uses Slack and Outlook in communicating direct head.

·         Uses Trello on accepting, development and UAT of reports.

·         Uses Australia-based Logistics  System on deploying custom sql and reports.

Company Name: TALLECO.com, July 2012- January 2015

Address: Cebu Business Park, Cebu City Philippines, Tel. Nos. +6332-4122550, +6332-4122122

Position: Fulltime Software Developer

Project: Analytics Tracking System

Project name: JobTarget Analytics Tracking System

Project Description: A technology that tracks the number of clicks, visits and applies on client’s job posting webpage.

Project Duration: August 2012 – January 2015

Programming Duration: It takes 3 working days to code new ATS, 1 hour for testing and 1 hour deployment.  There were multiple ATS’s delivered during this period.

Responsibilities:

·         Analyze and prepare Perl and/or PHP code to proxy client’s career page

·         Troubleshoot Perl code that monitors client’s career page

·         Analyze data gathered with MySQL and T-SQL

·         Perform Unit Tests using PHP

·         Coordinate with QA on regression test

·         Request staging and production code deployment

·         Uses Tortoise SVN on source code sub-versioning

Company Name: University of Cebu-LM, June 2001- June 2011

Address: AC Cortes Avenue Looc, Mandaue City, Cebu, Philippines Tel. No. +6332-3467461

Position: Fulltime IT Teacher

Responsibilities:

·         Teach computer science/engineering to undergraduate courses:

o   Database Systems with IBM DB2-UDB, MySQL, T-SQL and VB6

o   Computer programming 1 with Turbo C

o   Data Structures with Java

Design and develop appropriate computer instructional material.
Quizzes
Laboratory projects
Major exams
Prepare students grades.
Company Name: CSK Trading, June 2006- April 2008

Address: J. Vera St., Cebu City Philippines, Tel. No. +639177236787

Position: Part-time Software Developer

Project: Production Costing and Inventory System

Project name: CSK Production Costing and Inventory System

Project Description: It is a DOS-based Production Costing and Inventory System

Project Duration: August 2006 – January 2008

Programming Duration: Three months development and testing.

Responsibilities:

·         Participate in the analysis and planning of the system

·         Design the system’s database using DOS-DBF/MS Access

·         Modify and Integrates reusable codes and/or functions in Clipper5/VB6 that can address specific programming needs.

·         Deploy program to the server and enable workstation access

·         Document the system and conduct user training

Company Name: Cebu Titan Surplus Incorporated, April 2003-May 2005

Address: Pakna-an Mandaue City, Cebu Philippines, Tel. No. +6332-2329166

Position: Part-time Software Developer

Project: Production Costing and Inventory System

Project name: Cebu Titan Surplus Production Costing and Inventory System

Project Description: It is a DOS-based Production Costing and Inventory System

Project Duration: April 2003 – May 2005

Programming Duration: Three months development and testing.

Responsibilities:

·         Participate in the analysis and planning of the system

·         Design the system’s database using DOS-DBF

·         Modify and Integrates reusable codes and/or functions in Clipper5 that can address specific programming needs.

·         Deploy program to the server and enable workstation access

Company Name: University of Cebu-LM, May 1996-May 1997

Address: AC Cortes Avenue Looc, Mandaue City Cebu Philippines, Tel. No. +6332-3467461

Position: Full-time EDP Programmer

Project: Enrollment System

Project name: UCLM College Registration System

Project Description: It is a DOS-based College Registration System

Project Duration: May 1996 – May 1997

Programming Duration: More than one year

Responsibilities:

·         Initiated LAN cabling with coaxial cable

·         Install and troubleshoot Novell-NT server

·         Install DOS-based workstations

·         Maintain College Database using Clipper5/Foxpro

·         Prepare modules that automate the archiving and retrieval of students record

·         Performs database backup and maintenance

IT CERTIFICATIONS

Certificate of Completion, MongoDB for Node.js Developers, MongoDB University, December 2013

Certificate of Completion, MongoDB for DBAs, MongoDB University, November 2013

Certificate of Completion, IBM Academic Initiative DB2 Information Track 11 April 2008

EDUCATION

Master in Information Technology (36 units), University of San Jose-Recoletos, Cebu City, Philippines, 11/2007-10/2009 GPA is 1.6

Master of Science in Teaching (42 units) – Computer Science, University of Cebu-Main, Cebu City, Philippines,  06/2001-03/2004 GPA is 1.5

PROFESSIONAL TRAINING

Certificate of Attendance, Positive Courseware Training for Database Systems 2 June 2006

Certificate of Participation, Algorithm Analysis and Design seminar-workshop 6-8 May 2004

Certificate of Completion, Short Course-Training on PHP 3 April 2004