Profile

Tech Lead with more than 14 years track record of successfully designing, developing, system analysis and administrating system applications for mid to large scale, both local and international companies.

Qualifications Summary

• Years of experience in systems design and development using Object Oriented Programming Method, particularly enterprise solution in client server environment.
• Years of experience in database design, backend SQL programming, writing queries, triggers, stored procedures, functions, creating tables and views, etc.
• Years of experience in reports programming that includes data manipulation and warehousing.
• Years of experience managing projects, from design to implementation.
• Years of experience in systems analysis.
• System Implementation, testing, documentations and conducting training for the users both individually and in - group.
• Proven ability to quickly learn and apply new technologies.
• Strong strategic planning and analysis.
• Ability to work under pressure, manage multiple projects and beat deadlines.
• A self-starter, a motivated team lead/player, well-organized, strong work ethics, and willingness to go the extra mile to help the team in achieving employer objectives, without sacrifice to quality.
• Motivational leadership style that delivers results.

Skills

• Tools used: Powerbuilder 6,7,8,9,10,10.5, Crystal Report 8.5, 9, Macromedia Dreamweaver MX, Macromedia Flash MX, Adobe Photoshop 5,6,7,CS2/4/5, HotMetal Pro, Director, MS Office, Moray, Povray, Visio, Citrix.
• OS: Windows 2000/NT/VISTA/XP/7, Macintosh.
• Database Server: Microsoft SQL Server 7/2000/2003/2005/2008, Oracle 7,/10g, EAServer, Sybase SQL Anywhere, Sybase Adaptive Server Enterprise, PostgreSQL., MS Access, Btrieve
• Database Administration: Installation, Trouble shooting, Database backup and Recovery, Import/Export, Data Transformation Services DTS, creating Jobs, etc.
• Database Programming/SQL Programming: Creating Triggers, Stored Procedures and Functions, Views.
• Functional knowledge of PL/SQL, HTML, Perl, Visual Basic, C, Powerbuilder 11 12

Projects:

Confidential

Description: Team Lead - Doing high level support which includes system analysis, bug fixing, data conversion, database programming, and doing development/enhancement for the client's applications.

Environment: Powerbuilder 6.5/9/10.5, Sybase ASE, Oracle 10g, MS SQL Server 2000/2005, Citrix, Unix, Pearl

Confidential

Description: Decommissioning of existing financial applications, eliminating redundancy, migrating functionalities from one application to another.

Job Descriptions:

• Doing Systems and database analysis to determine which functionalities to be migrated and which are obsolete.
• To determine if the application is to be decommissioned/retired or needs to be modified and migrated to another application.
• Doing Gap Analysis between Applications for data migration.
• Doing Field and Code Mapping.
• Doing Documentations for Analysis Result and Systems Design.

Environment: Powerbuilder 9, Powerbuilder 6.5, Sybase ASE, Oracle 10g, Citrix, Unix, Pearl

Confidential

Elance is the leading site for online work where businesses connect with independent professionals to get work done. Businesses and Companies post their work or project in elance, while professionals use Elance to meet clients, bid for project, stay independent and get paid for delivering great results.

Projects:

Confidential

• Description: Tilt Demon is a silent program that works in the background, tracking your winnings and losses through your Holdem Manager Database and allows you to set limits such as amount lost, amount won, bb's lost or won, time played and hands played and also a trailing loss where it calculates your loss from the highest point in a session. For more information please visit the site
• Job Description:Doing Enhancements/Modifications for this Poker Game Stopper Application that includes programming and debugging of the system. Database Design and SQL programming. Systems testing and implementation.

Environment: Powerbuilder 9, Sybase SQL Anywhere, PostgreSQL 8.3/8.4, visual C

Confidential

Job Description:

• Migrated a Human Resources application from PowerBuilder 5 to 9.
• Debugged other systems issues that arose.
• Programmed/Configured and Implement the new application into production.

Environment: Powerbuilder 9 and Sybase SQL Anywhere 8 later migrated to .NET

Confidential

Countdown Counter System

Description: The system is use for the church's countdown, it allows the user to customize the time the counter will start and stop running, and can Add, delete and replace pictures that show every minute. Managing the project from design, programming to implementation.

Environment: Powerbuilder 10.5, Sybase SQL Anywhere

Confidential

