Pavel Zimahorau, Developer in Málaga, Spain
Pavel is available for hire
Hire Pavel

Pavel Zimahorau

Verified Expert  in Engineering

Software Developer

Málaga, Spain

Toptal member since June 18, 2020

Bio

Pavel is a versatile developer with more than 12 years of experience with different RDBMs (mainly Oracle) in various phases such as requirement gathering, planning & analysis, development, performance tuning, and maintenance. He can successfully work in any role on a project: developer, team lead, manager, and architect. He also has built ETL and BI/DHW solutions and is able to effectively troubleshoot and resolve performance issues.

Portfolio

NDA
Java 6, PL/SQL, Oracle
O Fields
Google Sheets, Python 2, BigQuery
Ascend Partners
Python, Microsoft SQL Server, Oracle

Experience

  • Oracle RDBMS - 14 years
  • MySQL - 7 years
  • Python - 6 years
  • Google Cloud - 3 years
  • PostgreSQL - 3 years
  • BigQuery - 3 years
  • Informatica ETL - 1 year

Availability

Part-time

Preferred Environment

Bash, Git, PL/SQL Developer, Make.com, SQL, Python, No-code Development, ETL

The most amazing...

...project I've done was when I prepared a dataset for a Californian university's data science department which helped them to utilize plastic waste.

Work Experience

Development Team Lead | Project Coordinator

2016 - PRESENT
NDA
  • Gathered data from an internal customer system and processed it.
  • Delivered information to customers in FTP directories and AWS buckets.
  • Created new applications based on an existing PL/SQL framework.
  • Managed the project and worked as a solution architecture; gathered the requirements, staffed the team, scoped the management, risk-managed, and handled the product delivery.
  • Worked within a multiple-country team (the US, the UK, Canada, Belarus, Ukraine, China, and India).
Technologies: Java 6, PL/SQL, Oracle

DWH Developer

2017 - 2018
O Fields
  • Migrated data to BigQuery.
  • Implemented query preparation for a reporting tool.
  • Checked and ensured data quality.
  • Create ad-hoc queries for businesses.
Technologies: Google Sheets, Python 2, BigQuery

Developer

2015 - 2018
Ascend Partners
  • Set up projects around FDM and FDMEE tools to process the financial data.
  • Configured and mapped FDM and FDMEE processes.
  • Created custom Python and VBA scripts.
  • Migrated a database from Oracle 10 to Microsoft SQL 2012.
Technologies: Python, Microsoft SQL Server, Oracle

Python Developer

2015 - 2018
Resecurity, Inc.
  • Worked on various projects related to loading data from different sources such as websites, a public REST API, and public data sets.
  • Developed multithreading tools to work in 500 threads with Socks proxies.
  • Transformed data to work within an internal structure for further processing.
Technologies: MySQL, Python 2

Data Modeler | ETL Developer

2016 - 2016
InterContinental Hotels
  • Worked with an ETL Informatica 9 toolkit.
  • Transferred data from an Oracle database to Teradata DWH via different ways.
  • Implemented a data quality tool for checking the quality of data loads.
  • Developed and proactively bug-fixed a Markov data mart.
  • Contributed to architecture discussions and the development of a Kimpton migration. The customer extended his loyalty program to Kimpton hotels and we then had to migrate more than 5 million members from a fairly complex data structure to the customer database.
  • Defined the software development processes for the database team working in the IHG project; e.g., use of GitLab, code reviews, and weekly status meetings.
Technologies: Mapping, Informatica, Teradata, Java 7, KSH, SQL, PL/SQL

Database Developer

2015 - 2016
Think Gaming, LLC
  • Created OLAP cubes based on game activity information.
  • Stabilized ETL processes.
  • Implemented performance tuning.
Technologies: Python, MySQL

BI Developer

2015 - 2016
Affilipoint
  • Loaded data from MySQL to BigQuery.
  • Prepared ad-hoc reports for business.
  • Prepared queries for a reporting tool.
Technologies: BigQuery

Lead Database Developer

2014 - 2015
Datalex
  • Wrote reports and implemented ETL processes.
  • Designed, developed, and implemented database solutions.
  • Prepared the architecture for further development.
  • Performed database support for the team and during go-live.
  • Communicated with business people.
Technologies: Python, Perl, Bash Script, SQL, PL/SQL

Development Team Lead | Delivery Team Lead

2012 - 2013
Minsk-Moscow Main Road
  • Prepared high-level architecture.
  • Designed, developed, and implemented database and application solutions.
  • Managed team work.
  • Communicated with the client.
  • Managed the delivery.
Technologies: Windows Presentation Foundation (WPF), ADO.NET, PL/SQL, Remoting, C#, .NET

Development Team Lead | Delivery Team Lead

2008 - 2013
Severstal
  • Worked mainly on the manufacturing execution system (MES) for Severstal TPZ Sheksna.
  • Implemented a ERP data integration and an MDM data integration at database level.
  • Wrote production reports.
  • Designed, developed, and implemented database and application solutions.
  • Handled the SAP NetWeaver Process Integration (SAP PI).
  • Communicated with the client.
Technologies: Windows Presentation Foundation (WPF), ADO.NET, Remoting, PL/SQL, C#, .NET

