XIAOQING LENG

781-***-**** Greater Boston Area ad2w51@r.postjobfree.com

EDUCATION

Northeastern University, Boston Master in Analytic Sep 21 – Dec 23 University of Connecticut, Storrs Bachelor, Biomedical Engineering Concentration Sep 15 – Dec 20 TECHNICAL SKILLS

Programming Language: Python (Jupyter Notebook, PyCharm), R, SQL, MATLAB Data Analytical Tools: Excel (VBA, Power Query), Power BI, Tableau, SQL Server, Hadoop Methodologies: Machine Learning, Statistical Inference, A/B Testing, Hypothesis testing, Simulations, Regression Data Engineering: ETL, Data Extraction, Data Mining, Manipulation and Database Management PROFESSIONAL EXPERIENCE

The Commons XR Jan 23 – Jun 23

Full-Time Data Engineer Intern San Diego, CA

• Utilized advanced SQL skills to devise scripts, enhancing data loading speeds by 30% and streamlining the integration between NoSQL and SQL databases with Power BI for optimized data analytics.

• Leverage Power BI to design interactive visualization reports, collaborating with data scientists and the research team to present key insights weekly to the CEO and leadership teams.

• Employed data visualization tools to emphasize data accuracy and identify database discrepancies, leading collaborative efforts to develop a refined and more efficient database system.

• Collaborated with cross-functional DevOps and full-stack teams to design an efficient data structure, enabling direct data retrieval from the company's website, and embedding Power BI reports for wider stakeholder access. Yunnan Shengshi Di'an Biotechnology co., Ltd Feb 21 – Jun 21 Full-Time Data Analyst Intern China

• Employed advanced Excel techniques to conduct a comprehensive financial analysis for 20+ healthcare service providers, synthesizing insights for informed decision-making in areas like budgeting and financial strategy.

• Collaborated with the sales department to extract historical data, applying analytical tools to discern key determinants of product sales, such as marketing channels and pricing.

• Integrated inventory data to streamline supply chain processes, bolster data integrity, and reduce costs. PROJECT EXPERIENCE

Big Data Management for London Household Electricity Consumption Analysis Mar 23 – Jun 23

• Analyzed energy consumption from 5,567 London households using Databricks on Azure and Apache Impala, navigating data inconsistencies.

• Extracted actionable insights from complex, real-time data and emphasized feature correlations through multidimensional analysis, optimizing understanding of electricity consumption patterns. NLP Amazon Review Analysis Dec 22 – Feb 23

• Utilized LDA and text mining techniques to analyze over 12,000 Amazon customer reviews, uncovering hidden themes and topics to enhance customer service strategies.

• Conducted EDA on Amazon reviews, identified key positive categories, and provided tailored recommendations to enhance product categorization and offerings based on user insights. Risk Analysis for Loan Interest Rate Apr 22 – Jul 22

• Undertook comprehensive EDA using Python and applied the SMOTE technique to effectively handle data imbalances.

• Utilized Logistic Regression and Gradient Boosting models to analyze loan interest rate factors, achieving a 90.08% accuracy with Gradient Boosting and offering data-driven loan recommendations.

• Optimized supply chain efficiency by integrating inventory data, enhancing data reliability and cost-effectiveness. Toxic Release Inventory Analysis Feb 22 – Apr 22

• Leveraged R to conduct comprehensive data analysis on the Toxic Release Inventory, employing techniques like ANOVA and logistic regression to investigate regional and temporal variations in toxic emissions.

• Designed insightful visualizations with Tableau, effectively communicating key findings and recommendations on environmental issues through presentations.