IGOR GARCHINE (Business & System Analyst, Architect, Certified Oracle specialist) E-mail: garchine@mail.ru ; phone: mob. 8*(8617) 701-210. Home website: http://garshin.ru (rus.). CV’s, recommendations and certification’s are placed on www.garshin.ru/personal/my-cv.html; photo - http://garshin.ru/personal/_images/my_photo/ig_plak.jpg (2003rd year).

________________________________________________________________________________

 

SUMMARY:                 Certified Oracle Specialist

                                                  Experience:

                                                  - 17 years – IT skills,

                                                    10 years from them - database development (over 20 projects),

                                                    5 last years (and earlier) – as analyst.

                                                  - Configuration of Oracle Advanced Replication (Multimaster etc).

                                                  - Complete description of the factory business model.

                                                  Customers:

                                                  - “CPC” – Caspian Pipeline Consortium.

                                                  - “Transnefteproduct” (largest company of main oil product pipeline transport).

                                                  - “Transneft” (largest company of main oil pipeline transport).

                                                  - Supreme Arbitration Court of the Russian Federation.

                                                  - Kazakhstan National Bank.

                                                       

HARDWARE:               IBM PC and compatibles

 

SOFTWARE:               OS:       MS Windows 9x-2000, NT, XP; UNIX (Linux RedHat 6.0); Novell Netware 5.0;

                                                                MS Windows 3.1; MS DOS 3.30-6.22; SFP-2, PDP-11.

CASE:  Oracle Designer2000 2.0-6.1; Platinum BPwin 2.5; Powersoft PowerDesigner 6.0.

Apps:    MS Office 95-2000; MS Project 2000; Lotus 1-2-3 5.01; MERANT PVCS 5.3.0-6.6.10;

              American Cybernetics Multi-Edit 8.0; Visio 5.0-2000 Prof.; Macromedia HomeSite 5...

 

DATABASES:                  Oracle 7.3-8.1.5; MS Access 95-2000 & VBA; Clipper S’97-5.2, FoxPro 1.01-2.6, Foxbase.

 

DBA UTILITIES:                   Oracle Enterprise Manager 1.3.5-1.6, Oracle Replication Manager 1.4.1; Platinum SQL-Station 3.2.0; SQL Navigator 3.1c7.

 

PROGRAMMING

LANGUAGES:                        SQL-servers:                       Oracle SQL & PL/SQL.

                                                  MS Windows 9x:                MS Visual Basic 4.0-6.0 etc.

                                                  MS DOS:                             Clipper S’87-5.2, Turbo Basic.

                                                  SFP-2:                                 Basic.

                                                  PDP-11 (DEC):                 Basic; Pascal, FORTRAN, Assembler.

 

