Pinaki Basu
Franklin,ACT
Summary
Dedicated Data Migration Specialist with a proven track record of delivering robust data migration solutions and effective ETL strategies. Skilled in SQL scripting, data mapping, transformation, and quality assurance. Adept at using SQL Server Data Tools (SSDT), Oracle, and Azure Data Factory (ADF) to ensure seamless data migration. Strong project management, problem-solving, and communication skills with a commitment to continuous improvement and teamwork.
Overview
10
10
years of professional experience
Work History
Data Migration Specialist
Defence Housing Australia (DHA)
02.2024 - Current
- Migrated legacy data from Oracle to Salesforce
- Designed flow maps and implemented transformation rules for accurate data migration
- Analyzed data quality, presented findings, and executed cleansing recommendations using SQL scripts
- Utilized SQL Server Data Tools (SSDT) for seamless migration package deployment and performance optimization
- Implemented validation checks, collaborated on standards, and maintained documentation for data integrity
- Engaged with stakeholders, conveyed project updates, and fostered a collaborative environment.
Data Engineer
Australian Fisheries Management Authority (AFMA)
08.2023 - 02.2024
- Developed and automated ETL processes using SSIS packages
- Managed Oracle databases, ran queries for data investigation, and implemented data validation and cleansing processes
- Led data migration to data warehouses ensuring accurate transfer of large datasets using SSIS and Oracle SQL Developer
- Collaborated with cross-functional teams to support data needs and developed reports aiding strategic decision-making
- Documented data architectures and ETL processes, and solved complex data issues in SQL Server, SSIS, and Oracle environments.
Data Manager
Leidos Australia
08.2022 - 07.2023
- Developed comprehensive data migration strategies aligning with organizational goals
- Engaged with clients to understand their data migration requirements and conducted data audits to identify quality issues
- Executed data cleansing processes and maintained detailed documentation of migration processes
- Managed and allocated tasks within projects and mentored junior team members in SQL Server and data migration techniques.
Data Test Engineer
Department of Health
01.2022 - 08.2022
- Conducted thorough data investigations to understand underlying data structures and patterns
- Implemented data mining methodologies to extract valuable information from large datasets
- Developed and optimized complex SQL queries in Oracle for data extraction and manipulation
- Gained practical experience with the Snowflake schema for enhanced data analysis and reporting.
Data Migration Lead
National Health and Medical Research Council (NHMRC)
06.2019 - 12.2021
- Developed comprehensive data migration strategies and managed the creation of migration flows
- Led a team of migration analysts, overseeing the creation of migration designs and system field mappings
- Supported project management with cut-over plans and impact analysis while collaborating with management
- Identified process improvement opportunities in data migration and management, and provided technical support.
Data Engineer
Lion Nathan
05.2014 - 04.2016
- Translated business requirements into effective data migration rules
- Designed workflows and dataflows for data extraction from legacy systems to MS SQL Server
- Implemented ETL job recovery mechanisms and automated ETL processes using SSIS packages
- Developed and maintained SSIS packages in Visual Studio, resolving issues during testing
- Collaborated with business groups in developing Reference Data and optimized data collation and sorting processes.
Education
Graduate Certificate of Project Management -
The University of South Australia
Master of Computer Science (Information Technology) -
The University of Western Sydney
Skills
- SQL Server Management Console (SSMS)
- SQL Server Integration Services (SSIS)
- Visual Studio
- SQL Developer for Oracle
- Microsoft Visio
- TOAD for Oracle
- JIRA
- Formal & Informal Communication
- Problem/Conflict Resolution
- Analytical & Logical Reasoning
- Effective Communication
- Self-Direction
- Highly Adaptive and Flexible
- PowerShell (Exposure)
- XML (Exposure)
Websites
Accomplishments
- Delivered a data migration solution for Lion Nathan using SQL scripting.
- Developed an SQL cursor program for a Tolling project deployed to millions of fuel stations in NSW.
- Played a vital role at the Australian Fisheries Management Authority in ETL processes and data migration.
- Formulated data migration strategies at Leidos Australia and led data cleansing and documentation efforts.
- Led a team at NHMRC focusing on data migration strategy and project management.
Timeline
Data Migration Specialist
Defence Housing Australia (DHA)
02.2024 - Current
Data Engineer
Australian Fisheries Management Authority (AFMA)
08.2023 - 02.2024
Data Manager
Leidos Australia
08.2022 - 07.2023
Data Test Engineer
Department of Health
01.2022 - 08.2022
Data Migration Lead
National Health and Medical Research Council (NHMRC)
06.2019 - 12.2021
Data Engineer
Lion Nathan
05.2014 - 04.2016
Graduate Certificate of Project Management -
The University of South Australia
Master of Computer Science (Information Technology) -
The University of Western Sydney
Similar Profiles
Pinaki BasuPinaki Basu
Data Migration Specialist at Defence Housing Australia (DHA)Data Migration Specialist at Defence Housing Australia (DHA)
Abrarullah NoorAbrarullah Noor
Senior Material Engineer at Defence Housing Authority (DHA)Senior Material Engineer at Defence Housing Authority (DHA)
RIZWANA FAHIMRIZWANA FAHIM
Sales and Marketing Manager at Defence Housing Society (DHA) IslamabadSales and Marketing Manager at Defence Housing Society (DHA) Islamabad