Francesca Piccorelli

White Plains, NY ***** 914-***-**** adusd0@r.postjobfree.com linkedin.com/in/francesca-piccorelli/

Summary

Analyst with 6 years of experience optimizing visualizations & summaries, automating reports, and documenting technical procedures. Key member of a team that doubled subscription count, streaming income, and company size. Reduced software costs by $33K/year, halved reporting time, and located and rectified $28K in missing revenue annually. Eager to leverage skillset to boost sales and drive growth.

Education

Baruch College, New York, NY

Bachelor of the Arts in Actuarial Science Dec 2016

Studied calculus, probability, and actuarial and financial mathematics. Graduated magna cum laude.

Experience

Digital Insights Analyst Tracy Anderson Method NY & Remote Jan 2019 – Present

Main Responsibilities

Delivered KPIs to executive team & advised marketing strategies accordingly. Used predictive analytics for financial forecasting.

Accelerated reporting processes for all revenue streams by:

obuilding SQL-automated daily data exports,

ocreating a live Power BI dashboard, and

owriting a protocol for faster Excel summaries.

Other projects

oNegotiated a 25% discount for a 3 year, $100K+ software contract.

oManaged all database changes, including a migration of 20,000+ streamers to a new platform.

oSupervised the recovery of missing income from disputed payments, unpaid visits, programming glitches, and staff misuse.

Metis Data Science Machine Learning Bootcamp Student Remote Jan – Oct 2022

Completed accredited 28 week program and compiled a portfolio of projects showcasing cutting edge tools and newly learned techniques.

Coded with Python, SQL and HTML to create a portfolio 7 projects.

Topics included web scraping, linear regression, machine learning classification, natural language processing, and deploying an interactive dashboard.

ClickPay Variable Data Analyst Hackensack, NJ Aug 2017 – Jan 2019

Calculated weekly income and operating expenses for management team. Found strategy to boost revenue by 10%.

Created competitor database to ensure ClickPay had the lowest prices and best product development.

Modified, merged, and updated client data. Implemented more efficient database change processes.

Created training manuals for new employees to understand the in-house software system & resolve IT incidents.

Willis Towers Watson Health & Benefits Data Analyst Intern White Plains, NY Jun 2016 – Jun 2017

Sustained & upgraded pharmaceutical reports for client budget meetings to communicate savings value compared to competitors.

Assisted cultivating a centralized database by:

-converting actuarial model to simple algorithms for developers,

-ensuring PPI & compliance guidelines were followed, and

-overseeing testing and quality assurance of the resulting web application.

Skills

CODING: Python, SQL, Pandas, Matplotlib, Sklearn, HTML, GitHub, C++, Java

DATA SCIENCE: Classification, Natural Language Processing, Web Scraping, Linear Regression, Topic Modelling, Streamlit, Google Cloud

ANALYSIS: Statistics, Probability, Excel, Tableau, Power BI, Visualization

Projects

Web Scraping & Linear Regression

Used Selenium and BeautifulSoup to launch hundreds of BaseballReference.com web pages and scrape meaningful data for analysis using Python. Takeaway results showed that trends towards taller, heavier teams are NOT associated with increase an organization's win-loss ratio.

Unsupervised Machine Learning / Natural Language Processing with Twitter

Modeled topics for 1.4 million tweets using the NLTK library, Non-Negative Matrix Factorization and CorEx. Uncovered themes from world events to spring break wisdom tooth removal.

Data Engineering Pipeline

Transferred cloud data to SQL Server, manipulated in Python, and deployed to a web app using Streamlit. Created dashboard with cell coverage overview in Spain for visitors, civilians, and government officials.

Contact this candidate