Insurance Data

HERBERT RONAN V. CRUZ

*** ***** **., **. ***** Morong, Rizal

091********; 441-7444 (local 7584)

Email add: ******@**********.***.**; *************@*****.***; ************@*****.***

WORK EXPERIENCE

July‘2015 – Present

SOCIAL INSURANCE OFFICER II

Philippine Health Insurance Corporation

709 Shaw Blvd., Pasig City

Responsible in data extraction, managing data warehouse and BI dashboard, support PhilHealth Central Office and PROs and performs other related task that may be assigned by the supervisor from time to time.

October‘2012 – Jun‘2015

INFORMATION TECHNOLOGY OFFICER II (SG-22)

Philippine Health Insurance Corporation

709 Shaw Blvd., Pasig City

Responsible in data extraction and report generation, managing data warehouse and BI dashboard, support PhilHealth Central Office and PROs and performs other related task that may be assigned by the supervisor from time to time.

November‘2008 – September’2012

INFORMATION SYSTEMS ANALYST II (SG-16)

Philippine Health Insurance Corporation

709 Shaw Blvd., Pasig City

Responsible in data extraction, uploading of data, back-up database, create new user account, assist in managing user account granting roles, reset passwords and unlock account, support PhilHealth Central Office and PROs and performs other related task that may be assigned by the supervisor from time to time.

December ‘2000 – October’2008

AUDITING SYSTEMS SPECIALIST I (SG-13)

Philippine Health Insurance Corporation

709 Shaw Blvd., Pasig City

Responsible in data and information gathering needed in the audit to ensure that the system will operate in conformity with the design. Review, evaluate and analyze the fund utilization/disbursement in the Central Office and PhilHealth Regional Offices. Conduct cash examination to prove the accuracy of the cash report in PhilHealth Regional Offices. Verify the correctness of the outstanding accounts payables and unliquidated cash advances. Assist in the verification if all financial transactions are properly and correctly taken-up in the books of accounts. Verify if all financial transactions are properly funded. Prepare audit working papers. Assist in the conduct of the review sampling of financial transactions as to its legality and correctness and performs other related task that may be assigned by the supervisor from time to time.

I.T. COORDINATOR

PhilHealth (Internal Audit Department)

Responsible in performing the 1st level troubleshooting of I.T. equipment problem, updating software, coordinate with MIS Department regarding I.T. related concerns and preparation of hardware and software allocation matrix.

OTHER AFFILIATIONS

SYSTEM ANALYST

Flatworld Digital Systems Corporation (Flatworld)

www.flatworlddigital.com

Current Project

