Post Job Free

Resume

Sign in

Fixed Asset Intern

Location:
Philadelphia, PA
Posted:
May 31, 2021

Contact this candidate

Resume:

Kyllian Vong

*** ******* ******, ************ **, 19147 321-***-**** admuk7@r.postjobfree.com linkedin.com/in/kyllianvong EDUCATION

American University, Kogod School of Business May 2021 Washington, DC Bachelor of Science in Business Administration in Finance GPA: 3.62 Relevant Coursework: Economics, Individual Income Taxes, Intermediate Financial Reporting, Intermediate Corporate Finance, Financial Modeling, Strategic Management, Statistics, Student Managed Investment Fund Honors & Awards: Dean’s List, Deloitte Consulting Technology Case Competition (1st Place) PROFESSIONAL EXPERIENCE

Tesla Fremont, CA

Fixed Asset Intern, Finance Operations May 2021 – Present Maintain completeness and accuracy of Tesla’s $12.7B fixed assets sub-ledger through month-end closing activities such as recording newly acquired fixed assets, account reconciliations, and depreciation, impairment, and disposal adjustments Oversee the asset tag issuance process by coordinating the delivery of 5000+ tags with 37 business units at 142 Tesla service centers to enable asset geolocation capabilities for Tesla’s annual asset confirmation process per GAAP guidelines Evaluate 200+ monthly asset creation requests from business units based on internal fixed asset capitalization guidelines Goldman Sachs New York, NY

Summer Analyst, Comprehensive Capital Analysis and Review (CCAR) Jul 2020 – Aug 2020 Consulted senior management on how to improve the existing state of visualizing/manipulating CCAR scenario outputs that project nine quarters of performance under stress test conditions used to finalize the firm’s annual Capital Plan Designed five Tableau dashboards that assist the CCAR team and 330+ stakeholders by dynamically manipulating macroeconomic variables, enabling upper-level management to visualize bespoke projections, saving 100+ hours annually Developed an Excel reconciliation of the Tableau dashboard results in order to verify the figures output by coded calculated fields to ensure proper due diligence means were taken before being published for the entire firm to utilize PricewaterhouseCoopers (PwC) McLean, VA

Core Assurance Intern, Banking and Capital Markets Jan 2020 – Mar 2020 Performed compliance testing, tests of controls (targeted testing, non-statistical testing, accept-reject testing), and substantive analytics to gain comfort over significant risk areas and client systems within the audit execution phase Developed Alteryx workflows to automate audit procedures, allowing for data wrangling of big data received by the client, reducing lead time by 3+ days on 5 projects, allowing for focus on higher-level audit areas U.S. Securities and Exchange Commission Washington, DC Financial Data Analyst, Division of Economic and Risk Analysis Aug 2019 – Dec 2019 Collaborated with the Office of Financial Intermediaries to update the economic baseline of new market participants dealing with credit default swaps, classifying them by fund type to comply with Title VII of the Dodd-Frank Act Analyzed YOY registration (485BPOS) statements of Fortune 1000 investment management companies in XBRL to investigate changes in risk factors, management fees/expenses, and fund types to be in accordance with SEC rulings Chubb Philadelphia, PA

Financial Reporting Analyst, Statutory Reporting Apr 2019 – Aug 2019 Reported daily and quarterly P&L changes of up to $50MM+ in Chubb's subsidiary P&C (Property & Casualty) division companies to executives to keep them updated on operations and underwriting activity for North America Reconciled Chubb and ACE Limited's consolidated Schedule P to determine when insurance premiums were earned or losses were incurred while removing double entries that may have occurred in the midst of the acquisition period Lexerd Capital Management Philadelphia, PA

Private Equity Intern, Real Estate Coverage Mar 2019 – Jul 2019 Prepared pitch decks for partners who presented our firm's empirical track record and future investment plans to Limited Partners in order to secure callable capital for 10 year, high-yield funds valued between $100MM-$300MM Assisted partners with the development of financial models that generated initial operational forecasts about potential deals and acquisitions, targeting deals that can turn over a 40%+ return by the end of a 10-year funding period SKILLS & INTERESTS

Foreign Languages: Japanese (Native), Mandarin Chinese (Conversational), Korean (Beginner) Skills: Alteryx (Intermediate), Bloomberg, LaTeX, Python, Tableau (Intermediate), Thomson Reuters Eikon Certifications & Training: Bloomberg Market Concepts, Excel 2016 Certification, IBM Data Science Python Certification, PwC Digital Acumen, Wharton School Business and Financial Modeling Certification Interests: Chess, Digital Upskilling, Tennis, Competitive Tetris



Contact this candidate