Data Engineer
2018 - PRESENTSelf-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.
Technologies: Syniti DSP, PL/SQL, SQLAlchemy, CSV File Processing, Data Migration, Data-driven Testing, Notepad++, Jupyter Notebook, Excel VBA, Data Migration Testing, QuickBooks API, Google Drive API, Oracle ERP, Data Integration, Microsoft Excel, Windows, Oracle PL/SQL, Teamcenter, Visual Studio Code (VS Code), Twilio API, SAP, PostgreSQL, MySQL, SQL Server 2014, Oracle, SQL, Pandas, Python 3, ETL, Star Schema, Data Engineering, Data Extraction, Microsoft Access, Oracle EBS, Microsoft SQL Server, ETL Implementation & Design, APIs, Amazon Web Services (AWS)Senior Data Migration Consultant
2007 - 2018BackOffice Associates- Performed successful data migrations for multiple systems implementation projects for the following BackOffice Associates clients include St. Jude Medical (2007-2010), Avnet Technology Solutions (2010-2012), Avnet Technology Solutions GmbH (2012-2013), 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). Target systems were SAP (ECC and CRM), Oracle EBS, Siemens Teamcenter PLM, and Microsoft Dynamics NAV.
- Facilitated business requirement discussions, data mapping sessions, cross-functional, and technology 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 (for example 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.
Technologies: Syniti DSP, PL/SQL, CSV File Processing, SAP LSMW Data Migrations, Syniti Data Stewardship Platform (DSP), Notepad++, SAP S4 HANA Cloud Services, SAP MM, Excel VBA, SAP SD, SAP FICO, Data Migration Testing, BackOffice Cransoft, BackOffice DSP, Oracle ERP, Data Integration, Microsoft Excel, Windows, Oracle PL/SQL, SQL, MySQL, Teamcenter, Microsoft Dynamics NAV, Oracle Database, Salesforce, Siebel, IBM Cognos, Cognos 10, Oracle E-Business Suite (EBS), SAP, Microsoft SQL Server, DSP, ETL, Star Schema, Data Extraction, Oracle EBS, Data Engineering, CSV, ETL Implementation & Design
Pavlo M Kurochka
Data Extraction Developer in Walnut Creek, CA, United States
Member since June 18, 2020
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.
Pavlo is now available for hire
Portfolio
- Self-employedSyniti DSP, PL/SQL, SQLAlchemy, CSV File Processing, Data Migration...
- BackOffice AssociatesSyniti DSP, PL/SQL, CSV File Processing, SAP LSMW Data Migrations...
Experience
- SQL 20 years
- DB 20 years
- Data Extraction 20 years
- Data Migration 20 years
- Microsoft SQL Server 15 years
- Python 5 years
- Data Engineering 5 years
- Pandas 3 years
Availability
Full-time
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.
Employment
Experience
- Zoho CRM to Hubspot CRM Data Migrationhttps://www.useloom.com/share/25a3520e9ec946339d239daa67c43afb
This proof of concept project demonstrates the power and flexibility of the methodology and toolset that I use for data migrations.
Skills: 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
Developed and configured data conversion logic for 15 conversion objects into SAP CRM, SD, and FI.
Executed complex customer data conversion that involved integration with Satori Address Validation software and de-duplication in spreadsheets.
Skills
Languages
Python, SQL, T-SQL, Python 3, Excel VBALibraries/APIs
Pandas, Twilio API, Google Drive API, QuickBooks API, SQLAlchemyTools
BackOffice Cransoft, Microsoft Excel, Oracle ERP, Oracle E-Business Suite (EBS), Microsoft Access, Notepad++, Toad, IBM Cognos, SAP MM, Microsoft Dynamics NAV, GitHubParadigms
ETL, ETL Implementation & Design, Data-driven TestingPlatforms
Windows, Oracle Database, Visual Studio Code (VS Code), Jupyter Notebook, Amazon Web Services (AWS), Oracle, SalesforceStorage
Oracle PL/SQL, Microsoft SQL Server, Data Integration, DB, MySQL, PostgreSQL, SQLite, PL/SQL, SAP S4 HANA Cloud Services, SQL Server 2014Other
Syniti DSP, 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, SAP FICO, SAP SD, APIs, SAP, Teamcenter, Cognos 10, Siebel
Education
- Master's Degree in Economics, Management1988 - 1993Kyiv National Commerce and Economics University - Kyiv, Ukraine
Certifications
- Google IT Automation with PythonMAY 2020 - PRESENTGoogle
- 6.00.1x: Introduction to Computer Science and Programming Using PythonMARCH 2019 - PRESENTMITx on edX
- Oracle Certified Applications Consultant, Procurement Release 11MARCH 2000 - PRESENTOracle
