Christopher Alverio
Frostproof,FL
Summary
Adept Freelance Data Analyst with a proven track record of leveraging MySQL and Python to deliver actionable insights, enhancing business decisions for clients including Self-Employed. Excelled in creating data-driven solutions, showcasing exceptional analytical skills and collaboration. Achieved significant improvements in data processing efficiency and accuracy, directly impacting client satisfaction.
Overview
1
1
Certification
Work History
Freelance Data Analyst
Self-Employed
- Analyzed complex datasets for various clients, providing actionable insights to support business decisions
- Used SQL for data extraction, transformation, and cleaning to ensure data quality and accuracy
- Created interactive data dashboards in Tableau and Excel to visualize key performance metrics and trends
- Conducted in-depth statistical analysis on various datasets, including sales data, customer behavior, and market trends
- Worked with clients to define project requirements and deliver customized analytical reports
Freelance
Data Entry Work
- Managed and entered large volumes of data from various sources into spreadsheets and databases.
- Ensured data accuracy and integrity by performing regular data cleaning and validation tasks.
- Created and maintained organized records, files, and reports for clients.
- Utilized Excel and other tools to automate data entry tasks and improve efficiency.
- Collaborated with clients to understand their data needs and deliver customized data entry solutions.
- Provided timely and accurate updates on project progress to clients.
Education
fire science -
South Florida State College
12.2024
High School Diploma -
Sebring High School
Sebring, FL05.2024
Skills
- MySQL
- Excel
- Tableau
- Python
- Data Transformation
- Analytical Skills
- Collaboration
Certification
- Analyst Builder Excel For Data Analytics Certificate, https://www.analystbuilder.com/certificates/713878e0-e060-4190-94bc-258a9ed39792
- Datacamp Data Preparation in Excel Certificate, https://www.datacamp.com/completed/statement-of-accomplishment/course/7503258f360a573f4e7e9b9161c9bc60b4702d45
- Datacamp Data Analysis in Excel Certificate, https://www.datacamp.com/completed/statement-of-accomplishment/course/14ef27cbd6e721d98764909ce11372a8b2e37ae2
- Analyst Builder Advanced MYSQL For Data Analysis Certificate, https://www.analystbuilder.com/certificates/7df6c1fb-b535-4047-b52c-4da03cb46380
- Analyst Builder MYSQL For Data Analysis Certificate, https://www.analystbuilder.com/certificates/6a5ca62d-962e-405e-b5bd-d45f75e4ae19
- Analyst Builder Tableau For Data Visualization Certificate, https://www.analystbuilder.com/certificates/283d03c1-3fb3-4235-87ec-9328d2e46530
- Google Analytics Professional Certificate, https://www.coursera.org/account/accomplishments/professional-cert/E8NO6H9V9FQB
- Data Camp Introduction to Python Certificate, https://www.datacamp.com/completed/statement-of-accomplishment/course/97be2bc1a21bdcdfc8eaaad06bef3a948c344dea
Additional Information
Technical Requirements: Daily access to a broadband internet connection, computer, and relevant software for research and evaluation tasks., Time Management: Ability to work independently and efficiently manage multiple tasks to meet deadlines in a remote setting., Adaptability: Quick to learn new tools and systems, able to adjust to changing project requirements and evolving workflows.
Projects
Bike Sales Dashboard (Excel), https://github.com/christopheralverio/Chris/blob/main/Movie%20Correlation%20Project1%20(3).ipynb, Created an interactive Excel dashboard to analyze bike sales metrics and trends., Transformed and processed sales data using advanced Excel functions and pivot tables., Collaborated with clients to define key metrics and visualizations, improving business insights. Data Cleaning Project (SQL), https://github.com/christopheralverio/Data-Cleaning-in-SQL/blob/main/Data_Cleaning%20project%20.sql, Conducted data cleaning and quality assurance using SQL, ensuring reliable and accurate analysis., Removed duplicates, standardized inconsistent formats, and handled missing values., Utilized SQL joins and aggregation functions to validate and clean the dataset. Car Sales Data Analysis (SQL), https://github.com/christopheralverio/Car-Sales-Data-Cleaning-in-SQL/blob/main/CarSales%20Project%20.sql, Performed sales trend analysis and customer segmentation using SQL., Cleaned and transformed data by standardizing fields and removing inconsistencies., Joined multiple tables to create comprehensive datasets, applying SQL case statements to calculate key metrics. Vrinda Stores Sales Analysis (Excel), https://1drv.ms/x/c/f2cdb123fbb7f88d/EY34t_sjsc0ggPKeAAAAAAABJNrLkrPEcZ8fa1EhuiMpiA?e=6op81N, Collected and cleaned raw sales data, identifying trends and insights., Used pivot tables for dynamic analysis and structured an interactive dashboard for performance overview., Applied slicers and conditional formatting to improve data visualization and decision-making. Airbnb Listings Dashboard (Tableau), https://public.tableau.com/app/profile/christopher.alverio/viz/ChristopherAlverio/Dashboard1, Developed a Tableau dashboard to analyze Airbnb pricing trends and potential revenue based on property features., Cleaned and formatted data for accurate visualizations, incorporating filters for location and property type., Used various charts (bar, line, map) to highlight relationships between bedroom count, price, and revenue. Movie Correlation Analysis (Python), https://github.com/christopheralverio/Chris/blob/main/Movie%20Correlation%20Project1%20(3).ipynb, Analyzed relationships between movie box office earnings, ratings, genres, and release dates., Preprocessed data using Python libraries (Pandas, NumPy) and applied statistical methods (e.g., Pearson correlation)., Visualized findings with heatmaps and scatter plots to present key insights.
Languages
- English, Fluent
- Spanish, Fluent
Languages
English
Native/ Bilingual
Spanish
Full Professional
References
References available upon request.
Timeline
Freelance Data Analyst
Self-Employed
Freelance
Data Entry Work
fire science -
South Florida State College
High School Diploma -
Sebring High School
Similar Profiles
Aamuktha MadabhushiAamuktha Madabhushi
Singing teacher at Self-employedSinging teacher at Self-employed
Ava Jane Glenski VillanuevaAva Jane Glenski Villanueva
Translator at Self-employedTranslator at Self-employed
Bilal SadiqBilal Sadiq
Property Owner at Self-employedProperty Owner at Self-employed
Mike SjostromMike Sjostrom
Construction Worker at Self-employedConstruction Worker at Self-employed
Sergio BadilloSergio Badillo
Picking Manager at FergusonPicking Manager at Ferguson