Title: Igor Garshin CV
Author: Igor Garshin
Last saved by: Игорь
Company: Igor Garshin site
Keywords: Igor Garshin, programmer, DBA, developer, Web-designer, CV

E-mail: garchine@mail.ru      Phones: home 7*(8617) 61-64-19, mob. 7*(8617) 701-210 (Novorossiysk, Krasnodar reg.)

IGOR GARSHIN 
(Business & System Analyst, Architect, Certified Oracle specialist, Web-designer)
E-mail: garchine@mail.ru . Phones: at home +7 (8617) 616-419, cellular +7 (9887) 701-210. 
Personal Website http://garshin.ru (Rus.).
Photo - http://garshin.ru/personal/_images/my-photo/ig-cpc2.jpg (2003 year).
________________________________________________________________________________

SUMMARY:	Certified Oracle Specialist
	Experience:
	- 28 years – IT skills,
	  24 years from them – database software development (over 20 projects - http://garshin.ru/it/applications/index.html ),
	 10 last years – as business and system analyst.
	- Configuration of Oracle Advanced Replication (Multimaster etc).
	- Complete description of the factory business model.
	Customers:
	- “CPC-R” – Caspian Pipeline Consortium (Russia).
	- “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-200x, 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; Rational Rose, Sparx Enterprise Architect.
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 Visual Studio.NET, C#, JavaSCript.
	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. UML.
	Project management:	Oracle CDM, RUP.
	Data Access:		ADO, DAO, ODBC.
	Web:			HTML5 & CSS3.
	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”.
2004	Interface Ltd., Moscow, Russia: 
•	The course “Using the professional report generator Crystal Reports 10”.
2005	Bauman’s Computer Education Centre, Moscow, Russia:
•	The course “HTML & CSS foundation”.
•	The course “Macromedia Flash MX. Foundation”.
•	The course “Action Script programming. Experience”.
2008	Edu)itonline. Guru Academy, Moscow, Russia:
•	Aaron Marcus’s seminar “Interface oriented for user”.
2009	Education Centre “Microinform”, Moscow, Russia:
•	The course “M2310: Developing Web Applications Using Microsoft Visual Studio 2008”.
2009	Bauman’s Computer Education Centre, Moscow, Russia:
•	The course “AJAX. Web-design for Web 2.0”.
•	The course “JavaScript. Level 1. Foundation”.
•	The course “JavaScript. Level 2. Expanded possibiliies”.
•	The course “Web-design. Corporative & Information websites modelling”.
2010	Interface Ltd., Moscow, Russia: 
•	The course “Using Sparx Enterprise Architect for a business modelling and system analysis”.
2011	Microinform., Moscow, Russia: 
•	The course “Web-programming: DHTML, PHP, ASP и ASP.NET”.
2011	Interface Ltd., Moscow, Russia: 
•	The course “С#-programming using Microsoft .NET Framework 4”.
2012	Specialists, Moscow, Russia:
•	The course “M10265: Developing Data Access Solutions with Microsoft Visual Studio 2010”.
•	The course “XML & XSLT: the modern technology data processing”.
2014	Specialists, Moscow, Russia:
•	The course “M20480: Programming using HTML5 with JavaScript и CSS3”.
2014	Interface Ltd., Moscow, Russia: 
•	The course “Programming on SQL and PL/SQL”.

JOBS:

04/2002 - present	“Caspian Pipeline Consortium”, Technological Dep., Moscow, Russia (http://www.cpc.ru/  )
1. Project: Customer Management System for the Oil Shippers (m:pro, Documentum 4i, Oracle 9.1). Positions: Analyst,  Implementator, Supporter.
2. Project: Dispatcher Report from SCADA OASyS (Oracle PL/SQL, MS VS.NET). 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, (Kazakhstan)
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).

ADDRESS:	Khvorostiansky street 15-257, Novorossiysk, Krasnodar region, Russia, 353925.

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 16.12.2013. The driving license is on hand.

PERSONAL DATA:	Place and date of birth: Uralsk town (Kazakhstan), August 29, 1963. Russian. 
	Divorced. Two children: sun of 1990 y. (he lives with me), daughter of 1993 y.

HOBBIES:	Japanese sword fencing (Tenshin Shoden Katori Shinto Ryu – http://katori.ru ), martial arts; skydiving; mountain tourism and speleology; traveling. 
	Scientific researches (ancient history, linguistics, paleography, paleontology, biogenesis, geodynamics…). 
	Web-design (garshin.ru, lexicons.ru, slovorod.ru, proto-slavic.ru, proto-indo-european.ru, proto-nostratic.ru).

Igor Garshin: Certified Oracle Specialist , Web Designer, Business Analyst         Page  from           August 16, 2006