Data Analyst Financial

Vera D

Seattle, WA, ***** +1-208-***-**** adh2z2@r.postjobfree.com

SUMMARY

• Skills: SQL, Python, Tableau, Quicksight, Excel (pivot table, v-lookup, formulas, financial modeling)

• Analytics: Business Forecasting, Statistical Analysis (hypothesis test, z-test, t-test, f-test), Regression

• Tools: ETL, AWS services (S3, Redshift, Aurora, RDS), Salesforce, Oracle, Bloomberg, Rodeo, OperativeOne EDUCATION

UNIVERSITY OF CALIFORNIA, SAN DIEGO San Diego, CA

M.S. in Financial Mathematics STEM Certified 2018 - 2019

• Coursework: Collect / Analyze Financial Data (Python & SQL), Business Forecasting (machine learning), Statistics, Valuation in Corporate Finance, Investment Analysis, Advanced Risk Management XIAMEN UNIVERSITY Xiamen, China

B.E in Science & Engineering Technology, minor in Quantitative Finance 2014 - 2018 PROFESSIONAL EXPERIENCE

AMAZON Seattle, WA

Finance Support (Contractor) Mar – Present 2020

• Addressed ad-hoc Business Intelligence data SIM requests on daily basis and reduced the turnaround time by a few days

• Translated business demands into specific metrics to draw impactful conclusions; developed and automated structured queries and visualization dashboards through Tableau/Quicksight from multiple data sources

• Independently create and teach a 7- training sessions on how to write high-quality SQL to extract and combine data from relational databases (Redshift and Aurora); manage full project lifecycle from issue identification to solution and deployment

• Dived deep into accured but not billed campaigns through collecting data from Salesforce, Oracle and correct the accruals and billed amount through financial data analysis, resulted in a drop of loss profits from 15.3% to 2.19% within one quarter

• Created data pipeline to automate ABNB process; conduct SQL workbench to collect, clean and analyze detailed transaction data and track performance metrics regarding profit and loss; generate insights to deliver weekly reports to senior stakeholders

• Partnered with cross-functionally with financial analysts, engineers and account managers for enhancing ads growth INTELGRIDS INC (a fintech start-up) Bay Area, CA

Data Analyst Intern Jul – Dec 2019

• Data Analytics: Independently utilized Python to construct quantitative trading models based on complicated algorithms for user growth (from 500 to 10,000) and performance optimization (cutting monthly cost by ~$10,000)

• Visualization & Reporting: Conducted SQL to rephrase the business outcome into actionable insights; utilized Tableau to create dashboard reports and visualize the trading trends in the trading market

• Cross-team Collaboration: Delivered data-driven results to influence the user interface and strategy of other teams PRICEWATERHOUSECOOPERS Shanghai, China

Business Analyst Intern Jan – Mar 2018

• Data Analytics: Collected operating data through SQL from the accounting and finance department of the client; performed complex analysis to find risk issues

• Visualization & Reporting: Delivered a comprehensive financial audit report and found root causes of risk issues

• Cross-team Collaboration: Participated in an audit project for an international trade company with team of 5 from different departments; communicated across all levels of business to collect information and try to identify risk issues ROLAND BERGER Shanghai, China

Financial Data Analyst Intern Sep - Dec 2017

• Data Analytics: Conducted SQL to support revenue forecasting through data aggregation identifying the potential development; generated a detailed business plan including problems, trends and opportunities for the whole strategy

• Visualization & Reporting: Translated large datasets into insights and presented analysis through Tableau

• Cross-team Collaboration: Participated in a strategy consulting project with another five consultants for a municipal city government’s plan of developing a sports town within only 2 weeks

Contact this candidate