Jessie Gonzalez

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