Sql Oracle
Resume:
Title:Developer
******.**********@***.***
Document
Source below
NAME: SERGEY CHEREPANOV
ADDRESS:
CITY: Glenview
STATE/PROVINCE: IL
ZIP/POSTAL CODE: 60025
COUNTRY: USA
EMAIL: ******.**********@***.***
PHONE: 847-***-****
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:
COMMENTS:
HOTSKILLS:
ESUME
Sergey Cherepanov
No Address
Glenview, IL 60025
******.**********@***.***
OBJECTIVE
Seeking DBA position utilizing my knowledge of Oracle and Unix in
Chicago
downtown/north suburb area.
SUMMARY OF QUALIFICATIONS * Twelve years of software engineering
experience. * Last 5 years spent working on client/server applications
running Oracle v. 6, v. 7 and v.
8 on Unix, Novell and Windows NT
platforms with DOS, Unix and Windows clients. * Functioned as project
leader, Oracle DBA, Oracle WEB administrator, NT administrator, and
developer for both client and server software development projects. *
ORACLE 8.0.4, 7.4, 7.2, 7.1, 7.0.16. * ORACLE WEB Server 3.02, 2.1;
Oracle Forms 4.5, 3.0; SQL*Plus, SQL*Loader; Export; Import; Reports
2.5; Designer/2000; Developer/2000; PL/SQL; ERWIN 3.0, 2.5 and 2.1;
SQL Windows 5.0. * DG Unix 4.0b; Windows NT Server and Workstation
4.0, 3.51; Novell 4.12, 3.11. * PL/SQL 2.3; SQL; Java; C/C++; HTML;
Visual Basic; Shell; Pascal; Fortran.
EXPERIENCE
Client:
MCI Chicago Role
: Developer01/98 - Present * Installed Oracle
WEB server 3.0.1 and Apache WEB server on DG Unix 4.0b. * Functioned
as Oracle WEB server administrator on DG Unix 4.0b. * Developed sales
support WEB application for existing datawarehouse using PL/SQL
cartridge. Application supported running, publishing and viewing
previously published reports. Time-consuming reports can be run in
background using DBMS_JOB package. Developed specialized security
schema allowed different privileges for groups of users to run, to
view or to publish groups of reports. Developed WEB-based menu system
that allowed easy integration of reports, provided facilities to run,
to publish and to view published reports. Menu system allowed users to
review scheduled background jobs, kill them or run immediately. WEB
application had various limitations on resource consuming, including
restriction of time to run specific report, time to store published
reports, times the same report can be run during one day, day hours
when report can be run, limit of days published report can reside in
database and so on. Developed PL/SQL package that support design
standards for WEB pages. Created administrative application on Forms
4.5 for maintaining WEB functionality. Utilized PL/SQL 2.3, Forms 4.5,
Designer/2000, Unix shell, X11. * Developed WEB application using
PL/SQL cartridge to review status of resource scheduling process.
Application allowed users to go throughout complicated errors that
invoked review of information from about 30 tables using simple and
intuitive "drill-down" interface. * Supported existing application.
Tuning system performance on application and server level. Utilized
Designer/2000, tkprof, Unix shell, X11. * Migrated application from
Oracle server version 7.2.3 to 8.0.4 on DG Unix. Testing application
using tkprof on DG Unix. * Developed specialized module for Apache WEB
server on DG Unix 4.0b. This module featured same functionality as
PL/SQL cartridge from Oracle WEB server. Utilized Pro*C.
Employer:
MosBusinessBank Moscow, Russia Role: Project
Leader/Developer
08/95 - 12/97 * Designed Oracle database utilizing
ERWIN 2.1. Integrity of data implemented by extensive use of triggers
and packages for complex transactions. Database was originally
designed under Oracle 7.1.6 under Novell 3.11 and then migrated to
Oracle 7.2 and Oracle 8.03 running under Novell 4.12 and NT Server 4.0
respectively. * Application defined 3 levels of user rights, including
BackOffice clerk, main office analyst, and application administrator.
Forms for this application were developed in SQL*Forms 3.0 and later
migrated to Forms 4.5. Numerous reports were developed, with a special
method, to run from SQL*Plus or under Oracle WEB PL/SQL agent without
modifications. * Utilized Oracle WEB 3.02, 2.1, 2.0; PL/SQL, SQL*Forms
4.5,3.0; SQL*Plus, SQL Windows 5.0, Reports 2.5, Developer/2000. *
Developed Real-time Oracle-based Securities Trading Support system
(OLTP system). Goal of the project was to give remote users direct
access to MICEX (Russia's largest stock exchange) for the purpose of
online trading. Database design with extensive use of triggers and
packages as well as tight coupling to BackOffice (previous project).
Remote users connected to Oracle server through Intranet
(X.25-provider Global One). Special precautions were taken to prevent
traffic on external network. Client side was written on SQL Windows.
Utilized ERWIN 2.6, PL/SQL, SQL*Plus, SQL Windows. * System supported
real-time quotes from the securities exchange as well as all client
positions. The following levels defined user rights: Trader, Client of
Main Office, Branch Clerk, Branch Client, Guest, and Application
administrator. All data manipulation was done through procedure calls.
Level of user rights was defined by granted role and extensive using
username-based views with nontrivial synonym translation, allowing
users with varying privileges to use the same client application. Set
of available procedures from packages was narrowed for some roles
through additional packages and synonym translation. Current system
has approximately 120 users of the following categories: Main office
users, Remote users connected via public phone lines and NT RAS,
Remote users connecting through optical fiber, Remote users connected
via X.25 through Global One. * Provide replication of securities
quotes data between two servers in order to increase overall
productivity of system. Custom replication was developed using PL/SQL
server-side packages in order to insure proper replication functioning
after restarting one of the servers. * Functioned as NT Server 4.0
administrator during application support. * This system performed 1%
of total amount of orders on MICEX in January with more than 60
trading terminals spread throughout Russia. * Implemented standard
operational data approach to accounting. Data is divided into current
and archive with changes available only to data from current day.
Procedures are given for moving operational data forward and backward.
BackOffice system keeps money and securities positions for every
client. Twofold interface with banks main ledger through some
corresponding accounts was developed. Numerous reports, required by
Russian Central Bank, along with analytical reports were developed. *
Developed SWIFT - like message system with digital signature and
interfaced it to existing ORACLE based securities accounting system.
Goal of the project was to implement automatic interface between two
existing systems - accounting and a SWIFT-like message system. This
way it was possible to implement file operation and data operation in
one transaction using standard ORACLE tools under DOS.
System ran under Oracle 7.2 and Novell 4.12. Messages were loaded into
a temporary database table by SQL*Loader in text form and parsed by an
anonymous PL/SQL block in SQL*Plus script. Results were registered
into message table.
Second SQL*Plus script with anonymous PL/SQL block generated answer
messages and changed bells database according to data from input
message. Some SQL*Forms 3.0 forms were developed to maintain analysis
of message history with improper digital signatures. Database design
was accomplished utilizing ERWIN 2.1; PL/SQL 2.1; SQL*FORMS 3.0;
SQL*PLUS 3.3, 3.1, 3.0; and SQL*LOADER. * Developed real-time
information system on Russian stock exchanges. Utilized
Developer/2000; Forms 4.5; Graphics 2.5; PL/SQL.
Employer:
FORS, Ltd Moscow, Russia Role: Developer/DBA08/93 - 07/95 *
Responsible for the development and support of an Oracle based
accounting system for multi-branch banks. * Functioned as Oracle DBA
for maintenance tasks on Novell, including database recovery, backup,
tuning, and migration. * Developed speech recognition system for
Securities Trading - Client was Chase Manhattan Bank. Utilized Visual
Basic, Microsoft C++, and Assembler in Windows 3.1 environment.
Extensive use of GUI and SDK.
Employer:
ENERGO 44
Moscow, Russia Role: Owner/CEO1990 - 01/93 *
Company employed 14 people in 1991 - 4 of them were full time. *
Developed hardware and software for DEC LSI 11, then for PC and VME.
Project was for NIKIMT Corporation. * Software was developed using
Top-Speed Modula-2, Borland Turbo C, Borland Turbo Pascal, and
Assembler. * Developed speech recognition project for Institute of
Cybernetics in Kiev.
Software and hardware was developed for DEC LSI 11 utilizing C and
Assembler.
EDUCATION
SMT Designer 2000 Course - December 1997 System Modeling and Tools
Microsoft Official Curriculum #476 - February 1997 Fundamentals of
Programming MFC Library Applications SQL Windows Advanced Programming
- January 1997
Moscow Institute of Physics and Technology
Moscow, Russia MS in
Computer Science
- 1984 Institute of Cybernetics Kiev, Ukraine Post
Graduate
student in Computer Science - 1986 - 1989 Specializing in
Speech Recognition Systems
Contact this candidate