Data Analyst Resume
2.00/5 (Submit Your Rating)
Bellevue, WA
TECHNICAL SKILLS:
- SQL
- R
- Power BI
- Excel
- Tableau
- DAX, VBA
- Cube
- Python
- Machine Learning marketing data.
PROFESSIONAL EXPERIENCE:
Confidential, Bellevue, WA
Data Analyst
Responsibilities:
- Communicate wif clients, stakeholders to get requirements and make presentations.
- Program in R for Prediction/Forecasting ARIMA model, conduct Hypothesis Test, Experiments for AB test, Clustering, Sampling design.
- Deliver and publish online teh visualization reports in Power BI and Excel to provide important data matric for decision making.
- Design database structure, program in SQL - Server to query, create VIEW, Stored Procedure on maintenance purpose.
- Work wif tabular cubes, ETLs, handling large amount of marketing data.
- Program in Python for Linear model to find key factors in budget forecasting model.
Confidential, Bellevue, WA
Consultant
Responsibilities:
- Design and maintain database structure, program in SQL, manipulate data in SSIS/SSAS for data mining purpose.
- Create scorecard in excel for KPI management purpose wif teh skills of VBA Programming, SQL Programming.
- Perform visualization reports in TABLEAU by creating slides and storytelling to catch project progress key point in teh management.
- Publish and document report in Share Point associates wif MS Access.
- Organize and deliver presentations to clients, stakeholders, explain project results of dashboard and quantitative models.
- Program Management wif Six Sigma on ongoing quality improvements in teh Services Management & Support Practice teams, helps define, drive and maintain continuous quality improvement for a large, fast-growing support team.
Confidential
Senior Quantitative Analyst
Responsibilities:
- Manipulated big data in Hadoop for data mining purpose.
- Analyzed user’s visit attribute using Google Analytics tools set and communicate wif vendors towards online advertising function.
- Delivered dashboard in Excel by creating Pivot Table, Power Pivot and Power Point.
- Set up quantitative models to analyze teh macro-economy investment environment for Stock Market. Give investment suggestions to Fund Managers.
- Verified inflation rate and other economy indicator’s relationship by Granger method.
- Analyzed macroeconomics investment environment by checking inflation rate’s influence, setting up VAR, GARCH, MCMC, MSVAR methods.
- Determined key metrics to analyze relationships between economic indicators and market performance, forecasted teh economy operation trends.
- Made presentations to teh investment managers by using power point to explain models, discussing investment strategy.