Photo

Ramon Jacob Sapina Systems Analyst / Database and Application Systems Officer

Cavite, Philippines Mon Sapina
Crystal Reports Writingdatabase managementNetwork connectivity and troubleshootingPC TroubleshootingprogrammingSQL ScriptingSystems Analysis and DesignTeaching

Ramon J. Sapina

B-9 L-17, Jasmin St., Area-B

Queen’s Row Subdivision

Molino 3, Bacoor, Cavite 4102

E-mail: [email protected]

Mobile Phone No.: +639566733777

 

 

 

EDUCATIONAL ATTAINMENT

 

 

College                                                       BACHELOR OF SCIENCE

1990 – 1993                                                  Major in COMPUTER SCIENCE

AMA COMPUTER UNIVERSITY

South Super Highway, Makati City

 

High School                                          MANILA CENTRAL UNIVERSITY

1983 – 1987                                                  Old Samson Road, Kalookan City

 

Elementary                                            MANILA CENTRAL UNIVERSITY

1976 – 1983                                                  Old Samson Road, Kalookan City

 

 

 

WORK EXPERIENCE

 

UNIVERSITY OF PERPETUAL HELP SYSTEM DALTA

Alabang-Zapote Road, Pamplona, Las Piñas City

 

POSITION:    Systems Analyst

Information Technology Department – DALTA CENTRAL

December 15, 2015 – October 15, 2016

 

 

BASIC FUNCTIONS

 

·        Analyze and examine existing systems to check if it still fit serving the business.

·        Performs requirements gathering.

·        Prepares relational diagrams, data flow diagrams, and flow charts to illustrate and document both existing and proposed systems.

 

 

·        Coordinates with programmers and pass on requirements to be converted to program codes and functions.

·        Implements the newly developed system.

·        Performs change management.

 

 

PERPETUAL HELP Medical Center – las piÑas city

Alabang-Zapote Road, Pamplona, Las Piñas City

 

POSITION:    Database & Application Systems Officer

Information Technology Department

June 2, 2006 – October 14, 2015

 

BASIC FUNCTIONS

 

Responsible for the creation, maintenance, performance, integrity and security of the databases including, but is not limited to design,  installation, implementation, administration, monitoring, tuning, migration, support, backup, restore, and disaster recovery.
Manages application development projects for the successful development and implementation of in-house and proprietary business application systems and/or modules.
Also conducts trainings for end users.
DUTIES AND RESPONSIBILITIES

 

·         Designs and documents database architecture. Builds database scheme, tables, procedures and permissions. Writes data dictionary.

·         Develops database utilities, scripts and automated reporting.

·         Develops interfaces, data mapping and staging tables for systems integration.

·         Installs and tests patches and upgrades, in coordination w/ DC & Systems.

·         Monitors and performs database tuning.

·         Oversee the DR system, backup/restore.

·         Restores and recovers corrupted databases.

·         Evaluates user needs and system functionality and ensures that solutions are aligned with the IT standards and IT facility meets these needs.

·                                                Manages in-house and outsourced business application projects.

·         Establishes priorities and sets deadlines for all business application development projects.

·         Directs the programmers in planning, analysis, design, testing, and deployment of business applications.

·         Test and installs new business applications and databases before migrating to production environment.

·         Creates and deploys modules for scheduled and ad-hoc reports.

·         Maintains projects/program register and system documentations.

·         Maintains, troubleshoots, supports and upgrades all business application systems.

·         Provides trainings to end users on in-house and proprietary business applications

·         Performs other tasks that may be assigned from time to time.

 

 

 

 

UNIVERSITY OF PERPETUAL HELP SYSTEM DALTA

Alabang-Zapote Road, Pamplona, Las Piñas City

 

POSITION:    Sr. Programmer – Information Technology Department (Central Office)

June 1, 2004 – June 1, 2006

 

DUTIES AND RESPONSIBILITIES

 

