Sebastian Negrete
Olathe,Kansas
Summary
Results-driven Data Analyst with 2 years of experience at an insurance broker. Skilled in database management, report automation, data communication, and actuarial analysis. Proficient in Excel, Power BI, SQL, Python ETL, Tableau, and more. Strong track record of creating insightful reports and providing Excel training to account managers and clients.
Overview
5
5
years of professional experience
Work History
Data Analyst
Lockton Companies
10.2021 - Current
- Managed database by cleaning and mapping carrier data, ensuring accurate and consistent data storage
- Automated reports, resulting in significant time savings for the company and improved data accuracy
- Compiled historical data from numerous Excel files to central database, streamlining data access and analysis
- Utilized advanced Excel functions and Power BI to create insightful visualizations and reports
- Created census reports for clients to determine social determinants of health, enabling tailored medical plans
- Facilitated Excel training for incoming account managers and clients' HR teams, enhancing their data analysis skills
- Effectively communicated insights from reports to account teams, facilitating data-driven decision-making
- Produced projections and refocusing reports for clients, aiding in budgeting for health insurance plans.
Bartender
Sporting Kansas City
03.2019 - Current
- Prepare and serve a diverse range of beverages in a fast-paced and high-energy environment
- Maintain a clean and organized bar area, including ensuring that the bar has been fully stocked before and after the match, wasted has been removed to their designated disposal area, and maintain communication with warehouse staff to help retrieve low stock items throughout the match
- Engage with fans in a friendly and professional manner, creating a positive and memorable environment
- Collaborate with other team members to ensure smooth operation and exceptional customer service.
Education
Bachelors of Science - Chemistry, Computer Science
MidAmerica Nazarene University
Olathe, Kansas01.2021
Skills
- Problem-solving
- Teamwork
- Attention to Detail
- Communication
Accomplishments
Eagle Scout
Timeline
Data Analyst
Lockton Companies
10.2021 - Current
Bartender
Sporting Kansas City
03.2019 - Current
Bachelors of Science - Chemistry, Computer Science
MidAmerica Nazarene University
Similar Profiles
Yesenia GandaraYesenia Gandara
Associate Account Executive at Lockton Dunning Benefits, Lockton CompaniesAssociate Account Executive at Lockton Dunning Benefits, Lockton Companies
Shannon McCraineShannon McCraine
Account Executive - Executive Benefits at Lockton CompaniesAccount Executive - Executive Benefits at Lockton Companies
THOMAS SANGTHOMAS SANG
Founders Series Intern at Lockton CompaniesFounders Series Intern at Lockton Companies
WHITNEY MATTHEWSWHITNEY MATTHEWS
Flood Account Administrator at Lockton CompaniesFlood Account Administrator at Lockton Companies
Drew BolickDrew Bolick
Kitchen Staff Member at Urban Air Trampoline and Adventure ParkKitchen Staff Member at Urban Air Trampoline and Adventure Park