Developer System

I. PERSONAL INFORMATION

Name : Renato J. Ramos

Age : 46 yrs old Date of Birth : December 29, 1969 Sex : Male

Home Address : #* ********* **., ****** ****, Merville Park, Paranaque City

Place of Birth : Manila

Tel . No. : 8460977 (Res.), 091******** (Cell)

II. KEY QUALIFICATIONS

Employer : Moylan’s Insurance Representative Office.

Period covered : September 2009 – Present

Position Held : Assistant Manager, IT Unit for International Life Insurance Operations

Duties and Responsibilities:

Serves as consultant to executive level officers when it comes to developing and applying information technology policy and standards.

Supervises and directs the workflow of various teams of people. Assigns and prioritizes tasks to be performed by system analysts, computer programmers, and other support staff.

Oversees the upgrading and installation of system-related software and hardware related to internet.

Supervises the development, maintenance, and security of computer and information network systems.

Tests the integrity and performance of various information networks and software applications.

Periodically reviews and evaluates how current systems and applications are meeting the needs of the company or organization.

Identifies and implements new technologies to enhance the long-term operational and strategic goals of the company.

Application Systems of Moylan’s Insurance Underwriters, Inc. :

CIS–LIFE System

System Provider: Advance Digital Services

Database: Oracle

LifePRO Life Insurance Administration System Version 14.00

System Provider: Professional Data Management Again, Inc. (PDMA)

Database : Microsoft SQL Server database

SAM System

In-House developed

Database : Microsoft SQL Server database

Tools : Forms - Microsoft Visual Studio 2005 ; Reports - Crystal Report XI Rel. 2

Group Term Life Insurance

In-House developed

Database : Microsoft SQL Server database

Tools : Forms - Microsoft Visual Studio 2005; Reports - Crystal Report XI Rel. 2

InSoft General Insurance Systems

System Provider: Insoft New Zealand.

Database: Oracle

Tools : Report Builder 10.1.2.0.2; TOAD Ver 9.6.1.1; SQL*Plus: Release 10.1.0.4.2

Employer : Blue Cross Insurance Incorporated

Position Held : Systems Analyst / Programmer

Period covered : November 2006 – September 2009

Duties and Responsibilities

Creates stored procedures in (PM) Policy Master, (Unix)

Modifies existing stored procedures in Policy Master (Unix)

Creates various reports using Crystal Reports

Creates scripts for Data Migration

Performs data clean-up

Analyzes/interprets/converts current PM data to conform with (HBS) Health Benefit System requirements

Performs Tests of HBS Prototype

Reviews Operations Manual

Creates test scripts to validate expected results based on Operations Manual

Performs Testing of Online Functions, Batch and Report functions

Performs System Data Structure analysis ( Oracle)

Systems Developed

Broker Maintenance – system designed for maintaining Brokers’ Masterfile; application for Agency Department

Commission System – system designed for processing Brokers’ commissions; application for Accounting Department

Production Bonus System - system designed for processing the Production Bonus of Account Executives

Team Leaders\ Renewal Team Bonus – system designed for processing Incentives of Team Leaders and Renewal Teams; application for Accounting Department

Various Reports (Monthly Persistency Production Report, etc)

Tool/Environment

VB.NET (front-end)

Crystal Report ver. 8.5

ORACLE ver. 9i, SQL Server Ver. 8 (back-end)

Employer : Prudentialife Plans, Incorporated

Position Held : Systems Analyst

Period covered : September 2003 – August 2006

Consolidated CER System

Description

Application for Credit and Collection Department

System designed for Evaluation Collection Efficiency Rating for Sales Agents

Features of the System

Extraction, Reports, File and System Maintenance

Environment

Developer 2000 rel. 2.1 – Forms 4.5 and Reports 2.5 (front-end)

ORACLE ver. 8i (back-end)

MDFG Basic Commission Systems

Description

Application for Accounting Department

