About Me
I am a Data Analyst at McKinsey & Company, skilled in R, Snowflake SQL, and Tableau. I adeptly transform complex datasets into clear, digestible business insights. Over the past two years at McKinsey, I have been involved in projects analyzing business insights for GHD Analytics Services, Zoom, SharePoint, and other projects related to secure foundation domains. As a PhD candidate with a deep understanding of economic theory, I seamlessly integrate academic rigor with practical data analysis, driving impactful business solutions and operational efficiency in fast-paced environments. I am fluent in Chinese and English and am actively developing my Slovak language skills.
My PhD research primarily revolves around three key areas of study:
- Green finance
- Credit rating
- Financial market analysis: stock, bond pricing
The tech stack I am most familar with are:
- Data modeling using Snowflake SQL
- Data visualisation and reporting using Tableau
- Econometric analysis using R and Stata
- I am actively progressing myself with skills in Python
Working Experience
- Designed and implemented Tableau dashboards to provide interactive visualizations, showcasing product and service performance metrics across the organization.
- Employed a suite of advanced analytics tools and empirical methodologies for comprehensive data analysis, utilizing R, Python, and Snowflake SQL to derive actionable insights.
- Offered analytic support to the product and service teams by translating large amounts of data into business insights, enhancing their data access and insight generation capabilities, thus facilitating informed decision-making processes.
- Spearheaded the development of predictive analytics models to forecast trends and performance, enabling proactive decision-making and strategic planning across various departments.
- Overseeing the design and devilry of seminar teaching materials.
- Delivering weekly seminars.
- Setting and grading student assignments.
- Ensuring the maintenance of learning materials (Textbook, seminar slides, and suggested solutions) on the online learning environment site.
Marcpoint Technology Ltd
Consumer Insight Analysts
January 2018 - June 2018
https://www.marcpoint.com/
- Data analysis using SQL, Excel and Python.
- Consumer-based market information research and data analysis.
- Customising solutions and supersessions for market promotions to enhance clients strategic marketing development and market competitiveness in Chinese Market.
- Fundamental market research about the Chinese renewable energy market.
- Customer relation management via phone calls and E-mails.
- Estimating the industrial growth of Chinese offshore wind power based on given private databases.
- Data analysis and result reporting on regular base.
- IBM Note and Microsoft Access Data Entry.
Education history
- Institute of Economic Studies, Faculty of Social Sciences, Charles University, Prague, Czech Republic.
- September 2018 - Present: PhD Candidate in Economics
- University of East Anglia, Norwich, UK.
- September 2013 - July 2016: BSc. Business Finance and Economcis
- September 2016 - September 2017: MSc. Economics
Working papers
Research work published at working paper:
- Janda K., Zhang B. (2019): “Renewable Energy Financial Modelling: A China Case Study”, IES Working Papers 7/2019. IES FSV. Charles University.
- Janda K., Zhang B. (2020). “The impact of renewable energy and technology innovation on Chinese carbon dioxide emissions”. FFA Working Paper 3/2020, FFA, University of Economics, Prague. • Janda K, Kortusova A, Zhang B (2022): “Green Bond Premiums in the Chinese Secondary Market”, IES Working Papers 20/2022. IES FSV. Charles University.
- Janda, K., Kortusova, A., and Zhang, B. (2022). “Estimation of green bond premiums in the Chinese secondary market”, CAMA Working Papers 2022-38, Centre for Applied Macroeconomic Analysis, Crawford School of Public Policy, The Australian National University.
- Janda, K., Kristoufek, L. and Zhang, B. (2022). “Return and volatility spillovers between Chinese and U.S. Clean Energy Related Stocks: Evidence from VAR-MGARCH estimations”, FFA Working Papers, 4, 2022.001.
- Janda, K., Kristoufek, L. and Zhang, B. (2022).”Return and volatility spillovers between Chinese and US clean energy related stocks,” CAMA Working Papers 2022-17, Centre for Applied Macroeconomic Analysis, Crawford School of Public Policy, The Australian National University.
Publications
Publications with impact factors:
- Janda, K., Kocenda, E, Kortusova, A and Zhang, B (2022). Estimation of Green Bond Premiums in the Chinese Secondary Market. Politická Ekonomie, 2022, 70 (6). Paper link, Replication code and data.
- Janda, K., Kristoufek, L. and Zhang, B., (2022). Return and volatility spillovers between Chinese and US clean energy related stocks. Energy Economics, p.105911. Paper link, Replication code and data.