Project: Lead generation for credit organizations. More than 170 partner companies (local and international).• Lead Data Analyst. Implemented an automated reporting system with data loading and aggregation from multiple independent databases (Amazon Aurora, Hetzner Cloud hosted MySQL, etc.) and third-party systems (TUNE Marketing Platform (formerly HasOffers), Google AdSense, etc.), including regular automatic reporting updates to Google Sheets. Deployed and configured Apache Superset.• Successfully migrated user bases from closing sites (1.3M and 300K unique registered users) with all associated financial information, transaction history, etc. With balancing distribution to other sites, checking for duplicates and updating information if there were matches.• Implemented design improvements to existing database architecture and corrected existing data errors (e.g., correcting invalid zip code and address mappings, removing unnecessary duplicate data, etc.).• Continuous monitoring and error correction (including acting as a project manager, setting tasks for PHP-developers, prioritizing, controlling deadlines, etc.) in the work of 5 company sites (about 10K unique visitors per day) and identifying problems on the API side of partners. Provided acceleration of some processes by more than 10 times.• ETL, data export, analyzing raw data and developing SQL scripts.

Project: Unified Information and Payment Center of Moscow. Financial services/users support, over 4M households, over 10M unique users, over 300 types of utilities, including online services.• Project’s data base design and development: implemented new logic, added flexibility, DWH for real-time reporting. Lead consultant on the developing micro-services’ data standards (XSD schemes). Final code/ scripts/ features review.• Analytics and statistics project development (from scratch): over 10K different types of data being collected and analyzed. Data analysis, PL/SQL, Transact-SQL, Excel, Oracle BI, Tableau.• Multiple databases integration (over 25 independent DBs, including MS Access, FoxFro, 1C & etc., with over 320K unique users), data exchange projects, ETL (SQL & Python scripting, Pentaho Data Integration, raw data analysis, SOAP & JSON, XSD).

Project: Unified Information and Payment Center of Moscow. Financial services/users support, over 4M households, over 10M unique users, over 300 types of utilities, including online services.• Statistics & data analysis for the project (Excel, BIRT Analytics, Oracle BI). SQL script development (PL/SQL, Transact-SQL, PostgreSQL, HP Vertica).• Analyzed and documented the project (more than 20 mln units of various types, about 20 sources of data receiving, incl. the data from devices). Database architecture, structure, design & code review (Sybase PowerDesigner). Project technical scope and limitations defining.• Integration of independent DBs into project, ETL (Pentaho Data Integration, Perl). Project DB structure adaptation. Troubleshooting (fixpacks, data verification and correction, developers support).

Key responsibilities:• Developing analytical reports (Oracle BI reports design)• Developed and maintained web portals (HTML, CSS, JS, PHP, Drupal, Perl, analytics and statistics)• Communication with prefectures and public institutions of engineering services as part of the city web-portal maintenance

Key responsibilities:• Software development (Delphi, Perl, PHP, SQL)• Industrial Safety Group LAN administration and data protection (Windows servers, Active Directory, FreeBSD, VPN, Kerio WinRoute Firewall, Kaspersky Business Space Security, StarForce)