Mark John I. de Villa

#*** ***** **.***** ** Gatchalian Subd. Las Pinas City

Phone: 632-***-****

Mobile: (632) 917-***-****

aczje6@r.postjobfree.com:aczje6@r.postjobfree.com

mailto:aczje6@r.postjobfree.com

OBJECTIVE

I seek to impart the experience and knowledge I gained from my vast work experience to help my company improve and realize their goals and objectives.

PROFILE

A software developer with more than 10 years of IT experience in programming such as VB, VBA, MS SQL, Oracle, Sybase SQL, Java, XML, etc, who pursue to lead in problem resolution and provide innovative solution.

TECHNICAL SKILLS

Programming

Languages

HTML, VB6, Crystal Report 10, Crystal Report 6, Crystal Report 7, Crystal Report 11, Perl, MS SQL 2000, MS SQL 2005, MS SQL 2008, SSIS, VBA – Word 2007 and Excel 2007, VB.Net 2005, Basic Core Java, xml, XSLT programming, xquery, webmethods, javascript, vbscript, Basic knowledge in MVC 4, Basic C# Programming, and web api

Operating Systems

Databases

Application Servers

Unix, Linux, Windows 98/ME/2000/2003/XP/Vista/7/8

Sybase SQL 12.5, MySQL, MS SQL 2000 / 2003 / 2005, MS Access/ Oracle 12.1, XML Database

Tomcat, .Net Framework, Windows Server such as 2000 and 2003, Tamino XML Server

EDUCATION

●Bachelor of Science in Computer Science Lyceum of the Philippines (June 1999 – March 2003)

PROFESSIONAL EXPERIENCE

Company: iResource Incorporated [August 15, 2016 – Present]

Projects/Client:

Sunlife Incorporated of Canada - (Taguig) [August 15, 2016 – Present]

Automates OLA Reports of ASCP team (Asia Sunlife Centre Philippines)

Position: VBA Analyst.

Responsibilities include:

●Automates, using VBA, manually created OLA reports, which the client is producing on a daily task.

Company: Total Information Management Corp. [August 05, 2015 – April 29, 2016]

Projects/Client:

BPI Head Office (Wolters Kluwer Financial Services Team) [August 05, 2015 – April 29, 2016]

Implements financial application called Summix, developed by WKFS.

Position: Senior Technical Consultant.

Responsibilities include:

●Sets up SL/GL Reconciliation module to make it work on the Summix software

●Modifies/Administers existing SSIS tool for ETL of BPI data going into Summix

●Updates views, sql jobs, scheduling, optimization, non-clustered indexing, etc.

Company: 77 Global Solutions Inc. [February 05, 2014 – March 31, 2015]

Projects/Client:

Deutsche Knowledge Services (EUDA Team) [February 05, 2014 – March 31, 2015]

Support for End User Development Application Project

.

Position: IT Consultant

Responsibilities include:

●VBA Support for existing EUDA tools for Manila based DKS clients

●Creates new VBA for whatever purpose it may serve for Manila based DKS clients

Company: KFORCE GLOBAL SOLUTIONS INC. [February 22, 2012 – September 25, 2013]

Projects/Client:

AIG Shared Services (SDI team) [March 25, 2013 – September 25, 2013]

The Project involves production support for SDI Middleware application

Position: IT Consultant.

Responsibilities include:

●Analysis and debugging of SDI application for AIG employees/clients

●Used VB, VBA(Excel), Batch Processing, and Sybase SQL as tools for assigned tasks

Amkor Technologies Inc. (ICS B2B team) [February 23, 2012 – February 21, 2013]

Creates XSLT transformations that handles XML data exchange format between business

Position: IT Consultant.

Responsibilities include:

●Debugs/Modifies/Enhances existing XSLT program.

●Creates new XSLT or service which is to be used both by the client and the company (Amkor) itself.

●Creates XQueries for Tamino Server – main XML database server that XSLT program uses.

●Creates/Modifies webMethods services to produce or enhance running time of existing business report process

●Keeps track of database activities/transfer and malfunction. Reports to designated people once spotted errors/problems

Company: SOFTWARE LABORATORIES INC. [August 22, 2011 – February 21, 2012]

Project/Client:

MISYS OPICS Application – BDO Private Bank [August 22, 2011 – February 21, 2012]

The Project involves debugging and enhancement

Position: IT Consultant.

Responsibilities include:

●Conversion of Oracle query to MS SQL 2005.

●Conversion and enhancement of Excel VBA application that connects with OPICS application

●Optimization of existing Oracle query

●Clustered and non clustered indexing of tables

