Pavlo M Kurochka
Verified Expert in Engineering
SQL Developer
Walnut Creek, CA, United States
Toptal member since August 7, 2019
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
- SQL - 20 years
- Data Migration - 20 years
- Data Extraction - 20 years
- Enterprise Resource Planning (ERP) - 20 years
- Manufacturing Execution Systems (MES) - 10 years
- Product Lifecycle Management (PLM) - 10 years
- Python - 8 years
- Data Engineering - 5 years
Preferred Environment
PostgreSQL, Microsoft SQL Server, MySQL, Toad, Visual Studio Code (VS Code), Python, Oracle, Excel 365, DuckDB, DBeaver
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 a 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-project• 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
Proof of Concept Framework for Data Migration into Salesforce.com
https://github.com/pavlokurochka/data_migration_sfdcIt covers all the steps of a proper data migration project:
• Enabling source and target system discovery and establishing connectivity.
• Making source and target table snapshots locally.
• Data profiling and column mapping.
• Generating the code for data transformation rules that create a staging table
• Producing pre-load reports.
• Loading data into the target system while marking loaded records and capturing any load errors.
• Producing post-load reports with column-by-column comparisons between staged and loaded values.
Education
Master's Degree in Economics, Management
Kyiv National Commerce and Economics University - Kyiv, Ukraine
Certifications
Data Engineering Zoomcamp
DataTalks Club
SQL (Advanced)
HackerRank
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
Skills
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, dltHub, Primavera Unifier, Toad, IBM Cognos, SAP Materials Management (MM), Microsoft Dynamics NAV, GitHub, Terraform, Mage, BigQuery
Languages
Python, SQL, Transact-SQL (T-SQL), Python 3
Paradigms
ETL, ETL Implementation & Design, Dimensional Modeling, Data-driven Testing, Management
Storage
Oracle PL/SQL, PostgreSQL, Microsoft SQL Server, Data Integration, DB, Data Validation, Data Pipelines, MySQL, SQLite, PL/SQL, SAP S/4HANA Cloud, SQL Server 2014, NoSQL, DBeaver
Frameworks
SQLMesh, Streamlit
Platforms
Oracle Database, Visual Studio Code (VS Code), Jupyter Notebook, Amazon Web Services (AWS), Google Cloud Platform (GCP), Oracle, Salesforce, Docker, Kestra
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, MotherDuck, SAP ERP, CRM, Syniti ADMM, Enterprise Resource Planning (ERP), Product Lifecycle Management (PLM), Customer Relationship Management (CRM), Data Governance, Data Transformation, Data Warehousing, Database Schema Design, IT Support, Data Cleaning, Data Analytics, Scripting, ETL Pipelines, Data Conversion, SAP FICO, SAP Sales and Distribution (SAP SD), APIs, RESTful Microservices, Data Build Tool (dbt), Economics, Manufacturing Execution Systems (MES), Analytics, Data Marts, Data Modeling, Oracle Primavera, Oracle Primavera Cloud (OPC), SAP, Teamcenter, Cognos 10, Siebel, Google BigQuery, Data, Excel Expert
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