Data Analyst Power Bi

YANZHI WANG

Houston, TX 713-***-**** *************@*****.*** LinkedIn

PROFESSIONAL_SUMMARY Data Analyst with over two years of experience in developing ETL workflows, automating data pipelines, and creating interactive BI dashboards using Alteryx, Power BI, SQL, and Python. Proficient in managing complex datasets and collaborating with cross-functional teams to optimize performance metrics. TECHNICAL_SKILLS Skills: Alteryx, Power BI, Oracle SQL, Python, Java WORK_EXPERIENCE Data Analyst (Remote Full-Time) Aug. 2023 – Present Abbott Diabetes Care Alameda, CA

● Designed and implemented ETL workflows using Alteryx to process medical device sales and complaint data

● Developed and maintained interactive Power BI dashboards to visualize KPIs, trends, and performance drivers, enabling data-driven decisions for leadership

EDUCATION The University of Texas at Arlington Dec. 2022

Master of Computer Science GPA – 3.64

Specialty Areas: Data Science and Software Engineering UNIVERSITY_PROJECT LeNet-5 CNN for Optical Character Recognition CNN Implementation in Python [Code] Sept. 2022 – Dec 2022

● Built a LeNet-5 CNN with Python, TensorFlow, and Keras for handwritten digit recognition on the MNIST dataset

● Preprocessed 28x28 images to 32x32, trained the model with the Adam optimizer, achieving ~99% accuracy, and visualized training progress with Matplotlib loss and accuracy curves

● Deployed the trained model for real-time OCR on the Chars74K dataset, extracting and recognizing digits and uppercase letters (0-9, A-Z) from images using OpenCV for contour-based character segmentation and preprocessing File Sharing System Socket Programming with JAVA [Code] Jan. 2022 – May 2022

● Developed a client-server file sync system using Java, allowing multiple clients to sync files with a central server

● Implemented a TCP connection for communication and designed a multi-threaded architecture Database Systems Oracle SQL [Code] Sept. 2021 – Dec. 2021

• Analyzed the IMDb database containing millions of rows of International Movies and TV episodes information

• Utilized Oracle SQL, applying JOINs, aggregate functions, and LIKE operators to extract actionable insights Exploring Data in Python PYTHON Programming Essentials [ Project] Sept. 2021 – Dec 2021

• Utilized pandas and BeautifulSoup to scrape, clean, split, and enrich stock dataframes with additional metrics

• Enabled user queries by ticker, storing results in a CSV file Spelling Checking System Socket Programming with PYTHON [Code] Jan. 2021 – May 2021

• Created a client-server spelling checking system using Python socket programming, with a GUI for clients to send text files for word modification

• Designed a UDP connection with a multi-threaded architecture, incorporating automatic file detection and handling for updates and deletions

Task Management Application Android Software Development [Code] [Video] Jan. 2021 – May 2021

• Built a task management app in Android Studio with intuitive UI for creating, delegating, and tracking group tasks

• Created a demo video showcasing the app’s features and functionality for seamless user experience Data Structure and Algorithm JAVA Programming Essentials Sept. 2020 – Dec. 2020

• A stable matching between an equal sized group of advisors and students [Code] [Algorithm Design]

• Use Prim’s Algorithm to find Minimum Spanning Tree [Code] [Algorithm Design]

• Use dynamic programming to find the path with the smallest travel time subject to limited amount of fuel. Use dynamic programming to determine the maximum attack damage [Code] COURSEWORK

Data Analysis & Modeling Techniques [Note] Distributed Systems [Note] Computer Networks [Note] Software Engineering: Analysis, Design, Testing [Note] Software Engineering: Management, Maintenance, QA [Note] Data Mining [Note] Database Systems [Note] Python Programming [Note]

Contact this candidate