Sergei Kuchin

A two-page resume is available.

HIGHER EDUCATION: Major Degrees in Computer Science and Applied Math & Mechanics, University of Novosibirsk, Russia, Department of Mechanics and Applied Math, 1981-1986.

SUMMARY OF EXPERTISE:

• Generic programming (3 years)
• Object oriented programming (7 years)
  
  
• Relational, object-relational, and object oriented databases (7 years)
  
  
• applications and user interfaces
• client/server architecture
• multi-tier architecture
• database modeling, schema design/optimization
• high performance backend & batch processing
  
  
• Applications development
  
  
• C/C++ in Unix and Windows NT (C - 12 years, C++ - 9years, C++ with STL - 3 years)
• Oracle 7.x, 8.0, 8.1.x (7 years)
• SQL, PL/SQL, database triggers, SQL*Loader, Pro*C/C++, OCI with C/C++, Oracle Developer, SQL*Net, SQL and PL/SQL tuning and optimization
• Microsoft SQL Server 6.5/7.0 (2 year)
• MS SQL, Transact-SQL (stored procedures), bcp, ODBC/MFC/C++ database development and optimization
• Oracle Applications (1 year): Account Receivables (AR), Project Accounting (PA)
• Web/database backend development in Oracle and Microsoft SQL Server (1 year)
• Crystal Report Writer (1 year)
• Exposure to database development in Sybase and DB2 for Windows NT and Unix platforms
• Got training in Java/JDBC
• Exposure to Oracle Discoverer and other Data Warehousing tools.
• C++/ObjectStore (1 year)
• Pascal (8 years)
  
  
• SunOS and Solaris (2 year)
• AIX (2 years)
• HP UX (2 years)
• SCO Unix, Xenix, Linux (2 years)
• Total 8 years in Unix
  
  
• Windows 95/98/NT (6 years)
• Database applications development in C++: VC++, Sun C++, AIX C++, HP C++ (7 years)
• (C++) Standard Template Library (3 year)
• Development of conversion tools from different information sources into HTML
  
  
• Miscellaneous
  
  
• Power systems database applications (3 years)
• Financial database applications (3 years)
• real time control systems (2 years)
• LEX & YACC, compilers: theory and development (2 years)
• development of technical and user documentation (8 years)
• team work player (12 years)
• natural language processing (4 years)

EMPLOYMENT HISTORY

Feb-97 - present. Analysts International Corp., Systems Analyst. Project list:

Dec-00 - present. Oracle 7,8/8i, C++, Windows & HP UX related project for Metavante Corp.

Oct-00 - Nov-00. Web/Oracle related work for Department 56.

May-00 - Oct-00. Worked in a project at Damark. Migration of an Internet/catalog purchase order processing system from Cfront (legacy C++) to ANSI C++ for HP UX. Also, migration of another production legacy system from PICK (database in AIX environment) to Oracle & ANSI C++ in HP UX.

The following tools were used: HP Unix (HP UX); Oracle SQL, PL/SQL, SQL*Plus, OCI; Rogue Wave Tools++, DBTools++; ANSI C++ for HP UX (aCC).

Oct-98 - Apr-00. Worked in a project at Honeywell. Collection management system, a hybrid of Oracle Apps and Microsoft SQL Server. Developed Oracle/SQL Server data population, extract programs to extract outstanding items (like old invoices, unapplied cash, etc.) from Oracle Apps and upload them into a SQL Server database which was used by collection management specialists and sales reps in the field. Also, developed a real-time data synchronization/population program to keep the SQL Server data in sync with the Oracle (Account Receivables and Project Accounting) data.

The following tools were used: Oracle SQL, PL/SQL, SQL*Plus; Microsoft SQL, Transact-SQL, bcp, Query Analyzer, Enterprise Manager; ODBC/MFC, Oracle Call Interface, Standard Template Library in Visual C++ environment.

Platforms: HP UX, Windows NT

Optimized and tuned up a number of online reports in Crystal Report Writer.

Aug-98 - Sep-98. Analysts International Corp., Systems Analyst. Worked on several short-term projects in Unix/C, Unix/Oracle Web database backend.

Feb-97 - Jul-98. Worked in a project at Travelers Express. Official check processing software. Developed a cross platform (Windows NT to MVS) ANSI C compliant command shell to execute PL/SQL batch jobs as well as a number of packages in server side PL/SQL. Also, developed a converter from PL/SQL into HTML (click here to see an example) and an incremental PL/SQL code promotion utility in Windows NT.

Contributed the Freeware Oracle Call Template Library to the MLE project the same client site. The library allowed the project to be delivered on time.

