, 439

TISS Company

Start May 2022
End Jan 2025
Customer: Company “TISS”
Project type: The website of the company
My position in project:
  • DBA
  • Web-programmer
  • Windows application developer
  • Data Analyst
  • Technical support engineer
Operation systems: Windows
Databases: MS SQL, PostgreSQL, ClickHouse
Languages: C#, SQL, HTML, JavaScript
Technologies: MS SQL Database (with replications), ASP.NET MVC, Razor, IIS, .NET CORE, WinForms, Git, AWS S3, SSRS

TISS is one of the leading distributors of auto parts in Russia. Official representative of the international trade and purchasing group Nexus.

  • On the market for over 27 years
  • More than 200 brands in the portfolio
  • About 10,000 wholesale customers
  • More than 1,000 employees
  • Branches in 25 cities of Russia
  • The company’s assortment includes about a million products

Continue Reading
, , 278

CRM Sigma

Start May 2005
End May 2010
s-1
Customer: Company “Promopost”, member of OTTO Group Russia
Project type: CRM-system of the company
My position in project:
  • The database architect
  • The architect of software solutions
  • Head of development department
    • Operation systems: Windows, Linux
    Databases: Oracle 11G
    Languages: SQL, PL/SQL, XML, HTML, JavaScript
    Technologies: Oracle database, ERWIN, Oracle Apache Server, Oracle gateways, MS Access
    Interaction with payment systems: Qiwi, Elecsnet
    Interface language: English

    Brief information about the project:

  • Customer base: more than 30 million people
  • Sales: up to 500,000 parcels per month
  • The size of advertising activities: sending to 4 million emails per month
  • Database size: more than 300 GB
  • The number of tables in the database: about 300
  • The number of system users: around 500
    • Continue Reading
    230

    CRM ESCC (Russia)

    Start May 2014
    End Mar 2015
    escc-2
    Customer: Company ESCC Russia
    Project type: Revision of CRM-system
    My position in project:
  • The database architect
  • DBA
  • Programmer
    • Operation systems: Windows 2008 Server
    Databases: Oracle 11G
    Languages: PL/SQL, Oracle SQL, HTML, JavaScript
    Technologies: Oracle database, Oracle heterogeneous services (gateways), Oracle Apache Server, jQuery
    Interface language: English



    Project for improvement of CRM system of the company.

  • Database size: 70Gb
  • Number of clients is over 6 million
  • Scope of activity: Russian Federation
  • On the market: with 1996 year
  • Headquarters: in the Netherlands
  • Branches: 8 branches in Europe and former USSR
    • Continue Reading
    , 264

    Data transformation for ESCC-Russia

    Start Feb 2013
    End Apr 2014
    load-06
    Customer: Company ESCC Russia
    Project type: The internal project for replacement old CRM-system
    My position in project:
  • The database architect
  • DBA
  • Programmer
    • Operation systems: Windows 2008 Server
    Databases: Oracle, DBF
    Languages: PL/SQL, Oracle SQL, HTML, JavaScript
    Technologies: Oracle database, Oracle heterogeneous services (gateways)
    Interface language: Russian

    Project for data migration from old CRM system of the company (Clipper-DBF) to new (Oracle, HTML, JavaScript).

  • Volume data: 30Gb
  • Volume of the resulting database (with indexes): 65Gb
  • Amount of destination tables: 60
  • Maximum number of records in the table: 90 million
  • Tables with number of records more than million: 25
  • Duration of the migration process: more 24 hours
  • The ability to restart process from same point in case of an error: provided
  • Stop the transformation process from interface: provided
  • Number of steps of the process: 9
  • Skipping steps transformation in the interface settings: provided
  • Oracle server: 11G 64bit
  • The mechanism of data transfer: Oracle heterogeneous services (MS Access DBF driver)
    • Continue Reading