Data Analyst and Business Intelligence Analyst

Mia You

*** *. ****** ***** *******, Illinois ***01 513-***-**** ********@*****.***

EDUCATION

DePaul University, College of Computing and Digital Media Chicago, IL Master Science in Information Systems GPA 3.86/4.00 Dec 2019 Concentration: Business Intelligence

Relevant Courses: System Design, Analysis, & Implementation, Database Design for Information System, Data Warehousing, Database Processing for Larger- Scale Analytics, Data Visualization, and Advanced Machine Learning Academic Projects: Mental Health Analysis in Technology Industry (Logistic Regression, KNN, and Decision Tree with Python) Movie Review Text Analysis (Text Mining and Sentiment Analysis with Python) Chicago Crime Data Visualization (Data Visualization with Tableau) Miami University, College of Engineering and Computing Oxford, OH Bachelor of Science, double major in Manufacturing Engineering & Engineering Management Aug 2015 EXPERIENCE

DePaul iD Lab - consultancy for software development, UIUX, and data analysis Chicago, IL Business Analyst Aug 2018– Dec 2019

Business analyst to iD Lab clients to improve business processes through innovative software solutions. Led daily standups and weekly Scrum meetings as Scrum Master in an Agile environment. Clients and projects included: CDW (technology product & service provider)

• Managed redevelopment of natural language processing FAQ chatbot using MS Azure Bot Service that improved query accuracy by 30% and lowered the ticket backlog volumes and response times by 25%.

• Diagnosed query issues, designed improved dialogue interactions and user flow; prototyped new chatbot and conducted usability testing to improve the user experience.

Ability Engineering Technology Inc. (manufacturer)

• Shifted business practices from manual input processes to automated operations and achieved time cost savings of 15%; enabled client to reduce production delays and project lead time.

• Mapped manufacturing and business workflow, standardized operational processes and identified time-cost savings; automated data input processes, and prototyped new CRM database to enable efficient tracking and management of clients. Data Analyst

Divvy Bike (Chicago bike-share system)

• Built predictive machine learning model to enable Divvy Bikes to optimize bike rental duration and bike volumes depending on weather conditions.

• Applied various techniques (classification, clustering, association rule discovery, etc.) to perform model selection and feature engineering.

Intertek Group - inspection and product testing certification provider Arlington Hts., IL Innovation Intern Summer 2019

Automated Intertek Electrical’s revenue reporting and forecasting processes by building new data infrastructure and modelling systems integrating multiple administrative data sources. Dramatically improved forecasting accuracy by 83% and reduced redundancies across multiple reporting systems.

• Built new DBMS, created ERD/relational database schema to combine CRM, TPS, and Electrical Project Folder data.

• Created predictive models to forecast quote win/loss rates by customer segment and quote turnaround time.

• Generated reports using Power BI; communicated results to cross-functional teams (including sales, IT and marketing analytics). Mitsuboshi Belting Ltd. USA - automotive industry manufacturer Ottawa, IL Production Engineer 2016–2017

Sole engineer responsible for one of Mitsuboshi’s 4 production lines in North America.

• Managed production targets, quality control, troubleshooting, machinery upkeep and maintenance, batch data analysis.

• Led weekly production meetings, reducing reject rate from 0.8% to 0.4% in 5 months.

• Reduced costs and enhanced quality by performing Total Productive Management and implementing process improvements.

• Responsible for reporting and authorizing standardized manufacturing work instructions for the production line. Consultant on designing production metrics to operationalize new products from clients’ design blueprints.

• Responsible for testing, statistical analysis to evaluate process variabilities and capabilities, for new product development. Skills Python, R, Tableau, SPSS, SAS, PowerBi, Excel, SQL, SQLite, MySQL, Hadoop, Microsoft Office (Access, Visio, Dynamics, C#), Agile & Scrum, Kanban, Jira, Lean Manufacturing & Six Sigma Certifications IASSC Certified Lean Six Sigma Yellow Belt

Contact this candidate