Project Oracle
Resume:
Title:Apple Developer
***********@******.***
Document
Source below
NAME:,
ADDRESS:
ADDRESS2:
CITY:
STATE:
ZIP:
CANDIDATE ID: 2574776
US CITIZENSHIP:
EDUCATION:
EXPERIENCE: 0
WILL RELOCATE: No -
JOB WANTED:
RATE NEEDED:
TELEPHONE: 382*******
EMAIL: ***********@******.***
HOMEPAGE:
HOTTEST SKILLS: oracle, database, programmer, vms, cobol, unix, lien, sql, programming,
fortran, information technology, microsoft, product, payroll, cms, information systems,
java, technical writ, inventory, statement
REVISION: 07-SEP-02
RESUME:
Resume: Jeniwati Ampualam
Expertise : Oracle
DBA
Availability : -
Email : ***********@******.***
Contact : 603-***-****
Presentation of Qualifications
Jeniwati Ampualam
Oracle Database Administrator
Project Leader
System Analyst / Programmer
SUMMARY
A self-motivated, enthusiast and
discipline team player with extensive experience and knowledge in
Information Technology area. Have twelve years of experience in
various area in information technology, from programmer/system
analyst with various programming and tools, Oracle database
administration, customer support, and Project Leader. Experience
to work in various Operating System, included UNIX, Open/VMS, and
Windows/NT, and as DBA for Oracle and MUMPS database, programmer
for various 3GL programming languange and tools.
As Oracle DBA, have performed
database administration tasks, such as database creation,
database setup, define database structure, manage database
objects and users, define strategy for database backup and
recovery, and database performance tuning, in various projects.
Also experience in doing various Oracle product installation and
setup. Have extensive experience in all phases of software system
development life cycle and in customer support and problem
solving. Have comprehensive experience in working with customer,
as well as with team member and partner. Have strong knowledge
and interest in OLAP systems technology.
HARDWARE
Digital Alpha
Digital VAX
PC s
SOFTWARE
Database : Oracle, MUMPS.
Database Tools : Oracle
Enterprise Manager, Oracle Enterprise Backup Utility,
Polycenter NSR for Oracle (System management tool)
Tool : Oracle Developer/2000
3GL Language : COBOL, BASIC,
MUMPS
O/S : Digital UNIX, Open/VMS,
Windows NT, Windows 95.
SELECTED EXPERIENCE
PT
. Astra Graphia Jan 96 to Present
Business Information Technology Group
PT Astra Graphia, Business
Information Technology Group (AGIT) is one of the biggest System
Integration company in Indonesia. AGIT is part of Astra group,
the big and recognized group in Indonesia. It has many
partnership with the international primary player in Information
Technology, such as with Oracle (as Oracle Primary Partner),
Microsoft (as Microsoft Solution Provider and Microsoft VAR),
Sybase, CISCO, Anixter, etc. It also has won many awards, such as
Best MCSP of the year, Best Partner of Anixter, Best Partner for
Oracle, Best Revenue Contributor (for Select) for Microsoft, etc.
AG-IT has also won much
prestigious high value System Integration project in Indonesia.
Title: Integration Specialist,
DBA, Group Leader
Jobs Specification:
As the Oracle Specialist,
responsible to perform DBA task for all database project,
including database creation, database setup, define
database structure, manage database objects and users,
define backup and recovery strategy, and database
performance tuning Also to install and set various Oracle
product in UNIX, Open/VMS, and Windows/NT environment for
customers
Support the directory
assistance application (using MUMPS database), and lead
the technical team for any new project in this area (Y2K,
Integration/modification).
Lead the database competency
group assist the new database group member,
develop group strategy and the career path.
Member of Data Warehouse
Group develop the methodology for data warehouse
project with the team, and support the project
implementation.
Projects
have been done :
PT. Elnusa Yellow Pages
Application Tuning.
Perform the
Application Tuning with another consultant, by
redesigned some tables and restructured the SQL
statement. The result of the tuning was very
significant, until 30 times faster for some
queries. Also responsible to recreate the
database, and setup new parameter.
Hardware : Digital Alpha
UNIX (Server), and PC Windows 95(Client).
Software : Oracle (Server),
Entera (middleware), and Visual Basic (Client).
Role : DBA
PT. Telkom MGTI - Network
Management System.
Perform the Oracle installation,
setup and create database in cluster Available Server
environment, set up the backup and restore strategy, install and
setup database dictionary for Oracle Enterprise Backup Utility
(OEBU), create and test backup script using the Oracle Enterprise
Backup Utility (OEBU) and Polycenter Network Save and Restore
(NSR). Also responsible to create and set up database environment
in backup machine, and develop scripts to transfer data from
operational to backup database. This is a 24 hour operated
application in a complex environment, using 5 Digital Alpha
Server.
Hardware : Digital Alpha
UNIX (Server), Digital Alpha Workstation & PC
Software : Temp Network
Management Software, Oracle RDBMS, Polycenter System Management
Tool, Oracle Enterprise Backup Utility.
Role : DBA
Excelcomindo, GSM
telecommunication provider - Data Mart.
Perform Oracle installation,
physical database design, setup the environment and connectivity
to data source and client, create development database and
operational database, and perform parameter tuning for getting
the best performance.
Hardware : Digital Alpha
Turbolaser - UNIX (Server), PC NT (Extraction Server), PC
Windows 95 (Client)
Software : Oracle RDBMS,
PowerMart (Extraction tool), Business Object (Query Tool), Oracle
Enterprise Manager (DBA tools)
Role : DBA
Bank BNI 46 Data
Mart System.
Perform Oracle installation,
database parameter tuning, and assist customer s DBA.
Hardware : Digital Alpha Server
UNIX (Server), PC (Client)
Software : SAS program (Data
Extraction), InfoBeacon (Query tool), Oracle Enterprise Manager
(DBA tool)
Role : DBA support
Federal Motor
Manufacturing Application Tuning.
Work together with a consultant
from Oracle Singapore to fine-tune the product line application
in a motorcycle manufacture. The application was developed using
Designer/2000 and Developer/2000, and had many ineffective
coding. After restructuring the SQL statements and the database
files, changing database parameter, the performance is improved
very significant.
Hardware : Digital Alpha - VMS
Software : Oracle RDBMS, Oracle
Developer/2000, Oracle Designer/2000
Role : DBA
Bank Indonesia
Application Conversion
Application was converted from
file system on FORTRAN to be a combination of Fortran,
PRO*Fortran, Oracle Forms and Reports using Oracle database.
My involvement in this project was
as Database Specialist/Consultant for the sub-contractor who did
the conversion. I did the installation of Oracle engine,
Forms3.0, and Report, and prepared the environment for the
development machine. I was also responsible as a quality control
for the database design of the sub-contractor.
Hardware : Digital VAX
Open/VMS
Software : Oracle RDBMS,
Pro*Fortran, Fortran, Oracle Forms, Oracle Report
Role : DBA and Database
Consultant
PT. Telkom MGTI
Disturbance Report Application System
Gather customer requirement,
design application, design logical and physical database, and
lead the development team. I was also responsible to set up the
environment, installed Developer/2000 in the PC-LAN Server,
coordinated with the customer s IS team to set up the LAN
environment for application users.
Hardware : Digital Alpha
UNIX (Server), PC (Client)
Software : Oracle RDBMS,
Developer/2000
Role : DBA, System Analyst,
Team Leader
PT. Telkom Telephone
Directory Information Services
This Y2K project is to upgrade and
modify the Telephone Directory Services Application in Jakarta
and Surabaya to be Year 2000 ready. I am responsible to upgrade
the DSM and lead the programmer to modify the Y2K affected
application. Also, to lead the technical team to make sure that
the upgrading process runs smoothly, without affecting the
operation as these 24-hour public services.
Hardware : Digital Alpha
Open/VMS (Server)
Software : DSM (Digital
Standard MUMPS)
Role : Team Leader, MUMPS
Administrator
PT. Telkom MGTI
Integrated Telephone Directory Information Services
This project is to integrate the
108 (telephone information) database and provide centralized
services for all cities in Central Java area. As the Application
Project Leader, I am responsible to gather user requirement, lead
the development team to modify and integrate existing system,
manage change request, arrange technical training with
Intersystem Inc., prepare user-training material and user manual
with technical writer, conduct the training, and develop
documentation.
Hardware : Digital Alpha
Open/VMS (Server)
Software : DSM (Digital
Standard MUMPS)
Role : Team Leader, System
Analyst, Instructor
PT. Digital Astra Nusantara Apr 92 to
Dec 95
Consulting Dept., Jakarta
PT. Digital Astra Nusantara is the
joint-venture company between Digital Equipment Corporation and
PT. Astra Graphia. PT. Digital Astra Nusantara and PT. Astra
Graphia was managed as one company with 2 legal entities. Because
of Indonesian rules, PT. DAN is mainly the Services Company,
while PT. Astra Graphia as the Digital computer seller.
Title:
Software Specialist, System
Analyst/Programmer
Jobs Specification:
As the Software Specialist, I am
responsible to work on various projects for Digital s
customer, and also to support the pre-sales activity for
Client/Server project as a database specialist.
Projects have been done:
VICO Inc
. Outsourcing
Project.
Worked as
Programmer/Analyst
in
the outsourcing project for VICO Inc
. My main task was to modify
the Inventory system, and develop a new subsystem for the
Purchasing system, both in COBOL. and using VAX/FMS as the form
design tools, VAX/CMS as the code management tools, and VAX/CDD
as data dictionary tools. The project was done in a team of 5
technical people. Beside that, I was also assigned to support the
IS team in their daily job, such as helping to modify some
application, fixing bugs in various system, etc.
Hardware : Digital Alpha
Open/VMS
Software : COBOL, VAX/FMS,
VAX/CMS, VAX/CDD.
Role : System
Analyst/Programmer
PT.PENI. Payroll System
Modification.
Develop additional features of
PENI s Payroll System. The responsibility was to gather
customer requirement, code the new features, modify existing
programs that are affected by this new features. This project is
finished in 5 months.
Hardware : Digital VAX
VMS
Software : COBOL
Role : System
Analyst/Programmer
PT. Telkom. Telephone
Directory System.
This project is to implement the
108 service (Telephone Information) in 5 big cities in Indonesia.
The application is owned by Digital-Telecom Ireland, and use
MUMPS as database and programming language. I joined the
technical team, with responsibility to learn the MUMPS
programming and the application, to be able to make modification
and fix problem. After the implementation, I also responsible for
customer support for this system.
Hardware : Digital Alpha
VMS Cluster
Software : DSM (Digital
Standard MUMPS)
Role : System
Analyst/Programmer
Dataquick Information Systems Inc
. Sep
90
to Jun 91 San Diego, USA
Dataquick Information Systems,
Inc. is the company that sells information about the houses in
California and part of Arizona.
Title:
System Analyst / Programmer
Jobs Specification:
As the member of Development Team,
responsible to develop a new system or new features in existing
system, develop data loading and data validation program.
Projects have been done:
On-line Real Estate Database
Project.
This project is to develop the
online system for querying the real-estate database. I was
responsible to develop the load programs, test and load the data,
and make the summary report of each database loaded. The data
came from another company (in reel-tape), and must be validated
and analyzed before loading into database. I was also responsible
to make programs on searching the data and creating report.
Hardware : Tandem - Guardian
Software : COBOL
Role :
Programmer/Analyst
Flat-file to RDBMS Migration
Project.
Assigned as the member of the
fore-runner flat-file to relational database conversion team. The
team responsibility are to set the programming standards in SQL
for all the development team, to design the database, to convert
flat-file system into relational database model, and to create
COBOL programs using embedded SQL to process data.
Hardware : Tandem - Guardian
Software : COBOL, Embedded SQL
Role :
Programmer/Analyst
PT Altamira Ekatama
Jun 84 to Jul 88
PT. Altamira Ekatama in Bandung is
the car-dealership that has many branches in many cities in
Central Java, Indonesia. The management of the company was very
committed with the information technology. Started with 1 System
Analyst/Programmer to develop application to support daily
operation, the EDP department grew to have 5 System
Analyst/Programmer and 5 Programmer in 3 year.
Title:
System Analyst / Programmer
Jobs Specification:
Responsible to develop new
application system, gather requirement, design, code, test, and
implement system. Also responsible for user training, and the
operation of the application.
Projects have been done:
Inventory System, Credit
System, Spare Part and Service System
Design, code, test and implement
the system. Also responsible for user training and operation
support.
Hardware : Tandy RadioShack
-Xenix
Software : BASIC, COBOL
Role : System
Analyst/Programmer
Finance, and Payroll system.
Design, code, test and implement
the system. Also responsible for user training and operation
support.
Hardware : Digital VAX
VAX/VMS
Software : COBOL, TDMS (Forms
tools), CDD (data dictionary)
Role : System
Analyst/Programmer
TRAINING/COURSES ATTENDED
System Query Language
(SQL) at TANDEM, by Dataquick, 1990.
Executive Information
System by Astra Graphia & NIIT, 1992.
Programming using
VAX/Rdb SQL, by Digital Astra, 1993.
Windows NT vs. UNIX,
by Digital Astra & Solution Inc. USA, 1993.
Relational Database
Design, by Digital Astra & NIIT, 1993.
VAX/DSM System
Manager, by Digital Hongkong, 1994.
OSF/1 Utilities and
Commands, by Digital Astra, 1995.
OSF/1 System
Administration, by Digital Astra, 1995.
DEC/Message-Q, by
Digital Astra, 1995.
Software Project
Management, by Digital/NIIT, 1995.
Successful Migration
to Open client/server, by Digital/UCLA, 1995.
Oracle7 DBA-7A, by
Sisindosat, Jakarta, 1995.
Oracle7 DBA-7B, by
Oracle Sdn.Bhd. Kuala Lumpur, 1995.
Oracle Tuning and
Trouble-shooting, by Oracle Singapore, 1996
Oracle Developer/2000
set classes, by Oracle Indonesia, 1996
Oracle Designer/2000
set classes, by Oracle Indonesia, 1996.
Seminar DBA : A
Structured Approach, by Oracle Netherland, 1996
Oracle OpenWorld
seminar, Brisbane Australia, 1996
Seminar Oracle8 New
Features, by Oracle Indonesia, 1997
Information Mapping
Technical Writing, by TACTICS Malaysia, 1997
DataWarehouse
seminars, by Digital Astra, 1997
Administering
Microsoft Windows NT 4.0, by Digital Astra, 1998.
EDUCATION
Master of Science
Information
Science
(1988 - 1990)
Coleman College,
La Mesa,
California, USA
Diplome III of Applied Computer
(1981-1984)
Bandung Institute of Technology,
Bandung, Indonesia
Completed classes of Accountancy,
except the last project
(1980 - 1984)
Bandung Academy of Accountancy,
Bandung, Indonesia
Get the text version of this resume, directly
mailed to you
Your
email address :
Contact this candidate