Oracle Project
Resume:
Title:Operations Assistant Intern
******@***************.***
Document
Source below
NAME:,
ADDRESS:
ADDRESS2:
CITY:
STATE: TX
ZIP:
CANDIDATE ID: 2907400
US CITIZENSHIP:
EDUCATION:
EXPERIENCE: 0
WILL RELOCATE: No -
JOB WANTED:
RATE NEEDED:
TELEPHONE: 817-***-****
EMAIL: *****@**.******
HOMEPAGE:
HOTTEST SKILLS: oracle, database, sql, financial, oracle financial, product, lien, unix,
audit, cobol, solaris, statistics, computer science, engineer, communication,
powerbuilder, programmer, sparc, sun micro, inventory
REVISION: 08
-SEP-02
RESUME:
NAME: CSABA KISS
ADDRESS: 2906 HARWOOD ROAD, APT. H 107
CITY: BEDFORD
STATE/PROVINCE: TX
ZIP/POSTAL CODE:
COUNTRY: USA
EMAIL:
PHONE: 817-***-****
CANDIDATE ID: NA
CITIZENSHIP: US Citizen
EDUCATION: Not Entered
EXPERIENCE: Not Entered
WILL RELOCATE: Not Entered
RELOCATION INFO: Not Entered
JOB WANTED: Any
RATE NEEDED: Not Entered
HOMEPAGE:
COMMENTS:
HOTSKILLS:
CSABA Z. KISS
2906 HARWOOD ROAD, APT. H 107
BEDFORD, TX 76021
*****@**.******
..com
Objective: A challenging Senior Oracle designer, CASE modelling or QA
position that effectively utilises my expertise and skills.
Experience Summary Client/Server 5 years of experience in Oracle
Server 6 to 7.3 and SqlForms 3.0 to Developer2000 : SQLForms 3.0, 4.0,
4.5 development, standards (one + two years + one) SQLReport 1.1, 2.0,
2.5 development, standards (one + one + one) SQLLoader conversion
modules (one) SQLPlus, PL/SQL coding stored procedures, scripting
(five years) RDBMS 6.0, 7.0, 7.1, 7.2, 7.3 and utilities Set up,
Administration, Performance tuning (half + two years + one and half
years + one) SQLNET v1, v2 setup and tuning (three + two) Case Tools
Two years hands on experience with Oracle Case products and the
corresponding methodology: one year hands on experience with Oracle
Case 5.1 design and generation, refinement one year hands on
experience with Designer 2000 guidelines, design, generation,
refinement Project Management One and half years of experience in
Project Management: half year of experience in project planning and
estimating half year of experience as Technical Team Leader one and
half year of experience with Oracle CDM and corresponding tools
(Project Workbench, Project Bridge Modeller)
References
Upon Request
Detailed Professional Experience: System Development
(
CDM
) Experience: 01/03/96 - 09/10/96Oracle Hungary Budapest Designed
and developed Land Registration and Customer Care System for Hungarian
Land Registration Offices. Responsible for several task in the project
life cycle. Performed an estimating and planning study for the
analysis, design, build, transition and production phases of the
project. Developed system development plan Identified and analysed
detailed business and user requirements. Responsible for standards and
procedures, such as design and build standards and procedures
(including GUI standards, Configuration Management procedures).
Responsible for applications logical and physical model using
Designer/2000. Mapped business functions to modules in the most
sophisticated part of the system (property sheet change control)
Responsible for application module design and build, providing general
Oracle development expertise for the project team used Developer 2000
tools. Responsible for developing (design and build) of data
conversion modules used PL/SQL and Oracle Loader. Applied performance
tuning for individual modules and for the whole system, considering
the database locking. Acting as DBA and Designer 2000 repository
administrator for the project, managing 8 Oracle multi platform
(HP-UX, Windows NT) instances.
08/01/95 - 12/01/95Oracle Eastern
Tallinn and Central Europe This scope of this project was a Customer
Care and Billing system for Estonian Mobile Telecom. Oracle Hungary
delegated consultants for the build and test phase. The system itself
was medium sized (50 functions and 65 entities). I performed a tasks
of Build and System Test phase of the project. I was responsible for
screen modules build phase. I built Oracle forms modules from scratch
following the module specification and keeping the project standards
used ERDs, DFDs. I performed the tasks of customization and bug fixing
of pre-generated modules in the test phase. We used Oracle Case 5.1
and Oracle Forms 4.0 tools.
09/01/93 - 05/01/94IFSz Ltd. Debrecen It
was a medium sized, Oracle7 based system to cover the tasks of Quality
Assurance at Chinoin Pharmaceutical. I built character based screen
modules for this system according to modules specification. I did
tasks from the database design and from the transition phase of the
system. Related to these I made the final tuning of the whole system.
03/01/93
- 08/01/93IQSoft Rt. Budapest As junior developer I took
part in a pilot project to deliver information system, what provides
overall information about congressmen. Responsible for design and
build related tasks in the system development.
Core Technical Experience:
11/11/96
- presentBluestone Inc. Dallas, TX The client is the one of
the largest Telecommunication company. My role is to provide Oracle
expertise for DBAs, for Developers, etc. I also responsible for to
managing the production systems. The tasks of the next months is to
establish standards and procedures to maintain the clients databases
and to manage their performances.
06/10/96 - 06/20/96Oracle Hungary
Budapest This is a Benchmark project for Sun Microsystems. Responsible
for managing the whole implementation of the benchmark, and performing
the Oracle related tasks: defining key performance metrics for the
process, designing and implementing the physical database, tuning and
refining SQL statements, collecting and evaluating statistics on the
instance (Oracle 7.1.6 with Parallel Query Option), tuning the
instance. I had to control the activities of two senior Operating
System experts. Their responsibility was to set up and tune the
underlying hardware and operating system (Solaris 5.1 on Sun
Enterprise Server 4000 w. 12 CPU).
12/03/96 - 2/20/96Oracle Hungary
Budapest Preparation of the installation kit of a custom database and
corresponding procedures for District Land Registration offices. The
objective was to provide a kit including the operating system (windows
NT), Oracle Server binaries, custom database for non technical rollout
team to set up 110 standalone Windows NT server with Oracle 7.1 on
country side, with minimal support cost. 07/01/95 - 07/20/95 Oracle
Hungary Budapest Preparation of an internal Benchmark on Sun
(performance benchmark on Solaris 2.4 with DiskArray System to test
Oracle Parallel Query Option on Sparc2000 with 8 CPU). Performed tasks
of defining performance metrics, designing and creating test database,
designing, coding and refining SQL scripts to perform the test,
collecting and evaluating statistics on the tested Oracle instance
(7.1.6 with PQO) and on the operating system (Solaris 2.4 with A+
edition).
06/10/95 - 07/10/95 Oracle Hungary Budapest Preparation of the
Benchmark phase for District Land Offices tender. Performed the tasks
of logical database design, physical database implementation, design
and code of the application to be measure, collecting and evaluating
system performance statistics, refining application, oracle instance
(v7.1.3) and operating system (Windows NT 3.51). 1995. February Oracle
Hungary Budapest Performing the tasks of upgrading (v7.0 to v7.1) and
setting up a large OLTP database with 300 ProC and ProCobol programs
on HP 9000 at SPAR Hungary. (Oracle 7.1 RDBMS with SQLNet v1)
1995. January Oracle Hungary Budapest Performed the tasks of
installing and setting up a large (+50Gb) OFA standard OLTP database
for Westel 900 Telecommunications. Migrated the database and a complex
application (100 ProC programs on 3 instances) from 7.0 to 7.1. During
the migration I reorganised the database considering the optimal
spreading among the disk devices.
Education 1989
- 1994 Kossuth Lajos Debrecen University M.Sc. in
computer sciences 1994
- 1996 Oracle Education London Oracle V7
internals Oracle Precompilers Application development with Oracle
Forms 4.0 CASE design and generation for Oracle Forms 4.0 Configuring
SQLNet V2 Project Management for Team Leaders Advanced Administration
for Oracle Application
>
M. XXX SREEDHAR
No Street
NYC, NY 00000
******@***************.***
Rate: $60/hour (we cover all expenses) Geography: ANY Available with 1
weeks notice ORACLE FINANCIALS / Senior Oracle DBA (Contact
Information at bottom of resume)
NAME: M. SREEDHAR
SUMMARY Over 8 years of expertise in ORACLE support as a Database
Administrator. Experience includes ORACLE FINANCIALS Applications
install/upgrade/migration, physical database design, database
security, backup procedures, restore procedures, UNIX System
Administration. database tuning and auditing. Extensive US and
Canadian project experience.
TECHNICAL PROFILE: Software: ORACLE FINANCIALS V 10.6.2 With Multi
Organization, ORACLE V 7.3.2.4, V 5.X/6.X, Tools/Utilities: Enterprise
Manager, Server Manager, SQL DBA, SQLPLUS, EXP/IMP, SQLLOADER, SQL NET
and PL/SQL, Alexandria/Petrol Backup/Restore Tools. Hardware/OS:
HP-9000, RS-6000 and Intel Base Systems, HP-UX V 9.X, AIX V 4.X
EXPERIENCE ALIAS /
WAVEFRONT, Canada Nov. 1996 to Dec. 1996 This firm
deals with the Hollywood film industry and provides special effects to
movies. The company planned a project for the MIS Division for various
on-going operations using ORACLE FINANCIALS VV 10.6.2 and another
project for the Operations Division using ORACLE V 7.3.2.4 Responsible
for: ORACLE V 7.1.6 installation (For ORACLE FINANCIALS) ORACLE
FINANCIALS V 10.6.2 installation and Multi-Organization Installation.
Database sizing (40 GB). Concurrent managers maintenance Resource
maintenance operations ORACLE V 7.3.2.4 installation Database sizing
(80 GB) Physical database creation (tables, indexes, clusters,
tablespaces/data files, redo logs, rollbacks, primary keys and foreign
Keys and Other Constraints). Database Backup/Restore procedures
Design/Test and Implementation. .Configuration of SQL Net Database
Security Module Design and Implementation Applying Patches to ORACLE
FINANCIALS Applications. DBA Activities for ORACLE FINANCIALS
Applications(GL, AR, PO, AP, INV and BOM) Dataload Requirements
Specifications Database Audit Requirement Specifications. UNIX systems
Admin. Activities, Files, Users
Creation/Modification/Deletion/Maintenance) UNIX Systems Level
Backup/Restore Using Patrol and Alexandria Evaluation of various DBA
and UNIX backup Tools
Environment: ORACLE FINANCIALS V 10.6.2, ORACLE V 7.2.3.4, ORACLE
Enterprise Manager, SQL DBA, SQL Plus, PL/SQL, EXP/IMP, SQLLOADER, HP
- 9000/HP- UX V 9.X
D&H INTERCHEQUES, Canada Apr. 96 to Oct. 96 This company is involved
in the printing of custom checks for various banks in Canada such as
Toronto Dominion bank, Bank of Nova Scotia, CIBC and Bank of Montreal.
They have 4 production units (each Database is 50 GB and big tables
with 20 million rows of data) and planned a project using ORACLE V
7.2/RS 6000/AIX V 4.2. This project involves maintenance operations
for the existing 4 ORACLE databases at 4 production units and
designing of new database for 4 production units using Client/Server
and ORACLE V 7.2 and PowerBuilder. As a Sr. DBA, was responsible for:
Logical database mapping to physical database ORACLE Installation V
7.2 Physical database creation (system data files/redo logs/rollbacks)
Database sizing(early 80 GB) Physical database creation (tables,
primary keys, secondary indexes, tablespaces, datafiles, user,
application rollbacks) Database backup procedures creation and
implementation Database restore procedures creation and implementation
Database security module design and implementation Data load
specifications Database tuning(system, SGA, buffers, I/O) Maintenance
operations for 4 production units: Database fragmentation elimination.
User maintenance Tablespace and datafiles Backup and restore
operations Alter keys and creation of additional indexes and alter
indexes User maintenance other regular DBA maintenance operations
Environment: ORACLE V 7.2, Server Manager, SQL Plus, SQL DBA, SQL
NET V 2.X, PL/SQL, EXP/IMP, SQL LOADER, Query Optimizer, IBM RS 6000
and AIX 4.2
SCITEX CORP
., USA Feb. 95 to Mar 96 Client manufactures hardware
products like printers/plotters. Client planned a project for the
corporate MIS division, using ORACLE FINANCIALS V 10.2 and HP-9000 to
keep track of various products, deals, inventory, invoices, purchase
orders. As an ORACLE FINANCIALS applications DBA was responsible for
ORACLE software installation (V7.1.6) ORACLE FINANCIALS V 10.2
installations Concurrent managers maintenance tasks DBA activities for
AR, AP, GL, BOM, I NV financial modules. Application sizing (50 GB)
Maintenance operations for concurrent operations and applications
Maintenance operations for tables,Indexes, tablespaces, data files,
rollbacks, keys, other constraints, users etc. Database fragmentation
elimination scripts and implementation. Reverse engineering scripts in
SQL and SHELL to generate schema structure (table, tablespaces,
indexes, rollbacks, datafiles, users and security scripts ) Database
monitoring tool design and implementation using SQL plus and SHELL To
monitor extents 7 to fix them after reaching red mark. Objects
analysis to generate report for user objects (tables,indexes,
procedures, packages) between any given dates. Data analysis to
monitor the size of data between any two dates for additional hardware
purchase. Create control file Data refresh (from development to test)
Database backup specs, test and implementation Database restore specs
and implementation Database security module specs and implementation
using PL/SQL. Database audit module specs and implementation using
PL/SQL
Environment: ORACLE FINANCIALS V 10.2, ORACLE V 7.1.6, SQL NET, SQLDBA, PL/SQL, SQL PLUS, EXP/IMP SQL LOADER, HP-9000,HP-UX V 9.X
BATON ROUGE INTERNATIONAL
Jan 89 to Jan 95 Was involved in the study,
design and implementation of the Total Concept Financial system 4 (TC
4). The product was targeted for all the Major Banks (in the USA, Bank
of Kuwait, bank of Dubai, China Bank of Japan) who were the customers
of TC 3 which was a third generation banking software implemented
using NCR COBOL. As a programmer analyst, was responsible for
Preparation of study report by going through millions lines of source
code Identification of tables (nearly 2000) Identification of
attributes (nearly 17000) Identification of keys Identification of
indexes Mapping of COBOL file format to ORACLE table Normalization As
an ORACLE DBA (From Jan. 1992) was responsible for Database sizing(120
GB) Physical database creation Database backup/restore
design/test/implementation Database migration from V 6 to V 7 Security
audit modules design and implementation Identification of stored
procedures and triggers Environment: ORACLE V5V6,V 7, V 7.2,SQL
DBA, Server manager, SQL PLUS, PL/SQL, NCR 3432/UNIX system 5.2
EDUCATION Bachelor Of Technology
Computer Science and Engineering from
Nagarjuna University,
India 1989.
CONTACT INFORMATION: This consultant is available as a subcontractor
through our firm at an all inclusive rate of $60/hour. He is available
for work anywhere in the US. He is currently on assignment overseas.
He can phone interview immediately and can start at your work site
within 5 days. Our rates are low enough to allow pass throughs of any
of our candidates to your end-clients.
Mr. Stephen Fleischner Director Intermedia Group, Inc. 122 East 42nd
Street, Suite 1700
New York, NY 10168 voice: 212-***-**** fax:
Email: ******@***************.*** Internet:
http://www.intermediagroup.com
Contact this candidate