, , 109

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
    74

    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
    , , 129

    Project OMS.

    Start May 2013
    End May 2014
    oms-11
    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.
    • Continue Reading
    , , 124

    Project InfoHelp

    Start May 2012
    End May 2013
    ca-02
    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)

    • Continue Reading
    , , 139

    The production planning of the company “Promopost”

    Start Jun 2011
    End Mar 2012
    Схема базы данных.
    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)
    • Continue Reading
    , 113

    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