Jayne Xing

WORK HISTORY

EDUCATION

ABOUT JAYNE XING

I\'m a data engineer & BI developer at U Conn School of Nursing right now. I\'m working on a project for State of Connecticut about healthcare claims data gathered from healthcare plan providers, I deliver dynamic ETL processes with Pyspark and SQL through Databricks and MS SQL server. I am a reliable individual and team player. I completed my undergraduate degree in Financial Mathematics in Hong Kong before the study and work in the U.S. My expertise lies mainly within the realms of SQL develops, data analysis, marketing analysis, statistics and I\'m familiar with Healthcare and Bank industry. I am enthusiastic in the data analysis in social network analysis too, because of my last job at Teradata Corp. I used Python and SQL developed a program that is able to automatically gather and summarize data to analyze, visualize and predict important information of VIP customers. Part of my responsibilities included extracting customer data from Teradata database, designing and building loan customer relationship database and transaction route database, finding potential risks with some customer\'s behaviors, visualize data with Tableau and Gephi. I care about the detail, critical thinking, ask questions and can study new things very quickly as need. SKILLS SUMMARY:Over two years of professional experience in ETL, Database Management, Statistical modeling, Machine Learning, Data Visualization and Reporting solutions in a variety of industries.Progressive experience in Tableau Desktop/Public for business analysis, delivering customized ad-hoc reports and performing actionable dashboards for enterprise applicationsExcellent understanding of designing and developing T-SQL queries, DDL, DML and ETL packages. Demonstrated experience in using Microsoft SQL Server (2012/2017)and writing Queries, Stored Procedures, CTE, Triggers and Transactions; Deep understanding of Star/Snowflakes Schema of data warehouse.Expert in Python Jupyter notebook and Databricks and its libraries like Pandas, Spark, NumPy, Matplotlib, Networkx and Scikit-Learn.