Christopher Agozar Cabrera

SUMMARY OF COMPETENCE
A Senior Developer with over 18 years of experience as an Oracle PL/SQL Developer. Some extensive Unix shell scripting or programming for almost 7 years. Recently, I have been performing L2 Production Support for AML Datamart, Mantas and Actimze. Have a good understanding of Project Management Framework, SDLC Methodology as well as Service Management and Delivery.

A quick-learner and focused problem-solver with proven analytical and multi-tasking skills. Hardworking and flexible as a team player and at the same time a dependable team leader with the can-do attitude. Able to deal with people at various levels of technical and business expertise. Has performed knowledge transfer sessions and has effective presentation and interpersonal skills.

PROFESSIONAL CERTIFICATIONS
 

·         Debt Manager Associate (Barclaycard Singapore)

PERSONAL INFORMATION
Qualification:
Systems Analyst / Programmer

Email Address
[email protected]

Mobile Phone
SG : +65 9844 4424

Date of Birth:
November 16, 1975

Place of Birth:
Taal, Batangas

Sex:
Male

Height:
170 cms.

Weight:
82 kgs.
EDUCATIONAL BACKGROUND
College
University of Santo Tomas

B.S. Mathematics

Major in Computer Science

1992 – 1996

High School
Marist School

High School Diploma

1988 – 1992

Prep – Grade 6
Marist School

Grade School Diploma

1981 – 1988
 

Company
Emerio Infotech Pte Ltd
Period :
Sep 29, 2014 – Present

Client:
Citibank (Singapore)
Position/s:
L2 Production Support Data Analyst
Job Description:
–          Initially part of the Data Request team that provide reports (adhoc, Monthly and Weekly) requested.

–          Coordinates with the requestors (Business users, Regional Compliance and other applications team) regarding the incident or request tickets they have raised.

–          Developed SQL scripts and PL/SQL block to produce an accurate data requested.

–          Performed simple SQL tuning to produce large quantity of data and an accurate output.

–          Performed Production deployment which involves the SDLC.

–          Performed data analyst for AML Datamart, Mantas & Actimize system with regards to alerts or clarifications regarding the system.

–          Coordinated with different Groups and Teams to resolve issues raised with regards to AML Datamart, Mantas & Actimize system.
Project/s Assigned to:
AML Datamart

Mantas

Actimize

Company
Encora Technologies Pte Ltd
Period :
Dec 10, 2012 – Aug 29, 2014

Client:
Barclays (Singapore)
Position/s:
Software Consultant
Job Description:
–          Maintenance of Oracle Packages (functions and procedures) for Debt Manager

–          Coordinates with users for Production issues or UAT sign-offs

–          Develops SQL queries to be used by Debt Manager

–          Develops Debt Manager design for country specific requirements

–          Creates Functional Specs for country specific change requests

–          Supports or coordinates during User Acceptance Testing

–          Supports or coordinates during Production Deployment

–          Prepares object(s) for deployment
Project/s Assigned to:
Debt Manager BAU Change Request

Company
Emerio Infotech Pte Ltd
Period :
May 24, 2011 – Nov 11, 2012

Client:
Citibank (Singapore)
Position/s:
Oracle Consultant
Job Description:
–          Backend programming using PL/SQL.

–          Maintenance of stored procedures and scripts using PL/SQL.

–          Used Informatica for report generation and other UNIX commands

–          Program and / or SQL tuning for new and existing procedures for HRAC and Mantas

–          Done shell scripting in Unix environment which calls ORACLE objects or packages

–          Creation and maintenance of Oracle Packages (functions and procedures) for HRAC and Mantas

–          Done some minor DBA functions in HRAC and Mantas environment. (index creation, partition creation, & grants)

–          Creates Adhoc Reports using SQL queries

–          Involved in HRAC / Mantas Production Support

–          Monitors Disk Space in DB and Apps Server(s) with 20TB capacity total

–          Coordinates with users for Production issues or UAT sign-offs

–          Monitors Batch Job process in production
Project/s Assigned to:
HRAC

Mantas

