REMAR F. CUYUGAN
Mobile Phone No. : 732-***-****
E-mail : abmmty@r.postjobfree.com, abmmty@r.postjobfree.com
Executive Summary
Over 24 years experience in the field of Information Technology.
Extensive experience in all areas of the System Development Life Cycle
including Project Management, Business Systems Analysis, Database Design
and Administration, and Programming in a variety of platforms and
languages.
1 Hardwares
2 SUN E10000, SUN E450/E250, SUN SparcCenter 2000, HP-9000, IBM-RS-6000,
Compaq, HP N-class, IBM AS/400, IBM-S38, IBM PCs, Fujitsu-PrimePower
800.
Operating System
Unix, Linux, Solaris 6/7/8, HP-UX 9/10/11, IBM-AIX, SCO-Unix, Windows-
NT, Windows 2000, OS/400, OS/38
Softwares
SAS Data Integration (ETL) Studio, Ascential DataStage XE, Lawson ERP,
Oracle V6/V7/8/8i/9i/10g/11g RDBMS, Oracle PL/SQL, Oracle SQL*Plus,
Oracle SQL*Loader, Oracle Enterprise Manager, Oracle Net*8, SQL*Net V2,
Quest Toad, Oracle Developer 2000 Forms/Reports, Visual Basic 6, Pro*C,
Korn Shell Scripting, Platinum Plan Analyzer, ERWIN data modeller,
MagicDraw data modeller, Platinum DBVision & Server Vision, Perl,
Crystal Report, Cobol-400, Control Language (CL) 400, AS-400 Screen
Design Aid (SDA), AS-400 Query, AS-400 Data File Utility (DFU), CL-38,
Cobol/38, Informix RDBMS, Informix 4GL, Informix SQL.
Work Experience
FDG Consulting, Inc
Morris Plains, NJ 07950
May 2008 to Present
Client: Automatic Data Processing (ADP), Inc. Feb 2010 to
Present
3 ADP Blvd., Roseland, NJ 07068
Performed the following as a Database Administrator/Developer:
. Install oracle software and create databases in RAC and non-RAC
environments
. Monitor and tune database performance using AWR, OEM
. Review and tune application (SQL) queries
. Develop logical and physical data models using TOAD Data Modeler
. Create the database objects in the database as per data models
. Extract/load data into databases using sql*loader, export/import
utilities
. Write PL/SQL scripts, procedures and triggers
. Write automated jobs using shell scripts
Client: Tangible Value, LLC May 2008 to Feb
2010
470 Wall St., Princeton, NJ 08540
Worked as a Sr. Database Administrator for various projects using Oracle
on Linux and Unix performing various database related tasks:
Database Administration
. Install and configure Oracle softwares and upgrades
. Install, configure, and manage Oracle Real Appication Cluster (RAC)
databases and Oracle single-instance databases
. Create physical database and database objects (tables, indexes, views,
etc) as per database design
. Monitor and tune database performance using Oracle Enterprise Manager
(OEM), Statspack, and OS utilities
. Write unix shell scripts and database scripts
. Support application developers in their database requirements, such
as, loading of test data, database refresh, writing and optimizing
queries, etc.
. Optimize database application queries using tkprof, explain plan, and
toad
. Gather data volume projections and plan for data growth
. Plan the back-up and recovery strategies for the different databases
. Implement back-up and recovery procedures using Oracle Recovery
Manager (RMAN)
. Plan and Implement database archiving for fault tolerance
. Ensure database availability and performance
. Attend to all database and database-related problems
Database Architect
. Gather and analyze database requirements from application architect/s
. Plan and design logical and physical database models using MagicDraw
. Create tables, indexes, views, synonyms, database triggers, and other
database objects for different applications
Database Developer
. Write Oracle PL/SQL programs using TOAD and SQLDeveloper
. Write and test stored procedures and packages using PL/SQL for
different applications
. Write stored functions to implement FGAC using VPD dbms procedures
. Design the Extract-Transform-Load (ETL) process for Business
Intelligence application
. Write and test ETL programs using DataStage
Lawson - Philippines
Bonifacio Global City, City of Taguig, Philippines
Feb 2007 to March 2008
Worked as a Sr. Oracle DBA for various projects. As an Oracle DBA:
. Install and configure Oracle softwares and upgrades
. Install, configure, and manage Oracle 10g Real Application Cluster
(RAC) databases and Oracle single-instance databases
. Design logical and physical database models
. Create physical database and database objects (tables, indexes, views,
etc) as per database design
. Monitor and tune database performance using Oracle Enterprise Manager
(OEM) Database Control and Grid Control for RAC, Statspack, and OS
utilities
. Manage users and user connections in RAC
. Write unix shell scripts and database scripts
. Led, managed, and coordinated a team of 5 people on a day-to-day basis
. Developed data quality assurance criteria and procedures
Soluziona Phils. / Corporate Information Solutions, Inc.
Meralco Center, Ortigas, Pasig City, Philippines
1 July 2001 to Jan 2007
Client: Manila Electric Company Aug 2001 to Jan 2007
Pasig City, Philippines
Worked as a Datawarehouse Designer/DBA for the Corporate Data Warehouse
of the Manila Electric Co. As a datawarehouse designer:
. Translated business requirements into technical specifications
. Designed datawarehouse dimensional data models to support user
requirements
. Designed datawarehouse ETL process.
. Identified data sources, constructed data decomposition/mapping
diagrams, and documented the process.
. Wrote specifications for the ETL process.
. Developed normalized data models for the staging database.
. Wrote ETL jobs using Ascential DataStage ETL tool.
. Wrote stored procedures/scripts to capture data changes using Oracle
Streams.
. Wrote stored procedures, packages for ETL process using Oracle
PL/SQL; also wrote shell scripts.
. Wrote programs using Cognos Impromptu, Transformer, and Powerplay.
. Prepared project plan and schedules.
As a datawarehouse DBA (Oracle 8i/9i):
. Prepared initial data volume and data growth rate to determine data
storage requirements.
. Wrote and Implemented physical database design for the datawarehouse
. Created database and corresponding storage and memory structures,
e.g., tablespaces, rollback segments, redo logs, etc.
. Created tables, partitions, indexes, synonyms, etc.
. Wrote shell scripts for running the ETL process.
. Manage the ETL process and validate the results.
. Monitor and Fine-tune the database and the application SQLs.
. Performed regular database backups.
USinternetworking, Inc./EnableVision LLC
50 Mt. Bethel Rd., Warren, NJ 07056 USA
May 2000 to June 2001
Worked as a Database Designer/Administrator for an application service
provider. As such performed the following tasks:
. Gathered and documented requirements from the users/analysts.
. Developed database designs and program specifications.
. Installed and configured Lawson ERP application software.
. Installed and configured Oracle 8/8i RDBMS.
. Developed physical designs for database implementations.
. Created database and database objects.
. Monitored and tuned the application and database.
. Configured and sized database and database objects, e.g.,
tablespaces, tables, and indexes
. Wrote database backup and recovery plan
. Wrote stored procedures/packages, PL/SQL scripts, shell scripts, and
perl scripts.
. Wrote report programs using Crystal Reports.
Millenium Computer Systems
New York, New York, USA
Aug 1998 - Apr 2000
Client: Cephren.com (formerly Ebricks.com) Dec 1999 - Apr
2000
26 Broadway Ave., New York, NY, USA
1
Worked as a Database Designer/Administrator on an internet supplies
procurement system using Oracle 8i on Sun Enterprise 250 operating on
Solaris 8. As a database administrator:
. installed Oracle 8i RDBMS on a Sun Solaris 8 operating system.
. developed logical and physical database design using Power Designer
case tool.
. created the database and all the database objects.
. installed and configured Oracle Client network connections.
. did performance monitoring and tuning using Oracle Enterprise
Manager.
. assisted the developers in SQL formulation and other problems related
to the database.
. reviewed and optimized SQL statements in every program.
. developed a customer database system in Microsoft Access.
. wrote stored procedures, packages, PL/SQL programs, and shell
scripts.
. supported the developers in the formulation and loading of test data
using SQL*Loader and Microsoft Access.
Client: Johnson & Johnson - Healthcare Systems, Inc. Aug 1998-Dec
1999
Piscataway, New Jersey, USA
As a Database Administrator for Contracts and Rebates System (CARS),
performed the following :
. planned and created the physical database and database objects.
. created test database, loaded test data, and did test database
refreshes using export/import and SQL*Loader.
. fine-tuned application SQL statements using explain plan, tkprof, and
Platinum's Plan Analyzer.
. monitored and fine-tuned database performance using Oracle Enterprise
Manager, Platinum SQL-Station, and Oracle's utlbstat/estat utility.
. created users and managed user privileges and resources.
. performed logical and physical database back-ups using export/import
and unix back-up utilities.
. apply upgrades to the CARS application software.
. attend to all database related problems.
. Wrote stored procedures/packages, PL/SQL scripts, and shell scripts.
As a Database Administrator/Programmer for Marketing and Research
System (MRS), performed the following:
. created the logical data model and physical design of the Marketing
and Research Database using the Erwin CASE tool
. determined space requirements for database objects, tables, primary
keys and other indexes.
. wrote data definition language (DDL) scripts for creation of tables,
indexes and other database objects.
. developed loader scripts and control files for loading initial data
and regular data updates.
. developed online programs using Visual Basic 6.
1 RCG Information Technology, Inc.
2 Edison, New Jersey, USA
2 Jun 1996 - Aug 1998
1
2 Client: AT&T Labs Jul 1996 - Aug
1998
Middletown, New Jersey, USA
Functioned as a Database Administrator for the Business Maintenance
Platform (BMP) - Managed Objects (MO). As a DBA:
. installed Oracle softwares and software upgrades.
. Installed and worked on sql and database performance tools such as
Platinum DBVision/ Server Vision/ Wire Tap, Quest's SQL*Lab.
. Performed SQL tuning and database performance monitoring/tuning,
designed physical database schemas, created database and database
objects (tables, indexes, etc.).
. Performed database back-up and management of user and user resources.
. developed a number of online programs and reports using ORACLE
Developer 2000 Forms Designer and Reports Designer for the Data
Management Group (DMG) of BMP.
. Wrote database triggers, PL/SQL scripts, stored procedures, and shell
scripts, and Pro*C programs.
3 Computer Information Systems
Pasig City, Philippines
Jan 1991 - May 1996
Client: Electronic Telephone Service Industries, Inc. (ETSI)
Nov 1995 - Jun 1996
Functioned as a Systems Designer responsible for the systems design,
development and packaging of the Personnel Information and Payroll
System (PIPS) which was implemented on an Oracle V7 environment using
Oracle Developer 2000 Tools. Duties include system/subsystem
application design (online and batch programs), database design, system
testing, and supervision of the construction phase.
Also acted as the database administrator responsible for the definition
of the physical and logical database architecture, creation of database
and database objects, database performance monitoring and tuning,
application tuning, installation of Oracle software and upgrades,
design and implementation of database security plan. Also wrote some
batch programs in Oracle PL/SQL.
Client: Manila Electric Company
Nov 1993 to Nov 1995
Worked as a Systems Designer for the Personnel Management System (PMS).
As a Systems Designer, designed the system architecture, application
and database. Also wrote program specifications and test plan,
supervised the development of the entire system.
May 1993 to July 1993
Worked as an IS Analyst/Designer on the Training and Development System
(TDS). As an analyst, gathered data, analyzed system requirements,
proposed alternative solutions and documented requirements using DFD's,
ERD's, and process specifications. As a designer, prepared the logical
and physical system/sub-system architecture, database structure,
application architecture and security requirements. The system was
developed on an Oracle V7 Environment, using Oracle CDE Toools.
July 1991 to March 1992
Worked as a C.S. Designer/Programmer on a Vehicle Fleet Management
System. This system was developed on a 486-based machine running on
SCO-Unix using Informix as the development tool and also its RDBMS.
Duties include preparation of system/subsystem application design,
database design and implementation, system testing, program coding.
January 1991 to July 1991
Worked as a C.S. Designer/Programmer on the Technical Documentation
System, developed on a 386-based machine running on SCO-Unix using
Informix as the development tool and RDBMS. Duties include design of
application system, design of database structures. Also wrote programs
in Informix-4GL.
2 Special Projects
Client: National Movement For Free Elections (NAMFREL)
Philippines
Apr 1995 - May 1995
Designed the NAMFREL Operation Quick Count, an Election Tallying system
used during the May 1995 Senatorial/Gubernatorial/ Representative
Elections.
Client: Media-Citizens' Quick Count (MCQC)
Philippines
Apr 1992 - May 1992
Worked as a CS Designer on a Vote Tallying System for the May 1992
Philippine National Elections on a 486-based machine using Informix-
Online operating on SCO-Unix. This system was implemented on a client-
server architecture. As a designer, designed the manual process and
document flow, designed the system and application architecture, and
the database structure. Also wrote most of the delicate programs.
Corporate Information Solutions
. A member of the Programming Standards team.
. Conducted training sessions on System and Application Design and
Oracle PL/SQL programming.
. A member of the Work Standards Team, which formulated company
standards for the entire System Development Life Cycle, from
Analysis to Implementation. Primarily tasked to handle the
standards requirements for Design and Programming phases.
ANSCOR INSURANCE BROKERS, INC.
Makati City, Philippines
Apr 1985 to Jan 1991
Worked as an analyst/programmer on the following systems :
. Enhancements to the General Ledger and Accounts Receivable system
. Insurance Sales Analysis System
. Insurance Billing (Invoicing/Refund Premium) System
. Policy Master System
. Insurance Claims System
As an analyst, gathered data on user requirements, analyzed gathered
data and proposed alternative solutions and documented the system
requirements. As a programmer, wrote a considerable number of programs
using COBOL/400 and CL/400 on IBM-AS/400.
Worked as a programmer on the following systems :
. Insurance Claims System
. Insurance Commission Invoicing System
. Insurance Policy Renewal System
. Group Hospitalization Reinsurance System
All these systems were developed on an IBM-S/38 using COBOL/38 and
CL/38 running on OS/38.
EDUCATION
Degree : B. S. in Electrical Engineering
Mapua Institute of Technology, Philippines
Courses Attended :
. Performance Management Workshop - 10/24/02 to 10/25/02
. CMM Orientation - 9/16/02
. CMM Orientation on SDLC, CSSP, Reqts Mgmt - 12/2/02 to 12/4/02
. Marketing in the New Millenium - 5/25/02 - 5/27-02
. Lawson Upgrade Certification - 3/30/01
2 Adv. Technologies Foundations & Install Certification - 9/11/00 - 9/15/00
. Lawson/Oracle DBA - Lawson - 6/12/00 to 6/14/00
3 Unix Database Administration - Lawson Software - 5/19/00
4 Unix Technical Foundation - Lawson - 5/15/00 to 5/16/00
. Unix System Administration - Lawson - 5/17/00 to 5/18/00
5 ORACLE V7 Database Administration
. ORACLE*Forms V4
. ORACLE*Reports V2
. ORACLE*Graphics
. ORACLE*PL/SQL
. Advanced Relational Analysis and Design
. Cost Benefit Analysis
. EDP Project Management
. AIX System Administration
. Database Administration for ORACLE V6
. Relational Database Analysis and Design
. Developing Informix-Online Applications
. Informix-Online for Database Administrators
. Optimizing Informix Applications
. Informix-SE for Database Administrators
. Developing Applications on Infomix-4GL
. General Design Course
. Data Analysis and Modelling
. AS-400 Performance Tuning and Analysis