
Pavel Zimahorau
Verified Expert in Engineering
Software Developer
Málaga, Spain
Toptal member since June 18, 2020
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
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
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
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).
DWH Developer
O Fields
- Migrated data to BigQuery.
- Implemented query preparation for a reporting tool.
- Checked and ensured data quality.
- Create ad-hoc queries for businesses.
Developer
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.
Python Developer
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.
Data Modeler | ETL Developer
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.
Database Developer
Think Gaming, LLC
- Created OLAP cubes based on game activity information.
- Stabilized ETL processes.
- Implemented performance tuning.
BI Developer
Affilipoint
- Loaded data from MySQL to BigQuery.
- Prepared ad-hoc reports for business.
- Prepared queries for a reporting tool.
Lead Database Developer
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.
Development Team Lead | Delivery Team Lead
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.
Development Team Lead | Delivery Team Lead
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.
Developer
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.
Development Team Lead | Delivery Team Lead
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.
Developer
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.
Developer
SysProg
- Migrated from Microsoft SQL 2005 to Oracle 10.
- Implemented performance tuning.
Developer | Delivery Team Lead | Build Engineer
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.
PHP Developer
Settlement and Management of Center Housing Mingroispolkoma
- Supported the corporate portal.
- Implemented reports.
- Created an administration tool for the corporate portal on Delphi.
Experience
MIfid2 Project
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
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
My project team was responsible for EAM (Enterprise Asset Management) system and the integration with the other parts of the IT landscape.
Chesla
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
My project team was fully responsible for the project from the initialization stage to delivery.
Think Gaming Project
For this project, I prepared the data for custom visualization tools.
IHG ETL Project
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
Specialist's Degree in Software Engineer
Minsk State Higher Radioengineering College - Minsk, Belarus
Certifications
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
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring