- Davao, PH
- £8 /hr
- Available now
Communicating effectively with stakeholders, analyzing the facts, identifying the critical issues, synthesizing solutions, and implementing on-time and on-budget are the keystonesmore...Communicating effectively with stakeholders, analyzing the facts, identifying the critical issues, synthesizing solutions, and implementing on-time and on-budget are the keystones of my delivery success. I get the job done effectively and efficiently across a wide range of disciplines and industries by taking the time to really listen to what clients have to say and being able understand their unique needs.
Area Covered: Europe, US, Asia, Australia, Etc
Work Experience Summary: May 2009 - May 2010
Kirean Solutions International, Inc.
#101 Narra St., Palm Village,
Obrero, Davao City 8000
Production Manager/Senior Programmer
ScanExpert Financial Products
Kirean targets a paperless office and help the financial and accounting world with its solutions and services for digitized documents. To achieve this goal, Kirean must make sure that their product must reduce time and cost for all administrative task by providing fast and accurate OCR software that fully integrates to any accounting system. Since there is a lot of accounting software and different customers, being the production manager and senior programmer, I need to make sure that all customer requirements must be gathered efficiently to create an optimize solutions by properly managing the available resources and people. Because our target is reduce paper work which is the future for every successful business.
Optimize code for OCR to support more invoices, receipts and bank statements Optimize ScanExpert libraries for faster processing
Completed and optimized the banking module
Completed payroll module
Customized Arco Document Management to meet Financial Requirements
Earn the trust and commitment of everyone to finished every project
Setup Kirean company and office process of davao office
Learn Abby flexilayout using self study and saves company 500Euro for each customized layout for invoices.
Create sustainable relationship with customers by helping them automate
Relevant skills/tech: SDLC, UML, Microsoft SQL Server 2005, C#, ORM, .NET Framework, Arco Document Management, VSS, Abby FineReader and Abby FlexiCapture, Java, Spring Framework, Spring.Net
May 2008 - May 2009
CES Partners Pte. Ltd
350 Orchard Rd., Suite 21-01/03 Shaw House
Business Analyst I
Land Registration Authority(LRA) Computerization
Scanning and Encoding System
LRA is now converting all Land Titles to electronic format in preparation for the computerization of all Registry of Deeds offices. With this, they have encountered a lot of problems with their current manual process. Most of the volumes that they created are returned for Reprocessing. To solve this problem, I communicate directly to the people of LARES and LRA and gather details of their requirements and identify problem on their current process. Convert a lot of their requirements into effective business design and created an efficient and effective workflow that would increase their productivity and output quality by more than 60% using G360 workflow management. I also customized G360 to meet their requirements using C#.Net.
Relevant skills/tech: SDLC, UML, Microsoft SQL Server 2005, C#, Hibernate.NET, Java, Hibernate, Spring Framework, Spring.Net, .NET Framework, Global360 Workflow Management, ITEXT.NET, NeroVision SDK
February 2008 - May 2008
Security Bank Corporation
Security Bank Building
Ayala Avenue, Makati City
The bank will be releasing a new Digibanker programmer for Small Medium Enterprise (SME) called Digibanker Lite. This program is a bundle of selected products/services that suites SME requirements. One of these services to be offered is the availability to pay its utility bills online through Realtime Electronic Payment System (REPS). The module will facilitate the online enrollment/nomination of selected merchants. This is to hasten the enrollment process for SME\'s and SME will no longer have to prepare a document but will just do an online enrollment subject to the defined Digibanker approval process (based on SME\'s funding matrix). Other project includes REPS Batch Upload, BIPPS Reports and REPS Merchant Payor Report.
Relevant skills/tech: SDLC, UML, Microsoft SQL Server 2005, ASP, ASP.Net, Visual Basic, Java, Spring Framework, Ajax, Struts Framework, Hibernate, Oracle, PL/SQL
Dec 2006 - Dec 2007
Danya Foods Limited (Arla Foods)
New Industrial City
P.O. Box 53164, Riyadh 11583, K.S.A
Danya Mobile Application Software
Manual entry of invoice and manual creation of receipt will cause a lot of problem for the accounting since they will be the one who will encode all the entries created by the salesman. There is a very big possibility that data that they entered will be inaccurate. To solve this problem, the decision to implement handheld computer for the salesman will be a very great advantage since the software created on the HHC will be tailored on the needs of organization and of the salesman. In this regard, the salesman can focus their attention on selling instead of writing manual entries; this will ensure that they can respond to a highly competitive marketplace. Since all they need is in the handheld (order creation, invoice creation, demand creation, receipt creation, printing), this will leverage them with other salesman thus becoming them more efficient. This system will automatically update the Attain ERP so no need for accounting to manually encode all invoice and receipts. Managers and supervisors can easily generate report at the end of the day to see the status of each salesman sales.
Relevant skills/tech: SDLC, UML, C#, VB.Net, ReportViewer, Microsoft SQL Server 2005, .NET Framework, .NET Compact Framework, Intermec Handheld Computer, Windows Mobile 2003, NHibernate (ORM)
Oct 2006 - Dec 2006
Smart Communications, Inc.
Ayala Avenue, Makati City, Metro Manila
Customer Solutions Platform (CSP) Inventory
The company needs a more stable and effective automated inventory management and monitoring system which requires recording of stock movement, from ordering, delivery, consumption and returns, ability to move stocks from location to another location, secured system, password-protected and ability to limit access, online real-time processing and multiple level of approval. To handle this feature, CSP Inventory was created. The CSP Inventory Module monitors the stock movements in each Wireless Centers. This system basically handles the life-cycle of the stock from Ordering, Delivery, Issuances, and Sales and up to After Sales.
1. Miscellaneous Stock Movement Module
2. Special Stock Movement Module
3. Stock Allocation Sales Channel
4. Stock Allocation Sales Channe\'s Stock Location
5. Generic Find Stock Movement Documents
6. Standardization of Ajax Implementation in CSP
7. Sub Menu implementation in CSP
8. CSP - Postpaid Sales Enhancement
Dec 2005 - Sep 2006
Prime Orion Philippines, Inc.
20th Floor, LKG Tower
Ayala Avenue, Makati City, Metro Manila
Tutuban Mall Interim Billing System
Located in Divisoria which is famous for its wholesale market, Tutuban mall have thousands of tenants which makes their monthly billing difficult. Their current system is a combination of manual computation which is prone to errors and causes a delay for the submission of the billing statement. To solve the current problem, we developed a 100% web based Interim Billing System that provides a secure, web based statement presentment and payment processing system. It will also provide the tenant and customer online access to their accounts. They can view their payment histories and print reports. In the future plan, customers can view their accounts and make payments online. With the online IBS, all stores in the mall can be queried for cumulative sales number and sales reports which will be available for the mall owner for each store.
March 2005 - Nov 2005
AMKOR Technology Philippines, Inc.
119 North Science Avenue
Laguna Technopark Inc. LTAI, Sta. Rosa, Laguna
Wafer Mount eFAI Enhancements
The need for fast and easy retrieval of manufacturing information to enable Amkor to respond to customers is the main drive for implementing Enhance Wafer Mount System at P1 TSSOP/TQFP line. Since Wafer Mount is deployed in P3 only, P1 FAI used manual filling up of the paper log sheets at wafer mount station, which is prone to incomplete and inaccurate filling up of data. I enhance the existing Wafer Mount eFAI system so that it will be easier to manipulate for PE\'s and operators by adding and modifying some program features & layout. Because of this enhancement, the system is easier to used and was able to improve cycle time for the P3 PE.
BMCS - Material Vendor Code Validation
Each lot and material that will be used must first passed BMCS. This validates the correctness of material for a lot. It is operated in such a way that operator scans the barcode of the lot and its lot details will be displayed by the system. Each lot has already been assigned with vendor specific material ingredients. The problem is that in MESA, materials that are alike but with different vendors may have the same SID. However, there is no way for the operator to know if they have used the wrong material. I enhance the BMCS to include material code validation to prevent the operator from using wrong material for the lot. Once operator scans the LTC, lot information will be displayed. Material vendor code will now be included in the lot information portion. Data will be available only if the material vendor code for the selected is station is applicable. Otherwise, this field will be blank. The enhancement reduces misoperation due to wrong material vendor used. Checking of material vendor for each lot to be processed will prevent the operator from using the same material with a different vendor.
Amkor Marking Design Software Winsock Integration
Currently, Amkor Marking Design Software (AMDS) accesses laser machines through mapping of required drives and/or folders configured as shared. The laser machines are accessed during laser mark file generation and laser logo enrollment for plant owners with enabled Centralized Laser Logo Enrollment. Computer viruses attack laser machines that are connected to LAN. Since AMDS requires the laser machines to enable drive and/or folder sharing to generated laser mark files, these machines become more vulnerable to virus attacks. These attacks result to marking quality discrepancies and machine downtimes. To eliminate drives and folder sharing, I will integrate Winsock to AMDS for laser mark file generation. The enhancement contributes in the increase of productivity due to the minimized laser machine vulnerability to virus attacks and reduces gross rejects due to laser mark issues.
Agere-Seagate S2 - 1\" HDD 2D Traceability Phase 1
Agere is one of the top suppliers of the Number 1 Hard Disk makers in the world, Seagate. Being Agere\'s major subcontractor, Amkor is identified to support Seagate\'s requirements for their new micro-drive product, an S2 - 1\" HDD with 10-gigabyte capacity. The Traceability project aims to provide all relevant data given a PCBA, a component or a wafer using the 2D barcode technology. For Example, all details related to a PCBA should be captured, like how many components are attached to it, what are these components, in what locations are these components attached, what machines are used, who are the operators responsible for processing the unit, when was the product processed, etc. Details related to a particular component or wafer should also be captured, like in which PCB\'s was it used, how many were used, etc. All traceability information shall be collected and sent to the end customer. With the growing technology and with the more complex products being developed, the need for traceability has increased. Most of the customers are not satisfied with the high level tracking strategy anymore. The system will send all traceability to the customer, even the smallest information that can possibly be tracked in the full development of their product.
Relevant skills/tech: SDLC, Unified Modelling Language, Visual Basic 6, ActiveX Data Objects, SQL 2000 Server, Microsoft Excel VBA-Macro, ODBC, Data Transformation Services and Stored Procedure.
Nov 2004 - Feb 2005
System and Software Consulting Group, Inc.
23/F Burgundy Tower
Senator Gil Puyat Street, Makati City
Bus Ticketing System
Current ticketing system used by the majority of bus operators is still paper ticketing system. This poses a big problem to the operators because they lose income when tickets are not properly audited by the conductors. To properly control tickets, a Bus Ticketing System must be developed. A Bus Ticketing System is a system that utilized a PDA that is attached to a portable PDA printer. A Point of Sale (POS) was created in the PDA using C++ that will compute the fare based on the distance. It will also print relevant information such as distance traveled (in km), fare, and control number that are given to the passenger. Each passenger transaction is stored in the PDA in Dbase format and is being synchronized in the defined bus terminal point. A front-end application was created in VB6 that will synchronize the data between the PDA and SQL server. Since fare is automatically computed and checker can automatically checked each ticket, it is much harder for conductors to cheat in the issuance of ticket to the passengers thus increasing income to the bus company.
Relevant skills/tech: SDLC, C++, Visual Basic 6, ActiveX Data Objects, SQL 2000 Server, Microsoft Excel VBA-Macro, ODBC, Data Transformation Services and Windows 2000.
Paperless Office through Hummingbird
With the worsening situation of graft and corruption in the Philippines, the president created another branch of government called Anti Money Laundering Council (AMLC). This branch will investigate all suspicious transactions in the Philippines that will allow them to investigate any account that is found in the watch list. The law required that all banks and pawnshops send all their transactions to AMLC. With the huge amount of data transmitted to AMLC, a system must be developed to automate the process of validating data. The data being transmitted must be automatically transferred to Hummingbird system. I designed and developed an application that will check all records that is under the watch list and the system will automatically generate a PDF Suspicious Transaction Report and automatically upload it into Hummingbird. This will automatically transfer the STR to the designated investigator. This increases productivity since investigator will not search a pile of documents because most of the reports that need to be investigated are automatically delivered.
Relevant skills/tech: SDLC, Java, Visual Basic for Applications (VBA) in Microsoft Office, Visual Basic, Crystal Reports, Active X Data Objects (ADO), Registry Tweaking, ETL, Oracle 9i and Windows/Third party API.
Aug 2004 - Oct 2004
Watson Wyatt Asia Pacific Shared Services Center
19th/F, Equitable Tower, Paseo de Roxas, Makati City
2004-2005 Asia Pacific Car Policy Survey
Watson Wyatt gives paper survey questionnaire to top 1000 companies and translates the data into information. With paper questionnaire, they manually compute the data which is prone to human errors. Stand-alone program is not also advisable since some companies do not like to run external program into their computers. The best way is to send them through excel file which contains the questionnaire. I designed and programmed a Car Policy Survey in Microsoft Excel using VBA. After the client finished filling up the questionnaire, the data is automatically sent to the server and automatically computed. This increased productivity since most of the data are automatically computed, the only thing they need to do is translate the data into information.
Relevant skills/tech: Visual Basic for Applications (VBA) in Microsoft Office, Active X Data Objects(ADO), Macro Programming and Windows API.
Nov 2003 - July 2004
Nestle Philippines Makati Center
#31 Plaza Drive, Rockwell Center, Makati City
SAP Data Standard & Conversion System
GLOBe, Global Excellence is the current project of Nestle that will transfer all AS400 data to SAP. With current AS400 data, many of the fields are useless and garbled and cannot be directly migrated to SAP system. With millions of records in AS400, standard must be formulated to clean-up data before being migrated to SAP. I developed a system that will validate AS400 data, fields by fields, records by records to ensure that data being migrated should be accurate and adhere to SAP requirements. All clean records is exported in Excel as loading sheet to be uploaded to SAP. The created system increases productivity by automating task through a set of rules provided by business analysts.
Relevant skills/tech: Visual Basic 6, ActiveX Data Objects, SQL 2000 Server, Microsoft Excel VBA-Macro, ODBC, Data Transformation Services and Windows 2000.
Jan 2003 to Jul 2003
Ilustre Street, Davao City 8000
Starex offers computer services by providing customer with continuous network connection. Their previous system network was poorly designed and bandwidth was not properly utilized to all computers. This decreased income since customers were unsatisfied with the service and caused complains because of poor internet connections. I redesigned network infrastructure to prevent loss of bandwidth and upgraded to DSL broadband connection to give customer high speed internet access. I installed additional security by adding firewall to prevent illegal access from outside, installed and optimized desktop systems to increase performance. This generates more income since customers are satisfied with the service and happy customer recommends Starex to their friends because of excellent services being offered.
Relevant skills/tech: Digital Subscriber Line (DSL), Hubs, Switches, Network Address Translation (NAT), TCP/IP, Domain Name Service(DNS), DHCP and cabling.
Jan 2000 - Nov 2002
The Little Lamb Schoolhouse
Bajada, Davao City 8000
The need of computer education for students prompts the school in buying computers. But computers will lose their usefulness if not maintained. And to utilize it properly, it should be connected with each other to properly share resources. Proper software must also be installed to allow students enjoy learning and restrict them from editing system files. Scheduled maintenance was formulated to provide users with a stable and trouble-free environment. This includes installation, upgrades and repairs and continuous network connection. This increase teacher\'s productivity when creating lesson plan/grades and enhance students learning experience through the use of technology.
Relevant skills/tech: Software router, Firewalls, VPN, Hubs, Switches, TCP/IP, DNS, DHCP and cabling.
Jun 1999 - Jan 2000
DIGIO Computer Services
Santa Ana St., Davao City 8000
One source of income in Davao City is through tourism. To have more tourists visit Davao, the city should advertise tourist spots. The cheapest and most economical way to do this is through a website which is visible all over the world. The current Davaoweb site is purely static, text based and dull. Once people visit the site, they normally do not return since they expect dynamic attractive site which is a balance of content and presentation. To make the site more active, a combination of popular script must be added to make it more dynamic and attractive. Design and layout graphical elements and organize the contents into groups and simplify user navigation. Since the site cater Davao City, the site theme of mostly the look and feel of Davao City. Since every browser has its own way of displaying the contents of the site, I created and followed design rules to ensure consistency on all browsers.
Education Summary: SEMINARS/TRAININGS ATTENDED
Dec. 13-17, 2004
Java 2 Enterprise Connectivity
New Horizons Computer Learning Center
10th Floor Robinsons Summit Center
6783 Ayala Avenue, Makati City
Dec. 6-10, 2004
Java 2 Programming Language
New Horizons Computer Learning Center
10th Floor Robinsons Summit Center
6783 Ayala Avenue, Makati City
Dec. 2-6, 2002
Software Engineering Training
Up Mindanao Office (formerly Terraza Mileza)
Rizal St., Davao City 8000
Nov. 18-22, 2002
Linux Training (Linux Study Group)
Claveria St., Davao City 8000
Nov. 14-15, 2002
3COM Certified Solutions Associate Training
Grand Men Seng Hotel
Magallanes St., Davao City 8000
2003 Ãƒï¿½ï’¿’½Ãƒï¿½Â’¢Ãƒï¿½Â’¯Ãƒï¿½Â’¿Ãƒï¿½Â’½Ãƒï¿½Â’¯Ãƒï¿½Â’¿Ãƒï¿½Â’½ Present Filipino Information Technology (Fil-IT)
Community of Filipino information technology professionals.
2000 - Present Greater Davao Jaycees (Junior Chamber)
An organization that helps develop leadership skills, social responsibility and fellowship necessary to create positive change.
1999 - Present Information Technology Society of Davao (ITS-Davao)
Community of local IT technology professionals.
Civil Service Professional
Cisco Certified Network Associate Examination
Cisco Certified Network Associate (CCNA) Cisco ID: CSCO10566234
Brainbench Certified Windows 98 Power User Transcript ID: 1051489
CISCO Networking Academy
AMA Computer College
Malvar St., Davao City 8000
Bachelor of Science in Computer Science
Ateneo de Davao University
Jacinto Street, Davao City 8000
Davao Christian High School
V. Mapa St., Davao City 8000
Davao Christian High School
V. Mapa St., Davao City 8000
Senior Software Developer