Analyze, prepare, and maintain written programs for the UPHSD Molino campus in consonance with the scopes of IT projects
Formulates and implements policies, plan, standards, and rules and regulations pertaining to information technology and electronic connectivity in the campus.
Responsible for the day-to-day operations and maintenance of the systems including back-up and restore procedures.
Train personnel after user acceptance criteria have been met.
Spearheads the formulation of IT plans, programs such as the Information Technology and Systems Strategic Plan and other computerization initiatives.
Administer and maintains the facilities for the operation of the campus Internet facility.
Assists other IT personnel in developing and installing IT related projects for critical / key services of the university and train respective users.
Maintains and effects database updates on record sources from different offices.
Assist in the preparation and data migration during the development of written programs.
Establish the process to be captured by the system to be defined in the detailed system specification.
Validates the accuracy of converted / migrated data.
 

 

 

 

 

UNIVERSITY OF PERPETUAL HELP SYSTEM DALTA

Alabang-Zapote Road, Pamplona, Las Piñas City

 

POSITION:    Faculty, College of Computer Studies

June 13, 2001 – May 31, 2004 (Full-Time)

June 1, 2004 – April 30, 2008 (Part-Time)

 

DUTIES AND RESPONSIBILITIES

 

§     COBOL Programming

§     Database Management Systems

§     Structures of Programming Languages

§     Software Quality Processes

 

Attends and participates in official meetings, school activities, academic counseling, and such other activities relevant to teaching assignment.
Other related tasks as delegated by the immediate superior.
Teaching various computer subjects such as:
§     Database Programming

§     Computer Architecture with Assembly Language

§     Language and Automata Theory

§     Systems Analysis and Design

§     Software Engineering

§     Visual Basic Programming

§     Principles of Data Communication and Networking

§     Discrete Mathematics

 

 

 

AMA COMPUTER UNIVERSITY

South Super Highway, Makati City

 

POSITION:    Faculty, College of Computer Studies

June 13, 1998 to June 16, 2000

 

DUTIES AND RESPONSIBILITIES

 

Teaching various computer subjects such as
§     Computer Fundamentals

§     Introduction to Programming

§     Structures of Programming Languages

§     File Processing

§     Discrete Mathematics

§     Database Management Systems

§     System Analysis and Design

§     Data Communication

Worked as subject coordinator for subjects like Database Management System and Data Communications.
Formulates and prepares periodical examination with table of specifications.
Motivates students to strive for their individual goals as well as instill discipline to follow campus regulations.
PHILIPPINE WIRELESS INC. – POCKETBELL PHILS.

Aurora Boulevard, Cubao, Quezon City

 

POSITION:    Section Head, Stores (Warehouse)

May 5, 1997 to June 12, 1998

 

DUTIES AND RESPONSIBILITIES

 

Supervises staffs in monitoring different functions related in keeping the section meet its goals.
Motivates staffs in performing according to the set job descriptions and meet individual targets.
Provides information relevant to stock status and communicates problems related to the group.
Facilitates meeting to monitor the progress of work productivity of each staff.
Handles the performance appraisal of each staff.
Represents the section in plenary meetings with different section sections heads of the company.
 

 

PHILIPPINE WIRELESS INC. – POCKETBELL PHILS.

Aurora Boulevard, Cubao, Quezon City

 

POSITION:    Importation Assistant (Purchasing)

February 26, 1996 to May 4, 1997

 

DUTIES AND RESPONSIBILITIES

 

Canvass all imported purchases and job requisition and compare prices with local distributor if there are any in order to obtain reasonable quotes and best offer.
Prepares and finalizes canvass sheet and purchase order form in order to properly document the transaction and be able to confirm orders with suppliers.
Coordinate with Finance Division regarding funds and Letter of Credit opening in order to facilitate all requirements needed.
Coordinate with suppliers, customs brokers and forwarders the exact time of delivery and closely monitor the progress of release of shipment from Bureau of Customs.
Coordinate with end-users on matters of specifications in order to have a clear idea of the requirements.
Reviews previews imported purchases and monitors increase and fluctuations of prices in order to help management in their decision making.
Coordinates with Stores section and end-users and advice Finance Division to call the Insurance Adjuster to physically inspect the materials in order to identify defective items.
Prepares e-mail and fax messages to be sent to suppliers in order to expedite the completion of requirements.
Facilitates the exportation of all materials for repair outside the country in order to ensure the completion of requirements on time.
Facilitates the exportation of mis-shipped and defective but guaranteed materials.
PHILIPPINE WIRELESS INC. – POCKETBELL PHILS.

