Pavlo M Kurochka, Data Migration Developer in Walnut Creek, CA, United States
Pavlo M Kurochka

Data Migration Developer in Walnut Creek, CA, United States

Member since May 29, 2019
Pavlo is an experienced professional who has designed, developed, and deployed data migrations and data 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. He gets along great with colleagues: once people get to know him, they always want him in their team.
Pavlo is now available for hire

Portfolio

Experience

  • Oracle PL/SQL, 20 years
  • Data Migration, 20 years
  • SQL, 20 years
  • Oracle ERP, 20 years
  • Microsoft SQL Server, 15 years
  • Syniti Data Stewardship Platform, 12 years
  • Python, 3 years
  • Pandas, 3 years

Location

Walnut Creek, CA, United States

Availability

Part-time

Preferred Environment

Python, VSC, TOAD, MySQL, MS SQL, PostgreSQL

The most amazing...

...thing I've done was GE BOMs interface. I distilled 1.5 million records to 3-500 changes. The client planned to use it for ~3 months; they used it for 2 years.

Employment

  • Senior Data Migration Consultant

    2007 - 2018
    BackOffice 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: BackOffice Data Stewardship Platform (DSP), CranSoft Toolset, Microsoft SQL Server, SAP, Oracle E-Business Suite, Cognos, Siebel, Salesforce.com, Oracle Database, Microsoft Dynamics NAV, Siemens Teamcenter PLM, MySQL, SQL

Experience

  • Zoho CRM to Hubspot CRM Data Migration (Development)
    https://www.useloom.com/share/25a3520e9ec946339d239daa67c43afb

    Proof of concept project that 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 (Development)
    https://resources.boaweb.com/customer-success-data-migration/customer-story-avnet

    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, 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++, SAP MM, Microsoft Dynamics NAV, GitHub
  • Platforms

    Windows, Visual Studio Code, Jupyter Notebook
  • Storage

    Oracle PL/SQL, Microsoft SQL Server, Data Integration, MySQL, PostgreSQL, SQLite, PL/SQL, SAP S4 HANA Cloud Services
  • Other

    BackOffice DSP, Syniti Data Stewardship Platform, CSV File Processing, SAP LSMW Data Migrations, Oracle EBS, Data Migration, Data Migration Testing, SAP FICO, SAP SD, Siebel
  • Paradigms

    Data-driven Testing

Education

  • Master's degree in Economics, Management
    1988 - 1993
    Kyiv National Commerce and Economics University - Kyiv, Ukraine
Certifications
  • 6.00.1x: Introduction to Computer Science and Programming Using Python
    MARCH 2019 - PRESENT
    MITx on edX
  • Oracle Certified Applications Consultant, Procurement Release 11
    MARCH 2000 - PRESENT
    Oracle

To view more profiles

Join Toptal
I really like this profile
Share it with others