| |
Primary at work |
Background at work |
| Programming languages |
PL/SQL, SQL |
Assembler x86, Pascal, HTML, VBA |
| DBMS |
Oracle 8i / 9i |
MS SQL Server, InterBase, FireBird |
| Design methodologies |
IDEF0, IDEF1X |
UML |
| CASE |
ERwin, BPwin, ModelValidator |
Rational Rose, DesignIDEF |
| Version Controlling Systems |
ModelMart, WinCVS |
|
| Development Environments |
TOAD, SQL Plus, SQL Navigator |
Borland Delphi |
| DBA Tools |
Quest Central |
OSM |
| Operating Systems |
Windows XP, Windows 2000 |
Windows 9x, Linux, MS DOS |
| Project Managements |
PVCS Tracker |
Microsoft Project |
| Office Tools |
Microsoft Office |
|
 | October 2000 - present : InfoLada, Ltd. Togliatty, Russia |
| Position: Senior Application Developer |
|
- Developing corporate standards in modeling and programming.
- As a team member, developing logical and physical data model (over 1000 tables) of a big industrial enterprise using ERwin in conjunction with ModelMart and ModelValidator. I am responsible for accordance this model with corporate modeling standard.
- Tuning PL/SQL code and SQL queries. For example, due to optimization of complex procedure a process of data import begin to work up to 33 times faster (11 minutes instead of 6 hours).
- Developing (with PL/SQL) a set of triggers and Oracle packages for implementing a low level application program interface for documents circulation system. Main point: On the basis of logical and physical data model and state transition diagram, main procedure generates SQL script of document (for instance invoice or contract). The script is composed of document view, "instead-of" trigger, package of methods (create, clone, update, delete, print, register, etc) and code for description this document in the information system data dictionary. Due to this module the document developing process decreases significantly.
- Supervising a process of developing of application program interface. I am responsible for efficiency and reliability of information system kernel.
- Administering ModelMart (instrument of joint model development): installing software, creating repository, tuning data mart parameters.
- In the context of information system I developed with PL/SQL an application for technical accounting of communication equipment. This application accomplishes a task of device mounting, repairing and dismantling, servicing of cable network, telephone wires allocating, building an optimal phone route. Developed a model of business process for this subject area using BPwin.
The application was successfully deployed in Togliatty and Samara. Now it is about to deploy in Zhigulevsk, Ulyanovsk and Syzran.
- As a team member, developed a logical and physical data model of billing application. Specific of this application is a huge amount of data (increase up to 15 millions of data records every month). We used a table partitioning and materialized views technique and thoroughly tuned our SQL code in order to application works effective with huge amount of data.
This application was successfully deployed in Togliatty. Now it is about to deploy in Samara.
- Developed about a hundred reports of different purpose using Report Generator and Blank Constructor (in-house design of InfoLada).
- Integrated third party applications into our information system.
- Wrote more than 90 000 lines of effective documented code with SQL and PL/SQL
- All developments were under Oracle database 8i Release 2 (8.1.7)
|
| November 1997 - October 2000 and August 1995 - October 1996 : Comsoft Corporation. Togliatty, Russia |
| Position: Senior Application Developer |
|
- As a team member, developed a low-level application program interface of complex accounting application with PL/SQL.
- Developed logical and physical data model (over 500 tables) using ERwin in conjunction with ERwin Examiner.
- Developed (with Delphi + PL/SQL) the Comsoft Dispatcher - a module to attach to information system screen forms, custom reports, libraries, operations, etc.
- Developed the Comsoft Tracer - a tool to trace and debug applications: intercept and log database engine messages, estimate a code execution time, show debug information.
- Tuned and optimized SQL queries and PL/SQL code to significantly increase system performance.
- Participated in Oracle database administration - installation of client and server software; SGA tuning, tablespaces and storage configuration.
- Participated in project administration - building the final release, backing up and rolling back of project components.
- Developed miscellaneous data converters using PL/SQL.
- Designed and implemented multilevel and multifunctional universal data editors using Delphi.
- All developments were under Oracle database 7.2 - 8.1.5
|
| October 1996 - November 1997 : Solo, Joint Stock Company. Togliatty, Russia |
| Position: Senior Application Developer |
|
- Designed an ER diagram for small accounting application with ERwin. Generated a physical data model to MS SQL Server 6.5 database. Developed a set of stored procedures using Transact-SQL. Implemented a module to support smart-cards processing.
- Developed a software and database for trading system. RDBMS is InterBase.
- Developed an interface between application and trading equipment, such as cash register and bar-code scanner.
- Developed an efficient algorithm to provide fast data transferring from Delphi-applications to Microsoft Excel via OLE Automation Technology.
|
| March 1994 - August 1995 : Nikolskaya, Private Enterprise. Togliatty, Russia |
| Position: Computer Programmer |
|
- Developed software to provide remote user access to relational database using radio-modem connection with Borland Pascal.
- Developed a communication device driver with Turbo Assembler to provide communication between radio-modems.
- Programmed for MS DOS: specific resident (TSR) calculators, using Borland Pascal + Object Professional
|
| July 1993 - March 1994 : Research & Development Center of Volga Car Manufacturing Factory. Togliatty, Russia |
| Position: Junior Computer Programmer |
|
- Developed a database for Vehicle Recycling Department, using DBF data format.
- Developed GUI, SQL queries and reports with FoxPro 2.0 and Turbo Pascal 6.0.
- Serviced more than 20 modems.
|
Highly creative, motivated and have an ability of taking any challenge with an objective to succeed.
Home
In Russian
MS Word format (~ 85 KB)
zip format (~ 40 KB)