Manager Data

REMAR F. CUYUGAN

Mobile Phone No. : 732-***-****

E-mail Address : *********@*******.***, *********@*****.***

Executive Summary

A seasoned Oracle Database Administrator and PL/SQL Developer with over 25 years experience managing Oracle databases and developing PL/SQL scripts and procedures. Adept at logical and physical data modeling for OLTP relational models and data warehouse dimensional (star schema) models. Highly skilled in database and application performance tuning. Experienced in all the phases of the SDLC. Experience also includes financial and investment systems, telecommunications, healthcare, utilities, and human resource management systems.

Work Experience

Albridge, Inc (affiliate of Pershing, a BNY Mellon company)

1009 Lenox Dr., Lawrenceville, NJ 08465

Dec 2010 to Dec 2016

Position: Sr Applications Developer

Write/test PL/SQL packages, procedures, functions, and unix shell scripts for the Albridge Wealth Reporting (AWR) application, a wealth management product used by various financial institutions, advisors, and investors, using advanced pl/sql, analytic functions, bulk collections, and global temporary tables for report generation, batch processing, and provision data to front-end java application

Gather and analyze requirements from business analysts

Create logical and physical data models

Write application design and program specifications

Manage/lead release development with on-shore and off-shore team

Manage and perform code reviews

Interact with various teams to resolve development issues

Perform SQL analysis and tuning

Support client on-boarding/implementation

Troubleshoot, analyze, and fix application issues

Create the database objects in the database as per data models

Monitor and tune database performance

Create, load, and refresh test databases

Support data warehouse data loading (ETL) using informatica monitor

Render production support on a rotation basis

Starpoint Solutions, Inc

Aug 2010 to Nov 2010

Client: Albridge Solutions (affiliate of Pershing) Aug 2010 to Nov 2010

1009 Lenox Dr., Lawrenceville, NJ 08465

Oracle Developer

Write/test PL/SQL packages, procedures, and functions for the Albridge Wealth Reporting (AWR) application, a wealth management product used by various financial institutions, advisors, and investors. Used advanced pl/sql, analytic functions, bulk collections, and global temporary tables for generating reports and online applications.

Write DDL and DML statements for creating database objects and managing privileges.

Write shell scripts as interface for running database jobs

Resolve database/application issues and tickets

FDG Consulting

May 2008 to July 2010

Client: Automatic Data Processing (ADP), Inc. Feb 2010 to July 2010

3 ADP Blvd., Roseland, NJ 07068

Role: Database Administrator/PLSQL Developer

Install oracle software and create databases in RAC and non-RAC environments on Windows and Linux/Unix environments

Improve database performance by evaluating AWR reports and OEM data

Optimize application (SQL) queries using explain plan

Gather data requirements and developed 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 PL/SQL procedures that get and pass data to MQ logs

Write automated jobs using dos and shell scripts

Client: Tangible Value, LLC May 2008 to Feb 2010

470 Wall St., Princeton, NJ 08540

Role: Sr. Database Administrator

Install and configure Oracle softwares and upgrades

Install, configure, and manage Oracle Real Appication Cluster (RAC) databases and Oracle single-instance databases in Oracle 10g and 11g

Create logical and physical data models using Power Designer

Create physical database and database objects (tables, indexes, views, etc) as per database design

Monitor and tune database performance using Oracle Enterprise Manager (OEM), AWR, 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

Implement and plan the back-up and recovery strategies for the different databases 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

Role: Sr. PL/SQL Database Developer

Write Oracle PL/SQL scripts, stored procedures and packages using TOAD and SQLDeveloper

Write stored functions to implement FGAC using VPD dbms procedures

Write scripts for promoting database changes from one environment to another

Lawson – Philippines

Bonifacio Global City, City of Taguig, Philippines

Feb 2007 to March 2008

Role: Sr. Oracle DBA/Developer

Role: Project Manager

Defined scope and contents of the project

Prepared and implemented project plans and schedules

Identified and provided manpower and other resource requirements to ensure efficient completion of the project

Identified and assigned roles and responsibilities to team members

Monitor and measure project progress and prepare progress/status reports

Prepared standards in work procedures, documentations and programming, and change management to enhance efficiency and effectiveness

Led, managed, and coordinated a team of 10 people on a day-to-day basis

Liaised with project owner and end-users

Involved in the technical planning, design, and implementation of the database and the application

Developed data quality assurance criteria and procedures

Soluziona Phils. / Corporate Information Solutions, Inc.

Meralco Center, Ortigas, Pasig City, Philippines

July 2001 to Jan 2007

Client: Manila Electric Company Aug 2001 to Jan 2007

Pasig City, Philippines

Role: Datawarehouse DBA/Developer (Oracle 8i/9i):

Identified initial data volume and growth rate to determine data storage requirements.

Prepared 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.

Designed the ETL processes

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.

Perform regular database backups.

Wrote ETL jobs using Ascential DataStage ETL tool.

Wrote stored procedures/scripts to capture data changes using PL/SQL and 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.

USinternetworking, Inc./EnableVision LLC

50 Mt. Bethel Rd., Warren, NJ 07056 USA

May 2000 to June 2001

Role: Sr. Database Administrator / Developer 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.

Led and mentored junior DBA’s

Millenium Computer Systems

New York, New York, USA

Aug 1998 – Apr 2000

Client: Johnson & Johnson - Healthcare Systems, Inc. Aug 1998-Apr 2000

Piscataway, New Jersey, USA

Role: Database Administrator for Contracts and Rebates System (CARS)

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.

RCG Information Technology, Inc.

Edison, New Jersey, USA

Jun 1996 – Aug 1998

Client: AT&T Labs Jul 1996 - Aug 1998

Middletown, New Jersey, USA

Role: Database Administrator for the Business Maintenance Platform (BMP) - Managed Objects (MO)

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.

Computer Information Systems

Pasig City, Philippines

Jan 1991 – May 1996

Client: Electronic Telephone Service Industries, Inc. (ETSI)

Nov 1995 - Jun 1996

Worked 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, and wrote PL/SQL programs.

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.

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.

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

EDUCATION

Degree : B. S. in Electrical Engineering

Mapua Institute of Technology, Philippines

Contact this candidate