ETL: KettleBI: FinereportData Warehouse : Oracle▪︎Responsible for data analysis, data crawler, and visualization report construction.▪︎The entire ETL process built of data from the business system to the data warehouse .▪︎Data integration, aggregation and cleaning, data warehouse construction.▪︎Combine business, communicate closely with business departments, and propose feasible analysis plans for different departments like Inventory, Sales, Members, etc.▪︎Finreport Linux system environment built, and Crontab created for automatic monitoring, operation and maintenance.▪︎Manage suppliers, be responsible for the docking of BI suppliers, contract management, price negotiation, etc.

ETL: TalendBI: Crystal Report, QlikviewData Warehouse : Oracle▪︎Responsible for the construction of the data warehouse of the RI reinsurance module of the insurance industry and the support of other modules.▪︎RI's JSON source data conversion, the association between tables, the combination of different dimensions.▪︎Use Talend to transfer data from business system database ETL to data warehouse, and aggregation▪︎Reporting demand analysis, Also create Crystal Visualization reports .▪︎Improve the structure model of the data warehouse.

Help friend's for their company's data develop and analyze.▪︎Build the entire ETL process with Kettle▪︎Build a data warehouse in Postgres▪︎ Assist in the development of Visualization reports on Qlikview

Onsite in eBay China Data Solution Services Team.ETL: Ab InitioBI: TableauSchedule: UC4Data Warehouse & Big Data : Teradata, Oracle, Mysql, SQL Server, Hadoop▪︎Using the ETL tool Ab initio as the framework to build the ETL process on Linux. Data source comes from eBay’s database of different business channels.▪︎Use Shell, Sql, Python, Hive, etc. Schedule and process billions of data on multiple system platforms, such as Teradata and Hadoop and combine all data in data warehouse and analysis.▪︎Data analysis of multiple related modules such as MyeBay, Daily Deals, Blacklist, etc on user behaviour and items by using Tableau display.

ETL: Cransoft, InformaticaBI: CognosData Warehouse :SQL Server▪︎Responsible for data migration, and discuss business logic with users from old system and new system.▪︎Use Cransoft to ETL the data, clean and transform it into data which can be imported into SAP directly, including MM, SD, FI module.▪︎Use Cognos to make Visualization reports to display data