Aurora Boulevard, Cubao, Quezon City

 

POSITION:    Merchandise Storekeeper (Warehouse)

May 1, 1994 to February 25, 1996

 

DUTIES AND RESPONSIBILITIES

 

Receives and checks condition of deliveries from suppliers and items/materials recovered from projects and prepares receiving reports.
Issues items requested by different units in the organization.
Responsible in safekeeping all materials in the stockroom.
Prepare reports relevant to stock status and coordinates with Inventory Planning and Control and Purchasing Section for stock replenishment.
PHILIPPINE WIRELESS INC. – POCKETBELL PHILS.

Aurora Boulevard, Cubao, Quezon City

 

POSITION:    Data Encoder (Inventory Planning and Control)

February 14, 1994 to April 30, 1994

 

DUTIES AND RESPONSIBILITIES

 

Encode all stock items with corresponding item codes.
Prepare summary reports of inventory.
Update records/files and other related documents.
 

TRAININGS AND SEMINARS ATTENDED

 

TRENDS IN OPEN SYSTEMS TECHNOLOGY

AMA Computer University, Makati City

March 1993

 

ADVANCE TECHNOLOGY AND SOLUTIONS – COMPUTER AIDED DESIGN / ENGINEERING

AMA Computer University, Makati City

March 1993

 

 

MODERN PURCHASING MANAGEMENT

Impact Management Systems

Dusit Hotel, Makati City

April 13, 1996

 

IMPORT RULES AND REGULATIONS

NCR research and Development Center

Dusit Hotel, Makati City

April 13, 1996

 

ESSENTIALS OF LETTER OF CREDIT

NCR research and Development Center

Dusit Hotel, Makati City

April 14, 1996

 

STRATEGIC PROCESS MANAGEMENT

Ciudad Fernandina, Eisenhower St., Greenhills

San Juan, Metro Manila

September 1996 – May 1998

 

WORLD Y2K SUMMIT

PICC Plenary Hall

Roxas Blvd., Manila

March 2-3, 1999

 

FACULTY DEVELOPMENT TRAINING

AMA Computer University

Project 8, Quezon City

March 11-13, 1999

 

CISCO NETWORKING ACADEMY PROGRAM ORIENTATION

Dela Salle University, Dasmariñas, Cavite

October 26, 2001

 

DEVELOPING PERSONAL MASTERY

People at Work Seminar Series (Philippine Daily Inquirer)

Equitable PCIB Auditorium, Makati City

May 28, 2002

 

BUILDING SYNERGY FOR ORGANIZATIONAL EXCELLENCE

People at Work Seminar Series (Philippine Daily Inquirer)

Equitable PCIB Auditorium, Makati City

May 30, 2002

 

FACULTY DEVELOPMENT WORKSHOP

University of Perpetual Help System Dalta – Molino Campus

August 10, 2002

 

“Does the Philippines have a chance: An Assessment of the IT Industry and its impact to the IT Professional”

IQ Session: ENTERPRISE RESOURCE PLANNING

EQ Session: [email protected] workplace

MONTHLY MEMBERSHIP MEETING & PROFESSIONAL DEVELOPMENT PROGRAM

AIM Conference Center, Makati City

September 27, 2002

 

IBM EDUCATION FORUM

Shangri-La Hotel, Makati City

May 30, 2003

 

“Proper Handling and Operation of LCD and Microsoft Office Specialist (MOS) Orientation and Review” – (Resource Speaker)

University of Perpetual Help System Dalta – Molino Campus

April 30, 2004

 

 

SYSTEMS DEVELOPED AND IMPLEMENTED

 

MATERIALS RECEIVING REPORT SYSTEM

October 1997

Developed under Foxpro for DOS version 2.6 for

