Katarina Ronbeck

WORK HISTORY

EDUCATION

ABOUT KATARINA RONBECK

As a financial analyst and business analyst, I aspire to develop my skillset and mindset to help drive the future of energy production. I am passionate about energy efficiency and accessibility for everyone. My previous work as a transport advisor for an environmental organization increased my skills in identifying problems, analyzing, and utilizing data, and connecting red lines in a broader sense. My experience as a professional athlete taught me to never give up on a task before the problem is solved. I believe these experiences will be useful when embarking on one of the greatest challenges we face today: Transitioning to large-scale production and energy accessibility.Some of my core competencies are: • Financial Planning and Analysis (FP & A), Financial Modelling, Statistics. • Python, R programming, SQL, Power Query (M), DAX, Azure and AWS, Advanced Microsoft Excel. • Corporate Finance, Valuation, Investment Analysis, Portfolio Management. • Data Management, Data Cleaning, ETL Process Optimization, ERD Development.I`m known as highly organized, productive, and efficient. When working with data, I tend to see the broader picture and always use data as a tool to tell a story. People would describe me as hardworking, detail-oriented, energetic, and passionate. Once I start a project, I make it my mission to improve every aspect of the project.Businesses and institutions need people who connect the dots.Microsoft Office: Word | Excel | Power Point | Pivot Table | XLOOKUP and VLOOKUP | If statements | Macros | Data analysis | Data validation | Goal seek | Solver | Advanced filtering | Conditional formatting | Index and Match | Data modeling | Power Bi | PowerPoint | PPT | Pivot Tables | Mashup | M | DAX Data Management: Normalization I Optimization I Cloud Databases I MySQL I SQL Server I Oracle I Agile I Presentation I Statistical Analysis | Data warehousing | ETL | Bi | Big Data | AWS | Azure | Google Cloud SQL | Snowflake | Data Governance | Data modeling | RDBMS | R Python: Numpy | Pandas | Matplotlib | seaborn | Data analysis | Data visualization | Data science | Colab | NLP | sklearn Financial Analysis: Options and Derivatives Analysis | Risk Management | Market Research | Financial reporting | Derivatives | Economic Analysis | Capital Markets | Contract Negotiation | Futures and Forward Analysis | Budgeting | Forecasting | Financial Modeling | Variance Analysis | Strategic Planning | Revenue Optimization | Cost Analysis | Scenario Analysis | Financial Reporting | Tableau | Tableau Public