Tianpei X.

Business Analyst @AmTrust Financial Services, Inc.

Jersey City, NJ, US

Enabled effective decision making by retrieving and aggregating data from Access database and compiling it into a digestible and actionable format.• Utilized Excel pivot tables and charts to analyze complex business problems such as client payment trends, provided insights into data-driven strategies.• Updated and maintained monthly and quarterly consolidation reports and benchmarking against financial results of key competitors.• Enhanced decision making and risk selection through the development of automated management information and data analysis by means of data mapping and integration.• Created SQL scripts to load the clean data which generated from Business Objects into Access database.• Delivered automated reports and ad-hoc analysis for MI pack using Excel VBA, analyzed rows of historical bound policy data to offer business insights.• Imported and cleaned raw datasets, evaluated data quality and integrity, fixed data issues, created analytical datasets using SQL to maintain and enhance ANV’s pricing engines.• Facilitated stakeholders from underwriting, claims, and operations team of global offices to gather, analyze, document, and communicate the current business challenges to ensure the alignment with business methodologies.• Troubleshooted and resolved data quality issues through data validation and error handling processes, reducing data discrepancies by 15%.• Conducted exploratory data analysis with data visualization tools, developed interactive dashboard to monitor business indicators such as GWPs, YTD bound policies etc, enabled stakeholders to get visual information from complex and unstructured raw data.• Served as a liaison between Europe and US teams, leveraging bilingual (Chinese) proficiency. Collaborated with cross-functional teams for effective data management, leveraging analytical skills to drive work efficiency.