Company
Software Laboratories, Inc
Period :
Jun 24, 2004 – May 23, 2011

Client:
Smart Communications Inc.
Position/s:
Developer Programmer
Job Description:
–          Backend programming using PL/SQL.

–          Maintenance of stored procedures and scripts using PL/SQL.

–          Customize or deploy Oracle forms (objects) using Forms 6i into Oracle 11i Apps.

–          Customize and develop forms and reports using ORACLE 6i Forms & Report

–          Worked on an 8i and 9i ORACLE database environment

–          Used ORACLE Workflow Builder v 2.6

–          Program and / or SQL tuning for new and existing packages in CSP (Customer Solution Platform) Production

–          Migrated from ORACLE 9i to 11g

–          Been part of SMART CSP SRM (Service Request Management) and CRM (Customer Relation Management) group

–          Done shell scripting in Unix environment which calls ORACLE objects or packages

–          Creation and maintenance of Oracle Packages (functions and procedures) for CSP

–          Done some minor DBA functions in CSP Dev environment. (index creation, partition creation)
Project/s Assigned to:
CSP (Customer Service Platform)

Company
ITM (Information Technology Managers, Inc.)**
Period :
Aug 1, 2003 – Apr 12, 2004

Client:
GlaxoSmithKline
Position/s:
Developer Programmer / SFA Administrator
Job Description:
–          Backend Report generation using SQL Plus.

–          Data monitoring of the SFA system.

–          IPAQ software installation and maintenance.
Project/s Assigned to:
SFA (Sales Force Automation)

Company
Information Professionals Inc
Period :
Oct 14, 2002 – Feb 28, 2003

Client:
SQL Wizards
Position/s:
IT Consultant
Job Description:
–          Regeneration and screen adjustments Phoenix System (PGA Client) screens for conversion to Designer 6i.

–          Maintains Phoenix reports (EIC Client) using Reports Builder v 2.5.

–          Customization of Phoenix System (GSIS Client) forms and reports using Designer 2.1, Forms Builder 5, Reports Builder 3, PL/SQL Developer and ORACLE Discoverer 4.
Project/s Assigned to:
EIC (Equitable Insurance Corporation)

PGA (Prudential Guaranty Assurance)

GSIS (Government Service Insurance System)

Company
HGC(Home Guaranty Corporation)**
Period :
Aug 1, 2000 – Sep 3, 2002

Position/s:
ORACLE Developer
Job Description:
–          Developed Cash Flow Information System, PAIS(Project Accounting Information System), ARMS (Account Receivables Management System), CAIS (Corporate Accounting Information System), PIS (Personnel Information System), GLIS (General Ledger Information System), DGIS (Developmental Guaranty Information System) and PRMS (Project Receivables Monitoring System) modules using DEVELOPER 2000(Forms 4.5 & Reports 2.5).

–          Converted raw data to control file/s using SQL Loader.

–          Performed quality assurance tasks.

–          ARMS System implementation.
Project/s Assigned to:
Cash Flow Information System

PAIS(Project Accounting Information System)

Company
RCG Information Technology Philippines Inc
Period :
May 1, 1998/Feb 1, 2000 – Jul 31, 2000

Client:
Home Guaranty Corporation
Position/s:
ORACLE Developer
Job Description:
–          Developed PFIS(Provident Fund Information System) and JBIS(Journal Book Information System)  modules using DEVELOPER 2000(Forms 4.5 & Reports 2.5).
Project/s Assigned to:
PFIS (Provident Fund Information System)

JBIS (Journal Book Information System)

Client:
RCG (Head Office)
Position/s:
ORACLE Designer

Visual Basic 6 Programmer
Job Description:
–          Helped in the initial design stages of Bed Bath & Beyond System using Designer 2000.
Project/s Assigned to:
Bed Bath & Beyond System

Client:
PLDT
Position/s:
ORACLE 8I Developer
Job Description:
–          Maintained and developed stored packages and procedures.

–          Maintained and developed TDAS (Traffic Data Administration System) forms using ORACLES 8I (Forms 5.0 and Reports 3.0)
Project/s Assigned to:
TDAS (Traffic Data Administration System)

