Qin Chen Email & Phone Number

Chengdu

Working as a data engineer/data analyst to build the next generation of data platform for ANZ and provide advanced data service to business for analytics. Working with business and architect to design solution for real business use cases(e.g. Responsible Banking; Financial Crime Data Hub); develop and implement them to production. Responsibilities: - Ingesting files from various source systems(core system, payments, fraud etc.) into big data platform via in-housed ETL framework; -… Show more Working as a data engineer/data analyst to build the next generation of data platform for ANZ and provide advanced data service to business for analytics. Working with business and architect to design solution for real business use cases(e.g. Responsible Banking; Financial Crime Data Hub); develop and implement them to production. Responsibilities: - Ingesting files from various source systems(core system, payments, fraud etc.) into big data platform via in-housed ETL framework; - Sqooping historical data from Teradata/Oracle database into big data platform; - Developing transformation tool to convert data per businesses' requirements; - Integrating with downstream systems for data virtualization on Qlik etc; - End-to-end testing support; - Change management, implementation and warranty support; - Production support; - Developing monitor tools for production environment by using Splunk etc. Primary Skills: - Big data skills like Hadoop; HDFS; Yarn; Hive; HBase; Hue; Impala; Flume; Sqoop - Spark (Java API; Pyspark; Scala; Spark-Streaming); - Kafka; - Java; - Python; - Scala; - Cloudera; - Zookeeper; - Teradata; - OracleResponsibilities:- Ingesting files from various source systems(core system, payments, fraud etc.) to into big data platform via in-housed ETL framework;- Sqooping historical data from Teradata/Oracle database into big data platform;- Developing transformation tool to convert data per businesses' requirements on Hadoop platform;- Integrating with downstream systems for data virtualization on Qlik or other tools;- End-to-end testing support;- Change management, implementation and warranty support;- Production support;- Developing monitor tools for production environment by using Splunk etc.Primary Skills:- Big data skills like Hadoop; HDFS; Yarn; Hive; Hbase; Hue; Impala; Flume; Sqoop- Spark (Java API; Pyspark; Sparkshell; Spark-Streaming);- Kafka;- Java;- Python;- Scala;- Cloudera;- Zookeeper;- Teradata;- Oracle Show less

Chengdu

TLM SMEWorked as technology support for TLM RP(Transaction Lifecycle Management – Reconciliation) in ANZ. Key role for some important projects such as: upgraded ANZ’s TLM version from 2.1 to 2.5.0.4; upgraded Oracle version from 11g to 12c; upgrade OS and WebShpere version to latest; moved system to cloud. Successfully deployed new products (Messaging Interface and Archival module) to ANZ system which will save business cost and improve performance… Show more TLM SMEWorked as technology support for TLM RP(Transaction Lifecycle Management – Reconciliation) in ANZ. Key role for some important projects such as: upgraded ANZ’s TLM version from 2.1 to 2.5.0.4; upgraded Oracle version from 11g to 12c; upgrade OS and WebShpere version to latest; moved system to cloud. Successfully deployed new products (Messaging Interface and Archival module) to ANZ system which will save business cost and improve performance significantly.Responsibilities:- Integration with upstream and downstream systems in 20+ countries; - Mapping feeds into TLM by converting files (via java program or shell script);- Transferring configurations from signed-off testing environment to production; - Trouble shooting and resolving technical issues by collaborating with multiple teams;- Creating automatic toolsPrimary Skills:- Familiar with Unix system/commands in Sun Solaris and IBM AIX; - Oracle PL/SQL and SQL tuning; - WebSphere configurations; - Java programming;- Shell scripting;- ServiceMix; - Karaf; - Control-M; - SDLC Show less

Chengdu

Working as vendor to help SRCU(Sichuan Rural Credit Union, the biggest local bank of Sichuan Province) to develop a full new core system (SC6000-z) on the mainframe platform, which including Front-end Systems, Control Systems and Core Intelligent Transaction Architecture (SOA). Responsibilities:- As a key member of Loan team, in charge of analyzing loan System and creating design specifications. - Analyzed new requirements and discussed service interfaces with users and service… Show more Working as vendor to help SRCU(Sichuan Rural Credit Union, the biggest local bank of Sichuan Province) to develop a full new core system (SC6000-z) on the mainframe platform, which including Front-end Systems, Control Systems and Core Intelligent Transaction Architecture (SOA). Responsibilities:- As a key member of Loan team, in charge of analyzing loan System and creating design specifications. - Analyzed new requirements and discussed service interfaces with users and service consumers.- Done some constructions in key function points.- Reviewed source code and unit testing results. - Fully involved in the testing phase(SIT, UAT, PnV, DRH). Played a key role in troubleshooting for all testing phases.- Fully involved in the data migration, in charge of analyzing data models, loading data to new system (from Linux platform to Mainframe platform) and building programs to verify data from technical and business perspectives.- Fully involved in the implementation, warranty support and quickly solving problems comes from production.- As Data Stewards of core-banking system to support the maintenance of data dictionary.Primary Skills:- Familiar with Mainframe system; - Professional on Mainframe skills such as COBOL, CICS, JCL, DB2, REXX and various tools.- Good at Linux system/commands and C programming.- Solid banking domain knowledge, e.g Deposit, Loan, Accounting; Payments. Show less

Chengdu/Singapore

CPF P+I project/CPF Withdrawal & Retirement Maintenance/CPF LIFE MaintenanceSystem enhancement involving multiple sub-systems across the provident funds board due to policy changes.Responsibility:- In charge of analyzing the changes’ impact and applying the enhancements according to the requirements.- Create design specifications and delivery to ODC team. Review test results and delivered program source. Doing some constructions in key modules.- Responsible for the… Show more CPF P+I project/CPF Withdrawal & Retirement Maintenance/CPF LIFE MaintenanceSystem enhancement involving multiple sub-systems across the provident funds board due to policy changes.Responsibility:- In charge of analyzing the changes’ impact and applying the enhancements according to the requirements.- Create design specifications and delivery to ODC team. Review test results and delivered program source. Doing some constructions in key modules.- Responsible for the full SDLC from analysis, construction, testing (SIT, UAT) and implementation. Show less