Dr. (RUS) Viacheslav Novgorodtsev

JEE system architect and Data Warehouse architect


Tel: +49 17647570394

GULP-ID:86534

GULP-Profile: http://www.gulp.de/Profil/vnovgorodtsev.html

XING-Profile: https://www.xing.com/profile/Viacheslav_Novgorodtsev

WEB-Profile: http://www.novgorodtsev.de

Mail: viacheslav@novgorodtsev.de







Curriculum Vitae pdf doc


Personal Facts

Born 13.10.1969 in Kemerovo / Russia

Married, three children

Fluent in English and German, both spoken and written. Native Russian speaker.


Education

1998 PhD in Computer Science

1997 Military Academy of Communication, Sankt-Petersburg

1990 Military High School of Communication, Kemerovo


Training and Certification

2006 «Oracle9i Database Administrator Certified Professional»

2005 «Oracle9i Performance Tuning» - Course

2004 «Zertifikat Deutsch» The European Language Certificates

2004 « Speed-Start Web Services» - IBM Conference Congress Centrum Bremen

2003 «Oracle9i PL/SQL Developer Certified Associate»

2003 «Oracle9i Database Administrator Certified Associate»

2001 «Certified ColdFusion 5.0 Developer” – Macromedia certified professional


Technical Skills

Enterprise Integration Architecture (EIA)

ESB: Jboss ESB, Mule

Web Services: Axis, JbossWS, JBOSS-NET, SOAP, WSDL

BPEL Engines: jBPM (JBoss)

Middleware frameworks and technologies

Persistence frameworks: Mybatis, Hibernate, JPA

JEE application framework : Spring, Seam, JSF, Facelet, Struts, Tiles, Jboss Portal

Ajax frameworks: RichFaces, PrimeFaces

JEE technology: JPA, Servlets, JSP, JNDI, JTA, JMS, JCA

Text search engines: Oracle Text, Lucene, Solr

B2B Datasources: Cnet data from Cnetchannel.com

SAP: SAP HANA, SAP NetWeaver, SAP Java Connector(JCo) , BAPI-Tools experiences

Development tools and technologies

Programming: Java, PL/SQL, Transact-SQL, C++, Perl, CFML, PHP, Flex, ActionScript

Modellers: Sybase Power Designer, Oracle Designer

IDE: RAD, Eclipse, Red Hat Developer Studio, MyEclipse

Version control systems: ClearCase, SVN, GIT, CVS, Microsoft SourceSafe

Build management: Maven, Ant, XDoclet, Continuum, Hudson, Jenkins, CruiseControl

Testing: TDD, BDD, ATTD, JUnit, Selenium, Cucumber, Jmeter,

Issue Tracking: Bugzilla, Jira, HP QC

Monitoring and Performance Analyse Tools

CA Wily Introscope

Environment

OS: HP-UX, Solaris, Linux, Windows

Database: ORACLE 8/9i/10g/11g/12c, Sybase IQ/ASE, Microsoft SQL server, DB2, SAP HANA

JEE servers: WebSphere 6.1/7/8, JBOSS, WebLogic


Projects

08.2009 – 03.2015 Data Warehouse Tools

Branch: Bank

Products / Standards / Experience:

WebSphere 6.1/7.0, Sybase IQ 12.7/15.2, Oracle 10g, UC4 API, LDAP, RAD, JEE, Spring Core, Spring Web MVC, Spring Web Flow, Spring Security, Spring Remoting, Hibernate, Ibatis/Mybatis, JSF2, PrimeFaces, Spring Flex (BlaizDS), Cairngorm (Flex), Flex SDK, BlaizDS/Spring Flex, ClearCase, WebServices, Maven 2/3, Junit 4, TestNG, Selenium WebDriver, Cucumber

Responsible for following tasks:

- status analysis

- requirements analysis

- architecture

- creation of Project Object Model (POM) for Maven

- BDD with Cucumber and Seleium WebDriver frameworks, JUnit 4

- implementation of correction tools, checkpoints tools and other modules

- documentation

- migration from WebSphere 6.1 to WebSphere 7 and from Maven 2 to Maven 3

