Guojun (Juno) Wang

* ******* *******, ******, ** 02148 781-***-**** adkblj@r.postjobfree.com

SUMMARY

A resourceful and avid learner with excellent collaborative skills. Experienced in Data warehousing, Database Management, ETL development, and Business Intelligence. I have worked with diverse groups delivering value to the business. Through these experiences, I have actively communicated with stakeholders to build and maintain cross-functional relationships. WORK EXPERIENCE

Data Engineer June.2019 – Dec.2019

Wayfair Boston MA

I was responsible for delivering analytical tools and quantitative analysis to Wayfair's marketing teams focused on brand development and new customer prospecting

• Collected and organized TB level data by SQL, built and maintained a reliable, scalable data warehouse for group of 100+ business stakeholders across various channels within marketing department, empower business stakeholders with relevant data and business-critical KPI

• Designed and monitored a variety of ETL procedures and data pipelines among Hive and Vertica using SQL and Python to collect and process log data from multiple sources for Online Video team, saved OV team 2-3 hours daily on data uploading and troubleshooting

• Designed and built reliable data pipelines, data models and integrity checks for data warehouse upgrade and transition, involved in migration cloud platform data migration (Vertica to GCP)

• Work collaboratively with both internal teams and external partners to to generate analytics metrics, optimize ETL process, and develop new features within Wayfair’s BI platform Data • Engineer Providing data-driven analysis and recommendations using R and Tableau for more involved ad-hoc business Jun 2017 reports – Jun 2018 Zhongtai • Developed Securities Co.optimized, Ltd. data models to populate Tableau dashboards for over millions of customers Beijing China

• Building data pipelines to move data across different servers to meet business needs

• Designed data visualized reports web pages based on result data using JavaScript at BI platform, adding animation effects to

• line Ensuring charts data and availability pie charts to stakeholders 100% of time to keep the business growing EDUCATION

Master of Data Analytics Engineering Dec, 2020

Northeastern University GPA: 3.73/4.0 Boston, MA

Bachelor of Industrial Engineering Jun, 2015

Shandong University of Technology Shandong, China

TECHNICAL PROFICIENCIES

• BI Tools: Power BI, Excel (Pivot table, V-lookup, Macros), Tableau (Tableau Desktop Specialist Certification),Looker

• Programming Languages: Java, Python, SQL, HTML/CSS, JavaScript, Scala

• Databases Technologies: MS SQL, Vertica, MySQL, PostgreSQL, Hadoop, Hive, Spark, GCP, AWS PROJECTS

JavaScript-Based Full Stack Social Network App June.2019 – Dec.2019

• Utilized Bootstrap to create a responsive, interactive front-end including landing, main, and profile pages

• Implemented a light weight back-end using with Node.js and Express.js, and used MongoDB to manage user data, using Mongoose APIs to CRUD the NoSQL database in server

• Designed RESTful APIs to handle HTTP requests under Express.js framework, implementing user authentication, authorization, request body parses, and exporting RESTful routes modules Nursing Home Compare Data Warehouse Design and Implementation Jan 2019 – Apr 2019

• Preprocessed millions of data related to nationwide nursing homes from multiple data sources by Python and R.

• Built data pipeline involving ETL process, data integration process, SCD process and implemented error handling procedure to enhance data consistency

• Built data warehouse and connected to cube using SSIS and SSAS and designed interactive and auto-update Tableau dashboards to empower self-served users to compare and analyze quality, ratings, locations and other features of nursing homes across the United States.

Contact this candidate