* Extended import GSheet into GCP BigQuery with options: column numbers; automatically definitionof types, column names* Developed transfer data for BigQuery between different regions using Airflow + DataSet TransferService for full datasets and using GCS for dedicated list of tables* Owned cross-communication system between Airflow DAGs based on metadata

In additional:Regular R&D:* Improvement internal data storage (MinIo objects storage AWS S3 + Image resize + Nginx + CDN integration)* Find solution for implementation GeoJSON + Geozone (solution + high level architecture + defense at the architectural control committee)* Implement monitoring system for all products. I've designed and implemented ~90% of all metrics, dashboards and establish monitor process (start from what and why to monitor, which metrics needs and finish with alarm system). As solution selected Grafana, Prometheus, Oracle Exporter, for alarm - telegram bots.* Implement and improve errors logs system.

Development and design Master Data Managment system for international trade net (OLTP system is based on Oracle Exadata ~10TB):* performance tuning* design and improve API for integration* improve replication system (Oracle GoldenGate is main opponent)* design and develop Product Information Management system (NoSQL in Oracle)* together with BAs design new business processes and develop thatDevelop Release Notes tool (Python). It's automatization service to synchronize GIT flow process (take into account merged and unmerged branches), JIRA epics (take into account resolved and unresolved tickets, defects, hotFixes and marked version). Result of RN tool is report with mismatchingTeam lead of up to 8 Oracle developers:* improve Code review process - establish and describe rules* participated in migration for Bugzilla to Jira - established, described and fixed processes* onboarding newcomers* conduct interviews

I've participated in 2 projectsMigration Germany telecom operator:I've been Migration Team Lead.Preparation and coordination with customer Statement of Work (Migration part), Migration Strategy and scopesRegular sync ups with customersLeading of 1 BA and 2 DevelopersManagement of processes within a team and between teamsWith team we improoved migration internal tool, which helped to optimize migration process (legacy and master info models are described in one place, tool parses info models and generates migration script, which runs via Maven)Migration CAM telecom operator (one solution for 4 countries):Group leading of distributed international BA team (Russia, India, Guatemala).Planning migration timeline, scopes and solution for all countries in parallel. Management of processes within a team and between teamsRegular sync ups with customers.For me interesting experience was 2 months business trip to customer on site (Guatemala).

Have started in project as developer and after 2 years became Group lead of 3 developers.In this roles I've introduced regular code review process (integration SonarQube with CVS), performed regular review of test cases, maintened Tech Design Documentation.

Design and develop backend of Financial Reporting System for Deutsche Bundesbank: ETL process, info model, API for frontend.Regulator hard deadline forced us pay special attention for all Oracle Exadata feature (Partitioning, Parallel DML, manage updated data via hashing, etc.), perform tuning long run scripts, deep understanding of Oracle Architecture.

- design database objects (Oracle 8i, 10g, PL/SQL);- prepare long runnins reports (Oracle Forms 3, Oracle Reports)- performance analyze and tune SQL scripts; - design and develope high performance SQL query;- support and analyze urgent PROD issue;- provide FSD, TDD