Company: SOGA TECHNOLOGIES INC. [Sept. 2010 – August 19, 2011]

Project:

The Health and Environment Safety Information System (THESIS) [Sept. 2010 – August 19, 2011]

The Project involves debugging and enhancement

Position: Junior Software Engineer

Responsibilities include:

●Creation of VBA for excel that will support for migration of data to be entered on excel worksheet and then directly to THESIS application backend(database)

●Testing of THESIS application bugs and fixing end user complaints. Including those not yet seen by end users (VB.Net and ASP.net)

●Analysis of existing application and its database

●Did some application support for THESIS and other projects that will update designated users, via email (Auto Email Report)

Company: RCG IT Philippines [Sept 2009 – June 2010]

Project/Client:

Computron - Chartis Insurance Incorporated [Sept 2009 – June 2010]

The Project involves production support for Computron application

Position: IT Consultant.

Responsibilities include:

●Analysis and debugging of Computron application for Chartis employees/end users

●Sybase SQL script modification

●Unix shell scripting to retrieve files and important records

●Batch data retrieval through MS command shell

Company: PRIMOVER CONSULTANCY INC. [Aug 2008 – Aug 2009]

Project/Client:

BDO Leasing Applications [Aug 2008 – Aug 2009]

The Project involves production support and creation of supporting application for existing system

Position: IT Consultant.

Responsibilities include:

●Debugging existing application. Most application deals with loans.

●Creates enhancements from existing application that leads to a new version. Major modifications such as new functionalities, new information window, etc, will lead to application reconstruction and editing. Although the core stays the same, there could also be new modification on the database to accommodate the new feature. Minor modifications mostly deals with adding of new report from existing application setup

Company: CONCENTRIX TECHNOLOGIES INC. [May 2007 – July 2008]

Project:

Infos ERP Accounting Software [May 2007 – July 2008]

The Project is an unfinished accounting software with existing bugs included

Position: Lead VB Programmer

Responsibilities include:

●Debugging existing application. Most application deals with loans.

●Creates enhancements from existing application that leads to a new version. Major modifications such as new functionalities, new information window, etc, will lead to application reconstruction and editing. Although the core stays the same, there could also be new modification on the database to accommodate the new feature. Minor modifications mostly deals with adding of new report from existing application setup

CTPayroll Plus [Oct 2007 – July 2008]

Application that deals with payroll for the employees of Concentrix. Planned to be outsourced to other companies

Position: Lead VB Programmer.

Responsibilities include:

●Planned and assigned tasks to subordinates on creation of payroll application.

●Kept track of changes and unfinished tasks on the system

●Does some of the testing before release of build

●Acts as the medium between the end user who tests the software, and the programmers

●Does some assistance, such as creation of functionalities that is integrated in the system, to help ease out some workload to my subordinates.

●Provides feedback to company VP about the project’s status, both verbally and via report

Company: SANYO SEIKI STAINLESS STEEL INC. [Apr 2006 – Apr 2007]

Boss Inventory System [Apr 2006 – Apr 2007]

The Project was created from scratch, to keep track of incoming and outgoing materials from company’s warehouses.

.

Position: MIS Staff/Programmer

Responsibilities include:

●Created company’s first inventory system

●Suggests functions or enhancements for the application to the consultant lead

●Debugs errors reported by end users from dry run tests

MIS Tasks/Responsibilities [Apr 2006 – Apr 2007]

Aside from being a programmer, I was also assigned on a dual role of being an MIS associate as well

.

Responsibilities include:

●Sets up company’s primary inventory system for use everyday

●Troubleshoots basic pc problems and networking within the company

●Backs up database on specified times of the day

●Administers server such as troubleshooting and database restoration

Company: GESTALT CONSULTING INC. [Nov 2005 – March 2006]

Projects:

ERP Accounting Software [Nov 2005 – March 2006]

The Project is an unfinished accounting software with existing bugs included

.

Position: Programmer

Responsibilities include:

●Debugging of existing accounting software created for clients

Company: SYKES ASIA INC. [June 2004 – August 2005]

Projects/Job:

Position: Technical Support Representative [June 2004 – August 2005]

.

Responsibilities include:

●Assists customers troubleshoots handheld devices and the software package that is included with the unit.

Company: SPI TECHNOLOGIES INC. [September 2003 – December 2003]

Projects/Job:

Position: Documents Analyst [September 2003 – December 2003]

Sets up written work of an author to a book

Responsibilities include:

●Proof Reader – Reads and corrects wrong output that is generated in the document.

●Typesetter – Layouts the work of an author to a book.

Contact this candidate