Kaung Myat Kyaw ( Kobe )

Data Engineering & Orchestration - Designed and developed production-ready Apache Airflow DAGs to orchestrate end-to-end data pipelines across multiple business domains. - Automated ETL workflows integrating MSSQL, ClickHouse, and cloud storage systems. - Implemented reusable DAG structures and modular pipeline architecture to improve maintainability and scalability. - Optimized task dependencies, scheduling strategies, and incremental processing to reduce runtime and system load. DBT & Data Modeling - Developed and maintained dbt models (staging, intermediate, and mart layers) following modern data warehouse architecture. - Implemented incremental models using strategies such as append, delete+insert, and ReplacingMergeTree for performance optimization. - Designed fact and dimension tables to support reporting, anomaly detection, and business KPI tracking. - Applied partitioning and ordering strategies in ClickHouse to improve query performance. Performance & Optimization - Tuned SQL queries and storage engines (MergeTree family) for large-scale analytical workloads. - Improved query performance by optimizing partition keys, order keys, and incremental filtering logic. - Reduced data latency in reporting pipelines by implementing efficient orchestration and transformation logic.

Business Intelligence & Data Integration Solutions - Delivered high-impact BI reports tailored to end-user needs, empowering stakeholders to make faster, data-driven decisions. - Resolved report issues and fixed bugs, ensuring data accuracy and reliability. - Built a Power App for Event Registration with Medical Checkup, streamlining form submission, data collection, and workflow automation across departments. - Designed and executed ETL processes to ensure smooth, optimized data flow into the enterprise data warehouse. - Integrated SAP S/4HANA with the data warehouse via SSIS, providing real-time, accurate data for reporting and analytics. - Automated SAP data extraction using optimized SSIS packages, reducing manual workload and speeding up dashboard refresh times. - Developed Power BI dashboards that unified financial, sales, inventory, and operational metrics, improving transparency and decision-making across the organization.

Data Integration & Business Intelligence Solutions - Designed a centralized data server and sync service that consolidated branch data seamlessly, improving data availability and accuracy. - Built high-performance ETL processes that reduced Power BI data load times by up to 40%. - Automated ETL scheduling with SQL Server Agent Jobs and Azure Data Factory, ensuring on-time daily data refreshes for key business transactions. - Developed custom Power BI dashboards that empowered business teams with actionable insights. - Created a Report View table for CMHL and City Express, enabling faster and more flexible data analysis. - Integrated Microsoft Dynamics 365 with Azure SQL using SSIS packages, streamlining data extraction and storage. - Enhanced ETL process efficiency, leading to faster report refreshes and improved decision-making timelines. - Continued delivery of tailored Power BI solutions to meet evolving business needs.

Team Lead – ERP & Retail Systems Development & Support - Led a team providing technical services to hundreds of V5 ERP and V5 Retail System customers, ensuring high system reliability and client satisfaction. - Directed troubleshooting efforts for critical business issues and software bugs, achieving a significant reduction in incident resolution times. - Oversaw the design and delivery of customized features and business reports, ensuring solutions met client-specific requirements. - Coordinated the creation and deployment of data exports for integration with external servers. - Managed patch releases and version upgrades, ensuring smooth implementation across multiple client systems. - Supervised system setup and deployment for new retail branch openings in major shopping centers. - Led the resolution of V5 Retail System issues to maintain uninterrupted store operations. - Directed data migration projects from V5 Retail to SAP, ensuring 100% data integrity. - Provided mentorship and guidance to team members, fostering skills growth and collaboration.

ERP & Retail Systems Support and Development - Delivered ERP services to hundreds of customers, maintaining a 99%+ system uptime and high customer satisfaction. - Diagnosed and resolved critical business issues and software bugs, reducing ticket resolution time by 30%. - Designed and implemented customized features that improved client-specific workflows, resulting in measurable efficiency gains. - Developed and deployed bespoke business reports, enabling customers to make faster, data-driven decisions. - Built automated data export pipelines for integration with external servers, cutting manual data handling time by 80%. - Led the preparation and rollout of new patches and system releases, ensuring smooth upgrades with zero operational disruption. - Supported the launch of multiple new retail branches in high-traffic shopping centers, delivering full system setup and staff on-boarding. - Troubleshot and resolved V5 Retail System issues, improving overall system stability. - Executed seamless data migration from V5 Retail to SAP, ensuring 100% data accuracy and business continuity.