Data applications architect and developer
- Verfügbarkeit einsehen
- 4 Referenzen
- 140‐160€/Stunde
- 40547 Düsseldorf
- Europa
- ru | en | de
- 14.11.2022
Kurzvorstellung
Auszug Referenzen (4)
"Schnelle Auffassungsgabe und hohe Kompetenz sowohl technisch als auch fachlich. Wir sind sehr zufrieden."
11/2019 – 5/2020
Tätigkeitsbeschreibung
- Analyzing business requirements and designing the application for providing data extraction and reporting generation functionality in the course of a major "Bank as a service" project. Defining application components (python, pyspark, pandas, jinja) and interfaces.
- Leading python code development. Outlining development, testing and deployment approaches for the team of developers. Setting up unified development environment, establishing source control, developing and executing unittests.
- Development SQL and non-SQL queries and defining templates for static batch generated reports and data extractions. Organizing data marts for interactive reports on PowerBI platform.
Power Bi, SQL, Apache Spark, Application Development, Python
"It has been some time already, but I recollect that it was a pleasure to work with M.. The solutions provided and execution itself were outstanding."
12/2018 – 9/2019
Tätigkeitsbeschreibung
Design and development of the application and supporting infrastructure.
- Creating infrastructure and software design for the solution (on-premise and cloud, Digital Ocean).
- Developing C-language application for data researching and automated decision making. Programming the section for automated orders execution on trading exchanges. Developing the Visual Basic component for data extraction, cleansing and load into CSV-format and PostgreSQL database.
- Setting up on-premise and cloud-based virtual servers using CentOS/KVM. Providing scalability through programming BASH-scripts for managing virtual servers and IaaS parts.
- Programming components for monitoring performance and availability of network and servers.
- Actively contributed to scrum sprints planning and reviews.
Application Development, Backend, Bash Shell, C++, Hardware Virtualisierung, Iaas, KVM (Kernel-based Virtual Machine), Microsoft Azure, Postgresql
"Herr [...] hat sich als ein sehr effektiver server-side Spezialist bei unseren Projekten gezeigt. Wir sind sehr zufrieden mit der Zusammenarbeit!"
6/2018 – 3/2019
Tätigkeitsbeschreibung
Developing data capture and analysis solution for gaming industry company.
- Redesigning PostgreSQL database structure, implementing new indexes and data-views to improve performance.
- Programming SQL-queries to obtain data sets and integrating outputs into the OLAP application.
- Programming PL/pgSQL functions and procedures in order to improve code usability.
- Developing scripts for integration and management buckets and objects stored on AWS S3.
Postgresql, PL/SQL, Amazon Web Services (AWS)
"Herr R. ist sehr kompetent, engagiert und zuverlässig. Wir können ihn mit gutem Gewissen weiterempfehlen."
12/2017 – 3/2018
Tätigkeitsbeschreibung
Data warehouse development project.
- Programming T-SQL procedures and data-processing queries for MSSQL SSRS reports.
- ETL development for data sources integration using MSSQL SSIS.
- Modeling business data representations using OLAP Cube, MDX-queries and Excel pivot tables.
- Source control and documentation development in MS Team Foundation Server.
ETL, Microsoft SQL-Server (MS SQL), Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Team Foundation Server, Transact-Sql
Qualifikationen
Projekt‐ & Berufserfahrung
6/2022 – offen
TätigkeitsbeschreibungAnalysis and documentation of business requirements and translation into the code. Assurance of the code quality by applying appropriate testing. Analysis for existing data pipelines and data sources, participating in design sessions. Design models and scenarios for various business processes and development of relevant application components using Python, Apache Spark, SQL.
Eingesetzte QualifikationenApache Spark, Application Development, Python, SQL
11/2021 – 4/2022
TätigkeitsbeschreibungCreating interfaces and integrating data-flows between back-end and front-end applications (Bullhorn, web-portal, messaging apps). Proposing the concept and further development of web-portal based on Bootstrap/Django frameworks, developing and programming functionality using Java-scripts and Python, participating in UX design.
Eingesetzte QualifikationenDjango, Python, Web Entwicklung
6/2021 – 11/2021
TätigkeitsbeschreibungDeveloping web-site and integrating web-ordering system (python/REST). Overall servicing for in-house and cloud-based parts of IT infrastructure, maintenance of centos server, including components such as postfix, Apache, ngnix, firewalld. Upgrading network devices and implementing fail-safe connection to the upstream provider.
Eingesetzte QualifikationenNetzwerkmanagement, Python, Representational State Transfer (REST), Server Administration
11/2019 – 5/2020
Tätigkeitsbeschreibung
- Analyzing business requirements and designing the application for providing data extraction and reporting generation functionality in the course of a major "Bank as a service" project. Defining application components (python, pyspark, pandas, jinja) and interfaces.
- Leading python code development. Outlining development, testing and deployment approaches for the team of developers. Setting up unified development environment, establishing source control, developing and executing unittests.
- Development SQL and non-SQL queries and defining templates for static batch generated reports and data extractions. Organizing data marts for interactive reports on PowerBI platform.
Power Bi, SQL, Apache Spark, Application Development, Python
12/2018 – 9/2019
Tätigkeitsbeschreibung
Design and development of the application and supporting infrastructure.
- Creating infrastructure and software design for the solution (on-premise and cloud, Digital Ocean).
- Developing C-language application for data researching and automated decision making. Programming the section for automated orders execution on trading exchanges. Developing the Visual Basic component for data extraction, cleansing and load into CSV-format and PostgreSQL database.
- Setting up on-premise and cloud-based virtual servers using CentOS/KVM. Providing scalability through programming BASH-scripts for managing virtual servers and IaaS parts.
- Programming components for monitoring performance and availability of network and servers.
- Actively contributed to scrum sprints planning and reviews.
Application Development, Backend, Bash Shell, C++, Hardware Virtualisierung, Iaas, KVM (Kernel-based Virtual Machine), Microsoft Azure, Postgresql
6/2018 – 3/2019
Tätigkeitsbeschreibung
Developing data capture and analysis solution for gaming industry company.
- Redesigning PostgreSQL database structure, implementing new indexes and data-views to improve performance.
- Programming SQL-queries to obtain data sets and integrating outputs into the OLAP application.
- Programming PL/pgSQL functions and procedures in order to improve code usability.
- Developing scripts for integration and management buckets and objects stored on AWS S3.
Postgresql, PL/SQL, Amazon Web Services (AWS)
12/2017 – 3/2018
Tätigkeitsbeschreibung
Data warehouse development project.
- Programming T-SQL procedures and data-processing queries for MSSQL SSRS reports.
- ETL development for data sources integration using MSSQL SSIS.
- Modeling business data representations using OLAP Cube, MDX-queries and Excel pivot tables.
- Source control and documentation development in MS Team Foundation Server.
ETL, Microsoft SQL-Server (MS SQL), Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Team Foundation Server, Transact-Sql
Zertifikate
Ausbildung
Moscow, Russia
Über mich
Weitere Kenntnisse
- Development of data processing and business intelligence applications, databases and data warehouses. Extensive algorithmic thinking and programming languages practice.
- Design, deployment and maintenance of IT infrastructure, cloud computing and virtualization. Integration of applications, technology and facilities structures.
- Adaptation and implementation of IT best practices and relevant regulations (ITIL, COBIT, SOX). Development of information processing and security policies, planning and providing information security. Handling budgets and financial aspects of IT.
- Strong project management and task delivery skills. Successfully led several teams of IT specialists, performing tasks assignment and control of execution.
- Extensive knowledge of financial industry processes, in particular retail banking and financial trading of stocks and commodities, including algorithmic high-frequency trading.
IT technologies:
- Platforms: Windows (desktop, servers NT/20xx), Unix (Linux, CentOS, FreeBSD).
- Cloud, virtualization: Azure/AWS/Google Cloud/DigitalOcean (IaaS, PaaS), KVM, Virtualbox.
- Data: PostgreSQL, MS SQL (SSIS, SSAS, SSRS), Hadoop, Hive, Spark, PowerBI, Zeppelin.
- Programming: Python, SQL, DAX, C/C++, Visual Basic, various other scripts and shells.
- Web: Apache, Nginx, IIS, ASP, PHP, Bootstrap, CSS, HTML.
- Networking: TCP/IP stack, routing, DNS, VPN, HAProxy.
- Security: IDS/IPS, iptables, Sophos, DGuardian.
Persönliche Daten
- Englisch (Fließend)
- Deutsch (Gut)
- Russisch (Muttersprache)
- Ukrainisch (Gut)
- Europäische Union
Kontaktdaten
Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.
Jetzt Mitglied werden