squarebear

 ​Square Bear

 ​Square Bear

Square Bear help you to build one-stop solution from business requirements to online.
Allow you to manage and arrange from website, mobile APPs, cloud infrastructure, big data, blockchain to
ecommerce system, Marketing SPA, CMS, BPM, Workflow
or packaged software
We could be your single touch point to facilitate technology needs

The Square Bear team was founded in 2014, graduated from ChinAccelerator, a famous incubator in Shanghai. The current team size is 20 employees. Creating and constructing high-quality IT products for customers has been the goal of the team for many years. We provide one-stop solutions including zero to one design and development, system transformation and optimization, technical staff recruitment, training and consulting services. Project scope includes IDC implementation for networks & system, mobile/website applications, packaged software, cloud or non-cloud infrastructure, hardware/IOT implementation, blockchain, big data, and fintech.

Standards and Certifications
Client projects ref

2014-2015 big data project AWS EMR, S3, Android APP
2014 Android app Drupal web backend
2014 IOS, Android appand web site
2017 Mageneto 2.0 Frontend and backend implementationPayment gateway
2017 Drupal web siteAWS EC2, nginx + php fpm tuning
Cache tuning, system upgrade
2017-2018 Drupal backend,Hardware implementation to multi-location
BI and big data workflow
Hiring and consulting
Scrum with 60+ dev team,
200-300k orders per day
2015 - 2017 Drupal web siteAWS auto-scaling architecture
Content management, Dynamic CDN
CICD, Web tuning, Newrelic, GA
Apache solr, 20+ web sites,
concurrent user 20000
2018 Dockerize of all nodejs applicationKong API gateway, nodejs PM2
Azure virtual machines, MongoDB cluster
2017-2018 Storage applicationGFW service
php application
2017 Drupal web sitePerformance tuning
AWS architecture implementation
2017-2018 Android app + web backend,
Hardware implementation, Ionic
Reactjs, Nodejs, Aliyun, CouchDB
2017-2019 Estuarine dynamic sedimentary geomorphology background data
collection application
2018-2019 academy web site, Tide monitoring application with hardware
and management web backend
2017-2018 PaaS for AWS, Azure by AWS Cloudformation, Azure ARM, Chef,
Apache Kylin, Kafka, AWS EMR,
Azure HDInight, ELK, Datadog monitoring
Docker implementation
Presales and POC
2017-2019 20+ Druapl web sites, php application, 3rd php framework
nodejs backend + electron + react js
CICD workflow,
web frontend and backend tuning
Apache solr, Project management,
Hiring and consulting
2017-2018 WeChat App, TV app,php backend,
Chinese Government project
Responsive website
Domain name and ICP,
WeChat public acct
2017-2018 Cross platform mapGPS location and navigation
User, Staff, Data management
Mobile, Desktop application
Image processing and display
2018 Online booking systemCodeigniter of php
Frontend and backend implement
2018 Blockchain projectWallet development,
Encryted hardware storage
Smart Contract
Fintect methodology, trading robot
Laravel CMS and
user management
2019 Blockchain projectWallet development,
Encryted Cellphone storage
Laravel CMS and
user management
2019 CMS project for China website
Frontend and
architecture development
2019-Current Network Equipment
2020Official Drupal website and
Complete architecture revamp
2020-2021Ecommerce system, CMS backend
Complete architecture revamp
Security enhancement
POS integration
2020-2021Single Page Application for
Mobile app marketing
2021Single Page Application for
New Shoe marketing,
Massive traffic for 8 countries
in global to release coupon code
2021-CurrentMarketing agency technical solution provider
2021-CurrentMarketing agency technical solution provider
2021-CurrentDevelopment technical solution provider, Shanghai branch
2021-CurrentAstraZeneca HK Online Health Club informative site
2021-CurrentAstraZeneca Lung Cancer information site
2021 Website integrationFor localization of marketing pages in China Cloud infra
2021 Quantum Computing SaaS Platform, development for tools and middleware
2021 SEO data analytic tools development and data gathering, desktop application
2021-2022Development technical solution provider, solution architect
2021-2023Electronic Data Collection System
2021-2023Development technical solution provider, solution architect
2021-2023Online Competition Forum Development
2021-CurrentInternal Staff Portal
2022-CurrentMarketing agency technical solution provider
2021-CurrentGaming marketing agency solution provider
2022 NYU Shanghai Photoframe application
https://10years.shanghai.nyu.edu/photo-frame/
2022 AstraZeneca HER2 Story sitehttps://her2story.hk
2022-CurrentEvo Health Patient Management system
Built by JEECG
2023 TJS imgaination Single page application
https://imagination.tianjinjuilliard.edu.cn/
2023 OpenOGAOganization main site
https://openoga/
2023 Fortocool, Fp-healthcarehttps://fortocool.fortunepharm.com/ &
https://www.fp-healthcare.com/
2023 New World Education hub
Cooperate site
https://educationhubgba.com/
2022-2023NYU Smart Building workflow ordering system, built by JEECG
2023-CurrentAstraZeneca, Oncology Academy website. https://oncologyacademy.hk/
2023-CurrentRed Sky Lighting cooperate website https://redskylighting.com
2023-CurrentWeMedTech WeChat mini-app
2023-CurrentMartell Chinese New Year Luck Draw page
2023 AstraZeneca HER2 Medical Education platform site for HCP
https://her2manage.hk
2023 - CurrentFitch Bohua China site maintenance
https://fitchbohua.cn/
2023AstraZeneca Health Club COPD, Chronic Obstuctive Pulmonary page
https://azhealthclub.com.hk/respiratory/chronic-obstructive-pulmonary
2023AstraZeneca Health Club CKD, Chronic kidney disease (CKD) page
https://azhealthclub.com.hk/ckd
2023AstraZeneca Health Club Foxiga page
https://azhealthclub.com.hk/diabetes/type2-diabetes/dm-april2021
2023The Whisky Circle Shopify site https://thewhiskycircle.net/
2024AstraZeneca Health Club 優惠申請APP
移动端运营及后台运维https://apps.apple.com/hk/app/%E5%BA%B7%E5%BF%83%E6%91%AF%E5%8F%8B/id1582875874
2024Hong Kong Government Planning Department CMS revamp
https://www.pland.gov.hk/
2024霍英東集團 Spree Social Sport club
2024Hong Kong Government Environmental Protection department X ViuTV 一步一減碳 campaign
2024Celemi cooperate china website
https://celemi.net.cn/
2024ERP application on WeChat mini-app
2024QV Skin Care HK Campaign site
https://qvskincarehk.com/
2024Toshiba HK lucky draw campaign site
https://toshiba-luckydraw.com/
2025HKU EMBA website revamp
https://emba.hkubs.hku.hk
2025Hong Kong Outback Steakhouse Online table booking WeChat Mini-app
2025Mercilon.hk Web Service security enhancement
2025https://skinscompressionna.com/ Wordpress website revamp and maintenance
2025西松屋 Industrial Manufacturing order management system
2025PPS Trading order platform
2025Pernod Ricard The Chuan Whisky brewing tour booking Wordpress site
2025-CurrentInternal Booking System
2025基石充電桩地圖管理系統
2025Sherpa Investment website revamp
Organizations
鲲鹏会
https://tgo.infoq.cn/
AWS China User Group
Drupal China Community
https://www.drupalchina.cn/
Azure User Group HK
Technical Showcases – Architecture Reform
Backgroud：Websites scaled from 3 sites to 10 sitesAWS costdown : USD 8K/m -> USD2K/mRate of flow: 3M -> 14M+ PV/monMax 20K Online Users at the same time (source from google analytics)Deployment times: 15 times/ day (Peak)SLA 99.98%Auto-scaling
Related Technology：
Drupal+AWS
Nginx
Php-fpm
Chef
Docker
SOLR
Solutions – Unlimited Bandwidth Architecture
Within a campaign, Spikes of traffic is the major concern of a technical architecture. In a serverless architecture, a event-trigger based application become possible. There are no service up-running until a logic is begin triggered. The performance is steady as all server-side resources will be loaded with CDN cache, and the client’s requests are handled by Functions in the serverless service that programmed by us but executed by the cloud.
The architect had been proven able to handle more than 30,000 visits per day.
Solutions – Hybrid Scaling(con’t)
AWS architecture:
Rebuild the whole building
Auto zoom
Cloudformation
Support for multiple domains
Dynamic CDN
Split cache between browser and CDN
Drupal/Wordpress/Any PHP framework：
Data processing, rewriting 10000 + sources
Use URL
Set Drupal 7 header
Maintain system storage independence
Individual cron jobs
PHP-FPM ：
Set up PHP_ Limit and php-fpm values
Optical buffer
Php 8+
Other tools:
Chef
Docker
SOLR
NGINX ：
Title and securityUsing nginx to implement page caching
Deploy Drupal configuration file
Page caching helps to open pages faster and reduce hard disk loss
New artifact
Drupal
Drupal is a powerful, open-source content management system (CMS) known for its flexibility and robust architecture. It's designed to handle complex websites with intricate content structures and advanced features.
Drupal's Key Strengths:
Advanced Content Management:
Scalability and Performance:
Security:
Flexibility and Customization:
Wordpress
WordPress: Empowering Website Creation
WordPress stands as a dominant force in the world of content management systems (CMS), powering a significant portion of websites across the internet. Its popularity stems from its remarkable blend of user-friendliness, flexibility, and a vibrant community.
Here's a breakdown of its key features:
Ease of Use:
Versatility:
Extensive Ecosystem:
Community Support:
SEO Friendliness:
Drupal Showcases
Case 1：HKSAR gov Planning Departmenthttps://www.pland.gov.hk/

