Data Analyst Python

Hao Ling

************@*****.*** 334-***-**** linkedin.com/in/hao-ling

SUMMARY

Dedicated and statistical think analyst with acute technical acumen and multi-modal communication skills. Excellent understanding of KPI analysis, customer insight and data migration of large data sets. Self-starter with excellent sense of probability and out-of-the-box thinking.

SKILLS

Programming Language: SQL, Python, R, MATLAB

Analytics Tools: Power BI, Tableau, SAP Business Objects, Microsoft Excel (Pivot table, Macros, VBA) Platforms: Microsoft SQL Server, Oracle, DB2, Teradata, AWS, SAP HANA, MySQL, Spark WORK EXPERIENCE

Joblogic-X Corporation Dallas, TX

Data Analyst Sep. 2019-present

• Participated in physical model design and developed stored procedures to populate the data warehouse in RDBMS and stored procedures using SQL server 2019. Created dashboard by using Power BI to present the customer purchase behavior correlation with price along with the time window during the day.

• Analyzed customer behavior by tracking the historical trend and proposed dynamic pricing strategy for time window to optimize the overall revenue. Implemented auto payment for accounts with lower balance that unlocked a significant increase in business revenue( $1.3+ MM).

• Developed ETL data flows and data cleaning pipelines to ingest data under heavy workload from various sources using SSIS combined with Python programs. Developed customized quality control routine using python to ensure data accuracy, integrity, and consistency, improved the SLA meet ratio by 80% and improved the data accuracy by 20%.

• Involved in Inventory Data Analysis Using Python Project.

• Leveraged Python to extract shipment tracking information from invoices/label scan image data. Built data loading process from these image data to automatically update the inventory database.

• Used Python to extract weekly and monthly inventory data from SQL Server Data Warehouse. Applied time series analysis method to analyze the trend in inventory. Predicted weekly inventory of each product from each supplier and reported the forecasting low inventory level weeks and months to ensure a high service level.

• Collated suppliers’ information through various sources. Checked information and explored new suppliers to update the database. Reached out to suppliers directly if information was not clear and sought opportunities to develop longterm cooperation. Southern Methodist University Dallas, TX

Data analyst Jan. 2018- Aug. 2019

• Compiled, recorded and maintained the lab experiment result dataflow on a daily basis in SSDT and report the final result with experimental requirement in Tableau.

• Implemented an application in SQL server to keep track of the chemical inventory and record laboratory check-in/check-out activities to improve the previous manual process.

• Utilized histogram and additional visualizations to demonstrate the trend as well as the distribution of predicted loss rate. HY Oil & Gas Hunan, China

Marketing Data Analyst Jan. 2017-Jan. 2018

• Established stochastic models in Python to predict 5 quarter's trend based on local gas prices appreciation history, purchase history, historical mortgage rate and unemployment rate data set from the past 5 years.

• Researched a vast amount of fundamental data. Reviewed, prioritized and analyzed market data and information by using SQL and Python to produce in-depth quantitative and qualitative reports.

• Designed and implemented sophisticated, reusable generic modules to export data to various formats including HTML, PDF, CSV using MSSQL and other tools.

EDUCATION

Southern Methodist University Dallas, TX

Master, Environmental Engineering Jan. 2018-Aug. 2019 Central South University of Forestry and Technology Changsha, China Bachelor, Engineering Management Sept. 2013-Aug. 2017

Contact this candidate