MS. Information Technology student with Finance and IT background

Qianyue (Andy) Lin

646-***-**** **********@*******.*** 885 Sixth Avenue, #16E, New York, NY 10001 EDUCATION

Fordham University, Gabelli School of Business 08/2019-12/2020 MS In Information Technology, GPA 3.67/4.00 New York, NY

Relevant Coursework:

Database Management [SQL Server]

Data Mining for Business [SPSS Modeler]

Programming with Python

Big data Analytics [Hadoop]

Indiana University of Bloomington, Kelley School of Business 08/2015-05/2019 BS in Finance & Technology Management Bloomington, IN

IU Global Engagement Scholarship $11,000(10/100), 2015

Relevant Coursework:

Corporate Finance Technology & Business Analysis

Venture Capital & Enterprise Finance Accounting EXPERIENCE

Deloitte 06/2019-08/2019

Summer Consultant, Strategy & Operation Advisory Division Beijing, China

Built 52 financial models, including bond valuation, fund valuation and financial derivative valuation by Excel, and 8 financial models, including forward interest rate calculation and bonds valuation by using Python

Wrote over ten-thousand-words customer requirement of post-investment part and delivered how the system work in post-investment stage to software development department

Utilized Mocking Bot to draw 50+ pages user interfaces Zhongtai Securities 07/2017-08/2017

Summer Investment Analyst, Investment Banking Division Beijing, China

Conducted benchmarking analysis for proposed $150MM IPO of one of the largest jewelry company in China and updated the compares model

Responsible for building a preliminary DCF model for the restructuring of a telecommunicate company and updating reports utilizing SQL server relational databases

Performed due diligence of two Pre-IPO enterprises, including capital stabilization, profitability structure, etc. China Merchants Bank 06/2016-08/2016

Summer Intern, Credit Department Yantai, China

Leveraged bank internal system to extract 70+ customers’ financial information, including customers’ income level, immovable properties, credit records, and repayment history to analyze the credit risk

Visited three post-loan enterprises and conduct post-loan review, and independently complete the review report LEADERSHIP & EXTRACURRICULAR ACTIVITIES

3M Information Technology Case Competition 02/2019 Semi-Finalist Bloomington, IN

Discussed 3M value chain with 3M employees and identified its demand for the database management system

Used SQL with three team members and wrote 35 pages introduction reports, including design of the database, user interface, and user manual, resulted in development of a new database management system Ascend Leadership – Indiana University Bloomington Chapter 01/2017-08/2018 Lead Member, Information Technology Department Bloomington, IN

Presented IT related news during meetings to update board members about the latest technological trends and sharing Information Technology skills include Tableau and Photoshop to 40 club members SKILLS

Skills: Excel (Advanced), SQL (Advanced), Tableau (Advanced), Git (Intermediate), Python (Intermediate), HTML (Intermediate), SDLC (Intermediate), AWS (Intermediate), SPSS (Intermediate), C# (Basic)

Languages: English, Mandarin (Fluent)

Contact this candidate