Katia Gerzmehle Email and Phone Number

Role: Conducted data analysis of member growth and retention. Cleaned, organized, transformed, analyzed data, and created dashboards. Collaborated with the Director of Member Success and used this analysis to increase membership.Tech stack: Wix, Excel, Tableau, Mapbox• Conducted analysis of nonprofit website features & database capabilities by using WIX & Excel, updating new & non-members by cleaning & coordinating data thru Concatenated, Remove Duplicates, VLookup, If, CountIFs Functions resulting in constant analysis of key performance indicators guiding management with data decision making.• Created data visualization using Excel and Tableau, analyzing & presenting the current data collection of the company visualizing Subscription Membership metadata reflected in Bar charts & Mapbox chart, data collected presenting locations by states and countries.

Role: Created and collaborated solutions to different projects using the latest data analytics technologies. Tech stack: SQL, Python, Tableau, and Excel.• Learned DAX (Data Analysis Expressions) and how to utilize it to perform advanced calculations in PowerPivot using Microsoft Excel. Using Pivot charts and sliders in pharmaceutical companies around the world. Were the U.S. getting more sales in the world. And what companies have more revenues. • Advanced in Excel and Data visualization using Microsoft Excel. Captured and developed data into visualizations.• Programmed in Python and structured a database using SQL.• Dashboard and Data Visualization using Tableau. Completed projects include finances, sales, and global statistics dashboards.

Role: Customer Service Specialist, retail management, and on-site registrar of large conferences at the San Diego Convention Center. Learned different proprietary software for each conference sponsor.Tech Stack: Excel, registration programs.• Translator and representative in bilingual assistance for conference attendees from Europe and South America for a smooth transition to programs offered for the larger conventions, ranging from International Bio Conference to Comic Con serving 30 to 300 people daily.• Quickly promoted to on-site registration administrator with privileges for addressing information needed and official meetings and conferences.

Role: Guest advocate with multiple duties which included receiving payments, answering questions, helping them locate items, and providing advice and recommendations.Tech Stack: Salesforce.• Communicated by telephone or in person to provide information about products or services, entered orders into the company CRM, canceled accounts, or obtained details of complaints.• Balanced the cash register and generated reports for credits and debits sales.

Role: Led undergraduate team and spearheaded the draft and final publication of a series of articles about microarray using Excel. Organized and cleaned the data, as well as utilized multi-criteria methods in the Cancer Medicine journal. Acted as spokesperson at conferences for these articles in Puerto Rico and the United States.Tech Stack: Excel, MatLab, Minitab, PubMed database, PowerPoint.• Created detailed analytical reports and effectively presented findings to teammates, leadership, and stakeholders.• Experienced working with large data sets. Acquired knowledge in manipulating, cleaning, and normalizing raw data sets for inclusion into the databases and used in analytics.• Understood data, analyzed results using statistical techniques, and created reports and presentations.• Recognized, analyzed, and interpreted changes or relationships in complex data sets.