Genko Mirchev Email & Phone Number

Москва, Россия

Moscow, Russia

Technical experience:DBMS: Oracle 11g, PostgreSQL 9.5, BI Tools: Oracle BI, Data Modelling Tools: Erwin, SAP PowerDesigner. Programming Languages: SQL, PL/SQL, plpgsql. Other Tools: FishEye, TestLink, JIRA, Git.Main projects:• Design, effort estimate and conversion (database and server logic) of a Road infrastructure control and planning system(SKPDI) from Oracle RDBMS to PostgreSQL.• Integrated dispatcher service (ODS) of the Housing and Public works Department of the Moscow government – register of road maintenance objects: server logic elaboration (SQL, PL/SQL), design and implementation of integration with NSI (normative-reference information) subsystem.• Unified information system of Department of the administrative and technical inspections of Moscow government (EIS OATI): design of data architecture, architecture of interaction with external subsystems (United Dispatcher Service (ODS), Normative-Reference information system (NSI), Automate System of Register Management (ASUR), Federal Service of Officers of the Court (FSSP), Road Police Dept (GIBDD)), development of server logic, API for integration services, SQL tuning, development of methods of efficiency increase. • Subsystem NSI – Normative-Reference information: data architecture, development of server logic and interaction with external subsystems.• Analytical subsystem EIS OATI - Department of the administrative and technical inspections of Moscow government: design and development of data warehouse, ETL procedures for processing subsystems data (OATI, NSI, authorization and authentication system), repository development (Oracle BI), development of analyses and dashboards (Oracle BI).

Moscow, Russia

Technical experience:OS: Unix/Linux, DBMS: Oracle9i,10g,11g. Data Modelling Tools:PowerDesigner Programming Languages: SQL, PL/SQL, PHP, HTML. Web servers: Apache 1.3, 2.xMain projects:• Multifunctional billing system ‘Atlant’ – implemented complex database server-side logic (SQL, PL/SQL), developed API and user interfaces for Customer's Account area (PHP, HTML).• Information management system Inventory – hardware and cable management for telecommunication companies. Gathered business requirements, developed data models and database server-side logic.• Implementation of server side logic and web interface of «Billing hosting» (Oracle 10g/ PL/SQL / PHP5) • Architecture design and development of server side logic of system «Cable TV» (Oracle 10g, PL/SQL)• Design and development of interaction of web-service «Where are you on the map» with external payment systems and system Billing as a Service. (Oracle 11g, PL/SQL, XML).• Architecture and database model design for the medical information system «Notum» (Oracle 11g)