Data Analyst Analytics

ALVIN DEREK TILETILE

*************@*****.*** 415-***-**** LINKEDIN.COM/IN/ALVIN-DEREK-TILETILE/

EDUCATION

California State University, East Bay Hayward, CA

Bachelor of Science in Computer Science

Relevant Courses: Database Architecture, Data Structures and Algorithms, Analysis of Algorithms, Software Engineering EXPERIENCE

COOP Careers San Francisco, California

Data Analytics Captain Jan 2023 - Present

2023 Spring Strategy Planning: Spearhead 2023 business plans by leading a team of 16 data analytics apprentices.

• Electrify a cohort of 16 data analytics apprentices into kickstarting their data analytics career by uplifting team morale and facilitating 200+ hours of workshops and projects utilizing SQL, Excel, Tableau, and Python.

• Mentor a pod of 4 new graduates by aiding their development in interview prep, resume writing, cover letters, LinkedIn, professionalism, and workplace etiquette.

• Expedite the goals of each apprentice by establishing clear expectations and priorities and empowering them to take ownership of their work and make decisions that align with the team's objectives.

• Strategize with other data analyst captains to successfully facilitate 4 workshops a week and weekly course of actions on a bi-weekly basis to best support the company’s mission of helping others overcome underemployment. Data Analytics Apprentice Aug 2022 - Dec 2022

Data Analysis: Launched a data-driven analysis project that visualized client data to increase overall conversion rates.

• Constructed multiple data visualizations with Tableau that easily conveyed CPC of their advertisements, audience demographics, and website traffic of their advertisements.

• Identified, resolved, and improved key areas in the presentation to clarify and highlight points that uncover insights in their data.

• Coordinated with 13 other data analytics apprentices to present a project of 47 slides showcasing business insights and strategic action plans that improve audience reach.

• Harmonized all work into one deck with the team to have a presentation that met client expectations. Data Visualization Project: Conducted a deep analysis of a 50K+ row dataset of San Francisco food safety violations.

• Visualized data in Tableau by creating multiple visuals such as pie, bubble, bar, and heat map charts, as well as mapping data geographically by districts.

• Generated all 10 pivot tables and categorized all 50K+ rows of data using VLOOKUP, allowing the team to dive deeper into analysis of the dataset.

• Cleaned a dataset by utilizing filters to handle missing values, removing duplicates, deleting irrelevant data such as phone numbers, standardizing capitalizations, converting data types, and fixing simple errors.

• Orchestrated a team of 4 data analytics apprentices to a prompt and successful completion of a project by aiding in the creation of all their data visualizations and slides. PROJECTS

Independent Work San Francisco, California

Exploratory Data Analysis Project Apr 2023

Excel Mastery: Developed 5 interactive dashboards in Excel to showcase key insights and metrics within the data.

• Utilized advanced Excel features such as PivotTables, PivotCharts, and slicers to synthesize 48 data visualizations throughout 5 interactive Excel dashboards and 5 datasets.

• Conducted thorough data cleaning to identify and eliminate errors, improving the accuracy and reliability of the datasets used for final analysis.

• Leveraged Excel’s data analysis capabilities allow users to identify key trends and insights via the interactive slicers in the dashboards.

• Created custom pivot tables and charts to summarize and compare data to easily identify correlations and trends within the datasets for analysis.

LEADERSHIP EXPERIENCE

Trader Joe’s San Francisco, California

Section Close Leader Mar 2020 - Present

Leadership: Lead the nightly close of a ~$2.8M yearly section, aiming to grow year over year.

• Overhauled closing procedures, allowing the store to reallocate ~$36K yearly into other areas of the store.

• Implemented strategic action plans that eliminated bottleneck problems, yielding a ~12% increase in monthly sales.

• Defined strategies for 5 sub-sections by collaborating closely with the team to identify workflow inefficiencies.

• Led the development of over 100 employees, championing the company’s mission of providing only the best. SKILLS

Certifications: Google Data Analytics Professional Certificate, Google Analytics Individual Qualification Technical: SQL, Python, Tableau, Spreadsheets, Microsoft Office (Word, Excel, PowerPoint), Data Visualization, Java

Contact this candidate