top of page

Resume

PROJECT EXPERIENCE

  • Olympics Data Engineering. Cleaned 162k results, 75k athletes, and 53 hosts of raw data to build an ETL pipeline and SQL database.

  • Anti-Cancer Medication Analysis. Conducted correlation and regression analysis, tumor volume distribution, and summary statistics for multiple types of drug treatment regimen by using Python and data visualization scripting.

  • School District Analysis. Aggregated data to identify school and district performance via Python, providing comprehensive metrics for stakeholders aiming to enhance educational outcomes and allocate resources effectively.

  • COVID-19 Rates Dashboard. Quantified COVID-19 vaccination rates over time, by country, and by income group; published a Tableau dashboard to visualize results.

  • Superstore Sales and Profitability Executive Dashboard. Quantified sales, profitability, profit ratio, and sales per customer. Visualized profit ratio by city on US map. Quantified monthly sales by segment and category over time by profitable vs. unprofitable orders. 

WORK EXPERIENCE

Redfin - Seattle, WA - Remote
Data Analyst (Apr 24' - Current)

Emplifi - New York, NY - Remote
Account Manager (Nov 20' - Aug 23')

  • Led weekly meetings with Strategic and Enterprise level clients such as Nike, Saks Fifth Avenue, and Hudson's Bay, ensuring successful syndication initiatives.

  • Spearheaded a project to improve and consolidate end-to-end service processes; restructured communication flow between 2 departments, resulting in a 25% acceleration in response rates for Zendesk tickets. 

  • Managed initiatives for Hudson's Bay, orchestrating the collection of 350,000 syndicated reviews within a single quarter, through precise data tracking and project management processes. 

  • Utilized advanced SQL skills to troubleshoot SKU data discrepancies, enhancing accuracy in

    syndicated reviews and elevating client satisfaction rates.

  • Conducted weekly pivot table analysis to optimize syndication strategies for 80+ clients.

  • Review Syndication is when one site authorizes the sharing of its existing content to other sites 

     

CareerArc - Burbank, CA
Business Development Rep (Oct 17' - Nov 19')

  • Accounted for $300k in revenue through personal generated leads

  • Managed 60-80 accounts on a monthly basis to conduct account-based marketing and enabled effective follow up.

  • Qualified and nurtured leads through effective communication and discovery calls, identifying potential customers and opportunities for the sales team.

  • Implemented DiscoverOrg into the company’s Tech Stack, alongside Salesforce and LinkedIn Sales Navigator, enhancing lead tracking and management.

EDUCATION

University of California Berkeley

Berkeley, CA

Certificate in Data Science & Analytics

Berkeley logo.png

Virscend University

Irvine, CA

Master of Business Administration

Virscend logo.png

California State University Los Angeles

Los Angeles, CA

Bachelor of Science in

Business Administration

CSULA Crest.png

TECHNICAL SKILLS

Data Analysis: Proficient in analyzing large datasets, identifying trends, and generating insights. Programming Languages: Experienced in Python, SQL, and JavaScript.
Data Visualization: Skilled in creating visualizations using tools like Tableau, Tableau Prep, and Python. Statistical Analysis: Strong understanding of statistical methods and hypothesis testing.
Databases: Well-versed in creating/manipulating databases with PostgreSQL, NoSQL, and MongoDB Project Management: Expert in Airtable for project tracking and Trello for visual task management.
API Integration: Experienced with APIs for data extraction and integration.
Tools: Proficient in Jupyter Notebooks, VS Code, Excel, Salesforce, Microsoft and Google Suite

PORTFOLIO MANAGEMENT

Coding Portfolio: github.com/paoloarciaga

Tableau Profile: public.tableau.com/app/profile/paolo.arciaga

bottom of page