TECHNOLOGIES:            System modeling:              IDEF0, IDEF1X, IDEF3, DFD.

                                                  Project management:       Oracle CDM, RUP.

                                                  Data Access:                      DAO, ODBC.

                                                  Web:                                     HTML (http://garshin.ru).

                                                  Protocols:                           TCP/IP, IPC.

 

EDUCATION:

 

1981-1986                       Kazan State University, Kazan city, Tatarstan, Russia,

                                                  Physical department. Speciality: physicist. The fulltime studies.

                                                  The excellent appreciated diploma (about the vibration combustion).

 

2000                               ORACLE CIS, Moscow, Russia:

¨    The course “Configure and Tune Oracle on HP/UX”;

¨    The course “Enterprise DBA Part 3: Network Administration”.

2003                               Documentum Servicies CIS, Moscow, Russia:

¨    The course “Documentum 4i Management”.

2003                               mpro IT Consult, Moscow, Russia:

¨    The course “mpro Administration”.

2003                               Interface Ltd., Moscow, Russia:

¨    The course “Oracle: Programming on SQL, PL/SQL and Java”.

2003                               Bauman’s Computer Education Centre, Moscow, Russia:

¨    The course “M2310: Developing MS ASP.NET Web Applications Using Visual Studio .Net”.

 

EXPERIENCE:

 

10/2000 - present              “Caspian Pipeline Consortium”, Technological Dep., Moscow, Russia (www.cpcpipe.ru )

1. Project: Customer Management System for Oil Shipper (m:pro, Documentum 4i, Oracle 9.1).

Positions: Analyst,  Implementator, Supporter.

2. Project: Dispatcher Report from SCADA(Oracle PL/SQL). Position: Programmer.

10/2000 – 04/2002            Company “Terna”, Dep. “Special Information Systems”, Moscow, Russia (www.terna.ru )

1. Project: Dispatching Control System “ASDU” for oil product transportation (Borland C++ 5.02, Oracle Developer2000 6.0, Oracle EE 8.1.7 & SDO).

Customer: “Transnefteproduct” Company (oil product pipeline transport) and regional centers.

Positions: Senior Analyst, Document Developer.

Performed:

¨    Planning and management for enterprise exploration and business analysis.

¨    Business and system analysis (IDEF0, IDEF1X, IDEF3, DFD; Platinum BPwin 2.5; Oracle Designer2000 6.0).

¨    Working out technical specifications for architecture, functions, data model, interface.

¨    Development of project documents structure; expertise for project documents.

2. Project: Global Geoinformation System “VECTOR” for oil pipeline engineering objects, repairs, incidents, damages with cartographic database and ecological monitoring (Borland C++ 5.02, Oracle Developer2000 2.1, Oracle8(i) EE with Oracle Spatial Data Option).

Customer: “Transneft” Company (oil pipeline transport) and regional centers.

Positions: Senior Analyst, System Architect

Performed:

¨    Enterprise inspection, business analysis, system analysis, system modeling (IDEF0, IDEF1X, IDEF3, DFD; Platinum BPwin 2.5; Oracle Designer2000 2.1).

¨    Working out concept and technical specifications for architecture, data model, interface, functions, data migration; installation plan and development plan.

                                                       

3/1999 - 8/2000                Company “Neftegazsistemy” (Oil gas systems), Moscow, Russia (www.ogs.gomel.by )

Project: Large-scale Monitoring System “SKUTOR” for oil pipeline using activities, repairs, incidents, damages.

Customer: “Transneft” Company (oil pipeline transport) and 10 regional centers.

Positions: Database Administrator, Programmer, Technical Editor

Performed:

¨    Generation and administration distributed database with advanced replication and removed access tuning (Oracle 8.0.3-8.1.5 in OS MS Windows NT 4, Novell Netware 5, Linux RedHat 6.0). Over 200 scripts. Performing of the existing databases from Access 8to Oracle8.

¨    Database and SQL optimization (Oracle8). Client part optimization (Access 8 VBA).

¨    Instructing for the Oracle database administrators.

¨    Developing of the technical specifications for a WEB-project.

¨    Development of the service tools: “Register Manager” (MS VC++ 6.0), “Oracle Viewer” (Borland Delphi 4.0).

 

11/1997 - 8/1998              Company “Corvus Int.”, Moscow, Russia (www.corvus-tg.com )

1. Project: “Budget planning”.

Customer: Supreme Arbitration Court of the Russian Federation and 90 regional courts.

Position: Programmer

Performed:

¨    Database development, coding, testing and installation of the program “Budget planning” (Clipper 5.2).

2. Project: Bank System “KUBAZH 3C”. Program module “Fixed Assets Accounting”.

Customer: National State Bank of the Kazakhstan Republic.

Position: Programmer

Performed:

¨    Working out technical specifications.

¨    Database development, coding, testing and documenting of the program “Fixed Assets Accounting” (Clipper 5.2).

¨    Development of the system for data replication between regional banks and National Bank Processing Center (Oracle 7.3). The stored procedures – > 1000 lines, the triggers – > 300 lines.

 

8/1994 - 8/1997                Gas Service, town Kalininskaya (Krasnodar region, Russia)

Position: Programmer

Performed:

¨    Development, installation and maintaining of the programs “Salary”, “Gas realization”, “Liquefied gas accounting”, “Fixed Assets and gas mains accounting”, “Natural gas accounting”, “HR department”, “Shareholder meeting”, “Gas counter factors”, “Storehouse”,  (Clipper S'87).

¨    Development, implementation and supporting of the programs “Organizations payments”, “Tax cards”, “Salary”, “Allowances” and others (Clipper 5.1) for the cheese production factory.

¨    Development, installation and supporting of the programs “Medical service accounting” and “Payment entrusting” (Clipper S'87) for District Central Hospital.

¨    Development, installation and supporting of the programs “Land certificates” (Clipper S'87) for the District Committee of the Land Resources.

¨    Development and supporting of the application “Examination” for district schools (MS Visual Basic 5.0 & MS Access 97).

 

8/1992 - 6/1994                National Bank, Uralsk (Kazakhstan)

Position: Programmer

Performed:

¨    Modification, commissioning and production support of the program “Bank Operating Day” (FoxBASE 2.0) in district bank departments.

¨    Installation of the telecommunication for the District Bank Departments (Telix).

¨    Development of the programs “Calculation of the consolidated balance”, “Entering of the bank documents”, “Everyday balance” (Clipper S'87).

 

12/1990 - 6/1992              Branch of the State Computer Committee, Uralsk, (Kazakhstsn)

Position: Programmer

Performed:

¨    Development of the program for plotter managing (Pascal / DEC).

¨    Development of the program “Salary” (Basic / DEC).

¨    Modification, commissioning & production support of the programs “Salary” (Clipper S'87), “Storehouse” (FoxBASE 2.0), “Personnel” (FoxPro 1.01), “Fixed Assets” (Turbo Pascal 5.0).

¨    Development of the program “Pensions and allowances accounting” (Clipper S'87).

 

11/1989 - 11/1990            Scientific and Research Institute “Granite” (shipbuilding), Uralsk (Kazakhstan)

Position: Programmer. Performed: Development of the program for booting and testing of the On-board Multicomputer (DEC Assembler).

 

9/1986 - 11/1989              Scientific and Research Institute “Hydrosystems” (shipbuilding), Uralsk (Kazakhstan)

Position: Programmer

Performed:

¨    Development of the program “Submarine dynamics imitation” (Pascal, FORTRAN / DEC).

¨    Production support of the system program for the On-board Computer (Pascal / DEC).

 

LANGUAGES:                        Russian (native), English (reading and writing).

 

KNOWLEDGES:                   Physics, Mathematics and Linguistics.

                                                  Contents of my diploma entered in a scientific article about the vibration combustion in jets.

 

ADDITIONAL:                       The foreign passport valid till 02/02/2002. No the driving license.

 

PERSONAL DATA:              Place and date of birth: Uralsk town (Kazakhstan), August 29, 1963. Russian.

                                                  Divorced. Two children: sun of 1990 y. (lives with me) and my dhaughter of 1993 y.

HOBBIES:                              Japanese sword fencing (Tenshin Shoden Katori Shinto Ryu), martial arts; skydiving, mountain tourism and speleology; traveling; ancient history, linguistics…