Caroline Tran Email & Phone Number

San Jose, California, United States

• Accurately inputted and verified insurance checks, billing codes, and unpaid claims for multiple clinics, ensuring up-to-date records and minimizing any discrepancies.• Identified and corrected billing errors for diabetic retinal photos by creating and distributing a comprehensive guide, resulting in accurate billing and increased revenue across all clinics.

Mountain View, California, United States

• Improved customer satisfaction by reducing the amount of time it took to notify patients by 84%. Increased overall office efficiency and reduced front desk workload by several hours a day by eliminating the need to manually call patients for appointment confirmations, reminders and order pick ups by setting up automated text reminders to patients.•Simplified glasses order backlog from as far back as 2018. Created the following processes to help: 1. Started labeling glasses orders by date to better keep track of what orders needed to be re-notified. 2. Set aside past orders overdue for pick up to make it easier for staff to find current orders, improving overall office workflow. • Reduced the amount of rejected insurance claims by 20% by taking the initiative to fix our billing software which was missing crucial product information that prevented our system from billing contact lens orders properly.• Trained new hires to help with front desk duties and clerical work such as checking in patients, billing and office procedures on how to assist patients or any other necessary tasks.• Helped plan and manage a successful trunk show that made a profit of $16,000 by assisting three times the usual amount of patients that day. Helped create marketing materials to promote the event months prior to ensure it reached our target audience to maximize success.

San Jose, California, United States

• Created and managed In2cuts’ website, making it possible for customers to easily book appointments, look up current prices for services and business hours online or directly on Google’s search page.• Acquired $24,000 of funding for the salon during Covid by applying for various government small business grants like the Paycheck Protection Program and the California Small Business COVID-19 Relief Grant Program.• Launched a growing social media account on Instagram to raise brand awareness and attract more customers. It gets regular updates with pictures of new hairstyles done by actual customers each week.• Used financial data to understand more about our business by looking at revenue and expenses generated within a month to use as a baseline to see if future marketing strategies worked and to find out what our most popular service was.

• Mastered skills in analyzing business problems, data analysis, presentingbusiness insights to different stakeholders, SQL, Python, and data visualization.Data Analytics Projects: Netflix: Exploratory Analysis — Tableau• Conducted a comprehensive exploratory analysis of Netflix titles and ratings to gain valuable insights into user preferences and optimize content production strategies• Minimized risk and identified popular show genres, ensuring informed decision-making for future content creationAnalyzing Trends in Gaming — Tableau • Conducted a comprehensive analysis of video game sales data using python to identify trends and patterns in the gaming industry• Gained insights into the performance of games across different platforms, regions, and genres

Bachelor Of Arts, Psychology

Data Analytics Career Track Certificate

400+ hours of hands-on course material and completion of 2 in-depth portfolio projects.

Education record

Acquired expertise in data cleaning, transformation, analysis, and visualization using SQL, Python, and Tableau during a 16-week.