Data Analyst Python

Lutian (Jimmy) Gong

216-***-**** New York, NY *****.******@*****.*** linkedin.com/in/lutiangong Education

Columbia University New York, NY

M.S. in Applied Analytics, GPA: 3.97/4.00, GMAT: 720 (Top 94%) Sept. 2018-Dec. 2019

● Relevant Courses: Machine Learning, Data Types and Data Structures, R for Data Modeling, Storytelling with Data, Python for Data Analysis, Strategy and Analytics, Database Architecture, SQL and Database Design, Analytics and Leading Change Case Western Reserve University Cleveland, OH

B.S. in Finance, B.A. in Political Science, Minor in Economics, GPA:3.45/4.00 Aug. 2014-May 2018

● Relevant Courses: Applied Financial Analytics, Financial Modeling, Game Theory, International Relations Skills

Tools: Data Analysis (R, Python), Database (PostgreSQL, MongoDB), Visualization (Tableau, Power BI), Microsoft Suite & Azure Technical Analysis: Financial Modeling, Clustering, Classification, Time Series Analysis, Web Scraping, Database Management Certification: Advanced Google Analytics, Professional Scrum Master I Working Experience

United Nations, DPO IMU New York, NY

Information Management Data Analysis Intern Jul. 2020-Present

• Perform geospatial analysis and update automated visuals (Power BI) based on requests and new findings to advise Secretary General and Executive Office and to support operation of peacekeeping missions.

• Develop metrics on COVID-19 data in mission countries to provide a multidimensional perspective on COVID activities monitoring and response improvement.

• Apply NLP machine learning techniques to process the abundant qualitative data within UN to generate quick summaries and immediate insights through APIs and thus improve overall efficiency in terms of information flow and decision making. Peltast Partners Chicago, IL

Data Analyst Intern Jul. 2018-Sept.2018

● Identified over $800K in supply chain cost reduction opportunities by processing and analyzing raw data from historical U.S. Steel Imports Trade records in the past 10 years with complex SQL queries.

● Refined manufacturer switching strategy by creating visualizations and geographical heat map using Tableau.

● Delivered key recommendations that were integrated into the final deliverable directly to the Product Manager by evaluating steel product market opportunities in 5 growth markets with in-depth analysis and reports. Zhe Shang Venture Capital Hangzhou, China

M&A Research Analyst Intern Jun. 2016-Aug. 2016

● Assessed over $1.2 million revenue and cost synergies in acquiring domestic digital health startups for clients by performing financial modeling, conducting research/expert calls and crafting multiple healthcare customer engagement strategies.

● Classified High, Medium and Low target companies for portfolio review by creating and implementing multi-factor model. Projects Experience

R & Tableau, Sample Quality Modeling and Prediction, Formosa Plastics Corp USA New York, NY Project Focus: Project Management, Business Reporting, Client Engagement, Data Science Application Sept.-Dec.2019

● Located $160 million revenue boost opportunity by automating the Melt Index testing process in polypropylene resin production.

● Predicted the Melt Index with 99 % accuracy 0.5 error) by developing a two-step model solution with GBM and ARIMA.

● Managed the end-to-end work flow by initiating, planning, executing, adjusting, and completing the work to achieve success criteria (80% accuracy) requested by clients and constructed a series of deliverable including presentation, visuals and SOPs. PostgreSQL & Python, Medicare Physician File Database Design New York, NY Project Focus: Normalization, ETL, Visualization, Interactive Dashboard, Data Analysis Oct.-Dec. 2019

● Extracted and transformed unstructured data with 1 million observations and 64 variables in Python and loaded them into PgAdmin where new data could be stored properly and automatically, reducing data redundancy and improving data integrity.

● Implemented insightful analysis from direct queries to showcase the potential benefits of established database.

● Built visualizations and interactive dashboards to provide a high-level strategic overview for C-suite audiences. 2019 Columbia Mailman School of Public Health Case Competition (4th among 13 teams) New York, NY Project Focus: Healthcare, Merger & Acquisition, Revenue Generation, Cost Reduction, synergies projection Nov. 2019 R, Airbnb Rental Pricing Prediction, Kaggle Competition New York, NY Ranked top 10% among 350+ participants Oct.-Dec. 2018

● Predicted the prices of Airbnb rentals using machine learning algorithms, such as Linear Regression and Random Forest.

● Applied feature selection techniques, Hybrid Stepwise and Lasso, to identify relevant predictors among 96 variables. Leadership Experience

Columbia Analytics Consulting Group, Columbia University New York, NY VP of Finance (elected by outgoing leadership) Dec. 2018-2019

● Managed $6K budget on club expenditures such as workshops, casebooks and joint career panels.

● Initiated 8 career panels with consulting professionals from top firms in the Greater New York area to provide over 600 students with industry insights and insider tips for recruitment.

Contact this candidate