Kelin Pan

+1-217-****-*** ad4m5i@r.postjobfree.com

EDUCATION

Columbia University New York City, NY

Master’s degree in Applied Analytic Sep 20232 – Current University of Illinois at Urbana-Champaign Champaign, IL Bachelor’s Degree in Accounting, minor in Computer Science Sep 2019 – May 2023 PROFESSIONAL EXPERIENCE

Anxin Securities Hefei, China

Investment Banking Intern Jul 2022 - Aug 2022

• Developed driver-based financial projections to valuate inorganic growth opportunities and assess the feasibility of M&A acquisitions, divestitures, joint ventures and restructures in the automobile industry

• Analyzed historical financial data and performed ratio analysis to come up with fair assumptions for cash flow projection, ROI and NPV. Refined financial models by identifying cross-sell and synergy opportunities

• Partnered with cross-functional teams to conduct tax/finance/real estate/IT/Privacy due diligence. Flagged key risks areas, identified mitigation strategies and summarized findings

• Prepared M&A Project presentations and Email communications to present acquisition strategic rational, transaction terms, due diligence findings, financial valuation and integration approach to clients

• Developed post-acquisition integration budget for 10+ target companies as input for the financial valuation. Optimized the budget planning model by streamlining the process and budget allocation based on past learnings

• Managed the engagement team budget, including labour hours, meal & travel expense. Prepared detailed template to track engagement spend by category and report on a monthly basis to team leader about under/over spend areas Atomic Venture Shanghai, China

Investment Assistant VC/PE May 2021 – Aug 2021

• Produced industry landscape analysis on new energy to gauge the investment backdrop in Electric Vehicle VC/PE

• Performed SWOT analysis of business proposals to determine viability for growth capital or acquisition financings. Identified risk factors of investment diversifications and then proposed key methos to avoid business failures

• Conducted several company site visits to gain deeper understanding over their business. Communicated with management on valuation expectations, exit strategies to make informed financing decisions

• Compared various investment alternatives using financial and operational KPIs related to the investment strategy of Atomic Venture. Generated KPI performance reports to identify the most viable investment alternative

• Documented and streamlined policies, procedures, and best practices for the VC/PE investment department Super Job Dream Technology Beijing, China

Market Intern Marketing Department Sep 2020 – Nov 2020

• Identified means of various KOLs to gain client exposure and conveyed brand messaging (achieved 1mm revenue)

• Helped devised a marketing tool to help reverse the public impression of a resume parsing tools

• Performed cost/benefit analysis to evaluate the potential financial benefits of a job hunting application marketing campaign. Developed campaign costs budget and calculated expected contract value generation ACADEMIC EXPERIENCE

Data Analysis – Develop Effective Marketing Strategy Sep 2021 – Dec 2021

• Converted data into actionable insights by developing clientele reports to accurately target potential clients. Built regression models such as the classification tree and random forest classifier to determine client categories

• Fit linear regression model and random forest regressor to helped to predict future revenue of each catalog sale. Tested each model to reduce error and increase accuracy of calculated expected annual revenue gained Cargo and Denim Ltd (bookkeeping for small business) Jan 2020 – Apr 2020

• Converted the store’s manual system of bookkeeping to an online system using Quickbook

• Implemented accrual-based accounting for the company’s P&L. Set up various accrued expense and receivable accounts. Monitored outstanding provisions to prevent overstatement and ensured compliance with GAAP

• Recorded transactions and year-end adjusting journal entries (transaction, accrual, amortization and reclassification), ensuring compliance with regulatory and organizational standards

• Reconciled various general ledger accounts. Used control procedures, including quality checks to efficiently identify discrepancies for investigation. Conducted account deep-dive analysis to investigate abnormal misalignments SKILLS

Computer Skills: Excel, PowerPoint, Word, Tableau. Proficient in Python, C++, Java, SQL, R

Contact this candidate