BERNADETH A. O. GATDULA

Ms. Gatdula is a Senior Database Developer/QA Analyst, with over 15 years
various experience in IT, systems development life cycle (SDLC).  Her most recent
experience is electronic data integration (EDI), extract-transform-load (ETL)
development using Oracle database management systems (DBMS) and its related tools
and utilities for data warehouse of financial exchange and CRM systems.  She has
strong coding, testing, maintenance and performance tuning experience using
PL/SQL, UNIX Shell script combined with Java, Perl, C, XML/HTML programming
languages. She has relevant experience in developing application programming
interfaces (APIs), stored procedures, functions, triggers for data replication,
interfaces or “glue” to Oracle ERP modules.  She has track record of delivering
quality work, has excellent communication skills, great attention to details,
team player and a fast learner.  Certifications obtained: Oracle PL/SQL, Object
Oriented Design Using Unified Modeling Language (UML), Sun Java Programmer.     


CAREER OBJECTIVES
Ms. Gatdula aims to use acquired technical skills, mainly Open Systems Unix,
Java with Oracle DBMS, for a systems and database application development
combined with quality assurance engagements.  She continuously looks for
opportunities that would allow her to be exposed to Oracle/Java/XML/UNIX/LINUX
and other Open Systems technologies and apply these into business process
solutions.  
  
PROJECT EXPERIENCE
For  TEKSystems:
The Allant Group, September 2009 to present
As Project Consultant, Ms. Gatdula performed senior programmer/analyst role for
client’s marketing data warehouse and customer relations management (CRM)
operations.  Particularly, she
 created ETL programs using PL/SQL, Perl and Unix Shell Scripts to load
data into the data warehouse or extract data from the data warehouse for
transmission to several marketing firms and for reporting and analytics purposes.
 She utilized these programming languages in conjunction with Allant’s
development framework “Prevalence” 
 prepared test plans, implementation procedures documentation
 coordinated final implementation to production ready systems using CVS
version control and provided system support
 coordinated and participated in performance tuning of several
data/tables utilizing techniques like table partitioning, SQL hints
Environment: Oracle 10G, Oracle 11, RAC, PL/SQL; Perl and Unix Shell Scripting;
SQL*Plus, SQL*Loader, Quest, TOAD, MS OFFICE; Novell Netware; Sun Solaris; LINUX;
CVS version control; Prevalence ETL tool

For Interactive Business Systems (IBS):
Chicago Board Options Exchange, Sep 2005 to May 2009
Intra-day trade transactions are copied, near real time, from distributed
trading systems into a consolidated database for temporary data store.  These
transactions are summarized and normalized and transferred to the final data
warehouse destination at end of trading day.  Data may also be transferred
to/from other regulatory firms electronically.  As Project Consultant, Ms.
Gatdula performed lead data modeler and developer roles for in-house data
warehouse application.  Particularly, she
 Participated in system enhancements, reengineering, streamlining with
activities such as data requirements gathering, process redesign, coding,
unit/system testing and assurance testing of most complex modules
 created ETL programs using PL/SQL and Unix Shell Scripts to load data
into the data warehouse or extract data from the data warehouse for transmission
to several options exchange regulatory firms and for reporting purposes 
 prepared test plans, implementation procedures documentation
 coordinated final implementation to production ready systems using
ClearCase and PVCS version control and provided system support
 coordinated and participated in performance tuning of several
data/tables utilizing techniques like table partitioning, SQL hints
 participated in program enhancements for Oracle upgrade (from Oracle 9i
to 10G)
Environment: Oracle 10G, Oracle 9i, RAC, PL/SQL; Korn Shell Scripting; Pro*C;
SQL*Plus, SQL*Loader, Quest, TOAD, MS OFFICE; MS NT; Sun Solaris; UNIX; PVCS
Version Manager;  BMC’s Control-M batch scheduler and work flow scheduler,
Control-D reporting tool and Remedy; Rational ClearCase

For Acxiom Corporation:
Philip Morris, Aug 2002 to Sep 2005
The project was aimed to maintain and support the customer relation (CRM) data
warehouse containing a tobacco company’s customers.  The database was used for
marketing and campaign management.  As a Solutions Developer, she performed the
following roles:
 Coding and testing a number of enhancement programs using Korn Shell,
