Summary
Overview
Work History
Education
Skills
Affiliations
Languages
Timeline
Generic

Andrea Dorella

Overland Park,United States

Summary

Logical Data Analyst skilled in requirement analysis and database management. Self-directed and proactive professional with two years of experience collecting, cleaning and interpreting data sets. Natural problem-solver possessing strong cross-functional understanding of information technology and business processes.

Overview

4
4
years of professional experience

Work History

Administrative Assistant

Intrepid Direct Insurance
02.2024 - Current
  • Ensured meticulous organization and documentation of financial accounts to facilitate smooth auditing processes. This involves maintaining comprehensive records, filing documents systematically, and noting relevant details pertaining to accounts, transactions, and financial activities.
  • Assisted the sales team by engaging in different activities using Salesforce. This support contributes to the sales effort by helping to generate leads, follow up on prospects, and maintain communication with clients.
  • Maintained open and transparent communication channels with all departments within the organization. This involved contributing ideas, sharing insights, and actively participating in discussions to achieve project goals and objectives.
  • Attended departmental and organization-wide meetings and events, actively engaging in discussions and providing input where necessary.

Data Analyst - Data Validation & Bookkeeping

Patriot Systems Analytics
05.2023 - 08.2023
  • Used Excel and R for data cleaning and transformation tasks, ensuring accurate and structured datasets for analysis.
  • Utilized Excel and R for in-depth data analysis of financial transactions, extracting meaningful insights and generating comprehensive reports for management.
  • Utilized Tableau data visualization tools to present financial information in a clear and accessible manner.
  • Implemented data validation techniques to ensure the integrity and accuracy of financial data, contributing to high-quality analyses.
  • Presented findings to executive leadership teams through concise presentations, influencing future strategies.

Marketer

Be Createful
05.2020 - 08.2020
  • Assisted in the development of pictures and videos to promote and prepare sales materials.
  • Created a new design for the company's website by using Adobe Photoshop and Illustrator.
  • Created a new printable rhinestone color chart, also used on the company website.

Education

Master of Science in Data Analytics - Data Analytics

Rockhurst University
Kansas City, United States
05-2024

Marketing - Marketing

MidAmerica Nazarene University
05.2022

Skills

  • R Language
  • Python
  • Structured Query Language (SQL)
  • Google Analytics
  • Tableau
  • Microsoft Office
  • Adobe Premiere Pro
  • Marketing and Sales
  • Leadership and Teamwork
  • Communication Skills
  • Collaboration & Teamwork
  • Data Modeling
  • Business Needs Analysis
  • Technical Writing
  • Data Warehousing

Affiliations

Relevant Project: Graduation Rate Prediction

Rockhurst University - The objective was to employ advanced analytics to enhance graduation rates by identifying students at risk of not graduating within four years.

Accomplishments:

Probability Analysis: Calculated the probability of graduating within four years, providing a quantitative foundation for targeted interventions.
Gini Impurity Index: Evaluated the Overall Gini Impurity Index, gaining insights into the diversity and homogeneity of the dataset.

Gender Impact Assessment: Conducted a thorough analysis to determine the impact of gender on graduation rates, identifying potential gender-based disparities.
Data Visualization: Plotted GPA against SAT scores, enabling a visual exploration of the relationship and distribution of key academic indicators.
Decision Tree Modeling: Implemented recursive partitioning to develop a decision tree, identifying critical predictors influencing graduation outcomes.
Random Forest Implementation: Applied Random Forest for ensemble learning, improving model accuracy and resilience against overfitting.
Policy Recommendations: Pruned the decision tree for enhanced interpretability, leading to strategic policy recommendations for targeted student support.

Outcomes:

Developed a predictive model that aids in proactive identification and support for students at risk of not graduating within the desired timeframe. Enhanced decision-making processes by providing actionable insights derived from statistical analysis and machine learning techniques. Contributed to the establishment of data-driven policies, fostering a culture of continuous improvement in education outcomes.

Languages

Italian
Native/ Bilingual
Spanish
Professional

Timeline

Administrative Assistant

Intrepid Direct Insurance
02.2024 - Current

Data Analyst - Data Validation & Bookkeeping

Patriot Systems Analytics
05.2023 - 08.2023

Marketer

Be Createful
05.2020 - 08.2020

Master of Science in Data Analytics - Data Analytics

Rockhurst University

Marketing - Marketing

MidAmerica Nazarene University
Andrea Dorella