Danni L. Email & Phone Number

Park Ridge, Il, Us

Greater Chicago Area

Riverwoods, Il

Northbrook, Illinois

Northbrook, Illinois

Greater Chicago Area

Work in Enterprise data analytics team• Created sales and SKU productivity budget for 13 distribution centers and 86 categories by analyzing historical trends and communicating with sales team. Created scenario analysis on budgets• Built interactive and dynamic PowerBI dashboard with drill-down and filters, to analyze and present key drivers of variance. Greatly improved the monthly category review process for the category management team • Generated monthly scorecard for more than 5,000 vendors and brands to monitor vendor participation and performance. Pulled large datasets from Cognos and cleaned data using Python. Automated the scorecard creating processes using VBA, saved 3 days of work per month. Improved accuracy for predicting vendor risks by adding key factors such as potentials and penetration • Partnered with Supply Chain, Finance and Vendor Management team to create monthly KPI reports, and summarized highlights to Vice President of the department• Designed a Vendor Risk Prediction Engine using Pandas, Numpy and Scikit-Learn packages in Python. Analyzed vendor sales and payback patterns using logistic regression and supervised machine learning to predict the probability of default of a vendor. • Worked with accounting team and outside auditors to perform monthly vendor hold and short on deal audits

Beijing City, China

• Identified and qualified new investment opportunities based on industry research (i.e. Consumer Goods, Fintech), competitor analysis via secondary research and/or contacting industry expert • Assisted business due diligence on technologies and user data of target companies. Closed a $2 million asset purchase deal by building financial model based on amount of daily active users and comparables of target company• Closed a $8 million bridge loan deal with an online wholesale company. Interviewed 10 district managers and 13 customers, built revenue, expenses, cash flow and working capital projections to predict the break-even point• Prepared financial valuation reports, presentation materials and presented investment suggestions to directors• Conducted add-on research on portfolio companies. Advised portfolio companies on financial planning, budget execution, corporate strategies and capital structure

Beijing City, China

• Assisted with Private Equity fund trade settlement. Collected and classified public data and transaction data from database. Imported the data into HS valuation software and calculated the daily Net Value Per Share of 76 funds• Reconciled daily settlement and Net Value Per Share of funds between the outsourcing valuation system and custody valuation system. Published net value per share of each fund on company website• Generated valuation reports, Balance Sheets, Fee Charge Reports and Warning Letter to fund managers • Communicated with settlement bank, fund managers and investors about contract, Net Value Per Share volatility

Beijing City, China

• Collected monthly sales data of branches in north quarter and macroeconomic information, such as monthly import and export data, CPI, the Inflation Index and changes of economic policies to rationalize sales fluctuation• Created an analysis report of monthly sales as reference for senior executives• Organized 3-day departmental annual meeting for 73 staff

Master'S Degree, Financial Mathematics, 3.86(4.0)

• Specializing in corporate finance track.

Bachelor Of Economics, Finance, General, Gpa 3.60

Activities and Societies: • Student Union of School of International Trade and Economy.• 3rd Grade UIBE Comprehensive Scholarship • 2nd.