Yiyin Li
Senior Business Analyst @GridX, Inc.
Signup · Get unlimited contacts
WORK HISTORY
Senior Business Analyst @GridX, Inc.
Managing data system upgrade project transferring billions of utility customer data from CSS to SAP; building the requirements and leading the technical team to control the data changes in data loading/conversion stage to avoid more complicated model changes improving the efficiency; applying SQL and QuickSight to analyze and to visualize the calibration results, predicting the records’ mismatch rate • Implementing end-to-end process to generate and to deliver Budget Assistant/Rate Analyzer/Unbilled Revenue Reports; building complex SQL and R to analyze and to automatically examine reports for over 5 million customers with over 1 billion payments; presenting findings in PowerPoint and Excel • Building the internal data loading requirement, and coordinating with the technical team to load billions of incoming data (customer, attribute, billing, usage, etc.) into the S3 cache, Athena, and SQL database; selecting variables and validating data quality to ensure the incoming data is meaningful and analyzable • Providing customer service to extract the required information from the internal system (database, model, outputs, etc.) and client’s UI; providing troubleshooting service to investigate
EDUCATION
University of Cincinnati Carl H. Lindner College of Business
Master's degree, Business Analytics
University of Cincinnati Carl H. Lindner College of Business
Bachelor's degree, Finance / Minor in Business Analytics
ABOUT YIYIN LI
I graduated from the University of Cincinnati and have four year business analytics…
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.