System designed for Processing of Basic Commission for MDFG Brokers

Features of the System

Extraction, Computation, Reports, File and System Maintenance

Environment

Developer 2000 rel. 2.1 – Forms 4.5 and Reports 2.5 (front-end)

ORACLE ver. 8i (back-end)

Position Held : Senior Programmer

Period covered : February 2000 – August 2003

Employer : Prudentialife Plans, Incorporated

Project/Systems Developed and Maintained

Plan Application Systems

Description

Application for the Plan Management Department

System designed for Processing of Plan Applications/Contract Policies

Features of the System

Extraction, Computation, Reports, File and System Maintenance

Environment

Developer 2000 rel. 2.1 – Forms 4.5 and Reports 2.5 (front-end)

ORACLE ver. 8i (back-end)

Collection Bonus Systems

Description

Application for the Credit and Collection Department

System designed for Processing of Incentives for Payment Collection efforts of Prudentialife

Area Managers

Features of the System

Extraction, Computation, Reports, File and System Maintenance

Environment

Developer 2000 rel. 2.1 – Forms 4.5 and Reports 2.5 (front-end)

ORACLE ver. 8i (back-end)

Collection Efficiency Rating Systems

Description

Application for the Credit and Collection Department

System designed to measure quality and quantity of the

Collection efforts of sales associates and to assists Area Managers in monitoring accounts sold

in their respective areas.

Features of the System

Extraction, Computation, Reports, File and System Maintenance

Environment

Developer 2000 rel. 2.1 – Forms 4.5 and Reports 2.5 (front-end)

ORACLE ver. 8i (back-end)

Basic Commission Systems

Description

Application for the Commission Section of the Accounting Department

Commission System designed for agents of Prudentialife

Features of the System

Extraction, Computation, Reports, File and System Maintenance

Environment

Developer 2000 rel. 2.1 – Forms 4.5 and Reports 2.5 (front-end)

ORACLE ver. 8i (back-end)

Credit and Collection Systems

Description

Systems for uploading/ updating of Point of Sales payments

and updating of Accounts Status.

Features of the system

Uploading, Extraction, Computation, Reports, File and System Maintenance.

Environment

Developer 2000 rel. 1.3 – Forms 4.5 and Reports 2.5 (front-end)

ORACLE ver. 7.2.3 (back-end)

Payments Systems

Description

Systems for inquiring, monitoring and maintaining payments made

by the Planholder

Feature of the system

Computation, Reports, File and System Maintenance.

Environment

Developer 2000 rel. 1.3 – Forms 4.5 and Reports 2.5 (front-end)

ORACLE ver. 7.2.3 (back-end)

Franchise Fee Systems

Description

Application for Credit and Collection Department

Commission System designed for Franchise Collector.

Feature of the system:

Computation, Reports, File and System Maintenance

Environment

Developer 2000 rel. 1.3 – Forms 4.5 and Reports 2.5 (front-end)

ORACLE ver. 7.2.3 (back-end)

Job Description : Provides computer support by analyzing business problems and making recommendations and

maintains the efficient operation of all automated office processes by designing and implementing

technical applications and advising on hardware and software purchases .

Position Held : Systems Programmer

Period Covered : September 1995 – January 2000

Employer : Prudentialife Information Systems, Inc.

Projects/Systems Name:

Payments Systems

Description

Systems for inquiring, monitoring and maintaining payments made

by the Planholder

Feature of the system

Computation, Reports, File and Systems Maintenance.

Environment

Developer 2000 rel. 1.3 – Forms 4.5 and Reports 2.5 (front-end)

ORACLE ver. 7.2.3 (back-end)

Billing Systems

Description

Application for Credit and Collection Department

System for generating Billing Notices for Planholders

Feature of the system

Extraction, Computations, Reports, File and System Maintenance.

Environment

Developer 2000 rel. 1.3 – Forms 4.5 and Reports 2.5 (front-end)