Developer

2005 - 2013
Severstal
  • Mainly worked on the MES Severgal's manufacturing execution system.
  • Designed, developed, and implemented database and application solutions.
  • Implemented a data integration with an ERP system.
  • Wrote reports and performance tuned.
  • Provided go-live support.
Technologies: Windows Forms (WinForms), C#, Oracle

Development Team Lead | Delivery Team Lead

2011 - 2012
Misk Water Chanel Company
  • Designed, developed, and implemented database and application solutions.
  • Conducted presale activities.
  • Wrote reports.
  • Performance tuned and integrated data.
  • Migrated data from legacy systems.
Technologies: Windows Presentation Foundation (WPF), ADO.NET, PL/SQL, C#, .NET 4

Developer

2005 - 2012
Severstal
  • Developed a universal EAM system.
  • Designed, developed, and implemented database and application solutions.
  • Implemented performance tuning.
  • Integrated with external systems.
  • Handled the release preparation and provided go-live support.
Technologies: .NET, Oracle

Developer

2006 - 2010
SysProg
  • Migrated from Microsoft SQL 2005 to Oracle 10.
  • Implemented performance tuning.
Technologies: XML, C#, Microsoft SQL Server, Oracle

Developer | Delivery Team Lead | Build Engineer

2008 - 2009
Mechel, BMK 11 Plant
  • Developed a manufacturing execution system.
  • Integrated ERP data and the process control system (including the incoming ODBS queries into the InfoPlus database).
  • Designed, developed, and implemented database and application solutions.
  • Implemented the reports and ETL processes.
  • Communicated with business people.
  • Handled the build preparation and delivery.
Technologies: Windows Presentation Foundation (WPF), ADO.NET, PL/SQL, C#, .NET 3

PHP Developer

2004 - 2006
Settlement and Management of Center Housing Mingroispolkoma
  • Supported the corporate portal.
  • Implemented reports.
  • Created an administration tool for the corporate portal on Delphi.
Technologies: Oracle, PHP

Experience

MIfid2 Project

The original Markets in Financial Instruments Directive (MiFID) should remove barriers to cross-border financial services within Europe for a safer, more transparent, and more evenly balanced marketplace as a whole.

As part of this project, the financial institutes have to provide more information to the regulator, however, they don't own this information. My employer helps them and then sells the missing records to their customers.

Role: Development Team Lead | Project Coordinator

DataLex Reporting Project

Datalex a leading provider of Omni Channel Airline Retail solutions. They needed a unified eCommerce platform that combines pricing, shopping, and order management.

As part of the project, my team was responsible for everything including transferring data from the operational database to the reports, data visualization, data quality, and integration with the external systems

Minsk-Moscow Main Road

I created an IT infrastructure for a newly paid portion of the highway connecting Minsk to Moscow.

My project team was responsible for EAM (Enterprise Asset Management) system and the integration with the other parts of the IT landscape.

Chesla

Chesla is involved manufacturing execution systems (MES); specifically with a computerized system developed for black metal factories to track and document the transformation of raw materials to finished goods.

The MES provides information that helps manufacturing decision makers understand how current conditions on the plant floor can be optimized to improve production output. MES works in real time to enable the control of multiple elements of the production process (e.g., input, personnel, machines, and support services).

Chesla was delivered for use in four Severstal plants, including the BMK-Mechel group and Intercos 4-MMK.

Misk Water Chanel Company Project

I developed an operating system for the Misk Water Chanel company to maintain assets, ensure water quality, and track emergencies.

My project team was fully responsible for the project from the initialization stage to delivery.

Think Gaming Project

Think Gaming is the first mobile advertising data co-op. Their platform lets mobile game developers join forces and share advertising data that helps them find the best-paying users.

For this project, I prepared the data for custom visualization tools.

IHG ETL Project

The InterContinental Hotels Group, informally InterContinental Hotels or IHG, is a British multinational hospitality company headquartered in Denham, Buckinghamshire. IHG has 809,889 guest rooms and 5,431 hotels across nearly 100 countries.

As part of this project, our team performed a data transfer from an operational database to DWH, designed the new data marts, and performed data quality checks.

Education

1999 - 2005

Specialist's Degree in Software Engineer

Minsk State Higher Radioengineering College - Minsk, Belarus

Certifications

JUNE 2018 - JUNE 2019

Leading SAFE 4.5

Scaled Agile, Inc.

Skills

Libraries/APIs

Windows Forms (WinForms)

Tools

MySQL Workbench, BigQuery, Notepad++, Google Sheets, Git, Informatica ETL, Talend ETL

Languages

SQL, Bash, Java 6, Java 7, Bash Script, Perl, C#, XML, Python 2, KSH, Python, PHP

Storage

Oracle PL/SQL, Oracle RDBMS, MySQL, PL/SQL Developer, PostgreSQL, Google Cloud, PL/SQL, Teradata, Microsoft SQL Server, MSSQLCE

Paradigms

ETL

Frameworks

.NET, ADO.NET, Windows Presentation Foundation (WPF), .NET 4, .NET 3

Platforms

Oracle, Linux

Other

Data Modeling, UML Diagrams, Informatica, Mapping, Remoting, Make.com, No-code Development

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring