Automate and optimize ELT pipelines and workflows, and perform data analysis using SQL and Python in Databricks. Visualize insights in Tableau. Make actionable recommendations to stakeholders.

• Database Analysis: Snowflake, BigQuery, Databricks, Azure SQL, Oracle, MS SQL Server• Reporting & Dashboard: Tableau, Power BI, Looker• Programming: Python• Data Engineering: Azure Data Factory, DBT, Python• Digital Marketing: Google Analytics, Adobe Analytics, Google Campaign Manager, DoubleClick Search, Adwords, Facebook Ads. Optimize

• Managed the whole project cycle from data preparation and stewardship, analytics, visualization, presentation and reporting. • Gathered requirements from customers, pulled data from various sources including external servers using SAS and Shell, or existing databases and tables in Hadoop. • Discovered insights behind over billions of consumer records, visualized result on Tableau, presented findings using PowerPoint and Visio, and provided appropriate suggestions to customers, including sales, marketing executives and modelers.• Conducted multiple regression analysis within R and analyze what and how the variables impact coverage ratio.• Optimized queries written by teammates, reduced the running time and space usage on server. • Monitored consumer credit data quality. Created trend reports to examine the quality or outliers of new data set.• Analyzed the incremental value of new vendors and potential impacts to the existing data assets.