Hong Kong, Hong Kong SAR
Industry & Business Process Expertise • 20+ years of experience in the Retail industry within the IT field. • Deep understanding of end-to-end business processes across Retail, Supply Chain, Finance, CRM, HR, and Customer Services. • Strong capability in supporting Digital Transformation & Rationalization (DTR) initiatives, aligning digital solutions with operational workflows and strategic objectives. Data Management & Business Intelligence • Expertise in SQL for data management with 10+ years of experience. • Skilled in Enterprise Data Warehouse (EDW) and Business Intelligence (BI) implementation for various business processes. • Thorough understanding of enterprise data architecture for Business Intelligence on the Cloud. Cloud & Big Data Technologies • Experienced in managing big data platforms such as AWS, GCP and Azure. • Proficient in using tools like Zeppelin and Jupyter Notebook for data analysis and processing. Software Development & Automation • Proficient in Python development with Continuous Integration/Continuous Deployment (CI/CD) in the Cloud. • Strong experience in automation, data integration, and digitalization projects to enhance operational efficiency.
Project • Provide TV dashboard solution, Power BI reports are displayed on the TV dashboard without delay and data loading. Technologies: Python, Git, Jenkins, Docker, Airflow, GCP(Bigquery, Kubernetes, GCS), Power BI API, SharePoint(front-end), power-automate Data • Lead data integration for new accounting datalake (data profiling of source system, define integration scope, priority, integration method and logic, documentation, knowledge transfer for data pipeline development) in a google bigquery. (39 Countries, 475 Companies over) (JDE for APAC and EMEA, LAWSON for AMER, U8 for China, TOGO for Qeelin WW, SXC for Kering HQ, M3 for Boucheron and Gucci Watch) • Modeling and develop new data layers for financial BI use cases. • Implement data quality check dashboards between multi cloud environment [Bigquery, Athena, Hologres] and report to the support team. Management • Support backend for APAC data team (Technical Method, Authentication, Data Model, Support Model, POC, Data Quality Monitor for each data in Datalake [GCP, AWS, Ali Cloud], offering advice and supporting technical solution to the team member for brands requirements.)
Project • Migration new pre-allocation solution (STS2020) for Korea and Japan. Data • Lead data integration location, sales and supply chain for pre-allocation system. (Kafka, SSIS, MS SQL) • Lead data integration for temporary accounting DW in HKDC for POC of finance transformation project rapidly. (MS SQL, SSIS) (JDE for APAC and EMEA, LAWSON for AMAR, U8 for China, SXC for Kering HQ)
Project • HR system migration from local vendor platform to Workday. (Planning, Define procedure, Data migration, Master data management) • Expend business area on BI solution for Finance and Customer Service. Accounting (AP, AR, GL, Balance, Master Data [COA, Vendor, Customer]) Customer Service (After Sales, Before Sales) • Daily flash sales reports via email for multiple brands based on BI solution. • Travel retail data direct integration system. • Server migration from Korea office to data center in HK for 12 servers. Data • Lead data integration for multi-brands travel retail business data (KR, JP) into Global EDW. • Lead data integration for multi-brands customer master data to Klient program. (Siebel) • Lead data integration for new POS (Xstore, multi-brands) to Korea DW (MS SQL / SSIS). • MS SQL Database server administrator (Core, SSIS, SSRS) Management • Lead application team and managed 3rd party vendors. (Planning, Budgeting (€11k annual), Demand management, Documentation, Provide support model to L1 Helpdesk)
Projects • New BI solution for Retail and Supply Chain area - IBM COGNOS v10. (Previous ProClarity) Analyzed over 300 reports of business, documentation for data modeling. • MS SQL database server migration (MS SQL 2000 to MS SQL 2008 SP2). • Pre-allocation solution for store back office (STS2010). • e-workflow system with JDE for Finance. • Order management system(backend / OMS & JDA) for new launch the GUCCI e-commerce. • New business process for Concession partner (“Shinsegae Mall”) with GUCCI e-Commerce. Data • Lead data integration new POS(Xstore) to Korea DW (MS SQL / SSIS). • Lead data integration ERP system to Korea DW for new BI solution. • Implemented data quality check procedure and monitoring tool. • MS SQL Database server administrator Management (service monitoring, demand management) • BI solution (monitoring data quality, creation new reports) – ProClarity, MS SQL / SSAS • In-house developed CRM solution. (C#, .NET) • Data quality management for CRM solution with 3rd party vendor. • Managed Store Projects for multi-brands. (Opening, Closing, Re-location)
• Account management (AD account, Email (Lotus Notes)) • In-house server management (set up and maintain the windows servers and networks, monitoring) • Network management (Traffic monitoring, Subnet, Planning and prepare new site requirements) • Implemented a corporate call-center workspace (MPLS VPN, Call Manage system) • Supported Store Projects for multi-brands. (Opening, Closing, Re-location) • Asset management
• End user support for multi-brands users. • Supported Store Projects for multi-brands. (Opening, Closing, Re-location) • Implemented Corporate Intranet Portal based on SharePoint. • Asset management.