Jingyi Liu
Jersey City,NJ
Summary
Dynamic Senior Business Analyst with extensive experience at JPMorgan Chase, driving successful AWS datalake migrations and automating reporting processes. Proven expertise in SQL and project management, enhancing data integration efficiency. Adept at leading cross-functional teams and delivering impactful solutions, consistently achieving significant operational improvements.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Senior Business Analyst
JPMorgan Chase
Jersey City, NJ
06.2022 - Current
- Led the AWS datalake migration project: Publishing on-prem data to the AWS datalake via S3. Designed migration solutions of both manual upload and automated pushing every one hour for more than 20 in-house support tables based on different use cases. Hosted meetings with software engineer team for design explanation and led end-to-end UAT process after built-completed.
- Led and delivered data integration projects. Over 3 years of experience in managing data integration projects, focusing on risk and reporting. Successfully automated reporting processes, significantly reducing manual processing time. Utilized both API-based and SQL-based connections for data sourcing and integration.
- Led the production issue investigation project after project going alive. Worked with production team and business user’s team to provide necessary production support on ad-hoc basis. Data analytics performed in SQL warehouse for ETL model testing and production issue investigation.
Reinsurance Data Analyst
Munich Re America
Princeton, NJ
03.2020 - 06.2022
- Led data consumption automation projects for controller’s office and reported to higher management level on a monthly basis for project updates. 95% insurance data process efficiency increased.
- Analyzed reinsurance contracts, extracted accounting ratios and requested regular settlements from the clients.
- Conducted analysis for the corporate reinsurance data storage system (SAP) and provided tests for in-house automation application functionality.
- Designed solutions to check data accuracy and applied multiple ways to solve data discrepancy issues for quarterly /monthly end financial data reconciliation.
Education
Master of Science - Business Analytics
University of Pittsburgh
Pittsburgh, PA12-2019
Bachelor of Arts - Accounting
Chongqing University
Chongqing06-2017
Some College (No Degree) - Economy
University of California, Los Angeles
Los Angeles, CA08-2016
Skills
- Project Management
- Data Science & Analytics
- Programming - Proficient in Python, R, and Java
- Data Integration & Management
Languages
English
Full Professional
Chinese (Mandarin)
Native/ Bilingual
Certification
- Google Project Management Certificate
- Databricks Applied Data Science for Data Analysts, Apache Spark SQL for Data Analysts
Timeline
Senior Business Analyst
JPMorgan Chase
06.2022 - Current
Reinsurance Data Analyst
Munich Re America
03.2020 - 06.2022
Master of Science - Business Analytics
University of Pittsburgh
Bachelor of Arts - Accounting
Chongqing University
Some College (No Degree) - Economy
University of California, Los Angeles
Similar Profiles
PASTELL JENKINSPASTELL JENKINS
Vice President of Operations at JPMorgan Chase, JPMorgan Chase & CoVice President of Operations at JPMorgan Chase, JPMorgan Chase & Co
Supraj CBSupraj CB
Analyst at JPMorgan Chase, JPMorgan Chase & CoAnalyst at JPMorgan Chase, JPMorgan Chase & Co
Noemie VillanuevaNoemie Villanueva
Retail Banking Associate at JPMorgan Chase, JPMorgan Chase & CoRetail Banking Associate at JPMorgan Chase, JPMorgan Chase & Co
Kimberly De La RosaKimberly De La Rosa
Waitress at JPMorgan Chase, JPMorgan Chase & CoWaitress at JPMorgan Chase, JPMorgan Chase & Co
Rena SinghRena Singh
Assistant Coach at University Academy Charter High SchoolAssistant Coach at University Academy Charter High School