Database driven website for an online examination system (joint venture project of Flatworld with Eightpoint, Inc., an Illinois, USA based entity.

Website of Christ Livingstone Ministries Inc.

July ‘2000 – November ‘2000

DATA CONTROLLER – ENCODER (UNIT HEAD) (SG-10)

Philippine Health Insurance Corporation

709 Shaw Blvd., Pasig City

Supervises the entire unit by monitoring output and attendance. Assist the Section Heads in maintaining the workflow of the unit. Entertain clients in updating their records for premium payment. Provides information from walk-in members and phone inquiries, Prepares weekly and monthly reports. Performs other related tasks that may be assigned or delegated by the Division Chief.

July ‘1999 – June ‘2000

DATA CONTROLLER II (SG-8)

Philippine Health Insurance Corporation

709 Shaw Blvd., Pasig City

Review and screen Employers Remittance Report per employees Contribution as to amount and updating of Employers Quarterly Records. Performs other related tasks that may be assigned by the Unit Head.

April ‘1999 – June ‘1999

CLERK (SG-6)

Philippine Health Insurance Corporation

709 Shaw Blvd., Pasig City

Receives Premium contribution reports from PhilHealth Regional Offices. Answers the communication letter received from mailed, Provides information phone inquiries, Prepares documents and transmittal for encoding.

December ‘1998 – April ‘1999

PROGRAMMER

JOROFE Computer Rentals

Morong, Rizal

EDUCATIONAL BACKGROUND

Tertiary

Bachelor of Science in Computer Science

1995 - 1998

Tomas Claudio Memorial College

Morong, Rizal

Bachelor of Science in Custom Administration

1993 - 1995

Philippine Maritime Institute

Sta. Cruz, Manila

Secondary

1989 - 1993

Immaculate Conception Parochial School

Malabon City

Primary

1983 - 1989

Immaculate Conception Parochial School

Malabon City

SEMINARS and TRAINING ATTENDED

Implementing Data Models and Reports with SQL Server 2014

December 27-28, 2017 & January 03-05, 2018

Implementing and Maintaining MSSQL Server Reporting Services

October 12-14, 2016

Developing on MS SQL Server 2014

January 25-29, 2016

Implementing a Data Warehouse with Microsoft SQL Server

January 11-15, 2016

Updating of Standards for Corporate Information Requirements

August 6 - 8, 2014

Benefit Claims System Forum

April 23 - 25, 2013

Database Build-up and Accuracy

September 23, 2011

Oracle Basic PL/SQL Training

September 19 – 21, 2011

System Requirements Specification Training

August 16 – 17, 2011

Basic SQL Workshop

October 26 – 30, 2009

Microsoft Office 2007

August 28, 2009

Workshop on Detailed Structure of PHIC Database

October 22 – 24, 2008

Basic Troubleshooting of Common Hardware & Network Problems & Update on I.T. Policies

February 8, 2007

Seminar on Fraud Investigation and Legal Evidence

October 23 – 27, 2006

Seminar / Workshop on Social Health Insurance

March 30 – 31, 2006

The Role of Internal Audit in Risk Management-Based Auditing

August 6-7, 2003

Information Systems Audit

July 22 - 26, 2002

Distance Learning Program

June 7 – July 19, 2002

Modern Trend in Information within the Philippine Context

September 16, 2001

Audit and Control in a Computerized Environment

March 31, 2001

Basic Orientation Seminar on the National Health Insurance Program

September 19, 2000

Briefing Session on Social Security System

September 17, 1999

Personal Effectiveness

May 6, 1999

SKILLS

Proficient in Structured Query Language - SQL (Oracle, Interbase and Microsoft SQL)

Proficient in Internet, MS Excel, Word, PowerPoint, and Access (Windows 98 – Windows 10)

Knowledgeable in Auditing (Financial and Systems Audit)

Basic knowledge in LINUX, Visual Basic, Dreamweaver, Local Area Network, System Analysis

Basic knowledge in Creating Dashboard - Business Intelligence (BI) using Yellow fin, Pentaho Software and Microsoft Power BI

IT PROJECT UNDERTAKEN

Internal Audit Department

Designed and developed the Investment Monitoring System (Audit Tool)

Designed and developed the Report Monitoring System (Audit Tool)

Designed and developed the Computation of Penalties and Interest of PhilHealth Accredited Banks (Audit Tool)

Designed and developed the Reconciliation System (Audit Tool)

Designed and developed the PhilHealth Internal Audit Department Web Site

Conduct lecture on Microsoft Access

Information Technology & Management Department

Designed and developed the Monitoring System (Technical Unit)

Conduct lecture on basic SQL

Task Force Informatics

Designed and developed the Inventory/Monitoring System (Property)

Designed and developed the Job Request Monitoring System

Conduct lecture on basic SQL and Crystal Report

PERSONAL DATA

Date of Birth : July 14, 1976

Civil Status : Married

Citizenship : Filipino

Religion : Roman Catholic

Language/s

Spoken/Written : English, Filipino

REFERENCES

Available upon Request

I hereby certify that the above data are true and correct to the best of my knowledge and belief.

HERBERT RONAN V. CRUZ

Applicant

Contact this candidate