SOPHIA FLORES DATA ANALYST
adq5zs@r.postjobfree.com 509-***-**** Clarkston, WA 99403
linkedin.com ● github.com
PROFESSIONAL SUMMARY
Detail focused analyst with experience in interpreting, analyzing, and reconciliation of data obtained from a variety of sources; proficient with the analytical tools, various presentation software and possesses strong and effective communication skills essential in conducting results in analysis and investigations.
PROJECTS
Capstone-Rental Car Company Scenario
●Created database utilizing Excel to develop and analyze project data
●Developed strategies to increase revenue and decrease overhead costs
●Presented PowerPoint slides describing strategies and gave recommendations
●Compared 50 branches and rental profit of 4000 vehicles
●Strategies included branch closures, upgrading fleet of cars, and a mix of both strategies
Capstone-Home Prices
●Created database from Kaggle utilizing SQL and Excel
●Developed dashboard to compare what drives home prices
●Presented PowerPoint slides to describe findings
●A/A test to determine if sample was biased
●Found correlations between numerical variables and sale price
●Using correlation results, picked the top correlated variables and ran multiple regression to find variables with the most significance
WORK HISTORY
Marshalls. Countryside, IL
Administrative Coordinator 06/2008 - 11/2011
●Document expenditures, and process reimbursement forms
●Prepared detailed documents and reports in adherence to administrative processes
●Conducted ongoing audits to achieve accurate inventory
●Helped employees with day-to-day work and complex problems by applying motivational and analytical strategies
●Established efficient workflow processes, monitored daily productivity
SKILLS
●Data Confidentiality
●Report analysis
●Data modeling and analysis
●Storytelling with data
●Data visualization
●Leadership
●Excel
●SQL
●Tableau
●Python
●Strategic planning
EDUCATION
Thinkful
Brooklyn, NY
Expected in 01/2021
Certification: Data Analytics
●SQL, Tableau, R, Python, Microsoft Excel
●Statistics, A/B testing
●Data Visualization
●Presentation Skills
Walla Walla Community College
Clarkston, WA
08/2007
Certification: Paralegal Studies
●Completed Secretarial Course
●Knowledge of all Windows operating systems; Microsoft Word, Excel, PowerPoint, Access, and Outlook
●Knowledge of excellent record maintenance and filing techniques
●Legal terminology