Data Analyst Analytics

Rui Jiang

Long Island City, NY 812-***-**** ******@***.*** www.linkedin.com/in/ruijiang-wyf

EDUCATION

New York University, Tandon School of Engineering GPA 3.8/4.0 09/2022 – 09/2023

Master of Science in Applied Urban Science & Informatics New York

Relevant Coursework: Database Management, Data Analytics & Visualization, Machine learning and Deep Learning

Indiana University Bloomington, Kelley School of Business 08/2018 – 12/2021

Bachelor of Science in Business Bloomington

TECHNICAL SKILLS

Database: SQL, SQL Server, MS Access, MySQL Statistical Language: R, SAS

Programming Language: Python, MATLAB, Html BI Tools: Tableau, SAP, Microsoft Excel

PROFESSIONAL EXPERIENCE

INTELLIIPACT LLC New York City, NY

Data Analyst Assistant 09/2023– Present

•Devised a comprehensive outbound marketing strategy for a rapidly expanding nationwide auto sales company, leading to a significant increase in their sales and conversion rates by 6%.

•Constructed and managed a robust email system with over 200,000 records of marketing database, driving consistent growth and fostering deeper customer relationships.

•Conducted rigorous data cleaning and validation processes on over 450,000 records, ensuring the high integrity and reliability of marketing data, thereby minimizing errors in decision-making.

•Orchestrated A/B tests on diverse marketing tactics, such as email headers, content, and CTA placements, resulting in a 10% uplift in open rates and a 5% reduction in unsubscribe rates.

•Identified and resolved email delivered fail issues, enhancing the performance of email campaigns by 25% and bolstering user growth efforts.

•Utilized SQL, Tableau, and Excel for extensive marketing data analytics, providing the basis for data-driven decision-making processes, and influencing the marketing strategy that boosted overall customer acquisition by 30%.

•Assembled exhaustive reports and presented findings to clients and internal teams, directly aiding in refining customer outreach and acquisition strategies, leading to a 20% improvement in campaign effectiveness.

TENCENT Shenzhen, China

Business Analysis Intern 06/2021 – 07/2021

•Identified customer pain point of payment issue and web traffic by analyzing user reviews and applied sentiment analysis using excel, provided corresponding resolutiom to customer support framing, which reduced customer churn rate by 15%.

•Developed and validated ETL pipelines in python and mySQL to automate end to end data collection, validation, and reporting task. Resulted in 60% reduction in processiong time, enhancing 30% of operational efficiency.

•Implemented an automation system for generating daily sales operation reports using Python and advanced Excel techniques, enhancing 10% of sales forecasting accuracy and accessibility.

BYTEDANCE Beijing, China

Data Analysis Intern 06/2020 – 07/2020

•Generated strategy to increase sales 50% by identifying new market opportunities, assisting in the development and implementation of customer demographics data, growth metrics, KPI analysis, and targeting specific customers.

•Created automatic and multisource user dashboard and introduced new processes to marketer of 25+ to support data integrity, take human error out of the calculation process, and keep lead generated below 10 days.

•Designed and implemented a new, effective CRM system, improving customer sales pipeline accuracy by 20%.

•Improved 35% of product adoption by developing training resources, establishing support cadence, and creating continuous feedback loop with change management.

MACHINE LEARNING PROJECT

Analyzing the Scope of Police Surveillance in Brooklyn 05/2023

•Analyzed police surveillance in Brooklyn by processing 25.5 million records from various sources, using geospatial analysis to map camera coverage and identify surveillance hotspots.

•Developed a novel Kernel Density Estimation (KDE) methodology to quantify camera surveillance intensity, enhancing the understanding of surveillance distribution across neighborhoods.

•Engineered an interactive dashboard using Tableau and Python to dynamically visualize surveillance patterns, fostering community engagement and sparking informed discussions on privacy concerns and equitable surveillance practices.

INTERESTS

Interests: Table Tennis, K-pop, Piano, Calligraphy, Ballet, Traditional Chinese Dance, Real Estate Agent

Contact this candidate