09.2008 – 08.2009 Tools for Stress-Testing Kreditrisiko

Branch: Bank

Products / Standards / Experience:
WebSphere 6.1, Oracle 10g, RAD, JEE, Spring, Seam, JSF, Facelets, RichFaces, Hibernate, Spring Security, SVN, WebServices, Maven 2, Junit

Responsible for following tasks:

- status analysis

- requirements analysis

- architecture

- release and build management

- maven build management

08.2008 Oracle Performance Tuning

Branch: E-Commerce

Products / Standards / Experience:

Oracle 10g, EM Grid Control, STATSPACK, SQL Developer, SQL*Plus


Responsible for following tasks:

- design/SQL/database

- monitoring relevant Oracle-resources

- analyze execution plans for top sessions and top SQL

- session tracing and TKPROF

- analyze STATSPACK reports

- using indexes in sorts and JOIN

- tuning SQL statements

- solving problems with locks and access collision

- settings CBO parameters

- improving queries performance by using materialized views and temporary tables

- optimizing memory structures such as Shared Pool, Buffer Cache

- configuration of memory and disk resources


08.2008 Common ClassLoader isolation in Web Container

Branch: E-Commerce

Products / Standards / Experience:

Jboss 4, Oracle 10g, J2EE, Struts, Spring, Ibatis, Ibator, Eclipse, EJB, Subversion, Maven 2, Junit


Responsible for following tasks:

- status analysis

- requirements analysis
- customization of JBOSS ClassLoader settings
- resolving ClassCastExceptions and LinkageErrors

- Maven Build customization

- unification of compatible JAR-libraries



06.2008 ASN (After Search Navigation) Product Search for B2B E-Commerce System

Branch: E-Commerce

Products / Standards / Experience:

MatchMaker (SearchEngine), Jboss 4, Oracle 9i, J2EE, Struts, Spring, Ibatis, Ibator, Eclipse, EJB, Subversion, Maven 2, Junit


Responsible for following tasks:

- architectural concept: Product search as Service in SOA architecture

- evaluation of the search engine MatchMaker

- application design

- application components development (Spring services, Struts actions, JSP, EJB Exporter)

- creating JUnit TestCase

- creating Project Object Model (POM) for Maven 2


04.2008 – 05.2008 Evaluation and prototyping product search service for B2B E-Commerce System

Branch: E-Commerce

Products / Standards / Experience:

Solr (SearchEngine), Jboss 4, Oracle 9i, J2EE, JSF, Spring, Hibernate, RichFaces, Seam, Eclipse, Facelets, Subversion, Maven 2, Junit

Responsible for following tasks:

- evaluation of Solr SearchEngine, creating schema, preparing text data

- application design ( RichFaces, Seam, Spring, JSF, Facelets)

- application components development (Spring services, Seam components, Templates, Navigation Rules)

- creating JUnit TestCase

- creating Project Object Model (POM) for Maven 2


2007 Supplier Support System - Actebis Holding GmbH

Branch: E-Commerce

Products / Standards / Experience:

Jboss 4, Oracle 9i, J2EE, Struts, Tiles, Spring, Ibatis, Ibator, Eclipse, POI, EJB, SAP Java Connector (Jco),

DWR, Acegi, Subversion, Maven 2, JUnit


Responsible for following tasks:

- status analysis

- requirements analysis

- evaluation of different java libraries for the export in the Excel data file and the import data files from the Excel data file

- creation of JUnit TestCase

- creation of Project Object Model (POM) for Maven 2

-implementation of the import products list direct in SAP via BAPI-interface

- implementation of SQL*Loader scripts for import data from SAP


2007 Navigation Adviser

Branch: E-Commerce

Products / Standards / Experience:

Jboss 4, Oracle 9i, J2EE, Struts, Tiles, Spring, Ibatis, Abator, Eclipse, Subversion, POI, EJB, Acegi, Maven 2, JUnit


Responsible for following tasks:

- status analysis

- requirements analysis

- creating database model

- development of Spring services layer for product and accessories search

- development of Back-Office for maintenance of search engine data


2007 Universal data import for inconsistent Big Data

Branch: E-Commerce

Products / Standards / Experience:


