Pavlo M Kurochka
Verified Expert in Engineering
Data Migration Developer
Pavlo is an experienced professional who has designed, developed, and deployed data migrations and integrations for dozens of successful projects of different sizes. He knows how many ERP, CRM, PLM, billing, and document management systems work inside and utilizes his experience using the latest tools and technologies. Pavlo gets along great with colleagues—once people get to know him, they want him on their team.
Portfolio
Experience
Availability
Preferred Environment
PostgreSQL, Microsoft SQL Server, MySQL, Toad, Visual Studio Code (VS Code), Python, Oracle, CSV, Excel 365
The most amazing...
...thing I've done was GE BOM's interface, distilling 1.5 million records to 3-500 changes. The client used it for two years, far longer than planned.
Work Experience
Data Engineer
Self-employed
- Developed a set of Python programs, automating the download of billing and pricing information from vendor APIs and transforming them into monthly Excel reports. Maintained history and reference data in MySQL database.
- Converted data into Siemens Teamcenter PLM using Oracle database, PL/SQL, and Python scripts.
- Converted data into SAP ERP using Synity DSP and MS SQL.
Senior Data Migration Consultant
BackOffice Associates
- Performed successful data migrations for multiple systems implementation projects for the following BackOffice Associates clients, including St. Jude Medical (2007-2010), Avnet Technology Solutions (2010-2012), and Avnet Technology Solutions GmbH (2012-2013).
- Completed the same data migrations for GE (2014-2015), Sysco (2015), LafargeHolcim (2016), The Kraft Heinz Company (2016), Municipality of Anchorage (2016-2017), Dimension Data (2017), Rockwell Collins (2017), Ferring Pharmaceuticals (2017).
- Used target systems for these mentioned projects: SAP (ECC and CRM), Oracle EBS, Siemens Teamcenter PLM, and Microsoft Dynamics NAV.
- Facilitated business requirement discussions, data mapping sessions, and cross-functional and technical meetings.
- Profiled legacy and target data to support the development of transformation specifications. Extracted data from legacy systems into staging databases.
- Designed, developed, and executed: data transformation and remediation rules, pre-load and post-load data validation reports, cross-reference tables for value mappings, and data construction web pages for data augmentation and creation.
- Identified and utilized various mass load methods in target business systems to automate data imports, such as SAP LSMW, BDC, Oracle EBS Open Interfaces, and PL/SQL APIs.
- Orchestrated and implemented data cleansing and de-duplication strategies. Developed system cutover plans.
- Planned and executed multiple test data load cycles per project, usually 4 to 7, depending on project size and complexity; analyzed and resolved resulting issues and defects.
- Established, implemented, and supported post-go-live data governance frameworks and processes. Managed onshore/offshore resources.
Experience
Zoho CRM to Hubspot CRM Data Migration
https://www.useloom.com/share/25a3520e9ec946339d239daa67c43afbSkills: ETL, Microsoft SQL Server, T-SQL, Python, Hubspot, Zoho-CRM, data migration
Please follow the link for a demo video.
Avnet SAP Data Migration Project
I executed complex customer data conversion that involved integration with Satori Address Validation software and de-duplication in spreadsheets.
Final project for the Data Engineering Zoomcamp by DataTalksClub
https://github.com/pavlokurochka/data-engineering-zoomcamp2024-projectI'm excited to share that I've completed the final project for the Data Engineering Zoomcamp by DataTalksClub! During this course, I had the opportunity to dive deep into various aspects of Data Engineering, including:
• Containerization and Infrastructure as Code: Learned about Docker, docker-compose, and setting up infrastructure on GCP with Terraform.
• Workflow Orchestration: Explored Data Lake and Workflow orchestration with Mage. Got inspired to research this field more extensively. Discovered, learned, and used in my project Kestra for orchestration.
• Data Warehouse: Gained insights into BigQuery, partitioning, clustering, and BigQuery best practices.
• Analytics Engineering: Delved into the basics of analytics engineering, dbt (data build tool), BigQuery and dbt, Postgres and dbt, dbt models, testing, documenting, deployment to the cloud and locally, and visualizing the data with Google Looker Studio and Metabase. Again, researched similar popular new technologies by myself and learned and started using DuckDB and SQLMesh.
• Batch Processing: Learned about batch processing and Spark Dataframes.
By applying these technologies, I was able to tackle my Capstone Project.
Lightweight Data Pipeline for Company of Heroes 3 Matches
https://github.com/pavlokurochka/data-engineering-zoomcamp2024-project2This open-source project, inspired by the Data Engineering Zoomcamp, showcases the power of a modern data engineering stack. All you need to install locally on your computer is Visual Studio Code. The rest, including cloud storage and computing resources, is free.
Simply create accounts on MotherDuck and GitHub and follow my detailed instructions. Within minutes, you'll have a robust and responsive data warehouse ready to handle your queries.
The example data pipeline transforms some online gaming data, but the described approach could be applied to any data source or subject matter.
Big thanks to Alexey Grigorev and the DataTalksClub team for putting together such an innovative and inspiring course.
Technologies used: Docker, Kestra, MotherDuck, SQLMesh, dlt, Python, SQL, Streamlit, DataEngineering, DEZoomcamp, dltHub, Tobiko Data
Skills
Languages
Python, SQL, T-SQL (Transact-SQL), Python 3
Libraries/APIs
Pandas, Twilio API, Google Drive API, QuickBooks API, SQLAlchemy
Tools
BackOffice Cransoft, Microsoft Excel, Oracle ERP, Oracle E-Business Suite (EBS), Microsoft Access, Notepad++, Apache Airflow, Toad, IBM Cognos, SAP Materials Management (MM), Microsoft Dynamics NAV, GitHub, Terraform, Mage
Paradigms
ETL, ETL Implementation & Design, Data-driven Testing, Management
Storage
Oracle PL/SQL, PostgreSQL, Microsoft SQL Server, Data Integration, DB, MySQL, SQLite, PL/SQL, SAP S/4HANA Cloud, SQL Server 2014, NoSQL
Other
BackOffice DSP, Syniti Data Stewardship Platform (DSP), CSV File Processing, SAP LSMW Data Migrations, Oracle EBS, Data Migration, Data Migration Testing, Star Schema, CSV, Excel 365, Data Engineering, Data Extraction, Scripting Languages, ETL Tools, Data Analysis, DuckDB, SAP FICO, SAP Sales and Distribution (SAP SD), APIs, RESTful Microservices, SQLMesh, SAP, Teamcenter, Cognos 10, Siebel, Google BigQuery, Data Build Tool (dbt), Kestra, Economics, MotherDuck, dltHub
Platforms
Oracle Database, Visual Studio Code (VS Code), Jupyter Notebook, Amazon Web Services (AWS), Google Cloud Platform (GCP), Oracle, Salesforce, Docker
Frameworks
Streamlit
Education
Master's Degree in Economics, Management
Kyiv National Commerce and Economics University - Kyiv, Ukraine
Certifications
Data Engineer
DataCamp
Google IT Automation with Python
6.00.1x: Introduction to Computer Science and Programming Using Python
MITx on edX
Oracle Certified Applications Consultant, Procurement Release 11
Oracle
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