Krystal Tran
Data Analyst at Five Points Benefits Solutions- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Native or bilingual proficiency
-
Vietnamese Limited working proficiency
Topline Score
Bio
Experience
-
Five Points Benefits Solutions
-
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
-
-
-
Optum
-
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
-
-
-
ServiceSource
-
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
-
-
-
KT Social Media Marketing Co.
-
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
-
-
-
Knoxville Entrepreneur Center
-
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
-
-
-
Monster Energy
-
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
-
-
-
Office Depot
-
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
-
-
-
Nail First Unlimited
-
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 -
CIEE London Exchange
Business Administration and Management, General -
Pope John Paull II High School