A comprehensive hands-on data analytics program requiring the completion of capstone projects using Excel, SQL, Tableau, and Python to perform statistical analysis, extract insights, create engaging visualizations and interactive dashboards.Data Analysis• Covering popular packages and libraries used in data processing, manipulation, and visualization• Setting up PostgreSQL database connections, using SQL including joins, CTEs, and aggregations• Statistical analysis and Independent Samples t-testing in Excel and Python, A/B testing, etc.Data Visualization• Design and build strategic and analytic types of dashboards in Excel and Tableau.• Story Boards in Tableau and slide decks in PowerPoint to effectively communicate data insights.• Delivering key information using clear language: a concise summary that's easy to comprehend.

Evaluated source documents to locate information needed for each data entry fieldProduced monthly insurance reports using Excel spreadsheet functions, such as vlookup and SUMIFCorresponded with insured or agent to obtain information or inform them account status or changesCreated a universal spreadsheet of loans in which flood insurance is required, monitoring and updating it monthlyEnsured that all loans secured by collateral have sufficient insurance

Enrolled prospect student contact information into an excel spreadsheets Answered incoming callsKeyed 35+ contacts every working shift Purged files to eliminate duplication of data

Entered insurance documents into databaseChecked incoming insurance documents met requirementsHelped Portifiolo Manager with day to day tasksFiled and scanned documents