Oracle 9i, JBoss 4, Subversion, PL/SQL, dynamic SQL, Oracle special features as EXCHANGE

PARTITION for full import, DBMS_DDL creating buffer tables, MERGE SQL Statements for incremental import, Java, JMX, EJB, HA-Services, Jboss Cache, Ibatis, Maven 2, JUnit


Responsible for following tasks:


- status analysis

- requirements analysis

- conceptual design, data modeling and requirements specification

- DB-programming, designing and realizing universal data import

- implementation HA-Services for Ibatis Cache update


The old data import pales in comparison with the new data import and shows significant performance

improvement (up to 20 till 60 time faster) and first-rate stability.


2006 -2007 Migration Pegasos and CMS to new environment (Maven 2, JDK 1.5, Jboss 4)

Branch: E-Commerce

Products / Standards / Experience:

Linux Suse, Jboss 3.2.3, Jboss 4.0.4, Ant, Maven 2.0.5, Subversion, Oracle 9i


Responsible for following tasks:

- evaluation of different tools for build as well as deployment

- status analysis

- requirements analysis

- migration of all current applications on Jboss 4.0.4, JDK 1.5

- migration of the projects to a new components architecture

- implementation of a new java project structure and build management based on Maven 2

- documentation for migration.

- altering of the deployment description, customizing to the Jboss 4 environment.

- bug fixing and defect analysis, configuration of Jboss 4.

- production control

- build and deployment management

- performance analysis


2006 Pegasos Performance Tuning

Branch: E-Commerce

Products / Standards / Experience:

Jboss 3.2.3, JDK 1.4, Oracle 9i, Servlets, Filter, EJB-Interseptor, JMX, HAServices, JVM, Wily Introscope

Responsible for following tasks:

- status analysis

- requirements analysis

- development audit filter to keep track&monitor web traffics

- development EJB-Interceptor for RMI statistics

- using Jboss JMX-Console for observing the activity in the shop

- JVM Tuning ( Analysis logs of JVM and Garbage Collector Parameters adaption)

- Oracle Database Performance Tuning (Statspack Reports Analysis, SQL statements Tuning, analyze and customizing instance settings)

- HTTP Session Tracing with Wily Introscope


2006 Wily Introscope Instrumentation for Pegasos observation

Branch: E-Commerce

Products / Standards / Experience:

Jboss 3.2.3, JDK 1.4, Oracle 9i, Wily Introscope

Responsible for following tasks:

- status analysis

- requirements analysis

- development of Dashboard for observing the Garbage Collector

- development of Alerts for Group Metrics

- development and adaption of the PBD data for Theads Pool observation

- development of Dashboards for observing the CPU load


2005 Cluster Cache for SAP Java Connector

Branch: E-Commerce

Products / Standards / Experience:

Jboss 3.2.3, Oracle 9i, Java, Java, HAServices, JbossCache, JMS, stateless EJB, MDB, Eclipse, Jmeter,

JUnit, Subversion, SAP Java Connector (Jco)


Responsible for following tasks:

- status analysis

- requirements analysis

- implementation of HA-Service for publishing return value of SAP Java Connector to the appropriate JMS topic

- development of MDB for the processing and storage in the local cache in every Node in the cluster


Implemented an asynchronous cache update, so that the slow SAP requests together with BAPI have little influence on the general performance.


2004 – 2005 Development E-Commerce B2B Pegasos

Branch: E-Commerce

Products / Standards / Experience:

Jboss 3.2.3, Oracle 9i, Oracle Text, Sybase PowerDesigner 7.0, Java, PL/SQL, Java, Servlets, JSP, EJB,

Struts, Eclipse, JMeter, JUnit, Subversion, Ibatis, Ant


Responsible for following tasks:

- status analysis

- requirements analysis

- Integration of the Cnet datasource in the Pegasos environment

- definition of quality assurance process

- preparing and maintenance of the infrastructure

- development of combined product search based on the Basis Oracle Text and CNET Datasource
- establishing of SQL statements and saved procedures;

- implementation of the data import of the text data to the Oracle 9i
- development of the product comparison, product information, product catalog based on the CNET datasource
- testing of the Web-Interface and Business Logic.