Client:
RCG (Head Office)
Position/s:
Visual Basic 6 Programmer
Job Description:
–          Developed In-house system for Accounting Department(computes number of hours worked per employee and/or per department) using Visual Basic 6.
Project/s Assigned to:
Timesheet Monitoring System

Client:
PLDT
Position/s:
ORACLE (7 & 8I) Developer
Job Description:
–          Developed, documented and maintained the Traffic Data Administration System(TDAS).

–          Developed and maintained stored packages and procedures.

–          Developed and maintained menu and query screens using ORACLE 7 & 8I as the back end and Developer 2000 (Forms 4.5 & 5.0 and Reports2.5 & 3.0) as the front end tool  using client server technology.

–          Directly interacts with the customer on ongoing procedures regarding preparation of user requirements specifications and other Information System (IS) related task.
Project/s Assigned to:
TDAS (Traffic Data Administration System)

Client:
AIU
Position/s:
Visual Basic 5.0 Programmer

Sysbase Programmer
Job Description:
–          Developed MARCO to GOALD Mappings(Uploading of raw data to database tables) using Visual Basic 5.0 and DBArtisan 2.56 (SYSBASE).
Project/s Assigned to:
MARCO(Philippines)

Client:
PLDT
Position/s:
ORACLE 7 Developer
Job Description:
–          Developed TDAS Modules using DEVELOPER 2000 (Forms 4.5 and Reports 2.5).

–          Developed batch file/s for TDAS.

–          Developed, documented and maintained the Traffic Data Administration System(TDAS).

–          Developed and maintained stored packages and procedures.

–          Developed and maintained menu and query screens using ORACLE v7.2.3 as the back end and Developer 2000 (Forms 4.5 and Reports 2.5) as the front end tool  using client server technology.

–          Prepared test data to check all aspects of the program.

–          Directly interacts with the customer on ongoing procedures regarding preparation of user requirements specifications and other Information System (IS) related task.
Project/s Assigned to:
TDAS (Traffic Data Administration System)

Company
Infolink Placement & Computer Services
Period :
Jan 2, 1997 – Nov 15, 1997

Client:
Citibank, N.A. APSC
Position/s:
Analyst/Programmer Consultant

Visual Basic 4.0 Programmer

Customer Activated Terminal (CAT) Developer

Customer Activated Terminal (CAT) Product Tester
Job Description:
–          Developed BOSS (Back Office Support System)  which consists of 6 different systems (House Keeping, MEP, Disbursement, Purchase Order, Fixed Assets and Inventory) using Visual Basic 4.

–          Developed RSN Thailand (Prototype) using Visual Basic 4.

–          Developed Indexing  using Visual Basic 4.

–          Developed ATM software (RSN)  using AGS.
Project/s Assigned to:
BOSS (Back Office Support System)

RSN (Regional Shared Network)

RSN Thailand (Prototype)

Indexing

COMPUTER MACHINES HANDLED
PC Compatibles

Turbo Pascal

Visual Basic 4.0, 5.0 & 6.0

MS Word, Access, Excel, Visio

Novell Netware

Authorware Professional

Cobol

Developer 2000 (ORACLE 7)

ORACLE 8I Database

Designer 2000

DBArtisan 2.56 (SYSBASE)

Designer 6i

Oracle 11i (CRM Apps)

ORACLE 6i (Forms & Reports)

ORACLE 9i Database

ORACLE 10g Database

ORACLE 11g Database
Sun SparcStation 5

UNIX OS (Solaris)

Application Generation System
 

REFERENCES
Name : SANTOS, Ditas (Dits) A.

Title : Manager

Company : Smart Communications, Inc.

Email : [email protected]

Celphone No.: +6329189487886

Tel. No.: +6325116251

Name : John Christian Yee

Title : Application Support Analyst

Company : Credit Suisse

Email : [email protected]

Celphone No.: 82168387

Tel No.: 82168387

Name : Aileen Valencia

Title : Software Development Analyst

Company : Smart Communications, Inc.

Email : [email protected]

Celphone No.: +6329297700917

Tel. No.: +6325116252