• Developed SQL Server Integration Services data flow to ingest data from various sources and process data of various format (flat-file/CSV/XML/JSON)• Developed and designed a monthly non-paid disconnect (DNP) report by using Power BI for the revenue protection team, which was used to determine the income account and prevented more than 2 million income losses• Participated in the development of standard job tracking routines to populate user activity tables. Write reports on the table schema for tracking and monitoring• Review and troubleshoot complex SQL queries to query more than 20 reports related to utilities and natural gas, including accounts receivable aging report, non-standard meter (NSM), discount 175 and switch retention report, etc.

• Designed an independent system database structure using SQL which makes the sales situation in the store accurately controlled, and increases the efficiency of data entry and retrieval by 30%• Established regression models analyzed the relationship between other independents and sales, adjusted the supermarket’s goods and sales methods increased the supermarket sales by 18% in 2017