Nov-94 - Feb-97. Consultant for Siemens/Empros Energy & Automation via Mosakin Corp. Power Control Systems Software. Developed a number of C++, Pro*C, OCI applications, user exits, Oracle forms and Pascal programs under IBM AIX and Windows NT environments.

Developed the Oracle Call Interface Template Library and contributed it as Freeware.

Jun-94 - Oct-94. Systems Analyst, Siberian Trade Bank, Financial Technologies Center. Redesigning and porting a legacy banking software from Btrieve (Netware) & Clipper (MSDOS) to Oracle client (MS-Windows)/server (SCO Unix) architecture. Pro*C, OCI, PL/SQL, SQL*Net, ODBC 2.0 with Oracle drivers, Oracle Forms 4.0, Visual C++.

Nov-92 - Nov-93. Visiting Researcher. German Research Center for Computer Science, Integrated Information and Publication Systems Institute, Darmstadt, Germany. Research project for the multimedia distributed object oriented database VODAK, on Sun OS/Solaris. Developed an object manager/mapper (in C++) for mapping internal VODAK objects into/from the external database ObjectStore.

Aug-88 - Oct-92. Research Programmer. Siberian Division of Russian Academy of Sciences, Artificial Intelligence Laboratory, Novosibirsk, Russia. Chief developer of a natural language front end InterBASE for relational databases. Demo version is available upon request.

Aug-86 - Jul-88. Programmer. Scientific Industrial Corporation "Applied Mechanics", Krasnoyarsk, Russia. A developer of an operating system for embedded microprocessors.

REFERENCES

• Davor Tomasic, Project Lead, Siemens/Empros Energy & Automation
  email: [email protected], tel. (work): (612) 536-4235
• Alexander Reshetov, Ph.D., Senior Researcher, Intel Corp.,
  email: [email protected].

Attachment

PROJECTS

May-00 - present at Damark: Migration of an Internet/catalog purchase order processing system from Cfront (legacy C++) to ANSI C++ for HP UX. Also, migration of another production legacy system from PICK (database in AIX environment) to Oracle & ANSI C++ in HP UX.

The following tools were used: HP Unix (HP UX); Oracle SQL, PL/SQL, SQL*Plus, OCI; Rogue Wave Tools++, DBTools++: ANSI C++ for HP UX (aCC).

Oct-98 - Apr-00, at Honeywell: As an Oracle Apps and Microsoft SQL database developer, developed a number of programs/modules for a collection management system, a hybrid of Oracle Apps and Microsoft SQL Server: Oracle/SQL Server data population, extract programs to extract outstanding items (like old invoices, unapplied cash, etc.) from Oracle Apps and upload them into a SQL Server database which was used by collection management specialists and sales reps in the field. Also, developed a real-time data synchronization/population program to keep the SQL Server data in sync with the Oracle (Account Receivables and Project Accounting) data.

The following tools were used: Oracle SQL, PL/SQL, SQL*Plus; Microsoft SQL, Transact-SQL, bcp, Query Analyzer, Enterprise Manager; ODBC/MFC, Oracle Call Interface, Standard Template Library in Visual C++ environment. Platforms: HP UX and Windows NT.

Wrote several data retrieval stored procedured in Transact-SQL for online reports for Crystal Report Writer. Also, optimized and tuned up the reports.

Aug-98 - Sep-98: short-term assignments at multiple client sites. As a C/Unix developer, developed a data extract program to extract data from a Progress database. As a Unix/Oracle Web database backend developer developed a number of PL/SQL packages to be used in the MS Active Server Pages environment.

Apr-97 - Jul-98, at Travelers Express: As a database developer/analyst at Travelers Express has been a key member of a development team of an official check online and batch processing system, and developed:

• a cross platform command shell to run PL/SQL batch jobs and reports
• a number of PL/SQL packages for General Ledger, Account Servicing and Settlement segments
• PL/SQL report request scheduler
• an incremental make utility to retrieve PL/SQL code from PVCS, compile and promote it across development, quality and assurance, and user test environments
• a converter from PL/SQL into HTML for automatic conversion of PL/SQL code and DDL statements into a set of HTML pages with hilighted keywords, linked procedure calls, function call and reference trees, etc
  
  

The following set of software tools has been used: PVCS source code archiving system, 4NT command shell, straight C, C++, OCI, Pro*C, server side SQL and PL/SQL (Oracle 7.3) in Windows NT and MVS environments.

Optimized and tuned up a great number of SQL statements and PL/SQL packages developed by the other members of the development team.

Contributed the Freeware Oracle Call Interface Template Library to another project and the same site. The library allowed the project to be delivered on time.

Nov-94 - Feb-97, at Siemens/Empros:

