Andy Quach

Andy Quach Email and Phone Number

Senior Data Analyst at PEAK6 InsurTech @ PEAK6 InsurTech
141 W Jackson Blvd, Chicago,IL 60604,United States
Andy Quach's Location
Greater Chicago Area, United States, United States
Andy Quach's Contact Details
About Andy Quach

To bring structure to large quantities of formless/unorganized data and to effectively communicate analytical discoveries to business departments of all levels of expertise. To turn data into information, information into insight, and insight into business decisions.Specialties• Technology Proficiencies: Power BI Desktop, Power BI Report Server, Tableau, VBA, Business Objects, SQL, SSRS, SSIS, Salesforce, TFS, Sharepoint, Microstrategies, Siebel, BPCS, SQL Server Management StudioMicrosoft Office: Advanced – Excel, Word, Outlook; Intermediate – Access, PowerPoint, OneNote• Microsoft Office Proficiencies: Excel (Advanced), Word, Access, PowerPoint, Outlook, Power BI• Languages: Basic knowledge in Vietnamese and Chinese

Andy Quach's Current Company Details
PEAK6 InsurTech

Peak6 Insurtech

View
Senior Data Analyst at PEAK6 InsurTech
141 W Jackson Blvd, Chicago,IL 60604,United States
Employees:
65
Andy Quach Work Experience Details
  • Peak6 Insurtech
    Peak6 Insurtech
    Chicago, Il, Us
  • Peak6 Insurtech
    Senior Data Analyst
    Peak6 Insurtech Mar 2022 - Present
  • Ryan Specialty Group
    Senior Business Intelligence Analyst
    Ryan Specialty Group Jun 2021 - Mar 2022
    Chicago, Il, Us
  • National General Insurance
    Senior Business Intelligence Analyst
    National General Insurance Feb 2021 - Jun 2021
    Winston-Salem, Nc, Us
  • National General Insurance
    Business Intelligence Analyst Ii
    National General Insurance Jun 2018 - Feb 2021
    Winston-Salem, Nc, Us
    • Manage the full development lifecycle of SaaS dynamic dashboards (performance tracking, mix of business report, forecasting, heatmaps) using Microsoft Power BI• Develop complex SQL queries leveraging enterprise data to provide insights into the entire business portfolio and departmental strategies• Integrate RLS into dashboarding and reporting architecture to increase user engagement and reduces data lag by 73%• Iterate and reduced 64 legacy dashboards to three central reporting dashboards for sales departments to track individual’s and team’s goals and metrics• Creating engagement dashboards frameworks to be whitelabeled for external partner’s utilization• Reduced annual licensing fees by converting legacy dashboards from Qlikview to Power BI
  • Bridgenet Solutions
    Qa Analyst
    Bridgenet Solutions Nov 2017 - Jun 2018
    Chicago, Illinois, Us
    • Created VBA Macros and SSIS packages to improve ETL processes across large data sources• Designed and executed the integration of new data types into current business solutions• Extracted and delivered analytical support of complex shipping data in SQL SMS• Leverages technical Excel/SQL expertise to streamline data solutions
  • Allstate
    Data Analytics Consultant
    Allstate 2014 - Nov 2017
    Northbrook, Il, Us
    • Aids in agent engagement consultations by creating visual reports that integrate numerous sources of information and pivot tables into simple dashboards• Plan, design, and deploy the integration of new data sources to current business solutions• Ensures delivery of complex data extractions and analytical support for internal users• Increased operational efficiency by rebuilding and automating monthly reports for leadership team to digest large amounts of data• Built and maintained tools to analyze and measure performance metrics to drive conversation in agency consultations• Created heatmaps and interactive dashboards in Tableau to translate complex data for consumption by key stakeholders
  • Newark Element14
    Customer Database Specialist
    Newark Element14 Oct 2012 - 2014
    Chicago, Illinois, Us
    •Creates smartscripts to resolve client site map and bill point inconsistencies•Reviews client sales and contact information for inaccuracies using various Excel functions•Utilizes Siebel database software to analyze and create new accounts to improve sales for Sundry Report
  • Navigant Consulting Limited
    Excel Specialist
    Navigant Consulting Limited Sep 2012 - Sep 2012
    •Provided data entry assistance to lead consultant for Women Business Leaders Forum•Created banquet project attendee information spreadsheet using pivot tables and other various Excel functions•Conducted research to aid lead consultant in updating contact information of top 100 female CEOs

Andy Quach Skills

Microsoft Excel Microsoft Word Microsoft Power Point Microsoft Outlook Siebel Databases Powerpoint Leadership Outlook Public Speaking Data Analysis Microsoft Office

Andy Quach Education Details

  • University Of Illinois Urbana-Champaign
    University Of Illinois Urbana-Champaign
    Actuarial Science

Frequently Asked Questions about Andy Quach

What company does Andy Quach work for?

Andy Quach works for Peak6 Insurtech

What is Andy Quach's role at the current company?

Andy Quach's current role is Senior Data Analyst at PEAK6 InsurTech.

What is Andy Quach's email address?

Andy Quach's email address is ni****@****ail.com

What schools did Andy Quach attend?

Andy Quach attended University Of Illinois Urbana-Champaign.

What skills is Andy Quach known for?

Andy Quach has skills like Microsoft Excel, Microsoft Word, Microsoft Power Point, Microsoft Outlook, Siebel, Databases, Powerpoint, Leadership, Outlook, Public Speaking, Data Analysis, Microsoft Office.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.