Home
About me
Name: Nikolay Voronkov
Place: Tver, Russia
Email: voronkov@engineer.com
Skype: nik-voronkov
Job: Freelancer
My portfolio (by category)
MS SQL / Oracle / mySQL
ASP.NET / Silverlight
C# / PHP
Adobe InDesign (client/server)
SSRS / SSAS
Wordpress
Decisions
Multilanguage support for Wordpress
Demo
Wordpress

CRM Sigma


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

    Read more …


  • CRM ESCC (Russia)

    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

    Read more …

  • Project OMS.

    Customer: Company “NADOM”, member of OTTO Group Russia
    Project type: The internal enterprise project for marketing Department
    My position in project:
  • The database architect
  • Head of development
  • The architect of software solutions
  • Operation systems: Windows, Mac OS
    Databases: mySQL, Oracle
    Languages: C#, PHP, SQL, Adobe JavaScript, XML
    Technologies: Silverlight, Adobe InDesign (client, server), SOAP, PHP image libraries, Microsoft Reporting Services
    Interface language: English


    OMS (Offer Management System) is a system for creating catalogs of products in a format for print (Adobe InDesign).

    Includes:

  • A graphical editor allowing you to create presentations consisting of images, text blocks, internal variables and other presentations.
  • Database (mySQL) for storage of proposals (offers) and the goods within them, which is updated from the database of a CRM system (Oracle). Also the database stores information about the catalogs and presentations.
  • The system for building of catalogue templates and the catalogues that can be replicated to the Adobe InDesign server using SOAP (PHP, Adobe JavaScript).
  • The set of scripts for client programs Adobe InDesign (Adobe JavaScript) that allow you to connect to a database of products and update prices and descriptions using internal variables.

    Read more …


  • Project InfoHelp

    Customer: Company “NADOM”, member of OTTO Group Russia
    Project type: The internal enterprise project for client department
    My position in project:
  • The database architect
  • Developer
  • Operation systems: Windows 2008 Server
    Databases: Oracle 11G
    Languages: C#, SQL, PHP
    Technologies: Silverlight, PHP image libraries, Oracle Apache Server
    Interface language: Russian

    The Project for CALL centers working with CRM of company.

    Brief description:

  • Main goal of the project: informational support of advertising campaigns of the company (promotions, catalogs, products, goods)
  • The existence of administrative and client systems
  • Support offers and client actions
  • Support product catalogs
  • Script support to communicate with customers
  • Support news
  • Support forums

    The aim of the project: provision of CALL centers working with CRM system of the company, details of promotions, product offers, products, and other information relating to the sales process. The project also has a feedback system (forums) specialists CALL centers with the Department of marketing. An additional benefit provided by the project, is to publish different kind of instructions regarding CRM system and communication process of CALL-center operators with customers (scripts-scenarios)

    Read more …


  • The production planning of the company “Promopost”


    Customer: Company “Promopost”, member of OTTO Group Russia
    Project type: Internal enterprise project for a Production Department
    My position in project:
  • The database architect
  • Developer
  • Operation systems: Windows, Linux
    Databases: mySQL, Oracle 11G
    Languages: C#, PHP, SQL
    Technologies: Silverlight, Oracle Apache Server
    IDEs: MS Visual Studio, mySQL Workbench
    Interface language: Russian

    Brief information about the project:

  • Support of calculations of loading for multiple assembly technologies
  • Planning within one month of loading assembly lines
  • Support for unlimited number of business units (firms)
  • Operational planning of lines loading for the days ahead
  • Storing relevant information about production processes in real-time
  • Import data from the CRM system of the company
  • Generation of reports in MS Reporting Services (SSRS)

    Read more …


  • Data transformation for ESCC-Russia

    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)

    Read more …