James Ng

• Develop data pipelines using in house Etl tools, sql and python scripts.
• Dashboarding using metabase and internal tools.
• Automated routine tasks using Python scripts, increasing team productivity and reducing manual errors.
• Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.

Projects:

• Developed a Large-Scale Traffic Dashboard that provides end-to-end data tracking of Shopee’s entry points, from the first interaction to gameplay within Shopee Games.
• Built Self-Service Data Export Tools, allowing users to dynamically generate queries and export data to Google Sheets based on inputs.

• Enhanced ETL processes by optimizing complex SQL queries and streamlining data extraction procedures.
• Develop ETL pipeline using SSIS and Datastage
• Dashboarding using Tableau

Projects:

CTBC Rwa Credit Risk Solution:

• Develop etl pipeline using SSIS for credit risk system
• Query tuning

Exim Bank (LPEI) MIS Report Automation:

• Designed and implemented a star schema to automate existing manual reports using SQL Server, SSIS, and Tableau

• Streamlined backup and recovery processes, enhancing overall system stability and availability.
• Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.