Software Engineer Oracle
Resume:
Title:Associate and Partner/member
****@*****.***
Document
Source below
NAME:,
ADDRESS:
ADDRESS2:
CITY:
STATE:
ZIP:
CANDIDATE ID: 2579564
US CITIZENSHIP:
EDUCATION:
EXPERIENCE: 0
WILL RELOCATE: No -
JOB WANTED:
RATE NEEDED:
TELEPHONE:
EMAIL: ****@*****.***
HOMEPAGE:
HOTTEST SKILLS: oracle, sql, unix, database, java, engineer, software engineer, btrieve,
c++, perl, systems analyst, payment, cgi, html, financial, javascript, credit, apache,
solaris, applet
REVISION: 07-SEP-02
RESUME:
Pavel V. Fomin, Software Engineer
JAVA/JDBC/EJB/WEBLOGIC/C/C++/OCI/PERL/CGI/JAVASCRIPT/ORACLE
Pavel V. Fomin
Software Engineer
JAVA/JDBC/EJB/BEA WEBLOGIC
C/C++/OCI/PRO*C/PERL/CGI/JAVASCRIPT/HTML
UNIX/KSH/ORACLE/SQL/PL/SQL
City, State
: Plymouth, MN USA
Email: ****@*****.***
Education: M.S
. in Computer Science & B.S. in Mathematics
Summary of Expertise
Experience Summary
Oper. Systems
Languages
Databases
Software
WEB
Work History
COTELLIGENT INC
. Software Engineer/Systems AnalystInnuity, Inc
.
Thomson Prometric
Medtronic, Inc
.
University of Minnesota Facilities Management
FRANKENDATA USA, INC
. Software Engineer/Systems Analyst
CENTER OF FINANCIAL TECHNOLOGIES
. Senior Software Engineer/Systems Analyst
SIBERIAN TRADE BANK
. Senior Software Engineer
INTERFACE
. Software Engineer
.
"
Education:
NOVOSIBIRSK TECHNICAL UNIVERSITY
- One of the major research and educational
centers of Russia, as well as one of the top technical universities
M.S
. in Computer Science & B.S. in Mathematics, 1992
Evaluated by
International Education Evaluation, Inc
.
(March 10, 1997
. REF # 116-0369)
"
SUMMARY OF EXPERTISE:
Database design and applications development (8+ years);
C (8+ years); in Unix (4+ years);
Client/server (7+ years);
Oracle (6+ years);
Financial applications development (4+ years);
JAVA/WEB (2+ years);
"
Experience Summary. Strongest
"
OPER. SYSTEMS
UNIX (SOLARIS, SCO, AIX, LINUX), WINDOWS NT/95, DOS "
LANGUAGES:
JAVA 1.1.7/1.2, EJB 1.1, JDBC, PERL 5 C, C++, OCI, PRO*C,
SQL, PL/SQL, SQL*PLUS Scripting,
UNIX KORN SHELL, AWK, SED, VISUAL BASIC 5.0/4.0/3.0,
CLIPPER
See WEB section also
"
DATABASES:
ORACLE 7.3, ORACLE 8.X, SYBASE 11.5.1/11.9.2, MYSQL, BTRIEVE, DBASE, FOXPRO
"
SOFTWARE:
BEA Weblogic 4.5.1/5.1, Rational Rose Designer, Sql*Loader,
Oracle Imp/Exp, Oracle Forms 4.5/4.0, Sql*DBA,
Oracle Designer 2000, Visual SourceSafe 5.0/6.0 (VSS), Unix RCS,
Emacs, Exceed, Samba 2.0.0, GNU make,
Visio Diagram Designer, Sybase Power Designer 6.1
"
WEB:
Apache 1.3.6 WEB Server; CGI, PERL, JAVASCRIPT, HTML,
JAVA Applets and Servlets,
Oracle WEB Server 2.1.1, PL/SQL/JAVA cartridge
Netscape Navigator 4.X, MS IExplorer 4.X
"
Work History
"
COTELLIGENT INC
.
Software Engineer/Systems Analyst, Full TimeConsultant. November 1998 - Present
"
Innuity, Inc
Designed and developed Enterprise Java Beans on the SUN Solaris and Windows NT
platforms using Rational Rose 2000 Enterprise Edition, JAVA 1.2.2,
EJB 1.1,
Borland Inprise Application Server, thin Oracle JDBC driver, Oracle 8i for the E-commerce project.
"
Thomson Prometric
Designed and developed Enterprise Java Beans in the multitier architecture
environment on the SUN Solaris and Windows NT
platforms using Rational Rose 2000 Enterprise Edition, JAVA 1.2.2,
EJB 1.1,
BEA Weblogic 4.5.1/5.1, JConnect as JDBC driver for Sybase,
Sybase 11.9.2 for new Prometric Unified Financial Module.
This module is the server side business logic package that
provides all the financial services for international corporate use by any
other J2EE complaint services or applications. Used javax.swing package
to create the graphical user interfaces.
Used Perl 5 with Sybase::DBlib and Sybase::Sybperl packages for the data
conversion. Created a generic data load utility (similar to Oracle SQLLOAD)
for loading the data into Sybase database. Administrated the Sybase
development server. Created the KSH scripts and crontab jobs to perform
the backup. Designed a number of the database sub-models using
Sybase Power Designer 6.1.
As a background task installed and made a number of enhancement changes
in Perl CGI scripts of
Bugzilla
- a defect tracking software used for the project. Installed and administrated
the MYSQL database server required by Bugzilla.
Installed and administrated Apache HTTP Server 1.3 and Samba 2.0.0.
Created a number of static HTML pages for the project's web site.
Modified and created new rules of the build process for GNU make.
Used VSS, Emacs, Visio Diagram Designer
"
Medtronic, Inc
.
Responsible for the Oracle Batch Processing and Oracle Database conversion
processes under UNIX AIX 4.*.
Created new and changed existing C/PRO*C code, KSH scripts,
SQL*PLUS scripts, SQL and PL/SQL code, SQL*LOADER's ctl files to meet
new requirements. Created generic PERL CGI programs to replace old
application interfaces with WEB based ones (Apache 1.3.6 WEB Server).
Revision Control System (Unix RCS) administrator.
"
University of Minnesota Facilities Management
Responsible for Oracle applications software development/optimisation in a
Unix AIX 4.3 and Windows 95/NT environment, Oracle 7.3.3/8.0.3. Developed a
number of transfers between different oracle instances and databases themself
using PL/SQL, SQLPLUS scripting, UNIX KSH scripting and VB 5.0 with
Oracle/Sybase ODBC, respectively.
Created installation packages for additional subsystems based on PL/SQL, SQLPLUS/UNIX KSH
scripting. Responsible for
providing the Oracle SqlLoader Control files with buffer calculating and
UNIX KSH scripts to execute all sqlloader sessions and control the results.
Also responsible for Oracle tablespace/datafiles management including calculation of
storage parameters for tables and indexes.
Developed JAVA
applets with Oracle JDBC "thin" driver to provide the access to an
Oracle database via WEB. Generated dynamic HTML pages using Oracle WEB 2.1.1.
Server's PL/SQL/JAVA cartridges.
Improved HTML documents by adding some
JAVASCRIPT code for MS IExplorer 4.x and Netscape Navigator 4.x.
Developed a
number of Oracle Forms 4.5 under Windows 95/NT to provide additional
functionality for subsystems.
Was responsible for source code repository as
Visual SourceSafe 5.0. (VSS) administrator, provided VSS scripts to get the
particular version of subproject and install it.
"
FRANKENDATA USA, INC
.
Software Engineer/Systems Analyst
.
July 1997
- October 1998
Member of a 40-person team that was responsible for Oracle database
design, tuning and optimization. Developed Oracle applications and Oracle
database objects and control procedures in the Power System Control area in an
AIX Unix and Windows NT environment. Served as an Oracle expert for several
large-scale
SIEMENS
projects.
Used C, C++, Pro*C, OCI, SQL; PL/SQL and RDBMS
packages on the server side; import/export utilities, SQL*Loader and
Oracle Forms 4.5.
Developed additional Oracle sub-systems required by a particular
project for Spectrum, a Power Control System.
Performed control processing using C, C++, Pro*C, OCI, PL/SQL and RDBMS
packages (dbms_pipe, dbms_alert, dbms_job, dbms_lock, dbms_sql), korn shell,
AWK and SQL*PLUS. Created the Oracle database access support library for
the Motif applications (based on Universal Pro*C library) including local
archiver based on Oracle export/import. Created Universal Pro*C library based
on Pro*C method 4.
Projected and created Oracle
objects. Responsible for calculating storage parameters for Oracle tables and
indexes. Developed Oracle server side installation procedures for all Oracle
objects of new sub-systems using SQL*PLUS, shell, korn shell and AWK.
Created number of user interface displays based
on Oracle Forms 4.5. Managed tablespaces and datafiles.
"
CENTER OF FINANCIAL TECHNOLOGIES
.
Senior Software Engineer/Systems Analyst
. Jan. 1996 - July 1997
Responsible for Oracle system and custom applications software development in
a Unix and Windows environment. Also responsible for an Oracle administration
support.
Responsible for full design and
implementation of Guard, a badge security system. The system fully controlled
office access and sent a signal to open the office based on appropriate card
identification. It included pass-card owners dossier, administration of
pass-cards and readers, pass setting, journal of pass cards moving
throughout the system and reporting component. User interface included
Visual Basic 4.0/5.0, Visual C++ 2.0 and OCI. Designed all Oracle objects
and control procedures using SQL, PL/SQL and RDBMS packages. Unix Shell,
SQL*PLUS, SQL and PL/SQL were used to install the Oracle server.
Designed and developed the
Project Dictionary Integrity Inspector (PDII). This is a universal integrity
control system for Oracle-objects in different schemas. It allowed to (1)
create a model copy of the Oracle database objects' dictionary, keeping it
in the form of oracle export files. (2) Create and re-create the model copy
of the Oracle database objects dictionary by importing prepared files.
(3) Revise the differences between model and work system objects with
the possibility of recreating the incorrect objects and receiving the new
list of differences. The technical environment included Oracle, SQL, PL/SQL,
Unix Shell, Visual Basic 4.0, Visual C++ 2.0 and OCI.
Designed and implemented a local archiver sub-system for a National Smart
Credit/Debit Card payment system GC based on Oracle export/import. The archive
was created in two stages. The first stage involved displacing the information
into temporary worktables. The second stage involved transferring information
to export files to save the table space. The technical environment included SQL,
PL/SQL, Visual Basic 3.0, Visual C++ 1.5, OCI, and Oracle export/import in a
Windows NT and Windows 95 environment.
Developed a reporting sub-system for the National Smart Credit/Debit
Card Payment System "Golden Crown" (GC) using GC Reporting Tool and Oracle
Forms 4.5/4.0.
Completed the proof-of-concept stage of project consisted of basic
UI Framework for Oracle database application using newest Java
JDK 1.1 release and JDBC.
Used VSS as the source version's control utility for all projects.
"
SIBERIAN TRADE BANK.
Senior Software Engineer
. March 1993 - Jan. 1996
Responsible for developing system and application software, analyzing data,
optimizing data, storage procedures and converting data.
On the Btrieve database, worked on a multi-parametrical system of banking
analysis including Reports Generator's component for the bank system
and the smart card payment system. Created a cistomized "conveyor" program
that automatically printed the bank's operating documents performing all
required operations such as sorting, grouping, etc.
On the Oracle database, developed data conversion sub-systems for
the bank system and the smart card payment system for the different National
Language Support (NLS) codes. Developed the reporting sub-systems for these
two systems. The system ran on Oracle, Btrieve, Unix and Windows. As part of a
100+ member team, worked on two conversions of Golden Crown (GC), the National
Smart Credit/Debit Card Payment System.
Responsible for full design and implementation of an Oracle server side
code/data NLS conversion for the National Smart Credit/Debit Card Payment
System, "Golden Grown" (GC) distributed to 143 banks and National Integrated
Bank System (IBS) distributed to 100+ banks. Primarily, the original Oracle
versions of both systems were based on US7ASCII server side NLS coding and
CL8MSWIN1251 for windows. The data in the Oracle database was in Windows
coding, which was inconvenient for all Unix client applications because of an
interfering page of Russian code. A Russian alphabet for current coding was
saved in a temporary table and the Oracle system table was updated to set new
server side coding. This allowed the Oracle server to translate the Russian
code into new code when rebooted with new NLS code setting. Created several
PL/SQL procedures controlled by Windows applications to translate the data from
old to new alphabet. Created the user interface to control the results of the
conversion process. The system ran on SQL, PL/SQL, RDBMS packages, Unix shell,
Visual Basic 3.0, Visual C++ 1.5 and OCI.
Responsible for full design and implementation of a
"Btrieve to Oracle" conversion of the GC and IBS systems. The data from the
Btrieve version were unloaded to ascii files in SQL*Loader format, a temporary
tables were then created and the data was transferred to Oracle using
SQL*Loader. The conversion itself was made by prepared PL/SQL procedures
controlled by Windows applications. Developed a specific user interface to
control the results of the conversion. The system ran on SQL, PL/SQL, RDBMS
packages, Unix shell, SQL*Loader, Visual Basic 3.0, Visual C++, OCI and
Pro*C.
Responsible for full design and implementation of a Btrieve version of
the expert multi-parametical system of banking analysis for IBS. The system
allowed the building of business functions (BF) on the basis of the Simple
Btrieve Data Access tool (SBDA). This approach provided an analytical tool
to analyze the business characteristics for mid-level supporting personnel,
as well as for the highest business management. The system contains text,
graphical and file output.
Developed a Btrieve version of the conveyor for automatic
printing of the bank operating documents including generating templates,
defining multi-parametrical output conditions and real-time processing of
current documents for printing.
Also worked on the Btrieve report generator
for IBS. The technical environment included C, Clipper 5, and Btrieve Data
Manager.
"
INTERFACE.
Software Engineer
. Sept. 1992 - March 1993
Developed software applications in dBase, FoxPro, C and DOS. Developed
automated auctions maintenance system for Novosibirsk Power Equipment Stock.
Developed a distributed information retrieval storage system.
Last Modified Sep 12, 2000
Mail to: ****@*****.***
Contact this candidate