C, Java and PL/SQL languages.  Program enhancements were created for fully
operational batch processes that loads, extracts and manipulates and formats them
using XML or flat ASCII files.
 Database investigation and implementing ways to improve data conversion
programs’ performance
 Developed deployment documents and participated in the actual
deployment to production
 Lead system and regression tester who created test plans and executed
them as part of the project’s quality assurance initiatives
 Participated in production support, defect logging and data and program
fixes
 Led the team in implementing configuration management process through
the use of version manager tool called PVCS
Environment: Oracle 9i, Oracle 8i; PL/SQL; Korn Shell Scripting; XML; Java/J2EE
DOM, SAX Parsers; C; SQLPlus, SQL Loader, TOAD, MS OFFICE; MS NT; HP True 64;
UNIX; BMC’s PVCS Version Manager; BMC’s Remedy (problem tracking system); IBM
VisualAge IDE Tool

For Spherion Corporation:
City of Chicago,  Jan 2001 – Aug 2002
The project was aimed at converting several large and small scale HR/Payroll
systems written in different languages and running in different platforms into an
enterprise-wide HR/Payroll packaged application (Oracle Application version 11i).
As Data Analyst/Lead Developer, was responsible for the following:
 Coding and testing a number of data conversion programs including Unix
Bourne Shell scripts
 Coding exchange data interfaces that transport data into or export data
out of Oracle Apps
 Performed load and integration tests on all programs created and
applied version control procedures to ensure that programs are properly
implemented in production
 Database investigation and implementing ways to improve data conversion
programs’ performance
 Developed implementation guide and participated in the actual
implementation
 Maintained all data conversion and interfaces programs for production
support
Environment: ORACLE 8i; PL/SQL; Bourne Shell Scripting; SQL Navigator; SQLPlus,
SQL Loader, TOAD, MS OFFICE; MS NT; Sun Solaris; UNIX
BlackVoices.com,  May 2000 – Oct 2000
The site is owned by Tribune Company.  It provides online magazine contents that
cater to African-American. Members of the site have access to free email, web
pages, chats and message boards.  As Data Architect/Developer, was responsible
for the following for site’s stabilization:
 Database investigation and finding ways to improve its performance
 Development of short term and long term solutions for performance
improvement
 Coded fixes to queries, executed optimization techniques such as index
creation, table partition and coding stored procedures
 Developed Perl scripts for data fixes and data conversion, site
statistic report and assisted in other ad hoc activities for marketing group
 Initiated stress testing for database performance checking; prepared
test plan and coordinated with QA to execute the plan resulting to increase in
performance by 29%
 Designed and created new tables for new site features
 Developed plan to migrate the database from Sybase to Oracle
Environment:  Interactive Web Community Page; Perl/CGI; HTML; Sybase; Bourne
Shell Scripting; ORACLE 8; Transact-SQL; Adaptive Server; DBArtisan; ISQL;
PL/SQL; SQL*Plus; SQL Navigator; MS OFFICE; MS NT; Sun Solaris, Reflection,
Apache Server

Various Clients Engagements with Fortune 500 US Companies March 1994 – Oct 1999
SBC-Ameritech
Enterprise Solution System (ESS), is a client server project for services
processing and fulfillment.  The system used Oracle suite of packages.  Ms
Gatdula was part of application team dedicated to build the interfaces between
several customers’ platforms for service order capture, billing and material
management.  She used PL/SQL, Oracle, Korn shell scripts for coding, unit and
integration testing.
Volkswagen Credit Inc.
The project was aimed to convert its existing interfaces for cash management,
order capture, billing and general ledger from “in-house” legacy system into
LeasePak (an integrated leasing package system).  As Systems Analyst, she was
involved in data mapping for the interface programs, created SQL queries to
extract data and coordinated integration testing of the interfaces.
For Accenture (formerly Andersen Consulting):
Pacific Enterprises and Anheuser Busch
Ms. Gatdula led an eight-person team in completing legacy programs to be Year
2000 compliant using Cobol in the mainframe environment.  She performed baseline
and after code testing to make sure that functionality is still met with the date
changes.  She was engaged in code and test results review and final submission of
programs to production