PHILIPPINE WIRELESS INC.

 

PURCHASING SYSTEM

December 1996

Developed under Foxpro for DOS version 2.6 for

PHILIPPINE WIRELESS INC.

 

 

 

PAGER MONITORING SYSTEM

April 1995

Developed under Foxpro for DOS version 2.6 for

PHILIPPINE WIRELESS INC.

 

GRADING MANAGEMENT SYSTEM

July 2004

Developed under Microsoft Visual Foxpro

University of Perpetual Help Dalta – Molino Campus

 

GRADES DATA ENTRY MODULE

April 2006

Developed under Visual Basic / SQL Server 2000

University of Perpetual Help Dalta – Molino Campus

 

OUTSIDE DOCTORS REGISTRATION MODULE

October 2008

Developed under Visual Basic / SQL Server 2000

Perpetual Help Medical Center – Las Pinas

 

HOSPITAL MANAGEMENT SYSTEM

November 2008

Developed under Visual Basic / SQL Server 2000

Perpetual Help Medical Center – Las Pinas

 

PROCEDURE & RATES INQUIRY SYSTEM

February 2009

Developed under Visual Basic / SQL Server 2005

Perpetual Help Medical Center – Las Pinas

 

INCOME, STATISTICS & PERFORMANCE REPORT GENERATOR

April 2009

Developed under Visual Basic / SQL Server 2005

Perpetual Help Medical Center – Las Pinas

 

OPD CHARGE SLIPS & ER/OR STATEMENTS REPORT GENERATOR

January 2010

Developed under Visual Basic / SQL Server 2008

Perpetual Help Medical Center – Las Pinas

 

INVENTORY AGING SYSTEM

July 2010

Developed under Visual Basic / SQL Server 2008

Perpetual Help Medical Center – Las Pinas

 

 

GENERAL ASSEMBLY ATTENDANCE SYSTEM

August 2010

Developed under Visual Basic / SQL Server 2008

Perpetual Help Medical Center – Las Pinas

 

PREVENTIVE MAINTENANCE SYSTEM (FOR UPHMC)

July 2011

Developed under Visual Basic / SQL Server 2008

Perpetual Help Medical Center – Las Pinas

 

CUSTOMER REGISTRATION AND CHARGING FOR WELLNESS CENTER

November 2011

Developed under Visual Basic / SQL Server 2008

Perpetual Help Medical Center – Las Pinas

 

MANAGEMENT DASHBOARD SYSTEM

October 2013

Developed under Visual Basic / SQL Server 2008

Perpetual Help Medical Center – Las Pinas

 

PACAKAGES AND PROCEDURES COMPONENT POSTING

July 2014

Developed under Visual Basic / SQL Server 2008

Perpetual Help Medical Center – Las Pinas

 

ATTENDING PHYSICIAN AND REFERRED DOCTORS SYSTEM

August 2015

Developed under Visual Basic / SQL Server 2008

Perpetual Help Medical Center – Las Pinas

 

Created several SQL Scrips, SQL Functions, and Views to augment, correct and or repair existing ones for the existing Hospital Information System

Perpetual Help Medical Center – Las Pinas

 

 

 

 

ORGANIZATIONS

 

Member – PHILIPPINE COMPUTER SOCIETY

 

Member – PHILIPPINE SOCIETY OF INFORMATION TECHNOLOGY EDUCATORS

 

 

 

OTHER POSITIONS HELD AT UPHSD

 

Vice-President, UPHSD – Molino Campus College Faculty Club

School Year 2002 – 2003

 

Member, Board of Directors, UPHSD – Molino Campus College Faculty Club

School Year 2003 – 2004

 

 

SKILLS

 

