Post Job Free
Sign in

Data Analyst

Location:
New York City, NY
Posted:
December 02, 2019

Contact this candidate

Resume:

EDUCATION

Columbia University Graduate School of Arts and Sciences New York, NY

M.A. in Statistics Sep 2017 – Feb 2019

Selected Coursework: Regression, Time Series Analysis, Advanced Data Analysis, Applied Data Science

Purdue University West Lafayette, IN

B.S. in Industrial Engineering, B.S. in Mathematics, B.S. in Statistics Aug 2013 – May 2017

GPA: Cumulative: 3.6/4.0 Major: 3.7/4.0 Dean’s List, Semester Honors, Alpha Pi Mu (Top 20% in Industrial Engineering)

GRE Quantitative: 168/170 (Top 5%)

PROFESSIONAL EXPERIENCE

Innovation Booster New York, NY

Data Science Consultant Intern – Top decile performer Feb 2019 – May 2019

Extracted data from Google BigQuery using SQL query, analyzed high-end soaps industry, and designed A/B tests to provide market entry recommendations for a Fortune 500 CPG client

Partnered with experts and internal managers (R&D, innovation, supply chain) to design new high-end soaps

Developed growth strategy framework for a global Fortune 500 pharmaceutical company by assessing the client’s marketing capabilities; formulated go-to-market strategies, and developed appropriate KPIs and A/B tests to evaluate relevant hypotheses on several mobile applications, using Agile/Scrum processes

Informed business executives about the potential to leverage opportunities through analytics insights

Owned marketing metrics (CPA, CAC, LTV, ROI); prepared marketing performance reports and data visualizations using Tableau to summarize key findings and conclusions of the market entry case, which ultimately led to another project with the same client

PricewaterhouseCoopers (PwC) Jakarta, Indonesia

Deals Strategy Advisory Intern (Deals Analytics Team) – Top decile performer Jun 2018 – Aug 2018

Select Experience: Data Due Diligence for U.S. $1 billion acquisition of Indonesian Financial Technology company

Assessed data cleanliness by verifying digital databases against extensive business records to determine the accuracy of data and identify incomplete or incorrect areas

Compared key business parameters against thresholds set by the OJK (Indonesian Financial Authority) to determine the compliance of the target company and developed a comprehensive understanding of new regulations

Prepared reports and data visualizations using Tableau to summarize key findings and conclusions of the diligence process; results were used to determine the soundness of the target company

Select Experience: U.S. $3 billion M&A Advisory representing strategic buyer in the Oil & Gas sector

Defined the scope and framework for the due diligence process; analyzed revenue and cost benchmarking and precedent transactions analysis, identified U.S. $700 million in annual cost synergies

Conducted multi-faceted analysis of operational, financial and market data, assessed competitive landscape; ultimately placed a project winning bid (> U.S. $1 billion company valuation)

Lautandhana Investment Management Jakarta, Indonesia

Quantitative Analyst Intern – Returning Offer; Top-ranked in class of 14 interns Jul 2017 – Aug 2017

Led the development of stock price predictive modelling by tailoring the U.S.-based Morgan Stanley model (MSCI Barra Factor Indexes) to Indonesian stock prices and utilizing a bootstrapping methodology to generate additional data sets; the model was used by fund managers to verify the investment thesis and trends

Provided recommendations for portfolio allocation and investment decisions based on regressions and other statistical analyses for a > U.S. $400 million AUM investment fund; insights were presented to senior management and implemented by fund managers

ACTIVITIES AND SKILLS

Skills: R, SQL, Python, Tableau, Google Analytics, Facebook Insights, Excel



Contact this candidate