Analyst Data

Justin Hackett

*** *** ****** *** *********, CA 513-***-**** *******.********@*****.*** Justin’s LinkedIn Profile Summary

Reliable and resourceful professional, demonstrating success in high-profile initiatives. Recognized for producing impactful and strategic deliverables under ambiguity while coordinating multiple full lifecycle projects. Strengths include: Market Analysis/Research Business Strategy Project Management Technical Skills: Microsoft Excel, Google Suite, Salesforce, Tableau, Relational Databases, SQL Experience/Accomplishments

Business Analyst March 2020 – June 2020

Cushman & Wakefield @ Google Mountain View, CA

o Start date delayed until June; offer rescinded due to COVID-19 Senior Client Analyst/ Client Analyst March 2018 – February 2020 Sequoia Consulting Group San Francisco, CA

o Developed & presented financial models to 25+ high-tech, clients, owned the scoped deliverables for succeeding meetings based on financial projections, market research trends and benchmarking data that resulted in typical savings of $50k-$500k; consulted directly with client leadership teams o Consulted with clients on quantitative and qualitative impacts on potential programs implementations, new vendors, adjusted contribution strategies

o Project managed benefits renewal for Sequoia Tech Program with 97% retention rate for 400+ clients and 50,000+ members; created internal workflows integrating 5+ teams; updated database with renewal content used for client-facing resources and carrier billing

o Wrote SQL queries to transfer existing client data into new data warehouse & wrote JIRA tickets requirements o Managed enterprise new business prospects; strategized with Sales team over potential prospects, successfully onboarding 10+ enterprise clients

o Designed questions with Marketing, collected results, and scrubbed raw survey data gathered from 1,000+ companies, produced visualizations in annual benchmarking publication that drove client strategy o Drove process improvement by drafting requirements, developing use cases and integrating new Salesforce components to enable timely reporting, eliminated 5+ hour of work per week per client Benefits Analyst January 2017 – March 2018

USI Insurance Services Cincinnati, OH

o Led RFP’s for client renewals and prospective groups, analyzed marketing proposals and created client-facing presentations; collaborated with Account Executives, Account Managers, and Producers o Delivered bi-annual financial models, quarterly IBNR & lag reports, & monthly claims validations to 20+ clients o Provided support for Producers and defined strategic plans and solutions for prospects and clients o Analyzed experience financial and utilization data, identified trends and relationship of experience to renewal rating, and suggested renewal activities based on market research findings o Reviewed benefit compliance material for each client, implemented new benefit carrier changes and reviewed all documents ensuring accuracy; prepared employee communication templates for clients Community Service

o Traveled to Port au Prince, Haiti to restore a health clinic that provides free health care for the community o Volunteered on USI community outreach efforts supporting local underprivileged children Education

University of Cincinnati, Class of 2016 Bachelor of Business Admin, Information Systems

Contact this candidate