- Error tracking and rectification

- Quality control together with handover to the customer


2002 – 2003 Development and maintenance CNET Datasource in Actebis Holding GmbH

Branch: E-Commerce

Products / Standards / Experience:

Tomcat, ColdFusion server 4.5, ColdFusion studio 4.5, MS SQL Server, MS Source Safe 6.0, Sybase

PowerDesigner 7.0, CFML, TransactSQL, HTML, JavaScript, Intershop Enfinity, Java, ISML


Responsible for following tasks:

- status analysis

- requirements analysis

- integration in the Intershop Enfinity environment

- definition of quality control processes

- preparation and maintenance of the infrastructure

- optimization and configuration of ColdFusion and MS SQL Server;
- establishing of the SQL statements and saved procedures;

- configuration of Job in the Manager Agent in the MS SQL Server

- implementation of the role and the rights in Back-Office

- implementation of the Data import from MS SQL Server to Oracle 8
- projection and development of Back-Office applications together with ColdFusion Studio

- projection and development of the Java Application for the Intershop Enfinity

- development of a new product search, product comparison, product information, product catalog for the Intershop Enfinity based on the CNET Datasource
- Testing of the Web-Interface and Business Logic.

- Error tracking and rectification

- Quality control together with handover to the manufacture


2001 CMS Continity for Intershop Enfinity

Branch: E-Commerce

Products / Standards / Experience:

ColdFusion server 4.5, ColdFusion studio 4.5, MS SQL Server, MS Source Safe 6.0, Sybase

PowerDesigner 7.0, CFML, TransactSQL, HTML, JavaScript, Intershop Enfinity, ISML, Java


Responsible for following tasks:

- status analysis

- requirements analysis

- definition editing and publishing processes

- configuration and optimization of ColdFusion and MS SQL Server
- creating SQL statements

- development WYSIWYG Editor

- transformation templates from CFML to ISML

- implementation of security concepts, roles & rights of users

- implementation of preview and publishing in Intershop Enfinity
- design and development of application in ColdFusion Studio
- testing Web-Interface and Business Logic.


2001 E-Commerce project (USA): FreeSoftPromotions

Branch: E-Commerce

Products / Standards / Experience:

ColdFusion server 4.5, ColdFusion studio 4.5, Sybase Adaptive Server 12, MS Source Safe 6.0,

Sybase PowerDesigner 7.0, CFML, TransactSQL, HTML, JavaScript


Responsible for following tasks:

- status analysis

- requirements analysis

- configuration and optimization ColdFusion и Sybase Adaptive Server 12;
- development SQL statements;
- design and development application in ColdFusion Studio;
- testing Web-Interface and Business Logic.


2001 Internet-Casino project (USA): SixGunsCasino

Branch: Entertainment

Products / Standards / Experience:

JRun Server, MS SQL Server, MS Source Safe 6.0, Sybase PowerDesigner 7.0, Java, TransactSQL,

HTML, JavaScript, Servlerts, JSP


Responsible for following tasks:

- status analysis

- requirements analysis

- configuration and optimization JRun Server and MS SQL Server
- development SQL statements
- design and development in JRun Studio
- testing Web-Interface and Business Logic


2000 E-Commerce project: www.ozon.ru

Branch: E-Commerce

Products / Standards / Experience:


ColdFusion server 4.5, ColdFusion studio 4.5, Sybase Adaptive Server 12, MS Source Safe 6.0,

Sybase PowerDesigner 7.0, CFML, TransactSQL, HTML, JavaScript


Responsible for following tasks:

- status analysis

- requirements analysis

- configuration and optimization of ColdFusion и Sybase Adaptive Server 12
- development of SQL statements;
- design and development of application in ColdFusion Studio;
- testing Web-Interface and Business Logic.


1997- 1999 Lecturer in Military Academy of Communication

Held lectures and seminars on computer sciences.


1994 – 1997 PhD Thesis in Military Academy of Communication

Scientific research project for my doctoral thesis


1990 – 1994 Programmer in High Military School of Communication

Development application for communication system based on PDP-11, RSX and database

Paradox for PC-XT/ PC-AT