Business Intelligence, SQL, Python

HUANCEN (HARRIS) LIU

*** ***** ****** #***, *** York, NY 10019 C: 585-***-**** ***********@*****.*** SUMMARY

Results-oriented Business Intelligence Analyst with over two years of experience in liaising between business and technical departments. Effectively translate and interpret business needs into technical requirements, along with analyzing the impact of changes as new solutions are introduced. Demonstrated ability to manage multi-functional teams to solve problems and address challenges.

SKILLS

Programming: expert in Python (numpy, pandas, folium), R Modeling: machine learning (regression, clustering),

(dplyr, ggplot2), PostgreSQL categorical data analysis, ANOVA analysis Data Visualization: Google Data Studio, Tableau Software and System: SAS, SPSS, advanced Excel WORK HISTORY

Senior Business Intelligence Analyst, 05/2015 to Current Fly Blade, Inc. – New York, NY

BLADE is the first digitally driven brand in short distance aviation and has revolutionized how travelers fly by offering individual seats or the opportunity to crowdsource flights.

Acting as a liaison between finance, operations, and technology stakeholders and communicating on project scope and objectives across the project.

Creates weekly business KPIs dashboard using SQL and Google Data Studio and offer recommendations using proforma P&L goals, ROI criteria, and Cost-benefit analysis that contribute 60 percent increase in revenue and 20 percent increase in gross margin.

Utilizes Mixpanel and Google Analytics to optimize the user experience by measuring customer behavior and apply data insights to improve the app experience.

Creates live user location heat map to identify new market opportunities and facilitate successful launch in LA market by using Python Folium package.

Performs pricing strategy analysis for new products and create customer segmentation using SQL. Using Python and Excel to create forecasting model and conduct financial analysis. Works closely with CEO and CFO to develop investor deck and documents for Series A Financing and participate Investor meetings.

Market Research Intern, 05/2013 to 09/2013

Second Avenue Learning – Rochester, NY

Second Avenue specializes in the development of interactive media for education. Created client segmentation using SQL and analyzed customer behavior that contributed 10 percent increase in retention rate. Performed competitive benchmarking analysis of the educational gaming market and researched potential online consumer channels by reviewing website demographics that contributed to the successful launch of the new product. Analytics Intern, 06/2012 to 09/2012

ClearMomentum, Inc. – Canandaigua, NY

A Financial Software Company that developed the first private equity portfolio management solution used to eliminate the non-value adding tasks associated with collecting, analyzing, reporting and distributing portfolio company data. Maintained and segmented client database utilizing SQL. Conducted analysis across multiple marketing channels such as email, paid search, banner ads, using Google Analytics. Developed KPIs dashboard for the marketing campaign and delivered actionable insights that helped improve sales by 20 percent.

Master of Science: Integrated Marketing- Analytics Concentration, May 2016 NEW YORK UNIVERSITY - New York, NY

Bachelor of Arts: Dual Majors in Business and Statistics, May 2014 UNIVERSITY OF ROCHESTER - Rochester, NY

EDUCATION

Contact this candidate