Resume

Sign in

Technical Support Developer

Location:
Pasig, National Capital Region, Philippines
Posted:
December 01, 2017

Contact this candidate

Melanio T. Rayanon Jr. (Rian)

Blk. * Lot ** Estrella Homes II Caloocan City, Philippines

Mobile No: (+63) 916-***-**** / (+63) 920-***-****

Tel. No. (+632) ***-**** / (+632) ***-****

Email Add: ac3jv1@r.postjobfree.com

An innovative, result-oriented IT professional, with more than 14 years of broad-based experience in IT business. An on site (client-based) developer for a relatively period of time, which illustrates the trust bestowed by the team members and superiors for the ability to communicate accordingly with the emphasis on building strong client association.

Extensive experience in handling various information technology projects ranging from systems development, quality assurance testing, implementation up to enhancement or

System Development Life Cycle (SDLC)

Proficient with PL/SQL, SQL programming languages, as well as with Relational Database Management Systems (RDBMS) such as Oracle v8, v8i, v9i, v10g, 11i and 12c.

Extensive hands-on experience with Oracle Tools such as SQL Plus, Oracle Forms & Reports and even PL/SQL Developer and TOAD Quest software.

Have handled and developed various bank system applications, insurance modules and freight forwarding systems and telecommunication systems. With excellent communication skills, great appreciation to learned more and continually driving towards performance of guaranteed quality.

TECHNICAL QUALIFICATIONS

Operating Systems:

Windows NT4.0, Windows ME, Windows 98,

Windows 95, Windows 2000, Windows XP, Windows Vista, Windows 7, Windows 8

Database:

Oracle 12c, 11i, Oracle 10g, Oracle 9i, Oracle 8i, MS SQL Sever 2000, Fox Pro

Software:

