Yuanpeng (Cindy) Feng Email & Phone Number

Carrollton, Texas, United States

- Performed 6+ margin analysis and cost impact analysis projects by calculating and visualizing sales data in Power BI to maintain internal margin metrics with a stable increase of 12%- Assessed competitors' pricing data by analyzing target costing projects and formulating competitive pricing rules to preserve positive customer price perception- Presented product sales trend data and dynamic changes in customer segments in weekly meetings to negotiate pricing problems with internal departments and propose suggestions and alternatives

Plano, Texas, United States

- Analyzed credit reports of 200+ clients implementing data modeling application in Python to predict credit scores trend with an accuracy of 93% and decrease the risk of the credit transaction- Led a team of 4 to design an automated framework for data extraction, transformation, and reporting of assessment data of clients in backend using SQL Server Integration Service and Python- Collaborated with sales officers to translate business needs into analytical requirements on loan rate approval to increase the loan outstanding on mortgage portfolio by 10% - Led junior analysts of the team and trained the business processing strategies and analytical techniques- Generated financial ratios to analyze clients’ financial data and prepared personalized reports about the degree of risk in extending credit for lending processes- Evaluated 50+ clients’ credit information per month and determined the loan decisions in accordance with compliance standards, credit union policy, and risk tolerance in a fast-paced environment

Greater Chicago Area

- Increased 12% of artists’ website traffic by executing A/B testing across landing pages and ads- Developed an SEO-centered content strategy for the launch of websites to increase pageviews by 37% - Created and implemented engaging demographic-driven marketing campaigns to develop brand identity, website traffic, and online presence for 6 music festivals- Tracked marketing metrics such as bounce rate and conversion rate to monitor websites and analyze a large dataset at both aggregation and individual page level through Google Analytics

Greater Chicago Area

- Utilized social media metrics in Adobe Analytics to track the students’ engagement and draw insights about strengthening relationships with college students- Designed Entity Relationship Diagram, updated database structure, and coded SQL queries to create data pipeline of 1000+ students allowing for scalable storage and straightforward access for exploratory analysis- Conducted behavior analysis of 800+ students by producing interactive data visualization dashboards in Tableau to improve the student satisfaction for activity service by 23%- Applied VLOOKUP function and VBA filter in MS Excel to analyze 20+ activities performance and present ad-hoc analytical findings to the senior management team

Nanjing, Jiangsu, China & Chicago, United States

- Presented how Frank J. Zirbel makes etchings using PowerPoint to the curator in the museum- Clearly communicated with Mr. Zirbel about “Display Cases of Stories” exhibition theme - Collaborated with Mr. Zirbel to choose 60 etchings, design layout, create art works descriptions- Came up with exhibition summary and arranged to ship etchings to Nanjing, China

Greater Chicago Area

- Curated “Dance photography exhibition in Contemporary China” Exhibition within one year- Collaborate with 3 featured dance photographers to analyze work and coordinate logistics- Managed limited budget of $300 and planed out the timeline for the exhibition in advance- Listed 10 media groups in Google Excel and emailed them to expand the influence of exhibition- Created exhibition proposals, advertisements and labels to be applied to 20+ artwork - Interpreted the background stories of dance to 100+ attendees in one month exhibition

Master'S Degree, Business/Office Automation/Technology/Data Entry

Bachelor Of Arts - Ba, International Arts Management

Bachelor'S Degree, Culture Trade