via World Network
Developed the Context Management Module (CMM) which is the 2nd tier interface
containing services that call “business-logic” APIs and translates the output
back to the “front-end” tier for display or playback on the interactive voice
response system (IVR).  The system handles online travel planning, booking,
transactions, ticketless travel, settlement, reconciliation and the capture of
travel usage data for corporate customers.  As a Lead Analyst/Programmer, Ms.
Gatdula led a team of 7 programmers to the delivery of CMM enhancements using
JAVA 1.1 as the programming language
Passenger Revenue Accounting (PRA)
The firm is a systems solution provider for several airlines to perform audits
of used airline tickets and release of debit/credit memos to travel agents.  As
Analyst/Programmer, Ms. Gatdula was responsible for the design of International
Trip Geometry program as one of the components of validation for International
Fair Audit (IFA) and Memo Notice Subsystems.  She developed new programs for
database load of airline pricing and rules using C and MicroFocus Cobol in the
UNIX environment.
Environment: JAVA; Shell Scripts; ORACLE 8; Oracle APPS 11i; SOLARIS UNIX; C;
COBOL; SAS; SYBASE; PRA; UCT; XVIEW; MICROFOCUS COBOL; Shell Scripts; IBM
Mainframe 3090; MVS/ESA; LeasePak; Visual Basic

Client Engagements in Philippine’s Top 500 Corporations Nov 1989 – Feb 1994 
San Miguel Corporation -- Served as part of the Management Reporting Finance,
Sales Delivery Management Construction Team that converted the text-based designs
to GUI applications.  Participated in its detailed design and was also
responsible for the following:
 Designed window layouts for the accounts receivable inquiry modules and
several sales delivery modules.
 Performed batch reports for the sales delivery modules.
 Coded Gupta’s SQLWINDOWS programs.
 Conducted and participated in code reviews and supported the
programmers in their coding and unit testing tasks.
Accenture (Internal Project) -- Financial Systems 90 (FS90) is a project that
handled project accounting, management and reporting from all consulting firm
branches world-wide.  As a team member who served on the Project Accounting
Development Team, was responsible for the following:
 Coded the Project Activity Posting Update, Project Extract and Format
Modules.
 Prepared test data, expected results and other documentation.
 Conducted unit and string tests of the modules.
Unilever Philippines  -- Conversion of  mainframe inventory, billing and
warehouse distribution systems to a packaged solution written in RPG 400.  As a
programmer, was responsible for the following:
 Performed the preparation of test data, expected results of the
inventory, accounts receivable and billing modules.
 Created system tests for the modules.
 Was responsible for monitoring and fixing the system’s investigation
requests and investigation of system errors for Accounts Receivable.
Radio Mindanao Network  -- Automation of broadcast advertising billing
applications:
 Performed coding, unit testing, expected results of advertisement time
slot inventory and billing modules.
 Created system tests for the modules.
Others Companies for Audit  -- Audit team member performing various auditing
tasks
Environments:  Warehouse Distribution; SQL WINDOWS; INFORMIX; SCO UNIX.  
Accounting and Financial; IBM 3090; MVS/ESA; COBOL II; DB2; CICS; DESIGN/1;
LOTUS NOTES; INSTALL/1; PANVALET; SPF; XPEDITER.
Billing; OS/400; RPG/400.
Advertising Time slot Inventory and Billing:  Clipper Database Programming,
Microsoft Office

EDUCATION
B.S., Business Administration and Accountancy, University of the Philippines,
Philippines.
Certificate Program Java Enterprise Edition (J2EE), Illinois Institute of
Technology, Illinois
Completed the following education and training courses:
-- Enterprise Java Beans (EJB) using WebLogic		-- Systems Installation School
-- Java 2 Programming					-- New Age Skills-C Programming
-- ASP Introductory Course/Visual Interdev		-- Business Practices School
-- Client/Server Technical Architecture Design		 -- Client/Server Application
Design
-- ACCENT on Client/Server				-- Conflict Management and Resolution
-- Computers in Our Practice School			-- Systems Design School			

Resume Updated:  12/27/2009