Proficient in developing applications using Microsoft Visual Studio .Net 3.5 Framework, Microsoft SQL Server 2000/2005/2008 R2
Writing complex SQL Server stored procedures, views and triggers.
Knowledgeable in using Crystal Report Writer
Knowledgeable in Operating Systems like Windows 7, 8, and 10, Windows 2003 Server, Windows 2008 Server, Windows 2012 Server.
Proficient in using Microsoft Office Applications (Microsoft Office Specialist in MS Word 2000 and MS Excel 2000, Microsoft Office Specialist in MS Word 2002, MS Excel 2002, MS PowerPoint 2002, MS Access 2002, MS Office 2003 & 2007, 2010, 2013)
Knowledgeable in System Analysis and Design
Knowledgeable in PC troubleshooting
Knowledgeable in LAN (TCP/IP) connectivity and troubleshooting
Good communication skills (oral/written)
Teaching
PERSONAL DATA

 

Date of Birth :                       July 19, 1970

Place of Birth           :                       Manila

Age                             :                       48 years old

Civil Status               :                       Married

No. of children        :                       3

Religion                    :                       Roman Catholic

Height                        :                       5 ft. 6 ½ inches

Weight                       :                       150 lbs.

 

 

 

 

CHARACTER REFERENCES

 

Ms. Luzviminda Y. Bonoan

Human Resource Director, Perpetual Help Medical Center

Tel. No.: +638748515 local 601/602

 

Dr. Rosalie M. Armando

IT Director, DALTA Central

Tel. No.: +638751806

 

Ms. Jesusa S. Llorono

Director, Perpetual Help Medical Center Kidney Transplantation

Tel No.: +638748515 local 239

Education

1990/1993 BS in Computer Science at AMA Computer University
1983/1987 Secondary Education at Manila Central University
1976/1983 Primary Education at Manila Central University

Experience

2015/2016 Systems Analyst at UNIVERSITY OF PERPETUAL HELP SYSTEM DALTA

BASIC FUNCTIONS

• Analyze and examine existing systems to check if it still fit serving the business.
• Performs requirements gathering.
• Prepares relational diagrams, data flow diagrams, and flow charts to illustrate and document both existing and proposed systems.
• Coordinates with programmers and pass on requirements to be converted to program codes and functions.
• Implements the newly developed system.
• Performs change management.

2006/2015 Database and Application Systems Officer at PERPETUAL HELP MEDICAL CENTER - LAS PINAS

BASIC FUNCTIONS

• Responsible for the creation, maintenance, performance, integrity and security of the databases including, but is not limited to design, installation, implementation, administration, monitoring, tuning, migration, support, backup, restore, and disaster recovery.

• Manages application development projects for the successful development and implementation of in-house and proprietary business application systems and/or modules.

• Also conducts trainings for end users.

DUTIES AND RESPONSIBILITIES

• Designs and documents database architecture. Builds database scheme, tables, procedures and permissions. Writes data dictionary.
• Develops database utilities, scripts and automated reporting.
• Develops interfaces, data mapping and staging tables for systems integration.
• Installs and tests patches and upgrades, in coordination w/ DC & Systems.
• Monitors and performs database tuning.
• Oversee the DR system, backup/restore.
• Restores and recovers corrupted databases.
• Evaluates user needs and system functionality and ensures that solutions are aligned with the IT standards and IT facility meets these needs.
• Manages in-house and outsourced business application projects.
• Establishes priorities and sets deadlines for all business application development projects.
• Directs the programmers in planning, analysis, design, testing, and deployment of business applications.
• Test and installs new business applications and databases before migrating to production environment.
• Creates and deploys modules for scheduled and ad-hoc reports.
• Maintains projects/program register and system documentations.
• Maintains, troubleshoots, supports and upgrades all business application systems.
• Provides trainings to end users on in-house and proprietary business applications
• Performs other tasks that may be assigned from time to time.

2004/2006 Senior Programmer at UNIVERSITY OF PERPETUAL HELP SYSTEM DALTA