Background：
Perform One-off System Enhancement, On-going System Enhancement and System Maintenance and Support for pland.gov.hk. Managed by PRINCE2 methodology, upgrading from D9 to D11.
Related Technology：
IIS
PHP 8
Nuxt for static page export
Drupal Custom Modules
Case 2：OpenOGA for Gitlabhttps://openoga.com

Background：
Perform One-off System Enhancement, On-going System Enhancement and System Maintenance and Support for pland.gov.hk. Managed by PRINCE2 methodology, upgrading from D9 to D11.
Related Technology：
IIS
PHP 8
Nuxt for static page export
Drupal Custom Modules
Wordpress Showcases
Case 1：Kindervarsity Hub, an internation school that locates in GuangZhouhttps://kindervarsityhub.com/

Background：
The site was built by Wordpress, embedding Lotti’s animation. Ref: https://lottiefiles.com/. With page content editable in Elementor, a wordpress plugin.

Related Technology：
Figma for design
Lotti, Frontend Animation
Wordpress / PHP hosting
Aliyun
Case 2：AZ Healthclub Disease info site.https://azhealthclub.com.hk/

Background：
The site was built by Wordpress, utilizing CMS’s out-of-the-box features.
Related Technology：
Figma for design
Wordpress / PHP hosting
Drupal vs. WordPress:

While both are popular CMS platforms, they cater to different needs:
WordPress:
Is renowned for its ease of use, making it ideal for beginners and smaller websites, such as blogs and small business sites.
Has a vast library of plugins and themes, providing quick and easy functionality.
Drupal:
Offers greater flexibility and control, particularly for complex websites with unique requirements.
Is better suited for organizations that need advanced content management, scalability, and security.
In essence:
- If you need a simple website or blog, WordPress is often the easier and faster option.
- If you require a complex, highly customized, and secure website, Drupal is generally the more powerful choice.

Essentially, Drupal is built for more complex projects, where as wordpress is built for ease of use.
Where is Square Bear?

欧帕(天津) 科技有限公司 (Infra Centre)
Rm 218, Blk A, Minglida Electronics Bldg,
Anshan West Road, Nankai District,
Tianjin

上海瞭源信息科技有限公司(Development Centre)
Rm 519, 151 Keyuan Road, Pudong New District, Shanghai

Square Bear Limited (HQ & Network Centre)
Rm 303, 134 Wai Yip Street, Kwun Tong, Hong Kong