Chen-Gang He Email & Phone Number

Shanghai, China

Shanghai City, China

1. Lead key project a> Designed and Implemented data architecture, data solution and development framework based on AWS like S3 and EMR (Hive, SparkSQL, Airflow and Redshift) platform which is first big-data and cloud-based project in Merkle. b> Led China 9-people team for delivering implementation with high quality timely.c> Corporated with US team and customer.2. Lead internal POC spark streaming and Kafka based project which aims at structuring semi-streams in meta-driven fashion 3. Manage 10+ people team and other projects on China site.

Shanghai City, China

Work as data warehouse architect and big data developer1. Provide end-to-end solution and consultation for traditional data warehouse2. Work on a few big data related projects as software developer. The following is 1> It aims at identifying new IT problem patterns and categorize incoming incident more efficiently and effectively and quickly by text analysis and mining. This project improves efficiency of IT maintenance and reduces cost. It's implemented in a few innovative ways like natural language processing and Apache Spark, Sqoop and HP Vertica.2> Worked on health sensor data analysis project which is intended to analyze health sensor data in near real-time in order to identify abnormal event and provide helpful health information for patient.3> Supply Apache Hadoop, Sqoop, Oozie and Hive solution to serve data ingesting and processing for accounting data warehouse, and provide performance tuning suggestions on HiveQL.Work as data architect in traditional data warehouse1. Be responsible for designing logical and physical data model and other deliverables like source-to-target mappings spreadsheet and deployment documents.2. Participate in maintaining data modeling (DM) standard and initializing DM review process and checklist.Work as team leader for WinXpress retirement1. Manage the life cycle of the project ensuring functionalities and deadlines are achieved as required.2. Coordinate with domain project manager to resolves program issues quickly.3. Lead the China team to participate in analysis of business requirement, and development of functionalities as per SLIM.Work as team leader for developing project WW PODS1. Take part in deploying PODS phase 32. Lead the China team to participate in analysis of business requirement, and development of functionalities in PODS Phase 43. Apply software lifecycle integration methodology (SLIM) to define, plan, track and ensure the accomplishment of targeted goals

Shanghai City, China

Work at SGM (Onstar) as Senior data warehouse engineer1. Participate in construction of data warehouse in Onstar, and take responsibility for the partial design of logic model and whole design of physical model by ERWin. 2. Develop ETL system for the data mart Work at HP (ISAP, HPIT-GADSC) 1. Participated in DCC project, and was in charge by using PL/SQL script. Some of tables have more than one billion records. The PL/SQL scripts ensure atomicity of each synchronization batch. 2. Developed Informatica support suite successfully, which monitors and audits all Informatica servers of IPG via Ksh and workflow. For example, restart pmserver/pmrepserver service, integrate Informatica running logs etc. 3. Succeeded in switching schedule of 800+ Informatica workflows to TIDAL 4. Developed one package to maintain table partitions of Oracle 10g, like drop and add table partition 5. Be responsible for developing one package which purges historical records in the fact and dimension tables automatically

Master Of Computer Science, Computer Science And Technology

Bachelor'S Degree, Computer Networking