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.
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
