Experience

China Unicom

• Telecommunications
• 700 & Above Employee

• data analysis specialist

  • Aug 2013 - Present

  1.Customer information maintenance. Created database storing information of up to 1 million customers, with their basic profile, user account and device status information, etc. and created corresponding tables and transition models in the Database for easy access.2.Data processing automation. Developed tools using python to automatically process raw data with up to tens of Giga bytes to have desirable output, and further customized such tools for various use cases, such as for multi-dimensional weekly report, monthly report, etc. Such tools greatly boost the work efficiency.3.Database migration from Access to MySQL. Fixed data redundancy and optimized tables of target databases. Show less

• Product manager

  • Jul 2011 - Jul 2013

  1.Integrate information of each phase of business customers into separate tables of a database and setup their connections, phases from the very beginning of contract signing, construction, account registration all the way to their end of the contract.2.Analyzed the data of the absent customers, verified the positive correlation hypothesis of their present period of time and their deconstruction.3.Cluster analyzed the customers' behavior and customized contract policies to strengthen their consistencies. Show less