Upwork home
Sign up
Secondary
Rutherford R. Status: Offline
Makati City, Philippines

Data Analyst

I have a Bachelor's Degree in Psychology from De La Salle University-Manila and I finished rank 9 from the Board Licensure Examination for Psychometrician back in 2019. I've been working with Marketing Consultants as a Data Analyst for 3 years and can provide different kinds of analytics reports depending on the business need. I can do statistical analyses using various tools like Excel (advanced functions and formulas, advanced visualizations and dashboards), SQL(extracting data from related databases), R(end-to-end data analysis), and Tableau(dashboards and visual storytelling). I handle the end-to-end analytics lifecycle from data collection, data preparation, data cleaning, data analysis, data visualization, and generating insights and recommendations out of the dataset. List of reports I can perform (regularly): 1. LTV Analysis (using Shopify and Amazon) - What is the Lifetime Value of your customers? (This can also be segmented) 2. Churn Analysis - What is the drop-off rate / cancellation rate of your subscriptions? How long does a customer typically subscribe before cancelling? 3. Email Attribution Analysis - which of the emails you captured ended up converting and how long? 4. Product Repeat Purchase Analysis - Which among your products tend to yield repeat purchases from your customers? 5. Customer Repeat Purchase Analysis - On a segmented basis (month, year, etc.), what is the repeat purchase rate of your customers? How many of your first-time customers tend to buy again? 6. Average Time Between Repeat Purchases Analysis - What is the average time between first and second purchase of your customers? second and third? etc. 7. Facebook/Google Ads Analysis - Which among your ads perform the best? Which should you drop off? What kind of creative / messaging resonates with your audience? 8. Discount Code Analysis - Among the discount codes you've ran, which among them were most profitable? Which among them were most effective in converting your audience? 9. Market Basket Analysis - Which among your products are best bundled together to increase AOV and probability of purchase? 10. Product-Based LTV - Which among your products tend to yield high LTV customers? This list is by no means exhaustive, and I work on many other reports depending on the requirements of the analytics problems. I mostly work on customized reports that require critical thinking and creative problem-solving (for example, building a report to help identify the existing customer reactivation of a specific client on a month-by-month basis.) Professional Skills: Excel, R, Tableau, SQL, Databox, Research Writing, Thesis Writing, Statistical Analysis, Psychological Testing and Assessment, PowerPoint Presentation, End-to-End Data Analysis Process, Lead Generation, Influencer Outreach, Customer Support.
Work history
Rutherford R. has more jobs. Create an account to review them
Skills

Skills

  • Microsoft Excel
  • R
  • Tableau
  • SQL
  • Data Visualization
  • Statistics
  • Research Papers
  • Quantitative Research
  • Data Analysis
  • Academic Writing
  • Marketing Analytics
  • Google Analytics Report
  • Google Ads
  • Facebook Ads Manager

Browse similar freelancers