NGAN LE (CRYSTAL)

857-***-**** adiolb@r.postjobfree.com https://github.com/thithainganle linkedin.com/in/thithainganle/ Problem solver who helps companies improve their business processes and services with communication and analytical skills. 2+ years of experience in business intelligence & reporting, project management. Skilled in modeling, forecasting. SKILLS

Programming Language R (dplyr, tidyverse, ggrepel) Python(Matplotlib, Pandas, Numpy) Database SQL (ETL, JOIN, Subqueries, Stored Procedure) SQL Server Access Data Visualization/ BI QGIS ArcMap Tableau Qlik Power BI Advanced Excel Statistical Modeling Hypothesis Testing Regression Clustering Classification Time Series Others SalesForce Zendesk Visio Jira Jupiter Notebook Git Markdown WORK EXPERIENCE

App Store Optimization (ASO) Specialist Intern Oct 2020 – Present Alpha Math Education Inc Dallas, TX, USA

• Gathers data on SensorTower, MobileAction; conducts analysis for higher ranking in the app store’s search results.

• Builds and maintains the ASO dashboard in PowerBI, communicates results to senior executives for decision making.

• Develops measurement and reporting frameworks for ASO campaign performance. Market Research Analyst Intern July 2020 – Oct 2020 Digital-PI Belmont, MA, USA

• Plans a penetration strategy to reach the US SaaS market by gathering, analyzing data from public sources.

• Performed research on potential customers, proposed a list of 100 target clients. Project & Data Analyst Jun 2016 – June 2018

Lazada Vietnam (leading Southeast Asian E-commerce Platform) Ho Chi Minh, Vietnam

• Developed daily SLA-tracking dashboards to cross-functional teams in Power BI and SQL.

• Created analysis, SQL queries (ETL) requested for optimization opportunities, slashing 50% delivery lead time.

• Launched end-to-end express delivery project. Volume reached 100 orders/day with a roughly 90% delivery rate.

• Led an outsourcing team of 3, trained the team to clear operation backlog on Salesforce, handle 3 projects.

• Collaborated with operations teams on performance metrics, SOPs, logics for reports. Customer Relationship Intern Aug 2015 – Nov 2015

Saigon Join Stock Commercial Bank (SCB) Ho Chi Minh, Vietnam

• Identified sales opportunities and presented the products to the customers. Dealt 10% out of total reach.

• Initiated warm calls leading to in-person meetings to convey value of the product tailored to each customers’ needs.

• Worked with sales management to execute campaigns with retail & automobile companies. ACADEMIC PROJECTS

Enhancing Marketing ads Campaign on Facebook (Power BI, R) April – June 2020

• Identified the best keywords to gain organic views, clicks by analyzing the dataset of 700k+ records in PowerBI.

• Utilized R to perform data cleaning, Linear Regression model to find the most influencing factors on the impressions. Sales Forecast using Time Series (R, Tableau)

• Predicted sales, suggested the sales plans of medical devices in the EU based on the analysis of 600k+ observations in R, compared methods (mean, naive, drift, seasonal naive, ARIMA) find the best fit. Hospital’s Bed Categories Data Warehousing (MySQL) Sep – Nov 2019

• Designed Star schema with fact and dimension tables based on the business requirements. (3x53k+ records)

• Applied ETL to compare the bed types, categories, number of ISCU beds among hospitals. Visualization of Traffic Accidents (Qlik) June – Aug 2019

• Developed an interactive dashboard in Qlik that figured the patterns of traffic crashes by time, suggested the safe time to drive in Cambridge, MA.

EDUCATION

MS in Analytics, Northeastern University, Boston, MA (GPA 3.9/4.0) Jan 2019 – June 2020 BA in Finance, Industrial University of Ho Chi Minh City, Vietnam (GPA 3.1/4.0) Sep 2012 – June 2016