Pavlo M Kurochka
Verified Expert in Engineering
Data Extraction 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
Executed complex customer data conversion that involved integration with Satori Address Validation software and de-duplication in spreadsheets.
Skills
Languages
Python, SQL, T-SQL (Transact-SQL), Python 3, Excel VBA
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 MM, Microsoft Dynamics NAV, GitHub
Paradigms
ETL, ETL Implementation & Design, Data-driven Testing
Platforms
Windows, Oracle Database, Visual Studio Code (VS Code), Jupyter Notebook, Amazon Web Services (AWS), Google Cloud Platform (GCP), Oracle, Salesforce
Storage
Oracle PL/SQL, PostgreSQL, Microsoft SQL Server, Data Integration, DB, MySQL, SQLite, PL/SQL, SAP S4 HANA Cloud Services, 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, SAP FICO, SAP SD, APIs, RESTful Microservices, SAP, Teamcenter, Cognos 10, Siebel
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