portrait

Bloopie Doopie

Somewhere, Everywhere | www.linkedin.com
(XXX) XXX – XXXX | X4@gmail.com
Portfolio: URL

OVERVIEW: Graduate from the University of Blank with a Bachelor's degree in Marketing and a minor in Finance. I have cultivated a diverse skill set combining technical proficiency with analytical abilities. Fluent in English, native in Spanish, and proficient in Italian, I possess strong communication skills essential for effective collaboration. Through my experience as a Research and Strategy Co-Director at Company, I've demonstrated leadership in directing teams, delivering consumer behavior analysis, and fostering client relationships across various industries. Additionally, my hands-on projects, such as developing interactive data analysis dashboards using Tableau and Excel and conducting data cleaning and visualization projects with SQL, Python, and PowerBI, have honed my technical prowess and problem-solving skills. With certifications in Google Analytics and Data Analyst Bootcamp, I am poised to contribute to impactful projects, leveraging my passion for learning and drive for excellence.

Skills & Certificates

  • Languages: Fluent in English, Native in Spanish, Intermediate in Italian
  • Technical: Microsoft Office (Word, Excel, PowerPoint, Teams), MSSQL, MySQL, PostgreSQL, Python, Tableau, PowerBI, Google Workspace, HTML, Shopify, Canva, Graphic Design
  • Soft Skills: Time Management, Team-work, Communication, Collaboration, Fast Learner, Organized, Professional, Passionate, Focused
  • Certifications: Google Analytics for Beginners, Advanced Google Analytics, Data Analyst Bootcamp

    • Education

    University of Blank – College of Something | Graduation: May XXXX
    Bachelor of Science in Marketing with a minor in Finance | (GPA: 3.58)
    Organizations/ Awards: XX, XX, Dean’s Honor List, Cum Laude

    Work Experience

    Research and Strategy Co-Director | April XXXX- May XXXX
    Company | Somewhere, Everywhere

  • Directed weekly meetings with a total of 12 interns to conduct workshops and deliver satisfactory work to clients before deadlines. Meetings were scheduled and held using Microsoft Teams and Google Meet.
  • Increased the department’s outputs by 740% for the agency’s busiest year.
  • Collaborated with the President, Vice President, Creative director, Account Management director, and Social Media director in weekly in-person, and remote, meetings.
  • Delivered consumer behavior analysis, newsletters, list of potential influencers, articles, mock social media posts, costumer persona profiles, and reached out to potential speakers.

    • Research and Strategy Intern | February XXXX- May XXXX
    Company | Somewhere, Everywhere

  • Researched industries and markets to find growth opportunities, market targets, and determined supplier power, buyer power, competitions, substitutions, and new threats.
  • Attended weekly in-person meetings and collaborated with teammates, including interns across the creative department.
  • Presented to the client an ad pitch and story board with visual and audio plans.

    • Creative Desiger | February XXXX- April XXXX
    Company | Somewhere, Everywhere

  • Collaborated directly with clients and companies to develop innovative design solutions tailored to their specific needs and preferences.
  • Utilized a combination of up to three editing software tools to efficiently produce and deliver three or more logo designs within the first week of project initiation.
  • Conducted thorough analysis of survey results to gain insights into target market preferences and behavior, informing the design process and ensuring alignment with client objectives.

    • Projects

    Interactive Airbnb Data Analysis Dashboard- Tableau and Excel Project | February 2024

  • Efficiently overcame the absence of direct zip code data in the original Excel dataset by manually correlating Chicago's 77 community areas with zip codes using Excel's IFS() formula.
  • Conducted comprehensive analysis of the Airbnb dataset by exploring pricing trends, and utilized statistical methods to identify patterns and outliers in Tableau.
  • Developed an interactive dashboard with visualization tools for user-friendly exploration in Tableau.

    • Nashville Housing Data Cleaning- SQL Project | January 2024

  • Conducted a thorough assessment of a Nashville housing dataset, identifying and addressing inconsistencies, errors, and missing values.
  • Employed SQL queries, and applied various data cleaning techniques, including null value handling, error correction, and format standardization, using UPDATE and ALTER TABLE queries to enhance data accuracy.
  • Developed an interactive dashboard with visualization tools for user-friendly exploration in Tableau.

    • Automated File Organization System- Python Project | February 2024

  • Developed a Python script for automatic folder sortment based on predefined categories or file types.
  • Designed a sorting algorithm to categorize files based on types, extensions, or user-defined attributes with efficient movement to respective folders.

    • Data Analysis and Visualization for Survey Data- Excel and PowerBI Project | January 2024

  • Conducted thorough data cleaning and transformation using Excel to address inconsistencies, missing values, and outliers in the survey dataset.
  • Developed an interactive Power BI dashboard with visualizations like charts, graphs, and tables that dynamically responds to user interactions, facilitating a comprehensive exploration of survey insights.
  • Utilized Power BI's analytical capabilities to derive key insights from survey responses.

    • Exploratory Analysis of COVID-19 Data- SQL Project | February 2024

  • Explored a real COVID-19 dataset, identifying key variables and understanding relationships between data fields to gain insight into COVID-19 death and vaccination data.
  • Implemented SQL's temp table feature for temporary storage, streamlining complex queries and analysis.
  • Leveraged the ORDER BY, GROUP BY, and WHERE clauses for sorting, aggregating, and filtering data, enhancing interpretability.