• Load Forecast Populator (converts data from the Oracle database to the Spectrum database); the populator is a combination of C++ (around 1000 lines), Oracle Call Interface (around 500 lines) and Pascal (around 500 lines) functions.
  
  
• Advanced Application Export Program; converts data from Oracle into an Import Data Definition format; the program is a precompiler (around 2000 lines in C) which compiles a directive text file (100Kb) into an operational Pro*C application (500Kb in source code).
  
  
• Interchange Transaction Scheduler (ITS); customization of its base version for different customers (Texas Utilities Electric, Northen Ireland Electric, etc.): new user exits which convert data from the Spectrum into Oracle database, new screen forms and changes in the existing forms, graphical (Motif) interface for transaction schedules and net schedule interchanges, audit trail of changes to finalized schedules (triggers, audit trail tables and user interface); revision of the base ITS: context help system, database schema normalization, tuning and sizing, revision of C (75000 lines) and Pro*C (25000 lines) source code, ITS Oracle forms (around 30 forms).
  
  
• Long/Midterm Resource Scheduler (LMRS): 3500 lines in Pro*C, 4000 lines in PL/SQL, 47 forms in Forms 4.0, around 40 tables in Oracle.
  
  
• Short Term Load Forecast (STLF): 17 forms in Forms 4.5, 2 forms in Oracle Graphics, 6000 lines in PL/SQL, 1500 in C++, 2500 in plain C,1000 in Pascal, 4000 in Pro*C.

Jun-94 - Oct-94, at Siberian Trade Bank:

• API from C++ to Oracle for MS-Windows and Unix (8000 lines). The API was used to build up a set of Oracle Oriented Visual Basic Controls. Besides, the same functions were used for developing Oracle applications in Unix.
  
  
• API from ExoSpace (Dos Extender for CA-Clipper) to the network Oracle 7.0 (for SCO Unix) and local Oracle 6.0 (for DOS) with use of OCI library V6.0 for C language (2000 lines). The API was used for converting data from Btrieve format to Oracle.
  
  

Nov-92 - Nov-93, at Integrated Information and Publication Systems Institute:

• Research project for the multimedia distributed object oriented database VODAK, on SunOS / Solaris platform. Object manager/mapper (in C++) for mapping internal VODAK objects into/from the external database ObjectStore.
  
  ObjectStore ODBMS (gives persistent C++) was chosen as an external repository for the VODAK data. VODAK has such objects as: scalar types, arrays, sets, dictionaries, classes and metaclasses, audio, video, graphical images, etc. The object mapper includes corresponding functionality for managing the objects of all classes. Special representation and member functions for audio, video classes were also implemented and tested (the "buddy" algorithm for persistent storage was used to store and maintain complex objects, e.g., a video consists of frames that can be freely inserted, deleted, updated.
  
  

Aug-88 - Oct-92. at AI Lab:

• Research (and eventually commercial) project for developing the natural language front end InterBASE for relational databases.
  
  The front end provides facilities to customize natural language interfaces for databases. After customization, the end user can ask questions (queries) to the database in natural language (English, Russian).
  
  Implemented a big part of the InterBASE: the whole user interface, search engine, NLI schema editor, dictionary editor, scanning database tables to extract keyword, compiler from intermediate query language (IQL) to interpreted code, context help system, a big part of user's manual, etc.
  
  InterBASE was chiefly implemented in Borland Pascal and C/C++. The search engine includes part written on Clipper and another part of source code on C - to implement fast keyword/template search (special non-Clipper index is used to perform fast search by keywords/templates (such as phone numbers, alpha-numeric codes, etc.). The IQL compiler was implemented with use of YACC.
  
  Earlier versions of InterBASE had no search engines and used dBASE, FoxBASE, FoxPro DBMSs as search servers, that is InterBASE generated formal code of a NL query in dBASE dialects and passed the control to the servers to perform the search.
  
  InterBASE was partly ported from MSDOS to Xenix/Unix platform.
  
  

Aug-86 - Jul-88, at "Applied Mechanics":

• Operating systems and application for embedded microprocessors.

AWARDS

• InterBASE won the first award of the (former USSR) Association of Artificial Intelligence in 1990.
  
  
• InterBASE was a finalist in the "Software in Europe" contest at the CeBIT'93, Hannover, Gemany (all-world soft/hardware exhibit) -- award was a free-of-charge stand for presenting InterBASE.

Also, InterBASE was registered in the Natural Language Software Registry as a commercial software package.

Copyright © 1996, 2001, Sergei Kuchin, email: [email protected], [email protected].

Permission to use, copy, modify and redistribute this document for any purpose is hereby granted without fee, provided that the above copyright notice appear in all copies.