Ramon Jacob Sapina Systems Analyst / Database and Application Systems Officer
Cavite, Philippines Mon SapinaRamon 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: www.worldclasswomen@the 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.