Andrea Dorella
Overland Park,United States
Summary
Former student-athlete currently pursuing a Master of Science in Data Analytics at Rockhurst University, adept in transforming complex datasets into insightful financial reports using SQL, Excel, R, and Tableau. Poised to apply educational and work experience to add value to a team and achieve tangible results.
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 strategy development.
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 States04.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
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 or Bilingual
Spanish
Full 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