Oracle Developer
Resume:
Title:DINH BANG
abpr7u@r.postjobfree.com
Document
Source below
NAME: DINH BANG
ADDRESS:
CITY: Austin
STATE/PROVINCE: TX
ZIP/POSTAL CODE: 78727
COUNTRY: USA
EMAIL: abpr7u@r.postjobfree.com
PHONE: 512-***-****
CANDIDATE ID: N/A
CITIZENSHIP: US
Citizen
EDUCATION: Not Entered
EXPERIENCE: Not Entered
WILL RELOCATE: Not Entered
RELOCATION INFO: Not Entered
JOB WANTED: Not Entered
HOMEPAGE:
HOTSKILLS:
ESUME
DINH BANG
6403-C Melrose Trail
Austin, TX 78727
abpr7u@r.postjobfree.com
abpr7u@r.postjobfree.com
www.sqlcontractor.com
OBJECTIVE
Looking for job as Oracle Analyst Programmer or Data Warehouse
Developer or
Database Modeler. The ideal job should require solid background of
Oracle server
technologies, rich experience Oracle development tools and/or database
modeling
expertise. I can deal with both client and server problems.
(Developer2000, Forms,
Reports, Discoverer, PL/SQL, Designer2000, ProC).
HINGHLIGHTS OF EXPERIENCE
- 6 years of experience with Oracle databases, Oracle design and
development tools,
and PL/SQL.
- Familiar with Oracle Financials, General Ledger, Oracle Applications
Object Library.
- Familiar with Oracle structured methods: Oracle CASE Method, Oracle
Custom
Development Method (CDM) and Oracle Project Management Method (PJM).
- Worked as Oracle Developer Consultant for fortune 500 companies,
including
Cummins, Oracle, Unisys and Wang Global.
- Custom development, Data warehouse and Oracle Applications.
SUMMARY OF SKILLS
- Tools and Programming Languages: Developer2000, Oracle Forms, Oracle
Reports,
Oracle Discoverer, Oracle Designer2000, Oracle Database Designer,
Oracle PL/SQL,
Oracle ProC, ANSI C.
- DBMS: Oracle8i, Oracle8, Oracle7, MS Access and MS FoxPro.
- Operating Systems: WindowsNT, SUN Solaris, Novell NetWare, MS
Windows,
MS-DOS.
PROFESSIONAL EXPERIENCE
January 2001
- Present, NetSolve Inc., www.netsolve.com
NetSolve Inc is a leading company in remote network management and
security
services. It currently services over 1000 customers in 50 states and
42 countries.
Technologies Used
- Oracle Developer2000: Oracle Forms5 and Reports3.0
- Oracle Discoverer3i.
- Oracle Procedure Builder and server-side PL/SQL
- Oracle Applications GUI standards.
- Oracle8.1.6 and Oracle8.0.5
- MS WindowsNT4.
1. Trouble Ticket Management, NetSolve Inc.
The system helps keep track and resolve all the network trouble
tickets reported by
NetSolve engineers or external parties. The new requirement is to
develop forms and
reports that view and analyze network installment and failures from
different angles.
So the technical teams can respond quickly and improve quality of
services.
Position: Senior Oracle Developer
My Responsibilities
- Develop and modify report data load stored procedures on Oracle
server. This stored
procedures prepare the data for the reports.
- Develop new reports using Oracle Reports, OLE2 with MS Excel and
Discoverer.
- Develop new forms with new program units.
- Modify database for reporting purpose, create new tables, indexes
and store
procedures.
My Deliverables
- New forms and reports for network management system
- New PL/SQL stored procedures for data load
- Revised database model for reporting purpose.
Interesting Technical Issues
- Oracle Forms, Reports and MS Excel integration
July 2000
- December 2000, Cummins Inc., www.cummins.com
Cummins is a worldwide designer and manufacturer of diesel engines and
related
products. The company uses Oracle database, Oracle applications and
Oracle
development tools for its information systems. I work in CEP Systems
Division as
Oracle Programmer. I mainly deal with conversion, enhancement and new
development
on an in-house database application project.
Technologies Used
- Oracle8.1.6 and Oracle7.3.4
- Oracle Developer2000: Oracle Forms6i and Oracle Forms4.5.
- Oracle PL/SQL, Oracle Procedure Builder and SQLPlus.
- Seagates Crystal Reports8.
- MS WindowsNT4.
1. Automotive Business Assembly Management System (ABAMS), Cummins.
The system manages assembly lines of two Cummins' diesel engine
plants. It receives
work orders and shop orders from external mainframe systems, processes
and delivers
processed data to the plants' shop floors for engine assembling. The
application
involves line configuration, failsafe control, engine status, engine
deviation, engine
conversion, etc.
Position: Oracle Developer Consultant
My Responsibilities
- Review and refine template forms and PL/SQL Forms libraries.
- Convert and migrate old forms from Forms4.5 on Oracle7.3.4 to
Forms6i on
Oracle8.1.6.
- Develop new forms using Oracle Forms6i on Oracle8i.
- Develop new PL/SQL Forms libraries.
- Develop new PL/SQL stored procedure on Oracle server.
- Use Crystal Reports8 to develop new reports and integrate them to
Oracle Forms on
the web environment.
- Tune performance of Oracle forms and PL/SQL libraries.
My Deliverables
- Refined and new Oracle Forms6i libraries with new functions and
procedures
- Refined Forms6i template forms.
- Converted and new forms using the new templates and new libraries.
- A new PL/SQL stored procedure for external data input.
- New reports (Crystal Reports8) integrated with Oracle forms on the
web
Interesting Technical Issues
- Integration of Oracle Forms6i and Crystal Reports8 on the web.
- Simulation of record "drag and drop" in web forms.
December 1999
- July 2000, Wang Global Corp., www.wang.com
The US-based company provides banking solutions to its customers
around the word.
In Asia it has strong bases in Japan and Hong kong. I work in a retail
banking project
conducted by Wang Global Hong kong.
1. Wang Global OSFA, Industrial and Commercial Bank of Vietnam (ICBV).
OSFA is a modern banking system architecture that we use to develop
and implement
a retail banking solution for ICBV. This is an online 3-tier
application running on Oracle
database and Sun Solaris. The business scope covers deposit, saving,
bank bonds and
general ledger operations. The system is developed to implement to 96
branches and
the headquarter of the bank.
Position: Senior Oracle Developer
.
Technologies Used
- Oracle8.0.5 and Oracle7.3.4.
- Oracle Developer2000: Oracle Forms6i/6, Oracle Reports6/3
- Oracle Designer2.1 and Database Designer1.0
- Oracle PL/SQL, Oracle Procedure Builder and Oracle SQLPlus.
- MS FoxPro2.0 (for old systems).
- Sun Solaris2.7, MS WindowsNT4.
My Responsibilities
- Develop new forms for back-end administration.
- Develop host applications.
- Develop general ledger reports
- Refine and update database design to adopt requirement changes.
- Design and perform data conversion from two old systems on Oracle
and MS FoxPro.
- Design and perform database performance tests.
- Perform physical database configuration and implementation.
My Deliverables
- New forms for back-end administration. (Forms6/6i)
- General ledger reports (Reports6)
- Host applications (ProC, PL/SQL stored procedures).
- SQL and PL/SQL database conversion scripts and converted data.
- Revised database model.
Interesting Technical Issues
- Host processing using Oracle ProC and PL/SQL stored procedures.
(PL/SQL stored
procedures for host processing improves modularity and performance).
- Using aggregated database views based on operational tables to
generate
accounting reports for general ledger accounts of different detail
levels.
April 1998
- November 1999, Thien Nam Computing Corp.,
www.thiennam.com.vn
Thien Nam Computing is a local partner of Unisys. It has a joint
support center with
Unisys to customize and implement Unisys banking solutions to local
customers. The
company also involves in custom development of financial software for
government's
organizations.
Technologies Used
- Oracle8.0.4 and Oracle7.3.4.
- Oracle Developer2000: Oracle Forms 5.0/4.5, Oracle Reports 3.0/2.5.
- Oracle Discoverer3.0
- Oracle Designer1.3.2/2.1
- Oracle PL/SQL, Oracle Procedure Builder and Oracle SQLPlus.
- SunSolaris2.5 and MS WindowsNT4.
1. Unisys TCBS, Asia Commercial Bank (www.acbbank.com.vn)
The goal of the project is to modernize and streamline business
organizations of the
bank particularly retail banking areas, including deposits, loans and
accounting
operations. Working as Oracle Developer Consultant I join Unisys team
to develop a
new module, customize and implement the retail banking solution to 15
branches and
the bank's headquarter.
The new development focuses on offline operations. This module is used
when a bank
branch goes offline while its services must be still available to
clients. The module
handles most offline transactions and synchronizes offline data with
the central
database server when the branch goes online again.
Position: Oracle Developer Consultant
.
My Responsibilities
- Take part in business and technical requirement definition and
analysis.
- Take part in new module design: database modeling, logical modules,
business
processes.
- Develop new forms, reports and PL/SQL store procedures.
- Perform database conversion.
- Take care of quality assurance for technical deliverables.
My Deliverables
- Database model and logic functions for offline operation module
(Designer2000)
- New forms that handle offline retail banking transactions.
(Forms4.5/5.0)
- New custom reports to State Bank and Department of Taxation.
(Reports2.5/3.0)
- Database integration the offline module with the main system.
(Oracle replication and
PL/SQL stored procedures).
- Converted data for the new system.
Interesting Technical Issues
- Synchronization between Oracle Personal and Oracle Enterprise.
(Offline transaction
must be updated to correct account and correct balance types)
- Customization of stored procedures for local currency transactions.
(retail
transactions can be made in dollar, local currency or gold)
- Batch processing and reporting for multiple chart of accounts at
central database
server and Oracle Reports2.5/3.0 (Each branch and headquarter have
their own chart
of accounts. General ledger transactions are spread on different chart
of accounts for
inter-branch transactions).
2. National Budget Management Decision Support System, Ministry of
Finance.
This is a data warehouse application, which provides statistical and
analytical reports
that helps enable informed decision-making process of Vietnamese
Government on
budget management and control. This project is funded and managed by
Work Bank to
assist local government to improve the efficiency of its financial
organizations.
Position:
Senior Oracle Developer
.
My Responsibilities
- Take part in database analysis and modeling. This is a star-schema
database model
with replication mechanism to get data from operational systems
(read-only
snapshots, database links, replication groups and store procedures).
The system is fed
by data from Taxation, Treasury and National Budget systems.
- Take part in new module design: data models, logical modules,
business processes.
- Use Discoverer3.0 to build business areas and develop
analytical/drill-down reports.
- Develop forms and reports for data warehouse administration.
- Develop PL/SQL stored procedures
- Implement the system and provide initial support.
My Deliverables
- Star-schema database model (Designer2000)
- Forms and reports for data warehouse administration (Developer2000:
Forms4.5 and
Reports2.5)
- Drill-down/Analytical reports(Discoverer3.0)
- PL/SQL stored procedures for data replication and extraction.
Interesting Technical Issues
- Database replication and stored procedures to gather transactional
data from
operational systems.
- Dynamic reporting using Oracle Discoverer.
- Star-schema database design for multi-dimensional reports.
August 1995
- March 1998, Oracle Vietnam Ltd., www.oracle.com
Oracle Vietnam is a subsidiary of Oracle, the world second-largest
software firm. I
work in the Consulting Department as Staff Consultant and then Senior
Consultant. I
specialize in Oracle development tools and PL/SQL programming. Aside
from custom
development projects, I take part in research and development
activities for the
Consulting Department.
Technologies Used
- Oracle 7.3.4/7.2.2.
- Oracle Developer2000: Oracle Forms 4.5, Oracle Reports 2.5.
- Oracle Designer 1.3.2/1.2
- Oracle PL/SQL, Oracle Procedure Builder and Oracle SQLPlus.
- Sun Solaris 2.5 and MS WindowsNT4.
1. Human Resource Management, Industrial and Commercial Bank of
Vietnam
The system is designed and implemented to the head quarter and 96
branches of the
bank. It handles employee files, job assignments, education and
training, payroll and
performance evaluation activities of Human Resource Managers.
Position:
Senior Developer Consultant
.
My Responsibilities
- Take part in database modeling and module design (Designer2000).
- Develop database including replication mechanism, read-only
snapshots, database
links, replication groups and store procedures.
- Generate forms and reports from Designer2000 repository.
- Use Oracle Forms4.5 and Reports2.5 to develop forms and reports.
- Implement the system to the head quarter and the first branch.
My Deliverables
- Database model and logical module design (Designer2000)
- End-user forms (Forms4.5)
- Management reports (Reports2.5)
- Oracle stored procedures, replication groups and database links.
Interesting Technical Issues
- Simulation of user-defined items on Oracle Forms. User-define data
items are stored
in a table. Forms will read the table when it starts and arrange the
dynamic item on
canvas.
- Data replication and data conflict resolutions between Oracle
databases.
2. National Budget Management System, Ministry of Finance
The project's objective is to build a new system that better handles
national budget
management process for the Ministry of Finance. The system keeps track
of budget
grants and expenses of all government-funded organizations in the
country. This
system is developed and implemented to 61 sites throughout Vietnam.
Position:
Staff Developer Consultant
.
My Responsibilities
- Take part in database modeling and logical module design using
Designer2000
- Generate forms and reports from Oracle Designer repository.
- Use Oracle Forms4.5, Oracle Reports2.5 and PL/SQL to build forms,
reports and
libraries.
- Convert data from FoxPro-based systems and import converted data to
the new
system on Oracle.
My Deliverables
- Database model and module design
- End-user forms and reports
- Oracle stored procedures and Developer libraries
- Database conversion scripts and converted data.
Interesting Technical Issues
- Generic code and libraries for Oracle Forms and Reports templates.
- Using ODBC for non-Oracle and dynamic data source forms.
3. Billing and Customer Care, Vietnam Posts and Telecom Corporation
(VNPT)
The deliverables of the project are detailed requirements and database
model for a
new integrated billing and customer care system that help the company
cope with a
new changing and highly competitive market.
The new data model is customized from Oracle Telecom Enterprise Data
Model,
Oracle's universal data design for typical modern telecom companies.
The customer will
use the data model and the requirement definition to acquire, develop
and integrate its
current and new sub-systems into a unified billing and customer care
system. VNPT is
the largest telecom company in Vietnam with nearly 4 million customers
nationwide.
Position:
Staff Consultant
.
My Responsibilities
- Define and analyze business requirements, functional requirements
and technical
requirements for a new modern billing and customer care system.
- Use Designer2000 to customize Oracle Telecom Enterprise Data Model
to specific
needs and possible future business changes.
- Document and present project deliverables to the customer.
My deliverables
- Customized database model and functional modules (Designer2000)
- Documented requirements and technical specifications for the new
billing system.
- Presentation documents
Interesting Technical Issues
- Generic database design for a typical telecom company.
- Requirement definition and analysis techniques.
January 1994
- July 1995, Transmecco Corp.,
The state-own company involves in a wide range of fields in
construction industry from
construction material producing, quarrying, importing and exporting. I
work for Bitumen
Division, Department of Information Systems. I am responsible for
system
administration and in-house software development.
Technologies used
- MS Foxpro2.0 and Assembler
- Novell Netware3.11
- MS DOS5.0.
1. Human Resource Management System, Transmecco.
The application assists the company's Human Resource Manager to manage
employee
files, payroll data, job assignments and performance evaluation
records.
Position:
Application Developer
.
My Responsibilities
- Gather and analyze business requirements.
- Design database and application modules.
- Develop screens and reports using MS FoxPro2.0
- Implement the application and provide end-user training.
My Deliverables
- The entire application on MS FoxPro2.0, including end-user screens,
reports, backup
and recovery procedures, and implementation and administration guides.
- Deployed application on MS DOS and Novell NetWare.
Interesting Technical Issues
- Speeding up MS FoxPro database for concurrent accesses. (Store user
transaction
data on local PC, then upload data to central database periodically).
- Preventing and recovering the database from system crashes.
(Recreate index data
whenever system encounters a database crash. Recover central database
using
backup data local PCs).
2. System Administration, Transmecco
The Bitumen Division has tens of networked computers using Novel
Netware3.11and
MS DOS5.0. The system requires quick access to central MS FoxPro
database and
shared resources.
Position:
System Administrator
.
My Responsibilities
- Install operating system and network.
- Perform everyday administration task.
- Troubleshoot and conduct performance tuning.
Interesting Technical Issues
- System configuration for high-speed access on limited hardware
resource.
- Debugging and killing MS DOS viruses.
EDUCATION
Master of Engineering
in Systems Engineering, 1995-1997.
Royal Melbourne Institute of Technology(RMIT),
www.rmit.edu.au
- Conduct research in information system development and management.
Special focus
on information system life cycle, software project management, system
integration
and quality management.
- Graduation research project: "Building an integrated information
system for a telecom
company".
Bachelor of Science
in Computer Science, 1990-1994.
Vietnam National University
(VNU), www.vnu.edu.vn
- Gain fundamental knowledge and skills of programming languages and
software
engineering, including Structured and Object Oriented Programming,
Relational
Database, Computer Structure, Operating Systems, Artificial
Intelligence, Networking,
Management Information System, etc.
- Graduation thesis: "Methods to protect software from being copied".
MY FAVORITE ORACLE FORUMS
- http://technet.oracle.com (forums for all Oracle technologies)
- news:comp.databases.oracle.server (forum Oracle server discussions)
- news:comp.databases.oracle.tools (forum for Oracle tools
discussions)
- http://www.oraclefans.com (forums for all Oracle-related issues)
- http://www.orafans.com (forums for all Oracle-related issues)
MY FAVORITE ORACLE BOOKS
- CASEMethod Entity Relationship Modeling. Richard Barker, 1990.
- CASEMethod: Tasks and Deliverables. Richard Barker, 1990.
- CASEMethod: Function and Process Modeling. Richard Barker, 1992.
- CASEMethod: Business Interviewing. Linda Hickman, 1995.
- Oracle Developer2000 Forms4.5 II, Oracle training material. Oracle
Education, 1995.
- Building a Data Warehouse for Decision Support, Vidette Poe, 1995.
- Oracle Certified Professional DBA Exams Guide. Jason S. Couchman,
1998.
- Oracle Developer/2000 Forms. Albert Lulushi, 1999.
- Oracle Certified Professional Application Developer Exam Guide.
Jason S. Couchman,
1999.
- Oracle Developer Advanced Forms & Reports. Peter Koletzke, 2000.
- Oracle Developer Forms Techniques. Bulusu Lakshman, 2000.
- Oracle Certified Professional Financial Applications Consultant Exam
Guide,
Christopher Allen, 2000.
a
Contact this candidate