Data applications architect and developer

freiberufler Data applications architect and developer auf freelance.de
Referenz
offline
Europa
en  |  de  |  ru
90€/Stunde
40547 Düsseldorf
16.11.2020

Kurzvorstellung

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

Auszug Referenzen (1)

"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)

Ich biete

  • Application Development
  • Big Data
  • Business Intelligence (BI)
  • Cloud Computing
  • Datawarehouse / DWH

Projekt‐ & Berufserfahrung

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
9/2018 – 9/2019 (1 Jahr, 1 Monat)
Banken
Tätigkeitszeitraum

9/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

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


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

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


Zertifikate

Certified Information Systems Auditor (CISA)
März 2010

Ausbildung

Automated information processing and managing systems
(Diplom-Ingenieur)
Jahr: 2001
Ort: Moscow, Russia

Qualifikationen

- Over 18 years' experience creating data processing solutions and managing IT infrastructure.
- Development of business intelligence and data analysis applications, databases and data warehouses. Extensive algorithmic thinking and use of various programming languages.
- 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.


- Platforms: Windows (desktop, servers NT/20xx), Unix (Linux, CentOS, FreeBSD).
- Cloud, virtualization: Azure/AWS/Google Cloud/DigitalOcean (IaaS, PaaS), KVM, Virtualbox.
- Data: MS SQL (SSIS, SSAS, SSRS), T-SQL, PostgreSQL, PL/SQL, MySQL, MongoDB.
- Programming: C/C++, SQL, Python, Visual Basic, Perl, various scripts and shells.
- Web: Apache, Nginx, IIS, ASP, PHP, CSS, HTML.
- Networking: TCP/IP stack, routing, DNS, VPN, HAProxy.
- Security: IDS/IPS, iptables, Sophos, DGuardian.

Über mich

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

Persönliche Daten

Sprache
  • Englisch (Fließend)
  • Deutsch (Gut)
  • Russisch (Muttersprache)
  • Ukrainisch (Gut)
Reisebereitschaft
Europa
Arbeitserlaubnis
  • Europäische Union
Home-Office
bevorzugt
Profilaufrufe
1277
Alter
42
Berufserfahrung
19 Jahre und 10 Monate (seit 03/2001)
Projektleitung
10 Jahre

Kontaktdaten

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

Jetzt Mitglied werden »