JESUS COLLANTES GONZALEZ
Address : Lot 14 Block 18 Harrison Drive, Broadway Pines Executive Village,
Baranggay Mayamot, Antipolo City, Rizal, Philippines - 1870
Mobile
Email
: (-
:-
Position Applied for: Senior Oracle Application Developer
TECHNICAL SKILLS:
Fluent and Familiar Programming Languages:
Oracle Developer 2000 Forms
Advanced
Oracle Developer 2000 Reports
Advanced
Flash5
Intermediate
SQL*Plus & PL/SQL ORACLE
Advanced
Software Application Experience:
ORACLE Database and Microsoft ACCESS
Others:
Basic Computer Maintenance
Drafting
WORK EXPERIENCE:
Accenture
May 11, 2015 – January 15, 2017
Position
Project
Tasks
:
:
:
Software Engineering Associate Manager
Claims Project for an International Insurance Company
Subject Matter Expert (SME) for Oracle SQL and PL/SQL.
Code review.
Maintained Oracle Materialized Views (MVIEWS) needed for the project.
Managed database cleanup.
Back End
Tools Used
:
:
Oracle 10g
TOAD for Oracle for standard coding implementation
Project
Tasks
:
:
Metrics Dashboard Project for a Local Client
Business Analyst for the project.
Coordinated with the key stakeholders to identify project requirements.
Created initial draft of the project plan and Business Requirement
Specification (BRS).
Sun Life Financials (ASCP)
January 20, 2014 – July 20, 2014
Position
Project
Task
:
:
:
Consultant / Oracle PL/SQL Developer / Oracle Forms & Reports Developer
Agency Information System (AGIS)
Developed new and additional PL/SQL codes needed for newly created agent
bonus scheme in AGIS processing for Sun Life Indonesia.
Asian Development Bank
October 08, 2012 – March 15, 2013
Position
Project
Tasks
:
:
:
Consultant / Oracle PL/SQL Developer / ETL Developer
CRMS ETL
Developed and maintained PL/SQL codes needed for ETL processing.
SMART Communications, Inc.
September 29, 2011 – June 29, 2012
Position
Project
Tasks
:
:
:
Consultant / Oracle PL/SQL Developer
KENAN Billing System
Addressed ad-hoc request and reports needed by KENAN users.
ABS-CBN Broadcasting Corporation
November 26, 2009 – August 25, 2011
Position
Project/s
:
:
Tasks
:
Consultant / Oracle PL/SQL Developer
CRM Data handling and PL/SQL development
ECS Campaign Management System
Back End
Front End
Tools Used
:
:
:
Created and maintained database objects (Packages, Procedures,
Functions, Views, Tables, PL/SQL, etc.) needed for CRM data processing.
Extracted data from other sources by creating DTS packages using MySQL,
SQL Server and Visual Studio.
Uploaded data to Oracle using SQL Loader / DTS packages.
Created jobs and other objects using IBM Data Stage for data handling and
deduping.
Created backend objects (Packages, Procedures, Functions, etc.) using
Oracle PL/SQL to support the Campaign Management System (.net).
Created front end modules using Oracle Forms 9i to be used for viewing and
validating the results of the ETL processes being done on CRM data.
Addressed ad hoc request and reports needed by CRM.
Oracle 11g, Oracle 10g, Oracle 9i
.Net, Oracle Forms 9i
IBM Data Stage Designer, IBM Data Stage Director
TOAD for Oracle for standard coding implementation
MS MySql, MS SQL Server, MS Visual Studio
SGS Gulf Limited – ROHQ
August 19, 2008 – May 13, 2009
Position
Project
Tasks
:
:
:
Consultant/Reports Developer
Trade Works Discoverer Reports development
Back End
:
Created and developed new Discoverer reports based on client’s request.
Debugged existing Discoverer Reports based on updates, changes and
additional requirements identified by the business.
Created and developed new PL/SQL Functions that would help in the
Discoverer report development.
Debugged existing PL/SQL Functions that needed updates, changes and
modifications identified by the business to help in the new or existing
Discoverer report modifications.
Oracle 10g
Front End
Tools Used
:
:
Oracle Discoverer Viewer
Oracle Discoverer Desktop
Oracle Discoverer Administrator
Oracle Discoverer Plus
PL/SQL Developer & TOAD for standard coding implementation.
United Coconut Planters Life Assurance Corp
April 07, 2005 – August 19, 2008
Position
Project
Tasks
:
:
:
Consultant / Analyst
CIS-LIFE Individual Life Administration – Variable Life Product
Back End
Front End
Tools Used
:
:
:
Customization Team Lead for CIS Life - Variable Life Insurance product.
Checked existing codes to determine how the current CIS Life system
handles Variable Life.
Created System behavior documentation of modules and procedures, both
local and stored, for System Architect’s (SA) perusal.
Created Gap Analysis report based on the study of current system and the
company’s existing business rule on Variable Life.
Assisted the SA in determining gaps for future program customization.
Created reports needed for Variable Life fund movement monitoring.
Assisted in creating reports needed for CIS Life particularly Internal
Processing (IP) reports.
Studied other areas of the system that requires customization as far as the
Variable Life product is concerned. This includes stored and local procedures
being used by the system.
Coordinated with other consultants and programmers in identifying gaps
between the Variable Life system requirement and the current system.
Oracle 9i
Developer Forms 6i, Developer Reports 3.0
Developer Forms 6i, Developer Reports 3.0
PL/SQL Developer & TOAD for standard coding implementation
Family First, Inc. / Berkley International Philippines
2003 – April 07, 2005
Position
Project/s
:
:
Senior Applications Developer
Listbill System
Application used to generate both ADA (Bank accounts) and CBE (Credit
Card accounts) lists to be sent to banks for debiting and EPP (Employee
Purchase Payment accounts) list to be used by HR in deducting premiums
from employee’s salary. Premiums of aforementioned accounts are loaded
using this application.
PDC Billing System
Application used for encoding and loading premiums of PDC accounts.
Automated Rebill System
Application used in generating list for rebill of ADA and CBE accounts.
Chargeback System for Base Plan
Module used to make payment reversal for the base plan.
Chargeback System for Rider Plans
Module used to make payment reversal for the rider plans.
Tasks
:
Developed business applications using Oracle Forms for the company’s use.
Developed automated reports using Oracle Reports for management’s use.
Develop and create program units and objects using Oracle SQL Plus to be
used in application development.
Maintained existing applications based on current business rules and
processes.
Coordinated with third party representatives to determine and compare
business requirements to facilitate automation of inter-company transactions.
Coordinated with Business Development Group to discuss Business
Requirements of every application for development requested by users.
Developed and maintained ad-hoc applications and reports needed by both
management and application users.
Conduct unit and application testing of specified projects prior to deployment.
Back End
Front End
Tools Used
:
:
:
Oracle 8i
Developer Forms 6i, Developer Reports 3.0
Developer Forms 6i, Developer Reports 3.0
TOAD for standard coding implementation
Maintenance
:
All above mentioned applications
April 2001 – 2003
Position
Tasks
:
:
Junior Applications Developer
Developed business applications for the company’s use.
Developed and provided automated reports for management’s use.
Supervised and conducted user training.
Family First, Inc.
June 2000 – April 2001
Position
Tasks
:
:
Research and Development Supervisor
Supervised documentation of all in-house business applications.
Supervised and conducted user training.
Conducted in-house training in the use of Microsoft Office applications
Supervised and conducted research on various IT related topics.
Submitted proposals based on research outcome.
December 1998 – June 2000
Position
:
IT Support Specialist for Marketing / Mailing Supervisor
Supervised the preparation of the company’s mails.
Developed applications, using MS Access, needed in automating the daily
reports needed by the Marketing department.
Developed applications, using MS Access, needed for encoding activities.
Developed applications, using MS Access, used to automatically generate
list for mailing.
June 1998 – December 1998
Position
:
Personal Assistant to the Field Operations Manager
Supervised marketing activities of Field Operations Officers.
Prepared weekly commissions of Field Operations Officers.
Prepared handouts, promotional materials and other materials needed for
Field Marketing.
Spectrum Electronics Applications Corporation (SEAC)
1996 – 1997
Position
:
Telemarketer
Responsible for cold calling possible clients for the company.
Prepared weekly telemarketing activity report.
Developed application, using MS Access, used for telemarketing.
ICC Telecoms (Bayantel)
1995
Position
Tasks
:
:
Telemarketer
Responsible for cold calling of possible clients for the company’s IDD service.
Jesus Flock Academy
1991 – 1995
Position
Tasks
:
:
Teacher
Class supervisor to Primary and Intermediate students.
The Legacy Collections, Inc.
1987 – 1991
Position
Tasks
:
:
Draftsman / Assistant Supervisor
Responsible for designing brass furniture for the company.
Supervised the production line.
Responsible for estimating and ordering materials needed for production.
Served as Quality Inspector of all finished products.
EDUCATIONAL ATTAINMENT:
Primary
Secondary
College
:
:
:
St. Catherine’s Academy
Siena College of Taytay
Mapua Institute of Technology
CHARACTER REFERENCE
Available upon request.
I hereby certify the veracity of the above information.
Jesus C. Gonzalez
1972 - - – 1986