Payments reports automation

DellEBIA Java program which processes data from Dell(about 3~6GB zipped flat data perday).It gets data from FTP and copies data to Hadoop, does some data cleaning and transformations on Hadoop, then loads data to SQL Server for further analysis. It uses frameworkes Apache Camel and Hadoop Casacading. It also uses other common frameworkes for Java programming such as Spring,Maven, Quartz, Log4j and TestNG. HIVE TestingWe are considering migrating our data to hadoop/HIVE. I did some evaluations on them.ReportsCreated multiple reports to maintain our jobs, log shipping, backups, capacity and so on. Some of them provide data to people who want to understand our data better. All the reports are automated using SQL Agent, SSIS, SSRS or JAMS.Daily managements for 200+ SQL Server boxes using Litespeed, Idera, JAMS or other tools. Including: Installing and upgrading the database servers and application tools. Modifying database structure, as necessary, from information given by application developers. Enrolling users and maintaining system security. Monitoring and optimizing the performance of the database.

Portfolio ControllerA Java program to control portfolio data loading. This component controls a ETL tool to load portfolio data into search engine automatically.Portfolio EFDA java program distributes the output of ETL tool to each destination.Portfolio Behavior-Driven Development TestingA java program has been integrated into portfolio Continues Delivery process to guarantee the quality of CD.Continues Delivery of portfolioWorking on Jenkins to deploy portfolio components to each env automatically.Continues Integration of portfolioMaintaining daily build/weekly builds on Jenkins for each portfolio components.Search UsageA BI project which analysis search engine usage using BI components from Microsoft, like SSAS, SSIS etc.This tool analyzes the response of users when they get search results. From their reactions, estimating if they find the results they are looking for. Then improve the quality of search engine.Portfolio Content LoaderA ETL project made from Ab Initio

Database development of a social network software both on website and mobile.I was in charge of database design and all the code of database.

Maintain UC (a kind of instant messenger) databases

Oracle Database Engineer