Cloud migration – Migrate on-premises data warehouse (Oracle) & (Teradata) to AWS cloud platform.Led the migration of data workflows from on-premises infrastructure to the AWS cloud platform, utilizing AWS Managed Workflows for Apache Airflow (MWAA).Collaborated with cross-functional teams to define data requirements, develop data models, and implement ETL (Extract, Transform, Load) scalable data processing pipelines using MWAA, ensuring efficient and reliable execution of data workflows for data integration, transformation.Design, develop and maintain custom Airflow operators and Dynamic DAGs to orchestrate complex data workflows and dependencies.Analyzing the scope of on-premise ETL and planning the migration of ETL processes to the cloud can be done in different phases.Lead a team of junior developers, providing guidance, mentorship, and technical expertise.

Design, develop, and maintain scalable data pipelines to facilitate the extraction, transformation, and loading (ETL) of data from various sources into databasePrepare operations documents and guidelines for user acceptance testing and system implementationDesign and implement data migration processes, ensuring the secure and efficient transfer of data from on-premises systems to cloud storage and databases.Provide daily support for data pipelines, ensuring the timely and accurate processing of data.Monitor and troubleshoot data pipeline issues, identifying root causes and implementing effective solutions to minimize downtime.

Establish Power BI dashboards and reports by using business intelligence for operational and financial performance of APAC supply chain, customer service and demand planningStreamline process and automate data flow to enhance efficiency of data maintenance for higher productivityDeliver performance results of APAC supply chain and customer service to all stakeholders regularly, ensuring the highest level of data integrityServe as a contact point in APAC for solving inquiries associated with data / performance raised by local countries.Provide sophisticated analysis on business performance to cope with business changesServe as a key conduit to business users for requirements of ERP system (e.g. SAP, Business Object) by communicating and coordinating with IT team and users

Prepared project plans in accordance with project management standard procedures. Estimated resource allocation based on identified project scope.Work closely with user to gather user requirement to design sub-regional financial Power BI report Prepare testing scenarios and collaborate with user for testing dashboard during UAT periodPrepared training guideline to users with respect to the functions of dashboard.

Performed system testing and communicated with IT and relevant parties for verification and defect solutions during user acceptance test period. Prepared training guideline and operation manual for users with respect to the functions of various key systems.Provided the analysis for estimating usage rate after implementation.