YANLAN LIANG

Piscataway, NJ ***** Email: adxob9@r.postjobfree.com Cell:732-***-****

SUMMARY & OBJECTIVES

• Skilled at building ETL solutions on large datasets using Snowflake, AWS S3, and Tableau.

• Individually created multiple automation solutions to help the team accelerate working efficiency.

• 2+ years’ work experience in data-focus roles in multiple industries, such as Computers and Electronics, Financial Services, and Software Development.

• Seeking job position of data analyst, market analyst, or business analyst PROFESSIONAL EXPERIENCES

Data Analyst II, Jul 2021 – Jun 2023

ZoomInfo - Waltham, MA

• Processed, manipulated 10M+ dataset independently, utilizing Excel, Snowflake, Databricks, and AWS.

• Designed and executed 400+ SQL queries and Generated 3,000+ files based on criteria.

• Developed 5+ analytics dashboards and implemented 1000+ customized analytics reports, enabling clients to gain valuable insights.

• Developed over 30 automation solutions using Pyspark to significantly enhance data delivery efficiency, resulting in an 80% reduction in man-hours required (from 5 days to 1 day).

• Collaborated with the sales team to help translate the business problems into data-driven solutions and worked closely with the Research team to ensure data integrity.

• Led a team of 5 internal Data Services teammates to generate training documents, oversaw training of Data Analyst I, and participated in the interview process for new data analysts. Economic Research Assistant, Apr 2021 – Jun 2021

Haver Analytics – New York, NY

• Managed macroeconomic and financial time series data from 100+ types of various financial institutions.

• Implemented streamlined processes for collecting, transferring, and loading data into proprietary databases.

• Conducted statistical analysis to seasonally adjusted data and ensure data quality and accuracy. Software Quality Assurance Engineer, Mar 2021 – Jun 2021 OnePlus – Bedminster, NJ

• Maintained and executed 40+ automated test scripts, analyzing their outcomes, and making necessary modifications.

• Conducted 100+ testing for new applications and existing products, diagnosing problems.

• Documented defects in a clear and detailed manner, providing steps to reproduce actual and expected results for the engineering team.

TECHNICAL SKILLS

• Programming Skills: SQL, Python, PySpark, AWS S3, Tableau, MS Excel, R, MS Access, C++

• Language Skills: Fluent in English, Cantonese, and Mandarin; Intermediate level in Korean. EDUCATION

Rutgers Business School, Rutgers University Sep 2019 - Dec 2020 Newark, NJ

M.S. in Information Technology Analytic

GPA 4.00/4.00, Top 5%

Rutgers Business School, Rutgers University Sep 2015 - May 2019 New Brunswick, NJ

B.S. in Business Analytics and Information Technology

GPA 3.603/4.00, Cum Laude

Contact this candidate