KM

Kimberly Ming

Data Analyst · CR&R


Work Experience

Data Analyst

CR&R

2020 – 2020

• Developed macros in Excel to reduce downtime in cleaning and formatting data for daily service changes made by our clients. • Created routing solutions in RouteSmart (ArcGIS) for CR&R truck drivers to increase efficiency and productivity during the pick-up/delivery process. • Evaluated and determined the productivity of CR&R's truck drivers by measuring and calculating their overall performance on a weekly basis in Excel. The variables that were measured and calculated were total working hours, over/under hours worked due to downtime (such as terrible traffic conditions, accidents, flat tire, engine failure..etc), and total number of pick-ups/deliveries each driver made on a daily basis. • Facilitated team meetings with logistics and operations department to present findings in route efficiency and productivity in CR&R's truck drivers

Data Verification Coordinator

LoanBeam

2020 – 2020

• Assisted LoanBeam's IT/Operations team in meeting consumer demand by analyzing and processing up to 2000 pages of tax documents for clients daily with 100% accuracy. • Increased productivity and decreased downtime for Data Verifiers by leading team members and peers to create a set of comprehensive guidelines highlighting the important rules to follow during the verification process. This reduced downtime by minimizing time spent asking and answering questions about the data verification process. • Collaborated with team members to resolve database connectivity errors by editing/checking SQL queries to ensure proper linking to LoanBeam software, which eliminated at least 2 hours of downtime on average. • Regularly trouble-shooted technical issues arising from processed loan submissions.

Data Entry Specialist

SurePrep LLC

2020 – 2020

• Reviewed and validated accuracy of SurePrep's software functionality to successfully prepare tax documents for clients. Approximately 2000 pages of tax forms were processed within six hours on a daily basis. • Input and/or edited any and all missing information entered into the software by looking into SurePrep's database for comparison by determining whether OCR properly captured all fields that is required for tax documents to process properly and finding necessary tax forms to properly file client's tax information. • Worked with multiple clients across various industries to help expedite the overall tax season process with a paperless workflow.

Student Researcher

TWiST Lab

2017 – 2019

• Conducted observational study of Mob Programming and other software development approaches with CGU students to study collaborative learning methods in various organizations. ? Through some analysis using Tableau and Excel, we found that the majority of problems in teams were caused by miscommunication and lack of leadership. • Presented current trends in technology and innovation to encourage research collaboration. • Reviewed research literature on Organizational Behavior in relation to the Tech Industry (e.g. Silicon Valley) and applied it to possible solutions to increase team efficiency for teams we have evaluated.

Director of Information Technology

CGU Drucker Net Impact

2018 – 2019

• Facilitated and coordinated Data Science Workshop series that included five different workshops emphasizing on analytical tools and techniques in Azure, Tableau, MySQL, and Python for current CGU students and alumni. ? Some the topics covered during these workshops include Machine Learning Algorithms such as Linear Regression, k-Nearest Neighbor, Support Vector Machines and Classification/Decision Tree. • Coordinated site visits to companies such as Amazon, Mellano Farms and Acuity Brands to help educate approximately fifty students about how technology can optimize the supply chain processes in various industries. • Participated in case competitions to help assist up to one hundred students with analytical tools in software such as R and Python.

STEM Coach/Office Administrator

Futurelink Inc

2018 – 2018

• Provided STEM tutoring to students by creating interactive assignments/activities to help students better understand complex concepts and stimulate learning. Through these activities, about seven out of ten students tutored improved their grades drastically, by anywhere from one to two letter grades on average. In some cases, students that generally received C's and D's in mathematics reported A grades after tutoring. • Facilitated and coordinated preliminary assessment tests for prospective students to appropriately prepare lectures/lessons that best suit their needs. This method helped improve overall academic performance by a full letter grade or more for several K-12 students that utilized our services. • Resolved inquiries and concerns for current and prospective customers to increase customer retention and attract new clients. At least 85% of clients were retained by ensuring that their children improve their academic performance within their 6-week prepaid sessions. • Utilized primarily Outlook (email) to reach out to current and prospective customers. • Created and taught coursework for various analytics software such as Tableau, PowerBI, SAS and R to young adults that are seeking to learn something new or change their career path. • MaximumBit was contracted with Microsoft, hence, we only used Windows in our office.

Cashier/Baker/Customer Service Associate

Nigel Donut, Laguna Nigel, CA

2010 – 2016

• Decreased excess inventory by using Microsoft Excel to track baking ingredients and beverages needed on a weekly basis • Provided customer support with a positive attitude regardless of how stressful the situation may be (e.g. customer complaints, malfunctioning/broken machines, or long waiting period for an order) • Managed finances on a daily basis after collecting recipes from the cash register on Microsoft Excel • Provided assistance to the primary baker by preparing ingredients such as kneading dough, adding sweeteners and decorating baked goods.

VOLUNTEER/EDUCATIONAL EXPERIENCE

Education

MBA

CLAREMONT GRADUATE UNIVERSITY

2019

MBA

Masters of Information Systems & Technology

UNIVERSITY OF CALIFORNIA

2019

Masters of Information Systems & Technology