Arkadiy Drovosekov
Chelyabinsk, 454021
Russia
Phone: +1-804-***-****
Cell: +7-351-***-****
e-mail: ******@*****.***
jabber: ******@*****.***
skype: arkadro
Software engineer
Highly motivated IT professional with proven experience in software
engineering and database programming. Great ability to analyze, develop and
implement technology solutions.
Technical qualifications
Operating systems: Linux (12 years), Solaris (3 year)
Databases: PostgreSQL (6 years), Oracle (1 year), MySQL (1 year)
Web servers: Apache (6 years)
Computer languages: Perl (10 years), regular expressions and pattern
matching (10 years), Unix shell (10 years), Korn shell / KShell (1 year),
SQL (6 years), Erlang/OTP (4 years), Assembler x86 (5 years), C (3 years),
Ruby (0.5 year), Python (0.5 year)
Technologies: SSH/FTP (10 years), GPG/PGP (10 years), Samba (3 years),
HTTP/CGI (6 years), DBI/DBD (6 years), SS7/SCCP/MAP/HLR/VLR/MSC (10 years),
Asn.1 (4 years), XML (0.5 year), Excel (0.5 year), Bugzilla trouble ticket
system (0.5 year), CSV (3 years), CVS (10 years), Gnuplot (6 years),
Vi/Sed/Awk (10 years)
Professional experience
05/2005 to Present
PortVision LLC
Senior Programmer
Responsibilities: troubleshoot, debug, resolve problems for all releases of
billing file converter (CDR-MD) software; perform pre-release test and
control; perform load/conversion/performance tests; perform customer
interaction; develop new features for customers; check new data samples for
an integrity; provide installation, troubleshooting support.
Key achievements:
designed and implemented the billing file converter (Erlang/OTP) used by
the Russian and Kazakhstan nation-wide cellular providers at 9 sites with
aggregated subscriber base over 5 million.
developed rich set of billing data change functionality based on customer
requests.
developed three major releases of the CDR-MD software.
07/2005 - to Present
Uralsvyazinform OJSC
mobile communications division,
Chelyabinsk branch.
Lead engineer
Responsibilities: automate tasks, develop automation tools, troubleshoot,
debug, resolve problems for mobile switching centers of Chelyabinsk and
Kurgan areas with aggregated subscriber base over 500 000; automate
miscellaneous tasks and develop tools for the billing department; support
the billing files delivery system; support the performance statistic
system; develop new extract/conversion/transform/load modules for new data
sources; develop new modules for the performance statistic system; query
performance tuning for the performance statistic system.
Key achievements:
designed and implemented the BSS alarm monitoring system (HTTP, CGI, Perl,
Shell, PostgreSQL, Linux, FTP) for the quality control department which
allowed to perform a power supply planning based on precise data.
created NGN statistic/ETL modules (HTTP, CGI, Perl, Shell, PostgreSQL,
Linux, SSH) for the performance statistic system which allowed to perform
an NGN hardware/software extension based on precise data.
developed the location based emergency SMS sending system (Shell, Perl,
Oracle) which allowed the Ministry of Emergency Situations' local branch to
broadcast emergency SMS.
designed and implemented the parallel network module for the subscribers'
data management system (Erlang, Perl, Linux, Apache) which improved an
average response time from 10 to 2 seconds.
automated subscriber data management tasks (Perl, Python, Ruby, Shell,
Linux) for the billing department which improved an average response time
for data manipulation commands from 30 to 2 seconds.
created the CDR (billing) files delivery system (Shell, Linux) for the
billing department which allowed to perform file delivery to several
consumers.
01/1999 - 06/2005
South-Ural Cellular Telephone, LLC
Lead engineer
Responsibilities: automate tasks, develop automation tools, troubleshoot,
debug, resolve problems for mobile switching centers of Chelyabinsk and
Kurgan areas with aggregated subscriber base over 500 000; support the
billing files delivery system; develop and support billing scripts for the
subscribers' data administration in the HLR; automate miscellaneous tasks
and develop tools for the billing department; support the performance
statistic system; develop new extract/conversion/ transform/load modules
for new data sources; develop new modules for the performance statistic
system; query performance tuning for the performance statistic system.
Key achievements:
created automated tools for the subscribers' data administration in the HLR
(Perl, Shell, Linux) for billing and maintenance departments which improved
an average response time from 20 to 3 seconds.
designed and implemented the monitoring program for the R2-SS7 signaling
converter (Assembler, DOS) which eliminated repeated heavy faults of
traffic links.
designed and implemented the traffic channel monitoring program for the
mobile switching centers (HTTP, CGI, Perl, Linux, FTP, SSH, Apache, MySQL)
for the maintenance department.
designed and implemented the performance statistic system for the mobile
switching centers (HTTP, CGI, Perl, PostgreSQL, Linux, FTP, SSH, Apache)
which allowed to perform a hardware/software extension based on precise
data.
improved SQL for the performance statistic system which reduced average
query time from 2 minutes to 5 seconds.
designed and implemented the payment transfer system for subscribers
(Shell, Linux, Samba, GPG, PGP) which improved an average transfer time
from several hours to a few minutes.
designed and implemented the CDR (billing) files delivery system (Shell,
Linux, Digital UNIX) for the billing department which improved an average
delivery time from 15 minutes to 2 minutes.
Education
Master of Science, Radio-Electronic Systems Department,
Electronics Faculty
South Ural State University, Chelyabinsk, 1990 - 1996