Limei H.

About Limei H.

Data analyst with a passion for condensing large data into a simple to understand story. Adept at working independently and collaborating with teams across multiple functions to break down concepts in layman terms to diverse audiences. Bring experience obtained through a cross-functional organization to streamline data analysis, reporting and auditing. Committed to continuous learning. Prepared to excel in solving complex problems. Fluent in English and Chinese.

Experience

1. Business Analytics Consultant Sr AVP at Pnc

   PNC

   Jan 2023 — Present · US

   Tableau Implementation of Excel Reports that exist in Third Part Verint’s Branch Hour Market Intelligence Excel Workbook. It includes two tasks data generation using VBA and dashboards developments using Tableau. Building Tableau dashboards for different Line of Businesses, and as Tableau site Admin manage extract refresh and user access.Using SQL pull data from Hadoop to perform ad hoc data analysis and build data extract for Tableau dashboards.Using Excel Macro/VBA automating calculations, automating report generation process for Enterprise Risk Management team PGA project and AML KRM regulatory reporting project.Using PySpark and Python validating Pipeline code.

Education

• Case Western Reserve University

  Certificate, Data Analytics Bootcamp

  2019 — 2020

• Cleveland State University

  Master degree in Computer Engineering

  2015 — 2015

• Cleveland State University, Cleveland, OH

  Ph.D course credits in Computer Engineering

  2009 — 2013

Skills

• Teaching
• Student Services
• Data Analysis
• Microsoft Excel
• Access
• Programming
• Databases
• Java
• Sql
• C
• Vba
• Higher Education
• Microsoft Office
• Visual Studio
• C# 4.0
• Academia
• C#
• C