Michael Rebong
SUMMARY OF QUALIFICATIONS:
• 7 years experience as an Oracle Developer with specialization in
Development (10 systems, 500+ programs made), Migration (3500+
programs) and Administration (150+ users).
• Extensive experience in client-server (Oracle RDBMS 7.3, 6i, 8i) and
3-tier (Oracle RDBMS 9i, 10g) architectures in both UNIX and Windows-
based environments.
• Full SDLC development experience and has thorough experience in
creation of functional documents (business requirements, test plan &
cases, implementation, etc).
• Veteran Oracle Forms and Reports developer in either character-based
or GUI-based applications.
• Self-reliant DBA and has experience in Oracle 7/8i/9i/10g database
administration: backup (hot & cold), recovery (complete & incomplete),
import & export, database migration and installing security patches
and updates.
• Strong PL/SQL programmer: stored procedures, functions, packages,
database triggers, indexes, error handling and application tuning
using Explain Plan, TKPROF and analysis tools.
• Strong data loading and data retrieval techniques with experience in
external tables and Oracle Utilities: SQL*Loader, Import and Export.
• Technical hands-on expertise using OLAP tool Business Objects 4/5.x/
6.0/XIR2(Reports, Designer, Web Intelligence, Info view and
Supervisor)
• Has done ERP development in Manufacturing (SCM, OM), Trade Marketing
and Distribution, Finance (AP, PO, AR, GL, FA), HRMS/Payroll and BOM
domains.
• Diverse experience in different industries: Insurance, Realty,
Services and Manufacturing.
• Experienced in scripting for process automation.
• Has worked in PM capacity and has exceptional technical,
interpersonal and creative skills to assume vaguely defined projects
and oversee their completion with minimal management intervention.
TECHNICAL SKILLS:
Languages: SQL, PL/SQL, HTML, JSP, Javascript, PHP, script
Development Tools: SQL*Forms, SQL*ReportsWriter, Oracle Developer/
2000: Forms 4.5/Reports 2.5, Oracle Forms Builder 6i/9i/10g, Oracle
Reports Builder 6i/9i/10g, SQL*Plus, , TOAD/SQL Navigator,
Database and File Management: Oracle RDBMS 7.3, 8i, 9i, 10gR2, iAS
10g, CVS, Xpedio
Operating System: Windows /2000/NT/2003/CE, Linux 2.4.9-e.49, Mac OS
X, HP-UNIX
Business Intelligence Tools: SAP, Business Objects, Microsoft Office
2003/XP, MS Project/Visio
PROFESSIONAL EXPERIENCE:
Feb ’08 - Present
Home Box Office (HBO)
Programmer Analyst
New York
Program Planning System
Home Box Office (HBO) offers 24 hours television services to 40
million US subscribers. The system is used to create and generate TV
and movie programming schedules.
Accomplishments:
• Sole developer responsible for entire development and migration of
Program Planning system and has executed this major initiative from
beginning to end with minimal management oversight.
• Complete involvement with SDLC process (business requirement,
analysis, design, code, unit test, system test, implementation, post-
implementation, support).
• Technical Lead for the design, implementation and project roll-out/
deployment.
• Created Database Models both Logical (ERD, server-model, process
flow) and Physical (Parameter Files, Trace, Alert, Data, Temp, Redo,
Log Files, etc.)
• Development of 18 new Oracle Forms 10g and 14 new Oracle Reports 10g
programs, assuming both functional and technical roles.
• Development of PL/SQL program units: packages, oracle tables, stored
procedures, functions, cursors, triggers using TOAD, SQL Developer and
SQL*Plus.
• Responsible for the configuration, implementation and documentation
of all the business processes and IT structures.
• Migration of legacy client-server based system to Oracle 10g – 3-
tier environment.
• Created database objects (tables, indexes, synonyms, views) using
SQL*Plus and TOAD, used SQL*Loader control files to load data from
external data sources into Oracle database.
• Took part in System Design meetings and was counted on to provide
technical know-how.
• Customization of Business Objects Reports according the business
user requirements.
• Modified triggers, functions and procedures to accommodate on-going
changes in business logics, scripts to automate manual tasks using
oracle built-in packages.
• Formulated and Implemented Unit and System Test Cases.
• Conducts PL/SQL, Oracle Developer Tools, 3-tier/2-tier trainings
(group and one-on-one sessions).
• Served as the technological resource person: frequently liaising
with system and network administrators, business users and vendors to
discuss company needs and find ways to meet them.
• Created batch scripts for the automated update of database data.
• Support to over 40 business users and 3 in-house developers,
frequently gathering deliverables from stakeholders and formulating
strategies based on this information.
• Created documentation for the system (Technical Design, System
Architecture, System Manual, Disaster Recovery Plan, Installation
Notes)
Environment: Oracle RDBMS 10gR2, Reports Builder 6i/10, iAS 10g,
SQL*Plus, TOAD/SQL Navigator, Apple OS X, Windows XP, UNIX, Xpedio,
CVS, Business Objects
Mar ‘07 – Jan ‘08
British American
Tobacco
Oracle Developer
Chicago
Sales with Information Technology (SWIFT)
Global Tobacco manufacturing company involved in 180 markets
worldwide. The system is a comprehensive ERP application used in
Accounts Payable, Purchases, Inventories, Trade Marketing,
Distribution and more.
Accomplishments:
• Sole developer handling the entire application and database system
of the company - performing all development, documentation and
support.
• Development of Trade Marketing component of the system (comprising
of 11 Forms 10g and 3 Reports 10g), first assessing user needs and
writing the detailed descriptions of the steps required to meet them.
• Resolves a year-long problem involving discrepancies of figures
among Business Objects, Oracle and SAP databases, resulting in better
utilization of data for management needs.
• Administration of database backup (Hot & Cold), database recovery
(complete & Incomplete), database Import & Export, database Migration,
database upgrade from 9i to 10g on Windows environment and generating
Stats pack reports for Database.
• Uses SQL*Loader to sync spreadsheet & text data between Oracle
Database and Intermec Handsets.
• Administration of Business Objects, Oracle and SAP databases.
• Created various Business Objects analytical reports like Market
Share, Trending and Rank from multiple data providers
• Developed system monitoring scripts in csh and bash to monitor CPU
usage, memory, process count and conducted performance tuning as
necessary.
• Development of DRP (disaster recovery plan) for Swift system that
included setup of Oracle Database 10g R2 in Windows Server 2003
interfaced with Veritas for backups and Business Objects for
management reporting tool.
• Responsible for all configuration and installation of Oracle RDBMS.
• Implementation of security measures (automatic password expiration/
renewal, application privileges, user rights, etc.) that paved the way
for the IT department to pass International Audit.
• Creates database objects like tables, indexes, synonyms and views
using SQL*Plus/TOAD.
• Uses EXPORT and IMPORT utilities to migrate Oracle databases.
• Development of Stored Procedures, Functions, Packages, Triggers and
Table Constraints to enforce business rules and accommodate on-going
changes in business logics.
• Administration of production and reporting databases using Oracle
Enterprise Manager.
• Promotes better user utilization of the Swift system by conducting
presentations and seminars ensuring proper data coding and system use.
• Collaborated with system administrators and vendors to determine
hardware and architecture changes as may be needed by the company.
• Customized SAP, Oracle Reports and Business Objects reports for
higher management needs.
• Created UNIX shell and batch scripts for the automatic shutdown/
startup of DB, convergence of data among SAP, BO, and Oracle
databases, automatic upload/download from external tables, etc.
• Support for PL/SQL compile/runtime errors, debugs stored procedures
for business logic modification, grants and revokes schema object
privileges and roles and responds to system events through triggers.
• Provides system and unit support to all levels of the organization
including the 60 field-based salesmen.
Environment: Oracle RDBMS 10g R2, UNIX, Forms Builder 6i/10g, Reports
Builder 6i/10g, SQL*Plus, TOAD/SQL Navigator, SAP, Business Objects,
CVS, Veritas, Intermec Handsets.
Mar ‘06 - Mar ‘07
Jardine Properties / Jardine Land
Programmer Analyst
Ortigas, Philippines
Financial Ledger System
The system is used to set and maintain general ledgers for financial
reporting.
Accomplishments:
• Development of additional modules to the system with accompanying
technical design documents for conversions, extensions, interfaces and
reports.
• Migration of entire system from Developer 2000 to Developer 6i for a
total of 81 Forms, 265 Reports, 2 package libraries and 1 menu
programs.
• Set-up financial system monitoring for Balance Sheet, Income and
Cash Flow Statements using Oracle Forms 6i.
• Administration of Oracle Financials (AP, AR, GL, FA) system.
• Development of PL/SQL constructs: Stored Procedures, Functions,
Packages and Triggers to enforce business rules
• Investigation and solution of abnormalities in transactions where
there are deviations from expected values such as in Profit and Loss
Statements.
• Generated Business Objects reports involving complex queries, sub
queries, unions and intersection.
• Administration of production and reporting databases using Oracle
Enterprise Manager, Oracle SQL Developer, TOAD, Oracle Import/Export,
SQL*Loader.
• Provides sole support for the entire system (10 business users) and
was responsible for all development and documentation.
Environment: Oracle RDBMS 7.3/8i/10g, Forms Builder 4.5, Reports
Builder 2.5, Forms Builder 6i/10g, Reports Builder 6i/10g, iAS 10g,
SQL*Plus, TOAD/SQL Navigator, Oracle Designer/2000.
Attendance Monitoring System
The system is used to record and monitor employee time-ins, time-outs,
absences and leaves.
Accomplishments:
• Enhances the system through the creation of additional modules
(leave and absences credits, detailed overtimes, time-in/time-outs and
lates monitoring applications).
• Migration of entire system from Developer 2000 to Developer 6i/10g
for a total of 15 Forms, 16 Reports, 2 package libraries and 1 menu
programs.
• Development of Oracle Reports 6i/10g programs for leave and absences
credits, detailed overtimes, time-in/time-outs and lates monitoring.
• Provides 1st level user support to over 12 business users.
• Administration of Oracle HRMS/Payroll/OTL system.
• Customized development of PL/SQL constructs (procedures, functions,
packages).
• Provides sole support for the entire system (4 business users) and
was responsible for all development and documentation
• Generates Oracle Report and Excel financial reports for management
use.
• Created documentation for the entire system.
Environment: Oracle RDBMS 7.3/8i/10g, Forms Builder 4.5, Reports
Builder 2.5, Forms Builder 6i/10g, Reports Builder 6i/10g, iAS 10g,
SQL*Plus, TOAD/SQL Navigator
Project Monitoring and Construction System
The system is used for all construction related transactions like
awarding of contracts, job/purchase orders, billing and material
purchases.
Accomplishments:
• Migration of entire system from Developer 2000 to Developer 6i/10g
for a total of 84 Forms, 151 Reports, 2 package libraries and 1 menu
programs.
• Development of several template programs for use in Job and Purchase
Orders using Oracle Forms 6i/10g.
• Development of Oracle Reports 6i/10g programs regarding Job/Purchase
Orders and Payment Schedules.
• Analyzes business processes on Site Production and designed ways to
automate and streamline current practices using Oracle Forms 6i/10g
and Reports 6i/10g as tools.
• Provides sole support for the entire system (40+ business users).
• Sole programmer responsible for the development, documentation and
maintenance of system.
• Created Documentation for the entire system.
• Provided trainings and seminars to staffs to enhance their ability
to use the system.
Environment: Oracle RDBMS 7.3/8i/10g, Forms Builder 4.5, Reports
Builder 2.5, Forms Builder 6i/10g, Reports Builder 6i/10g, iAS 10g,
SQL*Plus, TOAD/SQL Navigator, Oracle Designer/2000
Accounts Receivable System
The system is used for billing transactions with customers.
Accomplishments:
• Migration of entire system from Developer 2000 to Developer 6i/10g
for a total of 525 Forms, 1687 Reports, 8 package libraries and 14
menu programs.
• Modifies and revised existing programs based on user
specifications.
• Provides 1st level user support.
• Sole programmer responsible for the development, documentation and
maintenance of system.
• Created Documentation for the entire system and was involved with
user trainings.
Environment: Oracle RDBMS 7.3/8i/10g, Forms Builder 4.5, Reports
Builder 2.5, Forms Builder 6i/10g, Reports Builder 6i/10g, iAS 10g,
SQL*Plus, TOAD/SQL Navigator
Customer Communication System
The system is used to record all customer concerns.
Accomplishments:
• Development of the system from the ground up, conducting all
requirements analysis and design, development, testing, implementation
and maintenance.
• System Implementation on client’s site and provides both hardware
and software 1st level user support tasks.
• Sole programmer responsible for the development, documentation and
maintenance of system.
• Provides sole support for the entire system (15+ business users, 30+
agents).
• Created Documentation for the entire system.
• Conducted trainings and seminars on business users.
Environment: Oracle RDBMS 7.3/8i/10g, Forms Builder 4.5, Reports
Builder 2.5, Forms Builder 6i/10g, Reports Builder 6i/10g, iAS 10g,
SQL*Plus, TOAD/SQL Navigator, Oracle Designer/2000
Broker Communication System
The system is used by Jardine’s several Brokerage house partners for
sales monitoring.
Accomplishments:
• Development of the system from the ground up, conducting all
requirements analysis and design, development, testing, implementation
and maintenance.
• Uses Oracle Developer and Oracle Designer for design tasks.
• Sole support for the entire system (30+ agents).
• Conducts Oracle trainings for better utilization of system.
• Created Documentation for the entire system.
Environment: Oracle RDBMS 7.3/8i/10g, Forms Builder 4.5, Reports
Builder 2.5, Forms Builder 6i/10g, Reports Builder 6i/10g, SQL*Plus,
TOAD/SQL Navigator, MS-DOS, Oracle Designer/2000
Aug ‘02 - Mar ‘06 Pioneer
Insurance & Surety Corporation
Programmer Philippines /
Hong Kong
Non-Life Insurance Information System - HK
The system is used to support the non-life operations of Pioneer
Insurance Hong-Kong Branch.
Accomplishments:
• Debugs 200+ Oracle Reports 2000/8i/9i/10g and Oracle Forms 2000/8i/
9i/10g programs.
• Creation of new Oracle Reports and Oracle Forms programs based on
user specifications.
• Assists in design tasks such as debugging, specifications
development and system integration testing.
• Provides technical assistance and user support functions.
• Participates in action planning and implementation.
• Created documentation for each phase in the SDLC (specifications,
test cases, installation notes).
Environment: Oracle RDBMS 7.3/8i/9i/10g, Windows 98/XP, Redhat Linux
2.4.9-e.49, SQL*Forms, SQL*ReportsWriter, Oracle Developer 2000/6i/9i,
iAS 10g, CVS, SQL*Plus, TOAD.
Non-Life Insurance Information System - PH
The system is used to support the non-life operations of Pioneer
Insurance Philippines.
Accomplishments:
• Migration of 500+ Oracle Forms 4.5/6i programs to Oracle Forms 9i,
amounting to contribution rate of 19% in a 6 member team.
• Migration of 300+ Oracle Reports 2.5/6i programs to Oracle Reports
9i, amounting to a contribution rate of 36% in a 6 member team.
• Development of 100+ Forms 6i and Report 6i programs based on user
specifications.
• Average work rate of 144 programs per month.
• Standardized more than 1,000,000 lines of code based on programming
convention set by the company.
• Debugs 200+ Forms/Reports programs.
• Loaded test data into Oracle 7 using SQL*Loader and Import utilities
to enable the testing of newly created or revised applications.
• Development of stored procedures, functions, packages, tablespaces,
tables, sequences and other Oracle objects using Oracle Designer.
• Assists in design tasks such as debugging, specifications
development and system integration testing.
• Provides 1st and 2nd level user support functions and assists in the
training of technical staffs.
• Participates in analysis, conversion coding, code walkthrough and
unit/integration testing.
Environment: Oracle RDBMS 7.3/8i/9i/10g, Windows 98/XP, Redhat Linux
2.4.9-e.49, SQL*Forms, SQL*ReportsWriter, Oracle Developer 2000/6i/9i,
iAS 10g, CVS, SQL*Plus, TOAD.
EDUCATION:
Bachelor of Science in Computer Engineering (85% GPA, top 10% in
class).
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"project managment" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/project-managment
-~----------~----~----~----~------~----~------~--~---
