Sandra Ramirez

San Benito, TX 956-***-**** adzwl6@r.postjobfree.com LinkedIn GitHub Portfolio Google Certified Data Analytics Professional with recent completion of an intensive training program, focused on elevating skills in data preparation, processing, and analysis. 10+ years in Customer Service have led to developed skills in data analysis, problem-solving, and effective communication, with expertise in Excel, R Programming, and SQL. Seeking a position in data analytics offering opportunities for project management. TECHNICAL SKILLS

Data Analysis (Collection, Cleansing, Ethics) Data Visualization (Tableau, Dashboards) SQL (BigQuery, MSSQL) R Programming (RStudio, R Markdown) Microsoft Excel (Vlookup, Conditional Formatting, Pivot Tables) Google Workspace Slack

EDUCATION, CERTIFICATES, & CERTIFICATIONS

Google Data Analytics [Certificate] • Merit America, Virtual 05/2023

● Cultivated skills in the collection, transformation, organization, and visualization of data in order to draw conclusions, make predictions, and drive informed decision-making.

● Completed hands-on labs and a capstone project (case study) to master the art and science of asking questions, preparing, processing, analyzing, visualizing, and acting on data as encountered in real-world scenarios.

● Collaborated with training cohort to gain proficiency in team-based project management, task prioritization, problem-solving, and frequent use of Slack and Google Workspace tools. Associate of Science in Occupational Therapy • South Texas College, Mcallen, TX 08/2007 - 05/2009

● Accumulated 15 credit hours and maintained a 3.8 GPA during time in the program. DATA ANALYSIS PROJECTS

SQL Data Exploration [Project] • Covid-19 Statistics 05/2023

● Analyzed COVID statistics data by cleaning and formatting in Microsoft SQL Server, creating views with subsets of the data to analyze specific variables.

Microsoft Excel [Project] • Bike Sales Statistics 05/2023

● Utilized Microsoft Excel to import raw data on bicycle sales, then cleaned and analyzed the data for effective display of data using pivot tables and a dashboard. Data Visualization in Tableau [Project] • AirBnB Pricing & Revenue Statistics 05/2023

● Cleaned and analyzed a dataset on AirBnB listings using Microsoft Excel and created a Tableau dashboard with interactive visualizations.

*Additional projects can be viewed within my portfolio* ADDITIONAL EXPERIENCE

Caregiver • Starr Home Health, Rio Grande City, TX 11/2021 - Current

● Analyze data from daily vital records and communicate pertinent details to lead physician on a regular basis, leading to early diagnosis of medical changes and improved treatment plans.

● Prepare, administer, and log proper dosage of medications, take and log blood pressure and glucose levels to look for fluctuations, and keep medication and supplies in a sterile environment. Office Clerk • Cuevas Auto Sales, San Benito, TX 10/2018 - 11/2021

● Reviewed invoice reports and matched orders accurately with part numbers by paying close attention to the Excel spreadsheet created, updated, and maintained, which resulted in the discovery of $3000 worth of auto parts and inventory (repairs on vehicles) that needed to be reconciled in the service budget.

● Created a digital filing system within Excel to accurately track Invoices, leading to faster retrieval of vendor and customer information.

● Communicated and collaborated effectively with colleagues and supervisors via written or verbal communication to ensure clear coordination and maintain open lines of communication.