Francesca Baio Email & Phone Number

Chicago, IL, US

• Uses advanced knowledge of Microsoft Excel and Displayr to build comprehensive spreadsheets, utilizing formulas and pivot tables in order to analyze and cut data, and create visual charts
• Successfully interprets data in order to draw meaningful conclusions and create action plans to improve managerial strategies and operations; compiles charts and interpreted findings into a final report in PowerPoint
• Assists engagement managers with client meetings, participates in the presentation of findings, answers questions and adds insight when needed

• Uses advanced knowledge of Microsoft Excel to build comprehensive spreadsheets, utilizing formulas and pivot tables in order to analyze and cut data, and create visual charts
• Successfully interprets data in order to draw meaningful conclusions and create action plans to improve managerial strategies and operations; compiles charts and interpreted findings into a final report in PowerPoint
• Accompanies engagement managers to in-person client meetings, participates in the presentation of findings, answers questions and adds insight when needed

Chicago

• Worked as a Payroll Administrator, organizing and editing time logs, keeping track of total hours worked by employees as well as rates of pay, managing payments to employees, maintaining budgets and overall office.
• Performed administrative tasks such as stocking, filing, organizing and administering meetings, record keeping, and compiling varied reports in an accurate and timely manner

Chicago

• Assisted main analysts with spreadsheet creation, data analysis, and report writing as needed
• Oversaw the entry and organization of raw data into a master file; formatted and edited data as needed
• Completed regional reports by breaking down account reports, cutting data, and completing deeper analysis
• Tracked the company’s internal NPS over time, administered an internal VOE study, compiled and analyzed results

• Recognized for strong customer service and sales growth that resulted in a larger loyal customer base; set personal goals for maintaining sustainable sales growth and consumption
• Worked as a social-media admin for the café: promoted coffee consumption, created and promoted specials on drinks and food, created online polls to help gage demand for certain products, etc., thus strengthening my.
• Gained experience in preparing and serving a variety of coffee drinks and food items, coordinating inventory, stocking, advertising - allowing me to take more initiative and become a more engaged and productive team.

• Worked in a community outreach program strengthening long-term planning skills, organizational skills, time management, and independence by being responsible for and invested students’ academic growth and progress
• Worked with a range of middle and high school students, focusing on math and the social sciences

• Oversaw multiple case studies, working closely under two Postdoctoral Research Fellows at The University of Chicago’s Booth School of Business to gain experience in the process of data collection and analysis.
• Set up, facilitated and broke down studies; answered participant’s questions, recorded data, and worked on data entry
• Created full lifecycle hypotheses and sound studies to test them; yielding robust findings that worked to propel and strengthen the business research being conducted, as well as my own research abilities

• Worked as a teaching assistant in a 1st grade classroom, specializing in reading and writing
• Created and organized lesson plans and educational outings, working to enhance group collaboration and structural education
• Worked as a counselor for 2nd and 4th grade girls, acting in a leadership role for a large group; organized and spearheaded daily and weekly activities, brainstormed how to keep young girls engaged in educational.

• Worked as an assistant teacher during the academic school year, creating different lesson plans and curricula for each grade, and conducting
• Learned how to quickly alternate between lesson plans, topics and projects, and how to adapt teaching based on student age and learning style

• Worked as a Payroll Administrator, organizing and editing time logs, keeping track of total hours worked by employees as well as rates of pay, managing payments to employees, maintaining budgets and overall school.
• Handled attendance records: Collected attendance charts from each classroom, transferred logs into TimeOut software system, made calls home to the families of absent students
• Performed administrative tasks such as filing, administering meetings, record keeping, and compiling varied reports in an accurate and timely manner

• Fostered a connection to my local community by supporting a local school
• Managed a full office; subbed as an assistant or primary teacher when needed – both roles fostering flexibility, time management, and communication skills
• Scheduled meetings and appointments, organized office procedures, filed attendance records, organized and cataloged files, dealt with orders and invoices for supplies, answered questions, assisted parents and other.

Bachelor'S Degree, Psychology

Education record