• Organization: Prime Technology Specialists Inc.
• Units 1106-1107 Cityland Shaw Tower, Shaw Boulevard cor. Saint
• Francis St., Mandaluyong City
• 63 2 633-6280
• Company Assigned: Bahay Financial Services
• 22 24th Flr. BPI Bldg. Cor Buendia and Makati Avenue
• Makati City. Philippines 63 2 750-3888
• Account Management System AMS
• Description: The System is a Financial Management System for mortgage financing Company that includes collections, payments, valuations, property audit, account monitoring, etc.
• Team Leader Group is responsible for Systems Analysis, Enhancement, Monitoring and Maintenance of mortgage financial Systems. Backend or Database SQL Programming, Creating Database Jobs, Triggers, Stored Procedures. Email Automation - email alerts for Account Specialists and report automatically emailed to the Special Collection Department.

Environment: Powerbuilder 9/10, Java, MS SQL Server 2000, MS SQL Server 2005 later migrated to Oracle 10g

Confidential

• Responsible for the whole development of the system.
• Tracks total sales/Income daily, weekly, monthly and yearly. It generates Sales Comparison, and different kinds of Reports. It is interfaced with barcode scanner use for data entry and validation.
• Description: The System monitor all record of all medicine stocks, sales, returns.
• Managing the project from analysis, design to implementation.
• Database Modelling.
• Business Analyzation for Systems Design.
• Development of the System.
• System implementation and users training.

Environment: Powerbuilder 9, SQL Anywhere 9

Payment Distribution System

Description: The System monitors all product distributions, client orders, payments and provides daily, weekly, monthly, yearly reports of sales.

Responsible for the whole development of the system.

• Managing the project from analysis, design to implementation.
• Database Modelling.
• Business Analyzation for Systems Design.
• Development of the System.
• System implementation and users training.
• Backend/Databse SQL Programming that includes triggers, stored procedures, and creating jobs.

Environment: Powerbuilder 9, Sybase ASE 12, Citrix

Confidential

Responsible for the following:

• Development and System design.
• Managing the project, from analysis, design to implementation.
• Database Modelling and Design.
• Business Analyzation for Systems Design.
• System Implementation and Maintenance
• Database Server Administration.
• Doing Import/Export of datas using DTS. Regular database backup and restoration.
• Database SQL Programming that includes Creating Triggers, Stored Procedures, Jobs for faster data manipulation and monitoring activities.
• Database securities and controls by providing user authentication that includes permission validation.

Environment: PowerBuilder 9, Citrix, Microsoft SQL Server 2000, Crystal Reports

Confidential

Responsibilities:

• Systems Analyzation and made some modules for Enhancements.
• Backend/Databse SQL Programming that includes triggers, stored procedures, and functions.
• Systems Support that includes Database administration, data fixing and making some reports if needed.

Environment: Powerbuilder, Sybase SQL Anywhere, Crystal Reports, Oracle backup database for the ads

Confidential

Responsible for the whole development of the system.

• Managing the project from analysis, design to implementation.
• Database Modelling.
• Business Analyzation for Systems Design.
• Development of the System.
• System implementation and users training.

Environment: PowerBuilder 7, Adaptive Server Anywhere 6.0

Confidential

Responsible for the following activities:

• Development of a module for merging of files from region to manila and vice versa. Files are transferred using a dial up facility and then merge it to the live files updating all concern files for security purposes.
• Development of a module for image capture. This is for capturing each applicant's photo, that will be process and save to the database. Development of a module for fingerprint scanning. This is use to capture each applicant's finger prints. It was made using powerbuilder 5.0 and with the used of Rollfinger Print Scanner. Includes a Dll file made using C language that is called in the main program.
• Development of a module called PMIS Printing. This generates a report for those clearances ready for evaluation, to be check if a particular applicant will be permitted to have a clearance or not.

Environment: Microsoft C v.8, PowerBuilder v5.0, Btrieve Manager v6.0, Novell Netware 3.12/4.11

Land Transportation Driver's License System

Description:

The system generates Confidential with applicant's photo, signature, and 2-dimensional barcode security. Applications are referenced and cross-checked against a nationwide database of criminal records, hooked up to a 3270 gateway connection with an IBM 4381. Remote agencies using dialup file transfer facilities.

Responsible for the following activities:

• Development of image capture module. This is used for capturing each applicant's photo specifically new applicants for same day release of driver's license.
• Module for Importing/Exporting Data from different region to the main office.
• Environment: PowerBuilder 5.0, Oracle 7, Windows Programming using C language
• Computerize Qualifying Examination System
• This system is an in-house system used for online testing given to the applicants. It generates a report regarding the result of each exams as well as the final evaluation of who passed the exams.
• Responsible for whole system development.

Environment: PowerBuilder 5.0, Sybase SQL Anywhere 5.5