Chung In Ngan Email & Phone Number

Proactive and result-oriented individual looking for a career transition from marketing to data analytics, backed by three years of experience in the marketing industry. Completed the UC Berkeley Data Analytics and visualization Bootcamp, gaining expertise in data manipulation, statistical analysis, and data visualization. Skilled in extracting meaningful insights from large datasets to inform business strategies and optimize performance.--------------------------------------------------------------------------------------------------------Data Analytics & Visualization- Performed ETL on several movie datasets to predict popular films for a streaming service. Created an ETL pipeline from raw data to SQL database, extracted data from disparate sources using Python and Clean, and transformed data using Pandas. Used regular expressions to parse data and to transform text into numbers.- Extracted data to create an employee table list through SQL query analysis using statements including JOINs, aggregate functions, and more to filter through a company’s employee database based on criteria provided like work years, job levels, or job functions.- Analyzed ride-sharing data to develop a visualized graph report using Python, Pandas, and Matplotlib to showcase the data distribution and relationship between rides, drivers, locations, and fares. Based on the result, recommended increasing drivers in rural areas by 33% to make rides more affordable, and driving more marketing to increase riders to match the excess of drivers in urban areas.- Generated Tableau worksheets, dashboards, and stories by integrating with New York City’s bike-sharing data to identify profile insights, and determine peak rental routes, bike utilization rates, and bikes due for repair. Provided operational recommendations for optimal bike placements to maximize usage rate by location or time periods, as well as marketing and business strategies for promoting directly to end customers and investors.- Developed an interactive solar energy cost analysis webpage that used ongoing weather data API with machine learning to forecast the breakeven cost for installing rooftop solar panels on customers’ homes, based on sun intensity by zip code, current electricity usage, and electricity cost.

Listed skills include Multi Channel Marketing, Customer Acquisition, Google Analytics, Market Planning, and 17 others.