freiberufler Data applications architect and developer auf freelance.de

Data applications architect and developer

offline
  • 140‐160€/Stunde
  • 40547 Düsseldorf
  • Europa
  • ru  |  en  |  de
  • 14.11.2022

Kurzvorstellung

Over 20 years' experience creating data processing solutions and managing IT infrastructure. Development of data processing and business intelligence applications, databases and data warehouses.

Auszug Referenzen (4)

"Schnelle Auffassungsgabe und hohe Kompetenz sowohl technisch als auch fachlich. Wir sind sehr zufrieden."
Lead architect and developer
Konstantin Stolpovsky
Tätigkeitszeitraum

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.

Eingesetzte Qualifikationen

Microsoft 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."
Back-end developer
Sabina Jonas
Tätigkeitszeitraum

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.

Eingesetzte Qualifikationen

Application Development, Back-End Entwicklung, Bash (Shell), C++, Hardware Virtualisierung, IaaS (Infrastructure as a Service), 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!"
Back-end developer
Michael Mukovskiy
Tätigkeitszeitraum

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.

Eingesetzte Qualifikationen

PostgreSQL, PL/SQL, Amazon Web Services (AWS)

"Herr R. ist sehr kompetent, engagiert und zuverlässig. Wir können ihn mit gutem Gewissen weiterempfehlen."
Back-end developer
Simon Winkelsträter
Tätigkeitszeitraum

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.

Eingesetzte Qualifikationen

ETL, Microsoft SQL-Server (MS SQL), Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Team Foundation Server (TFS), Transact-SQL (T-SQL)

Qualifikationen

  • Apache Spark
  • Application Development
  • Big Data
  • Business Intelligence (BI)
  • Cloud Computing
  • Datawarehouse / DWH
  • Python
  • Software Architektur / Modellierung
  • SQL

Projekt‐ & Berufserfahrung

Lead data analyst and developer
Bank, Düsseldorf
6/2022 – offen (1 Jahr, 10 Monate)
Banken
Tätigkeitszeitraum

6/2022 – offen

Tätigkeitsbeschreibung

Analysis 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 Qualifikationen

Apache Spark, Application Development, Python, SQL

Full-stack developer
Personnel service provider, Düsseldorf
11/2021 – 4/2022 (6 Monate)
Dienstleistungsbranche
Tätigkeitszeitraum

11/2021 – 4/2022

Tätigkeitsbeschreibung

Creating 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 Qualifikationen

Django (Framework), Python, Web Entwicklung (allg.)

Web-developer. Infrastructure engineer.
Gastro, Neuss
6/2021 – 11/2021 (6 Monate)
Gastronomie
Tätigkeitszeitraum

6/2021 – 11/2021

Tätigkeitsbeschreibung

Developing 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 Qualifikationen

Netzwerkmanagement, Python, Representational State Transfer (REST), Serveradministration (allg.)

Lead architect and developer
Santander, Mönchengladbach
11/2019 – 5/2020 (7 Monate)
Banken
Tätigkeitszeitraum

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.

Eingesetzte Qualifikationen

Microsoft Power BI, SQL, Apache Spark, Application Development, Python

Back-end developer
Fidelity eTrade, Düsseldorf
12/2018 – 9/2019 (10 Monate)
Banken
Tätigkeitszeitraum

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.

Eingesetzte Qualifikationen

Application Development, Back-End Entwicklung, Bash (Shell), C++, Hardware Virtualisierung, IaaS (Infrastructure as a Service), KVM (Kernel-based Virtual Machine), Microsoft Azure, PostgreSQL

Back-end developer
metrica BI GmbH, Düsseldorf
6/2018 – 3/2019 (10 Monate)
Medienbranche
Tätigkeitszeitraum

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.

Eingesetzte Qualifikationen

PostgreSQL, PL/SQL, Amazon Web Services (AWS)

Back-end developer
ORAYLIS GmbH, Düsseldorf
12/2017 – 3/2018 (4 Monate)
IT & Entwicklung
Tätigkeitszeitraum

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.

Eingesetzte Qualifikationen

ETL, Microsoft SQL-Server (MS SQL), Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Team Foundation Server (TFS), Transact-SQL (T-SQL)

Zertifikate

Certified Information Systems Auditor (CISA)
2010

Ausbildung

Automated information processing and managing systems
Diplom-Ingenieur
2001
Moscow, Russia

Über mich

I am always open for challenging and interesting IT projects. I have deep knowledge and extensive experience in such fields as business intelligence and data processing, software development and IT components integration.

Weitere Kenntnisse

- Over 20 years' experience creating data processing solutions and managing IT infrastructure.
- 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

Sprache
  • Englisch (Fließend)
  • Deutsch (Gut)
  • Russisch (Muttersprache)
  • Ukrainisch (Gut)
Reisebereitschaft
Europa
Arbeitserlaubnis
  • Europäische Union
Home-Office
bevorzugt
Profilaufrufe
2634
Alter
46
Berufserfahrung
24 Jahre (seit 03/2000)
Projektleitung
12 Jahre

Kontaktdaten

Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.

Jetzt Mitglied werden