Volkan Şendemir

I am a fresh graduate of Koç University with a solid education in Business Administration and Economics.
I hold tracks on Finance, Accounting, Financial Institutions and Macroeconomic Policy.
My programming knowledge covers Visual Basic for Applications and Python, mainly focusing on automation of MS Office applications and interaction with the web through RestAPI or Selenium.
I am a very advanced Excel user, covering a myriad of topics including Pivot Tables, Pivot Charts, Vlookups, Index-Match, and complex Array Formulas. I encourage you to check out my projects in Excel.
I enjoy data analytics and dabble in machine learning, but I am rather a beginner in this field.

Education

Koç University

Istanbul, Turkey

2016 – 2020

Business Administration and Economics

Double-Major, 3.78/4.00 GPA
Vienna University of Technology

Vienna, Austria

2014 – 2016

Mechanical Engineering

Not completed
Koç Private High School

Istanbul, Turkey

2009 – 2014

High School Diploma

Including one year of preparatory English school

Work Experience

Koç University

Istanbul, Turkey

May 2018 – Feb 2020

Part-Time Work-Study Employee, Data Analyst (20h/week)
- Involved mostly in the automation of internal reports, mainly using Excel Visual Basic (VBA Macro)
- Collected, manipulated, and reported data, including major data extraction from the web
- Occasionally worked with other internal departments on automation, optimization, other data projects
Heidrick & Struggles

Istanbul, Turkey

May 2017 – Sep 2017

Full-time Summer Intern (40h/week)
- Worked on search projects, mapping and identifying the talent pool of executives from various sectors
- Assisted on preparing business development files and gathering company information
- Worked directly with the Partner, assisting him on executive assessments
- Attended assessment interviews of high-level executives, writing reports to be presented directly to the Chief Executive Officer of a leading telecommunications company and his related high-level staff

Additional

Computer
- Mainly focused on Visual Basic for Applications (VBA), interaction between MS Excel, Word, PowerPoint and Outlook as well as Selenium for browser automation and XHR for data extraction
- Advanced user of MS Office Programs
- Advanced formulas and charts, PivotTables and PivotCharts, and Array Formulas in MS Excel
- Experience in Python: mainly pandas, sk-learn, and requests, as well as some APIs
- Various projects in Java including web scraping and data manipulation/reporting
- Limited SQL, Access and RDBMS knowledge
- Some experience in Power BI and R
Tracks

Finance, Macroeconomic Policy and Financial Institutions
Other Specializations

Accounting, Auditing, Operations and Strategy
Languages (ILR Scale)
- English: Full professional proficiency
- German: Limited working proficiency
- Turkish: Native proficiency

Transcript

Finance and Accounting

Course Code	Course Name	Grade
ACCT201	Financial Accounting	A+
ACCT202	Management Accounting	B+
ACCT321	Financial Statement Analysis	A
ACCT403	Auditing	A-
MFIN202	Introduction to Financial Management	A
MFIN301	Corporate Finance	A
MFIN304	Investment Management	A-
MFIN351	Risk Management	A-
MFIN403	Financial Markets and Institutions	A-

Data Analytics and Computer

Course Code	Course Name	Grade
COMP130	Introduction to Programming	AU
COMP132	Advanced Programming	AU
COMP202	Data Structures and Algorithms	AU
COMP306	Database Management Systems	AU
MATH101	Finite Mathematics	A+
MATH102	Calculus	A
MATH201	Statistics	A-
MGIS301	Management Information Systems	A
MKTG301	Marketing Research	A-
QMBU301	Quantitative Methods in Business	A
QMBU310	Introduction to Management Science	A
QMBU450	Advanced Data Analytics in Python	A

Operations and Strategy

Course Code	Course Name	Grade
MGMT335	Strategy in a Global Environment	A+
OPSM302	Service Operations	A
OPSM410	Operations Strategy	AU

Business Administration

Course Code	Course Name	Grade
BLAW202	Business Law	C+
BUSA499	Business Administration Capstone	A
MKTG201	Marketing Management	B
MKTG302	Consumer Behavior	AU

Economics

Course Code	Course Name	Grade
ECIR313	Introduction to Global Political Economy	B
ECON100	Principles of Economics	A
ECON201	Intermediate Microeconomics	A-
ECON202	Macroeconomics	A-
ECON311	Introduction to Econometrics	A-
ECON321	International Trade	A-
ECON360	Money and Banking	B+
ECON481	Turkish Economy	C+
ECON499	Economics Capstone	A

Others

Course Code	Course Name	Grade
ACWR101	Basic Academic Writing	A
ACWR103	Academic Writing for Business	A
ASIU105	War in Literature	A
ETHR109	Environmental Ethics	A
HIST300	History of Modern Turkey	A
HUMS117	Rationality and Irrationality	B+
PSYC100	Psyhology	A
SCIE107	Energy and Environment	A+
SOSC105	Migration and Globalization	A
SOSC108	Social Origins of Wealth	AU
TURK100	Turkish Speech and Composition	A

Curriculum Vitae

Summary

Education

Koç University

Vienna University of Technology

Koç Private High School

Work Experience

Koç University

Heidrick & Struggles

Additional

Transcript