Skip to content
Projects
Backend

NetSuite ERP migration

A backend solution was designed and implemented to migrate structured data from a NetSuite Legacy ERP environment to the new NetSuite SuiteTax platform, covering critical domains such as entities, client-specific customizations, and initial accounting and inventory balances.

Stack
  • SQL
  • Python
  • FastAPI
  • Pandas
  • Power Automate
NetSuite ERP migration

My role

As a fullstack developer, I played a central role in designing and executing the data migration strategy from a NetSuite Legacy environment to NetSuite SuiteTax. My work focused on building integrated, automated, and secure solutions to ensure the successful transfer of critical data. Process automation: I developed Python scripts and Power Automate flows to automate extraction, transformation, and loading, reducing manual errors and execution time.

  • REST and SOAP API integrations: Implemented robust integrations with NetSuite services and related systems via REST and SOAP, ensuring correct synchronization across platforms.
  • Optimized SQL queries: Built complex SQL queries to extract data from different sources (relational databases and Excel files), applying filters, joins, and required transformations.
  • Backend development: Built APIs with FastAPI that served as a secure and efficient bridge for Power Automate bots to interact with the new system.
  • Data quality assurance: Implemented automated validations and consistency checks to ensure referential integrity, balance reconciliation, and correct structure of migrated records.
  • Cross-functional collaboration: Worked with functional analysts, NetSuite specialists, and the QA team to ensure each migration stage met quality standards and timelines.

Key project features:

  • Data extraction from multiple sources (Excel, relational databases).
  • Normalization and transformation of structures to match the SuiteTax schema.
  • Secure intermediate APIs consumable by Power Automate bots.
  • Referential integrity validation and accounting balance reconciliation after migration.
  • Log and error tracking for process traceability and auditing.

Impact achieved

My contribution enabled a smooth, automated migration of large data volumes between ERP platforms, reducing operational time and ensuring business continuity with zero loss of critical information.

Technologies

Technology Use / Implementation
Python Development of automation scripts for data extraction and transformation.
SQL Complex queries to extract data from databases and run validations.
FastAPI Creation of REST APIs that served as a bridge between the backend and automation bots.
Pandas Processing of Excel files and data structuring before load.
Power Automate Orchestration of automated flows that consumed APIs and executed integration tasks.

Project flow

NetSuite ERP migration architecture flow