• Analyze, prepare, and maintain written programs for the UPHSD Molino campus in consonance with the scopes of IT projects
• Formulates and implements policies, plan, standards, and rules and regulations pertaining to information technology and electronic connectivity in the campus.
• Responsible for the day-to-day operations and maintenance of the systems including back-up and restore procedures.
• Train personnel after user acceptance criteria have been met.
• Spearheads the formulation of IT plans, programs such as the Information Technology and Systems Strategic Plan and other computerization initiatives.
• Administer and maintains the facilities for the operation of the campus Internet facility.
• Assists other IT personnel in developing and installing IT related projects for critical / key services of the university and train respective users.
• Maintains and effects database updates on record sources from different offices.
• Assist in the preparation and data migration during the development of written programs.
• Establish the process to be captured by the system to be defined in the detailed system specification.
• Validates the accuracy of converted / migrated data.

2001 to 2004 (full time)/2004 to 2008 (part time) Faculty Member, College of Computer Studies at UNIVERSITY OF PERPETUAL HELP SYSTEM DALTA

DUTIES AND RESPONSIBILITIES

 COBOL Programming
 Database Management Systems
 Structures of Programming Languages
 Software Quality Processes

• Attends and participates in official meetings, school activities, academic counseling, and such other activities relevant to teaching assignment.
• Other related tasks as delegated by the immediate superior.
• Teaching various computer subjects such as:
 Database Programming
 Computer Architecture with Assembly Language
 Language and Automata Theory
 Systems Analysis and Design
 Software Engineering
 Visual Basic Programming
 Principles of Data Communication and Networking
 Discrete Mathematics

1998/2000 Faculty Member, College of Computer Studies at AMA Computer Unversity

• Teaching various computer subjects such as
 Computer Fundamentals
 Introduction to Programming
 Structures of Programming Languages
 File Processing
 Discrete Mathematics
 Database Management Systems
 System Analysis and Design
 Data Communication
• Worked as subject coordinator for subjects like Database Management System and Data Communications.
• Formulates and prepares periodical examination with table of specifications.
• Motivates students to strive for their individual goals as well as instill discipline to follow campus regulations.

1997/1998 Stores Section Head at PHILIPPINE WIRELESS INC. – POCKETBELL PHILS.

• Supervises staffs in monitoring different functions related in keeping the section meet its goals.
• Motivates staffs in performing according to the set job descriptions and meet individual targets.
• Provides information relevant to stock status and communicates problems related to the group.
• Facilitates meeting to monitor the progress of work productivity of each staff.
• Handles the performance appraisal of each staff.
• Represents the section in plenary meetings with different section sections heads of the company.

1996/1997 Importation Assistant at PHILIPPINE WIRELESS INC. – POCKETBELL PHILS.

• Canvass all imported purchases and job requisition and compare prices with local distributor if there are any in order to obtain reasonable quotes and best offer.
• Prepares and finalizes canvass sheet and purchase order form in order to properly document the transaction and be able to confirm orders with suppliers.
• Coordinate with Finance Division regarding funds and Letter of Credit opening in order to facilitate all requirements needed.
• Coordinate with suppliers, customs brokers and forwarders the exact time of delivery and closely monitor the progress of release of shipment from Bureau of Customs.
• Coordinate with end-users on matters of specifications in order to have a clear idea of the requirements.
• Reviews previews imported purchases and monitors increase and fluctuations of prices in order to help management in their decision making.
• Coordinates with Stores section and end-users and advice Finance Division to call the Insurance Adjuster to physically inspect the materials in order to identify defective items.
• Prepares e-mail and fax messages to be sent to suppliers in order to expedite the completion of requirements.
• Facilitates the exportation of all materials for repair outside the country in order to ensure the completion of requirements on time.
• Facilitates the exportation of mis-shipped and defective but guaranteed materials.

1994/1996 Merchandise Storekeeper at PHILIPPINE WIRELESS INC. – POCKETBELL PHILS.

• Receives and checks condition of deliveries from suppliers and items/materials recovered from projects and prepares receiving reports.
• Issues items requested by different units in the organization.
• Responsible in safekeeping all materials in the stockroom.
• Prepare reports relevant to stock status and coordinates with Inventory Planning and Control and Purchasing Section for stock replenishment.

1994/1994 Data Encoder at PHILIPPINE WIRELESS INC. – POCKETBELL PHILS.

• Encode all stock items with corresponding item codes.
• Prepare summary reports of inventory.
• Update records/files and other related documents.