Harold Chen

Experience

• 

  Nanjing Cross-century Decorative Building Materials Group Co., Ltd.

  Apr 2004 - Apr 2006

  Web Developer

  Charge of website development and IT maintenance.Develop websites and form applications by ASP and Access.IT help desk support.

• 

  Nanjing Kuanlian network development co. LTD.

  Apr 2006 - Jul 2009

  Senior Developer

  Charge of website project management and development.Develop websites and form applications by HTML/CSS, JavaScript, ASP, PHP, and Access, MySql.

• 

  Jiangsu XINLIHUA Group

  Jul 2009 - Nov 2012

  Charge of BI architecture design and development of group business.Design data warehouse architecture by MS SqlServer, and optimize table structure.Develop ETL job by MS SqlServer agent and SSIS.Develop MS SqlServer procedures and SSAS data model by DMX.Design report document template and data analysis document template.DBA of MS SqlServer. Charge of the HOMELIKE e-commerce website architecture design and development.Design website database by MS SqlServer, optimize table structure.Develop website by ASP.net with C#.Develop integration program between website and ERP by SQL.DBA of MS SqlServer.

  • Business Intelligence Engineer

    Oct 2011 - Nov 2012

  • Ecommerce Developer

    Jul 2009 - Oct 2011
• 

  New World Department Store China Ltd / ADR

  Nov 2012 - May 2015

  Information Technology Manager

  Charge of IT department of Nanjing store management and data warehouse architecture design and development.Make software and hardware budget, bidding, and procurement.Design data warehouse by MS SqlServer, optimize table structure.Develop ETL job by MS SqlServer agent and SSIS.Develop MS SqlServer procedures and SSAS data model by DMX.Design report document template and data analysis document template.DBA of MS SqlServer.

• 

  Jiangsu Sixiangjia technology CO LTD

  May 2015 - May 2016

  Senior Development Manager

  Charge of developing team management, development specifications, application architecture design, and project management.Full-stack development by HTML/CSS, Javascript, and PHP.Design database architecture by MySql, and optimize.Integration development of WeChat.Data analysis report template development.OPS of AliYun.

• 

  Nanjing Juxi culture communication co. LTD

  May 2016 - Dec 2016

  Project Director

  Charge of project management and product roadmap planning.Charge of web and App products requirement management, architecture design, and implementation control.Development plans, product roadmap control.

• 

  Self-employed

  Jan 2017 - Apr 2019

  Senior Information Technology Consultant

  Contract IT development and consult job

• 

  Cookie Time Group

  May 2019 - now

  Information Technology And Services Professional

  Charge of ERP upgrade and migration - Organize and optimize the data structure and determine the data migration template -- ODOO ERP, MS Dynamics AX - Write data migration and validation scripts -- Python, SQL Lang - Participate in improving and defining business processesCharge of core application architecture design and full-stack development - The web portal of the franchiser, XC seller, and management staff -- PHP with Laravel, JavaScript ReactJs with Material UI and MySql - Franchiser sales APP backend server rebuild and sales data migration -- FileMaker, python, PHP with Laravel, SQL Lang, and MySql - MUNCHTIME.CO.NZ e-commerce website -- WordPress with PHP, JavaScript jQuery and MySqlCharge of integration architecture design and development - MS Dynamics AX 2012 ERP data transfer with business subsystem -- Python and Ubuntu Shell script - SCS 3PL data transfer with business subsystem -- Python, PostgreSQL and Ubuntu Shell script - MUNCHTIME.CO.NZ WooCommerce API and WebHook notification with business subsystem -- Python with Facebook Workplace API, PHP with Laravel, and MySqlCharge of business intelligence architecture design and development - Data warehouse architecture design and development - ETL job design and development -- PostgreSQL, Python, SQL Lang, Ubuntu Shell script - Analysis report and dashboard design and development -- Qlik Cloud, Qlik Sense ScriptCharge of DEV OPS and Virtualization - Win Svr migration and Virtualization - MUNCHTIME.CO.NZ Amazon ECS server - Application server based on Docker Container - Gitlab Community Edition based on Docker Container - FortiClient Firewall port mapping policy -- Docker CE, Docker Compose, Ubuntu Shell script, AWS, MacOS, VM Fusion, and vBridge private cloud Show less