Oracle Developer ( Forms Builder v.10g, v.6i and v.5

( Reports Builder v.10g, v.6i

Oracle Developer 2000 (Forms Builder v.4.5

Reports Builder v2.5),

TOAD Quest v.9.5, SQL*Plus v.8, SQL Loader,

PL/SQL Developer v.10

Visual Basic .Net v.1.1, Visual Fox Pro v.6.0 v.5.0,

Fox Pro for DOS v.2.5

Tools / Utilities:

Oracle Developer 2000

Hardware:

Pentium IV / Pentium III, PC x86, Compaq Server, IBM 586, Pentium and Compatibles

Others:

Adobe Photo Shop v.6, Adobe Illustrator v.9, MS Office 97, 2000 and XP (MS Word, MS Excel, MS Power Point)

PROFESSIONAL EXPERIENCE

PRIMOVER CONSULTANCY SERVICES INC. May 2017 to November 2017

3rd Floor Erechem Bldg., Salcedo cor. V.A Rufino st.

Legaspi Village, Makati City, Philippines

A consulting company that provides manpower for client companies needing technical support.

From: May 2017 to November 2017

Position: I.T. Consultant / Oracle Developer Client: Veraction

Projects Handled: Inventory

Software / Tool: Oracle PL/SQL / PERL

Database: Oracle v.11g EER

Duties and Responsibilities:

Part of implementation team which provide user support

Create / revised stored procedure based on the code impact analysis.

Investigate user bug errors.

Prepare unit testing documents.

Prepare UAT documents

Prepare run guide document.

MANULIFE INSURANCE Philippines November 2016 up to May 2017

LKG Tower, Ayala Avenue

Makati City, Philippines

Duties and Responsibilities:

Support for system bugs and enhancement.

Revised existing procedures, packages and funtions

Prepare unit testing documents.

Revised existing report queries for optimization.

SOFTWARE LABORATORIES INCORPORATED. September 2015 to October 2016

6793 5TH Flr., Vicente Madrigal Bldg,.

Ayala Ave. Makati City,

Philippines

A consulting company that provides manpower for client companies needing technical support.

From: March 2016 to October 2016

Position: I.T. Consultant / Oracle Developer Client: Smart Telecommunication Inc.

Projects Handled: Inventory

Software / Tool: Oracle PL/SQL

Database: Oracle v.12c

Duties and Responsibilities:

Revised existing / creates SQLscripts for cron job (data warehousing).

Prepare unit testing documents.

Prepare UAT documents

Prepare run guide document.

From: September 2015 to March 2016

Position: I.T. Consultant / Oracle Developer Client: PLDT.

Projects Handled: Inventory

Software / Tool: Oracle PL/SQL

Database: Oracle v.10g

Duties and Responsibilities:

Revised existing procedures and scripts.

Prepare unit testing documents.

Support for system bugs.

JACM SOFTWARE SERVICES. January 2011 up to September 2015

Rm. 1709 Tycoon Bldg., Pearl Drive Street

Ortigas, Pasig City,

Philippines

A consulting company that specialized in Business Process Outsourcing (BPO).

From: Jan. 2011 up to September 2015

Position: Oracle Developer

Software / Tool: Oracle PL/SQL

Database: Oracle v.11i

Duties and Responsibilities:

Responsible for Creation of requested PL/SQL scripts.

Revised existing stored procedures.

Documents technical PL/SQL scripts.

Ensure that PL/SQL scripts are optimized and used by users effectively.

Fixed or support for system bugs.

Basic SQL tuning.

SOFTWARE LABORATORIES INCORPORATED. September 2008 to December 2010

6793 5TH Flr., Vicente Madrigal Bldg,.

Ayala Ave. Makati City,

Philippines

A consulting company that provides manpower for client companies needing technical support.

From: July 2010 to December 2010

Position: I.T. Consultant / Oracle Developer Client: SMART COMMUNICATION INC.

Projects Handled: MPG (Mobile Payment Gateway)

Software / Tool: Oracle PL/SQL

Database: Oracle v.10g

Duties and Responsibilities:

Responsible for Creation of MPG (PL/SQL) scripts.

Revised existing procedures and scripts.

Prepare unit testing documents.

From: September 2009 – June 2010

Position: I.T. Consultant / Oracle Developer Client: ABOITIZ ONE INC. (2GO EXPRESS)

Projects Handled: CLAIMS System

Software / Tool: Forms, Reports and PL/SQL

Database: Oracle v.9i

Duties and Responsibilities:

Revised stored procedures / Packages (PL/SQL Scripts) needed by the system.

Provide user interview for module request and provide user support.

Revised and create Browser for user report request.

Migrate CLAIMS System to a newer version of Oracle Forms.

(From Oracle Forms v.6i to v.10g version.)

Conducting user acceptance training.

Deploying the finish product to the CLAIMS users.

Provide documentation such as user manual and other documentation needs.

Ensure that module application are optimized and used by users effectively.

From: June 2008 to April 2009

Position: I.T. Consultant / Oracle Developer Client: SMART COMMUNICATION INC.

Projects Handled: Kenan Billing System (Back End)/Customer Service Platform (Front End)

Software / Tool: Oracle PL/SQL

Database: Oracle v.9i

Duties and Responsibilities:

• Responsible for Creation of Data Migration scripts.

• Responsible for test data creation for JAVA developers

• Revised stored procedures / Packages (PL/SQL Scripts) needed by the system.

• Assign as one of the production support for KENAN Billing System (Back End).

• Created adhoc scripts to correct error data's (data fix).

• Upload (DAT) files to Oralce tables using SQL LOADER.

GLOBAL QUEST CONSULTING GROUP INC. September 2007 to June 2008

Stanford Street, Cubao Quezon City,

Philippines

A consulting company that provides manpower for client companies needing technical support.

Position: I.T. Consultant / Oracle Developer Client: MANULIFE INSURANCE Philippines

Projects Handled: Manulife Integrated Collection System (MICS)

Client Administration System (CAS)

Agent Management System (AMS)

Software / Tool: Oracle Developer Forms v.10g v.6i and Reports v.6i and PL/SQL

Database: Oracle v.9i

Duties and Responsibilities:

Mainly focus on enhancement of MICS system.

Maintained and enhanced other system requirements.

Provide user interview for module request / Provide user support

Revised stored procedures / Packages (PL/SQL Scripts) needed by the system.

Perform Unit and Integration Testing.

Enhanced application based on defined systems architecture standard and methodology.

Resolves issues with business user on the project being handled.

Part of the team to migrate form v.6i to forms v.10g.

PRIMOVER CONSULTANCY SERVICES INC. March 2007 to September 2007

3/F Erechem Bldg. cor. Salcedo and V.A.

Rufino Street Legaspi Village,

Makati City, Philippines

A consulting company that provides manpower for client companies needing technical support.

Position: I.T. Consultant / Oracle Developer Client: FIRST LIFE INSURANCE INC.

Project Handled: Life Insurance For E-business (LIFE) Group Life System

Software / Tool: Oracle Developer Forms v.6i and Reports v.6i and PL/SQL

Database: Oracle v.9i

Duties and Responsibilities:

Perform analysis and development of modules on agreed user specifications

Perform impact analysis on the system to implement the changes for the new project

Revised existing procedures and scripts.

Revised existing modules (Forms and Reports).

Provide user support.

Conducted user acceptance training (UAT).

Provide documentation such as user manual and other documentation needs.

Ensure that module application are optimized and used by users effectively.

Resolves issues with business user on the project being handled.

Position: I.T. Consultant / Oracle Developer Client: SUNLIFE FINANCIALS

Project Handled: Client Record Management System (CIF)

Software / Tool: Oracle Developer Forms v.6i and Reports v.6i and PL/SQL

Database: Oracle v.9i

Duties and Responsibilities:

Responsible for module development and enhancement.

Creates module according to given specs.

Provide technical document for created module.

Maintained and enhanced CIF Management System.

Provide user support to the system.

INFORMATION PROFESSIONAL INCORPORATED July 2006 to October 2006

Rm. 1904 19th floor Herrera Tower

VA Rufino cor. Valero St.,

Salcedo Village Makati City, Philippines

A consulting company that provides manpower for client companies needing technical support.

Position: I.T. Consultant / Oracle Developer Client: SQL WIZARD INCORPORATED

Project Handled: Phoenix System

Software/Tool: Oracle Developer Forms v.6i and Reports v.6i and PL/SQL / Oracle

Designer

Database: Oracle v.9i

Duties and Responsibilities:

Revised existing procedures and scripts.

Revised program unit of particular module in Oracle Designer.

Provide on site support to Phoenix client.

Developed and maintained module assignment

Ensure that module application are optimized and used by users effectively.

Provide technical documents for certain revised or created module.

PRIME TECHONOLOGY SPECIALIST INC. February 2006 to June 2006

Unit 1106-1107 City Land Shaw Tower

Shaw Boulevard cor. St. Francis Street

Mandaluyong City, Philippines

A consulting company that provides manpower for client companies needing technical support.

Position: I.T. Consultant / Oracle Developer Client: International Exchanged Bank

Project Handled: Migration of GL System

Software / Tool: Oracle Developer Forms v.6i and Reports v.6i and PL/SQL

Database: Oracle v.9i

Duties and Responsibilities:

Create / revised stored procedures (PL/SQL Scripts) needed by the system.

Developed reports for General Ledger and Accounts Payable

Revised existing procedures and scripts.

Create GUI reports v6i and interface it in Oracle Applications

Revised / enhance existing GL reports (Trial Balance and Transaction Journals)

Investigates unbalance amount in Trial Balance and Transaction Journals.

Uploading text data in the table using SQL Loader.

ABOITIZ ONE INC. (2GO EXPRESS) May 2005 to January 2006

Aboitiz Air Transport Hangar

General Aviation Area

Manila Domestic Airport

Pasay City, Philippines

One of the largest inter-island movers of Cargo and Couriers in the Philippines.

Position: Information System Specialist

Project Handled: eQuikAir and Zip Inc

Software / Tool: Oracle Developer Forms v.6i and Reports v.6i and PL/SQL

Database: Oracle v.9i

Duties and Responsibilities:

Created new module applications as per users requirement

Study and review existing system applications.

Conducted interviews with the user, study impact analysis as a part of system

analysis.

Created some stored procedures (PL/SQL Scripts) needed by the system.

Revised existing procedures and scripts.

Table designing, screen designs and study business process.

Created reports requirements using TOAD.

Conducted user acceptance training.

Deploying the finish product to the users nationwide.

Provide documentation such as user manual and other documentation needs.

Ensure that module application are optimized and used by users effectively.

ROCS TECHNOLOGIES INC. October 2003 to April 2005

Unit 711 7/F City Land Shaw Tower

St. Francis St. Cor. Shaw Blvd.

Mandaluyong City, Philippines

A consulting company that provides manpower for client companies needing technical support.

Position: Consultant / Oracle Developer Client: Grepa Life Insurance

Project Handled: Client Information System (CIS)

Software / Tool: Oracle Developer 2000 Forms v4.5 and Reports 2.5

Database: Oracle v.9i

Duties and Responsibilities:

Study system applications support and evaluation.

Involved in development of new module applications as required by the company.

Study and review existing system applications and suggest improvement.

Ensure that module application are optimized and used by employee effectively.

Provide documentation such as user manual.

DBP DATA CENTER INC. (DBP-DCI) July 1999 to October 2003

4th Floor EBC Building

Sen. Gil Puyat Ave. cor Makati Ave.

Makati City, Philippines

A software-house affiliated with the Development Bank of the Philippines. It services the data processing requirements of the bank, engaged in the development and implementation of computer-based system to different institutions and also provides manpower for client companies needing technical support.

Position: Programmer II

Project Handled: Loans Executive Information System, Manually Service Utility System,

Deadline Tracking System, Payroll System, Personnel Information

System, New Central Liability System and Retail Loans Management

System

Software / Tool: Oracle Developer Forms v6i and Reports v6i, Visual FoxPro and Visual

Basic .NET

Database: Oracle v.8i, MY SQL, Visual FoxPro Database

Duties and Responsibilities:

Responsible for creation system up to the maintenance of the system (SDLC).

Performs unit testing, coding of scripts, User Acceptance Training Implementation

and Enhancement of the system.

Perform users investigation for a particular module request.

Update Detailed Document and System Architecture based on changes during module construction

Prepare test data and thoroughly test coded programs to validate accuracy.

Keep the modules responsive to user’s need and to assure efficient operation in the production environment.

Works with a team to develop and implement systems by following programming standards and methodology.

Creates a program that converts Visual FoxPro data into text file and then loaded it into Oracle tables using SQL Loader.

Development Projects:

Loans Executive Information System (L.E.I.S.)

A system that establishes a databank on the overall credit portfolio of the bank and may be retrieved in formats required by the senior management. This includes wholesale and retail loan accounts being handled at head office and loan-servicing branches. It provides senior executives direct on-line access to loan information relevant to their decision-making activities. The system is comprised of two modules: the Merger Module and the Executive Module. The LEIS-Merger Module facilitates data extract from feeder systems and file update by batch. The LEIS-Executive Module shall comprise the query and report modules for access by the senior executives. (September 2001 - April 2002). Software / Tool: (Oracle Developer Forms 6i and Reports 6i)

Manually Service Utility System (ManServ)

The Retail Loan System is a transaction processing system used at TP to handle booking and processing of retail loan accounts transaction. However, there are accounts which are not catered by the system, and are manually serviced. These accounts are booked in the Journal Ticket System (TKTS). The New Central Liability System is a reporting system that consolidates data pertinent to loans. All loans data including manually secured accounts (ManServ) are input to the system. This necessitates the development of a utility to capture ManServ data. (February 2001 to April 2001).

Software / Tool: (Oracle Developer Forms 6i and Reports 6i)

Deadline Tracking System (D.T.S.)

System design primarily record the internal and external communications received. Task can be assigned to an individual within a department, or on a personal capacity. (September 2000 to December 2000). Software / Tool: (Visual FoxPro v.6)

Payroll System (P.S.)

Integrated packaged system designed to minimize the manual tasks in the processing of DBP rank and file employees and DBP officers payroll. (December 1999 to April 2000) Software / Tool: (Visual FoxPro v.6)

Personnel Information System (P.I.S.)

System used in monitoring personnel actions related to the maintenance of the plantilla file, updating of employee data, and the recording of all personnel movements from hiring to separation. It also provides input data needed in the processing of Provident fund and payroll and generates reports required by the users within and outside DBP concerning personnel information. (July 1999 to December 1999)

Software / Tool: (Visual FoxPro v.6)

Maintenance Projects:

New Central Liability System (N.C.L.S.)

The New Central Liability System is a reporting system that consolidates data pertinent to loans. Software / Tool: (Visual FoxPro v.6)

Retail Loans Management System (RLMS)

The Loan Management System for Retail was conceived as a part of the banks Information System Plan (ISP). This is further aligned with the objective of allowing senior management, bank officers and staff to access timely, significant and accurate loan information vital in making important informed decisions and prevent over exposure due to delayed, incomplete and inaccurate information.

Software / Tool: (Visual Basic .NET v1.1)

TRAININGS ATTENDED:

ORACLE DEVELOPER 2000

DBP-Data Center Inc.

Executive Building Center,

Makati City, Philippines.

February 2000 - April 2000

VISUAL FOXPRO v6.0

DBP-Data Center Inc.

Executive Building Center, Makati City, Philippines.

May 1999 - June 1999

PROGRAM LOGIC FORMULATION and EDP CONCEPTS

DBP - Data Center, Inc.

Exec. Bldg. Center, Makati City, Philippines. May 1999

EDUCATION

Bachelor of Science in Commerce (B.S.C) Major in Computer Science

Arellano University, Manila, Philippines

March 1998



Contact this candidate