CV: Разработчик баз данных

• Development for various telecommunications companies in Europe, Asia and Africa.
• ERP, CRM systems development for Telecommunication Billing from scratch.
• Database development (PostgreSQL, DBISAM, MySQL)
• Development of services and applications for primary Billing CDRs processing (ASN.1, Teles, XML, CSV and other VOIP / SMS switches formats).
• Delphi / Free Pascal Database Applications for Windows and UNIX systems.

• ERP, CRM system development for Billing and Warehouse Logistics systems.
• Implementation and customization of Document management system.
• Create schemes of business processes.
• Logical and physical database design.
• Development of integrated information control system (ORACLE, PostgreSQL, MS SQL Server).
• Development environment - PL/SQL , Toad PL/SQL, Oracle Business Intelligence Discoverer, Oracle Warehouse Builder , Oracle Work Flow, T-SQL, Delphi, Free Pascal.
• Manage the development team.
• Scheduling to develop by MS Project.
• Continuous monitoring of the timing and quality of the releases.
• Work closely with database administrators, application servers’ administrators, and release managers.


Projects Description:

• Development and implementation of ERP, CRM systems for Billing and Warehouse Logistics systems.
DWH design and implementation, ETL, OWF.
Development Tools: Oracle Warehouse Builder, Oracle Work Flow, Borland RAD Studio.
Languages: SQL, Oracle PL/SQL, Pascal, XML, JSON.

• DWH development and implementation that provide information for the Risk Management Department. Development of migration and accumulation of data in DWH (processes ETL, OWF). DWH design and implementation.
Development Tools: Oracle Warehouse Builder, Oracle Work Flow.
Languages: SQL, Oracle PL/SQL.

• Development of Service "Database as a Service" (Database-as-a-Service, DBaaS) for Cloud Control 12c.
Development Tools and Monitoring: Oracle Apex, ORACLE 12c cloud Control.
Languages: Oracle PL/SQL, JavaScript.
Protocols: HTTP

• Develop a system of control calculations using advice between the branches of the Bank of Russia. Including the development of the following systems:
- Bulk data loading and unloading,
- Integration with external systems,
- Reporting
- Logging and auditing,
- Administration.
Development Tools Oracle Apex.
Languages: PL/SQL, JavaScript.

• Further development of systems integration in the telecommunication company. Support the transfer of payments and reporting system.
Development Tools: Ab Initio (ETL data management and analysis).
Languages: SQL, PL/SQL, Shell Script.

• Further development of automated accounting system in the CC DIA (Deposit Insurance Agency);
Development Tools Oracle Apex.
Languages: PL/SQL, JavaScript.

• Perform full life-cycle B2B Database design and development experience.
• Create and optimize server side programs of the billing accounts receivable, account balances and rating for Telecommunication Company.
• Designed and programmed Spatial Oracle database and Oracle Warehouse in SQL, PL/SQL.
• Write SQL, PL/SQL programs including triggers and stored procedures. Used XML for replicate data to other databases. Tuned the Oracle database performance.
• Created Java programs in IntelliJ IDEA using Client/Server technology.
• Created Java libraries.
• Design logical and physical data models for telecommunication applications. Developed the application schema creation scripts. Developed the system and data migration processes.
• Create SQL scripts to extract the database schema.
• Load data into multiple databases for development or testing purposes.
• Create PL/SQL programs for check data consistency.
• Performed Oracle Database Administration for testing new programs and technologies.
• Execution loading and unloading data for development or testing purposes by SQL loader scripts

• Maintain on-line billing and tariffing for internet-, VoIP- and TV- clients.
• Development backend application (SQL, ORACLE PL/SQL).
• Development system application in C, C++ for Unix OS.
• Development Shell scripts for Unix OS and Cisco routers management. Used SNMP protocol.
• Designed and Development interfaces for a billing management system in Delphi 7 and BDS.
• Monitored the UNIX system, including the related processes, CPU, memory, and disk I/O. Created shell scripts and C-programs for good maintenance of system processes.
• Implemented shell scripts.
• Enforced security policies. Maintained users.
• Designed the database backup and recovery strategies. Implemented the backup scripts, including hot backup, cold backup and exporting and importing scripts.
• Performed administration and configuration and tuning Oracle, MS SQL Server and Informix performance. Provided perl, shell, and sql scripts for the database maintenance. Troubleshoot the system.
• Loaded and unloaded data.
• Analyze statistical data in Crystal Reports 8.5.
• Created programs for maintain on-line billing and tariffing for internet, VoIP and TV clients.
• Designed and developed interfaces for a billing management system in Delphi .
• Development procedures and triggers in MSSQL 2000 Server for Billing systems.
• Development a payment system.
• System application in С, С++.