Telecom Billing Systems are high end,reliable and expensive softwares and provide various functionalities including applying required usage and rental charges and finally generating invoices for the customers. Telecom Billing process also includes receiving and recording payment from the customers. The Billing System should be composed of a series of independent applications. After a call is made, the system gathers usage data from the network switch and build a call detail record that is stored until it can be rated. The rated information is stored until the invoice is run. When the invoice is run, other monthly fee can be applied to the bill. The whole business processing is implemented by Stored Procedure or PL/SQL blocks and C++/Java Code
2008-7-1This project is a business intelligence system which breaks in BSS business case for Ericsson. It is used by the Telecom Operators of China, using data processing techniques to solve the problems of preventing revenue loss and standard income security processes. The web part implementation utilizes SpringMVC framework and the runtime part is able to schedule 100+ ETL jobs on top of architecture of Oracle. My responsibility is performing a multitude of functions to deal with the data from BSS data sources by Kettle engine tool.
This project is able to remotely manage a connected device. The system achieved Business Intelligence on used devices. The Bi Platform supports to query latest terminal information like capabilities, attributes, realize structured data using various views to export using several formats based Birt tool and offer a specific graphics engine based on JFreeChart which allows to develop single ready-to-use graphical widgets.
CMCC(China Mobile Communication Corporation) IPM(Integrated Performance Management) project aims to deliver a fully functional, integrated platform for CMCC to support the operation performance management area across Mainland China. The platform focus on massive data collection, transforming, storage and sharing and provides Big Data solution to build full-featured, excellent performance system to customers. The generic data flow is from the data which can be collected from BSS analysis system, processing by ETL tools, parsing and computing in Steam Engine and eventually importing into MPP database. Pivotal Hawq has been chosen for handling the massive data storage, computing and query relevant data.
2013-3-1Designed and implemented an interface called VIMGW that provides convertor between CMCC c7 interface and ECEE/Zabbix, support physical/virtual resource status monitoring task from NFVO(a platform from CMCC) to fulfill the ECEE gap in CMCC specific resource management workflow. This interface is able to collect physical/virtual resource PM counter from Zabbix and report to NFVO, also sending response alarm to NFVO. This interface is implemented by Jersey framework. The virtual data resource stored in the openStack platform of ECEE can be transformed into the Zabbix by the python ZabbixCeilometer procedure.
2014-5-1Florida Public Hurricane Losses Model is supported by the Florida government using data processing methods (designed and implemented database schemas and stored procedures to store and manipulate large insurance datasets) to process the policy data from insurance companies to predict the possible losses. This model implementation is a collection of programs and scripts mostly in Java, C++ and shell scripts.
2014-9-1Behavioral Risk Factor Analysis System(BRFAS) is a web application that would help data analysts to analyze the people’s health conditions. The system is combined with database management system, data mining and machine learning techniques, and shown the result with web pages. It is a web application that ensures users to manipulate the data with baked- in Weka of the website, based on the annual survey data from the Behavioral Risk Factor Surveillance System (BRFSS), users can train the data, build machine learning models, also generate their own health condition survey questions. BRFAS can be regraded as a survey system as well. The default survey is about Heart Attack.
2016-04-18Worked with a geoportal which is a gateway to Web-based geospatial resources. Data providers can use the geoportal to make their geospatial resources discoverable, viewable, and accessible to others. The user interface of the geoportal utilizes the JavaServer Faces (JSF) framework. Requests from website pages are processed by Faces and routed to the appropriate geoportal controller for execution. Customized the user interface on JSF framwork according to the user requirement and implemented the web page to make an ajax call from jQuery to access resources through the geoportal’s REST api.
2016-10-1