Krystal Tran

Data Analyst at Five Points Benefits Solutions
  • Claim this Profile
Contact Information
Location
Nashville Metropolitan Area
Languages
  • English Native or bilingual proficiency
  • Vietnamese Limited working proficiency

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • United States
    • Insurance
    • 1 - 100 Employee
    • Data Analyst
      • Apr 2021 - Jul 2022

      • Worked with over 30 Middle Tennessee local public schools and local government counties to organize and create payroll and insurance reports. • Provided weekly, monthly, and quarterly reconciliation reports between company data and client data using Microsoft Access to ensure updated and accurate data, and showcased any errors within the databases. • Minimized false positive errors within present and future reports by applying new filtering and database logic to continually improve… Show more • Worked with over 30 Middle Tennessee local public schools and local government counties to organize and create payroll and insurance reports. • Provided weekly, monthly, and quarterly reconciliation reports between company data and client data using Microsoft Access to ensure updated and accurate data, and showcased any errors within the databases. • Minimized false positive errors within present and future reports by applying new filtering and database logic to continually improve future recons in new financial quarters. • Actively created automated Microsoft Excel tools using VBA Macros for Account Executives to ensure a decrease in day to day operations, minimize errors, and to increase productivity. Account Executives' work process went from a week of data cleanup to a couple of days of data cleanup. • Collaborated with Account Executives and Management to determine best data processes that can be used across the board with different clients that have differing payroll report layouts. Show less • Worked with over 30 Middle Tennessee local public schools and local government counties to organize and create payroll and insurance reports. • Provided weekly, monthly, and quarterly reconciliation reports between company data and client data using Microsoft Access to ensure updated and accurate data, and showcased any errors within the databases. • Minimized false positive errors within present and future reports by applying new filtering and database logic to continually improve… Show more • Worked with over 30 Middle Tennessee local public schools and local government counties to organize and create payroll and insurance reports. • Provided weekly, monthly, and quarterly reconciliation reports between company data and client data using Microsoft Access to ensure updated and accurate data, and showcased any errors within the databases. • Minimized false positive errors within present and future reports by applying new filtering and database logic to continually improve future recons in new financial quarters. • Actively created automated Microsoft Excel tools using VBA Macros for Account Executives to ensure a decrease in day to day operations, minimize errors, and to increase productivity. Account Executives' work process went from a week of data cleanup to a couple of days of data cleanup. • Collaborated with Account Executives and Management to determine best data processes that can be used across the board with different clients that have differing payroll report layouts. Show less

    • United States
    • Hospitals and Health Care
    • 300 - 400 Employee
    • Recovery Resolution Analyst
      • Jun 2019 - Apr 2021

      • Examining , assessing, and documenting business operations and procedures to ensure data integrity, data security, and process optimization. • Recovering over $1,000,000 in Medicare coverage claims for health plans, commercial clients, and government programs, using various self-made filters within the database system. • Writing various automation tools within excel to aggregate and ensure data integrity, decrease false positives in potential refunds, and increasing productivity. •… Show more • Examining , assessing, and documenting business operations and procedures to ensure data integrity, data security, and process optimization. • Recovering over $1,000,000 in Medicare coverage claims for health plans, commercial clients, and government programs, using various self-made filters within the database system. • Writing various automation tools within excel to aggregate and ensure data integrity, decrease false positives in potential refunds, and increasing productivity. • Collaborating to create new business processes to ensure shorter training ramp up time from 3 months to less than 2 months. • Ensuring adherence to state and federal compliance policies and protecting private health information. Show less • Examining , assessing, and documenting business operations and procedures to ensure data integrity, data security, and process optimization. • Recovering over $1,000,000 in Medicare coverage claims for health plans, commercial clients, and government programs, using various self-made filters within the database system. • Writing various automation tools within excel to aggregate and ensure data integrity, decrease false positives in potential refunds, and increasing productivity. •… Show more • Examining , assessing, and documenting business operations and procedures to ensure data integrity, data security, and process optimization. • Recovering over $1,000,000 in Medicare coverage claims for health plans, commercial clients, and government programs, using various self-made filters within the database system. • Writing various automation tools within excel to aggregate and ensure data integrity, decrease false positives in potential refunds, and increasing productivity. • Collaborating to create new business processes to ensure shorter training ramp up time from 3 months to less than 2 months. • Ensuring adherence to state and federal compliance policies and protecting private health information. Show less

    • United States
    • IT Services and IT Consulting
    • 200 - 300 Employee
    • Operations Senior Services Specialist
      • Aug 2018 - Jun 2019

      - Created advanced Microsoft Excel VBA Macros to transform complex raw data into simple, easy to manipulate dashboards for the everyday user. - Built multiple automated Excel tools that increase efficiency by cutting down workload by over 50%. - Actively built reports to support the management team to drive results including call-outs from any data discrepancies, and using data to answer any business specific questions on demand. - Managed and met deadlines for several different daily,… Show more - Created advanced Microsoft Excel VBA Macros to transform complex raw data into simple, easy to manipulate dashboards for the everyday user. - Built multiple automated Excel tools that increase efficiency by cutting down workload by over 50%. - Actively built reports to support the management team to drive results including call-outs from any data discrepancies, and using data to answer any business specific questions on demand. - Managed and met deadlines for several different daily, weekly, and quarterly reports using KPI metrics of sales call center data from SalesForce. - Improved the new hire team training ramp up process from 90 days to 30 days, fully integrating the new hires in a shorter time. - Provided a solution for existing problems and prevention of future gaps in the workflow process. - Established a successful communicative relationship between other global operations teams and sales representatives to discuss changes in work process and areas of improvement. - Updated and managed company’s SalesForce CRM as needed by management and sales team. - Documented and updated processes for various work tasks that are used as a resource for present and future teams. - Led monthly operation sales process refreshers for both sales representatives and operations services teams. - Became a lead interviewer for potential new hires on the team and offering insight as to promote the quality of the team.

    • Operations Services Specialist
      • Nov 2017 - Aug 2018

    • United States
    • Advertising Services
    • 1 - 100 Employee
    • Social Media Marketing Specialist
      • Aug 2017 - Jul 2018

      + Specializing in Social Media Ad Campaigns to boost customer acquisitions or overall engagement + Organically growing social media groups / pages without any uses of Ads + Improving company brand online image + Business professional photography + Automating business systems to create higher efficiency levels Check me out at bit.ly/ktsocialmm + Specializing in Social Media Ad Campaigns to boost customer acquisitions or overall engagement + Organically growing social media groups / pages without any uses of Ads + Improving company brand online image + Business professional photography + Automating business systems to create higher efficiency levels Check me out at bit.ly/ktsocialmm

    • United States
    • Non-profit Organizations
    • 1 - 100 Employee
    • Social Media and Digital Marketing Intern
      • Sep 2016 - Aug 2017

      • Managing multiple client digital advertising accounts including the planning, launching and optimization of each account across paid search, social and display channels. • Finding over 50 clients per day and connecting the potential new clients to the company's products and services. • Generates hundreds of active views per post in company’s social media platforms • Managing multiple client digital advertising accounts including the planning, launching and optimization of each account across paid search, social and display channels. • Finding over 50 clients per day and connecting the potential new clients to the company's products and services. • Generates hundreds of active views per post in company’s social media platforms

    • United States
    • Food and Beverage Services
    • 700 & Above Employee
    • Collegiate Ambassador
      • May 2016 - Aug 2017

      • Working with large groups of people in order to initiate conversation about the company. • Creating a friendly and approachable environment for people to learn more about the company. • Distributing sampling products to the collegiate student body. • Promote Monster Energy to students with knowledge on the products through facts, samples, and giveaways. • Collaborate and assist field sales represented in other Monster Energy-sponsored events. • Working with large groups of people in order to initiate conversation about the company. • Creating a friendly and approachable environment for people to learn more about the company. • Distributing sampling products to the collegiate student body. • Promote Monster Energy to students with knowledge on the products through facts, samples, and giveaways. • Collaborate and assist field sales represented in other Monster Energy-sponsored events.

    • Work Study
      • Jan 2015 - May 2017

      • Transport various mediums of art into the gallery. • Answer and transfer phone calls. • Maintain the gallery throughout the day • Open and closing the gallery each day • Transport various mediums of art into the gallery. • Answer and transfer phone calls. • Maintain the gallery throughout the day • Open and closing the gallery each day

    • France
    • Retail Office Equipment
    • Sales Consultant
      • Sep 2015 - Dec 2015

      • Assisted and consulted customers in their sales needs. • Assisted customers in Print and Computer-Tech services. • Designed business card and flyer layouts for different companies and clients • Assisted and consulted customers in their sales needs. • Assisted customers in Print and Computer-Tech services. • Designed business card and flyer layouts for different companies and clients

    • United States
    • Individual and Family Services
    • Receptionist
      • 2010 - 2015

      I answered phone calls, dealt with customer service, scheduled appointments, and performed various janitorial tasks when necessary. I answered phone calls, dealt with customer service, scheduled appointments, and performed various janitorial tasks when necessary.

Education

  • University of Tennessee Knoxville
    Bachelor’s Degree, Business Analytics, Concentration in International Business
    2013 - 2017
  • CIEE London Exchange
    Business Administration and Management, General
    2016 - 2016
  • Pope John Paull II High School
    2009 - 2013

Community

You need to have a working account to view this content. Click here to join now