ORACLE ver. 7.2.3 (back-end)

Overdue Systems

Description

Application for Credit and Collection Department

System for generating Overdue Notices for Planholders

Feature of the system

Extraction, Computation, Reports, File

and System Maintenance.

Environment

Developer 2000 rel. 1.3 – Forms 4.5 and Reports 2.5 (front-end)

ORACLE ver. 7.2.3 (back-end)

Institutional Sales Systems (Crediting of Payment)

Description

Application for Credit and Collection Department

Application for Payment crediting of Group Sales accounts

Feature of the system

Extraction, Computation, Reports, File

and System Maintenance.

Environment

Developer 2000 rel. 1.3 – Forms 4.5 and Reports 2.5 (front-end)

ORACLE ver. 7.2.3 (back-end)

Reinstatement Systems

Description

Application for Credit and Collection Department

System for processing of Reinstating Lapsed Accounts

Feature of the system

Extraction, Computation, Reports, File and System Maintenance.

Environment

Developer 2000 rel. 1.3 – Forms 4.5 and Reports 2.5 (front-end)

ORACLE ver. 7.2.3 (back-end)

Sales Projection Systems

Description

Application for Credit and Collection Department

System for projecting expected payment collections

Feature of the system

Extraction and Reports generation,

Environment

Developer 2000 rel. 1.3 – Forms 4.5 and Reports 2.5 (front-end)

ORACLE ver. 7.2.3 (back-end)

Job Description : Analyzed, designed and coordinated the development of software systems to form the basis for the

solution of business, and Information processing problems through the use of electronic data processing machines.

TECHNICAL BACKGROUND

O/S

Windows 95/98/NT/XP, UNIX, MS-DOS

LANGUAGES

Oracle PL/SQL, SQL*Plus, Foxpro, Clipper, TransactSql, VB.NET

SOFTWARE

MSOffice (Word, Excel) FTP, CRT, Internet Explorer

UTILITIES

Oracle Development Tools: Developer/2000 Forms 5.0/4.5, Reports 10, SQL*Menu 5.0,

Graphics 2.5, Crystal Report XI Rel. 2

Database Administration Tools: SQLDBA, SQL Loader, Import/Export, MSSQL-Server, TOAD

III. EDUCATIONAL BACKGROUND

Adamson University B.S. Computer Engineering 1986 - 1991

San Marcelino St., Ermita

Metro Manila

IV. TRAININGS

Developing JAVA Web Applications

Active Learning, Inc.

September 02 – 09, 2013

Comprehensive Introduction to JAVA Programming

Active Learning, Inc.

August 26 – 30, 2013

Programming with Microsoft ADO.net

New Horizons Computer Learning Center Makati

August 2, 2007 - August 4, 2007

Programming with Visual Basic.net

Informatics Makati

June 27, 2007 - July 20, 2007

Structured Systems Analysis

Feb 22, 2003 – May 16, 2003

Ateneo Information Technical Institute

Apps Oracle Application Tuning Workshop

May 6&7,2002

Sql Wizard, Corporate Center, Makati City

Relational Analysis and Design

April 27, 2002; May 4, 2002

Trident Tower Sen. Gil Puyat Ave., Makati City

Oracle Discoverer Training

May 2 & 3, 2002

Trident Tower Sen. Gil Puyat Ave., Makati City

Basic HTML & Web Development Training

June 14 & 15, 1999

Trident Tower Sen. Gil Puyat Ave., Makati City

Oracle Forms 4.5, Oracle Reports 2.5, Oracle Graphics

December 1- 12, 1997

SQL Wizard (Makati City)

Clipper Programming

August – September 1994

Ateneo Computer Center

V. CAREER SERVICE EXAMINATION TAKEN

Subprofessional Examination Oct. 20, 1991 84.44 %

Professional Examination Dec. 08, 1991 84.75 %

Contact this candidate